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

79 rows where disposal = "Warning Letter", month = "2025-11" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, council_area_raw

reporter_transport_mode 5

offence 1

  • Driving without Due Care and Attention · 79 ✖

month 1

  • 2025-11 · 79 ✖

disposal 1

  • Warning Letter · 79 ✖
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
20494 op-snap---monthly-publication-november-2025.pdf   36 2025-11 Car Volkswagen Golf Blue Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
20531 op-snap---monthly-publication-november-2025.pdf   73 2025-11 Car Audi A3 Black Driving without Due Care and Attention None B4101 Coventry City Centre Coventry City Centre Coventry Coventry Warning Letter N/A   52.4146776 -1.5056904
20532 op-snap---monthly-publication-november-2025.pdf   74 2025-11 Car Ford Transit White Driving without Due Care and Attention None Warren Farm Road Warren Farm Road Birmingham Birmingham Warning Letter N/A   52.5424846 -1.8794625
20534 op-snap---monthly-publication-november-2025.pdf   76 2025-11 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Longdales Road Longdales Road Birmingham Birmingham Warning Letter N/A   52.3947881 -1.9285109
20539 op-snap---monthly-publication-november-2025.pdf   81 2025-11 Car Ford Mondeo Silver Driving without Due Care and Attention None Edgbaston Road Edgbaston Road Birmingham Birmingham Warning Letter N/A   52.4552785 -1.906384
20544 op-snap---monthly-publication-november-2025.pdf   86 2025-11 Car Mercedes-Benz GLC Blue Driving without Due Care and Attention None Wigston Road, Hinkley Road Roundabout Wigston Road, Hinkley Road Roundabout Coventry Coventry Warning Letter N/A      
20548 op-snap---monthly-publication-november-2025.pdf   90 2025-11 Car Audi A5 Red Driving without Due Care and Attention None Bromford Road Bromford Road Birmingham Birmingham Warning Letter N/A   52.503036 -1.8289972
20556 op-snap---monthly-publication-november-2025.pdf   98 2025-11 Car BMW 320.. Blue Driving without Due Care and Attention None M5 Northbound... ? M5 Northbound. ? Birmingham Birmingham Warning Letter N/A      
20561 op-snap---monthly-publication-november-2025.pdf   103 2025-11 Pedal Bike Toyota Yaris Red Driving without Due Care and Attention None Witherford Way Witherford Way Birmingham Birmingham Warning Letter N/A   52.4346604 -1.9538812
20574 op-snap---monthly-publication-november-2025.pdf   116 2025-11 Car Mercedes-Benz CLA 200 Silver Driving without Due Care and Attention None Jimmy HIll Way Jimmy HIll Way Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
20596 op-snap---monthly-publication-november-2025.pdf   138 2025-11 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham Warning Letter N/A   52.5170745 -1.9012542
20597 op-snap---monthly-publication-november-2025.pdf   139 2025-11 Car Mazda Sprinter White Driving without Due Care and Attention None Questett Road Questett Road Birmingham Birmingham Warning Letter N/A      
20599 op-snap---monthly-publication-november-2025.pdf   141 2025-11 Car Ford Transit White Driving without Due Care and Attention None Newbury Road Newbury Road Birmingham Birmingham Warning Letter N/A   52.4993019 -1.8964495
20600 op-snap---monthly-publication-november-2025.pdf   142 2025-11 Car Vauxhall Astra Blue Driving without Due Care and Attention None Sedgley Road Sedgley Road Sandwell Sandwell Warning Letter N/A   52.5219813 -2.0581691
20604 op-snap---monthly-publication-november-2025.pdf   146 2025-11 Car Audi A4 Black Driving without Due Care and Attention None Bognob Road Bognob Road Wolverhampton Wolverhampton Warning Letter N/A      
20646 op-snap---monthly-publication-november-2025.pdf   188 2025-11 Car Nissan Juke Red Driving without Due Care and Attention None Garrison Circus Garrison Circus Birmingham Birmingham Warning Letter N/A   52.4794658 -1.8762374
20662 op-snap---monthly-publication-november-2025.pdf   204 2025-11 Car Volkswagen Taigo Grey Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
20663 op-snap---monthly-publication-november-2025.pdf   205 2025-11 Pedal Bike Mercedes-Benz Tractor White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
20665 op-snap---monthly-publication-november-2025.pdf   207 2025-11 Pedal Bike Peugeot 308 Active Black Driving without Due Care and Attention None Blackwood Road Blackwood Road Birmingham Birmingham Warning Letter N/A   52.5529452 -1.909824
20705 op-snap---monthly-publication-november-2025.pdf   247 2025-11 Car Porsche Taycan Purple Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
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      
20719 op-snap---monthly-publication-november-2025.pdf   261 2025-11 Car Land Rover Range Rover Black Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
20729 op-snap---monthly-publication-november-2025.pdf   271 2025-11 Car Seat Leon Blue Driving without Due Care and Attention None a45 A45 Birmingham Birmingham Warning Letter N/A      
20733 op-snap---monthly-publication-november-2025.pdf   275 2025-11 Car Vauxhall Agila Red Driving without Due Care and Attention None Robbin Wood Lane Robbin Wood Lane Birmingham Birmingham Warning Letter N/A      
20741 op-snap---monthly-publication-november-2025.pdf   283 2025-11 Car Seat Leon Silver Driving without Due Care and Attention None New Birmingham Road New Birmingham Road Sandwell Sandwell Warning Letter N/A   52.5113475 -2.0508304
20748 op-snap---monthly-publication-november-2025.pdf   290 2025-11 Lorry Mercedes-Benz ML250 Silver Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A      
20764 op-snap---monthly-publication-november-2025.pdf   306 2025-11 Car BMW 335i Blue Driving without Due Care and Attention None Hockley Circus Hockley Circus Birmingham Birmingham Warning Letter N/A   52.4952382 -1.9146705
20765 op-snap---monthly-publication-november-2025.pdf   307 2025-11 Pedal Bike Peugeot 3008 GT Brown Driving without Due Care and Attention None Widney Road Widney Road Solihull Solihull Warning Letter N/A   52.3795667 -1.7478958
20771 op-snap---monthly-publication-november-2025.pdf   313 2025-11 Car Toyota Prius Silver Driving without Due Care and Attention None A4040 A4040 Birmingham Birmingham Warning Letter N/A      
20784 op-snap---monthly-publication-november-2025.pdf   326 2025-11 Pedal Bike Mazda 6 SE Silver Driving without Due Care and Attention None Black Haynes Road Black Haynes Road Birmingham Birmingham Warning Letter N/A   52.4260755 -1.9679443
20801 op-snap---monthly-publication-november-2025.pdf   343 2025-11 Car Renault Master White Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Warning Letter N/A   52.4041117 -1.5595662
20802 op-snap---monthly-publication-november-2025.pdf   344 2025-11 Car Yamaha GPD125 Red Driving without Due Care and Attention None Durham Road Durham Road Birmingham Birmingham Warning Letter N/A   52.4535652 -1.8699279
20815 op-snap---monthly-publication-november-2025.pdf   357 2025-11 Car Citroen Berlingo White Driving without Due Care and Attention None Eyre Street Eyre Street Birmingham Birmingham Warning Letter N/A   52.4851493 -1.9262172
20826 op-snap---monthly-publication-november-2025.pdf   368 2025-11 Car Volvo Tractor White Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A      
20848 op-snap---monthly-publication-november-2025.pdf   390 2025-11 Car Mercedes-Benz A 200 Black Driving without Due Care and Attention None Central Boulevard Central Boulevard Coventry Coventry Warning Letter N/A   52.4543969 -1.5168781
20854 op-snap---monthly-publication-november-2025.pdf   396 2025-11 Pedal Bike Mercedes-Benz A200 White Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
20864 op-snap---monthly-publication-november-2025.pdf   406 2025-11 Car Volkswagen Crafter White Driving without Due Care and Attention None Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
20885 op-snap---monthly-publication-november-2025.pdf   427 2025-11 Pedestrian Rolls-Royce Cullinan Black Driving without Due Care and Attention None Regent Place Regent Place Birmingham Birmingham Warning Letter N/A   52.4860376 -1.9095854
20902 op-snap---monthly-publication-november-2025.pdf   444 2025-11 Pedestrian Ford Kuga White Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
20903 op-snap---monthly-publication-november-2025.pdf   445 2025-11 Pedestrian Vauxhall Zafira Black Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
20904 op-snap---monthly-publication-november-2025.pdf   446 2025-11 Pedestrian Honda FRV Grey Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
20906 op-snap---monthly-publication-november-2025.pdf   448 2025-11 Car Toyota Previa Black Driving without Due Care and Attention None Heather Road Heather Road Birmingham Birmingham Warning Letter N/A   52.4699812 -1.841443
20931 op-snap---monthly-publication-november-2025.pdf   473 2025-11 Car Audi A4 White Driving without Due Care and Attention None Moseley Road / Cromer Rd Moseley Road / Cromer Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
20933 op-snap---monthly-publication-november-2025.pdf   475 2025-11 Car Skoda Rapide Beige Driving without Due Care and Attention None B4114 Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
20939 op-snap---monthly-publication-november-2025.pdf   481 2025-11 Car BMW 420D Grey Driving without Due Care and Attention None Coopers Lane Coopers Lane Sandwell Sandwell Warning Letter N/A   52.4921093 -1.9705849
20966 op-snap---monthly-publication-november-2025.pdf   508 2025-11 Car Nissan Juke Blue Driving without Due Care and Attention None Grange Road Grange Road Solihull Solihull Warning Letter N/A   52.4285724 -1.8019101
20985 op-snap---monthly-publication-november-2025.pdf   527 2025-11 Car Scania P410 White Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
21011 op-snap---monthly-publication-november-2025.pdf   553 2025-11 Car Audi A6 Black Driving without Due Care and Attention None Coventry Road Coventry Road Coventry Coventry Warning Letter N/A   52.4111289 -1.5094345
21021 op-snap---monthly-publication-november-2025.pdf   563 2025-11 Pedestrian Mercedes-Benz E300 Black Driving without Due Care and Attention None Ivanhoe Street Ivanhoe Street Birmingham Birmingham Warning Letter N/A      
21082 op-snap---monthly-publication-november-2025.pdf   624 2025-11 Car Honda Jazz Blue Driving without Due Care and Attention None Birmingham Road Birmingham Road Dudley Dudley Warning Letter N/A   52.5131355 -2.0651615
21235 op-snap---monthly-publication-november-2025.pdf   777 2025-11 Car Skoda Octavia Beige Driving without Due Care and Attention None London Road London Road Coventry Coventry Warning Letter N/A   52.3916468 -1.4925995
21239 op-snap---monthly-publication-november-2025.pdf   781 2025-11 Pedal Bike Land Rover Discovery Black Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Warning Letter N/A   52.4094108 -1.9930633
21241 op-snap---monthly-publication-november-2025.pdf   783 2025-11 Pedal Bike Fiat 500 White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
21242 op-snap---monthly-publication-november-2025.pdf   784 2025-11 Pedal Bike Toyota Yaris Black Driving without Due Care and Attention None Ashleigh Road Ashleigh Road Birmingham Birmingham Warning Letter N/A   52.5124638 -1.9824678
21255 op-snap---monthly-publication-november-2025.pdf   797 2025-11 Car Toyota Hi Lux Grey Driving without Due Care and Attention None Bell Green Road Bell Green Road Coventry Coventry Warning Letter N/A   52.4324855 -1.4815548
21275 op-snap---monthly-publication-november-2025.pdf   817 2025-11 Car Mercedes-Benz A CLASS Grey Driving without Due Care and Attention None Birmingham Road Oldbury Birmingham Road Oldbury Sandwell Sandwell Warning Letter N/A   52.5025832 -2.0105737
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      
21300 op-snap---monthly-publication-november-2025.pdf   842 2025-11 Car Honda Z-RV White Driving without Due Care and Attention None Lee Bank Middleway Lee Bank Middleway Birmingham Birmingham Warning Letter N/A   52.4677721 -1.9037358
21420 op-snap---monthly-publication-november-2025.pdf   962 2025-11 Car Mercedes-Benz C220 Blue Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Warning Letter N/A   52.5292752 -1.7618805
21421 op-snap---monthly-publication-november-2025.pdf   963 2025-11 Car Vauxhall Corsa Grey Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
21433 op-snap---monthly-publication-november-2025.pdf   975 2025-11 Car Citroen Berlingo White Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
21434 op-snap---monthly-publication-november-2025.pdf   976 2025-11 Car Yamaha 125 Black Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
21439 op-snap---monthly-publication-november-2025.pdf   981 2025-11 Other Saab 09-Mar Black Driving without Due Care and Attention None Market Street, Stourbridge Market Street, Stourbridge Dudley Dudley Warning Letter N/A   52.4569084 -2.147453
21453 op-snap---monthly-publication-november-2025.pdf   995 2025-11 Car Honda JAzz Grey Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Warning Letter N/A   52.4119174 -1.9735247
21488 op-snap---monthly-publication-november-2025.pdf   1030 2025-11 Pedal Bike Land Rover Discovery Silver Driving without Due Care and Attention None Ballsall St Ballsall Street Solihull Solihull Warning Letter N/A      
21519 op-snap---monthly-publication-november-2025.pdf   1061 2025-11 Car Hyundai I10 Silver Driving without Due Care and Attention None Westland Gardens Westland Gardens Dudley Dudley Warning Letter N/A   52.4638535 -2.1506664
21546 op-snap---monthly-publication-november-2025.pdf   1088 2025-11 Pedal Bike Mercedes-Benz GLE Blue Driving without Due Care and Attention None Church Road, Edgbaston Church Road, Edgbaston Birmingham Birmingham Warning Letter N/A   52.46114 -1.9180882
21571 op-snap---monthly-publication-november-2025.pdf   1113 2025-11 Car Toyota   White Driving without Due Care and Attention None Cinder Bank Cinder Bank Dudley Dudley Warning Letter N/A   52.4951209 -2.0924902
21631 op-snap---monthly-publication-november-2025.pdf   1173 2025-11 Car Land Rover Discovery Black Driving without Due Care and Attention None Blackford Road Blackford Road Solihull Solihull Warning Letter N/A   52.3971653 -1.8189489
21680 op-snap---monthly-publication-november-2025.pdf   1222 2025-11 Car Audi A1 White Driving without Due Care and Attention None Black Country New Road / Steel Roundabout Black Country New Road / Steel Roundabout Walsall Walsall Warning Letter N/A   52.5593848 -2.0426847
21708 op-snap---monthly-publication-november-2025.pdf   1250 2025-11 Car Vauxhall Insignia Black Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
21736 op-snap---monthly-publication-november-2025.pdf   1278 2025-11 Car Vauxhall Mokka Black Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham Warning Letter N/A   52.5170745 -1.9012542
21902 op-snap---monthly-publication-november-2025.pdf   1444 2025-11 Car Ford Focus Grey Driving without Due Care and Attention None A41 A41 Sandwell Sandwell Warning Letter N/A      
21903 op-snap---monthly-publication-november-2025.pdf   1445 2025-11 Pedal Bike Skoda Octavia Red Driving without Due Care and Attention None Straoud Road Straoud Road Solihull Solihull Warning Letter N/A      
21968 op-snap---monthly-publication-november-2025.pdf   1510 2025-11 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Swanawell Street Swanawell Street Coventry Coventry Warning Letter N/A      
21997 op-snap---monthly-publication-november-2025.pdf   1539 2025-11 Car Volkswagen Urban Silver Driving without Due Care and Attention None Horseley Fields Horseley Fields Wolverhampton Wolverhampton Warning Letter N/A   52.5850146 -2.1175982
22009 op-snap---monthly-publication-november-2025.pdf   1551 2025-11 Car Volkswagen T Cross Grey Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull Warning Letter N/A   52.4190728 -1.7449943
22024 op-snap---monthly-publication-november-2025.pdf   1566 2025-11 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Regent Road Regent Road Sandwell Sandwell Warning Letter N/A   52.5106406 -2.0559963
22042 op-snap---monthly-publication-november-2025.pdf   1584 2025-11 Car BMW 420D Grey Driving without Due Care and Attention None A456 A456 Birmingham Birmingham Warning Letter N/A      

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