Baselight
Sign In

Cambridgeshire Crime Counts And Rates

Cambridgeshire Insight

@ukgov.cambridgeshire_crime_counts_and_rates2

Loading...
Loading...

About this Dataset

Cambridgeshire Crime Counts And Rates

Cambridgeshire crime counts and rates data provides crime and community safety data and analysis for Cambridgeshire. This ward level data covers a range of community safety related topics.

A Cambridgeshire Atlas displaying the data can be found here.

Source: Raw data is provided by Cambridgeshire Constabulary (iBase), analyis is conducted by the Cambridgeshire Research Group.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:42:05Z

Tables

Count Of Crime In Cambridgeshire By Financial Year, 2013/14

@ukgov.cambridgeshire_crime_counts_and_rates2.count_of_crime_in_cambridgeshire_by_financial_year_2013_14
  • 88.67 KB
  • 131 rows
  • 65 columns
Loading... 

CREATE TABLE count_of_crime_in_cambridgeshire_by_financial_year_2013_14 (
  "ward_code" VARCHAR,
  "wardname" VARCHAR,
  "total_crime_rate_2007_2008" DOUBLE,
  "total_crime_rate_2008_2009" DOUBLE,
  "total_crime_rate_2009_2010" DOUBLE,
  "total_crime_rate_2010_2011" DOUBLE,
  "total_crime_rate_2011_2012" DOUBLE,
  "total_crime_rate_2012_2013" DOUBLE,
  "total_crime_rate_2013_2014" DOUBLE,
  "asb_rate_2007_2008" DOUBLE,
  "asb_rate_2008_2009" DOUBLE,
  "asb_rate_2009_2010" DOUBLE,
  "asb_rate_2010_2011" DOUBLE,
  "asb_rate_2011_2012" DOUBLE,
  "asb_rate_2012_2013" DOUBLE,
  "asb_rate_2013_2014" DOUBLE,
  "burglary_dwelling_rate_2007_2008" DOUBLE,
  "burglary_dwelling_rate_2008_2009" DOUBLE,
  "burglary_dwelling_rate_2009_2010" DOUBLE,
  "burglary_dwelling_rate_2010_2011" DOUBLE,
  "burglary_dwelling_rate_2011_2012" DOUBLE,
  "burglary_dwelling_rate_2012_2013" DOUBLE,
  "burglary_dwelling_rate_2013_2014" DOUBLE,
  "criminal_damage_rate_2007_2008" DOUBLE,
  "criminal_damage_rate_2008_2009" DOUBLE,
  "criminal_damage_rate_2009_2010" DOUBLE,
  "criminal_damage_rate_2010_2011" DOUBLE,
  "criminal_damage_rate_2011_2012" DOUBLE,
  "criminal_damage_rate_2012_2013" DOUBLE,
  "criminal_damage_rate_2013_2014" DOUBLE,
  "domestic_abuse_rate_2007_2008" DOUBLE,
  "domestic_abuse_rate_2008_2009" DOUBLE,
  "domestic_abuse_rate_2009_2010" DOUBLE,
  "domestic_abuse_rate_2010_2011" DOUBLE,
  "domestic_abuse_rate_2011_2012" DOUBLE,
  "domestic_abuse_rate_2012_2013" DOUBLE,
  "domestic_abuse_rate_2013_2014" DOUBLE,
  "theft_of_pedal_cycles_rate_2007_2008" DOUBLE,
  "theft_of_pedal_cycles_rate_2008_2009" DOUBLE,
  "theft_of_pedal_cycles_rate_2009_2010" DOUBLE,
  "theft_of_pedal_cycles_rate_2010_2011" DOUBLE,
  "theft_of_pedal_cycles_rate_2011_2012" DOUBLE,
  "theft_of_pedal_cycles_rate_2012_2013" DOUBLE,
  "theft_of_pedal_cycles_rate_2013_2014" DOUBLE,
  "vehicle_crime_rate_2007_2008" DOUBLE,
  "vehicle_crime_rate_2008_2009" DOUBLE,
  "vehicle_crime_rate_2009_2010" DOUBLE,
  "vehicle_crime_rate_2010_2011" DOUBLE,
  "vehicle_crime_rate_2011_2012" DOUBLE,
  "vehicle_crime_rate_2012_2013" DOUBLE,
  "vehicle_crime_rate_2013_2014" DOUBLE,
  "violence_against_a_person_rate_2007_2008" DOUBLE,
  "violence_against_a_person_rate_2008_2009" DOUBLE,
  "violence_against_a_person_rate_2009_2010" DOUBLE,
  "violence_against_a_person_rate_2010_2011" DOUBLE,
  "violence_against_a_person_rate_2011_2012" DOUBLE,
  "violence_against_a_person_rate_2012_2013" DOUBLE,
  "violence_against_a_person_rate_2013_2014" DOUBLE,
  "violent_crime_rate_2007_2008" DOUBLE,
  "violent_crime_rate_2008_2009" DOUBLE,
  "violent_crime_rate_2009_2010" DOUBLE,
  "violent_crime_rate_2010_2011" DOUBLE,
  "violent_crime_rate_2011_2012" DOUBLE,
  "violent_crime_rate_2012_2013" DOUBLE,
  "violent_crime_rate_2013_2014" DOUBLE
);

