CoronavirusHospitalCapacity_states
Data source: Big Local News · About: big-local-datasette
6 rows where PatientsPerBed_60plus = "1.2"
This data as json, copyable, CSV (advanced)
Suggested facets: PatientsPerBed_allages, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | 5 | 0400000US49 | Utah | 5,767 | 2,076 | 3,045,350 | 225,356 | 31,099 | 13,747 | 7.8 | 21.6 | 459,907 | 15.10% | 34,033 | 4,697 | 2,076 | 1.2 | 3.3 |
26 | 26 | 0400000US17 | Illinois | 32,066 | 11,544 | 12,821,497 | 948,791 | 130,933 | 57,876 | 5.9 | 16.4 | 2,675,686 | 20.90% | 198,001 | 27,324 | 12,078 | 1.2 | 3.4 |
28 | 28 | 0400000US27 | Minnesota | 13,895 | 5,002 | 5,527,358 | 409,024 | 56,445 | 24,950 | 5.9 | 16.3 | 1,174,081 | 21.20% | 86,882 | 11,990 | 5,300 | 1.2 | 3.5 |
30 | 30 | 0400000US36 | New York | 51,927 | 18,694 | 19,618,453 | 1,451,766 | 200,344 | 88,558 | 5.6 | 15.5 | 4,281,416 | 21.80% | 316,825 | 43,722 | 19,326 | 1.2 | 3.4 |
34 | 34 | 0400000US39 | Ohio | 33,157 | 11,937 | 11,641,879 | 861,499 | 118,887 | 52,551 | 5.2 | 14.4 | 2,658,702 | 22.80% | 196,744 | 27,151 | 12,001 | 1.2 | 3.3 |
35 | 35 | 0400000US42 | Pennsylvania | 36,730 | 13,223 | 12,791,181 | 946,547 | 130,624 | 57,739 | 5.1 | 14.2 | 3,092,425 | 24.20% | 228,839 | 31,580 | 13,959 | 1.2 | 3.4 |
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 );