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 17 rows (hide)

select 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 from hospital_data where date("filed_date") = :p0 and "state" = :p1 order by rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	hospital_name	address	city	state	zip_code	county_name	phone_number	hospital_type	hospital_ownership	emergency_services	lat	lng	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	oth_spec_beds	subtotal_acute_beds	subprovider_ipf_beds	subprovider_irf_beds	skilled_nursing_beds	oth_longterm_beds	all_beds
780	MERCY HEALTH - FAIRFIELD HOSPITAL	3000 MACK ROAD	FAIRFIELD	OH	45014	BUTLER	(513) 870-7197	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.3109020	-84.5195010	17	39	39017	17140	Cincinnati-Wilmington-Maysville, OH-KY-IN	Central	Butler County	https://data.medicare.gov/resource/xubh-q36u/row-jn7g~5cw6.5wsb	360056	648731	2019-05-21	2018-12-31	163	18	18		199		15			214
922	MERCY HEALTH - URBANA HOSPITAL	904 SCIOTO STREET	URBANA	OH	43078	CHAMPAIGN	(937) 653-5231	Critical Access Hospitals	Voluntary non-profit - Private	TRUE	40.1067250	-83.7302520	21	39	39021	46500	Dayton-Springfield-Sidney, OH	Central	Champaign County	https://data.medicare.gov/resource/xubh-q36u/row-2ktb~7c9h_tz4d	361312	648464	2019-05-21	2018-12-31	25				25	10				35
976	MERCY HEALTH - SPRINGFIELD REGIONAL MEDICAL CENTER	100 MEDICAL CENTER DRIVE	SPRINGFIELD	OH	45504	CLARK	(937) 523-1000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.9276240	-83.8157400	23	39	39023	44220	Dayton-Springfield-Sidney, OH	Central	Clark County	https://data.medicare.gov/resource/xubh-q36u/row-mf4i-3hs8~42yn	360086	648735	2019-05-21	2018-12-31	192	38			230		24			254
1033	MERCY HEALTH - CLERMONT HOSPITAL	3000 HOSPITAL DRIVE	BATAVIA	OH	45103	CLERMONT	(513) 732-8590	Acute Care Hospitals	Voluntary non-profit - Church	FALSE	39.0783090	-84.1449860	25	39	39025	17140	Cincinnati-Wilmington-Maysville, OH-KY-IN	Central	Clermont County	https://data.medicare.gov/resource/xubh-q36u/row-xva7-c5j9.zf8c	360236	648460	2019-05-21	2018-12-31	131	16			147					147
1096	CLINTON MEMORIAL HOSPITAL	610 WEST MAIN STREET	WILMINGTON	OH	45177	CLINTON	(937) 382-6611	Acute Care Hospitals	Government - Local	TRUE	39.4455420	-83.8394060	27	39	39027	48940	Cincinnati-Wilmington-Maysville, OH-KY-IN	Central	Clinton County	https://data.medicare.gov/resource/xubh-q36u/row-cuks-2rvh-qwpd	360175	648304	2019-05-21	2018-12-31	69	6			75					75
1408	HILLCREST HOSPITAL	6780 MAYFIELD ROAD	MAYFIELD HEIGHTS	OH	44124	CUYAHOGA	(440) 312-4500	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	41.5201330	-81.4343450	35	39	39035	17460	Cleveland-Akron-Canton, OH	Central	Cuyahoga County	https://data.medicare.gov/resource/xubh-q36u/row-6qz8~ktjz~ic38	360230	648458	2019-05-21	2018-12-31	302	23	12	35	385					385
1417	MARYMOUNT HOSPITAL	12300 MCCRACKEN ROAD	GARFIELD HEIGHTS	OH	44125	CUYAHOGA	(216) 581-0500	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	41.4224160	-81.5982710	35	39	39035	17460	Cleveland-Akron-Canton, OH	Central	Cuyahoga County	https://data.medicare.gov/resource/xubh-q36u/row-x3qr~kib9-zfuq	360143	648456	2019-05-21	2018-12-31	193	28			221	67				288
1421	LUTHERAN HOSPITAL	1730 WEST 25TH STREET	CLEVELAND	OH	44113	CUYAHOGA	(216) 696-4300	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	41.4872430	-81.7058340	35	39	39035	17460	Cleveland-Akron-Canton, OH	Central	Cuyahoga County	https://data.medicare.gov/resource/xubh-q36u/row-mmdc_utmv~fvev	360087	648736	2019-05-21	2018-12-31	109	10			119	82				201
1422	EUCLID HOSPITAL	18901 LAKE SHORE BOULEVARD	EUCLID	OH	44119	CUYAHOGA	(216) 531-9000	Acute Care Hospitals	Voluntary non-profit - Other	FALSE	41.5967340	-81.5474210	35	39	39035	17460	Cleveland-Akron-Canton, OH	Central	Cuyahoga County	https://data.medicare.gov/resource/xubh-q36u/row-cmpf.r9xq-srhj	360082	648734	2019-05-21	2018-12-31	98	12			110	15		40		165
1423	PARMA COMMUNITY GENERAL HOSPITAL	7007 POWERS BOULEVARD	PARMA	OH	44129	CUYAHOGA	(440) 743-3000	Acute Care Hospitals	Voluntary non-profit - Private	FALSE	41.3827620	-81.7314760	35	39	39035	17460	Cleveland-Akron-Canton, OH	Central	Cuyahoga County	https://data.medicare.gov/resource/xubh-q36u/row-taje-fzub~tnzc	360041	648296	2019-05-21	2018-12-31	200	16	14		230	14	29			273
1424	FAIRVIEW HOSPITAL	18101 LORAIN AVENUE	CLEVELAND	OH	44111	CUYAHOGA	(216) 476-7000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	41.4500690	-81.8209960	35	39	39035	17460	Cleveland-Akron-Canton, OH	Central	Cuyahoga County	https://data.medicare.gov/resource/xubh-q36u/row-4ekz_zwua~wb2p	360077	648733	2019-05-21	2018-12-31	349	38	14	34	435					435
2219	THE JEWISH HOSPITAL-MERCY HEALTH	4777 EAST GALBRAITH ROAD	CINCINNATI	OH	45236	HAMILTON	(513) 686-4127	Acute Care Hospitals	Voluntary non-profit - Private	FALSE	39.2067700	-84.3803720	61	39	39061	17140	Cincinnati-Wilmington-Maysville, OH-KY-IN	Central	Hamilton County	https://data.medicare.gov/resource/xubh-q36u/row-wrf8-t245.dvxf	360016	648728	2019-05-21	2018-12-31	118	54			172		14			186
2222	MERCY HEALTH - WEST HOSPITAL	3300 MERCY HEALTH BLVD	CINCINNATI	OH	45211	HAMILTON	(513) 215-5000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.1808840	-84.5953940	61	39	39061	17140	Cincinnati-Wilmington-Maysville, OH-KY-IN	Central	Hamilton County	https://data.medicare.gov/resource/xubh-q36u/row-8x4z_2qzb_2rqs	360234	648459	2019-05-21	2018-12-31	167	18	12		197		24			221
3010	MERCY HEALTH-LORAIN HOSPITAL	3700 KOLBE ROAD	LORAIN	OH	44053	LORAIN	(440) 960-4000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	41.4360020	-82.2352120	93	39	39093	17460	Cleveland-Akron-Canton, OH	Outlying	Lorain County	https://data.medicare.gov/resource/xubh-q36u/row-32k3_ajz8.6apg	360172	648303	2019-05-21	2018-12-31	155	16			171	25	30		13	239
3175	MH ST ELIZABETH BOARDMAN HOSPITAL	8401 MARKET STREET	BOARDMAN	OH	44512	MAHONING	(330) 729-2929	Acute Care Hospitals	Voluntary non-profit - Church	TRUE	40.9949560	-80.6627440	99	39	39099	49660	Youngstown-Warren, OH-PA	Central	Mahoning County	https://data.medicare.gov/resource/xubh-q36u/row-zues-ehaf-ss3m	360276	648461	2019-05-21	2018-12-31	188	18			206					206
3287	MEDINA HOSPITAL	1000 EAST WASHINGTON STREET	MEDINA	OH	44256	MEDINA	(330) 725-1000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	41.1388850	-81.8369330	103	39	39103	17460	Cleveland-Akron-Canton, OH	Central	Medina County	https://data.medicare.gov/resource/xubh-q36u/row-76xx-cu4t_nvyn	360091	648737	2019-05-21	2018-12-31	118	12			130					130
4087	MH ST JOSEPH WARREN HOSPITAL	667 EASTLAND AVE SE	WARREN	OH	44481	TRUMBULL	(330) 841-4016	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	41.2309550	-80.7783470	155	39	39155	49660	Youngstown-Warren, OH-PA	Central	Trumbull County	https://data.medicare.gov/resource/xubh-q36u/row-q9s4_4r2g~kccn	360161	648302	2019-05-21	2018-12-31	115	12			127					127