Name: Marijuana Arrests In Columbia
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

Marijuana Arrests In Columbia

Column	Description	Format
TYPE	Indicates the type of arrest	Text
ADULT_JUVENILE	Specifies whether the arrestee is an adult or a juvenile	Text
YEAR	The year in which the arrest occurred	Numeric
DATETIME	The date and time of the arrest	Text
CCN	Hash number that allows individuals to determine whether there are multiple arrests associated with one event	Text
AGE	The age of the arrestee at the time of the arrest	Numeric
OFFENSE_DISTRICT	The district where the offense took place	Text
OFFENSE_PSA	The Police Service Area (PSA) associated with the offense	Text
OFFENSE_BLOCKX	X-coordinate of the approximate block location of the offense	Numeric
OFFENSE_BLOCKY	Y-coordinate of the approximate block location of the offense	Numeric
DEFENDANT_PSA	The PSA associated with the defendant	Text
DEFENDANT_DISTRICT	The district associated with the defendant	Text
RACE	The race of the defendant, based on officer observation	Text
ETHNICITY	The ethnicity of the defendant, based on officer observation	Text
SEX	The gender of the defendant	Text
CATEGORY	The category of the offense (e.g., possession, distribution, public consumption)	Text
DESCRIPTION	A description of the offense	Text
ADDRESS	The address of the offense location	Text
ARREST_BLOCKX	X-coordinate of the approximate block location of the arrest	Numeric
ARREST_BLOCKY	Y-coordinate of the approximate block location of the arrest	Numeric
GIS_ID	Geographic Information System (GIS) ID associated with the record	Text
CREATOR	The creator of the record	Text
CREATED	The date and time when the record was created	Text
EDITOR	The editor of the record	Text
EDITED	The date and time when the record was last edited	Text
OBJECTID	Unique identifier for each record	Numeric
GLOBALID	Global unique identifier for each record	Text

Description

In the District of Columbia, the laws related to the recreational use and possession of marijuana have changed at two milestones: the effective dates of the Marijuana Possession Decriminalization Amendment Act of 2014 on July 17, 2014, and of Initiative 71 on February 26, 2015 (https://mpdc.dc.gov/marijuana). Due to privacy considerations, exact CCNs and arrest numbers for these arrest datasets are not provided. In lieu, hash numbers are provided for CNN which allows individuals to determine whether there are multiple arrests associated with one event. Additionally, arrest numbers can be linked directly to an individual and therefore DC government does not provide this more generally, but again as hash numbers.

This data includes arrests made by the Metropolitan Police Department (MPD). The data represents individuals arrested with a marijuana charge, regardless of whether there was a more serious secondary charge. If an arrestee was charged with multiple marijuana charges, the arrest is only counted once under the more serious charge type (Distribution > Possession with Intent to Distribute > Possession > Public Consumption).

MPD collects race and ethnicity data according to the United States Census Bureau standards (https://www.census.gov/topics/population/race/about.html). Hispanic, which was previously categorized under the Race field prior to August 2015, is now captured under Ethnicity. All records prior to August 2015 have been updated to “Unknown (Race), Hispanic (Ethnicity)”. Race and ethnicity data are based on officer observation, which may or may not be accurate.

MPD cannot release exact addresses to the general public unless proof of ownership or subpoena is submitted. The GeoX and GeoY values represent the block location (approximately 232 ft. radius) as of the date of the arrest. Due to the Department’s redistricting efforts in 2012 and 2017, data may not be comparable in some years.

Arrestee age is calculated based on the number of days between the self-reported or verified date of birth (DOB) of the arrestee and the date of the arrest; DOB data may not be accurate if selfreported or if the arrestee refused to provide it.

Due to the sensitive nature of juvenile data and to protect the arrestee’s confidentiality, any arrest records for defendants under the age of 18 have been coded as “Juvenile” for the following fields:

• Arrest Time

• CCN

• Age

• Offense Location Block GeoX/Y

• Defendant Race

• Defendant Ethnicity

• Defendant Sex

• Arrest Location Block Address

• Arrest Location Block GeoX/Y

This data may not match other marijuana data requests that may have included all law enforcement agencies in the District, or only the most serious charge. Figures are subject to change due to record sealing, expungements, and data quality audits.

Tables

Marijuana Arrests

@kaggle.utkarshx27_marijuana_arrests_in_columbia.marijuana_arrests

1.18 MB
13,063 rows
27 columns

CREATE TABLE marijuana_arrests (
  "type" VARCHAR,
  "adult_juvenile" VARCHAR,
  "year" BIGINT,
  "datetime" VARCHAR,
  "ccn" VARCHAR,
  "age" DOUBLE,
  "offense_district" VARCHAR,
  "offense_psa" DOUBLE,
  "offense_blockx" DOUBLE,
  "offense_blocky" DOUBLE,
  "defendant_psa" VARCHAR,
  "defendant_district" VARCHAR,
  "race" VARCHAR,
  "ethnicity" VARCHAR,
  "sex" VARCHAR,
  "category" VARCHAR,
  "description" VARCHAR,
  "address" VARCHAR,
  "arrest_blockx" DOUBLE,
  "arrest_blocky" DOUBLE,
  "gis_id" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR
);