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

1,016 rows where disposal = "NFA", 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: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make >30

month 14

reporter_transport_mode 1

  • Car · 1,016 ✖

offence 1

  • Contravening a Red Traffic Light · 1,016 ✖

disposal 1

  • NFA · 1,016 ✖
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
7304 op-snap---monthly-publication-february-2026.pdf   51 2026-02 Car     White Contravening a Red Traffic Light None High Street Wordesley High Street Wordesley Dudley Dudley NFA No Independent Evidence Available      
7361 op-snap---monthly-publication-february-2026.pdf   108 2026-02 Car Vauxhall Corsa White Contravening a Red Traffic Light None Bilston Road Bilston Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.5801329 -2.1138283
7434 op-snap---monthly-publication-february-2026.pdf   181 2026-02 Car Vauxhall Combo White Contravening a Red Traffic Light None Leek Road (A53) - Staffs Leek Road (A53) - Staffs Out of Force Area Out of Force Area NFA Out of Force      
7467 op-snap---monthly-publication-february-2026.pdf   214 2026-02 Car Audi A5 White Contravening a Red Traffic Light None Trinty Road Warkwickshire Trinty Road Warkwickshire Out of Force Area Out of Force Area NFA Out of Force      
7492 op-snap---monthly-publication-february-2026.pdf   239 2026-02 Car Mercedes-Benz   Black Contravening a Red Traffic Light None Talgarth Road London Talgarth Road London Out of Force Area Out of Force Area NFA Out of Force      
7556 op-snap---monthly-publication-february-2026.pdf   303 2026-02 Car Daf DAF Truck White Contravening a Red Traffic Light None Gibbins Road Gibbins Road Birmingham Birmingham NFA No VRM   52.4390303 -1.9512931
7643 op-snap---monthly-publication-february-2026.pdf   390 2026-02 Car Toyota   Blue Contravening a Red Traffic Light None Technology Drive Technology Drive Out of Force Area Out of Force Area NFA Out of Force      
7713 op-snap---monthly-publication-february-2026.pdf   460 2026-02 Car Volkswagen Golf Silver Contravening a Red Traffic Light None Birmingham Road Birmingham Road Birmingham Birmingham NFA No Independent Evidence Available   52.5505398 -1.8252993
7766 op-snap---monthly-publication-february-2026.pdf   513 2026-02 Car Mercedes-Benz CLA 180 White Contravening a Red Traffic Light None Witton Road Witton Road Birmingham Birmingham NFA No Offence   52.513336 -1.8833226
7778 op-snap---monthly-publication-february-2026.pdf   525 2026-02 Car       Contravening a Red Traffic Light None Sheet Road, Ludlow Sheet Road, Ludlow Out of Force Area Out of Force Area NFA Out of Force      
7858 op-snap---monthly-publication-february-2026.pdf   605 2026-02 Car Citroen C1 Black Contravening a Red Traffic Light None Church Road Church Road Birmingham Birmingham NFA No Independent Evidence Available   52.4624743 -1.7763934
7864 op-snap---monthly-publication-february-2026.pdf   611 2026-02 Car Ford Fiesta Silver Contravening a Red Traffic Light None Appleby Magna Appleby Magna Out of Force Area Out of Force Area NFA Out of Force      
7942 op-snap---monthly-publication-february-2026.pdf   689 2026-02 Car Fiat Panda White Contravening a Red Traffic Light None Tamworth Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.5724303 -1.8191247
7992 op-snap---monthly-publication-february-2026.pdf   739 2026-02 Car Volkswagen Fox Red Contravening a Red Traffic Light None Bridgwater Road Bridgwater Road Out of Force Area Out of Force Area NFA Out of Force      
8008 op-snap---monthly-publication-february-2026.pdf   755 2026-02 Car Mercedes-Benz   White Contravening a Red Traffic Light None Harbourne Road Harborne Road Birmingham Birmingham NFA No VRM   52.4718503 -1.9195423
8024 op-snap---monthly-publication-february-2026.pdf   771 2026-02 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None School Road School Road Solihull Solihull NFA No Offence   52.3517888 -1.7783232
8082 op-snap---monthly-publication-february-2026.pdf   829 2026-02 Car Volkswagen T-Cross Black Contravening a Red Traffic Light None Edwards Road Edwards Road Birmingham Birmingham NFA     52.523745 -1.8332475
8087 op-snap---monthly-publication-february-2026.pdf   834 2026-02 Car Audi A3 Black Contravening a Red Traffic Light None Binley Road Binley Road Coventry Coventry NFA     52.4070602 -1.4732469
8230 op-snap---monthly-publication-february-2026.pdf   977 2026-02 Car Toyota Prius Blue Contravening a Red Traffic Light None Green Lane, Green Lane Walsall Walsall NFA     52.5995834 -1.9971273
8234 op-snap---monthly-publication-february-2026.pdf   981 2026-02 Car Audi Q7 White Contravening a Red Traffic Light None Holloway Circus Holloway Circus Birmingham Birmingham NFA No Offence   52.474604 -1.89977
8238 op-snap---monthly-publication-february-2026.pdf   985 2026-02 Car Alfa Romeo Q7 White Contravening a Red Traffic Light None Holloway Circus Holloway Circus Birmingham Birmingham NFA No Offence   52.474604 -1.89977
8248 op-snap---monthly-publication-february-2026.pdf   995 2026-02 Car Ford Kuga Black Contravening a Red Traffic Light None B4632 B4632 Out of Force Area Out of Force Area NFA Out of Force   52.3994858 -1.4923603
8296 op-snap---monthly-publication-february-2026.pdf   1043 2026-02 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None West Bromwich Ringway West Bromwich Ringway Sandwell Sandwell NFA No Offence   52.516463 -1.9937537
8372 op-snap---monthly-publication-february-2026.pdf   1119 2026-02 Car Alfa Romeo Bravo Black Contravening a Red Traffic Light None Minster Road Minster Road Out of Force Area Out of Force Area NFA Out of Force   52.4100542 -1.5227279
8373 op-snap---monthly-publication-february-2026.pdf   1120 2026-02 Car Hyundai   Grey Contravening a Red Traffic Light None Minster Road Minster Road Out of Force Area Out of Force Area NFA Out of Force   52.4100542 -1.5227279
8374 op-snap---monthly-publication-february-2026.pdf   1121 2026-02 Car Peugeot   Blue Contravening a Red Traffic Light None Minster Road Minster Road Out of Force Area Out of Force Area NFA Out of Force   52.4100542 -1.5227279
8399 op-snap---monthly-publication-february-2026.pdf   1146 2026-02 Car       Contravening a Red Traffic Light None Sneyd Lane Sneyd Lane Walsall Walsall NFA No Independent Evidence Available   52.6198941 -2.0150184
8425 op-snap---monthly-publication-february-2026.pdf   1172 2026-02 Car Ford Transit Grey Contravening a Red Traffic Light None Europa Way (Warwickshire) Europa Way (Warwickshire) Out of Force Area Out of Force Area NFA Out of Force      
8466 op-snap---monthly-publication-february-2026.pdf   1213 2026-02 Car Polestar model2 Grey Contravening a Red Traffic Light None A44 Oxford Peartree Park&Ride Oxford Peartree Park&Ride Out of Force Area Out of Force Area NFA Out of Force      
8509 op-snap---monthly-publication-february-2026.pdf   1256 2026-02 Car Nissan Qashqai Black Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham NFA     52.4167654 -1.9411244
8538 op-snap---monthly-publication-february-2026.pdf   1285 2026-02 Car Peugeot 207 Blue Contravening a Red Traffic Light None New Birmingham Road New Birmingham Road Sandwell Sandwell NFA No Independent Evidence Available   52.5113475 -2.0508304
8547 op-snap---monthly-publication-february-2026.pdf   1294 2026-02 Car   HGV White Contravening a Red Traffic Light None Walmley Ash Road Walmley Ash Road Sutton Coldfield Sutton Coldfield NFA No VRM   52.5376726 -1.7973346
8575 op-snap---monthly-publication-february-2026.pdf   1322 2026-02 Car Porsche Cayenne Black Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham NFA No Independent Evidence Available   52.5359496 -1.8324115
8590 op-snap---monthly-publication-february-2026.pdf   1337 2026-02 Car Peugeot 2008 Grey Contravening a Red Traffic Light None Lawford Road, Rugby Lawford Road, Rugby Out of Force Area Out of Force Area NFA Out of Force      
8680 op-snap---monthly-publication-february-2026.pdf   1427 2026-02 Car Mercedes-Benz C220 White Contravening a Red Traffic Light None Longbridge Lane Longbridge Lane Birmingham Birmingham NFA No Offence   52.3962003 -1.9821252
8684 op-snap---monthly-publication-february-2026.pdf   1431 2026-02 Car Audi A3.. Grey Contravening a Red Traffic Light None Milhouse Lane Milhouse Lane Out of Force Area Out of Force Area NFA Out of Force      
8746 op-snap---monthly-publication-february-2026.pdf   1493 2026-02 Car BMW 5 series Grey Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA     52.4552785 -1.906384
8754 op-snap---monthly-publication-february-2026.pdf   1501 2026-02 Car   Multiple   Contravening a Red Traffic Light None Middleton Hall Road Middleton Hall Road Birmingham Birmingham NFA Misc Inc Crimes   52.4149989 -1.9345999
8759 op-snap---monthly-publication-february-2026.pdf   1506 2026-02 Car Nissan Qashqai Black Contravening a Red Traffic Light None Bath Street Hereford (West Mercia) Bath Street Hereford (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
10559 op-snap---monthly-publication-january-2026.pdf   20 2026-01 Car Land Rover Range White Contravening a Red Traffic Light None Marshall Lake Road Marshall Lake Road Solihull Solihull NFA No Independent Evidence Available   52.3975426 -1.818252
10571 op-snap---monthly-publication-january-2026.pdf   32 2026-01 Car Toyota Estima White Contravening a Red Traffic Light None Bordesley Green Road Bordesley Green Road Birmingham Birmingham NFA No Independent Evidence Available   52.4804926 -1.8563658
10633 op-snap---monthly-publication-january-2026.pdf   94 2026-01 Car Audi Q2 Grey Contravening a Red Traffic Light None Sky Blue Way Sky Blue Way Coventry Coventry NFA No Independent Evidence Available   52.4085943 -1.4943275
10638 op-snap---monthly-publication-january-2026.pdf   99 2026-01 Car Peugeot 3008 Red Contravening a Red Traffic Light None Stoney Stanton Road Stoney Stanton Road Coventry Coventry NFA No Independent Evidence Available   52.4221152 -1.4959475
10789 op-snap---monthly-publication-january-2026.pdf   250 2026-01 Car Mercedes-Benz C250 White Contravening a Red Traffic Light None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA Not in Public Interest   52.5047428 -2.0823754
10790 op-snap---monthly-publication-january-2026.pdf   251 2026-01 Car Land Rover Discovery Black Contravening a Red Traffic Light None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA No Independent Evidence Available   52.5047428 -2.0823754
10795 op-snap---monthly-publication-january-2026.pdf   256 2026-01 Car BMW 1 Series Blue Contravening a Red Traffic Light None Coventry Road, Exhall Coventry Road, Exhall Out of Force Area Out of Force Area NFA Out of Force      
10818 op-snap---monthly-publication-january-2026.pdf   279 2026-01 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Horseley Heath, Great Bridge Horseley Heath, Great Bridge Sandwell Sandwell NFA No Independent Evidence Available   52.5289091 -2.0391504
10827 op-snap---monthly-publication-january-2026.pdf   288 2026-01 Car Vauxhall Antara White Contravening a Red Traffic Light None Middleton Hall Road Middleton Hall Road Birmingham Birmingham NFA No Independent Evidence Available   52.4149989 -1.9345999
10945 op-snap---monthly-publication-january-2026.pdf   406 2026-01 Car Volkswagen Passat Black Contravening a Red Traffic Light None Portland Road Portland Road Birmingham Birmingham NFA Misc Inc Crimes   52.4737014 -1.9412436
10952 op-snap---monthly-publication-january-2026.pdf   413 2026-01 Car Hyundai Tuscan Black Contravening a Red Traffic Light None Walsall Road, Perry Barr Walsall Road, Perry Barr Birmingham Birmingham NFA No Offence   52.5290137 -1.9098939
10991 op-snap---monthly-publication-january-2026.pdf   452 2026-01 Car Daf Coach White Contravening a Red Traffic Light None Cromwell Lane, Burton Green, near HS2 bridge. Warwickshire Cromwell Lane, Burton Green, near HS2 bridge. Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
11032 op-snap---monthly-publication-january-2026.pdf   493 2026-01 Car Mercedes-Benz CLA Grey Contravening a Red Traffic Light   Unknown, "between Ikea and Wolverhampton". Cannot idetify the road Unknown, "between Ikea and Wolverhampton". Cannot idetify the road Wolverhampton Wolverhampton NFA No Independent Evidence Available      
11033 op-snap---monthly-publication-january-2026.pdf   494 2026-01 Car Audi A5 Silver Contravening a Red Traffic Light None Silverwoods Road Silverwoods Road Out of Force Area Out of Force Area NFA Out of Force      
11074 op-snap---monthly-publication-january-2026.pdf   535 2026-01 Car BMW 116d Black Contravening a Red Traffic Light None Soundwell Road, Bristol Soundwell Road, Bristol Out of Force Area Out of Force Area NFA Out of Force      
11124 op-snap---monthly-publication-january-2026.pdf   585 2026-01 Car Vauxhall Astra Red Contravening a Red Traffic Light No Insurance Tyburn Road Tyburn Road Birmingham Birmingham NFA No Independent Evidence Available   52.5113867 -1.8337258
11135 op-snap---monthly-publication-january-2026.pdf   596 2026-01 Car Vauxhall Corsa White Contravening a Red Traffic Light None Mary Vale Road Mary Vale Road Birmingham Birmingham NFA No Independent Evidence Available   52.425105 -1.9312861
11163 op-snap---monthly-publication-january-2026.pdf   624 2026-01 Car Vauxhall Astra White Contravening a Red Traffic Light None Dunchurch Road Dunchurch Road Out of Force Area Out of Force Area NFA Out of Force   52.390889 -1.6541476
11169 op-snap---monthly-publication-january-2026.pdf   630 2026-01 Car Mercedes-Benz Citan White Contravening a Red Traffic Light None Darthmouth Middleway Darthmouth Middleway Birmingham Birmingham NFA No Offence      
11214 op-snap---monthly-publication-january-2026.pdf   675 2026-01 Car Ford Focus Red Contravening a Red Traffic Light None Telford Town Centre Telford Town Centre Out of Force Area Out of Force Area NFA Out of Force      
11231 op-snap---monthly-publication-january-2026.pdf   692 2026-01 Car Nissan   Red Contravening a Red Traffic Light None Wilford Lane Wilford Lane Out of Force Area Out of Force Area NFA Out of Force      
11277 op-snap---monthly-publication-january-2026.pdf   738 2026-01 Car Fiat 500.. Black Contravening a Red Traffic Light None Stafford Road Stafford Road Wolverhampton Wolverhampton NFA No VRM   52.6291998 -2.126312
11310 op-snap---monthly-publication-january-2026.pdf   771 2026-01 Car BMW   Blue Contravening a Red Traffic Light None A34 Newcastle Newcastle Out of Force Area Out of Force Area NFA Out of Force      
11386 op-snap---monthly-publication-january-2026.pdf   847 2026-01 Car Mercedes-Benz E350 Silver Contravening a Red Traffic Light None Water Orton Road Water Orton Road Birmingham Birmingham NFA No Independent Evidence Available   52.5153394 -1.7573409
11394 op-snap---monthly-publication-january-2026.pdf   855 2026-01 Car Honda Jazz Black Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
11395 op-snap---monthly-publication-january-2026.pdf   856 2026-01 Car BMW 218D White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
11414 op-snap---monthly-publication-january-2026.pdf   875 2026-01 Car Honda CRV Black Contravening a Red Traffic Light None M54 J4 Telford M54 J4 Telford Out of Force Area Out of Force Area NFA Out of Force      
11419 op-snap---monthly-publication-january-2026.pdf   880 2026-01 Car Toyota   Silver Contravening a Red Traffic Light None Walsall Street Walsall Street Sandwell Sandwell NFA No VRM   52.518373 -1.9888052
11428 op-snap---monthly-publication-january-2026.pdf   889 2026-01 Car Vauxhall Crossland Silver Contravening a Red Traffic Light None Wood Lane Wood Lane Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6245669 -2.1205194
11496 op-snap---monthly-publication-january-2026.pdf   957 2026-01 Car BMW 640.. White Contravening a Red Traffic Light None A34 Grey Friars Grey Friars Out of Force Area Out of Force Area NFA Out of Force      
11686 op-snap---monthly-publication-january-2026.pdf   1147 2026-01 Car Peugeot boxer White Contravening a Red Traffic Light None Hartshill Road Hartshill Road Out of Force Area Out of Force Area NFA Out of Force   52.4975631 -1.7895826
11718 op-snap---monthly-publication-january-2026.pdf   1179 2026-01 Car Toyota Auris Silver Contravening a Red Traffic Light None Melchett Road Melchett Road Birmingham Birmingham NFA No Independent Evidence Available   52.413984 -1.9251511
11785 op-snap---monthly-publication-january-2026.pdf   1246 2026-01 Car Citroen   White Contravening a Red Traffic Light None Worcester Road Worcester Road Out of Force Area Out of Force Area NFA Out of Force   52.5860898 -2.0339138
11818 op-snap---monthly-publication-january-2026.pdf   1279 2026-01 Car Mercedes-Benz Sprinter Blue Contravening a Red Traffic Light None Frankwell Island, Shrewsbury Frankwell Island, Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
11829 op-snap---monthly-publication-january-2026.pdf   1290 2026-01 Car Audi S3 White Contravening a Red Traffic Light None Alcester Road Alcester Road Birmingham Birmingham NFA No Independent Evidence Available   52.4470686 -1.8880749
11853 op-snap---monthly-publication-january-2026.pdf   1314 2026-01 Car Vauxhall Astra White Contravening a Red Traffic Light None Ryders Green Road Ryders Green Road Sandwell Sandwell NFA No Independent Evidence Available   52.5237744 -2.022827
11888 op-snap---monthly-publication-january-2026.pdf   1349 2026-01 Car   Tesco Van White Contravening a Red Traffic Light None Ring Road St Patricks Ring Road Street Patricks Wolverhampton Wolverhampton NFA No VRM      
11891 op-snap---monthly-publication-january-2026.pdf   1352 2026-01 Car BMW 1 Series White Contravening a Red Traffic Light None Hunter Road Hunter Road Wolverhampton Wolverhampton NFA No Independent Evidence Available      
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
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
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
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
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
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
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      
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
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      
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
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
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
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

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