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

5 rows where csatitle = "Portland-Vancouver-Salem, OR-WA" and "filed_date" is on date 2019-08-30

View and edit SQL

Suggested facets: state, county_name, countyfips, statefips, statecountyfips, cbsacode, countyequivalent, icu_beds, subprovider_irf_beds, filed_date (date), fy_end_date (date)

Link 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
541 LEGACY SALMON CREEK MEDICAL CENTER 2211 NE 139TH STREET VANCOUVER WA 98686 CLARK (360) 487-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.7218230 -122.6498990 0   11 53 53011 38900 Portland-Vancouver-Salem, OR-WA Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-b4a4.2925~zmi9 500150 653361 2019-08-30 2019-03-31 128 16         166               166
1816 LEGACY SILVERTON MEDICAL CENTER 342 FAIRVIEW STREET SILVERTON OR 97381 MARION (503) 873-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.0045640 -122.7907460 0   47 41 41047 41420 Portland-Vancouver-Salem, OR-WA Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-wm4f.qf22_nr3s 380029 654480 2019-08-30 2019-03-31 25 4         29               29
1925 LEGACY GOOD SAMARITAN MEDICAL CENTER 1015 NW 22ND AVENUE, W121 PORTLAND OR 97210 MULTNOMAH (503) 413-7711 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5305510 -122.6965890 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-6zih.h2xm.wkif 380017 653351 2019-08-30 2019-03-31 136 28         164   36           200
1926 LEGACY MOUNT HOOD MEDICAL CENTER 24800 SE STARK STREET GRESHAM OR 97030 MULTNOMAH (503) 674-1122 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5190530 -122.4082790 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-cxuh~ek4n_xkr9 380025 653352 2019-08-30 2019-03-31 83 10         93               93
2373 LEGACY MERIDIAN PARK MEDICAL CENTER 19300 SW 65TH AVENUE TUALATIN OR 97062 WASHINGTON (503) 692-2182 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.3774810 -122.7439310 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-wudw-qmsk_mszn 380089 653353 2019-08-30 2019-03-31 101 16         117               117

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [hospital_data] (
   [hospital_name] TEXT,
   [address] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip_code] INTEGER,
   [county_name] TEXT,
   [phone_number] TEXT,
   [hospital_type] TEXT,
   [hospital_ownership] TEXT,
   [emergency_services] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [countyfips] INTEGER,
   [statefips] INTEGER,
   [statecountyfips] INTEGER,
   [cbsacode] TEXT,
   [csatitle] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [hosp_lookup_url] TEXT,
   [PRVDR_NUM] INTEGER,
   [RPT_REC_NUM] INTEGER,
   [filed_date] TEXT,
   [fy_end_date] TEXT,
   [acute_beds] INTEGER,
   [icu_beds] TEXT,
   [coronary_beds] TEXT,
   [burn_beds] TEXT,
   [surg_icu_beds] TEXT,
   [oth_spec_beds] TEXT,
   [subtotal_acute_beds] INTEGER,
   [subprovider_ipf_beds] TEXT,
   [subprovider_irf_beds] TEXT,
   [subprovider_oth_beds] TEXT,
   [skilled_nursing_beds] TEXT,
   [nursing_fac_beds] TEXT,
   [oth_longterm_beds] TEXT,
   [hospice_beds] TEXT,
   [all_beds] INTEGER
);