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 12 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 "geocode_flag" = :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	surg_icu_beds	oth_spec_beds	subtotal_acute_beds	subprovider_ipf_beds	subprovider_irf_beds	skilled_nursing_beds	all_beds
654	METHODIST HOSPITAL SOUTH	1905 HWY 97 EAST	JOURDANTON	TX	78026	ATASCOSA	(830) 769-3515	Acute Care Hospitals	Proprietary	TRUE	28.9331124	-98.5260352	1	ROOFTOP	13	48	48013	41700		Outlying	Atascosa County	https://data.medicare.gov/resource/xubh-q36u/row-5vk8_ecmw.2bzr	450165	660714	2019-11-26	2019-06-30	61	6				67				67
839	UNIVERSITY OF MISSOURI HEALTH CARE	ONE HOSPITAL DRIVE	COLUMBIA	MO	65212	BOONE	(573) 882-4141	Acute Care Hospitals	Government - State	TRUE	38.9386955	-92.3275514	1	ROOFTOP	19	29	29019	17860	Columbia-Moberly-Mexico, MO	Central	Boone County	https://data.medicare.gov/resource/xubh-q36u/row-63ac~57ef~2j52	260141	660405	2019-11-26	2019-06-30	372	82			58	530	61			591
1295	CARRINGTON HEALTH CENTER	PO BOX 461	CARRINGTON	ND	58421	FOSTER	(701) 652-3141	Critical Access Hospitals	Voluntary non-profit - Private	TRUE	47.4497201	-99.1262234	1	APPROXIMATE	31	38	38031					https://data.medicare.gov/resource/xubh-q36u/row-inkg_zfig.5z7t	351318	662239	2019-11-26	2019-06-30	25					25				25
1309	HOSPITAL UPR, DR FEDERICO TRILLA	CARR 3 KM 8 3 AVE 65TH INFANTERIA BOX 6021	CAROLINA	PR	984	CAROLINA	(787) 757-1800	Acute Care Hospitals	Proprietary	FALSE	18.3808638	-65.9632825	1	RANGE_INTERPOLATED	31	72	72031	41980	San Juan-Carolina, PR	Central	Carolina Municipio	https://data.medicare.gov/resource/xubh-q36u/row-xbn3-25u3~b8g7	400112	660876	2019-11-26	2019-06-30	210	8				233				233
1571	SAINT THOMAS WEST HOSPITAL	4220 HARDING RD, PO BOX 380	NASHVILLE	TN	37205	DAVIDSON	(615) 222-2111	Acute Care Hospitals	Voluntary non-profit - Church	TRUE	36.1290830	-86.8434476	1	ROOFTOP	37	47	47037	34980	Nashville-Davidson--Murfreesboro, TN	Central	Davidson County	https://data.medicare.gov/resource/xubh-q36u/row-xfk3~krcg.f39q	440082	660312	2019-11-26	2019-06-30	252	88				340				340
1932	MILBANK AREA HOSPITAL/AVERA HEALTH	301 FLYNN DRIVE	MILBANK	SD	57252	GRANT	(605) 432-4538	Critical Access Hospitals	Voluntary non-profit - Private	TRUE	45.2219130	-96.6175485	1	ROOFTOP	51	46	46051					https://data.medicare.gov/resource/xubh-q36u/row-y6xc~czq6~y94b	431326	660034	2019-11-26	2019-06-30	25					25				25
1974	AVERA GREGORY HOSPITAL	400 PARK STREET POST OFFICE BOX 408	GREGORY	SD	57533	GREGORY	(605) 835-8394	Critical Access Hospitals	Voluntary non-profit - Private	TRUE	43.2319878	-99.4304377	1	ROOFTOP	53	46	46053					https://data.medicare.gov/resource/xubh-q36u/row-sxnm~ansc_ejzf	431338	662257	2019-11-26	2019-06-30	25					25			55	80
3230	HOSPITAL OF UNIV OF PENNSYLVANIA	34TH & SPRUCE STS	PHILADELPHIA	PA	19104	PHILADELPHIA	(215) 662-3227	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.9504425	-75.1925902	1	GEOMETRIC_CENTER	101	42	42101	37980	Philadelphia-Reading-Camden, PA-NJ-DE-MD	Central	Philadelphia County	https://data.medicare.gov/resource/xubh-q36u/row-2v8t-hvbn_kbi7	390111	661968	2019-11-26	2019-06-30	587	32	12	78	2	748		58		806
3780	PRESBYTERIAN COMMUNITY HOSP	1451 ASHFORD AVENUE	SAN JUAN	PR	907	SAN JUAN	(787) 721-2160	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	18.4550543	-66.0654679	1	ROOFTOP	127	72	72127	41980	San Juan-Carolina, PR	Central	San Juan Municipio	https://data.medicare.gov/resource/xubh-q36u/row-gmb5-dr3a.fzy4	400001	660874	2019-11-26	2019-06-30	151	6				175				175
3793	EXCELA HEALTH LATROBE HOSPITAL	ONE MELLON WAY	LATROBE	PA	15650	WESTMORELAND	(724) 537-1000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	40.3209181	-79.3939014	1	ROOFTOP	129	42	42129	38300	Pittsburgh-New Castle-Weirton, PA-OH-WV	Central	Westmoreland County	https://data.medicare.gov/resource/xubh-q36u/row-ciy8-dq9e-fjwc	390219	659879	2019-11-26	2019-06-30	111	11				122				122
4060	CENTRACARE HEALTH SYSTEM - LONG PRAIRIE	50 CENTRACARE DRIVE	LONG PRAIRIE	MN	56347	TODD	(320) 732-2141	Critical Access Hospitals	Voluntary non-profit - Private	TRUE	45.9733659	-94.8429923	1	ROOFTOP	153	27	27153					https://data.medicare.gov/resource/xubh-q36u/row-auf6_7hb8_cyed	241326	660609	2019-11-26	2019-06-30	14					14			70	84
4298	WEBSTER COUNTY COMMUNITY HOSPITAL	P O BOX 465, 621 N FRANKLIN ST	RED CLOUD	NE	68970	WEBSTER	(402) 746-5600	Critical Access Hospitals	Government - Local	TRUE	40.0915582	-98.5280755	1	ROOFTOP	181	31	31181					https://data.medicare.gov/resource/xubh-q36u/row-2g3y_shvn~j8h3	281316	660132	2019-11-26	2019-06-30	13					13				13