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

105 rows where council_area = "Walsall", disposal = "NFA" and offence = "Driving without Due Care and Attention" 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

vehicle_make 28

  • Audi 11
  • Ford 11
  • Mercedes-Benz 11
  • Volkswagen 10
  • BMW 9
  • Toyota 5
  • Vauxhall 4
  • Citroen 3
  • Hyundai 3
  • Daf 2
  • Lexus 2
  • Peugeot 2
  • Scania 2
  • Skoda 2
  • Volvo 2
  • Yamaha 2
  • Alfa Romeo 1
  • Fiat 1
  • Honda 1
  • Jaguar 1
  • Kia 1
  • Maxus 1
  • Mini 1
  • Mitsubishi 1
  • Nissan 1
  • Porsche 1
  • Renault 1
  • Seat 1

month 14

  • 2025-06 14
  • 2025-08 14
  • 2025-05 12
  • 2026-02 11
  • 2025-10 9
  • 2025-04 8
  • 2025-03 7
  • 2025-09 7
  • 2025-12 6
  • 2025-07 5
  • 2026-01 5
  • 2025-02 3
  • 2025-11 3
  • 2025-01 1

reporter_transport_mode 6

  • Car 76
  • Pedal Bike 13
  • Other 7
  • Lorry 4
  • Pedestrian 4
  • Van 1

offence 1

  • Driving without Due Care and Attention · 105 ✖

disposal 1

  • NFA · 105 ✖

