CoronavirusHospitalCapacity_states

Table actions

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

2 rows where PatientsPerAvailableBed_60plus = "3.3"

✎ 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
5 5 0400000US49 Utah 5,767 2,076 3,045,350 225,356 31,099 13,747 7.8 21.6 459,907 15.10% 34,033 4,697 2,076 1.2 3.3
34 34 0400000US39 Ohio 33,157 11,937 11,641,879 861,499 118,887 52,551 5.2 14.4 2,658,702 22.80% 196,744 27,151 12,001 1.2 3.3

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