Count Of Crime In Cambridgeshire By Financial Year, 2014/15

@ukgov.cambridgeshire_crime_counts_and_rates2.count_of_crime_in_cambridgeshire_by_financial_year_2014_15
  • 108.22 KB
  • 131 rows
  • 83 columns
Loading... 

CREATE TABLE count_of_crime_in_cambridgeshire_by_financial_year_2014_15 (
  "wardcode" VARCHAR,
  "wardname" VARCHAR,
  "total_crime_count_2007_2008" DOUBLE,
  "total_crime_count_2008_2009" DOUBLE,
  "total_crime_count_2009_2010" DOUBLE,
  "total_crime_count_2010_2011" DOUBLE,
  "total_crime_count_2011_2012" DOUBLE,
  "total_crime_count_2012_2013" DOUBLE,
  "total_crime_count_2013_2014" DOUBLE,
  "total_crime_count_2014_2015" DOUBLE,
  "asb_count_2007_2008" DOUBLE,
  "asb_count_2008_2009" DOUBLE,
  "asb_count_2009_2010" DOUBLE,
  "asb_count_2010_2011" DOUBLE,
  "asb_count_2011_2012" DOUBLE,
  "asb_count_2012_2013" DOUBLE,
  "asb_count_2013_2014" DOUBLE,
  "asb_count_2014_2015" DOUBLE,
  "burglary_dwelling_count_2007_2008" DOUBLE,
  "burglary_dwelling_count_2008_2009" DOUBLE,
  "burglary_dwelling_count_2009_2010" DOUBLE,
  "burglary_dwelling_count_2010_2011" DOUBLE,
  "burglary_dwelling_count_2011_2012" DOUBLE,
  "burglary_dwelling_count_2012_2013" DOUBLE,
  "burglary_dwelling_count_2013_2014" DOUBLE,
  "burglary_dwelling_count_2014_2015" DOUBLE,
  "criminal_damage_count_2007_2008" DOUBLE,
  "criminal_damage_count_2008_2009" DOUBLE,
  "criminal_damage_count_2009_2010" DOUBLE,
  "criminal_damage_count_2010_2011" DOUBLE,
  "criminal_damage_count_2011_2012" DOUBLE,
  "criminal_damage_count_2012_2013" DOUBLE,
  "criminal_damage_count_2013_2014" DOUBLE,
  "criminal_damage_count_2014_2015" DOUBLE,
  "deliberate_fires_count_2008_2009" DOUBLE,
  "deliberate_fires_count_2009_2010" DOUBLE,
  "deliberate_fires_count_2010_2011" DOUBLE,
  "deliberate_fires_count_2011_2012" DOUBLE,
  "deliberate_fires_count_2012_2013" DOUBLE,
  "deliberate_fires_count_2013_2014" DOUBLE,
  "deliberate_fires_count_2014_2015" DOUBLE,
  "domestic_abuse_count_2007_2008" DOUBLE,
  "domestic_abuse_count_2008_2009" DOUBLE,
  "domestic_abuse_count_2009_2010" DOUBLE,
  "domestic_abuse_count_2010_2011" DOUBLE,
  "domestic_abuse_count_2011_2012" DOUBLE,
  "domestic_abuse_count_2012_2013" DOUBLE,
  "domestic_abuse_count_2013_2014" DOUBLE,
  "domestic_abuse_count_2014_2015" DOUBLE,
  "theft_of_pedal_cycles_count_2007_2008" DOUBLE,
  "theft_of_pedal_cycles_count_2008_2009" DOUBLE,
  "theft_of_pedal_cycles_count_2009_2010" DOUBLE,
  "theft_of_pedal_cycles_count_2010_2011" DOUBLE,
  "theft_of_pedal_cycles_count_2011_2012" DOUBLE,
  "theft_of_pedal_cycles_count_2012_2013" DOUBLE,
  "theft_of_pedal_cycles_count_2013_2014" DOUBLE,
  "theft_of_pedal_cycles_count_2014_2015" DOUBLE,
  "vehicle_crime_count_2007_2008" DOUBLE,
  "vehicle_crime_count_2008_2009" DOUBLE,
  "vehicle_crime_count_2009_2010" DOUBLE,
  "vehicle_crime_count_2010_2011" DOUBLE,
  "vehicle_crime_count_2011_2012" DOUBLE,
  "vehicle_crime_count_2012_2013" DOUBLE,
  "vehicle_crime_count_2013_2014" DOUBLE,
  "vehicle_crime_count_2014_2015" DOUBLE,
  "violence_against_the_person_count_2007_2008" DOUBLE,
  "violence_against_the_person_count_2008_2009" DOUBLE,
  "violence_against_the_person_count_2009_2010" DOUBLE,
  "violence_against_the_person_count_2010_2011" DOUBLE,
  "violence_against_the_person_count_2011_2012" DOUBLE,
  "violence_against_the_person_count_2012_2013" DOUBLE,
  "violence_against_the_person_count_2013_2014" DOUBLE,
  "violence_against_the_person_count_2014_2015" DOUBLE,
  "violent_crime_count_2007_2008" DOUBLE,
  "violent_crime_count_2008_2009" DOUBLE,
  "violent_crime_count_2009_2010" DOUBLE,
  "violent_crime_count_2010_2011" DOUBLE,
  "violent_crime_count_2011_2012" DOUBLE,
  "violent_crime_count_2012_2013" DOUBLE,
  "violent_crime_count_2013_2014" DOUBLE,
  "violent_crime_count_2014_2015" DOUBLE,
  "total_crime_rate_2007_2008" DOUBLE,
  "total_crime_rate_2008_2009" DOUBLE
);

