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
313 KAISER SUNNYSIDE MEDICAL CENTER 10180 SE SUNNYSIDE ROAD CLACKAMAS OR 97015 CLACKAMAS (503) 652-2880 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.4334620 -122.5585250 0   5 41 41005 38900 Portland-Vancouver-Salem, OR-WA Central Clackamas County https://data.medicare.gov/resource/xubh-q36u/row-akhw.kvgz.wg78 380091 649818 2019-06-06 2018-12-31 242 40         302               302
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 0   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