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'}
127 rows where council_area = "Wolverhampton", disposal = "Education" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence
vehicle_make 24
month 14
offence 10
- Contravening a Red Traffic Light 58
- Driving without Due Care and Attention 38
- Stop a vehicle within pelican pedestrian crossing limits 16
- Stop a vehicle on pedestrian crossing 7
- Driving without Reasonable Consideration 3
- Cause vehicle to be left in a dangerous position 1
- Drive a vehicle other than on the carriageway of a motorway 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Using a Mobile Phone Whilst Driving 1
- Vehicle overtake within crossing limits 1
reporter_transport_mode 1
- Car · 127 ✖
disposal 1
- Education · 127 ✖
council_area 1
- Wolverhampton · 127 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7532 | op-snap---monthly-publication-february-2026.pdf | 279 | 2026-02 | Car | Lexus | CT200 | White | Driving without Due Care and Attention | None | Cross Street South | Cross Street South | Wolverhampton | Wolverhampton | Education | N/A | 52.570955 | -2.130838 | ||
| 7635 | op-snap---monthly-publication-february-2026.pdf | 382 | 2026-02 | Car | BMW | 520.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | High Street Tettenhall | High Street Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 7644 | op-snap---monthly-publication-february-2026.pdf | 391 | 2026-02 | Car | Ford | Transit Connect | Black | Driving without Due Care and Attention | None | Ambergate Road / Highfield Rd, Bilston | Ambergate Road / Highfield Road, Bilston | Wolverhampton | Wolverhampton | Education | N/A | 52.5597351 | -2.081298 | ||
| 7731 | op-snap---monthly-publication-february-2026.pdf | 478 | 2026-02 | Car | Jaguar | F-Pace | Blue | Contravening a Red Traffic Light | None | Thompson Avenue | Thompson Avenue | Wolverhampton | Wolverhampton | Education | N/A | 52.5722181 | -2.1205684 | ||
| 7810 | op-snap---monthly-publication-february-2026.pdf | 557 | 2026-02 | Car | Volkswagen | golf | White | Driving without Reasonable Consideration | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6291998 | -2.126312 | ||
| 8007 | op-snap---monthly-publication-february-2026.pdf | 754 | 2026-02 | Car | Mg | HS Trophy | White | Driving without Due Care and Attention | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6291998 | -2.126312 | ||
| 8080 | op-snap---monthly-publication-february-2026.pdf | 827 | 2026-02 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Beech Road | Beech Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6155037 | -2.1354987 | ||
| 8092 | op-snap---monthly-publication-february-2026.pdf | 839 | 2026-02 | Car | BMW | 320d | Red | Contravening a Red Traffic Light | None | Oxley Moor Road | Oxley Moor Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6158347 | -2.1377689 | ||
| 8096 | op-snap---monthly-publication-february-2026.pdf | 843 | 2026-02 | Car | Citroen | Berlingo | White | Driving without Due Care and Attention | None | New Cross Hospital grounds, The Furlongs | New Cross Hospital grounds, The Furlongs | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 8163 | op-snap---monthly-publication-february-2026.pdf | 910 | 2026-02 | Car | BMW | 420i | White | Stop a vehicle on pedestrian crossing | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 8398 | op-snap---monthly-publication-february-2026.pdf | 1145 | 2026-02 | Car | Kia | Niro | Grey | Contravening a Red Traffic Light | None | Parkfield Road | Parkfield Road | Wolverhampton | Wolverhampton | Education | N/A | 52.567016 | -2.1208485 | ||
| 8451 | op-snap---monthly-publication-february-2026.pdf | 1198 | 2026-02 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Tudor Street | Tudor Street | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 8551 | op-snap---monthly-publication-february-2026.pdf | 1298 | 2026-02 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | Summerhill Road, Bilston | Summerhill Road, Bilston | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 8557 | op-snap---monthly-publication-february-2026.pdf | 1304 | 2026-02 | Car | Volkswagen | T Troc | Black | Contravening a Red Traffic Light | None | Black Country Route | Black Country Route | Wolverhampton | Wolverhampton | Education | N/A | 52.5642677 | -2.0755469 | ||
| 8619 | op-snap---monthly-publication-february-2026.pdf | 1366 | 2026-02 | Car | Ford | Ranger | Black | Contravening a Red Traffic Light | None | Essington Road | Essington Road | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 10738 | op-snap---monthly-publication-january-2026.pdf | 199 | 2026-01 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | A454 Black Country Route | Black Country Route | Wolverhampton | Wolverhampton | Education | N/A | 52.5642677 | -2.0755469 | ||
| 11072 | op-snap---monthly-publication-january-2026.pdf | 533 | 2026-01 | Car | Nissan | Juke | White | Contravening a Red Traffic Light | None | A449 Wolverhampton Road | Wolverhampton Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5968709 | -2.0954054 | ||
| 11168 | op-snap---monthly-publication-january-2026.pdf | 629 | 2026-01 | Car | Toyota | Rav 4 | Grey | Contravening a Red Traffic Light | None | Waterloo Road | Waterloo Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5960155 | -2.1295068 | ||
| 11489 | op-snap---monthly-publication-january-2026.pdf | 950 | 2026-01 | Car | Audi | A6 | Grey | Contravening a Red Traffic Light | None | Darlsaton Lane | Darlsaton Lane | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 11596 | op-snap---monthly-publication-january-2026.pdf | 1057 | 2026-01 | Car | Ford | Focus | White | Stop a vehicle within pelican pedestrian crossing limits | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 11847 | op-snap---monthly-publication-january-2026.pdf | 1308 | 2026-01 | Car | Renault | cLIO | White | Driving without Due Care and Attention | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6291998 | -2.126312 | ||
| 11889 | op-snap---monthly-publication-january-2026.pdf | 1350 | 2026-01 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Goldthorn Hill | Goldthorn Hill | Wolverhampton | Wolverhampton | Education | N/A | 52.5690522 | -2.1388773 | ||
| 11894 | op-snap---monthly-publication-january-2026.pdf | 1355 | 2026-01 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6291998 | -2.126312 | ||
| 4034 | op-snap---monthly-publication-december-2025.pdf | 162 | 2025-12 | Car | Porsche | Boxster | White | Driving without Due Care and Attention | None | Black Country Route | Black Country Route | Wolverhampton | Wolverhampton | Education | N/A | 52.5642677 | -2.0755469 | ||
| 4116 | op-snap---monthly-publication-december-2025.pdf | 244 | 2025-12 | Car | Volkswagen | Tiguan | Black | Contravening a Red Traffic Light | None | Kitchen Lane, Ashmore Park | Kitchen Lane, Ashmore Park | Wolverhampton | Wolverhampton | Education | N/A | 52.6214265 | -2.0603757 | ||
| 4430 | op-snap---monthly-publication-december-2025.pdf | 558 | 2025-12 | Car | BMW | 1 Series | Black | Driving without Due Care and Attention | None | Wednesfield Road | Wednesfield Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5885601 | -2.122003 | ||
| 5175 | op-snap---monthly-publication-december-2025.pdf | 1303 | 2025-12 | Car | Ford | FOCUS | Black | Cause vehicle to be left in a dangerous position | None | High St Tettenhall | High Street Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 20559 | op-snap---monthly-publication-november-2025.pdf | 101 | 2025-11 | Car | Kia | Ceed | Red | Contravening a Red Traffic Light | None | M6 J10 RA | M6 J10 Ra | Wolverhampton | Wolverhampton | Education | N/A | 52.6760749 | -2.0862582 | ||
| 20623 | op-snap---monthly-publication-november-2025.pdf | 165 | 2025-11 | Car | Volkswagen | ID7 | Blue | Driving without Due Care and Attention | None | M6 North | M6 North | Wolverhampton | Wolverhampton | Education | N/A | 52.6049795 | -2.085282 | ||
| 21418 | op-snap---monthly-publication-november-2025.pdf | 960 | 2025-11 | Car | Citroen | Belingo | black | Driving without Due Care and Attention | None | Bushbury Lane | Bushbury Lane | Wolverhampton | Wolverhampton | Education | N/A | 52.6107589 | -2.1231693 | ||
| 21521 | op-snap---monthly-publication-november-2025.pdf | 1063 | 2025-11 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Birmingham Road | Birmingham Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5733225 | -2.1227682 | ||
| 21993 | op-snap---monthly-publication-november-2025.pdf | 1535 | 2025-11 | Car | Mercedes-Benz | CLA 180 | White | Contravening a Red Traffic Light | None | Horseley Fields | Horseley Fields | Wolverhampton | Wolverhampton | Education | N/A | 52.5850146 | -2.1175982 | ||
| 22057 | op-snap---monthly-publication-october-2025.pdf | 7 | 2025-10 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Bilston Street Island | Bilston Street Island | Wolverhampton | Wolverhampton | Education | N/A | 52.5834806 | -2.1204011 | ||
| 22133 | op-snap---monthly-publication-october-2025.pdf | 83 | 2025-10 | Car | Suzuki | Celerio | Red | Contravening a Red Traffic Light | None | Aldersley Road | Aldersley Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6058472 | -2.1521123 | ||
| 22158 | op-snap---monthly-publication-october-2025.pdf | 108 | 2025-10 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Connaught Road | Connaught Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5876226 | -2.1426533 | ||
| 22304 | op-snap---monthly-publication-october-2025.pdf | 254 | 2025-10 | Car | Volkswagen | Transporter | Grey | Driving without Due Care and Attention | None | Warstones Road / Coalway Road, Penn | Warstones Road / Coalway Road, Penn | Wolverhampton | Wolverhampton | Education | N/A | 52.5687693 | -2.1613924 | ||
| 22413 | op-snap---monthly-publication-october-2025.pdf | 363 | 2025-10 | Car | BMW | 330.. | Blue | Driving without Due Care and Attention | None | Birches Barn Road | Birches Barn Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5716962 | -2.1462935 | ||
| 22570 | op-snap---monthly-publication-october-2025.pdf | 520 | 2025-10 | Car | Peugeot | Horizon | Grey | Contravening a Red Traffic Light | None | A4150N / Bilston Island | A4150N / Bilston Island | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 22572 | op-snap---monthly-publication-october-2025.pdf | 522 | 2025-10 | Car | Peugeot | 3008 | Grey | Driving without Due Care and Attention | None | Oxford Street Island | Oxford Street Island | Wolverhampton | Wolverhampton | Education | N/A | 52.5649947 | -2.07061 | ||
| 22592 | op-snap---monthly-publication-october-2025.pdf | 542 | 2025-10 | Car | Vauxhall | Zafira | Silver | Contravening a Red Traffic Light | None | Chapel Ash | Chapel Ash | Wolverhampton | Wolverhampton | Education | N/A | 52.5857494 | -2.1409393 | ||
| 22599 | op-snap---monthly-publication-october-2025.pdf | 549 | 2025-10 | Car | Audi | Q4 | Grey | Drive a vehicle other than on the carriageway of a motorway | None | M6 SB J10 | M6 Southbound J10 | Wolverhampton | Wolverhampton | Education | N/A | 52.676119 | -2.0858425 | ||
| 22792 | op-snap---monthly-publication-october-2025.pdf | 742 | 2025-10 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | A459 Dudley Road | Dudley Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5717314 | -2.1249182 | ||
| 22983 | op-snap---monthly-publication-october-2025.pdf | 933 | 2025-10 | Car | Volkswagen | Passat | Black | Driving without Due Care and Attention | None | Ettingshall Road | Ettingshall Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5737672 | -2.1037249 | ||
| 22986 | op-snap---monthly-publication-october-2025.pdf | 936 | 2025-10 | Car | Seat | Leon | Grey | Contravening a Red Traffic Light | None | A454 | A454 | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 22997 | op-snap---monthly-publication-october-2025.pdf | 947 | 2025-10 | Car | Peugeot | Expert | White | Contravening a Red Traffic Light | None | Wednesfield Road | Wednesfield Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5885601 | -2.122003 | ||
| 24192 | op-snap---monthly-publication-september-2025.pdf | 411 | 2025-09 | Car | Nissan | Pulsar | Blue | Contravening a Red Traffic Light | None | Stafford Road, Jn2 M54 | Stafford Road, Jn2 M54 | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 24361 | op-snap---monthly-publication-september-2025.pdf | 580 | 2025-09 | Car | Vauxhall | Mokka | White | Contravening a Red Traffic Light | None | A41 Oxford Street | Oxford Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5651361 | -2.0707545 | ||
| 24543 | op-snap---monthly-publication-september-2025.pdf | 762 | 2025-09 | Car | Citroen | Dispatch | White | Contravening a Red Traffic Light | None | Wednesfield Road | Wednesfield Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5885601 | -2.122003 | ||
| 24747 | op-snap---monthly-publication-september-2025.pdf | 966 | 2025-09 | Car | Volkswagen | Passat | Grey | Driving without Due Care and Attention | None | Black Country Route | Black Country Route | Wolverhampton | Wolverhampton | Education | N/A | 52.5642677 | -2.0755469 | ||
| 24798 | op-snap---monthly-publication-september-2025.pdf | 1017 | 2025-09 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Fareham Crescent | Fareham Crescent | Wolverhampton | Wolverhampton | Education | N/A | 52.5696136 | -2.1743897 | ||
| 24804 | op-snap---monthly-publication-september-2025.pdf | 1023 | 2025-09 | Car | Renault | Megane | Blue | Driving without Due Care and Attention | None | Fareham Crescent | Fareham Crescent | Wolverhampton | Wolverhampton | Education | N/A | 52.5696136 | -2.1743897 | ||
| 24852 | op-snap---monthly-publication-september-2025.pdf | 1071 | 2025-09 | Car | Volkswagen | Tiguan | White | Contravening a Red Traffic Light | None | Wednesfield Road | Wednesfield Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5885601 | -2.122003 | ||
| 24896 | op-snap---monthly-publication-september-2025.pdf | 1115 | 2025-09 | Car | Peugeot | Expert | Red | Contravening a Red Traffic Light | None | Willenhall Road | Willenhall Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5836778 | -2.0894997 | ||
| 2069 | op-snap---monthly-publication-august-2025.pdf | 44 | 2025-08 | Car | Nissan | Juke | White | Contravening a Red Traffic Light | None | A449 Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6291998 | -2.126312 | ||
| 2072 | op-snap---monthly-publication-august-2025.pdf | 47 | 2025-08 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | A449 | A449 | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 2347 | op-snap---monthly-publication-august-2025.pdf | 322 | 2025-08 | Car | Ford | Mondeo | Blue | Driving without Due Care and Attention | None | A463 | A463 | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 2360 | op-snap---monthly-publication-august-2025.pdf | 335 | 2025-08 | Car | Audi | A3.. | Red | Contravening a Red Traffic Light | None | Penn Road Wolverhampton | Penn Road Wolverhampton | Wolverhampton | Wolverhampton | Education | N/A | 52.5599616 | -2.1556338 | ||
| 2372 | op-snap---monthly-publication-august-2025.pdf | 347 | 2025-08 | Car | BMW | R1300 | Blue | Contravening a Red Traffic Light | None | Chapel Ash | Chapel Ash | Wolverhampton | Wolverhampton | Education | N/A | 52.5857494 | -2.1409393 | ||
| 2468 | op-snap---monthly-publication-august-2025.pdf | 443 | 2025-08 | Car | BMW | 320 | Grey | Driving without Due Care and Attention | None | Neachells Lane | Neachells Lane | Wolverhampton | Wolverhampton | Education | N/A | 52.597459 | -2.0791894 | ||
| 2580 | op-snap---monthly-publication-august-2025.pdf | 555 | 2025-08 | Car | Mini | Mini | Green | Contravening a Red Traffic Light | None | Hunter Street | Hunter Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5944363 | -2.1452444 | ||
| 2750 | op-snap---monthly-publication-august-2025.pdf | 725 | 2025-08 | Car | Mercedes-Benz | E Class | Black | Contravening a Red Traffic Light | None | Bilston Street | Bilston Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5838892 | -2.1231759 | ||
| 2780 | op-snap---monthly-publication-august-2025.pdf | 755 | 2025-08 | Car | Mercedes-Benz | Vito | White | Driving without Due Care and Attention | None | Birmingham New Road | Birmingham New Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5560698 | -2.1044322 | ||
| 2809 | op-snap---monthly-publication-august-2025.pdf | 784 | 2025-08 | Car | Ford | Fiesta | Black | Contravening a Red Traffic Light | None | Penn Road Island | Penn Road Island | Wolverhampton | Wolverhampton | Education | N/A | 52.5807112 | -2.1316397 | ||
| 3002 | op-snap---monthly-publication-august-2025.pdf | 977 | 2025-08 | Car | Toyota | CH-R | Black | Contravening a Red Traffic Light | None | Aspen Way | Aspen Way | Wolverhampton | Wolverhampton | Education | N/A | 52.5810956 | -2.1475001 | ||
| 3024 | op-snap---monthly-publication-august-2025.pdf | 999 | 2025-08 | Car | Peugeot | 208 | Blue | Driving without Due Care and Attention | None | A4150 Ring Road St Johns | Ring Road Street Johns | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 3047 | op-snap---monthly-publication-august-2025.pdf | 1022 | 2025-08 | Car | BMW | 520D | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | High Street | High Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5635963 | -2.0827567 | ||
| 12115 | op-snap---monthly-publication-july-2025.pdf | 167 | 2025-07 | Car | Mercedes-Benz | C220 | Red | Driving without Due Care and Attention | None | Wood End Road | Wood End Road | Wolverhampton | Wolverhampton | Education | N/A | 52.605993 | -2.0805938 | ||
| 12312 | op-snap---monthly-publication-july-2025.pdf | 364 | 2025-07 | Car | BMW | X1.. | White | Driving without Due Care and Attention | None | M5 Junction 1 Island | M5 Junction 1 Island | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 12439 | op-snap---monthly-publication-july-2025.pdf | 491 | 2025-07 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | A454 Wolverhampton | Wolverhampton | Wolverhampton | Wolverhampton | Education | N/A | 52.5879884 | -2.120242 | ||
| 12534 | op-snap---monthly-publication-july-2025.pdf | 586 | 2025-07 | Car | Volkswagen | Golf | Silver | Contravening a Red Traffic Light | None | Sneyd Lane | Sneyd Lane | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 12572 | op-snap---monthly-publication-july-2025.pdf | 624 | 2025-07 | Car | Mercedes-Benz | B class | Silver | Contravening a Red Traffic Light | None | Black Country Route, A463 | Black Country Route, A463 | Wolverhampton | Wolverhampton | Education | N/A | 52.5642677 | -2.0755469 | ||
| 12709 | op-snap---monthly-publication-july-2025.pdf | 761 | 2025-07 | Car | Yamaha | MT | Grey | Driving without Reasonable Consideration | None | Warstone Road | Warstone Road | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 12784 | op-snap---monthly-publication-july-2025.pdf | 836 | 2025-07 | Car | Renault | Clio | Red | Contravening a Red Traffic Light | None | Wobaston Road | Wobaston Road | Wolverhampton | Wolverhampton | Education | N/A | 52.628768 | -2.1306154 | ||
| 14231 | op-snap---monthly-publication-june-2025.pdf | 160 | 2025-06 | Car | BMW | 218 M | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Windmill Lane | Windmill Lane | Wolverhampton | Wolverhampton | Education | N/A | 52.5807057 | -2.1902528 | ||
| 14245 | op-snap---monthly-publication-june-2025.pdf | 174 | 2025-06 | Car | Mercedes-Benz | E320 | Black | Driving without Due Care and Attention | None | M6 SB J10 | M6 Southbound J10 | Wolverhampton | Wolverhampton | Education | N/A | 52.676119 | -2.0858425 | ||
| 14280 | op-snap---monthly-publication-june-2025.pdf | 209 | 2025-06 | Car | Volkswagen | Touran | Grey | Stop a vehicle on pedestrian crossing | None | High Street | High Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5635963 | -2.0827567 | ||
| 14300 | op-snap---monthly-publication-june-2025.pdf | 229 | 2025-06 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Oxbarn Avenue | Oxbarn Avenue | Wolverhampton | Wolverhampton | Education | N/A | 52.5726707 | -2.1604463 | ||
| 14427 | op-snap---monthly-publication-june-2025.pdf | 356 | 2025-06 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | St Davids Ring Road | Street Davids Ring Road | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 14433 | op-snap---monthly-publication-june-2025.pdf | 362 | 2025-06 | Car | BMW | 730d | Black | Contravening a Red Traffic Light | None | Tettenhall Road | Tettenhall Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5883523 | -2.1466187 | ||
| 14488 | op-snap---monthly-publication-june-2025.pdf | 417 | 2025-06 | Car | Ford | Tournei | Red | Contravening a Red Traffic Light | None | Willenhall Road | Willenhall Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5836778 | -2.0894997 | ||
| 14716 | op-snap---monthly-publication-june-2025.pdf | 645 | 2025-06 | Car | Toyota | Black | Contravening a Red Traffic Light | None | Chapel Ash Island | Chapel Ash Island | Wolverhampton | Wolverhampton | Education | N/A | 52.5847884 | -2.1341887 | |||
| 14790 | op-snap---monthly-publication-june-2025.pdf | 719 | 2025-06 | Car | Peugeot | 5008 | Grey | Contravening a Red Traffic Light | None | Wednesfield Road | Wednesfield Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5885601 | -2.122003 | ||
| 14882 | op-snap---monthly-publication-june-2025.pdf | 811 | 2025-06 | Car | BMW | 320D | Grey | Driving without Due Care and Attention | None | Church Hill | Church Hill | Wolverhampton | Wolverhampton | Education | N/A | 52.5590109 | -2.1567213 | ||
| 15011 | op-snap---monthly-publication-june-2025.pdf | 940 | 2025-06 | Car | Volkswagen | Golf | Blue | Stop a vehicle on pedestrian crossing | None | High Street | High Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5635963 | -2.0827567 | ||
| 15166 | op-snap---monthly-publication-june-2025.pdf | 1095 | 2025-06 | Car | Vauxhall | Astra | White | Driving without Due Care and Attention | None | Park Road West | Park Road West | Wolverhampton | Wolverhampton | Education | N/A | 52.587131 | -2.1396643 | ||
| 15169 | op-snap---monthly-publication-june-2025.pdf | 1098 | 2025-06 | Car | Volkswagen | Scirocco | Green | Using a Mobile Phone Whilst Driving | None | M6 South J10 | M6 South J10 | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 15264 | op-snap---monthly-publication-june-2025.pdf | 1193 | 2025-06 | Car | Vauxhall | Astra | White | Contravening a Red Traffic Light | None | Ring Road, | Ring Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5805525 | -2.1302823 | ||
| 15339 | op-snap---monthly-publication-june-2025.pdf | 1268 | 2025-06 | Car | Volkswagen | golf | White | Stop a vehicle within pelican pedestrian crossing limits | None | Hight st | Hight st | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 15583 | op-snap---monthly-publication-june-2025.pdf | 1512 | 2025-06 | Car | Toyota | C-rv | Grey | Contravening a Red Traffic Light | None | Bilston Road | Bilston Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5801329 | -2.1138283 | ||
| 15639 | op-snap---monthly-publication-june-2025.pdf | 1568 | 2025-06 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Bilston Street | Bilston Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5838892 | -2.1231759 | ||
| 15648 | op-snap---monthly-publication-june-2025.pdf | 1577 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Driving without Reasonable Consideration | None | Bilston Road | Bilston Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5801329 | -2.1138283 | ||
| 18969 | op-snap---monthly-publication-may-2025.pdf | 331 | 2025-05 | Car | Citroen | Berlingo | White | Stop a vehicle on pedestrian crossing | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 18991 | op-snap---monthly-publication-may-2025.pdf | 353 | 2025-05 | Car | Land Rover | Freelander | Blue | Contravening a Red Traffic Light | None | Birches Barn Road | Birches Barn Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5716962 | -2.1462935 | ||
| 19085 | op-snap---monthly-publication-may-2025.pdf | 447 | 2025-05 | Car | BMW | 316 | Blue | Contravening a Red Traffic Light | None | Wolverhampton ring Road | Wolverhampton ring Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5868722 | -2.1217519 | ||
| 19307 | op-snap---monthly-publication-may-2025.pdf | 669 | 2025-05 | Car | BMW | 520.. | Blue | Driving without Due Care and Attention | None | Wellington Road | Wellington Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5686779 | -2.0822541 | ||
| 19473 | op-snap---monthly-publication-may-2025.pdf | 835 | 2025-05 | Car | Seat | Arona | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | High Street | High Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5635963 | -2.0827567 | ||
| 19599 | op-snap---monthly-publication-may-2025.pdf | 961 | 2025-05 | Car | Audi | RS3 | Grey | Contravening a Red Traffic Light | None | Lower Street, Tettenhal | Lower Street, Tettenhal | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 19600 | op-snap---monthly-publication-may-2025.pdf | 962 | 2025-05 | Car | Renault | Van | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 181 | op-snap---monthly-publication-april-2025.pdf | 180 | 2025-04 | Car | Volkswagen | Tiguan | White | Driving without Due Care and Attention | Contravening a Red Traffic Light | M6 towards J10 | M6 towards J10 | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 298 | op-snap---monthly-publication-april-2025.pdf | 297 | 2025-04 | Car | Volkswagen | Fox | Grey | Stop a vehicle on pedestrian crossing | None | High Street | High Street | Wolverhampton | Wolverhampton | Education | N/A | 52.5635963 | -2.0827567 |
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);