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

81 rows where disposal = "Court", month = "2025-06" 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

vehicle_make 20

  • Volkswagen 16
  • BMW 12
  • Ford 8
  • Toyota 7
  • Audi 6
  • Vauxhall 6
  • Seat 5
  • Citroen 3
  • Mercedes-Benz 3
  • Honda 2
  • Hyundai 2
  • Daf 1
  • Fiat 1
  • Jaguar 1
  • Lamborghini 1
  • Peugeot 1
  • Porsche 1
  • Skoda 1
  • Suzuki 1
  • Tesla 1

council_area 9

  • Birmingham 46
  • Coventry 9
  • Sandwell 6
  • Wolverhampton 6
  • Solihull 5
  • Dudley 4
  • Sutton Coldfield 2
  • Walsall 2
  • Out of Force Area 1

offence 8

  • Driving without Due Care and Attention 54
  • Contravening a Red Traffic Light 14
  • Dangerous Driving 3
  • Driving without Reasonable Consideration 3
  • Using a Mobile Phone Whilst Driving 3
  • Motor vehicle fail to accord precedence at a pelican crossing 2
  • Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
  • Vehicle overtake within crossing limits 1

reporter_transport_mode 1

  • Car · 81 ✖

month 1

  • 2025-06 · 81 ✖

