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

44 rows where month = "2025-05", offence = "Misc - Non Traffic Offences" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make 18

  • Audi 6
  • Mercedes-Benz 5
  • BMW 4
  • Volkswagen 4
  • Ford 2
  • Vauxhall 2
  • Citroen 1
  • Daf 1
  • Honda 1
  • Hyundai 1
  • Iveco 1
  • Land Rover 1
  • Mazda 1
  • Mg 1
  • Nissan 1
  • Peugeot 1
  • Seat 1
  • Toyota 1

council_area 10

  • Birmingham 21
  • Out of Force Area 5
  • Coventry 3
  • Sandwell 3
  • Sutton Coldfield 3
  • Walsall 3
  • Dudley 2
  • Solihull 2
  • Optuotn Of Force Area 1
  • Wolverhampton 1

disposal 3

  • NFA 39
  • Other Action Taken 4
  • RTC - Actioned 1

reporter_transport_mode 1

  • Car · 44 ✖

offence 1

  • Misc - Non Traffic Offences · 44 ✖

month 1

  • 2025-05 · 44 ✖
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
18648 op-snap---monthly-publication-may-2025.pdf   10 2025-05 Car Audi A3.. Black Misc - Non Traffic Offences None A452 A452 Birmingham Birmingham NFA No Offence      
18660 op-snap---monthly-publication-may-2025.pdf   22 2025-05 Car Toyota Aygo Blue Misc - Non Traffic Offences None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Offence   52.5113867 -1.8337258
18662 op-snap---monthly-publication-may-2025.pdf   24 2025-05 Car Vauxhall Corsa Black Misc - Non Traffic Offences None Middleton Road Middleton Road Birmingham Birmingham NFA Misc Inc Crimes   52.4294291 -1.8905762
18714 op-snap---monthly-publication-may-2025.pdf   76 2025-05 Car Honda Insight Silver Misc - Non Traffic Offences None M6 NB J9 M6 Northbound J9 Walsall Walsall Other Action Taken nN/A   52.676119 -2.0858425
18728 op-snap---monthly-publication-may-2025.pdf   90 2025-05 Car Audi A3.. Black Misc - Non Traffic Offences None A452 A452 Birmingham Birmingham NFA No Offence      
18763 op-snap---monthly-publication-may-2025.pdf   125 2025-05 Car       Misc - Non Traffic Offences None Penns Lane Penns Lane Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5356148 -1.8191361
18808 op-snap---monthly-publication-may-2025.pdf   170 2025-05 Car Seat Ibiza White Misc - Non Traffic Offences Littering Stream Road Stream Road Dudley Dudley NFA Outside of 14 Days NIP   52.4871725 -2.1623764
18816 op-snap---monthly-publication-may-2025.pdf   178 2025-05 Car Audi A3 Blue Misc - Non Traffic Offences None Short Heath Road Short Heath Road Birmingham Birmingham NFA No VRM   52.5302344 -1.8505439
18822 op-snap---monthly-publication-may-2025.pdf   184 2025-05 Car Iveco HGV White Misc - Non Traffic Offences None M6 South M6 South Walsall Walsall NFA Not in Public Interest   52.6170728 -2.030393
18972 op-snap---monthly-publication-may-2025.pdf   334 2025-05 Car Volkswagen Golf Black Misc - Non Traffic Offences None Heath Road South Heath Road South Birmingham Birmingham NFA Not in Public Interest   52.415858 -1.9632649
19017 op-snap---monthly-publication-may-2025.pdf   379 2025-05 Car Mercedes-Benz C300 Green Misc - Non Traffic Offences None Collingwood Drive Collingwood Drive Birmingham Birmingham Other Action Taken nN/A      
19020 op-snap---monthly-publication-may-2025.pdf   382 2025-05 Car Citroen Relay White Misc - Non Traffic Offences None Startford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
19021 op-snap---monthly-publication-may-2025.pdf   383 2025-05 Car Mg ZS Red Misc - Non Traffic Offences None Alder Road Shifnal Alder Road Shifnal Out of Force Area Out of Force Area NFA Out of Force      
19029 op-snap---monthly-publication-may-2025.pdf   391 2025-05 Car Ford Sierra Grey Misc - Non Traffic Offences None Caffeine and Machine A422 Northam Caffeine and Machine A422 Northam Optuotn of Force Area Optuotn Of Force Area NFA Out of Force      
19070 op-snap---monthly-publication-may-2025.pdf   432 2025-05 Car BMW 520D GREY Misc - Non Traffic Offences None BARBEL DRIVE Barbel Drive Wolverhampton Wolverhampton NFA No Offence   52.5948801 -2.096089
19141 op-snap---monthly-publication-may-2025.pdf   503 2025-05 Car Nissan Micra Red Misc - Non Traffic Offences None Kenpas Highway Kenpas Highway Coventry Coventry NFA Misc Inc Crimes   52.3833661 -1.5265665
19144 op-snap---monthly-publication-may-2025.pdf   506 2025-05 Car Volkswagen Golf Black Misc - Non Traffic Offences None Cockshed Lane Cockshed Lane Sandwell Sandwell NFA No Offence      
19184 op-snap---monthly-publication-may-2025.pdf   546 2025-05 Car Mazda CX-5 Grey Misc - Non Traffic Offences None Moseley Road Moseley Road Birmingham Birmingham NFA No Offence   52.4679402 -1.881408
19185 op-snap---monthly-publication-may-2025.pdf   547 2025-05 Car Audi S4 Grey Misc - Non Traffic Offences None Merry Hill Car Park Merry Hill Car Park Sandwell Sandwell NFA No Offence      
19317 op-snap---monthly-publication-may-2025.pdf   679 2025-05 Car BMW M4 White Misc - Non Traffic Offences None Dickenheaths Dickenheaths Solihull Solihull NFA No Independent Evidence Available      
19323 op-snap---monthly-publication-may-2025.pdf   685 2025-05 Car Daf   White Misc - Non Traffic Offences None Snow Hill Snow Hill Birmingham Birmingham RTC - Actioned N/A   52.4825769 -1.897234
19373 op-snap---monthly-publication-may-2025.pdf   735 2025-05 Car Audi A5 Grey Misc - Non Traffic Offences None A38 A38 Birmingham Birmingham Other Action Taken nN/A      
19408 op-snap---monthly-publication-may-2025.pdf   770 2025-05 Car Volkswagen Tiguan White Misc - Non Traffic Offences None car park Car Park Birmingham Birmingham NFA No Offence   52.4778907 -1.8996453
19420 op-snap---monthly-publication-may-2025.pdf   782 2025-05 Car Land Rover Range Rover Brown Misc - Non Traffic Offences None M42 junction 6/7 M42 junction 6/7 Birmingham Birmingham NFA No Offence      
19430 op-snap---monthly-publication-may-2025.pdf   792 2025-05 Car   Scooter Blue Misc - Non Traffic Offences None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Other Action Taken nN/A   52.5940902 -1.843503
19478 op-snap---monthly-publication-may-2025.pdf   840 2025-05 Car   bike   Misc - Non Traffic Offences None Telford Telford Out of Force Area Out of Force Area NFA No Offence   52.4979333 -1.9664857
19581 op-snap---monthly-publication-may-2025.pdf   943 2025-05 Car Mercedes-Benz Sprinter White Misc - Non Traffic Offences None Load Lane Load Lane Birmingham Birmingham NFA No Offence      
19586 op-snap---monthly-publication-may-2025.pdf   948 2025-05 Car       Misc - Non Traffic Offences None Near Connon Hill Park Near Connon Hill Park Birmingham Birmingham NFA No Independent Evidence Available      
19701 op-snap---monthly-publication-may-2025.pdf   1063 2025-05 Car Vauxhall Meriva Grey Misc - Non Traffic Offences None Little Park Street Little Park Street Coventry Coventry NFA No Independent Evidence Available   52.4051331 -1.5085642
19707 op-snap---monthly-publication-may-2025.pdf   1069 2025-05 Car BMW 320.. Blue Misc - Non Traffic Offences None Belgrave Middleway Belgrave Middleway Birmingham Birmingham NFA No Offence   52.4668753 -1.8996143
19742 op-snap---monthly-publication-may-2025.pdf   1104 2025-05 Car Hyundai i40 White Misc - Non Traffic Offences None A452 A452 Sutton Coldfield Sutton Coldfield NFA No Offence      
19744 op-snap---monthly-publication-may-2025.pdf   1106 2025-05 Car Volkswagen Polo Black Misc - Non Traffic Offences None A44, West mercia A44, West mercia Out of Force Area Out of Force Area NFA Out of Force      
19760 op-snap---monthly-publication-may-2025.pdf   1122 2025-05 Car   UK Blue Misc - Non Traffic Offences None Wotton Road Wotton Road Birmingham Birmingham NFA No VRM      
19780 op-snap---monthly-publication-may-2025.pdf   1142 2025-05 Car Mercedes-Benz GLC Black Misc - Non Traffic Offences None COLEBANK ROAD Colebank Road Birmingham Birmingham NFA Misc Inc Crimes      
19844 op-snap---monthly-publication-may-2025.pdf   1206 2025-05 Car Audi A3 Silver Misc - Non Traffic Offences None A5 Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
19866 op-snap---monthly-publication-may-2025.pdf   1228 2025-05 Car Mercedes-Benz E220 Grey Misc - Non Traffic Offences None Harnell Lane Harnell Lane Coventry Coventry NFA Misc Inc Crimes      
20167 op-snap---monthly-publication-may-2025.pdf   1529 2025-05 Car       Misc - Non Traffic Offences None Kent Street Kent Street Birmingham Birmingham NFA No Independent Evidence Available   52.4717099 -1.897463
20216 op-snap---monthly-publication-may-2025.pdf   1578 2025-05 Car       Misc - Non Traffic Offences None Tansley Hill Avenue Tansley Hill Avenue Dudley Dudley NFA No Offence   52.5052608 -2.0631275
20291 op-snap---monthly-publication-may-2025.pdf   1653 2025-05 Car       Misc - Non Traffic Offences None M5 M5 Sandwell Sandwell NFA Misc Inc Crimes      
20301 op-snap---monthly-publication-may-2025.pdf   1663 2025-05 Car BMW 1 series Grey Misc - Non Traffic Offences None Coles Lane Coles Lane Birmingham Birmingham NFA No Offence   52.5557121 -1.8191693
20307 op-snap---monthly-publication-may-2025.pdf   1669 2025-05 Car Mercedes-Benz A180 Red Misc - Non Traffic Offences None Wood Lane Wood Lane Solihull Solihull NFA No VRM   52.4018937 -1.7126088
20393 op-snap---monthly-publication-may-2025.pdf   1755 2025-05 Car Peugeot Expert Black Misc - Non Traffic Offences None Bosty Lane Bosty Lane Walsall Walsall NFA No Offence   52.5948329 -1.927787
20432 op-snap---monthly-publication-may-2025.pdf   1794 2025-05 Car Ford Fiesta Red Misc - Non Traffic Offences None Lichfield Road Lichfield Road Birmingham Birmingham NFA Not in Public Interest   52.5012458 -1.8780942
20452 op-snap---monthly-publication-may-2025.pdf   1814 2025-05 Car       Misc - Non Traffic Offences None Market Drayton Market Drayton Out of Force Area Out of Force Area NFA Misc Inc Crimes      

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