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

161 rows where month = "2025-02", 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, witness_contacted

reporter_transport_mode 1

  • Car · 161 ✖

offence 1

  • Contravening a Red Traffic Light · 161 ✖

month 1

  • 2025-02 · 161 ✖
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
5191 op-snap---monthly-publication-february-2025.pdf   8 2025-02 Car Audi A5 Grey Contravening a Red Traffic Light None Bilston Road Bilston Road Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.5801329 -2.1138283
5195 op-snap---monthly-publication-february-2025.pdf   12 2025-02 Car Audi A3 White Contravening a Red Traffic Light None Parkfield Rd Parkfield Road Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.567016 -2.1208485
5206 op-snap---monthly-publication-february-2025.pdf   23 2025-02 Car Ford Focus Blue Contravening a Red Traffic Light None Gressel Lane Gressel Lane Birmingham Birmingham NFA No VRM Yes - Via Email 52.4839418 -1.7623613
5208 op-snap---monthly-publication-february-2025.pdf   25 2025-02 Car Ford Transit White Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4552785 -1.906384
5221 op-snap---monthly-publication-february-2025.pdf   38 2025-02 Car Audi Q3 Grey Contravening a Red Traffic Light None Kitts Green Road Kitts Green Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4815372 -1.7766518
5222 op-snap---monthly-publication-february-2025.pdf   39 2025-02 Car Ford Transit Black Contravening a Red Traffic Light None B4137 Cuckoo Road Cuckoo Road Birmingham Birmingham Education N/A Yes - Via Email 52.5049023 -1.8603659
5224 op-snap---monthly-publication-february-2025.pdf   41 2025-02 Car Ford FIESTA Black Contravening a Red Traffic Light Driving without Due Care and Attention BRADLEYS LANE Bradleys Lane Sandwell Sandwell Court N/A Yes - Via Email    
5228 op-snap---monthly-publication-february-2025.pdf   45 2025-02 Car Nissan QASHQUI Black Contravening a Red Traffic Light None QUINTON ROAD Quinton Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4028847 -1.5082329
5233 op-snap---monthly-publication-february-2025.pdf   50 2025-02 Car Seat leon Purple Contravening a Red Traffic Light None DARTMOUTH CIRCUS Dartmouth Circus Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4926487 -1.8879638
5236 op-snap---monthly-publication-february-2025.pdf   53 2025-02 Car Toyota YARIS Red Contravening a Red Traffic Light None HAGLEY ROAD Hagley Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.471632 -1.9456776
5239 op-snap---monthly-publication-february-2025.pdf   56 2025-02 Car Vauxhall Corsa White Contravening a Red Traffic Light None Hagley Road Hagley Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.471632 -1.9456776
5249 op-snap---monthly-publication-february-2025.pdf   66 2025-02 Car   Iveco ? White Contravening a Red Traffic Light None B4173 Cradley Road Cradley Road Dudley Dudley NFA No VRM Yes - Via Email 52.4877241 -2.0818998
5262 op-snap---monthly-publication-february-2025.pdf   79 2025-02 Car Seat Leon Orange Contravening a Red Traffic Light None Hagley Road / Wolverhampton Road Hagley Road / Wolverhampton Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.471836 -1.9401037
5279 op-snap---monthly-publication-february-2025.pdf   96 2025-02 Car Kia Picanto Red Contravening a Red Traffic Light None Sheaf Lane Sheaf Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4540536 -1.7819436
5282 op-snap---monthly-publication-february-2025.pdf   99 2025-02 Car BMW X3 Black Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5113867 -1.8337258
5283 op-snap---monthly-publication-february-2025.pdf   100 2025-02 Car Volkswagen Jetta Silver Contravening a Red Traffic Light None High Street, Harborne High Street, Harborne Birmingham Birmingham NFA No Offence Yes - Via Email 52.4612733 -1.9430543
5300 op-snap---monthly-publication-february-2025.pdf   117 2025-02 Car Ford Fiesta Silver Contravening a Red Traffic Light None Brandwood Park Road Brandwood Park Road Birmingham Birmingham Education N/A Yes - Via Email 52.4138206 -1.9041686
5343 op-snap---monthly-publication-february-2025.pdf   160 2025-02 Car Volkswagen Crafter White Contravening a Red Traffic Light None Digby Road Digby Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5573003 -1.8317101
5351 op-snap---monthly-publication-february-2025.pdf   168 2025-02 Car Land Rover Freelander Blue Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115
5367 op-snap---monthly-publication-february-2025.pdf   184 2025-02 Car Volkswagen T Cross Grey Contravening a Red Traffic Light None Robin Hood Island Robin Hood Island Solihull Solihull Education N/A Yes - Via Email 52.422933 -1.8352662
5418 op-snap---monthly-publication-february-2025.pdf   235 2025-02 Car Mercedes-Benz SPRINTER White Contravening a Red Traffic Light None STRATFORD ROAD Stratford Road Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.4191184 -1.8326637
5422 op-snap---monthly-publication-february-2025.pdf   239 2025-02 Car Nissan JUKE Grey Contravening a Red Traffic Light None CHURCH STRET, BRIERLEY HILL Church Stret, Brierley Hill Dudley Dudley Fixed Penalty N/A Yes - Via Email    
5428 op-snap---monthly-publication-february-2025.pdf   245 2025-02 Car Citroen DS3 Purple Contravening a Red Traffic Light None MOSELEY AVENUE Moseley Avenue Coventry Coventry NFA No Independent Evidence Available Yes - Via Email 52.417344 -1.5264979
5429 op-snap---monthly-publication-february-2025.pdf   246 2025-02 Car Mitsubishi eclipse Red Contravening a Red Traffic Light None FRANKLY BEACHES ROAD Frankly Beaches Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email    
5432 op-snap---monthly-publication-february-2025.pdf   249 2025-02 Car Seat Ibiza Grey Contravening a Red Traffic Light None Kingsbury Rd/Tyburn Rd Kingsbury Road/Tyburn Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5164444 -1.8126027
5434 op-snap---monthly-publication-february-2025.pdf   251 2025-02 Car Audi TT Silver Contravening a Red Traffic Light None Chester Rd Jct 5 Chester Road Junction 5 Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5443 op-snap---monthly-publication-february-2025.pdf   260 2025-02 Car Toyota   White Contravening a Red Traffic Light None Newbury Road Aston Newbury Road Aston Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4991241 -1.8973166
5449 op-snap---monthly-publication-february-2025.pdf   266 2025-02 Car Toyota Corrolla Silver Contravening a Red Traffic Light None Bristol Street, City Centre Bristol Street, City Centre Birmingham Birmingham Education N/A Yes - Via Email    
5452 op-snap---monthly-publication-february-2025.pdf   269 2025-02 Car Honda Civic Grey Contravening a Red Traffic Light None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4308271 -1.920078
5460 op-snap---monthly-publication-february-2025.pdf   277 2025-02 Car Volkswagen Passat White Contravening a Red Traffic Light None Wood Green Road Wood Green Road Walsall Walsall Warning Letter N/A Yes - Via Email 52.6248989 -1.9343969
5474 op-snap---monthly-publication-february-2025.pdf   291 2025-02 Car Toyota Auris Blue Contravening a Red Traffic Light None Eachlehurst Road Eachlehurst Road Sutton Coldfield Sutton Coldfield NFA No VRM Yes - Via Email    
5516 op-snap---monthly-publication-february-2025.pdf   333 2025-02 Car Audi S5 Black Contravening a Red Traffic Light None A4040 / Gibbins Road A4040 / Gibbins Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.480771 -1.8086714
5526 op-snap---monthly-publication-february-2025.pdf   343 2025-02 Car Citroen C4 White Contravening a Red Traffic Light None Princes End, Tipton Princes End, Tipton Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5424707 -2.0635612
5536 op-snap---monthly-publication-february-2025.pdf   353 2025-02 Car Nissan MICRA White Contravening a Red Traffic Light None RUSSELL ROAD Russell Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4398245 -1.8469786
5540 op-snap---monthly-publication-february-2025.pdf   357 2025-02 Car Vauxhall Corsa Silver Contravening a Red Traffic Light None Tamworth Road Tamworth Road Coventry Coventry Education N/A Yes - Via Email 52.4380313 -1.5339558
5551 op-snap---monthly-publication-february-2025.pdf   368 2025-02 Car Peugeot Boxer White Contravening a Red Traffic Light None Streetbrook Road Streetbrook Road Solihull Solihull Warning Letter N/A Yes - Via Email    
5556 op-snap---monthly-publication-february-2025.pdf   373 2025-02 Car Vauxhall CORSA Grey Contravening a Red Traffic Light None HAGLEY ROAD Hagley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.471632 -1.9456776
5577 op-snap---monthly-publication-february-2025.pdf   394 2025-02 Car Audi A4 Black Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5113867 -1.8337258
5585 op-snap---monthly-publication-february-2025.pdf   402 2025-02 Car Toyota   White Contravening a Red Traffic Light None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4468506 -1.9395619
5620 op-snap---monthly-publication-february-2025.pdf   437 2025-02 Car Ford Transit White Contravening a Red Traffic Light None Long Bank Long Bank Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.5785967 -2.0581007
5624 op-snap---monthly-publication-february-2025.pdf   441 2025-02 Car Mitsubishi Colt Red Contravening a Red Traffic Light None High Street, Kings Heath High Street, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4353506 -1.8927483
5647 op-snap---monthly-publication-february-2025.pdf   464 2025-02 Car Volkswagen Golf Black Contravening a Red Traffic Light None Oxhill Road Oxhill Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.513857 -1.9367367
5648 op-snap---monthly-publication-february-2025.pdf   465 2025-02 Car BMW X1 White Contravening a Red Traffic Light None Penn road WV Penn road WV Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email    
5650 op-snap---monthly-publication-february-2025.pdf   467 2025-02 Car Citroen DS3 Silver Contravening a Red Traffic Light None Wellington Road Bilston Wellington Road Bilston Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.5709262 -2.0909977
5660 op-snap---monthly-publication-february-2025.pdf   477 2025-02 Car Porsche Taycan Black Contravening a Red Traffic Light No vehicle excise licence Chester Rd, Boldmere Chester Road, Boldmere Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5359496 -1.8324115
5730 op-snap---monthly-publication-february-2025.pdf   547 2025-02 Car Peugeot 3008 Grey Contravening a Red Traffic Light None Lichfield Road Lichfield Road Walsall Walsall Warning Letter N/A Yes - Via Email 52.6095168 -2.0493009
5741 op-snap---monthly-publication-february-2025.pdf   558 2025-02 Car Ford Fiesta White Contravening a Red Traffic Light None Bordesley Circus Bordesley Circus Birmingham Birmingham Education N/A Yes - Via Email 52.4728608 -1.8754722
5748 op-snap---monthly-publication-february-2025.pdf   565 2025-02 Car Seat Tarraco White Contravening a Red Traffic Light None A45, Coventry Road A45, Coventry Road Birmingham Birmingham Education N/A Yes - Via Email 52.4648608 -1.8414021
5750 op-snap---monthly-publication-february-2025.pdf   567 2025-02 Car BMW 440 Black Contravening a Red Traffic Light None Sheaf Lane Sheaf Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4540536 -1.7819436
5751 op-snap---monthly-publication-february-2025.pdf   568 2025-02 Car Audi A6 Black Contravening a Red Traffic Light None Rigby Lane Bromsgrove Rigby Lane Bromsgrove Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5786 op-snap---monthly-publication-february-2025.pdf   603 2025-02 Car Mini Cooper Black Contravening a Red Traffic Light None A38 towards Bassetts Pole A38 towards Bassetts Pole Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5788 op-snap---monthly-publication-february-2025.pdf   605 2025-02 Car Toyota Corolla Blue Contravening a Red Traffic Light None Hagley Road West Hagley Road West Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4656414 -1.9852276
5846 op-snap---monthly-publication-february-2025.pdf   663 2025-02 Car Mercedes-Benz B200 Silver Contravening a Red Traffic Light None Minworth Island A38 and A4097 Minworth Island A38 and A4097 Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5316279 -1.7762358
5864 op-snap---monthly-publication-february-2025.pdf   681 2025-02 Car Volkswagen Tiguan Black Contravening a Red Traffic Light None Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Education N/A Yes - Via Email 52.4861917 -1.8829748
5911 op-snap---monthly-publication-february-2025.pdf   728 2025-02 Car Suzuki CELERIO Grey Contravening a Red Traffic Light None LOZELLS ROAD Lozells Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.502683 -1.9033516
5924 op-snap---monthly-publication-february-2025.pdf   741 2025-02 Car     Silver Contravening a Red Traffic Light None CHESTER ROAD Chester Road Walsall Walsall NFA No VRM Yes - Via Email 52.5692139 -1.8799672
5936 op-snap---monthly-publication-february-2025.pdf   753 2025-02 Car Volkswagen Tiguan Black Contravening a Red Traffic Light None Europa Avenue, West Bromwich Europa Avenue, West Bromwich Sandwell Sandwell Education N/A Yes - Via Email 52.5137909 -1.9786733
5939 op-snap---monthly-publication-february-2025.pdf   756 2025-02 Car Ford Focus Grey Contravening a Red Traffic Light None Shenley Lane Shenley Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Telephone 52.430111 -1.9753703
5943 op-snap---monthly-publication-february-2025.pdf   760 2025-02 Car Honda Jazz Yellow Contravening a Red Traffic Light None Cuckoo Road Cuckoo Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5049023 -1.8603659
5951 op-snap---monthly-publication-february-2025.pdf   768 2025-02 Car BMW 5 series Silver Contravening a Red Traffic Light None Wolverhampton Road, Walsall Wolverhampton Road, Walsall Walsall Walsall NFA No VRM Yes - Via Email 52.5867763 -2.0104342
5952 op-snap---monthly-publication-february-2025.pdf   769 2025-02 Car Daf   White Contravening a Red Traffic Light None Birchfield Lane, Oldbury Birchfield Lane, Oldbury Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.4893587 -2.0267401
5967 op-snap---monthly-publication-february-2025.pdf   784 2025-02 Car Ford Fiesta White Contravening a Red Traffic Light None Bloxwich Lane, Walsall Bloxwich Lane, Walsall Walsall Walsall Education N/A Yes - Via Email 52.6020474 -2.014682
5974 op-snap---monthly-publication-february-2025.pdf   791 2025-02 Car Mercedes-Benz E220 Black Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.6083917 -2.1033365
5977 op-snap---monthly-publication-february-2025.pdf   794 2025-02 Car Citroen DS3 White Contravening a Red Traffic Light None BIRMINGHAM NEW ROAD Birmingham New Road Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.5560698 -2.1044322
5987 op-snap---monthly-publication-february-2025.pdf   804 2025-02 Car BMW 120 White Contravening a Red Traffic Light No Insurance Trinity Rd/Witton Rd Trinity Road/Witton Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5812323 -1.8234706
5998 op-snap---monthly-publication-february-2025.pdf   815 2025-02 Car Ford Fiesta Silver Contravening a Red Traffic Light None A456 Kidderminster Road Hagley Kidderminster Road Hagley Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
6000 op-snap---monthly-publication-february-2025.pdf   817 2025-02 Car Volkswagen Golf White Contravening a Red Traffic Light None A456 Kidderminster Road Hagley Kidderminster Road Hagley Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
6004 op-snap---monthly-publication-february-2025.pdf   821 2025-02 Car Nissan QASHQUI Red Contravening a Red Traffic Light None HALESOWEN ROAD Halesowen Road Dudley Dudley Other Action Taken N/A Yes - Via Email 52.4624413 -2.0175178
6051 op-snap---monthly-publication-february-2025.pdf   868 2025-02 Car Kia Ceed Black Contravening a Red Traffic Light None Stoney Lane Stoney Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4745488 -1.8065911
6054 op-snap---monthly-publication-february-2025.pdf   871 2025-02 Car       Contravening a Red Traffic Light None A46, Baginton A46, Baginton Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.3846177 -1.5142959
6094 op-snap---monthly-publication-february-2025.pdf   911 2025-02 Car Volvo XC40 Black Contravening a Red Traffic Light None Stafford Street Stafford Street Wolverhampton Wolverhampton Education N/A Yes - Via Email 52.5653849 -2.0755665
6133 op-snap---monthly-publication-february-2025.pdf   950 2025-02 Car Renault Arkana Black Contravening a Red Traffic Light None Richmond Road Richmond Road Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.4430188 -1.8022218
6136 op-snap---monthly-publication-february-2025.pdf   953 2025-02 Car Skoda Fabia Grey Contravening a Red Traffic Light None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4804926 -1.8563658
6140 op-snap---monthly-publication-february-2025.pdf   957 2025-02 Car Land Rover Evoque Red Contravening a Red Traffic Light None Stratford Rd, Shirley Stratford Road, Shirley Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.4191731 -1.8324357
6141 op-snap---monthly-publication-february-2025.pdf   958 2025-02 Car Volkswagen Tiguan White Contravening a Red Traffic Light None Devon Road, Cannock Devon Road, Cannock Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
6153 op-snap---monthly-publication-february-2025.pdf   970 2025-02 Car Mercedes-Benz A180 Blue Contravening a Red Traffic Light None B4154 LICHFIELD ROAD B4154 Lichfield Road Walsall Walsall Warning Letter Outside of 14 Days NIP Yes - Via Email    
6172 op-snap---monthly-publication-february-2025.pdf   989 2025-02 Car Audi Q5 Black Contravening a Red Traffic Light None WAKE GREEN Wake Green Birmingham Birmingham Education N/A Yes - Via Email 52.4405852 -1.8708559
6184 op-snap---monthly-publication-february-2025.pdf   1001 2025-02 Car Ford Transit Red Contravening a Red Traffic Light None Newton Road Great Barr Newton Road Great Barr Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5428813 -1.9551642
6193 op-snap---monthly-publication-february-2025.pdf   1010 2025-02 Car Ford Transit White Contravening a Red Traffic Light No Insurance Lichfield Road Walsall Lichfield Road Walsall Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6099659 -2.0445263
6194 op-snap---monthly-publication-february-2025.pdf   1011 2025-02 Car BMW X3 M Blue Contravening a Red Traffic Light None James Watt Queensway James Watt Queensway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4824626 -1.8907785
6238 op-snap---monthly-publication-february-2025.pdf   1055 2025-02 Car Toyota MPV Black Contravening a Red Traffic Light None Stratford Road Hall Green Stratford Road Hall Green Birmingham Birmingham Education N/A Yes - Via Email 52.4423942 -1.8513451
6253 op-snap---monthly-publication-february-2025.pdf   1070 2025-02 Car Volkswagen Golf White Contravening a Red Traffic Light None Holy Lane, Erdington Holy Lane, Erdington Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
6256 op-snap---monthly-publication-february-2025.pdf   1073 2025-02 Car Toyota Yaris Red Contravening a Red Traffic Light None Villa Road Villa Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5015892 -1.9211391
6261 op-snap---monthly-publication-february-2025.pdf   1078 2025-02 Car Citroen Dispatch Black Contravening a Red Traffic Light None Stourbridge Road Stourbridge Road Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5002997 -2.1081386
6269 op-snap---monthly-publication-february-2025.pdf   1086 2025-02 Car Lexus 300 Black Contravening a Red Traffic Light None ICKNIELD ROAD Icknield Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4822095 -1.9332876
6340 op-snap---monthly-publication-february-2025.pdf   1157 2025-02 Car Ford Mondeo Blue Contravening a Red Traffic Light None Stroubrdige Road Dudley Stroubrdige Road Dudley Dudley Dudley Education N/A Yes - Via Email    
6349 op-snap---monthly-publication-february-2025.pdf   1166 2025-02 Car Vauxhall Corsa Grey Contravening a Red Traffic Light None Monument Road [B4124], Ladywood Monument Road [B4124], Ladywood Birmingham Birmingham NFA No Offence Yes - Via Email 52.4773692 -1.9280585
6350 op-snap---monthly-publication-february-2025.pdf   1167 2025-02 Car Mercedes-Benz GLE 400 AMG Black Contravening a Red Traffic Light None Monument Road [B4124], Ladywood Monument Road [B4124], Ladywood Birmingham Birmingham NFA No Offence Yes - Via Email 52.4773692 -1.9280585
6378 op-snap---monthly-publication-february-2025.pdf   1195 2025-02 Car Daf Scancia Orange Contravening a Red Traffic Light None Cooks Lane Cooks Lane Birmingham Birmingham Education N/A Yes - Via Email 52.482758 -1.7603097
6380 op-snap---monthly-publication-february-2025.pdf   1197 2025-02 Car BMW 3 series Blue Contravening a Red Traffic Light None Stafford Road, Stafford Road Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.6291998 -2.126312
6381 op-snap---monthly-publication-february-2025.pdf   1198 2025-02 Car Citroen C1 Grey Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.4726661 -1.8769032
6390 op-snap---monthly-publication-february-2025.pdf   1207 2025-02 Car Audi Q7 Black Contravening a Red Traffic Light None Cuckoo Road Cuckoo Road Birmingham Birmingham Education N/A Yes - Via Email 52.5049023 -1.8603659
6397 op-snap---monthly-publication-february-2025.pdf   1214 2025-02 Car Ford C-Max Silver Contravening a Red Traffic Light None Boldmere Road, jn Jockey Road Boldmere Road, jn Jockey Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
6450 op-snap---monthly-publication-february-2025.pdf   1267 2025-02 Car Land Rover Freelander Black Contravening a Red Traffic Light None Minworth Island Minworth Island Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5316279 -1.7762358
6451 op-snap---monthly-publication-february-2025.pdf   1268 2025-02 Car BMW X3 Black Contravening a Red Traffic Light None Black Country New Road Black Country New Road Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.5527191 -2.0312967
6517 op-snap---monthly-publication-february-2025.pdf   1334 2025-02 Car Peugeot 208 White Contravening a Red Traffic Light No vehicle excise licence Wake Green Road Wake Green Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4437078 -1.8783408
6527 op-snap---monthly-publication-february-2025.pdf   1344 2025-02 Car Toyota Prius Red Contravening a Red Traffic Light None A34 at Beeches Road junction A34 at Beeches Road junction Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
6567 op-snap---monthly-publication-february-2025.pdf   1384 2025-02 Car Kia Rio White Contravening a Red Traffic Light None Enville Enville Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.5067308 -2.1896188
6569 op-snap---monthly-publication-february-2025.pdf   1386 2025-02 Car Audi S3 Black Contravening a Red Traffic Light None Enville Enville Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.5067308 -2.1896188
6595 op-snap---monthly-publication-february-2025.pdf   1412 2025-02 Car Vauxhall CORSA White Contravening a Red Traffic Light NONE HIGH STREET QUARRY BANK High Street Quarry Bank Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.4583107 -2.1169703

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