Baselight
Sign In

Cambridgeshire Road Traffic Collision Casualties By Mode Of Transport Counts

Cambridgeshire Insight

@ukgov.cambridgeshire_road_traffic_collision_casualties_by_mo_b5c845df

Loading...
Loading...

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

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
  • 40.17 kB
  • 6 rows
  • 69 columns
Loading... 
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
);

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
  • 46.63 kB
  • 6 rows
  • 69 columns
Loading... 
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
);

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
  • 39.58 kB
  • 6 rows
  • 69 columns
Loading... 
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
);

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
  • 39.58 kB
  • 6 rows
  • 69 columns
Loading... 
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
);

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.93 kB
  • 6 rows
  • 69 columns
Loading... 
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
  • 40.34 kB
  • 6 rows
  • 69 columns
Loading... 
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
);

Share link

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