Influenza ICU Cases By Week And Demographic/Medical Category - Historical
City of Chicago
@usgov.city_of_chicago_influenza_icu_cases_by_week_and_demogr_0746df55
City of Chicago
@usgov.city_of_chicago_influenza_icu_cases_by_week_and_demogr_0746df55
NOTE: This dataset is no longer being updated but is being kept for historical reference. For current data on respiratory illness visits and respiratory laboratory testing data please see Influenza, COVID-19, RSV, and Other Respiratory Virus Laboratory Surveillance and Inpatient, Emergency Department, and Outpatient Visits for Respiratory Illnesses. In Illinois, influenza associated Intensive Care Unit (ICU) hospitalizations are reportable as soon as possible, but within 24 hours. Influenza associated ICU hospitalizations are defined as individuals hospitalized in an ICU with a positive laboratory test for influenza A or B, including specimens identified as influenza A/H3N2, A/H1N1pdm09, and specimens not subtyped (e.g., influenza positive cases by PCR or any rapid test such as EIA). This dataset represents weekly aggregated information for influenza-associated ICU hospitalizations among Chicago residents, which is a reportable condition in Illinois. Information includes demographics, influenza laboratory results, vaccination status, and death status. Column names containing "REPORTED" indicate the number of cases for which the indicated data element was reported. This, rather than the total number of cases, is used to calculate the corresponding percentage. All data are provisional and subject to change. Information is updated as additional details are received. At any given time, this dataset reflects data currently known to CDPH. Numbers in this dataset may differ from other public sources.
Organization: City of Chicago
Last updated: 2021-11-07T10:34:53.713805
Tags: flu, health, historical, public-health
CREATE TABLE table_1 (
"record_id" VARCHAR,
"mmwr_week" BIGINT,
"week_start" TIMESTAMP,
"week_end" TIMESTAMP,
"influenza_season" VARCHAR,
"cases" BIGINT,
"age_0_4_count" BIGINT,
"age_5_17_count" BIGINT,
"age_18_24_count" BIGINT,
"age_25_49_count" BIGINT,
"age_50_64_count" BIGINT,
"age_65_over_count" BIGINT,
"age_unknown_count" BIGINT,
"age_0_4_pct" DOUBLE,
"age_5_17_pct" DOUBLE,
"age_18_24_pct" DOUBLE,
"age_25_49_pct" DOUBLE,
"age_50_64_pct" DOUBLE,
"age_65_over_pct" DOUBLE,
"age_unknown_pct" DOUBLE,
"white_non_latinx_count" BIGINT,
"black_non_latinx_count" BIGINT,
"latinx_count" BIGINT,
"asian_non_latinx_count" BIGINT,
"nhpi_non_latinx_count" BIGINT,
"aian_non_latinx_count" BIGINT,
"other_race_non_latinx_count" BIGINT,
"unknown_race_ethnicity_count" BIGINT,
"white_non_latinx_pct" DOUBLE,
"black_non_latinx_pct" DOUBLE,
"latinx_pct" DOUBLE,
"asian_non_latinx_pct" DOUBLE,
"nhpi_non_latinx_pct" DOUBLE,
"aian_non_latinx_pct" DOUBLE,
"other_race_non_latinx_pct" DOUBLE,
"unknown_race_ethnicity_pct" DOUBLE,
"female_count" BIGINT,
"male_count" BIGINT,
"female_pct" DOUBLE,
"male_pct" DOUBLE,
"deaths_count" BIGINT,
"deaths_pct" DOUBLE,
"flushot_reported" BIGINT,
"flushot_count" BIGINT,
"flushot_pct" DOUBLE,
"ah3n2_count" BIGINT,
"anotsub_count" BIGINT,
"ah1n1_count" BIGINT,
"b_count" BIGINT,
"ah3n2_pct" DOUBLE,
"anotsub_pct" DOUBLE,
"ah1n1_pct" DOUBLE,
"b_pct" DOUBLE
);Anyone who has the link will be able to view this.