This dataset can be accessed in the following ways
SQL Query copied to clipboardSELECT covid19_usa_health_care_provider_capacity.community_health_centers AS community_health_centers, covid19_usa_health_care_provider_capacity.community_health_centers_service_delivery_sites AS community_health_centers_service_delivery_sites, covid19_usa_health_care_provider_capacity.country_name AS country_name, covid19_usa_health_care_provider_capacity.hospital_beds AS hospital_beds, covid19_usa_health_care_provider_capacity.hospital_beds_per_1000 AS hospital_beds_per_1000, covid19_usa_health_care_provider_capacity.location AS location FROM covid19_usa_health_care_provider_capacity
https://dataport.open.denodo.com/server/covid_19_data/rws_covid19_cases_detailed_country_level_information/views/covid19_usa_health_care_provider_capacity?%24count=25
Information from the Kaiser Family Foundation about health care provider capacity: hospital beds, ICU beds, and CHC by state in the United States.
location | hospital_beds | hospital_beds_per_1000 | community_health_centers | community_health_centers_service_delivery_sites | country_name | links |
---|---|---|---|---|---|---|
United States | 792417 | 2.43 | 1331 | 11606 | United States of America | |
Alabama | 15278 | 3.13 | 15 | 144 | United States of America | |
Alaska | 1636 | 2.23 | 27 | 193 | United States of America | |
Arizona | 13846 | 1.93 | 20 | 188 | United States of America | |
Arkansas | 9517 | 3.16 | 12 | 142 | United States of America | |
California | 72511 | 1.84 | 177 | 1740 | United States of America | |
Colorado | 10574 | 1.86 | 20 | 215 | United States of America | |
Connecticut | 7194 | 2.01 | 16 | 290 | United States of America | |
Delaware | 2101 | 2.18 | 3 | 17 | United States of America | |
District of Columbia | 3114 | 4.44 | 8 | 66 | United States of America | |
Florida | 54744 | 2.58 | 47 | 610 | United States of America | |
Georgia | 25114 | 2.39 | 35 | 265 | United States of America | |
Hawaii | 2749 | 1.94 | 14 | 73 | United States of America | |
Idaho | 3396 | 1.94 | 14 | 115 | United States of America | |
Illinois | 32066 | 2.52 | 44 | 402 | United States of America | |
Indiana | 18156 | 2.71 | 25 | 197 | United States of America | |
Iowa | 9423 | 2.99 | 14 | 80 | United States of America | |
Kansas | 9659 | 3.32 | 18 | 91 | United States of America | |
Kentucky | 14329 | 3.21 | 24 | 324 | United States of America | |
Louisiana | 15272 | 3.28 | 34 | 287 | United States of America | |
Maine | 3400 | 2.54 | 18 | 156 | United States of America | |
Maryland | 11577 | 1.92 | 17 | 129 | United States of America | |
Massachusetts | 15649 | 2.27 | 39 | 276 | United States of America | |
Michigan | 24949 | 2.5 | 38 | 302 | United States of America | |
Minnesota | 13895 | 2.48 | 16 | 87 | United States of America |