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

52 rows where disposal = "Warning Letter", reporter_transport_mode = "Pedestrian" and vehicle_make = "Renault" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_model, vehicle_colour, second_offence, council_area_raw, nfa_rationale

month 13

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

offence 9

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 21
  • Cause vehicle to be left in a dangerous position 14
  • Contravening a Red Traffic Light 6
  • Stop a vehicle within pelican pedestrian crossing limits 3
  • /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 2
  • Cause unnecessary obstruction by motor vehicle 2
  • Driving without Due Care and Attention 2
  • / trailer outside of the Greater London area 1
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq 1

council_area 7

  • Birmingham 33
  • Wolverhampton 7
  • Dudley 4
  • Sandwell 3
  • Solihull 2
  • Walsall 2
  • Hbeiramthingham 1

vehicle_make 1

  • Renault · 52 ✖

reporter_transport_mode 1

  • Pedestrian · 52 ✖

disposal 1

  • Warning Letter · 52 ✖
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
7961 op-snap---monthly-publication-february-2026.pdf   708 2026-02 Pedestrian Renault Zoe White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Springfield Road Springfield Road Birmingham Birmingham Warning Letter N/A   52.4327486 -1.8844997
11645 op-snap---monthly-publication-january-2026.pdf   1106 2026-01 Pedestrian Renault Clio Orange Contravening a Red Traffic Light None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A   52.471632 -1.9456776
3962 op-snap---monthly-publication-december-2025.pdf   90 2025-12 Pedestrian Renault Captur Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Huntingree road Huntingree road Dudley Dudley Warning Letter N/A      
4132 op-snap---monthly-publication-december-2025.pdf   260 2025-12 Pedestrian Renault Captur Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Petersfield Road Petersfield Road Birmingham Birmingham Warning Letter N/A   52.4307 -1.8494663
4517 op-snap---monthly-publication-december-2025.pdf   645 2025-12 Pedestrian Renault traffic Silver Stop a vehicle within pelican pedestrian crossing limits None regent road Regent Road Birmingham Birmingham Warning Letter N/A   52.5077359 -1.9452509
4589 op-snap---monthly-publication-december-2025.pdf   717 2025-12 Pedestrian Renault Clio Black Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq Nuiopnmeent Rosebery Road, Cape Hill Rosebery Road, Cape Hill Sandwell Sandwell Warning Letter N/A   52.4878382 -1.9570553
5036 op-snap---monthly-publication-december-2025.pdf   1164 2025-12 Pedestrian Renault clio black Cause vehicle to be left in a dangerous position None wattville road Wattville Road Birmingham Birmingham Warning Letter N/A   52.5063926 -1.9548648
20974 op-snap---monthly-publication-november-2025.pdf   516 2025-11 Pedestrian Renault scenic Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Knowle Knowle Solihull Solihull Warning Letter N/A   52.3932659 -1.738959
21211 op-snap---monthly-publication-november-2025.pdf   753 2025-11 Pedestrian Renault Master White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wentworth Road Wentworth Road Birmingham Birmingham Warning Letter N/A   52.5773229 -1.8324449
21284 op-snap---monthly-publication-november-2025.pdf   826 2025-11 Pedestrian Renault master White Cause vehicle to be left in a dangerous position None wentworth road Wentworth Road Birmingham Birmingham Warning Letter N/A   52.5773229 -1.8324449
21358 op-snap---monthly-publication-november-2025.pdf   900 2025-11 Pedestrian Renault megane blue Cause vehicle to be left in a dangerous position None the oval The Oval Birmingham Birmingham Warning Letter N/A   52.4577754 -1.8692099
21536 op-snap---monthly-publication-november-2025.pdf   1078 2025-11 Pedestrian Renault traffic White Cause vehicle to be left in a dangerous position None startford road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
21746 op-snap---monthly-publication-november-2025.pdf   1288 2025-11 Pedestrian Renault traffic Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lawrense lane Lawrense Lane Dudley Dudley Warning Letter N/A      
21747 op-snap---monthly-publication-november-2025.pdf   1289 2025-11 Pedestrian Renault traffic White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None ash street Ash Street Dudley Dudley Warning Letter N/A   52.6194553 -1.9924281
21941 op-snap---monthly-publication-november-2025.pdf   1483 2025-11 Pedestrian Renault megane Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None castle bromwhich Castle Bromwhich Birmingham Birmingham Warning Letter N/A      
23506 op-snap---monthly-publication-october-2025.pdf   1456 2025-10 Pedestrian Renault clio Red Cause vehicle to be left in a dangerous position None yorkmead road Yorkmead Road Birmingham Birmingham Warning Letter N/A   52.4408494 -1.846394
23520 op-snap---monthly-publication-october-2025.pdf   1470 2025-10 Pedestrian Renault clio Grey Cause vehicle to be left in a dangerous position None york road York Road Birmingham Birmingham Warning Letter N/A   52.5231321 -1.8415573
23638 op-snap---monthly-publication-october-2025.pdf   1588 2025-10 Pedestrian Renault   Blue Cause vehicle to be left in a dangerous position None Rathborne Road Rathborne Road Sandwell Sandwell Warning Letter N/A      
24739 op-snap---monthly-publication-september-2025.pdf   958 2025-09 Pedestrian Renault Scenic Brown Contravening a Red Traffic Light None Bushbury Rd / Cannock Rd Bushbury Road / Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.5988194 -2.1026037
24759 op-snap---monthly-publication-september-2025.pdf   978 2025-09 Pedestrian Renault Clio Black Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
24872 op-snap---monthly-publication-september-2025.pdf   1091 2025-09 Pedestrian Renault Clio Silver Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
25132 op-snap---monthly-publication-september-2025.pdf   1351 2025-09 Pedestrian Renault Clio Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Wyrely road Wyrely road Birmingham Birmingham Warning Letter N/A      
25148 op-snap---monthly-publication-september-2025.pdf   1367 2025-09 Pedestrian Renault megane Gold Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area ashdale drive Ashdale Drive Birmingham Birmingham Warning Letter N/A   52.4027335 -1.876125
25177 op-snap---monthly-publication-september-2025.pdf   1396 2025-09 Pedestrian Renault Trafic Grey Driving without Due Care and Attention None CLay Lane CLay Lane Birmingham Birmingham Warning Letter N/A   52.4509038 -1.8083784
25512 op-snap---monthly-publication-september-2025.pdf   1731 2025-09 Pedestrian Renault Clio Silver /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle None Goldthorn Crescent Goldthorn Crescent Wolverhampton Wolverhampton Warning Letter N/A   52.5668793 -2.1416656
25514 op-snap---monthly-publication-september-2025.pdf   1733 2025-09 Pedestrian Renault Kadjar Red / trailer outside of the Greater London area None Cambridge Road Cambridge Road Birmingham Birmingham Warning Letter N/A   52.4368662 -1.8846451
25549 op-snap---monthly-publication-september-2025.pdf   1768 2025-09 Pedestrian Renault Clio Red /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle None High St High Street Wolverhampton Wolverhampton Warning Letter N/A   52.5635963 -2.0827567
3532 op-snap---monthly-publication-august-2025.pdf   1507 2025-08 Pedestrian Renault Trucks White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Norton Road Norton Road Birmingham Birmingham Warning Letter N/A   52.426389 -1.9036435
3708 op-snap---monthly-publication-august-2025.pdf   1683 2025-08 Pedestrian Renault   Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barnsley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
3714 op-snap---monthly-publication-august-2025.pdf   1689 2025-08 Pedestrian Renault   Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Tower Hill Tower Hill Birmingham Birmingham Warning Letter N/A   52.5335541 -1.9186098
3800 op-snap---monthly-publication-august-2025.pdf   1775 2025-08 Pedestrian Renault Megane Grey Cause vehicle to be left in a dangerous position None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
13154 op-snap---monthly-publication-july-2025.pdf   1206 2025-07 Pedestrian Renault   White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road , Wahswood Washwood Heath Road , Wahswood HBeiramthingham Hbeiramthingham Warning Letter N/A      
13372 op-snap---monthly-publication-july-2025.pdf   1424 2025-07 Pedestrian Renault Captur Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lincoln Road Lincoln Road Birmingham Birmingham Warning Letter N/A   52.4438344 -1.810878
13428 op-snap---monthly-publication-july-2025.pdf   1480 2025-07 Pedestrian Renault capture Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Appleton Avenue Appleton Avenue Birmingham Birmingham Warning Letter N/A      
13440 op-snap---monthly-publication-july-2025.pdf   1492 2025-07 Pedestrian Renault Clio Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Glen Rise Glen Rise Birmingham Birmingham Warning Letter N/A   52.425244 -1.8620426
13596 op-snap---monthly-publication-july-2025.pdf   1648 2025-07 Pedestrian Renault CLIO Red Cause vehicle to be left in a dangerous position None Warwick Road Warwick Road Solihull Solihull Warning Letter N/A   52.4428606 -1.812114
13616 op-snap---monthly-publication-july-2025.pdf   1668 2025-07 Pedestrian Renault Gscenic Beige Cause vehicle to be left in a dangerous position None Barnsley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
13623 op-snap---monthly-publication-july-2025.pdf   1675 2025-07 Pedestrian Renault master White Cause vehicle to be left in a dangerous position None Reform Street Reform Street Birmingham Birmingham Warning Letter N/A      
13822 op-snap---monthly-publication-july-2025.pdf   1874 2025-07 Pedestrian Renault Captur Grey Cause vehicle to be left in a dangerous position None Jews Lane Jews Lane Dudley Dudley Warning Letter N/A   52.5253568 -2.1128168
13933 op-snap---monthly-publication-july-2025.pdf   1985 2025-07 Pedestrian Renault Traffic Black Cause vehicle to be left in a dangerous position None Victoria Street Victoria Street Birmingham Birmingham Warning Letter N/A   52.4751651 -1.8559775
14543 op-snap---monthly-publication-june-2025.pdf   472 2025-06 Pedestrian Renault Clio Silver Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Warning Letter N/A   52.6068849 -1.9611652
14605 op-snap---monthly-publication-june-2025.pdf   534 2025-06 Pedestrian Renault Megane Silver Stop a vehicle within pelican pedestrian crossing limits None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A   52.4865107 -1.9386263
15870 op-snap---monthly-publication-june-2025.pdf   1799 2025-06 Pedestrian Renault Megane Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Probert Road Probert Road Wolverhampton Wolverhampton Warning Letter N/A   52.6167619 -2.138419
20128 op-snap---monthly-publication-may-2025.pdf   1490 2025-05 Pedestrian Renault scenic Blue Driving without Due Care and Attention None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
17737 op-snap---monthly-publication-march-2025.pdf   1494 2025-03 Pedestrian Renault CLIO Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Knightlow Road Knightlow Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4684561 -1.9608907
18573 op-snap---monthly-publication-march-2025.pdf   2330 2025-03 Pedestrian Renault Master Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Denham Road Denham Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4546002 -1.8251291
6164 op-snap---monthly-publication-february-2025.pdf   981 2025-02 Pedestrian Renault Austral Grey Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5265939 -1.8509884
6198 op-snap---monthly-publication-february-2025.pdf   1015 2025-02 Pedestrian Renault Kadjar Blue Contravening a Red Traffic Light None     Walsall Walsall Warning Letter N/A Yes - Via Email    
6445 op-snap---monthly-publication-february-2025.pdf   1262 2025-02 Pedestrian Renault Megane Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Sabell Road Sabell Road Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.4969597 -1.9779396
6669 op-snap---monthly-publication-february-2025.pdf   1486 2025-02 Pedestrian Renault Clio Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bordley Green East Bordley Green East Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9315 op-snap---monthly-publication-january-2025.pdf   423 2025-01 Pedestrian Renault Megane White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rock Road Rock Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.490221 -1.8551892
10298 op-snap---monthly-publication-january-2025.pdf   1406 2025-01 Pedestrian Renault Megan Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4470686 -1.8880749

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