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 "burn_beds" = :p0 order by zip_code 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	surg_icu_beds	oth_spec_beds	subtotal_acute_beds	subprovider_ipf_beds	subprovider_irf_beds	skilled_nursing_beds	nursing_fac_beds	all_beds
2799	STATEN ISLAND UNIVERSITY HOSPITAL	475 SEAVIEW AVENUE	STATEN ISLAND	NY	10305	RICHMOND	(418) 226-9761	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	40.5840820	-74.0870130	0		85	36	36085	35620	New York-Newark, NY-NJ-CT-PA	Central	Richmond County	https://data.medicare.gov/resource/xubh-q36u/row-z9rb.hyek_grbe	330160	650195	2019-06-18	2018-12-31	426	44	38	10		11	543	35	49			627
3604	WESTCHESTER MEDICAL CENTER	100 WOODS RD	VALHALLA	NY	10595	WESTCHESTER	(914) 493-7000	Acute Care Hospitals	Government - Hospital District or Authority	TRUE	41.0876800	-73.8038970	0		119	36	36119	35620	New York-Newark, NY-NJ-CT-PA	Central	Westchester County	https://data.medicare.gov/resource/xubh-q36u/row-xkhz-jkc9_u59t	330234	650318	2019-06-21	2018-12-31	550	66	15	10		49	708	141	36			885
2156	NASSAU UNIVERSITY MEDICAL CENTER	2201 HEMPSTEAD TURNPIKE	EAST MEADOW	NY	11554	NASSAU	(516) 572-0123	Acute Care Hospitals	Government - Local	TRUE	40.7252980	-73.5544130	0		59	36	36059	35620	New York-Newark, NY-NJ-CT-PA	Central	Nassau County	https://data.medicare.gov/resource/xubh-q36u/row-jkr2_ys4r-jt6b	330027	650855	2019-06-26	2018-12-31	295	33		10		28	372	133	25			530
3221	TEMPLE UNIVERSITY HOSPITAL	3401 NORTH BROAD STREET	PHILADELPHIA	PA	19140	PHILADELPHIA	(215) 707-2000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	40.0046670	-75.1522000	0		101	42	42101	37980	Philadelphia-Reading-Camden, PA-NJ-DE-MD	Central	Philadelphia County	https://data.medicare.gov/resource/xubh-q36u/row-zzyj_ydxk_mei6	390027	661088	2019-12-02	2019-06-30	473	43	18	10			598	118	16			732
4713	JOHNS HOPKINS BAYVIEW MEDICAL CENTER	4940 EASTERN AVENUE	BALTIMORE	MD	21224	BALTIMORE CITY	(410) 550-0123	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.2872850	-76.5521340	0		510	24	24510	12580	Washington-Baltimore-Arlington, DC-MD-VA-WV-PA	Central	Baltimore city	https://data.medicare.gov/resource/xubh-q36u/row-tsuu-47er~ackm	210029	661192	2019-11-26	2019-06-30	332	22	12	10	10	25	411					411
1730	TANNER MEDICAL CENTER - CARROLLTON	705 DIXIE STREET	CARROLLTON	GA	30117	CARROLL	(770) 836-9580	Acute Care Hospitals	Government - Hospital District or Authority	TRUE	33.5705550	-85.0724640	0		45	13	13045	12060	Atlanta--Athens-Clarke County--Sandy Springs, GA	Outlying	Carroll County	https://data.medicare.gov/resource/xubh-q36u/row-7yah~3pv6~c65g	110011	660365	2019-12-03	2019-06-30	135	12		10			157					157
419	HOLMES REGIONAL MEDICAL CENTER	1350 S HICKORY ST	MELBOURNE	FL	32901	BREVARD	(321) 434-7000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	28.0869100	-80.6135230	0		9	12	12009	37340		Central	Brevard County	https://data.medicare.gov/resource/xubh-q36u/row-vfyd.d5k5.qxkg	100019	646066	2019-02-28	2018-09-30	450	54		10			514					514
2215	UNIVERSITY OF CINCINNATI MEDICAL CENTER, LLC	234 GOODMAN STREET	CINCINNATI	OH	45219	HAMILTON	(513) 584-1000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.1367280	-84.5025620	0		61	39	39061	17140	Cincinnati-Wilmington-Maysville, OH-KY-IN	Central	Hamilton County	https://data.medicare.gov/resource/xubh-q36u/row-rc7b_nuaq-8nt3	360003	661583	2019-12-03	2019-06-30	366			10	34		515	40				555
3482	MIAMI VALLEY HOSPITAL	ONE WYOMING STREET	DAYTON	OH	45409	MONTGOMERY	(937) 208-3023	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.7454533	-84.1856087	1	ROOFTOP	113	39	39113	19380	Dayton-Springfield-Sidney, OH	Central	Montgomery County	https://data.medicare.gov/resource/xubh-q36u/row-as44_ad35~hctr	360051	649310	2019-05-31	2018-12-31	574	103		10			753	32	40			825
3098	INDIANA UNIVERSITY HEALTH	1701 N SENATE BLVD	INDIANAPOLIS	IN	46202	MARION	(317) 962-5900	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.7905710	-86.1652590	0		97	18	18097	26900	Indianapolis-Carmel-Muncie, IN	Central	Marion County	https://data.medicare.gov/resource/xubh-q36u/row-eimw.p9j2.8uyj	150056	649207	2019-05-31	2018-12-31	914	66	64	10			1226	26	10			1262
4138	UNIVERSITY OF MICHIGAN HEALTH SYSTEM	1500 E MEDICAL CENTER DRIVE, SPC 5474	ANN ARBOR	MI	48109	WASHTENAW	(734) 764-1505	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	42.2853400	-83.7290400	0		161	26	26161	11460	Detroit-Warren-Ann Arbor, MI	Central	Washtenaw County	https://data.medicare.gov/resource/xubh-q36u/row-4jqn-utws_26e7	230046	659809	2019-11-26	2019-06-30	718	20	10	10			931	43	32			1006
1234	LOYOLA UNIVERSITY MEDICAL CENTER	2160 S 1ST AVENUE	MAYWOOD	IL	60153	COOK	(708) 216-9000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	41.8587320	-87.8332100	0		31	17	17031	16980	Chicago-Naperville, IL-IN-WI	Central	Cook County	https://data.medicare.gov/resource/xubh-q36u/row-tjbj~st8y~aaxx	140276	662522	2019-12-23	2019-06-30	345	76		10		50	515					515
4199	MEMORIAL MEDICAL CENTER	701 N FIRST ST	SPRINGFIELD	IL	62702	SANGAMON	(217) 788-3000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	39.8087780	-89.6545860	0		167	17	17167	44100	Springfield-Jacksonville-Lincoln, IL	Central	Sangamon County	https://data.medicare.gov/resource/xubh-q36u/row-pnue~2mxb_uc9u	140148	645540	2019-03-04	2018-09-30	352	38		10			400	36	30			466
741	OCHSNER LSU HEALTH SHREVEPORT	1541 KINGS HIGHWAY	SHREVEPORT	LA	71103	CADDO	(318) 675-5000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	32.4817910	-93.7615900	0		17	22	22017	43340		Central	Caddo Parish	https://data.medicare.gov/resource/xubh-q36u/row-mkra_a29f.kchy	190098	660383	2019-12-03	2019-06-30	285			10			369	37				406
3583	ARKANSAS CHILDREN'S HOSPITAL	1 CHILDREN'S WAY, SLOT 301	LITTLE ROCK	AR	72202	PULASKI	(501) 364-1100	Childrens	Voluntary non-profit - Private	TRUE	34.7428220	-92.2920060	0		119	5	5119	30780	Little Rock-North Little Rock, AR	Central	Pulaski County	https://data.medicare.gov/resource/xubh-q36u/row-p66z~xhi7.pxk4	43300	660352	2019-12-03	2019-06-30	153	26	30	10		104	336					336
3673	NORTH COLORADO MEDICAL CENTER	1801 - 16TH ST	GREELEY	CO	80631	WELD	(970) 810-4121	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	40.4138340	-104.7094290	0		123	8	8123	24540	Denver-Aurora, CO	Central	Weld County	https://data.medicare.gov/resource/xubh-q36u/row-b7wk~gizs_ie2f	60001	649545	2019-06-03	2018-12-31	199	16		10			225					225
815	COMMUNITY REGIONAL MEDICAL CENTER	2823 FRESNO STREET	FRESNO	CA	93721	FRESNO	(559) 459-6000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	36.7425830	-119.7830230	0		19	6	6019	23420	Fresno-Madera, CA	Central	Fresno County	https://data.medicare.gov/resource/xubh-q36u/row-xy9w-yfis_5dn2	50060	662313	2019-01-28	2018-08-31	577	78		10		84	749		32	58	48	887