cityofchicago/covid19-daily-rolling-average-case-death-and-e68t-c7fv
Icon for Socrata external plugin
 
Readme
Updated 22 hours ago
Indexed 3 hours ago

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

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