Rate Of Crime In Cambridgeshire By Financial Year, 2013/14

@ukgov.cambridgeshire_crime_counts_and_rates2.rate_of_crime_in_cambridgeshire_by_financial_year_2013_14
  • 88.67 KB
  • 131 rows
  • 65 columns
Loading... 

CREATE TABLE rate_of_crime_in_cambridgeshire_by_financial_year_2013_14 (
  "ward_code" VARCHAR,
  "wardname" VARCHAR,
  "total_crime_rate_2007_2008" DOUBLE,
  "total_crime_rate_2008_2009" DOUBLE,
  "total_crime_rate_2009_2010" DOUBLE,
  "total_crime_rate_2010_2011" DOUBLE,
  "total_crime_rate_2011_2012" DOUBLE,
  "total_crime_rate_2012_2013" DOUBLE,
  "total_crime_rate_2013_2014" DOUBLE,
  "asb_rate_2007_2008" DOUBLE,
  "asb_rate_2008_2009" DOUBLE,
  "asb_rate_2009_2010" DOUBLE,
  "asb_rate_2010_2011" DOUBLE,
  "asb_rate_2011_2012" DOUBLE,
  "asb_rate_2012_2013" DOUBLE,
  "asb_rate_2013_2014" DOUBLE,
  "burglary_dwelling_rate_2007_2008" DOUBLE,
  "burglary_dwelling_rate_2008_2009" DOUBLE,
  "burglary_dwelling_rate_2009_2010" DOUBLE,
  "burglary_dwelling_rate_2010_2011" DOUBLE,
  "burglary_dwelling_rate_2011_2012" DOUBLE,
  "burglary_dwelling_rate_2012_2013" DOUBLE,
  "burglary_dwelling_rate_2013_2014" DOUBLE,
  "criminal_damage_rate_2007_2008" DOUBLE,
  "criminal_damage_rate_2008_2009" DOUBLE,
  "criminal_damage_rate_2009_2010" DOUBLE,
  "criminal_damage_rate_2010_2011" DOUBLE,
  "criminal_damage_rate_2011_2012" DOUBLE,
  "criminal_damage_rate_2012_2013" DOUBLE,
  "criminal_damage_rate_2013_2014" DOUBLE,
  "domestic_abuse_rate_2007_2008" DOUBLE,
  "domestic_abuse_rate_2008_2009" DOUBLE,
  "domestic_abuse_rate_2009_2010" DOUBLE,
  "domestic_abuse_rate_2010_2011" DOUBLE,
  "domestic_abuse_rate_2011_2012" DOUBLE,
  "domestic_abuse_rate_2012_2013" DOUBLE,
  "domestic_abuse_rate_2013_2014" DOUBLE,
  "theft_of_pedal_cycles_rate_2007_2008" DOUBLE,
  "theft_of_pedal_cycles_rate_2008_2009" DOUBLE,
  "theft_of_pedal_cycles_rate_2009_2010" DOUBLE,
  "theft_of_pedal_cycles_rate_2010_2011" DOUBLE,
  "theft_of_pedal_cycles_rate_2011_2012" DOUBLE,
  "theft_of_pedal_cycles_rate_2012_2013" DOUBLE,
  "theft_of_pedal_cycles_rate_2013_2014" DOUBLE,
  "vehicle_crime_rate_2007_2008" DOUBLE,
  "vehicle_crime_rate_2008_2009" DOUBLE,
  "vehicle_crime_rate_2009_2010" DOUBLE,
  "vehicle_crime_rate_2010_2011" DOUBLE,
  "vehicle_crime_rate_2011_2012" DOUBLE,
  "vehicle_crime_rate_2012_2013" DOUBLE,
  "vehicle_crime_rate_2013_2014" DOUBLE,
  "violence_against_a_person_rate_2007_2008" DOUBLE,
  "violence_against_a_person_rate_2008_2009" DOUBLE,
  "violence_against_a_person_rate_2009_2010" DOUBLE,
  "violence_against_a_person_rate_2010_2011" DOUBLE,
  "violence_against_a_person_rate_2011_2012" DOUBLE,
  "violence_against_a_person_rate_2012_2013" DOUBLE,
  "violence_against_a_person_rate_2013_2014" DOUBLE,
  "violent_crime_rate_2007_2008" DOUBLE,
  "violent_crime_rate_2008_2009" DOUBLE,
  "violent_crime_rate_2009_2010" DOUBLE,
  "violent_crime_rate_2010_2011" DOUBLE,
  "violent_crime_rate_2011_2012" DOUBLE,
  "violent_crime_rate_2012_2013" DOUBLE,
  "violent_crime_rate_2013_2014" DOUBLE
);

