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

150 rows where disposal = "Warning Letter", month = "2025-07" 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, second_offence, council_area_raw

vehicle_make >30

  • BMW 20
  • Ford 19
  • Mercedes-Benz 19
  • Volkswagen 14
  • Audi 11
  • Toyota 10
  • Vauxhall 10
  • Nissan 7
  • Kia 5
  • Land Rover 4
  • Citroen 3
  • Honda 3
  • Seat 3
  • Hyundai 2
  • Mazda 2
  • Renault 2
  • Skoda 2
  • Byd 1
  • Chevrolet 1
  • Chysler 1
  • Cupra 1
  • Dacia 1
  • Daf 1
  • Fiat 1
  • Mini 1
  • Mitsubishi 1
  • Peugeot 1
  • Scania 1
  • Suzuki 1
  • Tesla 1
  • …

council_area 10

  • Birmingham 76
  • Coventry 23
  • Walsall 9
  • Dudley 8
  • Metropolitan Borough Of Dudley 8
  • Sandwell 8
  • Wolverhampton 7
  • Solihull 6
  • Out of Force Area 3
  • Sutton Coldfield 2

reporter_transport_mode 5

  • Car 95
  • Pedal Bike 28
  • Pedestrian 17
  • Other 8
  • Motorbike 2

offence 1

  • Driving without Due Care and Attention · 150 ✖

month 1

  • 2025-07 · 150 ✖

