Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

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

5 rows where csatitle = "Minneapolis-St. Paul, MN-WI" and "filed_date" is on date 2019-05-24

View and edit SQL

Suggested facets: state, county_name, hospital_type, hospital_ownership, countyfips, statefips, statecountyfips, cbsacode, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_irf_beds, skilled_nursing_beds, all_beds, filed_date (date), fy_end_date (date)

Link rowid ▼ hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
2793 GLENCOE REGIONAL HEALTH SERVICES 1805 HENNEPIN AVENUE NORTH GLENCOE MN 55336 MC LEOD (320) 864-3121 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.7775500 -94.1517140 0   85 27 27085 26780 Minneapolis-St. Paul, MN-WI Central McLeod County https://data.medicare.gov/resource/xubh-q36u/row-j3nk_h3k3_6mv6 241355 649274 2019-05-24 2018-12-31 25           25       99       124
3407 WESTFIELDS HOSPITAL AND CLINIC 535 HOSPITAL RD NEW RICHMOND WI 54017 ST. CROIX (715) 243-2600 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.1174600 -92.5532140 0   109 55 55109 33460 Minneapolis-St. Paul, MN-WI Outlying St. Croix County https://data.medicare.gov/resource/xubh-q36u/row-v45z.6njd_wida 521345 649384 2019-05-24 2018-12-31 25           25               25
3410 HUDSON HOSPITAL & CLINIC 405 STAGELINE ROAD HUDSON WI 54016 ST. CROIX (715) 531-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9622890 -92.7188390 0   109 55 55109 33460 Minneapolis-St. Paul, MN-WI Outlying St. Croix County https://data.medicare.gov/resource/xubh-q36u/row-sjw8_yf3z~m67j 521335 649383 2019-05-24 2018-12-31 25           25               25
3682 REGIONS HOSPITAL 640 JACKSON STREET SAINT PAUL MN 55101 RAMSEY (651) 254-1616 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9553380 -93.0962770 0   123 27 27123 33460 Minneapolis-St. Paul, MN-WI Central Ramsey County https://data.medicare.gov/resource/xubh-q36u/row-36zs~9stm-xa4i 240106 649268 2019-05-24 2018-12-31 375 16 12   18 10 431   21           452
4175 LAKEVIEW MEMORIAL HOSPITAL 927 WEST CHURCHILL STREET STILLWATER MN 55082 WASHINGTON (651) 430-5330 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.0481260 -92.8184890 0   163 27 27163 33460 Minneapolis-St. Paul, MN-WI Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-wues-hzji_9g79 240066 649267 2019-05-24 2018-12-31 55 13         68               68

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [hospital_data] (
   [hospital_name] TEXT,
   [address] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip_code] INTEGER,
   [county_name] TEXT,
   [phone_number] TEXT,
   [hospital_type] TEXT,
   [hospital_ownership] TEXT,
   [emergency_services] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [countyfips] INTEGER,
   [statefips] INTEGER,
   [statecountyfips] INTEGER,
   [cbsacode] TEXT,
   [csatitle] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [hosp_lookup_url] TEXT,
   [PRVDR_NUM] INTEGER,
   [RPT_REC_NUM] INTEGER,
   [filed_date] TEXT,
   [fy_end_date] TEXT,
   [acute_beds] INTEGER,
   [icu_beds] TEXT,
   [coronary_beds] TEXT,
   [burn_beds] TEXT,
   [surg_icu_beds] TEXT,
   [oth_spec_beds] TEXT,
   [subtotal_acute_beds] INTEGER,
   [subprovider_ipf_beds] TEXT,
   [subprovider_irf_beds] TEXT,
   [subprovider_oth_beds] TEXT,
   [skilled_nursing_beds] TEXT,
   [nursing_fac_beds] TEXT,
   [oth_longterm_beds] TEXT,
   [hospice_beds] TEXT,
   [all_beds] INTEGER
);