Name: Felony Sentences

Display Field: RID

Type: Table

Geometry Type: N/A

Description: 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.

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• RID ( type: esriFieldTypeString, alias: RID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rID )
• GENERIC_CASE_ID ( type: esriFieldTypeString, alias: GENERIC_CASE_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Generic_Case_ID )
• GENERIC_OFFENDER_ID ( type: esriFieldTypeString, alias: GENERIC_OFFENDER_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Generic_Offender_ID )
• CHARGE_NUMBER ( type: esriFieldTypeDouble, alias: CHARGE_NUMBER, editable: true, nullable: true, defaultValue: null, modelName: Charge_Number )
• SENTENCE_YEAR ( type: esriFieldTypeDouble, alias: SENTENCE_YEAR, editable: true, nullable: true, defaultValue: null, modelName: Sentence_Year )
• RACE ( type: esriFieldTypeString, alias: RACE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Race )
• GENDER ( type: esriFieldTypeString, alias: GENDER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Gender )
• AGE_GROUP ( type: esriFieldTypeString, alias: AGE_GROUP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Age_Group )
• OFFENSE ( type: esriFieldTypeString, alias: OFFENSE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Offense )
• OFFENSE_TYPE ( type: esriFieldTypeString, alias: OFFENSE_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Offense_Type )
• HOMICIDE_TYPE ( type: esriFieldTypeString, alias: HOMICIDE_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Homicide_Type )
• OFFENSE_SEVERITY_GROUP ( type: esriFieldTypeString, alias: OFFENSE_SEVERITY_GROUP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Offense_Severity_Group )
• SENTENCE_TYPE ( type: esriFieldTypeString, alias: SENTENCE_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Sentence_Type )
• SENTENCE_IMPOSED_MONTHS ( type: esriFieldTypeDouble, alias: SENTENCE_IMPOSED_MONTHS, editable: true, nullable: true, defaultValue: null, modelName: Sentence_Imposed_Months )
• SENTENCE_SUSPENDED_MONTHS ( type: esriFieldTypeDouble, alias: SENTENCE_SUSPENDED_MONTHS, editable: true, nullable: true, defaultValue: null, modelName: Sentence_Suspended_Months )
• SENTENCE_TO_SERVE_MONTHS ( type: esriFieldTypeDouble, alias: SENTENCE_TO_SERVE_MONTHS, editable: true, nullable: true, defaultValue: null, modelName: Sentence_to_Serve_Months )
• SENTENCE_PROBATION_MONTHS ( type: esriFieldTypeDouble, alias: SENTENCE_PROBATION_MONTHS, editable: true, nullable: true, defaultValue: null, modelName: Sentence_Probation_Months )
• VVCA_AMT ( type: esriFieldTypeDouble, alias: VVCA_AMT, editable: true, nullable: true, defaultValue: null, modelName: VVCA_AMT )
• FINE_AMT ( type: esriFieldTypeDouble, alias: FINE_AMT, editable: true, nullable: true, defaultValue: null, modelName: Fine_AMT )
• RESTITUTION_AMT ( type: esriFieldTypeDouble, alias: RESTITUTION_AMT, editable: true, nullable: true, defaultValue: null, modelName: Restitution_AMT )
• FINE_SUSPENDED_AMT ( type: esriFieldTypeDouble, alias: FINE_SUSPENDED_AMT, editable: true, nullable: true, defaultValue: null, modelName: Fine_Suspended_AMT )
• GIS_ID ( type: esriFieldTypeString, alias: GIS_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GIS_ID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• CREATED ( type: esriFieldTypeDate, alias: CREATED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED )
• EDITED ( type: esriFieldTypeDate, alias: EDITED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDITED )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Felony Sentences
  Description:
  Prototype:
  EDITED: null
  RID: null
  GENERIC_CASE_ID: null
  GENERIC_OFFENDER_ID: null
  CHARGE_NUMBER: null
  SENTENCE_YEAR: null
  RACE: null
  GENDER: null
  AGE_GROUP: null
  OFFENSE: null
  OFFENSE_TYPE: null
  HOMICIDE_TYPE: null
  OFFENSE_SEVERITY_GROUP: null
  SENTENCE_TYPE: null
  SENTENCE_IMPOSED_MONTHS: null
  SENTENCE_SUSPENDED_MONTHS: null
  SENTENCE_TO_SERVE_MONTHS: null
  SENTENCE_PROBATION_MONTHS: null
  VVCA_AMT: null
  FINE_AMT: null
  RESTITUTION_AMT: null
  FINE_SUSPENDED_AMT: null
  GIS_ID: null
  CREATED: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata