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 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	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	subtotal_acute_beds	subprovider_ipf_beds	subprovider_irf_beds	all_beds
1679	EVANSTON REGIONAL HOSPITAL	190 ARROWHEAD DR	EVANSTON	WY	82930	UINTA	(307) 789-3636	Acute Care Hospitals	Proprietary	TRUE	41.2422140	-110.9913360	0		41	56	56041	21740		Central	Uinta County	https://data.medicare.gov/resource/xubh-q36u/row-7bqu_vhhd.zycd	530032	654952	2019-10-01	2019-04-30	26	6	32			32
2523	CAPITAL REGIONAL MEDICAL CENTER	2626 CAPITAL MEDICAL BLVD	TALLAHASSEE	FL	32308	LEON	(850) 656-5000	Acute Care Hospitals	Proprietary	TRUE	30.4753760	-84.2307280	0		73	12	12073	45220	Tallahassee-Bainbridge, FL-GA	Central	Leon County	https://data.medicare.gov/resource/xubh-q36u/row-9js5~veid~7wjn	100254	654879	2019-10-01	2019-04-30	246	20	266			266
3663	LEWISGALE HOSPITAL MONTGOMERY	3700 SOUTH MAIN STREET	BLACKSBURG	VA	24060	MONTGOMERY	(540) 951-1111	Acute Care Hospitals	Proprietary	TRUE	37.1856210	-80.4086120	0		121	51	51121	13980		Central	Montgomery County	https://data.medicare.gov/resource/xubh-q36u/row-3des-4erp_ke8h	490110	654901	2019-10-01	2018-09-30	78	10	88			88
4194	SUMNER REGIONAL MEDICAL CENTER	555 HARTSVILLE PIKE	GALLATIN	TN	37066	SUMNER	(615) 452-4210	Acute Care Hospitals	Proprietary	TRUE	36.3911170	-86.4343410	0		165	47	47165	34980	Nashville-Davidson--Murfreesboro, TN	Central	Sumner County	https://data.medicare.gov/resource/xubh-q36u/row-5cut-g6dp_ruat	440003	654752	2019-10-01	2019-04-30	108	18	126	12	17	155
4280	SPOTSYLVANIA REGIONAL MEDICAL CENTER	4600 SPOTSYLVANIA PARKWAY	FREDERICKSBURG	VA	22408	SPOTSYLVANIA	(540) 498-4000	Acute Care Hospitals	Proprietary	TRUE	38.2194960	-77.4964500	0		177	51	51177	47900	Washington-Baltimore-Arlington, DC-MD-VA-WV-PA	Outlying	Spotsylvania County	https://data.medicare.gov/resource/xubh-q36u/row-vmhu-vfub_yswh	490141	654902	2019-10-01	2019-04-30	93	12	105	28		133
4286	OTTUMWA REGIONAL HEALTH CENTER	1001 E PENNSYLVANIA	OTTUMWA	IA	52501	WAPELLO	(641) 682-7511	Acute Care Hospitals	Proprietary	TRUE	41.0288887	-92.3895049	1	ROOFTOP	179	19	19179	36900		Central	Wapello County	https://data.medicare.gov/resource/xubh-q36u/row-q5qs.dgin-w3wa	160089	654920	2019-10-01	2019-04-30	77	11	88	14	18	120