CoronavirusHospitalCapacity_states

Table actions

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

2 rows where PatientsPerAvailableBed_60plus = "4.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
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
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

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