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

277 rows where disposal = "Education" and month = "2025-08" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw

vehicle_make >30

  • Ford 38
  • BMW 30
  • Volkswagen 29
  • Mercedes-Benz 24
  • Toyota 21
  • Vauxhall 19
  • Audi 18
  • Seat 11
  • Nissan 10
  • Renault 8
  • Citroen 7
  • Fiat 6
  • Kia 6
  • Hyundai 5
  • Mg 5
  • Mini 4
  • Peugeot 4
  • Skoda 4
  • Jaguar 3
  • Land Rover 3
  • Volvo 3
  • Honda 2
  • Iveco 2
  • Lexus 2
  • Mazda 2
  • Tesla 2
  • Chysler 1
  • Cupra 1
  • Daf 1
  • Mitsubishi 1
  • …

offence 10

  • Driving without Due Care and Attention 136
  • Contravening a Red Traffic Light 105
  • Driving without Reasonable Consideration 18
  • Stop a vehicle within pelican pedestrian crossing limits 5
  • Drive on hard shoulder 4
  • Prohibited vehicle in offside lane of motorway 3
  • Contravene Lane Closure Red X 2
  • Drive a vehicle other than on the carriageway of a motorway 2
  • Using a Mobile Phone Whilst Driving 1
  • Vehicle overtake within crossing limits 1

council_area 9

  • Birmingham 147
  • Coventry 23
  • Walsall 22
  • Sandwell 21
  • Dudley 20
  • Solihull 18
  • Wolverhampton 15
  • Sutton Coldfield 8
  • Halesowen 3

reporter_transport_mode 6

  • Car 202
  • Pedal Bike 54
  • Pedestrian 12
  • Other 4
  • Lorry 3
  • Motorbike 2

month 1

  • 2025-08 · 277 ✖

