COVID-19 Contact Tracing: ContaCT Summary - ARCHIVE

Note: This dataset has been archived and is no longer being updated.

Contact tracing is the process of contacting all people who have tested positive for COVID-19 or have had contact with someone who tested positive. The software for contact tracing in Connecticut is called ContaCT. ContaCT is used for monitoring the health and wellbeing of people affected by COVID-19 and assists in facilitating timely and accurate contact tracing.

This dataset includes metrics on COVID-19 cases in the ContaCT system and the contacts associated with those cases for each reporting period, including:

Total actionable community cases

Attempted interviews within 48 hours - cases

Successful interviews within 48 hours - cases

Total actionable community contacts

Attempted interviews within 48 hours - contacts

Successful interviews within 48 hours - contacts

Ratio of contacts:cases

Number of cases listing at least one contact

Median contacts reported

Range of contacts reported (min)

Range of contacts reported (max)

All data are preliminary and are subject to change.

Additional information on COVID-19 Contact Tracing can be found here: https://portal.ct.gov/Coronavirus/ContaCT

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-contact-tracing-contact-summary-archive-x7e5-mdri\".\"covid19_contact_tracing_contact_summary_archive\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.