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

77 rows where month = "2025-06", offence = "Driving without Reasonable Consideration" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Car · 77 ✖

offence 1

  • Driving without Reasonable Consideration · 77 ✖

month 1

  • 2025-06 · 77 ✖
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
14078 op-snap---monthly-publication-june-2025.pdf   7 2025-06 Car Renault Van Blue Driving without Reasonable Consideration None M5 M5 Out of Force Area Out of Force Area NFA Out of Force      
14097 op-snap---monthly-publication-june-2025.pdf   26 2025-06 Car Ford Transit White Driving without Reasonable Consideration None Bloxwich Lane Bloxwich Lane Walsall Walsall Warning Letter N/A   52.6020474 -2.014682
14130 op-snap---monthly-publication-june-2025.pdf   59 2025-06 Car BMW 3 series Grey Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
14131 op-snap---monthly-publication-june-2025.pdf   60 2025-06 Car Fiat 500 Black Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
14135 op-snap---monthly-publication-june-2025.pdf   64 2025-06 Car Audi A4 Grey Driving without Reasonable Consideration None B4101 B4101 Birmingham Birmingham NFA No Offence   52.5079951 -1.9495377
14146 op-snap---monthly-publication-june-2025.pdf   75 2025-06 Car Toyota Aygo Silver Driving without Reasonable Consideration None Radford Road Radford Road Coventry Coventry Education N/A   52.4235908 -1.5226276
14148 op-snap---monthly-publication-june-2025.pdf   77 2025-06 Car Mg three Black Driving without Reasonable Consideration None Avenue Road Avenue Road Birmingham Birmingham Warning Letter N/A   52.4941712 -1.8795158
14150 op-snap---monthly-publication-june-2025.pdf   79 2025-06 Car Land Rover Vogue Gold Driving without Reasonable Consideration None M5 South M5 South Sandwell Sandwell NFA Outside of 14 Days NIP   52.5228877 -2.0650728
14155 op-snap---monthly-publication-june-2025.pdf   84 2025-06 Car Ford Ranger White Driving without Reasonable Consideration None Smithy Lane Smithy Lane Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5094086 -2.1346957
14157 op-snap---monthly-publication-june-2025.pdf   86 2025-06 Car Vauxhall Corsa White Driving without Reasonable Consideration None Milking Bank Milking Bank Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5182185 -2.1123641
14158 op-snap---monthly-publication-june-2025.pdf   87 2025-06 Car Yamaha ns50 Grey Driving without Reasonable Consideration None A4152 at A452 A4152 at A452 Walsall Walsall Warning Letter N/A   52.5805622 -1.9769245
14227 op-snap---monthly-publication-june-2025.pdf   156 2025-06 Car Peugeot 207 Blue Driving without Reasonable Consideration None Coleshill Road Coleshill Road Birmingham Birmingham Education N/A   52.4967329 -1.8097462
14246 op-snap---monthly-publication-june-2025.pdf   175 2025-06 Car Daf HGV Yellow Driving without Reasonable Consideration None M42 M42 Solihull Solihull NFA No Independent Evidence Available      
14248 op-snap---monthly-publication-june-2025.pdf   177 2025-06 Car   NP   Driving without Reasonable Consideration None Great Barr Great Barr Birmingham Birmingham NFA No VRM   52.5309945 -1.9288687
14249 op-snap---monthly-publication-june-2025.pdf   178 2025-06 Car BMW 1 series White Driving without Reasonable Consideration None Leamington Spa Leamington Spa Out of Force Area Out of Force Area NFA Out of Force      
14257 op-snap---monthly-publication-june-2025.pdf   186 2025-06 Car Seat Ibiza White Driving without Reasonable Consideration None Mintague St Mintague Street Birmingham Birmingham NFA Not in Public Interest      
14263 op-snap---monthly-publication-june-2025.pdf   192 2025-06 Car Toyota Yaris Silver Driving without Reasonable Consideration None Belgrave Road Belgrave Road Birmingham Birmingham Warning Letter N/A   52.4669004 -1.9011385
14270 op-snap---monthly-publication-june-2025.pdf   199 2025-06 Car BMW 3 Series Red Driving without Reasonable Consideration None Horsely Fields Horsely Fields Sandwell Sandwell Education N/A      
14284 op-snap---monthly-publication-june-2025.pdf   213 2025-06 Car Ford Ranger White Driving without Reasonable Consideration None Highbridge Road Highbridge Road Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5472182 -1.8359595
14298 op-snap---monthly-publication-june-2025.pdf   227 2025-06 Car Daf HGV White Driving without Reasonable Consideration None Newport Road Newport Road Out of Force Area Out of Force Area NFA Out of Force   52.5024739 -1.7975977
14317 op-snap---monthly-publication-june-2025.pdf   246 2025-06 Car   Lotus Black Driving without Reasonable Consideration None Tyburn Island Tyburn Island Birmingham Birmingham Education N/A   52.5193542 -1.800381
14327 op-snap---monthly-publication-june-2025.pdf   256 2025-06 Car Volvo XC60 Grey Driving without Reasonable Consideration None Spring Lane Spring Lane Birmingham Birmingham Warning Letter N/A   52.5182019 -1.8336169
14329 op-snap---monthly-publication-june-2025.pdf   258 2025-06 Car Volkswagen Touran Grey Driving without Reasonable Consideration None New John Street West New John Street West Birmingham Birmingham NFA Outside of 14 Days NIP   52.4944784 -1.9122329
14330 op-snap---monthly-publication-june-2025.pdf   259 2025-06 Car BMW 3 series Grey Driving without Reasonable Consideration No vehicle excise licence New John Street West New John Street West Birmingham Birmingham NFA Outside of 14 Days NIP   52.4944784 -1.9122329
14338 op-snap---monthly-publication-june-2025.pdf   267 2025-06 Car Ford Puma Blue Driving without Reasonable Consideration None Kingston Road Kingston Road Birmingham Birmingham Warning Letter N/A   52.4747333 -1.8728345
14340 op-snap---monthly-publication-june-2025.pdf   269 2025-06 Car Mercedes-Benz A180 Black Driving without Reasonable Consideration None Kingston Road Kingston Road Birmingham Birmingham Warning Letter N/A   52.4747333 -1.8728345
14341 op-snap---monthly-publication-june-2025.pdf   270 2025-06 Car Audi A3 Green Driving without Reasonable Consideration None Kington Road Kington Road Birmingham Birmingham Warning Letter N/A      
14342 op-snap---monthly-publication-june-2025.pdf   271 2025-06 Car Hyundai I20 Grey Driving without Reasonable Consideration None Kington Road Kington Road Birmingham Birmingham Warning Letter N/A      
14343 op-snap---monthly-publication-june-2025.pdf   272 2025-06 Car Audi Q3 Silver Driving without Reasonable Consideration None Kington Road Kington Road Birmingham Birmingham Warning Letter N/A      
14362 op-snap---monthly-publication-june-2025.pdf   291 2025-06 Car Mini Cooper Red Driving without Reasonable Consideration None Stratford Road Stratford Road Solihull Solihull Fixed Penalty N/A   52.4191184 -1.8326637
14378 op-snap---monthly-publication-june-2025.pdf   307 2025-06 Car Toyota Prius White Driving without Reasonable Consideration None Hill Street Hill Street Birmingham Birmingham NFA No Offence   52.4777765 -1.901321
14409 op-snap---monthly-publication-june-2025.pdf   338 2025-06 Car   Scancia White Driving without Reasonable Consideration None Cinder Bank Cinder Bank Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.4951209 -2.0924902
14418 op-snap---monthly-publication-june-2025.pdf   347 2025-06 Car BMW 218I Black Driving without Reasonable Consideration None Kenpas Highway Kenpas Highway Birmingham Birmingham NFA Outside of 14 Days NIP      
14424 op-snap---monthly-publication-june-2025.pdf   353 2025-06 Car Volvo HGV Grey Driving without Reasonable Consideration None Heartlands Parkway Heartlands Parkway Birmingham Birmingham NFA No Independent Evidence Available   52.5038363 -1.8432663
14436 op-snap---monthly-publication-june-2025.pdf   365 2025-06 Car Audi S3 Yellow Driving without Reasonable Consideration None Bath Row Bath Row Birmingham Birmingham NFA No VRM   52.472238 -1.9127983
14452 op-snap---monthly-publication-june-2025.pdf   381 2025-06 Car Ford transit Grey Driving without Reasonable Consideration None Cat Lane Cat Lane Birmingham Birmingham NFA No Independent Evidence Available   52.5000715 -1.7840322
14472 op-snap---monthly-publication-june-2025.pdf   401 2025-06 Car Seat Ateca Grey Driving without Reasonable Consideration None Hawbush Road Hawbush Road Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.6037191 -1.9834465
14503 op-snap---monthly-publication-june-2025.pdf   432 2025-06 Car Land Rover HSE Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
14558 op-snap---monthly-publication-june-2025.pdf   487 2025-06 Car Seat Arona Red Driving without Reasonable Consideration None Yorkminster Drive Yorkminster Drive Birmingham Birmingham Warning Letter N/A      
14693 op-snap---monthly-publication-june-2025.pdf   622 2025-06 Car Porsche Panamera Black Driving without Reasonable Consideration None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
14745 op-snap---monthly-publication-june-2025.pdf   674 2025-06 Car Volkswagen Golf Black Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham NFA Misc Inc Crimes      
14772 op-snap---monthly-publication-june-2025.pdf   701 2025-06 Car Ford Fiesta Red Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham Warning Letter N/A      
14791 op-snap---monthly-publication-june-2025.pdf   720 2025-06 Car Vauxhall Corsa Grey Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham Court N/A      
14794 op-snap---monthly-publication-june-2025.pdf   723 2025-06 Car BMW 535D Grey Driving without Reasonable Consideration None Marshlake Road Marshlake Road Solihull Solihull Warning Letter N/A      
14833 op-snap---monthly-publication-june-2025.pdf   762 2025-06 Car Volkswagen Golf White Driving without Reasonable Consideration None Hodge Hill Hodge Hill Birmingham Birmingham NFA No VRM   52.4981788 -1.8112796
14836 op-snap---monthly-publication-june-2025.pdf   765 2025-06 Car Volkswagen LT35 Red Driving without Reasonable Consideration None Upper Green Upper Green Wolverhampton Wolverhampton Warning Letter N/A   52.5991066 -2.168802
14842 op-snap---monthly-publication-june-2025.pdf   771 2025-06 Car Seat   Blue Driving without Reasonable Consideration None Oxford Oxford Out of Force Area Out of Force Area NFA Out of Force      
14845 op-snap---monthly-publication-june-2025.pdf   774 2025-06 Car Skoda Rapid Blue Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham NFA No Offence   52.4543565 -1.9114004
14865 op-snap---monthly-publication-june-2025.pdf   794 2025-06 Car BMW M3 White Driving without Reasonable Consideration None Holly Road Holly Road Birmingham Birmingham Warning Letter N/A   52.473564 -1.94941
15087 op-snap---monthly-publication-june-2025.pdf   1016 2025-06 Car Vauxhall Corsa Orange Driving without Reasonable Consideration None Warstock Lane Warstock Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4175988 -1.8774655
15089 op-snap---monthly-publication-june-2025.pdf   1018 2025-06 Car Ford Focus Grey Driving without Reasonable Consideration None Dudley Road East Dudley Road East Sandwell Sandwell Warning Letter N/A   52.5111988 -2.0318469
15121 op-snap---monthly-publication-june-2025.pdf   1050 2025-06 Car Tesla Model Y White Driving without Reasonable Consideration None M6 Jn5 M6 Jn5 Birmingham Birmingham Warning Letter N/A      
15143 op-snap---monthly-publication-june-2025.pdf   1072 2025-06 Car Renault Megane White Driving without Reasonable Consideration None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5940902 -1.843503
15190 op-snap---monthly-publication-june-2025.pdf   1119 2025-06 Car Kia NIRO Silver Driving without Reasonable Consideration None WHITTAL STREET Whittal Street Birmingham Birmingham NFA No Offence   52.4847569 -1.8962965
15212 op-snap---monthly-publication-june-2025.pdf   1141 2025-06 Car Citroen c4 Red Driving without Reasonable Consideration None Coronation Road Coronation Road Walsall Walsall Education N/A   52.6234357 -1.955744
15218 op-snap---monthly-publication-june-2025.pdf   1147 2025-06 Car Volkswagen golf Grey Driving without Reasonable Consideration None Woodbridge Road Woodbridge Road Birmingham Birmingham NFA No Offence   52.4482076 -1.8864335
15226 op-snap---monthly-publication-june-2025.pdf   1155 2025-06 Car Volkswagen Tiguan White Driving without Reasonable Consideration None Collector Road Collector Road Birmingham Birmingham Warning Letter N/A   52.5139393 -1.7600186
15239 op-snap---monthly-publication-june-2025.pdf   1168 2025-06 Car Land Rover Discovery Beige Driving without Reasonable Consideration None Maypole Island Maypole Island Birmingham Birmingham Warning Letter N/A   52.4047413 -1.8859323
15259 op-snap---monthly-publication-june-2025.pdf   1188 2025-06 Car Citroen C4 Grey Driving without Reasonable Consideration None A452 Collector Road Collector Road Birmingham Birmingham Warning Letter N/A   52.5139393 -1.7600186
15334 op-snap---monthly-publication-june-2025.pdf   1263 2025-06 Car Mercedes-Benz GLC Black Driving without Reasonable Consideration None M6 M6 Walsall Walsall NFA Outside of 14 Days NIP      
15467 op-snap---monthly-publication-june-2025.pdf   1396 2025-06 Car Peugeot 307 Silver Driving without Reasonable Consideration None Holyhead Road Holyhead Road Birmingham Birmingham Warning Letter N/A   52.505233 -1.9446276
15470 op-snap---monthly-publication-june-2025.pdf   1399 2025-06 Car Ford Mondeo Blue Driving without Reasonable Consideration None A452 towards Erdington A452 towards Erdington Birmingham Birmingham Warning Letter N/A      
15471 op-snap---monthly-publication-june-2025.pdf   1400 2025-06 Car Volkswagen Tiguan Silver Driving without Reasonable Consideration None A452 towards Erdington A452 towards Erdington Birmingham Birmingham Warning Letter N/A      
15472 op-snap---monthly-publication-june-2025.pdf   1401 2025-06 Car Renault Scenic Red Driving without Reasonable Consideration None Tyburn House roundabout Tyburn House roundabout Birmingham Birmingham Warning Letter N/A      
15507 op-snap---monthly-publication-june-2025.pdf   1436 2025-06 Car BMW 320D Grey Driving without Reasonable Consideration None Hamstead Road Hamstead Road Birmingham Birmingham Fixed Penalty N/A   52.505832 -1.92002
15581 op-snap---monthly-publication-june-2025.pdf   1510 2025-06 Car Volkswagen Golf Grey Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
15633 op-snap---monthly-publication-june-2025.pdf   1562 2025-06 Car Nissan Qashqai Black Driving without Reasonable Consideration None Henwood Road Henwood Road Wolverhampton Wolverhampton Warning Letter N/A   52.5930037 -2.1685306
15648 op-snap---monthly-publication-june-2025.pdf   1577 2025-06 Car Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Bilston Road Bilston Road Wolverhampton Wolverhampton Education N/A   52.5801329 -2.1138283
15649 op-snap---monthly-publication-june-2025.pdf   1578 2025-06 Car BMW 1 series Grey Driving without Reasonable Consideration None A435 HGigh Street, Kings Heath A435 HGigh Street, Kings Heath Birmingham Birmingham Warning Letter N/A      
15665 op-snap---monthly-publication-june-2025.pdf   1594 2025-06 Car Peugeot 207 White Driving without Reasonable Consideration No Insurance Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Court N/A      
15672 op-snap---monthly-publication-june-2025.pdf   1601 2025-06 Car BMW 320 Blue Driving without Reasonable Consideration No Insurance Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A   52.4929304 -1.8229092
15704 op-snap---monthly-publication-june-2025.pdf   1633 2025-06 Car BMW 1 series Grey Driving without Reasonable Consideration None A41 A41 Sandwell Sandwell Warning Letter N/A      
15706 op-snap---monthly-publication-june-2025.pdf   1635 2025-06 Car Volkswagen Passat Grey Driving without Reasonable Consideration None Castlegate Island Castlegate Island Sandwell Sandwell Warning Letter N/A      
15707 op-snap---monthly-publication-june-2025.pdf   1636 2025-06 Car Ford Fiesta Black Driving without Reasonable Consideration None Cradley Road Cradley Road Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.4827555 -2.0816033
15711 op-snap---monthly-publication-june-2025.pdf   1640 2025-06 Car Volkswagen Passat Black Driving without Reasonable Consideration None Granville Street Granville Street Birmingham Birmingham Warning Letter N/A   52.4762076 -1.9124263
15720 op-snap---monthly-publication-june-2025.pdf   1649 2025-06 Car   Mclaren Grey Driving without Reasonable Consideration None M42 M42 Birmingham Birmingham NFA No Independent Evidence Available      
15738 op-snap---monthly-publication-june-2025.pdf   1667 2025-06 Car Mercedes-Benz A class White Driving without Reasonable Consideration None Fletchamstead Highway Fletchamstead Highway Coventry Coventry NFA Outside of 14 Days NIP   52.396476 -1.5561348

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