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	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	subtotal_acute_beds	subprovider_ipf_beds	nursing_fac_beds	oth_longterm_beds	all_beds
82	KONA COMMUNITY HOSPITAL	79-1019 HAUKAPILA STREET	KEALAKEKUA	HI	96750	HAWAII	(808) 322-9311	Acute Care Hospitals	Government - State	TRUE	19.5192370	-155.9177190	0		1	15	15001	25900		Central	Hawaii County	https://data.medicare.gov/resource/xubh-q36u/row-j5zq.9y53_j6as	120019	662187	2019-12-02	2019-06-30	74	9		83	11			94
84	KAU HOSPITAL	1 KAMANI STREET	PAHALA	HI	96777	HAWAII	(808) 928-8331	Critical Access Hospitals	Government - State	TRUE	19.2005710	-155.4720970	0		1	15	15001	25900		Central	Hawaii County	https://data.medicare.gov/resource/xubh-q36u/row-jcnf-fhnk_q5i3	121301	662188	2019-12-02	2019-06-30	6			6				6
632	UNIVERSITY HOSPITAL	150 BERGEN ST	NEWARK	NJ	7101	ESSEX	(973) 972-5658	Acute Care Hospitals	Government - State	TRUE	40.7409500	-74.1921300	0		13	34	34013	35620	New York-Newark, NY-NJ-CT-PA	Central	Essex County	https://data.medicare.gov/resource/xubh-q36u/row-b5qq_ap3x-6s92	310119	661058	2019-12-02	2019-06-30	266	41	6	355				355
1584	FLORIDA STATE HOSPITAL UNIT 31 MED	100 N MAIN ST	CHATTAHOOCHEE	FL	32324	GADSDEN	(850) 663-7536	Acute Care Hospitals	Government - State	FALSE	30.7068990	-84.8425840	0		39	12	12039	45220	Tallahassee-Bainbridge, FL-GA	Outlying	Gadsden County	https://data.medicare.gov/resource/xubh-q36u/row-kyk8-9a3q-5siu	100298	660194	2019-12-02	2019-06-30	24			24	34		1172	1230
1824	WELCH COMMUNITY HOSPITAL	454 MCDOWELL STREET	WELCH	WV	24801	MC DOWELL	(304) 436-8461	Acute Care Hospitals	Government - State	TRUE	37.4388220	-81.5892950	0		47	54	54047					https://data.medicare.gov/resource/xubh-q36u/row-y7rn~73h2.fggs	510086	661439	2019-12-02	2019-06-30	42	7		49		59		108
3313	LALLIE KEMP MEDICAL CENTER	52579 HIGHWAY 51 SOUTH	INDEPENDENCE	LA	70443	TANGIPAHOA	(985) 878-9421	Critical Access Hospitals	Government - State	TRUE	30.6221940	-90.4969990	0		105	22	22105	25220	New Orleans-Metairie-Hammond, LA-MS	Central	Tangipahoa Parish	https://data.medicare.gov/resource/xubh-q36u/row-iyxe~6sc2-ecgv	191321	662534	2019-12-02	2019-06-30	20	4		24				24
3645	WHITFIELD MEDICAL SURGICAL HOSPITAL	3550 HWY 468 W, BLDG 60	WHITFIELD	MS	39193	RANKIN	(601) 351-8023	Acute Care Hospitals	Government - State	FALSE	32.2418381	-90.0709905	1	ROOFTOP	121	28	28121	27140	Jackson-Vicksburg-Brookhaven, MS	Central	Rankin County	https://data.medicare.gov/resource/xubh-q36u/row-h6gx_kf5u~ce53	250134	660110	2019-12-02	2019-06-30	32			32				32