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

30 rows where month = "2025-05", offence = "Driving without Due Care and Attention" and vehicle_make = "Toyota" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

council_area 10

  • Birmingham 13
  • Wolverhampton 5
  • Coventry 3
  • Sandwell 3
  • Dudley 1
  • Ebtisrm Cinogrhnamer 1
  • Halesowen 1
  • Out of Force Area 1
  • Solihull 1
  • Walsall 1

disposal 5

  • NFA 14
  • Warning Letter 9
  • Court 3
  • Education 3
  • Fixed Penalty 1

reporter_transport_mode 4

  • Car 22
  • Pedal Bike 6
  • Lorry 1
  • car 1

vehicle_make 1

  • Toyota · 30 ✖

offence 1

  • Driving without Due Care and Attention · 30 ✖

month 1

  • 2025-05 · 30 ✖
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
18844 op-snap---monthly-publication-may-2025.pdf   206 2025-05 Car Toyota Prius White Driving without Due Care and Attention None Great Barr Interchange Great Barr Interchange Sandwell Sandwell NFA Outside of 14 Days NIP   52.5526943 -1.9321372
18858 op-snap---monthly-publication-may-2025.pdf   220 2025-05 Car Toyota Yaris White Driving without Due Care and Attention None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton Warning Letter N/A   52.5847884 -2.1341887
18984 op-snap---monthly-publication-may-2025.pdf   346 2025-05 Car Toyota PRIUS White Driving without Due Care and Attention None Tessall Lane Tessall Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4045186 -1.9891793
19018 op-snap---monthly-publication-may-2025.pdf   380 2025-05 Car Toyota Rav 4 Beige Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham NFA Outside of 14 Days NIP   52.4220705 -1.8372335
19034 op-snap---monthly-publication-may-2025.pdf   396 2025-05 Car Toyota Prius Silver Driving without Due Care and Attention No Insurance Holbrook Lane Holbrook Lane Coventry Coventry Fixed Penalty N/A   52.436155 -1.5064002
19043 op-snap---monthly-publication-may-2025.pdf   405 2025-05 Car Toyota AYGO Red Driving without Due Care and Attention None WHARF ROAD Wharf Road Halesowen Halesowen Court N/A   52.4571689 -1.8277656
19128 op-snap---monthly-publication-may-2025.pdf   490 2025-05 Pedal Bike Toyota Prius Red Driving without Due Care and Attention None Swarthmore Road Swarthmore Road Birmingham Birmingham Warning Letter N/A   52.4299657 -1.9599121
19175 op-snap---monthly-publication-may-2025.pdf   537 2025-05 Car Toyota Yaris Blue Driving without Due Care and Attention None Lode Lane at Warwick Road Lode Lane at Warwick Road Solihull Solihull NFA Outside of 14 Days NIP   52.4286691 -1.7775374
19421 op-snap---monthly-publication-may-2025.pdf   783 2025-05 Car Toyota Yaris Blue Driving without Due Care and Attention None M69 to M6 j2 nb M69 to M6 j2 nb Out of Force Area Out of Force Area NFA Out of Force      
19441 op-snap---monthly-publication-may-2025.pdf   803 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.430111 -1.9753703
19446 op-snap---monthly-publication-may-2025.pdf   808 2025-05 Car Toyota Prius White Driving without Due Care and Attention None Perry Hill Road Perry Hill Road Sandwell Sandwell Education N/A   52.4633031 -2.0036421
19458 op-snap---monthly-publication-may-2025.pdf   820 2025-05 Car Toyota auris Grey Driving without Due Care and Attention None Sandon Road Sandon Road Birmingham Birmingham Court N/A   52.4733908 -1.9577579
19502 op-snap---monthly-publication-may-2025.pdf   864 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Fairfax Street Fairfax Street Coventry Coventry NFA Outside of 14 Days NIP   52.4097547 -1.5065519
19544 op-snap---monthly-publication-may-2025.pdf   906 2025-05 car Toyota   White Driving without Due Care and Attention None SIR HENRY PARKES ROAD Sir Henry Parkes Road Coventry Coventry NFA No Offence   52.3900568 -1.5550766
19569 op-snap---monthly-publication-may-2025.pdf   931 2025-05 Lorry Toyota C-HR Red Driving without Due Care and Attention None Coseley Road island Coseley Road island Wolverhampton Wolverhampton Court N/A   52.5618304 -2.0826954
19579 op-snap---monthly-publication-may-2025.pdf   941 2025-05 Car Toyota Yaris Black Driving without Due Care and Attention None Garretts Green Lane Garretts Green Lane Birmingham Birmingham Warning Letter N/A   52.4675802 -1.7905748
19635 op-snap---monthly-publication-may-2025.pdf   997 2025-05 Car Toyota ESTIMA White Driving without Due Care and Attention None A45 SMALL HEATH HIGHWAY,PO A45 Small Heath Highway, Po EBTiSrm CinOgRhNamER Ebtisrm Cinogrhnamer Education N/A      
19665 op-snap---monthly-publication-may-2025.pdf   1027 2025-05 Pedal Bike Toyota   White Driving without Due Care and Attention None Station Road, Marston Green Station Road, Marston Green Birmingham Birmingham Education N/A      
19980 op-snap---monthly-publication-may-2025.pdf   1342 2025-05 Car Toyota Corolla Blue Driving without Due Care and Attention None Shutlock Lane/Avenue road jct Shutlock Lane/Avenue road jct Birmingham Birmingham NFA Outside of 14 Days NIP   52.4381927 -1.9042054
19997 op-snap---monthly-publication-may-2025.pdf   1359 2025-05 Car Toyota CRV Black Driving without Due Care and Attention None himley RD himley RD Dudley Dudley NFA Outside of 14 Days NIP   52.514621 -2.1318889
20072 op-snap---monthly-publication-may-2025.pdf   1434 2025-05 Car Toyota NP Red Driving without Due Care and Attention None JCT BEFORE SHORTLANDS LANE Jct Before Shortlands Lane Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
20100 op-snap---monthly-publication-may-2025.pdf   1462 2025-05 Car Toyota NP Blue Driving without Due Care and Attention None Dogpool Lane Dogpool Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4373055 -1.9126748
20148 op-snap---monthly-publication-may-2025.pdf   1510 2025-05 Pedal Bike Toyota corolla Silver Driving without Due Care and Attention None Cateswell Road Cateswell Road Birmingham Birmingham NFA Misc Inc Crimes   52.4387009 -1.8454267
20246 op-snap---monthly-publication-may-2025.pdf   1608 2025-05 Car Toyota Yaris Grey Driving without Due Care and Attention None Underhill Lane Underhill Lane Wolverhampton Wolverhampton Warning Letter N/A   52.6184526 -2.0954562
20249 op-snap---monthly-publication-may-2025.pdf   1611 2025-05 Car Toyota MPV White Driving without Due Care and Attention None Covnetry Road Covnetry Road Birmingham Birmingham Warning Letter N/A      
20257 op-snap---monthly-publication-may-2025.pdf   1619 2025-05 Car Toyota Estima White Driving without Due Care and Attention None sutton rd Sutton Rd Birmingham Birmingham Warning Letter N/A   52.5346721 -1.827743
20374 op-snap---monthly-publication-may-2025.pdf   1736 2025-05 Car Toyota Estima Silver Driving without Due Care and Attention None All Saints Way All Saints Way Sandwell Sandwell Warning Letter N/A   52.5344405 -1.985568
20385 op-snap---monthly-publication-may-2025.pdf   1747 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention none Heath Road Heath Road Walsall Walsall Warning Letter N/A   52.5736792 -2.0223376
20399 op-snap---monthly-publication-may-2025.pdf   1761 2025-05 Car Toyota     Driving without Due Care and Attention None Teddesley Road Teddesley Road Wolverhampton Wolverhampton NFA No VRM      
20408 op-snap---monthly-publication-may-2025.pdf   1770 2025-05 Car Toyota Prius Silver Driving without Due Care and Attention None Bordesley Circus Bordesley Circus Birmingham Birmingham Warning Letter N/A   52.4728608 -1.8754722

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