Data Dictionary

Column Type Label Description
Arrest_Year int4

Year of arrest

Arrest_Month text

Month of arrest in quarters (Jan-Mar, Apr-June, Jul-Sept, Oct-Dec)

EventID int4

Randomized ID value - Incident related to the arrest

ArrestID int4

Randomized ID value – Arrest event

PersonID int4

Randomized ID value – Unique Person

Perceived_Race text

Officer's perception of the person's race

Sex text

Arrested person's sex

Age_group__at_arrest_ text

Arrested person's age at time of arrest

Youth_at_arrest__under_18_years text
ArrestLocDiv text

Location of Arrest (Division)

StripSearch int4

Person was strip searched following arrest

Booked int4

Person was booked at the station

Occurrence_Category text

Most serious offence or incident type associated with the arrest

Actions_at_arrest___Concealed_i int4

The Person's actions at the time of arrest -- concealing items

Actions_at_arrest___Combative__ int4

The Person's actions at the time of arrest -- combative, violent or biting/spitting behaviours

Actions_at_arrest___Resisted__d int4

The Person's actions at the time of arrest -- resisted arrest, defensive or attempted escape

Actions_at_arrest___Mental_inst int4

The Person's actions at the time of arrest -- appeared mentally unstable

Actions_at_arrest___Assaulted_o int4

The Person's actions at the time of arrest -- assaulted officer

Actions_at_arrest___Cooperative int4

The Person's actions at the time of arrest -- cooperative

SearchReason_CauseInjury text

Reason for search -- items to cause injury

SearchReason_AssistEscape text

Reason for search -- items to assist escape

SearchReason_PossessWeapons text

Reason for search -- possess weapons

SearchReason_PossessEvidence text

Reason for search -- possess evidence

ItemsFound text

Items were found during a strip search

ObjectId int4

Unique identifier from the source system

Additional Information

Field Value
Data last updated December 2, 2022
Metadata last updated October 15, 2024
Created December 2, 2022
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '78ef6b68-7a88-47f9-9dab-a0f00f5d8b0d', 'XML': '88e99ca8-e779-43bc-8fbf-48a9d63237a6', 'JSON': '8f0a2caf-6a94-444a-8819-197db732e0ca'}
Datastore cache last update7 months ago
Extract jobAirflow - files_to_datastore.py - police-race-and-identity-based-data-collection-arrests-strip-searches
Has viewsTrue
Idc64c9852-f251-445b-8723-9cbd8f5c2b19
Is previewTrue
Package idpolice-race-and-identity-based-data-collection-arrests-strip-searches
Package name or idpolice-race-and-identity-based-data-collection-arrests-strip-searches
Position0
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - police-race-and-identity-based-data-collection-arrests-strip-searches
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID