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

219 rows where month = "2025-09", 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

reporter_transport_mode 1

  • Car · 219 ✖

offence 1

  • Contravening a Red Traffic Light · 219 ✖

month 1

  • 2025-09 · 219 ✖
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
23782 op-snap---monthly-publication-september-2025.pdf   1 2025-09 Car Toyota Yaris Black Contravening a Red Traffic Light None Central Way, Merry Hill Central Way, Merry Hill Dudley Dudley NFA No Offence      
23783 op-snap---monthly-publication-september-2025.pdf   2 2025-09 Car Skoda Elroq Blue Contravening a Red Traffic Light None Kingsbury Road Kingsbury Road Birmingham Birmingham Fixed Penalty N/A   52.5292752 -1.7618805
23784 op-snap---monthly-publication-september-2025.pdf   3 2025-09 Car Cupra Formentor Black Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
23796 op-snap---monthly-publication-september-2025.pdf   15 2025-09 Car Fiat 500.. White Contravening a Red Traffic Light None Sheaf Lane Sheaf Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4540536 -1.7819436
23811 op-snap---monthly-publication-september-2025.pdf   30 2025-09 Car Seat Leon Black Contravening a Red Traffic Light None Lode Lane Lode Lane Solihull Solihull Fixed Penalty N/A   52.4149064 -1.7832364
23818 op-snap---monthly-publication-september-2025.pdf   37 2025-09 Car Land Rover Evoque White Contravening a Red Traffic Light None Spitfire Island Spitfire Island Birmingham Birmingham Education N/A   52.5138106 -1.797297
23824 op-snap---monthly-publication-september-2025.pdf   43 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Allesley Old Road Allesley Old Road Coventry Coventry Warning Letter N/A   52.4103629 -1.5441218
23826 op-snap---monthly-publication-september-2025.pdf   45 2025-09 Car Ford Focus Red Contravening a Red Traffic Light None Patshull Avenue Patshull Avenue Wolverhampton Wolverhampton Fixed Penalty N/A   52.6253375 -2.1375315
23836 op-snap---monthly-publication-september-2025.pdf   55 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A   52.5083238 -1.8332287
23837 op-snap---monthly-publication-september-2025.pdf   56 2025-09 Car Skoda Octavia Blue Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A   52.5083238 -1.8332287
23839 op-snap---monthly-publication-september-2025.pdf   58 2025-09 Car BMW M3 Black Contravening a Red Traffic Light None A4036 Merry Hill Merry Hill Dudley Dudley Education N/A   52.4817646 -2.1113435
23843 op-snap---monthly-publication-september-2025.pdf   62 2025-09 Car BMW M3.. White Contravening a Red Traffic Light None Windmill Lane Smethwick Windmill Lane Smethwick Sandwell Sandwell Warning Letter N/A   52.4877204 -1.9592449
23847 op-snap---monthly-publication-september-2025.pdf   66 2025-09 Car Nissan Juke Grey Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
23852 op-snap---monthly-publication-september-2025.pdf   71 2025-09 Car Mercedes-Benz CLA 200 Black Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham NFA No Independent Evidence Available   52.4726661 -1.8769032
23853 op-snap---monthly-publication-september-2025.pdf   72 2025-09 Car BMW 330.. Grey Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
23854 op-snap---monthly-publication-september-2025.pdf   73 2025-09 Car Volkswagen Golf Black Contravening a Red Traffic Light None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
23861 op-snap---monthly-publication-september-2025.pdf   80 2025-09 Car Audi SQ5 Black Contravening a Red Traffic Light None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
23868 op-snap---monthly-publication-september-2025.pdf   87 2025-09 Car Audi A3 Grey Contravening a Red Traffic Light Use vehicle on a road without valid test certificate Poets Corner Poets Corner Birmingham Birmingham Court N/A   52.4647091 -1.8588833
23876 op-snap---monthly-publication-september-2025.pdf   95 2025-09 Car Audi A3 Silver Contravening a Red Traffic Light None Leighswood Road Aldridge Leighswood Road Aldridge Walsall Walsall Education N/A   52.6071662 -1.9231466
23883 op-snap---monthly-publication-september-2025.pdf   102 2025-09 Car BMW X6 Grey Contravening a Red Traffic Light None Nailcote Lane Nailcote Lane Solihull Solihull Education N/A   52.3948197 -1.6142205
23886 op-snap---monthly-publication-september-2025.pdf   105 2025-09 Car Vauxhall Astra Black Contravening a Red Traffic Light None Newbury Road Newbury Road Birmingham Birmingham Warning Letter N/A   52.4993019 -1.8964495
23887 op-snap---monthly-publication-september-2025.pdf   106 2025-09 Car Citroen Berlingo White Contravening a Red Traffic Light None Lakefield Rd jct with Green Meadow Lakefield Road jct with Green Meadow Wolverhampton Wolverhampton Fixed Penalty N/A      
23893 op-snap---monthly-publication-september-2025.pdf   112 2025-09 Car Mercedes-Benz C-class Silver Contravening a Red Traffic Light No Insurance Priory Road, Edgbaston Priory Road, Edgbaston Birmingham Birmingham Court N/A   52.4556998 -1.9102592
23901 op-snap---monthly-publication-september-2025.pdf   120 2025-09 Car Toyota Auris Blue Contravening a Red Traffic Light None Selly Oak Road Selly Oak Road Birmingham Birmingham NFA No Offence   52.4263875 -1.9397954
23910 op-snap---monthly-publication-september-2025.pdf   129 2025-09 Car Mercedes-Benz   Black Contravening a Red Traffic Light None Birmingham Road Birmingham Road Birmingham Birmingham Education N/A   52.5505398 -1.8252993
23913 op-snap---monthly-publication-september-2025.pdf   132 2025-09 Car Mercedes-Benz   Black Contravening a Red Traffic Light None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
23921 op-snap---monthly-publication-september-2025.pdf   140 2025-09 Car Audi A3 Silver Contravening a Red Traffic Light None Dads Lane Dads Lane Birmingham Birmingham Fixed Penalty N/A   52.4375913 -1.9068522
23923 op-snap---monthly-publication-september-2025.pdf   142 2025-09 Car Vauxhall Mokka White Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham NFA No Independent Evidence Available   52.5083238 -1.8332287
23934 op-snap---monthly-publication-september-2025.pdf   153 2025-09 Car Toyota Verso Silver Contravening a Red Traffic Light None Suffolk Street Suffolk Street Birmingham Birmingham Fixed Penalty N/A   52.4749336 -1.9003475
23942 op-snap---monthly-publication-september-2025.pdf   161 2025-09 Car Volkswagen Polo White Contravening a Red Traffic Light None A41 Express way Express way Sandwell Sandwell Education N/A      
23950 op-snap---monthly-publication-september-2025.pdf   169 2025-09 Car Audi A6 White Contravening a Red Traffic Light None A4150 Wolverhampton Wolverhampton Wolverhampton Wolverhampton Warning Letter N/A   52.5879884 -2.120242
23954 op-snap---monthly-publication-september-2025.pdf   173 2025-09 Car Volkswagen Tiguan Grey Contravening a Red Traffic Light No Insurance Six Ways, Lozells Six Ways, Lozells Birmingham Birmingham NFA No Independent Evidence Available   52.5022359 -1.8984899
23956 op-snap---monthly-publication-september-2025.pdf   175 2025-09 Car Ford Focus Black Contravening a Red Traffic Light None Wake Green Road Wake Green Road Birmingham Birmingham Education N/A   52.4437078 -1.8783408
23967 op-snap---monthly-publication-september-2025.pdf   186 2025-09 Car Skoda Kodiaq Silver Contravening a Red Traffic Light None Holloway Head Holloway Head Birmingham Birmingham Education N/A   52.474258 -1.9019723
23969 op-snap---monthly-publication-september-2025.pdf   188 2025-09 Car Nissan Note Orange Contravening a Red Traffic Light None Broad Lane Kings Heath Broad Lane Kings Heath Birmingham Birmingham Education N/A   52.410787 -1.918202
23980 op-snap---monthly-publication-september-2025.pdf   199 2025-09 Car   Polestar Blue Contravening a Red Traffic Light No vehicle excise licence Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A   52.4103191 -1.8670224
23992 op-snap---monthly-publication-september-2025.pdf   211 2025-09 Car Vauxhall Astra Silver Contravening a Red Traffic Light None A4123 at Bunns Lane A4123 at Bunns Lane Dudley Dudley Fixed Penalty N/A   52.5478387 -2.0943116
23996 op-snap---monthly-publication-september-2025.pdf   215 2025-09 Car BMW 320.. Silver Contravening a Red Traffic Light None Calthorpe Road Calthorpe Road Birmingham Birmingham Warning Letter N/A   52.5142235 -1.9073557
24005 op-snap---monthly-publication-september-2025.pdf   224 2025-09 Car Ford Focus Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
24006 op-snap---monthly-publication-september-2025.pdf   225 2025-09 Car Peugeot 308 Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
24007 op-snap---monthly-publication-september-2025.pdf   226 2025-09 Car Toyota yaris Red Contravening a Red Traffic Light None Northfied Road Northfied Road Birmingham Birmingham Education N/A      
24009 op-snap---monthly-publication-september-2025.pdf   228 2025-09 Car BMW 5 series Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Court N/A   52.4167654 -1.9411244
24011 op-snap---monthly-publication-september-2025.pdf   230 2025-09 Car Nissan Qashqai Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Court N/A   52.4167654 -1.9411244
24018 op-snap---monthly-publication-september-2025.pdf   237 2025-09 Car Honda Civic Grey Contravening a Red Traffic Light None Castle Bromwich Interchange roundabout Castle Bromwich Interchange roundabout Birmingham Birmingham Warning Letter N/A      
24021 op-snap---monthly-publication-september-2025.pdf   240 2025-09 Car Mercedes-Benz SLC 250 White Contravening a Red Traffic Light None Stratford Road Shirley Stratford Road Shirley Birmingham Birmingham Fixed Penalty N/A      
24027 op-snap---monthly-publication-september-2025.pdf   246 2025-09 Car Audi A4.. White Contravening a Red Traffic Light None Diglis Road (Worcester) Diglis Road (Worcester) Out of Force Area Out of Force Area NFA Out of Force      
24036 op-snap---monthly-publication-september-2025.pdf   255 2025-09 Car Vauxhall corsa Black Contravening a Red Traffic Light None Walmley Road Walmley Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5405351 -1.8002219
24048 op-snap---monthly-publication-september-2025.pdf   267 2025-09 Car Toyota C-HR Silver Contravening a Red Traffic Light None Five ways Five ways Birmingham Birmingham Warning Letter N/A   52.4710941 -1.9130708
24049 op-snap---monthly-publication-september-2025.pdf   268 2025-09 Car Audi Q2 Black Contravening a Red Traffic Light None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Warning Letter N/A   52.4720132 -1.9142946
24053 op-snap---monthly-publication-september-2025.pdf   272 2025-09 Car     Silver Contravening a Red Traffic Light None M54 J4 Shrewsbury M54 J4 Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
24056 op-snap---monthly-publication-september-2025.pdf   275 2025-09 Car Ford Transit White Contravening a Red Traffic Light None Lime Lane, Pelsall Lime Lane, Pelsall Walsall Walsall Fixed Penalty N/A   52.6394826 -1.9681327
24070 op-snap---monthly-publication-september-2025.pdf   289 2025-09 Car Ford C-max White Contravening a Red Traffic Light None Coundon Wedge Drive Coundon Wedge Drive Coventry Coventry Education N/A   52.4385402 -1.5483746
24071 op-snap---monthly-publication-september-2025.pdf   290 2025-09 Car Land Rover Range Rover Black Contravening a Red Traffic Light None Stockfield Road Stockfield Road Birmingham Birmingham Fixed Penalty N/A   52.4519414 -1.831688
24076 op-snap---monthly-publication-september-2025.pdf   295 2025-09 Car Ford Focus Red Contravening a Red Traffic Light None Foundry Lane Foundry Lane Birmingham Birmingham NFA No VRM      
24077 op-snap---monthly-publication-september-2025.pdf   296 2025-09 Car Audi SQ5 Silver Contravening a Red Traffic Light None Jenkins Street Jenkins Street Birmingham Birmingham Education N/A   52.4705155 -1.8650312
24089 op-snap---monthly-publication-september-2025.pdf   308 2025-09 Car Suzuki Vitara Black Contravening a Red Traffic Light None Roman Road Hereford Roman Road Hereford Out of Force Area Out of Force Area NFA Out of Force      
24095 op-snap---monthly-publication-september-2025.pdf   314 2025-09 Car BMW 420d White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
24111 op-snap---monthly-publication-september-2025.pdf   330 2025-09 Car Vauxhall Mokka White Contravening a Red Traffic Light None Stonehouse Road Stonehouse Road Sutton Coldfield Sutton Coldfield Education N/A   52.5554307 -1.8439169
24113 op-snap---monthly-publication-september-2025.pdf   332 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Lichfield Road Lichfield Road Walsall Walsall Fixed Penalty N/A   52.6095168 -2.0493009
24116 op-snap---monthly-publication-september-2025.pdf   335 2025-09 Car Volkswagen Passat Silver Contravening a Red Traffic Light None Lichfield Road, jn Hawley Close Lichfield Road, jn Hawley Close Walsall Walsall Fixed Penalty N/A      
24127 op-snap---monthly-publication-september-2025.pdf   346 2025-09 Car Land Rover Sport Black Contravening a Red Traffic Light None Field Lane Bloxwich Field Lane Bloxwich Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.6235236 -1.9592167
24130 op-snap---monthly-publication-september-2025.pdf   349 2025-09 Car Ford Transit Silver Contravening a Red Traffic Light None Chester Road at Jockey Road Chester Road at Jockey Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
24136 op-snap---monthly-publication-september-2025.pdf   355 2025-09 Car Land Rover Sport Black Contravening a Red Traffic Light None Bridle Lane Bridle Lane Birmingham Birmingham NFA No Independent Evidence Available      
24137 op-snap---monthly-publication-september-2025.pdf   356 2025-09 Car Ford Fiesta Silver Contravening a Red Traffic Light None Bridle Lane Bridle Lane Birmingham Birmingham NFA No Independent Evidence Available      
24142 op-snap---monthly-publication-september-2025.pdf   361 2025-09 Car BMW 118.. White Contravening a Red Traffic Light None Blue Lane West Walsall Blue Lane West Walsall Walsall Walsall Education N/A   52.5872883 -1.9906083
24143 op-snap---monthly-publication-september-2025.pdf   362 2025-09 Car Ford Transit Grey Contravening a Red Traffic Light None Queslett Road Queslett Road Birmingham Birmingham Education N/A   52.5458699 -1.9304484
24144 op-snap---monthly-publication-september-2025.pdf   363 2025-09 Car Citroen C4 Black Contravening a Red Traffic Light None Walsall Road Walsall Road Sandwell Sandwell Education N/A   52.5439824 -1.9306805
24147 op-snap---monthly-publication-september-2025.pdf   366 2025-09 Car Ford focus Silver Contravening a Red Traffic Light None Tessell Lane Tessell Lane Birmingham Birmingham Education N/A      
24151 op-snap---monthly-publication-september-2025.pdf   370 2025-09 Car Mercedes-Benz Vito White Contravening a Red Traffic Light No Insurance Skidmore Road Skidmore Road Wolverhampton Wolverhampton Court N/A      
24161 op-snap---monthly-publication-september-2025.pdf   380 2025-09 Car Ford Connect Blue Contravening a Red Traffic Light None a426 Rugby a426 Rugby Out of Force Area Out of Force Area NFA Out of Force   52.5932479 -2.138134
24179 op-snap---monthly-publication-september-2025.pdf   398 2025-09 Car Skoda Yeti Red Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham NFA No VRM   52.4203897 -1.8338574
24192 op-snap---monthly-publication-september-2025.pdf   411 2025-09 Car Nissan Pulsar Blue Contravening a Red Traffic Light None Stafford Road, Jn2 M54 Stafford Road, Jn2 M54 Wolverhampton Wolverhampton Education N/A      
24194 op-snap---monthly-publication-september-2025.pdf   413 2025-09 Car Vauxhall zafira Black Contravening a Red Traffic Light None Stadium Way Stadium Way Out of Force Area Out of Force Area Warning Letter N/A   52.5298237 -1.9081248
24195 op-snap---monthly-publication-september-2025.pdf   414 2025-09 Car Seat Leon White Contravening a Red Traffic Light None Level Street Brierley Hill Level Street Brierley Hill Dudley Dudley Education N/A   52.4842017 -2.116248
24210 op-snap---monthly-publication-september-2025.pdf   429 2025-09 Car Seat Alhambra Blue Contravening a Red Traffic Light None Redford Road Redford Road Coventry Coventry Education N/A      
24212 op-snap---monthly-publication-september-2025.pdf   431 2025-09 Car Audi Q4 Black Contravening a Red Traffic Light None A3400 Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
24213 op-snap---monthly-publication-september-2025.pdf   432 2025-09 Car Mercedes-Benz GLC White Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
24215 op-snap---monthly-publication-september-2025.pdf   434 2025-09 Car Volkswagen Golf Black Contravening a Red Traffic Light None Queslett Road Queslett Road Birmingham Birmingham Education N/A   52.5458699 -1.9304484
24216 op-snap---monthly-publication-september-2025.pdf   435 2025-09 Car Honda Civic Blue Contravening a Red Traffic Light None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
24217 op-snap---monthly-publication-september-2025.pdf   436 2025-09 Car BMW X6 White Contravening a Red Traffic Light None Shaftmoor Lane Shaftmoor Lane Birmingham Birmingham Other Action Taken N/A   52.4418944 -1.8407335
24226 op-snap---monthly-publication-september-2025.pdf   445 2025-09 Car Mitsubishi Hi-Lux Black Contravening a Red Traffic Light None Minworth Island Minworth Island Birmingham Birmingham Education N/A   52.5316279 -1.7762358
24229 op-snap---monthly-publication-september-2025.pdf   448 2025-09 Car Peugeot Partner White Contravening a Red Traffic Light None High Street / A491, Audnam, Stourbridge High Street / A491, Audnam, Stourbridge Dudley Dudley Education N/A   52.4722518 -2.1552954
24232 op-snap---monthly-publication-september-2025.pdf   451 2025-09 Car Nissan Qashqai Black Contravening a Red Traffic Light None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield Education N/A   52.5361464 -1.8270283
24235 op-snap---monthly-publication-september-2025.pdf   454 2025-09 Car Ford Mondeo Grey Contravening a Red Traffic Light No vehicle excise licence New Road New Road Sandwell Sandwell Warning Letter N/A   52.5330407 -2.0376222
24238 op-snap---monthly-publication-september-2025.pdf   457 2025-09 Car Porsche Taycan White Contravening a Red Traffic Light None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A   52.5872149 -1.8300386
24247 op-snap---monthly-publication-september-2025.pdf   466 2025-09 Car Audi Q7 Black Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham NFA No Independent Evidence Available   52.4726661 -1.8769032
24256 op-snap---monthly-publication-september-2025.pdf   475 2025-09 Car Volvo XC40 Black Contravening a Red Traffic Light None Turves Green Turves Green Birmingham Birmingham Education N/A   52.4035104 -1.9666324
24258 op-snap---monthly-publication-september-2025.pdf   477 2025-09 Car Ford Kuga Silver Contravening a Red Traffic Light None A4540 Icknield Street Icknield Street Birmingham Birmingham Court N/A   52.5709191 -1.8759339
24259 op-snap---monthly-publication-september-2025.pdf   478 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
24260 op-snap---monthly-publication-september-2025.pdf   479 2025-09 Car Toyota Prius Silver Contravening a Red Traffic Light None Witton Road Witton Road Birmingham Birmingham Fixed Penalty N/A   52.513336 -1.8833226
24266 op-snap---monthly-publication-september-2025.pdf   485 2025-09 Car Ford Transit White Contravening a Red Traffic Light None Warwick Road Warwick Road Birmingham Birmingham Fixed Penalty N/A   52.4555288 -1.8613929
24269 op-snap---monthly-publication-september-2025.pdf   488 2025-09 Car Toyota   Blue Contravening a Red Traffic Light None Castle Gate Island Castle Gate Island Dudley Dudley NFA No Independent Evidence Available   52.5136155 -2.0733909
24270 op-snap---monthly-publication-september-2025.pdf   489 2025-09 Car Vauxhall Vivaro White Contravening a Red Traffic Light None J3 M42 J3 M42 Out of Force Area Out of Force Area NFA Out of Force   52.4028859 -1.75593
24282 op-snap---monthly-publication-september-2025.pdf   501 2025-09 Car Volkswagen Polo White Contravening a Red Traffic Light None Walsall Road Perry Barr Walsall Road Perry Barr Birmingham Birmingham Education N/A   52.5219655 -1.9010321
24288 op-snap---monthly-publication-september-2025.pdf   507 2025-09 Car Mercedes-Benz c200 Red Contravening a Red Traffic Light None Cole Hill Lane Cole Hill Lane Birmingham Birmingham Education N/A   52.4951084 -1.7913851
24296 op-snap---monthly-publication-september-2025.pdf   515 2025-09 Car Seat Leon Silver Contravening a Red Traffic Light None A449 Wolverhampton Road Wolverhampton Road Dudley Dudley NFA No Independent Evidence Available   52.5063917 -2.1711502
24306 op-snap---monthly-publication-september-2025.pdf   525 2025-09 Car Land Rover Range Rover Grey Contravening a Red Traffic Light None Victoria Road Victoria Road Birmingham Birmingham NFA No Offence   52.5615573 -1.820549
24307 op-snap---monthly-publication-september-2025.pdf   526 2025-09 Car Land Rover Discovery White Contravening a Red Traffic Light None Walstead Road Walstead Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5648629 -1.9517624
24313 op-snap---monthly-publication-september-2025.pdf   532 2025-09 Car Land Rover Discovery Grey Contravening a Red Traffic Light None A35 A35 Solihull Solihull NFA No Offence      
24321 op-snap---monthly-publication-september-2025.pdf   540 2025-09 Car Volkswagen Touran Red Contravening a Red Traffic Light None M6 J10 Island M6 J10 Island Walsall Walsall Education N/A   52.6760749 -2.0862582

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