About this Dataset

On Street Crime In Camden

This dataset contains on street crimes provided by the Police via their API (https://data.police.uk/docs/). The data is clipped to the London Borough of Camden boundary, and can contain up to fifteen types of street crime including bicycle theft, shoplifting and criminal damage. The London Borough of Camden does not maintain the content of this dataset.
Publisher name: London Borough of Camden
Last updated: 2025-04-07T04:00:03Z

Tables

Table 1

@ukgov.on_street_crime_in_camden.table_1

31.47 MB
456,852 rows
20 columns

CREATE TABLE table_1 (
  "category" VARCHAR,
  "street_id" BIGINT,
  "street_name" VARCHAR,
  "context" VARCHAR,
  "outcome_category" VARCHAR,
  "outcome_date" VARCHAR,
  "service" VARCHAR,
  "location_subtype" VARCHAR,
  "id" BIGINT,
  "persistent_id" VARCHAR,
  "epoch" VARCHAR,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" TIMESTAMP,
  "location" VARCHAR
);