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

162 rows where council_area = "Out of Force Area", 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, council_area_raw, nfa_rationale

disposal 2

reporter_transport_mode 1

  • Car · 162 ✖

offence 1

  • Contravening a Red Traffic Light · 162 ✖

council_area 1

  • Out of Force Area · 162 ✖
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
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      
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      
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      
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      
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
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
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      
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      
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      
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      
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      
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      
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      
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
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      
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      
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      
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
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      
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      
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      
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      
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      
4790 op-snap---monthly-publication-december-2025.pdf   918 2025-12 Car   Motorbike Black Contravening a Red Traffic Light None School Road, Nuneaton School Road, Nuneaton Out of Force Area Out of Force Area NFA Out of Force      
20647 op-snap---monthly-publication-november-2025.pdf   189 2025-11 Car Skoda Fabia White Contravening a Red Traffic Light None Birmingham Road (Lichfield) Birmingham Road (Lichfield) Out of Force Area Out of Force Area NFA Out of Force   52.5675481 -1.8213094
20806 op-snap---monthly-publication-november-2025.pdf   348 2025-11 Car Vauxhall Astra Blue Contravening a Red Traffic Light None A5190 Lichfield Lichfield Out of Force Area Out of Force Area NFA Out of Force   52.6708614 -1.8442078
20859 op-snap---monthly-publication-november-2025.pdf   401 2025-11 Car Audi A6 White Contravening a Red Traffic Light None Stoneleigh Road Stoneleigh Road Out of Force Area Out of Force Area NFA Out of Force   52.5137424 -1.8969649
21008 op-snap---monthly-publication-november-2025.pdf   550 2025-11 Car Suzuki Swift Red Contravening a Red Traffic Light None Blakedown Road Blakedown Road Out of Force Area Out of Force Area NFA Out of Force   52.4405157 -2.0638003
21013 op-snap---monthly-publication-november-2025.pdf   555 2025-11 Car BMW i3 Silver Contravening a Red Traffic Light None Priory Road, Kenilworth Priory Road, Kenilworth Out of Force Area Out of Force Area NFA Out of Force      
21544 op-snap---monthly-publication-november-2025.pdf   1086 2025-11 Car Peugeot Partner van White Contravening a Red Traffic Light None A5112 Hereford Road, Shrewsbury Hereford Road, Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
21755 op-snap---monthly-publication-november-2025.pdf   1297 2025-11 Car Tesla Model 3 White Contravening a Red Traffic Light None JCT 4 Roudabout for M5 JCT 4 Roudabout for M5 Out of Force Area Out of Force Area NFA Out of Force      
21802 op-snap---monthly-publication-november-2025.pdf   1344 2025-11 Car Ford Transit Black Contravening a Red Traffic Light None Wellington Road, Coalbrookedale Wellington Road, Coalbrookedale Out of Force Area Out of Force Area NFA Out of Force      
21858 op-snap---monthly-publication-november-2025.pdf   1400 2025-11 Car Mercedes-Benz E300 Grey Contravening a Red Traffic Light None Linley Lane Linley Lane Out of Force Area Out of Force Area NFA Out of Force   52.5994644 -1.9419658
21920 op-snap---monthly-publication-november-2025.pdf   1462 2025-11 Car Land Rover Evoque Brown Contravening a Red Traffic Light None M54 J2 M54 J2 Out of Force Area Out of Force Area NFA Out of Force   52.4945433 -2.0190848
21921 op-snap---monthly-publication-november-2025.pdf   1463 2025-11 Car BMW X3.. Black Contravening a Red Traffic Light None M54 J2 M54 J2 Out of Force Area Out of Force Area NFA Out of Force   52.4945433 -2.0190848
22078 op-snap---monthly-publication-october-2025.pdf   28 2025-10 Car Kia Sportage Black Contravening a Red Traffic Light None M42 J9 Island M42 J9 Island Out of Force Area Out of Force Area NFA Out of Force   52.3601724 -1.8062199
22107 op-snap---monthly-publication-october-2025.pdf   57 2025-10 Car Volvo XC70 Red Contravening a Red Traffic Light None Bilton Lane, Rugby Bilton Lane, Rugby Out of Force Area Out of Force Area NFA Out of Force      
22194 op-snap---monthly-publication-october-2025.pdf   144 2025-10 Car Volkswagen Tiago White Contravening a Red Traffic Light None Welsh Road, Warwickshire Welsh Road, Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
22232 op-snap---monthly-publication-october-2025.pdf   182 2025-10 Car Chevrolet Spark Blue Contravening a Red Traffic Light None Wrockwardine Wood Way, Telford Wrockwardine Wood Way, Telford Out of Force Area Out of Force Area NFA Out of Force      
22234 op-snap---monthly-publication-october-2025.pdf   184 2025-10 Car   Motorcycle Red Contravening a Red Traffic Light None Vale Road Stourport on Severn Vale Road Stourport on Severn Out of Force Area Out of Force Area NFA Out of Force      
22390 op-snap---monthly-publication-october-2025.pdf   340 2025-10 Car Ford Kuga Silver Contravening a Red Traffic Light None Amington Road Amington Road Out of Force Area Out of Force Area NFA Out of Force   52.4577115 -1.8237002
22476 op-snap---monthly-publication-october-2025.pdf   426 2025-10 Car Ford Transit White Contravening a Red Traffic Light None A5 J10 M42 Tamworth A5 J10 M42 Tamworth Out of Force Area Out of Force Area NFA Out of Force      
22507 op-snap---monthly-publication-october-2025.pdf   457 2025-10 Car Vauxhall van White Contravening a Red Traffic Light None Jn21 of M1, exit for M69 Jn21 of M1, exit for M69 Out of Force Area Out of Force Area NFA Out of Force      
22537 op-snap---monthly-publication-october-2025.pdf   487 2025-10 Car Ford Transit White Contravening a Red Traffic Light None Wolverhampton Road, Stafford Wolverhampton Road, Stafford Out of Force Area Out of Force Area NFA Out of Force   52.6022632 -2.1299215
22577 op-snap---monthly-publication-october-2025.pdf   527 2025-10 Car Vauxhall vivaro White Contravening a Red Traffic Light None J15 M40 J15 M40 Out of Force Area Out of Force Area NFA Out of Force      
22583 op-snap---monthly-publication-october-2025.pdf   533 2025-10 Car Ford Fiesta green Contravening a Red Traffic Light None A444 Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
22747 op-snap---monthly-publication-october-2025.pdf   697 2025-10 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Ashby Road Loughbrorough Ashby Road Loughbrorough Out of Force Area Out of Force Area NFA Out of Force      
22748 op-snap---monthly-publication-october-2025.pdf   698 2025-10 Car Vauxhall Corsa Green Contravening a Red Traffic Light None Dark Lane (Staffordshire) Dark Lane (Staffordshire) Out of Force Area Out of Force Area NFA Out of Force      
22783 op-snap---monthly-publication-october-2025.pdf   733 2025-10 Car Ford Ka Grey Contravening a Red Traffic Light None Davis Road, Evesham Davis Road, Evesham Out of Force Area Out of Force Area NFA Out of Force      
22919 op-snap---monthly-publication-october-2025.pdf   869 2025-10 Car   HGV Red Contravening a Red Traffic Light None Drybrook Gloucester Drybrook Gloucester Out of Force Area Out of Force Area NFA Out of Force      
23038 op-snap---monthly-publication-october-2025.pdf   988 2025-10 Car Mazda 3 White Contravening a Red Traffic Light None Bromsgrove Road Bromsgrove Road Out of Force Area Out of Force Area NFA Out of Force   52.4473174 -2.0452886
23082 op-snap---monthly-publication-october-2025.pdf   1032 2025-10 Car Land Rover Discovery Silver Contravening a Red Traffic Light None Castle Street, Hadley Castle Street, Hadley Out of Force Area Out of Force Area NFA Out of Force      
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      
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      
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      
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
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
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
24335 op-snap---monthly-publication-september-2025.pdf   554 2025-09 Car Land Rover Sport Grey Contravening a Red Traffic Light None Smithfield Road, Shrewbury Smithfield Road, Shrewbury Out of Force Area Out of Force Area NFA Out of Force      
24425 op-snap---monthly-publication-september-2025.pdf   644 2025-09 Car Scania   White Contravening a Red Traffic Light None M42 J9 Roundabout M42 J9 Roundabout Out of Force Area Out of Force Area NFA Out of Force   52.3601724 -1.8062199
24499 op-snap---monthly-publication-september-2025.pdf   718 2025-09 Car Skoda superb White Contravening a Red Traffic Light None Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
24592 op-snap---monthly-publication-september-2025.pdf   811 2025-09 Car Toyota Prius Silver Contravening a Red Traffic Light None Watery Lane, Lichfield Watery Lane, Lichfield Out of Force Area Out of Force Area NFA Out of Force      
24595 op-snap---monthly-publication-september-2025.pdf   814 2025-09 Car Vauxhall Combo van White Contravening a Red Traffic Light None Coventry Road Coventry Road Out of Force Area Out of Force Area NFA Out of Force   52.4519358 -1.7824508
24618 op-snap---monthly-publication-september-2025.pdf   837 2025-09 Car Volkswagen Golf Grey Contravening a Red Traffic Light None Battlefield Road, Shrewsbury Battlefield Road, Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
24661 op-snap---monthly-publication-september-2025.pdf   880 2025-09 Car Audi Q4 Grey Contravening a Red Traffic Light None Kidderminster Rd / Worcester Road, Hadley Kidderminster Road / Worcester Road, Hadley Out of Force Area Out of Force Area NFA Out of Force      
24723 op-snap---monthly-publication-september-2025.pdf   942 2025-09 Car Ford Modeo Silver Contravening a Red Traffic Light None Tachbrook Road Tachbrook Road Out of Force Area Out of Force Area NFA Out of Force      
24893 op-snap---monthly-publication-september-2025.pdf   1112 2025-09 Car Volkswagen Golf Black Contravening a Red Traffic Light None Dunbarton Avenue, York Dunbarton Avenue, York Out of Force Area Out of Force Area NFA Out of Force      
24895 op-snap---monthly-publication-september-2025.pdf   1114 2025-09 Car BMW X1 White Contravening a Red Traffic Light None Islington Leeds. Islington Leeds Out of Force Area Out of Force Area NFA Out of Force      
24946 op-snap---monthly-publication-september-2025.pdf   1165 2025-09 Car Mercedes-Benz SLK Black Contravening a Red Traffic Light None A460 A460 Out of Force Area Out of Force Area NFA Out of Force      
2059 op-snap---monthly-publication-august-2025.pdf   34 2025-08 Car Audi A3 Blue Contravening a Red Traffic Light None Homer Road Homer Road Out of Force Are Out of Force Area NFA No Independent Evidence Available      
2062 op-snap---monthly-publication-august-2025.pdf   37 2025-08 Car BMW M4 Grey Contravening a Red Traffic Light None Iiford High Road Iiford High Road Out of Force Are Out of Force Area NFA Out of Force      
2156 op-snap---monthly-publication-august-2025.pdf   131 2025-08 Car Tesla Model 3 Grey Contravening a Red Traffic Light None Europa Way Europa Way Out of Force Are Out of Force Area NFA Out of Force      
2192 op-snap---monthly-publication-august-2025.pdf   167 2025-08 Car Mercedes-Benz B200 Red Contravening a Red Traffic Light None Lime Lane Lime Lane Out of Force Are Out of Force Area NFA Out of Force      
2286 op-snap---monthly-publication-august-2025.pdf   261 2025-08 Car Vauxhall Corsa Black Contravening a Red Traffic Light None M42 J9 M42 J9 Out of Force Are Out of Force Area NFA Out of Force   52.3601724 -1.8062199
2336 op-snap---monthly-publication-august-2025.pdf   311 2025-08 Car Ford Transit White Contravening a Red Traffic Light None A453 (Tamworth) A453 (Tamworth) Out of Force Are Out of Force Area NFA Out of Force      
2505 op-snap---monthly-publication-august-2025.pdf   480 2025-08 Car   Sachs Red Contravening a Red Traffic Light None Gallingale View, Stoke Gallingale View, Stoke Out of Force Are Out of Force Area NFA Out of Force      
2558 op-snap---monthly-publication-august-2025.pdf   533 2025-08 Car BMW   White Contravening a Red Traffic Light None A444 A444 Out of Force Are Out of Force Area NFA Out of Force      
2559 op-snap---monthly-publication-august-2025.pdf   534 2025-08 Car Mercedes-Benz   Grey Contravening a Red Traffic Light None A444 A444 Out of Force Are Out of Force Area NFA Out of Force      
2575 op-snap---monthly-publication-august-2025.pdf   550 2025-08 Car BMW 1 Series White Contravening a Red Traffic Light None A4097 A4097 Out of Force Are Out of Force Area NFA Out of Force      
2582 op-snap---monthly-publication-august-2025.pdf   557 2025-08 Car Fiat 500 Grey Contravening a Red Traffic Light None Bulkington Bulkington Out of Force Are Out of Force Area NFA Out of Force      
2608 op-snap---monthly-publication-august-2025.pdf   583 2025-08 Car Seat Ateca Black Contravening a Red Traffic Light None Barrow Road Barrow Road Out of Force Are Out of Force Area NFA Out of Force      
2682 op-snap---monthly-publication-august-2025.pdf   657 2025-08 Car Peugeot   White Contravening a Red Traffic Light None M5 Bromsgrove M5 Bromsgrove Out of Force Are Out of Force Area NFA Out of Force   52.432364 -2.0176127
2746 op-snap---monthly-publication-august-2025.pdf   721 2025-08 Car Ford Ranger White Contravening a Red Traffic Light None A449 W`ton A449 W`ton Out of Force Are Out of Force Area NFA Out of Force      
2760 op-snap---monthly-publication-august-2025.pdf   735 2025-08 Car Nissan Juke White Contravening a Red Traffic Light None Stanley Matthews Way (Stoke) Staffs Stanley Matthews Way (Stoke) Staffs Out of Force Are Out of Force Area NFA Out of Force      
2789 op-snap---monthly-publication-august-2025.pdf   764 2025-08 Car Ford   Grey Contravening a Red Traffic Light None M6 J2 M6 J2 Out of Force Are Out of Force Area NFA Out of Force      
3067 op-snap---monthly-publication-august-2025.pdf   1042 2025-08 Car Toyota Prius Silver Contravening a Red Traffic Light None Floredine Street Tamworth (Staffs) Floredine Street Tamworth (Staffs) Out of Force Are Out of Force Area NFA Out of Force      
3079 op-snap---monthly-publication-august-2025.pdf   1054 2025-08 Car Seat Arona Grey Contravening a Red Traffic Light None M40 Jn10 in Warwickshire M40 Jn10 in Warwickshire Out of Force Are Out of Force Area NFA Out of Force      
3104 op-snap---monthly-publication-august-2025.pdf   1079 2025-08 Car Ford Auto-Trail Grey Contravening a Red Traffic Light None Chester Road South, Kidderminster Chester Road South, Kidderminster Out of Force Are Out of Force Area NFA Out of Force      
3128 op-snap---monthly-publication-august-2025.pdf   1103 2025-08 Car Volvo V40.. Silver Contravening a Red Traffic Light None Emstrey Island (West Mercia) Emstrey Island (West Mercia) Out of Force Are Out of Force Area NFA Out of Force      

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