CoronavirusHospitalCapacity_states
Data source: Big Local News · About: big-local-datasette
3 rows where PatientsPerAvailableBed_60plus = "3.9"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17 | 17 | 0400000US51 | Virginia | 18,065 | 6,503 | 8,413,774 | 622,619 | 85,921 | 37,980 | 6.9 | 19.1 | 1,739,052 | 20.70% | 128,690 | 17,759 | 7,850 | 1.4 | 3.9 |
20 | 20 | 0400000US32 | Nevada | 6,493 | 2,337 | 2,922,849 | 216,291 | 29,848 | 13,194 | 6.6 | 18.4 | 612,136 | 20.90% | 45,298 | 6,251 | 2,763 | 1.4 | 3.9 |
25 | 25 | 0400000US45 | South Carolina | 12,120 | 4,363 | 4,955,925 | 366,738 | 50,610 | 22,371 | 6 | 16.7 | 1,150,118 | 23.20% | 85,109 | 11,745 | 5,192 | 1.4 | 3.9 |
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 );