CoronavirusHospitalCapacity_states
Data source: Big Local News · About: big-local-datasette
10 rows where PatientsPerBed_60plus = "1.1" sorted by State
This data as json, copyable, CSV (advanced)
Suggested facets: 60plus_PercentOfTotalPopulation, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );