CoronavirusHospitalCapacity_states
Data source: Big Local News · About: big-local-datasette
5 rows where PatientsPerBed_60plus = "1.6" sorted by Population_allages
This data as json, copyable, CSV (advanced)
Suggested facets: PatientsPerAvailableBed_60plus
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | 0400000US44 | Rhode Island | 2,187 | 787 | 1,056,611 | 78,189 | 10,790 | 4,770 | 7.1 | 19.8 | 243,523 | 23.00% | 18,021 | 2,487 | 1,099 | 1.6 | 4.6 |
29 | 29 | 0400000US23 | Maine | 3,400 | 1,224 | 1,332,813 | 98,628 | 13,611 | 6,016 | 5.8 | 16 | 360,329 | 27.00% | 26,664 | 3,680 | 1,627 | 1.6 | 4.3 |
15 | 15 | 0400000US55 | Wisconsin | 12,103 | 4,357 | 5,778,394 | 427,601 | 59,009 | 26,084 | 7 | 19.5 | 1,304,186 | 22.60% | 96,510 | 13,318 | 5,887 | 1.6 | 4.4 |
7 | 7 | 0400000US24 | Maryland | 11,577 | 4,168 | 6,003,435 | 444,254 | 61,307 | 27,100 | 7.6 | 21.2 | 1,246,886 | 20.80% | 92,270 | 12,733 | 5,628 | 1.6 | 4.4 |
18 | 18 | 0400000US10 | Delaware | 2,101 | 756 | 949,495 | 70,263 | 9,696 | 4,286 | 6.7 | 18.5 | 228,755 | 24.10% | 16,928 | 2,336 | 1,033 | 1.6 | 4.5 |
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 );