Baselight
Sign In

Road Traffic Collisions: Location

Cambridgeshire Insight

@ukgov.road_traffic_collisions_location1

About this Dataset

Road Traffic Collisions: Location

Information on collisions across Cambridgeshire. Data includes location, number of people and vehicles involved, road surface, weather conditions and severity of any casualties.

Data is currently available between 01/01/2012 and 31/12/2018 in the spreadsheets linked below. Read on for information as to how to obtain more recent collision data.

Please note that collision data from the last five years is updated monthlyvia this link.

We also update this collision map on a monthly basis. The page contains further detail on how to obtain collision data from Cambridgeshire County Council on a self-serve basis.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:14Z

Tables

Road Traffic Collisions 2018

@ukgov.road_traffic_collisions_location1.road_traffic_collisions_2018
  • 112.27 KB
  • 1802 rows
  • 34 columns
Loading...
 

CREATE TABLE road_traffic_collisions_2018 (
  "date" BIGINT,
  "police_ref" BIGINT,
  "easting" BIGINT,
  "northing" BIGINT,
  "severity" VARCHAR,
  "road_cond" VARCHAR,
  "visibility" VARCHAR,
  "casualties" BIGINT,
  "pedestrian" BIGINT,
  "cycles" BIGINT,
  "p2w" BIGINT,
  "oaps" BIGINT,
  "children" BIGINT,
  "manoeuvre" VARCHAR,
  "time" VARCHAR,
  "vehicles" BIGINT,
  "roadclass1" VARCHAR,
  "roadnum1" BIGINT,
  "road_type" VARCHAR,
  "speed_lim" BIGINT,
  "junct_det" VARCHAR,
  "junct_ctrl" VARCHAR,
  "roadclass2" VARCHAR,
  "roadnum2" BIGINT,
  "cross_ctrl" VARCHAR,
  "cross_fac" VARCHAR,
  "weather" VARCHAR,
  "spcond" BIGINT,
  "carr_haz" VARCHAR,
  "day" VARCHAR,
  "location" VARCHAR,
  "local_auth" VARCHAR,
  "reportedat" VARCHAR,
  "parish" BIGINT
);