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 7 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_irf_beds	skilled_nursing_beds	all_beds
1783	MCLAREN NORTHERN MICHIGAN	416 CONNABLE AVE	PETOSKEY	MI	49770	EMMET	(231) 487-4000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	45.3734770	-84.9691520	47	26	26047					https://data.medicare.gov/resource/xubh-q36u/row-fcnu-j4f4.fztp	230105	648840	2019-05-28	2018-09-30	129	18	40	187	15		202
2946	SAINT LUKE'S SOUTH HOSPITAL	12300 METCALF AVENUE	OVERLAND PARK	KS	66213	JOHNSON	(913) 317-7904	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	38.9055830	-94.6678470	91	20	20091	28140	Kansas City-Overland Park-Kansas City, MO-KS	Central	Johnson County	https://data.medicare.gov/resource/xubh-q36u/row-e3mi-imz9-8jhg	170185	648912	2019-05-28	2018-12-31	75	8		83	12		95
2990	FAIRCHILD MEDICAL CENTER	444 BRUCE STREET	YREKA	CA	96097	SISKIYOU	(530) 842-4121	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	41.7185790	-122.6454570	93	6	6093					https://data.medicare.gov/resource/xubh-q36u/row-wj65.hzqw~ibav	51316	659220	2019-05-28	2018-12-31	21	4		25			25
3634	CHILDREN'S HEALTHCARE OF ATLANTA AT SCOTTISH RITE	1001 JOHNSON FERRY ROAD	ATLANTA	GA	30342	FULTON	(404) 785-5252	Childrens	Voluntary non-profit - Other	TRUE	33.9079000	-84.3544260	121	13	13121	12060	Atlanta--Athens-Clarke County--Sandy Springs, GA	Central	Fulton County	https://data.medicare.gov/resource/xubh-q36u/row-9wgb.g8f7-d9n3	113301	649891	2019-05-28	2018-12-31	217	102		319			319
3665	MAYO CLINIC HEALTH SYSTEM-OAKRIDGE	13025 8TH ST	OSSEO	WI	54758	TREMPEALEAU	(715) 597-3121	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	44.5779110	-91.2163510	121	55	55121					https://data.medicare.gov/resource/xubh-q36u/row-vcjc-izvc_f2he	521302	649520	2019-05-28	2018-12-31	18			18			18
4088	LECONTE MEDICAL CENTER	742 MIDDLECREEK ROAD	SEVIERVILLE	TN	37862	SEVIER	(865) 446-7500	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	35.8538550	-83.5369650	155	47	47155	42940	Knoxville-Morristown-Sevierville, TN	Central	Sevier County	https://data.medicare.gov/resource/xubh-q36u/row-e253~p4xt.4gx7	440081	648984	2019-05-28	2018-12-31	42	16		58		51	109
4259	BAY PARK COMMUNITY HOSPITAL	2801 BAY PARK DRIVE	OREGON	OH	43616	LUCAS	(419) 690-7700	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	41.6183000	-83.4787000	173	39	39173	45780	Toledo-Port Clinton, OH	Central	Wood County	https://data.medicare.gov/resource/xubh-q36u/row-7sqh_8nj6.k327	360259	648743	2019-05-28	2018-12-31	69	8		77			77