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 "csatitle" = :p0 and date("filed_date") = :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	all_beds
2134	PIEDMONT ATHENS REGIONAL MEDICAL CENTER	1199 PRINCE AVENUE	ATHENS	GA	30606	CLARKE	(706) 475-7000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	33.9623770	-83.3977330	59	13	13059	12020	Atlanta--Athens-Clarke County--Sandy Springs, GA	Central	Clarke County	https://data.medicare.gov/resource/xubh-q36u/row-599w-riw6~r6rq	110074	659937	2019-11-22	2019-06-30	301	24	12	20	357	357
3462	PIEDMONT FAYETTE HOSPITAL	1255 HIGHWAY 54 WEST	FAYETTEVILLE	GA	30214	FAYETTE	(770) 719-7000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	33.4505930	-84.5105260	113	13	13113	12060	Atlanta--Athens-Clarke County--Sandy Springs, GA	Central	Fayette County	https://data.medicare.gov/resource/xubh-q36u/row-gfr6_jzg4.vm89	110215	659234	2019-11-22	2019-06-30	204	66		20	290	290
4461	MORGAN MEDICAL CENTER	1740 LIONS CLUB ROAD	MADISON	GA	30650	MORGAN	(706) 342-1667	Critical Access Hospitals	Government - Hospital District or Authority	TRUE	33.5675450	-83.4720040	211	13	13211	12060	Atlanta--Athens-Clarke County--Sandy Springs, GA	Outlying	Morgan County	https://data.medicare.gov/resource/xubh-q36u/row-55f2~6g7b_y7ku	111304	659236	2019-11-22	2019-06-30	25				25	25
4479	PIEDMONT NEWTON HOSPITAL	5126 HOSPITAL DRIVE NE	COVINGTON	GA	30014	NEWTON	(770) 786-7053	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	33.6026730	-83.8480820	217	13	13217	12060	Atlanta--Athens-Clarke County--Sandy Springs, GA	Central	Newton County	https://data.medicare.gov/resource/xubh-q36u/row-esav.9mwz.esp9	110018	659488	2019-11-22	2019-06-30	78	10		6	94	94
4494	PIEDMONT MOUNTAINSIDE HOSPITAL INC	1266 HIGHWAY 515 SOUTH	JASPER	GA	30143	PICKENS	(706) 301-5269	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	34.4474660	-84.4465610	227	13	13227	12060	Atlanta--Athens-Clarke County--Sandy Springs, GA	Outlying	Pickens County	https://data.medicare.gov/resource/xubh-q36u/row-3378.2eh9-tse8	110225	659235	2019-11-22	2019-06-30	46	6			52	52
4518	PIEDMONT ROCKDALE HOSPITAL	1412 MILSTEAD AVENUE, NE	CONYERS	GA	30012	ROCKDALE	(770) 918-3000	Acute Care Hospitals	Proprietary	FALSE	33.6822390	-84.0019410	247	13	13247	12060	Atlanta--Athens-Clarke County--Sandy Springs, GA	Central	Rockdale County	https://data.medicare.gov/resource/xubh-q36u/row-x66k.dxnr.f5df	110091	659231	2019-11-22	2019-06-30	105	16			141	141
4555	PIEDMONT WALTON HOSPITAL, INC	2151 W SPRING STREET	MONROE	GA	30655	WALTON	(770) 267-8461	Acute Care Hospitals	Proprietary	TRUE	33.7986350	-83.7463160	297	13	13297	12060	Atlanta--Athens-Clarke County--Sandy Springs, GA	Central	Walton County	https://data.medicare.gov/resource/xubh-q36u/row-ncms_jxz6_rqcg	110046	659772	2019-11-22	2019-06-30	69	7			76	76