Cambridgeshire Road Traffic Collision Casualties By Mode Of Transport Counts by UK Government | Transportation and Logistics

About this Dataset

Cambridgeshire Road Traffic Collision Casualties By Mode Of Transport Counts

A series of data files containing counts of road traffic collision casualty counts across Cambridgeshire. There is a dataset for the county and each district broken down each month by the mode of transport of the casualty victim.

The data can be used to monitor levels of road traffic collision casualties across Cambridgeshire since January 2012.

Please note that these are police recorded road traffic collision casualties that have been recorded at the roadside or afterwards at the police station.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:14Z

Tables

East Cambridgeshire District Monthly Road Traffic Casualties By Transport Mode 2012 To 2017

@ukgov.cambridgeshire_road_traffic_collision_casualties_by_mo_b5c845df.east_cambridgeshire_district_monthly_road_traffic_casu_c222bf8d

38.66 KB
6 rows
69 columns


CREATE TABLE east_cambridgeshire_district_monthly_road_traffic_casu_c222bf8d (
  "east_cambs" VARCHAR,
  "jan_12" VARCHAR,
  "feb_12" VARCHAR,
  "mar_12" VARCHAR,
  "apr_12" VARCHAR,
  "may_12" VARCHAR,
  "jun_12" VARCHAR,
  "jul_12" VARCHAR,
  "aug_12" VARCHAR,
  "sep_12" VARCHAR,
  "oct_12" VARCHAR,
  "nov_12" VARCHAR,
  "dec_12" VARCHAR,
  "jan_13" VARCHAR,
  "feb_13" VARCHAR,
  "mar_13" VARCHAR,
  "apr_13" VARCHAR,
  "may_13" VARCHAR,
  "jun_13" VARCHAR,
  "jul_13" VARCHAR,
  "aug_13" VARCHAR,
  "sep_13" VARCHAR,
  "oct_13" VARCHAR,
  "nov_13" VARCHAR,
  "dec_13" VARCHAR,
  "jan_14" VARCHAR,
  "feb_14" VARCHAR,
  "mar_14" VARCHAR,
  "apr_14" VARCHAR,
  "may_14" VARCHAR,
  "jun_14" VARCHAR,
  "jul_14" VARCHAR,
  "aug_14" VARCHAR,
  "sep_14" VARCHAR,
  "oct_14" VARCHAR,
  "nov_14" VARCHAR,
  "dec_14" VARCHAR,
  "jan_15" VARCHAR,
  "feb_15" VARCHAR,
  "mar_15" VARCHAR,
  "apr_15" VARCHAR,
  "may_15" VARCHAR,
  "jun_15" VARCHAR,
  "jul_15" VARCHAR,
  "aug_15" VARCHAR,
  "sep_15" VARCHAR,
  "oct_15" VARCHAR,
  "nov_15" VARCHAR,
  "dec_15" VARCHAR,
  "jan_16" VARCHAR,
  "feb_16" VARCHAR,
  "mar_16" VARCHAR,
  "apr_16" VARCHAR,
  "may_16" VARCHAR,
  "jun_16" VARCHAR,
  "jul_16" VARCHAR,
  "aug_16" VARCHAR,
  "sep_16" VARCHAR,
  "oct_16" VARCHAR,
  "nov_16" VARCHAR,
  "dec_16" VARCHAR,
  "jan_17" VARCHAR,
  "feb_17" BIGINT,
  "mar_17" VARCHAR,
  "apr_17" VARCHAR,
  "may_17" VARCHAR,
  "jun_17" VARCHAR,
  "jul_17" VARCHAR,
  "aug_17" VARCHAR
);

Huntingdonshire District Monthly Road Traffic Casiualties By Transport Mode 2012 - 2017

@ukgov.cambridgeshire_road_traffic_collision_casualties_by_mo_b5c845df.huntingdonshire_district_monthly_road_traffic_casiualt_62d16535

39 KB
6 rows
69 columns


