Name: Crime
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Crime

Data showing the amount and type of crime committed in Plymouth.
Publisher name: Plymouth City Council
Last updated: 2022-07-01T04:04:31Z

Tables

Crime - Plymouth 2003-2015

@ukgov.crime1.crime_plymouth_2003_2015

11.67 kB
19 rows
14 columns

CREATE TABLE crime_plymouth_2003_2015 (
  "offence" VARCHAR,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015
);