disposal 1

  • Education · 277 ✖
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
2025 op-snap---monthly-publication-august-2025.pdf   0 2025-08 Car BMW 120M White Driving without Due Care and Attention None Dudley Road Dudley Road Birmingham Birmingham Education N/A   52.4865107 -1.9386263
2026 op-snap---monthly-publication-august-2025.pdf   1 2025-08 Car Kia Sportage Blue Contravening a Red Traffic Light None Vicarage Road Vicarage Road Birmingham Birmingham Education N/A   52.470423 -1.9304786
2027 op-snap---monthly-publication-august-2025.pdf   2 2025-08 Car Ford Fiesta Red Contravening a Red Traffic Light None Vicarage Road Vicarage Road Birmingham Birmingham Education N/A   52.470423 -1.9304786
2031 op-snap---monthly-publication-august-2025.pdf   6 2025-08 Pedal Bike   Ferrari Red Driving without Due Care and Attention None A4040 A4040 Birmingham Birmingham Education N/A      
2035 op-snap---monthly-publication-august-2025.pdf   10 2025-08 Car Audi Q5 Grey Contravening a Red Traffic Light None Newport Road Newport Road Birmingham Birmingham Education N/A   52.5027779 -1.7982159
2039 op-snap---monthly-publication-august-2025.pdf   14 2025-08 Car Skoda Suberb Black Driving without Due Care and Attention None Jayshaw Avenue Jayshaw Avenue Birmingham Birmingham Education N/A      
2048 op-snap---monthly-publication-august-2025.pdf   23 2025-08 Car BMW 118I White Contravening a Red Traffic Light None Walsall Road Walsall Road Walsall Walsall Education N/A   52.6166864 -1.9660822
2049 op-snap---monthly-publication-august-2025.pdf   24 2025-08 Car Seat Leon White Driving without Due Care and Attention None Swanshurst Lane Swanshurst Lane Birmingham Birmingham Education N/A   52.4337146 -1.8634884
2051 op-snap---monthly-publication-august-2025.pdf   26 2025-08 Pedestrian Ford Fiesta Yellow Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Education N/A      
2054 op-snap---monthly-publication-august-2025.pdf   29 2025-08 Car Ford Puma Grey Driving without Due Care and Attention None Dudley Road Dudley Road Dudley Dudley Education N/A   52.4881161 -2.1199108
2058 op-snap---monthly-publication-august-2025.pdf   33 2025-08 Car Ford Fiesta Grey Driving without Due Care and Attention None Blake Street Blake Street Sutton Coldfield Sutton Coldfield Education N/A   52.6043776 -1.8446597
2060 op-snap---monthly-publication-august-2025.pdf   35 2025-08 Car Peugeot 3008.. Black Contravening a Red Traffic Light None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
2064 op-snap---monthly-publication-august-2025.pdf   39 2025-08 Car Volvo XC40 Black Driving without Due Care and Attention None Wellington Road Wellington Road Birmingham Birmingham Education N/A   52.5133725 -1.9193405
2065 op-snap---monthly-publication-august-2025.pdf   40 2025-08 Car Ford C Maxx White Driving without Due Care and Attention None A5127 A5127 Birmingham Birmingham Education N/A      
2067 op-snap---monthly-publication-august-2025.pdf   42 2025-08 Pedal Bike Fiat 500 White Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
2069 op-snap---monthly-publication-august-2025.pdf   44 2025-08 Car Nissan Juke White Contravening a Red Traffic Light None A449 Stafford Road Stafford Road Wolverhampton Wolverhampton Education N/A   52.6291998 -2.126312
2071 op-snap---monthly-publication-august-2025.pdf   46 2025-08 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
2072 op-snap---monthly-publication-august-2025.pdf   47 2025-08 Car Volkswagen Golf Black Contravening a Red Traffic Light None A449 A449 Wolverhampton Wolverhampton Education N/A      
2079 op-snap---monthly-publication-august-2025.pdf   54 2025-08 Car Audi A4.. Black Contravening a Red Traffic Light None A34 Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
2080 op-snap---monthly-publication-august-2025.pdf   55 2025-08 Car Vauxhall Combo Red Contravening a Red Traffic Light None A452 Collector Road Collector Road Birmingham Birmingham Education N/A   52.5139393 -1.7600186
2082 op-snap---monthly-publication-august-2025.pdf   57 2025-08 Car Mercedes-Benz A160.. Blue Contravening a Red Traffic Light None Hollyhedge Road West Brom Hollyhedge Road West Brom Sandwell Sandwell Education N/A      
2084 op-snap---monthly-publication-august-2025.pdf   59 2025-08 Car Fiat 500 Grey Contravening a Red Traffic Light None Hall Green Road Hall Green Road Coventry Coventry Education N/A   52.4401926 -1.475417
2086 op-snap---monthly-publication-august-2025.pdf   61 2025-08 Car Ford Transit Blue Contravening a Red Traffic Light None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
2089 op-snap---monthly-publication-august-2025.pdf   64 2025-08 Pedal Bike Ford Transit Yellow Driving without Reasonable Consideration None Meadowbrook Road Meadowbrook Road Birmingham Birmingham Education N/A      
2091 op-snap---monthly-publication-august-2025.pdf   66 2025-08 Pedestrian Volkswagen T Roc White Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
2092 op-snap---monthly-publication-august-2025.pdf   67 2025-08 Car Porsche Macan Grey Contravene Lane Closure Red X None A38M Expressway A38M Expressway Birmingham Birmingham Education N/A      
2094 op-snap---monthly-publication-august-2025.pdf   69 2025-08 Car BMW 330 D White Contravening a Red Traffic Light None A4123 Wolverhampton Wolverhampton Dudley Dudley Education N/A   52.5082944 -2.0789873
2107 op-snap---monthly-publication-august-2025.pdf   82 2025-08 Pedal Bike Ford Focus Blue Driving without Due Care and Attention None Thornhill Road Thornhill Road Birmingham Birmingham Education N/A   52.5042818 -1.9279918
2109 op-snap---monthly-publication-august-2025.pdf   84 2025-08 Car Ford Focus Blue Contravening a Red Traffic Light None A34 Walsall Rd Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
2110 op-snap---monthly-publication-august-2025.pdf   85 2025-08 Car Seat Tarraco Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell Education N/A   52.5461417 -1.9334193
2112 op-snap---monthly-publication-august-2025.pdf   87 2025-08 Car Hyundai I20 Black Contravening a Red Traffic Light None Birmingham Road Birmingham Road Birmingham Birmingham Education N/A   52.5505398 -1.8252993
2116 op-snap---monthly-publication-august-2025.pdf   91 2025-08 Pedestrian BMW X7 Silver Contravening a Red Traffic Light None Lawley Middleway Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
2118 op-snap---monthly-publication-august-2025.pdf   93 2025-08 Car Lexus CT Black Driving without Due Care and Attention None     Coventry Coventry Education N/A      
2119 op-snap---monthly-publication-august-2025.pdf   94 2025-08 Pedal Bike Ford Fiesta Grey Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
2123 op-snap---monthly-publication-august-2025.pdf   98 2025-08 Lorry Jaguar I Pace Blue Driving without Due Care and Attention None M42 M42 Solihull Solihull Education N/A      
2126 op-snap---monthly-publication-august-2025.pdf   101 2025-08 Car Hyundai I30 White Driving without Due Care and Attention None Upper Church Road Upper Church Road Walsall Walsall Education N/A      
2127 op-snap---monthly-publication-august-2025.pdf   102 2025-08 Pedal Bike BMW 530D Silver Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
2129 op-snap---monthly-publication-august-2025.pdf   104 2025-08 Car BMW 330 Black Driving without Due Care and Attention None The Broadway The Broadway Walsall Walsall Education N/A   52.6090076 -2.0515573
2130 op-snap---monthly-publication-august-2025.pdf   105 2025-08 Car Mercedes-Benz AMG White Driving without Due Care and Attention None The Broadway The Broadway Walsall Walsall Education N/A   52.6090076 -2.0515573
2136 op-snap---monthly-publication-august-2025.pdf   111 2025-08 Car   Lorry White Prohibited vehicle in offside lane of motorway None M5 NB M5 Northbound Birmingham Birmingham Education N/A      
2138 op-snap---monthly-publication-august-2025.pdf   113 2025-08 Pedestrian Volvo XC60 Grey Driving without Due Care and Attention None Sandyfields Road Sandyfields Road Dudley Dudley Education N/A   52.5334161 -2.1371465
2147 op-snap---monthly-publication-august-2025.pdf   122 2025-08 Car Mercedes-Benz GLA Black Driving without Due Care and Attention None Battery Way Battery Way Birmingham Birmingham Education N/A   52.4493988 -1.8476406
2154 op-snap---monthly-publication-august-2025.pdf   129 2025-08 Car   Copen Gold Drive on hard shoulder None M6 Southbound Jct 6 M6 Southbound Junction 6 Birmingham Birmingham Education N/A   52.6760749 -2.0862582
2159 op-snap---monthly-publication-august-2025.pdf   134 2025-08 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Salisbury Road Salisbury Road Birmingham Birmingham Education N/A   52.4943878 -1.8504211
2161 op-snap---monthly-publication-august-2025.pdf   136 2025-08 Pedal Bike Renault Captur Silver Driving without Reasonable Consideration None Streetbrook Road Streetbrook Road Birmingham Birmingham Education N/A      
2166 op-snap---monthly-publication-august-2025.pdf   141 2025-08 Car Mazda 2.. Blue Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
2170 op-snap---monthly-publication-august-2025.pdf   145 2025-08 Car Ford Fiesta Black Contravening a Red Traffic Light None A4040 A4040 Birmingham Birmingham Education N/A      
2171 op-snap---monthly-publication-august-2025.pdf   146 2025-08 Pedal Bike Tesla   Red Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
2184 op-snap---monthly-publication-august-2025.pdf   159 2025-08 Car BMW 520.. Black Contravening a Red Traffic Light None Thorns Road Thorns Road Dudley Dudley Education N/A   52.4628538 -2.1160108
2186 op-snap---monthly-publication-august-2025.pdf   161 2025-08 Car BMW 118i Grey Driving without Due Care and Attention None Cole Hall Road Cole Hall Road Birmingham Birmingham Education N/A   52.4968357 -1.7908553
2187 op-snap---monthly-publication-august-2025.pdf   162 2025-08 Car BMW 320D Grey Contravening a Red Traffic Light None A47 Spitfire Island Spitfire Island Birmingham Birmingham Education N/A   52.5138106 -1.797297
2189 op-snap---monthly-publication-august-2025.pdf   164 2025-08 Car Ford fiesta Black Driving without Reasonable Consideration None Fenton Street Fenton Street Sandwell Sandwell Education N/A   52.5004036 -1.9790049
2200 op-snap---monthly-publication-august-2025.pdf   175 2025-08 Pedal Bike Volkswagen Golf Beige Driving without Due Care and Attention None Moorgreen Lane Moorgreen Lane Birmingham Birmingham Education N/A      
2202 op-snap---monthly-publication-august-2025.pdf   177 2025-08 Pedal Bike Volkswagen Polo Silver Contravening a Red Traffic Light None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
2203 op-snap---monthly-publication-august-2025.pdf   178 2025-08 Pedal Bike Volkswagen ID Grey Driving without Reasonable Consideration None St James Lane Street James Lane Coventry Coventry Education N/A      
2206 op-snap---monthly-publication-august-2025.pdf   181 2025-08 Car Hyundai I20 Silver Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
2208 op-snap---monthly-publication-august-2025.pdf   183 2025-08 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Harborne Road Harborne Road Birmingham Birmingham Education N/A   52.4718503 -1.9195423
2210 op-snap---monthly-publication-august-2025.pdf   185 2025-08 Other Renault Clio White Driving without Due Care and Attention None Waterfront Merry Hill Waterfront Merry Hill Dudley Dudley Education N/A   52.4874176 -2.1129449
2212 op-snap---monthly-publication-august-2025.pdf   187 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Barrs Road Cradley Heath Barrs Road Cradley Heath Sandwell Sandwell Education N/A   52.4682935 -2.0660364
2215 op-snap---monthly-publication-august-2025.pdf   190 2025-08 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Hatherton Street Hatherton Street Walsall Walsall Education N/A   52.5880551 -1.9796606
2225 op-snap---monthly-publication-august-2025.pdf   200 2025-08 Pedal Bike Peugeot Partner White Driving without Due Care and Attention None Caldwell Road Caldwell Road Birmingham Birmingham Education N/A   52.4847159 -1.8263643
2227 op-snap---monthly-publication-august-2025.pdf   202 2025-08 Car Volkswagen Scirocco White Drive a vehicle other than on the carriageway of a motorway None M6 Slip Jct 10 Slip M6 Slip Junction 10 Slip Walsall Walsall Education N/A      
2231 op-snap---monthly-publication-august-2025.pdf   206 2025-08 Pedal Bike Land Rover Range Rover Black Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
2233 op-snap---monthly-publication-august-2025.pdf   208 2025-08 Car Vauxhall Agila Red Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry Education N/A   52.4068712 -1.4994695
2235 op-snap---monthly-publication-august-2025.pdf   210 2025-08 Car Toyota Aygo White Driving without Due Care and Attention Use vehicle on a road without valid test certificate A4040 A4040 Birmingham Birmingham Education N/A      
2242 op-snap---monthly-publication-august-2025.pdf   217 2025-08 Car Volkswagen Golf Red Driving without Due Care and Attention None Puma Way Puma Way Coventry Coventry Education N/A   52.401984 -1.5046079
2247 op-snap---monthly-publication-august-2025.pdf   222 2025-08 Car Toyota Corolla White Driving without Due Care and Attention None Dads Lane Dads Lane Birmingham Birmingham Education N/A   52.4375913 -1.9068522
2251 op-snap---monthly-publication-august-2025.pdf   226 2025-08 Car Land Rover Range Rover Grey Contravening a Red Traffic Light None Castlegate Island Castlegate Island Dudley Dudley Education N/A      
2263 op-snap---monthly-publication-august-2025.pdf   238 2025-08 Car Toyota Yaris Black Driving without Due Care and Attention None Coventry Road Coventry Road Solihull Solihull Education N/A   52.4505232 -1.7606378
2278 op-snap---monthly-publication-august-2025.pdf   253 2025-08 Car Ford B Max Silver Contravening a Red Traffic Light None Birchley Island Birchley Island Sandwell Sandwell Education N/A   52.4926604 -2.0216743
2280 op-snap---monthly-publication-august-2025.pdf   255 2025-08 Car Vauxhall Insignia White Contravening a Red Traffic Light None City Road City Road Birmingham Birmingham Education N/A   52.4763176 -1.9584897
2284 op-snap---monthly-publication-august-2025.pdf   259 2025-08 Pedal Bike Ford B Max Blue Driving without Due Care and Attention None Station Road Station Road Solihull Solihull Education N/A   52.3927253 -1.6455823
2288 op-snap---monthly-publication-august-2025.pdf   263 2025-08 Car Vauxhall Corsa White Driving without Due Care and Attention None     Sandwell Sandwell Education N/A      
2292 op-snap---monthly-publication-august-2025.pdf   267 2025-08 Car BMW X6 Black Contravening a Red Traffic Light None Battery Way Battery Way Birmingham Birmingham Education N/A   52.4493988 -1.8476406
2293 op-snap---monthly-publication-august-2025.pdf   268 2025-08 Car Toyota Prius Grey Contravening a Red Traffic Light None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
2304 op-snap---monthly-publication-august-2025.pdf   279 2025-08 Car Hyundai Tucson Silver Contravening a Red Traffic Light None Witton Lane Witton Lane Sandwell Sandwell Education N/A   52.5409118 -2.0073184
2306 op-snap---monthly-publication-august-2025.pdf   281 2025-08 Car Skoda Yeti Grey Driving without Due Care and Attention None Black Country New Road Black Country New Road Sandwell Sandwell Education N/A   52.5527191 -2.0312967
2314 op-snap---monthly-publication-august-2025.pdf   289 2025-08 Car Fiat Tipo Grey Driving without Due Care and Attention None Gravelly Hill Gravelly Hill Birmingham Birmingham Education N/A   52.5153884 -1.8527437
2321 op-snap---monthly-publication-august-2025.pdf   296 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Longford Road Longford Road Coventry Coventry Education N/A   52.445164 -1.4879298
2326 op-snap---monthly-publication-august-2025.pdf   301 2025-08 Pedal Bike Vauxhall Grandland Blue Driving without Due Care and Attention None Lichfield Road Lichfield Road Walsall Walsall Education N/A   52.6095168 -2.0493009
2327 op-snap---monthly-publication-august-2025.pdf   302 2025-08 Car Audi S3 Grey Driving without Reasonable Consideration None M242 J5 M242 J5 Solihull Solihull Education N/A      
2332 op-snap---monthly-publication-august-2025.pdf   307 2025-08 Car Volkswagen Polo Black Contravening a Red Traffic Light None Sutton New Road Sutton New Road Birmingham Birmingham Education N/A   52.5260956 -1.8379401
2334 op-snap---monthly-publication-august-2025.pdf   309 2025-08 Pedestrian Toyota Prius White Contravening a Red Traffic Light None Hall Green Road Hall Green Road Sandwell Sandwell Education N/A   52.5457385 -1.9935809
2339 op-snap---monthly-publication-august-2025.pdf   314 2025-08 Car Iveco Daily White Contravening a Red Traffic Light None Alcester Road South Alcester Road South Birmingham Birmingham Education N/A   52.4170522 -1.8906187
2340 op-snap---monthly-publication-august-2025.pdf   315 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Longford Longford Coventry Coventry Education N/A   52.4516182 -1.4885443
2341 op-snap---monthly-publication-august-2025.pdf   316 2025-08 Car Kia Sportage Silver Contravening a Red Traffic Light None Albany Road Albany Road Coventry Coventry Education N/A   52.4006218 -1.5284125
2343 op-snap---monthly-publication-august-2025.pdf   318 2025-08 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Darthmouth Middleway Darthmouth Middleway Birmingham Birmingham Education N/A      
2345 op-snap---monthly-publication-august-2025.pdf   320 2025-08 Other Mercedes-Benz C-class Silver Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Education N/A      
2347 op-snap---monthly-publication-august-2025.pdf   322 2025-08 Car Ford Mondeo Blue Driving without Due Care and Attention None A463 A463 Wolverhampton Wolverhampton Education N/A      
2351 op-snap---monthly-publication-august-2025.pdf   326 2025-08 Car Mini Cooper Silver Contravening a Red Traffic Light None Dovehouse Lane Dovehouse Lane Solihull Solihull Education N/A   52.4319915 -1.7915192
2352 op-snap---monthly-publication-august-2025.pdf   327 2025-08 Car Vauxhall Crossland Grey Contravening a Red Traffic Light None Garretts Lane, Old Hill Garretts Lane, Old Hill Sandwell Sandwell Education N/A      
2354 op-snap---monthly-publication-august-2025.pdf   329 2025-08 Pedal Bike Audi SQ8 Grey Contravening a Red Traffic Light None A435 A435 Birmingham Birmingham Education N/A      
2355 op-snap---monthly-publication-august-2025.pdf   330 2025-08 Car Audi TT Grey Contravening a Red Traffic Light None Hagley Road West Hagley Road West Sandwell Sandwell Education N/A   52.4634145 -1.9969046
2356 op-snap---monthly-publication-august-2025.pdf   331 2025-08 Car Volkswagen Caddy White Contravening a Red Traffic Light None A38 North North Sutton Coldfield Sutton Coldfield Education N/A   52.5495196 -1.8608447
2360 op-snap---monthly-publication-august-2025.pdf   335 2025-08 Car Audi A3.. Red Contravening a Red Traffic Light None Penn Road Wolverhampton Penn Road Wolverhampton Wolverhampton Wolverhampton Education N/A   52.5599616 -2.1556338
2365 op-snap---monthly-publication-august-2025.pdf   340 2025-08 Pedal Bike Renault Scenic Grey Driving without Due Care and Attention None Vicarage Road Vicarage Road Walsall Walsall Education N/A   52.64682 -1.9259844
2367 op-snap---monthly-publication-august-2025.pdf   342 2025-08 Car Seat Ibiza White Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
2369 op-snap---monthly-publication-august-2025.pdf   344 2025-08 Pedal Bike Mercedes-Benz EClass White Driving without Due Care and Attention None Underhill Road Underhill Road Wolverhampton Wolverhampton Education N/A      
2371 op-snap---monthly-publication-august-2025.pdf   346 2025-08 Pedal Bike Toyota Aygo Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
2372 op-snap---monthly-publication-august-2025.pdf   347 2025-08 Car BMW R1300 Blue Contravening a Red Traffic Light None Chapel Ash Chapel Ash Wolverhampton Wolverhampton Education N/A   52.5857494 -2.1409393

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