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

75 rows where council_area = "Coventry", disposal = "Warning Letter" and month = "2025-07" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence

vehicle_make 22

  • Audi 9
  • BMW 7
  • Ford 7
  • Mercedes-Benz 7
  • Vauxhall 7
  • Volkswagen 7
  • Nissan 5
  • Toyota 5
  • Skoda 3
  • Citroen 2
  • Daf 2
  • Iveco 2
  • Seat 2
  • Chevrolet 1
  • Dacia 1
  • Honda 1
  • Hyundai 1
  • Land Rover 1
  • Lexus 1
  • Mazda 1
  • Peugeot 1
  • Scania 1

offence 10

  • Cause vehicle to be left in a dangerous position 25
  • Driving without Due Care and Attention 23
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 13
  • Contravening a Red Traffic Light 4
  • Driving without Reasonable Consideration 4
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
  • Misc - Non Traffic Offences 1
  • Prohibited vehicle in offside lane of motorway 1
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
  • Using a Mobile Phone Whilst Driving 1

reporter_transport_mode 5

  • Pedal Bike 30
  • Car 23
  • Pedestrian 20
  • Motorbike 1
  • Other 1

month 1

  • 2025-07 · 75 ✖

disposal 1

  • Warning Letter · 75 ✖

council_area 1

  • Coventry · 75 ✖
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
11989 op-snap---monthly-publication-july-2025.pdf   41 2025-07 Car Volkswagen Caddy White Driving without Reasonable Consideration None Grange Road, Coventry Grange Road, Coventry Coventry Coventry Warning Letter N/A   52.4521035 -1.4777638
12002 op-snap---monthly-publication-july-2025.pdf   54 2025-07 Car Daf   Grey Contravening a Red Traffic Light none Sir Henry Parkes Road Sir Henry Parkes Road Coventry Coventry Warning Letter N/A   52.3900568 -1.5550766
12026 op-snap---monthly-publication-july-2025.pdf   78 2025-07 Pedal Bike Toyota Prius Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
12143 op-snap---monthly-publication-july-2025.pdf   195 2025-07 Car Skoda Octavia Black Driving without Reasonable Consideration None A444 Jimmy Hill Way Jimmy Hill Way Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
12178 op-snap---monthly-publication-july-2025.pdf   230 2025-07 Pedestrian Vauxhall Zafira Beige Driving without Due Care and Attention None Outside Coventry Market Outside Coventry Market Coventry Coventry Warning Letter N/A      
12371 op-snap---monthly-publication-july-2025.pdf   423 2025-07 Car Toyota Auris White Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Warning Letter N/A   52.4134557 -1.4442138
12459 op-snap---monthly-publication-july-2025.pdf   511 2025-07 Pedal Bike Vauxhall Insignia White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
12505 op-snap---monthly-publication-july-2025.pdf   557 2025-07 Car Skoda Citigo Red Driving without Due Care and Attention None Stivichall Roundabout Stivichall Roundabout Coventry Coventry Warning Letter N/A   52.3776818 -1.4982138
12584 op-snap---monthly-publication-july-2025.pdf   636 2025-07 Car Vauxhall Astra Grey Driving without Reasonable Consideration None Moseley Avenue Moseley Avenue Coventry Coventry Warning Letter N/A   52.417344 -1.5264979
12671 op-snap---monthly-publication-july-2025.pdf   723 2025-07 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Holbrook Lane Holbrook Lane Coventry Coventry Warning Letter N/A   52.436155 -1.5064002
12729 op-snap---monthly-publication-july-2025.pdf   781 2025-07 Other   Kawasaki Blue Misc - Non Traffic Offences None Moathouse Park (Cov) Moathouse Park (Cov) Coventry Coventry Warning Letter N/A   52.4352858 -1.4634999
12782 op-snap---monthly-publication-july-2025.pdf   834 2025-07 Car Volkswagen Golf Black Contravening a Red Traffic Light None Gulson Road Gulson Road Coventry Coventry Warning Letter N/A   52.4076795 -1.4911676
13019 op-snap---monthly-publication-july-2025.pdf   1071 2025-07 Pedestrian Iveco Daily Blue Contravening a Red Traffic Light None Ansty Road A4600 Ansty Road A4600 Coventry Coventry Warning Letter N/A   52.416665 -1.4604791
13085 op-snap---monthly-publication-july-2025.pdf   1137 2025-07 Car Mercedes-Benz   Silver Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry Warning Letter N/A   52.4235908 -1.5226276
13120 op-snap---monthly-publication-july-2025.pdf   1172 2025-07 Pedestrian Nissan Qashqai Grey Contravening a Red Traffic Light None Foleshill Road A444 Foleshill Road A444 Coventry Coventry Warning Letter N/A   52.4363104 -1.4936555
13167 op-snap---monthly-publication-july-2025.pdf   1219 2025-07 Pedal Bike Land Rover Defender Green Driving without Due Care and Attention None Lavender Hall Lane Lavender Hall Lane Coventry Coventry Warning Letter N/A      
13168 op-snap---monthly-publication-july-2025.pdf   1220 2025-07 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Lavender Hall Lane Lavender Hall Lane Coventry Coventry Warning Letter N/A      
13198 op-snap---monthly-publication-july-2025.pdf   1250 2025-07 Car Scania Tractor White Driving without Due Care and Attention None Toll Bar End Toll Bar End Coventry Coventry Warning Letter N/A   52.377406 -1.4651313
13224 op-snap---monthly-publication-july-2025.pdf   1276 2025-07 Car BMW 218i White Driving without Due Care and Attention None A45 A45 Coventry Coventry Warning Letter N/A      
13249 op-snap---monthly-publication-july-2025.pdf   1301 2025-07 Car Dacia Sandero White Driving without Due Care and Attention None A45 Sir Henry Parkes Road Sir Henry Parkes Road Coventry Coventry Warning Letter N/A   52.3900568 -1.5550766
13319 op-snap---monthly-publication-july-2025.pdf   1371 2025-07 Pedal Bike Mercedes-Benz GLE Green Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13323 op-snap---monthly-publication-july-2025.pdf   1375 2025-07 Pedal Bike Daf Tipper Blue Driving without Due Care and Attention None Stoney Stanton Lane Stoney Stanton Lane Coventry Coventry Warning Letter N/A   52.4211068 -1.4966527
13325 op-snap---monthly-publication-july-2025.pdf   1377 2025-07 Pedal Bike Mercedes-Benz Coach White Driving without Due Care and Attention None Stoney Stanton Lane Stoney Stanton Lane Coventry Coventry Warning Letter N/A   52.4211068 -1.4966527
13342 op-snap---monthly-publication-july-2025.pdf   1394 2025-07 Car Toyota Prius Silver Cause vehicle to be left in a dangerous position None Earlsdon Street Earlsdon Street Coventry Coventry Warning Letter N/A   52.3988977 -1.5323674
13349 op-snap---monthly-publication-july-2025.pdf   1401 2025-07 Pedal Bike Ford Fiesta Silver Cause vehicle to be left in a dangerous position None Earlsdon Street Earlsdon Street Coventry Coventry Warning Letter N/A   52.3988977 -1.5323674
13408 op-snap---monthly-publication-july-2025.pdf   1460 2025-07 Pedal Bike Ford Fiesta Red Cause vehicle to be left in a dangerous position None Corporation Street Corporation Street Coventry Coventry Warning Letter N/A   52.4086244 -1.515132
13409 op-snap---monthly-publication-july-2025.pdf   1461 2025-07 Pedal Bike Audi a3 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Duncroft Avenue Duncroft Avenue Coventry Coventry Warning Letter N/A   52.4285538 -1.5345395
13410 op-snap---monthly-publication-july-2025.pdf   1462 2025-07 Car Citroen C4 Blue Driving without Due Care and Attention None Cheveral Avenue Cheveral Avenue Coventry Coventry Warning Letter N/A   52.4257402 -1.5185037
13434 op-snap---monthly-publication-july-2025.pdf   1486 2025-07 Pedal Bike Lexus CT200 Black Cause vehicle to be left in a dangerous position None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13435 op-snap---monthly-publication-july-2025.pdf   1487 2025-07 Pedal Bike Mercedes-Benz A180 Grey Cause vehicle to be left in a dangerous position None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13442 op-snap---monthly-publication-july-2025.pdf   1494 2025-07 Pedestrian Chevrolet Orlando Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dewsbury Avenue Dewsbury Avenue Coventry Coventry Warning Letter N/A   52.3848122 -1.5204351
13443 op-snap---monthly-publication-july-2025.pdf   1495 2025-07 Pedestrian Hyundai I20 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dewsbury Avenue Dewsbury Avenue Coventry Coventry Warning Letter N/A   52.3848122 -1.5204351
13451 op-snap---monthly-publication-july-2025.pdf   1503 2025-07 Pedestrian Skoda Kodiaq Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Parkgate Road Parkgate Road Coventry Coventry Warning Letter N/A   52.445796 -1.5148141
13456 op-snap---monthly-publication-july-2025.pdf   1508 2025-07 Pedestrian BMW 118D Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Mitchell Avenue Mitchell Avenue Coventry Coventry Warning Letter N/A   52.3940834 -1.5696642
13468 op-snap---monthly-publication-july-2025.pdf   1520 2025-07 Pedestrian Nissan Qashqai Red Cause vehicle to be left in a dangerous position None Albany Road Albany Road Coventry Coventry Warning Letter N/A   52.4006218 -1.5284125
13478 op-snap---monthly-publication-july-2025.pdf   1530 2025-07 Pedestrian Seat Arona Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dunsmore Avenue Dunsmore Avenue Coventry Coventry Warning Letter N/A   52.3855553 -1.4659743
13496 op-snap---monthly-publication-july-2025.pdf   1548 2025-07 Car Audi A3 White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Holy Head road Holy Head road Coventry Coventry Warning Letter N/A      
13515 op-snap---monthly-publication-july-2025.pdf   1567 2025-07 Pedestrian Nissan Duke White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Charter Avenue Charter Avenue Coventry Coventry Warning Letter N/A   52.3928409 -1.5888076
13532 op-snap---monthly-publication-july-2025.pdf   1584 2025-07 Pedestrian Toyota Prius White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Chace Avenue Chace Avenue Coventry Coventry Warning Letter N/A   52.3865575 -1.4715848
13533 op-snap---monthly-publication-july-2025.pdf   1585 2025-07 Pedestrian Volkswagen fox Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None chace Avenue chace Avenue Coventry Coventry Warning Letter N/A   52.3865575 -1.4715848
13565 op-snap---monthly-publication-july-2025.pdf   1617 2025-07 Pedal Bike Audi Q5 Grey Cause vehicle to be left in a dangerous position None Hollyfast Road Hollyfast Road Coventry Coventry Warning Letter N/A   52.4230701 -1.5346523
13566 op-snap---monthly-publication-july-2025.pdf   1618 2025-07 Pedal Bike BMW 1 series White Cause vehicle to be left in a dangerous position None Hollyfast Road Hollyfast Road Coventry Coventry Warning Letter N/A   52.4230701 -1.5346523
13567 op-snap---monthly-publication-july-2025.pdf   1619 2025-07 Pedal Bike Nissan Juke Black Cause vehicle to be left in a dangerous position None Hollyfast Road Hollyfast Road Coventry Coventry Warning Letter N/A   52.4230701 -1.5346523
13571 op-snap---monthly-publication-july-2025.pdf   1623 2025-07 Pedal Bike Vauxhall Zafira Blue Cause vehicle to be left in a dangerous position None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13606 op-snap---monthly-publication-july-2025.pdf   1658 2025-07 Car Vauxhall Corsa Silver Cause vehicle to be left in a dangerous position None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13633 op-snap---monthly-publication-july-2025.pdf   1685 2025-07 Pedestrian Audi a4 Blue Cause vehicle to be left in a dangerous position None Chace Avenue Chace Avenue Coventry Coventry Warning Letter N/A   52.3865575 -1.4715848
13634 op-snap---monthly-publication-july-2025.pdf   1686 2025-07 Pedestrian Audi A6 Grey Cause vehicle to be left in a dangerous position None Chace Avenue Chace Avenue Coventry Coventry Warning Letter N/A   52.3865575 -1.4715848
13635 op-snap---monthly-publication-july-2025.pdf   1687 2025-07 Pedestrian Mercedes-Benz e220 White Cause vehicle to be left in a dangerous position None Chace Avenue Chace Avenue Coventry Coventry Warning Letter N/A   52.3865575 -1.4715848
13655 op-snap---monthly-publication-july-2025.pdf   1707 2025-07 Pedestrian Audi Q6 Grey Cause vehicle to be left in a dangerous position None Earlsdon Street Earlsdon Street Coventry Coventry Warning Letter N/A   52.3988977 -1.5323674
13656 op-snap---monthly-publication-july-2025.pdf   1708 2025-07 Pedestrian Ford Kuga White Cause vehicle to be left in a dangerous position None Earlsdon Street Earlsdon Street Coventry Coventry Warning Letter N/A   52.3988977 -1.5323674
13657 op-snap---monthly-publication-july-2025.pdf   1709 2025-07 Pedestrian BMW 1 series Blue Cause vehicle to be left in a dangerous position None Unknown   Coventry Coventry Warning Letter N/A      
13702 op-snap---monthly-publication-july-2025.pdf   1754 2025-07 Pedal Bike BMW 3 series White Cause vehicle to be left in a dangerous position None Gosford Street, Coventry Gosford Street, Coventry Coventry Coventry Warning Letter N/A   52.4068712 -1.4994695
13703 op-snap---monthly-publication-july-2025.pdf   1755 2025-07 Pedal Bike Volkswagen Crafter Van White Cause vehicle to be left in a dangerous position None Unknown   Coventry Coventry Warning Letter N/A      
13704 op-snap---monthly-publication-july-2025.pdf   1756 2025-07 Pedal Bike Toyota Hilux Silver Cause vehicle to be left in a dangerous position None Gosford Street, Coventry Gosford Street, Coventry Coventry Coventry Warning Letter N/A   52.4068712 -1.4994695
13750 op-snap---monthly-publication-july-2025.pdf   1802 2025-07 Pedestrian Seat Cupra Grey Cause vehicle to be left in a dangerous position None Walsgrabe Gardens Walsgrabe Gardens Coventry Coventry Warning Letter N/A      
13759 op-snap---monthly-publication-july-2025.pdf   1811 2025-07 Car Ford BMAX Red Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Barras Lane Barras Lane Coventry Coventry Warning Letter N/A   52.4109877 -1.5203488
13791 op-snap---monthly-publication-july-2025.pdf   1843 2025-07 Pedal Bike BMW 730D Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Binley Road Binley Road Coventry Coventry Warning Letter N/A   52.4070602 -1.4732469
13838 op-snap---monthly-publication-july-2025.pdf   1890 2025-07 Pedal Bike Volkswagen golf Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13867 op-snap---monthly-publication-july-2025.pdf   1919 2025-07 Pedal Bike Peugeot eurotaxi White Cause vehicle to be left in a dangerous position None Stoney Stanton road Stoney Stanton road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13894 op-snap---monthly-publication-july-2025.pdf   1946 2025-07 Pedal Bike Honda civic Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13901 op-snap---monthly-publication-july-2025.pdf   1953 2025-07 Car Citroen Berlingo White Using a Mobile Phone Whilst Driving None Unknon in Coventry Unknon in Coventry Coventry Coventry Warning Letter N/A      
13902 op-snap---monthly-publication-july-2025.pdf   1954 2025-07 Pedal Bike Nissan qashqai Black Driving without Due Care and Attention None Stoney Stanton Stoney Stanton Coventry Coventry Warning Letter N/A   52.4196813 -1.4978941
13903 op-snap---monthly-publication-july-2025.pdf   1955 2025-07 Pedal Bike Ford transit Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None stoney stanton Stoney Stanton Coventry Coventry Warning Letter N/A   52.4196813 -1.4978941
13913 op-snap---monthly-publication-july-2025.pdf   1965 2025-07 Pedal Bike Audi A4 Black Driving without Due Care and Attention None broad lane Broad Lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
13918 op-snap---monthly-publication-july-2025.pdf   1970 2025-07 Car Mazda 3 Sport Silver Driving without Due Care and Attention None Holyhead road Holyhead road Coventry Coventry Warning Letter N/A   52.418488 -1.5472387
13947 op-snap---monthly-publication-july-2025.pdf   1999 2025-07 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Warning Letter N/A   52.4047134 -1.5351834
13948 op-snap---monthly-publication-july-2025.pdf   2000 2025-07 Pedal Bike Vauxhall Movano White Driving without Due Care and Attention None Broadway Broadway Coventry Coventry Warning Letter N/A   52.3999339 -1.5249817
13949 op-snap---monthly-publication-july-2025.pdf   2001 2025-07 Pedal Bike Ford Ranger Silver Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Warning Letter N/A   52.4047134 -1.5351834
13950 op-snap---monthly-publication-july-2025.pdf   2002 2025-07 Pedal Bike BMW 120D Brown Driving without Due Care and Attention None Queensland Avenue Queensland Avenue Coventry Coventry Warning Letter N/A   52.406658 -1.5363495
13955 op-snap---monthly-publication-july-2025.pdf   2007 2025-07 Car Audi Q3 Black Cause vehicle to be left in a dangerous position None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
13956 op-snap---monthly-publication-july-2025.pdf   2008 2025-07 Car Volkswagen Polo Blue Cause vehicle to be left in a dangerous position None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
13957 op-snap---monthly-publication-july-2025.pdf   2009 2025-07 Motorbike Ford Fiesta Red Driving without Due Care and Attention None A444 Gallagher shopping center Gallagher shopping center Coventry Coventry Warning Letter N/A      
13961 op-snap---monthly-publication-july-2025.pdf   2013 2025-07 Car Mercedes-Benz c220 Black Driving without Due Care and Attention None A444 A444 Coventry Coventry Warning Letter N/A      
14020 op-snap---monthly-publication-july-2025.pdf   2072 2025-07 Pedestrian Audi a3 Red Cause vehicle to be left in a dangerous position None Albany Road Albany Road Coventry Coventry Warning Letter N/A   52.4006218 -1.5284125
14040 op-snap---monthly-publication-july-2025.pdf   2092 2025-07 Car Iveco Daily White Prohibited vehicle in offside lane of motorway None M6 North junction3 M6 North junction3 Coventry Coventry 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);