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

769 rows where month = "2026-01" 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 >30

offence 30

reporter_transport_mode 1

  • Car · 769 ✖

month 1

  • 2026-01 · 769 ✖
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
10539 op-snap---monthly-publication-january-2026.pdf   0 2026-01 Car Mercedes-Benz GLC 300 Silver Driving without Due Care and Attention None High Street, Bloxwich High Street, Bloxwich Walsall Walsall Education N/A   52.6142343 -2.0043397
10541 op-snap---monthly-publication-january-2026.pdf   2 2026-01 Car Audi S3 Black Contravening a Red Traffic Light No Insurance Alum Rock Road Alum Rock Road Birmingham Birmingham Court N/A   52.4883936 -1.8310056
10542 op-snap---monthly-publication-january-2026.pdf   3 2026-01 Car Volkswagen Golf Silver Driving without Due Care and Attention None M42 near birmingham airport M42 near birmingham airport Birmingham Birmingham Warning Letter N/A      
10545 op-snap---monthly-publication-january-2026.pdf   6 2026-01 Car Audi S3 Black Duplicate Submission None Alum Rock Road Alum Rock Road Birmingham Birmingham Duplicate Submission Duplicate Submission   52.4883936 -1.8310056
10546 op-snap---monthly-publication-january-2026.pdf   7 2026-01 Car Mitsubishi Eclipse Black Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull NFA No Offence   52.4191184 -1.8326637
10548 op-snap---monthly-publication-january-2026.pdf   9 2026-01 Car Mercedes-Benz A200 Black Using a Mobile Phone Whilst Driving None Binley Road Binley Road Coventry Coventry NFA No Independent Evidence Available   52.4070602 -1.4732469
10549 op-snap---monthly-publication-january-2026.pdf   10 2026-01 Car Scania   White Prohibited vehicle in offside lane of motorway None M42 between A45 and J 5 M42 between A45 and J 5 Birmingham Birmingham Warning Letter N/A      
10550 op-snap---monthly-publication-january-2026.pdf   11 2026-01 Car Toyota Hi-lux Green Drive a vehicle other than on the carriageway of a motorway None M6 NB J6 M6 Northbound J6 Birmingham Birmingham Education N/A   52.676119 -2.0858425
10551 op-snap---monthly-publication-january-2026.pdf   12 2026-01 Car Lexus IS 250 Grey Driving without Due Care and Attention None Coventry Ring Road Coventry Ring Road Coventry Coventry Education N/A      
10553 op-snap---monthly-publication-january-2026.pdf   14 2026-01 Car Toyota Avensis Silver Driving without Due Care and Attention None M6 NB J3 M6 Northbound J3 Coventry Coventry NFA No Independent Evidence Available   52.6760749 -2.0862582
10554 op-snap---monthly-publication-january-2026.pdf   15 2026-01 Car Volkswagen Polo White Contravening a Red Traffic Light None J10 Roundabout, Wolverhampton Road West J10 Roundabout, Wolverhampton Road West Walsall Walsall Education N/A      
10555 op-snap---monthly-publication-january-2026.pdf   16 2026-01 Car Kia Sportage Silver Contravene Lane Closure Red X None M6 M6 Birmingham Birmingham NFA No Independent Evidence Available      
10559 op-snap---monthly-publication-january-2026.pdf   20 2026-01 Car Land Rover Range White Contravening a Red Traffic Light None Marshall Lake Road Marshall Lake Road Solihull Solihull NFA No Independent Evidence Available   52.3975426 -1.818252
10560 op-snap---monthly-publication-january-2026.pdf   21 2026-01 Car Honda Civic Grey Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall Education N/A   52.5692139 -1.8799672
10563 op-snap---monthly-publication-january-2026.pdf   24 2026-01 Car Mercedes-Benz C220. Grey Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Fixed Penalty N/A   52.4092804 -1.8056214
10566 op-snap---monthly-publication-january-2026.pdf   27 2026-01 Car Audi A4.. Black Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Fixed Penalty N/A   52.4092804 -1.8056214
10570 op-snap---monthly-publication-january-2026.pdf   31 2026-01 Car Mazda 6 SE-L Grey Driving without Due Care and Attention None Foleshill Road Foleshill Road Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4274335 -1.5002381
10571 op-snap---monthly-publication-january-2026.pdf   32 2026-01 Car Toyota Estima White Contravening a Red Traffic Light None Bordesley Green Road Bordesley Green Road Birmingham Birmingham NFA No Independent Evidence Available   52.4804926 -1.8563658
10572 op-snap---monthly-publication-january-2026.pdf   33 2026-01 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Unknown   Birmingham Birmingham NFA No Independent Evidence Available      
10573 op-snap---monthly-publication-january-2026.pdf   34 2026-01 Car Land Rover Discovery Grey Using a Mobile Phone Whilst Driving None A48 Gloucester Gloucester Out of Force Area Out of Force Area NFA Out of Force   52.405214 -1.9708282
10574 op-snap---monthly-publication-january-2026.pdf   35 2026-01 Car Audi A1 Black Driving without Due Care and Attention None M5 SB J3 M5 Southbound J3 Birmingham Birmingham NFA No Offence   52.4846642 -1.9297585
10577 op-snap---monthly-publication-january-2026.pdf   38 2026-01 Car Audi A3 Blue Driving without Due Care and Attention None Cuckoo Road Cuckoo Road Birmingham Birmingham Fixed Penalty N/A   52.5049023 -1.8603659
10582 op-snap---monthly-publication-january-2026.pdf   43 2026-01 Car Polestar   White Driving without Due Care and Attention None A45 A45 Coventry Coventry Warning Letter N/A      
10583 op-snap---monthly-publication-january-2026.pdf   44 2026-01 Car Toyota Aygo Grey Contravening a Red Traffic Light No Insurance Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
10584 op-snap---monthly-publication-january-2026.pdf   45 2026-01 Car Audi Q3.. Black Driving without Due Care and Attention None Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
10585 op-snap---monthly-publication-january-2026.pdf   46 2026-01 Car Nissan Micra White Driving without Due Care and Attention No Insurance Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
10596 op-snap---monthly-publication-january-2026.pdf   57 2026-01 Car Audi s3 White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None warwick road Warwick Road Birmingham Birmingham Warning Letter N/A   52.4555288 -1.8613929
10598 op-snap---monthly-publication-january-2026.pdf   59 2026-01 Car Mercedes-Benz A200.. Grey Driving without Due Care and Attention None A41 Newport towards Market Drayton Newport towards Market Drayton Out of Force Area Out of Force Area NFA Out of Force      
10599 op-snap---monthly-publication-january-2026.pdf   60 2026-01 Car Man HGV White Driving without Due Care and Attention None A46 Stratford towards Evesham Stratford towards Evesham Out of Force Area Out of Force Area NFA Out of Force      
10600 op-snap---monthly-publication-january-2026.pdf   61 2026-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Swan Island Swan Island Birmingham Birmingham RTC - Actioned N/A   52.4616042 -1.8154705
10601 op-snap---monthly-publication-january-2026.pdf   62 2026-01 Car Audi RSQ7 White Driving without Due Care and Attention None M42 near M40 junc M42 near M40 junc Solihull Solihull Warning Letter N/A      
10602 op-snap---monthly-publication-january-2026.pdf   63 2026-01 Car Toyota Yaris Black Contravene Lane Closure Red X None Green Lane Green Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4618966 -1.9955421
10603 op-snap---monthly-publication-january-2026.pdf   64 2026-01 Car Seat Leon Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
10605 op-snap---monthly-publication-january-2026.pdf   66 2026-01 Car   Irizar Coach White Driving without Due Care and Attention None St Chads Queensway Street Chads Queensway Birmingham Birmingham Warning Letter N/A      
10608 op-snap---monthly-publication-january-2026.pdf   69 2026-01 Car Volkswagen Scirocco Black Driving without Due Care and Attention None M6 to M5 junction M6 to M5 junction Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.6912891 -2.1046372
10609 op-snap---monthly-publication-january-2026.pdf   70 2026-01 Car Mercedes-Benz CLA250.. White Driving without Due Care and Attention None M5 Jct 23 (Weston) M5 Junction 23 (Weston) Out of Force Area Out of Force Area NFA Out of Force      
10610 op-snap---monthly-publication-january-2026.pdf   71 2026-01 Car Toyota Corolla Grey Using a Mobile Phone Whilst Driving None Stourbridge Road Wombourne Stourbridge Road Wombourne Out of Force Area Out of Force Area NFA Out of Force      
10611 op-snap---monthly-publication-january-2026.pdf   72 2026-01 Car Toyota Yaris Silver Driving without Due Care and Attention None Lincoln Morland Avenue, Lincoln Lincoln Morland Avenue, Lincoln Out of Force Area Out of Force Area NFA Out of Force      
10612 op-snap---monthly-publication-january-2026.pdf   73 2026-01 Car Suzuki SX4 white Driving without Due Care and Attention None Jn9 M6 Jn9 M6 Walsall Walsall Education N/A      
10617 op-snap---monthly-publication-january-2026.pdf   78 2026-01 Car Volkswagen passat Silver Misc - Non Traffic Offences None west brom West Brom Sandwell Sandwell Other Action Taken N/A   52.473606 -1.9686379
10625 op-snap---monthly-publication-january-2026.pdf   86 2026-01 Car Mercedes-Benz gl350 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None oxhill road Oxhill Road Birmingham Birmingham Warning Letter N/A   52.513857 -1.9367367
10626 op-snap---monthly-publication-january-2026.pdf   87 2026-01 Car Volkswagen golf Grey Misc - Non Traffic Offences None cox street Cox Street Birmingham Birmingham NFA No Independent Evidence Available   52.4864073 -1.905273
10627 op-snap---monthly-publication-january-2026.pdf   88 2026-01 Car Audi a4 Grey Misc - Non Traffic Offences None M6 SB J9 M6 Southbound J9 Birmingham Birmingham NFA Misc Inc Crimes   52.676119 -2.0858425
10629 op-snap---monthly-publication-january-2026.pdf   90 2026-01 Car Mazda 3 TS Black Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4470686 -1.8880749
10631 op-snap---monthly-publication-january-2026.pdf   92 2026-01 Car Toyota Corolla Silver Contravening a Red Traffic Light None Chester Road / Hurst Lane North Chester Road / Hurst Lane North Birmingham Birmingham Education N/A   52.5359496 -1.8324115
10633 op-snap---monthly-publication-january-2026.pdf   94 2026-01 Car Audi Q2 Grey Contravening a Red Traffic Light None Sky Blue Way Sky Blue Way Coventry Coventry NFA No Independent Evidence Available   52.4085943 -1.4943275
10635 op-snap---monthly-publication-january-2026.pdf   96 2026-01 Car Citroen Dispatch white Contravening a Red Traffic Light None A45 Sheldon Sheldon Birmingham Birmingham Fixed Penalty N/A   52.4533229 -1.778016
10637 op-snap---monthly-publication-january-2026.pdf   98 2026-01 Car Ford Ranger White Driving without Due Care and Attention None Collector Road Collector Road Birmingham Birmingham NFA No Offence   52.5139393 -1.7600186
10638 op-snap---monthly-publication-january-2026.pdf   99 2026-01 Car Peugeot 3008 Red Contravening a Red Traffic Light None Stoney Stanton Road Stoney Stanton Road Coventry Coventry NFA No Independent Evidence Available   52.4221152 -1.4959475
10639 op-snap---monthly-publication-january-2026.pdf   100 2026-01 Car Mitsubishi Outlander Grey Driving without Due Care and Attention None School Road School Road Birmingham Birmingham Education N/A   52.4161736 -1.8619692
10642 op-snap---monthly-publication-january-2026.pdf   103 2026-01 Car Volkswagen Golf Grey Driving without Due Care and Attention None Wolverhampton Road South Wolverhampton Road South Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.463146 -1.9844677
10643 op-snap---monthly-publication-january-2026.pdf   104 2026-01 Car Volkswagen Arteon Black Driving without Due Care and Attention None M6 SB J9 M6 Southbound J9 Walsall Walsall NFA No Independent Evidence Available   52.676119 -2.0858425
10645 op-snap---monthly-publication-january-2026.pdf   106 2026-01 Car Honda   Blue Driving without Due Care and Attention None New Road New Road Solihull Solihull NFA No Independent Evidence Available   52.4119526 -1.773235
10646 op-snap---monthly-publication-january-2026.pdf   107 2026-01 Car BMW 318D White Driving without Due Care and Attention None Underhill Lane Underhill Lane Wolverhampton Wolverhampton Court N/A   52.6184526 -2.0954562
10648 op-snap---monthly-publication-january-2026.pdf   109 2026-01 Car Nissan Qashqai Black Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham Education N/A   52.5020639 -1.9026192
10649 op-snap---monthly-publication-january-2026.pdf   110 2026-01 Car Seat Leon White Contravening a Red Traffic Light None Bromford Road Bromford Road Birmingham Birmingham Fixed Penalty N/A   52.503036 -1.8289972
10650 op-snap---monthly-publication-january-2026.pdf   111 2026-01 Car Kia Sportage Black Driving without Due Care and Attention None A5 Oswestry Oswestry Out of Force Area Out of Force Area NFA Out of Force      
10651 op-snap---monthly-publication-january-2026.pdf   112 2026-01 Car Daf HGV White Driving without Due Care and Attention None M6 SB J16-15 M6 Southbound J16-15 Out of Force Area Out of Force Area NFA Out of Force      
10654 op-snap---monthly-publication-january-2026.pdf   115 2026-01 Car Ford Fiesta Blue Driving without Due Care and Attention None Spring Bank, Hull Spring Bank, Hull Out of Force Area Out of Force Area NFA Out of Force      
10655 op-snap---monthly-publication-january-2026.pdf   116 2026-01 Car Toyota Prius Silver Driving without Due Care and Attention None Clay Lane Clay Lane Birmingham Birmingham Education N/A   52.4509038 -1.8083784
10657 op-snap---monthly-publication-january-2026.pdf   118 2026-01 Car BMW 318.. Silver Driving without Due Care and Attention No Insurance A41 Birmingham Road Birmingham Road Sandwell Sandwell Court N/A   52.5461417 -1.9334193
10659 op-snap---monthly-publication-january-2026.pdf   120 2026-01 Car Mercedes-Benz e220 Black Cause vehicle to be left in a dangerous position None robin hood lane Robin Hood Lane Birmingham Birmingham Warning Letter N/A   52.4221526 -1.8425617
10663 op-snap---monthly-publication-january-2026.pdf   124 2026-01 Car Land Rover defender Green Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
10664 op-snap---monthly-publication-january-2026.pdf   125 2026-01 Car Toyota yaris Grey Cause vehicle to be left in a dangerous position None witton road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
10665 op-snap---monthly-publication-january-2026.pdf   126 2026-01 Car Ford focus Grey Cause vehicle to be left in a dangerous position None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
10666 op-snap---monthly-publication-january-2026.pdf   127 2026-01 Car Volkswagen passat Black Cause vehicle to be left in a dangerous position None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
10667 op-snap---monthly-publication-january-2026.pdf   128 2026-01 Car Honda civic White Cause vehicle to be left in a dangerous position None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
10668 op-snap---monthly-publication-january-2026.pdf   129 2026-01 Car Ford Ranger Black Driving without Due Care and Attention None Royal Road Royal Road Birmingham Birmingham NFA No Offence   52.5609478 -1.8170275
10669 op-snap---monthly-publication-january-2026.pdf   130 2026-01 Car Vauxhall Insignia Silver Using a Mobile Phone Whilst Driving None Hollyhedge Road Hollyhedge Road Sandwell Sandwell Fixed Penalty N/A   52.5360974 -1.9837968
10670 op-snap---monthly-publication-january-2026.pdf   131 2026-01 Car Toyota Yaris Silver Duplicate Submission None Alcester Road Alcester Road Birmingham Birmingham Duplicate Submission Duplicate Submission   52.4470686 -1.8880749
10671 op-snap---monthly-publication-january-2026.pdf   132 2026-01 Car Toyota Yaris Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
10672 op-snap---monthly-publication-january-2026.pdf   133 2026-01 Car BMW 320d Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None High Street, Deritend High Street, Deritend Birmingham Birmingham NFA No Independent Evidence Available   52.4746492 -1.8839977
10675 op-snap---monthly-publication-january-2026.pdf   136 2026-01 Car Renault Clio Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10676 op-snap---monthly-publication-january-2026.pdf   137 2026-01 Car Peugeot Partner White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10677 op-snap---monthly-publication-january-2026.pdf   138 2026-01 Car Volvo XC40 Green Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10678 op-snap---monthly-publication-january-2026.pdf   139 2026-01 Car Citroen C1 White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10679 op-snap---monthly-publication-january-2026.pdf   140 2026-01 Car Ford Focus Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham NFA No Independent Evidence Available   52.4929304 -1.8229092
10680 op-snap---monthly-publication-january-2026.pdf   141 2026-01 Car Ford C-Max Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10681 op-snap---monthly-publication-january-2026.pdf   142 2026-01 Car Mercedes-Benz c180 Black Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10682 op-snap---monthly-publication-january-2026.pdf   143 2026-01 Car Toyota Prius White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath road Washwood Heath road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10683 op-snap---monthly-publication-january-2026.pdf   144 2026-01 Car Audi A4 Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10684 op-snap---monthly-publication-january-2026.pdf   145 2026-01 Car Vauxhall Insignia White Stop a vehicle within pelican pedestrian crossing limits None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
10685 op-snap---monthly-publication-january-2026.pdf   146 2026-01 Car Volkswagen Tayron Green Stop a vehicle on pedestrian crossing None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
10686 op-snap---monthly-publication-january-2026.pdf   147 2026-01 Car Nissan Juke Red Cause vehicle to be left in a dangerous position None Washwood Heath Rd Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10687 op-snap---monthly-publication-january-2026.pdf   148 2026-01 Car Volkswagen Tcross Grey Stop a vehicle within pelican pedestrian crossing limits None Coleshill Rd Coleshill Road Birmingham Birmingham Education N/A   52.4967329 -1.8097462
10688 op-snap---monthly-publication-january-2026.pdf   149 2026-01 Car Toyota Auris Brown Stop a vehicle on pedestrian crossing None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
10689 op-snap---monthly-publication-january-2026.pdf   150 2026-01 Car Renault Clio Silver Stop a vehicle on pedestrian crossing None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
10690 op-snap---monthly-publication-january-2026.pdf   151 2026-01 Car Toyota Yaris Grey Stop a vehicle on pedestrian crossing None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
10691 op-snap---monthly-publication-january-2026.pdf   152 2026-01 Car Toyota Auris Blue Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Church Street Lozells Church Street Lozells Birmingham Birmingham Warning Letter N/A   52.4997378 -1.9113714
10696 op-snap---monthly-publication-january-2026.pdf   157 2026-01 Car Vauxhall Mokka Black Stop a vehicle on pedestrian crossing None Summer Road at Marsh Lane Summer Road at Marsh Lane Birmingham Birmingham Education N/A   52.5224 -1.8440808
10697 op-snap---monthly-publication-january-2026.pdf   158 2026-01 Car Audi A4.. White Stop a vehicle on pedestrian crossing None Summer Road at Marsh Lane Summer Road at Marsh Lane Birmingham Birmingham Education N/A   52.5224 -1.8440808
10698 op-snap---monthly-publication-january-2026.pdf   159 2026-01 Car Porsche Panamera Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
10699 op-snap---monthly-publication-january-2026.pdf   160 2026-01 Car Land Rover Range Grey Stop a vehicle within pelican pedestrian crossing limits None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
10700 op-snap---monthly-publication-january-2026.pdf   161 2026-01 Car Iveco Daily White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
10701 op-snap---monthly-publication-january-2026.pdf   162 2026-01 Car Volvo XC40.. White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Camrose Croft Camrose Croft Birmingham Birmingham Warning Letter N/A   52.4583441 -1.8904687
10719 op-snap---monthly-publication-january-2026.pdf   180 2026-01 Car Ford Kuga White Cause vehicle to be left in a dangerous position None Moor Green Lane Moor Green Lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
10720 op-snap---monthly-publication-january-2026.pdf   181 2026-01 Car Vauxhall Mokka White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dale St Dale Street Wolverhampton Wolverhampton Warning Letter N/A   52.5811293 -2.1369957
10721 op-snap---monthly-publication-january-2026.pdf   182 2026-01 Car Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Zoar Street Zoar Street Wolverhampton Wolverhampton NFA No Offence   52.5807478 -2.1383109
10722 op-snap---monthly-publication-january-2026.pdf   183 2026-01 Car Toyota Yaris Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Zoar Street Zoar Street Wolverhampton Wolverhampton Warning Letter N/A   52.5807478 -2.1383109
10723 op-snap---monthly-publication-january-2026.pdf   184 2026-01 Car Alfa Romeo Brera Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Zoar Street Zoar Street Wolverhampton Wolverhampton Warning Letter N/A   52.5807478 -2.1383109

Next page

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