disposal 1

  • Court · 81 ✖
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
14090 op-snap---monthly-publication-june-2025.pdf   19 2025-06 Car Seat Leon Red Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Court N/A   52.4726661 -1.8769032
14094 op-snap---monthly-publication-june-2025.pdf   23 2025-06 Car Seat Altea Silver Driving without Due Care and Attention None Stonebridge Highway Stonebridge Highway Coventry Coventry Court N/A   52.3782187 -1.478696
14099 op-snap---monthly-publication-june-2025.pdf   28 2025-06 Car Toyota Prius Silver Contravening a Red Traffic Light No Insurance Soho Road Soho Road Birmingham Birmingham Court N/A   52.502568 -1.9305447
14125 op-snap---monthly-publication-june-2025.pdf   54 2025-06 Car BMW 420d Black Driving without Due Care and Attention None Much Park Street Much Park Street Coventry Coventry Court N/A   52.4061531 -1.505845
14128 op-snap---monthly-publication-june-2025.pdf   57 2025-06 Car Skoda FABIA BLUE Driving without Due Care and Attention None A457 ROLFE STREET A457 Rolfe Street Birmingham Birmingham Court N/A      
14169 op-snap---monthly-publication-june-2025.pdf   98 2025-06 Car Ford Fiesta Blue Contravening a Red Traffic Light Use vehicle on a road without valid test certificate Holland Road jn with A5127 Holland Road jn with A5127 Sutton Coldfield Sutton Coldfield Court N/A      
14192 op-snap---monthly-publication-june-2025.pdf   121 2025-06 Car Seat Leon Black Driving without Due Care and Attention None Kings Road Kings Road Birmingham Birmingham Court N/A   52.5531351 -1.8852761
14202 op-snap---monthly-publication-june-2025.pdf   131 2025-06 Car Hyundai I10 Red Driving without Due Care and Attention None Trysul Road Trysul Road Wolverhampton Wolverhampton Court N/A      
14207 op-snap---monthly-publication-june-2025.pdf   136 2025-06 Car Volkswagen GOLF Black Contravening a Red Traffic Light None KING STREET King Street Dudley Dudley Court N/A   52.5095654 -2.0806912
14212 op-snap---monthly-publication-june-2025.pdf   141 2025-06 Car Ford Fiesta Black Contravening a Red Traffic Light Use vehicle on a road without valid test certificate Bristol Road, Selly Oak Bristol Road, Selly Oak Birmingham Birmingham Court N/A   52.4325994 -1.9481062
14230 op-snap---monthly-publication-june-2025.pdf   159 2025-06 Car Vauxhall Astra Black Motor vehicle fail to accord precedence at a pelican crossing No Insurance Windmill Lane Windmill Lane Wolverhampton Wolverhampton Court N/A   52.5807057 -2.1902528
14274 op-snap---monthly-publication-june-2025.pdf   203 2025-06 Car Suzuki GSX 1250 Black Driving without Due Care and Attention No vehicle excise licence M54 motorway, nr Jn1 M54 motorway, nr Jn1 Out of Force Area Out of Force Area Court N/A      
14279 op-snap---monthly-publication-june-2025.pdf   208 2025-06 Car Audi S3 Grey Driving without Due Care and Attention None Richmond Road Richmond Road Solihull Solihull Court N/A   52.4430188 -1.8022218
14349 op-snap---monthly-publication-june-2025.pdf   278 2025-06 Car Volkswagen Scirocco White Driving without Due Care and Attention No Insurance Burton Road, towards Sedgley Burton Road, towards Sedgley Dudley Dudley Court N/A      
14354 op-snap---monthly-publication-june-2025.pdf   283 2025-06 Car Toyota Auris Red Contravening a Red Traffic Light None A34 Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
14359 op-snap---monthly-publication-june-2025.pdf   288 2025-06 Car Mercedes-Benz Sprinter minibus Silver Dangerous Driving None Kingsbury Road / Tyburn Road Kingsbury Road / Tyburn Road Birmingham Birmingham Court N/A   52.5184687 -1.8052101
14395 op-snap---monthly-publication-june-2025.pdf   324 2025-06 Car Jaguar F Pace Blue Driving without Due Care and Attention None Spitfire Island Spitfire Island Birmingham Birmingham Court N/A   52.5138106 -1.797297
14415 op-snap---monthly-publication-june-2025.pdf   344 2025-06 Car Toyota MR2 Silver Driving without Due Care and Attention None Downing Street Smethwick Downing Street Smethwick Sandwell Sandwell Court N/A   52.5015329 -1.9556094
14419 op-snap---monthly-publication-june-2025.pdf   348 2025-06 Car Ford Fiesta Grey Driving without Due Care and Attention None Greenfield Lane Greenfield Lane Wolverhampton Wolverhampton Court N/A   52.6342843 -2.1143514
14422 op-snap---monthly-publication-june-2025.pdf   351 2025-06 Car Vauxhall Astra Black Using a Mobile Phone Whilst Driving None M42 North M42 North Solihull Solihull Court N/A   52.4734164 -1.711338
14423 op-snap---monthly-publication-june-2025.pdf   352 2025-06 Car Volkswagen Golf White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
14474 op-snap---monthly-publication-june-2025.pdf   403 2025-06 Car Volkswagen Golf Silver Driving without Due Care and Attention None A452 Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Court N/A      
14479 op-snap---monthly-publication-june-2025.pdf   408 2025-06 Car Vauxhall Astra Black Driving without Due Care and Attention None Leighswood Road, Aldridge Leighswood Road, Aldridge Walsall Walsall Court N/A   52.6071662 -1.9231466
14502 op-snap---monthly-publication-june-2025.pdf   431 2025-06 Car Toyota Yaris Black Contravening a Red Traffic Light None A47 Fort Parkway Fort Parkway Birmingham Birmingham Court N/A   52.50787 -1.8195713
14504 op-snap---monthly-publication-june-2025.pdf   433 2025-06 Car Honda civic Red Driving without Due Care and Attention Use vehicle on a road without valid test certificate Chester Road Chester Road Birmingham Birmingham Court N/A   52.5359496 -1.8324115
14511 op-snap---monthly-publication-june-2025.pdf   440 2025-06 Car Vauxhall Zafira White Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Sandwell Sandwell Court N/A   52.4702299 -1.9948976
14534 op-snap---monthly-publication-june-2025.pdf   463 2025-06 Car Volkswagen Golf Grey Driving without Due Care and Attention None Broadway North Broadway North Walsall Walsall Court N/A   52.5886007 -1.9741222
14690 op-snap---monthly-publication-june-2025.pdf   619 2025-06 Car Fiat Punto White Driving without Due Care and Attention None Scimitar Way Scimitar Way Coventry Coventry Court N/A   52.3836203 -1.4862458
14710 op-snap---monthly-publication-june-2025.pdf   639 2025-06 Car   KTM Duke Orange Driving without Due Care and Attention No Insurance Kings Road Kings Road Birmingham Birmingham Court N/A   52.5531351 -1.8852761
14749 op-snap---monthly-publication-june-2025.pdf   678 2025-06 Car Toyota Corolla Silver Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
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
14773 op-snap---monthly-publication-june-2025.pdf   702 2025-06 Car BMW 8401 Black Driving without Due Care and Attention VRM fails to conform to Regulations Blossomfield Road Blossomfield Road Solihull Solihull Court N/A   52.4144779 -1.7848758
14786 op-snap---monthly-publication-june-2025.pdf   715 2025-06 Car Ford Fiesta Silver Driving without Due Care and Attention None Farnborough Road Farnborough Road Birmingham Birmingham Court N/A   52.5148331 -1.79231
14788 op-snap---monthly-publication-june-2025.pdf   717 2025-06 Car Volkswagen Golf Silver Driving without Due Care and Attention No Insurance City Road City Road Birmingham Birmingham Court N/A   52.4763176 -1.9584897
14791 op-snap---monthly-publication-june-2025.pdf   720 2025-06 Car Vauxhall Corsa Grey Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham Court N/A      
14796 op-snap---monthly-publication-june-2025.pdf   725 2025-06 Car Citroen Berlingo White Driving without Due Care and Attention None Vulcan Road Vulcan Road Wolverhampton Wolverhampton Court N/A   52.563872 -2.0617003
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
14826 op-snap---monthly-publication-june-2025.pdf   755 2025-06 Car Mercedes-Benz A180 Black Contravening a Red Traffic Light None Portland Road Portland Road Birmingham Birmingham Court N/A   52.4737014 -1.9412436
14841 op-snap---monthly-publication-june-2025.pdf   770 2025-06 Car Mercedes-Benz E220 White Driving without Due Care and Attention None Hamptonn Lane Hamptonn Lane Solihull Solihull Court N/A      
14860 op-snap---monthly-publication-june-2025.pdf   789 2025-06 Car Volkswagen Golf Blue Dangerous Driving None Hagley Road Hagley Road Birmingham Birmingham Court N/A   52.471632 -1.9456776
14877 op-snap---monthly-publication-june-2025.pdf   806 2025-06 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Blackhalve Lane Blackhalve Lane Wolverhampton Wolverhampton Court N/A   52.6139368 -2.0960778
14904 op-snap---monthly-publication-june-2025.pdf   833 2025-06 Car Porsche 911.. Black Contravening a Red Traffic Light None A5127 A5127 Birmingham Birmingham Court N/A      
14906 op-snap---monthly-publication-june-2025.pdf   835 2025-06 Car Volkswagen Passat Grey Using a Mobile Phone Whilst Driving None M42 M42 Birmingham Birmingham Court N/A      
14914 op-snap---monthly-publication-june-2025.pdf   843 2025-06 Car BMW M140i Black Driving without Due Care and Attention None Ring Road Ring Road Coventry Coventry Court N/A      
14916 op-snap---monthly-publication-june-2025.pdf   845 2025-06 Car BMW X6.. Black Driving without Due Care and Attention No Insurance A453 A453 Coventry Coventry Court N/A      
15031 op-snap---monthly-publication-june-2025.pdf   960 2025-06 Car   E Deliever White Driving without Due Care and Attention None Cranmore Boulevard Cranmore Boulevard Solihull Solihull Court N/A   52.3947549 -1.8141729
15032 op-snap---monthly-publication-june-2025.pdf   961 2025-06 Car Seat Leon Blue Driving without Due Care and Attention No Insurance Windward Way Windward Way Birmingham Birmingham Court N/A      
15051 op-snap---monthly-publication-june-2025.pdf   980 2025-06 Car Audi A4 Black Dangerous Driving None COTTERILLS LANE Cotterills Lane Birmingham Birmingham Court N/A   52.4884297 -1.817811
15095 op-snap---monthly-publication-june-2025.pdf   1024 2025-06 Car Citroen C5 Grey Driving without Due Care and Attention None M6/M5 J7 M6/M5 J7 Birmingham Birmingham Court N/A      
15100 op-snap---monthly-publication-june-2025.pdf   1029 2025-06 Car Tesla Y Long White Contravening a Red Traffic Light None Waste Lane Waste Lane Coventry Coventry Court N/A   52.437361 -1.5371291
15105 op-snap---monthly-publication-june-2025.pdf   1034 2025-06 Car Volkswagen Golf Blue Driving without Due Care and Attention None Hawthorn Road Hawthorn Road Birmingham Birmingham Court N/A   52.5436609 -1.8214668
15126 op-snap---monthly-publication-june-2025.pdf   1055 2025-06 Car Audi A6 Black Vehicle overtake within crossing limits Driving without Due Care and Attention Alcester Road Alcester Road Birmingham Birmingham Court N/A   52.4470686 -1.8880749
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      
15153 op-snap---monthly-publication-june-2025.pdf   1082 2025-06 Car Ford Fiesta Black Driving without Due Care and Attention No Insurance Chester Road Chester Road Birmingham Birmingham Court N/A   52.5359496 -1.8324115
15204 op-snap---monthly-publication-june-2025.pdf   1133 2025-06 Car Toyota Aygo Silver Driving without Due Care and Attention None Lockhurst Lane Lockhurst Lane Coventry Coventry Court N/A   52.4255689 -1.5023841
15206 op-snap---monthly-publication-june-2025.pdf   1135 2025-06 Car Audi A3 Black Contravening a Red Traffic Light None A45 Heybarnes Island Heybarnes Island Birmingham Birmingham Court N/A      
15215 op-snap---monthly-publication-june-2025.pdf   1144 2025-06 Car Volkswagen CADDY White Driving without Due Care and Attention No Insurance Haslucks Green Road Haslucks Green Road 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
15240 op-snap---monthly-publication-june-2025.pdf   1169 2025-06 Car Volkswagen   Grey Driving without Due Care and Attention None WOOD GREEN ROAD Wood Green Road Sandwell Sandwell Court N/A   52.5628617 -2.0055157
15244 op-snap---monthly-publication-june-2025.pdf   1173 2025-06 Car BMW 4 series Grey Driving without Due Care and Attention None Cradley Heath Cradley Heath Sandwell Sandwell Court N/A   52.4694427 -2.0907047
15246 op-snap---monthly-publication-june-2025.pdf   1175 2025-06 Car BMW M4 White Contravening a Red Traffic Light None NEW B-HAM ROAD New B-Ham Road Dudley Dudley Court N/A      
15283 op-snap---monthly-publication-june-2025.pdf   1212 2025-06 Car Audi A3 Black Driving without Due Care and Attention Use vehicle on a road without valid test certificate SUFFOLK STREET Suffolk Street Birmingham Birmingham Court N/A   52.4749336 -1.9003475
15476 op-snap---monthly-publication-june-2025.pdf   1405 2025-06 Car Volkswagen Golf Red Driving without Due Care and Attention None Brackenbury Road Brackenbury Road Birmingham Birmingham Court N/A   52.5407924 -1.8709807
15495 op-snap---monthly-publication-june-2025.pdf   1424 2025-06 Car Volkswagen Golf Grey Driving without Due Care and Attention None Dudley Road, Halesowen Dudley Road, Halesowen Sandwell Sandwell Court N/A      
15520 op-snap---monthly-publication-june-2025.pdf   1449 2025-06 Car Volkswagen Golf Silver Driving without Due Care and Attention None Hollybank Road Hollybank Road Birmingham Birmingham Court N/A   52.4236341 -1.8787502
15548 op-snap---monthly-publication-june-2025.pdf   1477 2025-06 Car Ford Transit White Driving without Due Care and Attention None Hazelhurst Road Hazelhurst Road Birmingham Birmingham Court N/A   52.4297698 -1.8966539
15550 op-snap---monthly-publication-june-2025.pdf   1479 2025-06 Car Ford Transit White Driving without Due Care and Attention None Hazelhurst Road Hazelhurst Road Birmingham Birmingham Court N/A   52.4297698 -1.8966539
15554 op-snap---monthly-publication-june-2025.pdf   1483 2025-06 Car Volkswagen Touran Blue Driving without Due Care and Attention None Reddings Lane Reddings Lane Birmingham Birmingham Court N/A   52.4506039 -1.8463952
15578 op-snap---monthly-publication-june-2025.pdf   1507 2025-06 Car Ford mondeo Grey Use a motor vehicle / trailer in a condition likely to cause danger of injury None Garretts Green Lane Garretts Green Lane Birmingham Birmingham Court N/A   52.4675802 -1.7905748
15584 op-snap---monthly-publication-june-2025.pdf   1513 2025-06 Car Citroen DS3 Blue Driving without Due Care and Attention None Wolverhampton Street Wolverhampton Street Sandwell Sandwell Court N/A      
15586 op-snap---monthly-publication-june-2025.pdf   1515 2025-06 Car Audi A5 Black Driving without Due Care and Attention None Cinder Bank Cinder Bank Dudley Dudley Court N/A   52.4951209 -2.0924902
15589 op-snap---monthly-publication-june-2025.pdf   1518 2025-06 Car Volkswagen golf Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Birmingham Birmingham Court N/A   52.5505398 -1.8252993
15617 op-snap---monthly-publication-june-2025.pdf   1546 2025-06 Car BMW 318D Grey Contravening a Red Traffic Light No Insurance Icknield St Icknield Street Sutton Coldfield Sutton Coldfield Court N/A   52.5709191 -1.8759339
15627 op-snap---monthly-publication-june-2025.pdf   1556 2025-06 Car Daf Scancia Red Using a Mobile Phone Whilst Driving None M6 M6 Coventry Coventry Court N/A      
15632 op-snap---monthly-publication-june-2025.pdf   1561 2025-06 Car Toyota Prius Black Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Court N/A   52.4070602 -1.4732469
15665 op-snap---monthly-publication-june-2025.pdf   1594 2025-06 Car Peugeot 207 White Driving without Reasonable Consideration No Insurance Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Court N/A      
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
15681 op-snap---monthly-publication-june-2025.pdf   1610 2025-06 Car Lamborghini Urus Black Driving without Due Care and Attention None Suffolk Street Suffolk Street Birmingham Birmingham Court N/A   52.4749336 -1.9003475
15683 op-snap---monthly-publication-june-2025.pdf   1612 2025-06 Car Seat Leon Yellow Driving without Due Care and Attention None Willenhall Road Willenhall Road Wolverhampton Wolverhampton Court N/A   52.5836778 -2.0894997
15710 op-snap---monthly-publication-june-2025.pdf   1639 2025-06 Car Honda Civic Blue Driving without Due Care and Attention None Percy Road Percy Road Birmingham Birmingham Court N/A   52.4506155 -1.8585325
15742 op-snap---monthly-publication-june-2025.pdf   1671 2025-06 Car Hyundai I10 Silver Motor vehicle fail to accord precedence at a pelican crossing None Farnborough Road Farnborough Road Birmingham Birmingham Court N/A   52.5148331 -1.79231

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