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

144 rows where month = "2025-12" 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 · 144 ✖

month 1

  • 2025-12 · 144 ✖
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
3873 op-snap---monthly-publication-december-2025.pdf   1 2025-12 Car Skoda Octavia Grey Contravening a Red Traffic Light None M42 Jct 10 M42 Junction 10 Out of Force Area Out of Force Area NFA Out of Force      
3877 op-snap---monthly-publication-december-2025.pdf   5 2025-12 Car BMW 220M Silver Contravening a Red Traffic Light None Alcester Road South Alcester Road South Birmingham Birmingham NFA No Independent Evidence Available   52.4170522 -1.8906187
3887 op-snap---monthly-publication-december-2025.pdf   15 2025-12 Car Tesla model Y White Contravening a Red Traffic Light None Monkspath Interchange Monkspath Interchange Solihull Solihull NFA No Independent Evidence Available   52.3792737 -1.7869373
3904 op-snap---monthly-publication-december-2025.pdf   32 2025-12 Car Cupra Formentor Black Contravening a Red Traffic Light None Dudley Road Dudley Road Sandwell Sandwell NFA No Independent Evidence Available   52.4877352 -1.9494469
3905 op-snap---monthly-publication-december-2025.pdf   33 2025-12 Pedestrian Volkswagen Crafter White Contravening a Red Traffic Light None Leaf Lane Leaf Lane Coventry Coventry NFA No Independent Evidence Available   52.3837942 -1.4979145
3906 op-snap---monthly-publication-december-2025.pdf   34 2025-12 Pedestrian Ford Fiesta White Contravening a Red Traffic Light None Leaf Lane Leaf Lane Coventry Coventry NFA No Independent Evidence Available   52.3837942 -1.4979145
3907 op-snap---monthly-publication-december-2025.pdf   35 2025-12 Pedestrian Mercedes-Benz   Grey Contravening a Red Traffic Light None Leaf Lane Leaf Lane Coventry Coventry NFA No Independent Evidence Available   52.3837942 -1.4979145
3981 op-snap---monthly-publication-december-2025.pdf   109 2025-12 Car Toyota AYGO White Contravening a Red Traffic Light None Streetsbrook Road Streetsbrook Road Solihull Solihull Warning Letter N/A   52.4223176 -1.8253145
3990 op-snap---monthly-publication-december-2025.pdf   118 2025-12 Car Mercedes-Benz CLA220 White Contravening a Red Traffic Light None Stafford Road Stafford Road Wolverhampton Wolverhampton Warning Letter N/A   52.6291998 -2.126312
3991 op-snap---monthly-publication-december-2025.pdf   119 2025-12 Car Ford Transit White Contravening a Red Traffic Light None Factory Road Factory Road Dudley Dudley Education N/A   52.5324055 -2.0739923
3992 op-snap---monthly-publication-december-2025.pdf   120 2025-12 Car Mercedes-Benz Vito White Contravening a Red Traffic Light None Factory Road Factory Road Dudley Dudley Education N/A   52.5324055 -2.0739923
3997 op-snap---monthly-publication-december-2025.pdf   125 2025-12 Car Renault Truck White Contravening a Red Traffic Light None Newport Road, Castle Bromwich Newport Road, Castle Bromwich Birmingham Birmingham Education N/A      
4001 op-snap---monthly-publication-december-2025.pdf   129 2025-12 Car Skoda Octavia Black Contravening a Red Traffic Light None Stafford Road Stafford Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6291998 -2.126312
4007 op-snap---monthly-publication-december-2025.pdf   135 2025-12 Car Audi A5 Silver Contravening a Red Traffic Light None Church Hill Road Church Hill Road Solihull Solihull Education N/A   52.4078582 -1.7777439
4008 op-snap---monthly-publication-december-2025.pdf   136 2025-12 Car Fiat doblo Red Contravening a Red Traffic Light None Soho Hill Soho Hill Birmingham Birmingham NFA No Offence   52.4983151 -1.9186252
4013 op-snap---monthly-publication-december-2025.pdf   141 2025-12 Car BMW 3 series Black Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham NFA No Independent Evidence Available   52.4726661 -1.8769032
4014 op-snap---monthly-publication-december-2025.pdf   142 2025-12 Car BMW 2 series Black Contravening a Red Traffic Light None Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
4018 op-snap---monthly-publication-december-2025.pdf   146 2025-12 Car Mercedes-Benz CLA Red Contravening a Red Traffic Light None Hagley Road West Hagley Road West Birmingham Birmingham NFA No Offence   52.4656414 -1.9852276
4021 op-snap---monthly-publication-december-2025.pdf   149 2025-12 Pedal Bike Volkswagen Polo White Contravening a Red Traffic Light None California Way California Way Birmingham Birmingham NFA No VRM   52.4454714 -1.9753804
4030 op-snap---monthly-publication-december-2025.pdf   158 2025-12 Car Honda Jazz Grey Contravening a Red Traffic Light None Wolverhampton Road at Portway Wolverhampton Road at Portway RSoaanddwell Rsoaanddwell Fixed Penalty N/A   52.4661511 -1.9846785
4036 op-snap---monthly-publication-december-2025.pdf   164 2025-12 Car BMW 420 Black Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
4037 op-snap---monthly-publication-december-2025.pdf   165 2025-12 Car Kia Niro Black Contravening a Red Traffic Light None Hagley Road Hagley Road Birmingham Birmingham NFA No Offence   52.471632 -1.9456776
4038 op-snap---monthly-publication-december-2025.pdf   166 2025-12 Car Volkswagen Golf White Contravening a Red Traffic Light None Hagley Road Hagley Road Birmingham Birmingham NFA No Offence   52.471632 -1.9456776
4042 op-snap---monthly-publication-december-2025.pdf   170 2025-12 Car BMW X5 White Contravening a Red Traffic Light None Newton Road Newton Road Birmingham Birmingham NFA No Independent Evidence Available   52.4541102 -1.8710993
4053 op-snap---monthly-publication-december-2025.pdf   181 2025-12 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Fenton Street Fenton Street Sandwell Sandwell NFA No VRM   52.5004036 -1.9790049
4054 op-snap---monthly-publication-december-2025.pdf   182 2025-12 Car Skoda Octavia Black Contravening a Red Traffic Light None Fenton Street Fenton Street Sandwell Sandwell Court N/A   52.5004036 -1.9790049
4056 op-snap---monthly-publication-december-2025.pdf   184 2025-12 Car Porsche Macan Black Contravening a Red Traffic Light None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5872149 -1.8300386
4058 op-snap---monthly-publication-december-2025.pdf   186 2025-12 Car Toyota Yaris White Contravening a Red Traffic Light None Beake Avenue Beake Avenue Coventry Coventry NFA No Independent Evidence Available   52.4388246 -1.5229308
4073 op-snap---monthly-publication-december-2025.pdf   201 2025-12 Car Suzuki Swift White Contravening a Red Traffic Light None Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Education N/A   52.4861917 -1.8829748
4076 op-snap---monthly-publication-december-2025.pdf   204 2025-12 Car Audi A3 Grey Contravening a Red Traffic Light None A449 Wolverhampton Wolverhampton Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5879884 -2.120242
4084 op-snap---monthly-publication-december-2025.pdf   212 2025-12 Car Ford Focus Grey Contravening a Red Traffic Light None Brockmoor High St Brockmoor High Street Dudley Dudley NFA No Independent Evidence Available      
4092 op-snap---monthly-publication-december-2025.pdf   220 2025-12 Car Volkswagen GOLF Red Contravening a Red Traffic Light None Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Fixed Penalty N/A   52.4861917 -1.8829748
4093 op-snap---monthly-publication-december-2025.pdf   221 2025-12 Car Seat ibiza Grey Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham NFA No Offence   52.4726661 -1.8769032
4101 op-snap---monthly-publication-december-2025.pdf   229 2025-12 Car BMW X3.. Grey Contravening a Red Traffic Light None Alcester Road South Alcester Road South Birmingham Birmingham Warning Letter N/A   52.4170522 -1.8906187
4112 op-snap---monthly-publication-december-2025.pdf   240 2025-12 Car Mercedes-Benz GLA Black Contravening a Red Traffic Light None Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham NFA No Offence      
4116 op-snap---monthly-publication-december-2025.pdf   244 2025-12 Car Volkswagen Tiguan Black Contravening a Red Traffic Light None Kitchen Lane, Ashmore Park Kitchen Lane, Ashmore Park Wolverhampton Wolverhampton Education N/A   52.6214265 -2.0603757
4121 op-snap---monthly-publication-december-2025.pdf   249 2025-12 Car Mercedes-Benz C class Black Contravening a Red Traffic Light None Eastfield Road, Stechford Eastfield Road, Stechford Birmingham Birmingham NFA No VRM   52.486104 -1.8218907
4122 op-snap---monthly-publication-december-2025.pdf   250 2025-12 Car Ford Focus Silver Contravening a Red Traffic Light None Chester Road, Spitfire Island, Castl Chester Road, Spitfire Island, Castl eB iVrmaleingham Eb Ivrmaleingham Education N/A      
4141 op-snap---monthly-publication-december-2025.pdf   269 2025-12 Car Mercedes-Benz c class Silver Contravening a Red Traffic Light Use vehicle on a road withou tV vuallcidan t ersdt, cbeilrsttiofincate t V vuallcidan t ersdt, cbeilrsttiofincate Wolverhampton Wolverhampton Fixed Penalty N/A      
4150 op-snap---monthly-publication-december-2025.pdf   278 2025-12 Car Volkswagen Polo Black Contravening a Red Traffic Light None Park Gate Road Park Gate Road Coventry Coventry Court N/A   52.4538286 -1.7889568
4153 op-snap---monthly-publication-december-2025.pdf   281 2025-12 Car Volkswagen Polo White Contravening a Red Traffic Light None Lichfield Road A5127 / Cuckoo Ro Lichfield Road A5127 / Cuckoo Ro aBdirmingham Abdirmingham Education N/A   52.5872149 -1.8300386
4157 op-snap---monthly-publication-december-2025.pdf   285 2025-12 Pedal Bike Seat Ibiza Black Contravening a Red Traffic Light None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
4158 op-snap---monthly-publication-december-2025.pdf   286 2025-12 Car Audi A3 Black Contravening a Red Traffic Light None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Fixed Penalty N/A   52.4929304 -1.8229092
4164 op-snap---monthly-publication-december-2025.pdf   292 2025-12 Car Mercedes-Benz A180.. Blue Contravening a Red Traffic Light None New Hampton New Hampton Birmingham Birmingham NFA No Independent Evidence Available   52.4896402 -1.9101083
4165 op-snap---monthly-publication-december-2025.pdf   293 2025-12 Car Toyota Camry Black Contravening a Red Traffic Light None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
4167 op-snap---monthly-publication-december-2025.pdf   295 2025-12 Car Ford Transit Silver Contravening a Red Traffic Light None Bordsley Circus Roundabout Bordsley Circus Roundabout Birmingham Birmingham NFA No Offence      
4177 op-snap---monthly-publication-december-2025.pdf   305 2025-12 Car Scania Tractor White Contravening a Red Traffic Light None Hagley Road Hagley Road Birmingham Birmingham NFA No Offence   52.471632 -1.9456776
4188 op-snap---monthly-publication-december-2025.pdf   316 2025-12 Car BMW 118i Black Contravening a Red Traffic Light None Craddock Street Craddock Street Birmingham Birmingham NFA No Independent Evidence Available   52.490126 -1.9129277
4191 op-snap---monthly-publication-december-2025.pdf   319 2025-12 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
4261 op-snap---monthly-publication-december-2025.pdf   389 2025-12 Car BMW 3 Series Black Contravening a Red Traffic Light None Spring HIll Spring HIll Birmingham Birmingham NFA No Independent Evidence Available   52.4854232 -1.9218159
4266 op-snap---monthly-publication-december-2025.pdf   394 2025-12 Car Audi A3.. White Contravening a Red Traffic Light None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4268 op-snap---monthly-publication-december-2025.pdf   396 2025-12 Car Scania Lorry White Contravening a Red Traffic Light None Islington Road Islington Road Birmingham Birmingham Warning Letter N/A      
4272 op-snap---monthly-publication-december-2025.pdf   400 2025-12 Car Jaguar E Pace Grey Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
4306 op-snap---monthly-publication-december-2025.pdf   434 2025-12 Car Mini Clubman Grey Contravening a Red Traffic Light None Chester Road North Chester Road North Birmingham Birmingham Warning Letter N/A   52.548449 -1.8594603
4309 op-snap---monthly-publication-december-2025.pdf   437 2025-12 Car Seat Alhambra White Contravening a Red Traffic Light None Black Lake Black Lake Sandwell Sandwell Fixed Penalty N/A   52.5341947 -2.0098521
4312 op-snap---monthly-publication-december-2025.pdf   440 2025-12 Car Audi A1 White Contravening a Red Traffic Light None B4124 Hamstread Hill Hamstread Hill Birmingham Birmingham NFA No Offence      
4315 op-snap---monthly-publication-december-2025.pdf   443 2025-12 Car   various   Contravening a Red Traffic Light None Birmingham Birmingham Birmingham Birmingham NFA No VRM   52.4796992 -1.9026911
4327 op-snap---monthly-publication-december-2025.pdf   455 2025-12 Car Nissan Qashqai Black Contravening a Red Traffic Light None Fletchemstead Highway A45 Fletchemstead Highway A45 Coventry Coventry Warning Letter N/A      
4385 op-snap---monthly-publication-december-2025.pdf   513 2025-12 Car Audi Q3 Silver Contravening a Red Traffic Light Use vehicle on a road without valid test certificate Battery Way Battery Way Birmingham Birmingham Warning Letter N/A   52.4493988 -1.8476406
4386 op-snap---monthly-publication-december-2025.pdf   514 2025-12 Car Mercedes-Benz V220 Blue Contravening a Red Traffic Light None Ring Road, Ring Road Wolverhampton Wolverhampton NFA No VRM   52.5805525 -2.1302823
4387 op-snap---monthly-publication-december-2025.pdf   515 2025-12 Car Peugeot Boxer Silver Contravening a Red Traffic Light None Hall Lane Hall Lane Walsall Walsall NFA No Independent Evidence Available   52.6255445 -1.9722185
4390 op-snap---monthly-publication-december-2025.pdf   518 2025-12 car Mercedes-Benz   Black Contravening a Red Traffic Light None Manchester Manchester Out of Force Area Out of Force Area NFA Out of Force   52.4908553 -1.8943638
4394 op-snap---monthly-publication-december-2025.pdf   522 2025-12 Car Volkswagen Scirroco White Contravening a Red Traffic Light None Stratford Road Shirley Stratford Road Shirley Birmingham Birmingham Education N/A      
4395 op-snap---monthly-publication-december-2025.pdf   523 2025-12 Car Volkswagen Touran Silver Contravening a Red Traffic Light None Highfield Road Highfield Road Birmingham Birmingham Fixed Penalty N/A   52.4216321 -1.855984
4396 op-snap---monthly-publication-december-2025.pdf   524 2025-12 Car BMW 420D Grey Contravening a Red Traffic Light None Hamsread Road, Hockley Hamsread Road, Hockley Birmingham Birmingham Education N/A      
4397 op-snap---monthly-publication-december-2025.pdf   525 2025-12 Car Volkswagen Golf Silver Contravening a Red Traffic Light None A4040 Wellington Road Wellington Road Birmingham Birmingham Education N/A   52.5133725 -1.9193405
4406 op-snap---monthly-publication-december-2025.pdf   534 2025-12 Car Toyota Prius Silver Contravening a Red Traffic Light None Grove Lane Grove Lane Birmingham Birmingham NFA No Independent Evidence Available   52.5055208 -1.9328067
4423 op-snap---monthly-publication-december-2025.pdf   551 2025-12 Car Volkswagen Scirroco Purple Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A   52.4726661 -1.8769032
4424 op-snap---monthly-publication-december-2025.pdf   552 2025-12 Car Toyota Yaris Red Contravening a Red Traffic Light None High Street (A491), Stourbridge High Street (A491), Stourbridge Dudley Dudley Education N/A   52.4602651 -2.1490725
4429 op-snap---monthly-publication-december-2025.pdf   557 2025-12 Car BMW 33D Grey Contravening a Red Traffic Light None Newport Road Newport Road Birmingham Birmingham Education N/A   52.5027779 -1.7982159
4435 op-snap---monthly-publication-december-2025.pdf   563 2025-12 Car Mercedes-Benz C63 White Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham NFA No Independent Evidence Available   52.5919543 -1.8517118
4436 op-snap---monthly-publication-december-2025.pdf   564 2025-12 Car Daf   White Contravening a Red Traffic Light None A44 Pershore Pershore Out of Force Area Out of Force Area NFA Out of Force      
4478 op-snap---monthly-publication-december-2025.pdf   606 2025-12 Car BMW 1 Series Silver Contravening a Red Traffic Light None Bridgnorth Road Bridgnorth Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.5870072 -2.1755927
4479 op-snap---monthly-publication-december-2025.pdf   607 2025-12 Pedal Bike Mazda RX 8 Silver Contravening a Red Traffic Light None Bell Green Road Bell Green Road Coventry Coventry NFA No Independent Evidence Available   52.4324855 -1.4815548
4480 op-snap---monthly-publication-december-2025.pdf   608 2025-12 Car Ford Fiesta Blue Contravening a Red Traffic Light None Ring Road Wolves Ring Road Wolves Wolverhampton Wolverhampton NFA No Independent Evidence Available      
4504 op-snap---monthly-publication-december-2025.pdf   632 2025-12 Car BMW   White Contravening a Red Traffic Light None Old Walsall Road Old Walsall Road Birmingham Birmingham NFA No Independent Evidence Available   52.5294399 -1.9282714
4508 op-snap---monthly-publication-december-2025.pdf   636 2025-12 Car Nissan X-trail Black Contravening a Red Traffic Light None Small Heath Highway Small Heath Highway Birmingham Birmingham NFA No Independent Evidence Available   52.4709298 -1.8722585
4518 op-snap---monthly-publication-december-2025.pdf   646 2025-12 Car Toyota Prius Grey Contravening a Red Traffic Light None The Chesils The Chesils Coventry Coventry Fixed Penalty N/A   52.3887111 -1.5065639
4519 op-snap---monthly-publication-december-2025.pdf   647 2025-12 Car Audi A3 Black Contravening a Red Traffic Light None Brighton Road Brighton Road Birmingham Birmingham Education N/A   52.4543156 -1.8840717
4532 op-snap---monthly-publication-december-2025.pdf   660 2025-12 Car Audi A6.. White Contravening a Red Traffic Light None M42 Jct 3 M42 Junction 3 Out of Force Area Out of Force Area NFA Out of Force      
4545 op-snap---monthly-publication-december-2025.pdf   673 2025-12 Car Volkswagen Passat Silver Contravening a Red Traffic Light None Hagley Road West Hagley Road West Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4656414 -1.9852276
4548 op-snap---monthly-publication-december-2025.pdf   676 2025-12 Car Land Rover Range Rover Sport Grey Contravening a Red Traffic Light None Tipton Road jn with Birmingham N Tipton Road jn with Birmingham N eDwud Rleoyad Edwud Rleoyad Fixed Penalty N/A      
4549 op-snap---monthly-publication-december-2025.pdf   677 2025-12 Car Nissan Cube White Contravening a Red Traffic Light None Longmore Road Shirley Longmore Road Shirley Solihull Solihull NFA No Independent Evidence Available   52.4044532 -1.8136222
4567 op-snap---monthly-publication-december-2025.pdf   695 2025-12 Car Tesla Model Y Grey Contravening a Red Traffic Light None M5 Jn 6. West Mercia M5 Junction 6. West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4582 op-snap---monthly-publication-december-2025.pdf   710 2025-12 Car Land Rover Evoque Black Contravening a Red Traffic Light None West Bromwich Interchange West Bromwich Interchange Sandwell Sandwell Warning Letter N/A   52.5109262 -1.9753718
4590 op-snap---monthly-publication-december-2025.pdf   718 2025-12 Pedal Bike   Skip lorry Red Contravening a Red Traffic Light None Parade, nr Great Charles Street Q Parade, nr Great Charles Street Q uBeiernmsiwngahyam Ubeiernmsiwngahyam NFA Outside of 14 DAYS Late Submission      
4606 op-snap---monthly-publication-december-2025.pdf   734 2025-12 Car Audi SQ7 Blue Contravening a Red Traffic Light None A3400 Stratford Road Stratford Road Solihull Solihull NFA No Independent Evidence Available   52.4191184 -1.8326637
4618 op-snap---monthly-publication-december-2025.pdf   746 2025-12 Pedal Bike Skoda Karoq Blue Contravening a Red Traffic Light None Gibbins Road, Selly Oak Gibbins Road, Selly Oak Birmingham Birmingham Warning Letter N/A   52.4390303 -1.9512931
4622 op-snap---monthly-publication-december-2025.pdf   750 2025-12 Car Mercedes-Benz C200 Black Contravening a Red Traffic Light None Alcester Road Alcester Road Birmingham Birmingham NFA No Independent Evidence Available   52.4470686 -1.8880749
4632 op-snap---monthly-publication-december-2025.pdf   760 2025-12 Car Mg HS Trophy Grey Contravening a Red Traffic Light None Longbridge Lane Longbridge Lane Birmingham Birmingham NFA Not in Public Interest   52.3962003 -1.9821252
4633 op-snap---monthly-publication-december-2025.pdf   761 2025-12 Car Audi A3 Blue Contravening a Red Traffic Light None Hickman Road Hickman Road Dudley Dudley Education N/A   52.4878144 -2.1286751
4666 op-snap---monthly-publication-december-2025.pdf   794 2025-12 Car Toyota Prius Silver Contravening a Red Traffic Light None Linden Road Linden Road Birmingham Birmingham Fixed Penalty N/A   52.4263156 -1.9351622
4667 op-snap---monthly-publication-december-2025.pdf   795 2025-12 Car Ford eco sport Grey Contravening a Red Traffic Light None Wednesbury J9 Roundabout Wednesbury J9 Roundabout Sandwell Sandwell Education N/A      
4675 op-snap---monthly-publication-december-2025.pdf   803 2025-12 Car Mg 3.. Black Contravening a Red Traffic Light None Blackberry Lane Blackberry Lane Coventry Coventry Education N/A   52.4254016 -1.4665041
4676 op-snap---monthly-publication-december-2025.pdf   804 2025-12 Car Ford Focus Blue Contravening a Red Traffic Light None West Boulevard West Boulevard Birmingham Birmingham Education N/A   52.4484674 -1.9780395
4686 op-snap---monthly-publication-december-2025.pdf   814 2025-12 Car Hyundai Tuscon Black Contravening a Red Traffic Light None Jennens Road Jennens Road Birmingham Birmingham Education N/A   52.4855858 -1.8837544
4691 op-snap---monthly-publication-december-2025.pdf   819 2025-12 Car Audi A7 Black Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham NFA No Offence   52.4726661 -1.8769032
4692 op-snap---monthly-publication-december-2025.pdf   820 2025-12 Pedal Bike Audi A4 White Contravening a Red Traffic Light None Lichfield Road Lichfield Road Birmingham Birmingham Warning Letter N/A   52.5012458 -1.8780942
4717 op-snap---monthly-publication-december-2025.pdf   845 2025-12 Car Mercedes-Benz C250 Black Contravening a Red Traffic Light None Merridale Road Merridale Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.5854145 -2.1408114
4723 op-snap---monthly-publication-december-2025.pdf   851 2025-12 Car Toyota Auris Silver Contravening a Red Traffic Light None Clifford St Clifford Street Wolverhampton Wolverhampton NFA No Offence   52.592759 -2.1455592

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