disposal 1

  • Warning Letter · 150 ✖
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
11960 op-snap---monthly-publication-july-2025.pdf   12 2025-07 Pedal Bike Vauxhall Zafira Black Driving without Due Care and Attention None Bearwood Road Bearwood Road Birmingham Birmingham Warning Letter N/A   52.4762784 -1.9678366
11980 op-snap---monthly-publication-july-2025.pdf   32 2025-07 Car Mercedes-Benz A Class Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
12003 op-snap---monthly-publication-july-2025.pdf   55 2025-07 Car Audi A6 Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
12070 op-snap---monthly-publication-july-2025.pdf   122 2025-07 Car Ford Transit White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
12088 op-snap---monthly-publication-july-2025.pdf   140 2025-07 Car Nissan Qashqai Grey Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A   52.4816806 -1.8788939
12111 op-snap---monthly-publication-july-2025.pdf   163 2025-07 Car BMW 3 SERIES Grey Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Warning Letter N/A   52.5517052 -1.7825505
12164 op-snap---monthly-publication-july-2025.pdf   216 2025-07 Car Audi A4... Black Driving without Due Care and Attention None A452 Pype Hayes Pype Hayes Birmingham Birmingham Warning Letter N/A   52.5275673 -1.8101068
12178 op-snap---monthly-publication-july-2025.pdf   230 2025-07 Pedestrian Vauxhall Zafira Beige Driving without Due Care and Attention None Outside Coventry Market Outside Coventry Market Coventry Coventry Warning Letter N/A      
12198 op-snap---monthly-publication-july-2025.pdf   250 2025-07 Car BMW   Grey Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Warning Letter N/A   52.470423 -1.9304786
12213 op-snap---monthly-publication-july-2025.pdf   265 2025-07 Car BMW 318.. White Driving without Due Care and Attention None Bath Row Bath Row Birmingham Birmingham Warning Letter N/A   52.472238 -1.9127983
12219 op-snap---monthly-publication-july-2025.pdf   271 2025-07 Other BMW 330.. White Driving without Due Care and Attention None Waterfrnt Car Park Waterfrnt Car Park Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A      
12221 op-snap---monthly-publication-july-2025.pdf   273 2025-07 Car Nissan GT-R Blue Driving without Due Care and Attention None Rumbush Lane Rumbush Lane Birmingham Birmingham Warning Letter N/A      
12222 op-snap---monthly-publication-july-2025.pdf   274 2025-07 Car Mitsubishi Mirage White Driving without Due Care and Attention None St Mary's Row Street Mary's Row Birmingham Birmingham Warning Letter N/A      
12239 op-snap---monthly-publication-july-2025.pdf   291 2025-07 Car Toyota Prius Silver Driving without Due Care and Attention None Stafford Road Stafford Road Wolverhampton Wolverhampton Warning Letter N/A   52.6291998 -2.126312
12256 op-snap---monthly-publication-july-2025.pdf   308 2025-07 Motorbike Vauxhall Corsa Silver Driving without Due Care and Attention None New Cross Hospital New Cross Hospital Wolverhampton Wolverhampton Warning Letter N/A   52.6000052 -2.0954966
12270 op-snap---monthly-publication-july-2025.pdf   322 2025-07 Pedal Bike BMW 220i White Driving without Due Care and Attention None Woodbourne Road Woodbourne Road Birmingham Birmingham Warning Letter N/A   52.4702361 -1.951945
12277 op-snap---monthly-publication-july-2025.pdf   329 2025-07 Pedal Bike Audi RSQ8 Grey Driving without Due Care and Attention None Cornwall Street Cornwall Street Birmingham Birmingham Warning Letter N/A   52.4815054 -1.9032499
12302 op-snap---monthly-publication-july-2025.pdf   354 2025-07 Car Mercedes-Benz GLA Red Driving without Due Care and Attention None Stockfield Road Stockfield Road Birmingham Birmingham Warning Letter N/A   52.4519414 -1.831688
12303 op-snap---monthly-publication-july-2025.pdf   355 2025-07 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Warning Letter N/A   52.4555288 -1.8613929
12310 op-snap---monthly-publication-july-2025.pdf   362 2025-07 Car Toyota Corolla Blue Driving without Due Care and Attention None M5 Junction 1 Island M5 Junction 1 Island Sandwell Sandwell Warning Letter N/A      
12342 op-snap---monthly-publication-july-2025.pdf   394 2025-07 Car Chevrolet L200 Black Driving without Due Care and Attention None Alcester Road South Alcester Road South Birmingham Birmingham Warning Letter N/A   52.4170522 -1.8906187
12351 op-snap---monthly-publication-july-2025.pdf   403 2025-07 Car Volkswagen Polo Black Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Warning Letter N/A   52.4656414 -1.9852276
12359 op-snap---monthly-publication-july-2025.pdf   411 2025-07 Car Kia Proceed Blue Driving without Due Care and Attention None A435 (towards Brackenbury Road) A435 (towards Brackenbury Road) Sutton Coldfield Sutton Coldfield Warning Letter N/A      
12388 op-snap---monthly-publication-july-2025.pdf   440 2025-07 Car Volkswagen Amarok Blue Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
12390 op-snap---monthly-publication-july-2025.pdf   442 2025-07 Car Suzuki Swift Orange Driving without Due Care and Attention None York Road York Road Birmingham Birmingham Warning Letter N/A   52.5231321 -1.8415573
12392 op-snap---monthly-publication-july-2025.pdf   444 2025-07 Other Volkswagen Polo Blue Driving without Due Care and Attention None Arden Road Arden Road Birmingham Birmingham Warning Letter N/A   52.4515759 -1.8296192
12396 op-snap---monthly-publication-july-2025.pdf   448 2025-07 Other Seat Leon Black Driving without Due Care and Attention None Waterfront carpark 7 Waterfront carpark 7 Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A      
12397 op-snap---monthly-publication-july-2025.pdf   449 2025-07 Car Toyota CHR Silver Driving without Due Care and Attention None Brackenbury Road Brackenbury Road Birmingham Birmingham Warning Letter N/A   52.5407924 -1.8709807
12432 op-snap---monthly-publication-july-2025.pdf   484 2025-07 Car Mercedes-Benz A180 Grey Driving without Due Care and Attention None A458 Stourbridge Ring Road Stourbridge Ring Road Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.4590366 -2.1465735
12459 op-snap---monthly-publication-july-2025.pdf   511 2025-07 Pedal Bike Vauxhall Insignia White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
12477 op-snap---monthly-publication-july-2025.pdf   529 2025-07 Car Ford Kuga Silver Driving without Due Care and Attention None Oakenshaw Road Oakenshaw Road Solihull Solihull Warning Letter N/A   52.4017754 -1.8151522
12478 op-snap---monthly-publication-july-2025.pdf   530 2025-07 Car Mercedes-Benz A Green Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
12480 op-snap---monthly-publication-july-2025.pdf   532 2025-07 Car Ford Kuga White Driving without Due Care and Attention None Monument Road Monument Road Birmingham Birmingham Warning Letter N/A   52.4731312 -1.930947
12487 op-snap---monthly-publication-july-2025.pdf   539 2025-07 Other Honda C90MG Red Driving without Due Care and Attention None Bullring Sedgley Bullring Sedgley Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.5411442 -2.1221913
12505 op-snap---monthly-publication-july-2025.pdf   557 2025-07 Car Skoda Citigo Red Driving without Due Care and Attention None Stivichall Roundabout Stivichall Roundabout Coventry Coventry Warning Letter N/A   52.3776818 -1.4982138
12517 op-snap---monthly-publication-july-2025.pdf   569 2025-07 Pedal Bike Kia Sportage Silver Driving without Due Care and Attention None Talbot Street Talbot Street Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.4956227 -1.9324692
12522 op-snap---monthly-publication-july-2025.pdf   574 2025-07 Car Land Rover Vogue Black Driving without Due Care and Attention None Leighswood Road Leighswood Road Walsall Walsall Warning Letter N/A   52.6071662 -1.9231466
12533 op-snap---monthly-publication-july-2025.pdf   585 2025-07 Car Skoda Superb Silver Driving without Due Care and Attention None Bromford lane Bromford lane Birmingham Birmingham Warning Letter N/A   52.5083238 -1.8332287
12537 op-snap---monthly-publication-july-2025.pdf   589 2025-07 Car Ford Transit Grey Driving without Due Care and Attention None Wellington Road Wellington Road Walsall Walsall Warning Letter N/A   52.5676426 -1.9505165
12544 op-snap---monthly-publication-july-2025.pdf   596 2025-07 Car Audi A1 Beige Driving without Due Care and Attention None New John Street New John Street Birmingham Birmingham Warning Letter N/A   52.4920451 -1.8920402
12616 op-snap---monthly-publication-july-2025.pdf   668 2025-07 Car Mazda 2.. Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
12655 op-snap---monthly-publication-july-2025.pdf   707 2025-07 Car Audi A3 White Driving without Due Care and Attention None Moorend Avenue Moorend Avenue Birmingham Birmingham Warning Letter N/A      
12671 op-snap---monthly-publication-july-2025.pdf   723 2025-07 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Holbrook Lane Holbrook Lane Coventry Coventry Warning Letter N/A   52.436155 -1.5064002
12714 op-snap---monthly-publication-july-2025.pdf   766 2025-07 Pedal Bike Volkswagen Golf White Driving without Due Care and Attention None Wuchall Road Northfield Wuchall Road Northfield Birmingham Birmingham Warning Letter N/A      
12745 op-snap---monthly-publication-july-2025.pdf   797 2025-07 Car Volkswagen Golf GTI Blue Driving without Due Care and Attention None Kenrick Way Kenrick Way Sandwell Sandwell Warning Letter N/A   52.5079468 -1.9755194
12747 op-snap---monthly-publication-july-2025.pdf   799 2025-07 Pedal Bike Nissan Note Grey Driving without Due Care and Attention None Brierley Hill Road Brierley Hill Road Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.4811151 -2.1456435
12749 op-snap---monthly-publication-july-2025.pdf   801 2025-07 Car Mercedes-Benz Splinter Red Driving without Due Care and Attention None Water Orton Road Water Orton Road Birmingham Birmingham Warning Letter N/A   52.5153394 -1.7573409
12766 op-snap---monthly-publication-july-2025.pdf   818 2025-07 Pedal Bike Mercedes-Benz CLA Grey Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull Warning Letter N/A   52.4191184 -1.8326637
12789 op-snap---monthly-publication-july-2025.pdf   841 2025-07 Car BMW X4.. Grey Driving without Due Care and Attention None M6 Jct 10 M6 Junction 10 Walsall Walsall Warning Letter N/A   52.676119 -2.0858425
12791 op-snap---monthly-publication-july-2025.pdf   843 2025-07 Other BMW 135.. Blue Driving without Due Care and Attention None Beacon Park Farm Beacon Park Farm Walsall Walsall Warning Letter N/A      
12806 op-snap---monthly-publication-july-2025.pdf   858 2025-07 Other BMW 116.. Black Driving without Due Care and Attention None Waterfront Way Waterfront Way Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.5846796 -1.9935385
12852 op-snap---monthly-publication-july-2025.pdf   904 2025-07 Car Ford Transit White Driving without Due Care and Attention None Tysley Hill Rd Tysley Hill Road Birmingham Birmingham Warning Letter N/A      
12880 op-snap---monthly-publication-july-2025.pdf   932 2025-07 Car Volvo Bus Red Driving without Due Care and Attention None Dudley Road, Tipton Dudley Road, Tipton Sandwell Sandwell Warning Letter N/A   52.5238596 -2.0740455
12881 op-snap---monthly-publication-july-2025.pdf   933 2025-07 Car Toyota Yaris Red Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
12913 op-snap---monthly-publication-july-2025.pdf   965 2025-07 Car BMW X2 Black Driving without Due Care and Attention None Valbourne Road Valbourne Road Birmingham Birmingham Warning Letter N/A   52.4165707 -1.9062691
12939 op-snap---monthly-publication-july-2025.pdf   991 2025-07 Car Audi A3 Black Driving without Due Care and Attention None Kelsley Lane Kelsley Lane Solihull Solihull Warning Letter N/A      
13024 op-snap---monthly-publication-july-2025.pdf   1076 2025-07 Pedal Bike Toyota Auris Silver Driving without Due Care and Attention None Darlsaton Road (Wednesbury) Darlsaton Road (Wednesbury) Sandwell Sandwell Warning Letter N/A      
13042 op-snap---monthly-publication-july-2025.pdf   1094 2025-07 Car Mercedes-Benz C 220 Black Driving without Due Care and Attention None M6 North M6 North Birmingham Birmingham Warning Letter N/A   52.5143137 -1.7683873
13053 op-snap---monthly-publication-july-2025.pdf   1105 2025-07 Other Ford Focus Blue Driving without Due Care and Attention None Waterfront Way Car park 7 Waterfront Way Car park 7 Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A      
13080 op-snap---monthly-publication-july-2025.pdf   1132 2025-07 Pedal Bike Fiat Spider Blue Driving without Due Care and Attention None War lane War lane Birmingham Birmingham Warning Letter N/A   52.4569552 -1.9616483
13081 op-snap---monthly-publication-july-2025.pdf   1133 2025-07 Pedal Bike Peugeot van White Driving without Due Care and Attention None War lane War lane Birmingham Birmingham Warning Letter N/A   52.4569552 -1.9616483
13085 op-snap---monthly-publication-july-2025.pdf   1137 2025-07 Car Mercedes-Benz   Silver Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry Warning Letter N/A   52.4235908 -1.5226276
13159 op-snap---monthly-publication-july-2025.pdf   1211 2025-07 Car BMW   Grey Driving without Due Care and Attention None Dartmouth Circus Dartmouth Circus Birmingham Birmingham Warning Letter N/A   52.4926487 -1.8879638
13167 op-snap---monthly-publication-july-2025.pdf   1219 2025-07 Pedal Bike Land Rover Defender Green Driving without Due Care and Attention None Lavender Hall Lane Lavender Hall Lane Coventry Coventry Warning Letter N/A      
13168 op-snap---monthly-publication-july-2025.pdf   1220 2025-07 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Lavender Hall Lane Lavender Hall Lane Coventry Coventry Warning Letter N/A      
13198 op-snap---monthly-publication-july-2025.pdf   1250 2025-07 Car Scania Tractor White Driving without Due Care and Attention None Toll Bar End Toll Bar End Coventry Coventry Warning Letter N/A   52.377406 -1.4651313
13224 op-snap---monthly-publication-july-2025.pdf   1276 2025-07 Car BMW 218i White Driving without Due Care and Attention None A45 A45 Coventry Coventry Warning Letter N/A      
13229 op-snap---monthly-publication-july-2025.pdf   1281 2025-07 Car Audi S4 Black Driving without Due Care and Attention None Kingston Road Kingston Road Birmingham Birmingham Warning Letter N/A   52.4747333 -1.8728345
13232 op-snap---monthly-publication-july-2025.pdf   1284 2025-07 Car Mercedes-Benz C220 Black Driving without Due Care and Attention None A45 Smallheath Highway Smallheath Highway Birmingham Birmingham Warning Letter N/A      
13233 op-snap---monthly-publication-july-2025.pdf   1285 2025-07 Car Renault Megane Silver Driving without Due Care and Attention None A45 Smallheath Highway Smallheath Highway Birmingham Birmingham Warning Letter N/A      
13246 op-snap---monthly-publication-july-2025.pdf   1298 2025-07 Car Cupra Born ev Grey Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham Warning Letter N/A   52.505832 -1.92002
13249 op-snap---monthly-publication-july-2025.pdf   1301 2025-07 Car Dacia Sandero White Driving without Due Care and Attention None A45 Sir Henry Parkes Road Sir Henry Parkes Road Coventry Coventry Warning Letter N/A   52.3900568 -1.5550766
13253 op-snap---monthly-publication-july-2025.pdf   1305 2025-07 Car Seat Leon Black Driving without Due Care and Attention None Allman Road at Holly Lane Allman Road at Holly Lane Birmingham Birmingham Warning Letter N/A   52.5227985 -1.8270199
13310 op-snap---monthly-publication-july-2025.pdf   1362 2025-07 Pedestrian Ford Focus Silver Driving without Due Care and Attention None Waterfront Way, Dudley Waterfront Way, Dudley Dudley Dudley Warning Letter N/A   52.4880905 -2.1164794
13319 op-snap---monthly-publication-july-2025.pdf   1371 2025-07 Pedal Bike Mercedes-Benz GLE Green Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13321 op-snap---monthly-publication-july-2025.pdf   1373 2025-07 Car BMW 520D Blue Driving without Due Care and Attention None M42 Northbound M42 Northbound Birmingham Birmingham Warning Letter N/A      
13323 op-snap---monthly-publication-july-2025.pdf   1375 2025-07 Pedal Bike Daf Tipper Blue Driving without Due Care and Attention None Stoney Stanton Lane Stoney Stanton Lane Coventry Coventry Warning Letter N/A   52.4211068 -1.4966527
13325 op-snap---monthly-publication-july-2025.pdf   1377 2025-07 Pedal Bike Mercedes-Benz Coach White Driving without Due Care and Attention None Stoney Stanton Lane Stoney Stanton Lane Coventry Coventry Warning Letter N/A   52.4211068 -1.4966527
13330 op-snap---monthly-publication-july-2025.pdf   1382 2025-07 Car Toyota Proace White Driving without Due Care and Attention None M6 North M6 North Birmingham Birmingham Warning Letter N/A   52.5143137 -1.7683873
13336 op-snap---monthly-publication-july-2025.pdf   1388 2025-07 Car Byd Seal Grey Driving without Due Care and Attention None Upper Holland Road Upper Holland Road Birmingham Birmingham Warning Letter N/A   52.561 -1.8187105
13382 op-snap---monthly-publication-july-2025.pdf   1434 2025-07 Car Volkswagen caddy White Driving without Due Care and Attention None worcester road Worcester Road Out of Force Area Out of Force Area Warning Letter N/A   52.5860898 -2.0339138
13401 op-snap---monthly-publication-july-2025.pdf   1453 2025-07 Car Volkswagen Golf Blue Driving without Due Care and Attention None Cooks Lane Cooks Lane Birmingham Birmingham Warning Letter N/A   52.482758 -1.7603097
13410 op-snap---monthly-publication-july-2025.pdf   1462 2025-07 Car Citroen C4 Blue Driving without Due Care and Attention None Cheveral Avenue Cheveral Avenue Coventry Coventry Warning Letter N/A   52.4257402 -1.5185037
13419 op-snap---monthly-publication-july-2025.pdf   1471 2025-07 Car BMW 730 Beige Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Warning Letter N/A   52.4103191 -1.8670224
13432 op-snap---monthly-publication-july-2025.pdf   1484 2025-07 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Blackford Road Blackford Road Solihull Solihull Warning Letter N/A   52.3971653 -1.8189489
13438 op-snap---monthly-publication-july-2025.pdf   1490 2025-07 Other Honda Civic Black Driving without Due Care and Attention None Lozells Street Lozells Street Birmingham Birmingham Warning Letter N/A   52.5007454 -1.9067107
13470 op-snap---monthly-publication-july-2025.pdf   1522 2025-07 Pedestrian Ford Fiesta Black Driving without Due Care and Attention None Regent Place Regent Place Birmingham Birmingham Warning Letter N/A   52.4860376 -1.9095854
13534 op-snap---monthly-publication-july-2025.pdf   1586 2025-07 Car Nissan note silver Driving without Due Care and Attention None Russel Road Russel Road Wolverhampton Wolverhampton Warning Letter N/A      
13536 op-snap---monthly-publication-july-2025.pdf   1588 2025-07 Pedestrian Ford focus Silver Driving without Due Care and Attention None Falstaff road Falstaff road Solihull Solihull Warning Letter N/A   52.4042425 -1.8243195
13556 op-snap---monthly-publication-july-2025.pdf   1608 2025-07 Car Kia Sportage Silver Driving without Due Care and Attention None Lombard Street Lombard Street Birmingham Birmingham Warning Letter N/A   52.4707728 -1.8872607
13569 op-snap---monthly-publication-july-2025.pdf   1621 2025-07 Car Ford Focus Black Driving without Due Care and Attention None Express Way, West Brom Express Way, West Brom Sandwell Sandwell Warning Letter N/A      
13572 op-snap---monthly-publication-july-2025.pdf   1624 2025-07 Car Kia Rio White Driving without Due Care and Attention None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley Warning Letter N/A   52.4590366 -2.1465735
13574 op-snap---monthly-publication-july-2025.pdf   1626 2025-07 Car BMW 320D White Driving without Due Care and Attention None Birmingham Road Birmingham Road Birmingham Birmingham Warning Letter N/A   52.5505398 -1.8252993
13604 op-snap---monthly-publication-july-2025.pdf   1656 2025-07 Pedal Bike Volkswagen GOLF Blue Driving without Due Care and Attention None Station Road Station Road Birmingham Birmingham Warning Letter N/A   52.5054559 -1.9506109
13610 op-snap---monthly-publication-july-2025.pdf   1662 2025-07 Car Mercedes-Benz A class Silver Driving without Due Care and Attention None M40 M40 Out of Force Area Out of Force Area Warning Letter N/A      
13651 op-snap---monthly-publication-july-2025.pdf   1703 2025-07 Car Volkswagen Fox Black Driving without Due Care and Attention None High Street, Dudley High Street, Dudley Dudley Dudley Warning Letter N/A   52.4503499 -2.0504997
13662 op-snap---monthly-publication-july-2025.pdf   1714 2025-07 Pedestrian Ford Focus Blue Driving without Due Care and Attention none Tower Street Tower Street Dudley Dudley Warning Letter N/A   52.5112053 -2.0833165
13663 op-snap---monthly-publication-july-2025.pdf   1715 2025-07 Pedestrian Chysler Grand yVoyager Silver Driving without Due Care and Attention None School Road School Road Birmingham Birmingham Warning Letter N/A   52.4161736 -1.8619692
13681 op-snap---monthly-publication-july-2025.pdf   1733 2025-07 Pedestrian Hyundai Kona Grey Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Warning Letter N/A   52.4831397 -2.1309273
13685 op-snap---monthly-publication-july-2025.pdf   1737 2025-07 Car Tesla Model 3 Red Driving without Due Care and Attention None Birmingham road Birmingham road Birmingham Birmingham Warning Letter N/A   52.5505398 -1.8252993

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