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

147 rows where council_area = "Out of Force Area", month = "2025-08" 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 · 147 ✖

month 1

  • 2025-08 · 147 ✖

disposal 1

council_area 1

  • Out of Force Area · 147 ✖
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
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      
2101 op-snap---monthly-publication-august-2025.pdf   76 2025-08 Car Mercedes-Benz   Black Driving without Due Care and Attention None A425 Southam Southam Out of Force Are Out of Force Area NFA Out of Force      
2103 op-snap---monthly-publication-august-2025.pdf   78 2025-08 Car Ford Mondeo Blue Driving without Due Care and Attention None A5 Telford Telford Out of Force Are Out of Force Area NFA Out of Force   52.4979333 -1.9664857
2106 op-snap---monthly-publication-august-2025.pdf   81 2025-08 Car   Polestar Silver Driving without Due Care and Attention No Insurance A52 Bottesford Bottesford Out of Force Are Out of Force Area NFA Out of Force      
2114 op-snap---monthly-publication-august-2025.pdf   89 2025-08 Car Mercedes-Benz Sprinter Blue Using a Mobile Phone Whilst Driving None M6 Staffs M6 Staffs Out of Force Are Out of Force Area NFA Out of Force   52.6170728 -2.030393
2115 op-snap---monthly-publication-august-2025.pdf   90 2025-08 Car Peugeot   White Driving without Due Care and Attention None M42 M42 Out of Force Are Out of Force Area NFA Out of Force      
2125 op-snap---monthly-publication-august-2025.pdf   100 2025-08 Car Ford Fiesta Blue Driving without Due Care and Attention None Bromsgrove Road (Studley) Bromsgrove Road (Studley) Out of Force Are Out of Force Area NFA Out of Force      
2128 op-snap---monthly-publication-august-2025.pdf   103 2025-08 Car Ford Transit White Using a Mobile Phone Whilst Driving None A5 (Brownhills) A5 (Brownhills) Out of Force Are Out of Force Area NFA Out of Force      
2134 op-snap---monthly-publication-august-2025.pdf   109 2025-08 Car Dacia Stepway Grey Driving without Due Care and Attention None Daventry Road Daventry 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      
2160 op-snap---monthly-publication-august-2025.pdf   135 2025-08 Car Ford Transit Grey Driving without Due Care and Attention None Bromsgrove Bromsgrove Out of Force Are Out of Force Area NFA Out of Force   52.4728322 -1.897536
2188 op-snap---monthly-publication-august-2025.pdf   163 2025-08 Car Tesla   Grey Driving without Due Care and Attention None Newbold Road Newbold Road 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      
2209 op-snap---monthly-publication-august-2025.pdf   184 2025-08 Car   Saab Silver Driving without Due Care and Attention None Dunchurch Dunchurch Out of Force Are Out of Force Area NFA Out of Force      
2237 op-snap---monthly-publication-august-2025.pdf   212 2025-08 Car BMW 530.. White Driving without Due Care and Attention None Childs Way Milton Keynes Childs Way Milton Keynes Out of Force Are Out of Force Area NFA Out of Force      
2243 op-snap---monthly-publication-august-2025.pdf   218 2025-08 Car Land Rover Land Rover Grey Driving without Due Care and Attention None M40 M40 Out of Force Are Out of Force Area NFA Out of Force      
2244 op-snap---monthly-publication-august-2025.pdf   219 2025-08 Car BMW X5 Black Driving without Due Care and Attention None M4/m42 M4/m42 Out of Force Are Out of Force Area NFA Out of Force      
2246 op-snap---monthly-publication-august-2025.pdf   221 2025-08 Car Hyundai   Grey Driving without Due Care and Attention None Redhill, Telford Redhill, Telford Out of Force Are Out of Force Area NFA Out of Force      
2248 op-snap---monthly-publication-august-2025.pdf   223 2025-08 Car Land Rover Discovery Black Driving without Due Care and Attention None M40 towards Jct 15 M40 towards Junction 15 Out of Force Are Out of Force Area NFA Out of Force      
2249 op-snap---monthly-publication-august-2025.pdf   224 2025-08 Car Ford Focus Grey Driving without Due Care and Attention None A452 A452 Out of Force Are Out of Force Area NFA Out of Force      
2258 op-snap---monthly-publication-august-2025.pdf   233 2025-08 Car       Misc - Non Traffic Offences None Manor way Manor way Out of Force Are Out of Force Area NFA Out of Force      
2259 op-snap---monthly-publication-august-2025.pdf   234 2025-08 Car Scania   White Driving without Due Care and Attention None M42 NB J9 M42 Northbound J9 Out of Force Are Out of Force Area NFA Out of Force      
2265 op-snap---monthly-publication-august-2025.pdf   240 2025-08 Car     Red Driving without Due Care and Attention None Haughton Haughton Out of Force Are Out of Force Area NFA Out of Force      
2281 op-snap---monthly-publication-august-2025.pdf   256 2025-08 Car Jaguar F-Pace Grey Using a Mobile Phone Whilst Driving None M5 Worcester M5 Worcester Out of Force Are Out of Force Area NFA Out of Force   52.5908671 -1.8140277
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
2297 op-snap---monthly-publication-august-2025.pdf   272 2025-08 Car Renault   White Driving without Due Care and Attention None M1 M1 Out of Force Are Out of Force Area NFA Out of Force      
2310 op-snap---monthly-publication-august-2025.pdf   285 2025-08 Car Ford Fiesta White Using a Mobile Phone Whilst Driving None M5 NB J7-6 M5 Northbound J7-6 Out of Force Are Out of Force Area NFA Out of Force      
2318 op-snap---monthly-publication-august-2025.pdf   293 2025-08 Car       Driving without Due Care and Attention None Long Lane, Worksop Long Lane, Worksop Out of Force Are Out of Force Area NFA Out of Force      
2328 op-snap---monthly-publication-august-2025.pdf   303 2025-08 Car Vauxhall Vivaro Black Driving without Due Care and Attention None Tamworth Tamworth Out of Force Are Out of Force Area NFA Out of Force   52.5724303 -1.8191247
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      
2362 op-snap---monthly-publication-august-2025.pdf   337 2025-08 Car Volvo V40.. Red Driving without Due Care and Attention None A46 Stratford Stratford Out of Force Are Out of Force Area NFA Out of Force      
2381 op-snap---monthly-publication-august-2025.pdf   356 2025-08 Car Ford Focus Blue Driving without Due Care and Attention None A36 Deptford Deptford Out of Force Are Out of Force Area NFA Out of Force      
2403 op-snap---monthly-publication-august-2025.pdf   378 2025-08 Car Ford Transit White Driving without Due Care and Attention None Offenham Road Evesham Offenham Road Evesham Out of Force Are Out of Force Area NFA Out of Force      
2405 op-snap---monthly-publication-august-2025.pdf   380 2025-08 Car Citroen Relay White Driving without Due Care and Attention None M42 M42 Out of Force Are Out of Force Area NFA Out of Force      
2419 op-snap---monthly-publication-august-2025.pdf   394 2025-08 Car   KAWASAKI Black Driving without Due Care and Attention None Worcester Worcester Out of Force Are Out of Force Area NFA Out of Force   52.3101165 -2.0442678
2420 op-snap---monthly-publication-august-2025.pdf   395 2025-08 Car Land Rover Discovery Red Driving without Due Care and Attention None Derby Derby Out of Force Are Out of Force Area NFA Out of Force      
2434 op-snap---monthly-publication-august-2025.pdf   409 2025-08 Car Land Rover SDV6 White Driving without Due Care and Attention None Burnage Lane, Stockport Burnage Lane, Stockport Out of Force Are Out of Force Area NFA Out of Force      
2436 op-snap---monthly-publication-august-2025.pdf   411 2025-08 Car Audi A5 White Driving without Due Care and Attention None A52 Nottingham Nottingham Out of Force Are Out of Force Area NFA Out of Force      
2462 op-snap---monthly-publication-august-2025.pdf   437 2025-08 Car BMW 116I Grey Using a Mobile Phone Whilst Driving None M62 Mnachester M62 Mnachester Out of Force Are Out of Force Area NFA Out of Force      
2475 op-snap---monthly-publication-august-2025.pdf   450 2025-08 Car Audi A3 Black Driving without Due Care and Attention None M45 M45 Out of Force Are Out of Force Area NFA Out of Force      
2482 op-snap---monthly-publication-august-2025.pdf   457 2025-08 Car BMW 335d Blue Driving without Due Care and Attention None Sheepwash Road Sheepwash Road Out of Force Are Out of Force Area NFA Out of Force      
2496 op-snap---monthly-publication-august-2025.pdf   471 2025-08 Car BMW 535D Grey Driving without Due Care and Attention None M6 M6 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      
2512 op-snap---monthly-publication-august-2025.pdf   487 2025-08 Car Hyundai Ionic Silver Driving without Due Care and Attention None M6 (near to Keele Services) M6 (near to Keele Services) Out of Force Are Out of Force Area NFA Out of Force      
2519 op-snap---monthly-publication-august-2025.pdf   494 2025-08 Car Audi A3.. Blue Using a Mobile Phone Whilst Driving None Somewhere on the M6. Somewhere on the M6 Out of Force Are Out of Force Area NFA Out of Force      
2522 op-snap---monthly-publication-august-2025.pdf   497 2025-08 Car BMW 520D Silver Using a Mobile Phone Whilst Driving None A444 (West Mercia) A444 (West Mercia) Out of Force Are Out of Force Area NFA Out of Force      
2550 op-snap---monthly-publication-august-2025.pdf   525 2025-08 Car Audi A1 Grey Driving without Reasonable Consideration None Woodgreen Drive (Worcester) Woodgreen Drive (Worcester) 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      
2568 op-snap---monthly-publication-august-2025.pdf   543 2025-08 Car Vauxhall Van White Driving without Due Care and Attention None M69, near Coventry M69, near Coventry 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      
2602 op-snap---monthly-publication-august-2025.pdf   577 2025-08 Car Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None M1 M1 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      
2618 op-snap---monthly-publication-august-2025.pdf   593 2025-08 Car Tesla   White Driving without Due Care and Attention None A46 A46 Out of Force Are Out of Force Area NFA Out of Force      
2629 op-snap---monthly-publication-august-2025.pdf   604 2025-08 Car BMW 320.. White Driving without Due Care and Attention None Castle Farm Way Priorslee Castle Farm Way Priorslee Out of Force Are Out of Force Area NFA Out of Force      
2635 op-snap---monthly-publication-august-2025.pdf   610 2025-08 Car Ford Focus ST White Driving without Due Care and Attention None Water Orton Bridge Water Orton Bridge Out of Force Are Out of Force Area NFA Out of Force      
2636 op-snap---monthly-publication-august-2025.pdf   611 2025-08 Car Audi A3 Black Driving without Due Care and Attention None M54 J1-2 EB M54 J1-2 Eb Out of Force Are Out of Force Area NFA Out of Force      
2644 op-snap---monthly-publication-august-2025.pdf   619 2025-08 Car Toyota Rav4 Grey Driving without Due Care and Attention None Malvern Malvern Out of Force Are Out of Force Area NFA Out of Force   52.4093693 -1.7713445
2649 op-snap---monthly-publication-august-2025.pdf   624 2025-08 Car Fiat Ducato White Driving without Due Care and Attention None A40 Monmouth Monmouth Out of Force Are Out of Force Area NFA Out of Force      
2651 op-snap---monthly-publication-august-2025.pdf   626 2025-08 Car Mercedes-Benz CLA200 Grey Driving without Due Care and Attention None Bilton Road (Rugby) Bilton Road (Rugby) Out of Force Are Out of Force Area NFA Out of Force      
2652 op-snap---monthly-publication-august-2025.pdf   627 2025-08 Car Ford   White Driving without Due Care and Attention None Littleworth Road Littleworth Road Out of Force Are Out of Force Area NFA Out of Force      
2663 op-snap---monthly-publication-august-2025.pdf   638 2025-08 Car Iveco Daily White Driving without Due Care and Attention None M40.. M40 Out of Force Are Out of Force Area NFA Out of Force      
2665 op-snap---monthly-publication-august-2025.pdf   640 2025-08 Car Citroen Berlingo White Driving without Due Care and Attention None Hartle Lane Hartle Lane Out of Force Are Out of Force Area NFA Out of Force      
2673 op-snap---monthly-publication-august-2025.pdf   648 2025-08 Car Audi S4 Blue Driving without Due Care and Attention None M6 junction 3 Warwickshire M6 junction 3 Warwickshire 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
2711 op-snap---monthly-publication-august-2025.pdf   686 2025-08 Car Skoda Octivia Black Driving without Due Care and Attention None Towcester Road Towcester Road Out of Force Are Out of Force Area NFA Out of Force      
2716 op-snap---monthly-publication-august-2025.pdf   691 2025-08 Car       Drive on hard shoulder None M62 Widnes M62 Widnes Out of Force Are Out of Force Area NFA Out of Force      
2729 op-snap---monthly-publication-august-2025.pdf   704 2025-08 Car Hyundai Ionic Blue Driving without Due Care and Attention None A45 Northampton Northampton Out of Force Are Out of Force Area NFA Out of Force      
2744 op-snap---monthly-publication-august-2025.pdf   719 2025-08 Car Mercedes-Benz A180.. Grey Driving without Due Care and Attention None M1 North towards jct 29. (Derbyshire) M1 North towards jct 29. (Derbyshire) Out of Force Are Out of Force Area NFA Out of Force      
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      
2748 op-snap---monthly-publication-august-2025.pdf   723 2025-08 Car   Aprillia Grey Driving without Due Care and Attention None A423 (Warwickshire) A423 (Warwickshire) Out of Force Are Out of Force Area NFA Out of Force      
2751 op-snap---monthly-publication-august-2025.pdf   726 2025-08 Car Daf Trucks Red Prohibited vehicle in offside lane of motorway None M5 Bridgewater M5 Bridgewater Out of Force Are Out of Force Area NFA Out of Force      
2752 op-snap---monthly-publication-august-2025.pdf   727 2025-08 Car Vauxhall Mokka White Driving without Due Care and Attention None A442 Telford Telford Out of Force Are Out of Force Area NFA Out of Force   52.4979333 -1.9664857
2758 op-snap---monthly-publication-august-2025.pdf   733 2025-08 Car Toyota Avensis White Driving without Due Care and Attention None A50 (Nottingham) A50 (Nottingham) 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      
2761 op-snap---monthly-publication-august-2025.pdf   736 2025-08 Car BMW 4 Series Green Driving without Due Care and Attention None A528 A528 Out of Force Are Out of Force Area NFA Out of Force      
2762 op-snap---monthly-publication-august-2025.pdf   737 2025-08 Car BMW N/K Black Driving without Due Care and Attention None M6 South Jct 19 M6 South Junction 19 Out of Force Are Out of Force Area NFA Out of Force      
2767 op-snap---monthly-publication-august-2025.pdf   742 2025-08 Car Mini One Black Driving without Due Care and Attention None Out of Force (Stoke) Out of Force (Stoke) Out of Force Are Out of Force Area NFA Out of Force      
2772 op-snap---monthly-publication-august-2025.pdf   747 2025-08 Car BMW X5 Grey Driving without Due Care and Attention None Shrewsbury Shrewsbury Out of Force Are Out of Force Area NFA Out of Force   52.6195535 -2.0193824
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      
2792 op-snap---monthly-publication-august-2025.pdf   767 2025-08 Car Honda Jazz Silver Driving without Due Care and Attention None M54 Shifnal M54 Shifnal Out of Force Are Out of Force Area NFA Out of Force      
2800 op-snap---monthly-publication-august-2025.pdf   775 2025-08 Car Ford Transit Black Driving without Due Care and Attention None A5 A5 Out of Force Are Out of Force Area NFA Out of Force      
2802 op-snap---monthly-publication-august-2025.pdf   777 2025-08 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Warwick Street (Leamington Spa) Warwick Street (Leamington Spa) Out of Force Are Out of Force Area NFA Out of Force      
2804 op-snap---monthly-publication-august-2025.pdf   779 2025-08 Car Ford Focus White Driving without Due Care and Attention None Bourne Road Bourne Road Out of Force Are Out of Force Area NFA Out of Force      
2827 op-snap---monthly-publication-august-2025.pdf   802 2025-08 Car Renault   White Driving without Reasonable Consideration None A447 Ashby Road Ashby Road Out of Force Are Out of Force Area NFA Out of Force      
2830 op-snap---monthly-publication-august-2025.pdf   805 2025-08 Car Seat Cupra Grey Driving without Due Care and Attention None M42 SN Jn3 M42 SN Jn3 Out of Force Are Out of Force Area NFA Out of Force      
2838 op-snap---monthly-publication-august-2025.pdf   813 2025-08 Car Toyota Verso Grey Driving without Due Care and Attention None Sandy Lane Church Brampton (Northampton) Sandy Lane Church Brampton (Northampton) Out of Force Are Out of Force Area NFA Out of Force      
2851 op-snap---monthly-publication-august-2025.pdf   826 2025-08 Car   Ferrri Red Driving without Due Care and Attention None A4104 Pershire Pershire Out of Force Are Out of Force Area NFA Out of Force      
2856 op-snap---monthly-publication-august-2025.pdf   831 2025-08 Car Ford Fiesta Blue Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Charles Street Sheffield Charles Street Sheffield Out of Force Are Out of Force Area NFA Out of Force      
2866 op-snap---monthly-publication-august-2025.pdf   841 2025-08 Car Honda Civic Black Using a Mobile Phone Whilst Driving None Jct 1 on the M1. Junction 1 on the M1 Out of Force Are Out of Force Area NFA Out of Force      
2892 op-snap---monthly-publication-august-2025.pdf   867 2025-08 Car Lamborghini Ferrari F355 Red Using a Mobile Phone Whilst Driving None B4211 Upton Upon Severn Upton Upon Severn Out of Force Are Out of Force Area NFA Out of Force      
2896 op-snap---monthly-publication-august-2025.pdf   871 2025-08 Car Renault Clio Silver Driving without Due Care and Attention None A451 Kidderminster Kidderminster Out of Force Are Out of Force Area NFA Out of Force   52.4331313 -2.1702262
2898 op-snap---monthly-publication-august-2025.pdf   873 2025-08 Car Volkswagen Polo White Using a Mobile Phone Whilst Driving None A14.... A14 Out of Force Are Out of Force Area NFA Out of Force      
2900 op-snap---monthly-publication-august-2025.pdf   875 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None A454 Shipley Shipley Out of Force Are Out of Force Area NFA Out of Force      
2902 op-snap---monthly-publication-august-2025.pdf   877 2025-08 Car BMW   White Driving without Due Care and Attention None M40 J13 M40 J13 Out of Force Are Out of Force Area NFA Out of Force      
2903 op-snap---monthly-publication-august-2025.pdf   878 2025-08 Car Audi A4 White Driving without Due Care and Attention None Station Road, Badsey Station Road, Badsey Out of Force Are Out of Force Area NFA Out of Force      
2910 op-snap---monthly-publication-august-2025.pdf   885 2025-08 Car Volkswagen Passat Red Use a vehicle / cycle on a road and contravene a local traffic order other than parking None A41 Newport Newport Out of Force Are Out of Force Area NFA Out of Force   52.5027779 -1.7982159
2911 op-snap---monthly-publication-august-2025.pdf   886 2025-08 Car Vauxhall Vivaro Silver Driving without Due Care and Attention None Hednesford Road Hednesford Road 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);