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

108 rows where council_area = "Walsall" and month = "2025-04" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, nfa_rationale

reporter_transport_mode 5

month 1

  • 2025-04 · 108 ✖

council_area 1

  • Walsall · 108 ✖
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
48 op-snap---monthly-publication-april-2025.pdf   47 2025-04 Car Peugeot 206 Blue Contravening a Red Traffic Light None Walters Road Walters Road Walsall Walsall Other Action Taken N/A      
49 op-snap---monthly-publication-april-2025.pdf   48 2025-04 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Straight Road Straight Road Walsall Walsall Warning Letter N/A   52.6034813 -2.038059
58 op-snap---monthly-publication-april-2025.pdf   57 2025-04 Pedestrian   NP   Dangerous Driving None Pelsall High Street Pelsall High Street Walsall Walsall NFA No Independent Evidence Available   52.628914 -1.9675162
103 op-snap---monthly-publication-april-2025.pdf   102 2025-04 Pedestrian Porsche Macan Silver Contravening a Red Traffic Light None Littleton St Littleton Street Walsall Walsall Education N/A   52.5885092 -1.9817997
104 op-snap---monthly-publication-april-2025.pdf   103 2025-04 Pedestrian Kia Sedona Red Contravening a Red Traffic Light None Littleton St Littleton Street Walsall Walsall Education N/A   52.5885092 -1.9817997
105 op-snap---monthly-publication-april-2025.pdf   104 2025-04 Pedestrian Toyota Yaris Blue Contravening a Red Traffic Light None Littleton St Littleton Street Walsall Walsall NFA No VRM   52.5885092 -1.9817997
111 op-snap---monthly-publication-april-2025.pdf   110 2025-04 Car Nissan Qashqai Black Driving without Due Care and Attention None Broadway Broadway Walsall Walsall Warning Letter N/A   52.5719937 -1.9639882
129 op-snap---monthly-publication-april-2025.pdf   128 2025-04 Car   KTM Duke 390 White Driving without Due Care and Attention None Elmore Road Elmore Road Walsall Walsall Court N/A   52.6178185 -2.0093512
131 op-snap---monthly-publication-april-2025.pdf   130 2025-04 Car Peugeot 3008.. Red Contravening a Red Traffic Light None Walstead Road Walstead Road Walsall Walsall Fixed Penalty N/A   52.5648629 -1.9517624
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
163 op-snap---monthly-publication-april-2025.pdf   162 2025-04 Car Ford KUGA Grey Contravening a Red Traffic Light None SUN ISLAND BROWNHILLS Sun Island Brownhills Walsall Walsall Warning Letter N/A      
173 op-snap---monthly-publication-april-2025.pdf   172 2025-04 Car Mercedes-Benz A CLASS White Contravening a Red Traffic Light None BENTLEY MILL WAY Bentley Mill Way Walsall Walsall Fixed Penalty N/A   52.5786876 -2.0165115
175 op-snap---monthly-publication-april-2025.pdf   174 2025-04 Car BMW 320i White Contravening a Red Traffic Light None TOWNEND STREET Townend Street Walsall Walsall Fixed Penalty N/A   52.5863213 -1.9852108
346 op-snap---monthly-publication-april-2025.pdf   345 2025-04 Pedestrian Fiat 500L Red Misc - Non Traffic Offences None Littleton Street West, Littleton Street West Walsall Walsall NFA No Independent Evidence Available   52.588379 -1.9843635
347 op-snap---monthly-publication-april-2025.pdf   346 2025-04 Pedestrian Audi Q5 Blue Misc - Non Traffic Offences None Littleton Street West, Littleton Street West Walsall Walsall NFA No Independent Evidence Available   52.588379 -1.9843635
351 op-snap---monthly-publication-april-2025.pdf   350 2025-04 Pedestrian Yamaha Taxi Black Using a Mobile Phone Whilst Driving None Lichfield Street Lichfield Street Walsall Walsall Fixed Penalty N/A   52.5882772 -1.9761264
352 op-snap---monthly-publication-april-2025.pdf   351 2025-04 Car Peugeot 3008 White Contravening a Red Traffic Light None Wednesbury Interchange Wednesbury Interchange Walsall Walsall Education N/A   52.5667977 -2.0037424
356 op-snap---monthly-publication-april-2025.pdf   355 2025-04 Pedestrian Renault Kadjar Red Misc - Non Traffic Offences None Littleton Street West, Littleton Street West Walsall Walsall NFA No Independent Evidence Available   52.588379 -1.9843635
359 op-snap---monthly-publication-april-2025.pdf   358 2025-04 Pedestrian Mercedes-Benz GLA 200 Silver Contravening a Red Traffic Light None Littleton Street West Littleton Street West Walsall Walsall NFA Outside of 14 Days NIP   52.588379 -1.9843635
360 op-snap---monthly-publication-april-2025.pdf   359 2025-04 Pedestrian Audi A3 Black Contravening a Red Traffic Light None Littleton Street West Littleton Street West Walsall Walsall NFA Outside of 14 Days NIP   52.588379 -1.9843635
365 op-snap---monthly-publication-april-2025.pdf   364 2025-04 Pedestrian Audi TT.. Silver Contravening a Red Traffic Light None Littleton Street West Littleton Street West Walsall Walsall NFA Outside of 14 Days NIP   52.588379 -1.9843635
411 op-snap---monthly-publication-april-2025.pdf   410 2025-04 Car Ford Puma Silver Stop a vehicle on pedestrian crossing None Wednesbury Rd Wednesbury Road Walsall Walsall Education N/A   52.5738499 -1.9961575
415 op-snap---monthly-publication-april-2025.pdf   414 2025-04 Car Volkswagen Crafter White Stop a vehicle within pelican pedestrian crossing limits None Wednesbury Road Wednesbury Road Walsall Walsall Warning Letter N/A   52.5738499 -1.9961575
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
459 op-snap---monthly-publication-april-2025.pdf   458 2025-04 Pedestrian Vauxhall COMBO White Contravening a Red Traffic Light None DAW END LANE Daw End Lane Walsall Walsall NFA Outside of 14 Days NIP   52.6068849 -1.9611652
479 op-snap---monthly-publication-april-2025.pdf   478 2025-04 Car Mercedes-Benz C220 Black Contravening a Red Traffic Light None Corporation St Corporation Street Walsall Walsall NFA Outside of 14 Days NIP   52.5773099 -1.9850716
492 op-snap---monthly-publication-april-2025.pdf   491 2025-04 Car Ford Focus Blue Contravening a Red Traffic Light None Littleton St East Littleton Street East Walsall Walsall Warning Letter N/A   52.5887823 -1.9801166
528 op-snap---monthly-publication-april-2025.pdf   527 2025-04 Car       Contravening a Red Traffic Light None M6 NORTH M6 North Walsall Walsall NFA No Independent Evidence Available   52.5859649 -1.9897914
620 op-snap---monthly-publication-april-2025.pdf   619 2025-04 Lorry Vauxhall Corsa Black Contravene Lane Closure Red X None Oxford Street Oxford Street Walsall Walsall NFA Outside of 14 Days NIP   52.5740295 -1.99768
626 op-snap---monthly-publication-april-2025.pdf   625 2025-04 Car BMW 3 Seris Blue Contravening a Red Traffic Light None Broadway North Broadway North Walsall Walsall Warning Letter N/A   52.5886007 -1.9741222
636 op-snap---monthly-publication-april-2025.pdf   635 2025-04 Car Nissan Juke Black Contravening a Red Traffic Light None Bentley Lane Bentley Lane Walsall Walsall NFA Outside of 14 Days NIP   52.5944332 -2.0119525
643 op-snap---monthly-publication-april-2025.pdf   642 2025-04 Car Volkswagen Polo Grey Contravening a Red Traffic Light None Walstead Road Walstead Road Walsall Walsall NFA Outside of 14 Days NIP   52.5648629 -1.9517624
648 op-snap---monthly-publication-april-2025.pdf   647 2025-04 Car Volkswagen ID4 Grey Driving without Reasonable Consideration None Wodne Road East Wodne Road East Walsall Walsall Warning Letter N/A      
703 op-snap---monthly-publication-april-2025.pdf   702 2025-04 Car Ford Focus Blue Contravening a Red Traffic Light None Bescot Road Bescot Road Walsall Walsall NFA No Independent Evidence Available   52.5707373 -2.0014215
725 op-snap---monthly-publication-april-2025.pdf   724 2025-04 Car Toyota Corolla Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Croft Street Croft Street Walsall Walsall Warning Letter N/A   52.5929393 -1.9884291
726 op-snap---monthly-publication-april-2025.pdf   725 2025-04 Car   London Taxi Black Stop a vehicle on pedestrian crossing None Churchill Road Churchill Road Walsall Walsall Education N/A   52.5887964 -2.0253617
728 op-snap---monthly-publication-april-2025.pdf   727 2025-04 Car Audi A3 White Contravene Lane Closure Red X None Townend Street Townend Street Walsall Walsall Fixed Penalty N/A   52.5863213 -1.9852108
730 op-snap---monthly-publication-april-2025.pdf   729 2025-04 Car Skoda Fabia Green Cause vehicle to be left in a dangerous position None Croft Street Croft Street Walsall Walsall Fixed Penalty N/A   52.5929393 -1.9884291
758 op-snap---monthly-publication-april-2025.pdf   757 2025-04 Pedal Bike Volkswagen Polo White Driving without Reasonable Consideration None Sutton Road Sutton Road Walsall Walsall Education N/A   52.5612988 -2.0522715
763 op-snap---monthly-publication-april-2025.pdf   762 2025-04 Pedal Bike Hyundai Tucson White Using a Mobile Phone Whilst Driving None Lichfield Road Lichfield Road Walsall Walsall Fixed Penalty N/A   52.6095168 -2.0493009
803 op-snap---monthly-publication-april-2025.pdf   802 2025-04 Pedestrian Vauxhall Astra White Contravening a Red Traffic Light None Daw End Lane Walsall Daw End Lane Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6070366 -1.96132
806 op-snap---monthly-publication-april-2025.pdf   805 2025-04 Pedestrian Peugeot 308.. Blue Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall NFA Outside of 14 Days NIP   52.6068849 -1.9611652
814 op-snap---monthly-publication-april-2025.pdf   813 2025-04 Car Renault Kadjar Grey Drive a vehicle other than on the carriageway of a motorway None M6 Jct 7 M6 Junction 7 Walsall Walsall NFA Outside of 14 Days NIP   52.676119 -2.0858425
847 op-snap---monthly-publication-april-2025.pdf   846 2025-04 Pedestrian Mercedes-Benz Benz Red Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
849 op-snap---monthly-publication-april-2025.pdf   848 2025-04 Car Toyota   Black Driving without Reasonable Consideration None Lichfield Road , Walsall Lichfield Road , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6099659 -2.0445263
886 op-snap---monthly-publication-april-2025.pdf   885 2025-04 Car   Lorry Black Driving without Reasonable Consideration None A4148 , Walsall A4148 , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5886101 -1.9749676
892 op-snap---monthly-publication-april-2025.pdf   891 2025-04 Car Toyota   White Driving without Reasonable Consideration None Wednesbury Road , Walsall Wednesbury Road , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5788509 -1.986315
965 op-snap---monthly-publication-april-2025.pdf   964 2025-04 Car Ford Transit Silver Driving without Reasonable Consideration None Rocky Lane , Walsall Rocky Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5293579 -1.9102272
969 op-snap---monthly-publication-april-2025.pdf   968 2025-04 Car Mercedes-Benz   White Driving without Reasonable Consideration None A34 towards Walsall A34 towards Walsall Walsall Walsall NFA Outside of 14 Days NIP      
973 op-snap---monthly-publication-april-2025.pdf   972 2025-04 Car Volkswagen Polo Grey Driving without Reasonable Consideration None B4154 Norton Road , Pelsall Norton Road , Pelsall Walsall Walsall NFA Outside of 14 Days NIP   52.6337623 -1.9674818
998 op-snap---monthly-publication-april-2025.pdf   997 2025-04 Car Citroen Cactus Grey Driving without Reasonable Consideration None The old railway track back of Poplar Ave , Bentley The old railway track back of Poplar Ave , Bentley Walsall Walsall NFA Outside of 14 Days NIP      
999 op-snap---monthly-publication-april-2025.pdf   998 2025-04 Car   Motorbike Green Driving without Reasonable Consideration None Walsall Area Walsall Area Walsall Walsall NFA Outside of 14 Days NIP      
1027 op-snap---monthly-publication-april-2025.pdf   1026 2025-04 Car Toyota   Grey Using a Mobile Phone Whilst Driving None Bentley Lane , Walsall Bentley Lane , Walsall Walsall Walsall NFA No Independent Evidence Available   52.5922567 -2.0105392
1047 op-snap---monthly-publication-april-2025.pdf   1046 2025-04 Car Hyundai   Brown Driving without Reasonable Consideration None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1049 op-snap---monthly-publication-april-2025.pdf   1048 2025-04 Pedestrian Renault   Red Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1050 op-snap---monthly-publication-april-2025.pdf   1049 2025-04 Pedestrian Volkswagen   Blue Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1051 op-snap---monthly-publication-april-2025.pdf   1050 2025-04 Pedal Bike Ford Van White Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1057 op-snap---monthly-publication-april-2025.pdf   1056 2025-04 Pedestrian Honda Motorbike Silver Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1058 op-snap---monthly-publication-april-2025.pdf   1057 2025-04 Car Seat Ibiza Blue Cause vehicle to be left in a dangerous position None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1064 op-snap---monthly-publication-april-2025.pdf   1063 2025-04 Pedal Bike Suzuki   Black Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1070 op-snap---monthly-publication-april-2025.pdf   1069 2025-04 Car Citroen   White Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1078 op-snap---monthly-publication-april-2025.pdf   1077 2025-04 Car Daf truck White Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1120 op-snap---monthly-publication-april-2025.pdf   1119 2025-04 Car Land Rover   Black Contravening a Red Traffic Light None Middlemore Lane , Walsall Middlemore Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6046656 -1.9262024
1125 op-snap---monthly-publication-april-2025.pdf   1124 2025-04 Car Toyota   Grey Contravening a Red Traffic Light None Middle more Lane , Walsall Middle more Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP      
1131 op-snap---monthly-publication-april-2025.pdf   1130 2025-04 Car Kia   Grey Contravening a Red Traffic Light None Bosty Lane , Walsall Bosty Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5973696 -1.9377903
1171 op-snap---monthly-publication-april-2025.pdf   1170 2025-04 Car   Box Van White & Orange Contravening a Red Traffic Light None A452 towards Aldridge A452 towards Aldridge Walsall Walsall NFA Outside of 14 Days NIP      
1189 op-snap---monthly-publication-april-2025.pdf   1188 2025-04 Car Peugeot 3008 Black Driving without Reasonable Consideration None Bloxwich from leamore direction Bloxwich from leamore direction Walsall Walsall NFA Outside of 14 Days NIP      
1227 op-snap---monthly-publication-april-2025.pdf   1226 2025-04 Car Ford Focus Black Driving without Reasonable Consideration None Bloxwich Lane , Beechdale Bloxwich Lane , Beechdale Walsall Walsall NFA Outside of 14 Days NIP      
1266 op-snap---monthly-publication-april-2025.pdf   1265 2025-04 Car Mercedes-Benz Van White Cause vehicle to be left in a dangerous position None A452 High Street , Brownhills High Street , Brownhills Walsall Walsall NFA Outside of 14 Days NIP   52.6252131 -1.9338823
1308 op-snap---monthly-publication-april-2025.pdf   1307 2025-04 Car BMW NP Beige Using a Mobile Phone Whilst Driving None Erdington road , streetly Erdington road , streetly Walsall Walsall NFA No Offence   52.5821369 -1.9060837
1340 op-snap---monthly-publication-april-2025.pdf   1339 2025-04 Car Nissan Note Silver Contravening a Red Traffic Light None Walsall Road , Walsall Walsall Road , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5747831 -2.0180075
1483 op-snap---monthly-publication-april-2025.pdf   1482 2025-04 Car Nissan Navara Grey Driving without Reasonable Consideration None A4148 Walsall to Wolverhampton Walsall to Wolverhampton Walsall Walsall NFA Outside of 14 Days NIP   52.629207 -1.9300274
1530 op-snap---monthly-publication-april-2025.pdf   1529 2025-04 Car Vauxhall Crossland Grey Driving without Reasonable Consideration None Green Lane , Bloxwich Green Lane , Bloxwich Walsall Walsall NFA Outside of 14 Days NIP   52.5882453 -1.9871426
1532 op-snap---monthly-publication-april-2025.pdf   1531 2025-04 Pedestrian BMW NP Black Stop a vehicle within pelican pedestrian crossing limits None Walstead Road , Walsall Walstead Road , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5648629 -1.9517624
1566 op-snap---monthly-publication-april-2025.pdf   1565 2025-04 Pedal Bike Volkswagen Polo Black Using a Mobile Phone Whilst Driving None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA No Independent Evidence Available   52.6069179 -1.9610677
1569 op-snap---monthly-publication-april-2025.pdf   1568 2025-04 Pedal Bike Volkswagen NP Silver No Seat Belt None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
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
1597 op-snap---monthly-publication-april-2025.pdf   1596 2025-04 Car Land Rover NP Black Contravening a Red Traffic Light None A4148 Junction of stafford street walsall Junction of stafford street walsall Walsall Walsall NFA Outside of 14 Days NIP      
1631 op-snap---monthly-publication-april-2025.pdf   1630 2025-04 Car Ford Ranger White Drive on hard shoulder None M6 between Juction 8 and Junction 9 M6 between Juction 8 and Junction 9 Walsall Walsall NFA Outside of 14 Days NIP      
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
1672 op-snap---monthly-publication-april-2025.pdf   1671 2025-04 Car Tesla NP White Contravening a Red Traffic Light None Daw end lane , Rushall Daw end lane , Rushall Walsall Walsall NFA Outside of 14 Days NIP   52.6070366 -1.96132
1673 op-snap---monthly-publication-april-2025.pdf   1672 2025-04 Car   Pick up Red Contravening a Red Traffic Light None Daw end Lane , Rushall Daw end Lane , Rushall Walsall Walsall NFA Outside of 14 Days NIP   52.6070366 -1.96132
1744 op-snap---monthly-publication-april-2025.pdf   1743 2025-04 Pedestrian Ford NP White Driving without Reasonable Consideration None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1745 op-snap---monthly-publication-april-2025.pdf   1744 2025-04 Pedestrian Audi NP Grey Contravening a Red Traffic Light None Daw end Lane , Walsall Daw end Lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1746 op-snap---monthly-publication-april-2025.pdf   1745 2025-04 Pedestrian Nissan NP Blue Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1747 op-snap---monthly-publication-april-2025.pdf   1746 2025-04 Pedestrian   NP White Contravening a Red Traffic Light None Daw end lane , Walsall Daw end lane , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.6069179 -1.9610677
1748 op-snap---monthly-publication-april-2025.pdf   1747 2025-04 Car Audi NP Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cannon Hill Park Cannon Hill Park Walsall Walsall NFA Outside of 14 Days NIP      
1763 op-snap---monthly-publication-april-2025.pdf   1762 2025-04 Car Land Rover NP White Using a Mobile Phone Whilst Driving None Northgate , Aldridge Northgate , Aldridge Walsall Walsall NFA No VRM   52.6094474 -1.9202238
1773 op-snap---monthly-publication-april-2025.pdf   1772 2025-04 Pedal Bike Ford NP Red Contravening a Red Traffic Light None Littleton street Littleton street Walsall Walsall NFA Outside of 14 Days NIP   52.5885092 -1.9817997
1774 op-snap---monthly-publication-april-2025.pdf   1773 2025-04 Pedal Bike   NP White Contravening a Red Traffic Light None Littleton street Littleton street Walsall Walsall NFA Outside of 14 Days NIP   52.5885092 -1.9817997
1775 op-snap---monthly-publication-april-2025.pdf   1774 2025-04 Pedal Bike   NP Red Contravening a Red Traffic Light None Litleton street west Litleton street west Walsall Walsall NFA Outside of 14 Days NIP      
1776 op-snap---monthly-publication-april-2025.pdf   1775 2025-04 Pedal Bike Honda NP Blue Contravening a Red Traffic Light None Littleton Street West Littleton Street West Walsall Walsall NFA Outside of 14 Days NIP   52.588379 -1.9843635
1777 op-snap---monthly-publication-april-2025.pdf   1776 2025-04 Pedal Bike   NP Grey Contravening a Red Traffic Light None Close to Walsall Arboretum Close to Walsall Arboretum Walsall Walsall NFA Outside of 14 Days NIP      
1778 op-snap---monthly-publication-april-2025.pdf   1777 2025-04 Pedal Bike   NP White Contravening a Red Traffic Light None Close to Walsall Arboretum Close to Walsall Arboretum Walsall Walsall NFA Outside of 14 Days NIP      
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
1816 op-snap---monthly-publication-april-2025.pdf   1815 2025-04 Car Seat NP White Contravening a Red Traffic Light None Beacon Road , Walsall Beacon Road , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.553832 -1.9097815
1867 op-snap---monthly-publication-april-2025.pdf   1866 2025-04 Other Vauxhall Corsa Red Misc - Non Traffic Offences None Canalside close Canalside close Walsall Walsall NFA Outside of 14 Days NIP   52.616402 -1.9786826
1901 op-snap---monthly-publication-april-2025.pdf   1900 2025-04 Pedal Bike Nissan NP White Contravening a Red Traffic Light None Lichfield Street , Walsall Lichfield Street , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5854972 -1.9792935

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