home / opsnap

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

96 rows where council_area = "Out of Force Area", offence = "Driving without Reasonable Consideration" and reporter_transport_mode = "Car" 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

vehicle_make 27

  • Ford 13
  • Audi 9
  • BMW 9
  • Toyota 5
  • Volkswagen 5
  • Daf 4
  • Land Rover 4
  • Skoda 4
  • Vauxhall 4
  • Nissan 3
  • Peugeot 3
  • Dacia 2
  • Honda 2
  • Isuzu 2
  • Kia 2
  • Mercedes-Benz 2
  • Renault 2
  • Seat 2
  • Suzuki 2
  • Volvo 2
  • Alfa Romeo 1
  • Byd 1
  • Hyundai 1
  • Jaguar 1
  • Mini 1
  • Scania 1
  • Tesla 1

month 12

  • 2025-04 47
  • 2025-07 13
  • 2025-03 10
  • 2025-05 7
  • 2025-09 5
  • 2025-06 4
  • 2025-08 3
  • 2025-01 2
  • 2026-02 2
  • 2025-02 1
  • 2025-10 1
  • 2025-11 1

reporter_transport_mode 1

  • Car · 96 ✖

offence 1

  • Driving without Reasonable Consideration · 96 ✖

disposal 1

  • NFA 96

council_area 1

  • Out of Force Area · 96 ✖
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      
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      
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      
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
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      
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
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
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      
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      
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      
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      
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      
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      
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      
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      
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
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      
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      
1642 op-snap---monthly-publication-april-2025.pdf   1641 2025-04 Car   NP Black Driving without Reasonable Consideration None Eardiston , Tenbury Wells Eardiston , Tenbury Wells Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1643 op-snap---monthly-publication-april-2025.pdf   1642 2025-04 Car   NP   Driving without Reasonable Consideration None A45 heading towards Northhampton A45 heading towards Northhampton Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1645 op-snap---monthly-publication-april-2025.pdf   1644 2025-04 Car Audi A3 Silver Driving without Reasonable Consideration None B4103 Sounthbound heading towards Kenilworth Sounthbound heading towards Kenilworth Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1676 op-snap---monthly-publication-april-2025.pdf   1675 2025-04 Car Ford Fiesta Blue Driving without Reasonable Consideration None Stanklyn Lane , Kidderminster Stanklyn Lane , Kidderminster Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1677 op-snap---monthly-publication-april-2025.pdf   1676 2025-04 Car Volkswagen Tigan White Driving without Reasonable Consideration None Birchley Island Roundabout Birchley Island Roundabout Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1702 op-snap---monthly-publication-april-2025.pdf   1701 2025-04 Car BMW NP Grey Driving without Reasonable Consideration Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD A458 outside of Much Wenlock A458 outside of Much Wenlock Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1706 op-snap---monthly-publication-april-2025.pdf   1705 2025-04 Car Peugeot NP Blue Driving without Reasonable Consideration None Eurpoa Way towards M40 Eurpoa Way towards M40 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1755 op-snap---monthly-publication-april-2025.pdf   1754 2025-04 Car Nissan Quashqai Black Driving without Reasonable Consideration None B4102 over cock and Bear bridge Nuneaton B4102 over cock and Bear bridge Nuneaton Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
1911 op-snap---monthly-publication-april-2025.pdf   1910 2025-04 Car BMW 3 Series Blue Driving without Reasonable Consideration None Manor way Road Manor way Road Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4011424 -1.7754147
1965 op-snap---monthly-publication-april-2025.pdf   1964 2025-04 Car Audi A5 Black Driving without Reasonable Consideration None Rashwood area towards Bristol Rashwood area towards Bristol Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
2011 op-snap---monthly-publication-april-2025.pdf   2010 2025-04 Car Honda Civic Black Driving without Reasonable Consideration None A49 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.6195535 -2.0193824
2021 op-snap---monthly-publication-april-2025.pdf   2020 2025-04 Car Kia Sportive Black Driving without Reasonable Consideration None Sir Henry Parks way Sir Henry Parks way Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
16307 op-snap---monthly-publication-march-2025.pdf   64 2025-03 Car Volkswagen Golf White Driving without Reasonable Consideration None M42 Junction 2 M42 Junction 2 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4945433 -2.0190848
16640 op-snap---monthly-publication-march-2025.pdf   397 2025-03 Car Seat Ateca White Driving without Reasonable Consideration None Watling Street, Atherstone Watling Street, Atherstone Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17093 op-snap---monthly-publication-march-2025.pdf   850 2025-03 Car Ford C Max Blue Driving without Reasonable Consideration None Campden Road (Stratford) Campden Road (Stratford) Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17821 op-snap---monthly-publication-march-2025.pdf   1578 2025-03 Car Toyota Prius White Driving without Reasonable Consideration None M42 Jn8-8a M42 Jn8-8a Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17934 op-snap---monthly-publication-march-2025.pdf   1691 2025-03 Car BMW 2 Series Blue Driving without Reasonable Consideration None Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.3837388 -1.5529669
18032 op-snap---monthly-publication-march-2025.pdf   1789 2025-03 Car Jaguar iPace Black Driving without Reasonable Consideration None M42 (N/B) Jn9, Warwickshire M42 (Northbound) Jn9, Warwickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18183 op-snap---monthly-publication-march-2025.pdf   1940 2025-03 Car Nissan QASHQUI Grey Driving without Reasonable Consideration None B4380 SHREWSBURY B4380 Shrewsbury Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18185 op-snap---monthly-publication-march-2025.pdf   1942 2025-03 Car Ford KUGA Grey Driving without Reasonable Consideration None B4380 SHREWSBURY B4380 Shrewsbury Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18222 op-snap---monthly-publication-march-2025.pdf   1979 2025-03 Car Dacia   Grey Driving without Reasonable Consideration None Tolladine Road Worcester Tolladine Road Worcester Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18225 op-snap---monthly-publication-march-2025.pdf   1982 2025-03 Car Daf HGV White Driving without Reasonable Consideration None A42 Warwickshire Warwickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4318492 -1.7319529
7185 op-snap---monthly-publication-february-2025.pdf   2002 2025-02 Car Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Bromsgrove Road, Romsley Bromsgrove Road, Romsley Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9153 op-snap---monthly-publication-january-2025.pdf   261 2025-01 Car Land Rover Defender Black Driving without Reasonable Consideration None M54 Jct 2 to 3, Coven, Staffs M54 Junction 2 to 3, Coven, Staffs Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9612 op-snap---monthly-publication-january-2025.pdf   720 2025-01 Car Volvo Tractor White Driving without Reasonable Consideration None M5 J5-J6 Worcestershire M5 J5-J6 Worcestershire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    

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