Cambridgeshire Road Traffic Collision Data
Where does the data come from?
Road traffic collision records are provided to CCC by the police. The records are cleaned by CCC officers before being included in CCC’s road traffic collision database. The dataset only includes collisions that meet the Department for Transport STATS19 definition of a road traffic collision:
“Involves personal injury occurring on the public highway (including footways) in which at least one road vehicle or a vehicle in collision with a pedestrian is involved and which becomes known to the police within 30 days of its occurrence. Damage-only accidents, with no human casualties or accidents on private roads or car parks are not included.”
For further information about collision reporting and data collection, please refer to the Department for Transport STATS 19 and STATS 20 guidance.
How up to date is the data?
The road traffic collision data is available in two versions:
- The provisional dataset which is updated on a monthly basis. This dataset includes the most recent records and gives a more up to date picture but data from the most recent 12-18 months is marked as provisional because it is subject to change. The provisional dataset is available to view and download on Cambridgeshire Insight and is the dataset described on this page.
- The finalised dataset is approved by DfT in summer or early autumn each year for the previous calendar year. This dataset is more stable but doesn’t provide the latest picture due to being updated on an annual basis. DfT have currently approved data up to Dec 2021 and we expect the 2022 data to be approved by the end of September 2023. The DfT-approved dataset is available to view on Maps Cambridgeshire.
How can I access the provisional dataset?
If you require up to date collision data, there is the option to self-serve (download) the provisional data from the Open Data Portal (free) or you can make a request for data to be provided by the Cambridgeshire County Council Research Group (chargeable), as detailed in the following sections.
The map below shows the locations of all personal injury road traffic collisions (STATS19 definition) that were reported to the police in Cambridgeshire from January 2017 to August 2023. The map legend can be viewed and different years switched on/off by clicking the double arrow button on the left hand side. Please note, the collision data for 2022 and 2023 is currently provisional and is therefore subject to change.
Last updated with data to the end of August 2023 on 10/11/2023.
Self-serve collision data (free-of-charge)
Road traffic collision data for Cambridgeshire is available for immediate, free-of-charge download on the Cambridgeshire Insight Open Data Portal. The data is available to download in Excel and Shapefile formats. A shapefile can be loaded using CAD or GIS software.
Please note, the data that’s publicly available to download on the Open Data Portal:
- is currently provisional for 2022 and 2023 and is therefore subject to change.
- doesn’t include collision descriptions or contributory factors – we are only permitted to share this information with parties engaged in accident investigation, accident remedial works and/or safety engineering.
If you are unable to use the self-serve option, please make a request to the Research Group using the steps below.
Request collision data (chargeable)
If you are unable to self-serve collision data from the Open Data Portal, you can make a request for data to the Research Group. The provision of collision data is a chargeable process, unless you are working on behalf of CCC.
From 1st January 2023, a £350+VAT standing charge will apply to all collision data requests that are fulfilled by the CCC Research Group on behalf of external parties. The standing charge covers the data query and the supply of the data in Excel and/or Shapefile format. The following extra fees will also apply where appropriate:
- Larger requests exceeding 1,000 collisions (£100+VAT per additional 500 collisions).
- Alternative data export formats (£400+VAT).
- A labelled PDF map of collisions:
- Up to 25 collisions: £350+VAT
- 26-50 collisions: £375+VAT
- 51-75 collisions: £400+VAT
- 76-100 collisions: £425+VAT
- 101-150 collisions: £450+VAT
- 151-200 collisions: £475+VAT
- 201-250 collisions: £500+VAT
- 251+ collisions: Not available.
How to request collision data:
1. Check the collision data map
Please use the map above to view your area of interest and ascertain whether there are any collisions recorded. If there are no collisions on the map in your area of interest, we do not have a record of any personal injury collisions in this area since 2017.
2. Look at the charging structure
If there are collisions within your area of interest, you can request this data from the Research Team for a fee. Please be sure to check if there are collisions in your area of interest before you send your request as all data queries performed by the Research Group will be chargeable.
3. Request the data
Send your data request to email@example.com.
In your email, please include:
- the date range you require data for (e.g. July 2019 to June 2021)
- your area of interest – ideally defined by a polygon using a shapefile or DXF but an image or a detailed description is acceptable.
- the format for your data – note that our standard format is Excel or Shapefile and an additional charge is payable for other formats.
- the purpose of your request – this is to establish whether the nature of your work is considered to relate to accident investigation, accident remedial works and/or safety engineering. We are only permitted to provide collision descriptions and contributory factors to parties engaged with this nature of work.
The Research Group will respond to your request with a quote. If you would like to proceed with purchasing the data, we will arrange for payment to be taken by credit/debit card.
5. Data provision
Once payment has been taken, we will provide you with your collision data in the format requested within 15 working days unless specified otherwise.
Peterborough collision data
If you require collision data for Peterborough, please contact: Jenny.Wright@peterborough.gov.uk.
Cluster site analysis
Collision cluster site analysis is undertaken by CCC on an annual basis to identify locations on the public highway where a higher number of injury collisions are occurring. CCC define a collision cluster site as follows:
- 6 or more injury collisions (any severity) within 100m or at a junction, in the most recent 3 calendar year period; or
- 3 or more higher severity injury collisions (fatal or serious injuries) within 100m or at a junction, in the most recent 3 calendar year period.
The latest identified cluster sites can be viewed on Maps Cambridgeshire by selecting the “Transport and Streets” drop-down and ticking on the “Accident Clusters” layer.