COVID_AHA_Hospital_beds

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

Custom SQL query returning 6 rows (hide)

Query parameters

rowidGEO_IDStateTotal_BedsEstimated_Available_BedsPopulation_allagesInfected_allagesSevere_allagesCritical_allagesPatientsPerBed_allagesPatientsPerAvailableBed_allagesPopulation_60plus60plus_PercentOfTotalPopulationInfected_60plusSevere_60plusCritical_60plusPatientsPerBed_60plusPatientsPerAvailableBed_60plus
26 0400000US17 Illinois 32,066 11,544 12,821,497 948,791 130,933 57,876 5.9 16.4 2,675,686 20.90% 198,001 27,324 12,078 1.2 3.4
34 0400000US39 Ohio 33,157 11,937 11,641,879 861,499 118,887 52,551 5.2 14.4 2,658,702 22.80% 196,744 27,151 12,001 1.2 3.3
35 0400000US42 Pennsylvania 36,730 13,223 12,791,181 946,547 130,624 57,739 5.1 14.2 3,092,425 24.20% 228,839 31,580 13,959 1.2 3.4
30 0400000US36 New York 51,927 18,694 19,618,453 1,451,766 200,344 88,558 5.6 15.5 4,281,416 21.80% 316,825 43,722 19,326 1.2 3.4
5 0400000US49 Utah 5,767 2,076 3,045,350 225,356 31,099 13,747 7.8 21.6 459,907 15.10% 34,033 4,697 2,076 1.2 3.3
28 0400000US27 Minnesota 13,895 5,002 5,527,358 409,024 56,445 24,950 5.9 16.3 1,174,081 21.20% 86,882 11,990 5,300 1.2 3.5