Crime In Vancouver

Data of crimes in Vancouver (Canada) from 2003 to 2017

@kaggle.wosaku_crime_in_vancouver

Table List

2 tables(10.03 MB)

Crime

@kaggle.wosaku_crime_in_vancouver.crime

10.03 MB
530652 rows
12 columns

type TYPE	year YEAR	month MONTH	day DAY	hour HOUR	minute MINUTE	hundred_block HUNDRED BLOCK	neighbourhood NEIGHBOURHOOD	x X	y Y	latitude Latitude	longitude Longitude
Other Theft	2003	5	12	16	15	9XX TERMINAL AVE	Strathcona	493906.5	5457452.47	49.26980201	-123.0837633
Other Theft	2003	5	7	15	20	9XX TERMINAL AVE	Strathcona	493906.5	5457452.47	49.26980201	-123.0837633
Other Theft	2003	4	23	16	40	9XX TERMINAL AVE	Strathcona	493906.5	5457452.47	49.26980201	-123.0837633
Other Theft	2003	4	20	11	15	9XX TERMINAL AVE	Strathcona	493906.5	5457452.47	49.26980201	-123.0837633
Other Theft	2003	4	12	17	45	9XX TERMINAL AVE	Strathcona	493906.5	5457452.47	49.26980201	-123.0837633
Other Theft	2003	3	26	20	45	9XX TERMINAL AVE	Strathcona	493906.5	5457452.47	49.26980201	-123.0837633
Break and Enter Residential/Other	2003	3	10	12		63XX WILTSHIRE ST	Kerrisdale	489325.58	5452817.95	49.22805078	-123.1466105
Mischief	2003	6	28	4	13	40XX W 19TH AVE	Dunbar-Southlands	485903.09	5455883.77	49.25555918	-123.1937252
Other Theft	2003	2	16	9	2	9XX TERMINAL AVE	Strathcona	493906.5	5457452.47	49.26980201	-123.0837633
Break and Enter Residential/Other	2003	7	9	18	15	18XX E 3RD AVE	Grandview-Woodland	495078.19	5457221.38	49.26773386	-123.067654


CREATE TABLE crime (
  "type" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour" DOUBLE,
  "minute" DOUBLE,
  "hundred_block" VARCHAR,
  "neighbourhood" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);