ct-gov/connecticut-reportable-disease-case-list-with-the-4rss-apm8
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

Connecticut Reportable Disease Case List with the County of Residence

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 county 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-with-the-4rss-apm8\".\"connecticut_reportable_disease_case_list_with_the\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • connecticut_reportable_disease_case_list_with_the
     
     
     
     
     
Upstream Metadata