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

71 rows where disposal = "Court" and month = "2025-08" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw

vehicle_make 22

  • Vauxhall 11
  • Audi 8
  • BMW 7
  • Honda 6
  • Mercedes-Benz 6
  • Volkswagen 5
  • Ford 4
  • Peugeot 4
  • Toyota 4
  • Land Rover 2
  • Seat 2
  • Skoda 2
  • Byd 1
  • Fiat 1
  • Hyundai 1
  • Leximoto 1
  • Lexus 1
  • Mazda 1
  • Nissan 1
  • Porsche 1
  • Renault 1
  • Tesla 1

offence 10

  • Driving without Due Care and Attention 47
  • Contravening a Red Traffic Light 9
  • Use a motor vehicle / trailer in a condition likely to cause danger of injury 5
  • Dangerous Driving 2
  • Driving without Reasonable Consideration 2
  • Using a Mobile Phone Whilst Driving 2
  • Contravene Lane Closure Red X 1
  • Drive on hard shoulder 1
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
  • Vehicle overtake within crossing limits 1

council_area 9

  • Birmingham 32
  • Dudley 10
  • Coventry 6
  • Sandwell 6
  • Wolverhampton 5
  • Walsall 4
  • Halesowen 3
  • Solihull 3
  • Sutton Coldfield 2

reporter_transport_mode 5

  • Car 57
  • Other 5
  • Pedestrian 5
  • Pedal Bike 3
  • car 1

month 1

  • 2025-08 · 71 ✖

