cityofchicago/covid19-daily-rolling-average-case-death-and-e68t-c7fv

 
External

COVID-19 Daily Rolling Average Case, Death, and Hospitalization Rates

  • covid-19
  • death
  • ethnicity
  • gender
  • health
  • And 4 more...

COVID-19 Daily Rolling Average Case, Death, and Hospitalization Rates

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

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.

This dataset is a companion to the COVID-19 Daily Cases and Deaths dataset (https://data.cityofchicago.org/d/naz8-j4nc). The major difference in this dataset is that the case, death, and hospitalization corresponding rates per 100,000 population are not those for the single date indicated. They are rolling averages for the seven-day period ending on that date. This rolling average is used to account for fluctuations that may occur in the data, such as fewer cases being reported on weekends, and small numbers. The intent is to give a more representative view of the ongoing COVID-19 experience, less affected by what is essentially noise in the data.

All rates are per 100,000 population in the indicated group, or Chicago, as a whole, for “Total” columns.

Only Chicago residents are included based on the home address as provided by the medical provider.

Cases with a positive molecular (PCR) or antigen test are included in this dataset. Cases are counted based on the date the test specimen was collected. Deaths among cases are aggregated by day of death. Hospitalizations are reported by date of first hospital admission. Demographic data are based on what is reported by medical providers or collected by CDPH during follow-up investigation.

Denominators are from the U.S. Census Bureau American Community Survey 1-year estimate for 2018 and can be seen in the Citywide, 2018 row of the Chicago Population Counts dataset (https://data.cityofchicago.org/d/85cm-7uqa).

All data are provisional and subject to change. Information is updated as additional details are received and it is, in fact, very common for recent dates to be incomplete and to be updated as time goes on. At any given time, this dataset reflects cases and deaths currently known to CDPH.

Numbers in this dataset may differ from other public sources due to definitions of COVID-19-related cases and deaths, sources used, how cases and deaths are associated to a specific date, and similar factors.

Data Source: Illinois National Electronic Disease Surveillance System, Cook County Medical Examiner’s Office, U.S. Census Bureau American Community Survey

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Deaths - Maledeaths_maledeaths_maleNumber
Deaths - Age 80+deaths_age_80deaths_age_80Number
Deaths - Age 70-79deaths_age_70_79deaths_age_70_79Number
Deaths Rate - Asian Non-Latinxdeaths_rate_asian_non_latinxdeaths_rate_asian_non_latinxNumber
Hospitalizations Rate - Age 0-17hospitalizations_rate_age_0_17hospitalizations_rate_age_0_17Number
Hospitalizations Rate - Age 80+hospitalizationsrate_age_80hospitalizationsrate_age_80Number
Hospitalizations Rate - Asian Non-Latinxhospitalizations_rate_asian_non_latinxhospitalizations_rate_asian_non_latinxNumber
Hospitalizations Rate - White Non-Latinxhospitalizations_rate_white_non_latinxhospitalizations_rate_white_non_latinxNumber
Cases - Age 50-59cases_age_50_59cases_age_50_59Number
Cases - Age 80+cases_age_80cases_age_80Number
Cases - Other Race Non-Latinxcases_other_race_non_latinxcases_other_race_non_latinxNumber
Deaths - Age 50-59deaths_age_50_59deaths_age_50_59Number
Cases - Latinxcases_latinxcases_latinxNumber
Cases - Malecases_malecases_maleNumber
Cases - Age 70-79cases_age_70_79cases_age_70_79Number
Cases - Age 60-69cases_age_60_69cases_age_60_69Number
Cases - Age 0-17cases_age_0_17cases_age_0_17Number
Hospitalizations - Totalhospitalizations_totalhospitalizations_totalNumber
Cases - Totalcases_totalcases_totalNumber
Deaths Rate - Age 18-29deaths_rate_age_18_29deaths_rate_age_18_29Number
Cases Rate - Age 30-39cases_rate_age_30_39cases_rate_age_30_39Number
Hospitalizations - Age 30-39hospitalizations_age_30_39hospitalizations_age_30_39Number
Cases Rate - Age 40-49cases_rate_age_40_49cases_rate_age_40_49Number
Cases Rate - Age 80+cases_rate_age_80cases_rate_age_80Number
Hospitalizations Rate - Age 50-59hospitalizations_rate_age_50_59hospitalizations_rate_age_50_59Number
Deaths Rate - Age 40-49deaths_rate_age_40_49deaths_rate_age_40_49Number
Hospitalizations - Age 60-69hospitalizations_age_60_69hospitalizations_age_60_69Number
Deaths - Femaledeaths_femaledeaths_femaleNumber
Deaths - Age 0-17deaths_age_0_17deaths_age_0_17Number
Hospitalizations Rate - Other Race Non-Latinxhospitalizations_rate_other_race_non_latinxhospitalizations_rate_other_race_non_latinxNumber
Deaths Rate - White Non-Latinxdeaths_rate_white_non_latinxdeaths_rate_white_non_latinxNumber
Hospitalizations - Age 50-59hospitalizations_age_50_59hospitalizations_age_50_59Number
Cases Rate - Age 0-17cases_rate_age_0_17cases_rate_age_0_17Number
Deaths - Totaldeaths_totaldeaths_totalNumber
Hospitalizations Rate - Age 30-39hospitalizations_rate_age_30_39hospitalizations_rate_age_30_39Number
Deaths Rate - Age 30-39deaths_rate_age_30_39deaths_rate_age_30_39Number
Cases Rate - Latinxcases_rate_latinxcases_rate_latinxNumber
Deaths Rate - Other Race Non-Latinxdeaths_rate_other_race_nondeaths_rate_other_race_nonNumber
Deaths Rate - Age 50-59deaths_rate_age_50_59deaths_rate_age_50_59Number
Deaths Rate - Age 0-17deaths_rate_age_0_17deaths_rate_age_0_17Number
Cases - Age 18-29cases_age_18_29cases_age_18_29Number
Deaths Rate - Totaldeaths_rate_totaldeaths_rate_totalNumber
Hospitalizations - Age 0-17hospitalizations_age_0_17hospitalizations_age_0_17Number
Cases Rate - Age 50-59cases_rate_age_50_59cases_rate_age_50_59Number
Hospitalizations Rate - Age 60-69hospitalizations_rate_age_60_69hospitalizations_rate_age_60_69Number
Cases Rate - Age 18-29cases_rate_age_18_29cases_rate_age_18_29Number
Hospitalizations - White Non-Latinxhospitalizations_white_non_latinxhospitalizations_white_non_latinxNumber
Hospitalizations Rate - Latinxhospitalizations_rate_latinxhospitalizations_rate_latinxNumber
Hospitalizations Rate - Age 40-49hospitalizations_rate_age_40_49hospitalizations_rate_age_40_49Number
Hospitalizations Rate - Age 18-29hospitalizations_rate_age_18_29hospitalizations_rate_age_18_29Number
Hospitalizations - Other Race Non-Latinxhospitalizations_other_race_non_latinxhospitalizations_other_race_non_latinxNumber
Hospitalizations - Asian Non-Latinxhospitalizations_asian_non_latinxhospitalizations_asian_non_latinxNumber
Deaths - Age 18-29deaths_age_18_29deaths_age_18_29Number
Deaths - Other Race Non-Latinxdeaths_other_race_non_latinxdeaths_other_race_non_latinxNumber
DatedatedateCalendar dateThe end date of the seven-day period averaged.
Cases Rate - Asian Non-Latinxcases_rate_asian_non_latinxcases_rate_asian_non_latinxNumber
Hospitalizations Rate - Malehospitalizations_rate_malehospitalizations_rate_maleNumber
Hospitalizations Rate - Black Non-Latinxhospitalizations_rate_black_non_latinxhospitalizations_rate_black_non_latinxNumber
Cases - Black Non-Latinxcases_black_non_latinxcases_black_non_latinxNumber
Deaths - Age 30-39deaths_age_30_39deaths_age_30_39Number
Hospitalizations - Black Non-Latinxhospitalizations_black_non_latinxhospitalizations_black_non_latinxNumber
Hospitalizations - Malehospitalizations_malehospitalizations_maleNumber
Hospitalizations - Femalehospitalizations_femalehospitalizations_femaleNumber
Hospitalizations - Age 80+hospitalizationsage_80hospitalizationsage_80Number
Deaths Rate - Maledeaths_rate_maledeaths_rate_maleNumber
Deaths - Black Non-Latinxdeaths_black_non_latinxdeaths_black_non_latinxNumber
Deaths - Asian Non-Latinxdeaths_asian_non_latinxdeaths_asian_non_latinxNumber
Deaths - Age 60-69deaths_age_60_69deaths_age_60_69Number
Cases - White Non-Latinxcases_white_non_latinxcases_white_non_latinxNumber
Deaths Rate - Femaledeaths_rate_femaledeaths_rate_femaleNumber
Deaths Rate - Age 80+deaths_rate_age_80deaths_rate_age_80Number
Deaths Rate - Age 60-69deaths_rate_age_60_69deaths_rate_age_60_69Number
Cases Rate - Black Non-Latinxcases_rate_black_non_latinxcases_rate_black_non_latinxNumber
Cases Rate - Malecases_rate_malecases_rate_maleNumber
Cases Rate - Age 70-79cases_rate_age_70_79cases_rate_age_70_79Number
Cases Rate - Age 60-69cases_rate_age_60_69cases_rate_age_60_69Number
Hospitalizations Rate - Totalhospitalizations_rate_totalhospitalizations_rate_totalNumber
Cases - Age 30-39cases_age_30_39cases_age_30_39Number
Hospitalizations Rate - Age 70-79hospitalizations_rate_age_70_79hospitalizations_rate_age_70_79Number
Cases Rate - Other Race Non-Latinxcases_rate_other_race_noncases_rate_other_race_nonNumber
Hospitalizations - Age 40-49hospitalizations_age_40_49hospitalizations_age_40_49Number
Hospitalizations - Age 18-29hospitalizations_age_18_29hospitalizations_age_18_29Number
Cases - Asian Non-Latinxcases_asian_non_latinxcases_asian_non_latinxNumber
Deaths - White Non-Latinxdeaths_white_non_latinxdeaths_white_non_latinxNumber
Deaths - Latinxdeaths_latinxdeaths_latinxNumber
Deaths - Age 40-49deaths_age_40_49deaths_age_40_49Number
Cases Rate - Totalcases_rate_totalcases_rate_totalNumber
Cases Rate - Femalecases_rate_femalecases_rate_femaleNumber
Deaths Rate - Age 70-79deaths_rate_age_70_79deaths_rate_age_70_79Number
Cases - Femalecases_femalecases_femaleNumber
Cases - Age 40-49cases_age_40_49cases_age_40_49Number
Hospitalizations Rate - Femalehospitalizations_rate_femalehospitalizations_rate_femaleNumber
Deaths Rate - Black Non-Latinxdeaths_rate_black_non_latinxdeaths_rate_black_non_latinxNumber
Deaths Rate - Latinxdeaths_rate_latinxdeaths_rate_latinxNumber
Cases Rate - White Non-Latinxcases_rate_white_non_latinxcases_rate_white_non_latinxNumber
Hospitalizations - Latinxhospitalizations_latinxhospitalizations_latinxNumber
Hospitalizations - Age 70-79hospitalizations_age_70_79hospitalizations_age_70_79Number

Upstream Metadata