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

109 rows where council_area = "Dudley" and month = "2025-09" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

vehicle_make 26

  • Volkswagen 13
  • Audi 10
  • Ford 10
  • BMW 9
  • Vauxhall 9
  • Mercedes-Benz 8
  • Seat 8
  • Toyota 6
  • Hyundai 4
  • Mini 4
  • Peugeot 4
  • Land Rover 3
  • Citroen 2
  • Kia 2
  • Mg 2
  • Suzuki 2
  • Chevrolet 1
  • Chysler 1
  • Jaguar 1
  • Lamborghini 1
  • Nissan 1
  • Renault 1
  • Scania 1
  • Skoda 1
  • Volvo 1
  • Yamaha 1

offence 14

  • Driving without Due Care and Attention 54
  • Contravening a Red Traffic Light 18
  • Cause unnecessary obstruction by motor vehicle 11
  • Using a Mobile Phone Whilst Driving 8
  • Misc - Non Traffic Offences 6
  • Motor vehicle fail to comply with endorsable sect 3
  • Cause vehicle to be left in a dangerous position 2
  • CCaauussee uunnnneecceessssaarryy oobbssttrruuccttiioonn bbyy mmoottoorr vveehhiiccllee 1
  • Driving without Reasonable Consideration 1
  • MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 1
  • Motor vehicle fail to comply with a non endorsab 1
  • No Insurance 1
  • Use a vehicle / cycle on a road and contravene a l 1
  • VRM fails to conform to Regulations 1

reporter_transport_mode 7

  • Car 62
  • Other 28
  • Pedestrian 9
  • Pedal Bike 7
  • Motorbike 1
  • car 1
  • other 1

disposal 6

  • Warning Letter 31
  • NFA 29
  • Education 23
  • Fixed Penalty 16
  • Court 9
  • Other Action Taken 1

month 1

  • 2025-09 · 109 ✖

