This dataset can be accessed in the following ways
SQL Query copied to clipboard
SELECT 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 |