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

208 rows where council_area = "Walsall", disposal = "NFA" and reporter_transport_mode = "Car" 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

reporter_transport_mode 1

  • Car · 208 ✖

disposal 1

  • NFA · 208 ✖

council_area 1

  • Walsall · 208 ✖
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      
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
8178 op-snap---monthly-publication-february-2026.pdf   925 2026-02 Car Skoda Enyaq Blue Offence to be added None M6 NB J8 M6 Northbound J8 Walsall Walsall NFA No Independent Evidence Available   52.6760749 -2.0862582
8230 op-snap---monthly-publication-february-2026.pdf   977 2026-02 Car Toyota Prius Blue Contravening a Red Traffic Light None Green Lane, Green Lane Walsall Walsall NFA     52.5995834 -1.9971273
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      
8399 op-snap---monthly-publication-february-2026.pdf   1146 2026-02 Car       Contravening a Red Traffic Light None Sneyd Lane Sneyd Lane Walsall Walsall NFA No Independent Evidence Available   52.6198941 -2.0150184
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
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      
4387 op-snap---monthly-publication-december-2025.pdf   515 2025-12 Car Peugeot Boxer Silver Contravening a Red Traffic Light None Hall Lane Hall Lane Walsall Walsall NFA No Independent Evidence Available   52.6255445 -1.9722185
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      
4830 op-snap---monthly-publication-december-2025.pdf   958 2025-12 Car Hyundai TUCSON White Using a Mobile Phone Whilst Driving None M6 near Willenhall M6 near Willenhall Walsall Walsall NFA No Independent Evidence Available      
4951 op-snap---monthly-publication-december-2025.pdf   1079 2025-12 Car Porsche taycan Blue Misc - Non Traffic Offences None broadway west Broadway West Walsall Walsall NFA Misc Inc Crimes   52.5698309 -1.9942176
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
5076 op-snap---monthly-publication-december-2025.pdf   1204 2025-12 Car Alfa Romeo NK Blue Drive on hard shoulder No Insurance M6 Jct 10 M6 Junction 10 Walsall Walsall NFA No VRM   52.676119 -2.0858425
20594 op-snap---monthly-publication-november-2025.pdf   136 2025-11 Car Volkswagen   Silver Contravening a Red Traffic Light None Lindon Road Lindon Road Walsall Walsall NFA No Independent Evidence Available   52.6404641 -1.9267966
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
21190 op-snap---monthly-publication-november-2025.pdf   732 2025-11 Car Audi Q7 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Buckle Close Buckle Close Walsall Walsall NFA No Independent Evidence Available   52.5776288 -1.9794178
21525 op-snap---monthly-publication-november-2025.pdf   1067 2025-11 Car Vauxhall Mokka Blue Using a Mobile Phone Whilst Driving None Stephson Street Stephson Street Walsall Walsall NFA No Independent Evidence Available      
21718 op-snap---monthly-publication-november-2025.pdf   1260 2025-11 Car Vauxhall   White Misc - Non Traffic Offences None Walsall Wood. Walsall Wood Walsall Walsall NFA No Offence   52.629207 -1.9300274
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
21946 op-snap---monthly-publication-november-2025.pdf   1488 2025-11 Car Ford Kuga Blue Contravene Lane Closure Red X None Pelsall Road Pelsall Road Walsall Walsall NFA No Independent Evidence Available   52.6472723 -1.9393233
21953 op-snap---monthly-publication-november-2025.pdf   1495 2025-11 Car Ford Kuga Blue Contravening a Red Traffic Light None Pelsall Road Pelsall Road Walsall Walsall NFA No Independent Evidence Available   52.6472723 -1.9393233
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
21974 op-snap---monthly-publication-november-2025.pdf   1516 2025-11 Car Toyota Yaris White Contravening a Red Traffic Light None Broadway Broadway Walsall Walsall NFA No Offence   52.5719937 -1.9639882
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
22253 op-snap---monthly-publication-october-2025.pdf   203 2025-10 Car Seat Leon Orange Misc - Non Traffic Offences None Bloxwich Road Bloxwich Road Walsall Walsall NFA No Offence   52.6099132 -1.9970978
22387 op-snap---monthly-publication-october-2025.pdf   337 2025-10 Car Mercedes-Benz A180 Blue Contravening a Red Traffic Light None Braodway Braodway Walsall Walsall NFA No Independent Evidence Available      
22389 op-snap---monthly-publication-october-2025.pdf   339 2025-10 Car Mercedes-Benz A180 Blue Contravening a Red Traffic Light None Broadway West Broadway West Walsall Walsall NFA No Offence   52.5698309 -1.9942176
22397 op-snap---monthly-publication-october-2025.pdf   347 2025-10 Car     White Contravening a Red Traffic Light None A454 A454 Walsall Walsall NFA No VRM      
22401 op-snap---monthly-publication-october-2025.pdf   351 2025-10 Car Peugeot Expert White Contravene Lane Closure Red X None Park Lane Park Lane Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5703934 -2.0184
22515 op-snap---monthly-publication-october-2025.pdf   465 2025-10 Car Audi A3 White Using a Mobile Phone Whilst Driving None Wolverhampton Road Wolverhampton Road Walsall Walsall NFA No Independent Evidence Available   52.5867763 -2.0104342
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      
22672 op-snap---monthly-publication-october-2025.pdf   622 2025-10 Car Land Rover Defender Black Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway None M6 (S/B) Jn10a to Jn8 M6 (Southbound) Jn10a to Jn8 Walsall Walsall NFA No Offence      
22698 op-snap---monthly-publication-october-2025.pdf   648 2025-10 Car Ford Focus Red Contravening a Red Traffic Light None Bloxwich Lane Bloxwich Lane Walsall Walsall NFA No Offence   52.6020474 -2.014682
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
22960 op-snap---monthly-publication-october-2025.pdf   910 2025-10 Car Audi A6 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wisemore Road Wisemore Road Walsall Walsall NFA Misc Inc Crimes      
23044 op-snap---monthly-publication-october-2025.pdf   994 2025-10 Car Volvo Lorry Black Using a Mobile Phone Whilst Driving None M6 M6 Walsall Walsall NFA No Independent Evidence Available      
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      
23050 op-snap---monthly-publication-october-2025.pdf   1000 2025-10 Car Volkswagen Scirocco White Contravening a Red Traffic Light None Chester Road Chester Road Walsall Walsall NFA No Independent Evidence Available   52.5692139 -1.8799672
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
23350 op-snap---monthly-publication-october-2025.pdf   1300 2025-10 Car   Yutong G12 White Prohibited vehicle in offside lane of motorway None M6 M6 Walsall Walsall NFA Misc Inc Crimes      
23357 op-snap---monthly-publication-october-2025.pdf   1307 2025-10 Car Audi Q6 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Willenhall Road Willenhall Road Walsall Walsall NFA Misc Inc Crimes   52.5771198 -2.0320614
24098 op-snap---monthly-publication-september-2025.pdf   317 2025-09 Car Ford Transit White Using a Mobile Phone Whilst Driving None High Street Bloxwich High Street Bloxwich Walsall Walsall NFA No Independent Evidence Available   52.6124215 -2.0022243
24127 op-snap---monthly-publication-september-2025.pdf   346 2025-09 Car Land Rover Sport Black Contravening a Red Traffic Light None Field Lane Bloxwich Field Lane Bloxwich Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.6235236 -1.9592167
24307 op-snap---monthly-publication-september-2025.pdf   526 2025-09 Car Land Rover Discovery White Contravening a Red Traffic Light None Walstead Road Walstead Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5648629 -1.9517624
24327 op-snap---monthly-publication-september-2025.pdf   546 2025-09 Car Daf Aston Martin Gold Contravening a Red Traffic Light None A452 Brownhills Brownhills Walsall Walsall NFA No Offence   52.6421956 -1.927161
24353 op-snap---monthly-publication-september-2025.pdf   572 2025-09 Car Volkswagen Golf Silver Contravening a Red Traffic Light None M6 Junction 9 M6 Junction 9 Walsall Walsall NFA No VRM   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
24521 op-snap---monthly-publication-september-2025.pdf   740 2025-09 Car Mercedes-Benz Vito White Drive a vehicle other than on the carriageway of a motorway None M6 SB J8 M6 Southbound J8 Walsall Walsall NFA No Independent Evidence Available   52.6760749 -2.0862582
24635 op-snap---monthly-publication-september-2025.pdf   854 2025-09 Car Ford Kuga Grey Using a Mobile Phone Whilst Driving None Stafford Road, Bloxwich Stafford Road, Bloxwich Walsall Walsall NFA No Independent Evidence Available   52.6329291 -2.0080068
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
2033 op-snap---monthly-publication-august-2025.pdf   8 2025-08 Car Nissan Interstar White Using a Mobile Phone Whilst Driving None Walsall Road Walsall Road Walsall Walsall NFA No Independent Evidence Available   52.6166864 -1.9660822
2036 op-snap---monthly-publication-august-2025.pdf   11 2025-08 Car Ford Focus White Contravening a Red Traffic Light None Walsall Road Walsall Road Walsall Walsall NFA No Independent Evidence Available   52.6166864 -1.9660822
2040 op-snap---monthly-publication-august-2025.pdf   15 2025-08 Car Man HGV Blue Using a Mobile Phone Whilst Driving None Walsall Road Walsall Road Walsall Walsall NFA No Independent Evidence Available   52.6166864 -1.9660822
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
2045 op-snap---monthly-publication-august-2025.pdf   20 2025-08 Car Volvo S60 Blue Misc - Non Traffic Offences None Waslall Road Waslall Road Walsall Walsall NFA No Offence      
2083 op-snap---monthly-publication-august-2025.pdf   58 2025-08 Car Daf Truck Orange Contravening a Red Traffic Light None B4154 B4154 Walsall Walsall NFA No Offence   52.5532445 -1.9092118
2096 op-snap---monthly-publication-august-2025.pdf   71 2025-08 Car Mg ZS Trophy Silver Using a Mobile Phone Whilst Driving None A34 Jct 9 Junction 9 Walsall Walsall NFA No Independent Evidence Available   52.56499 -1.9863008
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
2198 op-snap---monthly-publication-august-2025.pdf   173 2025-08 Car Mercedes-Benz C class Silver Misc - Non Traffic Offences None Green Lane Green Lane Walsall Walsall NFA No Offence   52.5995834 -1.9971273
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
2289 op-snap---monthly-publication-august-2025.pdf   264 2025-08 Car Nissan Qashqai Grey Using a Mobile Phone Whilst Driving None M6 NB J9 M6 Northbound J9 Walsall Walsall NFA No Independent Evidence Available   52.676119 -2.0858425
2312 op-snap---monthly-publication-august-2025.pdf   287 2025-08 Car Ford kuga Grey Driving without Reasonable Consideration None M6 J10 M6 J10 Walsall Walsall NFA No Independent Evidence Available   52.676119 -2.0858425
2463 op-snap---monthly-publication-august-2025.pdf   438 2025-08 Car Mazda 6 Black Using a Mobile Phone Whilst Driving None Moncreiffe Street Moncreiffe Street Walsall Walsall NFA No Offence      
2474 op-snap---monthly-publication-august-2025.pdf   449 2025-08 Car BMW Unknown Black Contravening a Red Traffic Light None Rushall Road Rushall Road Walsall Walsall NFA No Independent Evidence Available   52.5946021 -1.9629845
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
2690 op-snap---monthly-publication-august-2025.pdf   665 2025-08 Car BMW 420I Grey Misc - Non Traffic Offences None Stubbers Green Stubbers Green Walsall Walsall NFA No Offence   52.6130612 -1.9384549
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
2773 op-snap---monthly-publication-august-2025.pdf   748 2025-08 Car Toyota Prius Grey Misc - Non Traffic Offences None High St Bloxwich High Street Bloxwich Walsall Walsall NFA No Offence   52.6124215 -2.0022243
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
2795 op-snap---monthly-publication-august-2025.pdf   770 2025-08 Car Ford Focus White Contravening a Red Traffic Light None Walsall Road Walsall Road Walsall Walsall NFA Outside of 14 Days NIP   52.6166864 -1.9660822
2837 op-snap---monthly-publication-august-2025.pdf   812 2025-08 Car Peugeot 208 Orange Contravening a Red Traffic Light None Walsall Road Walsall Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.6166864 -1.9660822
2842 op-snap---monthly-publication-august-2025.pdf   817 2025-08 Car Ford Fiesta Red Contravening a Red Traffic Light None Birmingham Road A34 Birmingham Road A34 Walsall Walsall NFA No Offence   52.5675146 -1.9513505
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      
2924 op-snap---monthly-publication-august-2025.pdf   899 2025-08 Car Toyota Corolla White Contravening a Red Traffic Light None Pleck Road / Moat Road Pleck Road / Moat Road Walsall Walsall NFA Outside of 14 Days NIP   52.5784558 -1.9998793
2925 op-snap---monthly-publication-august-2025.pdf   900 2025-08 Car Toyota Yaris Grey Contravening a Red Traffic Light None Pleck Road / Moat Road Pleck Road / Moat Road Walsall Walsall NFA Outside of 14 Days NIP   52.5784558 -1.9998793
2987 op-snap---monthly-publication-august-2025.pdf   962 2025-08 Car Vauxhall Corsa Red Contravening a Red Traffic Light None High Street, Moxley High Street, Moxley Walsall Walsall NFA No Independent Evidence Available   52.5605268 -2.0530129
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
3134 op-snap---monthly-publication-august-2025.pdf   1109 2025-08 Car Toyota   Grey Contravening a Red Traffic Light None Bosty Lane Bosty Lane Walsall Walsall NFA No Offence   52.5948329 -1.927787
3135 op-snap---monthly-publication-august-2025.pdf   1110 2025-08 Car     Blue Misc - Non Traffic Offences None Northgate Northgate Walsall Walsall NFA Not in Public Interest   52.6094474 -1.9202238
3155 op-snap---monthly-publication-august-2025.pdf   1130 2025-08 Car BMW 320 White Contravening a Red Traffic Light None Wolverhampton Road West Wolverhampton Road West Walsall Walsall NFA No Independent Evidence Available   52.5866889 -2.0354488
3728 op-snap---monthly-publication-august-2025.pdf   1703 2025-08 Car Mercedes-Benz C class Blue Misc - Non Traffic Offences None Springhill Road, Willenhall Springhill Road, Willenhall Walsall Walsall NFA Misc Inc Crimes      
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

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