Skip to main content

Download the data on COVID-19

Overview

As part of the response to an outbreak of novel coronavirus (COVID-19), Public Health – Seattle & King County has prepared downloadable COVID-19 data, which are updated monthly.

These monthly data extracts summarize the COVID-19 epidemic in King County in multiple demographic and geographic groups as well as several time scales (daily and overall).

These data reflect reports for King County residents received through midnight of the day prior to update. 

The following data are available for download in Microsoft Excel format. Be sure to press refresh or reload on your web browser to ensure you're accessing the latest versions:

Outcomes datasets

Vaccination datasets


Datasets

Outcome datasets

The data are provided weekly as Microsoft Excel files. 

Each Excel workbook includes data on the estimated 2022 population for each geographic level, counts of total COVID-19 positive cases, hospitalizations, and deaths. These data are presented in the following tabs:

  • Overall counts of total COVID-19 positive cases, hospitalizations, and deaths 
  • Overall counts of total COVID-19 positive cases, hospitalizations, and deaths by age
  • Overall counts of total COVID-19 positive cases, hospitalizations, and deaths by race/ethnicity 
  • Overall counts of total COVID-19 positive cases, hospitalizations, and deaths by sex
  • Overall counts of total COVID-19 positive cases, hospitalizations, and deaths by geography (the 4 King County regions: Central, South, East, and Seattle)
  • Daily counts of total COVID-19 positive cases, hospitalizations, and deaths

Vaccination coverage datasets

  • Overall vaccination rates: This Excel workbook includes four tabs containing overall vaccination doses by age group, race/ethnicity group, and geographic region, as well as vaccination doses by day.  Vaccination doses are described by general categories as CDC recommendations have evolved over time (i.e., primary series doses, 2022-2023 bivalent vaccine doses, 2023-2024 updated vaccine doses). 

Shared data definitions and notes

The following variables are used across many of the downloadable datasets and public dashboards.

  • Population: Population is estimated for the specified geographic level. 2022 King County population estimates 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. 
  • Positive Cases: Count of a positive COVID-19 antigen test or a confirmed positive PCR laboratory result reported to the Washington State Department of Health by a King County resident.
  • 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.
  • Deaths: Count of King County residents who have died due to COVID-19. Prior to January 1, 2023, COVID-19 deaths include decedents with a positive COVID-19 PCR or antigen test result, and had a cause of death that was confirmed or suspected to have been related to COVID-19. COVID-19 deaths that occurred on or after January 1, 2023 require COVID-19 to be listed on the death certificate as either a contributing cause or other significant conditions, but no longer require a positive PCR or antigen test result. 
  • 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 the following categories: 0-4, 5-17,  18-49, 50-64, and 65+.
    • 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"

Vaccination-related data definitions and notes

Vaccination status is defined by CDC and determined based on the doses entered in the Washington State Immunization Information System (WAIIS). Vaccination status definitions have changed over time as recommendations have evolved. Learn more about staying up to date with COVID-19 vaccines. PHSKC data products use the CDC guidance released in October 2023, and the key vaccination status variables in the downloadable vaccination rates dataset and on our public dashboards are provided here: 

  • Completed original series: Count of King County residents who have received all doses of the original COVID-19 vaccine series. The original vaccine was designed to target the original virus that causes COVID-19. The original series, previously called the primary series, ranged from 1 to 3 doses depending on the vaccine manufacturer and person’s age. This count includes everyone who has completed at least the original vaccine series, regardless of whether they’ve received additional doses as boosters.
  • Received at least one original booster: Count of King County residents who have completed the original series and received at least one booster dose of the original vaccine formulation. The original boosters were monovalent formulations which targeted the original virus that causes COVID-19. As of August 31, 2022, they are no longer recommended, in favor of updated formulations.
  • Received 2022-2023 bivalent vaccine: Count of King County residents who have completed the original series and received at least one 2022-2023 bivalent vaccine dose. The doses are bivalent formulations which target the Omicron variant in addition to the original strain of the virus that causes COVID-19.  As of September 2023, the 2022-2023 bivalent vaccine is no longer recommended, in favor of the 2023-2024 updated COVID-19 vaccine.
  • Received 2023-2024 updated vaccine: Count of King County residents who have received at least one dose of the 2023-2024 updated COVID-19 vaccine. These are doses of the updated 2023 formula (which targets the XBB lineage of the Omicron variant).
A note on percentage estimates:  

The vaccination coverage percentages, such as the percent of people who have completed primary series and the percent of people who are up to date, use the OFM population estimates described above as the denominator. This may lead to imprecise numbers for some groups with small populations and/or very high levels of vaccination coverage (capped at 95%).

expand_less