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

9 rows where "filed_date" is on date 2019-05-22 and hospital_type = "Critical Access Hospitals"

View and edit SQL

Suggested facets: state, hospital_ownership, emergency_services, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, subtotal_acute_beds, subprovider_ipf_beds, nursing_fac_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
311 ATOKA COUNTY MEDICAL CENTER 1590 WEST LIBERTY ROAD ATOKA OK 74525 ATOKA (580) 889-3333 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.3952620 -96.1594880 0   5 40 40005         https://data.medicare.gov/resource/xubh-q36u/row-qvh3-hh93~canr 371300 649482 2019-05-22 2018-12-31 25           25               25
1110 FILLMORE COMMUNITY HOSPITAL 674 SOUTH HIGHWAY 99 FILLMORE UT 84631 MILLARD (435) 743-5591 Critical Access Hospitals Voluntary non-profit - Private FALSE 38.9541610 -112.3394550 0   27 49 49027         https://data.medicare.gov/resource/xubh-q36u/row-qrf9_kxm9-tj3a 461301 648497 2019-05-22 2018-12-31 19           19               19
1143 SANFORD BAGLEY MEDICAL CENTER 203 4TH STREET NORTHWEST BAGLEY MN 56621 CLEARWATER (218) 694-6501 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5258370 -95.4016760 0   29 27 27029         https://data.medicare.gov/resource/xubh-q36u/row-n7dg.2zvq~dkw4 241328 649453 2019-05-22 2018-12-31 25           25               25
1576 JEFFERSON MEDICAL CENTER 300 SOUTH PRESTON STREET RANSON WV 25438 JEFFERSON (304) 728-1600 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.2959710 -77.8582650 0   37 54 54037 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-ix2t~enbf.ekjg 511319 649005 2019-05-22 2018-12-31 20 5         25               25
1935 HEBER VALLEY HOSPITAL 1485 SOUTH HIGHWAY 40 HEBER CITY UT 84032 WASATCH (435) 654-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4890470 -111.4092180 0   51 49 49051 25720 Salt Lake City-Provo-Orem, UT Central Wasatch County https://data.medicare.gov/resource/xubh-q36u/row-8mif.5tu6.xu7b 461307 648498 2019-05-22 2018-12-31 19           19               19
2306 MADISON PARISH HOSPITAL 900 JOHNSON STREET TALLULAH LA 71282 MADISON (318) 574-2374 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.4037340 -91.1855030 0   65 22 22065         https://data.medicare.gov/resource/xubh-q36u/row-5rgc_wpty_n97z 191314 648538 2019-05-22 2018-12-31 25           25               25
2331 MEMORIAL HOSPITAL OF LAFAYETTE COUNTY 800 CLAY ST DARLINGTON WI 53530 LAFAYETTE (608) 776-4466 Critical Access Hospitals Government - Local TRUE 42.6839700 -90.1104190 0   65 55 55065         https://data.medicare.gov/resource/xubh-q36u/row-9ib5-tfyn~k464 521312 649522 2019-05-22 2018-12-31 25           25               25
2480 HIGHLAND DISTRICT HOSPITAL 1275 NORTH HIGH STREET HILLSBORO OH 45133 HIGHLAND (937) 393-6100 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2215760 -83.6087710 0   71 39 39071         https://data.medicare.gov/resource/xubh-q36u/row-8tax-6wz7_d86d 361332 648465 2019-05-22 2018-12-31 25           25 10             35
3520 SEDGWICK COUNTY MEMORIAL HOSPITAL 900 CEDAR ST JULESBURG CO 80737 SEDGWICK (970) 474-3323 Critical Access Hospitals Government - Local FALSE 40.9937430 -102.2692320 0   115 8 8115         https://data.medicare.gov/resource/xubh-q36u/row-ptjm_bmz6~8mzz 61310 649075 2019-05-22 2018-12-31 9           9         32     41

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
);