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

48 rows where council_area = "Birmingham", offence = "Misc - Non Traffic Offences" and reporter_transport_mode = "Other" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale

vehicle_make 14

  • Ford 8
  • BMW 7
  • Audi 4
  • Vauxhall 4
  • Volkswagen 3
  • Land Rover 2
  • Skoda 2
  • Hyundai 1
  • Kia 1
  • Mercedes-Benz 1
  • Nissan 1
  • Peugeot 1
  • Seat 1
  • Toyota 1

month 14

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

disposal 4

  • NFA 33
  • Other Action Taken 10
  • Warning Letter 3
  • RTC - Actioned 2

reporter_transport_mode 1

  • Other · 48 ✖

offence 1

  • Misc - Non Traffic Offences · 48 ✖

council_area 1

  • Birmingham · 48 ✖
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
7306 op-snap---monthly-publication-february-2026.pdf   53 2026-02 Other Audi A1 Blue Misc - Non Traffic Offences None UK Uk Birmingham Birmingham Other Action Taken N/A   52.45124 -1.937937
7584 op-snap---monthly-publication-february-2026.pdf   331 2026-02 Other Nissan Xtrail Orange Misc - Non Traffic Offences None Unett Street Unett Street Birmingham Birmingham NFA No Offence   52.4921149 -1.9071925
7880 op-snap---monthly-publication-february-2026.pdf   627 2026-02 Other Skoda Kodiaq White Misc - Non Traffic Offences None Welhead Road Welhead Road Birmingham Birmingham NFA No Offence      
7881 op-snap---monthly-publication-february-2026.pdf   628 2026-02 Other   multiple   Misc - Non Traffic Offences None Perry Barr Village Perry Barr Village Birmingham Birmingham NFA No Offence   52.5243314 -1.8819868
8117 op-snap---monthly-publication-february-2026.pdf   864 2026-02 Other BMW 525d Silver Misc - Non Traffic Offences None Spring Road Spring Road Birmingham Birmingham Other Action Taken N/A   52.444262 -1.8362585
8120 op-snap---monthly-publication-february-2026.pdf   867 2026-02 Other BMW 220.. Grey Misc - Non Traffic Offences None Spring Road Spring Road Birmingham Birmingham Other Action Taken N/A   52.444262 -1.8362585
8356 op-snap---monthly-publication-february-2026.pdf   1103 2026-02 Other Ford Fiesta Blue Misc - Non Traffic Offences None Star City Star City Birmingham Birmingham NFA No Offence   52.5054363 -1.8556273
10632 op-snap---monthly-publication-january-2026.pdf   93 2026-01 Other Vauxhall Meriva White Misc - Non Traffic Offences None The Oak Walk The Oak Walk Birmingham Birmingham RTC - Actioned N/A   52.4020485 -1.9696265
10692 op-snap---monthly-publication-january-2026.pdf   153 2026-01 Other BMW X3.. White Misc - Non Traffic Offences None Canal Court Canal Court Birmingham Birmingham Warning Letter N/A   52.4486586 -1.8085554
10849 op-snap---monthly-publication-january-2026.pdf   310 2026-01 Other   Unknown VRM   Misc - Non Traffic Offences None Kingstanding Circle Kingstanding Circle Birmingham Birmingham NFA No VRM   52.5536651 -1.8826944
11902 op-snap---monthly-publication-january-2026.pdf   1363 2026-01 Other Ford Transit Grey Misc - Non Traffic Offences None ladywood Ladywood Birmingham Birmingham NFA Misc Inc Crimes   52.4774932 -1.9233654
4178 op-snap---monthly-publication-december-2025.pdf   306 2025-12 Other Ford focus Black Misc - Non Traffic Offences None Arundel Road Arundel Road Birmingham Birmingham NFA No Offence   52.4032204 -1.8821733
4274 op-snap---monthly-publication-december-2025.pdf   402 2025-12 Other Audi a4 Blue Misc - Non Traffic Offences None a45 small heath highway A45 Small Heath Highway Birmingham Birmingham Warning Letter N/A   52.4601838 -1.8488291
4437 op-snap---monthly-publication-december-2025.pdf   565 2025-12 Other Volkswagen     Misc - Non Traffic Offences None edmund road Edmund Road Birmingham Birmingham NFA Misc Inc Crimes   52.4876113 -1.8542201
4536 op-snap---monthly-publication-december-2025.pdf   664 2025-12 Other Peugeot 208 White Misc - Non Traffic Offences None Merlin Grove Merlin Grove Birmingham Birmingham NFA No Offence   52.4578935 -1.7820619
21689 op-snap---monthly-publication-november-2025.pdf   1231 2025-11 Other       Misc - Non Traffic Offences None poplar avenue Poplar Avenue Birmingham Birmingham NFA Misc Inc Crimes   52.5723052 -1.8003041
22043 op-snap---monthly-publication-november-2025.pdf   1585 2025-11 Other Toyota Estima Silver Misc - Non Traffic Offences None Haden Circus Rounabout Haden Circus Rounabout Birmingham Birmingham Other Action Taken N/A      
22178 op-snap---monthly-publication-october-2025.pdf   128 2025-10 Other Volkswagen N/K Black Misc - Non Traffic Offences None N/K N/K Birmingham Birmingham NFA No Independent Evidence Available   52.5684524 -1.879732
22671 op-snap---monthly-publication-october-2025.pdf   621 2025-10 Other Ford minibus White Misc - Non Traffic Offences None Whittington Oval, Stechford Whittington Oval, Stechford Birmingham Birmingham NFA No Offence   52.4800782 -1.7942034
23311 op-snap---monthly-publication-october-2025.pdf   1261 2025-10 Other Volkswagen golf Red Misc - Non Traffic Offences None Grove Avenue Grove Avenue Birmingham Birmingham NFA Misc Inc Crimes   52.4422494 -1.8820898
24091 op-snap---monthly-publication-september-2025.pdf   310 2025-09 Other Skoda Octavia Grey Misc - Non Traffic Offences None Metchley Lane Metchley Lane Birmingham Birmingham NFA Not in Public Interest   52.4552055 -1.9461279
24092 op-snap---monthly-publication-september-2025.pdf   311 2025-09 Other Land Rover Discovery Black Misc - Non Traffic Offences None Metchley Lane Metchley Lane Birmingham Birmingham NFA Not in Public Interest   52.4552055 -1.9461279
24254 op-snap---monthly-publication-september-2025.pdf   473 2025-09 Other   Cycle   Misc - Non Traffic Offences None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
24298 op-snap---monthly-publication-september-2025.pdf   517 2025-09 Other Mercedes-Benz Vito Black Misc - Non Traffic Offences None Russell Road by Cannon Hill Park Russell Road by Cannon Hill Park Birmingham Birmingham NFA No Offence      
2077 op-snap---monthly-publication-august-2025.pdf   52 2025-08 Other   N/K   Misc - Non Traffic Offences None Holiday Street Holiday Street Birmingham Birmingham NFA No Independent Evidence Available   52.4757071 -1.8988573
2180 op-snap---monthly-publication-august-2025.pdf   155 2025-08 Other Audi R 3 Blue Misc - Non Traffic Offences None Arden Road Arden Road Birmingham Birmingham Other Action Taken N/A   52.4515759 -1.8296192
2223 op-snap---monthly-publication-august-2025.pdf   198 2025-08 Other Ford S Max Blue Misc - Non Traffic Offences None Fosbrooke Road Fosbrooke Road Birmingham Birmingham NFA Not in Public Interest   52.4700545 -1.834436
2683 op-snap---monthly-publication-august-2025.pdf   658 2025-08 Other BMW 3 Series Blue Misc - Non Traffic Offences None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
3066 op-snap---monthly-publication-august-2025.pdf   1041 2025-08 Other Ford Fiesta Silver Misc - Non Traffic Offences No Insurance Baltimore Road Baltimore Road Birmingham Birmingham NFA No Offence   52.5286702 -1.9241545
12149 op-snap---monthly-publication-july-2025.pdf   201 2025-07 Other   NP   Misc - Non Traffic Offences No Insurance Unknown   Birmingham Birmingham NFA No Independent Evidence Available      
12165 op-snap---monthly-publication-july-2025.pdf   217 2025-07 Other BMW 3 series Black Misc - Non Traffic Offences None A38 A38 Birmingham Birmingham NFA No Independent Evidence Available      
12571 op-snap---monthly-publication-july-2025.pdf   623 2025-07 Other BMW 4 series Grey Misc - Non Traffic Offences None A45 Coventry Road Coventry Road Birmingham Birmingham NFA No Offence   52.4726661 -1.8769032
13414 op-snap---monthly-publication-july-2025.pdf   1466 2025-07 Other Ford fiesta Blue Misc - Non Traffic Offences None Davey Road Davey Road Birmingham Birmingham NFA Misc Inc Crimes   52.5110968 -1.8943621
14127 op-snap---monthly-publication-june-2025.pdf   56 2025-06 Other Seat Leon Blue Misc - Non Traffic Offences None Parkhouse Drive Parkhouse Drive Birmingham Birmingham Other Action Taken N/A   52.5293532 -1.8756263
14320 op-snap---monthly-publication-june-2025.pdf   249 2025-06 Other       Misc - Non Traffic Offences None Smethwick Smethwick Birmingham Birmingham Other Action Taken N/A   52.4827749 -1.9586724
14567 op-snap---monthly-publication-june-2025.pdf   496 2025-06 Other Audi SQ7 Silver Misc - Non Traffic Offences None Church Lane Church Lane Birmingham Birmingham Other Action Taken N/A   52.5030217 -1.8764632
14871 op-snap---monthly-publication-june-2025.pdf   800 2025-06 Other Ford Transit Blue Misc - Non Traffic Offences None Slade Road Slade Road Birmingham Birmingham RTC - Actioned N/A   52.5894461 -1.8082962
15292 op-snap---monthly-publication-june-2025.pdf   1221 2025-06 Other       Misc - Non Traffic Offences None Unknown   Birmingham Birmingham NFA Misc Inc Crimes      
15378 op-snap---monthly-publication-june-2025.pdf   1307 2025-06 Other BMW 325D Black Misc - Non Traffic Offences None Heather Road Heather Road Birmingham Birmingham NFA No Offence   52.4699812 -1.841443
18761 op-snap---monthly-publication-may-2025.pdf   123 2025-05 Other Vauxhall Grandland Orange Misc - Non Traffic Offences None Metchley Lane QE Hospiital Metchley Lane QE Hospiital Birmingham Birmingham NFA No Offence      
20108 op-snap---monthly-publication-may-2025.pdf   1470 2025-05 Other Vauxhall Astra Grey Misc - Non Traffic Offences None 48 Willow Avenue 48 Willow Avenue Birmingham Birmingham NFA Outside of 14 Days NIP   52.4792236 -1.9652858
669 op-snap---monthly-publication-april-2025.pdf   668 2025-04 Other Kia Ceed Orange Misc - Non Traffic Offences None England England Birmingham Birmingham NFA Misc Inc Crimes   52.4882696 -1.9143495
1629 op-snap---monthly-publication-april-2025.pdf   1628 2025-04 Other Vauxhall Astra White Misc - Non Traffic Offences None 120 lindsworth road 120 Lindsworth Road Birmingham Birmingham NFA No Offence   52.41339 -1.9128473
16933 op-snap---monthly-publication-march-2025.pdf   690 2025-03 Other Hyundai Ix35 Grey Misc - Non Traffic Offences None Bradshaw Avenue Bradshaw Avenue Birmingham Birmingham NFA No Offence Yes - Via Email 52.4018255 -1.9490522
16986 op-snap---monthly-publication-march-2025.pdf   743 2025-03 Other       Misc - Non Traffic Offences None Beacon Road Beacon Road Birmingham Birmingham Other Action Taken N/A Yes - Via Email 52.545172 -1.836877
18589 op-snap---monthly-publication-march-2025.pdf   2346 2025-03 Other       Misc - Non Traffic Offences None kendrick way Kendrick Way Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email    
6173 op-snap---monthly-publication-february-2025.pdf   990 2025-02 Other Land Rover Range Rover Black Misc - Non Traffic Offences None Glenville Drive Glenville Drive Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5265939 -1.8509884
9677 op-snap---monthly-publication-january-2025.pdf   785 2025-01 Other       Misc - Non Traffic Offences None Southfield Avenue Southfield Avenue Birmingham Birmingham Other Action Taken eNn/A Yes - Via Email 52.4833844 -1.9484535

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