Marijuana Related Crime

weed and crime from 2016 to 2020 in Denver

@kaggle.jinbonnie_crime_and_weed

Table List

1 table(56.04 KB)

Crime Marijuana

@kaggle.jinbonnie_crime_and_weed.crime_marijuana

56.04 KB
1201 rows
14 columns

incident_id INCIDENT ID	first_occurence_date FIRST OCCURENCE DATE	last_occurence_date LAST OCCURENCE DATE	reportdate REPORTDATE	incident_address INCIDENT ADDRESS	geo_x GEO X	geo_y GEO Y	district_id DISTRICT ID	precinct_id PRECINCT ID	offense_code OFFENSE CODE	offense_type_id OFFENSE TYPE ID	offense_category_id OFFENSE CATEGORY ID	mj_relation_type MJ RELATION TYPE	neighborhood_id NEIGHBORHOOD ID
2017151765	06-MAR-17	06-MAR-17	06-MAR-17	2207 N HOOKER ST	3132526	1698468	1	121	3563	DRUG - MARIJUANA CULTIVATION	Drug Offenses	NON-INDUSTRY	sloan-lake
20184912	03-JAN-18	03-JAN-18	03-JAN-18	4400 E EVANS AVE	3158749	1672408	3	314	2205	BURGLARY - BUSINESS NO FORCE	Burglary	INDUSTRY	university-hills
20184942	03-JAN-18	03-JAN-18	03-JAN-18	3435 S YOSEMITE ST	3173094	1663993	3	323	2203	BURGLARY - BUSINESS BY FORCE	Burglary	INDUSTRY	hampden
201666719	01-FEB-16	01-FEB-16	01-FEB-16	5050 N YORK ST	3152054	1712498	2	212	2203	BURGLARY - BUSINESS BY FORCE	Burglary	INDUSTRY	elyria-swansea
2016317585	21-MAY-16	21-MAY-16	21-MAY-16	3888 E MEXICO AVE	3157004	1674967	3	312	2203	BURGLARY - BUSINESS BY FORCE	Burglary	INDUSTRY	cory-merrill
2015406705	19-JUL-15	nan	19-JUL-15	16TH ST / CALIFORNIA ST	3142790	1696716	6	611	1315	AGGRAVATED ASSAULT	Agg ASLT-Other	NON-INDUSTRY	cbd
20184840	03-JAN-18	03-JAN-18	03-JAN-18	120 S KALAMATH ST	3140719	1685494	3	311	2203	BURGLARY - BUSINESS BY FORCE	Burglary	INDUSTRY	baker
2015219242	17-APR-15	nan	22-APR-15	401 16TH ST	3143533	1696058	6	611	3560	DRUG - MARIJUANA SELL	Drug Offenses	INDUSTRY	cbd
20184860	03-JAN-18	03-JAN-18	03-JAN-18	755 S FEDERAL BLVD	3133515	1681258	4	412	2203	BURGLARY - BUSINESS BY FORCE	Burglary	INDUSTRY	westwood
201925397	12-JAN-19	12-JAN-19	12-JAN-19	1255 W VIRGINIA AVE	3139724	1683088	4	412	2203	BURGLARY - BUSINESS BY FORCE	Burglary	INDUSTRY	athmar-park


CREATE TABLE crime_marijuana (
  "incident_id" BIGINT,
  "first_occurence_date" VARCHAR,
  "last_occurence_date" VARCHAR,
  "reportdate" VARCHAR,
  "incident_address" VARCHAR,
  "geo_x" DOUBLE,
  "geo_y" DOUBLE,
  "district_id" BIGINT,
  "precinct_id" BIGINT,
  "offense_code" BIGINT,
  "offense_type_id" VARCHAR,
  "offense_category_id" VARCHAR,
  "mj_relation_type" VARCHAR,
  "neighborhood_id" VARCHAR
);