home / opsnap

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

45 rows where disposal = "Warning Letter", month = "2025-06" and offence = "Driving without Reasonable Consideration" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, council_area_raw, latitude, longitude

vehicle_make 20

  • Ford 9
  • Volkswagen 6
  • BMW 5
  • Seat 3
  • Audi 2
  • Land Rover 2
  • Peugeot 2
  • Renault 2
  • Citroen 1
  • Hyundai 1
  • Jaguar 1
  • Mercedes-Benz 1
  • Mg 1
  • Nissan 1
  • Porsche 1
  • Tesla 1
  • Toyota 1
  • Vauxhall 1
  • Volvo 1
  • Yamaha 1

council_area 8

  • Birmingham 27
  • Metropolitan Borough 6
  • Sandwell 3
  • Sutton Coldfield 3
  • Walsall 2
  • Wolverhampton 2
  • Coventry 1
  • Solihull 1

reporter_transport_mode 4

  • Car 39
  • Pedal Bike 3
  • Pedestrian 2
  • Van 1

offence 1

  • Driving without Reasonable Consideration · 45 ✖

month 1

  • 2025-06 · 45 ✖

disposal 1

  • Warning Letter · 45 ✖
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
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
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
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
14223 op-snap---monthly-publication-june-2025.pdf   152 2025-06 Pedestrian Peugeot Partner White Driving without Reasonable Consideration None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
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
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
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
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      
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
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
14481 op-snap---monthly-publication-june-2025.pdf   410 2025-06 Pedal Bike Seat Ibiza Grey Driving without Reasonable Consideration None Wrentham St Wrentham Street Birmingham Birmingham Warning Letter N/A   52.4708757 -1.8966158
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
14701 op-snap---monthly-publication-june-2025.pdf   630 2025-06 Pedestrian Jaguar XE Sport Red Driving without Reasonable Consideration None Cotsymore Road Cotsymore Road Sutton Coldfield Sutton Coldfield Warning Letter N/A      
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      
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      
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
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
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
15101 op-snap---monthly-publication-june-2025.pdf   1030 2025-06 Van BMW 140i blue Driving without Reasonable Consideration None Holbrook Lane Holbrook Lane Coventry Coventry Warning Letter N/A   52.436155 -1.5064002
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
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
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      
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
15634 op-snap---monthly-publication-june-2025.pdf   1563 2025-06 Pedal Bike Ford Puma White Driving without Reasonable Consideration None Long Mynd Road Long Mynd Road Birmingham Birmingham Warning Letter N/A   52.4257286 -1.9769008
15637 op-snap---monthly-publication-june-2025.pdf   1566 2025-06 Pedal Bike   WM BUS Red Driving without Reasonable Consideration None Gilson Way Gilson Way Birmingham Birmingham Warning Letter N/A      
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      
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

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