CoronavirusHospitalCapacity_states

Table actions

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

5 rows where PatientsPerBed_60plus = "1.6"

✎ 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
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
12 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
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
18 18 0400000US10 Delaware 2,101 756 949,495 70,263 9,696 4,286 6.7 18.5 228,755 24.10% 16,928 2,336 1,033 1.6 4.5
29 29 0400000US23 Maine 3,400 1,224 1,332,813 98,628 13,611 6,016 5.8 16 360,329 27.00% 26,664 3,680 1,627 1.6 4.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
);