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, 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 zeros.

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 Microsoft Excel workbooks (.xlsx) 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 data 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 is 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 five are suppressed and replaced with zeros.

  • 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 five are suppressed and replaced with zeros.

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.

  • 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 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 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.

  • 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.
    • 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”