council_area 1

  • Walsall · 105 ✖
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
7311 op-snap---monthly-publication-february-2026.pdf   58 2026-02 Car Audi A7 Black Driving without Due Care and Attention None Aldridge Road Aldridge Road Walsall Walsall NFA No Independent Evidence Available   52.5668693 -1.8879364
7414 op-snap---monthly-publication-february-2026.pdf   161 2026-02 Car       Driving without Due Care and Attention None Walsall Road Walsall Road Walsall Walsall NFA No VRM   52.6166864 -1.9660822
7450 op-snap---monthly-publication-february-2026.pdf   197 2026-02 Car Fiat 500 Blue Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Walsall Walsall NFA     52.5867763 -2.0104342
7688 op-snap---monthly-publication-february-2026.pdf   435 2026-02 Car Citroen Berlingo Silver Driving without Due Care and Attention None Wallows Lane Wallows Lane Walsall Walsall NFA No Offence   52.5699435 -2.0008354
7692 op-snap---monthly-publication-february-2026.pdf   439 2026-02 Car Volkswagen Tiguan White Driving without Due Care and Attention None JCT 11 M6 Jct 11 M6 Walsall Walsall NFA No Offence      
7703 op-snap---monthly-publication-february-2026.pdf   450 2026-02 Other Hyundai I10 White Driving without Due Care and Attention None Ashmore Lake Road Ashmore Lake Road Walsall Walsall NFA No Offence   52.5961284 -2.0497272
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
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
8251 op-snap---monthly-publication-february-2026.pdf   998 2026-02 Car Volkswagen Golf Black Driving without Due Care and Attention None Hydes Road Hydes Road Walsall Walsall NFA No Independent Evidence Available      
8482 op-snap---monthly-publication-february-2026.pdf   1229 2026-02 Pedestrian Vauxhall Adam Black Driving without Due Care and Attention None Mcdonalds Car Park Mcdonalds Car Park Walsall Walsall NFA No Independent Evidence Available      
8578 op-snap---monthly-publication-february-2026.pdf   1325 2026-02 Car Ford Transit White Driving without Due Care and Attention None Bridlewood Bridlewood Walsall Walsall NFA No Independent Evidence Available   52.5756112 -1.8865562
10608 op-snap---monthly-publication-january-2026.pdf   69 2026-01 Car Volkswagen Scirocco Black Driving without Due Care and Attention None M6 to M5 junction M6 to M5 junction Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.6912891 -2.1046372
10630 op-snap---monthly-publication-january-2026.pdf   91 2026-01 Pedestrian BMW 3 series White Driving without Due Care and Attention None Navigation Street Navigation Street Walsall Walsall NFA No Independent Evidence Available   52.5842791 -1.9872353
10643 op-snap---monthly-publication-january-2026.pdf   104 2026-01 Car Volkswagen Arteon Black Driving without Due Care and Attention None M6 SB J9 M6 Southbound J9 Walsall Walsall NFA No Independent Evidence Available   52.676119 -2.0858425
11079 op-snap---monthly-publication-january-2026.pdf   540 2026-01 Car Audi Q6 - e tron Black Driving without Due Care and Attention None M6 jn10 M6 jn10 Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5856486 -2.0142344
11589 op-snap---monthly-publication-january-2026.pdf   1050 2026-01 Car Scania HGV Blue Driving without Due Care and Attention None M6 North M6 North Walsall Walsall NFA No VRM   52.5859649 -1.9897914
4089 op-snap---monthly-publication-december-2025.pdf   217 2025-12 Car     White Driving without Due Care and Attention None M6 North Junction 10. M6 North Junction 10 Walsall Walsall NFA No VRM      
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      
4624 op-snap---monthly-publication-december-2025.pdf   752 2025-12 Car Scania HGV Red Driving without Due Care and Attention None M6 (N) at jn10 M6 (N) at jn10 Walsall Walsall NFA No Offence      
4918 op-snap---monthly-publication-december-2025.pdf   1046 2025-12 Other Yamaha Scrambler Orange Driving without Due Care and Attention Keeping a vehicle with registr aPtoiopnla rm Aavrekns uoeb,s cured a Ptoiopnla rm Aavrekns uoeb, s cured Walsall Walsall NFA No VRM      
4962 op-snap---monthly-publication-december-2025.pdf   1090 2025-12 Other Yamaha off road Orange Driving without Due Care and Attention None Poplar Avenue Poplar Avenue Walsall Walsall NFA No VRM   52.5945052 -2.0227343
5063 op-snap---monthly-publication-december-2025.pdf   1191 2025-12 Car Toyota Aygo White Driving without Due Care and Attention None Darlaston Road Darlaston Road Walsall Walsall NFA No Independent Evidence Available   52.5635181 -2.0322876
20732 op-snap---monthly-publication-november-2025.pdf   274 2025-11 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Hamstead Hill Hamstead Hill Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5309945 -1.9288687
21780 op-snap---monthly-publication-november-2025.pdf   1322 2025-11 Car Volvo HGV White Driving without Due Care and Attention None Sutton Road Walsall Sutton Road Walsall Walsall Walsall NFA No Offence   52.5803912 -1.941961
21972 op-snap---monthly-publication-november-2025.pdf   1514 2025-11 Car Maxus Deliver White Driving without Due Care and Attention None Walsall Road Walsall Road Walsall Walsall NFA No Offence   52.6166864 -1.9660822
22222 op-snap---monthly-publication-october-2025.pdf   172 2025-10 Car Toyota Auris Silver Driving without Due Care and Attention None Wood Green Road Wood Green Road Walsall Walsall NFA No Offence   52.6248989 -1.9343969
22584 op-snap---monthly-publication-october-2025.pdf   534 2025-10 Car BMW 135i White Driving without Due Care and Attention None Bescot Road, M6 Jn9 Bescot Road, M6 Jn9 Walsall Walsall NFA No Independent Evidence Available      
22632 op-snap---monthly-publication-october-2025.pdf   582 2025-10 Car Mercedes-Benz C-class Silver Driving without Due Care and Attention None Moat Road / Pleck Road Moat Road / Pleck Road Walsall Walsall NFA No VRM   52.5850047 -2.0016678
22633 op-snap---monthly-publication-october-2025.pdf   583 2025-10 Car Volkswagen Passat Black Driving without Due Care and Attention None Lyttleton Street Lyttleton Street Walsall Walsall NFA No Offence      
22700 op-snap---monthly-publication-october-2025.pdf   650 2025-10 Lorry Toyota   White Driving without Due Care and Attention None M6 M6 Walsall Walsall NFA No Independent Evidence Available      
22909 op-snap---monthly-publication-october-2025.pdf   859 2025-10 Car Ford Focus Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Walsall Walsall NFA No Offence   52.5723244 -1.9607214
22959 op-snap---monthly-publication-october-2025.pdf   909 2025-10 Car Toyota Prius Blue Driving without Due Care and Attention None Pleck Road Pleck Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5827033 -1.9960274
23049 op-snap---monthly-publication-october-2025.pdf   999 2025-10 Car Lexus Unknown Grey Driving without Due Care and Attention None Delves Green Lane Delves Green Lane Walsall Walsall NFA No Independent Evidence Available      
23058 op-snap---monthly-publication-october-2025.pdf   1008 2025-10 Car Daf HGV Blue Driving without Due Care and Attention None M6 J9 SB M6 J9 Southbound Walsall Walsall NFA No Offence   52.676119 -2.0858425
23806 op-snap---monthly-publication-september-2025.pdf   25 2025-09 Other   Moto bike Blue Driving without Due Care and Attention None Poplar Avenue Poplar Avenue Walsall Walsall NFA No VRM   52.5945052 -2.0227343
24197 op-snap---monthly-publication-september-2025.pdf   416 2025-09 Lorry Alfa Romeo   Blue Driving without Due Care and Attention None M6 Jct 10 Southbound M6 Junction 10 Southbound Walsall Walsall NFA No Offence   52.676119 -2.0858425
24410 op-snap---monthly-publication-september-2025.pdf   629 2025-09 Car Mercedes-Benz A Class Grey Driving without Due Care and Attention None Hall Lane, Pelsall Hall Lane, Pelsall Walsall Walsall NFA No VRM   52.6255445 -1.9722185
24536 op-snap---monthly-publication-september-2025.pdf   755 2025-09 Other Ford Transit White Driving without Due Care and Attention None Almond Avenue Almond Avenue Walsall Walsall NFA No Independent Evidence Available   52.5937008 -2.0278742
24616 op-snap---monthly-publication-september-2025.pdf   835 2025-09 Pedal Bike Audi A4 Black Driving without Due Care and Attention None Slaters Lane Slaters Lane Walsall Walsall NFA No Offence   52.5719978 -2.0041926
24720 op-snap---monthly-publication-september-2025.pdf   939 2025-09 Car Audi TT. White Driving without Due Care and Attention None M5 at M6 junction M5 at M6 junction Walsall Walsall NFA No Independent Evidence Available      
24907 op-snap---monthly-publication-september-2025.pdf   1126 2025-09 Car Porsche Macan Black Driving without Due Care and Attention None J10 M6 J10 M6 Walsall Walsall NFA No Offence   52.5726914 -2.0123687
2042 op-snap---monthly-publication-august-2025.pdf   17 2025-08 Car Ford Fiesta Silver Driving without Due Care and Attention None Walsall Road Walsall Road Walsall Walsall NFA No Offence   52.6166864 -1.9660822
2148 op-snap---monthly-publication-august-2025.pdf   123 2025-08 Car Volkswagen Polo Black Driving without Due Care and Attention None Bloxwich Road Bloxwich Road Walsall Walsall NFA No VRM   52.6099132 -1.9970978
2213 op-snap---monthly-publication-august-2025.pdf   188 2025-08 Car Mercedes-Benz CLA 220 White Driving without Due Care and Attention None Darlaston Road Darlaston Road Walsall Walsall NFA Not in Public Interest   52.5635181 -2.0322876
2477 op-snap---monthly-publication-august-2025.pdf   452 2025-08 Car Seat   White Driving without Due Care and Attention None M6 M6 Walsall Walsall NFA Outside of 14 Days NIP      
2566 op-snap---monthly-publication-august-2025.pdf   541 2025-08 Car Audi Q2 Grey Driving without Due Care and Attention None Hydes Road Hydes Road Walsall Walsall NFA No Offence      
2574 op-snap---monthly-publication-august-2025.pdf   549 2025-08 Car Ford S Max Black Driving without Due Care and Attention None A454 Walsall Walsall Walsall Walsall NFA No Independent Evidence Available   52.5841365 -1.9852679
2696 op-snap---monthly-publication-august-2025.pdf   671 2025-08 Car Audi A4 Grey Driving without Due Care and Attention None Stonnall Road Stonnall Road Walsall Walsall NFA No Independent Evidence Available   52.6144423 -1.9059638
2781 op-snap---monthly-publication-august-2025.pdf   756 2025-08 Car Mitsubishi Lancer White Driving without Due Care and Attention None Lichfield Road Lichfield Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.6095168 -2.0493009
2839 op-snap---monthly-publication-august-2025.pdf   814 2025-08 Pedal Bike Mercedes-Benz C350 Blue Driving without Due Care and Attention None Broadway West at Lord Street Broadway West at Lord Street Walsall Walsall NFA No Offence   52.5693639 -1.9919063
2849 op-snap---monthly-publication-august-2025.pdf   824 2025-08 Car Nissan Qashqai Black Driving without Due Care and Attention None M6 North Jct 10 M6 North Junction 10 Walsall Walsall NFA Outside of 14 DAYS Late Submission      
2907 op-snap---monthly-publication-august-2025.pdf   882 2025-08 Car Mercedes-Benz A Class Red Driving without Due Care and Attention None A454 A454 Walsall Walsall NFA No Offence      
2939 op-snap---monthly-publication-august-2025.pdf   914 2025-08 Other BMW 1 series Blue Driving without Due Care and Attention None Bridle Lane Bridle Lane Walsall Walsall NFA No Independent Evidence Available   52.5742643 -1.8934596
2988 op-snap---monthly-publication-august-2025.pdf   963 2025-08 Car   Van White Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall NFA No Independent Evidence Available   52.5692139 -1.8799672
2990 op-snap---monthly-publication-august-2025.pdf   965 2025-08 Lorry Skoda   Green Driving without Due Care and Attention None M6 J10 M6 J10 Walsall Walsall NFA No VRM   52.676119 -2.0858425
12114 op-snap---monthly-publication-july-2025.pdf   166 2025-07 Other Citroen Berlingo White Driving without Due Care and Attention None Ward Street Ward Street Walsall Walsall NFA Outside of 14 Days NIP   52.5918096 -2.0485738
12267 op-snap---monthly-publication-july-2025.pdf   319 2025-07 Car Kia Picanto Silver Driving without Due Care and Attention None Leigh Road Leigh Road Walsall Walsall NFA Outside of 14 Days NIP   52.594756 -1.9663792
12275 op-snap---monthly-publication-july-2025.pdf   327 2025-07 Car Skoda Superb White Driving without Due Care and Attention None Litchfield Road Litchfield Road Walsall Walsall NFA No Independent Evidence Available      
12353 op-snap---monthly-publication-july-2025.pdf   405 2025-07 Pedal Bike Audi A6... Black Driving without Due Care and Attention None Butts Road Butts Road Walsall Walsall NFA Not in Public Interest   52.592263 -1.9743536
12660 op-snap---monthly-publication-july-2025.pdf   712 2025-07 Car Hyundai i10 Red Driving without Due Care and Attention None M6 north J8 M6 north J8 Walsall Walsall NFA Outside of 14 Days NIP      
14290 op-snap---monthly-publication-june-2025.pdf   219 2025-06 Car Ford Focus Black Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall NFA No Independent Evidence Available   52.5692139 -1.8799672
14726 op-snap---monthly-publication-june-2025.pdf   655 2025-06 Car Mercedes-Benz   Silver Driving without Due Care and Attention None M6 Northbound M6 Northbound Walsall Walsall NFA Outside of 14 Days NIP      
14727 op-snap---monthly-publication-june-2025.pdf   656 2025-06 Car Toyota   Blue Driving without Due Care and Attention None M6 Northbound M6 Northbound Walsall Walsall NFA Outside of 14 Days NIP      
15043 op-snap---monthly-publication-june-2025.pdf   972 2025-06 Pedal Bike Vauxhall Meriva Grey Driving without Due Care and Attention None Wolverhampton Road West Wolverhampton Road West Walsall Walsall NFA No Offence   52.5866889 -2.0354488
15092 op-snap---monthly-publication-june-2025.pdf   1021 2025-06 Car Lexus Diablo Red Driving without Due Care and Attention None Lindon Road, Brownhills Lindon Road, Brownhills Walsall Walsall NFA Outside of 14 Days NIP   52.6404641 -1.9267966
15102 op-snap---monthly-publication-june-2025.pdf   1031 2025-06 Car Audi A3 Grey Driving without Due Care and Attention None M6 Motorway M6 Motorway Walsall Walsall NFA Outside of 14 Days NIP   52.6151447 -2.0290522
15104 op-snap---monthly-publication-june-2025.pdf   1033 2025-06 Pedestrian   Unknown Black Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall NFA No VRM   52.5692139 -1.8799672
15133 op-snap---monthly-publication-june-2025.pdf   1062 2025-06 Car Hyundai I20 White Driving without Due Care and Attention None Churchill Road Churchill Road Walsall Walsall NFA No Independent Evidence Available   52.5887964 -2.0253617
15145 op-snap---monthly-publication-june-2025.pdf   1074 2025-06 Car Audi   Blue Driving without Due Care and Attention None Walstead Road Walstead Road Walsall Walsall NFA Outside of 14 Days NIP   52.5648629 -1.9517624
15170 op-snap---monthly-publication-june-2025.pdf   1099 2025-06 Car   MAN White Driving without Due Care and Attention None M6 NB J8-9 M6 Northbound J8-9 Walsall Walsall NFA No Offence   52.6760749 -2.0862582
15242 op-snap---monthly-publication-june-2025.pdf   1171 2025-06 Van BMW 5 SERIES Blue Driving without Due Care and Attention No vehicle excise licence PINFOLD STREET, DARLASTON Pinfold Street, Darlaston Walsall Walsall NFA Outside of 14 Days NIP   52.5652629 -2.0396651
15692 op-snap---monthly-publication-june-2025.pdf   1621 2025-06 Pedal Bike Ford Galaxy Grey Driving without Due Care and Attention None Hollyhedge Road Hollyhedge Road Walsall Walsall NFA No Offence   52.5862112 -1.9959499
15741 op-snap---monthly-publication-june-2025.pdf   1670 2025-06 Car Volkswagen Amarok Black Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall NFA No VRM   52.5692139 -1.8799672
16033 op-snap---monthly-publication-june-2025.pdf   1962 2025-06 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Arundel Street Arundel Street Walsall Walsall NFA Outside of 14 Days NIP   52.5746233 -1.9815255
18896 op-snap---monthly-publication-may-2025.pdf   258 2025-05 Car Mercedes-Benz S class Black Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5867763 -2.0104342
18905 op-snap---monthly-publication-may-2025.pdf   267 2025-05 Pedal Bike       Driving without Due Care and Attention None Corporation street Corporation street Walsall Walsall NFA No VRM   52.5773099 -1.9850716
19048 op-snap---monthly-publication-may-2025.pdf   410 2025-05 Car Ford Transit White Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5692139 -1.8799672
19934 op-snap---monthly-publication-may-2025.pdf   1296 2025-05 Car Jaguar NP Black Driving without Due Care and Attention None Ablewell street Ablewell street Walsall Walsall NFA Outside of 14 Days NIP   52.5821593 -1.9747872
19953 op-snap---monthly-publication-may-2025.pdf   1315 2025-05 Pedal Bike Daf Truck White Driving without Due Care and Attention None Chester road Chester road Walsall Walsall NFA Outside of 14 Days NIP   52.5692139 -1.8799672
20000 op-snap---monthly-publication-may-2025.pdf   1362 2025-05 Pedal Bike BMW 600 SERIES Blue Driving without Due Care and Attention None jtc with barns lane Jtc With Barns Lane Walsall Walsall NFA Outside of 14 Days NIP      
20020 op-snap---monthly-publication-may-2025.pdf   1382 2025-05 Pedal Bike Honda jazz Silver Driving without Due Care and Attention None Bescot Crescent road Bescot Crescent road Walsall Walsall NFA Outside of 14 Days NIP   52.575204 -1.9916288
20085 op-snap---monthly-publication-may-2025.pdf   1447 2025-05 Car BMW 3rd series Black Driving without Due Care and Attention None TRYSULL RD TO BRADMORE RD Trysull Rd To Bradmore Rd Walsall Walsall NFA Outside of 14 Days NIP      
20225 op-snap---monthly-publication-may-2025.pdf   1587 2025-05 Pedestrian     White Driving without Due Care and Attention None Poplar Avenue, Walsall Poplar Avenue, Walsall Walsall Walsall NFA No VRM   52.5945052 -2.0227343
20228 op-snap---monthly-publication-may-2025.pdf   1590 2025-05 Pedal Bike       Driving without Due Care and Attention None Broad Lane, Bloxwich Broad Lane, Bloxwich Walsall Walsall NFA No VRM   52.6263759 -2.0189428
20231 op-snap---monthly-publication-may-2025.pdf   1593 2025-05 Car Audi q2 Black Driving without Due Care and Attention None Chester Road, Streetly Chester Road, Streetly Walsall Walsall NFA Misc Inc Crimes   52.5774374 -1.8842966
20358 op-snap---monthly-publication-may-2025.pdf   1720 2025-05 Car Volkswagen Polo Grey Driving without Due Care and Attention None Wood Green Road Wood Green Road Walsall Walsall NFA Misc Inc Crimes   52.6248989 -1.9343969
161 op-snap---monthly-publication-april-2025.pdf   160 2025-04 Pedal Bike Vauxhall Corsa Brown Driving without Due Care and Attention None Lichfield Road Lichfield Road Walsall Walsall NFA No Offence   52.6095168 -2.0493009
418 op-snap---monthly-publication-april-2025.pdf   417 2025-04 Car Citroen Relay White Driving without Due Care and Attention None Butts Road Butts Road Walsall Walsall NFA Outside of 14 Days NIP   52.592263 -1.9743536
419 op-snap---monthly-publication-april-2025.pdf   418 2025-04 Car Volvo V70 Red Driving without Due Care and Attention None Birmingham Street Birmingham Street Walsall Walsall NFA Outside of 14 Days NIP   52.584412 -2.0454894
1591 op-snap---monthly-publication-april-2025.pdf   1590 2025-04 Car BMW NP Silver Driving without Due Care and Attention None Greaves Avenue Greaves Avenue Walsall Walsall NFA Outside of 14 Days NIP   52.5773135 -1.9525262
1593 op-snap---monthly-publication-april-2025.pdf   1592 2025-04 Car Audi A1 Black Driving without Due Care and Attention None Hall lane pelsall Hall lane pelsall Walsall Walsall NFA Outside of 14 Days NIP   52.6255445 -1.9722185
1664 op-snap---monthly-publication-april-2025.pdf   1663 2025-04 Car   Jeep Cherokee Grey Driving without Due Care and Attention None Lichfield road Lichfield road Walsall Walsall NFA Outside of 14 Days NIP   52.6095168 -2.0493009
1810 op-snap---monthly-publication-april-2025.pdf   1809 2025-04 Pedal Bike Vauxhall Zafira Silver Driving without Due Care and Attention None Henley road Henley road Walsall Walsall NFA Outside of 14 Days NIP   52.5327231 -1.9300755
1923 op-snap---monthly-publication-april-2025.pdf   1922 2025-04 Car Ford NP White Driving without Due Care and Attention None M6 North bound M6 North bound Walsall Walsall NFA Outside of 14 Days NIP      
16955 op-snap---monthly-publication-march-2025.pdf   712 2025-03 Car BMW 3 Blue Driving without Due Care and Attention None Birmingham Road Birmingham Road Metropolitan Borough of Walsall Walsall NFA No VRM Yes - Via Email 52.5723244 -1.9607214
17527 op-snap---monthly-publication-march-2025.pdf   1284 2025-03 Pedal Bike Ford Transit White Driving without Due Care and Attention None The Crescent The Crescent Walsall Walsall NFA No Offence Yes - Via Email 52.5833842 -2.0393808
17570 op-snap---monthly-publication-march-2025.pdf   1327 2025-03 Car   Quad bike   Driving without Due Care and Attention None Aldridge Road Aldridge Road Walsall Walsall NFA No VRM Yes - Via Email 52.5668693 -1.8879364
17703 op-snap---monthly-publication-march-2025.pdf   1460 2025-03 Car Peugeot 207.. Red Driving without Due Care and Attention None Old Birchills, Walsall Old Birchills, Walsall Walsall Walsall NFA No VRM Yes - Via Email 52.5927031 -1.9924842
17904 op-snap---monthly-publication-march-2025.pdf   1661 2025-03 Car Ford Focus Silver Driving without Due Care and Attention None A5 A5 Walsall Walsall NFA No VRM Yes - Via Email    
17955 op-snap---monthly-publication-march-2025.pdf   1712 2025-03 Car Peugeot 308... White Driving without Due Care and Attention None U/K - Details only given as `Bloxwich` U/K - Details only given as `Bloxwich` Walsall Walsall NFA No VRM Yes - Via Email    

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