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 COVID-19 Summary Dashboard, which are updated weekly.

These weekly data extracts summarize the COVID-19 epidemic in King County at multiple geographic levels (ZIP code, health reporting area, city, and census tract) and time scales (daily, weekly, and overall). These data reflect reports for King County residents received through midnight of the day prior to update. To protect individual privacy, demographic categories where the count of deaths, hospitalizations, or cases is fewer than five are suppressed and replaced with zeroes.

Datasets

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 weekly as Microsoft Excel files on the Daily COVID-19 outbreak summary page as outlined below:

  • Overall counts and rates by geographic levels
  • This Excel workbook includes four tabs with data on the counts and rates of people tested for COVID-19, total COVID-19 test results, positive cases, hospitalizations and deaths across four geographic levels – city, health reporting area, ZIP code, and census tract since February 28, 2020 (the earliest date COVID-19 data are available).

  • Biweekly counts and rates by geographic levels
  • This Excel workbook includes four tabs containing biweekly counts and rates of people tested, all test results, positives, hospitalizations, and deaths in King County. Each tab corresponds to a geographic level: City, health reporting area, ZIP, and Census Tract. The Census Tract tab does not include hospitalizations and deaths to protect individual privacy and confidentiality.

  • Daily counts and rates for all of King County
  • This Excel workbook includes five tabs containing daily counts and rates of people tested for COVID-19, total COVID-19 test results, positive cases, hospitalizations, and deaths in King County.

  • Daily counts by city
  • This Excel workbook includes five tabs containing daily counts and rates of people tested, all test results, positives, hospitalizations, and deaths in King County. Data is aggregated to the City geography, which includes each incorporated city and major unincorporated city/town in King County.

  • Daily counts by ZIP
  • This Excel workbook includes five tabs containing daily counts and rates of people tested, all test results, positives, hospitalizations, and deaths in King County. Data are aggregated to the ZIP code geography and includes each ZIP code in King County.

  • Overall counts by city and demographic characteristics
  • This Excel workbook includes counts for five measures: people tested for COVID-19, total COVID-19 test results, positive cases, hospitalizations, and deaths due to COVID-19 illness by city and across three demographic categories: age group, sex at birth, and race/ethnicity. To protect individual privacy, demographic categories where the count of deaths, hospitalizations, or cases is fewer than 10 are suppressed and replaced with zeroes. In addition, in cities where the count of deaths, hospitalizations, or cases (after suppression) is only among one demographic group, counts are suppressed for all demographic groups. Finally, a small, random amount of noise has been added to demographic categories where the count of deaths, hospitalizations, or cases is greater than 10.

  • Weekly counts for all of King County by demographic characteristics
  • This Excel workbook includes weekly counts for five measures: people tested for COVID-19, total COVID-19 test results, positive cases, hospitalizations, and deaths in King County. There are three tabs, where each tab presents the data across one of three demographic categories: age group, sex at birth, and race/ethnicity. To protect individual privacy, demographic categories where the count of deaths, hospitalizations, or cases is fewer than 10 are suppressed and replaced with zeroes. In addition, in weeks where the count of deaths, hospitalizations, or cases (after suppression) is only available among one age, race/ethnicity, or sex at birth category, counts are suppressed for all demographic groups. Finally, a small, random amount of noise has been added to demographic categories where the count of deaths, hospitalizations, or cases is greater than 10.

Datasets of outcomes by vaccination status

