cityofchicago/covid19-cases-tests-and-deaths-by-zip-code-yhhz-zm2v

 
External

COVID-19 Cases, Tests, and Deaths by ZIP Code

  • covid-19
  • death
  • health
  • link to article present
  • public health
  • And 1 more...

COVID-19 Cases, Tests, and Deaths by ZIP Code

NOTE: Starting 2/9/2021, this dataset will be modified to include cases with positive antigen tests. This change may impact historical numbers for individual days going back to 3/1/2020.

NOTE: Starting 1/5/2021, the pattern used to populate the unique Row ID column is changing but values will still be unique. Please see http://dev.cityofchicago.org/open%20data/data%20portal/2021/01/05/covid-by-zip-rowid.html for more information.

This is the place to look for important information about how to use this dataset, so please expand this box and read on!

This is the source data for some of the metrics available at https://www.chicago.gov/city/en/sites/covid-19/home/latest-data.html.

For all datasets related to COVID-19, see https://data.cityofchicago.org/browse?limitTo=datasets&sortBy=alpha&tags=covid-19.

Only Chicago residents are included based on the home ZIP Code as provided by the medical provider. If a ZIP was missing or was not valid, it is displayed as "Unknown".

Cases with a positive molecular (PCR) or antigen test are included in this dataset. Cases are counted based on the week the test specimen was collected. For privacy reasons, until a ZIP Code reaches five cumulative cases, both the weekly and cumulative case counts will be blank. Therefore, summing the “Cases - Weekly” column is not a reliable way to determine case totals. Deaths are those that have occurred among cases based on the week of death.

For tests, each test is counted once, based on the week the test specimen was collected. Tests performed prior to 3/1/2020 are not included. Test counts include multiple tests for the same person (a change made on 10/29/2020). PCR and antigen tests reported to Chicago Department of Public Health (CDPH) through electronic lab reporting are included. Electronic lab reporting has taken time to onboard and testing availability has shifted over time, so these counts are likely an underestimate of community infection.

The “Percent Tested Positive” columns are calculated by dividing the number of positive tests by the number of total tests . Because of the data limitations for the Tests columns, such as persons being tested multiple times as a requirement for employment, these percentages may vary in either direction from the actual disease prevalence in the ZIP Code.

All data are provisional and subject to change. Information is updated as additional details are received.

To compare ZIP Codes to Chicago Community Areas, please see http://data.cmap.illinois.gov/opendata/uploads/CKAN/NONCENSUS/ADMINISTRATIVE_POLITICAL_BOUNDARIES/CCAzip.pdf. Both ZIP Codes and Community Areas are also geographic datasets on this data portal.

Data Source: Illinois National Electronic Disease Surveillance System, Cook County Medical Examiner’s Office, Illinois Vital Records, American Community Survey (2018)

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Deaths - Weeklydeaths_weeklydeaths_weeklyNumberNumber of deaths in the week.
Test Rate - Weeklytest_rate_weeklytest_rate_weeklyNumberTest rate per 100,000 population in the week. Because, as described in the dataset description, not all tests are reported, this rate is a low-end estimate. The true rate may be higher.
PopulationpopulationpopulationNumberZIP Code population.
Case Rate - Cumulativecase_rate_cumulativecase_rate_cumulativeNumberTotal case rate per 100,000 population through the week.
Cases - Cumulativecases_cumulativecases_cumulativeNumberTotal number of cases through the week. Values less than 5 are removed for privacy. A blank indicates a suppressed number from 0 to 4.
Row IDrow_idrow_idText
Cases - Weeklycases_weeklycases_weeklyNumberNumber of cases in the week. Values are removed for privacy until the cumulative total for the ZIP Code has reached 5 cases. A blank indicates a suppressed number from 0 to 4.
ZIP Codezip_codezip_codeTextHome ZIP Code of the cases and people tested.
Tests - Cumulativetests_cumulativetests_cumulativeNumberTotal number of tests through the week. Please note data limitations in the dataset description.
Week Endweek_endweek_endCalendar dateThe last date of the week.
Week Numberweek_numberweek_numberNumberA sequential count of weeks, starting at the beginning of 2020. These numbers are aligned to CDC MMWR weeks.
Percent Tested Positive - Cumulativepercent_tested_positive_cumulativepercent_tested_positive_cumulativeNumberPercentage of tests returning positive results through the week based on specimen collection date. Because, as described in the dataset description, some not-positive tests may not be received, this rate is a high-end estimate. The true rate may be lower. Values are removed for privacy until the cumulative total for the ZIP Code has reached 5 cases.
Death Rate - Cumulativedeath_rate_cumulativedeath_rate_cumulativeNumberDeath rate per 100,000 population through the week.
Case Rate - Weeklycase_rate_weeklycase_rate_weeklyNumberCase rate per 100,000 population in the week.
Death Rate - Weeklydeath_rate_weeklydeath_rate_weeklyNumberDeath rate per 100,000 population in the week.
Percent Tested Positive - Weeklypercent_tested_positive_weeklypercent_tested_positive_weeklyNumberPercentage of tests returning positive results in the week based on specimen collection date. Because, as described in the dataset description, some not-positive tests may not be received, this rate is a high-end estimate. The true rate may be lower. Values are removed for privacy until the cumulative total for the ZIP Code has reached 5 cases.
Test Rate - Cumulativetest_rate_cumulativetest_rate_cumulativeNumberTotal test rate per 100,000 population through the week. Because, as described in the dataset description, not all tests are reported, this rate is a low-end estimate. The true rate may be higher.
Tests - Weeklytests_weeklytests_weeklyNumberNumber of tests in the week. Please note data limitations in the dataset description.
Week Startweek_startweek_startCalendar dateThe first date of the week.
ZIP Code Locationzip_code_locationzip_code_locationPointA point within the ZIP Code to allow for geographic analysis. The precise point shown has no other meaning.
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumber
Census Tracts:@computed_region_bdys_3d7i:@computed_region_bdys_3d7iNumber
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumber
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumber
Boundaries - ZIP Codes:@computed_region_rpca_8um6:@computed_region_rpca_8um6Number
Deaths - Cumulativedeaths_cumulativedeaths_cumulativeNumberNumber of deaths through the week.