CoronavirusHospitalCapacity_states
Data source: Big Local News · About: big-local-datasette
2 rows where PatientsPerAvailableBed_60plus = "4.2"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | 4 | 0400000US06 | California | 72,511 | 26,104 | 39,148,760 | 2,897,008 | 399,787 | 176,718 | 8 | 22.1 | 7,507,934 | 19.20% | 555,587 | 76,671 | 33,891 | 1.5 | 4.2 |
16 | 16 | 0400000US37 | North Carolina | 21,549 | 7,758 | 10,155,624 | 751,516 | 103,709 | 45,842 | 6.9 | 19.3 | 2,189,433 | 21.60% | 162,018 | 22,358 | 9,883 | 1.5 | 4.2 |
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 );