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

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

379.99 KB
1525 rows
97 columns


CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "cases_rate_total" DOUBLE,
  "deaths_rate_total" DOUBLE,
  "hospitalizations_rate_total" DOUBLE,
  "cases_rate_age_0_17" DOUBLE,
  "cases_rate_age_18_29" DOUBLE,
  "cases_rate_age_30_39" DOUBLE,
  "cases_rate_age_40_49" DOUBLE,
  "cases_rate_age_50_59" DOUBLE,
  "cases_rate_age_60_69" DOUBLE,
  "cases_rate_age_70_79" DOUBLE,
  "cases_rate_age_80" DOUBLE,
  "cases_rate_female" DOUBLE,
  "cases_rate_male" DOUBLE,
  "cases_rate_latinx" DOUBLE,
  "cases_rate_asian_non_latinx" DOUBLE,
  "cases_rate_black_non_latinx" DOUBLE,
  "cases_rate_white_non_latinx" DOUBLE,
  "cases_rate_other_race_non_latinx" DOUBLE,
  "deaths_rate_age_0_17" DOUBLE,
  "deaths_rate_age_18_29" DOUBLE,
  "deaths_rate_age_30_39" DOUBLE,
  "deaths_rate_age_40_49" DOUBLE,
  "deaths_rate_age_50_59" DOUBLE,
  "deaths_rate_age_60_69" DOUBLE,
  "deaths_rate_age_70_79" DOUBLE,
  "deaths_rate_age_80" DOUBLE,
  "deaths_rate_female" DOUBLE,
  "deaths_rate_male" DOUBLE,
  "deaths_rate_latinx" DOUBLE,
  "deaths_rate_asian_non_latinx" DOUBLE,
  "deaths_rate_black_non_latinx" DOUBLE,
  "deaths_rate_white_non_latinx" DOUBLE,
  "deaths_rate_other_race_non_latinx" DOUBLE,
  "hospitalizations_rate_age_0_17" DOUBLE,
  "hospitalizations_rate_age_18_29" DOUBLE,
  "hospitalizations_rate_age_30_39" DOUBLE,
  "hospitalizations_rate_age_40_49" DOUBLE,
  "hospitalizations_rate_age_50_59" DOUBLE,
  "hospitalizations_rate_age_60_69" DOUBLE,
  "hospitalizations_rate_age_70_79" DOUBLE,
  "hospitalizations_rate_age_80" DOUBLE,
  "hospitalizations_rate_female" DOUBLE,
  "hospitalizations_rate_male" DOUBLE,
  "hospitalizations_rate_latinx" DOUBLE,
  "hospitalizations_rate_asian_non_latinx" DOUBLE,
  "hospitalizations_rate_black_non_latinx" DOUBLE,
  "hospitalizations_rate_white_non_latinx" DOUBLE,
  "hospitalizations_rate_other_race_non_latinx" DOUBLE,
  "cases_total" DOUBLE,
  "deaths_total" DOUBLE,
  "hospitalizations_total" DOUBLE,
  "cases_age_0_17" DOUBLE,
  "cases_age_18_29" DOUBLE,
  "cases_age_30_39" DOUBLE,
  "cases_age_40_49" DOUBLE,
  "cases_age_50_59" DOUBLE,
  "cases_age_60_69" DOUBLE,
  "cases_age_70_79" DOUBLE,
  "cases_age_80" DOUBLE,
  "cases_female" DOUBLE,
  "cases_male" DOUBLE,
  "cases_latinx" DOUBLE,
  "cases_asian_non_latinx" DOUBLE,
  "cases_black_non_latinx" DOUBLE,
  "cases_white_non_latinx" DOUBLE,
  "cases_other_race_non_latinx" DOUBLE,
  "deaths_age_0_17" DOUBLE,
  "deaths_age_18_29" DOUBLE,
  "deaths_age_30_39" DOUBLE,
  "deaths_age_40_49" DOUBLE,
  "deaths_age_50_59" DOUBLE,
  "deaths_age_60_69" DOUBLE,
  "deaths_age_70_79" DOUBLE,
  "deaths_age_80" DOUBLE,
  "deaths_female" DOUBLE,
  "deaths_male" DOUBLE,
  "deaths_latinx" DOUBLE,
  "deaths_asian_non_latinx" DOUBLE,
  "deaths_black_non_latinx" DOUBLE,
  "deaths_white_non_latinx" DOUBLE,
  "deaths_other_race_non_latinx" DOUBLE,
  "hospitalizations_age_0_17" DOUBLE,
  "hospitalizations_age_18_29" DOUBLE,
  "hospitalizations_age_30_39" DOUBLE,
  "hospitalizations_age_40_49" DOUBLE,
  "hospitalizations_age_50_59" DOUBLE,
  "hospitalizations_age_60_69" DOUBLE,
  "hospitalizations_age_70_79" DOUBLE,
  "hospitalizations_age_80" DOUBLE,
  "hospitalizations_female" DOUBLE,
  "hospitalizations_male" DOUBLE,
  "hospitalizations_latinx" DOUBLE,
  "hospitalizations_asian_non_latinx" DOUBLE,
  "hospitalizations_black_non_latinx" DOUBLE,
  "hospitalizations_white_non_latinx" DOUBLE,
  "hospitalizations_other_race_non_latinx" DOUBLE
);