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

67 rows where council_area = "Coventry", disposal = "Education" and vehicle_make = "Ford" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_model, vehicle_colour, second_offence

month 14

  • 2025-03 11
  • 2026-02 10
  • 2025-01 8
  • 2025-02 8
  • 2025-09 5
  • 2025-11 5
  • 2025-12 4
  • 2025-05 3
  • 2025-07 3
  • 2025-08 3
  • 2025-10 3
  • 2026-01 2
  • 2025-04 1
  • 2025-06 1

offence 7

  • Driving without Due Care and Attention 28
  • Driving without Reasonable Consideration 17
  • Stop a vehicle within pelican pedestrian crossing limits 9
  • Contravening a Red Traffic Light 8
  • Stop a vehicle on pedestrian crossing 3
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 1
  • Cause vehicle to be left in a dangerous position 1

reporter_transport_mode 4

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

vehicle_make 1

  • Ford · 67 ✖

disposal 1

  • Education · 67 ✖

council_area 1

  • Coventry · 67 ✖
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
7292 op-snap---monthly-publication-february-2026.pdf   39 2026-02 Car Ford Transit White Stop a vehicle on pedestrian crossing None Knowle High Street Knowle High Street Coventry Coventry Education N/A      
7359 op-snap---monthly-publication-february-2026.pdf   106 2026-02 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Greens Road Greens Road Coventry Coventry Education N/A   52.4381927 -1.5291209
7538 op-snap---monthly-publication-february-2026.pdf   285 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry Education N/A   52.418488 -1.5472387
7634 op-snap---monthly-publication-february-2026.pdf   381 2026-02 Car Ford Focus Blue Contravening a Red Traffic Light None Walsgrave Road Walsgrave Road Coventry Coventry Education N/A   52.4096725 -1.487901
8049 op-snap---monthly-publication-february-2026.pdf   796 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Broad Lane nr The Glade junction Broad Lane nr The Glade junction Coventry Coventry Education N/A      
8083 op-snap---monthly-publication-february-2026.pdf   830 2026-02 Car Ford Focus Red Driving without Due Care and Attention None Lamb Street Lamb Street Coventry Coventry Education N/A   52.4110367 -1.5143617
8147 op-snap---monthly-publication-february-2026.pdf   894 2026-02 Pedal Bike Ford Fiesta Blue Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
8404 op-snap---monthly-publication-february-2026.pdf   1151 2026-02 Pedestrian Ford Transit White Cause vehicle to be left in a dangerous position None Lentons Lane Lentons Lane Coventry Coventry Education N/A   52.4503238 -1.4546397
8594 op-snap---monthly-publication-february-2026.pdf   1341 2026-02 Car Ford Transit White Driving without Due Care and Attention None Ludgate Road Ludgate Road Coventry Coventry Education N/A      
8760 op-snap---monthly-publication-february-2026.pdf   1507 2026-02 Pedal Bike Ford Puma Red Driving without Due Care and Attention None Wall Hill Road Wall Hill Road Coventry Coventry Education N/A   52.4459445 -1.5552508
10743 op-snap---monthly-publication-january-2026.pdf   204 2026-01 Car Ford Ranger Red Contravening a Red Traffic Light None A45 Coventry - Jct of Tile Hill Lane Coventry - Junction of Tile Hill Lane Coventry Coventry Education N/A      
11120 op-snap---monthly-publication-january-2026.pdf   581 2026-01 Pedal Bike Ford Transit Blue Driving without Due Care and Attention None Burnaby Road at Beake Avenue Burnaby Road at Beake Avenue Coventry Coventry Education N/A   52.4352 -1.5194238
4017 op-snap---monthly-publication-december-2025.pdf   145 2025-12 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Westward Way Westward Way Coventry Coventry Education N/A      
4538 op-snap---monthly-publication-december-2025.pdf   666 2025-12 Car Ford Transit Grey Driving without Due Care and Attention None A444 A444 Coventry Coventry Education N/A      
4570 op-snap---monthly-publication-december-2025.pdf   698 2025-12 Car Ford Focus Black Driving without Due Care and Attention None Clifford Bridge Road to Ansty Road Clifford Bridge Road to Ansty Road Coventry Coventry Education N/A      
4701 op-snap---monthly-publication-december-2025.pdf   829 2025-12 Car Ford Transit Blue Stop a vehicle within pelican pedestrian crossing limits None far gosford street Far Gosford Street Coventry Coventry Education N/A   52.4071231 -1.4985178
20614 op-snap---monthly-publication-november-2025.pdf   156 2025-11 Pedal Bike Ford Focus White Driving without Due Care and Attention None Counden Wedge Drive Counden Wedge Drive Coventry Coventry Education N/A      
20778 op-snap---monthly-publication-november-2025.pdf   320 2025-11 Car Ford GALAXY White Driving without Due Care and Attention None A444 A444 Coventry Coventry Education N/A      
21471 op-snap---monthly-publication-november-2025.pdf   1013 2025-11 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
21665 op-snap---monthly-publication-november-2025.pdf   1207 2025-11 Car Ford B-Max Blue Driving without Due Care and Attention   Foleshill Road, Coventry Foleshill Road, Coventry Coventry Coventry Education N/A   52.4363104 -1.4936555
21693 op-snap---monthly-publication-november-2025.pdf   1235 2025-11 Car Ford galaxy Silver Driving without Due Care and Attention None crampers field Crampers Field Coventry Coventry Education N/A   52.4176927 -1.5257854
22198 op-snap---monthly-publication-october-2025.pdf   148 2025-10 Car Ford Fiesta Red Driving without Reasonable Consideration None A4053 RIng Road A4053 RIng Road Coventry Coventry Education N/A      
22623 op-snap---monthly-publication-october-2025.pdf   573 2025-10 Pedal Bike Ford Fiesta Blue Driving without Due Care and Attention None West Hill Road West Hill Road Coventry Coventry Education N/A   52.3994858 -1.4923603
22718 op-snap---monthly-publication-october-2025.pdf   668 2025-10 Pedal Bike Ford B-Max White Driving without Due Care and Attention None Leamington Road Leamington Road Coventry Coventry Education N/A   52.3921304 -1.5156601
23993 op-snap---monthly-publication-september-2025.pdf   212 2025-09 Pedal Bike Ford Transit Pink Contravening a Red Traffic Light None Bell Green Road Bell Green Road Coventry Coventry Education N/A   52.4324855 -1.4815548
24070 op-snap---monthly-publication-september-2025.pdf   289 2025-09 Car Ford C-max White Contravening a Red Traffic Light None Coundon Wedge Drive Coundon Wedge Drive Coventry Coventry Education N/A   52.4385402 -1.5483746
24274 op-snap---monthly-publication-september-2025.pdf   493 2025-09 Van Ford Transit Connect White Contravening a Red Traffic Light None Coventry Ring Road Coventry Ring Road Coventry Coventry Education N/A      
24625 op-snap---monthly-publication-september-2025.pdf   844 2025-09 Car Ford Smax Grey Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A   52.4134557 -1.4442138
24881 op-snap---monthly-publication-september-2025.pdf   1100 2025-09 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Beechwood Ave Beechwood Ave Coventry Coventry Education N/A   52.3963882 -1.5379305
2086 op-snap---monthly-publication-august-2025.pdf   61 2025-08 Car Ford Transit Blue Contravening a Red Traffic Light None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
3052 op-snap---monthly-publication-august-2025.pdf   1027 2025-08 Pedal Bike Ford Puma Grey Driving without Due Care and Attention None Tile Hill Road Tile Hill Road Coventry Coventry Education N/A      
3173 op-snap---monthly-publication-august-2025.pdf   1148 2025-08 Car Ford Focus Blue Contravening a Red Traffic Light None Ansty Road Ansty Road Coventry Coventry Education N/A   52.4205675 -1.4520187
12176 op-snap---monthly-publication-july-2025.pdf   228 2025-07 Car Ford Transit White Driving without Due Care and Attention None Widdrington Road Widdrington Road Coventry Coventry Education N/A   52.4191764 -1.5105738
12475 op-snap---monthly-publication-july-2025.pdf   527 2025-07 Car Ford Fiesta Blue Driving without Due Care and Attention None A45 Dunchurch Highway Dunchurch Highway Coventry Coventry Education N/A   52.4131902 -1.5650136
13108 op-snap---monthly-publication-july-2025.pdf   1160 2025-07 Car Ford Fiesta Black Contravening a Red Traffic Light Use vehicle on a road without valid test certificate Banner Lane Banner Lane Coventry Coventry Education N/A   52.4010821 -1.5953502
14674 op-snap---monthly-publication-june-2025.pdf   603 2025-06 Pedal Bike Ford Fiesta Silver Driving without Due Care and Attention None Tile Hill Tile Hill Coventry Coventry Education N/A   52.3951906 -1.5972825
18815 op-snap---monthly-publication-may-2025.pdf   177 2025-05 Pedal Bike Ford Transit White Stop a vehicle within pelican pedestrian crossing limits None Earlsdon St Earlsdon Street Coventry Coventry Education N/A   52.3988977 -1.5323674
18873 op-snap---monthly-publication-may-2025.pdf   235 2025-05 Pedal Bike Ford fiesta white Stop a vehicle within pelican pedestrian crossing limits none Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
19303 op-snap---monthly-publication-may-2025.pdf   665 2025-05 Car Ford Transit Black Stop a vehicle on pedestrian crossing None Quinton Park Quinton Park Coventry Coventry Education N/A   52.3906999 -1.5036996
75 op-snap---monthly-publication-april-2025.pdf   74 2025-04 Pedal Bike Ford FIESTA Silver Stop a vehicle within pelican pedestrian crossing limits None STONEY STANTON ROAD Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
17001 op-snap---monthly-publication-march-2025.pdf   758 2025-03 Pedal Bike Ford Focus Black Driving without Due Care and Attention None Alma Street Alma Street Coventry Coventry Education N/A Yes - Via Email 52.4097148 -1.500004
17055 op-snap---monthly-publication-march-2025.pdf   812 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Earlsdon Road Earlsdon Road Coventry Coventry Education N/A Yes - Via Email 52.3972344 -1.5388569
17306 op-snap---monthly-publication-march-2025.pdf   1063 2025-03 Pedestrian Ford Fiesta Grey Driving without Reasonable Consideration None Gosford Street Gosford Street Coventry Coventry Education N/A Yes - Via Email 52.4068712 -1.4994695
17336 op-snap---monthly-publication-march-2025.pdf   1093 2025-03 Pedal Bike Ford Fiesta Grey Stop a vehicle on pedestrian crossing None Albany Road Albany Road Coventry Coventry Education N/A Yes - Via Email 52.4006218 -1.5284125
17403 op-snap---monthly-publication-march-2025.pdf   1160 2025-03 Pedal Bike Ford Transit Silver Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A Yes - Via Email 52.4134557 -1.4442138
17713 op-snap---monthly-publication-march-2025.pdf   1470 2025-03 Pedal Bike Ford Transit Grey Driving without Reasonable Consideration None The Scotchill The Scotchill Coventry Coventry Education N/A Yes - Via Email 52.435625 -1.528323
17715 op-snap---monthly-publication-march-2025.pdf   1472 2025-03 Pedal Bike Ford C-Max Black Driving without Reasonable Consideration None Browett Road Browett Road Coventry Coventry Education N/A Yes - Via Email 52.4159473 -1.5310383
17998 op-snap---monthly-publication-march-2025.pdf   1755 2025-03 Car Ford MONDEO Grey Stop a vehicle within pelican pedestrian crossing limits None EARLSDON STREET Earlsdon Street Coventry Coventry Education N/A Yes - Via Email 52.3988977 -1.5323674
18105 op-snap---monthly-publication-march-2025.pdf   1862 2025-03 Car Ford Fiesta Black Driving without Due Care and Attention None Far Gosford Street Far Gosford Street Coventry Coventry Education N/A Yes - Via Email 52.4071231 -1.4985178
18350 op-snap---monthly-publication-march-2025.pdf   2107 2025-03 Pedal Bike Ford TRANSIT 350 White Driving without Reasonable Consideration None WOODWAY LANE Woodway Lane Coventry Coventry Education N/A Yes - Via Email 52.4275505 -1.4448681
18356 op-snap---monthly-publication-march-2025.pdf   2113 2025-03 Pedal Bike Ford Puma Black Driving without Reasonable Consideration None Woodway Lane, Woodway Lane Coventry Coventry Education N/A Yes - Via Email 52.4275505 -1.4448681
5218 op-snap---monthly-publication-february-2025.pdf   35 2025-02 Car Ford Transit White Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Education N/A Yes - Via Email 52.3988977 -1.5323674
5348 op-snap---monthly-publication-february-2025.pdf   165 2025-02 Pedal Bike Ford Mondeo Red Driving without Reasonable Consideration None Deedmore Road Deedmore Road Coventry Coventry Education N/A Yes - Via Email 52.4373935 -1.4615405
5510 op-snap---monthly-publication-february-2025.pdf   327 2025-02 Pedal Bike Ford Fiesta Blue Driving without Reasonable Consideration None Willenhall Lane Willenhall Lane Coventry Coventry Education N/A Yes - Via Email 52.3983962 -1.4423958
6544 op-snap---monthly-publication-february-2025.pdf   1361 2025-02 Pedal Bike Ford focus White Driving without Due Care and Attention None Birmingham Road Birmingham Road Coventry Coventry Education N/A Yes - Via Email 52.4272882 -1.5753221
6614 op-snap---monthly-publication-february-2025.pdf   1431 2025-02 Pedal Bike Ford Fiesta Blue Driving without Due Care and Attention None Charter Avenue Charter Avenue Coventry Coventry Education N/A Yes - Via Email 52.3928409 -1.5888076
6730 op-snap---monthly-publication-february-2025.pdf   1547 2025-02 Pedestrian Ford Transit Grey Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A Yes - Via Email 52.4221152 -1.4959475
7180 op-snap---monthly-publication-february-2025.pdf   1997 2025-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Millburn Hill Road Millburn Hill Road Coventry Coventry Education N/A Yes - Via Email 52.3863187 -1.5607105
7215 op-snap---monthly-publication-february-2025.pdf   2032 2025-02 Pedal Bike Ford Fiesta Black Driving without Reasonable Consideration None Mercer Avenue Mercer Avenue Coventry Coventry Education N/A Yes - Via Email 52.4170303 -1.482739
9389 op-snap---monthly-publication-january-2025.pdf   497 2025-01 Pedal Bike Ford Fiesta Grey Driving without Reasonable Consideration None Spon End Spon End Coventry Coventry Education N/A Yes - Via Email 52.4069072 -1.5247498
9617 op-snap---monthly-publication-january-2025.pdf   725 2025-01 Pedal Bike Ford Ranger Black Driving without Due Care and Attention No vehicle excise licence Church Lane Church Lane Coventry Coventry Education N/A Yes - Via Email 52.4202618 -1.6010473
9775 op-snap---monthly-publication-january-2025.pdf   883 2025-01 Pedal Bike Ford Ranger Grey Driving without Reasonable Consideration None Brandon Road Brandon Road Coventry Coventry Education N/A Yes - Via Email 52.399222 -1.4414386
9951 op-snap---monthly-publication-january-2025.pdf   1059 2025-01 Pedal Bike Ford Kuga Silver Driving without Reasonable Consideration None Lockhurst Lane Lockhurst Lane Coventry Coventry Education N/A Yes - Via Email 52.4255689 -1.5023841
9983 op-snap---monthly-publication-january-2025.pdf   1091 2025-01 Pedal Bike Ford Mondeo Blue Driving without Reasonable Consideration None Brinklow Road Brinklow Road Coventry Coventry Education N/A Yes - Via Email 52.4028059 -1.4461048
9989 op-snap---monthly-publication-january-2025.pdf   1097 2025-01 Car Ford Focus Silver Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Education N/A Yes - Via Email 52.3988977 -1.5323674
10224 op-snap---monthly-publication-january-2025.pdf   1332 2025-01 Pedal Bike Ford TRANSIT White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None JUBILEE CRESCENT Jubilee Crescent Coventry Coventry Education N/A Yes - Via Email 52.4307567 -1.5167147
10525 op-snap---monthly-publication-january-2025.pdf   1633 2025-01 Pedal Bike Ford TOURNEO Grey Driving without Reasonable Consideration None MITCHELL AVE Mitchell Ave Coventry Coventry Education N/A Yes - Via Email 52.3939553 -1.5697744

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