reports
Data license: ODbL · Data source: West Midlands Police
- id
- {'label': 'ID'}
- source_file
- {'label': 'Source PDF'}
- source_page
- {'label': 'Page'}
- source_row
- {'label': 'Row'}
- month
- {'label': 'Month'}
- reporter_transport_mode
- {'label': 'Reporter'}
- vehicle_make
- {'label': 'Make'}
- vehicle_model
- {'label': 'Model'}
- vehicle_colour
- {'label': 'Colour'}
- offence
- {'label': 'Offence'}
- second_offence
- {'label': 'Second offence'}
- offence_location_raw
- {'label': 'Location (raw)'}
- offence_location
- {'label': 'Location'}
- council_area_raw
- {'label': 'Council (raw)'}
- council_area
- {'label': 'Council area'}
- disposal
- {'label': 'Outcome'}
- nfa_rationale
- {'label': 'NFA reason'}
- witness_contacted
- {'label': 'Witness contacted'}
- latitude
- {'label': 'Lat'}
- longitude
- {'label': 'Lng'}
37 rows where council_area = "Wolverhampton", disposal = "NFA" and reporter_transport_mode = "Pedal Bike" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_model, vehicle_colour, second_offence, offence_location_raw, offence_location, nfa_rationale, latitude, longitude
vehicle_make 17
- Other 9
- Dennis 3
- Vauxhall 3
- BMW 2
- Ford 2
- Land Rover 2
- Nissan 2
- Volkswagen 2
- Audi 1
- Citroen 1
- Hyundai 1
- Mercedes-Benz 1
- Mg 1
- Mitsubishi 1
- Peugeot 1
- Saab 1
- Volvo 1
offence 8
- Misc - Non Traffic Offences 11
- Driving without Due Care and Attention 6
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 5
- Cause vehicle to be left in a dangerous position 5
- Cause unnecessary obstruction by motor vehicle 4
- Driving without Reasonable Consideration 4
- Contravening a Red Traffic Light 1
- Stop a vehicle within pelican pedestrian crossing limits 1
reporter_transport_mode 1
- Pedal Bike · 37 ✖
disposal 1
- NFA · 37 ✖
council_area 1
- Wolverhampton · 37 ✖
| id | source_file | source_page | source_row | month ▲ | reporter_transport_mode | vehicle_make | vehicle_model | vehicle_colour | offence | second_offence | offence_location_raw | offence_location | council_area_raw | council_area | disposal | nfa_rationale | witness_contacted | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8528 | op-snap---monthly-publication-february-2026.pdf | 1275 | 2026-02 | Pedal Bike | Ford | Ranger | White | Driving without Due Care and Attention | None | Lower Street | Lower Street | Wolverhampton | Wolverhampton | NFA | 52.6017311 | -2.1598475 | |||
| 11545 | op-snap---monthly-publication-january-2026.pdf | 1006 | 2026-01 | Pedal Bike | E Scooter | Black | Misc - Non Traffic Offences | No Insurance | Rookery Street | Rookery Street | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | 52.5986538 | -2.0858471 | |||
| 23874 | op-snap---monthly-publication-september-2025.pdf | 93 | 2025-09 | Pedal Bike | Nissan | Ariya | Green | Misc - Non Traffic Offences | None | Aldersly Leisure Village | Aldersly Leisure Village | Wolverhampton | Wolverhampton | NFA | No Offence | ||||
| 24969 | op-snap---monthly-publication-september-2025.pdf | 1188 | 2025-09 | Pedal Bike | Other | BUS | White | Misc - Non Traffic Offences | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 24970 | op-snap---monthly-publication-september-2025.pdf | 1189 | 2025-09 | Pedal Bike | Vauxhall | Corsa | Blue | Misc - Non Traffic Offences | None | Cannock ROad | Cannock ROad | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | 52.6083917 | -2.1033365 | ||
| 24971 | op-snap---monthly-publication-september-2025.pdf | 1190 | 2025-09 | Pedal Bike | Citroen | C4 | Red | Misc - Non Traffic Offences | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 24972 | op-snap---monthly-publication-september-2025.pdf | 1191 | 2025-09 | Pedal Bike | Other | BUS | White | Misc - Non Traffic Offences | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 24973 | op-snap---monthly-publication-september-2025.pdf | 1192 | 2025-09 | Pedal Bike | Other | Bus | Green | Misc - Non Traffic Offences | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 24974 | op-snap---monthly-publication-september-2025.pdf | 1193 | 2025-09 | Pedal Bike | Volkswagen | Golf | Silver | Misc - Non Traffic Offences | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 24975 | op-snap---monthly-publication-september-2025.pdf | 1194 | 2025-09 | Pedal Bike | Volkswagen | Polo | Silver | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | 52.6083917 | -2.1033365 | ||
| 24976 | op-snap---monthly-publication-september-2025.pdf | 1195 | 2025-09 | Pedal Bike | Vauxhall | Astra | White | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | 52.6083917 | -2.1033365 | ||
| 24977 | op-snap---monthly-publication-september-2025.pdf | 1196 | 2025-09 | Pedal Bike | Nissan | Note | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | 52.6083917 | -2.1033365 | ||
| 25263 | op-snap---monthly-publication-september-2025.pdf | 1482 | 2025-09 | Pedal Bike | Other | Misc - Non Traffic Offences | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.6083917 | -2.1033365 | ||||
| 25309 | op-snap---monthly-publication-september-2025.pdf | 1528 | 2025-09 | Pedal Bike | Volvo | Bus | Red | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.6083917 | -2.1033365 | ||
| 3534 | op-snap---monthly-publication-august-2025.pdf | 1509 | 2025-08 | Pedal Bike | Saab | 09-Mar | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannock road | Cannock road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 3535 | op-snap---monthly-publication-august-2025.pdf | 1510 | 2025-08 | Pedal Bike | Other | Bus | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 3536 | op-snap---monthly-publication-august-2025.pdf | 1511 | 2025-08 | Pedal Bike | Other | Bus | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannock road | Cannock road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 3538 | op-snap---monthly-publication-august-2025.pdf | 1513 | 2025-08 | Pedal Bike | Other | Bus | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 3809 | op-snap---monthly-publication-august-2025.pdf | 1784 | 2025-08 | Pedal Bike | Other | Bus | Red | Misc - Non Traffic Offences | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | ||
| 3819 | op-snap---monthly-publication-august-2025.pdf | 1794 | 2025-08 | Pedal Bike | Other | BUS | Red | Misc - Non Traffic Offences | none | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.6083917 | -2.1033365 | ||
| 3826 | op-snap---monthly-publication-august-2025.pdf | 1801 | 2025-08 | Pedal Bike | Dennis | Yellow | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6083917 | -2.1033365 | |||
| 3827 | op-snap---monthly-publication-august-2025.pdf | 1802 | 2025-08 | Pedal Bike | Dennis | White | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.6083917 | -2.1033365 | |||
| 3828 | op-snap---monthly-publication-august-2025.pdf | 1803 | 2025-08 | Pedal Bike | Dennis | Red | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.6083917 | -2.1033365 | |||
| 12912 | op-snap---monthly-publication-july-2025.pdf | 964 | 2025-07 | Pedal Bike | BMW | 116 | Silver | Driving without Due Care and Attention | None | Highfield Road | Highfield Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.5570756 | -2.073188 | ||
| 12914 | op-snap---monthly-publication-july-2025.pdf | 966 | 2025-07 | Pedal Bike | Ford | Transit | Silver | Driving without Due Care and Attention | None | Willenhall Road | Willenhall Road | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5836778 | -2.0894997 | ||
| 13133 | op-snap---monthly-publication-july-2025.pdf | 1185 | 2025-07 | Pedal Bike | Peugeot | Partner | White | Cause vehicle to be left in a dangerous position | None | Ambergate Road , Bilston | Ambergate Road , Bilston | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5597351 | -2.081298 | ||
| 13134 | op-snap---monthly-publication-july-2025.pdf | 1186 | 2025-07 | Pedal Bike | Land Rover | Evoque | Black | Cause vehicle to be left in a dangerous position | None | Ambergate Road Road , Bilston | Ambergate Road Road , Bilston | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5597351 | -2.081298 | ||
| 13181 | op-snap---monthly-publication-july-2025.pdf | 1233 | 2025-07 | Pedal Bike | N/P | Black | Driving without Due Care and Attention | None | Park Street , Darlston | Park Street , Darlston | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | |||||
| 14555 | op-snap---monthly-publication-june-2025.pdf | 484 | 2025-06 | Pedal Bike | Vauxhall | Zafira | Black | Contravening a Red Traffic Light | None | Skidmore Rpad | Skidmore Rpad | Wolverhampton | Wolverhampton | NFA | No Offence | ||||
| 14757 | op-snap---monthly-publication-june-2025.pdf | 686 | 2025-06 | Pedal Bike | Land Rover | Range Rover | Grey | Driving without Due Care and Attention | None | Wobaston Road | Wobaston Road | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.628768 | -2.1306154 | ||
| 14971 | op-snap---monthly-publication-june-2025.pdf | 900 | 2025-06 | Pedal Bike | Hyundai | I10 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Mill South | Long Mill South | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.6095019 | -2.0915196 | ||
| 15034 | op-snap---monthly-publication-june-2025.pdf | 963 | 2025-06 | Pedal Bike | Mg | 5 EXCITE | Silver | Driving without Reasonable Consideration | None | SPON LANE | Spon Lane | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5071465 | -2.0049226 | ||
| 15446 | op-snap---monthly-publication-june-2025.pdf | 1375 | 2025-06 | Pedal Bike | Mercedes-Benz | A Class | Silver | Driving without Reasonable Consideration | None | Wednesfield Way | Wednesfield Way | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.59548 | -2.0896906 | ||
| 18894 | op-snap---monthly-publication-may-2025.pdf | 256 | 2025-05 | Pedal Bike | BMW | 320 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | High Street | High Street | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.5635963 | -2.0827567 | ||
| 19933 | op-snap---monthly-publication-may-2025.pdf | 1295 | 2025-05 | Pedal Bike | Mitsubishi | L200 | Black | Driving without Due Care and Attention | None | holyhead road | Holyhead Road | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5967563 | -2.1605854 | ||
| 6885 | op-snap---monthly-publication-february-2025.pdf | 1702 | 2025-02 | Pedal Bike | Opel | Silver | Driving without Reasonable Consideration | None | Wednesfield Way Wolverhampton | Wednesfield Way Wolverhampton | Wolverhampton | Wolverhampton | NFA | Not in Public Interest | Yes - Via Email | 52.59548 | -2.0896906 | ||
| 10443 | op-snap---monthly-publication-january-2025.pdf | 1551 | 2025-01 | Pedal Bike | Audi | Q4 | Green | Driving without Reasonable Consideration | None | Broad Street | Broad Street | Wolverhampton | Wolverhampton | NFA | No Offence | Yes - Via Email | 52.5677057 | -2.0822688 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE reports (
id INTEGER PRIMARY KEY AUTOINCREMENT,
source_file TEXT NOT NULL,
source_page INTEGER,
source_row INTEGER,
month TEXT NOT NULL,
reporter_transport_mode TEXT,
vehicle_make TEXT,
vehicle_model TEXT,
vehicle_colour TEXT,
offence TEXT,
second_offence TEXT,
offence_location_raw TEXT,
offence_location TEXT,
council_area_raw TEXT,
council_area TEXT,
disposal TEXT,
nfa_rationale TEXT,
witness_contacted TEXT
, latitude REAL, longitude REAL);
CREATE INDEX idx_month ON reports(month);
CREATE INDEX idx_council_area ON reports(council_area);
CREATE INDEX idx_offence ON reports(offence);
CREATE INDEX idx_disposal ON reports(disposal);
CREATE INDEX idx_location ON reports(offence_location);