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 3 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
684 ST ELIZABETH FLORENCE 4900 HOUSTON ROAD FLORENCE KY 41042 BOONE (859) 212-5220 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0176150 -84.6327900 0   15 21 21015 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-udck-fezy-tei6 180045 648693 2019-05-24 2018-12-31 108 18         126       16       142
1541 ST ELIZABETH FT THOMAS 85 NORTH GRAND AVENUE FORT THOMAS KY 41075 CAMPBELL (859) 572-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0782810 -84.4646540 0   37 21 21037 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Campbell County https://data.medicare.gov/resource/xubh-q36u/row-c5tu~ywst-jxv8 180001 648692 2019-05-24 2018-12-31 102 21         123       26       149
2699 ST ELIZABETH GRANT 238 BARNES ROAD WILLIAMSTOWN KY 41097 GRANT (859) 824-8105 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.6478620 -84.5782640 0   81 21 21081 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Outlying Grant County https://data.medicare.gov/resource/xubh-q36u/row-z5ru.drf8.yem5 181311 648696 2019-05-24 2018-12-31 15           15               15