CoronavirusHospitalCapacity_states
Data source: Big Local News · About: big-local-datasette
4 rows where PatientsPerBed_60plus = "1.8" sorted by PatientsPerAvailableBed_60plus
This data as json, copyable, CSV (advanced)
Suggested facets: PatientsPerAvailableBed_60plus
Link | rowid | GEO_ID | State | Total_Beds | Estimated_Available_Beds | Population_allages | Infected_allages | Severe_allages | Critical_allages | PatientsPerBed_allages | PatientsPerAvailableBed_allages | Population_60plus | 60plus_PercentOfTotalPopulation | Infected_60plus | Severe_60plus | Critical_60plus | PatientsPerBed_60plus | PatientsPerAvailableBed_60plus ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | 0400000US53 | Washington | 12,774 | 4,599 | 7,294,336 | 539,781 | 74,490 | 32,927 | 8.4 | 23.4 | 1,527,965 | 20.90% | 113,069 | 15,604 | 6,897 | 1.8 | 4.9 |
8 | 8 | 0400000US15 | Hawaii | 2,749 | 990 | 1,422,029 | 105,230 | 14,522 | 6,419 | 7.6 | 21.2 | 335,874 | 23.60% | 24,855 | 3,430 | 1,516 | 1.8 | 5 |
14 | 14 | 0400000US50 | Vermont | 1,305 | 470 | 624,977 | 46,248 | 6,382 | 2,821 | 7.1 | 19.6 | 160,758 | 25.70% | 11,896 | 1,642 | 726 | 1.8 | 5 |
3 | 3 | 0400000US35 | New Mexico | 3,811 | 1,372 | 2,092,434 | 154,840 | 21,368 | 9,445 | 8.1 | 22.5 | 474,147 | 22.70% | 35,087 | 4,842 | 2,140 | 1.8 | 5.1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [CoronavirusHospitalCapacity_states] ( [GEO_ID] TEXT, [State] TEXT, [Total_Beds] TEXT, [Estimated_Available_Beds] TEXT, [Population_allages] TEXT, [Infected_allages] TEXT, [Severe_allages] TEXT, [Critical_allages] TEXT, [PatientsPerBed_allages] TEXT, [PatientsPerAvailableBed_allages] TEXT, [Population_60plus] TEXT, [60plus_PercentOfTotalPopulation] TEXT, [Infected_60plus] TEXT, [Severe_60plus] TEXT, [Critical_60plus] TEXT, [PatientsPerBed_60plus] TEXT, [PatientsPerAvailableBed_60plus] TEXT );