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'}
1,294 rows where reporter_transport_mode = "Car" and vehicle_make = "Mercedes-Benz" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
offence >30
- Driving without Due Care and Attention 455
- Contravening a Red Traffic Light 248
- Stop a vehicle within pelican pedestrian crossing limits 94
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 93
- Cause vehicle to be left in a dangerous position 64
- Driving without Reasonable Consideration 63
- Using a Mobile Phone Whilst Driving 58
- Stop a vehicle on pedestrian crossing 45
- Misc - Non Traffic Offences 35
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 27
- Cause unnecessary obstruction by motor vehicle 18
- VRM fails to conform to Regulations 14
- Contravene Lane Closure Red X 13
- Drive on hard shoulder 9
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 8
- Dangerous Driving 6
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 5
- Vehicle overtake within crossing limits 5
- Drive a vehicle other than on the carriageway of a motorway 3
- Motor vehicle fail to accord precedence at a pelican crossing 3
- Prohibited vehicle in offside lane of motorway 3
- Drive a vehicle other than on the carriageway of a 2
- Driving a vehicle wholly or partly on a footpath 2
- Keeping a vehicle with registration marks obscured 2
- Motor vehicle fail to comply with endorsable sect 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 2
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
- Contravene a Red Traffic Light 1
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Driver not in position to have Proper Control 1
- …
council_area 16
- Birmingham 751
- Out of Force Area 108
- Coventry 89
- Sandwell 83
- Solihull 77
- Wolverhampton 60
- Walsall 54
- Dudley 36
- Sutton Coldfield 22
- Halesowen 6
- Out Of Force Area 2
- Area 1
- Metropolitan Borough 1
- Metropolitan Borough Of Dudley 1
- Moeust Voaf Lfleoyr)Ce Area 1
- Ysandwell 1
month 14
disposal 8
- NFA 479
- Warning Letter 313
- Education 241
- Fixed Penalty 178
- Court 66
- RTC - Actioned 10
- Other Action Taken 6
- Duplicate Submission 1
vehicle_make 1
- Mercedes-Benz · 1,294 ✖
reporter_transport_mode 1
- Car · 1,294 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8887 | op-snap---monthly-publication-february-2026.pdf | 1634 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Benton Road | Benton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4589836 | -1.8637054 | ||
| 8846 | op-snap---monthly-publication-february-2026.pdf | 1593 | 2026-02 | Car | Mercedes-Benz | slk | White | Misc - Non Traffic Offences | None | lower queen street | Lower Queen Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5603978 | -1.8227403 | ||
| 8829 | op-snap---monthly-publication-february-2026.pdf | 1576 | 2026-02 | Car | Mercedes-Benz | sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8805 | op-snap---monthly-publication-february-2026.pdf | 1552 | 2026-02 | Car | Mercedes-Benz | Splinter | White | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Birmingham | Birmingham | Education | N/A | 52.5027779 | -1.7982159 | ||
| 8796 | op-snap---monthly-publication-february-2026.pdf | 1543 | 2026-02 | Car | Mercedes-Benz | c220 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8795 | op-snap---monthly-publication-february-2026.pdf | 1542 | 2026-02 | Car | Mercedes-Benz | sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8794 | op-snap---monthly-publication-february-2026.pdf | 1541 | 2026-02 | Car | Mercedes-Benz | c220 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | victoria street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 8748 | op-snap---monthly-publication-february-2026.pdf | 1495 | 2026-02 | Car | Mercedes-Benz | S220D | Blue | Misc - Non Traffic Offences | No vehicle excise licence | Moseley Road | Moseley Road | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4679402 | -1.881408 | ||
| 8697 | op-snap---monthly-publication-february-2026.pdf | 1444 | 2026-02 | Car | Mercedes-Benz | Blue | Driving without Due Care and Attention | None | Southam Road | Southam Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4334787 | -1.8516882 | |||
| 8695 | op-snap---monthly-publication-february-2026.pdf | 1442 | 2026-02 | Car | Mercedes-Benz | A Class | Black | Contravening a Red Traffic Light | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 8680 | op-snap---monthly-publication-february-2026.pdf | 1427 | 2026-02 | Car | Mercedes-Benz | C220 | White | Contravening a Red Traffic Light | None | Longbridge Lane | Longbridge Lane | Birmingham | Birmingham | NFA | No Offence | 52.3962003 | -1.9821252 | ||
| 8668 | op-snap---monthly-publication-february-2026.pdf | 1415 | 2026-02 | Car | Mercedes-Benz | Vito | White | Driving without Due Care and Attention | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | Warning Letter | N/A | 52.4214017 | -1.4870278 | ||
| 8657 | op-snap---monthly-publication-february-2026.pdf | 1404 | 2026-02 | Car | Mercedes-Benz | Black | Driving without Due Care and Attention | None | M42 SB J6 | M42 Southbound J6 | Solihull | Solihull | NFA | No VRM | |||||
| 8613 | op-snap---monthly-publication-february-2026.pdf | 1360 | 2026-02 | Car | Mercedes-Benz | CLA | Black | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 8607 | op-snap---monthly-publication-february-2026.pdf | 1354 | 2026-02 | Car | Mercedes-Benz | A180 | Red | Stop a vehicle on pedestrian crossing | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8563 | op-snap---monthly-publication-february-2026.pdf | 1310 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 8554 | op-snap---monthly-publication-february-2026.pdf | 1301 | 2026-02 | Car | Mercedes-Benz | E220 | Silver | Driving without Due Care and Attention | None | London Road to A444 Whitley Interchange | London Road to A444 Whitley Interchange | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 8534 | op-snap---monthly-publication-february-2026.pdf | 1281 | 2026-02 | Car | Mercedes-Benz | E300 | Black | Driving without Due Care and Attention | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 8494 | op-snap---monthly-publication-february-2026.pdf | 1241 | 2026-02 | Car | Mercedes-Benz | 400 AMG | Black | Driving without Reasonable Consideration | None | Hockley Lane | Hockley Lane | Coventry | Coventry | Education | N/A | 52.4165323 | -1.6001601 | ||
| 8460 | op-snap---monthly-publication-february-2026.pdf | 1207 | 2026-02 | Car | Mercedes-Benz | E200 | Black | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Education | N/A | 52.5083238 | -1.8332287 | ||
| 8435 | op-snap---monthly-publication-february-2026.pdf | 1182 | 2026-02 | Car | Mercedes-Benz | GLE | Black | Driving without Due Care and Attention | None | M4 towards Central London | M4 towards Central London | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8434 | op-snap---monthly-publication-february-2026.pdf | 1181 | 2026-02 | Car | Mercedes-Benz | C220D | White | Driving without Due Care and Attention | None | A45 | A45 | Birmingham | Birmingham | NFA | No Offence | ||||
| 8422 | op-snap---monthly-publication-february-2026.pdf | 1169 | 2026-02 | Car | Mercedes-Benz | E320 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way / Balkwill Cres | Hertford Way / Balkwill Crescent | Solihull | Solihull | Warning Letter | N/A | 52.3778812 | -1.7427424 | ||
| 8419 | op-snap---monthly-publication-february-2026.pdf | 1166 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | Court | N/A | 52.4760986 | -1.9018641 | ||
| 8415 | op-snap---monthly-publication-february-2026.pdf | 1162 | 2026-02 | Car | Mercedes-Benz | sprinter | White | Using a Mobile Phone Whilst Driving | None | M42 J3 | M42 J3 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4846642 | -1.9297585 | ||
| 8393 | op-snap---monthly-publication-february-2026.pdf | 1140 | 2026-02 | Car | Mercedes-Benz | GLE 450 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 8388 | op-snap---monthly-publication-february-2026.pdf | 1135 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 8369 | op-snap---monthly-publication-february-2026.pdf | 1116 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 8359 | op-snap---monthly-publication-february-2026.pdf | 1106 | 2026-02 | Car | Mercedes-Benz | CLA | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Spon Lane, West Bromwich | Spon Lane, West Bromwich | Sandwell | Sandwell | Warning Letter | N/A | 52.5151568 | -1.9909305 | ||
| 8338 | op-snap---monthly-publication-february-2026.pdf | 1085 | 2026-02 | Car | Mercedes-Benz | White | Drive a vehicle other than on the carriageway of a motorway | None | M62 towards NEC J6 | M62 towards NEC J6 | Birmingham | Birmingham | Education | N/A | |||||
| 8306 | op-snap---monthly-publication-february-2026.pdf | 1053 | 2026-02 | Car | Mercedes-Benz | A200 | Black | Driving without Due Care and Attention | M5 Motorway Jn1 | M5 Motorway Jn1 | Sandwell | Sandwell | Education | N/A | |||||
| 8296 | op-snap---monthly-publication-february-2026.pdf | 1043 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | West Bromwich Ringway | West Bromwich Ringway | Sandwell | Sandwell | NFA | No Offence | 52.516463 | -1.9937537 | ||
| 8265 | op-snap---monthly-publication-february-2026.pdf | 1012 | 2026-02 | Car | Mercedes-Benz | CLS 220 | White | Driving without Due Care and Attention | None | A34 | A34 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8263 | op-snap---monthly-publication-february-2026.pdf | 1010 | 2026-02 | Car | Mercedes-Benz | GLB | White | Drive on hard shoulder | None | M6 NB J8 | M6 Northbound J8 | Sandwell | Sandwell | Education | N/A | 52.6760749 | -2.0862582 | ||
| 8243 | op-snap---monthly-publication-february-2026.pdf | 990 | 2026-02 | Car | Mercedes-Benz | E55 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 8217 | op-snap---monthly-publication-february-2026.pdf | 964 | 2026-02 | Car | Mercedes-Benz | C200.. | Grey | Driving a vehicle wholly or partly on a footpath | None | Washwood Heath Road at Drews Lane. | Washwood Heath Road at Drews Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4949047 | -1.8544884 | ||
| 8213 | op-snap---monthly-publication-february-2026.pdf | 960 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Education | N/A | 52.5521118 | -1.8845138 | ||
| 8209 | op-snap---monthly-publication-february-2026.pdf | 956 | 2026-02 | Car | Mercedes-Benz | C220 D | Black | Driving without Due Care and Attention | None | Lawley MIddleway | Lawley MIddleway | Birmingham | Birmingham | Court | N/A | 52.4801772 | -1.8769185 | ||
| 8184 | op-snap---monthly-publication-february-2026.pdf | 931 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Bills Lane | Bills Lane | Solihull | Solihull | Education | N/A | 52.3998632 | -1.8392819 | ||
| 8158 | op-snap---monthly-publication-february-2026.pdf | 905 | 2026-02 | Car | Mercedes-Benz | Tipper | White | Driving without Due Care and Attention | None | M6 Motorway | M6 Motorway | Walsall | Walsall | Education | N/A | 52.6151447 | -2.0290522 | ||
| 8152 | op-snap---monthly-publication-february-2026.pdf | 899 | 2026-02 | Car | Mercedes-Benz | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830179 | -1.783876 | |||
| 8149 | op-snap---monthly-publication-february-2026.pdf | 896 | 2026-02 | Car | Mercedes-Benz | Sprinter | Red | Stop a vehicle on pedestrian crossing | None | Boldmere Road | Boldmere Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.548309 | -1.8411769 | ||
| 8122 | op-snap---monthly-publication-february-2026.pdf | 869 | 2026-02 | Car | Mercedes-Benz | B180 | Silver | Driving without Due Care and Attention | None | Bordesley Circus | Bordesley Circus | Birmingham | Birmingham | Education | N/A | 52.4728608 | -1.8754722 | ||
| 8114 | op-snap---monthly-publication-february-2026.pdf | 861 | 2026-02 | Car | Mercedes-Benz | C43 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | A34 Walsall Road | Walsall Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5919543 | -1.8517118 | ||
| 8078 | op-snap---monthly-publication-february-2026.pdf | 825 | 2026-02 | Car | Mercedes-Benz | C class | Black | Driving without Due Care and Attention | None | Bescot Road, Walsall | Bescot Road, Walsall | Walsall | Walsall | NFA | 52.5714189 | -2.0010178 | |||
| 8055 | op-snap---monthly-publication-february-2026.pdf | 802 | 2026-02 | Car | Mercedes-Benz | EQA 250 | Black | Driving without Due Care and Attention | None | Longbridge Roadabout at the M40 (Warickshire) | Longbridge Roadabout at the M40 (Warickshire) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8036 | op-snap---monthly-publication-february-2026.pdf | 783 | 2026-02 | Car | Mercedes-Benz | Blue | Driving without Due Care and Attention | None | M18 (Out of Force) | M18 (Out of Force) | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 8029 | op-snap---monthly-publication-february-2026.pdf | 776 | 2026-02 | Car | Mercedes-Benz | A180 | Grey | Driving without Due Care and Attention | None | Gay Hill Road | Gay Hill Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8026 | op-snap---monthly-publication-february-2026.pdf | 773 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | M6 SB J10 | M6 Southbound J10 | Walsall | Walsall | Education | N/A | 52.676119 | -2.0858425 | ||
| 8024 | op-snap---monthly-publication-february-2026.pdf | 771 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | School Road | School Road | Solihull | Solihull | NFA | No Offence | 52.3517888 | -1.7783232 | ||
| 8013 | op-snap---monthly-publication-february-2026.pdf | 760 | 2026-02 | Car | Mercedes-Benz | A180 | Grey | Contravening a Red Traffic Light | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | Education | N/A | 52.473883 | -1.9198244 | ||
| 8008 | op-snap---monthly-publication-february-2026.pdf | 755 | 2026-02 | Car | Mercedes-Benz | White | Contravening a Red Traffic Light | None | Harbourne Road | Harborne Road | Birmingham | Birmingham | NFA | No VRM | 52.4718503 | -1.9195423 | |||
| 7993 | op-snap---monthly-publication-february-2026.pdf | 740 | 2026-02 | Car | Mercedes-Benz | GLC | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hobbs Road | Hobbs Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 7988 | op-snap---monthly-publication-february-2026.pdf | 735 | 2026-02 | Car | Mercedes-Benz | A Class | Silver | Contravening a Red Traffic Light | None | Longmore Street | Longmore Street | Birmingham | Birmingham | Education | N/A | 52.464484 | -1.8923374 | ||
| 7959 | op-snap---monthly-publication-february-2026.pdf | 706 | 2026-02 | Car | Mercedes-Benz | 320.. | Black | Contravening a Red Traffic Light | None | Wolverhampton Road | Wolverhampton Road | Sandwell | Sandwell | Education | N/A | 52.4702299 | -1.9948976 | ||
| 7958 | op-snap---monthly-publication-february-2026.pdf | 705 | 2026-02 | Car | Mercedes-Benz | EAQ 350 | Grey | Driving without Reasonable Consideration | None | Five ways | Five ways | Birmingham | Birmingham | Warning Letter | N/A | 52.4710941 | -1.9130708 | ||
| 7954 | op-snap---monthly-publication-february-2026.pdf | 701 | 2026-02 | Car | Mercedes-Benz | A200 | Grey | Driving without Due Care and Attention | None | Foley Road East | Foley Road East | Walsall | Walsall | NFA | No Offence | 52.5842493 | -1.879646 | ||
| 7935 | op-snap---monthly-publication-february-2026.pdf | 682 | 2026-02 | Car | Mercedes-Benz | HGV | White | Driving without Due Care and Attention | None | M42 jct 7 - 7A | M42 jct 7 - 7A | Solihull | Solihull | NFA | Out of Force | ||||
| 7835 | op-snap---monthly-publication-february-2026.pdf | 582 | 2026-02 | Car | Mercedes-Benz | EQB | Black | Driving without Due Care and Attention | None | Sewall Highway | Sewall Highway | Coventry | Coventry | Education | N/A | 52.4318623 | -1.4804069 | ||
| 7809 | op-snap---monthly-publication-february-2026.pdf | 556 | 2026-02 | Car | Mercedes-Benz | A180 | Red | Driving without Due Care and Attention | None | A38 | A38 | Birmingham | Birmingham | Education | N/A | ||||
| 7799 | op-snap---monthly-publication-february-2026.pdf | 546 | 2026-02 | Car | Mercedes-Benz | A Class | Black | Contravening a Red Traffic Light | No Insurance | Jockey Road | Jockey Road | Sutton Coldfield | Sutton Coldfield | Court | N/A | 52.5535276 | -1.8302584 | ||
| 7798 | op-snap---monthly-publication-february-2026.pdf | 545 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | A5 | A5 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7776 | op-snap---monthly-publication-february-2026.pdf | 523 | 2026-02 | Car | Mercedes-Benz | A180 | Silver | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7769 | op-snap---monthly-publication-february-2026.pdf | 516 | 2026-02 | Car | Mercedes-Benz | GLA | black | Driving without Due Care and Attention | None | Kenilworth Road, A452, nr Balsall Common | Kenilworth Road, A452, nr Balsall Common | Solihull | Solihull | Warning Letter | N/A | ||||
| 7766 | op-snap---monthly-publication-february-2026.pdf | 513 | 2026-02 | Car | Mercedes-Benz | CLA 180 | White | Contravening a Red Traffic Light | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | No Offence | 52.513336 | -1.8833226 | ||
| 7765 | op-snap---monthly-publication-february-2026.pdf | 512 | 2026-02 | Car | Mercedes-Benz | Splinter | Green | Stop a vehicle within pelican pedestrian crossing limits | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 7746 | op-snap---monthly-publication-february-2026.pdf | 493 | 2026-02 | Car | Mercedes-Benz | A180.. | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7637 | op-snap---monthly-publication-february-2026.pdf | 384 | 2026-02 | Car | Mercedes-Benz | C200 | Blue | Misc - Non Traffic Offences | Use vehicle on a road without valid test certificate | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4096725 | -1.487901 | ||
| 7633 | op-snap---monthly-publication-february-2026.pdf | 380 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Leicester Road Rugby (Warcs) | Leicester Road Rugby (Warcs) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7625 | op-snap---monthly-publication-february-2026.pdf | 372 | 2026-02 | Car | Mercedes-Benz | CLA 220 | Red | Driving without Due Care and Attention | None | Coventry A45 W | Coventry A45 W | Coventry | Coventry | Education | N/A | 52.4314215 | -1.5948907 | ||
| 7616 | op-snap---monthly-publication-february-2026.pdf | 363 | 2026-02 | Car | Mercedes-Benz | A200 | White | Contravening a Red Traffic Light | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 7534 | op-snap---monthly-publication-february-2026.pdf | 281 | 2026-02 | Car | Mercedes-Benz | SLK200 | Silver | Driving without Due Care and Attention | None | A51 Birmingham Road | Birmingham Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7515 | op-snap---monthly-publication-february-2026.pdf | 262 | 2026-02 | Car | Mercedes-Benz | C 220 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Springfield Road Halesowen | Springfield Road Halesowen | Dudley | Dudley | NFA | No Offence | 52.4664617 | -2.0319975 | ||
| 7492 | op-snap---monthly-publication-february-2026.pdf | 239 | 2026-02 | Car | Mercedes-Benz | Black | Contravening a Red Traffic Light | None | Talgarth Road London | Talgarth Road London | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 7478 | op-snap---monthly-publication-february-2026.pdf | 225 | 2026-02 | Car | Mercedes-Benz | C220 | Black | Contravening a Red Traffic Light | None | Kings Road | Kings Road | Birmingham | Birmingham | Education | N/A | 52.5531351 | -1.8852761 | ||
| 7473 | op-snap---monthly-publication-february-2026.pdf | 220 | 2026-02 | Car | Mercedes-Benz | 312.. | White | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7471 | op-snap---monthly-publication-february-2026.pdf | 218 | 2026-02 | Car | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7385 | op-snap---monthly-publication-february-2026.pdf | 132 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7319 | op-snap---monthly-publication-february-2026.pdf | 66 | 2026-02 | Car | Mercedes-Benz | 160 | White | Driving without Due Care and Attention | None | Ringway Queens | Ringway Queens | Coventry | Coventry | NFA | No Offence | 52.4039782 | -1.5161639 | ||
| 7281 | op-snap---monthly-publication-february-2026.pdf | 28 | 2026-02 | Car | Mercedes-Benz | G63 | Black | Driving without Due Care and Attention | None | M6 Toll T8 | M6 Toll T8 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5804962 | -1.7833098 | ||
| 7277 | op-snap---monthly-publication-february-2026.pdf | 24 | 2026-02 | Car | Mercedes-Benz | CLC 220 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Warwick Road | Warwick Road | Solihull | Solihull | Duplicate Submission | Duplicate Submission | 52.4428606 | -1.812114 | ||
| 7266 | op-snap---monthly-publication-february-2026.pdf | 13 | 2026-02 | Car | Mercedes-Benz | CLA 250.. | White | Driving without Due Care and Attention | None | Solihull Bypass | Solihull Bypass | Solihull | Solihull | Fixed Penalty | N/A | 52.4207529 | -1.7757467 | ||
| 7265 | op-snap---monthly-publication-february-2026.pdf | 12 | 2026-02 | Car | Mercedes-Benz | CLA 180 | Black | Contravening a Red Traffic Light | None | Oak Tree Lane | Oak Tree Lane | Birmingham | Birmingham | Education | N/A | 52.431258 | -1.9394381 | ||
| 7258 | op-snap---monthly-publication-february-2026.pdf | 5 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Delph Road, | Delph Road | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4754271 | -2.1310168 | ||
| 11861 | op-snap---monthly-publication-january-2026.pdf | 1322 | 2026-01 | Car | Mercedes-Benz | GLE 450. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Education | N/A | 52.4437078 | -1.8783408 | ||
| 11818 | op-snap---monthly-publication-january-2026.pdf | 1279 | 2026-01 | Car | Mercedes-Benz | Sprinter | Blue | Contravening a Red Traffic Light | None | Frankwell Island, Shrewsbury | Frankwell Island, Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11796 | op-snap---monthly-publication-january-2026.pdf | 1257 | 2026-01 | Car | Mercedes-Benz | Sprinter | White | Stop a vehicle on pedestrian crossing | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Education | N/A | 52.4437078 | -1.8783408 | ||
| 11746 | op-snap---monthly-publication-january-2026.pdf | 1207 | 2026-01 | Car | Mercedes-Benz | CLK 280 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11734 | op-snap---monthly-publication-january-2026.pdf | 1195 | 2026-01 | Car | Mercedes-Benz | Sprinter | Silver | Contravening a Red Traffic Light | None | Spitfire Island | Spitfire Island | Birmingham | Birmingham | Education | N/A | 52.5138106 | -1.797297 | ||
| 11709 | op-snap---monthly-publication-january-2026.pdf | 1170 | 2026-01 | Car | Mercedes-Benz | C220 | Black | Driving without Due Care and Attention | None | Bath Row | Bath Row | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.472238 | -1.9127983 | ||
| 11703 | op-snap---monthly-publication-january-2026.pdf | 1164 | 2026-01 | Car | Mercedes-Benz | sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 11673 | op-snap---monthly-publication-january-2026.pdf | 1134 | 2026-01 | Car | Mercedes-Benz | A45.. | Black | Driving without Due Care and Attention | No Insurance | Calthorpe Road | Calthorpe Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5142235 | -1.9073557 | ||
| 11637 | op-snap---monthly-publication-january-2026.pdf | 1098 | 2026-01 | Car | Mercedes-Benz | CLK 200 | Silver | Driving without Due Care and Attention | None | Warwickshire | Warwickshire | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4318492 | -1.7319529 | ||
| 11625 | op-snap---monthly-publication-january-2026.pdf | 1086 | 2026-01 | Car | Mercedes-Benz | EQC | Blue | Driving without Due Care and Attention | None | Bosworth Drive | Bosworth Drive | Solihull | Solihull | Education | N/A | 52.4780944 | -1.7586668 | ||
| 11616 | op-snap---monthly-publication-january-2026.pdf | 1077 | 2026-01 | Car | Mercedes-Benz | C220d | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 11611 | op-snap---monthly-publication-january-2026.pdf | 1072 | 2026-01 | Car | Mercedes-Benz | Vito | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 11578 | op-snap---monthly-publication-january-2026.pdf | 1039 | 2026-01 | Car | Mercedes-Benz | C220 | Blue | Driving without Due Care and Attention | None | Heath Way | Heath Way | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4963549 | -1.7806171 | ||
| 11542 | op-snap---monthly-publication-january-2026.pdf | 1003 | 2026-01 | Car | Mercedes-Benz | A250 | Grey | Driving without Due Care and Attention | None | Blackberry Lane | Blackberry Lane | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5962461 | -1.8492935 | ||
| 11498 | op-snap---monthly-publication-january-2026.pdf | 959 | 2026-01 | Car | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Education | N/A | 52.4437078 | -1.8783408 | ||
| 11429 | op-snap---monthly-publication-january-2026.pdf | 890 | 2026-01 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 |
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);