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

110 rows where disposal = "Warning Letter", offence = "Driving without Due Care and Attention" and vehicle_make = "Audi" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_model, vehicle_colour, second_offence, council_area_raw, nfa_rationale

month 14

  • 2025-06 14
  • 2025-05 12
  • 2025-07 11
  • 2025-08 10
  • 2026-01 10
  • 2025-02 9
  • 2025-03 9
  • 2025-09 7
  • 2025-10 6
  • 2025-11 6
  • 2026-02 5
  • 2025-01 4
  • 2025-12 4
  • 2025-04 3

council_area 9

  • Birmingham 65
  • Dudley 13
  • Solihull 8
  • Coventry 7
  • Wolverhampton 6
  • Walsall 5
  • Sandwell 4
  • Metropolitan Borough Of Dudley 1
  • Sutton Coldfield 1

reporter_transport_mode 5

  • Car 80
  • Pedal Bike 14
  • Other 8
  • Pedestrian 7
  • Motorbike 1

vehicle_make 1

  • Audi · 110 ✖

offence 1

  • Driving without Due Care and Attention · 110 ✖

disposal 1

  • Warning Letter · 110 ✖
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
7730 op-snap---monthly-publication-february-2026.pdf   477 2026-02 Car Audi S3 Blue Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
7819 op-snap---monthly-publication-february-2026.pdf   566 2026-02 Car Audi A3 Red Driving without Due Care and Attention None Raddlebarn Road Raddlebarn Road Birmingham Birmingham Warning Letter N/A   52.4397168 -1.9260414
8390 op-snap---monthly-publication-february-2026.pdf   1137 2026-02 Other Audi A3 Silver Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A      
8490 op-snap---monthly-publication-february-2026.pdf   1237 2026-02 Pedal Bike Audi Q5 White Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Warning Letter N/A   52.4390303 -1.9512931
8679 op-snap---monthly-publication-february-2026.pdf   1426 2026-02 Car Audi A3 Grey Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A      
10552 op-snap---monthly-publication-january-2026.pdf   13 2026-01 Other Audi A5 Grey Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
10601 op-snap---monthly-publication-january-2026.pdf   62 2026-01 Car Audi RSQ7 White Driving without Due Care and Attention None M42 near M40 junc M42 near M40 junc Solihull Solihull Warning Letter N/A      
10604 op-snap---monthly-publication-january-2026.pdf   65 2026-01 Other Audi Q7 Blue Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
10652 op-snap---monthly-publication-january-2026.pdf   113 2026-01 Other Audi A3.. Grey Driving without Due Care and Attention None Star City Car Park Star City Car Park Birmingham Birmingham Warning Letter N/A      
10958 op-snap---monthly-publication-january-2026.pdf   419 2026-01 Car Audi A3 grey Driving without Due Care and Attention Use vehicle on a road without valid test certificate Cinder Bank Island, Netherton Cinder Bank Island, Netherton Dudley Dudley Warning Letter N/A   52.5004694 -2.0904035
11023 op-snap---monthly-publication-january-2026.pdf   484 2026-01 Other Audi S3 Black Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
11273 op-snap---monthly-publication-january-2026.pdf   734 2026-01 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Hearsall Common Hearsall Common Coventry Coventry Warning Letter N/A   52.402753 -1.5385829
11357 op-snap---monthly-publication-january-2026.pdf   818 2026-01 Car Audi Q5 Black Driving without Due Care and Attention None Marston Road Marston Road Wolverhampton Wolverhampton Warning Letter N/A   52.574516 -2.1341421
11415 op-snap---monthly-publication-january-2026.pdf   876 2026-01 Car Audi SQ5 Blue Driving without Due Care and Attention None The Broadwway The Broadwway Dudley Dudley Warning Letter N/A      
11575 op-snap---monthly-publication-january-2026.pdf   1036 2026-01 Car Audi S3 Black Driving without Due Care and Attention None Aston Express Way Aston Express Way Birmingham Birmingham Warning Letter N/A      
3878 op-snap---monthly-publication-december-2025.pdf   6 2025-12 Car Audi A6 Black Driving without Due Care and Attention None A41 A41 Sandwell Sandwell Warning Letter N/A      
4398 op-snap---monthly-publication-december-2025.pdf   526 2025-12 Car Audi A4 Silver Driving without Due Care and Attention None Hunters Road Hunters Road Birmingham Birmingham Warning Letter N/A   52.5011362 -1.9175837
4592 op-snap---monthly-publication-december-2025.pdf   720 2025-12 Pedestrian Audi s3 Blue Driving without Due Care and Attention None south parade South Parade Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5618877 -1.8226794
4818 op-snap---monthly-publication-december-2025.pdf   946 2025-12 Pedal Bike Audi A5 White Driving without Due Care and Attention None Oak Tree Lane, Selly Oak Oak Tree Lane, Selly Oak Birmingham Birmingham Warning Letter N/A   52.4386794 -1.939894
20531 op-snap---monthly-publication-november-2025.pdf   73 2025-11 Car Audi A3 Black Driving without Due Care and Attention None B4101 Coventry City Centre Coventry City Centre Coventry Coventry Warning Letter N/A   52.4146776 -1.5056904
20548 op-snap---monthly-publication-november-2025.pdf   90 2025-11 Car Audi A5 Red Driving without Due Care and Attention None Bromford Road Bromford Road Birmingham Birmingham Warning Letter N/A   52.503036 -1.8289972
20604 op-snap---monthly-publication-november-2025.pdf   146 2025-11 Car Audi A4 Black Driving without Due Care and Attention None Bognob Road Bognob Road Wolverhampton Wolverhampton Warning Letter N/A      
20931 op-snap---monthly-publication-november-2025.pdf   473 2025-11 Car Audi A4 White Driving without Due Care and Attention None Moseley Road / Cromer Rd Moseley Road / Cromer Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
21011 op-snap---monthly-publication-november-2025.pdf   553 2025-11 Car Audi A6 Black Driving without Due Care and Attention None Coventry Road Coventry Road Coventry Coventry Warning Letter N/A   52.4111289 -1.5094345
21680 op-snap---monthly-publication-november-2025.pdf   1222 2025-11 Car Audi A1 White Driving without Due Care and Attention None Black Country New Road / Steel Roundabout Black Country New Road / Steel Roundabout Walsall Walsall Warning Letter N/A   52.5593848 -2.0426847
22064 op-snap---monthly-publication-october-2025.pdf   14 2025-10 Car Audi A3 White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
22142 op-snap---monthly-publication-october-2025.pdf   92 2025-10 Car Audi A6 grey Driving without Due Care and Attention None Lea Road Lea Road Wolverhampton Wolverhampton Warning Letter N/A   52.5780818 -2.135334
22433 op-snap---monthly-publication-october-2025.pdf   383 2025-10 Pedal Bike Audi   grey Driving without Due Care and Attention None B4101 Balsall Street Balsall Street Birmingham Birmingham Warning Letter N/A   52.4579985 -1.8916996
23016 op-snap---monthly-publication-october-2025.pdf   966 2025-10 Car Audi Q8 White Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Warning Letter N/A   52.4668753 -1.8996143
23184 op-snap---monthly-publication-october-2025.pdf   1134 2025-10 Pedestrian Audi A3 Silver Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Birmingham Birmingham Warning Letter N/A   52.463146 -1.9844677
23695 op-snap---monthly-publication-october-2025.pdf   1645 2025-10 Car Audi RS3 Black Driving without Due Care and Attention None Newhall Hill Newhall Hill Birmingham Birmingham Warning Letter N/A   52.4832761 -1.9110049
24030 op-snap---monthly-publication-september-2025.pdf   249 2025-09 Car Audi Q5 Blue Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
24035 op-snap---monthly-publication-september-2025.pdf   254 2025-09 Car Audi A3 Black Driving without Due Care and Attention None Boldmere Road Boldmere Road Birmingham Birmingham Warning Letter N/A   52.548309 -1.8411769
24164 op-snap---monthly-publication-september-2025.pdf   383 2025-09 Car Audi Q6 Grey Driving without Due Care and Attention None Ulverley Green Lane Ulverley Green Lane Solihull Solihull Warning Letter N/A      
24297 op-snap---monthly-publication-september-2025.pdf   516 2025-09 Car Audi A3.. Grey Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Warning Letter N/A   52.5113867 -1.8337258
24584 op-snap---monthly-publication-september-2025.pdf   803 2025-09 Other Audi A1 Black Driving without Due Care and Attention None Waterfront car park 7 Waterfront car park 7 Dudley Dudley Warning Letter N/A      
24586 op-snap---monthly-publication-september-2025.pdf   805 2025-09 Other Audi A4 Grey Driving without Due Care and Attention None Waterfron car park 7 Waterfron car park 7 Dudley Dudley Warning Letter N/A      
24686 op-snap---monthly-publication-september-2025.pdf   905 2025-09 Pedal Bike Audi A1 Green Driving without Due Care and Attention None Marshall Lake Road Marshall Lake Road Solihull Solihull Warning Letter N/A   52.3975426 -1.818252
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      
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
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
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
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
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      
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
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
3288 op-snap---monthly-publication-august-2025.pdf   1263 2025-08 Pedestrian Audi A6 Black Driving without Due Care and Attention None Regent Parade Regent Parade Birmingham Birmingham Warning Letter N/A   52.4863585 -1.9094435
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
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
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
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
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      
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      
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
13897 op-snap---monthly-publication-july-2025.pdf   1949 2025-07 Pedestrian Audi RS3 Blue Driving without Due Care and Attention None Longbridge Lane, Scotland Lane Longbridge Lane, Scotland Lane Birmingham Birmingham Warning Letter N/A      
13913 op-snap---monthly-publication-july-2025.pdf   1965 2025-07 Pedal Bike Audi A4 Black Driving without Due Care and Attention None broad lane Broad Lane Coventry Coventry Warning Letter N/A   52.4074716 -1.5620671
13920 op-snap---monthly-publication-july-2025.pdf   1972 2025-07 Car Audi S3 White Driving without Due Care and Attention None Thimblemill Road Thimblemill Road Sandwell Sandwell Warning Letter N/A   52.4801354 -1.9749821
13936 op-snap---monthly-publication-july-2025.pdf   1988 2025-07 Pedestrian Audi TT Black Driving without Due Care and Attention None Victoria Street Victoria Street Birmingham Birmingham Warning Letter N/A   52.4751651 -1.8559775
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
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
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      
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
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
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
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
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
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
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
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      
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
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
19313 op-snap---monthly-publication-may-2025.pdf   675 2025-05 Car Audi Q3 White Driving without Due Care and Attention None Newbury Rd Newbury Road Birmingham Birmingham Warning Letter N/A   52.4993019 -1.8964495
19518 op-snap---monthly-publication-may-2025.pdf   880 2025-05 Car Audi Q7 Black Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Solihull Solihull Warning Letter N/A   52.4322443 -1.6746508
20159 op-snap---monthly-publication-may-2025.pdf   1521 2025-05 Pedal Bike Audi q7 White Driving without Due Care and Attention None Price Street Price Street Sandwell Sandwell Warning Letter N/A   52.5173895 -1.9973426
20180 op-snap---monthly-publication-may-2025.pdf   1542 2025-05 Pedal Bike Audi Q3 Black Driving without Due Care and Attention None Bristol St Bristol Street Birmingham Birmingham Warning Letter N/A   52.4691145 -1.9003257
20232 op-snap---monthly-publication-may-2025.pdf   1594 2025-05 Car Audi Q2 Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
20236 op-snap---monthly-publication-may-2025.pdf   1598 2025-05 Pedestrian Audi A3 Grey Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Warning Letter N/A   52.4879006 -2.1188734
20248 op-snap---monthly-publication-may-2025.pdf   1610 2025-05 Car Audi A3 Black Driving without Due Care and Attention None Small Heath highway Small Heath highway Birmingham Birmingham Warning Letter N/A   52.4709298 -1.8722585
20254 op-snap---monthly-publication-may-2025.pdf   1616 2025-05 Car Audi S3 Black Driving without Due Care and Attention None Lea Ford Road Lea Ford Road Birmingham Birmingham Warning Letter N/A   52.4882128 -1.7814913
20261 op-snap---monthly-publication-may-2025.pdf   1623 2025-05 Car Audi A3 Black Driving without Due Care and Attention None Cole Hall Lane Cole Hall Lane Birmingham Birmingham Warning Letter N/A   52.4877244 -1.787883
20317 op-snap---monthly-publication-may-2025.pdf   1679 2025-05 Car Audi S3 Blue Driving without Due Care and Attention None St Johns Road, Stourbridge Street Johns Road, Stourbridge Dudley Dudley Warning Letter N/A      
20319 op-snap---monthly-publication-may-2025.pdf   1681 2025-05 Pedal Bike Audi A6 Black Driving without Due Care and Attention None Dads Lane, Stirchley Dads Lane, Stirchley Birmingham Birmingham Warning Letter N/A   52.4375914 -1.9068522
20450 op-snap---monthly-publication-may-2025.pdf   1812 2025-05 Pedal Bike Audi A5 Grey Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Warning Letter N/A   52.5292752 -1.7618805
43 op-snap---monthly-publication-april-2025.pdf   42 2025-04 Car Audi A3 Black Driving without Due Care and Attention None M5 SB J1-2 M5 Southbound J1-2 Sandwell Sandwell Warning Letter N/A      
112 op-snap---monthly-publication-april-2025.pdf   111 2025-04 Car Audi A1 Silver Driving without Due Care and Attention None Stourbridge Road Stourbridge Road Birmingham Birmingham Warning Letter N/A      
139 op-snap---monthly-publication-april-2025.pdf   138 2025-04 Car Audi A3 Black Driving without Due Care and Attention None M6 J6 M6 J6 Birmingham Birmingham Warning Letter N/A   52.676119 -2.0858425
16796 op-snap---monthly-publication-march-2025.pdf   553 2025-03 Car Audi Q5 Black Driving without Due Care and Attention None Level Street, Brierley Hill Level Street, Brierley Hill Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4850236 -2.1088919
17373 op-snap---monthly-publication-march-2025.pdf   1130 2025-03 Car Audi S7 White Driving without Due Care and Attention None Bescot Lane Bescot Lane Walsall Walsall Warning Letter Outside of 14 Days NIP Yes - Via Email 52.5704696 -2.0017451
17611 op-snap---monthly-publication-march-2025.pdf   1368 2025-03 Car Audi A3 Blue Driving without Due Care and Attention None St Annes Road Street Annes Road Dudley Dudley Warning Letter N/A Yes - Via Email    
17679 op-snap---monthly-publication-march-2025.pdf   1436 2025-03 Car Audi RS Q8 Black Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4816806 -1.8788939
18336 op-snap---monthly-publication-march-2025.pdf   2093 2025-03 Car Audi A3 White Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18473 op-snap---monthly-publication-march-2025.pdf   2230 2025-03 Car Audi A3 Black Driving without Due Care and Attention None M42 Motorway M42 Motorway Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.490826 -1.8882034
18540 op-snap---monthly-publication-march-2025.pdf   2297 2025-03 Car Audi A5 Black Driving without Due Care and Attention None M5 Junction 1 M5 Junction 1 Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18621 op-snap---monthly-publication-march-2025.pdf   2378 2025-03 Car Audi A4 Black Driving without Due Care and Attention None M6 south towards J6 M6 south towards J6 Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18623 op-snap---monthly-publication-march-2025.pdf   2380 2025-03 Car Audi A5 Black Driving without Due Care and Attention None Radford Road Coventry Radford Road Coventry Coventry Coventry Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4246606 -1.5245844
5358 op-snap---monthly-publication-february-2025.pdf   175 2025-02 Car Audi A3 White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5361 op-snap---monthly-publication-february-2025.pdf   178 2025-02 Car Audi A5 Black Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5363 op-snap---monthly-publication-february-2025.pdf   180 2025-02 Car Audi RS3 Silver Driving without Due Care and Attention Use vehicle on a road without valid test certificate Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939

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