About this Dataset

COVID-19 Wastewater Detection - Historical

As described in https://data.cityofchicago.org/stories/s/sihu-d8va, the function of this dataset was replaced by https://data.cityofchicago.org/d/4tzt-ir6h. This dataset is historical-only.

Concentrations of the SARS-CoV-2 virus (the COVID-19 virus) gene in the Chicago sewer system, as measured at eight sewershed sites. These sites represent catchment areas that describe wastewater from 319,700 Chicagoans as of January 2023.

Because SARS-CoV-2 is shed in human feces, this method can be used to estimate changes in COVID-19 at different times and locations across Chicago. While the data in this dataset do not indicate how many people were infected with SARS-CoV-2, differences in the the normalized_n1 indicate whether the proportion of individuals at the site who are shedding that virus has changed.
Organization: City of Chicago
Last updated: 2023-02-10T20:49:19.893437
Tags: covid-19, health, historical, public-health, sanitation, testing

Tables

Table 1

@usgov.city_of_chicago_covid_19_wastewater_detection.table_1

64.54 kB
2,214 rows
7 columns

CREATE TABLE table_1 (
  "sewershed" VARCHAR,
  "sewershed_id" VARCHAR,
  "sample_collect_date" TIMESTAMP,
  "n1_copies_l" BIGINT,
  "pmmov_copies_l" DOUBLE,
  "normalized_n1" DOUBLE,
  "record_id" VARCHAR
);