COVID-19 Cases in CT Schools (Statewide), 2020-2021 School Year - Archive

This dataset provides the number of weekly COVID-19 cases for staff and students in CT public and private PK-12 schools.

As of 6/24/2021, COVID-19 school-based surveillance activities for the 2020 – 2021 academic year has ended. The Connecticut Department of Public Health along with the Connecticut State Department of Education are planning to resume these activities at the start of the 2021 – 2022 academic year.

Data for the 2021-2022 school year is available here: https://data.ct.gov/Health-and-Human-Services/COVID-19-Cases-in-CT-Schools-Statewide-2021-2022-S/72vp-djx5

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 \"ct-gov/covid19-cases-in-ct-schools-statewide-20202021-ehua-hw73\".\"covid19_cases_in_ct_schools_statewide_20202021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.