home / opsnap

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

789 rows where disposal = "NFA" and month = "2025-05" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make >30

  • Ford 92
  • BMW 80
  • Mercedes-Benz 71
  • Audi 65
  • Toyota 63
  • Volkswagen 61
  • Vauxhall 32
  • Nissan 27
  • Peugeot 23
  • Honda 22
  • Seat 21
  • Citroen 16
  • Hyundai 13
  • Renault 13
  • Skoda 13
  • Kia 11
  • Land Rover 10
  • Fiat 9
  • Jaguar 9
  • Mazda 9
  • Volvo 8
  • Suzuki 7
  • Mg 6
  • Daf 5
  • Lexus 5
  • Mini 4
  • Mitsubishi 4
  • Porsche 4
  • Tesla 4
  • Alfa Romeo 3
  • …

offence 29

  • Driving without Due Care and Attention 275
  • Contravening a Red Traffic Light 134
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 63
  • Driving without Reasonable Consideration 63
  • Misc - Non Traffic Offences 60
  • Stop a vehicle on pedestrian crossing 35
  • Using a Mobile Phone Whilst Driving 31
  • Cause vehicle to be left in a dangerous position 22
  • Stop a vehicle within pelican pedestrian crossing limits 20
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 17
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 17
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 11
  • Motor vehicle fail to comply with solid white line road markings 8
  • No Insurance 6
  • Dangerous Driving 4
  • No Seat Belt 4
  • Driving a vehicle wholly or partly on a footpath 3
  • Contravene Lane Closure Red X 2
  • Driver not in position to have Proper Control 2
  • Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
  • VRM fails to conform to Regulations 2
  • Drive a vehicle other than on the carriageway of a motorway 1
  • Drive on hard shoulder 1
  • Fail to Conform to Cycle Lane 1
  • Fail to display front VRM plate 1
  • Keeping a vehicle with registration marks obscured 1
  • Motor vehicle fail to accord precedence at a pelican crossing 1
  • Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
  • Use vehicle on a road without valid test certificate 1

