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

56 rows where council_area = "Birmingham", disposal = "Court" and vehicle_make = "BMW" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence

month 14

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

offence 8

  • Driving without Due Care and Attention 35
  • Contravening a Red Traffic Light 9
  • Stop a vehicle within pelican pedestrian crossing limits 3
  • Using a Mobile Phone Whilst Driving 3
  • Dangerous Driving 2
  • Driving without Reasonable Consideration 2
  • Cause vehicle to be left in a dangerous position 1
  • Vehicle overtake within crossing limits 1

reporter_transport_mode 4

  • Car 45
  • Pedal Bike 6
  • Pedestrian 4
  • Other 1

vehicle_make 1

  • BMW · 56 ✖

disposal 1

  • Court · 56 ✖

council_area 1

  • Birmingham · 56 ✖
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
8252 op-snap---monthly-publication-february-2026.pdf   999 2026-02 Car BMW S1000 XR Grey Driving without Due Care and Attention Contravening a Red Traffic Light Lichfield Road Lichfield Road Birmingham Birmingham Court N/A   52.5012458 -1.8780942
8516 op-snap---monthly-publication-february-2026.pdf   1263 2026-02 Car BMW 320I Black Driving without Due Care and Attention None Highfield Road Highfield Road Birmingham Birmingham Court N/A   52.4216321 -1.855984
8700 op-snap---monthly-publication-february-2026.pdf   1447 2026-02 Pedal Bike BMW 1 Series Blue Driving without Due Care and Attention None Dads Lane Dads Lane Birmingham Birmingham Court N/A   52.4375913 -1.9068522
11145 op-snap---monthly-publication-january-2026.pdf   606 2026-01 Car BMW M3 White Driving without Due Care and Attention Contravening a Red Traffic Light Linden Rd Linden Road Birmingham Birmingham Court N/A   52.4263156 -1.9351622
11396 op-snap---monthly-publication-january-2026.pdf   857 2026-01 Car BMW M4 Red Driving without Due Care and Attention No Insurance Holiday Street Holiday Street Birmingham Birmingham Court N/A   52.4757071 -1.8988573
5054 op-snap---monthly-publication-december-2025.pdf   1182 2025-12 Car BMW 330.. Grey Contravening a Red Traffic Light None Great Barr Interchange Great Barr Interchange Birmingham Birmingham Court N/A   52.544549 -1.9310678
20740 op-snap---monthly-publication-november-2025.pdf   282 2025-11 Car BMW 120d Black Driving without Due Care and Attention No Insurance Barnes Hill Barnes Hill Birmingham Birmingham Court N/A   52.4401325 -1.9785938
21673 op-snap---monthly-publication-november-2025.pdf   1215 2025-11 Car BMW 530 D Blue Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Court N/A      
21884 op-snap---monthly-publication-november-2025.pdf   1426 2025-11 Car BMW 118d Blue Driving without Due Care and Attention No Insurance Wharf Road Wharf Road Birmingham Birmingham Court N/A   52.4075531 -1.927329
22400 op-snap---monthly-publication-october-2025.pdf   350 2025-10 Pedal Bike BMW 335I Black Using a Mobile Phone Whilst Driving None Harbourne Road Harborne Road Birmingham Birmingham Court N/A   52.4718503 -1.9195423
23057 op-snap---monthly-publication-october-2025.pdf   1007 2025-10 Car BMW 118d White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Court N/A   52.4543565 -1.9114004
23908 op-snap---monthly-publication-september-2025.pdf   127 2025-09 Car BMW X3 Grey Driving without Due Care and Attention None Cartland Road Cartland Road Birmingham Birmingham Court N/A   52.4298554 -1.9086629
24009 op-snap---monthly-publication-september-2025.pdf   228 2025-09 Car BMW 5 series Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Court N/A   52.4167654 -1.9411244
24152 op-snap---monthly-publication-september-2025.pdf   371 2025-09 Car BMW 1 series Black Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Court N/A   52.4656414 -1.9852276
24799 op-snap---monthly-publication-september-2025.pdf   1018 2025-09 Car BMW 2 series Blue Vehicle overtake within crossing limits No Insurance Water Orton Road Water Orton Road Birmingham Birmingham Court N/A   52.5153394 -1.7573409
24818 op-snap---monthly-publication-september-2025.pdf   1037 2025-09 Car BMW 320D white Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Court N/A   52.470423 -1.9304786
24949 op-snap---monthly-publication-september-2025.pdf   1168 2025-09 Pedestrian BMW 335D Silver Driving without Due Care and Attention No vehicle excise licence Bishopsgate Street Bishopsgate Street Birmingham Birmingham Court N/A   52.473986 -1.9147087
2296 op-snap---monthly-publication-august-2025.pdf   271 2025-08 Car BMW 320D Blue Driving without Due Care and Attention None Springfield Road Springfield Road Birmingham Birmingham Court N/A   52.4327486 -1.8844997
2738 op-snap---monthly-publication-august-2025.pdf   713 2025-08 Car BMW 3 Series White Driving without Due Care and Attention No Insurance Bromford Lane Bromford Lane Birmingham Birmingham Court N/A   52.5083238 -1.8332287
3004 op-snap---monthly-publication-august-2025.pdf   979 2025-08 Car BMW M135I Grey Driving without Due Care and Attention None Lighthouse Avenue Lighthouse Avenue Birmingham Birmingham Court N/A      
12045 op-snap---monthly-publication-july-2025.pdf   97 2025-07 Car BMW 3 Series Blue Contravening a Red Traffic Light None Duddeston Mill Road Duddeston Mill Road Birmingham Birmingham Court N/A   52.4884042 -1.8688885
12049 op-snap---monthly-publication-july-2025.pdf   101 2025-07 Pedal Bike BMW 320d Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Court N/A   52.5292752 -1.7618805
12141 op-snap---monthly-publication-july-2025.pdf   193 2025-07 Car BMW M2 Blue Driving without Due Care and Attention None Kingshurst Way Kingshurst Way Birmingham Birmingham Court N/A      
12518 op-snap---monthly-publication-july-2025.pdf   570 2025-07 Car BMW 3 series Black Contravening a Red Traffic Light None Warwick Road Warwick Road Birmingham Birmingham Court N/A   52.4555288 -1.8613929
13203 op-snap---monthly-publication-july-2025.pdf   1255 2025-07 Car BMW M3 Blue Contravening a Red Traffic Light No Insurance New Johns Street West New Johns Street West Birmingham Birmingham Court N/A      
14204 op-snap---monthly-publication-june-2025.pdf   133 2025-06 Other BMW 116.. Black Driving without Due Care and Attention No Insurance Spouthouse Lane Spouthouse Lane Birmingham Birmingham Court N/A   52.5390972 -1.9319478
14751 op-snap---monthly-publication-june-2025.pdf   680 2025-06 Car BMW X6 Black Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
14797 op-snap---monthly-publication-june-2025.pdf   726 2025-06 Car BMW 330d Grey Driving without Due Care and Attention None Garretts Green Lane Garretts Green Lane Birmingham Birmingham Court N/A   52.4675802 -1.7905748
15142 op-snap---monthly-publication-june-2025.pdf   1071 2025-06 Car BMW 320D Silver Driving without Due Care and Attention None A5127 A5127 Birmingham Birmingham Court N/A      
15221 op-snap---monthly-publication-june-2025.pdf   1150 2025-06 Car BMW M2 Auto White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Court N/A   52.5359496 -1.8324115
15672 op-snap---monthly-publication-june-2025.pdf   1601 2025-06 Car BMW 320 Blue Driving without Reasonable Consideration No Insurance Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A   52.4929304 -1.8229092
18983 op-snap---monthly-publication-may-2025.pdf   345 2025-05 Car BMW 530.. Blue Driving without Due Care and Attention None Alum Rock Road Alum Rock Road Birmingham Birmingham Court N/A   52.4883936 -1.8310056
19211 op-snap---monthly-publication-may-2025.pdf   573 2025-05 Pedal Bike BMW 5 series Blue Driving without Due Care and Attention No Insurance Hagley Road Hagley Road Birmingham Birmingham Court N/A   52.471632 -1.9456776
19587 op-snap---monthly-publication-may-2025.pdf   949 2025-05 Car BMW M340 Grey Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham Court N/A   52.5170745 -1.9012542
19654 op-snap---monthly-publication-may-2025.pdf   1016 2025-05 Car BMW 116 Black Contravening a Red Traffic Light None WITTON ROAD Witton Road Birmingham Birmingham Court N/A   52.513336 -1.8833226
704 op-snap---monthly-publication-april-2025.pdf   703 2025-04 Car BMW 3 series Black Driving without Due Care and Attention None Aldridge Road Aldridge Road Birmingham Birmingham Court N/A   52.5368764 -1.8976461
16268 op-snap---monthly-publication-march-2025.pdf   25 2025-03 Car BMW 2 series White Contravening a Red Traffic Light Use vehicle on a road without valid test certificate Hagley Road Hagley Road Birmingham Birmingham Court N/A Yes - Via Email 52.471632 -1.9456776
16575 op-snap---monthly-publication-march-2025.pdf   332 2025-03 Car BMW 318 Black Driving without Due Care and Attention Use vehicle on a road without valid test certificate A45 Coventry Road Coventry Road Birmingham Birmingham Court N/A Yes - Via Email 52.4726661 -1.8769032
16984 op-snap---monthly-publication-march-2025.pdf   741 2025-03 Car BMW X3 Grey Contravening a Red Traffic Light No Insurance Brooklands Road Brooklands Road Birmingham Birmingham Court N/A Yes - Via Email 52.4368229 -1.8413396
17178 op-snap---monthly-publication-march-2025.pdf   935 2025-03 Car BMW X3 Grey Driving without Reasonable Consideration Use vehicle on a road without valid test certificate Priory Road Priory Road Birmingham Birmingham Court N/A Yes - Via Email 52.4132696 -1.8555008
17258 op-snap---monthly-publication-march-2025.pdf   1015 2025-03 Pedestrian BMW 218D White Stop a vehicle within pelican pedestrian crossing limits Use vehicle on a road without valid test certificate Dudley Road Dudley Road Birmingham Birmingham Court N/A Yes - Via Email 52.4865107 -1.9386263
17627 op-snap---monthly-publication-march-2025.pdf   1384 2025-03 Car BMW 3 SERIES Black Driving without Due Care and Attention No Insurance M42 NORTH M42 North Birmingham Birmingham Court N/A Yes - Via Email 52.5151103 -1.8501538
18051 op-snap---monthly-publication-march-2025.pdf   1808 2025-03 Car BMW 635.. White Driving without Due Care and Attention No Insurance Tessall Lane Tessall Lane Birmingham Birmingham Court N/A Yes - Via Email 52.4045186 -1.9891793
18246 op-snap---monthly-publication-march-2025.pdf   2003 2025-03 Car BMW 320d Grey Driving without Due Care and Attention None Cardigan Street Cardigan Street Birmingham Birmingham Court N/A Yes - Via Email 52.4849063 -1.8846609
5525 op-snap---monthly-publication-february-2025.pdf   342 2025-02 Pedestrian BMW 320D White Cause vehicle to be left in a dangerous position VRM fails to conform to Regulations Glenville Drive Glenville Drive Birmingham Birmingham Court N/A Yes - Via Email 52.5265939 -1.8509884
5544 op-snap---monthly-publication-february-2025.pdf   361 2025-02 Car BMW 320d Grey Stop a vehicle within pelican pedestrian crossing limits No Insurance Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A Yes - Via Email 52.4929304 -1.8229092
5583 op-snap---monthly-publication-february-2025.pdf   400 2025-02 Car BMW 118D Black Driving without Due Care and Attention None M6, Junction 6 M6, Junction 6 Birmingham Birmingham Court N/A Yes - Via Email 52.6760749 -2.0862582
6404 op-snap---monthly-publication-february-2025.pdf   1221 2025-02 Pedestrian BMW 218 Blue Using a Mobile Phone Whilst Driving Use vehicle on a road without valid test certificate Alcester Road Alcester Road Birmingham Birmingham Court N/A Yes - Via Email 52.4470686 -1.8880749
6475 op-snap---monthly-publication-february-2025.pdf   1292 2025-02 Car BMW 118d Black Stop a vehicle within pelican pedestrian crossing limits No Insurance Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A Yes - Via Email 52.4929304 -1.8229092
6523 op-snap---monthly-publication-february-2025.pdf   1340 2025-02 Car BMW 320D Black Driving without Due Care and Attention None A45 Coventry Road at Heybarnes Coventry Road at Heybarnes Birmingham Birmingham Court N/A Yes - Via Email 52.4513272 -1.7638967
7033 op-snap---monthly-publication-february-2025.pdf   1850 2025-02 Pedal Bike BMW 118 White Driving without Due Care and Attention None Dads Lane Dads Lane Birmingham Birmingham Court N/A Yes - Via Email 52.4375913 -1.9068522
7065 op-snap---monthly-publication-february-2025.pdf   1882 2025-02 Car BMW 320d Black Driving without Due Care and Attention None Gospel Lane Gospel Lane Birmingham Birmingham Court N/A Yes - Via Email 52.4412976 -1.8152918
9175 op-snap---monthly-publication-january-2025.pdf   283 2025-01 Pedal Bike BMW M2 Black Using a Mobile Phone Whilst Driving None Bristol Road, Edgbaston Bristol Road, Edgbaston Birmingham Birmingham Court N/A Yes - Via Email 52.4561817 -1.9097774
9888 op-snap---monthly-publication-january-2025.pdf   996 2025-01 Car BMW 320D Black Dangerous Driving None Egghill Lane Egghill Lane Birmingham Birmingham Court N/A Yes - Via Email 52.4093768 -1.9976236
10148 op-snap---monthly-publication-january-2025.pdf   1256 2025-01 Car BMW 320d White Driving without Due Care and Attention Contravening a Red Traffic Light Warwick Road Warwick Road Birmingham Birmingham Court N/A Yes - Via Email 52.4555288 -1.8613929
10376 op-snap---monthly-publication-january-2025.pdf   1484 2025-01 Car BMW 1 SERIES Black Dangerous Driving No Insurance COMMON LANE,SHELDON Common Lane, Sheldon Birmingham Birmingham Court N/A Yes - Via Email 52.4581998 -1.7809901

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