The data are provided weekly as Microsoft Excel files on the COVID-19 outcomes by vaccination status page as outlined below:

  • Counts by vaccination status
  • This Excel workbook includes three tabs containing daily counts and rates of positives, hospitalizations, and deaths in King County by vaccination status. Vaccination status includes not fully vaccinated, fully vaccinated, and boosted. Data are aggregated across three time periods: before the Omicron surge (1/17/2021 to 12/1/2021), since the Omicron surge (since 12/1/2021), and the past 30 days.

  • Daily counts by vaccination status
  • This Excel workbook includes three tabs containing daily counts and rates of positives, hospitalizations, and deaths in King County by vaccination status. Vaccination status includes not fully vaccinated, fully vaccinated, and boosted.

  • Counts by demographics and vaccination status
  • This Excel workbook includes three tabs containing daily counts and rates of positives, hospitalizations, and deaths in King County by vaccination status. Vaccination status includes not fully vaccinated, fully vaccinated, and boosted. Data are aggregated across three demographic categories: age group, race/ethnicity, and sex at birth.

  • Counts by region and vaccination status
  • This Excel workbook includes three tabs containing daily counts and rates of positives, hospitalizations, and deaths in King County by vaccination status. Vaccination status includes not fully vaccinated, fully vaccinated, and boosted. Data are aggregated across 10 regions.

Data definitions and notes

  • Population: Population estimate for the specified geographic level. 2019 King County population estimates for incorporated cities, health reporting areas, ZIP codes, and census tracts 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 and census tract 53033008100 are greater than the total population in these areas.
    • On June 15, 2021, population estimates were updated to use 2020 King County population estimates (and 2019 estimates for unincorporated areas). Previous versions of these datasets used 2019 King County population estimates because 2020 estimates. This update resulted in changes in the rates presented in these datasets.

  • People Tested: 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.

  • People Test Rate: Rate of testing (count of people tested divided by total population) among residents of each geographic area. For city and health reporting area, the test rate is reported as tests per 100,000 residents. For ZIP code and census tract, the test rate is reported as tests per 1,000 residents.

  • All Test Results: Count of all COVID-19 PCR laboratory results reported to the Washington State Department of Health. If a person was tested multiple times, all their test results are counted.

  • All Test Results Rate: Rate of testing (count of all test results divided by total population) among residents of each geographic area. For city and health reporting area, the test rate is reported as tests per 100,000 residents. For ZIP code and census tract, the test rate is reported as tests per 1,000 residents.

  • Positives: Count of unique King County residents who have had a positive COVID-19 PCR or antigen 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 health reporting area, the positive rate is reported as positives per 100,000 residents. For ZIP code and census tract, the positive rate is reported as positives per 1,000 residents.

  • Confirmed Cases: 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.

  • Confirmed Rate: Rate of confirmed cases (count of positives divided by total population) among residents of each geographic area. For city and health reporting area, the positive rate is reported as positives per 100,000 residents. For ZIP code and census tract, the positive rate is reported as positives per 1,000 residents.

  • Probable Cases: Count of unique King County residents who have had a confirmed positive COVID-19 antigen test, but not a PCR laboratory result reported to the Washington State Department of Health.

  • Probable Case Rate: Rate of confirmed cases (count of positives divided by total population) among residents of each geographic area. For city and health reporting area, the positive rate is reported as positives per 100,000 residents. For ZIP code and census tract, 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. Hospital records are reviewed by Public Health-Seattle & King County investigators when there is a question about the primary reason for a hospitalization. Those that are deemed incidental are excluded from the official count of COVID-19 hospitalizations.

  • Hospitalization Rate: Rate of hospitalizations (count of hospitalizations divided by total population) among residents of each geographic area. For city and health reporting area, the hospitalization rate is reported as hospitalizations per 100,000 residents. For ZIP code and census tract, 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 health reporting area, the death rate is reported as deaths per 100,000 residents. For ZIP code and census tract, the death rate is reported as deaths per 1,000 residents.

  • Geographic levels:
    • City: Includes incorporated cities and major unincorporated cities/towns in King County.
    • Health reporting area (HRA): 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 health reporting areas are available here).
    • ZIP code: ZIP codes are defined by the United States Postal Service.
    • Census tract: Census tracts are defined by the United States Census Bureau.

  • 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 and biweekly 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.
    • o 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 = " ").

  • Demographic characteristics: Demographic information is collected by interviewing cases, medical notes, test results, or by matching with other data sources. Large numbers of cases are missing demographic details, particularly race/ethnicity. Small numbers and missing data should be considered when interpreting the data, as some age groups and race/ethnicity groups have very small counts of outcomes.
    • Age groups: Age is grouped into 10-year categories (from 0-9 years of age to 80+ years of age).
    • Sex at birth: Sex at birth is categorized as female, male, and unknown.
    • Race/ethnicity: Race/ethnicity categories are defined as follows:
      • For individuals of Hispanic/Latinx ethnicity, race/ethnicity is categorized as “Hispanic”
      • For individuals of non-Hispanic/Latinx ethnicity, race/ethnicity is categorized based on the race they selected
      • For individuals of non-Hispanic/Latinx ethnicity who specified multiple race categories, race/ethnicity is categorized as “multi-racial”

