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

41 rows where disposal = "Warning Letter", month = "2025-01" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, council_area_raw, nfa_rationale, latitude, longitude

vehicle_make 18

  • BMW 6
  • Audi 4
  • Ford 4
  • Mercedes-Benz 4
  • Vauxhall 4
  • Toyota 3
  • Kia 2
  • Seat 2
  • Volkswagen 2
  • Daf 1
  • Honda 1
  • Jaguar 1
  • Mini 1
  • Peugeot 1
  • Renault 1
  • Skoda 1
  • Suzuki 1
  • Yamaha 1

council_area 6

  • Birmingham 25
  • Dudley 8
  • Walsall 3
  • Sandwell 2
  • Solihull 2
  • Coventry 1

reporter_transport_mode 5

  • Car 32
  • Pedestrian 6
  • Bus 1
  • Pedal Bike 1
  • car 1

offence 1

  • Driving without Due Care and Attention · 41 ✖

month 1

  • 2025-01 · 41 ✖

disposal 1

  • Warning Letter · 41 ✖
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
8898 op-snap---monthly-publication-january-2025.pdf   6 2025-01 Car BMW 7 Series White Driving without Due Care and Attention None M6 Motorway near 10a Southbound M6 Motorway near 10a Southbound Walsall Walsall Warning Letter N/A Yes - Via Email    
8930 op-snap---monthly-publication-january-2025.pdf   38 2025-01 Car Audi s3 Blue Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
8943 op-snap---monthly-publication-january-2025.pdf   51 2025-01 Car Volkswagen Golf Blue Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4203897 -1.8338574
8976 op-snap---monthly-publication-january-2025.pdf   84 2025-01 Car Renault Clio Blue Driving without Due Care and Attention None Alma Street Alma Street Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.5546385 -2.0062935
8977 op-snap---monthly-publication-january-2025.pdf   85 2025-01 Pedestrian Ford Fiesta Grey Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9001 op-snap---monthly-publication-january-2025.pdf   109 2025-01 Bus Daf bus Blue Driving without Due Care and Attention None Summer Row Summer Row Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4813439 -1.9074798
9011 op-snap---monthly-publication-january-2025.pdf   119 2025-01 Car BMW X5 Blue Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9120 op-snap---monthly-publication-january-2025.pdf   228 2025-01 Car Toyota Yaris black Driving without Due Care and Attention None Chester Road North Chester Road North Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.548449 -1.8594603
9125 op-snap---monthly-publication-january-2025.pdf   233 2025-01 Car Mini Cooper Blue Driving without Due Care and Attention None Water Orton Road Water Orton Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5153394 -1.7573409
9143 op-snap---monthly-publication-january-2025.pdf   251 2025-01 Car Kia Ceed Blue Driving without Due Care and Attention None Victoria St, Stourbridge Victoria Street, Stourbridge Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9186 op-snap---monthly-publication-january-2025.pdf   294 2025-01 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Six Ways Lozells Six Ways Lozells Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.502463 -1.8995194
9226 op-snap---monthly-publication-january-2025.pdf   334 2025-01 Car Seat Arona Black Driving without Due Care and Attention None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4865107 -1.9386263
9233 op-snap---monthly-publication-january-2025.pdf   341 2025-01 Car Peugeot Allure Red Driving without Due Care and Attention None Worcester Street roundabout Worcester Street roundabout Dudley Dudley Warning Letter N/A Yes - Via Email    
9250 op-snap---monthly-publication-january-2025.pdf   358 2025-01 Pedestrian Vauxhall Corsa Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9251 op-snap---monthly-publication-january-2025.pdf   359 2025-01 Pedestrian Vauxhall Corsa Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9252 op-snap---monthly-publication-january-2025.pdf   360 2025-01 Pedestrian Ford Fiesta Grey Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9253 op-snap---monthly-publication-january-2025.pdf   361 2025-01 Pedestrian BMW 118 Red Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9254 op-snap---monthly-publication-january-2025.pdf   362 2025-01 Pedestrian Skoda Citigo Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9267 op-snap---monthly-publication-january-2025.pdf   375 2025-01 Car Ford Transit Blue Driving without Due Care and Attention None Genners lane Genners lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4282602 -1.9861769
9352 op-snap---monthly-publication-january-2025.pdf   460 2025-01 Car BMW 330D Black Driving without Due Care and Attention None Hollybank Road Hollybank Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4236341 -1.8787502
9363 op-snap---monthly-publication-january-2025.pdf   471 2025-01 car Volkswagen POLO Blue Driving without Due Care and Attention None SIX WAYS ROUNDABOUT,ASTON Six Ways Roundabout, Aston Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9368 op-snap---monthly-publication-january-2025.pdf   476 2025-01 Car Mercedes-Benz A-180 Black Driving without Due Care and Attention None Saltley Viaduct Saltley Viaduct Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4920836 -1.8619149
9408 op-snap---monthly-publication-january-2025.pdf   516 2025-01 Car Yamaha YS 125 Red Driving without Due Care and Attention None High Street, Kingswinford High Street, Kingswinford Dudley Dudley Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4975687 -2.1672039
9448 op-snap---monthly-publication-january-2025.pdf   556 2025-01 Car Mercedes-Benz A180 Red Driving without Due Care and Attention None BROADWAY Broadway Walsall Walsall Warning Letter N/A Yes - Via Email 52.5719937 -1.9639882
9527 op-snap---monthly-publication-january-2025.pdf   635 2025-01 Car Jaguar XJ Grey Driving without Due Care and Attention None Seven Star Road Seven Star Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.420978 -1.7767887
9643 op-snap---monthly-publication-january-2025.pdf   751 2025-01 Car Honda CRV Black Driving without Due Care and Attention None Tyburn Rd, Erdington Tyburn Road, Erdington Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5089926 -1.8468653
9650 op-snap---monthly-publication-january-2025.pdf   758 2025-01 Car Audi A3 Grey Driving without Due Care and Attention None A4040 Stechford Lane Stechford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4930549 -1.8179571
9692 op-snap---monthly-publication-january-2025.pdf   800 2025-01 Car Mercedes-Benz A250 Grey Driving without Due Care and Attention None Sandwell Road Sandwell Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5082522 -1.9487918
10109 op-snap---monthly-publication-january-2025.pdf   1217 2025-01 Car Vauxhall G LAND Black Driving without Due Care and Attention None BOLDMERE ROAD Boldmere Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.548309 -1.8411769
10144 op-snap---monthly-publication-january-2025.pdf   1252 2025-01 Car Seat Ibiza Red Driving without Due Care and Attention None Sewall Highway Sewall Highway Coventry Coventry Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4318623 -1.4804069
10152 op-snap---monthly-publication-january-2025.pdf   1260 2025-01 Car   FORTUNO Black Driving without Due Care and Attention None LADYWOOD MIDDLEWAY Ladywood Middleway Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.473883 -1.9198244
10153 op-snap---monthly-publication-january-2025.pdf   1261 2025-01 Car Ford FOCUS Black Driving without Due Care and Attention None NEW TOWN ROW New Town Row Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4896513 -1.8947514
10208 op-snap---monthly-publication-january-2025.pdf   1316 2025-01 Car Audi Q3 Grey Driving without Due Care and Attention None Aldridge Road, Birmingham Aldridge Road, Birmingham Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5269511 -1.897032
10276 op-snap---monthly-publication-january-2025.pdf   1384 2025-01 Car BMW 1 series Black Driving without Due Care and Attention None A34 Walsall Rd Walsall Road Walsall Walsall Warning Letter N/A Yes - Via Email 52.6166864 -1.9660822
10357 op-snap---monthly-publication-january-2025.pdf   1465 2025-01 Pedal Bike Kia ceed Grey Driving without Due Care and Attention None Warwick Rd Warwick Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.4428606 -1.812114
10361 op-snap---monthly-publication-january-2025.pdf   1469 2025-01 Car Suzuki Swift Grey Driving without Due Care and Attention None Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.502683 -1.9033516
10387 op-snap---monthly-publication-january-2025.pdf   1495 2025-01 Car Audi A3 White Driving without Due Care and Attention None Alcester Road, Moseley Alcester Road, Moseley Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4445135 -1.8907323
10476 op-snap---monthly-publication-january-2025.pdf   1584 2025-01 Car Toyota Corolla Grey Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.5083238 -1.8332287
10481 op-snap---monthly-publication-january-2025.pdf   1589 2025-01 Car Toyota Prius White Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4103191 -1.8670224
10529 op-snap---monthly-publication-january-2025.pdf   1637 2025-01 Car BMW 318Ci Silver Driving without Due Care and Attention None M5 SB J1 M5 Southbound J1 Sandwell Sandwell Warning Letter N/A Yes - Via Email    
10535 op-snap---monthly-publication-january-2025.pdf   1643 2025-01 Car Vauxhall Corsa Black Driving without Due Care and Attention None Cotterills Lane Cotterills Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4884297 -1.817811

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