council_area 25

  • Birmingham 398
  • Out of Force Area 86
  • Dudley 60
  • Solihull 50
  • Coventry 45
  • Sandwell 44
  • Walsall 42
  • Wolverhampton 25
  • Sutton Coldfield 18
  • Mbirmingham 4
  • Halesowen 2
  • `Birmingham 2
  • Askoelsihpuellare Drive 1
  • Banirdm Tinhgeh Qaem Hospital 1
  • Bbiirrmminingghahmam 1
  • Bboiurmt Oinf Gthhea Mjunction 1
  • Gbhirammin Gham 1
  • Gsautteto N Coldfield 1
  • Optuotn Of Force Area 1
  • Rsohuirte O)F Force Area 1
  • Sanodlih Jucltl 4 1
  • Scoouvtehn Try 1
  • Tbirmingham 1
  • Two Bolrvaedrmhaomrep Rtooand 1
  • Yb Irmingham 1

reporter_transport_mode 10

  • Car 463
  • Pedal Bike 144
  • Pedestrian 120
  • Other 41
  • Motorbike 9
  • car 7
  • Lorry 2
  • Bus 1
  • CAR 1
  • Horse Rider 1

month 1

  • 2025-05 · 789 ✖

disposal 1

  • NFA · 789 ✖
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
18638 op-snap---monthly-publication-may-2025.pdf   0 2025-05 Car Mercedes-Benz A 200.. Black Driving without Due Care and Attention None Garretts Lane Garretts Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4734898 -1.7799814
18639 op-snap---monthly-publication-may-2025.pdf   1 2025-05 Car Ford Kuga Black Driving without Due Care and Attention None Meadway Meadway Birmingham Birmingham NFA Outside of 14 Days NIP   52.4783348 -1.8007708
18640 op-snap---monthly-publication-may-2025.pdf   2 2025-05 Car Hyundai Kona Grey Driving without Due Care and Attention None Barrows Lane Barrows Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4665114 -1.8010003
18641 op-snap---monthly-publication-may-2025.pdf   3 2025-05 Pedestrian Citroen c5 Silver No Seat Belt None Hannah Road Hannah Road Wolverhampton Wolverhampton NFA No Independent Evidence Available      
18642 op-snap---monthly-publication-may-2025.pdf   4 2025-05 Pedestrian Citroen C5 Silver Using a Mobile Phone Whilst Driving None Hannah Road Hannah Road Wolverhampton Wolverhampton NFA Not in Public Interest      
18643 op-snap---monthly-publication-may-2025.pdf   5 2025-05 Pedal Bike BMW 118I White Driving without Reasonable Consideration None Birmingham New Road Birmingham New Road Dudley Dudley NFA Outside of 14 Days NIP   52.5478387 -2.0943116
18647 op-snap---monthly-publication-may-2025.pdf   9 2025-05 Other Toyota Prius Silver Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham NFA Outside of 14 Days NIP   52.5265939 -1.8509884
18648 op-snap---monthly-publication-may-2025.pdf   10 2025-05 Car Audi A3.. Black Misc - Non Traffic Offences None A452 A452 Birmingham Birmingham NFA No Offence      
18650 op-snap---monthly-publication-may-2025.pdf   12 2025-05 Other Toyota Prius Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Glenville Drive Glenville Drive Birmingham Birmingham NFA Outside of 14 Days NIP   52.5265939 -1.8509884
18651 op-snap---monthly-publication-may-2025.pdf   13 2025-05 Bus Toyota Yaris Grey Contravening a Red Traffic Light None Bristol Street Bristol Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4691145 -1.9003257
18652 op-snap---monthly-publication-may-2025.pdf   14 2025-05 Car Vauxhall Insignia Grey Contravening a Red Traffic Light None Stafford Road Stafford Road Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.6291998 -2.126312
18653 op-snap---monthly-publication-may-2025.pdf   15 2025-05 Pedestrian Volvo XC60 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Clent Road Clent Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4725947 -1.9952306
18655 op-snap---monthly-publication-may-2025.pdf   17 2025-05 Pedestrian Mercedes-Benz C220 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Castle Road Castle Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5258312 -2.0768625
18656 op-snap---monthly-publication-may-2025.pdf   18 2025-05 Pedestrian Kia Sportage Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheatley Road Wheatley Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4705903 -1.9933164
18657 op-snap---monthly-publication-may-2025.pdf   19 2025-05 Car   RAM Blue Driving without Due Care and Attention None M42 SB J4 M42 Southbound J4 Solihull Solihull NFA Outside of 14 Days NIP      
18658 op-snap---monthly-publication-may-2025.pdf   20 2025-05 Car Jaguar XJ Black Driving without Due Care and Attention None M42 SB J7 M42 Southbound J7 Solihull Solihull NFA Outside of 14 Days NIP      
18659 op-snap---monthly-publication-may-2025.pdf   21 2025-05 Pedal Bike Land Rover Range Rover Green Using a Mobile Phone Whilst Driving None Widney Road Solihull Widney Road Solihull Solihull Solihull NFA Not in Public Interest   52.3795667 -1.7478958
18660 op-snap---monthly-publication-may-2025.pdf   22 2025-05 Car Toyota Aygo Blue Misc - Non Traffic Offences None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Offence   52.5113867 -1.8337258
18662 op-snap---monthly-publication-may-2025.pdf   24 2025-05 Car Vauxhall Corsa Black Misc - Non Traffic Offences None Middleton Road Middleton Road Birmingham Birmingham NFA Misc Inc Crimes   52.4294291 -1.8905762
18664 op-snap---monthly-publication-may-2025.pdf   26 2025-05 Other Toyota Prius Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Glenville Drive Glenville Drive Birmingham Birmingham NFA Outside of 14 Days NIP   52.5265939 -1.8509884
18665 op-snap---monthly-publication-may-2025.pdf   27 2025-05 Pedestrian   720s Orange Fail to display front VRM plate None Anchorage Road Anchorage Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5699381 -1.8249539
18666 op-snap---monthly-publication-may-2025.pdf   28 2025-05 Other Mercedes-Benz A CLass Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Glenville Drive Glenville Drive Birmingham Birmingham NFA Outside of 14 Days NIP   52.5265939 -1.8509884
18669 op-snap---monthly-publication-may-2025.pdf   31 2025-05 Pedal Bike Volkswagen Polo Blue Cause vehicle to be left in a dangerous position None Mary Vale Road Mary Vale Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.425105 -1.9312861
18671 op-snap---monthly-publication-may-2025.pdf   33 2025-05 Car Volkswagen Golf Blue Cause vehicle to be left in a dangerous position None Darwin Street Darwin Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.468128 -1.8848315
18672 op-snap---monthly-publication-may-2025.pdf   34 2025-05 Car Toyota Rav4 Black Cause vehicle to be left in a dangerous position None Darwin Street Darwin Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.468128 -1.8848315
18676 op-snap---monthly-publication-may-2025.pdf   38 2025-05 Car BMW M4 Grey Cause vehicle to be left in a dangerous position None Ladypool Road Ladypool Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4520441 -1.8787544
18678 op-snap---monthly-publication-may-2025.pdf   40 2025-05 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Cliff Rock Road Cliff Rock Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.3937169 -2.0011078
18679 op-snap---monthly-publication-may-2025.pdf   41 2025-05 Car Volvo XC60 White Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell NFA Outside of 14 Days NIP   52.4926604 -2.0216743
18680 op-snap---monthly-publication-may-2025.pdf   42 2025-05 Car Ford Transit White Using a Mobile Phone Whilst Driving None Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force   52.4047807 -2.0101216
18681 op-snap---monthly-publication-may-2025.pdf   43 2025-05 Car Volkswagen Polo Red Contravening a Red Traffic Light None Bath Road Bath Road Dudley Dudley NFA Outside of 14 Days NIP   52.4552307 -2.1496182
18684 op-snap---monthly-publication-may-2025.pdf   46 2025-05 Motorbike Hyundai IX35 Grey Driving without Due Care and Attention None M5 NB 2-1 M5 Northbound 2-1 Sandwell Sandwell NFA Outside of 14 Days NIP      
18685 op-snap---monthly-publication-may-2025.pdf   47 2025-05 Car Honda Jazz Blue Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4415108 -1.8971434
18686 op-snap---monthly-publication-may-2025.pdf   48 2025-05 Car Porsche Cayenne Black Driving without Due Care and Attention None Manor Way Manor Way Dudley Dudley NFA Outside of 14 Days NIP   52.4493861 -2.0168307
18689 op-snap---monthly-publication-may-2025.pdf   51 2025-05 Motorbike BMW 320d Blue Driving without Due Care and Attention None M5 NB 2-1 M5 Northbound 2-1 Sandwell Sandwell NFA Outside of 14 Days NIP      
18690 op-snap---monthly-publication-may-2025.pdf   52 2025-05 Car Honda C-RV Grey Contravening a Red Traffic Light None St Paul Street Street Paul Street Walsall Walsall NFA Outside of 14 Days NIP   52.5857518 -1.9828836
18691 op-snap---monthly-publication-may-2025.pdf   53 2025-05 Car Audi A4 White Contravening a Red Traffic Light None A41 A41 Sandwell Sandwell NFA Outside of 14 Days NIP      
18693 op-snap---monthly-publication-may-2025.pdf   55 2025-05 Motorbike Toyota Pirus White Driving without Reasonable Consideration None M40 J15-J16 M40 J15-J16 Solihull Solihull NFA Outside of 14 Days NIP      
18695 op-snap---monthly-publication-may-2025.pdf   57 2025-05 Pedal Bike Ford Tourneo Silver Driving without Due Care and Attention None Wherretts Well Lane Wherretts Well Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4225399 -1.763283
18696 op-snap---monthly-publication-may-2025.pdf   58 2025-05 Pedestrian Audi A6.. Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
18698 op-snap---monthly-publication-may-2025.pdf   60 2025-05 Pedal Bike Audi A6 Black Driving without Reasonable Consideration None Slade Road Slade Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5894461 -1.8082962
18700 op-snap---monthly-publication-may-2025.pdf   62 2025-05 Car BMW 318I Black Driving without Reasonable Consideration None Creynolds Lane Creynolds Lane Solihull Solihull NFA Outside of 14 Days NIP   52.3779859 -1.8107431
18701 op-snap---monthly-publication-may-2025.pdf   63 2025-05 Car Volkswagen Tiguan Blue Driving without Due Care and Attention None A449 Worcestershire Worcestershire Out of Force Area Out of Force Area NFA Out of Force      
18706 op-snap---monthly-publication-may-2025.pdf   68 2025-05 Pedestrian Nissan Qashqai Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Field Lane Field Lane Dudley Dudley NFA Not in Public Interest   52.4469063 -2.1430048
18707 op-snap---monthly-publication-may-2025.pdf   69 2025-05 Pedal Bike BMW 535d Black Driving without Reasonable Consideration None Cambridge Street Cambridge Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4802932 -1.9079609
18708 op-snap---monthly-publication-may-2025.pdf   70 2025-05 Pedal Bike BMW 430d Grey Driving without Reasonable Consideration None Ridgeacre Road Ridgeacre Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4620871 -2.0123436
18709 op-snap---monthly-publication-may-2025.pdf   71 2025-05 Car Mercedes-Benz GLC Black Contravening a Red Traffic Light None Stratford Road Stratford Road Solihull Solihull NFA Outside of 14 Days NIP   52.4191184 -1.8326637
18710 op-snap---monthly-publication-may-2025.pdf   72 2025-05 Car Mercedes-Benz A180.. Grey Contravene Lane Closure Red X None Sandwell Road Sandwell Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5082522 -1.9487918
18711 op-snap---monthly-publication-may-2025.pdf   73 2025-05 Car Audi A3 Blue Driving without Due Care and Attention None M5 J 2 M5 J 2 Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4945433 -2.0190848
18712 op-snap---monthly-publication-may-2025.pdf   74 2025-05 Car Ford Transit Black Driving without Due Care and Attention None Lillington Avenue Lillington Avenue Out of Force Area Out of Force Area NFA Out of Force      
18715 op-snap---monthly-publication-may-2025.pdf   77 2025-05 Car Toyota Rav 4 Grey Using a Mobile Phone Whilst Driving None Table Oak Lane Table Oak Lane Solihull Solihull NFA No Independent Evidence Available   52.36756 -1.6490909
18716 op-snap---monthly-publication-may-2025.pdf   78 2025-05 Pedal Bike Mazda 2 Purple Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bradford Street Bradford Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4708802 -1.8792135
18717 op-snap---monthly-publication-may-2025.pdf   79 2025-05 Pedal Bike Mercedes-Benz 200 AMG Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bradford Street Bradford Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4708802 -1.8792135
18718 op-snap---monthly-publication-may-2025.pdf   80 2025-05 Car Mercedes-Benz CLA200 Black Contravening a Red Traffic Light None Oxhill Road Oxhill Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.513857 -1.9367367
18719 op-snap---monthly-publication-may-2025.pdf   81 2025-05 Pedal Bike Audi s4 Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bradford Street Bradford Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4708802 -1.8792135
18720 op-snap---monthly-publication-may-2025.pdf   82 2025-05 Pedal Bike Mercedes-Benz AMG Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bradford Street Bradford Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4708802 -1.8792135
18721 op-snap---monthly-publication-may-2025.pdf   83 2025-05 Car Toyota C-HR Grey Contravening a Red Traffic Light None A461 Birmingham Road Birmingham Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5461417 -1.9334193
18722 op-snap---monthly-publication-may-2025.pdf   84 2025-05 Car Ford Fiesta Silver Contravening a Red Traffic Light None Bromford Lane Bromford Lane Sandwell Sandwell NFA Outside of 14 Days NIP   52.5141069 -2.003425
18724 op-snap---monthly-publication-may-2025.pdf   86 2025-05 Car Mercedes-Benz EQC Grey Driving without Due Care and Attention None Telford Way West Bromwich Telford Way West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP   52.5065282 -1.976582
18725 op-snap---monthly-publication-may-2025.pdf   87 2025-05 Pedal Bike Peugeot Partner Red Driving without Due Care and Attention None Ring Road Ring Road Coventry Coventry NFA No Offence      
18726 op-snap---monthly-publication-may-2025.pdf   88 2025-05 Pedal Bike Mercedes-Benz ML350 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Westhill Road Westhill Road Coventry Coventry NFA No Offence   52.4225058 -1.5356916
18728 op-snap---monthly-publication-may-2025.pdf   90 2025-05 Car Audi A3.. Black Misc - Non Traffic Offences None A452 A452 Birmingham Birmingham NFA No Offence      
18729 op-snap---monthly-publication-may-2025.pdf   91 2025-05 Car Lexus IS300H Silver Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Kings Road at Chester Road Kings Road at Chester Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5496587 -1.8665906
18730 op-snap---monthly-publication-may-2025.pdf   92 2025-05 Car Vauxhall Vivaro White Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham NFA Outside of 14 Days NIP      
18733 op-snap---monthly-publication-may-2025.pdf   95 2025-05 Pedestrian Renault CAPTUR Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None PETERSFIELD ROAD Petersfield Road Birmingham Birmingham NFA No Independent Evidence Available   52.4307 -1.8494663
18734 op-snap---monthly-publication-may-2025.pdf   96 2025-05 Car Ford Eco Sport White Use a motor vehicle / trailer in a condition likely to cause danger of injury None Sheaf Lane Sheaf Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4540536 -1.7819436
18735 op-snap---monthly-publication-may-2025.pdf   97 2025-05 Pedal Bike   KYM Duke Orange Driving without Reasonable Consideration None Gosford Street Gosford Street Coventry Coventry NFA Outside of 14 Days NIP   52.4068712 -1.4994695
18738 op-snap---monthly-publication-may-2025.pdf   100 2025-05 Pedestrian Ford Transit Silver Cause vehicle to be left in a dangerous position None Chiswell Road Chiswell Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4878246 -1.9421047
18740 op-snap---monthly-publication-may-2025.pdf   102 2025-05 Pedestrian BMW 218M White Contravening a Red Traffic Light None WARSTONE LANE Warstone Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4870496 -1.912873
18742 op-snap---monthly-publication-may-2025.pdf   104 2025-05 Car Tesla Model 3 Grey Driving without Due Care and Attention None M42 EB J2 M42 Eb J2 Out of Force Area Out of Force Area NFA Out of Force   52.4945433 -2.0190848
18743 op-snap---monthly-publication-may-2025.pdf   105 2025-05 Pedestrian Toyota Prius White Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen Nt one Frederick Street Frederick Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4863384 -1.9123011
18744 op-snap---monthly-publication-may-2025.pdf   106 2025-05 Pedestrian Mercedes-Benz CLA Black Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen Nt one Frederick Street Frederick Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4863384 -1.9123011
18745 op-snap---monthly-publication-may-2025.pdf   107 2025-05 Pedestrian BMW 1 Series White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Turners Lane Turners Lane Dudley Dudley NFA Outside of 14 Days NIP   52.4721372 -2.1243522
18747 op-snap---monthly-publication-may-2025.pdf   109 2025-05 Pedestrian Volvo S60 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Trossachs Road Trossachs Road Coventry Coventry NFA Outside of 14 Days NIP   52.412542 -1.5757615
18750 op-snap---monthly-publication-may-2025.pdf   112 2025-05 Car Mercedes-Benz C220 Black Stop a vehicle on pedestrian crossing None Charford Road Bromsgrove Charford Road Bromsgrove Out of Force Area Out of Force Area NFA Out of Force      
18751 op-snap---monthly-publication-may-2025.pdf   113 2025-05 Car Suzuki   White Driving without Due Care and Attention None Kettering Kettering Out of Force Area Out of Force Area NFA Out of Force      
18755 op-snap---monthly-publication-may-2025.pdf   117 2025-05 Car Mercedes-Benz CLA 200 Black Driving without Due Care and Attention None Cregoe Street Cregoe Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4718419 -1.9061401
18761 op-snap---monthly-publication-may-2025.pdf   123 2025-05 Other Vauxhall Grandland Orange Misc - Non Traffic Offences None Metchley Lane QE Hospiital Metchley Lane QE Hospiital Birmingham Birmingham NFA No Offence      
18763 op-snap---monthly-publication-may-2025.pdf   125 2025-05 Car       Misc - Non Traffic Offences None Penns Lane Penns Lane Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5356148 -1.8191361
18769 op-snap---monthly-publication-may-2025.pdf   131 2025-05 Pedal Bike Skoda Fabia White Driving without Reasonable Consideration None Chester Rd Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
18771 op-snap---monthly-publication-may-2025.pdf   133 2025-05 Pedal Bike Jaguar X Pace Grey Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
18772 op-snap---monthly-publication-may-2025.pdf   134 2025-05 Car Land Rover Range Rover Green Contravening a Red Traffic Light None Broadway Walsall Broadway Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5719937 -1.9639882
18783 op-snap---monthly-publication-may-2025.pdf   145 2025-05 Pedal Bike Tesla Model 3 White Driving without Reasonable Consideration None Priory Road Priory Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4132696 -1.8555008
18785 op-snap---monthly-publication-may-2025.pdf   147 2025-05 Pedal Bike Toyota AURIS Grey Driving without Reasonable Consideration None NEWHALL STREET Newhall Street Birmingham Birmingham NFA No Offence   52.4830482 -1.905069
18786 op-snap---monthly-publication-may-2025.pdf   148 2025-05 Pedal Bike Ford FIESTA Blue Driving without Reasonable Consideration None GUNNERS LANE Gunners Lane Birmingham Birmingham NFA Outside of 14 Days NIP      
18787 op-snap---monthly-publication-may-2025.pdf   149 2025-05 Pedal Bike Toyota MPV Silver Driving without Reasonable Consideration None MERRITTS HILL ROAD Merritts Hill Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4216997 -1.9756752
18788 op-snap---monthly-publication-may-2025.pdf   150 2025-05 Pedal Bike Toyota Yaris Silver Driving without Reasonable Consideration None Genners Lane Genners Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4282602 -1.9861769
18790 op-snap---monthly-publication-may-2025.pdf   152 2025-05 Pedal Bike Toyota MPV White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Small Brook Queensway Small Brook Queensway Birmingham Birmingham NFA Not in Public Interest      
18791 op-snap---monthly-publication-may-2025.pdf   153 2025-05 Car Citroen Xsara Silver Contravening a Red Traffic Light None Blue Lane West Blue Lane West Walsall Walsall NFA Outside of 14 Days NIP   52.5880833 -1.9891415
18793 op-snap---monthly-publication-may-2025.pdf   155 2025-05 Car Mazda THREE Blue Driving without Due Care and Attention None Beacon Road Beacon Road Sandwell Sandwell NFA No VRM   52.5499696 -1.9797407
18794 op-snap---monthly-publication-may-2025.pdf   156 2025-05 Car Ford Transit White Contravening a Red Traffic Light None Camp Lane Camp Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.5144871 -1.9539012
18796 op-snap---monthly-publication-may-2025.pdf   158 2025-05 Car BMW 530E Grey Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5113867 -1.8337258
18797 op-snap---monthly-publication-may-2025.pdf   159 2025-05 Car BMW R 1200 Black Driving without Due Care and Attention None M5 South Junction 2 M5 South Junction 2 Dudley Dudley NFA Outside of 14 Days NIP      
18798 op-snap---monthly-publication-may-2025.pdf   160 2025-05 Other Renault Kadjar Blue Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen Nt one Norwood Road Norwood Road Dudley Dudley NFA Outside of 14 Days NIP   52.4831397 -2.1309273
18799 op-snap---monthly-publication-may-2025.pdf   161 2025-05 Pedestrian Iveco   White Use a motor vehicle / trailer in a condition likely to cause danger of injury None Birmingham Road Aldridge Birmingham Road Aldridge Walsall Walsall NFA Outside of 14 Days NIP   52.5766298 -1.9685663
18800 op-snap---monthly-publication-may-2025.pdf   162 2025-05 Pedestrian   London Taxi Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Heath Road Heath Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4220874 -1.9409615
18803 op-snap---monthly-publication-may-2025.pdf   165 2025-05 Car BMW X1 Black Driving without Reasonable Consideration None M5 M5 Sandwell Sandwell NFA Outside of 14 Days NIP      
18804 op-snap---monthly-publication-may-2025.pdf   166 2025-05 Car Suzuki GsXS Blue Contravening a Red Traffic Light None Soho Road Soho Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.502568 -1.9305447
18805 op-snap---monthly-publication-may-2025.pdf   167 2025-05 Car Honda NSC White Driving without Due Care and Attention None Market Street Market Street Dudley Dudley NFA Outside of 14 Days NIP   52.4964695 -2.1680501
18806 op-snap---monthly-publication-may-2025.pdf   168 2025-05 Car BMW 520 Grey Contravening a Red Traffic Light None soho road Soho Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.502568 -1.9305447
18808 op-snap---monthly-publication-may-2025.pdf   170 2025-05 Car Seat Ibiza White Misc - Non Traffic Offences Littering Stream Road Stream Road Dudley Dudley NFA Outside of 14 Days NIP   52.4871725 -2.1623764

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