Skip to main content
King County logo

Overview

As part of the response to an outbreak of novel coronavirus (COVID-19), Public Health – Seattle & King County has prepared downloadable extracts of the data presented on the Daily COVID-19 Outbreak Summary Dashboard, which are updated weekly.

These weekly data extracts summarize the COVID-19 outbreak in King County at multiple geographic levels (ZIP code, health reporting area, and city) and time scales (daily, weekly, and overall). These data reflect reports for King County residents received through midnight of the day prior to update. Data are subject to change as information from lab reports and case investigations is gathered. In particular, data from the most recent 14-day period may be an underestimate due to reporting delays, data entry corrections, and assignment of cases across jurisdictions.

The data are provided as five Microsoft Excel workbooks (.xlsx):

  • Overall counts and rates by city, health reporting area, and zip code: Counts and rates of COVID-19 tests, positive cases, hospitalizations, and deaths by city, health reporting area, and ZIP code.
  • Total counts by date, for all King County: Counts and rates of COVID-19 tests, positive cases, hospitalizations, and deaths for all King County by day.


Overall counts and rates by city, health reporting area, and zip code

This Excel workbook includes three tabs with data on the counts and rates of COVID-19 tests, positive cases, hospitalizations and deaths across three geographic levels – city, health reporting area, and ZIP code since February 28, 2020 (the earliest date data COVID-19 data are available). The City tab includes counts and rates for each incorporated city and major unincorporated city/town in King County. The HRA tab includes counts and rates for each health reporting area in King County. Health reporting areas are neighborhoods that closely align with city boundaries and were created to aid in considering issues related to health status or health policies (more information about HRAs). The ZIP tab includes counts and rates for all ZIP codes in King County.


Data definitions and notes

  • Population: Population estimate for the city/HRA/ZIP code. 2019 King County population estimates for incorporated cities, HRAs, and ZIP codes are obtained from the Washington State Office of Financial Management (OFM). For unincorporated areas, population estimates were obtained from the 2018 American Community Survey because OFM does not provide population estimates for unincorporated areas.
    • Note: Due to data quality issues with address information for negative test results, the number of tested individuals in zip codes 98164 and 98195 are greater than the total population in these areas.
  • Tests: Count of unique King County residents who have had a COVID-19 PCR laboratory result reported to the Washington State Department of Health. If a person was tested more than once, they are counted one time.
  • Test Rate: Rate of testing (count of tests divided by total population) among residents of each geographic area. For city and HRA, the test rate is reported as tests per 100,000 residents. For ZIP code, the test rate is reported as tests per 1,000 residents.
  • Positives: Count of unique King County residents who have had a confirmed positive COVID-19 PCR laboratory result reported to the Washington State Department of Health.
  • Positive Rate: Rate of positive cases (count of positives divided by total population) among residents of each geographic area. For city and HRA, the positive rate is reported as positives per 100,000 residents. For ZIP code, the positive rate is reported as positives per 1,000 residents.
  • Hospitalizations: Count of King Country residents who have tested positive for COVID-19 and have been hospitalized. In some cases, COVID-19 may be an incidental finding and not the primary reason for hospitalization.
  • Hospitalization rate: Rate of hospitalizations (count of hospitalizations divided by total population) among residents of each geographic area. For city and HRA, the hospitalization rate is reported as hospitalizations per 100,000 residents. For ZIP code, the hospitalization rate is reported as hospitalizations per 1,000 residents.
  • Deaths: Count of King County residents who have died due to COVID-19. Confirmed deaths include decedents who tested positive and had COVID-19 infection listed on their death certificate as either a contributing cause or other significant condition.
  • Death rate: Rate of deaths (count of deaths divided by total population) among residents of each geographic area. For city and HRA, the death rate is reported as deaths per 100,000 residents. For ZIP code, the death rate is reported as deaths per 1,000 residents.

Total counts by date, for all King County

This Excel workbook includes four tabs containing daily counts and rates of tests, positives, hospitalizations, and deaths in King County.

Due to reporting delays, data corrections, and assignment of cases across jurisdictions, data from the most recent 14-day period may be underestimated and subject to change.


Data definitions and notes

  • Rates: Test rate, positive rate, hospitalization rate, and death rate are defined as the count of each measure divided by the total population of King County. Rates are presented as counts per 100,000 residents.
  • Dates: Different date fields are used to provide daily counts of tests, positives, hospitalizations, and deaths.
    • Result date is used to aggregate daily counts and rates of all PCR laboratory tests and positive PCR laboratory tests. This date reflects when the COVID-19 laboratory result was reported to the Washington State Department of Health.
    • Admission date is used to aggregate daily counts and rates of hospitalizations. This date reflects when a patient was admitted to the hospital.
    • Death date is used to aggregate daily counts and rates of deaths.
    • Laboratory date, admission date, and death date may be missing for some patients due to data quality issues. In each dataset, the count of records missing a date field are included. In these cases, the date is left blank (i.e., date = " ").