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'}
110 rows where disposal = "Fixed Penalty" and month = "2025-08" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw
vehicle_make 24
offence 14
- Driving without Due Care and Attention 34
- Using a Mobile Phone Whilst Driving 31
- Contravening a Red Traffic Light 25
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 7
- Cause vehicle to be left in a dangerous position 2
- Driving a vehicle wholly or partly on a footpath 2
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 2
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 1
- Drive on hard shoulder 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- No Insurance 1
- Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 1
- Vehicle overtake within crossing limits 1
council_area 8
- Birmingham 59
- Dudley 13
- Sandwell 10
- Solihull 10
- Coventry 7
- Walsall 7
- Sutton Coldfield 2
- Wolverhampton 2
reporter_transport_mode 6
- Car 75
- Pedal Bike 12
- Pedestrian 12
- Other 8
- Motorbike 2
- Lorry 1
month 1
- 2025-08 · 110 ✖
disposal 1
- Fixed Penalty · 110 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2028 | op-snap---monthly-publication-august-2025.pdf | 3 | 2025-08 | Other | Renault | Master | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Norwood Road | Norwood Road | Dudley | Dudley | Fixed Penalty | N/A | 52.4831397 | -2.1309273 | ||
| 2029 | op-snap---monthly-publication-august-2025.pdf | 4 | 2025-08 | Other | Hyundai | I30 | Red | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Norwood Road | Norwood Road | Dudley | Dudley | Fixed Penalty | N/A | 52.4831397 | -2.1309273 | ||
| 2032 | op-snap---monthly-publication-august-2025.pdf | 7 | 2025-08 | Car | BMW | 525I | Grey | Driving without Due Care and Attention | None | Richmond Hill Road | Richmond Hill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4607238 | -1.935227 | ||
| 2053 | op-snap---monthly-publication-august-2025.pdf | 28 | 2025-08 | Pedal Bike | Audi | S3 | Black | Using a Mobile Phone Whilst Driving | None | Swaswell St | Swaswell Street | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 2070 | op-snap---monthly-publication-august-2025.pdf | 45 | 2025-08 | Pedal Bike | Byd | Bus | Grey | Driving a vehicle wholly or partly on a footpath | None | Loda Lane | Loda Lane | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 2075 | op-snap---monthly-publication-august-2025.pdf | 50 | 2025-08 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Green Lane Small Heath | Green Lane Small Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4733613 | -1.8591116 | ||
| 2081 | op-snap---monthly-publication-august-2025.pdf | 56 | 2025-08 | Car | Hyundai | I10 | White | Using a Mobile Phone Whilst Driving | None | M42 South | M42 South | Solihull | Solihull | Fixed Penalty | N/A | 52.4473832 | -1.7140496 | ||
| 2090 | op-snap---monthly-publication-august-2025.pdf | 65 | 2025-08 | Pedal Bike | Renault | Kadjar | Red | Using a Mobile Phone Whilst Driving | None | Lickey Road | Lickey Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.3868298 | -2.0003781 | ||
| 2105 | op-snap---monthly-publication-august-2025.pdf | 80 | 2025-08 | Car | Honda | Civic | Blue | Driving without Due Care and Attention | No Insurance | Billesley Lane | Billesley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4344402 | -1.8845368 | ||
| 2117 | op-snap---monthly-publication-august-2025.pdf | 92 | 2025-08 | Car | BMW | SUV | Black | Using a Mobile Phone Whilst Driving | None | Middle lane of the M5 JUNCTION 1 AND M6 JUNCTION 8 | Middle lane of the M5 JUNCTION 1 AND M6 JUNCTION 8 | Sandwell | Sandwell | Fixed Penalty | N/A | ||||
| 2122 | op-snap---monthly-publication-august-2025.pdf | 97 | 2025-08 | Pedestrian | Renault | Scenic | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gulson Road | Gulson Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4076795 | -1.4911676 | ||
| 2133 | op-snap---monthly-publication-august-2025.pdf | 108 | 2025-08 | Car | Volkswagen | Tiguan | Grey | Using a Mobile Phone Whilst Driving | None | M6 South 10a - 10 | M6 South 10a - 10 | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2140 | op-snap---monthly-publication-august-2025.pdf | 115 | 2025-08 | Pedal Bike | Toyota | Vision | Black | Using a Mobile Phone Whilst Driving | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 | ||
| 2144 | op-snap---monthly-publication-august-2025.pdf | 119 | 2025-08 | Lorry | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | M6 North | M6 North | Walsall | Walsall | Fixed Penalty | N/A | 52.5859649 | -1.9897914 | ||
| 2146 | op-snap---monthly-publication-august-2025.pdf | 121 | 2025-08 | Pedestrian | Volkswagen | Tiguan | Grey | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Walsall | Walsall | Fixed Penalty | N/A | 52.5723244 | -1.9607214 | ||
| 2157 | op-snap---monthly-publication-august-2025.pdf | 132 | 2025-08 | Car | Audi | A3 | Silver | Using a Mobile Phone Whilst Driving | None | Romney WAY | Romney WAY | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2175 | op-snap---monthly-publication-august-2025.pdf | 150 | 2025-08 | Car | Vauxhall | Insignia | Silver | Driving without Due Care and Attention | None | Birmingham New Road | Birmingham New Road | Dudley | Dudley | Fixed Penalty | N/A | 52.5478387 | -2.0943116 | ||
| 2214 | op-snap---monthly-publication-august-2025.pdf | 189 | 2025-08 | Car | BMW | 118d | White | Driving without Due Care and Attention | None | M6 South | M6 South | Coventry | Coventry | Fixed Penalty | N/A | 52.4146643 | -1.5694761 | ||
| 2252 | op-snap---monthly-publication-august-2025.pdf | 227 | 2025-08 | Car | BMW | White | Using a Mobile Phone Whilst Driving | None | M6 Motorway | M6 Motorway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5327447 | -1.899844 | |||
| 2268 | op-snap---monthly-publication-august-2025.pdf | 243 | 2025-08 | Pedestrian | Toyota | Corolla | Black | Using a Mobile Phone Whilst Driving | None | Broad Street | Broad Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4749212 | -1.9147497 | ||
| 2287 | op-snap---monthly-publication-august-2025.pdf | 262 | 2025-08 | Other | Vauxhall | Corsa | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Norwood Road | Norwood Road | Dudley | Dudley | Fixed Penalty | N/A | 52.4831397 | -2.1309273 | ||
| 2323 | op-snap---monthly-publication-august-2025.pdf | 298 | 2025-08 | Pedal Bike | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Camphill Circus | Camphill Circus | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2331 | op-snap---monthly-publication-august-2025.pdf | 306 | 2025-08 | Car | Nissan | Micra | Black | Using a Mobile Phone Whilst Driving | None | A4148 | A4148 | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 2349 | op-snap---monthly-publication-august-2025.pdf | 324 | 2025-08 | Car | Toyota | Prius | Black | Contravening a Red Traffic Light | None | Colmore Row | Colmore Row | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4811968 | -1.9001526 | ||
| 2350 | op-snap---monthly-publication-august-2025.pdf | 325 | 2025-08 | Car | Tesla | Model Y | Blue | Using a Mobile Phone Whilst Driving | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4119174 | -1.9735247 | ||
| 2357 | op-snap---monthly-publication-august-2025.pdf | 332 | 2025-08 | Other | Mercedes-Benz | 180 | Grey | Using a Mobile Phone Whilst Driving | None | A4123 | A4123 | Sandwell | Sandwell | Fixed Penalty | N/A | ||||
| 2421 | op-snap---monthly-publication-august-2025.pdf | 396 | 2025-08 | Car | Mercedes-Benz | C220. | White | Vehicle overtake within crossing limits | None | A41 Moxley | Moxley | Walsall | Walsall | Fixed Penalty | N/A | 52.5573644 | -2.0465687 | ||
| 2422 | op-snap---monthly-publication-august-2025.pdf | 397 | 2025-08 | Car | Iveco | Daily | White | Drive on hard shoulder | None | M5 North | M5 North | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5274455 | -2.0298903 | ||
| 2451 | op-snap---monthly-publication-august-2025.pdf | 426 | 2025-08 | Car | Tesla | Model Y | Grey | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4191184 | -1.8326637 | ||
| 2458 | op-snap---monthly-publication-august-2025.pdf | 433 | 2025-08 | Pedestrian | Peugeot | 308.. | Grey | No Insurance | None | Birchley Island | Birchley Island | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4926604 | -2.0216743 | ||
| 2481 | op-snap---monthly-publication-august-2025.pdf | 456 | 2025-08 | Pedestrian | Renault | Traffic | White | Using a Mobile Phone Whilst Driving | None | Radford Road | Radford Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4235908 | -1.5226276 | ||
| 2495 | op-snap---monthly-publication-august-2025.pdf | 470 | 2025-08 | Car | Ford | Puma | Silver | Contravening a Red Traffic Light | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4437078 | -1.8783408 | ||
| 2497 | op-snap---monthly-publication-august-2025.pdf | 472 | 2025-08 | Car | Seat | Ateca | White | Contravening a Red Traffic Light | None | St Chads Queensway | Street Chads Queensway | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2509 | op-snap---monthly-publication-august-2025.pdf | 484 | 2025-08 | Car | Volkswagen | Touran | Black | Using a Mobile Phone Whilst Driving | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4726661 | -1.8769032 | ||
| 2518 | op-snap---monthly-publication-august-2025.pdf | 493 | 2025-08 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Lightswood Hill | Lightswood Hill | Sandwell | Sandwell | Fixed Penalty | N/A | ||||
| 2521 | op-snap---monthly-publication-august-2025.pdf | 496 | 2025-08 | Car | Toyota | Prius | Grey | Using a Mobile Phone Whilst Driving | None | Bordsley Circus | Bordsley Circus | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2525 | op-snap---monthly-publication-august-2025.pdf | 500 | 2025-08 | Car | Citroen | C5 | Blue | Using a Mobile Phone Whilst Driving | None | M42 J5 | M42 J5 | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 2534 | op-snap---monthly-publication-august-2025.pdf | 509 | 2025-08 | Car | Volkswagen | Golf | Black | Using a Mobile Phone Whilst Driving | None | Drummond Road | Drummond Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4776129 | -1.8391838 | ||
| 2540 | op-snap---monthly-publication-august-2025.pdf | 515 | 2025-08 | Car | Audi | Q5 | Grey | Motor vehicle fail to accord precedence at a pelican crossing | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4967329 | -1.8097462 | ||
| 2541 | op-snap---monthly-publication-august-2025.pdf | 516 | 2025-08 | Car | BMW | X5 | Black | Driving without Due Care and Attention | None | A4040 | A4040 | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2560 | op-snap---monthly-publication-august-2025.pdf | 535 | 2025-08 | Motorbike | Tesla | Model 3 | Blue | Using a Mobile Phone Whilst Driving | None | A38M | A38M | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2564 | op-snap---monthly-publication-august-2025.pdf | 539 | 2025-08 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | A4040 a Chapel Lane | A4040 a Chapel Lane | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2577 | op-snap---monthly-publication-august-2025.pdf | 552 | 2025-08 | Car | BMW | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | |||
| 2598 | op-snap---monthly-publication-august-2025.pdf | 573 | 2025-08 | Car | Toyota | Corolla | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Proffitt Street | Proffitt Street | Walsall | Walsall | Fixed Penalty | N/A | 52.5939862 | -1.9849197 | ||
| 2610 | op-snap---monthly-publication-august-2025.pdf | 585 | 2025-08 | Car | Peugeot | Boxer | White | Using a Mobile Phone Whilst Driving | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 2619 | op-snap---monthly-publication-august-2025.pdf | 594 | 2025-08 | Car | Seat | Altea | Grey | Contravening a Red Traffic Light | None | Blossomfield Road | Blossomfield Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4144779 | -1.7848758 | ||
| 2624 | op-snap---monthly-publication-august-2025.pdf | 599 | 2025-08 | Pedestrian | Yamaha | NMAX | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Corporation Street | Corporation Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4895456 | -1.8900666 | ||
| 2633 | op-snap---monthly-publication-august-2025.pdf | 608 | 2025-08 | Car | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Tansey Green Road | Tansey Green Road | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | ||||
| 2639 | op-snap---monthly-publication-august-2025.pdf | 614 | 2025-08 | Car | Volvo | XC40 | Black | Contravening a Red Traffic Light | None | Pedmore Road Brierley Hill | Pedmore Road Brierley Hill | Dudley | Dudley | Fixed Penalty | N/A | 52.4897451 | -2.1069141 | ||
| 2646 | op-snap---monthly-publication-august-2025.pdf | 621 | 2025-08 | Car | Mercedes-Benz | A180 | Blue | Contravening a Red Traffic Light | None | Stourbridge Road | Stourbridge Road | Dudley | Dudley | Fixed Penalty | N/A | 52.5002997 | -2.1081386 | ||
| 2658 | op-snap---monthly-publication-august-2025.pdf | 633 | 2025-08 | Car | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Blossomfield Road | Blossomfield Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4144779 | -1.7848758 | ||
| 2670 | op-snap---monthly-publication-august-2025.pdf | 645 | 2025-08 | Car | Volkswagen | Passatt | Black | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5083238 | -1.8332287 | ||
| 2679 | op-snap---monthly-publication-august-2025.pdf | 654 | 2025-08 | Car | BMW | X1.. | Grey | Contravening a Red Traffic Light | None | New John Street | New John Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4920451 | -1.8920402 | ||
| 2693 | op-snap---monthly-publication-august-2025.pdf | 668 | 2025-08 | Car | Ford | Puma | Grey | Driving without Due Care and Attention | None | Key Hill Circus Roundabout | Key Hill Circus Roundabout | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2694 | op-snap---monthly-publication-august-2025.pdf | 669 | 2025-08 | Pedestrian | Mercedes-Benz | CLA220 | Grey | Driving without Due Care and Attention | None | M5 South | M5 South | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5228877 | -2.0650728 | ||
| 2697 | op-snap---monthly-publication-august-2025.pdf | 672 | 2025-08 | Car | Volkswagen | Passat | White | Contravening a Red Traffic Light | None | Church Lane | Church Lane | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5311655 | -2.0008707 | ||
| 2698 | op-snap---monthly-publication-august-2025.pdf | 673 | 2025-08 | Car | Seat | Ibiza | Red | Contravening a Red Traffic Light | None | Tettenhall Road | Tettenhall Road | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | 52.5883523 | -2.1466187 | ||
| 2701 | op-snap---monthly-publication-august-2025.pdf | 676 | 2025-08 | Pedestrian | Toyota | Prius | White | Contravening a Red Traffic Light | None | Newtown Road | Newtown Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4990909 | -1.8963634 | ||
| 2717 | op-snap---monthly-publication-august-2025.pdf | 692 | 2025-08 | Other | Citroen | Dispatch | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Norwood Road | Norwood Road | Dudley | Dudley | Fixed Penalty | N/A | 52.4831397 | -2.1309273 | ||
| 2718 | op-snap---monthly-publication-august-2025.pdf | 693 | 2025-08 | Car | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | Mincing Lane | Mincing Lane | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4830242 | -2.0339971 | ||
| 2721 | op-snap---monthly-publication-august-2025.pdf | 696 | 2025-08 | Other | Ford | Transit | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Norwood Road | Norwood Road | Dudley | Dudley | Fixed Penalty | N/A | 52.4831397 | -2.1309273 | ||
| 2722 | op-snap---monthly-publication-august-2025.pdf | 697 | 2025-08 | Pedal Bike | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4275505 | -1.4448681 | ||
| 2745 | op-snap---monthly-publication-august-2025.pdf | 720 | 2025-08 | Car | Fiat | Doblo | Grey | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 2749 | op-snap---monthly-publication-august-2025.pdf | 724 | 2025-08 | Car | Nissan | X Trail | White | Using a Mobile Phone Whilst Driving | None | Heartlands Hopsital (car park) | Heartlands Hopsital (car park) | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2765 | op-snap---monthly-publication-august-2025.pdf | 740 | 2025-08 | Car | Renault | Megane | White | Contravening a Red Traffic Light | None | A4123 (Coseley) | A4123 (Coseley) | Dudley | Dudley | Fixed Penalty | N/A | 52.5477155 | -2.0940631 | ||
| 2768 | op-snap---monthly-publication-august-2025.pdf | 743 | 2025-08 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Redditch Road | Redditch Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.3954946 | -1.9516557 | ||
| 2776 | op-snap---monthly-publication-august-2025.pdf | 751 | 2025-08 | Pedestrian | Yamaha | 125cc | Black | Contravening a Red Traffic Light | No Insurance | Hagley Road, Quinton | Hagley Road, Quinton | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4633457 | -2.0003455 | ||
| 2779 | op-snap---monthly-publication-august-2025.pdf | 754 | 2025-08 | Car | Vauxhall | Astra | Grey | Contravening a Red Traffic Light | None | A5127 Gravely Hill North | Gravely Hill North | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2806 | op-snap---monthly-publication-august-2025.pdf | 781 | 2025-08 | Car | Hyundai | I10.. | Grey | Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver | None | Allard Way | Allard Way | Coventry | Coventry | Fixed Penalty | N/A | 52.3955174 | -1.4685442 | ||
| 2807 | op-snap---monthly-publication-august-2025.pdf | 782 | 2025-08 | Pedestrian | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 2821 | op-snap---monthly-publication-august-2025.pdf | 796 | 2025-08 | Car | Peugeot | 2008 | White | Driving a vehicle wholly or partly on a footpath | None | Anchorage Road | Anchorage Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5699381 | -1.8249539 | ||
| 2843 | op-snap---monthly-publication-august-2025.pdf | 818 | 2025-08 | Car | Ford | Cmax | Blue | Contravening a Red Traffic Light | Use vehicle on a road without valid test ce | rBtiirfmicaintegham Road A34 | r Btiirfmicaintegham Road A34 | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 2863 | op-snap---monthly-publication-august-2025.pdf | 838 | 2025-08 | Car | Volkswagen | Transporter | White | Using a Mobile Phone Whilst Driving | None | M6 NB J6-7 | M6 Northbound J6-7 | Birmingham | Birmingham | Fixed Penalty | N/A | 52.6760749 | -2.0862582 | ||
| 2864 | op-snap---monthly-publication-august-2025.pdf | 839 | 2025-08 | Pedestrian | Peugeot | E 3008 | White | Using a Mobile Phone Whilst Driving | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4555288 | -1.8613929 | ||
| 2875 | op-snap---monthly-publication-august-2025.pdf | 850 | 2025-08 | Car | Ford | Eco sport | Blue | Driving without Due Care and Attention | None | Haslucks Green Road | Haslucks Green Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4145149 | -1.8301272 | ||
| 2918 | op-snap---monthly-publication-august-2025.pdf | 893 | 2025-08 | Car | Seat | Ibiza | White | Contravening a Red Traffic Light | None | Lower High Street Wednesbury | Lower High Street Wednesbury | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5494463 | -2.0190134 | ||
| 2921 | op-snap---monthly-publication-august-2025.pdf | 896 | 2025-08 | Car | Citroen | C1 | Orange | Contravening a Red Traffic Light | None | Lode Lane | Lode Lane | Solihull | Solihull | Fixed Penalty | N/A | 52.4149064 | -1.7832364 | ||
| 2934 | op-snap---monthly-publication-august-2025.pdf | 909 | 2025-08 | Pedal Bike | Zontes ZT M/C | Silver | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | |||
| 2935 | op-snap---monthly-publication-august-2025.pdf | 910 | 2025-08 | Car | Audi | Q4 Etron | Blue | Driving without Due Care and Attention | None | Widney Lane | Widney Lane | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 2937 | op-snap---monthly-publication-august-2025.pdf | 912 | 2025-08 | Car | Vauxhall | Vivaro | Red | Driving without Due Care and Attention | None | Thimble Lane | Thimble Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5013989 | -1.8730898 | ||
| 2953 | op-snap---monthly-publication-august-2025.pdf | 928 | 2025-08 | Car | Mini | Cooper | Silver | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4167654 | -1.9411244 | ||
| 2954 | op-snap---monthly-publication-august-2025.pdf | 929 | 2025-08 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4167654 | -1.9411244 | ||
| 2963 | op-snap---monthly-publication-august-2025.pdf | 938 | 2025-08 | Other | Aprilla | White | Driving without Due Care and Attention | None | High Street Dudley | High Street Dudley | Dudley | Dudley | Fixed Penalty | N/A | 52.4506569 | -2.0527394 | |||
| 2965 | op-snap---monthly-publication-august-2025.pdf | 940 | 2025-08 | Car | Skoda | Octavia | Blue | Contravening a Red Traffic Light | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5517052 | -1.7825505 | ||
| 2976 | op-snap---monthly-publication-august-2025.pdf | 951 | 2025-08 | Car | Mercedes-Benz | A class | Black | Using a Mobile Phone Whilst Driving | None | Cherry Tree Avenue | Cherry Tree Avenue | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 2980 | op-snap---monthly-publication-august-2025.pdf | 955 | 2025-08 | Car | Jaguar | E Pace | Red | Driving without Due Care and Attention | None | College Road | College Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5151832 | -1.9361664 | ||
| 2994 | op-snap---monthly-publication-august-2025.pdf | 969 | 2025-08 | Pedestrian | BMW | 1 Series | Grey | Using a Mobile Phone Whilst Driving | None | Woodstock Road | Woodstock Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4486205 | -1.8740822 | ||
| 3010 | op-snap---monthly-publication-august-2025.pdf | 985 | 2025-08 | Car | Harley Davidson | Black | Driving without Due Care and Attention | None | Duncan Edwards Way A461 | Duncan Edwards Way A461 | Dudley | Dudley | Fixed Penalty | N/A | 52.5101471 | -2.0771378 | |||
| 3017 | op-snap---monthly-publication-august-2025.pdf | 992 | 2025-08 | Car | Audi | A3.. | White | Contravening a Red Traffic Light | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4437078 | -1.8783408 | ||
| 3018 | op-snap---monthly-publication-august-2025.pdf | 993 | 2025-08 | Car | Peugeot | 2008.. | Black | Contravening a Red Traffic Light | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4437078 | -1.8783408 | ||
| 3026 | op-snap---monthly-publication-august-2025.pdf | 1001 | 2025-08 | Car | Toyota | Corolla | Silver | Driving without Due Care and Attention | None | Old Lode Lane | Old Lode Lane | Solihull | Solihull | Fixed Penalty | N/A | 52.4496642 | -1.7805476 | ||
| 3040 | op-snap---monthly-publication-august-2025.pdf | 1015 | 2025-08 | Car | BMW | M135i | Grey | Driving without Due Care and Attention | None | Stonehouse Lane | Stonehouse Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4440435 | -1.9818872 | ||
| 3048 | op-snap---monthly-publication-august-2025.pdf | 1023 | 2025-08 | Car | Seat | Leon | White | Driving without Due Care and Attention | None | A45 Coventry near Broad Lane Jct | Coventry near Broad Lane Junction | Coventry | Coventry | Fixed Penalty | N/A | 52.400739 | -1.5135474 | ||
| 3057 | op-snap---monthly-publication-august-2025.pdf | 1032 | 2025-08 | Other | Yamaha | GPD125 | Red | Driving without Due Care and Attention | None | MerryHill Car Park | Merry Hill Car Park | Dudley | Dudley | Fixed Penalty | N/A | ||||
| 3061 | op-snap---monthly-publication-august-2025.pdf | 1036 | 2025-08 | Car | Kia | Niro | Grey | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 3097 | op-snap---monthly-publication-august-2025.pdf | 1072 | 2025-08 | Car | Peugeot | Bipper | White | Using a Mobile Phone Whilst Driving | None | Sheldon Heath Road | Sheldon Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4744736 | -1.7892633 | ||
| 3109 | op-snap---monthly-publication-august-2025.pdf | 1084 | 2025-08 | Pedal Bike | Toyota | Avensis | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Poplar Road, Kings Heath | Poplar Road, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.436035 | -1.891685 | ||
| 3118 | op-snap---monthly-publication-august-2025.pdf | 1093 | 2025-08 | Pedal Bike | Toyota | Auris | Grey | Using a Mobile Phone Whilst Driving | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4167654 | -1.9411244 | ||
| 3119 | op-snap---monthly-publication-august-2025.pdf | 1094 | 2025-08 | Pedal Bike | Nissan | Note | Grey | Using a Mobile Phone Whilst Driving | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4390303 | -1.9512931 | ||
| 3130 | op-snap---monthly-publication-august-2025.pdf | 1105 | 2025-08 | Car | Seat | Ibiza | Red | Driving without Due Care and Attention | None | M5 Jct 1 North | M5 Junction 1 North | Sandwell | Sandwell | Fixed Penalty | 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);