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

133 rows where disposal = "Fixed Penalty", month = "2025-03" 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

reporter_transport_mode 4

offence 1

  • Contravening a Red Traffic Light · 133 ✖

month 1

  • 2025-03 · 133 ✖

disposal 1

  • Fixed Penalty · 133 ✖
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
16265 op-snap---monthly-publication-march-2025.pdf   22 2025-03 Car Peugeot 508 Grey Contravening a Red Traffic Light None Lawley Middleway Lawley Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4801772 -1.8769185
16306 op-snap---monthly-publication-march-2025.pdf   63 2025-03 Pedal Bike BMW 330 Silver Contravening a Red Traffic Light None Mosley Road Mosley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4488097 -1.8877254
16325 op-snap---monthly-publication-march-2025.pdf   82 2025-03 Pedestrian Volvo XC40 Grey Contravening a Red Traffic Light None Daw End Lane, Rushall Daw End Lane, Rushall Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6051634 -1.956872
16396 op-snap---monthly-publication-march-2025.pdf   153 2025-03 Car Ford Fiesta Red Contravening a Red Traffic Light None Oxhill Road Oxhill Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.513857 -1.9367367
16397 op-snap---monthly-publication-march-2025.pdf   154 2025-03 Car BMW 116 Grey Contravening a Red Traffic Light None Hall Street Hall Street Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5409774 -2.1235921
16428 op-snap---monthly-publication-march-2025.pdf   185 2025-03 Pedestrian Jaguar XF. Red Contravening a Red Traffic Light None Daw End Lane at Lichfield Road Daw End Lane at Lichfield Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6057559 -1.9583791
16429 op-snap---monthly-publication-march-2025.pdf   186 2025-03 Pedestrian BMW 530 Red Contravening a Red Traffic Light None Daw End Lane at Lichfield Road Daw End Lane at Lichfield Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6057559 -1.9583791
16430 op-snap---monthly-publication-march-2025.pdf   187 2025-03 Pedestrian Honda Jazz Blue Contravening a Red Traffic Light None Daw End Lane at Lichfield Road Daw End Lane at Lichfield Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6057559 -1.9583791
16441 op-snap---monthly-publication-march-2025.pdf   198 2025-03 Car Fiat 500 White Contravening a Red Traffic Light None Bilston Street Bilston Street Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.5838892 -2.1231759
16469 op-snap---monthly-publication-march-2025.pdf   226 2025-03 Pedestrian Toyota Proace White Contravening a Red Traffic Light None Daw End Lane at Lichfield Road Daw End Lane at Lichfield Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6057559 -1.9583791
16470 op-snap---monthly-publication-march-2025.pdf   227 2025-03 Pedestrian Ford Transit White Contravening a Red Traffic Light None Daw End Lane at Lichfield Road Daw End Lane at Lichfield Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6057559 -1.9583791
16473 op-snap---monthly-publication-march-2025.pdf   230 2025-03 Pedestrian Ford Transit White Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16475 op-snap---monthly-publication-march-2025.pdf   232 2025-03 Pedestrian Vauxhall Insignia White Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16477 op-snap---monthly-publication-march-2025.pdf   234 2025-03 Pedestrian Audi A4 Red Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16493 op-snap---monthly-publication-march-2025.pdf   250 2025-03 Pedestrian Nissan Juke Black Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16522 op-snap---monthly-publication-march-2025.pdf   279 2025-03 Pedestrian Peugeot 208 White Contravening a Red Traffic Light None A46 Coventry Eastern Bypass Coventry Eastern Bypass Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3793117 -1.4625379
16537 op-snap---monthly-publication-march-2025.pdf   294 2025-03 Car Ford Transit White Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032
16539 op-snap---monthly-publication-march-2025.pdf   296 2025-03 Car Yamaha 125 Blue Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032
16541 op-snap---monthly-publication-march-2025.pdf   298 2025-03 Car   TGE Silver Contravening a Red Traffic Light None Toll Bar End Roundabout Toll Bar End Roundabout Coventry Coventry Fixed Penalty n/a Yes - Via Email    
16567 op-snap---monthly-publication-march-2025.pdf   324 2025-03 Car Seat ALHAMBRA Silver Contravening a Red Traffic Light None NEWPORT ROAD Newport Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5027779 -1.7982159
16571 op-snap---monthly-publication-march-2025.pdf   328 2025-03 Car Kia SPORTAGE White Contravening a Red Traffic Light None NEWPORT ROAD Newport Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5027779 -1.7982159
16600 op-snap---monthly-publication-march-2025.pdf   357 2025-03 Car Mercedes-Benz GLA White Contravening a Red Traffic Light None A41 Warwick Road Warwick Road Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.4428606 -1.812114
16617 op-snap---monthly-publication-march-2025.pdf   374 2025-03 Pedestrian Vauxhall Movano Black Contravening a Red Traffic Light None Dw End Lane Dw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email    
16618 op-snap---monthly-publication-march-2025.pdf   375 2025-03 Pedestrian Land Rover Velar Grey Contravening a Red Traffic Light None Dw End Lane Dw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email    
16619 op-snap---monthly-publication-march-2025.pdf   376 2025-03 Pedestrian Ford Connect Silver Contravening a Red Traffic Light None Dw End Lane Dw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email    
16620 op-snap---monthly-publication-march-2025.pdf   377 2025-03 Car BMW 435d Black Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5083238 -1.8332287
16670 op-snap---monthly-publication-march-2025.pdf   427 2025-03 Car Tesla Model3 White Contravening a Red Traffic Light None Highfield Rd, Edgbaston Highfield Road, Edgbaston Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4712241 -1.9259851
16773 op-snap---monthly-publication-march-2025.pdf   530 2025-03 Car Volkswagen Polo Silver Contravening a Red Traffic Light None Holyhead Road, Handsworth Holyhead Road, Handsworth Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.505233 -1.9446276
16830 op-snap---monthly-publication-march-2025.pdf   587 2025-03 Car Audi RS3 Blue Contravening a Red Traffic Light None Selly Oak Road at junction with Northfield Roa Selly Oak Road at junction with Northfield Roa dBirmingham Dbirmingham Fixed Penalty N/A Yes - Via Email 52.4263875 -1.9397954
16832 op-snap---monthly-publication-march-2025.pdf   589 2025-03 Car Renault Captur Orange Contravening a Red Traffic Light None Dudley Road East Dudley Road East Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5111988 -2.0318469
16851 op-snap---monthly-publication-march-2025.pdf   608 2025-03 Pedestrian Kia Ceed Black Contravening a Red Traffic Light None Spring Road, Tyseley Spring Road, Tyseley Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.444262 -1.8362585
16899 op-snap---monthly-publication-march-2025.pdf   656 2025-03 Pedestrian Volvo S60 White Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16905 op-snap---monthly-publication-march-2025.pdf   662 2025-03 Pedestrian Ford Transit Blue Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16909 op-snap---monthly-publication-march-2025.pdf   666 2025-03 Pedestrian Peugeot 308 Black Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16913 op-snap---monthly-publication-march-2025.pdf   670 2025-03 Pedestrian Vauxhall Zafira Silver Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16914 op-snap---monthly-publication-march-2025.pdf   671 2025-03 Pedestrian Hyundai I10. Grey Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16915 op-snap---monthly-publication-march-2025.pdf   672 2025-03 Pedestrian Peugeot 207.. Black Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16950 op-snap---monthly-publication-march-2025.pdf   707 2025-03 Pedal Bike Volkswagen Tiguan White Contravening a Red Traffic Light None Bordsley Green Bordsley Green Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
16954 op-snap---monthly-publication-march-2025.pdf   711 2025-03 Car Vauxhall Vivaro Grey Contravening a Red Traffic Light None Worcester Lane Worcester Lane Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.4336498 -2.1403487
16963 op-snap---monthly-publication-march-2025.pdf   720 2025-03 Car Audi A5 Silver Contravening a Red Traffic Light None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4543565 -1.9114004
16977 op-snap---monthly-publication-march-2025.pdf   734 2025-03 Motorbike Seat Arona Blue Contravening a Red Traffic Light None A38 A38 Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
16989 op-snap---monthly-publication-march-2025.pdf   746 2025-03 Car Toyota Yaris Grey Contravening a Red Traffic Light None Manor Lane Manor Lane Halesowen Halesowen Fixed Penalty N/A Yes - Via Email 52.4500678 -2.0276115
16992 op-snap---monthly-publication-march-2025.pdf   749 2025-03 Car Hyundai Tucson Grey Contravening a Red Traffic Light None Hamstead Road / Soho Hill Hamstead Road / Soho Hill Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.500402 -1.9189405
17008 op-snap---monthly-publication-march-2025.pdf   765 2025-03 Car BMW X5 Black Contravening a Red Traffic Light None Dudley Road Dudley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4865107 -1.9386263
17025 op-snap---monthly-publication-march-2025.pdf   782 2025-03 Car Skoda Octavia Black Contravening a Red Traffic Light None Grove Lane Grove Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5055208 -1.9328067
17034 op-snap---monthly-publication-march-2025.pdf   791 2025-03 Car Peugeot Expert Red Contravening a Red Traffic Light None Wolverhampton Street Wolverhampton Street Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5674241 -2.0426354
17065 op-snap---monthly-publication-march-2025.pdf   822 2025-03 Pedestrian Audi Q7 Grey Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17066 op-snap---monthly-publication-march-2025.pdf   823 2025-03 Pedestrian Volvo XC40 Blue Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17067 op-snap---monthly-publication-march-2025.pdf   824 2025-03 Pedestrian Hyundai i40 Red Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17068 op-snap---monthly-publication-march-2025.pdf   825 2025-03 Pedestrian Toyota Yaris Black Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17069 op-snap---monthly-publication-march-2025.pdf   826 2025-03 Pedestrian Mercedes-Benz 300 AMG White Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17070 op-snap---monthly-publication-march-2025.pdf   827 2025-03 Pedestrian Hyundai I40 Silver Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17072 op-snap---monthly-publication-march-2025.pdf   829 2025-03 Pedestrian Renault Captur Black Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17073 op-snap---monthly-publication-march-2025.pdf   830 2025-03 Pedestrian Suzuki SX4 Blue Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17085 op-snap---monthly-publication-march-2025.pdf   842 2025-03 Car Nissan Micra Black Contravening a Red Traffic Light None Warwick Road Warwick Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4555288 -1.8613929
17104 op-snap---monthly-publication-march-2025.pdf   861 2025-03 Car Kia RIO Red Contravening a Red Traffic Light None East Meadway East Meadway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4813031 -1.7670825
17125 op-snap---monthly-publication-march-2025.pdf   882 2025-03 Car Ford Fiesta White Contravening a Red Traffic Light None A452 Spitfire RA Spitfire RA Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
17126 op-snap---monthly-publication-march-2025.pdf   883 2025-03 Car   Ssangyong White Contravening a Red Traffic Light None Four Pounds Avenue Four Pounds Avenue Coventry Coventry Fixed Penalty N/A   52.413228 -1.5323652
17139 op-snap---monthly-publication-march-2025.pdf   896 2025-03 Car Audi A1 White Contravening a Red Traffic Light None Bull Street Bull Street Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.4758309 -2.1355917
17159 op-snap---monthly-publication-march-2025.pdf   916 2025-03 Car Citroen C3 Red Contravening a Red Traffic Light None All Saints Way All Saints Way Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5344405 -1.985568
17164 op-snap---monthly-publication-march-2025.pdf   921 2025-03 Pedestrian Toyota Auris Grey Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17165 op-snap---monthly-publication-march-2025.pdf   922 2025-03 Pedestrian Fiat Scudo White Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17167 op-snap---monthly-publication-march-2025.pdf   924 2025-03 Pedestrian Peugeot 308 White Contravening a Red Traffic Light None Daw End Lane Daw End Lane Metropolitan Borough of Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17168 op-snap---monthly-publication-march-2025.pdf   925 2025-03 Pedestrian Ford Fiesta White Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17170 op-snap---monthly-publication-march-2025.pdf   927 2025-03 Pedestrian Nissan NV400 White Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17177 op-snap---monthly-publication-march-2025.pdf   934 2025-03 Car Tesla Model 3 White Contravening a Red Traffic Light None Chapel Ash at Compton Road W`Ton Chapel Ash at Compton Road W`Ton Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.5857494 -2.1409393
17266 op-snap---monthly-publication-march-2025.pdf   1023 2025-03 Car Skoda Octavia Grey Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4203897 -1.8338574
17267 op-snap---monthly-publication-march-2025.pdf   1024 2025-03 Pedestrian Ford Transit Blue Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17269 op-snap---monthly-publication-march-2025.pdf   1026 2025-03 Pedestrian Land Rover Range Rover Silver Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17270 op-snap---monthly-publication-march-2025.pdf   1027 2025-03 Pedestrian Toyota   Beige Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17284 op-snap---monthly-publication-march-2025.pdf   1041 2025-03 Car   Cadillac Red Contravening a Red Traffic Light No Insurance Wylde Green Road Wylde Green Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.546976 -1.8098124
17337 op-snap---monthly-publication-march-2025.pdf   1094 2025-03 Car Audi A4 Black Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5083238 -1.8332287
17407 op-snap---monthly-publication-march-2025.pdf   1164 2025-03 Car Volkswagen Golf Grey Contravening a Red Traffic Light None Firefly Road Coventry Firefly Road Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3786307 -1.4839701
17414 op-snap---monthly-publication-march-2025.pdf   1171 2025-03 Car Toyota Yaris Red Contravening a Red Traffic Light None Bescot Road Bescot Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
17446 op-snap---monthly-publication-march-2025.pdf   1203 2025-03 Car Vauxhall ASTRA Black Contravening a Red Traffic Light None THE CRESCENT The Crescent Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4568799 -1.8734416
17453 op-snap---monthly-publication-march-2025.pdf   1210 2025-03 Car Volkswagen Polo Beige Contravening a Red Traffic Light None Beechwood Av Beechwood Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3960292 -1.5340332
17477 op-snap---monthly-publication-march-2025.pdf   1234 2025-03 Car Ford Transit Silver Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4203897 -1.8338574
17478 op-snap---monthly-publication-march-2025.pdf   1235 2025-03 Car Hyundai I20 Grey Contravening a Red Traffic Light None OLD WALSALL ROAD Old Walsall Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5294399 -1.9282714
17495 op-snap---monthly-publication-march-2025.pdf   1252 2025-03 Car Volkswagen ID3 White Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032
17498 op-snap---monthly-publication-march-2025.pdf   1255 2025-03 Car Toyota Corolla Grey Contravening a Red Traffic Light None Bordesley Circus Bordesley Circus Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4728608 -1.8754722
17552 op-snap---monthly-publication-march-2025.pdf   1309 2025-03 Car BMW 335D Grey Contravening a Red Traffic Light None Walmey Ash Road Walmey Ash Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
17561 op-snap---monthly-publication-march-2025.pdf   1318 2025-03 Car BMW 118M Black Contravening a Red Traffic Light None Ladywood Circus Ladywood Circus Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4774425 -1.9266984
17584 op-snap---monthly-publication-march-2025.pdf   1341 2025-03 Car Audi Q5.. Grey Contravening a Red Traffic Light None Dyas Road Great Barr Dyas Road Great Barr Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
17608 op-snap---monthly-publication-march-2025.pdf   1365 2025-03 Car Renault Trafic Grey Contravening a Red Traffic Light None Harborne Harborne Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4591151 -1.9480763
17616 op-snap---monthly-publication-march-2025.pdf   1373 2025-03 Pedal Bike BMW 420I Grey Contravening a Red Traffic Light None Far Gosford Street Far Gosford Street Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4071231 -1.4985178
17636 op-snap---monthly-publication-march-2025.pdf   1393 2025-03 Car Ford Fiesta White Contravening a Red Traffic Light None Newton Road Newton Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5428224 -1.9569444
17668 op-snap---monthly-publication-march-2025.pdf   1425 2025-03 Car Nissan Micra White Contravening a Red Traffic Light None Chemsley Wood Collector Road Chemsley Wood Collector Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
17675 op-snap---monthly-publication-march-2025.pdf   1432 2025-03 Pedal Bike Vauxhall Zafira White Contravening a Red Traffic Light None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
17709 op-snap---monthly-publication-march-2025.pdf   1466 2025-03 Car Volkswagen Golf GTD Grey Contravening a Red Traffic Light None Pleck Road, Walsall Pleck Road, Walsall Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5827033 -1.9960274
17749 op-snap---monthly-publication-march-2025.pdf   1506 2025-03 Car Seat Ibiza Black Contravening a Red Traffic Light Use vehicle on a road without valid test certificate Yardley Wood Road/ Wake Green Road Yardley Wood Road/ Wake Green Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4392351 -1.8715775
17787 op-snap---monthly-publication-march-2025.pdf   1544 2025-03 Car Ford B-Max Grey Contravening a Red Traffic Light None Binley Road Binley Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4070602 -1.4732469
17793 op-snap---monthly-publication-march-2025.pdf   1550 2025-03 Car Peugeot 3008 Red Contravening a Red Traffic Light None Penns lane/ Walmley Road Penns lane/ Walmley Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.538898 -1.8004185
17844 op-snap---monthly-publication-march-2025.pdf   1601 2025-03 Car Mercedes-Benz SPRINTER White Contravening a Red Traffic Light None HARDING STREET Harding Street Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email    
17856 op-snap---monthly-publication-march-2025.pdf   1613 2025-03 Car Skoda Kodiaq Black Contravening a Red Traffic Light None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4929304 -1.8229092
17858 op-snap---monthly-publication-march-2025.pdf   1615 2025-03 Car Audi A3 White Contravening a Red Traffic Light None Gooch Street Gooch Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4686609 -1.8945007
17860 op-snap---monthly-publication-march-2025.pdf   1617 2025-03 Car BMW X1 Green Contravening a Red Traffic Light None Parkes Hall Road Parkes Hall Road Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.529619 -2.105277
17865 op-snap---monthly-publication-march-2025.pdf   1622 2025-03 Pedal Bike Seat Ibizia Black Contravening a Red Traffic Light None Proffitt Avenue Proffitt Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4330807 -1.4816593
17868 op-snap---monthly-publication-march-2025.pdf   1625 2025-03 Pedal Bike Kia SORRENTO Grey Contravening a Red Traffic Light None BELL GREEN ROAD Bell Green Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4324855 -1.4815548
17931 op-snap---monthly-publication-march-2025.pdf   1688 2025-03 Car Hyundai KONA Grey Contravening a Red Traffic Light No vehicle excise licence STRATFORD ROAD Stratford Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4203897 -1.8338574
17950 op-snap---monthly-publication-march-2025.pdf   1707 2025-03 Car Dacia Duster Black Contravening a Red Traffic Light None Kings Road Kingstanding Kings Road Kingstanding Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5525625 -1.8823672

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