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

316 rows where offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Other" 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

  • Other · 316 ✖

offence 1

  • Driving without Due Care and Attention · 316 ✖
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
7318 op-snap---monthly-publication-february-2026.pdf   65 2026-02 Other BMW 116 Silver Driving without Due Care and Attention None London Road Shrewsbury London Road Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
7387 op-snap---monthly-publication-february-2026.pdf   134 2026-02 Other Volkswagen Golf Blue Driving without Due Care and Attention None Star City Star City Birmingham Birmingham Other Action Taken N/A   52.5054363 -1.8556273
7575 op-snap---monthly-publication-february-2026.pdf   322 2026-02 Other Seat Alteca Grey Driving without Due Care and Attention None Orphange Road / Chester Road Orphange Road / Chester Road Birmingham Birmingham Education N/A      
7581 op-snap---monthly-publication-february-2026.pdf   328 2026-02 Other Jaguar u/k Blue Driving without Due Care and Attention None Long Bank Long Bank Out of Force Area Out of Force Area NFA Out of Force   52.5785967 -2.0581007
7626 op-snap---monthly-publication-february-2026.pdf   373 2026-02 Other Alfa Romeo Giulietta Blue Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
7646 op-snap---monthly-publication-february-2026.pdf   393 2026-02 Other Vauxhall Corsa Brown Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley NFA Not in Public Interest   52.4874281 -2.1117204
7656 op-snap---monthly-publication-february-2026.pdf   403 2026-02 Other Mini Cooper Silver Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Other Action Taken N/A   52.4874281 -2.1117204
7663 op-snap---monthly-publication-february-2026.pdf   410 2026-02 Other Vauxhall Corsa Grey Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley NFA No Offence   52.4874281 -2.1117204
7666 op-snap---monthly-publication-february-2026.pdf   413 2026-02 Other Volkswagen Polo Grey Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Warning Letter N/A   52.4874281 -2.1117204
7678 op-snap---monthly-publication-february-2026.pdf   425 2026-02 Other Jaguar XE Red Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Fixed Penalty N/A   52.4831397 -2.1309273
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
7736 op-snap---monthly-publication-february-2026.pdf   483 2026-02 Other Mercedes-Benz   Grey Driving without Due Care and Attention None London somewhere? This is from social media. London somewhere? This is from social media Out of Force Area Out of Force Area NFA Out of Force      
8253 op-snap---monthly-publication-february-2026.pdf   1000 2026-02 Other Nissan Note Black Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham RTC - Actioned N/A   52.5083238 -1.8332287
8352 op-snap---monthly-publication-february-2026.pdf   1099 2026-02 Other Fiat 500 White Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A      
8390 op-snap---monthly-publication-february-2026.pdf   1137 2026-02 Other Audi A3 Silver Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A      
8446 op-snap---monthly-publication-february-2026.pdf   1193 2026-02 Other Yamaha FZS 600 Blue Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A      
8483 op-snap---monthly-publication-february-2026.pdf   1230 2026-02 Other Volkswagen Lupo Green Driving without Due Care and Attention None Waterfront main car park Waterfront main car park Dudley Dudley Warning Letter N/A      
8484 op-snap---monthly-publication-february-2026.pdf   1231 2026-02 Other Seat Ibiza White Driving without Due Care and Attention None Waterfront Main Car Park Waterfront Main Car Park Dudley Dudley Warning Letter N/A      
8487 op-snap---monthly-publication-february-2026.pdf   1234 2026-02 Other Audi A3 Grey Driving without Due Care and Attention None High Street High Street Dudley Dudley Education N/A   52.4779764 -2.1598371
8488 op-snap---monthly-publication-february-2026.pdf   1235 2026-02 Other Nissan Qashqai Blue Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
8503 op-snap---monthly-publication-february-2026.pdf   1250 2026-02 Other BMW 335d Black Driving without Due Care and Attention No Insurance Showcase Cinema Showcase Cinema Dudley Dudley Court N/A   52.5169253 -2.070981
8593 op-snap---monthly-publication-february-2026.pdf   1340 2026-02 Other Nissan Navara Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
8658 op-snap---monthly-publication-february-2026.pdf   1405 2026-02 Other Ford Fiesta Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Education N/A      
8735 op-snap---monthly-publication-february-2026.pdf   1482 2026-02 Other Hyundai i10 Black Driving without Due Care and Attention None Star City Star City Birmingham Birmingham Warning Letter N/A   52.5054363 -1.8556273
8736 op-snap---monthly-publication-february-2026.pdf   1483 2026-02 Other   Proton Blue Driving without Due Care and Attention None Gervase Drive Gervase Drive Dudley Dudley Warning Letter N/A   52.5169749 -2.0827363
8737 op-snap---monthly-publication-february-2026.pdf   1484 2026-02 Other Volkswagen Taigo Black Driving without Due Care and Attention None Gervase Drive Gervase Drive Dudley Dudley Warning Letter N/A   52.5169749 -2.0827363
10552 op-snap---monthly-publication-january-2026.pdf   13 2026-01 Other Audi A5 Grey Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
10569 op-snap---monthly-publication-january-2026.pdf   30 2026-01 Other Seat Ibiza Red Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
10575 op-snap---monthly-publication-january-2026.pdf   36 2026-01 Other BMW NK White Driving without Due Care and Attention None Unknown   Dudley Dudley NFA No Independent Evidence Available      
10576 op-snap---monthly-publication-january-2026.pdf   37 2026-01 Other BMW 330E White Driving without Due Care and Attention No vehicle excise licence Tulip Avenue Tulip Avenue Dudley Dudley NFA No Independent Evidence Available      
10578 op-snap---monthly-publication-january-2026.pdf   39 2026-01 Other BMW 330E White Driving without Due Care and Attention No vehicle excise licence Tulip Avenue Tulip Avenue Dudley Dudley NFA No Independent Evidence Available      
10597 op-snap---monthly-publication-january-2026.pdf   58 2026-01 Other Land Rover 414.. Red Driving without Due Care and Attention None Waterfront main car park Waterfront main car park Dudley Dudley Warning Letter N/A      
10604 op-snap---monthly-publication-january-2026.pdf   65 2026-01 Other Audi Q7 Blue Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
10640 op-snap---monthly-publication-january-2026.pdf   101 2026-01 Other BMW 3 series blue Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10641 op-snap---monthly-publication-january-2026.pdf   102 2026-01 Other BMW 3 series black Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10652 op-snap---monthly-publication-january-2026.pdf   113 2026-01 Other Audi A3.. Grey Driving without Due Care and Attention None Star City Car Park Star City Car Park Birmingham Birmingham Warning Letter N/A      
10776 op-snap---monthly-publication-january-2026.pdf   237 2026-01 Other       Driving without Due Care and Attention None Broadmoor Road Broadmoor Road Sandwell Sandwell RTC - Actioned N/A      
10817 op-snap---monthly-publication-january-2026.pdf   278 2026-01 Other Volkswagen Amarok Black Driving without Due Care and Attention None Castlegate Way, Dudley Castlegate Way, Dudley Dudley Dudley Education N/A   52.5152644 -2.07245
10843 op-snap---monthly-publication-january-2026.pdf   304 2026-01 Other Ford Fiesta Blue Driving without Due Care and Attention None Dudley Cinema Dudley Cinema Dudley Dudley NFA No Independent Evidence Available      
10844 op-snap---monthly-publication-january-2026.pdf   305 2026-01 Other Volkswagen Golf White Driving without Due Care and Attention None Dudley Cinema Dudley Cinema Dudley Dudley NFA No Independent Evidence Available      
10847 op-snap---monthly-publication-january-2026.pdf   308 2026-01 Other Skoda Kodiaq White Driving without Due Care and Attention None Star City Star City Birmingham Birmingham NFA Misc Inc Crimes   52.5054363 -1.8556273
10980 op-snap---monthly-publication-january-2026.pdf   441 2026-01 Other   Unknown Black Driving without Due Care and Attention None Hydes Road Hydes Road Sandwell Sandwell NFA No VRM   52.5538064 -2.0139199
10986 op-snap---monthly-publication-january-2026.pdf   447 2026-01 Other Mercedes-Benz A Class Silver Driving without Due Care and Attention None A38 A38 Birmingham Birmingham NFA No Independent Evidence Available      
11022 op-snap---monthly-publication-january-2026.pdf   483 2026-01 Other Volkswagen Amarok Black Driving without Due Care and Attention None Castlegate Way Castlegate Way Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Duplicate Submission Duplicate Submission   52.5143403 -2.0723636
11023 op-snap---monthly-publication-january-2026.pdf   484 2026-01 Other Audi S3 Black Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
11024 op-snap---monthly-publication-january-2026.pdf   485 2026-01 Other Land Rover Range Rover Green Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
11025 op-snap---monthly-publication-january-2026.pdf   486 2026-01 Other Land Rover Defender Red Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
11026 op-snap---monthly-publication-january-2026.pdf   487 2026-01 Other Land Rover Range Rover Black Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
11028 op-snap---monthly-publication-january-2026.pdf   489 2026-01 Other Suzuki Vitara Blue Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
11035 op-snap---monthly-publication-january-2026.pdf   496 2026-01 Other Mercedes-Benz sprinter White Driving without Due Care and Attention None Arden Road Arden Road Birmingham Birmingham Fixed Penalty N/A   52.4515759 -1.8296192
11147 op-snap---monthly-publication-january-2026.pdf   608 2026-01 Other Volkswagen Golf Grey Driving without Due Care and Attention None Dry Thistle Close (West Mercia) Dry Thistle Close (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
11241 op-snap---monthly-publication-january-2026.pdf   702 2026-01 Other Vauxhall Astra Silver Driving without Due Care and Attention None Waterfront main car park Waterfront main car park Dudley Dudley Warning Letter N/A      
11265 op-snap---monthly-publication-january-2026.pdf   726 2026-01 Other BMW 318d Grey Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
11266 op-snap---monthly-publication-january-2026.pdf   727 2026-01 Other BMW 323i White Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
11295 op-snap---monthly-publication-january-2026.pdf   756 2026-01 Other Volkswagen Golf Black Driving without Due Care and Attention None George Street George Street Birmingham Birmingham Court N/A   52.5048075 -1.9545728
11387 op-snap---monthly-publication-january-2026.pdf   848 2026-01 Other Fiat DOBLO Grey Driving without Due Care and Attention None Miall Park Road Miall Park Road Solihull Solihull Education N/A   52.4214617 -1.8086577
11398 op-snap---monthly-publication-january-2026.pdf   859 2026-01 Other BMW Z4 Blue Driving without Due Care and Attention No Insurance Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
11408 op-snap---monthly-publication-january-2026.pdf   869 2026-01 Other Volkswagen T Roc Black Driving without Due Care and Attention None Lysander Road Lysander Road Birmingham Birmingham NFA No Offence   52.4066385 -2.0128329
11412 op-snap---monthly-publication-january-2026.pdf   873 2026-01 Other   Off road bikes Black Driving without Due Care and Attention None Dudley Wood Road Dudley Wood Road Dudley Dudley NFA No VRM   52.4776953 -2.0859444
11413 op-snap---monthly-publication-january-2026.pdf   874 2026-01 Other Skoda Octavia Grey Driving without Due Care and Attention None Willenhall Road Willenhall Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.5836778 -2.0894997
11438 op-snap---monthly-publication-january-2026.pdf   899 2026-01 Other Ford Fiesta Black Driving without Due Care and Attention None Waterfront Carpark 7 Waterfront Carpark 7 Dudley Dudley Warning Letter N/A      
11440 op-snap---monthly-publication-january-2026.pdf   901 2026-01 Other Renault Clio Blue Driving without Due Care and Attention None Waterfront Carpark 7 Waterfront Carpark 7 Dudley Dudley Warning Letter N/A      
11454 op-snap---monthly-publication-january-2026.pdf   915 2026-01 Other Jaecoo 7 Luxury Silver Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
11467 op-snap---monthly-publication-january-2026.pdf   928 2026-01 Other Vauxhall CORSA Silver Driving without Due Care and Attention None Saltwells Road Saltwells Road Dudley Dudley RTC - Actioned N/A   52.4828169 -2.0775182
11621 op-snap---monthly-publication-january-2026.pdf   1082 2026-01 Other Vauxhall Astra White Driving without Due Care and Attention None Main car park dudley Main car park dudley Dudley Dudley Warning Letter N/A   52.4799731 -2.0985927
11630 op-snap---monthly-publication-january-2026.pdf   1091 2026-01 Other Mini cooper Silver Driving without Due Care and Attention Contravening a Red Traffic Light Church St towards Wolverhampton Road Church Street towards Wolverhampton Road Wolverhampton Wolverhampton Fixed Penalty N/A      
4026 op-snap---monthly-publication-december-2025.pdf   154 2025-12 Other Renault Clio Blue Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4035 op-snap---monthly-publication-december-2025.pdf   163 2025-12 Other Vauxhall Vivaro White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4062 op-snap---monthly-publication-december-2025.pdf   190 2025-12 Other Audi A5 Black Driving without Due Care and Attention None Gopsal Street Gopsal Street Birmingham Birmingham Court N/A   52.4837913 -1.8822888
4064 op-snap---monthly-publication-december-2025.pdf   192 2025-12 Other Volkswagen Caddy White Driving without Due Care and Attention None Gravelly HIll Gravelly HIll Birmingham Birmingham NFA No Independent Evidence Available   52.5153884 -1.8527437
4075 op-snap---monthly-publication-december-2025.pdf   203 2025-12 Other Fiat 500 Beige Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4179 op-snap---monthly-publication-december-2025.pdf   307 2025-12 Other BMW 330E White Driving without Due Care and Attention None Metchley Lane Metchley Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4552055 -1.9461279
4409 op-snap---monthly-publication-december-2025.pdf   537 2025-12 Other BMW 335D Black Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley NFA No Independent Evidence Available   52.4874281 -2.1117204
4482 op-snap---monthly-publication-december-2025.pdf   610 2025-12 Other Vauxhall Astra Silver Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley NFA No Independent Evidence Available      
4815 op-snap---monthly-publication-december-2025.pdf   943 2025-12 Other Audi SQ7 Grey Driving without Due Care and Attention None Greens End Road Greens End Road Coventry Coventry NFA Out of Force      
4835 op-snap---monthly-publication-december-2025.pdf   963 2025-12 Other Volkswagen Crafter Silver Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
4862 op-snap---monthly-publication-december-2025.pdf   990 2025-12 Other Jaguar XJ Blue Driving without Due Care and Attention None Waterfront main Car Park. Waterfront main Car Park Dudley Dudley Other Action Taken Misc Inc Crimes      
4912 op-snap---monthly-publication-december-2025.pdf   1040 2025-12 Other Mercedes-Benz C-class Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A      
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
4982 op-snap---monthly-publication-december-2025.pdf   1110 2025-12 Other Audi A3 White Driving without Due Care and Attention No Insurance Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
20463 op-snap---monthly-publication-november-2025.pdf   5 2025-11 Other Audi RS3 Black Driving without Due Care and Attention No Insurance Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
20476 op-snap---monthly-publication-november-2025.pdf   18 2025-11 Other BMW 225d White Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Court N/A      
20505 op-snap---monthly-publication-november-2025.pdf   47 2025-11 Other Vauxhall Corsa Red Driving without Due Care and Attention None Waterfront Main Car Park Waterfront Main Car Park Dudley Dudley Court N/A      
20510 op-snap---monthly-publication-november-2025.pdf   52 2025-11 Other Fiat Punto White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
20515 op-snap---monthly-publication-november-2025.pdf   57 2025-11 Other Audi   Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
20564 op-snap---monthly-publication-november-2025.pdf   106 2025-11 Other Volkswagen Tiago Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
20581 op-snap---monthly-publication-november-2025.pdf   123 2025-11 Other Volkswagen Golf Black Driving without Due Care and Attention None Gooch Street Gooch Street Coventry Coventry NFA No Independent Evidence Available      
20595 op-snap---monthly-publication-november-2025.pdf   137 2025-11 Other Ford Transit White Driving without Due Care and Attention No vehicle excise licence Norwood Road Norwood Road Dudley Dudley Court N/A   52.4831397 -2.1309273
20598 op-snap---monthly-publication-november-2025.pdf   140 2025-11 Other Ford Transit Black Driving without Due Care and Attention None The Deers Leap The Deers Leap Birmingham Birmingham Court N/A   52.5601871 -1.8928907
20655 op-snap---monthly-publication-november-2025.pdf   197 2025-11 Other   Unknown   Driving without Due Care and Attention None Unknown       NFA No VRM      
20712 op-snap---monthly-publication-november-2025.pdf   254 2025-11 Other Vauxhall Corsa White Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
20714 op-snap---monthly-publication-november-2025.pdf   256 2025-11 Other Hyundai I10 Beige Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Court N/A      
20715 op-snap---monthly-publication-november-2025.pdf   257 2025-11 Other Jaguar   Blue Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Court N/A      
20717 op-snap---monthly-publication-november-2025.pdf   259 2025-11 Other Nissan Micra Blue Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
20813 op-snap---monthly-publication-november-2025.pdf   355 2025-11 Other Fiat 500 White Driving without Due Care and Attention None Oldbury Road Oldbury Road Sandwell Sandwell NFA No Independent Evidence Available   52.5018196 -1.9811249
21276 op-snap---monthly-publication-november-2025.pdf   818 2025-11 Other Vauxhall Corsa White Driving without Due Care and Attention No Insurance Waterfront Waterfront Dudley Dudley Court N/A   52.4874281 -2.1117204
21277 op-snap---monthly-publication-november-2025.pdf   819 2025-11 Other Volkswagen Polo White Driving without Due Care and Attention None Merry Hill Centre Merry Hill Centre Dudley Dudley Fixed Penalty N/A   52.4796946 -2.1113792
21296 op-snap---monthly-publication-november-2025.pdf   838 2025-11 Other Vauxhall Corsa Yellow Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
21299 op-snap---monthly-publication-november-2025.pdf   841 2025-11 Other Toyota Aygo blue Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park 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);