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 5 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 "icu_beds" = :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	countyfips	statefips	statecountyfips	cbsacode	csatitle	centraloutlyingcounty	countyequivalent	hosp_lookup_url	PRVDR_NUM	RPT_REC_NUM	filed_date	fy_end_date	acute_beds	icu_beds	subtotal_acute_beds	all_beds
50	KAISER FOUNDATION HOSPITAL - SAN LEANDRO	2500 MERCED STREET	SAN LEANDRO	CA	94577	ALAMEDA	(510) 454-1000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	37.7065240	-122.1694470	1	6	6001	41860	San Jose-San Francisco-Oakland, CA	Central	Alameda County	https://data.medicare.gov/resource/xubh-q36u/row-tv6k~4ts3.26zc	50777	652239	2019-06-06	2018-12-31	166	20	206	206
1531	KAISER FOUNDATION HOSPITAL - SOUTH BAY	25825 SOUTH VERMONT AVENUE	HARBOR CITY	CA	90710	LOS ANGELES	(310) 325-5111	Acute Care Hospitals	Voluntary non-profit - Other	FALSE	33.7886230	-118.2943660	37	6	6037	31080	Los Angeles-Long Beach, CA	Central	Los Angeles County	https://data.medicare.gov/resource/xubh-q36u/row-schm-gstk~qa9r	50411	649028	2019-06-06	2018-12-31	227	20	257	257
2374	KAISER FOUNDATION HOSPITAL - WESTSIDE	2875 NW STUCKI AVE	HILLSBORO	OR	97124	WASHINGTON	(971) 310-1000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	45.5397130	-122.8756670	67	41	41067	38900	Portland-Vancouver-Salem, OR-WA	Central	Washington County	https://data.medicare.gov/resource/xubh-q36u/row-7pvy~zd9e_3y9d	380103	652265	2019-06-06	2018-12-31	102	20	122	122
2681	KAISER FOUNDATION HOSPITAL - REDWOOD CITY	1100 VETERANS BOULEVARD	REDWOOD CITY	CA	94063	SAN MATEO	(650) 299-2000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	37.4896930	-122.2246820	81	6	6081	41860	San Jose-San Francisco-Oakland, CA	Central	San Mateo County	https://data.medicare.gov/resource/xubh-q36u/row-6avk.237w~4hyr	50541	652224	2019-06-06	2018-12-31	125	20	149	149
3083	KAISER FOUNDATION HOSPITAL-SANTA ROSA	401 BICENTENNIAL WAY	SANTA ROSA	CA	95403	SONOMA	(707) 571-4000	Acute Care Hospitals	Voluntary non-profit - Private	TRUE	38.4702170	-122.7243160	97	6	6097	42220	San Jose-San Francisco-Oakland, CA	Central	Sonoma County	https://data.medicare.gov/resource/xubh-q36u/row-r3a7-uzvm_nnth	50690	652231	2019-06-06	2018-12-31	142	20	173	173