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 4 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
3685 S E LACKEY MEMORIAL HOSPITAL 330 N BROAD STREET FOREST MS 39074 SCOTT (601) 469-4151 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.3659070 -89.4709630 0   123 28 28123         https://data.medicare.gov/resource/xubh-q36u/row-kw7i.243c~t4se 251300 654851 2019-10-07 2019-07-31 25           25 10             35
2817 METHODIST MCKINNEY HOSPITAL 8000 W ELDORADO PKWY BLDG C SUITE C MCKINNEY TX 75070 COLLIN (214) 491-5710 Acute Care Hospitals Proprietary TRUE 33.1758090 -96.7243430 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-mnxi-9kbn.uk2u 670069 661131 2019-12-11 2019-07-31 23           23               23
2400 FLEMING COUNTY HOSPITAL 55 FOUNDATION DRIVE FLEMINGSBURG KY 41041 FLEMING (606) 849-2351 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.4215390 -83.7530940 0   69 21 21069         https://data.medicare.gov/resource/xubh-q36u/row-xzgt-vj27~vpzh 180053 662527 2019-12-18 2019-07-31 49 3         52               52
1962 PHILLIPS EYE INSTITUTE 2215 PARK AVENUE SOUTH MINNEAPOLIS MN 55404 HENNEPIN (612) 775-8751 Acute Care Hospitals Government - Federal FALSE 44.9604780 -93.2651060 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-6egw_a4dk~jkf6 240196 662388 2019-12-11 2019-07-31 8           8               8