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'}
158 rows where council_area = "Wolverhampton" and disposal = "Education" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence
vehicle_make 24
month 14
offence 11
- Contravening a Red Traffic Light 66
- Driving without Due Care and Attention 50
- Stop a vehicle within pelican pedestrian crossing limits 19
- Stop a vehicle on pedestrian crossing 9
- Driving without Reasonable Consideration 6
- Cause vehicle to be left in a dangerous position 3
- Drive a vehicle other than on the carriageway of a motorway 1
- Driving a vehicle wholly or partly on a footpath 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 5
- Car 127
- Pedal Bike 16
- Pedestrian 13
- Horse Rider 1
- Motorbike 1
disposal 1
- Education · 158 ✖
council_area 1
- Wolverhampton · 158 ✖
| 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 | ||
| 7698 | op-snap---monthly-publication-february-2026.pdf | 445 | 2026-02 | Horse Rider | Vauxhall | Corsa | Grey | Driving without Due Care and Attention | None | Wakeley Hill Penn between Mount Rd and Swan Bank | Wakeley Hill Penn between Mount Road and Swan Bank | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 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 | ||
| 7786 | op-snap---monthly-publication-february-2026.pdf | 533 | 2026-02 | Pedal Bike | Citroen | Nemo | Blue | Driving without Due Care and Attention | None | Linthouse Lane | Linthouse Lane | Wolverhampton | Wolverhampton | Education | N/A | 52.6118187 | -2.0810618 | ||
| 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 | ||
| 11770 | op-snap---monthly-publication-january-2026.pdf | 1231 | 2026-01 | Pedestrian | Toyota | Prius | Black | Cause vehicle to be left in a dangerous position | None | Gough Road Coseley | Gough Road Coseley | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 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 | ||
| 21389 | op-snap---monthly-publication-november-2025.pdf | 931 | 2025-11 | Pedal Bike | Volkswagen | Scirocco | Red | Driving without Due Care and Attention | None | Linthouse Lane | Linthouse Lane | Wolverhampton | Wolverhampton | Education | N/A | 52.6118187 | -2.0810618 | ||
| 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 | ||
| 22083 | op-snap---monthly-publication-october-2025.pdf | 33 | 2025-10 | Pedal Bike | Nissan | Note | Blue | Driving without Due Care and Attention | None | Inchlaggan Road | Inchlaggan Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6049304 | -2.10742 | ||
| 22087 | op-snap---monthly-publication-october-2025.pdf | 37 | 2025-10 | Pedal Bike | Nissan | X-Trail | Black | Driving a vehicle wholly or partly on a footpath | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6083917 | -2.1033365 | ||
| 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 | ||
| 22750 | op-snap---monthly-publication-october-2025.pdf | 700 | 2025-10 | Pedal Bike | Audi | A7 | Black | Driving without Due Care and Attention | None | Wednesfield Way | Wednesfield Way | Wolverhampton | Wolverhampton | Education | N/A | 52.59548 | -2.0896906 | ||
| 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 | ||
| 23855 | op-snap---monthly-publication-september-2025.pdf | 74 | 2025-09 | Pedal Bike | Peugeot | 107 | Silver | Driving without Due Care and Attention | None | Wolverhampton Rd , jn with Dimmock Street | Wolverhampton Road , jn with Dimmock Street | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 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 | ||
| 24381 | op-snap---monthly-publication-september-2025.pdf | 600 | 2025-09 | Pedestrian | Toyota | CHR | White | Cause vehicle to be left in a dangerous position | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6083917 | -2.1033365 | ||
| 24496 | op-snap---monthly-publication-september-2025.pdf | 715 | 2025-09 | Pedal Bike | Porsche | Cayman | White | Driving without Due Care and Attention | None | Great Bridge Road, Bilston | Great Bridge Road, Bilston | Wolverhampton | Wolverhampton | Education | N/A | 52.5602666 | -2.0579414 | ||
| 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 | ||
| 24710 | op-snap---monthly-publication-september-2025.pdf | 929 | 2025-09 | Pedestrian | Kia | Grey | Contravening a Red Traffic Light | None | Bushbury Road | Bushbury Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5988194 | -2.1026037 | |||
| 24711 | op-snap---monthly-publication-september-2025.pdf | 930 | 2025-09 | Pedestrian | Seat | Ibiza | White | Contravening a Red Traffic Light | None | Bushbury Road | Bushbury Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5988194 | -2.1026037 | ||
| 24740 | op-snap---monthly-publication-september-2025.pdf | 959 | 2025-09 | Pedestrian | Audi | A3 | White | Contravening a Red Traffic Light | None | Bushbury Rd / Cannock Rd | Bushbury Road / Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5988194 | -2.1026037 | ||
| 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 | ||
| 24757 | op-snap---monthly-publication-september-2025.pdf | 976 | 2025-09 | Pedestrian | Vauxhall | Astra | Grey | Contravening a Red Traffic Light | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6083917 | -2.1033365 | ||
| 24758 | op-snap---monthly-publication-september-2025.pdf | 977 | 2025-09 | Pedestrian | Mercedes-Benz | Vito | White | Contravening a Red Traffic Light | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6083917 | -2.1033365 | ||
| 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 | ||
| 24853 | op-snap---monthly-publication-september-2025.pdf | 1072 | 2025-09 | Pedestrian | Audi | A4 | Black | Contravening a Red Traffic Light | None | Bushbury Road / Cannock Road | Bushbury Road / Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5988194 | -2.1026037 | ||
| 24855 | op-snap---monthly-publication-september-2025.pdf | 1074 | 2025-09 | Pedestrian | Ford | Puma | Grey | Contravening a Red Traffic Light | None | Bushbury Road / Cannock Road | Bushbury Road / Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5988194 | -2.1026037 | ||
| 24868 | op-snap---monthly-publication-september-2025.pdf | 1087 | 2025-09 | Pedestrian | Ford | Focus | White | Contravening a Red Traffic Light | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6083917 | -2.1033365 | ||
| 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 | ||
| 2369 | op-snap---monthly-publication-august-2025.pdf | 344 | 2025-08 | Pedal Bike | Mercedes-Benz | EClass | White | Driving without Due Care and Attention | None | Underhill Road | Underhill Road | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 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 | ||
| 2615 | op-snap---monthly-publication-august-2025.pdf | 590 | 2025-08 | Pedal Bike | BMW | 120D | Black | Driving without Due Care and Attention | None | Rayner Road | Rayner Road | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 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 | ||
| 11991 | op-snap---monthly-publication-july-2025.pdf | 43 | 2025-07 | Pedal Bike | Audi | A3 | Silver | Driving without Due Care and Attention | None | Wolverhampton Road | Wolverhampton Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5968709 | -2.0954054 | ||
| 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 | ||
| 13245 | op-snap---monthly-publication-july-2025.pdf | 1297 | 2025-07 | Motorbike | Ford | Transit | White | Driving without Due Care and Attention | None | Finchfield Road | Finchfield Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5805119 | -2.1581621 | ||
| 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 |
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);