Dataset: Felony Sentences

About this Dataset

Felony Sentences

This dataset contains all felony counts sentenced from 2010 onward and includes offender demographic information such as gender, race, and age, as well as sentencing information such as the offense, offense severity group, and the type and length of sentence imposed. The dataset is updated annually. Individuals interested in more extensive data sets may contact the Sentencing Commission via email at sccrc@dc.gov.
Organization: District of Columbia
Last updated: 2024-05-29T02:12:34.425500
Tags: court, crime, criminal, criminal-justice, felony, justice, public-safety, rahbilitation, scdc, sentencing

Tables

Table 1

@usgov.district_of_columbia_felony_sentences_0299e.table_1

1.79 MB
24676 rows
28 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "rid" BIGINT,
  "generic_case_id" BIGINT,
  "generic_offender_id" BIGINT,
  "charge_number" BIGINT,
  "sentence_year" BIGINT,
  "race" VARCHAR,
  "gender" VARCHAR,
  "age_group" VARCHAR,
  "offense" VARCHAR,
  "offense_type" VARCHAR,
  "homicide_type" VARCHAR,
  "offense_severity_group" VARCHAR,
  "sentence_type" VARCHAR,
  "sentence_imposed_months" DOUBLE,
  "sentence_suspended_months" DOUBLE,
  "sentence_to_serve_months" DOUBLE,
  "sentence_probation_months" DOUBLE,
  "vvca_amt" BIGINT,
  "fine_amt" DOUBLE,
  "restitution_amt" DOUBLE,
  "fine_suspended_amt" DOUBLE,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR
);