COVID-19 Wastewater Detection
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.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"cityofchicago/covid19-wastewater-detection-urdi-w8wq\".\"covid19_wastewater_detection\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.