CoronavirusHospitalCapacity_states

Table actions

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

7 rows where PatientsPerBed_60plus = "1.4"

✎ 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
17 17 0400000US51 Virginia 18,065 6,503 8,413,774 622,619 85,921 37,980 6.9 19.1 1,739,052 20.70% 128,690 17,759 7,850 1.4 3.9
20 20 0400000US32 Nevada 6,493 2,337 2,922,849 216,291 29,848 13,194 6.6 18.4 612,136 20.90% 45,298 6,251 2,763 1.4 3.9
21 21 0400000US25 Massachusetts 15,649 5,634 6,830,193 505,434 69,750 30,831 6.4 17.9 1,511,891 22.10% 111,880 15,439 6,825 1.4 4
22 22 0400000US34 New Jersey 20,901 7,524 8,881,845 657,257 90,701 40,093 6.3 17.4 1,928,202 21.70% 142,687 19,691 8,704 1.4 3.8
25 25 0400000US45 South Carolina 12,120 4,363 4,955,925 366,738 50,610 22,371 6 16.7 1,150,118 23.20% 85,109 11,745 5,192 1.4 3.9
27 27 0400000US26 Michigan 24,949 8,982 9,957,488 736,854 101,686 44,948 5.9 16.3 2,288,719 23.00% 169,365 23,372 10,331 1.4 3.8
31 31 0400000US12 Florida 54,744 19,708 20,598,139 1,524,262 210,348 92,980 5.5 15.4 5,378,753 26.10% 398,028 54,928 24,280 1.4 4

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