disposal 1

  • Court · 71 ✖
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
2044 op-snap---monthly-publication-august-2025.pdf   19 2025-08 Car Ford Mondeo Black Driving without Due Care and Attention None Foleshill Road Foleshill Road Coventry Coventry Court N/A   52.4274335 -1.5002381
2076 op-snap---monthly-publication-august-2025.pdf   51 2025-08 Car Vauxhall Zafira Silver Driving without Due Care and Attention None Bromford Lane / Heartlands Parkway Bromford Lane / Heartlands Parkway Birmingham Birmingham Court N/A   52.5083238 -1.8332287
2143 op-snap---monthly-publication-august-2025.pdf   118 2025-08 Car Honda civic Silver Driving without Reasonable Consideration No Insurance Haslucks Green Road Haslucks Green Road Birmingham Birmingham Court N/A      
2173 op-snap---monthly-publication-august-2025.pdf   148 2025-08 Car Seat Leon Black Driving without Due Care and Attention None Himley Road Himley Road Dudley Dudley Court N/A   52.5142667 -2.1304764
2204 op-snap---monthly-publication-august-2025.pdf   179 2025-08 Pedestrian Vauxhall Corsa Silver Using a Mobile Phone Whilst Driving None Hadley Road Hadley Road Birmingham Birmingham Court N/A   52.4419793 -1.9297441
2224 op-snap---monthly-publication-august-2025.pdf   199 2025-08 Car Honda 125 Red Contravening a Red Traffic Light None Kitts Green Road Kitts Green Road Birmingham Birmingham Court N/A   52.4815372 -1.7766518
2229 op-snap---monthly-publication-august-2025.pdf   204 2025-08 Car Seat Altea Black Contravening a Red Traffic Light None Winson Green Road Winson Green Road Birmingham Birmingham Court N/A   52.4870332 -1.9373713
2234 op-snap---monthly-publication-august-2025.pdf   209 2025-08 Pedal Bike Peugeot 2008 Blue Driving without Reasonable Consideration None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
2238 op-snap---monthly-publication-august-2025.pdf   213 2025-08 Other Fiat Punto white Dangerous Driving None Waterfront car park Waterfront car park Dudley Dudley Court N/A      
2261 op-snap---monthly-publication-august-2025.pdf   236 2025-08 Pedal Bike Honda GLR 125 Red Contravene Lane Closure Red X No Insurance High Street Digbeth High Street Digbeth Birmingham Birmingham Court N/A   52.4918911 -1.8603826
2271 op-snap---monthly-publication-august-2025.pdf   246 2025-08 Car Ford C Max Black Drive on hard shoulder None M5 M5 Sandwell Sandwell Court N/A      
2295 op-snap---monthly-publication-august-2025.pdf   270 2025-08 Car Vauxhall Insignia Black Driving without Due Care and Attention No Insurance High Street, Smethwick High Street, Smethwick Sandwell Sandwell Court N/A   52.4955266 -1.9697742
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
2309 op-snap---monthly-publication-august-2025.pdf   284 2025-08 Car Mazda 2TS Grey Driving without Due Care and Attention None Warwick Road Warwick Road Solihull Solihull Court N/A   52.4428606 -1.812114
2342 op-snap---monthly-publication-august-2025.pdf   317 2025-08 Pedestrian Land Rover Velar Black Driving without Due Care and Attention None Flethchamstead Road Flethchamstead Road Coventry Coventry Court N/A      
2366 op-snap---monthly-publication-august-2025.pdf   341 2025-08 Car Honda Jazz Yellow Driving without Due Care and Attention None Longmore Street Longmore Street Birmingham Birmingham Court N/A   52.464484 -1.8923374
2368 op-snap---monthly-publication-august-2025.pdf   343 2025-08 Car BMW 335 Black Dangerous Driving None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley Court N/A   52.4590366 -2.1465735
2377 op-snap---monthly-publication-august-2025.pdf   352 2025-08 Car Peugeot 207 Silver Driving without Due Care and Attention No Insurance Wednesbury Road Wednesbury Road Wolverhampton Wolverhampton Court N/A      
2415 op-snap---monthly-publication-august-2025.pdf   390 2025-08 Car Vauxhall Corsa Red Contravening a Red Traffic Light No Insurance Battery Way Battery Way Birmingham Birmingham Court N/A   52.4493988 -1.8476406
2417 op-snap---monthly-publication-august-2025.pdf   392 2025-08 Car Honda Jazz Red Contravening a Red Traffic Light None Warwick Road Warwick Road Birmingham Birmingham Court N/A   52.4555288 -1.8613929
2424 op-snap---monthly-publication-august-2025.pdf   399 2025-08 car Audi Q2 Grey Driving without Due Care and Attention None Dudley Road Dudley Road Birmingham Birmingham Court N/A   52.4865107 -1.9386263
2425 op-snap---monthly-publication-august-2025.pdf   400 2025-08 Car Mercedes-Benz Splinter White Driving without Due Care and Attention None Halesowen Road Halesowen Road Halesowen Halesowen Court N/A   52.4624413 -2.0175178
2450 op-snap---monthly-publication-august-2025.pdf   425 2025-08 Pedal Bike Volkswagen Golf Silver Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Sir Harrys Road Sir Harrys Road Birmingham Birmingham Court N/A   52.4587457 -1.9077277
2454 op-snap---monthly-publication-august-2025.pdf   429 2025-08 Car Toyota Prius White Vehicle overtake within crossing limits None Coleshill Road Coleshill Road Sutton Coldfield Sutton Coldfield Court N/A   52.5613155 -1.8139826
2467 op-snap---monthly-publication-august-2025.pdf   442 2025-08 Car Audi TT Grey Driving without Due Care and Attention No Insurance Noose lane Noose lane Wolverhampton Wolverhampton Court N/A   52.5845301 -2.0748599
2469 op-snap---monthly-publication-august-2025.pdf   444 2025-08 Other Volkswagen Golf White Driving without Due Care and Attention No Insurance Car park opposite Odeon Cinema Car park opposite Odeon Cinema Dudley Dudley Court N/A      
2524 op-snap---monthly-publication-august-2025.pdf   499 2025-08 Car Toyota Yaris Grey Use a motor vehicle / trailer in a condition likely to cause danger of injury None New Fosse Way New Fosse Way Birmingham Birmingham Court N/A   52.4473373 -1.9392405
2545 op-snap---monthly-publication-august-2025.pdf   520 2025-08 Car Mercedes-Benz   Black Driving without Due Care and Attention None M5 towarsd J3 M5 towarsd J3 Halesowen Halesowen Court N/A      
2573 op-snap---monthly-publication-august-2025.pdf   548 2025-08 Car Honda Civic Silver Driving without Due Care and Attention None Springfield Road Springfield Road Birmingham Birmingham Court N/A   52.4327486 -1.8844997
2581 op-snap---monthly-publication-august-2025.pdf   556 2025-08 Pedestrian Vauxhall Corsa Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
2601 op-snap---monthly-publication-august-2025.pdf   576 2025-08 Car Toyota Yaris Silver Using a Mobile Phone Whilst Driving None Worlds End Lane Worlds End Lane Birmingham Birmingham Court N/A   52.4555997 -1.9882443
2623 op-snap---monthly-publication-august-2025.pdf   598 2025-08 Car Vauxhall Astra White Driving without Due Care and Attention None Long Lane Blackheath Long Lane Blackheath Sandwell Sandwell Court N/A   52.4748171 -2.0377939
2656 op-snap---monthly-publication-august-2025.pdf   631 2025-08 Car Mercedes-Benz A200 Silver Driving without Due Care and Attention None Richmond Road Richmond Road Solihull Solihull Court N/A   52.4430188 -1.8022218
2657 op-snap---monthly-publication-august-2025.pdf   632 2025-08 Car Mercedes-Benz AMG Black Driving without Due Care and Attention None Cakemore Road Cakemore Road Sandwell Sandwell Court N/A   52.4784618 -2.0263474
2660 op-snap---monthly-publication-august-2025.pdf   635 2025-08 Car Audi Q3 Grey Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Court N/A   52.4543565 -1.9114004
2685 op-snap---monthly-publication-august-2025.pdf   660 2025-08 Car Tesla Model 3 Black Driving without Due Care and Attention None High Street High Street Sutton Coldfield Sutton Coldfield Court N/A   52.5669628 -1.8233167
2688 op-snap---monthly-publication-august-2025.pdf   663 2025-08 Car Hyundai IX5.. Black Driving without Due Care and Attention None M6 South M6 South Birmingham Birmingham Court N/A   52.4031308 -2.0142003
2712 op-snap---monthly-publication-august-2025.pdf   687 2025-08 Car Audi A6.. Black Driving without Due Care and Attention None Chester Road Walsall Chester Road Walsall Walsall Walsall Court N/A   52.5692139 -1.8799672
2714 op-snap---monthly-publication-august-2025.pdf   689 2025-08 Car Ford Transit Grey Driving without Due Care and Attention None Coundon Wedge Drive Coundon Wedge Drive Coventry Coventry Court N/A   52.4385402 -1.5483746
2724 op-snap---monthly-publication-august-2025.pdf   699 2025-08 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Court N/A   52.5047428 -2.0823754
2734 op-snap---monthly-publication-august-2025.pdf   709 2025-08 Car Renault Master White Driving without Due Care and Attention None Trittiford Road Trittiford Road Birmingham Birmingham Court N/A   52.4248084 -1.8660294
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
2747 op-snap---monthly-publication-august-2025.pdf   722 2025-08 Car Toyota MPV Grey Contravening a Red Traffic Light No Insurance Heathfield Road Heathfield Road Birmingham Birmingham Court N/A   52.5905365 -1.8453418
2770 op-snap---monthly-publication-august-2025.pdf   745 2025-08 Car Skoda Octavia Blue Contravening a Red Traffic Light No Insurance Highters Heath Lane Highters Heath Lane Birmingham Birmingham Court N/A   52.4100972 -1.8742772
2790 op-snap---monthly-publication-august-2025.pdf   765 2025-08 Pedestrian Volkswagen Golf Black Driving without Due Care and Attention None Holbrook Lane Holbrook Lane Coventry Coventry Court N/A   52.436155 -1.5064002
2791 op-snap---monthly-publication-august-2025.pdf   766 2025-08 Car Vauxhall Vivaro White Driving without Due Care and Attention None Ridgacre Road Ridgacre Road Birmingham Birmingham Court N/A   52.4593367 -2.0000298
2815 op-snap---monthly-publication-august-2025.pdf   790 2025-08 Car Skoda Octavia Blue Driving without Due Care and Attention None Bordesley Green Bordesley Green Birmingham Birmingham Court N/A   52.4758869 -1.8512072
2831 op-snap---monthly-publication-august-2025.pdf   806 2025-08 Car Nissan Micra Blue Driving without Due Care and Attention None M6 Junction8 M6 Junction8 Walsall Walsall Court N/A   52.6760749 -2.0862582
2834 op-snap---monthly-publication-august-2025.pdf   809 2025-08 Car Mercedes-Benz AMG GLA White Driving without Due Care and Attention None Hordern Road Hordern Road Wolverhampton Wolverhampton Court N/A   52.6011418 -2.1550745
2835 op-snap---monthly-publication-august-2025.pdf   810 2025-08 Car Audi A6 Black Driving without Due Care and Attention None Hordern Road Hordern Road Wolverhampton Wolverhampton Court N/A   52.6011418 -2.1550745
2847 op-snap---monthly-publication-august-2025.pdf   822 2025-08 Car BMW 340.. Black Driving without Due Care and Attention None M6 North Jct 10 M6 North Junction 10 Walsall Walsall Court N/A      
2881 op-snap---monthly-publication-august-2025.pdf   856 2025-08 Pedestrian Mercedes-Benz GLA White Use a motor vehicle / trailer in a condition likely to cause danger of injury None Thomas Lansdail St Thomas Lansdail Street Coventry Coventry Court N/A      
2888 op-snap---monthly-publication-august-2025.pdf   863 2025-08 Other Vauxhall Corsa Grey Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
2893 op-snap---monthly-publication-august-2025.pdf   868 2025-08 Other Ford Fiesta Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
2959 op-snap---monthly-publication-august-2025.pdf   934 2025-08 Car Lexus NX 300 Blue Driving without Due Care and Attention Use vehicle on a road without valid test ce rQtiufieceantes Road, Yardley r Qtiufieceantes Road, Yardley Birmingham Birmingham Court N/A      
2960 op-snap---monthly-publication-august-2025.pdf   935 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None St Marys Row Street Marys Row Birmingham Birmingham Court N/A      
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      
3043 op-snap---monthly-publication-august-2025.pdf   1018 2025-08 Car Porsche 911.. Black Contravening a Red Traffic Light No Insurance Stetchford lane Stetchford lane Birmingham Birmingham Court N/A      
3064 op-snap---monthly-publication-august-2025.pdf   1039 2025-08 Car Audi TT Silver Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham Court N/A   52.4220705 -1.8372335
3085 op-snap---monthly-publication-august-2025.pdf   1060 2025-08 Car Byd Atto 3 Blue Driving without Due Care and Attention None A449 Kidderminster Road, Kingswinford Kidderminster Road, Kingswinford Dudley Dudley Court N/A      
3089 op-snap---monthly-publication-august-2025.pdf   1064 2025-08 Car BMW 335.. Silver Driving without Due Care and Attention None Richmond Road at Warwick Road Richmond Road at Warwick Road Solihull Solihull Court N/A   52.4430188 -1.8022218
3114 op-snap---monthly-publication-august-2025.pdf   1089 2025-08 Other Vauxhall Corsa White Use a motor vehicle / trailer in a condition likely to cause danger of injury None Waterfront Car Park Grey 7 Waterfront Car Park Grey 7 Dudley Dudley Court N/A      
3125 op-snap---monthly-publication-august-2025.pdf   1100 2025-08 Car Leximoto Wy125 Blue Driving without Due Care and Attention No Insurance Corngreaves Road Corngreaves Road Sandwell Sandwell Court N/A   52.4686695 -2.0776976
3156 op-snap---monthly-publication-august-2025.pdf   1131 2025-08 Car Volkswagen Golf Blue Contravening a Red Traffic Light None Lichfeild Road Lichfeild Road Walsall Walsall Court N/A      
3158 op-snap---monthly-publication-august-2025.pdf   1133 2025-08 Car Peugeot 307.. Blue Driving without Due Care and Attention No Insurance Watford Road at Northfield Road Watford Road at Northfield Road Birmingham Birmingham Court N/A   52.41674 -1.9306562
3160 op-snap---monthly-publication-august-2025.pdf   1135 2025-08 Car Vauxhall Corsa Red Driving without Due Care and Attention None School Lane School Lane Birmingham Birmingham Court N/A   52.4998745 -1.783172
3166 op-snap---monthly-publication-august-2025.pdf   1141 2025-08 Car Audi A1 Grey Driving without Due Care and Attention None Westwood Heath road Westwood Heath road Coventry Coventry Court N/A   52.3846451 -1.5763626
3177 op-snap---monthly-publication-august-2025.pdf   1152 2025-08 Car Land Rover   Grey Driving without Due Care and Attention None Halesowen Road Halesowen Road Halesowen Halesowen Court N/A   52.4624413 -2.0175178
3193 op-snap---monthly-publication-august-2025.pdf   1168 2025-08 Car BMW M3 Black Contravening a Red Traffic Light No Insurance Oxford Street Island at A463 Oxford Street Island at A463 Wolverhampton Wolverhampton Court N/A   52.5648968 -2.0708366
3195 op-snap---monthly-publication-august-2025.pdf   1170 2025-08 Car Audi S3 White Use a motor vehicle / trailer in a condition likely to cause danger of injury None Bishopsgate Street Bishopsgate Street Birmingham Birmingham Court N/A   52.473986 -1.9147087
3830 op-snap---monthly-publication-august-2025.pdf   1805 2025-08 Car Peugeot Panel Van White Use a motor vehicle / trailer in a condition likely to cause danger of injury None M5 junction 2 M5 junction 2 Sandwell Sandwell Court N/A   52.4945433 -2.0190848

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