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 2 rows (hide)

Query parameters

rowidhospital_nameaddresscitystatezip_codecounty_namephone_numberhospital_typehospital_ownershipemergency_serviceslatlnggeocode_flaggeocode_accuracycountyfipsstatefipsstatecountyfipscbsacodecsatitlecentraloutlyingcountycountyequivalenthosp_lookup_urlPRVDR_NUMRPT_REC_NUMfiled_datefy_end_dateacute_bedsicu_bedscoronary_bedsburn_bedssurg_icu_bedsoth_spec_bedssubtotal_acute_bedssubprovider_ipf_bedssubprovider_irf_bedssubprovider_oth_bedsskilled_nursing_bedsnursing_fac_bedsoth_longterm_bedshospice_bedsall_beds
1529 KAISER FOUNDATION HOSPITAL - DOWNEY 9333 IMPERIAL HIGHWAY DOWNEY CA 90242 LOS ANGELES (562) 461-6007 Acute Care Hospitals Voluntary non-profit - Other FALSE 33.9171010 -118.1289980 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-sg5x~3x2a.esq9 50139 652218 2019-06-06 2018-12-31 265 38         352               352
2782 KAISER FOUNDATION HOSPITAL-SANTA CLARA 700 LAWRENCE EXPRESSWAY SANTA CLARA CA 95051 SANTA CLARA (408) 236-6400 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3354560 -121.9957670 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-zbup-cmjk.by57 50071 649021 2019-06-06 2018-12-31 263 38         327               327