CoronavirusHospitalCapacity_states
Data source: Big Local News · About: big-local-datasette
4 rows where PatientsPerAvailableBed_60plus = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23 | 23 | 0400000US48 | Texas | 65,671 | 23,642 | 27,885,195 | 2,063,504 | 284,764 | 125,874 | 6.3 | 17.4 | 4,783,562 | 17.20% | 353,984 | 48,850 | 21,593 | 1.1 | 3 |
33 | 33 | 0400000US40 | Oklahoma | 11,144 | 4,012 | 3,918,137 | 289,942 | 40,012 | 17,686 | 5.2 | 14.4 | 820,105 | 20.90% | 60,688 | 8,375 | 3,702 | 1.1 | 3 |
38 | 38 | 0400000US29 | Missouri | 18,749 | 6,750 | 6,090,062 | 450,665 | 62,192 | 27,491 | 4.8 | 13.3 | 1,368,995 | 22.50% | 101,306 | 13,980 | 6,180 | 1.1 | 3 |
44 | 44 | 0400000US30 | Montana | 3,542 | 1,275 | 1,041,732 | 77,088 | 10,638 | 4,702 | 4.3 | 12 | 260,242 | 25.00% | 19,258 | 2,658 | 1,175 | 1.1 | 3 |
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 );