ct-gov/covid19-in-correctional-facilities-6t8i-du3u
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 11 months ago
Indexed 3 hours ago

COVID-19 in Correctional Facilities

June 8, 2023: Daily transmission is no longer available.

Summary of COVID-19 statistics for Connecticut correctional facilities including:

Total # of Staff Positive for COVID-19

Total # of Inmates Pos. for COVID-19

COVID-19 Pos. Inmates Housed at Northern CI Medical Isolation Unit

COVID-19 Pos. Inmates Housed at MacDougall-Walker Medical Isolation Unit

COVID-19 Pos. Staff Returned to Work

Total # of Inmates Medically Cleared

Total # of COVID-19 Pos. Inmate Deaths

More information can be found on the DOC website: https://portal.ct.gov/DOC/Common-Elements/Common-Elements/Health-Information-and-Advisories

Data will be updated every weekday.

Additional notes:

The data on 7/15 reflects a decrease in the number of inmates testing positive for COVID-19 and those who have recovered; this decrease was due to an internal data audit that led to the removal of some duplicate information.

The data on 6/2/2020 reflects an increase in the number of inmates who had been medically cleared; this increase was the result of 146 asymptomatic positive inmates who had completed a 14-day isolation period.

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-in-correctional-facilities-6t8i-du3u\".\"covid19_in_correctional_facilities\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • covid19_in_correctional_facilities
     
     
     
     
     
Upstream Metadata