CoronavirusHospitalCapacity_states

Table actions

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

3 rows where PatientsPerAvailableBed_60plus = "2.6"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: PatientsPerBed_60plus

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
42 42 0400000US22 Louisiana 15,272 5,498 4,663,616 345,108 47,625 21,052 4.5 12.5 964,214 20.70% 71,352 9,847 4,352 0.93 2.6
43 43 0400000US20 Kansas 9,659 3,477 2,908,776 215,249 29,704 13,130 4.4 12.3 615,164 21.10% 45,522 6,282 2,777 0.94 2.6
45 45 0400000US56 Wyoming 2,015 725 581,836 43,056 5,942 2,626 4.3 11.8 127,891 22.00% 9,464 1,306 577 0.93 2.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
);