CoronavirusHospitalCapacity_states
Data source: Big Local News · About: big-local-datasette
3 rows where PatientsPerBed_60plus = "1.7" sorted by Infected_allages
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | 10 | 0400000US09 | Connecticut | 7,194 | 2,590 | 3,581,504 | 265,031 | 36,574 | 16,167 | 7.3 | 20.4 | 823,529 | 23.00% | 60,941 | 8,410 | 3,717 | 1.7 | 4.7 |
9 | 9 | 0400000US04 | Arizona | 13,846 | 4,985 | 6,946,685 | 514,055 | 70,940 | 31,357 | 7.4 | 20.5 | 1,567,148 | 22.60% | 115,969 | 16,004 | 7,074 | 1.7 | 4.6 |
13 | 13 | 0400000US33 | New Hampshire | 2,783 | 1,002 | 1,343,622 | 99,428 | 13,721 | 6,065 | 7.1 | 19.7 | 323,496 | 24.10% | 23,939 | 3,304 | 1,460 | 1.7 | 4.8 |
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 );