Rate Of Crime In Cambridgeshire By Financial Year, 2014/15

@ukgov.cambridgeshire_crime_counts_and_rates2.rate_of_crime_in_cambridgeshire_by_financial_year_2014_15
  • 113.86 KB
  • 131 rows
  • 72 columns
Loading... 

CREATE TABLE rate_of_crime_in_cambridgeshire_by_financial_year_2014_15 (
  "wardcode" VARCHAR,
  "wardname" VARCHAR,
  "total_crime_rate_2009_2010" DOUBLE,
  "total_crime_rate_2010_2011" DOUBLE,
  "total_crime_rate_2011_2012" DOUBLE,
  "total_crime_rate_2012_2013" DOUBLE,
  "total_crime_rate_2013_2014" DOUBLE,
  "total_crime_rate_2014_2015" DOUBLE,
  "asb_rate_2007_2008" DOUBLE,
  "asb_rate_2008_2009" DOUBLE,
  "asb_rate_2009_2010" DOUBLE,
  "asb_rate_2010_2011" DOUBLE,
  "asb_rate_2011_2012" DOUBLE,
  "asb_rate_2012_2013" DOUBLE,
  "asb_rate_2013_2014" DOUBLE,
  "asb_rate_2014_2015" DOUBLE,
  "burglary_dwelling_rate_2007_2008" DOUBLE,
  "burglary_dwelling_rate_2008_2009" VARCHAR,
  "burglary_dwelling_rate_2009_2010" DOUBLE,
  "burglary_dwelling_rate_2010_2011" DOUBLE,
  "burglary_dwelling_rate_2011_2012" DOUBLE,
  "burglary_dwelling_rate_2012_2013" DOUBLE,
  "burglary_dwelling_rate_2013_2014" DOUBLE,
  "burglary_dwelling_rate_2014_2015" DOUBLE,
  "criminal_damage_rate_2007_2008" DOUBLE,
  "criminal_damage_rate_2008_2009" DOUBLE,
  "criminal_damage_rate_2009_2010" DOUBLE,
  "criminal_damage_rate_2010_2011" DOUBLE,
  "criminal_damage_rate_2011_2012" DOUBLE,
  "criminal_damage_rate_2012_2013" DOUBLE,
  "criminal_damage_rate_2013_2014" DOUBLE,
  "criminal_damage_rate_2014_2015" DOUBLE,
  "domestic_abuse_rate_2007_2008" DOUBLE,
  "domestic_abuse_rate_2008_2009" DOUBLE,
  "domestic_abuse_rate_2009_2010" DOUBLE,
  "domestic_abuse_rate_2010_2011" DOUBLE,
  "domestic_abuse_rate_2011_2012" DOUBLE,
  "domestic_abuse_rate_2012_2013" DOUBLE,
  "domestic_abuse_rate_2013_2014" DOUBLE,
  "domestic_abuse_rate_2014_2015" DOUBLE,
  "theft_of_pedal_cycles_rate_2007_2008" DOUBLE,
  "theft_of_pedal_cycles_rate_2008_2009" DOUBLE,
  "theft_of_pedal_cycles_rate_2009_2010" DOUBLE,
  "theft_of_pedal_cycles_rate_2010_2011" DOUBLE,
  "theft_of_pedal_cycles_rate_2011_2012" DOUBLE,
  "theft_of_pedal_cycles_rate_2012_2013" DOUBLE,
  "theft_of_pedal_cycles_rate_2013_2014" DOUBLE,
  "theft_of_pedal_cycles_rate_2014_2015" DOUBLE,
  "vehicle_crime_rate_2007_2008" DOUBLE,
  "vehicle_crime_rate_2008_2009" DOUBLE,
  "vehicle_crime_rate_2009_2010" DOUBLE,
  "vehicle_crime_rate_2010_2011" DOUBLE,
  "vehicle_crime_rate_2011_2012" DOUBLE,
  "vehicle_crime_rate_2012_2013" DOUBLE,
  "vehicle_crime_rate_2013_2014" DOUBLE,
  "vehicle_crime_rate_2014_2015" DOUBLE,
  "violence_against_the_person_rate_2007_2008" DOUBLE,
  "violence_against_the_person_rate_2008_2009" DOUBLE,
  "violence_against_the_person_rate_2009_2010" DOUBLE,
  "violence_against_the_person_rate_2010_2011" DOUBLE,
  "violence_against_the_person_rate_2011_2012" DOUBLE,
  "violence_against_the_person_rate_2012_2013" DOUBLE,
  "violence_against_the_person_rate_2013_2014" DOUBLE,
  "violence_against_the_person_rate_2014_2015" DOUBLE,
  "violent_crime_rate_2007_2008" DOUBLE,
  "violent_crime_rate_2008_2009" DOUBLE,
  "violent_crime_rate_2009_2010" DOUBLE,
  "violent_crime_rate_2010_2011" DOUBLE,
  "violent_crime_rate_2011_2012" DOUBLE,
  "violent_crime_rate_2012_2013" DOUBLE,
  "violent_crime_rate_2013_2014" DOUBLE,
  "violent_crime_rate_2014_2015" DOUBLE
);

Share link

Anyone who has the link will be able to view this.