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	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	subtotal_acute_beds	subprovider_ipf_beds	all_beds
146	HOSPITAL OF CENTRAL CONNECTICUT, THE	100 GRAND STREET	NEW BRITAIN	CT	6050	HARTFORD	(860) 224-5011	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	41.6620150	-72.7877990	3	9	9003	25540	Hartford-West Hartford, CT	Central	Hartford County	https://data.medicare.gov/resource/xubh-q36u/row-wbxc-gjw3~i99u	70035	645240	2019-03-01	2018-09-30	222	24		246	32	278
363	BAPTIST MEDICAL CENTER-ATTALA	220 HWY 12 WEST	KOSCIUSKO	MS	39090	ATTALA	(662) 289-4311	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	33.0655920	-89.5967210	7	28	28007					https://data.medicare.gov/resource/xubh-q36u/row-24jy_6div~59c7	251336	644042	2019-03-01	2018-09-30	25			25		25
614	BAYSTATE WING HOSPITAL AND MEDICAL CENTERS	40 WRIGHT STREET	PALMER	MA	1069	HAMPDEN	(413) 283-7651	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	42.1687270	-72.3410310	13	25	25013	44140	Springfield-Greenfield Town, MA	Central	Hampden County	https://data.medicare.gov/resource/xubh-q36u/row-jar6~4ycw~3q2r	220030	645421	2019-03-01	2018-09-30	40	6		46	28	74
2058	NORTHSIDE HOSPITAL CHEROKEE	450 NORTHSIDE CHEROKEE BOULEVARD	CANTON	GA	30115	CHEROKEE	(770) 244-1000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	34.2275230	-84.4605620	57	13	13057	12060	Atlanta--Athens-Clarke County--Sandy Springs, GA	Central	Cherokee County	https://data.medicare.gov/resource/xubh-q36u/row-8mi6.4b7m_m9gq	110008	644263	2019-03-01	2018-09-30	99		15	114		114
3760	DIMMIT REGIONAL HOSPITAL	704 HOSPITAL DRIVE	CARRIZO SPRINGS	TX	78834	DIMMIT	(830) 876-2424	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	28.5199740	-99.8620980	127	48	48127					https://data.medicare.gov/resource/xubh-q36u/row-f4ys-ri9j-kfns	451390	643855	2019-03-01	2018-09-30	25			25		25
4206	THE JAMES B HAGGIN MEMORIAL HOSPITAL	464 LINDEN AVENUE	HARRODSBURG	KY	40330	MERCER	(859) 239-2409	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	37.7564480	-84.8482120	167	21	21167					https://data.medicare.gov/resource/xubh-q36u/row-wq8e~n6v3_qk82	181302	658990	2019-03-01	2018-09-30	21	4		25		25