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 15 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	burn_beds	oth_spec_beds	subtotal_acute_beds	subprovider_ipf_beds	subprovider_irf_beds	skilled_nursing_beds	oth_longterm_beds	all_beds
8	ADVOCATE TRINITY HOSPITAL	2320 E 93RD ST	CHICAGO	IL	60617	COOK	(773) 967-5002	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	41.7262110	-87.5672500	0		31	17	17031	16980	Chicago-Naperville, IL-IN-WI	Central	Cook County	https://data.medicare.gov/resource/xubh-q36u/row-wz9w.j9tr_sabj	140048	650686	2019-05-30	2018-12-31	177	24				201					201
219	LIMA MEMORIAL HEALTH SYSTEM	1001 BELLEFONTAINE AVENUE	LIMA	OH	45804	ALLEN	(419) 226-3335	Acute Care Hospitals	Voluntary non-profit - Other	FALSE	40.7356020	-84.0877130	0		3	39	39003	30620	Lima-Van Wert-Celina, OH	Central	Allen County	https://data.medicare.gov/resource/xubh-q36u/row-p8qs-v8mw~whtd	360009	648963	2019-05-30	2018-12-31	123	16	16			155		17			172
290	ALLEGAN GENERAL HOSPITAL	555 LINN STREET	ALLEGAN	MI	49010	ALLEGAN	(269) 686-4101	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	42.5202590	-85.8569390	0		5	26	26005	26090	Grand Rapids-Wyoming-Muskegon, MI	Central	Allegan County	https://data.medicare.gov/resource/xubh-q36u/row-9kac~4r3i~rk7m	231328	649266	2019-05-30	2018-12-31	25					25					25
590	JOHN MUIR MEDICAL CENTER - WALNUT CREEK CAMPUS	1601 YGNACIO VALLEY RD	WALNUT CREEK	CA	94598	CONTRA COSTA	(925) 939-3000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	37.9142970	-122.0420710	0		13	6	6013	41860	San Jose-San Francisco-Oakland, CA	Outlying	Contra Costa County	https://data.medicare.gov/resource/xubh-q36u/row-uuns~9ybk_k8ca	50180	650563	2019-05-30	2018-12-31	391	55			60	506		48			554
631	SAINT BARNABAS MEDICAL CENTER	94 OLD SHORT HILLS ROAD	LIVINGSTON	NJ	7039	ESSEX	(973) 322-5000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	40.7640450	-74.3023340	0		13	34	34013	35620	New York-Newark, NY-NJ-CT-PA	Central	Essex County	https://data.medicare.gov/resource/xubh-q36u/row-wmjt.uit8.jq23	310076	649051	2019-05-30	2018-12-31	440	46	10		56	552					552
1415	METROHEALTH SYSTEM	2500 METROHEALTH DRIVE	CLEVELAND	OH	44109	CUYAHOGA	(216) 778-7089	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	41.4622390	-81.6979280	0		35	39	39035	17460	Cleveland-Akron-Canton, OH	Central	Cuyahoga County	https://data.medicare.gov/resource/xubh-q36u/row-tmz3-anq4-3mgv	360059	648966	2019-05-30	2018-12-31	400	28	16	14		528	20	67	4		619
1754	CROZER CHESTER MEDICAL CENTER	ONE MEDICAL CENTER BOULEVARD	UPLAND	PA	19013	DELAWARE	(610) 447-2000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	39.8559248	-75.3692897	1	ROOFTOP	45	42	42045	37980	Philadelphia-Reading-Camden, PA-NJ-DE-MD	Central	Delaware County	https://data.medicare.gov/resource/xubh-q36u/row-n43i.tyzh.5v4t	390180	649488	2019-05-30	2018-12-31	287	25	15	14	18	359	52	38		10	459
1897	FAYETTE COUNTY HOSPITAL	7TH AND TAYLOR	VANDALIA	IL	62471	FAYETTE	(618) 283-1231	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	38.9706410	-89.0988780	1	GEOMETRIC_CENTER	51	17	17051					https://data.medicare.gov/resource/xubh-q36u/row-3m36-npvv-f9tn	141346	648907	2019-05-30	2018-12-31	25	4				29			85		114
2054	SHRINERS HOSPITALS FOR CHILDREN-TAMPA	12502 USF PINE DR	TAMPA	FL	33612	HILLSBOROUGH	(813) 972-2250	Childrens	Voluntary non-profit - Other	FALSE	28.0603710	-82.4229680	0		57	12	12057	45300		Central	Hillsborough County	https://data.medicare.gov/resource/xubh-q36u/row-u3s8~6bbc_882j	103303	659465	2019-05-30	2018-12-31
2495	HOLY FAMILY MEMORIAL	2300 WESTERN AVE	MANITOWOC	WI	54221	MANITOWOC	(920) 320-2011	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	44.0944100	-87.6768650	0		71	55	55071	31820		Central	Manitowoc County	https://data.medicare.gov/resource/xubh-q36u/row-3t2y-xqgp.yeuz	520107	650622	2019-05-30	2018-12-31	48	10				58					58
3257	ADVENTHEALTH NORTH PINELLAS	1395 S PINELLAS AVE	TARPON SPRINGS	FL	34689	PINELLAS	(727) 942-5000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	28.1331400	-82.7585760	0		103	12	12103	45300		Central	Pinellas County	https://data.medicare.gov/resource/xubh-q36u/row-fea3-vbec-qidb	100055	649410	2019-05-30	2018-12-31	123	13				136			32		168
3331	SSM HEALTH ST MARY'S HOSPITAL - JANESVILLE	3400 EAST RACINE STREET	JANESVILLE	WI	53546	ROCK	(608) 373-8000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	42.6709820	-88.9760750	0		105	55	55105	27500	Madison-Janesville-Beloit, WI	Central	Rock County	https://data.medicare.gov/resource/xubh-q36u/row-ded9.rse4~fbnh	520208	650625	2019-05-30	2018-12-31	44	6				50					50
4059	LAKEWOOD HEALTH SYSTEM	49725 COUNTY ROAD 83	STAPLES	MN	56479	TODD	(218) 894-1515	Critical Access Hospitals	Voluntary non-profit - Other	TRUE	46.3508690	-94.7483930	0		153	27	27153					https://data.medicare.gov/resource/xubh-q36u/row-vn9e~m7ke-5ysu	241329	650720	2019-05-30	2018-12-31	22	3				25	10		100		135
4189	MAYO CLINIC HEALTH SYSTEM - ST JAMES	1101 MOULTON AND PARSONS DRIVE	ST JAMES	MN	56081	WATONWAN	(507) 375-8601	Critical Access Hospitals	Voluntary non-profit - Other	FALSE	43.9694900	-94.6215150	0		165	27	27165					https://data.medicare.gov/resource/xubh-q36u/row-iach_4kbz_5xj2	241333	649779	2019-05-30	2018-12-31	25					25					25
4552	UPSON REGIONAL MEDICAL CENTER	801 W GORDON STREET	THOMASTON	GA	30286	UPSON	(706) 647-8111	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	32.8872520	-84.3361090	0		293	13	13293	45580	Atlanta--Athens-Clarke County--Sandy Springs, GA	Central	Upson County	https://data.medicare.gov/resource/xubh-q36u/row-f57v_e6uf_3ezw	110002	651193	2019-05-30	2018-12-31	59	28				87	18				105