Data of outcomes by vaccination status definitions and notes

  • Population estimates: populations of vaccinated and not fully vaccinated individuals are derived from 2020 King County population estimates. These estimates may be imprecise when looking at small numbers, especially unvaccinated individuals in some demographic or geographic groups. These measurement errors are corrected using a 5% continuity correction. More information can be found in the technical appendix.
    • Population boosted/fully vaccinated/not fully vaccinated (in outcomes_daily): these populations are cumulative totals.
    • Approximate population percent (in outcomes_geo, outcomes_demo, and outcomes_overall): percentages are calculated using person-time at risk. Individuals may occupy different vaccination categories over time (I.e., an individual may be unvaccinated and then become fully vaccinated), therefore we calculate person-time, which is the number of days a person was considered boosted, fully vaccinated, or not fully vaccinated.

  • Vaccination status:
    • Not fully vaccinated: individuals who have not yet received any vaccine doses of any COVID-19 vaccine, individuals who have started their COVID-19 vaccine series, and individuals who have completed their COVID-19 vaccine series within the past 14 days.
    • Fully vaccinated: individuals who have received 2 doses of a mRNA or one dose of the Janssen COVID-19 vaccine and have had at least 14 days to establish protection and who have not yet had their booster dose (or have had their booster dose but have not had 14 days to establish protection). Fully vaccinated cases include individuals who have tested positive for COVID-19 (either a PCR or antigen test) at least 14 days after they completed their vaccination series.
    • Boosted: individuals who received a third dose following their full mRNA COVID-19 series or a second dose following their Janssen COVID-19 vaccine and have had at least 14 days to establish protection. Boosted cases include individuals who have tested positive for COVID-19 (either a PCR test or antigen test) at least 14 days after they received a booster dose.

  • Average positives/hospitalization/death rate (in outcomes_daily): Rate of each outcome (count of each outcome divided by total population) per 100,000 residents averaged over the most recent 7-day period. Cases are counted on the date of an individual’s positive COVID-19 test; hospitalizations are counted on the date an individual’s hospital admission; deaths are counted on the date of death. Rates are not age standardized.

  • Average adjusted positives/hospitalization/death Rate (in outcomes_daily): Rate of each outcome (count of each outcome divided by total population) averaged over the most recent 7-day period. Cases are counted on the date of an individual’s positive COVID-19 test; hospitalizations are counted on the date an individual’s hospital admission; death are counted on the date of death. Rates are age standardized.

  • Adjusted positives/hospitalization/death Rate (in outcomes_geo, outcomes_demo, and outcomes_overall): Rate of each outcome (count of each outcome divided by total population). Cases are counted on the date of an individual’s positive COVID-19 test; hospitalizations are counted on the date an individual’s hospital admission; death are counted on the date of death. Rates are adjusted for age and time; for more information on adjustments, see the technical appendix.

  • Positives/Hospitalization/Death total: total outcomes for all vaccination statuses.

  • RR: these variables are relative risks.