council_area 1

  • Dudley · 109 ✖
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
23781 op-snap---monthly-publication-september-2025.pdf   0 2025-09 Other Skoda Fabia White Driving without Due Care and Attention None Waterfron main car park Waterfron main car park Dudley Dudley Warning Letter N/A      
23782 op-snap---monthly-publication-september-2025.pdf   1 2025-09 Car Toyota Yaris Black Contravening a Red Traffic Light None Central Way, Merry Hill Central Way, Merry Hill Dudley Dudley NFA No Offence      
23793 op-snap---monthly-publication-september-2025.pdf   12 2025-09 Other Vauxhall Grandland Red Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Fixed Penalty N/A   52.4831397 -2.1309273
23794 op-snap---monthly-publication-september-2025.pdf   13 2025-09 Other Volkswagen Polo Blue Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Fixed Penalty N/A   52.4831397 -2.1309273
23813 op-snap---monthly-publication-september-2025.pdf   32 2025-09 Other Vauxhall Agila Green Motor vehicle fail to comply with endorsable sect ion 36 traffic sign -otheNr othnaen manned or automatic Teoqwuieprm Setrnetet Teoqwuieprm Setrnetet Dudley Dudley Fixed Penalty N/A      
23839 op-snap---monthly-publication-september-2025.pdf   58 2025-09 Car BMW M3 Black Contravening a Red Traffic Light None A4036 Merry Hill Merry Hill Dudley Dudley Education N/A   52.4817646 -2.1113435
23840 op-snap---monthly-publication-september-2025.pdf   59 2025-09 Car Nissan Primastar Grey Driving without Due Care and Attention None A4036 Merry Hill Merry Hill Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.4817646 -2.1113435
23846 op-snap---monthly-publication-september-2025.pdf   65 2025-09 Car Mercedes-Benz Smart ForTwo Black Driving without Due Care and Attention No Insurance Roberts Street Roberts Street Dudley Dudley Court N/A   52.5213135 -2.1197042
23890 op-snap---monthly-publication-september-2025.pdf   109 2025-09 Car Chevrolet Orlando Silver Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Warning Letter N/A   52.5047428 -2.0823754
23914 op-snap---monthly-publication-september-2025.pdf   133 2025-09 Other Kia Picanto Yellow Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
23917 op-snap---monthly-publication-september-2025.pdf   136 2025-09 Car Suzuki GSXS Black Driving without Due Care and Attention None A449 A449 Dudley Dudley Warning Letter N/A      
23918 op-snap---monthly-publication-september-2025.pdf   137 2025-09 Other   Teyin Black Driving without Due Care and Attention No Insurance Waterfront Merry Hill Waterfront Merry Hill Dudley Dudley Court N/A   52.4874176 -2.1129449
23919 op-snap---monthly-publication-september-2025.pdf   138 2025-09 Car Hyundai Tuscon Grey Driving without Due Care and Attention None Bridgnorth Road Bridgnorth Road Dudley Dudley Court N/A   52.4603456 -2.1716457
23988 op-snap---monthly-publication-september-2025.pdf   207 2025-09 Other Volkswagen Scirocco Silver No Insurance None Western Avenue Western Avenue Dudley Dudley NFA No Independent Evidence Available   52.4535134 -2.0258726
23990 op-snap---monthly-publication-september-2025.pdf   209 2025-09 Other Volkswagen Golf Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Education N/A      
23992 op-snap---monthly-publication-september-2025.pdf   211 2025-09 Car Vauxhall Astra Silver Contravening a Red Traffic Light None A4123 at Bunns Lane A4123 at Bunns Lane Dudley Dudley Fixed Penalty N/A   52.5478387 -2.0943116
24067 op-snap---monthly-publication-september-2025.pdf   286 2025-09 Other Mercedes-Benz Citan White Motor vehicle fail to comply with endorsable sect ion 36 traffic sign -otheNr othnaen manned or automatic Teoqwuieprm Setrnetet Teoqwuieprm Setrnetet Dudley Dudley Fixed Penalty N/A      
24088 op-snap---monthly-publication-september-2025.pdf   307 2025-09 Car Peugeot 2008.. Grey Using a Mobile Phone Whilst Driving None Park Road at Parkes Hall Road Park Road at Parkes Hall Road Dudley Dudley Fixed Penalty N/A   52.4566333 -2.1646355
24090 op-snap---monthly-publication-september-2025.pdf   309 2025-09 Pedal Bike Hyundai I20 Grey Driving without Due Care and Attention None Turners Lane Turners Lane Dudley Dudley Education N/A   52.4721372 -2.1243522
24099 op-snap---monthly-publication-september-2025.pdf   318 2025-09 Motorbike Mercedes-Benz EQA250 Grey Using a Mobile Phone Whilst Driving None Chawn Park Drive Chawn Park Drive Dudley Dudley Warning Letter N/A   52.4453636 -2.1319058
24114 op-snap---monthly-publication-september-2025.pdf   333 2025-09 Pedal Bike Peugeot Partner Grey Driving without Due Care and Attention None Tipton Road Tipton Road Dudley Dudley Education N/A   52.5198386 -2.0740876
24195 op-snap---monthly-publication-september-2025.pdf   414 2025-09 Car Seat Leon White Contravening a Red Traffic Light None Level Street Brierley Hill Level Street Brierley Hill Dudley Dudley Education N/A   52.4842017 -2.116248
24227 op-snap---monthly-publication-september-2025.pdf   446 2025-09 Car Toyota Aygo Silver Driving without Due Care and Attention None Castlegate Island Castlegate Island Dudley Dudley NFA No Offence      
24229 op-snap---monthly-publication-september-2025.pdf   448 2025-09 Car Peugeot Partner White Contravening a Red Traffic Light None High Street / A491, Audnam, Stourbridge High Street / A491, Audnam, Stourbridge Dudley Dudley Education N/A   52.4722518 -2.1552954
24230 op-snap---monthly-publication-september-2025.pdf   449 2025-09 Car Land Rover Evoque White Driving without Due Care and Attention None High Street / A491, Audnam, Stourbridge High Street / A491, Audnam, Stourbridge Dudley Dudley Warning Letter N/A   52.4722518 -2.1552954
24261 op-snap---monthly-publication-september-2025.pdf   480 2025-09 Car BMW 1 Series Black Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Education N/A   52.4879006 -2.1188734
24268 op-snap---monthly-publication-september-2025.pdf   487 2025-09 Pedal Bike Vauxhall Combo Grey Driving without Due Care and Attention None Thorns Road Thorns Road Dudley Dudley Education N/A   52.4628538 -2.1160108
24269 op-snap---monthly-publication-september-2025.pdf   488 2025-09 Car Toyota   Blue Contravening a Red Traffic Light None Castle Gate Island Castle Gate Island Dudley Dudley NFA No Independent Evidence Available   52.5136155 -2.0733909
24296 op-snap---monthly-publication-september-2025.pdf   515 2025-09 Car Seat Leon Silver Contravening a Red Traffic Light None A449 Wolverhampton Road Wolverhampton Road Dudley Dudley NFA No Independent Evidence Available   52.5063917 -2.1711502
24314 op-snap---monthly-publication-september-2025.pdf   533 2025-09 Other Mini One Blue Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
24316 op-snap---monthly-publication-september-2025.pdf   535 2025-09 Car Peugeot 208 White Using a Mobile Phone Whilst Driving None Birmingham new Road Birmingham new Road Dudley Dudley Fixed Penalty N/A   52.5478387 -2.0943116
24318 op-snap---monthly-publication-september-2025.pdf   537 2025-09 Other Audi A1 Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
24325 op-snap---monthly-publication-september-2025.pdf   544 2025-09 Other Scania   White Using a Mobile Phone Whilst Driving None Brettell Lane Brettell Lane Dudley Dudley Warning Letter N/A   52.4706676 -2.1545486
24334 op-snap---monthly-publication-september-2025.pdf   553 2025-09 Car BMW   White Driving without Due Care and Attention None A491 High Street High Street Dudley Dudley Education N/A   52.4779764 -2.1598371
24354 op-snap---monthly-publication-september-2025.pdf   573 2025-09 Car   Piaggio Black Driving without Due Care and Attention None Gospel End Road Gospel End Road Dudley Dudley NFA No Independent Evidence Available   52.5392439 -2.1282642
24363 op-snap---monthly-publication-september-2025.pdf   582 2025-09 Car Ford Fiesta Silver Driving without Due Care and Attention None Halesowen Road Halesowen Road Dudley Dudley Education N/A   52.4624413 -2.0175178
24375 op-snap---monthly-publication-september-2025.pdf   594 2025-09 Car BMW   Blue Contravening a Red Traffic Light None Brettell Lane Brettell Lane Dudley Dudley Education N/A   52.4706676 -2.1545486
24398 op-snap---monthly-publication-september-2025.pdf   617 2025-09 Car   VDL Bus Blue Contravening a Red Traffic Light None Merry Hill Merry Hill Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.4817646 -2.1113435
24401 op-snap---monthly-publication-september-2025.pdf   620 2025-09 Other Mercedes-Benz Sprinter Grey Misc - Non Traffic Offences None High Street, Brockmoor High Street, Brockmoor Dudley Dudley NFA No Offence   52.501153 -2.1208987
24416 op-snap---monthly-publication-september-2025.pdf   635 2025-09 Car Land Rover Range Rover Grey Using a Mobile Phone Whilst Driving None Gate Street Gate Street Dudley Dudley NFA No Independent Evidence Available   52.5381741 -2.1180164
24417 op-snap---monthly-publication-september-2025.pdf   636 2025-09 Car Audi A1 Grey Contravening a Red Traffic Light None Hall Street Hall Street Dudley Dudley NFA Not in Public Interest   52.5409774 -2.1235921
24421 op-snap---monthly-publication-september-2025.pdf   640 2025-09 Other Ford Transit Grey Motor vehicle fail to comply with endorsable sect ion 36 traffic sign -otheNr othnaen manned or automatic Neqourwipomoedn Rtoad Neqourwipomoedn Rtoad Dudley Dudley Fixed Penalty N/A      
24424 op-snap---monthly-publication-september-2025.pdf   643 2025-09 Other Audi A5 Grey Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
24431 op-snap---monthly-publication-september-2025.pdf   650 2025-09 Car Seat Leon White Driving without Due Care and Attention None Prince Street Prince Street Dudley Dudley NFA Not in Public Interest   52.4966192 -2.0854322
24435 op-snap---monthly-publication-september-2025.pdf   654 2025-09 Car BMW 116d White Contravening a Red Traffic Light None Racecourse Lane Racecourse Lane Dudley Dudley NFA No Independent Evidence Available   52.4377169 -2.1495045
24436 op-snap---monthly-publication-september-2025.pdf   655 2025-09 Car Hyundai I30 Silver Driving without Due Care and Attention None Manor Park Manor Park Dudley Dudley Warning Letter N/A   52.4961407 -2.1668754
24437 op-snap---monthly-publication-september-2025.pdf   656 2025-09 Car Suzuki Alto Silver Using a Mobile Phone Whilst Driving None Foxoak Street Foxoak Street Dudley Dudley NFA No Independent Evidence Available      
24482 op-snap---monthly-publication-september-2025.pdf   701 2025-09 Car Volkswagen Golf Silver Driving without Due Care and Attention None Waterfront car park 7 Waterfront car park 7 Dudley Dudley NFA No Independent Evidence Available      
24491 op-snap---monthly-publication-september-2025.pdf   710 2025-09 Pedal Bike Chysler 300C Silver Driving without Due Care and Attention None The Broadway The Broadway Dudley Dudley Education N/A   52.515445 -2.0885791
24493 op-snap---monthly-publication-september-2025.pdf   712 2025-09 Pedal Bike Land Rover Evoque Black Driving without Due Care and Attention None A491 Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
24506 op-snap---monthly-publication-september-2025.pdf   725 2025-09 Other Mini Mini White Driving without Due Care and Attention None Parsons Street Parsons Street Dudley Dudley Education N/A   52.511015 -2.0864656
24529 op-snap---monthly-publication-september-2025.pdf   748 2025-09 Car Audi A3 Grey Driving without Due Care and Attention None Moss Grove Moss Grove Dudley Dudley NFA No Independent Evidence Available   52.5025066 -2.1702039
24530 op-snap---monthly-publication-september-2025.pdf   749 2025-09 Other Seat Leon Black Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Fixed Penalty N/A      
24534 op-snap---monthly-publication-september-2025.pdf   753 2025-09 Car Mercedes-Benz GLC white Driving without Due Care and Attention None High Street, Wall Heath, Dudley High Street, Wall Heath, Dudley Dudley Dudley Education N/A   52.5046529 -2.1784687
24546 op-snap---monthly-publication-september-2025.pdf   765 2025-09 Car Seat Ibiza Grey Driving without Due Care and Attention None Bunns Lane Bunns Lane Dudley Dudley Court N/A   52.5111371 -2.0643295
24550 op-snap---monthly-publication-september-2025.pdf   769 2025-09 Car Seat Leon Grey Driving without Due Care and Attention None Moor Street Moor Street Dudley Dudley Education N/A   52.4816337 -2.1283208
24584 op-snap---monthly-publication-september-2025.pdf   803 2025-09 Other Audi A1 Black Driving without Due Care and Attention None Waterfront car park 7 Waterfront car park 7 Dudley Dudley Warning Letter N/A      
24586 op-snap---monthly-publication-september-2025.pdf   805 2025-09 Other Audi A4 Grey Driving without Due Care and Attention None Waterfron car park 7 Waterfron car park 7 Dudley Dudley Warning Letter N/A      
24607 op-snap---monthly-publication-september-2025.pdf   826 2025-09 Car Volkswagen Tiguan Black Driving without Due Care and Attention None High Street, Stourbridge High Street, Stourbridge Dudley Dudley Education N/A   52.4570763 -2.1136199
24612 op-snap---monthly-publication-september-2025.pdf   831 2025-09 Car Toyota CHR White Contravening a Red Traffic Light None Birmingham New Road (Burntree) Birmingham New Road (Burntree) Dudley Dudley Fixed Penalty N/A      
24620 op-snap---monthly-publication-september-2025.pdf   839 2025-09 other Volkswagen golf Grey Misc - Non Traffic Offences None Waterfront car park Waterfront car park Dudley Dudley NFA No Independent Evidence Available      
24623 op-snap---monthly-publication-september-2025.pdf   842 2025-09 Other Volkswagen Caddy van White Misc - Non Traffic Offences None Waterfront car park Waterfront car park Dudley Dudley NFA No Independent Evidence Available      
24639 op-snap---monthly-publication-september-2025.pdf   858 2025-09 Car Volvo S90.. Grey Contravening a Red Traffic Light None Aston Road B4177 Aston Road B4177 Dudley Dudley Fixed Penalty N/A   52.5054243 -2.0950625
24712 op-snap---monthly-publication-september-2025.pdf   931 2025-09 Pedestrian Vauxhall Caddy White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
24724 op-snap---monthly-publication-september-2025.pdf   943 2025-09 Pedal Bike Citroen DS3 Red Use a vehicle / cycle on a road and contravene a l ocal traffic order other Nthoanne parking Worcester Street, Stourbridge Worcester Street, Stourbridge Dudley Dudley Fixed Penalty N/A   52.4507058 -2.1503743
24725 op-snap---monthly-publication-september-2025.pdf   944 2025-09 Car Toyota Prius Silver Driving without Due Care and Attention None Stourbridge Road Stourbridge Road Dudley Dudley NFA No Independent Evidence Available   52.5002997 -2.1081386
24735 op-snap---monthly-publication-september-2025.pdf   954 2025-09 Car BMW X1 Silver Contravening a Red Traffic Light None Castlegate Island Castlegate Island Dudley Dudley Education N/A      
24765 op-snap---monthly-publication-september-2025.pdf   984 2025-09 Car Jaguar E-Pace Silver Driving without Due Care and Attention None Archer Way Archer Way Dudley Dudley Education N/A      
24769 op-snap---monthly-publication-september-2025.pdf   988 2025-09 Other Volkswagen Golf White Driving without Due Care and Attention None Merry Hill Main Car Park Merry Hill Main Car Park Dudley Dudley NFA No Offence      
24771 op-snap---monthly-publication-september-2025.pdf   990 2025-09 Other Volkswagen EOS Black Driving without Due Care and Attention None Merry Hill Main Car Park Merry Hill Main Car Park Dudley Dudley Warning Letter N/A      
24772 op-snap---monthly-publication-september-2025.pdf   991 2025-09 Car BMW M340D Black Driving without Due Care and Attention None Hall Street Hall Street Dudley Dudley Fixed Penalty N/A   52.5409774 -2.1235921
24791 op-snap---monthly-publication-september-2025.pdf   1010 2025-09 Car Mercedes-Benz GLA 300 Grey Contravening a Red Traffic Light None Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
24794 op-snap---monthly-publication-september-2025.pdf   1013 2025-09 Car Hyundai Ioniq Silver Contravening a Red Traffic Light None Highbridge Road Highbridge Road Dudley Dudley NFA Outside of 14 Days NIP   52.485907 -2.0953009
24795 op-snap---monthly-publication-september-2025.pdf   1014 2025-09 Car Kia Venga Silver Driving without Due Care and Attention None Bowers Lane Bowers Lane Dudley Dudley Warning Letter N/A      
24796 op-snap---monthly-publication-september-2025.pdf   1015 2025-09 Car Ford C-Max Black Driving without Due Care and Attention None Dudley Road Dudley Road Dudley Dudley NFA Outside of 14 Days NIP   52.4881161 -2.1199108
24808 op-snap---monthly-publication-september-2025.pdf   1027 2025-09 Other Volkswagen Taigo Blue Driving without Reasonable Consideration None Thorns Hill Thorns Hill Dudley Dudley Fixed Penalty N/A   52.4679374 -2.1184626
24824 op-snap---monthly-publication-september-2025.pdf   1043 2025-09 Car Vauxhall Zafira White Using a Mobile Phone Whilst Driving None Gerald Road Gerald Road Dudley Dudley Fixed Penalty N/A   52.4655739 -2.1614353
24838 op-snap---monthly-publication-september-2025.pdf   1057 2025-09 Other Seat Leon White Driving without Due Care and Attention None Waterfront Main Car Park Waterfront Main Car Park Dudley Dudley Warning Letter N/A      
24839 op-snap---monthly-publication-september-2025.pdf   1058 2025-09 Other Yamaha Aprilia 125 Black Driving without Due Care and Attention None Waterfront Main Car Park Waterfront Main Car Park Dudley Dudley Warning Letter N/A      
24843 op-snap---monthly-publication-september-2025.pdf   1062 2025-09 Car BMW X1 White Driving without Due Care and Attention None Tame Road Tame Road Dudley Dudley Court N/A   52.4710313 -2.0126866
24846 op-snap---monthly-publication-september-2025.pdf   1065 2025-09 Car Lamborghini Ferrari Red Contravening a Red Traffic Light None Moss Grove / Summer Hill Road, Kingswinford Moss Grove / Summer Hill Road, Kingswinford Dudley Dudley Education N/A   52.5025066 -2.1702039
24847 op-snap---monthly-publication-september-2025.pdf   1066 2025-09 car Ford Transit White Using a Mobile Phone Whilst Driving None Peartree Lane Peartree Lane Dudley Dudley Fixed Penalty N/A   52.4999595 -2.0919022
24850 op-snap---monthly-publication-september-2025.pdf   1069 2025-09 Car Volkswagen Touran Black Contravening a Red Traffic Light None King Street King Street Dudley Dudley NFA Outside of 14 Days NIP   52.5095654 -2.0806912
24870 op-snap---monthly-publication-september-2025.pdf   1089 2025-09 Car BMW 320.. White Driving without Due Care and Attention None Mucklow Hill Mucklow Hill Dudley Dudley Warning Letter N/A   52.461008 -2.0345574
24875 op-snap---monthly-publication-september-2025.pdf   1094 2025-09 Other Ford Fiesta Red Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Warning Letter N/A   52.4879006 -2.1188734
24876 op-snap---monthly-publication-september-2025.pdf   1095 2025-09 Other Ford Fiesta Black Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Warning Letter N/A   52.4879006 -2.1188734
24880 op-snap---monthly-publication-september-2025.pdf   1099 2025-09 Other Ford Fiesta Blue Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley NFA No Offence      
24900 op-snap---monthly-publication-september-2025.pdf   1119 2025-09 Car Renault Trafic Black Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Warning Letter N/A   52.5047428 -2.0823754
24903 op-snap---monthly-publication-september-2025.pdf   1122 2025-09 Car Mercedes-Benz C220 White Driving without Due Care and Attention None Cot Lane Cot Lane Dudley Dudley Court N/A   52.4939289 -2.1730601
24992 op-snap---monthly-publication-september-2025.pdf   1211 2025-09 Car Volkswagen scirocco White Misc - Non Traffic Offences None m5 M5 Dudley Dudley NFA Misc Inc Crimes      
25063 op-snap---monthly-publication-september-2025.pdf   1282 2025-09 Pedestrian Mercedes-Benz A180 White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
25081 op-snap---monthly-publication-september-2025.pdf   1300 2025-09 Car Ford fiesta Blue Misc - Non Traffic Offences No Insurance quarry bank high street Quarry Bank High Street Dudley Dudley NFA Misc Inc Crimes   52.4725789 -2.100641
25096 op-snap---monthly-publication-september-2025.pdf   1315 2025-09 Pedestrian Seat leon White Motor vehicle fail to comply with a non endorsab le traffic sign - detectedN boyn meeans other than ACD Brierley Hill Brierley Hill Dudley Dudley Other Action Taken N/A   52.4823185 -2.1237803
25211 op-snap---monthly-publication-september-2025.pdf   1430 2025-09 Car Ford Ranger Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Whithymoor primary school Whithymoor primary school Dudley Dudley Warning Letter N/A      
25212 op-snap---monthly-publication-september-2025.pdf   1431 2025-09 Car Mini Countryman Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Whithymoor Primary School Whithymoor Primary School Dudley Dudley NFA Misc Inc Crimes      
25241 op-snap---monthly-publication-september-2025.pdf   1460 2025-09 Car Audi A3 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Roberts St Roberts Street Dudley Dudley Warning Letter N/A   52.5213135 -2.1197042
25264 op-snap---monthly-publication-september-2025.pdf   1483 2025-09 Car Volkswagen Polo White VRM fails to conform to Regulations None Wollescote Road Wollescote Road Dudley Dudley Warning Letter N/A   52.4471527 -2.1236271
25316 op-snap---monthly-publication-september-2025.pdf   1535 2025-09 Car Mg 3 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Berwood Road Berwood Road Dudley Dudley Warning Letter N/A      
25317 op-snap---monthly-publication-september-2025.pdf   1536 2025-09 Car Audi q3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Berwood Road Berwood Road Dudley Dudley Warning Letter N/A      
25318 op-snap---monthly-publication-september-2025.pdf   1537 2025-09 Car Toyota Rav4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Berwood Road Berwood Road Dudley Dudley Warning Letter N/A      

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