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

103 rows where disposal = "Warning Letter", month = "2025-06" 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 20

  • Audi 14
  • BMW 14
  • Ford 13
  • Mercedes-Benz 12
  • Seat 7
  • Volkswagen 7
  • Toyota 6
  • Kia 4
  • Land Rover 4
  • Renault 4
  • Vauxhall 4
  • Honda 2
  • Mini 2
  • Skoda 2
  • Fiat 1
  • Hyundai 1
  • Iveco 1
  • Lexus 1
  • Peugeot 1
  • Suzuki 1

council_area 9

  • Birmingham 57
  • Solihull 9
  • Metropolitan Borough 6
  • Sandwell 6
  • Walsall 6
  • Wolverhampton 6
  • Coventry 5
  • Dudley 4
  • Sutton Coldfield 4

reporter_transport_mode 5

  • Car 67
  • Pedal Bike 25
  • Pedestrian 5
  • Other 4
  • Motorbike 2

offence 1

  • Driving without Due Care and Attention · 103 ✖

month 1

  • 2025-06 · 103 ✖

disposal 1

  • Warning Letter · 103 ✖
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
14072 op-snap---monthly-publication-june-2025.pdf   1 2025-06 Pedestrian Seat Leon Grey Driving without Due Care and Attention None Cotterills Road Cotterills Road Birmingham Birmingham Warning Letter N/A      
14100 op-snap---monthly-publication-june-2025.pdf   29 2025-06 Car BMW X6 White Driving without Due Care and Attention None Rowleys Green Roundabout Rowleys Green Roundabout Coventry Coventry Warning Letter N/A   52.4486967 -1.4991069
14119 op-snap---monthly-publication-june-2025.pdf   48 2025-06 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Warning Letter N/A   52.4718503 -1.9195423
14171 op-snap---monthly-publication-june-2025.pdf   100 2025-06 Pedestrian Toyota Aygo White Driving without Due Care and Attention None Spouthouse Lane at Old Walsall Road Spouthouse Lane at Old Walsall Road Birmingham Birmingham Warning Letter N/A   52.5390972 -1.9319478
14173 op-snap---monthly-publication-june-2025.pdf   102 2025-06 Pedestrian Kia Picanto Red Driving without Due Care and Attention None Spouthouse Lane at Old Walsall Road Spouthouse Lane at Old Walsall Road Birmingham Birmingham Warning Letter N/A   52.5390972 -1.9319478
14176 op-snap---monthly-publication-june-2025.pdf   105 2025-06 Car Audi RS 3.. Grey Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
14190 op-snap---monthly-publication-june-2025.pdf   119 2025-06 Car BMW X3 Black Driving without Due Care and Attention None Ebrook Road Ebrook Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5557273 -1.8159805
14203 op-snap---monthly-publication-june-2025.pdf   132 2025-06 Car BMW 440i Blue Driving without Due Care and Attention None Warwick Road Warwick Road Solihull Solihull Warning Letter N/A   52.4428606 -1.812114
14211 op-snap---monthly-publication-june-2025.pdf   140 2025-06 Car Ford Transit White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
14216 op-snap---monthly-publication-june-2025.pdf   145 2025-06 Pedal Bike Ford fiesta Black Driving without Due Care and Attention None The Broadway The Broadway Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5108588 -1.8919435
14217 op-snap---monthly-publication-june-2025.pdf   146 2025-06 Car Audi A3 Grey Driving without Due Care and Attention None Stonebridge Island Stonebridge Island Coventry Coventry Warning Letter N/A   52.4459998 -1.6949291
14220 op-snap---monthly-publication-june-2025.pdf   149 2025-06 Motorbike Seat Cupra Black Driving without Due Care and Attention None Station Road, Rowley Regis Station Road, Rowley Regis Sandwell Sandwell Warning Letter N/A   52.4712548 -2.0554193
14233 op-snap---monthly-publication-june-2025.pdf   162 2025-06 Car Mercedes-Benz A35 Black Driving without Due Care and Attention None Moseley Road Moseley Road Wolverhampton Wolverhampton Warning Letter N/A   52.5782924 -2.0742911
14286 op-snap---monthly-publication-june-2025.pdf   215 2025-06 Pedal Bike Volkswagen Sharan Silver Driving without Due Care and Attention None Old Dickens Heath Road Old Dickens Heath Road Solihull Solihull Warning Letter N/A   52.3864791 -1.8355922
14288 op-snap---monthly-publication-june-2025.pdf   217 2025-06 Pedal Bike Honda E Black Driving without Due Care and Attention None Cliff Rock Road Cliff Rock Road Birmingham Birmingham Warning Letter N/A   52.3937169 -2.0011078
14325 op-snap---monthly-publication-june-2025.pdf   254 2025-06 Car Honda Civic Blue Driving without Due Care and Attention None Dingle Lane Dingle Lane Solihull Solihull Warning Letter N/A   52.4044204 -1.7965379
14357 op-snap---monthly-publication-june-2025.pdf   286 2025-06 Car Audi A1 Blue Driving without Due Care and Attention None M6 Motorway to Salford Circus M6 Motorway to Salford Circus Birmingham Birmingham Warning Letter N/A      
14389 op-snap---monthly-publication-june-2025.pdf   318 2025-06 Car BMW 118i White Driving without Due Care and Attention None McKean Road Mc Kean Road Sandwell Sandwell Warning Letter N/A   52.5077405 -2.0124813
14392 op-snap---monthly-publication-june-2025.pdf   321 2025-06 Car Renault Traffic Black Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall Warning Letter N/A   52.5692139 -1.8799672
14394 op-snap---monthly-publication-june-2025.pdf   323 2025-06 Car Skoda Enyaq Grey Driving without Due Care and Attention None Romney Way Romney Way Birmingham Birmingham Warning Letter N/A      
14403 op-snap---monthly-publication-june-2025.pdf   332 2025-06 Car Mercedes-Benz Vito White Driving without Due Care and Attention None Thornton Road Thornton Road Wolverhampton Wolverhampton Warning Letter N/A   52.5798636 -2.0917141
14413 op-snap---monthly-publication-june-2025.pdf   342 2025-06 Car Land Rover Evoque White Driving without Due Care and Attention None Cot Lane Cot Lane Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.4939289 -2.1730601
14444 op-snap---monthly-publication-june-2025.pdf   373 2025-06 Car BMW X3 Grey Driving without Due Care and Attention None Barnes Hill Barnes Hill Birmingham Birmingham Warning Letter N/A   52.4401325 -1.9785938
14447 op-snap---monthly-publication-june-2025.pdf   376 2025-06 Car Land Rover Range Rover Black Driving without Due Care and Attention None Quinton Expressway Quinton Expressway Birmingham Birmingham Warning Letter N/A   52.4491086 -2.0131915
14462 op-snap---monthly-publication-june-2025.pdf   391 2025-06 Car Audi Q5 White Driving without Due Care and Attention None Old church road Old church road Birmingham Birmingham Warning Letter N/A   52.4529004 -1.9554069
14468 op-snap---monthly-publication-june-2025.pdf   397 2025-06 Car Audi TT Grey Driving without Due Care and Attention None Bekgrave Middleway Belgrave Middleway Birmingham Birmingham Warning Letter N/A   52.4668753 -1.8996143
14473 op-snap---monthly-publication-june-2025.pdf   402 2025-06 Car Ford Focus Blue Driving without Due Care and Attention None Old Walsall Road Old Walsall Road Birmingham Birmingham Warning Letter N/A   52.5294399 -1.9282714
14475 op-snap---monthly-publication-june-2025.pdf   404 2025-06 Car Vauxhall Corsa Red Driving without Due Care and Attention None Swan Islan Swan Islan Sandwell Sandwell Warning Letter N/A      
14480 op-snap---monthly-publication-june-2025.pdf   409 2025-06 Pedal Bike Vauxhall Vivaro White Driving without Due Care and Attention None Alwod Road Alwod Road Birmingham Birmingham Warning Letter N/A      
14527 op-snap---monthly-publication-june-2025.pdf   456 2025-06 Pedal Bike Audi A6 Black Driving without Due Care and Attention None Gibbet Hill Road Gibbet Hill Road Coventry Coventry Warning Letter N/A   52.3749141 -1.5564977
14554 op-snap---monthly-publication-june-2025.pdf   483 2025-06 Car Kia Niro White Driving without Due Care and Attention None Expressway Expressway Sandwell Sandwell Warning Letter N/A   52.5256969 -2.004455
14559 op-snap---monthly-publication-june-2025.pdf   488 2025-06 Motorbike Audi A6 Black Driving without Due Care and Attention None A45 Small Heath Highway Small Heath Highway Birmingham Birmingham Warning Letter N/A   52.4709298 -1.8722585
14714 op-snap---monthly-publication-june-2025.pdf   643 2025-06 Car Mercedes-Benz Sprinter Yellow Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
14728 op-snap---monthly-publication-june-2025.pdf   657 2025-06 Car Renault Captur Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
14762 op-snap---monthly-publication-june-2025.pdf   691 2025-06 Pedal Bike Audi Q5 Black Driving without Due Care and Attention None Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
14767 op-snap---monthly-publication-june-2025.pdf   696 2025-06 Car Ford Transit White Driving without Due Care and Attention None Bath Road, Stourbridge Bath Road, Stourbridge Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.4591918 -2.1497211
14774 op-snap---monthly-publication-june-2025.pdf   703 2025-06 Car Ford Kuga White Driving without Due Care and Attention None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham Warning Letter N/A      
14785 op-snap---monthly-publication-june-2025.pdf   714 2025-06 Pedal Bike Seat Cupra Born Grey Driving without Due Care and Attention None Webster Way Webster Way Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5445328 -1.7884784
14804 op-snap---monthly-publication-june-2025.pdf   733 2025-06 Car Audi A6 Black Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull Warning Letter N/A   52.4144779 -1.7848758
14806 op-snap---monthly-publication-june-2025.pdf   735 2025-06 Pedal Bike Mercedes-Benz E220 White Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Warning Letter N/A   52.4718503 -1.9195423
14820 op-snap---monthly-publication-june-2025.pdf   749 2025-06 Car Audi Q4 Silver Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Solihull Solihull Warning Letter N/A   52.4322443 -1.6746508
14822 op-snap---monthly-publication-june-2025.pdf   751 2025-06 Car Toyota Aygo Red Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
14839 op-snap---monthly-publication-june-2025.pdf   768 2025-06 Car Audi A4 Grey Driving without Due Care and Attention None Greaves Avenue Greaves Avenue Walsall Walsall Warning Letter N/A   52.5773135 -1.9525262
14848 op-snap---monthly-publication-june-2025.pdf   777 2025-06 Car BMW 520e Silver Driving without Due Care and Attention None Church Road Church Road Birmingham Birmingham Warning Letter N/A   52.4624743 -1.7763934
14852 op-snap---monthly-publication-june-2025.pdf   781 2025-06 Car Mercedes-Benz GLC 220 Blue Driving without Due Care and Attention None Grange Road Grange Road Birmingham Birmingham Warning Letter N/A   52.5065077 -1.892207
14859 op-snap---monthly-publication-june-2025.pdf   788 2025-06 Car Seat Leon White Driving without Due Care and Attention None Rednal Road Rednal Road Birmingham Birmingham Warning Letter N/A   52.4033763 -1.9367704
14870 op-snap---monthly-publication-june-2025.pdf   799 2025-06 Car BMW 530d Grey Driving without Due Care and Attention None Monkspath Hall Road Monkspath Hall Road Solihull Solihull Warning Letter N/A   52.3900358 -1.8026595
14887 op-snap---monthly-publication-june-2025.pdf   816 2025-06 Car Volkswagen Golf White Driving without Due Care and Attention None M6SB M6Sb Birmingham Birmingham Warning Letter N/A      
14900 op-snap---monthly-publication-june-2025.pdf   829 2025-06 Car Peugeot 3008 Blue Driving without Due Care and Attention None Netherwood Lane Netherwood Lane Solihull Solihull Warning Letter N/A   52.3572751 -1.7083402
14917 op-snap---monthly-publication-june-2025.pdf   846 2025-06 Car Volkswagen XC40 Black Driving without Due Care and Attention None Wellington Place Wellington Place Wolverhampton Wolverhampton Warning Letter N/A      
14924 op-snap---monthly-publication-june-2025.pdf   853 2025-06 Pedal Bike Seat Ibiza Blue Driving without Due Care and Attention none Salisbury Road Salisbury Road Birmingham Birmingham Warning Letter N/A   52.4943878 -1.8504211
15016 op-snap---monthly-publication-june-2025.pdf   945 2025-06 Car Hyundai IX35 Grey Driving without Due Care and Attention None Alcester Road South Alcester Road South Birmingham Birmingham Warning Letter N/A   52.4170522 -1.8906187
15052 op-snap---monthly-publication-june-2025.pdf   981 2025-06 Pedal Bike Suzuki Ignis White Driving without Due Care and Attention None Herald Avenue Herald Avenue Coventry Coventry Warning Letter N/A   52.4029059 -1.5541193
15061 op-snap---monthly-publication-june-2025.pdf   990 2025-06 Car Vauxhall Mokka Green Driving without Due Care and Attention None Perry Common Road Perry Common Road Birmingham Birmingham Warning Letter N/A   52.533472 -1.8676846
15078 op-snap---monthly-publication-june-2025.pdf   1007 2025-06 Car Lexus IS200 Black Driving without Due Care and Attention None Alma Street Alma Street Birmingham Birmingham Warning Letter N/A   52.4977617 -1.8973363
15122 op-snap---monthly-publication-june-2025.pdf   1051 2025-06 Car Mercedes-Benz CLA Black Driving without Due Care and Attention None M5 J2 M5 J2 Sandwell Sandwell Warning Letter N/A   52.4945433 -2.0190848
15148 op-snap---monthly-publication-june-2025.pdf   1077 2025-06 Car Audi A3 White Driving without Due Care and Attention None A452 A452 Birmingham Birmingham Warning Letter N/A      
15161 op-snap---monthly-publication-june-2025.pdf   1090 2025-06 Pedal Bike Kia Ceed Red Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
15175 op-snap---monthly-publication-june-2025.pdf   1104 2025-06 Car Ford Fiesta Blue Driving without Due Care and Attention None Cotterills Lane Cotterills Lane Birmingham Birmingham Warning Letter N/A   52.4884297 -1.817811
15186 op-snap---monthly-publication-june-2025.pdf   1115 2025-06 Car Ford Mustang Grey Driving without Due Care and Attention None Ducan Edward Way Ducan Edward Way Metropolitan Borough Metropolitan Borough Warning Letter N/A      
15189 op-snap---monthly-publication-june-2025.pdf   1118 2025-06 Car BMW 1 Series Red Driving without Due Care and Attention None Arden Road Arden Road Birmingham Birmingham Warning Letter N/A   52.4515759 -1.8296192
15192 op-snap---monthly-publication-june-2025.pdf   1121 2025-06 Car BMW 320 D White Driving without Due Care and Attention None Arden Road Arden Road Birmingham Birmingham Warning Letter N/A   52.4515759 -1.8296192
15224 op-snap---monthly-publication-june-2025.pdf   1153 2025-06 Pedal Bike Fiat Panda Grey Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Warning Letter N/A   52.4415108 -1.8971434
15248 op-snap---monthly-publication-june-2025.pdf   1177 2025-06 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Tessall Lane Tessall Lane Birmingham Birmingham Warning Letter N/A   52.4045186 -1.9891793
15251 op-snap---monthly-publication-june-2025.pdf   1180 2025-06 Pedal Bike Volkswagen Tiguan Black Driving without Due Care and Attention None Bells Lane Bells Lane Birmingham Birmingham Warning Letter N/A   52.4053419 -1.8944602
15252 op-snap---monthly-publication-june-2025.pdf   1181 2025-06 Pedal Bike Seat Cupra Grey Driving without Due Care and Attention None Brandwood Road Brandwood Road Birmingham Birmingham Warning Letter N/A   52.4139427 -1.9037653
15263 op-snap---monthly-publication-june-2025.pdf   1192 2025-06 Car Kia Rio Red Driving without Due Care and Attention None Waddensbrook Lane Waddensbrook Lane Walsall Walsall Warning Letter N/A      
15267 op-snap---monthly-publication-june-2025.pdf   1196 2025-06 Car BMW 520d Gold Driving without Due Care and Attention None Pleck Road Pleck Road Walsall Walsall Warning Letter N/A   52.5827033 -1.9960274
15273 op-snap---monthly-publication-june-2025.pdf   1202 2025-06 Pedal Bike Renault Megane Red Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
15286 op-snap---monthly-publication-june-2025.pdf   1215 2025-06 Car BMW 420d Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
15303 op-snap---monthly-publication-june-2025.pdf   1232 2025-06 Car   ENVIRO Black Driving without Due Care and Attention None Merritts Hill Merritts Hill Birmingham Birmingham Warning Letter N/A   52.424853 -1.9814275
15429 op-snap---monthly-publication-june-2025.pdf   1358 2025-06 Pedal Bike Mercedes-Benz A45 Black Driving without Due Care and Attention None A429 Kenilworth Road Kenilworth Road Coventry Coventry Warning Letter N/A   52.3833298 -1.5379214
15449 op-snap---monthly-publication-june-2025.pdf   1378 2025-06 Car BMW X1 Grey Driving without Due Care and Attention None Gravelly Hill Gravelly Hill Birmingham Birmingham Warning Letter N/A   52.5153884 -1.8527437
15453 op-snap---monthly-publication-june-2025.pdf   1382 2025-06 Pedal Bike Seat Cupra Grey Driving without Due Care and Attention None Hagley Road Hagley Road Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.4719358 -1.9341335
15460 op-snap---monthly-publication-june-2025.pdf   1389 2025-06 Car Skoda Fabia White Driving without Due Care and Attention None Albert Road Albert Road Birmingham Birmingham Warning Letter N/A   52.4854338 -1.8140135
15506 op-snap---monthly-publication-june-2025.pdf   1435 2025-06 Car Renault Traffic White Driving without Due Care and Attention None Holly Lane Holly Lane Sandwell Sandwell Warning Letter N/A   52.4992354 -1.9835418
15508 op-snap---monthly-publication-june-2025.pdf   1437 2025-06 Car Land Rover Range Rover White Driving without Due Care and Attention None Birmingham Road Birmingham Road Birmingham Birmingham Warning Letter N/A   52.5505398 -1.8252993
15511 op-snap---monthly-publication-june-2025.pdf   1440 2025-06 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None A34 A34 Birmingham Birmingham Warning Letter N/A      
15513 op-snap---monthly-publication-june-2025.pdf   1442 2025-06 Pedal Bike   Dennis Grey Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
15546 op-snap---monthly-publication-june-2025.pdf   1475 2025-06 Pedal Bike Ford Galaxy Silver Driving without Due Care and Attention None Gillhurst Road Gillhurst Road Birmingham Birmingham Warning Letter N/A   52.467676 -1.9548345
15565 op-snap---monthly-publication-june-2025.pdf   1494 2025-06 Other Volkswagen Polo Blue Driving without Due Care and Attention None Waterfront car park Waterfront car park Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5859649 -1.9882444
15567 op-snap---monthly-publication-june-2025.pdf   1496 2025-06 Car Audi A4 White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
15573 op-snap---monthly-publication-june-2025.pdf   1502 2025-06 Car Toyota Auris Silver Driving without Due Care and Attention None Balsall Street East Balsall Street East Solihull Solihull Warning Letter N/A   52.3854087 -1.6550831
15626 op-snap---monthly-publication-june-2025.pdf   1555 2025-06 Pedal Bike Mercedes-Benz A class White Driving without Due Care and Attention None Frankley Road Frankley Road Birmingham Birmingham Warning Letter N/A   52.4119312 -1.9753363
15666 op-snap---monthly-publication-june-2025.pdf   1595 2025-06 Car Volkswagen Golf Blue Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
15670 op-snap---monthly-publication-june-2025.pdf   1599 2025-06 Car Volkswagen Passat White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
15688 op-snap---monthly-publication-june-2025.pdf   1617 2025-06 Car Mercedes-Benz A180 Silver Driving without Due Care and Attention None M6 NB J6 M6 Northbound J6 Birmingham Birmingham Warning Letter N/A   52.676119 -2.0858425
15713 op-snap---monthly-publication-june-2025.pdf   1642 2025-06 Car Mini Countryman Grey Driving without Due Care and Attention None Monmouth Drive Monmouth Drive Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5575249 -1.8640053
15714 op-snap---monthly-publication-june-2025.pdf   1643 2025-06 Pedal Bike Audi Q8 Grey Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Warning Letter N/A   52.4718503 -1.9195423
15732 op-snap---monthly-publication-june-2025.pdf   1661 2025-06 Pedal Bike Mercedes-Benz GLC Black Driving without Due Care and Attention None New John St West New John Street West Birmingham Birmingham Warning Letter N/A   52.4944784 -1.9122329
16089 op-snap---monthly-publication-june-2025.pdf   2018 2025-06 Pedestrian Iveco Daily White Driving without Due Care and Attention None Steelpark Way Steelpark Way Walsall Walsall Warning Letter N/A      
16094 op-snap---monthly-publication-june-2025.pdf   2023 2025-06 Car Ford Kuga Grey Driving without Due Care and Attention None Long Mill South Long Mill South Wolverhampton Wolverhampton Warning Letter N/A   52.6095019 -2.0915196
16098 op-snap---monthly-publication-june-2025.pdf   2027 2025-06 Car Ford Focus Black Driving without Due Care and Attention None M6 Southbound, Junction 9 M6 Southbound, Junction 9 Walsall Walsall Warning Letter N/A   52.676119 -2.0858425
16099 op-snap---monthly-publication-june-2025.pdf   2028 2025-06 Car Ford Fiesta Black Driving without Due Care and Attention None M6 Southbound, Junction 8 M6 Southbound, Junction 8 Birmingham Birmingham Warning Letter N/A   52.6760749 -2.0862582
16104 op-snap---monthly-publication-june-2025.pdf   2033 2025-06 Car Mini Countryman Silver Driving without Due Care and Attention None Long Mill South Long Mill South Wolverhampton Wolverhampton Warning Letter N/A   52.6095019 -2.0915196
16105 op-snap---monthly-publication-june-2025.pdf   2034 2025-06 Car Toyota Prius White Driving without Due Care and Attention None Long Mill South Long Mill South Wolverhampton Wolverhampton Warning Letter N/A   52.6095019 -2.0915196
16119 op-snap---monthly-publication-june-2025.pdf   2048 2025-06 Car Toyota Prius Purple Driving without Due Care and Attention None Medley Road Medley Road Birmingham Birmingham Warning Letter N/A   52.4555602 -1.859382
16160 op-snap---monthly-publication-june-2025.pdf   2089 2025-06 Car Vauxhall Zafira Blue Driving without Due Care and Attention None Birmingham Road Birmingham Road Birmingham Birmingham Warning Letter N/A   52.5505398 -1.8252993
16178 op-snap---monthly-publication-june-2025.pdf   2107 2025-06 Other BMW 320 White Driving without Due Care and Attention None Tower Street Tower Street Dudley Dudley Warning Letter N/A   52.5112053 -2.0833165
16184 op-snap---monthly-publication-june-2025.pdf   2113 2025-06 Pedestrian Land Rover Evoque Grey Driving without Due Care and Attention None Tower Street Tower Street Dudley Dudley Warning Letter N/A   52.5112053 -2.0833165

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