Connecticut Reportable Disease Case List

Table published by the Connecticut Department of Public Health that contains reportable disease data. Each row of data represents a case of disease in a person with the reported state of residence.

Each case is assigned to a report period based on the date of symptom onset or first positive test. The report period is identified by the Report Period Start Date and Report Period End Date. The actual date the case occurred is not included to protect confidentially.

All data are preliminary; data for previous weeks are routinely updated as new reports are received, duplicate records are removed, and data errors are corrected.

The following disease(s) are included in this table:

MPOX (previously called Monkeypox), Influenza

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/connecticut-reportable-disease-case-list-qhtt-czu2\".\"connecticut_reportable_disease_case_list\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.