ct-gov/connecticut-reportable-disease-case-list-with-the-drc5-scuw
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 3 days ago
Indexed 3 hours ago

Connecticut Reportable Disease Case List with the Reported Race and Ethnicity

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 their reported race/ethnicity.

Information on race/ethnicity is gathered from individuals during case interviews. Reported race and ethnicity information is used create a single race/ethnicity variable. People with more than one race are classified as two or more races. People with Hispanic ethnicity are classified as Hispanic regardless of reported race(s). People with a missing ethnicity are classified as non-Hispanic.

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-drc5-scuw\".\"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