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

143 rows where month = "2026-01", offence = "Contravening a Red Traffic Light" 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

disposal 5

reporter_transport_mode 1

  • Car · 143 ✖

offence 1

  • Contravening a Red Traffic Light · 143 ✖

month 1

  • 2026-01 · 143 ✖
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
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
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      
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
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
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
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
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
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
10738 op-snap---monthly-publication-january-2026.pdf   199 2026-01 Car Ford Transit White Contravening a Red Traffic Light None A454 Black Country Route Black Country Route Wolverhampton Wolverhampton Education N/A   52.5642677 -2.0755469
10743 op-snap---monthly-publication-january-2026.pdf   204 2026-01 Car Ford Ranger Red Contravening a Red Traffic Light None A45 Coventry - Jct of Tile Hill Lane Coventry - Junction of Tile Hill Lane Coventry Coventry Education N/A      
10747 op-snap---monthly-publication-january-2026.pdf   208 2026-01 Car Peugeot 208 Grey Contravening a Red Traffic Light None Eachelhurst Road Eachelhurst Road Sutton Coldfield Sutton Coldfield Education N/A   52.5376965 -1.80033
10750 op-snap---monthly-publication-january-2026.pdf   211 2026-01 Car Seat Ibiza White Contravening a Red Traffic Light None Heath Way Heath Way Birmingham Birmingham Education N/A   52.4963549 -1.7806171
10759 op-snap---monthly-publication-january-2026.pdf   220 2026-01 Car Volvo V60 Red Contravening a Red Traffic Light None Dartmouth Road Dartmouth Road Birmingham Birmingham Education N/A   52.4425813 -1.9338044
10789 op-snap---monthly-publication-january-2026.pdf   250 2026-01 Car Mercedes-Benz C250 White Contravening a Red Traffic Light None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA Not in Public Interest   52.5047428 -2.0823754
10790 op-snap---monthly-publication-january-2026.pdf   251 2026-01 Car Land Rover Discovery Black Contravening a Red Traffic Light None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA No Independent Evidence Available   52.5047428 -2.0823754
10793 op-snap---monthly-publication-january-2026.pdf   254 2026-01 Car Volkswagen Taigo Blue Contravening a Red Traffic Light None Holder Road Holder Road Birmingham Birmingham Fixed Penalty N/A   52.4655509 -1.8219
10795 op-snap---monthly-publication-january-2026.pdf   256 2026-01 Car BMW 1 Series Blue Contravening a Red Traffic Light None Coventry Road, Exhall Coventry Road, Exhall Out of Force Area Out of Force Area NFA Out of Force      
10811 op-snap---monthly-publication-january-2026.pdf   272 2026-01 Car Audi A3 Grey Contravening a Red Traffic Light None Church Lane Church Lane Sandwell Sandwell Education N/A   52.5311655 -2.0008707
10818 op-snap---monthly-publication-january-2026.pdf   279 2026-01 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Horseley Heath, Great Bridge Horseley Heath, Great Bridge Sandwell Sandwell NFA No Independent Evidence Available   52.5289091 -2.0391504
10827 op-snap---monthly-publication-january-2026.pdf   288 2026-01 Car Vauxhall Antara White Contravening a Red Traffic Light None Middleton Hall Road Middleton Hall Road Birmingham Birmingham NFA No Independent Evidence Available   52.4149989 -1.9345999
10852 op-snap---monthly-publication-january-2026.pdf   313 2026-01 Car Audi A3 Black Contravening a Red Traffic Light None Walsgrave Road Jct with Sky Blue Way Walsgrave Road Junction with Sky Blue Way Coventry Coventry Education N/A   52.410402 -1.4847441
10859 op-snap---monthly-publication-january-2026.pdf   320 2026-01 Car Toyota Yaris Green Contravening a Red Traffic Light No Insurance Alcester Road Alcester Road Birmingham Birmingham Court N/A   52.4470686 -1.8880749
10864 op-snap---monthly-publication-january-2026.pdf   325 2026-01 Car Mercedes-Benz C220 Grey Contravening a Red Traffic Light None Cole Brook Road Cole Brook Road Birmingham Birmingham Fixed Penalty N/A   52.4968357 -1.7908553
10897 op-snap---monthly-publication-january-2026.pdf   358 2026-01 Car Vauxhall Astra Silver Contravening a Red Traffic Light None Commonside Commonside Dudley Dudley Fixed Penalty N/A   52.4931112 -2.1326078
10919 op-snap---monthly-publication-january-2026.pdf   380 2026-01 Car Vauxhall Zafira Silver Contravening a Red Traffic Light None Hagley Road at Highfield Road Hagley Road at Highfield Road Birmingham Birmingham Warning Letter N/A   52.471836 -1.9401037
10940 op-snap---monthly-publication-january-2026.pdf   401 2026-01 Car Citroen C1 Black Contravening a Red Traffic Light None Foleshill Road Foleshill Road Coventry Coventry Education N/A   52.4274335 -1.5002381
10945 op-snap---monthly-publication-january-2026.pdf   406 2026-01 Car Volkswagen Passat Black Contravening a Red Traffic Light None Portland Road Portland Road Birmingham Birmingham NFA Misc Inc Crimes   52.4737014 -1.9412436
10952 op-snap---monthly-publication-january-2026.pdf   413 2026-01 Car Hyundai Tuscan Black Contravening a Red Traffic Light None Walsall Road, Perry Barr Walsall Road, Perry Barr Birmingham Birmingham NFA No Offence   52.5290137 -1.9098939
10963 op-snap---monthly-publication-january-2026.pdf   424 2026-01 Car Scania Tipper Yellow Contravening a Red Traffic Light None Birmingham Road Birmingham Road Dudley Dudley Warning Letter N/A   52.5131355 -2.0651615
10970 op-snap---monthly-publication-january-2026.pdf   431 2026-01 Car Suzuki Vitara Black Contravening a Red Traffic Light None Winsford Avenue Winsford Avenue Coventry Coventry Education N/A   52.4151819 -1.5629773
10983 op-snap---monthly-publication-january-2026.pdf   444 2026-01 Car Ford Transit White Contravening a Red Traffic Light none London Road London Road Coventry Coventry Fixed Penalty N/A   52.3916468 -1.4925995
10991 op-snap---monthly-publication-january-2026.pdf   452 2026-01 Car Daf Coach White Contravening a Red Traffic Light None Cromwell Lane, Burton Green, near HS2 bridge. Warwickshire Cromwell Lane, Burton Green, near HS2 bridge. Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
10997 op-snap---monthly-publication-january-2026.pdf   458 2026-01 Car Seat Leon Black Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
11001 op-snap---monthly-publication-january-2026.pdf   462 2026-01 Car Honda Accord Silver Contravening a Red Traffic Light None Western Road / Dudley Road Western Road / Dudley Road Birmingham Birmingham Education N/A   52.5461182 -1.8340257
11012 op-snap---monthly-publication-january-2026.pdf   473 2026-01 Car Toyota Yaris Silver Contravening a Red Traffic Light None harrier Way to A34 harrier Way to A34 Birmingham Birmingham Education N/A      
11032 op-snap---monthly-publication-january-2026.pdf   493 2026-01 Car Mercedes-Benz CLA Grey Contravening a Red Traffic Light   Unknown, "between Ikea and Wolverhampton". Cannot idetify the road Unknown, "between Ikea and Wolverhampton". Cannot idetify the road Wolverhampton Wolverhampton NFA No Independent Evidence Available      
11033 op-snap---monthly-publication-january-2026.pdf   494 2026-01 Car Audi A5 Silver Contravening a Red Traffic Light None Silverwoods Road Silverwoods Road Out of Force Area Out of Force Area NFA Out of Force      
11072 op-snap---monthly-publication-january-2026.pdf   533 2026-01 Car Nissan Juke White Contravening a Red Traffic Light None A449 Wolverhampton Road Wolverhampton Road Wolverhampton Wolverhampton Education N/A   52.5968709 -2.0954054
11074 op-snap---monthly-publication-january-2026.pdf   535 2026-01 Car BMW 116d Black Contravening a Red Traffic Light None Soundwell Road, Bristol Soundwell Road, Bristol Out of Force Area Out of Force Area NFA Out of Force      
11075 op-snap---monthly-publication-january-2026.pdf   536 2026-01 Car Audi Q8 Beige Contravening a Red Traffic Light None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
11083 op-snap---monthly-publication-january-2026.pdf   544 2026-01 Car Dacia Duster Blue Contravening a Red Traffic Light None Newport Road Newport Road Birmingham Birmingham Education N/A   52.5027779 -1.7982159
11124 op-snap---monthly-publication-january-2026.pdf   585 2026-01 Car Vauxhall Astra Red Contravening a Red Traffic Light No Insurance Tyburn Road Tyburn Road Birmingham Birmingham NFA No Independent Evidence Available   52.5113867 -1.8337258
11125 op-snap---monthly-publication-january-2026.pdf   586 2026-01 Car Volkswagen Golf Blue Contravening a Red Traffic Light None Oxhill Road jn Rookery Road, Handsworth Oxhill Road jn Rookery Road, Handsworth Birmingham Birmingham Fixed Penalty N/A      
11128 op-snap---monthly-publication-january-2026.pdf   589 2026-01 Car Audi A3 Beige Contravening a Red Traffic Light None B4124 Old Walsall Road Old Walsall Road Birmingham Birmingham Fixed Penalty N/A   52.5294399 -1.9282714
11135 op-snap---monthly-publication-january-2026.pdf   596 2026-01 Car Vauxhall Corsa White Contravening a Red Traffic Light None Mary Vale Road Mary Vale Road Birmingham Birmingham NFA No Independent Evidence Available   52.425105 -1.9312861
11137 op-snap---monthly-publication-january-2026.pdf   598 2026-01 Car Mercedes-Benz Sprinter 314 White Contravening a Red Traffic Light None A45 Coventry Road, Sheldon Coventry Road, Sheldon Birmingham Birmingham Fixed Penalty N/A   52.4516212 -1.7687473
11142 op-snap---monthly-publication-january-2026.pdf   603 2026-01 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Minworth Island Minworth Island Sutton Coldfield Sutton Coldfield Court N/A   52.5310982 -1.7747583
11149 op-snap---monthly-publication-january-2026.pdf   610 2026-01 Car Peugeot 108.. Purple Contravening a Red Traffic Light None A45 A45 Birmingham Birmingham Education N/A      
11163 op-snap---monthly-publication-january-2026.pdf   624 2026-01 Car Vauxhall Astra White Contravening a Red Traffic Light None Dunchurch Road Dunchurch Road Out of Force Area Out of Force Area NFA Out of Force   52.390889 -1.6541476
11168 op-snap---monthly-publication-january-2026.pdf   629 2026-01 Car Toyota Rav 4 Grey Contravening a Red Traffic Light None Waterloo Road Waterloo Road Wolverhampton Wolverhampton Education N/A   52.5960155 -2.1295068
11169 op-snap---monthly-publication-january-2026.pdf   630 2026-01 Car Mercedes-Benz Citan White Contravening a Red Traffic Light None Darthmouth Middleway Darthmouth Middleway Birmingham Birmingham NFA No Offence      
11199 op-snap---monthly-publication-january-2026.pdf   660 2026-01 Car Volkswagen T-Roc Blue Contravening a Red Traffic Light None Reddings Lane Tysley Reddings Lane Tysley Birmingham Birmingham Court N/A      
11201 op-snap---monthly-publication-january-2026.pdf   662 2026-01 Car Vauxhall Astra White Contravening a Red Traffic Light None Ickneild Street Ickneild Street Birmingham Birmingham Warning Letter N/A   52.3992394 -1.919918
11202 op-snap---monthly-publication-january-2026.pdf   663 2026-01 Car Toyota Corolla Silver Contravening a Red Traffic Light None Reddings Lane Tysley Reddings Lane Tysley Birmingham Birmingham Education N/A      
11214 op-snap---monthly-publication-january-2026.pdf   675 2026-01 Car Ford Focus Red Contravening a Red Traffic Light None Telford Town Centre Telford Town Centre Out of Force Area Out of Force Area NFA Out of Force      
11231 op-snap---monthly-publication-january-2026.pdf   692 2026-01 Car Nissan   Red Contravening a Red Traffic Light None Wilford Lane Wilford Lane Out of Force Area Out of Force Area NFA Out of Force      
11243 op-snap---monthly-publication-january-2026.pdf   704 2026-01 Car Audi RS5.. Grey Contravening a Red Traffic Light None Spitfire Island Spitfire Island Birmingham Birmingham Education N/A   52.5138106 -1.797297
11246 op-snap---monthly-publication-january-2026.pdf   707 2026-01 Car Honda Jazz Blue Contravening a Red Traffic Light None Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Education N/A      
11260 op-snap---monthly-publication-january-2026.pdf   721 2026-01 Car Volvo S80 Silver Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
11267 op-snap---monthly-publication-january-2026.pdf   728 2026-01 Car Seat Leon Silver Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
11277 op-snap---monthly-publication-january-2026.pdf   738 2026-01 Car Fiat 500.. Black Contravening a Red Traffic Light None Stafford Road Stafford Road Wolverhampton Wolverhampton NFA No VRM   52.6291998 -2.126312
11280 op-snap---monthly-publication-january-2026.pdf   741 2026-01 Car Renault Clio Beige Contravening a Red Traffic Light None Venture Way Brierley Hill Venture Way Brierley Hill Dudley Dudley Education N/A   52.4845535 -2.1206737
11284 op-snap---monthly-publication-january-2026.pdf   745 2026-01 Car Mercedes-Benz GLA Black Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
11310 op-snap---monthly-publication-january-2026.pdf   771 2026-01 Car BMW   Blue Contravening a Red Traffic Light None A34 Newcastle Newcastle Out of Force Area Out of Force Area NFA Out of Force      
11312 op-snap---monthly-publication-january-2026.pdf   773 2026-01 Car Toyota Prius White Contravening a Red Traffic Light None Walsgrave Road Walsgrave Road Coventry Coventry Warning Letter N/A   52.4096725 -1.487901
11318 op-snap---monthly-publication-january-2026.pdf   779 2026-01 Car Nissan ARIYA Black Contravening a Red Traffic Light None Wake Green Road Wake Green Road Birmingham Birmingham Education N/A   52.4437078 -1.8783408
11332 op-snap---monthly-publication-january-2026.pdf   793 2026-01 Car Nissan X Trail Green Contravening a Red Traffic Light None Wednesbury Interchange Wednesbury Interchange Sandwell Sandwell Education N/A   52.5660847 -2.0041239
11333 op-snap---monthly-publication-january-2026.pdf   794 2026-01 Car Peugeot 308 GT Red Contravening a Red Traffic Light None Blakesley Road Blakesley Road Birmingham Birmingham Education N/A   52.473201 -1.8086134
11334 op-snap---monthly-publication-january-2026.pdf   795 2026-01 Car Citroen DS3 Silver Contravening a Red Traffic Light None Blakesley Road Blakesley Road Birmingham Birmingham Education N/A   52.473201 -1.8086134
11338 op-snap---monthly-publication-january-2026.pdf   799 2026-01 Car Nissan Note Beige Contravening a Red Traffic Light None Bescot Road Bescot Road Walsall Walsall Education N/A   52.5707373 -2.0014215
11369 op-snap---monthly-publication-january-2026.pdf   830 2026-01 Car Iveco EuroCargo White Contravening a Red Traffic Light None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
11370 op-snap---monthly-publication-january-2026.pdf   831 2026-01 Car BMW X5.. Blue Contravening a Red Traffic Light None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
11386 op-snap---monthly-publication-january-2026.pdf   847 2026-01 Car Mercedes-Benz E350 Silver Contravening a Red Traffic Light None Water Orton Road Water Orton Road Birmingham Birmingham NFA No Independent Evidence Available   52.5153394 -1.7573409
11390 op-snap---monthly-publication-january-2026.pdf   851 2026-01 Car BMW 1 Series Grey Contravening a Red Traffic Light None Cooks Lane Cooks Lane Birmingham Birmingham Education N/A   52.482758 -1.7603097
11394 op-snap---monthly-publication-january-2026.pdf   855 2026-01 Car Honda Jazz Black Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
11395 op-snap---monthly-publication-january-2026.pdf   856 2026-01 Car BMW 218D White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
11397 op-snap---monthly-publication-january-2026.pdf   858 2026-01 Car Skoda Octavia Blue Contravening a Red Traffic Light No Insurance Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
11401 op-snap---monthly-publication-january-2026.pdf   862 2026-01 Car Vauxhall Corsa Grey Contravening a Red Traffic Light None Friary Road Friary Road Birmingham Birmingham Education N/A   52.5162814 -1.9395798
11414 op-snap---monthly-publication-january-2026.pdf   875 2026-01 Car Honda CRV Black Contravening a Red Traffic Light None M54 J4 Telford M54 J4 Telford Out of Force Area Out of Force Area NFA Out of Force      
11418 op-snap---monthly-publication-january-2026.pdf   879 2026-01 Car Porsche Macan Black Contravening a Red Traffic Light None Summer Lane Summer Lane Birmingham Birmingham Fixed Penalty N/A   52.4948034 -1.8983555
11419 op-snap---monthly-publication-january-2026.pdf   880 2026-01 Car Toyota   Silver Contravening a Red Traffic Light None Walsall Street Walsall Street Sandwell Sandwell NFA No VRM   52.518373 -1.9888052
11421 op-snap---monthly-publication-january-2026.pdf   882 2026-01 Car Ford Fiesta Grey Contravening a Red Traffic Light None High St West Brom High Street West Brom Sandwell Sandwell Education N/A      
11428 op-snap---monthly-publication-january-2026.pdf   889 2026-01 Car Vauxhall Crossland Silver Contravening a Red Traffic Light None Wood Lane Wood Lane Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6245669 -2.1205194
11429 op-snap---monthly-publication-january-2026.pdf   890 2026-01 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
11431 op-snap---monthly-publication-january-2026.pdf   892 2026-01 Car Man TGE Blue Contravening a Red Traffic Light None Princes Way Princes Way Birmingham Birmingham Education N/A      
11439 op-snap---monthly-publication-january-2026.pdf   900 2026-01 Car Hyundai I 10.. White Contravening a Red Traffic Light None Cooks Lane Cooks Lane Birmingham Birmingham Warning Letter N/A   52.482758 -1.7603097
11452 op-snap---monthly-publication-january-2026.pdf   913 2026-01 Car Ford Transit White Contravening a Red Traffic Light None Tamworth Road Tamworth Road Birmingham Birmingham Warning Letter N/A   52.5724303 -1.8191247
11478 op-snap---monthly-publication-january-2026.pdf   939 2026-01 Car Vauxhall Astra Blue Contravening a Red Traffic Light None Downing Street Downing Street Sandwell Sandwell Court N/A   52.5015329 -1.9556094
11489 op-snap---monthly-publication-january-2026.pdf   950 2026-01 Car Audi A6 Grey Contravening a Red Traffic Light None Darlsaton Lane Darlsaton Lane Wolverhampton Wolverhampton Education N/A      
11496 op-snap---monthly-publication-january-2026.pdf   957 2026-01 Car BMW 640.. White Contravening a Red Traffic Light None A34 Grey Friars Grey Friars Out of Force Area Out of Force Area NFA Out of Force      
11514 op-snap---monthly-publication-january-2026.pdf   975 2026-01 Car Peugeot 2008 Grey Contravening a Red Traffic Light None Oxhill Road Oxhill Road Birmingham Birmingham Education N/A   52.513857 -1.9367367
11523 op-snap---monthly-publication-january-2026.pdf   984 2026-01 Car Volkswagen Polo Black Contravening a Red Traffic Light None Church Road, Yardley Church Road, Yardley Birmingham Birmingham Fixed Penalty N/A   52.4655896 -1.8112542
11524 op-snap---monthly-publication-january-2026.pdf   985 2026-01 Car Volkswagen Passatt Red Contravening a Red Traffic Light None A38 Minworth Minworth Sutton Coldfield Sutton Coldfield Education N/A   52.5301514 -1.7586638
11525 op-snap---monthly-publication-january-2026.pdf   986 2026-01 Car Volvo XC60.. Blue Contravening a Red Traffic Light None A38 Minworth Island Minworth Island Sutton Coldfield Sutton Coldfield Education N/A   52.5310982 -1.7747583
11526 op-snap---monthly-publication-january-2026.pdf   987 2026-01 Car Land Rover Range Rover grey Contravening a Red Traffic Light None Union Road Solihull Union Road Solihull Solihull Solihull Fixed Penalty N/A   52.4044229 -1.8141776
11572 op-snap---monthly-publication-january-2026.pdf   1033 2026-01 Car Cupra Leon White Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Fixed Penalty N/A   52.5083238 -1.8332287
11576 op-snap---monthly-publication-january-2026.pdf   1037 2026-01 Car Toyota Yaris Grey Contravening a Red Traffic Light None Lode Lane Lode Lane Solihull Solihull Education N/A   52.4149064 -1.7832364
11601 op-snap---monthly-publication-january-2026.pdf   1062 2026-01 Car Toyota Aygo White Contravening a Red Traffic Light None Meadway Meadway Birmingham Birmingham Education N/A   52.4783348 -1.8007708

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