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

140 rows where disposal = "Warning Letter", month = "2025-08" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, council_area_raw

vehicle_make 26

  • BMW 19
  • Ford 17
  • Volkswagen 17
  • Mercedes-Benz 12
  • Audi 10
  • Toyota 7
  • Vauxhall 7
  • Hyundai 6
  • Skoda 6
  • Kia 4
  • Nissan 4
  • Mini 3
  • Porsche 3
  • Renault 3
  • Cupra 2
  • Dacia 2
  • Fiat 2
  • Honda 2
  • Land Rover 2
  • Mazda 2
  • Peugeot 2
  • Citroen 1
  • Iveco 1
  • Jaguar 1
  • Seat 1
  • Tesla 1

council_area 8

  • Birmingham 71
  • Dudley 19
  • Coventry 14
  • Wolverhampton 11
  • Sandwell 8
  • Solihull 6
  • Sutton Coldfield 6
  • Walsall 5

reporter_transport_mode 5

  • Car 86
  • Pedestrian 22
  • Pedal Bike 17
  • Other 11
  • Motorbike 4

offence 1

  • Driving without Due Care and Attention · 140 ✖

month 1

  • 2025-08 · 140 ✖

disposal 1

  • Warning Letter · 140 ✖
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
2037 op-snap---monthly-publication-august-2025.pdf   12 2025-08 Car Cupra Ateca Grey Driving without Due Care and Attention None Sedgley Road Sedgley Road Sandwell Sandwell Warning Letter N/A   52.5219813 -2.0581691
2056 op-snap---monthly-publication-august-2025.pdf   31 2025-08 Car BMW X3 Black Driving without Due Care and Attention None A38 A38 Birmingham Birmingham Warning Letter N/A      
2068 op-snap---monthly-publication-august-2025.pdf   43 2025-08 Pedal Bike Mini Cooper White Driving without Due Care and Attention None Beechwood Park Road Beechwood Park Road Sutton Coldfield Sutton Coldfield Warning Letter N/A      
2074 op-snap---monthly-publication-august-2025.pdf   49 2025-08 Car Fiat Scudo Grey Driving without Due Care and Attention None Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
2088 op-snap---monthly-publication-august-2025.pdf   63 2025-08 Car Tesla Model 3 White Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Warning Letter N/A   52.4073149 -1.5250454
2099 op-snap---monthly-publication-august-2025.pdf   74 2025-08 Car Hyundai I30 Red Driving without Due Care and Attention None Shenstone Road Shenstone Road Birmingham Birmingham Warning Letter N/A   52.4011594 -1.879934
2102 op-snap---monthly-publication-august-2025.pdf   77 2025-08 Car BMW 320.. Blue Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Warning Letter N/A   52.5047428 -2.0823754
2139 op-snap---monthly-publication-august-2025.pdf   114 2025-08 Other Hyundai I20 White Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Warning Letter N/A   52.4874281 -2.1117204
2141 op-snap---monthly-publication-august-2025.pdf   116 2025-08 Motorbike Mercedes-Benz GLC 300 Black Driving without Due Care and Attention None Truggist Lane Truggist Lane Solihull Solihull Warning Letter N/A   52.3962708 -1.6254918
2163 op-snap---monthly-publication-august-2025.pdf   138 2025-08 Pedal Bike Vauxhall Corsa Blue Driving without Due Care and Attention None Friar Park Road Friar Park Road Sandwell Sandwell Warning Letter N/A   52.5538676 -1.9965667
2185 op-snap---monthly-publication-august-2025.pdf   160 2025-08 Car Ford Puma White Driving without Due Care and Attention None A41 A41 Sandwell Sandwell Warning Letter N/A      
2190 op-snap---monthly-publication-august-2025.pdf   165 2025-08 Car Ford Fiesta Red Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Warning Letter N/A   52.4555288 -1.8613929
2191 op-snap---monthly-publication-august-2025.pdf   166 2025-08 Other Volkswagen Polo Blue Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Warning Letter N/A   52.4874281 -2.1117204
2193 op-snap---monthly-publication-august-2025.pdf   168 2025-08 Other Mercedes-Benz A180 Black Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Warning Letter N/A   52.4874281 -2.1117204
2194 op-snap---monthly-publication-august-2025.pdf   169 2025-08 Other Volkswagen Corsa Black Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Warning Letter N/A   52.4874281 -2.1117204
2195 op-snap---monthly-publication-august-2025.pdf   170 2025-08 Car Volkswagen Golf Grey Driving without Due Care and Attention None Churchbridge Churchbridge Sandwell Sandwell Warning Letter N/A   52.4938109 -2.0217545
2201 op-snap---monthly-publication-august-2025.pdf   176 2025-08 Pedal Bike Volkswagen T-Roc Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
2205 op-snap---monthly-publication-august-2025.pdf   180 2025-08 Car Porsche Cayenne Black Driving without Due Care and Attention None New Hampton Road East New Hampton Road East Wolverhampton Wolverhampton Warning Letter N/A   52.5920541 -2.1374052
2211 op-snap---monthly-publication-august-2025.pdf   186 2025-08 Car Ford Transit White Driving without Due Care and Attention None Aston Road Aston Road Birmingham Birmingham Warning Letter N/A   52.4929386 -1.888744
2216 op-snap---monthly-publication-august-2025.pdf   191 2025-08 Car Mercedes-Benz B Class Blue Driving without Due Care and Attention None Grove Lane Grove Lane Sandwell Sandwell Warning Letter N/A   52.4882564 -1.949089
2219 op-snap---monthly-publication-august-2025.pdf   194 2025-08 Car Volkswagen Touran Blue Driving without Due Care and Attention None Bordsley Middleway Bordsley Middleway Birmingham Birmingham Warning Letter N/A      
2220 op-snap---monthly-publication-august-2025.pdf   195 2025-08 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Keresley Road Keresley Road Coventry Coventry Warning Letter N/A   52.4331176 -1.5314475
2240 op-snap---monthly-publication-august-2025.pdf   215 2025-08 Car Ford Fiesta White Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham Warning Letter N/A   52.4220705 -1.8372335
2260 op-snap---monthly-publication-august-2025.pdf   235 2025-08 Car   Triumph Black Driving without Due Care and Attention None Thornhill Road Thornhill Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5690586 -1.8794686
2266 op-snap---monthly-publication-august-2025.pdf   241 2025-08 Pedal Bike Renault Traffic Grey Driving without Due Care and Attention None Sycamore Road Sycamore Road Birmingham Birmingham Warning Letter N/A   52.5398019 -1.8455792
2276 op-snap---monthly-publication-august-2025.pdf   251 2025-08 Pedal Bike Ford focus White Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall Warning Letter N/A   52.5692139 -1.8799672
2279 op-snap---monthly-publication-august-2025.pdf   254 2025-08 Pedal Bike Kia Ceed Silver Driving without Due Care and Attention None South Road South Road Dudley Dudley Warning Letter N/A   52.4530371 -2.1660216
2301 op-snap---monthly-publication-august-2025.pdf   276 2025-08 Car BMW 325d Silver Driving without Due Care and Attention None Thompson Avenue Thompson Avenue Wolverhampton Wolverhampton Warning Letter N/A   52.5722181 -2.1205684
2370 op-snap---monthly-publication-august-2025.pdf   345 2025-08 Pedestrian Mazda CX-30 Red Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
2389 op-snap---monthly-publication-august-2025.pdf   364 2025-08 Car Ford Transit White Driving without Due Care and Attention None Wyrley Road Wyrley Road Birmingham Birmingham Warning Letter N/A   52.5172973 -1.8785949
2392 op-snap---monthly-publication-august-2025.pdf   367 2025-08 Car Skoda Octavia Grey Driving without Due Care and Attention None A38 Queensway Queensway Birmingham Birmingham Warning Letter N/A   52.4856447 -1.8972389
2418 op-snap---monthly-publication-august-2025.pdf   393 2025-08 Car Vauxhall Astra Black Driving without Due Care and Attention None Sutton Road at Beacon Road Sutton Road at Beacon Road Walsall Walsall Warning Letter N/A   52.561577 -2.0535982
2428 op-snap---monthly-publication-august-2025.pdf   403 2025-08 Motorbike BMW 5 series White Driving without Due Care and Attention None Alcester Road / Salisbury Road Alcester Road / Salisbury Road Birmingham Birmingham Warning Letter N/A   52.4467548 -1.8880528
2437 op-snap---monthly-publication-august-2025.pdf   412 2025-08 Car Ford Fiesta Silver Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Warning Letter N/A   52.4221526 -1.8425617
2445 op-snap---monthly-publication-august-2025.pdf   420 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None Constitution Hill Constitution Hill Birmingham Birmingham Warning Letter N/A   52.4866022 -1.901562
2456 op-snap---monthly-publication-august-2025.pdf   431 2025-08 Car Toyota Aygo Red Driving without Due Care and Attention None Bromfield Lane Bromfield Lane Birmingham Birmingham Warning Letter N/A      
2486 op-snap---monthly-publication-august-2025.pdf   461 2025-08 Pedal Bike Hyundai Santa Fe White Driving without Due Care and Attention None Smallbrook Queensway Smallbrook Queensway Birmingham Birmingham Warning Letter N/A   52.4772584 -1.8965734
2493 op-snap---monthly-publication-august-2025.pdf   468 2025-08 Car Mercedes-Benz A class White Driving without Due Care and Attention None A45 Small Heath Highway Small Heath Highway Birmingham Birmingham Warning Letter N/A   52.4709298 -1.8722585
2501 op-snap---monthly-publication-august-2025.pdf   476 2025-08 Car Dacia Sandero White Driving without Due Care and Attention None Great Western Way Great Western Way Walsall Walsall Warning Letter N/A      
2529 op-snap---monthly-publication-august-2025.pdf   504 2025-08 Motorbike BMW X5 Blue Driving without Due Care and Attention None Holbeach Road Holbeach Road Dudley Dudley Warning Letter N/A      
2546 op-snap---monthly-publication-august-2025.pdf   521 2025-08 Car Ford Fiesta Black Driving without Due Care and Attention None A452 Spitfire Island Spitfire Island Birmingham Birmingham Warning Letter N/A   52.5138106 -1.797297
2548 op-snap---monthly-publication-august-2025.pdf   523 2025-08 Car BMW 1 series Grey Driving without Due Care and Attention None Lower Prestwood Road Lower Prestwood Road Wolverhampton Wolverhampton Warning Letter N/A   52.609833 -2.0871598
2591 op-snap---monthly-publication-august-2025.pdf   566 2025-08 Other Nissan Juke Black Driving without Due Care and Attention None Raynor Road Raynor Road Wolverhampton Wolverhampton Warning Letter N/A   52.6043868 -2.1046385
2592 op-snap---monthly-publication-august-2025.pdf   567 2025-08 Pedal Bike Skoda Octavia Black Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Warning Letter N/A   52.4119174 -1.9735247
2595 op-snap---monthly-publication-august-2025.pdf   570 2025-08 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Earlsdon Av Earlsdon Avenue Coventry Coventry Warning Letter N/A   52.4047134 -1.5351834
2605 op-snap---monthly-publication-august-2025.pdf   580 2025-08 Pedal Bike Nissan Juke Black Driving without Due Care and Attention None Bakers Lane Bakers Lane Birmingham Birmingham Warning Letter N/A   52.5632567 -1.8782299
2637 op-snap---monthly-publication-august-2025.pdf   612 2025-08 Other Mini Cooper White Driving without Due Care and Attention None Waterfront carpark Waterfront carpark Dudley Dudley Warning Letter N/A      
2641 op-snap---monthly-publication-august-2025.pdf   616 2025-08 Pedal Bike Porsche Cayenne Blue Driving without Due Care and Attention None Kineton Lane Kineton Lane Solihull Solihull Warning Letter N/A   52.3661553 -1.7890942
2648 op-snap---monthly-publication-august-2025.pdf   623 2025-08 Pedal Bike BMW X1 Grey Driving without Due Care and Attention None Manor Road Manor Road Solihull Solihull Warning Letter N/A   52.4193737 -1.7798629
2650 op-snap---monthly-publication-august-2025.pdf   625 2025-08 Car Mercedes-Benz EQ300 Grey Driving without Due Care and Attention None Lichfield Road Lichfield Road Walsall Walsall Warning Letter N/A   52.6095168 -2.0493009
2664 op-snap---monthly-publication-august-2025.pdf   639 2025-08 Car Hyundai Tucson Black Driving without Due Care and Attention None Boscobel Road Boscobel Road Wolverhampton Wolverhampton Warning Letter N/A      
2675 op-snap---monthly-publication-august-2025.pdf   650 2025-08 Car   Subuara Grey Driving without Due Care and Attention None Torrington Avenue Torrington Avenue Coventry Coventry Warning Letter N/A   52.3987354 -1.567693
2676 op-snap---monthly-publication-august-2025.pdf   651 2025-08 Car Volkswagen Polo Grey Driving without Due Care and Attention None Mavis Road Mavis Road Birmingham Birmingham Warning Letter N/A   52.4020383 -1.9799109
2681 op-snap---monthly-publication-august-2025.pdf   656 2025-08 Car Skoda Octavia Blue Driving without Due Care and Attention None Bickenhill Road Bickenhill Road Birmingham Birmingham Warning Letter N/A      
2684 op-snap---monthly-publication-august-2025.pdf   659 2025-08 Car Skoda FABIA Black Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Warning Letter N/A   52.4668753 -1.8996143
2705 op-snap---monthly-publication-august-2025.pdf   680 2025-08 Other Mini cooper White Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Warning Letter N/A   52.4874281 -2.1117204
2706 op-snap---monthly-publication-august-2025.pdf   681 2025-08 Other Ford Fiesta Silver Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Warning Letter N/A   52.4874281 -2.1117204
2708 op-snap---monthly-publication-august-2025.pdf   683 2025-08 Car Audi RS6 Grey Driving without Due Care and Attention None Birmingham New Road Bilston Birmingham New Road Bilston Wolverhampton Wolverhampton Warning Letter N/A      
2709 op-snap---monthly-publication-august-2025.pdf   684 2025-08 Car BMW M3 Grey Driving without Due Care and Attention None Birmingham New Road Bilston Birmingham New Road Bilston Wolverhampton Wolverhampton Warning Letter N/A      
2720 op-snap---monthly-publication-august-2025.pdf   695 2025-08 Car Peugeot 1007SE Black Driving without Due Care and Attention None Holbrook WAY Holbrook WAY Coventry Coventry Warning Letter N/A   52.438551 -1.502488
2757 op-snap---monthly-publication-august-2025.pdf   732 2025-08 Car BMW 320D Blue Driving without Due Care and Attention None Green Lane Green Lane Coventry Coventry Warning Letter N/A   52.38188 -1.5300381
2763 op-snap---monthly-publication-august-2025.pdf   738 2025-08 Car Volkswagen Polo White Driving without Due Care and Attention None Walstead Road Walstead Road Sutton Coldfield Sutton Coldfield Warning Letter N/A      
2812 op-snap---monthly-publication-august-2025.pdf   787 2025-08 Car Audi A3.. Red Driving without Due Care and Attention None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton Warning Letter N/A   52.5847884 -2.1341887
2817 op-snap---monthly-publication-august-2025.pdf   792 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
2819 op-snap---monthly-publication-august-2025.pdf   794 2025-08 Other Ford Fiesta Red Driving without Due Care and Attention None Water front Merry Hill Water front Merry Hill Dudley Dudley Warning Letter N/A      
2828 op-snap---monthly-publication-august-2025.pdf   803 2025-08 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None College Road College Road Birmingham Birmingham Warning Letter N/A   52.5151832 -1.9361664
2844 op-snap---monthly-publication-august-2025.pdf   819 2025-08 Car Toyota Yaris Silver Driving without Due Care and Attention None Billesley Lane Billesley Lane Birmingham Birmingham Warning Letter N/A   52.4344402 -1.8845368
2852 op-snap---monthly-publication-august-2025.pdf   827 2025-08 Other Audi A1 Black Driving without Due Care and Attention None Waterfront Merry Hill Waterfront Merry Hill Dudley Dudley Warning Letter N/A   52.4874176 -2.1129449
2870 op-snap---monthly-publication-august-2025.pdf   845 2025-08 Car Peugeot Partner White Driving without Due Care and Attention None Sears Retails Park Sears Retails Park Solihull Solihull Warning Letter N/A      
2872 op-snap---monthly-publication-august-2025.pdf   847 2025-08 Car Hyundai I10 White Driving without Due Care and Attention None Bilston Road Bilston Road Wolverhampton Wolverhampton Warning Letter N/A   52.5801329 -2.1138283
2874 op-snap---monthly-publication-august-2025.pdf   849 2025-08 Car Kia Rio Yellow Driving without Due Care and Attention None M42 Junction M42 Junction Solihull Solihull Warning Letter N/A      
2877 op-snap---monthly-publication-august-2025.pdf   852 2025-08 Car BMW 335.. White Driving without Due Care and Attention None Bridge Road Saltley Bridge Road Saltley Birmingham Birmingham Warning Letter N/A   52.4857537 -1.8531485
2884 op-snap---monthly-publication-august-2025.pdf   859 2025-08 Car Vauxhall Astra White Driving without Due Care and Attention None Brettle Lane Brettle Lane Dudley Dudley Warning Letter N/A      
2890 op-snap---monthly-publication-august-2025.pdf   865 2025-08 Car Iveco Daily White Driving without Due Care and Attention None M6 SB J6 M6 Southbound J6 Birmingham Birmingham Warning Letter N/A   52.676119 -2.0858425
2915 op-snap---monthly-publication-august-2025.pdf   890 2025-08 Car Vauxhall Insignia Black Driving without Due Care and Attention None M6 NB J6 M6 Northbound J6 Birmingham Birmingham Warning Letter N/A   52.676119 -2.0858425
2938 op-snap---monthly-publication-august-2025.pdf   913 2025-08 Car Audi Q4 Black Driving without Due Care and Attention None Trinity Road Trinity Road Birmingham Birmingham Warning Letter N/A   52.5812323 -1.8234706
2942 op-snap---monthly-publication-august-2025.pdf   917 2025-08 Pedal Bike Vauxhall Astra Grey Driving without Due Care and Attention None Langleys Road, Selly Oak Langleys Road, Selly Oak Birmingham Birmingham Warning Letter N/A   52.4358093 -1.9411176
2947 op-snap---monthly-publication-august-2025.pdf   922 2025-08 Car Audi A1 White Driving without Due Care and Attention None Snow Hill Snow Hill Birmingham Birmingham Warning Letter N/A   52.4825769 -1.897234
2969 op-snap---monthly-publication-august-2025.pdf   944 2025-08 Car Audi A3 White Driving without Due Care and Attention None Egghill Lane Egghill Lane Birmingham Birmingham Warning Letter N/A   52.4093768 -1.9976236
2985 op-snap---monthly-publication-august-2025.pdf   960 2025-08 Car Land Rover   Black Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A      
2993 op-snap---monthly-publication-august-2025.pdf   968 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Anderton Road Anderton Road Coventry Coventry Warning Letter N/A   52.4519205 -1.4736655
3000 op-snap---monthly-publication-august-2025.pdf   975 2025-08 Pedestrian Mercedes-Benz E200 White Driving without Due Care and Attention None M5 North M5 North Sandwell Sandwell Warning Letter N/A   52.5274455 -2.0298903
3023 op-snap---monthly-publication-august-2025.pdf   998 2025-08 Pedestrian BMW X3 White Driving without Due Care and Attention None Clapgate Lane Clapgate Lane Birmingham Birmingham Warning Letter N/A   52.4417035 -1.9902817
3035 op-snap---monthly-publication-august-2025.pdf   1010 2025-08 Car Volkswagen T Roc Black Driving without Due Care and Attention None Robert Street Robert Street Dudley Dudley Warning Letter N/A   52.5221845 -2.1196502
3037 op-snap---monthly-publication-august-2025.pdf   1012 2025-08 Car Audi A1 Blue Driving without Due Care and Attention None Stourbridge Ringroad Stourbridge Ringroad Dudley Dudley Warning Letter N/A      
3041 op-snap---monthly-publication-august-2025.pdf   1016 2025-08 Car Skoda Superb Grey Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
3044 op-snap---monthly-publication-august-2025.pdf   1019 2025-08 Car Audi Q2 Grey Driving without Due Care and Attention None Pritchatts Road Pritchatts Road Birmingham Birmingham Warning Letter N/A   52.4522304 -1.9267446
3051 op-snap---monthly-publication-august-2025.pdf   1026 2025-08 Car Dacia Jogger Grey Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
3073 op-snap---monthly-publication-august-2025.pdf   1048 2025-08 Car Nissan Micra White Driving without Due Care and Attention None B4101 Balsall Street Balsall Street Birmingham Birmingham Warning Letter N/A   52.4579985 -1.8916996
3087 op-snap---monthly-publication-august-2025.pdf   1062 2025-08 Pedestrian Audi E-tron Silver Driving without Due Care and Attention None Raynor Road Raynor Road Wolverhampton Wolverhampton Warning Letter N/A   52.6043868 -2.1046385
3091 op-snap---monthly-publication-august-2025.pdf   1066 2025-08 Car Ford Fiesta Silver Driving without Due Care and Attention None Longbridge Lane Longbridge Lane Birmingham Birmingham Warning Letter N/A   52.3962003 -1.9821252
3115 op-snap---monthly-publication-august-2025.pdf   1090 2025-08 Car Mercedes-Benz CLA 250 White Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
3117 op-snap---monthly-publication-august-2025.pdf   1092 2025-08 Pedal Bike Volkswagen Golf Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
3123 op-snap---monthly-publication-august-2025.pdf   1098 2025-08 Car Renault Clio Orange Driving without Due Care and Attention None Lodge Road, Winson Green Lodge Road, Winson Green Birmingham Birmingham Warning Letter N/A   52.4925309 -1.9177131
3144 op-snap---monthly-publication-august-2025.pdf   1119 2025-08 Car Toyota Sienta Black Driving without Due Care and Attention None Aldridge Bypass Aldridge Bypass Walsall Walsall Warning Letter N/A   52.6026073 -1.9200419
3162 op-snap---monthly-publication-august-2025.pdf   1137 2025-08 Pedestrian Hyundai I10 Blue Driving without Due Care and Attention None Chapel Lane Chapel Lane Birmingham Birmingham Warning Letter N/A   52.4409424 -1.9387702
3163 op-snap---monthly-publication-august-2025.pdf   1138 2025-08 Car Ford Transit White Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A   52.5083238 -1.8332287
3175 op-snap---monthly-publication-august-2025.pdf   1150 2025-08 Car BMW 1 series White Driving without Due Care and Attention None Silver Eagle Way Silver Eagle Way Coventry Coventry Warning Letter N/A      
3179 op-snap---monthly-publication-august-2025.pdf   1154 2025-08 Other Seat Ibiza Red Driving without Due Care and Attention None Tower Street Tower Street Dudley Dudley Warning Letter N/A   52.5112053 -2.0833165
3182 op-snap---monthly-publication-august-2025.pdf   1157 2025-08 Car Renault Trafic White Driving without Due Care and Attention None Silver Birch Avenue, Canley Silver Birch Avenue, Canley Coventry Coventry Warning Letter N/A   52.3954274 -1.5568965

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