Name: London Crime Data, 2008-2016
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

London Crime Data, 2008-2016

Context:

Crime in major metropolitan areas, such as London, occurs in distinct patterns. This data covers the number of criminal reports by month, LSOA borough, and major/minor category from Jan 2008-Dec 2016.

Content:

13M rows containing counts of criminal reports by month, LSOA borough, and major/minor category.

Acknowledgements:

Txt file was pulled from Google Cloud Platform and converted to csv. Photo by James Sutton.

Inspiration:

Are there seasonal or time-of-week/day changes in crime occurrences? Any boroughs where particular crimes are increasing or decreasing? Policy makers use this data to plan upcoming budgets and deployment--can you use previous year crime reports to reliably predict later trends? If you normalize by borough population, can you find any areas where crime is more or less likely?

Tables

London Crime By Lsoa

@kaggle.jboysen_london_crime.london_crime_by_lsoa

67.4 MB
13,490,604 rows
7 columns

CREATE TABLE london_crime_by_lsoa (
  "lsoa_code" VARCHAR,
  "borough" VARCHAR,
  "major_category" VARCHAR,
  "minor_category" VARCHAR,
  "value" BIGINT,
  "year" BIGINT,
  "month" BIGINT
);