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

1 row where PatientsPerAvailableBed_60plus = "2.1"

View and edit SQL

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
48 0400000US28 Mississippi 12,071 4,346 2,988,762 221,168 30,521 13,491 3.6 10.1 631,828 21.10% 46,755 6,452 2,852 0.77 2.1

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