About this Dataset

Sentenced Inmates In Correctional Facilities

A listing, updated nightly, of individuals being held in Department of Correction facilities who are sentenced to a period of incarceration. This data is appended on nightly basis reflecting the individual inmates being held in correctional facilities each day beginning August 22, 2017.
Organization: State of Connecticut
Last updated: 2020-11-12T14:58:04.194542
Tags: facility, inmates, sentenced

Tables

Table 1

@usgov.state_of_connecticut_sentenced_inmates_in_correctional_08fca352.table_1

104.4 MB
12,377,785 rows
12 columns

CREATE TABLE table_1 (
  "download_date" TIMESTAMP,
  "identifier" VARCHAR,
  "latest_admission_date" TIMESTAMP,
  "race" VARCHAR,
  "gender" VARCHAR,
  "age" DOUBLE,
  "end_sentence_date" VARCHAR,
  "offense" VARCHAR,
  "facility" VARCHAR,
  "detainer" VARCHAR,
  "sentence_days" DOUBLE,
  "special_parole_end_date" VARCHAR
);