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

139 rows where council_area = "Out of Force Area", disposal = "NFA" and offence = "Driving without Reasonable Consideration" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale, latitude, longitude

reporter_transport_mode 7

offence 1

  • Driving without Reasonable Consideration · 139 ✖

disposal 1

  • NFA · 139 ✖

council_area 1

  • Out of Force Area · 139 ✖
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
7397 op-snap---monthly-publication-february-2026.pdf   144 2026-02 Car Kia Stonic Red Driving without Reasonable Consideration None Telford Town Centre Telford Town Centre Out of Force Area Out of Force Area NFA Out of Force      
8763 op-snap---monthly-publication-february-2026.pdf   1510 2026-02 Car Tesla model 3 Grey Driving without Reasonable Consideration None Jn3 M42, West Mercia Jn3 M42, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
11515 op-snap---monthly-publication-january-2026.pdf   976 2026-01 Lorry Volkswagen Tiguan Grey Driving without Reasonable Consideration None M1 J24 - Leicester M1 J24 - Leicester 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      
22065 op-snap---monthly-publication-october-2025.pdf   15 2025-10 Pedal Bike Audi   Black Driving without Reasonable Consideration None Castle Road Castle Road Out of Force Area Out of Force Area NFA Out of Force   52.4358056 -1.9593904
22795 op-snap---monthly-publication-october-2025.pdf   745 2025-10 Motorbike Audi S4 Blue Driving without Reasonable Consideration None Astwood Bank Astwood Bank Out of Force Area Out of Force Area NFA Out of Force      
22985 op-snap---monthly-publication-october-2025.pdf   935 2025-10 Horse Rider BMW 225xe Blue Driving without Reasonable Consideration None Withybrook Road, Bedworth Withybrook Road, Bedworth Out of Force Area Out of Force Area NFA Out of Force      
23321 op-snap---monthly-publication-october-2025.pdf   1271 2025-10 Car Daf Tipper White Driving without Reasonable Consideration None Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
23790 op-snap---monthly-publication-september-2025.pdf   9 2025-09 Car Volkswagen Crafter Grey Driving without Reasonable Consideration None St Peters Driv, Worcester Street Peters Driv, Worcester Out of Force Area Out of Force Area NFA Out of Force      
23865 op-snap---monthly-publication-september-2025.pdf   84 2025-09 Car Audi A3 Black Driving without Reasonable Consideration None M6 J12 M6 J12 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
24075 op-snap---monthly-publication-september-2025.pdf   294 2025-09 Car Land Rover Range Black Driving without Reasonable Consideration None Hereford Ring Road Hereford Ring Road Out of Force Area Out of Force Area NFA Out of Force      
24203 op-snap---monthly-publication-september-2025.pdf   422 2025-09 Car Peugeot 208 Grey Driving without Reasonable Consideration None M1 J21 - Leicester M1 J21 - Leicester Out of Force Area Out of Force Area NFA Out of Force      
24289 op-snap---monthly-publication-september-2025.pdf   508 2025-09 Pedal Bike Volvo V40 Blue Driving without Reasonable Consideration None Henwick Road Henwick Road Out of Force Area Out of Force Area NFA Out of Force      
24509 op-snap---monthly-publication-september-2025.pdf   728 2025-09 Car Daf Trucks White Driving without Reasonable Consideration None M42 J9 M42 J9 Out of Force Area Out of Force Area NFA Out of Force   52.3601724 -1.8062199
24578 op-snap---monthly-publication-september-2025.pdf   797 2025-09 Pedal Bike Peugeot 308 Silver Driving without Reasonable Consideration None Marston Lane Marston Lane Out of Force Area Out of Force Area NFA Out of Force   52.4670062 -1.7548427
2199 op-snap---monthly-publication-august-2025.pdf   174 2025-08 Lorry Renault   Silver Driving without Reasonable Consideration None Gloucester Road Gloucester Road Out of Force Are Out of Force Area NFA Out of Force      
2311 op-snap---monthly-publication-august-2025.pdf   286 2025-08 Pedal Bike   Bus Blue Driving without Reasonable Consideration None Church Hill Way, Redditch Church Hill Way, Redditch Out of Force Are Out of Force Area NFA Out of Force      
2364 op-snap---monthly-publication-august-2025.pdf   339 2025-08 Other Fiat Fiorino White Driving without Reasonable Consideration None Northwood (Shrewsbury) Northwood (Shrewsbury) 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      
2576 op-snap---monthly-publication-august-2025.pdf   551 2025-08 Pedal Bike Suzuki   Yellow Driving without Reasonable Consideration None Llley Lane Llley Lane 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      
3196 op-snap---monthly-publication-august-2025.pdf   1171 2025-08 Car Vauxhall Adam Red Driving without Reasonable Consideration None M42 Jn 10, Warwickshire M42 Junction 10, Warwickshire Out of Force Are Out of Force Area NFA Out of Force      
12062 op-snap---monthly-publication-july-2025.pdf   114 2025-07 Car Byd Seal Blue Driving without Reasonable Consideration None Kenilworth Road Kenilworth Road Out of Force Area Out of Force Area NFA Out of Force   52.5124557 -1.8917609
12065 op-snap---monthly-publication-july-2025.pdf   117 2025-07 Car BMW 330E Grey Driving without Reasonable Consideration None M42 Junction 3 West Mercia M42 Junction 3 West Mercia Out of Force Area Out of Force Area NFA Out of Force   52.4846642 -1.9297585
12567 op-snap---monthly-publication-july-2025.pdf   619 2025-07 Pedal Bike Honda Jazz Green Driving without Reasonable Consideration None Saltway Saltway Out of Force Area Out of Force Area NFA Out of Force      
12688 op-snap---monthly-publication-july-2025.pdf   740 2025-07 Car BMW 118 Black Driving without Reasonable Consideration None A514 Bedford Bedford Out of Force Area Out of Force Area NFA Out of Force      
12752 op-snap---monthly-publication-july-2025.pdf   804 2025-07 Car Ford Focus Grey Driving without Reasonable Consideration None Coventry Street, Kidderminster Coventry Street, Kidderminster Out of Force Area Out of Force Area NFA Out of Force      
12887 op-snap---monthly-publication-july-2025.pdf   939 2025-07 Car Audi A5 Red Driving without Reasonable Consideration None M40 Southbound M40 Southbound Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
12888 op-snap---monthly-publication-july-2025.pdf   940 2025-07 Car Scania   White Driving without Reasonable Consideration None M6 Northbound M6 Northbound Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4316701 -2.0178238
12898 op-snap---monthly-publication-july-2025.pdf   950 2025-07 Car Mercedes-Benz sprinter Orange Driving without Reasonable Consideration None Caynton Road Caynton Road Out of Force Area Out of Force Area NFA Out of Force      
12905 op-snap---monthly-publication-july-2025.pdf   957 2025-07 Car   Contera MDI Red Driving without Reasonable Consideration None A46 Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force   52.3837388 -1.5529669
12950 op-snap---monthly-publication-july-2025.pdf   1002 2025-07 Other Volkswagen Bora Black Driving without Reasonable Consideration None M54 M54 Out of Force Area Out of Force Area NFA Out of Force      
12954 op-snap---monthly-publication-july-2025.pdf   1006 2025-07 Car BMW   White Driving without Reasonable Consideration None Birmingham Road , Stratford Birmingham Road , Stratford Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4496153 -1.8646204
12979 op-snap---monthly-publication-july-2025.pdf   1031 2025-07 Car BMW x1 Black Driving without Reasonable Consideration None M6 J13 M6 J13 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
12995 op-snap---monthly-publication-july-2025.pdf   1047 2025-07 Car Ford Focus Blue Driving without Reasonable Consideration None Bridge Street , Worcester Bridge Street , Worcester Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
13045 op-snap---monthly-publication-july-2025.pdf   1097 2025-07 Car Land Rover Evoque White Driving without Reasonable Consideration None Unknown - Country Lane, Coleshill Unknown - Country Lane, Coleshill Out of Force Area Out of Force Area NFA Out of Force      
13095 op-snap---monthly-publication-july-2025.pdf   1147 2025-07 Pedestrian Nissan   Black Driving without Reasonable Consideration None The Parade , Boldmere The Parade , Boldmere Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
13098 op-snap---monthly-publication-july-2025.pdf   1150 2025-07 Car Volkswagen   Black Driving without Reasonable Consideration None Park way Ruberey Park way Ruberey Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
14078 op-snap---monthly-publication-june-2025.pdf   7 2025-06 Car Renault Van Blue Driving without Reasonable Consideration None M5 M5 Out of Force Area Out of Force Area NFA Out of Force      
14249 op-snap---monthly-publication-june-2025.pdf   178 2025-06 Car BMW 1 series White Driving without Reasonable Consideration None Leamington Spa Leamington Spa Out of Force Area Out of Force Area NFA Out of Force      
14298 op-snap---monthly-publication-june-2025.pdf   227 2025-06 Car Daf HGV White Driving without Reasonable Consideration None Newport Road Newport Road Out of Force Area Out of Force Area NFA Out of Force   52.5024739 -1.7975977
14842 op-snap---monthly-publication-june-2025.pdf   771 2025-06 Car Seat   Blue Driving without Reasonable Consideration None Oxford Oxford Out of Force Area Out of Force Area NFA Out of Force      
15115 op-snap---monthly-publication-june-2025.pdf   1044 2025-06 Pedal Bike Renault Kangoo White Driving without Reasonable Consideration None Sutton Park Road Sutton Park Road Out of Force Area Out of Force Area NFA Out of Force   52.5298146 -1.7902196
15139 op-snap---monthly-publication-june-2025.pdf   1068 2025-06 Pedal Bike Kia Sorento Silver Driving without Reasonable Consideration None Henley In Arden (Wottoon Wawen) Henley In Arden (Wottoon Wawen) Out of Force Area Out of Force Area NFA Out of Force      
15200 op-snap---monthly-publication-june-2025.pdf   1129 2025-06 Pedal Bike Skoda Octavia White Driving without Reasonable Consideration None Myton Road Myton Road Out of Force Area Out of Force Area NFA Out of Force   52.4106096 -1.4829312
15479 op-snap---monthly-publication-june-2025.pdf   1408 2025-06 Motorbike Volkswagen Polo Silver Driving without Reasonable Consideration None Commandery Road, Worcester Commandery Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
18849 op-snap---monthly-publication-may-2025.pdf   211 2025-05 Pedal Bike   Scancia Red Driving without Reasonable Consideration None Ventura Park Ventura Park Out of Force Area Out of Force Area NFA Out of Force      
18943 op-snap---monthly-publication-may-2025.pdf   305 2025-05 Car Suzuki XR 125 Silver Driving without Reasonable Consideration None A444 off M6 Jn3 A444 off M6 Jn3 Out of Force Area Out of Force Area NFA Out of Force      
19176 op-snap---monthly-publication-may-2025.pdf   538 2025-05 Car Alfa Romeo . Red Driving without Reasonable Consideration None Bognop road Bognop road Out of Force Area Out of Force Area NFA Out of Force      
19477 op-snap---monthly-publication-may-2025.pdf   839 2025-05 Car Ford Fiesta Black Driving without Reasonable Consideration None M6 SB jn2 M6 Southbound jn2 Out of Force Area Out of Force Area NFA Out of Force      
19524 op-snap---monthly-publication-may-2025.pdf   886 2025-05 Pedal Bike Mercedes-Benz CLA 220 Grey Driving without Reasonable Consideration None A458 Bridgnorth Bridgnorth Out of Force Area Out of Force Area NFA Out of Force      
19639 op-snap---monthly-publication-may-2025.pdf   1001 2025-05 Car Dacia Duster Blue Driving without Reasonable Consideration None Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
20012 op-snap---monthly-publication-may-2025.pdf   1374 2025-05 Car Vauxhall NP White Driving without Reasonable Consideration None A456 towards Kidderminster A456 towards Kidderminster Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
20013 op-snap---monthly-publication-may-2025.pdf   1375 2025-05 Car Skoda NP Blue Driving without Reasonable Consideration None Innage Lane , Brignorth Innage Lane , Brignorth Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
20014 op-snap---monthly-publication-may-2025.pdf   1376 2025-05 Car Ford NP Blue Driving without Reasonable Consideration None A454 towards Bridgnorth A454 towards Bridgnorth Out of Force Area Out of Force Area NFA Out of Force      
30 op-snap---monthly-publication-april-2025.pdf   29 2025-04 Pedal Bike Iveco DAILY White Driving without Reasonable Consideration None LYNN LANE,SHENSTONE Lynn Lane, Shenstone Out of Force Area Out of Force Area NFA Out of Force      
86 op-snap---monthly-publication-april-2025.pdf   85 2025-04 Pedal Bike Land Rover Evoque Silver Driving without Reasonable Consideration None Off force Off force Out of Force Area Out of Force Area NFA Out of Force      
116 op-snap---monthly-publication-april-2025.pdf   115 2025-04 Car Volvo Coach White Driving without Reasonable Consideration None A438 Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force   52.4047807 -2.0101216
599 op-snap---monthly-publication-april-2025.pdf   598 2025-04 Car Ford Mondeo Blue Driving without Reasonable Consideration None A50 in Staffordshire A50 in Staffordshire Out of Force Area Out of Force Area NFA Out of Force      
602 op-snap---monthly-publication-april-2025.pdf   601 2025-04 Car Mini Cooper White Driving without Reasonable Consideration None M40 in Warwickshire M40 in Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
733 op-snap---monthly-publication-april-2025.pdf   732 2025-04 Pedal Bike Land Rover Defender Black Driving without Reasonable Consideration None A500 Staffs Staffs Out of Force Area Out of Force Area NFA Out of Force      
882 op-snap---monthly-publication-april-2025.pdf   881 2025-04 Car Volkswagen Golf Blue Driving without Reasonable Consideration None Leasingham bypass , Lincoln Leasingham bypass , Lincoln Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
898 op-snap---monthly-publication-april-2025.pdf   897 2025-04 Car Nissan Qashqai White Driving without Reasonable Consideration None Gleneagle's Avenue , Leicester Gleneagle's Avenue , Leicester Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
931 op-snap---monthly-publication-april-2025.pdf   930 2025-04 Car Vauxhall   Black Driving without Reasonable Consideration None Henley Road , B4089 Henley Road , B4089 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4343442 -1.4716402
944 op-snap---monthly-publication-april-2025.pdf   943 2025-04 Car Audi   Black Driving without Reasonable Consideration None B4176 Rabbit Run towards Bridgnorth Rabbit Run towards Bridgnorth Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
966 op-snap---monthly-publication-april-2025.pdf   965 2025-04 Car Ford Explorer White Driving without Reasonable Consideration None Lowerwick , Worcester Lowerwick , Worcester Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
979 op-snap---monthly-publication-april-2025.pdf   978 2025-04 Car   Off road bike Black Driving without Reasonable Consideration none West Hill Field , Bridlington West Hill Field , Bridlington Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1046 op-snap---monthly-publication-april-2025.pdf   1045 2025-04 Car Toyota Yaris Grey Driving without Reasonable Consideration None SOlitaire Avenue , WOrcester SOlitaire Avenue , WOrcester Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1108 op-snap---monthly-publication-april-2025.pdf   1107 2025-04 Car Ford   White Driving without Reasonable Consideration None Stoke Road , Bromsgrove Stoke Road , Bromsgrove Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1115 op-snap---monthly-publication-april-2025.pdf   1114 2025-04 Car Toyota Yaris White Driving without Reasonable Consideration None Mill Road , Rugby Mill Road , Rugby Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1116 op-snap---monthly-publication-april-2025.pdf   1115 2025-04 Car Toyota HILLUX Green Driving without Reasonable Consideration None A556 , WHitchurch A556 , WHitchurch Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.394829 -1.5774929
1117 op-snap---monthly-publication-april-2025.pdf   1116 2025-04 Car Vauxhall Corsa Black Driving without Reasonable Consideration None M6 North Bound close to Junction 10 M6 North Bound close to Junction 10 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1135 op-snap---monthly-publication-april-2025.pdf   1134 2025-04 Car Skoda   Blue Driving without Reasonable Consideration None Jinnah Road , Redditch Jinnah Road , Redditch Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1170 op-snap---monthly-publication-april-2025.pdf   1169 2025-04 Car Isuzu   Blue Driving without Reasonable Consideration None A41 towards Cosford A41 towards Cosford Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1201 op-snap---monthly-publication-april-2025.pdf   1200 2025-04 Car Ford   Grey Driving without Reasonable Consideration None Banbury Road towards Stratford upon Avon Banbury Road towards Stratford upon Avon Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1202 op-snap---monthly-publication-april-2025.pdf   1201 2025-04 Car Land Rover Discovery Blue Driving without Reasonable Consideration None Warwick Road , Stratford Warwick Road , Stratford Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1263 op-snap---monthly-publication-april-2025.pdf   1262 2025-04 Car Peugeot   Grey Driving without Reasonable Consideration None Trench Lock , Telford Trench Lock , Telford Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1275 op-snap---monthly-publication-april-2025.pdf   1274 2025-04 Pedal Bike Volkswagen Polo White Driving without Reasonable Consideration None     Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1279 op-snap---monthly-publication-april-2025.pdf   1278 2025-04 Car Ford Transit Van White Driving without Reasonable Consideration None Harrogate Road , Harrogate Harrogate Road , Harrogate Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1328 op-snap---monthly-publication-april-2025.pdf   1327 2025-04 Car   other   Driving without Reasonable Consideration None sugden lane Sugden Lane Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1335 op-snap---monthly-publication-april-2025.pdf   1334 2025-04 Car Suzuki Swift Grey Driving without Reasonable Consideration None M6 Southbound Junction 3 heading towards Junction 3A M6 Southbound Junction 3 heading towards Junction 3A Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1363 op-snap---monthly-publication-april-2025.pdf   1362 2025-04 Car Skoda   Blue Driving without Reasonable Consideration None A47 heading towardfs Bromford A47 heading towardfs Bromford Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1365 op-snap---monthly-publication-april-2025.pdf   1364 2025-04 Car BMW   White Driving without Reasonable Consideration None A47 heading towards Bromford A47 heading towards Bromford Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1366 op-snap---monthly-publication-april-2025.pdf   1365 2025-04 Car Honda Jazz Orange Driving without Reasonable Consideration None M42 M42 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1374 op-snap---monthly-publication-april-2025.pdf   1373 2025-04 Pedal Bike   Triumph TR6 Red Driving without Reasonable Consideration None Station Road , Dorridge Station Road , Dorridge Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.3807865 -1.7446497
1376 op-snap---monthly-publication-april-2025.pdf   1375 2025-04 Car Isuzu Pick Up Blue Driving without Reasonable Consideration None A49 , Shrewsbury A49 , Shrewsbury Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.6195535 -2.0193824
1410 op-snap---monthly-publication-april-2025.pdf   1409 2025-04 Car   NP Silver Driving without Reasonable Consideration None M6 South @ Junction 4a with M42 M6 South @ Junction 4a with M42 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1458 op-snap---monthly-publication-april-2025.pdf   1457 2025-04 Pedal Bike Volkswagen Polo Silver Driving without Reasonable Consideration None Redditch Road towards Redditch Redditch Road towards Redditch Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1460 op-snap---monthly-publication-april-2025.pdf   1459 2025-04 Car Ford Fiesta Blue Driving without Reasonable Consideration None Duggins Lane Duggins Lane Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.3964189 -1.5989088
1464 op-snap---monthly-publication-april-2025.pdf   1463 2025-04 Car Audi NP Black Driving without Reasonable Consideration None High Street , Albrighton High Street , Albrighton Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1468 op-snap---monthly-publication-april-2025.pdf   1467 2025-04 Car Toyota Voxy Black Driving without Reasonable Consideration None A462 High Street High Street Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4993921 -1.8955888
1471 op-snap---monthly-publication-april-2025.pdf   1470 2025-04 Car Audi NP Grey Driving without Reasonable Consideration None Kidderminster road A456 Kidderminster road A456 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4331313 -2.1702262
1491 op-snap---monthly-publication-april-2025.pdf   1490 2025-04 Car Audi A6 Grey Driving without Reasonable Consideration None A444 Stoke Stoke Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4211905 -1.4854094
1499 op-snap---monthly-publication-april-2025.pdf   1498 2025-04 Pedal Bike Nissan Qashqai White Driving without Reasonable Consideration None Newman Bridge , Worcestershire Newman Bridge , Worcestershire Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1529 op-snap---monthly-publication-april-2025.pdf   1528 2025-04 Car   NP Blue Driving without Reasonable Consideration None 6 Ways Worcestr 6 Ways Worcestr Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1552 op-snap---monthly-publication-april-2025.pdf   1551 2025-04 Pedal Bike Ford Kuga White Driving without Reasonable Consideration None Stoke Green Stoke Green Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4047116 -1.4813418
1577 op-snap---monthly-publication-april-2025.pdf   1576 2025-04 Car Skoda Kodiaq Black Driving without Reasonable Consideration None Birchfield Road , Redditch Birchfield Road , Redditch Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1579 op-snap---monthly-publication-april-2025.pdf   1578 2025-04 Car   HGV Red Driving without Reasonable Consideration None M42 South Junction 4 M42 South Junction 4 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1608 op-snap---monthly-publication-april-2025.pdf   1607 2025-04 Pedal Bike Renault Kadjar Silver Driving without Reasonable Consideration None A449 A449 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1613 op-snap---monthly-publication-april-2025.pdf   1612 2025-04 Pedal Bike Ford KUGA Grey Driving without Reasonable Consideration None Technolgy Drive , Rugby Technolgy Drive , Rugby Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      

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