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

131 rows where council_area = "Out of Force Area", month = "2025-07" 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

vehicle_make 28

  • Ford 17
  • Volkswagen 16
  • Audi 14
  • Mercedes-Benz 13
  • BMW 11
  • Vauxhall 10
  • Land Rover 7
  • Nissan 7
  • Honda 3
  • Mini 3
  • Peugeot 3
  • Volvo 3
  • Renault 2
  • Seat 2
  • Skoda 2
  • Tesla 2
  • Byd 1
  • Citroen 1
  • Fiat 1
  • Hyundai 1
  • Iveco 1
  • Jaguar 1
  • Lexus 1
  • Man 1
  • Omoda 1
  • Porsche 1
  • Scania 1
  • Yamaha 1

offence 13

  • Driving without Due Care and Attention 82
  • Driving without Reasonable Consideration 13
  • Contravening a Red Traffic Light 7
  • Using a Mobile Phone Whilst Driving 7
  • Drive on hard shoulder 6
  • Misc - Non Traffic Offences 6
  • Contravene Lane Closure Red X 3
  • Prohibited vehicle in offside lane of motorway 2
  • Driver not in position to have Proper Control 1
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
  • Motor vehicle fail to comply with solid white line road markings 1
  • Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1

disposal 2

  • NFA 125
  • Warning Letter 6

reporter_transport_mode 1

  • Car · 131 ✖

month 1

  • 2025-07 · 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
