CoronavirusHospitalCapacity_states

Table actions

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

4 rows where PatientsPerBed_60plus = "1.5"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: PatientsPerAvailableBed_60plus

PatientsPerBed_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
4 4 0400000US06 California 72,511 26,104 39,148,760 2,897,008 399,787 176,718 8 22.1 7,507,934 19.20% 555,587 76,671 33,891 1.5 4.2
6 6 0400000US08 Colorado 10,574 3,807 5,531,141 409,304 56,484 24,968 7.7 21.4 1,071,803 19.40% 79,313 10,945 4,838 1.5 4.1
11 11 0400000US16 Idaho 3,396 1,223 1,687,809 124,898 17,236 7,619 7.3 20.3 355,290 21.10% 26,291 3,628 1,604 1.5 4.3
16 16 0400000US37 North Carolina 21,549 7,758 10,155,624 751,516 103,709 45,842 6.9 19.3 2,189,433 21.60% 162,018 22,358 9,883 1.5 4.2

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