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

131 rows where council_area = "Out of Force Area", disposal = "NFA" and month = "2025-11" 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 6

month 1

  • 2025-11 · 131 ✖

disposal 1

  • NFA · 131 ✖

council_area 1

  • Out of Force Area · 131 ✖
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      
20520 op-snap---monthly-publication-november-2025.pdf   62 2025-11 Pedal Bike Jaguar XF Black Driving without Due Care and Attention No Insurance Stretton Sugwas (Hereford) Stretton Sugwas (Hereford) 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      
20724 op-snap---monthly-publication-november-2025.pdf   266 2025-11 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Blackhalve Lane Blackhalve Lane Out of Force Area Out of Force Area NFA Out of Force   52.6139368 -2.0960778
20725 op-snap---monthly-publication-november-2025.pdf   267 2025-11 Pedal Bike Dacia Sandero Blue Driving without Due Care and Attention None Teddesley Road (Staffs) Teddesley Road (Staffs) 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      
20742 op-snap---monthly-publication-november-2025.pdf   284 2025-11 Pedal Bike Peugeot 208 Red Using a Mobile Phone Whilst Driving None Hebburn Hebburn 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      
20788 op-snap---monthly-publication-november-2025.pdf   330 2025-11 Pedestrian Ford Transit White Driving without Due Care and Attention None School Bank School Bank Out of Force Area Out of Force Area NFA Out of Force   52.5149378 -2.1130096
20793 op-snap---monthly-publication-november-2025.pdf   335 2025-11 Motorbike     Red Contravening a Red Traffic Light None Weedon Road, Northampton Weedon Road, Northampton 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
20829 op-snap---monthly-publication-november-2025.pdf   371 2025-11 Pedestrian       Misc - Non Traffic Offences None Leicester Leicester Out of Force Area Out of Force Area NFA Out of Force   52.4145125 -1.5097639
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      
20840 op-snap---monthly-publication-november-2025.pdf   382 2025-11 Other       Misc - Non Traffic Offences None np Np Out of Force Area Out of Force Area NFA Misc Inc Crimes      
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      
20943 op-snap---monthly-publication-november-2025.pdf   485 2025-11 Pedestrian Ford Fiesta Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Malvern Malvern Out of Force Area Out of Force Area NFA Out of Force   52.4093693 -1.7713445
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      
20968 op-snap---monthly-publication-november-2025.pdf   510 2025-11 Pedal Bike Mini One 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      
20993 op-snap---monthly-publication-november-2025.pdf   535 2025-11 Pedestrian Ford fiesta Blue Misc - Non Traffic Offences None out of force Out Of Force 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      
21053 op-snap---monthly-publication-november-2025.pdf   595 2025-11 Lorry   Subara Blue Using a Mobile Phone Whilst Driving None NJTP South, New Jersey, New York, USA NJTP South, New Jersey, New York, USA 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      
21208 op-snap---monthly-publication-november-2025.pdf   750 2025-11 Pedestrian BMW 1 Series Grey Misc - Non Traffic Offences None Ramsden Avenue Ramsden Avenue Out of Force Area Out of Force Area NFA Out of Force      
21210 op-snap---monthly-publication-november-2025.pdf   752 2025-11 Pedestrian Kia Stonic Yellow Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stourport Road Stourport Road 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
21291 op-snap---monthly-publication-november-2025.pdf   833 2025-11 Pedestrian Volkswagen golf Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
21316 op-snap---monthly-publication-november-2025.pdf   858 2025-11 Motorbike Hyundai   Black Using a Mobile Phone Whilst Driving None Queensway Island Queensway Island Out of Force Area Out of Force Area NFA Out of Force      
21352 op-snap---monthly-publication-november-2025.pdf   894 2025-11 Pedestrian Skoda Octavia Red Misc - Non Traffic Offences None Bidford On Avon Bidford On Avon Out of Force Area Out of Force Area NFA No Offence      
21364 op-snap---monthly-publication-november-2025.pdf   906 2025-11 Other Ford Transit Silver Using a Mobile Phone Whilst Driving None Beaconside Stafford Beaconside Stafford Out of Force Area Out of Force Area NFA Out of Force      
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      
21448 op-snap---monthly-publication-november-2025.pdf   990 2025-11 Pedestrian Kia ceed Grey Cause vehicle to be left in a dangerous position None somer park avenue Somer Park Avenue Out of Force Area Out of Force Area NFA Misc Inc Crimes      
21465 op-snap---monthly-publication-november-2025.pdf   1007 2025-11 Pedestrian Daf   White Use a motor vehicle / trailer in a condition likely to cause danger of injury None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
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
21523 op-snap---monthly-publication-november-2025.pdf   1065 2025-11 Lorry Ferrari Masarati Ghibli black Drive on hard shoulder None M6 Southbound Jn4 M6 Southbound Jn4 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      
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      
21559 op-snap---monthly-publication-november-2025.pdf   1101 2025-11 Pedestrian Land Rover Range Rover Black Driving without Due Care and Attention None Leominster bypass A49 Leominster bypass A49 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      

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