11950 op-snap---monthly-publication-july-2025.pdf   2 2025-07 Car Tesla   White Contravening a Red Traffic Light None Ventura Park Road Ventura Park Road Out of Force Area Out of Force Area NFA Out of Force      
11971 op-snap---monthly-publication-july-2025.pdf   23 2025-07 Car Skoda Enyaq Blue Driving without Due Care and Attention None A44 Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
11978 op-snap---monthly-publication-july-2025.pdf   30 2025-07 Car Vauxhall Corsa Red Driving without Due Care and Attention None Queensbury, Bradford Queensbury, Bradford Out of Force Area Out of Force Area NFA Out of Force      
11979 op-snap---monthly-publication-july-2025.pdf   31 2025-07 Car Porsche Cayman Silver Driving without Due Care and Attention None Stratford Road, Wellesbourne Stratford Road, Wellesbourne Out of Force Area Out of Force Area NFA Out of Force      
11984 op-snap---monthly-publication-july-2025.pdf   36 2025-07 Car Mercedes-Benz Sprinter Blue Driving without Due Care and Attention None Off force - west mercia Off force - west mercia Out of Force Area Out of Force Area NFA Out of Force      
11990 op-snap---monthly-publication-july-2025.pdf   42 2025-07 Car Ford Mondeo Blue Driving without Due Care and Attention None A5189 Burton upon Trent Burton upon Trent Out of Force Area Out of Force Area NFA Out of Force      
12000 op-snap---monthly-publication-july-2025.pdf   52 2025-07 Car Audi A6 Silver Driving without Due Care and Attention None Bilford Road Bilford Road Out of Force Area Out of Force Area NFA Out of Force      
12023 op-snap---monthly-publication-july-2025.pdf   75 2025-07 Car Audi Q3 Blue Driving without Due Care and Attention None M43 WB J3 M43 Wb J3 Out of Force Area Out of Force Area NFA Out of Force   52.4846642 -1.9297585
12025 op-snap---monthly-publication-july-2025.pdf   77 2025-07 Car Nissan Qashqai Black Driving without Due Care and Attention None Beehive Hill Beehive Hill Out of Force Area Out of Force Area NFA Out of Force   52.5518914 -2.0227634
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
12069 op-snap---monthly-publication-july-2025.pdf   121 2025-07 Car Mini Countryman White Contravening a Red Traffic Light None Tamworth Road Tamworth Road Out of Force Area Out of Force Area NFA Out of Force   52.5856221 -1.790692
12074 op-snap---monthly-publication-july-2025.pdf   126 2025-07 Car Volvo XC90 Black Driving without Due Care and Attention None M6 Warwickshire M6 Warwickshire Out of Force Area Out of Force Area NFA Out of Force   52.4572944 -1.4815973
12079 op-snap---monthly-publication-july-2025.pdf   131 2025-07 Car BMW   Black Driving without Due Care and Attention None Church Lane Church Lane Out of Force Area Out of Force Area NFA Out of Force   52.5133161 -1.9278283
12110 op-snap---monthly-publication-july-2025.pdf   162 2025-07 Car Audi Q7.. Grey Driving without Due Care and Attention None Slip road London Slip road London Out of Force Area Out of Force Area NFA Out of Force      
12127 op-snap---monthly-publication-july-2025.pdf   179 2025-07 Car Volkswagen Golf White Driving without Due Care and Attention None Bitterscote Drive Bitterscote Drive Out of Force Area Out of Force Area NFA Out of Force      
12131 op-snap---monthly-publication-july-2025.pdf   183 2025-07 Car Nissan Qashqai White Driver not in position to have Proper Control None M54 J1, M 10A M54 J1, M 10A Out of Force Area Out of Force Area NFA Out of Force      
12139 op-snap---monthly-publication-july-2025.pdf   191 2025-07 Car Vauxhall Movano White Driving without Due Care and Attention None B4115 near Rocky Lane B4115 near Rocky Lane Out of Force Area Out of Force Area NFA Out of Force      
12140 op-snap---monthly-publication-july-2025.pdf   192 2025-07 Car Volvo   Blue Motor vehicle fail to comply with solid white line road markings None M42/M40 M42/M40 Out of Force Area Out of Force Area NFA Out of Force   52.3628734 -1.8040442
12142 op-snap---monthly-publication-july-2025.pdf   194 2025-07 Car Tesla model 3 white Driving without Due Care and Attention None A41, Newport, West Mercia A41, Newport, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
12157 op-snap---monthly-publication-july-2025.pdf   209 2025-07 Car Mercedes-Benz E220 Black Driving without Due Care and Attention None Ediburgh Ediburgh Out of Force Area Out of Force Area NFA Out of Force      
12171 op-snap---monthly-publication-july-2025.pdf   223 2025-07 Car Seat Ibiza Green Driving without Due Care and Attention None Pershore Road Pershore Road Out of Force Area Out of Force Area NFA Out of Force   52.4653873 -1.8988344
12229 op-snap---monthly-publication-july-2025.pdf   281 2025-07 Car   Kymco Red Driving without Due Care and Attention None Cheadle - Off force Cheadle - Off force Out of Force Area Out of Force Area NFA Out of Force      
12231 op-snap---monthly-publication-july-2025.pdf   283 2025-07 Car Mercedes-Benz A class White Driving without Due Care and Attention None Ledbury, West Mercia Ledbury, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
12238 op-snap---monthly-publication-july-2025.pdf   290 2025-07 Car Mini Cooper Grey Driving without Due Care and Attention None Walwyn Road Walwyn Road Out of Force Area Out of Force Area NFA Out of Force      
12240 op-snap---monthly-publication-july-2025.pdf   292 2025-07 Car Renault Clio Grey Driving without Due Care and Attention None Astwood Road Astwood Road Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
12253 op-snap---monthly-publication-july-2025.pdf   305 2025-07 Car Volkswagen Golf Black Driving without Due Care and Attention None Droitwich Droitwich Out of Force Area Out of Force Area NFA Out of Force      
12274 op-snap---monthly-publication-july-2025.pdf   326 2025-07 Car   Infiniti Grey Driving without Due Care and Attention None Barlborough Interchange Barlborough Interchange Out of Force Area Out of Force Area NFA Out of Force      
12292 op-snap---monthly-publication-july-2025.pdf   344 2025-07 Car Peugeot Boxer van White Driving without Due Care and Attention None Smite lane, Worcester Smite lane, Worcester Out of Force Area Out of Force Area NFA Out of Force      
12297 op-snap---monthly-publication-july-2025.pdf   349 2025-07 Car Nissan Micra Red Driving without Due Care and Attention None Tesco, Blackpool Tesco, Blackpool Out of Force Area Out of Force Area NFA Out of Force      
12298 op-snap---monthly-publication-july-2025.pdf   350 2025-07 Car Ford Fiesta Black Driving without Due Care and Attention None Fleetwood FY7 7JL Fleetwood FY7 7JL Out of Force Area Out of Force Area NFA Out of Force   52.4743461 -1.7895289
12299 op-snap---monthly-publication-july-2025.pdf   351 2025-07 Car Volkswagen Golf Grey Driving without Due Care and Attention None Jubilee Tower, Lancaster Jubilee Tower, Lancaster Out of Force Area Out of Force Area NFA Out of Force      
12314 op-snap---monthly-publication-july-2025.pdf   366 2025-07 Car Renault Master van Green Using a Mobile Phone Whilst Driving No vehicle excise licence M6, near Knutsford M6, near Knutsford Out of Force Area Out of Force Area NFA Out of Force      
12403 op-snap---monthly-publication-july-2025.pdf   455 2025-07 Car Mercedes-Benz CLK-250 Grey Driving without Due Care and Attention None B4504 Redditch Redditch Out of Force Area Out of Force Area NFA Out of Force   52.4072158 -1.9277937
12451 op-snap---monthly-publication-july-2025.pdf   503 2025-07 Car BMW   White Driving without Due Care and Attention None M40 Motorway M40 Motorway Out of Force Area Out of Force Area NFA Out of Force   52.490826 -1.8882034
12467 op-snap---monthly-publication-july-2025.pdf   519 2025-07 Car Volkswagen Golf Black Driving without Due Care and Attention None Tamworth Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.5724303 -1.8191247
12489 op-snap---monthly-publication-july-2025.pdf   541 2025-07 Car Audi A3 Black Contravening a Red Traffic Light None Kidderminster road Kidderminster road Out of Force Area Out of Force Area NFA Out of Force   52.4331313 -2.1702262
12493 op-snap---monthly-publication-july-2025.pdf   545 2025-07 Car       Driving without Due Care and Attention None High Lane High Lane Out of Force Area Out of Force Area NFA Out of Force   52.4908428 -1.9653065
12495 op-snap---monthly-publication-july-2025.pdf   547 2025-07 Car Jaguar   Black Driving without Due Care and Attention None Four Ashes Road Four Ashes Road Out of Force Area Out of Force Area NFA Out of Force   52.3828826 -1.7624844
12499 op-snap---monthly-publication-july-2025.pdf   551 2025-07 Car Ford Focus Blue Driving without Due Care and Attention None Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
12509 op-snap---monthly-publication-july-2025.pdf   561 2025-07 Car Skoda Enyaq Blue Driving without Due Care and Attention None M6 NB Liverpool M6 Northbound Liverpool Out of Force Area Out of Force Area NFA Out of Force      
12510 op-snap---monthly-publication-july-2025.pdf   562 2025-07 Car Land Rover Range Black Driving without Due Care and Attention None Off force Off force Out of Force Area Out of Force Area NFA Out of Force      
12530 op-snap---monthly-publication-july-2025.pdf   582 2025-07 Car Audi TT Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Eardley Road, Streatham Eardley Road, Streatham Out of Force Area Out of Force Area NFA Out of Force      
12535 op-snap---monthly-publication-july-2025.pdf   587 2025-07 Car Mercedes-Benz C class Black Driving without Due Care and Attention None M6 nr Jn2 M6 nr Jn2 Out of Force Area Out of Force Area NFA Out of Force      
12536 op-snap---monthly-publication-july-2025.pdf   588 2025-07 Car Man Lorry White Contravening a Red Traffic Light None Tern Hill Tern Hill Out of Force Area Out of Force Area NFA Out of Force      
12565 op-snap---monthly-publication-july-2025.pdf   617 2025-07 Car Mercedes-Benz Lorry White Driving without Due Care and Attention None A5 Watling Street Watling Street Out of Force Area Out of Force Area NFA Out of Force   52.6562907 -1.9111505
12577 op-snap---monthly-publication-july-2025.pdf   629 2025-07 Car Honda Civic Silver Driving without Due Care and Attention None A441, Birmingham Road A441, Birmingham Road Out of Force Area Out of Force Area NFA Out of Force   52.5358009 -1.8271588
12602 op-snap---monthly-publication-july-2025.pdf   654 2025-07 Car Nissan Juke Grey Driving without Due Care and Attention None A49 Ludlow Ludlow Out of Force Area Out of Force Area NFA Out of Force      
12609 op-snap---monthly-publication-july-2025.pdf   661 2025-07 Car Ford Focus Blue Using a Mobile Phone Whilst Driving None A5271 (Staffs) A5271 (Staffs) Out of Force Area Out of Force Area NFA Out of Force      
12631 op-snap---monthly-publication-july-2025.pdf   683 2025-07 Car BMW X5.. Black Driving without Due Care and Attention None A523 A523 Out of Force Area Out of Force Area NFA Out of Force      
12633 op-snap---monthly-publication-july-2025.pdf   685 2025-07 Car Ford Galaxy Black Driving without Due Care and Attention None A38 Droitwich Droitwich Out of Force Area Out of Force Area NFA Out of Force      
12657 op-snap---monthly-publication-july-2025.pdf   709 2025-07 Car Vauxhall Astra Silver Driving without Due Care and Attention None M4 Eastbound J11 M4 Eastbound J11 Out of Force Area Out of Force Area NFA Out of Force      
12674 op-snap---monthly-publication-july-2025.pdf   726 2025-07 Car Volkswagen Caddy White Driving without Due Care and Attention None A5 Wall Island Wall Island Out of Force Area Out of Force Area NFA Out of Force      
12677 op-snap---monthly-publication-july-2025.pdf   729 2025-07 Car Volkswagen Golf Grey Driving without Due Care and Attention None M62 M62 Out of Force Area Out of Force Area NFA Out of Force      
12680 op-snap---monthly-publication-july-2025.pdf   732 2025-07 Car Audi A3 Grey Driving without Due Care and Attention None A5 (Staffs) A5 (Staffs) Out of Force Area Out of Force Area NFA Out of Force   52.6562775 -1.9262309
12682 op-snap---monthly-publication-july-2025.pdf   734 2025-07 Car BMW 330 Black Misc - Non Traffic Offences None A4110 Wigmore Wigmore Out of Force Area Out of Force Area NFA Out of Force      
12683 op-snap---monthly-publication-july-2025.pdf   735 2025-07 Car Omoda 5 NOBLE Black Driving without Due Care and Attention None Lincolnshire Lincolnshire Out of Force Area Out of Force Area NFA Out of Force      
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      
12704 op-snap---monthly-publication-july-2025.pdf   756 2025-07 Car Ford S-Max Black Misc - Non Traffic Offences None Edinburgh Road, Nuneaton Edinburgh Road, Nuneaton Out of Force Area Out of Force Area NFA Out of Force      
12711 op-snap---monthly-publication-july-2025.pdf   763 2025-07 Car Mercedes-Benz   Blue Driving without Due Care and Attention None Derby Road, Off Force Derby Road, Off Force Out of Force Area Out of Force Area NFA Out of Force      
12716 op-snap---monthly-publication-july-2025.pdf   768 2025-07 Car Ford Ranger Grey Driving without Due Care and Attention None M74 M74 Out of Force Area Out of Force Area NFA Out of Force      
12717 op-snap---monthly-publication-july-2025.pdf   769 2025-07 Car Mercedes-Benz Vito Grey Driving without Due Care and Attention Driving without Due Care and AMt5te4n (tOiount of Force) AMt5te4n (t Oiount of Force) Out of Force Area Out of Force Area NFA Out of Force      
12721 op-snap---monthly-publication-july-2025.pdf   773 2025-07 Car Audi A5... Grey Driving without Due Care and Attention None A53 A53 Out of Force Area Out of Force Area NFA Out of Force      
12741 op-snap---monthly-publication-july-2025.pdf   793 2025-07 Car Land Rover Discovery Black Driving without Due Care and Attention None A483 (Welshpool) A483 (Welshpool) Out of Force Area Out of Force Area NFA Out of Force      
12748 op-snap---monthly-publication-july-2025.pdf   800 2025-07 Car Audi S1 Blue Driving without Due Care and Attention None Moor Road (West Yorkshire) Moor Road (West Yorkshire) Out of Force Area Out of Force Area NFA Out of Force      
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      
12795 op-snap---monthly-publication-july-2025.pdf   847 2025-07 Car Hyundai Kona Grey Driving without Due Care and Attention None M5 South (Frankley Services) M5 South (Frankley Services) Out of Force Area Out of Force Area NFA Out of Force      
12796 op-snap---monthly-publication-july-2025.pdf   848 2025-07 Car Nissan Juke Red Contravening a Red Traffic Light None A38 Lichfield Lichfield Out of Force Area Out of Force Area NFA Out of Force   52.6708614 -1.8442078
12809 op-snap---monthly-publication-july-2025.pdf   861 2025-07 Car Mercedes-Benz A200.. Black Driving without Due Care and Attention None M62 M62 Out of Force Area Out of Force Area NFA Out of Force      
12825 op-snap---monthly-publication-july-2025.pdf   877 2025-07 Car Vauxhall Mokka White Driving without Due Care and Attention None Woodhouse Lane Woodhouse Lane Out of Force Area Out of Force Area NFA Out of Force      
12831 op-snap---monthly-publication-july-2025.pdf   883 2025-07 Car BMW M140I Grey Driving without Due Care and Attention None A38 A38 Out of Force Area Out of Force Area NFA Out of Force      
12874 op-snap---monthly-publication-july-2025.pdf   926 2025-07 Car Vauxhall Movano Yellow Driving without Due Care and Attention No Insurance M54 nr Telford M54 nr Telford Out of Force Area Out of Force Area NFA Out of Force      
12875 op-snap---monthly-publication-july-2025.pdf   927 2025-07 Car Volkswagen Polo Grey Contravening a Red Traffic Light None Alexandra Hospital A441, Redditch Alexandra Hospital A441, Redditch 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
12952 op-snap---monthly-publication-july-2025.pdf   1004 2025-07 Car Ford Ranger Black Contravening a Red Traffic Light None B4101 Tile Hill Lane Tile Hill Lane Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
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
12977 op-snap---monthly-publication-july-2025.pdf   1029 2025-07 Car Vauxhall Viva Silver Driving without Due Care and Attention None M40 Warwick. M40 Warwick Out of Force Area Out of Force Area NFA Out of Force   52.4504261 -1.842549
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      
12997 op-snap---monthly-publication-july-2025.pdf   1049 2025-07 Car Land Rover Evoque Silver Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Meriden Road Meriden Road Out of Force Area Out of Force Area NFA Out of Force   52.615491 -2.14217
12999 op-snap---monthly-publication-july-2025.pdf   1051 2025-07 Car Ford transit White Drive on hard shoulder None M42 J9 M42 J9 Out of Force Area Out of Force Area NFA Out of Force   52.3601724 -1.8062199
13006 op-snap---monthly-publication-july-2025.pdf   1058 2025-07 Car Yamaha 125 cc Blue Driving without Due Care and Attention None B4112 B4112 Out of Force Area Out of Force Area NFA Out of Force   52.3994858 -1.4923603
13014 op-snap---monthly-publication-july-2025.pdf   1066 2025-07 Car Nissan Juke Grey Using a Mobile Phone Whilst Driving None B4362 , Mortimers Cross B4362 , Mortimers Cross Out of Force Area Out of Force Area NFA Out of Force      
13037 op-snap---monthly-publication-july-2025.pdf   1089 2025-07 Car Audi A5 Blue Driving without Due Care and Attention None Grantham Road, Lincoln Grantham Road, Lincoln Out of Force Area Out of Force Area NFA Out of Force      
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      
13086 op-snap---monthly-publication-july-2025.pdf   1138 2025-07 Car BMW M135 Green Driving without Due Care and Attention None Off Force Off Force Out of Force Area Out of Force Area NFA Out of Force      
13090 op-snap---monthly-publication-july-2025.pdf   1142 2025-07 Car Vauxhall Zafira Blue Using a Mobile Phone Whilst Driving None M1 M1 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      
13102 op-snap---monthly-publication-july-2025.pdf   1154 2025-07 Car Ford Transit white Driving without Due Care and Attention None M6 j 5 M6 j 5 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.6760749 -2.0862582
13113 op-snap---monthly-publication-july-2025.pdf   1165 2025-07 Car Honda Kona Grey Driving without Due Care and Attention None Worksop Road Worksop Road Out of Force Area Out of Force Area NFA Out of Force      
13128 op-snap---monthly-publication-july-2025.pdf   1180 2025-07 Car Land Rover   Black Using a Mobile Phone Whilst Driving None Somewhere in Manchester Somewhere in Manchester Out of Force Area Out of Force Area NFA No Independent Evidence Available      
13163 op-snap---monthly-publication-july-2025.pdf   1215 2025-07 Car Volkswagen Scirocco Black Driving without Due Care and Attention None Kidderminster Road Kidderminster Road Out of Force Area Out of Force Area NFA Out of Force   52.4331313 -2.1702262
13171 op-snap---monthly-publication-july-2025.pdf   1223 2025-07 Car Vauxhall Corsa Grey Misc - Non Traffic Offences None Out of Force Out of Force Out of Force Area Out of Force Area NFA Out of Force      
13193 op-snap---monthly-publication-july-2025.pdf   1245 2025-07 Car Mercedes-Benz Sprinte White Driving without Due Care and Attention None Cressage (Shropshire) Cressage (Shropshire) Out of Force Area Out of Force Area NFA Out of Force      
13204 op-snap---monthly-publication-july-2025.pdf   1256 2025-07 Car Volkswagen T Cross White Driving without Due Care and Attention None A45 (Rugby) A45 (Rugby) Out of Force Area Out of Force Area NFA Out of Force   52.3762151 -1.4625313
13210 op-snap---monthly-publication-july-2025.pdf   1262 2025-07 Car Volkswagen Golf Black Driving without Due Care and Attention None HIgh Street Hillmorton HIgh Street Hillmorton Out of Force Area Out of Force Area NFA Out of Force      
13213 op-snap---monthly-publication-july-2025.pdf   1265 2025-07 Car Land Rover Evoque Gold Driving without Due Care and Attention None M5 Bromsgrove M5 Bromsgrove Out of Force Area Out of Force Area NFA Out of Force   52.432364 -2.0176127

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