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

98 rows where council_area = "Out of Force Area", month = "2025-07" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 7

disposal 2

offence 1

  • Driving without Due Care and Attention · 98 ✖

month 1

  • 2025-07 · 98 ✖

council_area 1

  • Out of Force Area · 98 ✖
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
11971 op-snap---monthly-publication-july-2025.pdf   23 2025-07 Car Skoda Enyaq Blue Driving without Due Care and Attention None A44 Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
11978 op-snap---monthly-publication-july-2025.pdf   30 2025-07 Car Vauxhall Corsa Red Driving without Due Care and Attention None Queensbury, Bradford Queensbury, Bradford Out of Force Area Out of Force Area NFA Out of Force      
11979 op-snap---monthly-publication-july-2025.pdf   31 2025-07 Car Porsche Cayman Silver Driving without Due Care and Attention None Stratford Road, Wellesbourne Stratford Road, Wellesbourne Out of Force Area Out of Force Area NFA Out of Force      
11984 op-snap---monthly-publication-july-2025.pdf   36 2025-07 Car Mercedes-Benz Sprinter Blue Driving without Due Care and Attention None Off force - west mercia Off force - west mercia Out of Force Area Out of Force Area NFA Out of Force      
11990 op-snap---monthly-publication-july-2025.pdf   42 2025-07 Car Ford Mondeo Blue Driving without Due Care and Attention None A5189 Burton upon Trent Burton upon Trent Out of Force Area Out of Force Area NFA Out of Force      
12000 op-snap---monthly-publication-july-2025.pdf   52 2025-07 Car Audi A6 Silver Driving without Due Care and Attention None Bilford Road Bilford Road Out of Force Area Out of Force Area NFA Out of Force      
12023 op-snap---monthly-publication-july-2025.pdf   75 2025-07 Car Audi Q3 Blue Driving without Due Care and Attention None M43 WB J3 M43 Wb J3 Out of Force Area Out of Force Area NFA Out of Force   52.4846642 -1.9297585
12025 op-snap---monthly-publication-july-2025.pdf   77 2025-07 Car Nissan Qashqai Black Driving without Due Care and Attention None Beehive Hill Beehive Hill Out of Force Area Out of Force Area NFA Out of Force   52.5518914 -2.0227634
12074 op-snap---monthly-publication-july-2025.pdf   126 2025-07 Car Volvo XC90 Black Driving without Due Care and Attention None M6 Warwickshire M6 Warwickshire Out of Force Area Out of Force Area NFA Out of Force   52.4572944 -1.4815973
12079 op-snap---monthly-publication-july-2025.pdf   131 2025-07 Car BMW   Black Driving without Due Care and Attention None Church Lane Church Lane Out of Force Area Out of Force Area NFA Out of Force   52.5133161 -1.9278283
12110 op-snap---monthly-publication-july-2025.pdf   162 2025-07 Car Audi Q7.. Grey Driving without Due Care and Attention None Slip road London Slip road London Out of Force Area Out of Force Area NFA Out of Force      
12127 op-snap---monthly-publication-july-2025.pdf   179 2025-07 Car Volkswagen Golf White Driving without Due Care and Attention None Bitterscote Drive Bitterscote Drive Out of Force Area Out of Force Area NFA Out of Force      
12139 op-snap---monthly-publication-july-2025.pdf   191 2025-07 Car Vauxhall Movano White Driving without Due Care and Attention None B4115 near Rocky Lane B4115 near Rocky Lane Out of Force Area Out of Force Area NFA Out of Force      
12142 op-snap---monthly-publication-july-2025.pdf   194 2025-07 Car Tesla model 3 white Driving without Due Care and Attention None A41, Newport, West Mercia A41, Newport, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
12157 op-snap---monthly-publication-july-2025.pdf   209 2025-07 Car Mercedes-Benz E220 Black Driving without Due Care and Attention None Ediburgh Ediburgh Out of Force Area Out of Force Area NFA Out of Force      
12171 op-snap---monthly-publication-july-2025.pdf   223 2025-07 Car Seat Ibiza Green Driving without Due Care and Attention None Pershore Road Pershore Road Out of Force Area Out of Force Area NFA Out of Force   52.4653873 -1.8988344
12195 op-snap---monthly-publication-july-2025.pdf   247 2025-07 Pedal Bike Mini cooper Blue Driving without Due Care and Attention None Bewdley Bewdley Out of Force Area Out of Force Area NFA Out of Force   52.4330724 -1.9181313
12214 op-snap---monthly-publication-july-2025.pdf   266 2025-07 Pedestrian Volkswagen Golf Blue Driving without Due Care and Attention None Bernard Road Bernard Road Out of Force Area Out of Force Area NFA No Independent Evidence Available   52.4777838 -1.9587163
12229 op-snap---monthly-publication-july-2025.pdf   281 2025-07 Car   Kymco Red Driving without Due Care and Attention None Cheadle - Off force Cheadle - Off force Out of Force Area Out of Force Area NFA Out of Force      
12231 op-snap---monthly-publication-july-2025.pdf   283 2025-07 Car Mercedes-Benz A class White Driving without Due Care and Attention None Ledbury, West Mercia Ledbury, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
12238 op-snap---monthly-publication-july-2025.pdf   290 2025-07 Car Mini Cooper Grey Driving without Due Care and Attention None Walwyn Road Walwyn Road Out of Force Area Out of Force Area NFA Out of Force      
12240 op-snap---monthly-publication-july-2025.pdf   292 2025-07 Car Renault Clio Grey Driving without Due Care and Attention None Astwood Road Astwood Road Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
12253 op-snap---monthly-publication-july-2025.pdf   305 2025-07 Car Volkswagen Golf Black Driving without Due Care and Attention None Droitwich Droitwich Out of Force Area Out of Force Area NFA Out of Force      
12274 op-snap---monthly-publication-july-2025.pdf   326 2025-07 Car   Infiniti Grey Driving without Due Care and Attention None Barlborough Interchange Barlborough Interchange Out of Force Area Out of Force Area NFA Out of Force      
12292 op-snap---monthly-publication-july-2025.pdf   344 2025-07 Car Peugeot Boxer van White Driving without Due Care and Attention None Smite lane, Worcester Smite lane, Worcester Out of Force Area Out of Force Area NFA Out of Force      
12297 op-snap---monthly-publication-july-2025.pdf   349 2025-07 Car Nissan Micra Red Driving without Due Care and Attention None Tesco, Blackpool Tesco, Blackpool Out of Force Area Out of Force Area NFA Out of Force      
12298 op-snap---monthly-publication-july-2025.pdf   350 2025-07 Car Ford Fiesta Black Driving without Due Care and Attention None Fleetwood FY7 7JL Fleetwood FY7 7JL Out of Force Area Out of Force Area NFA Out of Force   52.4743461 -1.7895289
12299 op-snap---monthly-publication-july-2025.pdf   351 2025-07 Car Volkswagen Golf Grey Driving without Due Care and Attention None Jubilee Tower, Lancaster Jubilee Tower, Lancaster Out of Force Area Out of Force Area NFA Out of Force      
12309 op-snap---monthly-publication-july-2025.pdf   361 2025-07 Lorry Iveco Daily Yellow 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
12403 op-snap---monthly-publication-july-2025.pdf   455 2025-07 Car Mercedes-Benz CLK-250 Grey Driving without Due Care and Attention None B4504 Redditch Redditch Out of Force Area Out of Force Area NFA Out of Force   52.4072158 -1.9277937
12420 op-snap---monthly-publication-july-2025.pdf   472 2025-07 Pedal Bike Land Rover Discovery Silver Driving without Due Care and Attention None Bridgenorth Road Bridgenorth Road Out of Force Area Out of Force Area NFA Out of Force      
12444 op-snap---monthly-publication-july-2025.pdf   496 2025-07 Pedestrian Ford Focus Orange Driving without Due Care and Attention None Off Force Off Force Out of Force Area Out of Force Area NFA Out of Force      
12451 op-snap---monthly-publication-july-2025.pdf   503 2025-07 Car BMW   White Driving without Due Care and Attention None M40 Motorway M40 Motorway Out of Force Area Out of Force Area NFA Out of Force   52.490826 -1.8882034
12452 op-snap---monthly-publication-july-2025.pdf   504 2025-07 Pedestrian BMW M2 White Driving without Due Care and Attention None Tesco Blackpool Tesco Blackpool Out of Force Area Out of Force Area NFA Out of Force      
12467 op-snap---monthly-publication-july-2025.pdf   519 2025-07 Car Volkswagen Golf Black 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
12470 op-snap---monthly-publication-july-2025.pdf   522 2025-07 Other       Driving without Due Care and Attention None Cowslip Road Cowslip Road Out of Force Area Out of Force Area NFA No VRM      
12471 op-snap---monthly-publication-july-2025.pdf   523 2025-07 Horse Rider Ford Fiesta White Driving without Due Care and Attention None Haselour Lane Haselour Lane Out of Force Area Out of Force Area NFA Out of Force      
12485 op-snap---monthly-publication-july-2025.pdf   537 2025-07 Pedal Bike Vauxhall Zafira Silver Driving without Due Care and Attention None Thruxton, Herefordshire Thruxton, Herefordshire Out of Force Area Out of Force Area NFA Out of Force      
12493 op-snap---monthly-publication-july-2025.pdf   545 2025-07 Car       Driving without Due Care and Attention None High Lane High Lane Out of Force Area Out of Force Area NFA Out of Force   52.4908428 -1.9653065
12495 op-snap---monthly-publication-july-2025.pdf   547 2025-07 Car Jaguar   Black Driving without Due Care and Attention None Four Ashes Road Four Ashes Road Out of Force Area Out of Force Area NFA Out of Force   52.3828826 -1.7624844
12499 op-snap---monthly-publication-july-2025.pdf   551 2025-07 Car Ford Focus Blue Driving without Due Care and Attention None Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
12509 op-snap---monthly-publication-july-2025.pdf   561 2025-07 Car Skoda Enyaq Blue Driving without Due Care and Attention None M6 NB Liverpool M6 Northbound Liverpool Out of Force Area Out of Force Area NFA Out of Force      
12510 op-snap---monthly-publication-july-2025.pdf   562 2025-07 Car Land Rover Range Black Driving without Due Care and Attention None Off force Off force Out of Force Area Out of Force Area NFA Out of Force      
12535 op-snap---monthly-publication-july-2025.pdf   587 2025-07 Car Mercedes-Benz C class Black Driving without Due Care and Attention None M6 nr Jn2 M6 nr Jn2 Out of Force Area Out of Force Area NFA Out of Force      
12565 op-snap---monthly-publication-july-2025.pdf   617 2025-07 Car Mercedes-Benz Lorry White Driving without Due Care and Attention None A5 Watling Street Watling Street Out of Force Area Out of Force Area NFA Out of Force   52.6562907 -1.9111505
12577 op-snap---monthly-publication-july-2025.pdf   629 2025-07 Car Honda Civic Silver Driving without Due Care and Attention None A441, Birmingham Road A441, Birmingham Road Out of Force Area Out of Force Area NFA Out of Force   52.5358009 -1.8271588
12602 op-snap---monthly-publication-july-2025.pdf   654 2025-07 Car Nissan Juke Grey Driving without Due Care and Attention None A49 Ludlow Ludlow Out of Force Area Out of Force Area NFA Out of Force      
12631 op-snap---monthly-publication-july-2025.pdf   683 2025-07 Car BMW X5.. Black Driving without Due Care and Attention None A523 A523 Out of Force Area Out of Force Area NFA Out of Force      
12632 op-snap---monthly-publication-july-2025.pdf   684 2025-07 Motorbike Land Rover Defender Grey Driving without Due Care and Attention None New Road Norton Lindsey New Road Norton Lindsey Out of Force Area Out of Force Area NFA Out of Force      
12633 op-snap---monthly-publication-july-2025.pdf   685 2025-07 Car Ford Galaxy Black Driving without Due Care and Attention None A38 Droitwich Droitwich Out of Force Area Out of Force Area NFA Out of Force      
12657 op-snap---monthly-publication-july-2025.pdf   709 2025-07 Car Vauxhall Astra Silver Driving without Due Care and Attention None M4 Eastbound J11 M4 Eastbound J11 Out of Force Area Out of Force Area NFA Out of Force      
12674 op-snap---monthly-publication-july-2025.pdf   726 2025-07 Car Volkswagen Caddy White Driving without Due Care and Attention None A5 Wall Island Wall Island Out of Force Area Out of Force Area NFA Out of Force      
12677 op-snap---monthly-publication-july-2025.pdf   729 2025-07 Car Volkswagen Golf Grey Driving without Due Care and Attention None M62 M62 Out of Force Area Out of Force Area NFA Out of Force      
12680 op-snap---monthly-publication-july-2025.pdf   732 2025-07 Car Audi A3 Grey Driving without Due Care and Attention None A5 (Staffs) A5 (Staffs) Out of Force Area Out of Force Area NFA Out of Force   52.6562775 -1.9262309
12683 op-snap---monthly-publication-july-2025.pdf   735 2025-07 Car Omoda 5 NOBLE Black Driving without Due Care and Attention None Lincolnshire Lincolnshire Out of Force Area Out of Force Area NFA Out of Force      
12689 op-snap---monthly-publication-july-2025.pdf   741 2025-07 Pedestrian Jaguar F Pace Grey Driving without Due Care and Attention None B4034 Stratford Stratford Out of Force Area Out of Force Area NFA Out of Force      
12697 op-snap---monthly-publication-july-2025.pdf   749 2025-07 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Valley Road, Earlswood Valley Road, Earlswood Out of Force Area Out of Force Area NFA Out of Force      
12711 op-snap---monthly-publication-july-2025.pdf   763 2025-07 Car Mercedes-Benz   Blue Driving without Due Care and Attention None Derby Road, Off Force Derby Road, Off Force Out of Force Area Out of Force Area NFA Out of Force      
12716 op-snap---monthly-publication-july-2025.pdf   768 2025-07 Car Ford Ranger Grey Driving without Due Care and Attention None M74 M74 Out of Force Area Out of Force Area NFA Out of Force      
12717 op-snap---monthly-publication-july-2025.pdf   769 2025-07 Car Mercedes-Benz Vito Grey Driving without Due Care and Attention Driving without Due Care and AMt5te4n (tOiount of Force) AMt5te4n (t Oiount of Force) Out of Force Area Out of Force Area NFA Out of Force      
12721 op-snap---monthly-publication-july-2025.pdf   773 2025-07 Car Audi A5... Grey Driving without Due Care and Attention None A53 A53 Out of Force Area Out of Force Area NFA Out of Force      
12741 op-snap---monthly-publication-july-2025.pdf   793 2025-07 Car Land Rover Discovery Black Driving without Due Care and Attention None A483 (Welshpool) A483 (Welshpool) Out of Force Area Out of Force Area NFA Out of Force      
12748 op-snap---monthly-publication-july-2025.pdf   800 2025-07 Car Audi S1 Blue Driving without Due Care and Attention None Moor Road (West Yorkshire) Moor Road (West Yorkshire) Out of Force Area Out of Force Area NFA Out of Force      
12794 op-snap---monthly-publication-july-2025.pdf   846 2025-07 Pedestrian Volkswagen polo Black Driving without Due Care and Attention None Telford Telford Out of Force Area Out of Force Area NFA Out of Force   52.4979333 -1.9664857
12795 op-snap---monthly-publication-july-2025.pdf   847 2025-07 Car Hyundai Kona Grey Driving without Due Care and Attention None M5 South (Frankley Services) M5 South (Frankley Services) Out of Force Area Out of Force Area NFA Out of Force      
12809 op-snap---monthly-publication-july-2025.pdf   861 2025-07 Car Mercedes-Benz A200.. Black Driving without Due Care and Attention None M62 M62 Out of Force Area Out of Force Area NFA Out of Force      
12815 op-snap---monthly-publication-july-2025.pdf   867 2025-07 Pedestrian Mercedes-Benz S350 Silver Driving without Due Care and Attention None A3400 (Stratford Up on Avon) Warks A3400 (Stratford Up on Avon) Warks Out of Force Area Out of Force Area NFA Out of Force      
12825 op-snap---monthly-publication-july-2025.pdf   877 2025-07 Car Vauxhall Mokka White Driving without Due Care and Attention None Woodhouse Lane Woodhouse Lane Out of Force Area Out of Force Area NFA Out of Force      
12831 op-snap---monthly-publication-july-2025.pdf   883 2025-07 Car BMW M140I Grey Driving without Due Care and Attention None A38 A38 Out of Force Area Out of Force Area NFA Out of Force      
12874 op-snap---monthly-publication-july-2025.pdf   926 2025-07 Car Vauxhall Movano Yellow Driving without Due Care and Attention No Insurance M54 nr Telford M54 nr Telford Out of Force Area Out of Force Area NFA Out of Force      
12977 op-snap---monthly-publication-july-2025.pdf   1029 2025-07 Car Vauxhall Viva Silver Driving without Due Care and Attention None M40 Warwick. M40 Warwick Out of Force Area Out of Force Area NFA Out of Force   52.4504261 -1.842549
13006 op-snap---monthly-publication-july-2025.pdf   1058 2025-07 Car Yamaha 125 cc Blue Driving without Due Care and Attention None B4112 B4112 Out of Force Area Out of Force Area NFA Out of Force   52.3994858 -1.4923603
13037 op-snap---monthly-publication-july-2025.pdf   1089 2025-07 Car Audi A5 Blue Driving without Due Care and Attention None Grantham Road, Lincoln Grantham Road, Lincoln Out of Force Area Out of Force Area NFA Out of Force      
13086 op-snap---monthly-publication-july-2025.pdf   1138 2025-07 Car BMW M135 Green Driving without Due Care and Attention None Off Force Off Force Out of Force Area Out of Force Area NFA Out of Force      
13102 op-snap---monthly-publication-july-2025.pdf   1154 2025-07 Car Ford Transit white Driving without Due Care and Attention None M6 j 5 M6 j 5 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.6760749 -2.0862582
13103 op-snap---monthly-publication-july-2025.pdf   1155 2025-07 Pedal Bike Land Rover Defender Green Driving without Due Care and Attention None Killhorse Lane (Ludlow) Killhorse Lane (Ludlow) Out of Force Area Out of Force Area NFA Out of Force      
13113 op-snap---monthly-publication-july-2025.pdf   1165 2025-07 Car Honda Kona Grey Driving without Due Care and Attention None Worksop Road Worksop Road Out of Force Area Out of Force Area NFA Out of Force      
13121 op-snap---monthly-publication-july-2025.pdf   1173 2025-07 Pedestrian Chevrolet Spark White Driving without Due Care and Attention None Malvern Malvern Out of Force Area Out of Force Area NFA Out of Force   52.4093693 -1.7713445
13163 op-snap---monthly-publication-july-2025.pdf   1215 2025-07 Car Volkswagen Scirocco Black 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
13193 op-snap---monthly-publication-july-2025.pdf   1245 2025-07 Car Mercedes-Benz Sprinte White Driving without Due Care and Attention None Cressage (Shropshire) Cressage (Shropshire) Out of Force Area Out of Force Area NFA Out of Force      
13204 op-snap---monthly-publication-july-2025.pdf   1256 2025-07 Car Volkswagen T Cross White Driving without Due Care and Attention None A45 (Rugby) A45 (Rugby) Out of Force Area Out of Force Area NFA Out of Force   52.3762151 -1.4625313
13210 op-snap---monthly-publication-july-2025.pdf   1262 2025-07 Car Volkswagen Golf Black Driving without Due Care and Attention None HIgh Street Hillmorton HIgh Street Hillmorton Out of Force Area Out of Force Area NFA Out of Force      
13213 op-snap---monthly-publication-july-2025.pdf   1265 2025-07 Car Land Rover Evoque Gold Driving without Due Care and Attention None M5 Bromsgrove M5 Bromsgrove Out of Force Area Out of Force Area NFA Out of Force   52.432364 -2.0176127
13252 op-snap---monthly-publication-july-2025.pdf   1304 2025-07 Car Ford Focus Blue Driving without Due Care and Attention None M5 Jn4A to Jn3 M5 Jn4A to Jn3 Out of Force Area Out of Force Area NFA Out of Force      
13382 op-snap---monthly-publication-july-2025.pdf   1434 2025-07 Car Volkswagen caddy White Driving without Due Care and Attention None worcester road Worcester Road Out of Force Area Out of Force Area Warning Letter N/A   52.5860898 -2.0339138
13610 op-snap---monthly-publication-july-2025.pdf   1662 2025-07 Car Mercedes-Benz A class Silver Driving without Due Care and Attention None M40 M40 Out of Force Area Out of Force Area Warning Letter N/A      
13919 op-snap---monthly-publication-july-2025.pdf   1971 2025-07 Car Iveco Daily White Driving without Due Care and Attention None M1 South M1 South Out of Force Area Out of Force Area NFA Out of Force   52.4031308 -2.0142003
13939 op-snap---monthly-publication-july-2025.pdf   1991 2025-07 Car Ford Ranger Green Driving without Due Care and Attention None Oxford Oxford Out of Force Area Out of Force Area NFA Out of Force      
13940 op-snap---monthly-publication-july-2025.pdf   1992 2025-07 Car Lexus RX400 Black Driving without Due Care and Attention None Oxford Oxford Out of Force Area Out of Force Area NFA Out of Force      
13941 op-snap---monthly-publication-july-2025.pdf   1993 2025-07 Car Audi A6 Grey Driving without Due Care and Attention None Oxford Oxford Out of Force Area Out of Force Area NFA Out of Force      
13942 op-snap---monthly-publication-july-2025.pdf   1994 2025-07 Car Volkswagen Polo Black Driving without Due Care and Attention None Oxford Oxford Out of Force Area Out of Force Area NFA Out of Force      
13943 op-snap---monthly-publication-july-2025.pdf   1995 2025-07 Car Mercedes-Benz GLC Black Driving without Due Care and Attention None Oxford Oxford Out of Force Area Out of Force Area NFA Out of Force      
13966 op-snap---monthly-publication-july-2025.pdf   2018 2025-07 Car Peugeot Partner White Driving without Due Care and Attention None Worcester Road, Stourport Worcester Road, Stourport Out of Force Area Out of Force Area NFA No VRM      
13979 op-snap---monthly-publication-july-2025.pdf   2031 2025-07 Car Volkswagen Golf White Driving without Due Care and Attention None Out of force Out of force Out of Force Area Out of Force Area NFA Out of Force      
13982 op-snap---monthly-publication-july-2025.pdf   2034 2025-07 Car Land Rover range rover White Driving without Due Care and Attention None M62 M62 Out of Force Area Out of Force Area NFA Out of Force      
13999 op-snap---monthly-publication-july-2025.pdf   2051 2025-07 Car BMW 3 series Silver Driving without Due Care and Attention None M6 Manchester out of force area M6 Manchester out of force area Out of Force Area Out of Force Area Warning Letter N/A      
14006 op-snap---monthly-publication-july-2025.pdf   2058 2025-07 Car Mini One Blue Driving without Due Care and Attention None Longden Road Longden Road Out of Force Area Out of Force Area NFA Out of Force      
14011 op-snap---monthly-publication-july-2025.pdf   2063 2025-07 Car Ford Mondeo Black Driving without Due Care and Attention None M6 junction2 M6 junction2 Out of Force Area Out of Force Area NFA No Offence   52.676119 -2.0858425

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