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 20 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 "hospital_ownership" = :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	oth_longterm_beds	all_beds
250	BERKELEY MEDICAL CENTER	2500 HOSPITAL DRIVE	MARTINSBURG	WV	25401	BERKELEY	(304) 264-1000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.4772540	-77.9806190	3	54	54003	25180	Washington-Baltimore-Arlington, DC-MD-VA-WV-PA	Central	Berkeley County	https://data.medicare.gov/resource/xubh-q36u/row-faju-yvek_2eqd	510008	648871	2019-05-21	2018-12-31	122	20			146	23			169
324	NORTHEASTERN VERMONT REGIONAL HOSPITAL	1315 HOSPITAL DRIVE	SAINT JOHNSBURY	VT	5819	CALEDONIA	(802) 748-7400	Critical Access Hospitals	Voluntary non-profit - Private	TRUE	44.4452620	-72.0095160	5	50	50005					https://data.medicare.gov/resource/xubh-q36u/row-868v.jqmt-84z2	471303	649002	2019-05-21	2018-09-30	21	4			25				25
400	BRAXTON COUNTY MEMORIAL HOSPITAL	100 HOYLMAN DRIVE	GASSAWAY	WV	26624	BRAXTON	(304) 364-5156	Critical Access Hospitals	Voluntary non-profit - Private	TRUE	38.6601260	-80.7483340	7	54	54007					https://data.medicare.gov/resource/xubh-q36u/row-4gv3_6ku8_c448	511308	648873	2019-05-21	2018-12-31	25				25				25
485	CLEVELAND CLINIC HOSPITAL	3100 WESTON RD	WESTON	FL	33331	BROWARD	(954) 689-5000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	26.0804010	-80.3654670	11	12	12011	33100	Miami-Fort Lauderdale-Port St. Lucie, FL	Central	Broward County	https://data.medicare.gov/resource/xubh-q36u/row-fghj-6tqw.6cse	100289	648091	2019-05-21	2018-12-31	158	48			206				206
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
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
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
2305	MARCUM & WALLACE MEMORIAL HOSPITAL	60 MERCY COURT	IRVINE	KY	40336	ESTILL	(606) 723-2115	Critical Access Hospitals	Voluntary non-profit - Private	TRUE	37.7052670	-83.9777420	65	21	21065					https://data.medicare.gov/resource/xubh-q36u/row-2ab6~wg69.6pp4	181301	648695	2019-05-21	2018-12-31	25				25				25
2781	STANFORD HEALTH CARE	300 PASTEUR DRIVE	STANFORD	CA	94305	SANTA CLARA	(650) 723-5708	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	37.4331380	-122.1766640	85	6	6085	41940	San Jose-San Francisco-Oakland, CA	Central	Santa Clara County	https://data.medicare.gov/resource/xubh-q36u/row-v6r4_6jzv~q6hb	50441	662344	2019-05-21	2018-08-31	380	59	8		447	30			477
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
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
3361	CAMDEN CLARK MEDICAL CENTER	800 GARFIELD AVE	PARKERSBURG	WV	26101	WOOD	(304) 424-2111	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.2702090	-81.5604260	107	54	54107	37620	Parkersburg-Marietta-Vienna, WV-OH	Central	Wood County	https://data.medicare.gov/resource/xubh-q36u/row-pmmk.a48e.nj6g	510058	648872	2019-05-21	2018-12-31	194	18	18		230	19			249
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