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

47 rows where offence = "Driving without Due Care and Attention", reporter_transport_mode = "Car" and vehicle_make = "Fiat" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

month 12

  • 2025-08 7
  • 2025-05 6
  • 2026-01 6
  • 2025-03 5
  • 2025-11 5
  • 2025-06 4
  • 2025-02 3
  • 2025-10 3
  • 2026-02 3
  • 2025-07 2
  • 2025-09 2
  • 2025-01 1

council_area 9

  • Birmingham 18
  • Coventry 6
  • Out of Force Area 6
  • Sandwell 4
  • Walsall 4
  • Wolverhampton 4
  • Dudley 2
  • Solihull 2
  • Sutton Coldfield 1

disposal 7

  • NFA 16
  • Education 14
  • Warning Letter 7
  • Fixed Penalty 4
  • Court 3
  • Other Action Taken 2
  • RTC - Actioned 1

vehicle_make 1

  • Fiat · 47 ✖

reporter_transport_mode 1

  • Car · 47 ✖

offence 1

  • Driving without Due Care and Attention · 47 ✖
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
7450 op-snap---monthly-publication-february-2026.pdf   197 2026-02 Car Fiat 500 Blue Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Walsall Walsall NFA     52.5867763 -2.0104342
7503 op-snap---monthly-publication-february-2026.pdf   250 2026-02 Car Fiat 500 White Driving without Due Care and Attention None M54 Motorway, jn4 M54 Motorway, jn4 Out of Force Area Out of Force Area NFA Out of Force      
8762 op-snap---monthly-publication-february-2026.pdf   1509 2026-02 Car Fiat Panda White Driving without Due Care and Attention None Raddlebarn Road Raddlebarn Road Birmingham Birmingham Education N/A   52.4397168 -1.9260414
10982 op-snap---monthly-publication-january-2026.pdf   443 2026-01 Car Fiat 500L White Driving without Due Care and Attention None Wylde Green Road Wylde Green Road Sutton Coldfield Sutton Coldfield Education N/A   52.546976 -1.8098124
11040 op-snap---monthly-publication-january-2026.pdf   501 2026-01 Car Fiat Ducato White Driving without Due Care and Attention None Bushwood Road Bushwood Road Birmingham Birmingham RTC - Actioned N/A   52.4369115 -1.9584265
11122 op-snap---monthly-publication-january-2026.pdf   583 2026-01 Car Fiat Ducato White Driving without Due Care and Attention None M5 Jct 1 M5 Junction 1 Sandwell Sandwell Warning Letter N/A      
11554 op-snap---monthly-publication-january-2026.pdf   1015 2026-01 Car Fiat Abarth Grey Driving without Due Care and Attention None Edgbaston Road Edgbaston Road Birmingham Birmingham Warning Letter N/A   52.4552785 -1.906384
11701 op-snap---monthly-publication-january-2026.pdf   1162 2026-01 Car Fiat Punto Black Driving without Due Care and Attention None A38M A38M Birmingham Birmingham Warning Letter N/A      
11739 op-snap---monthly-publication-january-2026.pdf   1200 2026-01 Car Fiat Grande Blue Driving without Due Care and Attention None Westgate Westgate Walsall Walsall Education N/A   52.6053205 -1.9378711
20631 op-snap---monthly-publication-november-2025.pdf   173 2025-11 Car Fiat 500.. Green Driving without Due Care and Attention None No exact location other than Redditch near Sainsburys No exact location other than Redditch near Sainsburys Out of Force Area Out of Force Area NFA Out of Force      
20856 op-snap---monthly-publication-november-2025.pdf   398 2025-11 Car Fiat Ducato White Driving without Due Care and Attention None Jockey Road Jockey Road Birmingham Birmingham Education N/A   52.5512291 -1.8357776
21383 op-snap---monthly-publication-november-2025.pdf   925 2025-11 Car Fiat Panda White Driving without Due Care and Attention None Bentley Road South Bentley Road South Wolverhampton Wolverhampton Fixed Penalty N/A      
21394 op-snap---monthly-publication-november-2025.pdf   936 2025-11 Car Fiat Punto White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
21396 op-snap---monthly-publication-november-2025.pdf   938 2025-11 Car Fiat Ducato White Driving without Due Care and Attention None Forest Ego, Bromsgrove Forest Ego, Bromsgrove Out of Force Area Out of Force Area NFA Out of Force      
22119 op-snap---monthly-publication-october-2025.pdf   69 2025-10 Car Fiat Panda White Driving without Due Care and Attention None Knighton Road Knighton Road Birmingham Birmingham Education N/A   52.5982705 -1.8541228
22611 op-snap---monthly-publication-october-2025.pdf   561 2025-10 Car Fiat Punto White Driving without Due Care and Attention No Insurance Danford Lane Danford Lane Solihull Solihull Other Action Taken N/A   52.4092804 -1.8056214
22803 op-snap---monthly-publication-october-2025.pdf   753 2025-10 Car Fiat   Green Driving without Due Care and Attention None Cheadle Road Cheadle Road Out of Force Area Out of Force Area NFA Out of Force   52.4493915 -1.4804335
24043 op-snap---monthly-publication-september-2025.pdf   262 2025-09 Car Fiat 500 White Driving without Due Care and Attention None Sutton Road Sutton Road Walsall Walsall Court N/A   52.5612988 -2.0522715
24588 op-snap---monthly-publication-september-2025.pdf   807 2025-09 Car Fiat 500 White Driving without Due Care and Attention None Clifford Bridge Road Clifford Bridge Road Coventry Coventry NFA No Independent Evidence Available   52.4134557 -1.4442138
2074 op-snap---monthly-publication-august-2025.pdf   49 2025-08 Car Fiat Scudo Grey Driving without Due Care and Attention None Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
2314 op-snap---monthly-publication-august-2025.pdf   289 2025-08 Car Fiat Tipo Grey Driving without Due Care and Attention None Gravelly Hill Gravelly Hill Birmingham Birmingham Education N/A   52.5153884 -1.8527437
2460 op-snap---monthly-publication-august-2025.pdf   435 2025-08 Car Fiat 500 Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
2626 op-snap---monthly-publication-august-2025.pdf   601 2025-08 Car Fiat 500 Black Driving without Due Care and Attention None Startford rd Startford rd Solihull Solihull NFA Outside of 14 Days NIP      
2649 op-snap---monthly-publication-august-2025.pdf   624 2025-08 Car Fiat Ducato White Driving without Due Care and Attention None A40 Monmouth Monmouth Out of Force Are Out of Force Area NFA Out of Force      
2745 op-snap---monthly-publication-august-2025.pdf   720 2025-08 Car Fiat Doblo Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Fixed Penalty N/A   52.5359496 -1.8324115
3136 op-snap---monthly-publication-august-2025.pdf   1111 2025-08 Car Fiat Pando Grey Driving without Due Care and Attention None Poplar Road Poplar Road Birmingham Birmingham Education N/A   52.436035 -1.891685
12443 op-snap---monthly-publication-july-2025.pdf   495 2025-07 Car Fiat 500 L Black Driving without Due Care and Attention None Garratts Lane Garratts Lane Sandwell Sandwell Education N/A   52.4783554 -2.0611589
13575 op-snap---monthly-publication-july-2025.pdf   1627 2025-07 Car Fiat Fiorino White Driving without Due Care and Attention None Chantry Crescent Chantry Crescent Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.5725056 -2.0611908
14345 op-snap---monthly-publication-june-2025.pdf   274 2025-06 Car Fiat Punto Blue Driving without Due Care and Attention None Prologis Park Prologis Park Coventry Coventry NFA No Offence   52.4552589 -1.5260803
14487 op-snap---monthly-publication-june-2025.pdf   416 2025-06 Car Fiat Panda Red Driving without Due Care and Attention None Bromford Road Bromford Road Birmingham Birmingham Education N/A   52.503036 -1.8289972
14686 op-snap---monthly-publication-june-2025.pdf   615 2025-06 Car Fiat 500... Red Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry NFA No Independent Evidence Available   52.4047134 -1.5351834
14690 op-snap---monthly-publication-june-2025.pdf   619 2025-06 Car Fiat Punto White Driving without Due Care and Attention None Scimitar Way Scimitar Way Coventry Coventry Court N/A   52.3836203 -1.4862458
19471 op-snap---monthly-publication-may-2025.pdf   833 2025-05 Car Fiat Ducato recovery White Driving without Due Care and Attention None M5 motorway M5 motorway Sandwell Sandwell NFA No Offence   52.5368223 -1.96752
19628 op-snap---monthly-publication-may-2025.pdf   990 2025-05 Car Fiat Panda White Driving without Due Care and Attention None Lancaster Circus Queensway Lancaster Circus Queensway Birmingham Birmingham Education N/A   52.4862571 -1.8928621
19648 op-snap---monthly-publication-may-2025.pdf   1010 2025-05 Car Fiat Punto Blue Driving without Due Care and Attention None A4040 Vicarage Road Vicarage Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.470423 -1.9304786
19829 op-snap---monthly-publication-may-2025.pdf   1191 2025-05 Car Fiat Punto White Driving without Due Care and Attention None Jct 7 Cov ring road Junction 7 Cov ring road Coventry Coventry NFA Outside of 14 DAYS Late Submission      
20274 op-snap---monthly-publication-may-2025.pdf   1636 2025-05 Car Fiat 500 Orange Driving without Due Care and Attention None Chapel Ash Chapel Ash Wolverhampton Wolverhampton Warning Letter N/A   52.5857494 -2.1409393
20445 op-snap---monthly-publication-may-2025.pdf   1807 2025-05 Car Fiat 500 White Driving without Due Care and Attention None Stephenson Avenue Stephenson Avenue Walsall Walsall Warning Letter N/A   52.6031501 -2.0117279
16310 op-snap---monthly-publication-march-2025.pdf   67 2025-03 Car Fiat 500 Black Driving without Due Care and Attention None Roughill Drive Roughill Drive Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16937 op-snap---monthly-publication-march-2025.pdf   694 2025-03 Car Fiat 500 E Gold Driving without Due Care and Attention None Himley Road, Dudley Himley Road, Dudley Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5142667 -2.1304764
17214 op-snap---monthly-publication-march-2025.pdf   971 2025-03 Car Fiat Punto Red Driving without Due Care and Attention None A45 Small Heath Bypass Small Heath Bypass Birmingham Birmingham Education N/A Yes - Via Email    
17322 op-snap---monthly-publication-march-2025.pdf   1079 2025-03 Car Fiat Panda Red Driving without Due Care and Attention None Great Bridge Street Great Bridge Street Sandwell Sandwell Other Action Taken N/A Yes - Via Email 52.5292014 -2.0306229
18299 op-snap---monthly-publication-march-2025.pdf   2056 2025-03 Car Fiat 124 White Driving without Due Care and Attention None ASTON UNIVERSITY Aston University Birmingham Birmingham Education N/A Yes - Via Email 52.4861905 -1.8884689
5271 op-snap---monthly-publication-february-2025.pdf   88 2025-02 Car Fiat 500 Black Driving without Due Care and Attention None Mackadown Lane Mackadown Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4708415 -1.7675939
5858 op-snap---monthly-publication-february-2025.pdf   675 2025-02 Car Fiat 500 White Driving without Due Care and Attention None Russel Road Russel Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4297153 -1.934958
6135 op-snap---monthly-publication-february-2025.pdf   952 2025-02 Car Fiat Tipo Silver Driving without Due Care and Attention None A45, Fletchamstead Highway A45, Fletchamstead Highway Coventry Coventry Warning Letter N/A Yes - Via Email 52.3971823 -1.5564772
10001 op-snap---monthly-publication-january-2025.pdf   1109 2025-01 Car Fiat Punto Grey Driving without Due Care and Attention No Insurance Parkfield Road Parkfield Road Wolverhampton Wolverhampton Court N/A Yes - Via Email 52.567016 -2.1208485

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