CREATE TABLE huntingdonshire_district_monthly_road_traffic_casiualt_62d16535 (
  "huntingdonshire" VARCHAR,
  "jan_12" VARCHAR,
  "feb_12" VARCHAR,
  "mar_12" VARCHAR,
  "apr_12" VARCHAR,
  "may_12" VARCHAR,
  "jun_12" VARCHAR,
  "jul_12" VARCHAR,
  "aug_12" VARCHAR,
  "sep_12" VARCHAR,
  "oct_12" VARCHAR,
  "nov_12" VARCHAR,
  "dec_12" VARCHAR,
  "jan_13" VARCHAR,
  "feb_13" VARCHAR,
  "mar_13" VARCHAR,
  "apr_13" VARCHAR,
  "may_13" VARCHAR,
  "jun_13" VARCHAR,
  "jul_13" VARCHAR,
  "aug_13" VARCHAR,
  "sep_13" VARCHAR,
  "oct_13" VARCHAR,
  "nov_13" VARCHAR,
  "dec_13" VARCHAR,
  "jan_14" VARCHAR,
  "feb_14" VARCHAR,
  "mar_14" VARCHAR,
  "apr_14" VARCHAR,
  "may_14" VARCHAR,
  "jun_14" VARCHAR,
  "jul_14" VARCHAR,
  "aug_14" VARCHAR,
  "sep_14" VARCHAR,
  "oct_14" VARCHAR,
  "nov_14" VARCHAR,
  "dec_14" VARCHAR,
  "jan_15" VARCHAR,
  "feb_15" VARCHAR,
  "mar_15" VARCHAR,
  "apr_15" VARCHAR,
  "may_15" VARCHAR,
  "jun_15" VARCHAR,
  "jul_15" VARCHAR,
  "aug_15" VARCHAR,
  "sep_15" VARCHAR,
  "oct_15" VARCHAR,
  "nov_15" VARCHAR,
  "dec_15" VARCHAR,
  "jan_16" VARCHAR,
  "feb_16" VARCHAR,
  "mar_16" VARCHAR,
  "apr_16" VARCHAR,
  "may_16" VARCHAR,
  "jun_16" VARCHAR,
  "jul_16" VARCHAR,
  "aug_16" VARCHAR,
  "sep_16" VARCHAR,
  "oct_16" VARCHAR,
  "nov_16" VARCHAR,
  "dec_16" VARCHAR,
  "jan_17" VARCHAR,
  "feb_17" VARCHAR,
  "mar_17" VARCHAR,
  "apr_17" VARCHAR,
  "may_17" VARCHAR,
  "jun_17" VARCHAR,
  "jul_17" VARCHAR,
  "aug_17" VARCHAR
);

South Cambridgeshire District Monthly Road Traffic Casualties By Transport Mode 2012 To 2017

@ukgov.cambridgeshire_road_traffic_collision_casualties_by_mo_b5c845df.south_cambridgeshire_district_monthly_road_traffic_cas_52201514

39.39 KB
6 rows
69 columns


CREATE TABLE south_cambridgeshire_district_monthly_road_traffic_cas_52201514 (
  "south_cambs" VARCHAR,
  "jan_12" VARCHAR,
  "feb_12" VARCHAR,
  "mar_12" VARCHAR,
  "apr_12" VARCHAR,
  "may_12" VARCHAR,
  "jun_12" VARCHAR,
  "jul_12" VARCHAR,
  "aug_12" VARCHAR,
  "sep_12" VARCHAR,
  "oct_12" VARCHAR,
  "nov_12" BIGINT,
  "dec_12" VARCHAR,
  "jan_13" VARCHAR,
  "feb_13" VARCHAR,
  "mar_13" VARCHAR,
  "apr_13" VARCHAR,
  "may_13" VARCHAR,
  "jun_13" BIGINT,
  "jul_13" VARCHAR,
  "aug_13" VARCHAR,
  "sep_13" BIGINT,
  "oct_13" VARCHAR,
  "nov_13" VARCHAR,
  "dec_13" VARCHAR,
  "jan_14" VARCHAR,
  "feb_14" VARCHAR,
  "mar_14" VARCHAR,
  "apr_14" VARCHAR,
  "may_14" VARCHAR,
  "jun_14" VARCHAR,
  "jul_14" BIGINT,
  "aug_14" VARCHAR,
  "sep_14" VARCHAR,
  "oct_14" VARCHAR,
  "nov_14" VARCHAR,
  "dec_14" VARCHAR,
  "jan_15" VARCHAR,
  "feb_15" VARCHAR,
  "mar_15" VARCHAR,
  "apr_15" VARCHAR,
  "may_15" VARCHAR,
  "jun_15" VARCHAR,
  "jul_15" BIGINT,
  "aug_15" VARCHAR,
  "sep_15" VARCHAR,
  "oct_15" VARCHAR,
  "nov_15" VARCHAR,
  "dec_15" VARCHAR,
  "jan_16" VARCHAR,
  "feb_16" VARCHAR,
  "mar_16" VARCHAR,
  "apr_16" VARCHAR,
  "may_16" VARCHAR,
  "jun_16" VARCHAR,
  "jul_16" VARCHAR,
  "aug_16" VARCHAR,
  "sep_16" VARCHAR,
  "oct_16" VARCHAR,
  "nov_16" VARCHAR,
  "dec_16" VARCHAR,
  "jan_17" VARCHAR,
  "feb_17" VARCHAR,
  "mar_17" VARCHAR,
  "apr_17" VARCHAR,
  "may_17" VARCHAR,
  "jun_17" VARCHAR,
  "jul_17" VARCHAR,
  "aug_17" VARCHAR
);

