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 6 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 "burn_beds" = :p0 order by oth_spec_beds 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	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	skilled_nursing_beds	oth_longterm_beds	all_beds
1415	METROHEALTH SYSTEM	2500 METROHEALTH DRIVE	CLEVELAND	OH	44109	CUYAHOGA	(216) 778-7089	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	41.4622390	-81.6979280	0		35	39	39035	17460	Cleveland-Akron-Canton, OH	Central	Cuyahoga County	https://data.medicare.gov/resource/xubh-q36u/row-tmz3-anq4-3mgv	360059	648966	2019-05-30	2018-12-31	400	28	16	14			528	20	67	4		619
4562	UNIVERSITY MEDICAL CENTER	602 INDIANA AVENUE	LUBBOCK	TX	79415	LUBBOCK	(806) 775-8200	Acute Care Hospitals	Government - Hospital District or Authority	TRUE	33.5894290	-101.8879770	0		303	48	48303	31180	Lubbock-Levelland, TX	Central	Lubbock County	https://data.medicare.gov/resource/xubh-q36u/row-rb7e~xppr~6ftx	450686	654605	2019-09-23	2018-12-31	293	104		14	20		476					476
1754	CROZER CHESTER MEDICAL CENTER	ONE MEDICAL CENTER BOULEVARD	UPLAND	PA	19013	DELAWARE	(610) 447-2000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	39.8559248	-75.3692897	1	ROOFTOP	45	42	42045	37980	Philadelphia-Reading-Camden, PA-NJ-DE-MD	Central	Delaware County	https://data.medicare.gov/resource/xubh-q36u/row-n43i.tyzh.5v4t	390180	649488	2019-05-30	2018-12-31	287	25	15	14		18	359	52	38		10	459
4111	REGIONAL ONE HEALTH	877 JEFFERSON AVENUE	MEMPHIS	TN	38103	SHELBY	(901) 545-7928	Acute Care Hospitals	Government - Hospital District or Authority	TRUE	35.1426340	-90.0312970	0		157	47	47157	32820	Memphis-Forrest City, TN-MS-AR	Central	Shelby County	https://data.medicare.gov/resource/xubh-q36u/row-s7c8-zbce-azfz	440152	660458	2019-11-27	2019-06-30	164			14		18	288		24	14		326
229	WEST PENN HOSPITAL	4800 FRIENDSHIP AVENUE	PITTSBURGH	PA	15224	ALLEGHENY	(412) 578-5000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	40.4624190	-79.9464350	0		3	42	42003	38300	Pittsburgh-New Castle-Weirton, PA-OH-WV	Central	Allegheny County	https://data.medicare.gov/resource/xubh-q36u/row-yf26.8cka~e7ru	390090	661633	2019-12-02	2019-06-30	124	34		14		20	260		33			293
2427	ARROWHEAD REGIONAL MEDICAL CENTER	400 NORTH PEPPER AVENUE	COLTON	CA	92324	SAN BERNARDINO	(909) 580-1000	Acute Care Hospitals	Government - Local	TRUE	34.0728840	-117.3528330	0		71	6	6071	40140	Los Angeles-Long Beach, CA	Central	San Bernardino County	https://data.medicare.gov/resource/xubh-q36u/row-w78g-jnyb.b7ix	50245	662024	2019-11-27	2019-06-30	274	32		14	16	30	366	90				456