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	oth_spec_beds	subtotal_acute_beds	subprovider_ipf_beds	subprovider_irf_beds	skilled_nursing_beds	oth_longterm_beds	all_beds
102	MARY LANNING HEALTHCARE	715 N ST JOSEPH AVE	HASTINGS	NE	68901	ADAMS	(402) 461-5108	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	40.5924160	-98.3874740	1	31	31001	25580		Central	Adams County	https://data.medicare.gov/resource/xubh-q36u/row-6nbf.h76f_85sy	280032	648632	2019-05-24	2018-12-31	87	10			97	26	9	11		143
1334	FORT WASHINGTON HOSPITAL	11711 LIVINGSTON ROAD	FORT WASHINGTON	MD	20744	PRINCE GEORGES	(301) 292-7000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	38.7288130	-76.9915880	33	24	24033	47900	Washington-Baltimore-Arlington, DC-MD-VA-WV-PA	Central	Prince George's County	https://data.medicare.gov/resource/xubh-q36u/row-wn97~mjiu~6g79	210060	648938	2019-05-24	2018-12-31	25	4			29					29
1503	VALLEY PRESBYTERIAN HOSPITAL	15107 VANOWEN ST	VAN NUYS	CA	91406	LOS ANGELES	(818) 782-6600	Acute Care Hospitals	Voluntary non-profit - Other	FALSE	34.1939170	-118.4632710	37	6	6037	31080	Los Angeles-Long Beach, CA	Central	Los Angeles County	https://data.medicare.gov/resource/xubh-q36u/row-k5i4-nbwt~csaa	50126	648666	2019-05-24	2018-12-31	271	20		32	333		17			350
2250	GOVE COUNTY MEDICAL CENTER	520 WEST 5TH STREET	QUINTER	KS	67752	GOVE	(785) 754-3341	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	39.0671610	-100.2413110	63	20	20063					https://data.medicare.gov/resource/xubh-q36u/row-yfic-b2ck-cmkm	171367	648622	2019-05-24	2018-12-31	21				21				42	63
2793	GLENCOE REGIONAL HEALTH SERVICES	1805 HENNEPIN AVENUE NORTH	GLENCOE	MN	55336	MC LEOD	(320) 864-3121	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	44.7775500	-94.1517140	85	27	27085	26780	Minneapolis-St. Paul, MN-WI	Central	McLeod County	https://data.medicare.gov/resource/xubh-q36u/row-j3nk_h3k3_6mv6	241355	649274	2019-05-24	2018-12-31	25				25			99		124
4133	TRINITY ROCK ISLAND	2701 17TH ST	ROCK ISLAND	IL	61201	ROCK ISLAND	(309) 779-5000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	41.4836490	-90.5727990	161	17	17161	19340	Davenport-Moline, IA-IL	Central	Rock Island County	https://data.medicare.gov/resource/xubh-q36u/row-93v6_urpw.vbnn	140280	648241	2019-05-24	2018-12-31	237	20	31		297		22	29		348