About this Dataset

COVID-19 Daily Rolling Average Case, Death, And Hospitalization Rates - Historical

NOTE: This dataset has been retired and marked as historical-only. 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
Organization: City of Chicago
Last updated: 2020-11-10T16:54:49.588661
Tags: covid-19, death, ethnicity, gender, health, historical, hospitalization, link-to-article-present, public-health, race

Tables

Table 1

@usgov.city_of_chicago_covid_19_daily_rolling_average_case_an_9f13bcdb.table_1

389.11 kB
1,525 rows
97 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "cases_rate_total" DOUBLE  -- Cases Rate - Total,
  "deaths_rate_total" DOUBLE  -- Deaths Rate - Total,
  "hospitalizations_rate_total" DOUBLE  -- Hospitalizations Rate - Total,
  "cases_rate_age_0_17" DOUBLE  -- Cases Rate - Age 0-17,
  "cases_rate_age_18_29" DOUBLE  -- Cases Rate - Age 18-29,
  "cases_rate_age_30_39" DOUBLE  -- Cases Rate - Age 30-39,
  "cases_rate_age_40_49" DOUBLE  -- Cases Rate - Age 40-49,
  "cases_rate_age_50_59" DOUBLE  -- Cases Rate - Age 50-59,
  "cases_rate_age_60_69" DOUBLE  -- Cases Rate - Age 60-69,
  "cases_rate_age_70_79" DOUBLE  -- Cases Rate - Age 70-79,
  "cases_rate_age_80" DOUBLE  -- Cases Rate - Age 80+,
  "cases_rate_female" DOUBLE  -- Cases Rate - Female,
  "cases_rate_male" DOUBLE  -- Cases Rate - Male,
  "cases_rate_latinx" DOUBLE  -- Cases Rate - Latinx,
  "cases_rate_asian_non_latinx" DOUBLE  -- Cases Rate - Asian Non-Latinx,
  "cases_rate_black_non_latinx" DOUBLE  -- Cases Rate - Black Non-Latinx,
  "cases_rate_white_non_latinx" DOUBLE  -- Cases Rate - White Non-Latinx,
  "cases_rate_other_race_non_latinx" DOUBLE  -- Cases Rate - Other Race Non-Latinx,
  "deaths_rate_age_0_17" DOUBLE  -- Deaths Rate - Age 0-17,
  "deaths_rate_age_18_29" DOUBLE  -- Deaths Rate - Age 18-29,
  "deaths_rate_age_30_39" DOUBLE  -- Deaths Rate - Age 30-39,
  "deaths_rate_age_40_49" DOUBLE  -- Deaths Rate - Age 40-49,
  "deaths_rate_age_50_59" DOUBLE  -- Deaths Rate - Age 50-59,
  "deaths_rate_age_60_69" DOUBLE  -- Deaths Rate - Age 60-69,
  "deaths_rate_age_70_79" DOUBLE  -- Deaths Rate - Age 70-79,
  "deaths_rate_age_80" DOUBLE  -- Deaths Rate - Age 80+,
  "deaths_rate_female" DOUBLE  -- Deaths Rate - Female,
  "deaths_rate_male" DOUBLE  -- Deaths Rate - Male,
  "deaths_rate_latinx" DOUBLE  -- Deaths Rate - Latinx,
  "deaths_rate_asian_non_latinx" DOUBLE  -- Deaths Rate - Asian Non-Latinx,
  "deaths_rate_black_non_latinx" DOUBLE  -- Deaths Rate - Black Non-Latinx,
  "deaths_rate_white_non_latinx" DOUBLE  -- Deaths Rate - White Non-Latinx,
  "deaths_rate_other_race_non_latinx" DOUBLE  -- Deaths Rate - Other Race Non-Latinx,
  "hospitalizations_rate_age_0_17" DOUBLE  -- Hospitalizations Rate - Age 0-17,
  "hospitalizations_rate_age_18_29" DOUBLE  -- Hospitalizations Rate - Age 18-29,
  "hospitalizations_rate_age_30_39" DOUBLE  -- Hospitalizations Rate - Age 30-39,
  "hospitalizations_rate_age_40_49" DOUBLE  -- Hospitalizations Rate - Age 40-49,
  "hospitalizations_rate_age_50_59" DOUBLE  -- Hospitalizations Rate - Age 50-59,
  "hospitalizations_rate_age_60_69" DOUBLE  -- Hospitalizations Rate - Age 60-69,
  "hospitalizations_rate_age_70_79" DOUBLE  -- Hospitalizations Rate - Age 70-79,
  "hospitalizations_rate_age_80" DOUBLE  -- Hospitalizations Rate - Age 80+,
  "hospitalizations_rate_female" DOUBLE  -- Hospitalizations Rate - Female,
  "hospitalizations_rate_male" DOUBLE  -- Hospitalizations Rate - Male,
  "hospitalizations_rate_latinx" DOUBLE  -- Hospitalizations Rate - Latinx,
  "hospitalizations_rate_asian_non_latinx" DOUBLE  -- Hospitalizations Rate - Asian Non-Latinx,
  "hospitalizations_rate_black_non_latinx" DOUBLE  -- Hospitalizations Rate - Black Non-Latinx,
  "hospitalizations_rate_white_non_latinx" DOUBLE  -- Hospitalizations Rate - White Non-Latinx,
  "hospitalizations_rate_other_race_non_latinx" DOUBLE  -- Hospitalizations Rate - Other Race Non-Latinx,
  "cases_total" DOUBLE  -- Cases - Total,
  "deaths_total" DOUBLE  -- Deaths - Total,
  "hospitalizations_total" DOUBLE  -- Hospitalizations - Total,
  "cases_age_0_17" DOUBLE  -- Cases - Age 0-17,
  "cases_age_18_29" DOUBLE  -- Cases - Age 18-29,
  "cases_age_30_39" DOUBLE  -- Cases - Age 30-39,
  "cases_age_40_49" DOUBLE  -- Cases - Age 40-49,
  "cases_age_50_59" DOUBLE  -- Cases - Age 50-59,
  "cases_age_60_69" DOUBLE  -- Cases - Age 60-69,
  "cases_age_70_79" DOUBLE  -- Cases - Age 70-79,
  "cases_age_80" DOUBLE  -- Cases - Age 80+,
  "cases_female" DOUBLE  -- Cases - Female,
  "cases_male" DOUBLE  -- Cases - Male,
  "cases_latinx" DOUBLE  -- Cases - Latinx,
  "cases_asian_non_latinx" DOUBLE  -- Cases - Asian Non-Latinx,
  "cases_black_non_latinx" DOUBLE  -- Cases - Black Non-Latinx,
  "cases_white_non_latinx" DOUBLE  -- Cases - White Non-Latinx,
  "cases_other_race_non_latinx" DOUBLE  -- Cases - Other Race Non-Latinx,
  "deaths_age_0_17" DOUBLE  -- Deaths - Age 0-17,
  "deaths_age_18_29" DOUBLE  -- Deaths - Age 18-29,
  "deaths_age_30_39" DOUBLE  -- Deaths - Age 30-39,
  "deaths_age_40_49" DOUBLE  -- Deaths - Age 40-49,
  "deaths_age_50_59" DOUBLE  -- Deaths - Age 50-59,
  "deaths_age_60_69" DOUBLE  -- Deaths - Age 60-69,
  "deaths_age_70_79" DOUBLE  -- Deaths - Age 70-79,
  "deaths_age_80" DOUBLE  -- Deaths - Age 80+,
  "deaths_female" DOUBLE  -- Deaths - Female,
  "deaths_male" DOUBLE  -- Deaths - Male,
  "deaths_latinx" DOUBLE  -- Deaths - Latinx,
  "deaths_asian_non_latinx" DOUBLE  -- Deaths - Asian Non-Latinx,
  "deaths_black_non_latinx" DOUBLE  -- Deaths - Black Non-Latinx,
  "deaths_white_non_latinx" DOUBLE  -- Deaths - White Non-Latinx,
  "deaths_other_race_non_latinx" DOUBLE  -- Deaths - Other Race Non-Latinx,
  "hospitalizations_age_0_17" DOUBLE  -- Hospitalizations - Age 0-17,
  "hospitalizations_age_18_29" DOUBLE  -- Hospitalizations - Age 18-29,
  "hospitalizations_age_30_39" DOUBLE  -- Hospitalizations - Age 30-39,
  "hospitalizations_age_40_49" DOUBLE  -- Hospitalizations - Age 40-49,
  "hospitalizations_age_50_59" DOUBLE  -- Hospitalizations - Age 50-59,
  "hospitalizations_age_60_69" DOUBLE  -- Hospitalizations - Age 60-69,
  "hospitalizations_age_70_79" DOUBLE  -- Hospitalizations - Age 70-79,
  "hospitalizations_age_80" DOUBLE  -- Hospitalizations - Age 80+,
  "hospitalizations_female" DOUBLE  -- Hospitalizations - Female,
  "hospitalizations_male" DOUBLE  -- Hospitalizations - Male,
  "hospitalizations_latinx" DOUBLE  -- Hospitalizations - Latinx,
  "hospitalizations_asian_non_latinx" DOUBLE  -- Hospitalizations - Asian Non-Latinx,
  "hospitalizations_black_non_latinx" DOUBLE  -- Hospitalizations - Black Non-Latinx,
  "hospitalizations_white_non_latinx" DOUBLE  -- Hospitalizations - White Non-Latinx,
  "hospitalizations_other_race_non_latinx" DOUBLE  -- Hospitalizations - Other Race Non-Latinx
);