Cambridge City District Monthly Road Traffic Casualties By Transport Mode 2012 To 2017

@ukgov.cambridgeshire_road_traffic_collision_casualties_by_mo_b5c845df.cambridge_city_district_monthly_road_traffic_casualtie_f72b4409

39.23 KB
6 rows
69 columns


CREATE TABLE cambridge_city_district_monthly_road_traffic_casualtie_f72b4409 (
  "cambridge" VARCHAR,
  "jan_12" VARCHAR,
  "feb_12" VARCHAR,
  "mar_12" VARCHAR,
  "apr_12" VARCHAR,
  "may_12" VARCHAR,
  "jun_12" VARCHAR,
  "jul_12" VARCHAR,
  "aug_12" VARCHAR,
  "sep_12" VARCHAR,
  "oct_12" VARCHAR,
  "nov_12" VARCHAR,
  "dec_12" VARCHAR,
  "jan_13" VARCHAR,
  "feb_13" VARCHAR,
  "mar_13" VARCHAR,
  "apr_13" VARCHAR,
  "may_13" VARCHAR,
  "jun_13" VARCHAR,
  "jul_13" BIGINT,
  "aug_13" VARCHAR,
  "sep_13" VARCHAR,
  "oct_13" VARCHAR,
  "nov_13" VARCHAR,
  "dec_13" VARCHAR,
  "jan_14" VARCHAR,
  "feb_14" VARCHAR,
  "mar_14" VARCHAR,
  "apr_14" VARCHAR,
  "may_14" BIGINT,
  "jun_14" VARCHAR,
  "jul_14" VARCHAR,
  "aug_14" VARCHAR,
  "sep_14" VARCHAR,
  "oct_14" VARCHAR,
  "nov_14" VARCHAR,
  "dec_14" VARCHAR,
  "jan_15" VARCHAR,
  "feb_15" VARCHAR,
  "mar_15" VARCHAR,
  "apr_15" VARCHAR,
  "may_15" VARCHAR,
  "jun_15" VARCHAR,
  "jul_15" VARCHAR,
  "aug_15" VARCHAR,
  "sep_15" VARCHAR,
  "oct_15" VARCHAR,
  "nov_15" VARCHAR,
  "dec_15" VARCHAR,
  "jan_16" VARCHAR,
  "feb_16" VARCHAR,
  "mar_16" VARCHAR,
  "apr_16" VARCHAR,
  "may_16" VARCHAR,
  "jun_16" VARCHAR,
  "jul_16" VARCHAR,
  "aug_16" VARCHAR,
  "sep_16" VARCHAR,
  "oct_16" VARCHAR,
  "nov_16" VARCHAR,
  "dec_16" VARCHAR,
  "jan_17" VARCHAR,
  "feb_17" VARCHAR,
  "mar_17" VARCHAR,
  "apr_17" VARCHAR,
  "may_17" VARCHAR,
  "jun_17" VARCHAR,
  "jul_17" VARCHAR,
  "aug_17" VARCHAR
);

Fenland District Monthly Road Traffic Casualties By Transport Mode 2012 To 2017

@ukgov.cambridgeshire_road_traffic_collision_casualties_by_mo_b5c845df.fenland_district_monthly_road_traffic_casualties_by_tr_1732d4a6

38.65 KB
6 rows
69 columns


