COVID_HospitalBeds_CountyDemographics_NursingHomes

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

Custom SQL query returning 2 rows (hide)

Query parameters

rowidhospital_nameaddresscitystatezip_codecounty_namephone_numberhospital_typehospital_ownershipemergency_serviceslatlnggeocode_flaggeocode_accuracycountyfipsstatefipsstatecountyfipscbsacodecsatitlecentraloutlyingcountycountyequivalenthosp_lookup_urlPRVDR_NUMRPT_REC_NUMfiled_datefy_end_dateacute_bedsicu_bedscoronary_bedsburn_bedssurg_icu_bedsoth_spec_bedssubtotal_acute_bedssubprovider_ipf_bedssubprovider_irf_bedssubprovider_oth_bedsskilled_nursing_bedsnursing_fac_bedsoth_longterm_bedshospice_bedsall_beds
3464 ADVOCATE BROMENN MEDICAL CENTER 1304 FRANKLIN AVENUE NORMAL IL 61761 MC LEAN (309) 454-1400 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.4963320 -88.9909600 0   113 17 17113 14010 Bloomington-Pontiac, IL Central McLean County https://data.medicare.gov/resource/xubh-q36u/row-yyk7.wts2-z6re 140127 650688 2019-05-30 2018-12-31 176 30         206   15           221
4707 WISE REGIONAL HEALTH SYSTEM 609 MEDICAL CENTER DRIVE DECATUR TX 76234 WISE (940) 627-5921 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2202630 -97.5931070 0   497 48 48497 19100 Dallas-Fort Worth, TX-OK Outlying Wise County https://data.medicare.gov/resource/xubh-q36u/row-cn54-zrya.j3rq 450271 649353 2019-05-30 2018-12-31 60 21         81 20 15           116