hospital_data

Table actions
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

10 rows where "filed_date" is on date 2019-08-27 and hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, icu_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, oth_longterm_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
1154 1154 MIMBRES MEMORIAL HOSPITAL 900 W ASH DEMING NM 88031 LUNA (575) 546-5803 Critical Access Hospitals Proprietary TRUE 32.2603723 -107.7678531 1 ROOFTOP 29 35 35029 19700   Central Luna County https://data.medicare.gov/resource/xubh-q36u/row-vtah.tqch.7v58 321309 653912 2019-08-27 2018-12-31 19 6         25               25
1255 1255 METROSOUTH MEDICAL CENTER 12935 S GREGORY BLUE ISLAND IL 60406 COOK (708) 597-2000 Acute Care Hospitals Proprietary TRUE 41.6586704 -87.6770674 1 ROOFTOP 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-miqp~tr2i-gj89 140118 653389 2019-08-27 2018-12-31 264 36         300 14             314
1766 1766 MOUNTAIN WEST MEDICAL CENTER 2055 NORTH MAIN STREET TOOELE UT 84074 TOOELE (435) 843-3700 Acute Care Hospitals Proprietary TRUE 40.5663676 -112.2978893 1 ROOFTOP 45 49 49045 41620 Salt Lake City-Provo-Orem, UT Outlying Tooele County https://data.medicare.gov/resource/xubh-q36u/row-c6yc_xi6t-5yr5 460014 653932 2019-08-27 2018-12-31 32 4         36               36
2440 2440 BARSTOW COMMUNITY HOSPITAL 820 E MOUNTAIN VIEW STREET BARSTOW CA 92311 SAN BERNARDINO (760) 256-1761 Acute Care Hospitals Proprietary TRUE 34.8936960 -117.0166000 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-2mmv_xa7g.rdya 50298 654086 2019-08-27 2019-01-31 26 4         30               30
2553 2553 ASPIRUS WAUSAU HOSPITAL 333 PINE RIDGE BLVD WAUSAU WI 54401 MARATHON (715) 847-2121 Acute Care Hospitals Proprietary TRUE 44.9645030 -89.6663720 0   73 55 55073 48140 Wausau-Stevens Point-Wisconsin Rapids, WI Central Marathon County https://data.medicare.gov/resource/xubh-q36u/row-xwvg~xtcv~8zke 520030 653166 2019-08-27 2019-06-30 181 28         223   12           235
2629 2629 HENDERSON COUNTY COMMUNITY HOSPITAL 200 W CHURCH ST LEXINGTON TN 38351 HENDERSON (731) 968-1801 Acute Care Hospitals Proprietary TRUE 35.6541950 -88.3988380 0   77 47 47077         https://data.medicare.gov/resource/xubh-q36u/row-cnu2~rrwu-tu6p 440008 653856 2019-08-27 2019-01-31 36           36               36
3334 3334 HELENA REGIONAL MEDICAL CENTER 1801 MARTIN LUTHER KING JR DRIVE HELENA AR 72342 PHILLIPS (870) 338-5800 Acute Care Hospitals Proprietary TRUE 34.5083570 -90.6273300 0   107 5 5107 25760   Central Phillips County https://data.medicare.gov/resource/xubh-q36u/row-wchu_rtin.sqck 40085 654083 2019-08-27 2018-12-31 121 6         127               127
3423 3423 FANNIN REGIONAL HOSPITAL 2855 OLD HIGHWAY 5 NORTH BLUE RIDGE GA 30513 FANNIN (706) 632-3711 Acute Care Hospitals Proprietary TRUE 34.9169230 -84.3755090 0   111 13 13111         https://data.medicare.gov/resource/xubh-q36u/row-3uid_fxin_vxkm 110189 653957 2019-08-27 2018-12-31 45 5         50               50
4295 4295 UNION COUNTY HOSPITAL 517 NORTH MAIN STREET ANNA IL 62906 UNION (618) 833-4511 Critical Access Hospitals Proprietary TRUE 37.4653050 -89.2450190 0   181 17 17181         https://data.medicare.gov/resource/xubh-q36u/row-pcrc-gp3a~kn84 141342 653887 2019-08-27 2018-12-31 25           25           22   47
4497 4497 SCENIC MOUNTAIN MEDICAL CENTER, A STEWARD FAMILY H 1601 W 11TH PLACE BIG SPRING TX 79720 HOWARD (432) 263-1211 Acute Care Hospitals Proprietary TRUE 32.2400150 -101.4924120 0   227 48 48227 13700   Central Howard County https://data.medicare.gov/resource/xubh-q36u/row-qsv2-q6dr_r7bx 450653 653861 2019-08-27 2018-12-31 67 8         75 17             92

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