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

2 rows where PatientsPerAvailableBed_60plus = "4.6"

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
9 0400000US04 Arizona 13,846 4,985 6,946,685 514,055 70,940 31,357 7.4 20.5 1,567,148 22.60% 115,969 16,004 7,074 1.7 4.6
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

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