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 5 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 hospital_name 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	all_beds
4159	DETROIT RECEIVING HOSPITAL & UNIV HEALTH CENTER	4201 ST ANTOINE ST - 2C	DETROIT	MI	48201	WAYNE	(313) 745-3104	Acute Care Hospitals	Proprietary	TRUE	42.3535426	-83.0550940	1	ROOFTOP	163	26	26163	19820	Detroit-Warren-Ann Arbor, MI	Central	Wayne County	https://data.medicare.gov/resource/xubh-q36u/row-niud-7c22~chx9	230273	649265	2019-05-30	2018-12-31	134	28	12	9	12		195	19		214
2613	MERCY HOSPITAL SPRINGFIELD	1235 E CHEROKEE	SPRINGFIELD	MO	65804	GREENE	(417) 820-2000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	37.1779690	-93.2752760	0		77	29	29077	44180	Springfield-Branson, MO	Central	Greene County	https://data.medicare.gov/resource/xubh-q36u/row-nsr7-quxq_yayx	260065	661209	2019-11-26	2019-06-30	530	55		9	25	46	665			665
4358	MERCY HOSPITAL ST LOUIS	615 NEW BALLAS ROAD	SAINT LOUIS	MO	63141	ST. LOUIS	(314) 569-6000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	38.6439938	-90.4465938	1	ROOFTOP	189	29	29189	41180	St. Louis-St. Charles-Farmington, MO-IL	Central	St. Louis County	https://data.medicare.gov/resource/xubh-q36u/row-37f8.hd52.bkvb	260020	661026	2019-11-27	2019-06-30	654	66	16	9		98	843	16		859
3506	PARKLAND HEALTH AND HOSPITAL SYSTEM	5200 HARRY HINES BLVD	DALLAS	TX	75235	DALLAS	(214) 590-8000	Acute Care Hospitals	Government - Hospital District or Authority	TRUE	32.8117980	-96.8369810	0		113	48	48113	19100	Dallas-Fort Worth, TX-OK	Central	Dallas County	https://data.medicare.gov/resource/xubh-q36u/row-r83n-2jzv.t89y	450015	659727	2019-11-19	2018-09-30	621	35		9	17	77	771	18	18	807
801	ST. MARY'S HOSPITAL	1601 WEST ST MARY'S ROAD	TUCSON	AZ	85745	PIMA	(520) 872-3000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	32.2289230	-111.0000320	0		19	4	4019	46060	Tucson-Nogales, AZ	Central	Pima County	https://data.medicare.gov/resource/xubh-q36u/row-8z3y-kp4a.tw3t	30010	644007	2019-02-28	2018-09-30	300	40		9			349	23	28	400