CREATE TABLE fenland_district_monthly_road_traffic_casualties_by_tr_1732d4a6 (
  "fenland" VARCHAR,
  "jan_12" VARCHAR,
  "feb_12" VARCHAR,
  "mar_12" VARCHAR,
  "apr_12" VARCHAR,
  "may_12" VARCHAR,
  "jun_12" VARCHAR,
  "jul_12" VARCHAR,
  "aug_12" VARCHAR,
  "sep_12" VARCHAR,
  "oct_12" VARCHAR,
  "nov_12" VARCHAR,
  "dec_12" VARCHAR,
  "jan_13" VARCHAR,
  "feb_13" VARCHAR,
  "mar_13" VARCHAR,
  "apr_13" VARCHAR,
  "may_13" VARCHAR,
  "jun_13" VARCHAR,
  "jul_13" VARCHAR,
  "aug_13" VARCHAR,
  "sep_13" VARCHAR,
  "oct_13" VARCHAR,
  "nov_13" VARCHAR,
  "dec_13" VARCHAR,
  "jan_14" VARCHAR,
  "feb_14" VARCHAR,
  "mar_14" VARCHAR,
  "apr_14" VARCHAR,
  "may_14" VARCHAR,
  "jun_14" VARCHAR,
  "jul_14" VARCHAR,
  "aug_14" VARCHAR,
  "sep_14" VARCHAR,
  "oct_14" VARCHAR,
  "nov_14" VARCHAR,
  "dec_14" VARCHAR,
  "jan_15" VARCHAR,
  "feb_15" VARCHAR,
  "mar_15" VARCHAR,
  "apr_15" VARCHAR,
  "may_15" VARCHAR,
  "jun_15" VARCHAR,
  "jul_15" VARCHAR,
  "aug_15" VARCHAR,
  "sep_15" VARCHAR,
  "oct_15" VARCHAR,
  "nov_15" VARCHAR,
  "dec_15" VARCHAR,
  "jan_16" VARCHAR,
  "feb_16" VARCHAR,
  "mar_16" VARCHAR,
  "apr_16" VARCHAR,
  "may_16" VARCHAR,
  "jun_16" VARCHAR,
  "jul_16" VARCHAR,
  "aug_16" VARCHAR,
  "sep_16" VARCHAR,
  "oct_16" BIGINT,
  "nov_16" VARCHAR,
  "dec_16" VARCHAR,
  "jan_17" VARCHAR,
  "feb_17" VARCHAR,
  "mar_17" VARCHAR,
  "apr_17" VARCHAR,
  "may_17" VARCHAR,
  "jun_17" VARCHAR,
  "jul_17" VARCHAR,
  "aug_17" VARCHAR
);

Cambridgeshire Monthly Road Traffic Casualties By Mode Of Transport 2012 To 2017

@ukgov.cambridgeshire_road_traffic_collision_casualties_by_mo_b5c845df.cambridgeshire_monthly_road_traffic_casualties_by_mode_c2ebc819

45.54 KB
6 rows
69 columns


CREATE TABLE cambridgeshire_monthly_road_traffic_casualties_by_mode_c2ebc819 (
  "cambridgeshire" VARCHAR,
  "jan_12" BIGINT,
  "feb_12" BIGINT,
  "mar_12" BIGINT,
  "apr_12" BIGINT,
  "may_12" BIGINT,
  "jun_12" BIGINT,
  "jul_12" BIGINT,
  "aug_12" BIGINT,
  "sep_12" BIGINT,
  "oct_12" BIGINT,
  "nov_12" BIGINT,
  "dec_12" BIGINT,
  "jan_13" BIGINT,
  "feb_13" BIGINT,
  "mar_13" BIGINT,
  "apr_13" BIGINT,
  "may_13" BIGINT,
  "jun_13" VARCHAR,
  "jul_13" BIGINT,
  "aug_13" BIGINT,
  "sep_13" BIGINT,
  "oct_13" BIGINT,
  "nov_13" BIGINT,
  "dec_13" BIGINT,
  "jan_14" BIGINT,
  "feb_14" BIGINT,
  "mar_14" BIGINT,
  "apr_14" BIGINT,
  "may_14" BIGINT,
  "jun_14" BIGINT,
  "jul_14" BIGINT,
  "aug_14" BIGINT,
  "sep_14" BIGINT,
  "oct_14" BIGINT,
  "nov_14" BIGINT,
  "dec_14" BIGINT,
  "jan_15" BIGINT,
  "feb_15" VARCHAR,
  "mar_15" BIGINT,
  "apr_15" BIGINT,
  "may_15" BIGINT,
  "jun_15" BIGINT,
  "jul_15" BIGINT,
  "aug_15" VARCHAR,
  "sep_15" BIGINT,
  "oct_15" BIGINT,
  "nov_15" BIGINT,
  "dec_15" BIGINT,
  "jan_16" BIGINT,
  "feb_16" BIGINT,
  "mar_16" BIGINT,
  "apr_16" BIGINT,
  "may_16" BIGINT,
  "jun_16" BIGINT,
  "jul_16" BIGINT,
  "aug_16" BIGINT,
  "sep_16" BIGINT,
  "oct_16" BIGINT,
  "nov_16" BIGINT,
  "dec_16" BIGINT,
  "jan_17" BIGINT,
  "feb_17" BIGINT,
  "mar_17" BIGINT,
  "apr_17" BIGINT,
  "may_17" BIGINT,
  "jun_17" BIGINT,
  "jul_17" BIGINT,
  "aug_17" BIGINT
);