COVID-19 Cases by Vaccination Status - ARCHIVE

Note: As of 10/28/2021 this dataset is no longer being updated. For more information about COVID-19 cases by vaccination status, visit the Department of Public Health's daily report here: https://data.ct.gov/stories/s/q5as-kyim

Cases of COVID-19 by vaccination status by weekly reporting period.

All data in this report are preliminary; data for previous dates will be updated as new reports are received and data errors are corrected.

Since February 2021, cases of COVID-19 among fully vaccinated persons (e.g., vaccine breakthrough cases) were identified based on a medical provider report to DPH identifying such cases. Recently, DPH developed a process that matches COVID-19 case data with the vaccine registry to determine which cases meet the definition of being fully vaccinated and are also vaccine breakthrough cases. A case of COVID-19 in a fully vaccinated person (e.g., vaccine breakthrough case) is defined as a person who has a positive PCR/NAAT or antigen test in a respiratory specimen collected ≥14 days after completing the final dose of an FDA-authorized or approved COVID-19 vaccine series and who did not have a previously positive COVID-19 test <45 days prior to the positive test currently under investigation. This newer process provides more accurate and complete data on the vaccine status of persons who have tested positive for COVID-19.

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-by-vaccination-status-archive-d5k4-zq6c\".\"covid19_cases_by_vaccination_status_archive\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.