CoronavirusHospitalCapacity_states

Table actions

Data source: Big Local News · About: big-local-datasette

3 rows where PatientsPerAvailableBed_60plus = "3.4"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
26 26 0400000US17 Illinois 32,066 11,544 12,821,497 948,791 130,933 57,876 5.9 16.4 2,675,686 20.90% 198,001 27,324 12,078 1.2 3.4
30 30 0400000US36 New York 51,927 18,694 19,618,453 1,451,766 200,344 88,558 5.6 15.5 4,281,416 21.80% 316,825 43,722 19,326 1.2 3.4
35 35 0400000US42 Pennsylvania 36,730 13,223 12,791,181 946,547 130,624 57,739 5.1 14.2 3,092,425 24.20% 228,839 31,580 13,959 1.2 3.4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);