reports

Each row is one public submission to Operation Snap. Includes the offence, vehicle details, location, and outcome.

Disposal outcomes: Education (driver awareness course), Warning Letter, Fixed Penalty (fine), Court (prosecution), NFA (no further action).

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'}

765 rows where disposal = "NFA" and vehicle_make = "Mercedes-Benz" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

offence >30

month 14

reporter_transport_mode 10

vehicle_make 1

  • Mercedes-Benz · 765 ✖

disposal 1

  • NFA · 765 ✖
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
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
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
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
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      
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
7521 op-snap---monthly-publication-february-2026.pdf   268 2026-02 Pedestrian Mercedes-Benz   Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dudley Road Dudley Road Birmingham Birmingham NFA Misc Inc Crimes   52.4865107 -1.9386263
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      
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      
7704 op-snap---monthly-publication-february-2026.pdf   451 2026-02 Other Mercedes-Benz E220 Grey Driving a vehicle wholly or partly on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA Not in Public Interest   52.5521118 -1.8845138
7719 op-snap---monthly-publication-february-2026.pdf   466 2026-02 Other Mercedes-Benz E220 Grey Driving a vehicle wholly or partly on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA Not in Public Interest   52.5521118 -1.8845138
7736 op-snap---monthly-publication-february-2026.pdf   483 2026-02 Other Mercedes-Benz   Grey Driving without Due Care and Attention None London somewhere? This is from social media. London somewhere? This is from social media Out of Force Area Out of Force Area NFA Out of Force      
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
7791 op-snap---monthly-publication-february-2026.pdf   538 2026-02 Other Mercedes-Benz E220 Grey Driving a vehicle wholly or partly on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA No Independent Evidence Available   52.5521118 -1.8845138
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      
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      
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
7957 op-snap---monthly-publication-february-2026.pdf   704 2026-02 Pedestrian Mercedes-Benz Sprinter Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Sandgate Rd Sandgate Road Birmingham Birmingham NFA No Independent Evidence Available   52.4168132 -1.8393822
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      
8004 op-snap---monthly-publication-february-2026.pdf   751 2026-02 Pedestrian Mercedes-Benz GLB Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Milby Drive Milby Drive Out of Force Area Out of Force Area NFA Out of Force      
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
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
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      
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      
8054 op-snap---monthly-publication-february-2026.pdf   801 2026-02 Pedestrian Mercedes-Benz Sprinter White Driving without Due Care and Attention None Sandford Avenue Church Stretton Sandford Avenue Church Stretton Out of Force Area Out of Force Area NFA Out of Force      
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      
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
8138 op-snap---monthly-publication-february-2026.pdf   885 2026-02 Pedestrian Mercedes-Benz A Class White Motor vehicle fail to accord precedence at a pelican crossing None Church Road, Yardley Church Road, Yardley Birmingham Birmingham NFA Outside of 14 Days NIP   52.4655896 -1.8112542
8181 op-snap---monthly-publication-february-2026.pdf   928 2026-02 Pedestrian Mercedes-Benz G Class Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Lane Stoney Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4745488 -1.8065911
8223 op-snap---monthly-publication-february-2026.pdf   970 2026-02 Other Mercedes-Benz Sprinter Red Offence to be added None Uplands Road Uplands Road Birmingham Birmingham NFA No Offence   52.5131738 -1.9434941
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
8307 op-snap---monthly-publication-february-2026.pdf   1054 2026-02 Pedestrian Mercedes-Benz   Black Driving without Due Care and Attention None Highters Heath Lane Highters Heath Lane Birmingham Birmingham NFA No VRM   52.4100972 -1.8742772
8348 op-snap---monthly-publication-february-2026.pdf   1095 2026-02 Pedestrian Mercedes-Benz C180 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Birmingham street Birmingham street Sandwell Sandwell NFA No Independent Evidence Available   52.5036256 -2.0151874
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
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      
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      
8521 op-snap---monthly-publication-february-2026.pdf   1268 2026-02 Pedal Bike Mercedes-Benz Smart Fortwo Blue Driving without Due Care and Attention None Streetbrook Road Streetbrook Road Solihull Solihull NFA Outside of 14 Days NIP      
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      
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      
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
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
8751 op-snap---monthly-publication-february-2026.pdf   1498 2026-02 Motorbike Mercedes-Benz   Black Driving without Due Care and Attention None J15 M40 J15 M40 Out of Force Area Out of Force Area NFA Out of Force      
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
10548 op-snap---monthly-publication-january-2026.pdf   9 2026-01 Car Mercedes-Benz A200 Black Using a Mobile Phone Whilst Driving None Binley Road Binley Road Coventry Coventry NFA No Independent Evidence Available   52.4070602 -1.4732469
10598 op-snap---monthly-publication-january-2026.pdf   59 2026-01 Car Mercedes-Benz A200.. Grey Driving without Due Care and Attention None A41 Newport towards Market Drayton Newport towards Market Drayton Out of Force Area Out of Force Area NFA Out of Force      
10609 op-snap---monthly-publication-january-2026.pdf   70 2026-01 Car Mercedes-Benz CLA250.. White Driving without Due Care and Attention None M5 Jct 23 (Weston) M5 Junction 23 (Weston) Out of Force Area Out of Force Area NFA Out of Force      
10618 op-snap---monthly-publication-january-2026.pdf   79 2026-01 Pedestrian Mercedes-Benz box van White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None beech road Beech Road Birmingham Birmingham NFA Misc Inc Crimes   52.5393906 -1.8446767
10647 op-snap---monthly-publication-january-2026.pdf   108 2026-01 Pedal Bike Mercedes-Benz Vito Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None New Street New Street Birmingham Birmingham NFA No Independent Evidence Available   52.4791344 -1.8986915
10741 op-snap---monthly-publication-january-2026.pdf   202 2026-01 Pedestrian Mercedes-Benz Sprinter White Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Chapel House Street Chapel House Street Birmingham Birmingham NFA No Independent Evidence Available   52.474429 -1.8854816
10789 op-snap---monthly-publication-january-2026.pdf   250 2026-01 Car Mercedes-Benz C250 White Contravening a Red Traffic Light None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA Not in Public Interest   52.5047428 -2.0823754
10803 op-snap---monthly-publication-january-2026.pdf   264 2026-01 Car Mercedes-Benz E250 Grey Driving without Due Care and Attention None London Road London Road Coventry Coventry NFA No Offence   52.3916468 -1.4925995
10818 op-snap---monthly-publication-january-2026.pdf   279 2026-01 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Horseley Heath, Great Bridge Horseley Heath, Great Bridge Sandwell Sandwell NFA No Independent Evidence Available   52.5289091 -2.0391504
10825 op-snap---monthly-publication-january-2026.pdf   286 2026-01 Pedal Bike Mercedes-Benz Sprinter Red Driving without Due Care and Attention None Quinton Island Quinton Island Birmingham Birmingham NFA No Independent Evidence Available   52.4617515 -2.0079008
10869 op-snap---monthly-publication-january-2026.pdf   330 2026-01 Pedestrian Mercedes-Benz E250 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Abbey Road Abbey Road Birmingham Birmingham NFA Not in Public Interest   52.5162302 -1.8593733
10894 op-snap---monthly-publication-january-2026.pdf   355 2026-01 Car Mercedes-Benz Sprinter van White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Soho Road Soho Road Birmingham Birmingham NFA No Offence   52.502568 -1.9305447
10921 op-snap---monthly-publication-january-2026.pdf   382 2026-01 Car Mercedes-Benz G-Wagon Black Driving without Due Care and Attention None Chester Road North Chester Road North Birmingham Birmingham NFA No Independent Evidence Available   52.548449 -1.8594603
10966 op-snap---monthly-publication-january-2026.pdf   427 2026-01 Car Mercedes-Benz Vito Silver Driving without Due Care and Attention None Sandy Lane, Bromsgrove Sandy Lane, Bromsgrove Out of Force Area Out of Force Area NFA Out of Force      
10986 op-snap---monthly-publication-january-2026.pdf   447 2026-01 Other Mercedes-Benz A Class Silver Driving without Due Care and Attention None A38 A38 Birmingham Birmingham NFA No Independent Evidence Available      
11032 op-snap---monthly-publication-january-2026.pdf   493 2026-01 Car Mercedes-Benz CLA Grey Contravening a Red Traffic Light   Unknown, "between Ikea and Wolverhampton". Cannot idetify the road Unknown, "between Ikea and Wolverhampton". Cannot idetify the road Wolverhampton Wolverhampton NFA No Independent Evidence Available      
11169 op-snap---monthly-publication-january-2026.pdf   630 2026-01 Car Mercedes-Benz Citan White Contravening a Red Traffic Light None Darthmouth Middleway Darthmouth Middleway Birmingham Birmingham NFA No Offence      
11233 op-snap---monthly-publication-january-2026.pdf   694 2026-01 Car Mercedes-Benz A200 White Driving without Due Care and Attention None Worcester Road, Bromsgrove Worcester Road, Bromsgrove Out of Force Area Out of Force Area NFA Out of Force      
11256 op-snap---monthly-publication-january-2026.pdf   717 2026-01 Car Mercedes-Benz CLA200 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
11294 op-snap---monthly-publication-january-2026.pdf   755 2026-01 Car Mercedes-Benz A200 Black Driving without Due Care and Attention None Victoria Street South, Grimsby Victoria Street South, Grimsby Out of Force Area Out of Force Area NFA Out of Force      
11386 op-snap---monthly-publication-january-2026.pdf   847 2026-01 Car Mercedes-Benz E350 Silver Contravening a Red Traffic Light None Water Orton Road Water Orton Road Birmingham Birmingham NFA No Independent Evidence Available   52.5153394 -1.7573409
11406 op-snap---monthly-publication-january-2026.pdf   867 2026-01 Car Mercedes-Benz C250 Blue Driving without Due Care and Attention None Bordsley Middlway Bordsley Middlway Birmingham Birmingham NFA No Independent Evidence Available      
11444 op-snap---monthly-publication-january-2026.pdf   905 2026-01 Pedestrian Mercedes-Benz C Class Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Worlds End Lane Worlds End Lane Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4555997 -1.9882443
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
11672 op-snap---monthly-publication-january-2026.pdf   1133 2026-01 Pedestrian Mercedes-Benz   Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Silver Street Silver Street Birmingham Birmingham NFA No Independent Evidence Available   52.433129 -1.8963794
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
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
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      
11830 op-snap---monthly-publication-january-2026.pdf   1291 2026-01 Other Mercedes-Benz C Class Grey Drive / Ride / Lead an animal on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA No VRM   52.5521118 -1.8845138
11850 op-snap---monthly-publication-january-2026.pdf   1311 2026-01 Other Mercedes-Benz C Class Grey Drive / Ride / Lead an animal on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA No VRM   52.5521118 -1.8845138
11925 op-snap---monthly-publication-january-2026.pdf   1386 2026-01 Other Mercedes-Benz c class Grey Driving a vehicle wholly or partly on a footpath None kingstanding road Kingstanding Road Birmingham Birmingham NFA Misc Inc Crimes   52.5521118 -1.8845138
3907 op-snap---monthly-publication-december-2025.pdf   35 2025-12 Pedestrian Mercedes-Benz   Grey Contravening a Red Traffic Light None Leaf Lane Leaf Lane Coventry Coventry NFA No Independent Evidence Available   52.3837942 -1.4979145
3909 op-snap---monthly-publication-december-2025.pdf   37 2025-12 Car Mercedes-Benz Benz White Using a Mobile Phone Whilst Driving None Alcester Street Alcester Street Birmingham Birmingham NFA No Independent Evidence Available   52.4696096 -1.8871873
3989 op-snap---monthly-publication-december-2025.pdf   117 2025-12 Car Mercedes-Benz C220 White Driving without Due Care and Attention None Lodge Road Lodge Road Birmingham Birmingham NFA No Independent Evidence Available   52.5072626 -1.8935604
4018 op-snap---monthly-publication-december-2025.pdf   146 2025-12 Car Mercedes-Benz CLA Red Contravening a Red Traffic Light None Hagley Road West Hagley Road West Birmingham Birmingham NFA No Offence   52.4656414 -1.9852276
4053 op-snap---monthly-publication-december-2025.pdf   181 2025-12 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Fenton Street Fenton Street Sandwell Sandwell NFA No VRM   52.5004036 -1.9790049
4066 op-snap---monthly-publication-december-2025.pdf   194 2025-12 Car Mercedes-Benz E220 black Driving without Due Care and Attention None Warwick Bypass Warwick Bypass Out of Force Area Out of Force Area NFA Out of Force   52.4020704 -1.7491448
4068 op-snap---monthly-publication-december-2025.pdf   196 2025-12 Car Mercedes-Benz A-Class Black Driving without Due Care and Attention None Hubert Road Hubert Road Birmingham Birmingham NFA No Independent Evidence Available   52.4395644 -1.9305389
4085 op-snap---monthly-publication-december-2025.pdf   213 2025-12 Car Mercedes-Benz   Black Driving without Due Care and Attention None M25 M25 Out of Force Area Out of Force Area NFA Out of Force      
4112 op-snap---monthly-publication-december-2025.pdf   240 2025-12 Car Mercedes-Benz GLA Black Contravening a Red Traffic Light None Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham NFA No Offence      
4121 op-snap---monthly-publication-december-2025.pdf   249 2025-12 Car Mercedes-Benz C class Black Contravening a Red Traffic Light None Eastfield Road, Stechford Eastfield Road, Stechford Birmingham Birmingham NFA No VRM   52.486104 -1.8218907
4144 op-snap---monthly-publication-december-2025.pdf   272 2025-12 Car Mercedes-Benz Vito Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA Misc Inc Crimes   52.4929304 -1.8229092
4164 op-snap---monthly-publication-december-2025.pdf   292 2025-12 Car Mercedes-Benz A180.. Blue Contravening a Red Traffic Light None New Hampton New Hampton Birmingham Birmingham NFA No Independent Evidence Available   52.4896402 -1.9101083
4335 op-snap---monthly-publication-december-2025.pdf   463 2025-12 Car Mercedes-Benz sprinter White Driving without Due Care and Attention None startfrod road Startfrod Road Birmingham Birmingham NFA No VRM      
4360 op-snap---monthly-publication-december-2025.pdf   488 2025-12 Pedal Bike Mercedes-Benz E350 Blue Using a Mobile Phone Whilst Driving None     Birmingham Birmingham NFA No Independent Evidence Available      
4366 op-snap---monthly-publication-december-2025.pdf   494 2025-12 Car Mercedes-Benz e220 Grey Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA Misc Inc Crimes   52.4929304 -1.8229092
4376 op-snap---monthly-publication-december-2025.pdf   504 2025-12 Car Mercedes-Benz E220 Black Driving without Due Care and Attention None M6 (S) after jn9 M6 (S) after jn9 Walsall Walsall NFA No Independent Evidence Available      
4386 op-snap---monthly-publication-december-2025.pdf   514 2025-12 Car Mercedes-Benz V220 Blue Contravening a Red Traffic Light None Ring Road, Ring Road Wolverhampton Wolverhampton NFA No VRM   52.5805525 -2.1302823
4390 op-snap---monthly-publication-december-2025.pdf   518 2025-12 car Mercedes-Benz   Black Contravening a Red Traffic Light None Manchester Manchester Out of Force Area Out of Force Area NFA Out of Force   52.4908553 -1.8943638
4399 op-snap---monthly-publication-december-2025.pdf   527 2025-12 Car Mercedes-Benz a-class Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
4408 op-snap---monthly-publication-december-2025.pdf   536 2025-12 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Brook Lane Brook Lane Solihull Solihull NFA No Offence   52.4328972 -1.8147602
4435 op-snap---monthly-publication-december-2025.pdf   563 2025-12 Car Mercedes-Benz C63 White Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham NFA No Independent Evidence Available   52.5919543 -1.8517118
4438 op-snap---monthly-publication-december-2025.pdf   566 2025-12 Pedestrian Mercedes-Benz a200 Black Misc - Non Traffic Offences None hafley road Hafley Road Dudley Dudley NFA Misc Inc Crimes      
4461 op-snap---monthly-publication-december-2025.pdf   589 2025-12 Car Mercedes-Benz   White Misc - Non Traffic Offences None OOF- Shrewsbury OOF- Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
4463 op-snap---monthly-publication-december-2025.pdf   591 2025-12 Car Mercedes-Benz   Black Driving without Due Care and Attention None Dog Kennel Lane Dog Kennel Lane Sandwell Sandwell NFA No VRM   52.4901007 -1.9986317
4488 op-snap---monthly-publication-december-2025.pdf   616 2025-12 Pedestrian Mercedes-Benz   Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None dudley road Dudley Road Birmingham Birmingham NFA Misc Inc Crimes   52.4865107 -1.9386263
4498 op-snap---monthly-publication-december-2025.pdf   626 2025-12 Car Mercedes-Benz GLE Black Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4668753 -1.8996143
4544 op-snap---monthly-publication-december-2025.pdf   672 2025-12 Car Mercedes-Benz C220. Silver Driving without Due Care and Attention None Whitley Wood Road Reading (Tha Whitley Wood Road Reading (Tha mOeust Voaf lFleoyr)ce Area Moeust Voaf Lfleoyr)Ce Area NFA Out of Force      

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);