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 17 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("fy_end_date") = :p0 order by hospital_name 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	oth_spec_beds	subtotal_acute_beds	subprovider_ipf_beds	all_beds
1578	ASPEN MOUNTAIN MEDICAL CENTER	4401 COLLEGE DRIVE	ROCK SPRINGS	WY	82901	SWEETWATER	(307) 448-2758	Acute Care Hospitals	Proprietary	FALSE	41.6031870	-109.2479170	0		37	56	56037	40540		Central	Sweetwater County	https://data.medicare.gov/resource/xubh-q36u/row-x9bs.ynhd_upz4	530035	651148	2018-05-29	2017-12-31
4620	CARE REGIONAL MEDICAL CENTER	1711 W WHEELER AVENUE	ARANSAS PASS	TX	78336	SAN PATRICIO	(361) 758-8585	Acute Care Hospitals	Proprietary	TRUE	27.9159210	-97.1618290	0		409	48	48409	18580	Corpus Christi-Kingsville-Alice, TX	Central	San Patricio County	https://data.medicare.gov/resource/xubh-q36u/row-g7k6_vy64~c2bf	450605	655598	2018-07-30	2017-12-31	63			63	12	75
2296	DOCTORS HOSPITAL OF RIVERSIDE	3865 JACKSON STREET	RIVERSIDE	CA	92503	RIVERSIDE	(951) 688-2211	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	33.9256970	-117.4400520	0		65	6	6065	40140	Los Angeles-Long Beach, CA	Central	Riverside County	https://data.medicare.gov/resource/xubh-q36u/row-sdgf-p94g_256s	50102	654640	2018-05-31	2017-12-31	166	13	12	191		191
191	HARMON HOSPITAL	2170 EAST HARMON AVENUE	LAS VEGAS	NV	89119	CLARK	(702) 794-0100	Acute Care Hospitals	Voluntary non-profit - Private	FALSE	36.1073690	-115.1219920	0		3	32	32003	29820	Las Vegas-Henderson, NV-AZ	Central	Clark County	https://data.medicare.gov/resource/xubh-q36u/row-qtzp-aczd_sysf	290042	629833	2018-05-31	2017-12-31
4579	LITTLE RIVER HEALTHCARE	1700 BRAZOS	ROCKDALE	TX	76567	MILAM	(512) 446-4500	Critical Access Hospitals	Proprietary	TRUE	30.6503240	-97.0201050	0		331	48	48331					https://data.medicare.gov/resource/xubh-q36u/row-afvn-5pmv_graz	451357	630239	2018-06-01	2017-12-31	25			25		25
1979	MARY BRIDGE CHILDREN'S HOSPITAL	317 MARTIN LUTHER KING JR W BOX 5299	TACOMA	WA	98415	PIERCE	(253) 403-1400	Childrens	Voluntary non-profit - Other	TRUE	47.2587434	-122.4527167	1	ROOFTOP	53	53	53053	42660	Seattle-Tacoma, WA	Central	Pierce County	https://data.medicare.gov/resource/xubh-q36u/row-8c85~gidq~gevc	503301	645385	2018-06-05	2017-12-31
158	SHRINERS HOSPITAL FOR CHILDREN	1310 PUNAHOU STREET	HONOLULU	HI	96826	HONOLULU	(808) 941-4466	Childrens	Voluntary non-profit - Private	FALSE	21.3002330	-157.8343650	0		3	15	15003	46520		Central	Honolulu County	https://data.medicare.gov/resource/xubh-q36u/row-jcn3.53aq~rski	123301	644976	2018-05-31	2017-12-31
2274	SHRINERS HOSPITAL FOR CHILDREN	911 WEST 5TH AVENUE	SPOKANE	WA	99204	SPOKANE	(509) 623-0422	Childrens	Voluntary non-profit - Private	FALSE	47.6513980	-117.4259570	0		63	53	53063	44060	Spokane-Spokane Valley-Coeur d'Alene, WA-ID	Central	Spokane County	https://data.medicare.gov/resource/xubh-q36u/row-mctz_2czz-inqw	503302	645453	2018-05-31	2017-12-31
1921	SHRINERS HOSPITAL FOR CHILDREN-PORTLAND	3101 SW SAM JACKSON PARK ROAD	PORTLAND	OR	97239	MULTNOMAH	(971) 544-3312	Childrens	Voluntary non-profit - Private	FALSE	45.5001050	-122.6846030	0		51	41	41051	38900	Portland-Vancouver-Salem, OR-WA	Central	Multnomah County	https://data.medicare.gov/resource/xubh-q36u/row-3x85_ztpc_gwzg	383300	645441	2018-05-31	2017-12-31
739	SHRINERS HOSPITALS FOR CHILDREN	3100 SAMFORD AVENUE	SHREVEPORT	LA	71103	CADDO	(318) 222-5704	Childrens	Voluntary non-profit - Private	FALSE	32.4812950	-93.7566370	0		17	22	22017	43340		Central	Caddo Parish	https://data.medicare.gov/resource/xubh-q36u/row-yvmb~28rx-rdcg	193301	647125	2018-05-31	2017-12-31
1501	SHRINERS HOSPITALS FOR CHILDREN	3160 GENEVA STREET	LOS ANGELES	CA	90020	LOS ANGELES	(213) 388-3151	Childrens	Voluntary non-profit - Private	FALSE	34.0677080	-118.2863870	0		37	6	6037	31080	Los Angeles-Long Beach, CA	Central	Los Angeles County	https://data.medicare.gov/resource/xubh-q36u/row-zkfj-xhi2.ce89	53310	655536	2018-05-31	2017-12-31
4432	SHRINERS HOSPITALS FOR CHILDREN	6977 MAIN STREET	HOUSTON	TX	77030	HARRIS	(713) 797-1616	Childrens	Voluntary non-profit - Other	FALSE	29.7047380	-95.4061740	0		201	48	48201	26420	Houston-The Woodlands, TX	Central	Harris County	https://data.medicare.gov/resource/xubh-q36u/row-zk7z~jazy_wtka	453312	651360	2018-07-12	2017-12-31
3238	SHRINERS HOSPITALS FOR CHILDREN - PHILADELPHIA	3551 N BROAD STREET	PHILADELPHIA	PA	19104	PHILADELPHIA	(215) 430-4000	Childrens	Voluntary non-profit - Other	FALSE	40.0069680	-75.1516990	0		101	42	42101	37980	Philadelphia-Reading-Camden, PA-NJ-DE-MD	Central	Philadelphia County	https://data.medicare.gov/resource/xubh-q36u/row-iwpu.igc9.39y9	393309	629311	2018-05-30	2017-12-31
1441	SHRINERS HOSPITALS FOR CHILDREN - SALT LAKE CITY	1275 EAST FAIRFAX ROAD	SALT LAKE CITY	UT	84103	SALT LAKE	(801) 536-3500	Childrens	Voluntary non-profit - Private	FALSE	40.7767640	-111.8511170	0		35	49	49035	41620	Salt Lake City-Provo-Orem, UT	Central	Salt Lake County	https://data.medicare.gov/resource/xubh-q36u/row-z268_bq8t.wgx8	463302	651875	2018-05-31	2017-12-31
2333	SHRINERS HOSPITALS FOR CHILDREN NORTHERN CALIF	2425 STOCKTON BOULEVARD	SACRAMENTO	CA	95817	SACRAMENTO	(916) 453-2000	Childrens	Voluntary non-profit - Private	FALSE	38.5529930	-121.4562690	0		67	6	6067	40900	Sacramento-Roseville, CA	Central	Sacramento County	https://data.medicare.gov/resource/xubh-q36u/row-pctf.xrmj_v2ef	53311	655537	2018-05-31	2017-12-31
1055	SUMMIT MEDICAL CENTER	6350 E 2ND STREET	CASPER	WY	82609	NATRONA	(307) 232-6600	Acute Care Hospitals	Physician	FALSE	42.8408460	-106.2317960	0		25	56	56025	16220		Central	Natrona County	https://data.medicare.gov/resource/xubh-q36u/row-8pwp.t3su_b96w	530034	645740	2019-03-04	2017-12-31
300	WEISMAN CHILDRENS REHABILITATION HOSPITAL	92 BRICK ROAD, 3RD FLOOR	MARLTON	NJ	8053	BURLINGTON	(856) 489-4520	Childrens	Proprietary	TRUE	39.8805880	-74.9192090	0		5	34	34005	37980	Philadelphia-Reading-Camden, PA-NJ-DE-MD	Central	Burlington County	https://data.medicare.gov/resource/xubh-q36u/row-9nkd_6jvc_38s2	313302	651476	2018-04-12	2017-12-31	18			18		18