CoronavirusHospitalCapacity_states

Table actions

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

10 rows where PatientsPerBed_60plus = "1.1"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: 60plus_PercentOfTotalPopulation, PatientsPerAvailableBed_60plus

PatientsPerBed_60plus ✖

  • 1.1 · 10 ✖
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
19 19 0400000US02 Alaska 1,636 589 738,516 54,650 7,542 3,334 6.6 18.5 122,281 16.60% 9,049 1,249 552 1.1 3.1
23 23 0400000US48 Texas 65,671 23,642 27,885,195 2,063,504 284,764 125,874 6.3 17.4 4,783,562 17.20% 353,984 48,850 21,593 1.1 3
24 24 0400000US13 Georgia 25,114 9,041 10,297,484 762,014 105,158 46,483 6 16.8 1,930,893 18.80% 142,886 19,718 8,716 1.1 3.1
32 32 0400000US18 Indiana 18,156 6,536 6,637,426 491,170 67,781 29,961 5.4 15 1,407,682 21.20% 104,168 14,375 6,354 1.1 3.2
33 33 0400000US40 Oklahoma 11,144 4,012 3,918,137 289,942 40,012 17,686 5.2 14.4 820,105 20.90% 60,688 8,375 3,702 1.1 3
36 36 0400000US47 Tennessee 19,387 6,979 6,651,089 492,181 67,921 30,023 5.1 14 1,460,994 22.00% 108,114 14,920 6,595 1.1 3.1
37 37 0400000US19 Iowa 9,423 3,392 3,132,499 231,805 31,989 14,140 4.9 13.6 713,847 22.80% 52,825 7,290 3,222 1.1 3.1
38 38 0400000US29 Missouri 18,749 6,750 6,090,062 450,665 62,192 27,491 4.8 13.3 1,368,995 22.50% 101,306 13,980 6,180 1.1 3
39 39 0400000US01 Alabama 15,278 5,500 4,864,680 359,986 49,678 21,959 4.7 13 1,092,836 22.50% 80,870 11,160 4,933 1.1 2.9
44 44 0400000US30 Montana 3,542 1,275 1,041,732 77,088 10,638 4,702 4.3 12 260,242 25.00% 19,258 2,658 1,175 1.1 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
);