COVID-19 Cases in CT Schools (Statewide), 2021-2022 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 during the 2021-2022 school year. The following metrics are included:

Number of student cases - total

Number of student cases - fully vaccinated

June 30, 2022 is the last report for the 2021 – 2022 academic school year.

Number of student cases - not vaccinated

Number of student cases - no vaccine information

Number of staff cases - total

Number of staff cases - fully vaccinated

Number of staff cases - not vaccinated

Number of staff cases - no vaccine information

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

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-20212022-72vp-djx5\".\"covid19_cases_in_ct_schools_statewide_20212022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.