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

102 rows where council_area = "Out of Force Area", month = "2025-11" 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, nfa_rationale, latitude, longitude

reporter_transport_mode 1

  • Car · 102 ✖

month 1

  • 2025-11 · 102 ✖

disposal 1

council_area 1

  • Out of Force Area · 102 ✖
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
20462 op-snap---monthly-publication-november-2025.pdf   4 2025-11 Car Ford Focus Blue Driving without Due Care and Attention None M6 NB 1 to 2 M6 Northbound 1 to 2 Out of Force Area Out of Force Area NFA Out of Force      
20467 op-snap---monthly-publication-november-2025.pdf   9 2025-11 Car BMW X4 Black Driving without Due Care and Attention None M6 Toll M6 Toll Out of Force Area Out of Force Area NFA Out of Force   52.5804962 -1.7833098
20472 op-snap---monthly-publication-november-2025.pdf   14 2025-11 Car     White Driving without Due Care and Attention None M40. M40 Out of Force Area Out of Force Area NFA No VRM      
20477 op-snap---monthly-publication-november-2025.pdf   19 2025-11 Car Audi A3.. Black Driving without Due Care and Attention None M5 (West Mercia) M5 (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
20486 op-snap---monthly-publication-november-2025.pdf   28 2025-11 Car Land Rover Discovery Black Driving without Due Care and Attention None Congleton Congleton Out of Force Area Out of Force Area NFA Out of Force   52.4408597 -1.4953575
20487 op-snap---monthly-publication-november-2025.pdf   29 2025-11 Car Audi A1 Grey Driving without Due Care and Attention None Lloyds Road (Telford?) Lloyds Road (Telford?) Out of Force Area Out of Force Area NFA Out of Force      
20499 op-snap---monthly-publication-november-2025.pdf   41 2025-11 Car BMW 2 series Blue Driving without Due Care and Attention None High Street, Alvechurch. West Mercia High Street, Alvechurch. West Mercia Out of Force Area Out of Force Area NFA Out of Force      
20503 op-snap---monthly-publication-november-2025.pdf   45 2025-11 Car Ford Transit White Driving without Due Care and Attention None Junction 11 Staffs Junction 11 Staffs Out of Force Area Out of Force Area NFA Out of Force      
20509 op-snap---monthly-publication-november-2025.pdf   51 2025-11 Car Volkswagen Golf Black Driving without Due Care and Attention None Dinmore Hill Dinmore Hill Out of Force Area Out of Force Area NFA Out of Force      
20513 op-snap---monthly-publication-november-2025.pdf   55 2025-11 Car Audi Q5 White Driving without Due Care and Attention None A52 A52 Out of Force Area Out of Force Area NFA Out of Force      
20514 op-snap---monthly-publication-november-2025.pdf   56 2025-11 Car Audi A3 Black Driving without Due Care and Attention None Lawley Common Lawley Common Out of Force Area Out of Force Area NFA Out of Force      
20541 op-snap---monthly-publication-november-2025.pdf   83 2025-11 Car Mercedes-Benz GLA Blue Driving without Due Care and Attention None Newport Road, Stafford Newport Road, Stafford Out of Force Area Out of Force Area NFA Out of Force      
20545 op-snap---monthly-publication-november-2025.pdf   87 2025-11 Car Volkswagen Golf White Driving without Due Care and Attention None Derby Road, Burton On Trent Derby Road, Burton On Trent Out of Force Area Out of Force Area NFA Out of Force      
20554 op-snap---monthly-publication-november-2025.pdf   96 2025-11 Car Ford Kuga Silver Driving without Due Care and Attention None Clough Road. (Hull) Clough Road. (Hull) Out of Force Area Out of Force Area NFA Out of Force      
20569 op-snap---monthly-publication-november-2025.pdf   111 2025-11 Car Honda   Silver Using a Mobile Phone Whilst Driving None M6 Toll NB M6 Toll Northbound Out of Force Area Out of Force Area NFA Out of Force      
20582 op-snap---monthly-publication-november-2025.pdf   124 2025-11 Car Lexus RC 300 Grey Driving without Due Care and Attention None A5, Lichfield A5, Lichfield Out of Force Area Out of Force Area NFA Out of Force   52.6562446 -1.9182118
20592 op-snap---monthly-publication-november-2025.pdf   134 2025-11 Car Jeep Avenger   Using a Mobile Phone Whilst Driving None M40 J4 M40 J4 Out of Force Area Out of Force Area NFA Out of Force      
20602 op-snap---monthly-publication-november-2025.pdf   144 2025-11 Car Toyota Corolla Grey Driving without Due Care and Attention None Butt Lane Warwickshire Butt Lane Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
20607 op-snap---monthly-publication-november-2025.pdf   149 2025-11 Car BMW X5 Silver Driving without Due Care and Attention None M5 Gloucester M5 Gloucester Out of Force Area Out of Force Area NFA Out of Force   52.4760581 -1.8948199
20631 op-snap---monthly-publication-november-2025.pdf   173 2025-11 Car Fiat 500.. Green Driving without Due Care and Attention None No exact location other than Redditch near Sainsburys No exact location other than Redditch near Sainsburys Out of Force Area Out of Force Area NFA Out of Force      
20633 op-snap---monthly-publication-november-2025.pdf   175 2025-11 Car Toyota Corolla White Driving without Due Care and Attention None Lydiate Ash. Lydiate Ash Out of Force Area Out of Force Area NFA Out of Force      
20639 op-snap---monthly-publication-november-2025.pdf   181 2025-11 Car Volkswagen Golf Silver Driving without Due Care and Attention None Abbey Bridge Evesham Abbey Bridge Evesham Out of Force Area Out of Force Area NFA Out of Force      
20643 op-snap---monthly-publication-november-2025.pdf   185 2025-11 Car Volvo   Grey Driving without Due Care and Attention None Stainer Street Staffs Stainer Street Staffs Out of Force Area Out of Force Area NFA Out of Force      
20645 op-snap---monthly-publication-november-2025.pdf   187 2025-11 Car Honda Civic Red Driving without Due Care and Attention None A49 West Mercia West Mercia Out of Force Area Out of Force Area NFA Out of Force   52.5827653 -2.0983246
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
20648 op-snap---monthly-publication-november-2025.pdf   190 2025-11 Car Omoda   White Driving without Due Care and Attention None M40 WARWICKSHIRE M40 Warwickshire Out of Force Area Out of Force Area NFA Out of Force   52.3976134 -1.4337873
20657 op-snap---monthly-publication-november-2025.pdf   199 2025-11 Car Renault Trafic White Using a Mobile Phone Whilst Driving None Tomkinson Road Tomkinson Road Out of Force Area Out of Force Area NFA Out of Force      
20661 op-snap---monthly-publication-november-2025.pdf   203 2025-11 Car Hyundai I10 Red Driving without Due Care and Attention None A449 West Mercia West Mercia Out of Force Area Out of Force Area NFA Out of Force   52.5827653 -2.0983246
20675 op-snap---monthly-publication-november-2025.pdf   217 2025-11 Car Volkswagen Golf Blue Driving without Due Care and Attention None Hanbury Hanbury Out of Force Area Out of Force Area NFA Out of Force   52.3760234 -1.7518131
20676 op-snap---monthly-publication-november-2025.pdf   218 2025-11 Car Kia Rio 2 Blue Driving without Due Care and Attention None M25 M25 Out of Force Area Out of Force Area NFA Out of Force      
20684 op-snap---monthly-publication-november-2025.pdf   226 2025-11 Car Renault Capture Red Driving without Due Care and Attention None Tame Drive Tame Drive Out of Force Area Out of Force Area NFA Out of Force   52.6183253 -1.9677414
20689 op-snap---monthly-publication-november-2025.pdf   231 2025-11 Car Mini Cooper Beige Driving without Due Care and Attention None Townsend Way Townsend Way Out of Force Area Out of Force Area NFA Out of Force   52.4814941 -1.9134628
20691 op-snap---monthly-publication-november-2025.pdf   233 2025-11 Car   Van Blue Driver not in position to have Proper Control None M1 Junction 8 M1 Junction 8 Out of Force Area Out of Force Area NFA Out of Force      
20701 op-snap---monthly-publication-november-2025.pdf   243 2025-11 Car BMW 640 D Black Misc - Non Traffic Offences None A456 (Tenbury Wells) A456 (Tenbury Wells) Out of Force Area Out of Force Area NFA Out of Force      
20731 op-snap---monthly-publication-november-2025.pdf   273 2025-11 Car Volkswagen California Grey Driving without Due Care and Attention None M54 M54 Out of Force Area Out of Force Area NFA Out of Force      
20738 op-snap---monthly-publication-november-2025.pdf   280 2025-11 Car Vauxhall Meriva Black Using a Mobile Phone Whilst Driving None Burley Road, Leeds Burley Road, Leeds Out of Force Area Out of Force Area NFA Out of Force      
20770 op-snap---monthly-publication-november-2025.pdf   312 2025-11 Car Polestar 3 Silver Driving without Due Care and Attention None Bishopstow Road, Warminster Bishopstow Road, Warminster Out of Force Area Out of Force Area NFA Out of Force      
20803 op-snap---monthly-publication-november-2025.pdf   345 2025-11 Car Audi Q2 Red Driving without Due Care and Attention None James Roby Way James Roby Way Out of Force Area Out of Force Area NFA Out of Force      
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
20807 op-snap---monthly-publication-november-2025.pdf   349 2025-11 Car Mercedes-Benz CLA 220 White Driving without Due Care and Attention None M1 Jct 4 M1 Junction 4 Out of Force Area Out of Force Area NFA Out of Force      
20828 op-snap---monthly-publication-november-2025.pdf   370 2025-11 Car Volkswagen Polo Blue Driving without Due Care and Attention None Tamworth Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.5724303 -1.8191247
20837 op-snap---monthly-publication-november-2025.pdf   379 2025-11 Car Peugeot 308 Black Driving without Due Care and Attention None Stonebridge Road Stonebridge Road Out of Force Area Out of Force Area NFA Out of Force   52.4623158 -1.7032394
20838 op-snap---monthly-publication-november-2025.pdf   380 2025-11 Car Nissan Juke White Driving without Due Care and Attention None Arley Lane - West Mercia Arley Lane - West Mercia Out of Force Area Out of Force Area NFA Out of Force      
20852 op-snap---monthly-publication-november-2025.pdf   394 2025-11 Car   Genesis Black Using a Mobile Phone Whilst Driving None M1 Junction 18 M1 Junction 18 Out of Force Area Out of Force Area NFA Out of Force      
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
20932 op-snap---monthly-publication-november-2025.pdf   474 2025-11 Car Peugeot Partner White Driving without Due Care and Attention None Dunchurch, near Rugby Dunchurch, near Rugby Out of Force Area Out of Force Area NFA Out of Force      
20960 op-snap---monthly-publication-november-2025.pdf   502 2025-11 Car       Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
20965 op-snap---monthly-publication-november-2025.pdf   507 2025-11 Car BMW M3 Black Driving without Due Care and Attention None Park Road, Ware Park Road, Ware Out of Force Area Out of Force Area NFA Out of Force      
20967 op-snap---monthly-publication-november-2025.pdf   509 2025-11 Car Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Springfield Road, Worcester Springfield Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
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      
21037 op-snap---monthly-publication-november-2025.pdf   579 2025-11 Car Mercedes-Benz   Black Using a Mobile Phone Whilst Driving None Brighton Road Brighton Road Out of Force Area Out of Force Area NFA Out of Force   52.4543156 -1.8840717
21050 op-snap---monthly-publication-november-2025.pdf   592 2025-11 Car Vauxhall Insignia Silver Driving without Due Care and Attention None Hessle High Road Hessle High Road Out of Force Area Out of Force Area NFA Out of Force      
21054 op-snap---monthly-publication-november-2025.pdf   596 2025-11 Car Dacia Duster Grey Driving without Due Care and Attention None Ironbridge Road Ironbridge Road Out of Force Area Out of Force Area NFA Out of Force      
21055 op-snap---monthly-publication-november-2025.pdf   597 2025-11 Car Vauxhall Vivaro White Driving without Due Care and Attention None Boundary Drive Boundary Drive Out of Force Area Out of Force Area NFA Out of Force   52.443303 -1.9033555
21059 op-snap---monthly-publication-november-2025.pdf   601 2025-11 Car BMW X5 Black Driving without Due Care and Attention None Southam, Warwickshire Southam, Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
21061 op-snap---monthly-publication-november-2025.pdf   603 2025-11 Car BMW 116 Black Driving without Due Care and Attention None Bingley Bingley Out of Force Area Out of Force Area NFA Out of Force   52.4891301 -1.8273363
21065 op-snap---monthly-publication-november-2025.pdf   607 2025-11 Car Mercedes-Benz EQE Black Using a Mobile Phone Whilst Driving None M1. M1 Out of Force Area Out of Force Area NFA Out of Force      
21081 op-snap---monthly-publication-november-2025.pdf   623 2025-11 Car Volvo XC90 Silver Driving without Due Care and Attention None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
21228 op-snap---monthly-publication-november-2025.pdf   770 2025-11 Car Peugeot   White Driving without Due Care and Attention None M42 M42 Out of Force Area Out of Force Area NFA Out of Force      
21240 op-snap---monthly-publication-november-2025.pdf   782 2025-11 Car Hyundai i30 blue Driving without Reasonable Consideration None M5 Northbound, West Mercia M5 Northbound, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
21253 op-snap---monthly-publication-november-2025.pdf   795 2025-11 Car Land Rover Evoque Grey Driving without Due Care and Attention None Washford Drive Washford Drive Out of Force Area Out of Force Area NFA Out of Force      
21274 op-snap---monthly-publication-november-2025.pdf   816 2025-11 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None M5? M5? Out of Force Area Out of Force Area NFA Out of Force   52.4467142 -2.0168499
21365 op-snap---monthly-publication-november-2025.pdf   907 2025-11 Car Peugeot 3008 White Driving without Due Care and Attention None M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
21390 op-snap---monthly-publication-november-2025.pdf   932 2025-11 Car Renault   Blue Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger None A442 A442 Out of Force Area Out of Force Area NFA Out of Force      
21395 op-snap---monthly-publication-november-2025.pdf   937 2025-11 Car Audi Q5 Grey Driving without Due Care and Attention None M62 Manchester M62 Manchester Out of Force Area Out of Force Area NFA Out of Force   52.4908553 -1.8943638
21396 op-snap---monthly-publication-november-2025.pdf   938 2025-11 Car Fiat Ducato White Driving without Due Care and Attention None Forest Ego, Bromsgrove Forest Ego, Bromsgrove Out of Force Area Out of Force Area NFA Out of Force      
21487 op-snap---monthly-publication-november-2025.pdf   1029 2025-11 Car Mitsubishi L200 White Using a Mobile Phone Whilst Driving None Hereford City Centre Hereford City Centre Out of Force Area Out of Force Area NFA Out of Force      
21490 op-snap---monthly-publication-november-2025.pdf   1032 2025-11 Car Volkswagen Touran Blue Driving without Due Care and Attention None Manor Road Kenilworth Manor Road Kenilworth Out of Force Area Out of Force Area NFA Out of Force   52.386917 -1.7285648
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      
21553 op-snap---monthly-publication-november-2025.pdf   1095 2025-11 Car Mercedes-Benz GLA Black Driving without Due Care and Attention None Strichley Avenue, Telford Strichley Avenue, Telford Out of Force Area Out of Force Area NFA Out of Force      
21581 op-snap---monthly-publication-november-2025.pdf   1123 2025-11 Car Skoda Octavia Black Driving without Due Care and Attention No Insurance M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
21584 op-snap---monthly-publication-november-2025.pdf   1126 2025-11 Car Toyota Corolla Black Driving without Due Care and Attention None George Street George Street Out of Force Area Out of Force Area NFA Out of Force   52.5048075 -1.9545728
21588 op-snap---monthly-publication-november-2025.pdf   1130 2025-11 Car Man Lorry White Driving without Due Care and Attention None A435 A435 Out of Force Area Out of Force Area NFA Out of Force      
21594 op-snap---monthly-publication-november-2025.pdf   1136 2025-11 Car Honda Civic Silver Misc - Non Traffic Offences None A14 A14 Out of Force Area Out of Force Area NFA Out of Force      
21608 op-snap---monthly-publication-november-2025.pdf   1150 2025-11 Car Man truck White Misc - Non Traffic Offences None lottle oxon lane Lottle Oxon Lane Out of Force Area Out of Force Area NFA Out of Force      
21632 op-snap---monthly-publication-november-2025.pdf   1174 2025-11 Car Volkswagen T Roc Blue Driving without Due Care and Attention None Kidderminster Road Kidderminster Road Out of Force Area Out of Force Area NFA Out of Force   52.4331313 -2.1702262
21634 op-snap---monthly-publication-november-2025.pdf   1176 2025-11 Car Iveco Daily White Driving without Due Care and Attention None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
21636 op-snap---monthly-publication-november-2025.pdf   1178 2025-11 Car Volvo XC90 White Using a Mobile Phone Whilst Driving None A43 A43 Out of Force Area Out of Force Area NFA Out of Force      
21639 op-snap---monthly-publication-november-2025.pdf   1181 2025-11 Car Audi Q7 Blue Driving without Due Care and Attention None Bassetts Pole Bassetts Pole Out of Force Area Out of Force Area NFA Out of Force   52.5622444 -1.816155
21649 op-snap---monthly-publication-november-2025.pdf   1191 2025-11 Car Audi a6 Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
21660 op-snap---monthly-publication-november-2025.pdf   1202 2025-11 Car Audi A1.. Blue Driving without Due Care and Attention None M1 between Jct 13 & 15. M1 between Junction 13 & 15 Out of Force Area Out of Force Area NFA Out of Force      
21667 op-snap---monthly-publication-november-2025.pdf   1209 2025-11 Car Volkswagen Passatt Silver Driving without Due Care and Attention None V6 Grafton Street V6 Grafton Street Out of Force Area Out of Force Area NFA Out of Force   52.4070357 -1.4938256
21715 op-snap---monthly-publication-november-2025.pdf   1257 2025-11 Car       Driving without Due Care and Attention None M6 NB Manchester M6 Northbound Manchester Out of Force Area Out of Force Area NFA No Independent Evidence Available      
21725 op-snap---monthly-publication-november-2025.pdf   1267 2025-11 Car Mercedes-Benz SLC Blue Driving without Due Care and Attention None Longdon Hill Worcester Longdon Hill Worcester 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      
21774 op-snap---monthly-publication-november-2025.pdf   1316 2025-11 Car Lamborghini Urus Green Driving without Due Care and Attention None New Road New Road Out of Force Area Out of Force Area NFA Out of Force   52.3947919 -2.0141009
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
21880 op-snap---monthly-publication-november-2025.pdf   1422 2025-11 Car Lexus ES300H Black Driving without Due Care and Attention None M6 SB J18 M6 Southbound J18 Out of Force Area Out of Force Area NFA Out of Force      
21901 op-snap---monthly-publication-november-2025.pdf   1443 2025-11 Car Nissan Qashqai White Driving without Due Care and Attention None A449 at Doctors Lane (Kinver) A449 at Doctors Lane (Kinver) Out of Force Area Out of Force Area NFA Out of Force      
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
21928 op-snap---monthly-publication-november-2025.pdf   1470 2025-11 Car Kia Sportage White Driving without Due Care and Attention None Stainland Road (Halifax) Stainland Road (Halifax) Out of Force Area Out of Force Area NFA Out of Force      
21934 op-snap---monthly-publication-november-2025.pdf   1476 2025-11 Car Byd Seal Black Driving without Due Care and Attention None M40 NB M40 Northbound Out of Force Area Out of Force Area NFA Out of Force      
21937 op-snap---monthly-publication-november-2025.pdf   1479 2025-11 Car Ford transit White Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
21945 op-snap---monthly-publication-november-2025.pdf   1487 2025-11 Car Honda CR-V Grey Using a Mobile Phone Whilst Driving None M25 - Jct 15-16 (Thames Valley) M25 - Junction 15-16 (Thames Valley) Out of Force Area Out of Force Area NFA Out of Force      
21949 op-snap---monthly-publication-november-2025.pdf   1491 2025-11 Car BMW m1 Grey Driving without Due Care and Attention None M5 Bristol M5 Bristol Out of Force Area Out of Force Area NFA Out of Force   52.4713698 -1.8991453
21951 op-snap---monthly-publication-november-2025.pdf   1493 2025-11 Car Vauxhall Combo White Driving without Due Care and Attention None Tern Hill West Mercia Tern Hill West Mercia Out of Force Area Out of Force Area NFA Out of Force      
21971 op-snap---monthly-publication-november-2025.pdf   1513 2025-11 Car Ford Transit White Driving without Due Care and Attention None A38 Oakhalls Oakhalls Out of Force Area 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);