CoronavirusHospitalCapacity_states
Data source: Big Local News · About: big-local-datasette
4 rows where PatientsPerAvailableBed_60plus = "3.1"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19 | 19 | 0400000US02 | Alaska | 1,636 | 589 | 738,516 | 54,650 | 7,542 | 3,334 | 6.6 | 18.5 | 122,281 | 16.60% | 9,049 | 1,249 | 552 | 1.1 | 3.1 |
24 | 24 | 0400000US13 | Georgia | 25,114 | 9,041 | 10,297,484 | 762,014 | 105,158 | 46,483 | 6 | 16.8 | 1,930,893 | 18.80% | 142,886 | 19,718 | 8,716 | 1.1 | 3.1 |
36 | 36 | 0400000US47 | Tennessee | 19,387 | 6,979 | 6,651,089 | 492,181 | 67,921 | 30,023 | 5.1 | 14 | 1,460,994 | 22.00% | 108,114 | 14,920 | 6,595 | 1.1 | 3.1 |
37 | 37 | 0400000US19 | Iowa | 9,423 | 3,392 | 3,132,499 | 231,805 | 31,989 | 14,140 | 4.9 | 13.6 | 713,847 | 22.80% | 52,825 | 7,290 | 3,222 | 1.1 | 3.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 );