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

159 rows where month = "2025-01" and offence = "Contravening a Red Traffic Light" 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 27

reporter_transport_mode 5

offence 1

  • Contravening a Red Traffic Light · 159 ✖

month 1

  • 2025-01 · 159 ✖
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
8913 op-snap---monthly-publication-january-2025.pdf   21 2025-01 Car Honda Civic Red Contravening a Red Traffic Light None Bosty Lane Bosty Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5948329 -1.927787
8923 op-snap---monthly-publication-january-2025.pdf   31 2025-01 Car Volkswagen Golf Grey Contravening a Red Traffic Light None Dudley Road Dudley Road Halesowen Halesowen Education N/A Yes - Via Email 52.5717314 -2.1249182
8926 op-snap---monthly-publication-january-2025.pdf   34 2025-01 Car BMW 320i Black Contravening a Red Traffic Light None Kings Road Kings Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5531351 -1.8852761
8940 op-snap---monthly-publication-january-2025.pdf   48 2025-01 Car BMW X1 White Contravening a Red Traffic Light None Wednesfield Road Wednesfield Road Wolverhampton Wolverhampton Education N/A Yes - Via Email 52.5885601 -2.122003
8946 op-snap---monthly-publication-january-2025.pdf   54 2025-01 Car Mercedes-Benz GLB 200 Black Contravening a Red Traffic Light None Lickey Road Lickey Road Birmingham Birmingham NFA Out of Force Yes - Via Email 52.3868298 -2.0003781
8986 op-snap---monthly-publication-january-2025.pdf   94 2025-01 CAR Toyota YARIS Blue Contravening a Red Traffic Light None A34 STRATFORD ROAD A34 Stratford Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4496153 -1.8646204
9018 op-snap---monthly-publication-january-2025.pdf   126 2025-01 Car Audi A3 Silver Contravening a Red Traffic Light NONE WEDNESBURY INTERCHANGE Wednesbury Interchange Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5667977 -2.0037424
9021 op-snap---monthly-publication-january-2025.pdf   129 2025-01 Car Ford TRANSIT White Contravening a Red Traffic Light None A452 CHESTER ROAD A452 Chester Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.5338529 -1.8296813
9023 op-snap---monthly-publication-january-2025.pdf   131 2025-01 Car Hyundai TUCSON Grey Contravening a Red Traffic Light None Wolverhampton road Wolverhampton road Birmingham Birmingham Education N/A Yes - Via Email 52.463146 -1.9844677
9028 op-snap---monthly-publication-january-2025.pdf   136 2025-01 Pedestrian Skoda Kamiq Grey Contravening a Red Traffic Light None Rivcer Drive Rivcer Drive Walsall Walsall NFA Out of Force Yes - Via Email    
9038 op-snap---monthly-publication-january-2025.pdf   146 2025-01 Car BMW 118i Grey Contravening a Red Traffic Light None Darlaston Road Darlaston Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5635181 -2.0322876
9039 op-snap---monthly-publication-january-2025.pdf   147 2025-01 Car Audi A3 Grey Contravening a Red Traffic Light None Darlaston Road Darlaston Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5635181 -2.0322876
9064 op-snap---monthly-publication-january-2025.pdf   172 2025-01 Car Nissan Juke White Contravening a Red Traffic Light None Five Ways roundabout Five Ways roundabout Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9065 op-snap---monthly-publication-january-2025.pdf   173 2025-01 Car Ford Focus Blue Contravening a Red Traffic Light None Lode Lane, Solihull Lode Lane, Solihull Solihull Solihull Court N/A Yes - Via Email 52.4286691 -1.7775374
9069 op-snap---monthly-publication-january-2025.pdf   177 2025-01 Car Toyota Noah White Contravening a Red Traffic Light None A45 A45 Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9076 op-snap---monthly-publication-january-2025.pdf   184 2025-01 Pedal Bike Ford Fiesta Black Contravening a Red Traffic Light None A441 Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4308271 -1.920078
9087 op-snap---monthly-publication-january-2025.pdf   195 2025-01 Car BMW 3 series Black Contravening a Red Traffic Light No Insurance Chase Road Chase Road Walsall Walsall Court N/A Yes - Via Email 52.6146822 -2.0143222
9091 op-snap---monthly-publication-january-2025.pdf   199 2025-01 Car Hyundai I10 White Contravening a Red Traffic Light None Coventry Ring Road Coventry Ring Road Coventry Coventry Court N/A Yes - Via Email    
9106 op-snap---monthly-publication-january-2025.pdf   214 2025-01 Car Volvo V40 White Contravening a Red Traffic Light None Island Road Island Road Birmingham Birmingham Education N/A Yes - Via Email 52.5095686 -1.9544485
9147 op-snap---monthly-publication-january-2025.pdf   255 2025-01 Car Nissan Juke Black Contravening a Red Traffic Light None Harborne Lane Harborne Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4468464 -1.9454816
9151 op-snap---monthly-publication-january-2025.pdf   259 2025-01 Car Mercedes-Benz E220 Blue Contravening a Red Traffic Light None Parkfield Road Parkfield Road Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.567016 -2.1208485
9161 op-snap---monthly-publication-january-2025.pdf   269 2025-01 Car Renault Clio Silver Contravening a Red Traffic Light None Factory Road, Tipton Factory Road, Tipton Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5301378 -2.071306
9172 op-snap---monthly-publication-january-2025.pdf   280 2025-01 Car Peugeot 208 Blue Contravening a Red Traffic Light None WALSGRAVE ROAD Walsgrave Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4096725 -1.487901
9205 op-snap---monthly-publication-january-2025.pdf   313 2025-01 Car Volkswagen GOLF Black Contravening a Red Traffic Light None WAKE GREEN ROAD Wake Green Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4437078 -1.8783408
9211 op-snap---monthly-publication-january-2025.pdf   319 2025-01 Car Kia Picanto Red Contravening a Red Traffic Light None Soho Road Soho Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.502568 -1.9305447
9223 op-snap---monthly-publication-january-2025.pdf   331 2025-01 Car Toyota PRIUS White Contravening a Red Traffic Light None HENLEY GREEN ROAD Henley Green Road Coventry Coventry Education N/A Yes - Via Email 52.4283425 -1.4543011
9225 op-snap---monthly-publication-january-2025.pdf   333 2025-01 Car Renault KANGOO White Contravening a Red Traffic Light None Oxford Street, Bilston Oxford Street, Bilston Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.5631051 -2.0668747
9232 op-snap---monthly-publication-january-2025.pdf   340 2025-01 Pedal Bike Audi A3 Black Contravening a Red Traffic Light None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4221152 -1.4959475
9246 op-snap---monthly-publication-january-2025.pdf   354 2025-01 Car Mercedes-Benz CLA250 White Contravening a Red Traffic Light None Wheelwright Lane Wheelwright Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5089309 -1.8333828
9259 op-snap---monthly-publication-january-2025.pdf   367 2025-01 Car Vauxhall ASTRA SRI Grey Contravening a Red Traffic Light Driving without Due Care and Attention BRISTOL ROAD Bristol Road Birmingham Birmingham Court N/A Yes - Via Email 52.4543565 -1.9114004
9295 op-snap---monthly-publication-january-2025.pdf   403 2025-01 Car Mercedes-Benz C350 Blue Contravening a Red Traffic Light None Lode Lane Lode Lane Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.4149064 -1.7832364
9299 op-snap---monthly-publication-january-2025.pdf   407 2025-01 Car Ford Transit White Contravening a Red Traffic Light None Wood Green Road Wood Green Road Walsall Walsall Education N/A Yes - Via Email 52.6248989 -1.9343969
9300 op-snap---monthly-publication-january-2025.pdf   408 2025-01 Car Land Rover Evoque White Contravening a Red Traffic Light None A491/A456 West Hagley- West Mercia A491/A456 West Hagley- West Mercia Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9340 op-snap---monthly-publication-january-2025.pdf   448 2025-01 Car Volkswagen UP Silver Contravening a Red Traffic Light No Insurance CUCKOO ROAD Cuckoo Road Birmingham Birmingham Court N/A Yes - Via Email 52.5049023 -1.8603659
9351 op-snap---monthly-publication-january-2025.pdf   459 2025-01 car Peugeot EXPERT White Contravening a Red Traffic Light None FOLESHILL ROAD Foleshill Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4274335 -1.5002381
9360 op-snap---monthly-publication-january-2025.pdf   468 2025-01 Car BMW X5 Grey Contravening a Red Traffic Light None Newton Road, Hamstead Newton Road, Hamstead Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5429259 -1.9534939
9366 op-snap---monthly-publication-january-2025.pdf   474 2025-01 Car Nissan X-TRAIL Black Contravening a Red Traffic Light None SOHO ROAD Soho Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.502568 -1.9305447
9371 op-snap---monthly-publication-january-2025.pdf   479 2025-01 Car Vauxhall Corsa Blue Contravening a Red Traffic Light None Stafford Road Stafford Road Wolverhampton Wolverhampton Fixed Penalty n/a Yes - Via Email 52.6291998 -2.126312
9378 op-snap---monthly-publication-january-2025.pdf   486 2025-01 Car Nissan Note Silver Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4203897 -1.8338574
9379 op-snap---monthly-publication-january-2025.pdf   487 2025-01 Car Ford Transit White Contravening a Red Traffic Light None Dartmouth Circus Dartmouth Circus Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4926487 -1.8879638
9382 op-snap---monthly-publication-january-2025.pdf   490 2025-01 Pedal Bike BMW 340d Orange Contravening a Red Traffic Light None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4308271 -1.920078
9395 op-snap---monthly-publication-january-2025.pdf   503 2025-01 Car Ford Kuga Grey Contravening a Red Traffic Light None Antrobus Road Antrobus Road Birmingham Birmingham Education N/A Yes - Via Email 52.5457851 -1.8457052
9403 op-snap---monthly-publication-january-2025.pdf   511 2025-01 Car Isuzu D MAX Grey Contravening a Red Traffic Light None DARTMOUTH CIRCUS Dartmouth Circus Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4926487 -1.8879638
9413 op-snap---monthly-publication-january-2025.pdf   521 2025-01 Pedestrian       Contravening a Red Traffic Light None Walsall unknown Walsall unknown Walsall Walsall NFA No VRM Yes - Via Email    
9426 op-snap---monthly-publication-january-2025.pdf   534 2025-01 Car Honda Civic Red Contravening a Red Traffic Light None Highgate Road Highgate Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4606652 -1.8791145
9427 op-snap---monthly-publication-january-2025.pdf   535 2025-01 Car Vauxhall Corsa Silver Contravening a Red Traffic Light None Lawley Middleway Lawley Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4801772 -1.8769185
9428 op-snap---monthly-publication-january-2025.pdf   536 2025-01 Car Honda Civic Red Contravening a Red Traffic Light None Lawley Middleway Lawley Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4801772 -1.8769185
9435 op-snap---monthly-publication-january-2025.pdf   543 2025-01 Car Seat IBIZA White Contravening a Red Traffic Light None LOWER TESSAL LANE Lower Tessal Lane Birmingham Birmingham NFA No Offence Yes - Via Email    
9492 op-snap---monthly-publication-january-2025.pdf   600 2025-01 Car Ford Fiesta Grey Contravening a Red Traffic Light None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton NFA No Independent Evidence Available Yes - Via Email 52.5847884 -2.1341887
9497 op-snap---monthly-publication-january-2025.pdf   605 2025-01 Car Mercedes-Benz S350 Black Contravening a Red Traffic Light None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.5847884 -2.1341887
9509 op-snap---monthly-publication-january-2025.pdf   617 2025-01 Pedal Bike Ford Transit Blue Contravening a Red Traffic Light None M42 J4 M42 J4 Solihull Solihull Fixed Penalty N/A Yes - Via Email    
9532 op-snap---monthly-publication-january-2025.pdf   640 2025-01 Car Ford Kuga Blue Contravening a Red Traffic Light None Ansty Road, Coventry Ansty Road, Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4205675 -1.4520187
9541 op-snap---monthly-publication-january-2025.pdf   649 2025-01 Car Seat Ibiza White Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5083238 -1.8332287
9542 op-snap---monthly-publication-january-2025.pdf   650 2025-01 Car Land Rover Evoque Black Contravening a Red Traffic Light Driving without Due Care and Attention Cradley Road, Netherton Cradley Road, Netherton Dudley Dudley Court N/A Yes - Via Email 52.4877241 -2.0818998
9546 op-snap---monthly-publication-january-2025.pdf   654 2025-01 Car Toyota Prius White Contravening a Red Traffic Light None Broad Street Broad Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4749212 -1.9147497
9558 op-snap---monthly-publication-january-2025.pdf   666 2025-01 Pedestrian   MAN White Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.5113867 -1.8337258
9565 op-snap---monthly-publication-january-2025.pdf   673 2025-01 Car Volkswagen Golf Black Contravening a Red Traffic Light No Insurance Junction 10, M6 Junction 10, M6 Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email    
9566 op-snap---monthly-publication-january-2025.pdf   674 2025-01 Car Daf TRUCK White Contravening a Red Traffic Light None WOLVERHAMPTON ROAD Wolverhampton Road Walsall Walsall Other Action Taken eNn/A Yes - Via Email 52.5867763 -2.0104342
9574 op-snap---monthly-publication-january-2025.pdf   682 2025-01 Car Skoda Fabia Silver Contravening a Red Traffic Light No Insurance Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A Yes - Via Email 52.4929304 -1.8229092
9591 op-snap---monthly-publication-january-2025.pdf   699 2025-01 Car Ford Transit White Contravening a Red Traffic Light None Shaw Road Shaw Road Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5480002 -2.0943429
9592 op-snap---monthly-publication-january-2025.pdf   700 2025-01 Car Seat Cupra Gold Contravening a Red Traffic Light None Yardley Green Rd Yardley Green Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.4764154 -1.8311418
9625 op-snap---monthly-publication-january-2025.pdf   733 2025-01 Car Ford Fiesta Silver Contravening a Red Traffic Light None Monkspath Interchange Monkspath Interchange Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.3792737 -1.7869373
9627 op-snap---monthly-publication-january-2025.pdf   735 2025-01 Car BMW 320 Black Contravening a Red Traffic Light None Sliproad M6 South Jct 9, Wednesbury Sliproad M6 South Junction 9, Wednesbury Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
9629 op-snap---monthly-publication-january-2025.pdf   737 2025-01 Car Vauxhall Corsa Black Contravening a Red Traffic Light Use vehicle on a road without valid test c eWrtaifriwcaictek Road e Wrtaifriwcaictek Road Birmingham Birmingham Court N/A Yes - Via Email    
9639 op-snap---monthly-publication-january-2025.pdf   747 2025-01 Car Mercedes-Benz E250 Silver Contravening a Red Traffic Light None Wolverhampton Road Wolverhampton Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4702299 -1.9948976
9654 op-snap---monthly-publication-january-2025.pdf   762 2025-01 Car Volkswagen Polo Red Contravening a Red Traffic Light None Chapel Ash Chapel Ash Wolverhampton Wolverhampton Education N/A Yes - Via Email 52.5857494 -2.1409393
9657 op-snap---monthly-publication-january-2025.pdf   765 2025-01 Pedal Bike Kia Ceed Brown Contravening a Red Traffic Light None Beake Ave Beake Ave Coventry Coventry NFA No Independent Evidence Available Yes - Via Email 52.4360855 -1.5226352
9662 op-snap---monthly-publication-january-2025.pdf   770 2025-01 Car Audi A3 Black Contravening a Red Traffic Light None Church Road A4040 Church Road A4040 Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5040085 -1.876404
9665 op-snap---monthly-publication-january-2025.pdf   773 2025-01 Car Mercedes-Benz C class Silver Contravening a Red Traffic Light None Kings Road Kings Road Birmingham Birmingham Education N/A Yes - Via Email 52.5531351 -1.8852761
9668 op-snap---monthly-publication-january-2025.pdf   776 2025-01 Car BMW 430i White Contravening a Red Traffic Light VRM fails to conform to Regulations High Street, Quarry Bank High Street, Quarry Bank Dudley Dudley Court N/A Yes - Via Email 52.4576453 -2.1150716
9679 op-snap---monthly-publication-january-2025.pdf   787 2025-01 Car Mg HS White Contravening a Red Traffic Light None Stratford Road Stratford Road Solihull Solihull Education N/A Yes - Via Email 52.4191184 -1.8326637
9725 op-snap---monthly-publication-january-2025.pdf   833 2025-01 Car Vauxhall Corsa White Contravening a Red Traffic Light None Junction with A41 Bypass Junction with A41 Bypass Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
9744 op-snap---monthly-publication-january-2025.pdf   852 2025-01 Car Ford Focus Black Contravening a Red Traffic Light None Aston Road Aston Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.4929386 -1.888744
9747 op-snap---monthly-publication-january-2025.pdf   855 2025-01 Car Toyota Verso Silver Contravening a Red Traffic Light None Aston Road Aston Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4929386 -1.888744
9754 op-snap---monthly-publication-january-2025.pdf   862 2025-01 Car Volvo V70 Blue Contravening a Red Traffic Light Use vehicle on a road without valid test c eArLtCifEicSaTtEeR ROAD e Ar Lt Cif Eic Sa Tt Ee R ROAD Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9756 op-snap---monthly-publication-january-2025.pdf   864 2025-01 Car BMW 5 SERIES Black Contravening a Red Traffic Light None WATERLOO ROAD Waterloo Road Wolverhampton Wolverhampton NFA No VRM Yes - Via Email 52.5960155 -2.1295068
9759 op-snap---monthly-publication-january-2025.pdf   867 2025-01 Car Vauxhall CROSSLAND White Contravening a Red Traffic Light No Insurance SALFORD CIRCUS Salford Circus Birmingham Birmingham Court N/A Yes - Via Email 52.5095071 -1.8593732
9767 op-snap---monthly-publication-january-2025.pdf   875 2025-01 Car Peugeot 107 Blue Contravening a Red Traffic Light None A456 Hagley Road Hagley Road Birmingham Birmingham Education N/A Yes - Via Email 52.471632 -1.9456776
9784 op-snap---monthly-publication-january-2025.pdf   892 2025-01 Car Jaguar XF Grey Contravening a Red Traffic Light None NEWHAMPTON ROAD WEST Newhampton Road West Wolverhampton Wolverhampton NFA No Independent Evidence Available Yes - Via Email 52.5956595 -2.1550795
9788 op-snap---monthly-publication-january-2025.pdf   896 2025-01 Car   Renegade Grey Contravening a Red Traffic Light None Lichfield Road, Willenhall Lichfield Road, Willenhall Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email    
9791 op-snap---monthly-publication-january-2025.pdf   899 2025-01 Car Volkswagen Crafter White Contravening a Red Traffic Light None Blackhalve Lane Blackhalve Lane Wolverhampton Wolverhampton NFA No VRM Yes - Via Email 52.6139368 -2.0960778
9805 op-snap---monthly-publication-january-2025.pdf   913 2025-01 Car Volkswagen Transporter Black Contravening a Red Traffic Light None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.473883 -1.9198244
9822 op-snap---monthly-publication-january-2025.pdf   930 2025-01 Car Seat Leon White Contravening a Red Traffic Light None Clarke Road Clarke Road Wolverhampton Wolverhampton NFA No Offence Yes - Via Email    
9826 op-snap---monthly-publication-january-2025.pdf   934 2025-01 Car Hyundai i10 white Contravening a Red Traffic Light None Bromford Lane roundabout with Heartlands Parkway Bromford Lane roundabout with Heartlands Parkway Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9836 op-snap---monthly-publication-january-2025.pdf   944 2025-01 Car Renault Clio Black Contravening a Red Traffic Light None Birmingham New Road Birmingham New Road Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5478387 -2.0943116
9837 op-snap---monthly-publication-january-2025.pdf   945 2025-01 Car Daf truck Black Contravening a Red Traffic Light None Birmingham New Road Birmingham New Road Dudley Dudley NFA No Offence Yes - Via Email 52.5478387 -2.0943116
9844 op-snap---monthly-publication-january-2025.pdf   952 2025-01 Car Toyota Prius Silver Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5919543 -1.8517118
9845 op-snap---monthly-publication-january-2025.pdf   953 2025-01 Car Volvo X60 White Contravening a Red Traffic Light None HAGLEY ROAD Hagley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.471632 -1.9456776
9846 op-snap---monthly-publication-january-2025.pdf   954 2025-01 Car Toyota AVENSIS Black Contravening a Red Traffic Light None HAGLEY ROAD Hagley Road Birmingham Birmingham Education N/A Yes - Via Email 52.471632 -1.9456776
9849 op-snap---monthly-publication-january-2025.pdf   957 2025-01 Car Volkswagen GOLF Grey Contravening a Red Traffic Light None HAGLEY ROAD Hagley Road Birmingham Birmingham Education N/A Yes - Via Email 52.471632 -1.9456776
9864 op-snap---monthly-publication-january-2025.pdf   972 2025-01 Car Mercedes-Benz GLE 400 Grey Contravening a Red Traffic Light None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.473883 -1.9198244
9885 op-snap---monthly-publication-january-2025.pdf   993 2025-01 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Fletchamstead highway towards Vanguard Avenue Fletchamstead highway towards Vanguard Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email    
9889 op-snap---monthly-publication-january-2025.pdf   997 2025-01 Car Audi RS 5 Grey Contravening a Red Traffic Light None Brandwood Road Brandwood Road Birmingham Birmingham Court N/A Yes - Via Email 52.4139427 -1.9037653
9890 op-snap---monthly-publication-january-2025.pdf   998 2025-01 Car Mercedes-Benz CLA 200 Grey Contravening a Red Traffic Light None Northgate Northgate Walsall Walsall NFA No Offence Yes - Via Email 52.6094474 -1.9202238
9893 op-snap---monthly-publication-january-2025.pdf   1001 2025-01 Car Kia Niro Blue Contravening a Red Traffic Light None Skidmore Road Skidmore Road Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5501779 -2.0773101
9895 op-snap---monthly-publication-january-2025.pdf   1003 2025-01 Car Mini Cooper Silver Contravening a Red Traffic Light None Skidmore Road Skidmore Road Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5501779 -2.0773101
9899 op-snap---monthly-publication-january-2025.pdf   1007 2025-01 Car Ford Fiesta White Contravening a Red Traffic Light None Lewisham Road Lewisham Road Sandwell Sandwell NFA No Offence Yes - Via Email 52.5007274 -1.9661248
9909 op-snap---monthly-publication-january-2025.pdf   1017 2025-01 Car Volkswagen GOLF Grey Contravening a Red Traffic Light None JENENS ROAD Jenens Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9923 op-snap---monthly-publication-january-2025.pdf   1031 2025-01 Car Ford Fiesta Red Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.5919543 -1.8517118
9925 op-snap---monthly-publication-january-2025.pdf   1033 2025-01 Car Land Rover Velar Black Contravening a Red Traffic Light None Great Tindal Street Great Tindal Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4789283 -1.9215495

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