Name: Vancouver, BC Crime Dataset
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Vancouver, BC Crime Dataset

Geospatially tagged crime incident data for Vancouver, BC. Covers the period from 2003 to November 2023 (data access date).

Fields:

TYPE: The type of crime activity.
YEAR: A four-digit field that indicates the year when the reported crime activity occurred.
MONTH: A numeric field that indicates the month when the reported crime activity occurred.
DAY: A two-digit field that indicates the day of the month when the reported crime activity occurred.
HOUR: A two-digit field that indicates the hour time (in 24 hours format) when the reported crime activity occurred.
MINUTE: A two-digit field that indicates the minute when the reported crime activity occurred
HUNDRED_BLOCK: Generalized location of the reported crime activity
NEIGHBOURHOOD: Neighbourhoods within the City of Vancouver are based on the census tract (CT) concept within census metropolita area (CMA).
X: Coordinate values are projected in UTM Zone 10
Y: Coordinate values are projected in UTM Zone 10

Outdated versions of the dataset from the same source:

Tables

Crimedata Allneighbourhoods Allyears

@kaggle.tcashion_vancouver_bc_crime_dataset.crimedata_allneighbourhoods_allyears

8.33 MB
881,242 rows
10 columns

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