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 month = "2025-12", 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, latitude, longitude

vehicle_make 20

  • BMW 4
  • Mercedes-Benz 4
  • Peugeot 4
  • Volkswagen 4
  • Audi 3
  • Ford 3
  • Porsche 3
  • Vauxhall 3
  • Fiat 2
  • Honda 2
  • Jaguar 2
  • Renault 2
  • Hyundai 1
  • Jeep 1
  • Kia 1
  • Seat 1
  • Skoda 1
  • Toyota 1
  • Volvo 1
  • Yamaha 1

council_area 9

  • Birmingham 17
  • Out of Force Area 9
  • Sandwell 8
  • Dudley 4
  • Wolverhampton 4
  • Sutton Coldfield 2
  • Coventry 1
  • Solihull 1
  • Walsall 1

disposal 6

  • NFA 32
  • Warning Letter 10
  • RTC - Actioned 2
  • Court 1
  • Fixed Penalty 1
  • Other Action Taken 1

reporter_transport_mode 1

  • Car · 47 ✖

offence 1

  • Misc - Non Traffic Offences · 47 ✖

month 1

  • 2025-12 · 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
3900 op-snap---monthly-publication-december-2025.pdf   28 2025-12 Car Fiat 500 White Misc - Non Traffic Offences None M5, worcestershire M5, worcestershire Out of Force Area Out of Force Area NFA No VRM   52.432364 -2.0176127
3965 op-snap---monthly-publication-december-2025.pdf   93 2025-12 Car Audi q3 Black Misc - Non Traffic Offences None huntingtree road Huntingtree Road Dudley Dudley NFA No Independent Evidence Available   52.4484682 -2.0689885
4024 op-snap---monthly-publication-december-2025.pdf   152 2025-12 Car Audi A3 Grey Misc - Non Traffic Offences None Holloway Bank Holloway Bank Sandwell Sandwell RTC - Actioned N/A   52.5430345 -2.0152621
4063 op-snap---monthly-publication-december-2025.pdf   191 2025-12 Car Jeep Renegade White Misc - Non Traffic Offences None A4040 Island Road Island Road Sandwell Sandwell NFA No Offence   52.4634433 -1.9965278
4123 op-snap---monthly-publication-december-2025.pdf   251 2025-12 Car Honda Civic Grey Misc - Non Traffic Offences None Maple Tree Lane Maple Tree Lane Sandwell Sandwell Warning Letter N/A      
4127 op-snap---monthly-publication-december-2025.pdf   255 2025-12 Car Volkswagen Golf Grey Misc - Non Traffic Offences None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
4173 op-snap---monthly-publication-december-2025.pdf   301 2025-12 Car Ford Transit Blue Misc - Non Traffic Offences None Wednesbury Oak Road Wednesbury Oak Road Sandwell Sandwell NFA No Offence   52.5461405 -2.0536516
4310 op-snap---monthly-publication-december-2025.pdf   438 2025-12 Car Jaguar XF Silver Misc - Non Traffic Offences None A4040 Island Road Island Road Sandwell Sandwell NFA Not in Public Interest   52.4634433 -1.9965278
4317 op-snap---monthly-publication-december-2025.pdf   445 2025-12 Car BMW 1 series White Misc - Non Traffic Offences None Burnt Tree Burnt Tree Dudley Dudley NFA No Independent Evidence Available   52.513767 -2.0633163
4325 op-snap---monthly-publication-december-2025.pdf   453 2025-12 Car Yamaha 125 Grey Misc - Non Traffic Offences None A38 (M) A38 (M) Birmingham Birmingham Court N/A   52.5096656 -1.8611835
4373 op-snap---monthly-publication-december-2025.pdf   501 2025-12 Car       Misc - Non Traffic Offences None penn road Penn Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.5599616 -2.1556338
4461 op-snap---monthly-publication-december-2025.pdf   589 2025-12 Car Mercedes-Benz   White Misc - Non Traffic Offences None OOF- Shrewsbury OOF- Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
4481 op-snap---monthly-publication-december-2025.pdf   609 2025-12 Car Toyota Corolla Blue Misc - Non Traffic Offences None M5 West Mercia M5 West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4483 op-snap---monthly-publication-december-2025.pdf   611 2025-12 Car Volkswagen Tiguan Grey Misc - Non Traffic Offences None A45 A45 Birmingham Birmingham NFA No Independent Evidence Available      
4495 op-snap---monthly-publication-december-2025.pdf   623 2025-12 Car Fiat   Grey Misc - Non Traffic Offences None OOF Warwickshire OOF Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
4509 op-snap---monthly-publication-december-2025.pdf   637 2025-12 Car Vauxhall corsa Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
4534 op-snap---monthly-publication-december-2025.pdf   662 2025-12 Car Vauxhall Corsa Blue Misc - Non Traffic Offences None Lickey Lane West Mercia Lickey Lane West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4562 op-snap---monthly-publication-december-2025.pdf   690 2025-12 Car BMW 3 series Silver Misc - Non Traffic Offences None dudley road Dudley Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.5717314 -2.1249182
4565 op-snap---monthly-publication-december-2025.pdf   693 2025-12 Car Audi   White Misc - Non Traffic Offences None boldmere road Boldmere Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.548309 -1.8411769
4566 op-snap---monthly-publication-december-2025.pdf   694 2025-12 Car Jaguar epace White Misc - Non Traffic Offences None boldmere road Boldmere Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.548309 -1.8411769
4594 op-snap---monthly-publication-december-2025.pdf   722 2025-12 Car       Misc - Non Traffic Offences None startford road Stratford Road Birmingham Birmingham NFA Misc Inc Crimes   52.4203897 -1.8338574
4596 op-snap---monthly-publication-december-2025.pdf   724 2025-12 Car Volvo xc90 Grey Misc - Non Traffic Offences None birchfield road Birchfield Road Birmingham Birmingham NFA Misc Inc Crimes   52.5170745 -1.9012542
4627 op-snap---monthly-publication-december-2025.pdf   755 2025-12 Car Honda Civic Grey Misc - Non Traffic Offences None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
4683 op-snap---monthly-publication-december-2025.pdf   811 2025-12 Car Volkswagen Polo Black Misc - Non Traffic Offences None Garretts Green Lane Garretts Green Lane Birmingham Birmingham NFA No Offence   52.4675802 -1.7905748
4703 op-snap---monthly-publication-december-2025.pdf   831 2025-12 Car Peugeot boxer Silver Misc - Non Traffic Offences None court street Court Street Dudley Dudley NFA Misc Inc Crimes   52.455056 -2.1443561
4714 op-snap---monthly-publication-december-2025.pdf   842 2025-12 Car BMW 840i Red Misc - Non Traffic Offences None B6049 Hope, Sheffield Hope, Sheffield Out of Force Area Out of Force Area NFA Out of Force      
4737 op-snap---monthly-publication-december-2025.pdf   865 2025-12 Car Peugeot Allure Black Misc - Non Traffic Offences None Leicester Row Leicester Row Coventry Coventry NFA No Independent Evidence Available   52.414317 -1.5104573
4768 op-snap---monthly-publication-december-2025.pdf   896 2025-12 Car Volkswagen TAIGO Green Misc - Non Traffic Offences None sainsburys castle vale Sainsburys Castle Vale Birmingham Birmingham NFA No Independent Evidence Available   52.5168269 -1.7940387
4823 op-snap---monthly-publication-december-2025.pdf   951 2025-12 Car Hyundai Ioniq Black Misc - Non Traffic Offences None Alridge Road Aldridge Road Birmingham Birmingham NFA No Offence   52.5368764 -1.8976461
4824 op-snap---monthly-publication-december-2025.pdf   952 2025-12 Car Vauxhall Vivaro Blue Misc - Non Traffic Offences None Startford Road Stratford Road Birmingham Birmingham NFA No VRM   52.4203897 -1.8338574
4844 op-snap---monthly-publication-december-2025.pdf   972 2025-12 Car   Scooter Grey Misc - Non Traffic Offences None Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force   52.4047807 -2.0101216
4857 op-snap---monthly-publication-december-2025.pdf   985 2025-12 Car BMW 320i Grey Misc - Non Traffic Offences None M5 jn1 M5 jn1 Sandwell Sandwell NFA No Offence      
4874 op-snap---monthly-publication-december-2025.pdf   1002 2025-12 Car Renault Captur Black Misc - Non Traffic Offences Use vehicle on a road withou tI lvsaalnidd tReosat dc ertificate t I lvsaalnidd t Reosat dc ertificate Birmingham Birmingham Fixed Penalty N/A      
4875 op-snap---monthly-publication-december-2025.pdf   1003 2025-12 Car Mercedes-Benz Sprinter White Misc - Non Traffic Offences None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
4890 op-snap---monthly-publication-december-2025.pdf   1018 2025-12 Car Renault Megane Blue Misc - Non Traffic Offences None Lauderdale Gardens Lauderdale Gardens Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6283075 -2.1143864
4893 op-snap---monthly-publication-december-2025.pdf   1021 2025-12 Car Seat Leon Black Misc - Non Traffic Offences none A4040 Island Road Island Road Birmingham Birmingham NFA Misc Inc Crimes   52.5095686 -1.9544485
4914 op-snap---monthly-publication-december-2025.pdf   1042 2025-12 Car Skoda Kodiaq Grey Misc - Non Traffic Offences None Dudley Dudley Dudley Dudley RTC - Actioned Misc Inc Crimes   52.5110832 -2.0816813
4946 op-snap---monthly-publication-december-2025.pdf   1074 2025-12 Car Peugeot 3008 Red Misc - Non Traffic Offences None A4040 A4040 Sandwell Sandwell Warning Letter N/A      
4947 op-snap---monthly-publication-december-2025.pdf   1075 2025-12 Car Porsche Cayenne Silver Misc - Non Traffic Offences None A4040 A4040 Sandwell Sandwell Warning Letter N/A      
4951 op-snap---monthly-publication-december-2025.pdf   1079 2025-12 Car Porsche taycan Blue Misc - Non Traffic Offences None broadway west Broadway West Walsall Walsall NFA Misc Inc Crimes   52.5698309 -1.9942176
4960 op-snap---monthly-publication-december-2025.pdf   1088 2025-12 Car Porsche Cayenne Silver Misc - Non Traffic Offences None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
4995 op-snap---monthly-publication-december-2025.pdf   1123 2025-12 Car Peugeot 107 Black Misc - Non Traffic Offences None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
5028 op-snap---monthly-publication-december-2025.pdf   1156 2025-12 Car Mercedes-Benz na Black Misc - Non Traffic Offences None blosomfield road Blosomfield Road Solihull Solihull NFA No VRM      
5084 op-snap---monthly-publication-december-2025.pdf   1212 2025-12 Car Kia Ceed White Misc - Non Traffic Offences None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
5107 op-snap---monthly-publication-december-2025.pdf   1235 2025-12 Car Mercedes-Benz C Class White Misc - Non Traffic Offences None Warwick Warwick Out of Force Area Out of Force Area NFA Out of Force   52.3813073 -1.5639569
5118 op-snap---monthly-publication-december-2025.pdf   1246 2025-12 Car Ford Kuga Blue Misc - Non Traffic Offences None Waterloo Road Waterloo Road Wolverhampton Wolverhampton Warning Letter No Offence   52.5960155 -2.1295068
5167 op-snap---monthly-publication-december-2025.pdf   1295 2025-12 Car Ford Fiesta White Misc - Non Traffic Offences None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Other Action Taken Misc Inc Crimes   52.4804926 -1.8563658

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