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 8 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 oth_spec_beds 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	all_beds
2365	NORTH CAROLINA BAPTIST HOSPITAL	MEDICAL CENTER BOULEVARD	WINSTON-SALEM	NC	27157	FORSYTH	(336) 716-2011	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	36.0896734	-80.2713468	1	GEOMETRIC_CENTER	67	37	37067	49180	Greensboro--Winston-Salem--High Point, NC	Central	Forsyth County	https://data.medicare.gov/resource/xubh-q36u/row-r4e3-jftf~8jdf	340047	661763	2019-12-02	2019-06-30	565	110	22	16			797	34	39	870
2462	UNIVERSITY MEDICAL CENTER NEW ORLEANS	2000 CANAL STREET	NEW ORLEANS	LA	70112	ORLEANS	(504) 903-3000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	29.9610920	-90.0809100	0		71	22	22071	35380	New Orleans-Metairie-Hammond, LA-MS	Central	Orleans Parish	https://data.medicare.gov/resource/xubh-q36u/row-hnr4.2w3s~mz8n	190005	655272	2019-10-04	2018-12-31	208	40		16			264	60		324
2560	SAINT FRANCIS MEMORIAL HOSPITAL	900 HYDE ST	SAN FRANCISCO	CA	94109	SAN FRANCISCO	(415) 353-6000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	37.7895610	-122.4171120	0		75	6	6075	41860	San Jose-San Francisco-Oakland, CA	Central	San Francisco County	https://data.medicare.gov/resource/xubh-q36u/row-qjay~rve8~yys3	50152	662020	2019-12-03	2019-06-30	122	18		16			156	35	20	211
3432	UNIVERSITY OF LOUISVILLE HOSPITAL	530 SOUTH JACKSON STREET	LOUISVILLE	KY	40202	JEFFERSON	(502) 562-3000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	38.2484460	-85.7450700	0		111	21	21111	31140	Louisville/Jefferson County--Elizabethtown--Madison, KY-IN	Central	Jefferson County	https://data.medicare.gov/resource/xubh-q36u/row-tgzi_ynfd~ifit	180141	655002	2019-10-01	2019-06-30	242	56	10	16			348			348
4756	MEDICAL COLLEGE OF VIRGINIA HOSPITALS	BOX 980510 1250 EAST MARSHALL STREET	RICHMOND	VA	23298	RICHMOND CITY	(804) 828-0938	Acute Care Hospitals	Government - Hospital District or Authority	TRUE	37.5400695	-77.4299163	1	ROOFTOP	760	51	51760	40060		Central	Richmond city	https://data.medicare.gov/resource/xubh-q36u/row-p6wh~7aeu~ic6q	490032	659745	2019-11-25	2019-06-30	502	28	14	16	28		715	28	38	781
192	UNIVERSITY MEDICAL CENTER	1800 W CHARLESTON BLVD	LAS VEGAS	NV	89102	CLARK	(702) 383-2000	Acute Care Hospitals	Government - Local	TRUE	36.1589410	-115.1659450	0		3	32	32003	29820	Las Vegas-Henderson, NV-AZ	Central	Clark County	https://data.medicare.gov/resource/xubh-q36u/row-crh9_6nqs_53ud	290007	662546	2019-11-29	2019-06-30	358	20	24	16	16	14	498			498
4749	SENTARA NORFOLK GENERAL HOSPITAL	600 GRESHAM DR	NORFOLK	VA	23507	NORFOLK CITY	(757) 388-3000	Acute Care Hospitals	Voluntary non-profit - Other	TRUE	36.8597280	-76.3048200	0		710	51	51710	47260	Virginia Beach-Norfolk, VA-NC	Central	Norfolk city	https://data.medicare.gov/resource/xubh-q36u/row-r5z9-wxad_tcc7	490007	650916	2019-06-03	2018-12-31	381	44	10	16		20	471	34	22	527
3381	CHI HEALTH ST ELIZABETH	555 SOUTH 70TH ST	LINCOLN	NE	68510	LANCASTER	(402) 219-7700	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	40.8076090	-96.6251790	0		109	31	31109	30700	Lincoln-Beatrice, NE	Central	Lancaster County	https://data.medicare.gov/resource/xubh-q36u/row-dwnv_q2vi_cf6s	280020	659989	2019-12-02	2019-06-30	176	16		16		27	235			235