About this Dataset

Street Level Crime (police.uk Data)

Crime data and neighbourhood policing information from all forces in England and Wales to the Public. This data is what is behind the police.uk website.

The Police API allows you to retrieve information about neighbourhood areas in all 43 English & Welsh police forces. All forces are required to keep this data accurate and up to date, so the API provides a rich and definitive data source for crime statistics at both street and neighourhood level.

The API is implemented as a standard XML REST web service using HTTP GET/POST requests.

The monthly data dumps can be downloaded using URLs structured consistently in the following format: https://data.police.uk/data/archive/[year]-[month].zip However because the data file is over 19 million rows, we also provide Custom CSV Download and JSON API helper interfaces so you can easily access subsets of the data. Generally, we recommend working with one of these interfaces instead of the full data dump.

Publisher name: Home Office
Last updated: 2024-09-15T07:29:25Z

Tables

Street Level Crime (police.uk Data)

@ukgov.england_national_crime_mapping.street_level_crime_police_uk_data

10.45 MB
133059 rows
10 columns


CREATE TABLE street_level_crime_police_uk_data (
  "crime_id" VARCHAR,
  "month" TIMESTAMP,
  "reported_by" VARCHAR,
  "falls_within" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "lsoa_code" VARCHAR,
  "lsoa_name" VARCHAR,
  "outcome_type" VARCHAR
);