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

281 rows where disposal = "Warning Letter", reporter_transport_mode = "Car" and vehicle_make = "Audi" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

offence 27

  • Driving without Due Care and Attention 80
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 45
  • Contravening a Red Traffic Light 32
  • Cause vehicle to be left in a dangerous position 31
  • Cause unnecessary obstruction by motor vehicle 23
  • Driving without Reasonable Consideration 16
  • Misc - Non Traffic Offences 7
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 7
  • VRM fails to conform to Regulations 7
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 5
  • Contravene Lane Closure Red X 4
  • Stop a vehicle on pedestrian crossing 4
  • Stop a vehicle within pelican pedestrian crossing limits 4
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
  • Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
  • DCariuvsineg u wnnitehcoeusts aDruye o Cbasrteru acntido nA tbtye nmtiootnor vehicle 1
  • Dangerous Driving 1
  • Drive a vehicle other than on the carriageway of a motorway 1
  • Drive on hard shoulder 1
  • Driving a vehicle wholly or partly on a footpath 1
  • Fail to display front VRM plate 1
  • Motor vehicle fail to accord precedence at a pelican crossing 1
  • No Seat Belt 1
  • Offence to be added 1
  • Use a vehicle / cycle on a road and contravene a l 1
  • Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
  • Using a Mobile Phone Whilst Driving 1

month 14

  • 2025-09 39
  • 2025-07 32
  • 2025-08 32
  • 2025-06 30
  • 2025-03 22
  • 2025-10 22
  • 2025-11 21
  • 2025-02 16
  • 2025-12 16
  • 2025-05 14
  • 2026-02 12
  • 2026-01 10
  • 2025-01 9
  • 2025-04 6

council_area 10

  • Birmingham 202
  • Wolverhampton 15
  • Dudley 14
  • Sandwell 14
  • Coventry 11
  • Solihull 11
  • Walsall 10
  • Sutton Coldfield 2
  • Metropolitan Borough Of Dudley 1
  • Out of Force Area 1

vehicle_make 1

  • Audi · 281 ✖

reporter_transport_mode 1

  • Car · 281 ✖

disposal 1

  • Warning Letter · 281 ✖
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
7445 op-snap---monthly-publication-february-2026.pdf   192 2026-02 Car Audi TT Black Offence to be added None B4101 B4101 Solihull Solihull Warning Letter N/A   52.3497163 -1.7776659
7609 op-snap---monthly-publication-february-2026.pdf   356 2026-02 Car Audi RS6 White VRM fails to conform to Regulations None Gibbins Road Gibbins Road Birmingham Birmingham Warning Letter N/A   52.4390303 -1.9512931
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
7745 op-snap---monthly-publication-february-2026.pdf   492 2026-02 Car Audi Q3 Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Berwood Road Berwood Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5342947 -1.8155375
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
8021 op-snap---monthly-publication-february-2026.pdf   768 2026-02 Car Audi Q3 Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Highgate Road Highgate Road Birmingham Birmingham Warning Letter N/A   52.4606652 -1.8791145
8565 op-snap---monthly-publication-february-2026.pdf   1312 2026-02 Car Audi Q5 Grey Contravening a Red Traffic Light No vehicle excise licence Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
8603 op-snap---monthly-publication-february-2026.pdf   1350 2026-02 Car Audi a5 Grey Stop a vehicle on pedestrian crossing None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8650 op-snap---monthly-publication-february-2026.pdf   1397 2026-02 Car Audi a1 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
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      
8798 op-snap---monthly-publication-february-2026.pdf   1545 2026-02 Car Audi a1 Grey Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8800 op-snap---monthly-publication-february-2026.pdf   1547 2026-02 Car Audi s3 Grey Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
10596 op-snap---monthly-publication-january-2026.pdf   57 2026-01 Car Audi s3 White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None warwick road Warwick Road Birmingham Birmingham Warning Letter N/A   52.4555288 -1.8613929
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      
10829 op-snap---monthly-publication-january-2026.pdf   290 2026-01 Car Audi A6 Blue Fail to display front VRM plate None Institute Road Institute Road Birmingham Birmingham Warning Letter N/A   52.4334781 -1.8892337
10888 op-snap---monthly-publication-january-2026.pdf   349 2026-01 Car Audi A4 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ninweh Road Ninweh Road 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
10998 op-snap---monthly-publication-january-2026.pdf   459 2026-01 Car Audi Q5 Grey Misc - Non Traffic Offences None Colley Gate Colley Gate Birmingham Birmingham Warning Letter N/A      
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      
11886 op-snap---monthly-publication-january-2026.pdf   1347 2026-01 Car Audi A4 Black Contravening a Red Traffic Light None Penn Road Penn Road Wolverhampton Wolverhampton Warning Letter N/A   52.5599616 -2.1556338
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      
3940 op-snap---monthly-publication-december-2025.pdf   68 2025-12 Car Audi RS6 Black Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Warning Letter N/A   52.5265939 -1.8509884
3959 op-snap---monthly-publication-december-2025.pdf   87 2025-12 Car Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Witton Road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
4266 op-snap---monthly-publication-december-2025.pdf   394 2025-12 Car Audi A3.. White Contravening a Red Traffic Light None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4385 op-snap---monthly-publication-december-2025.pdf   513 2025-12 Car Audi Q3 Silver Contravening a Red Traffic Light Use vehicle on a road without valid test certificate Battery Way Battery Way Birmingham Birmingham Warning Letter N/A   52.4493988 -1.8476406
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
4443 op-snap---monthly-publication-december-2025.pdf   571 2025-12 Car Audi q6 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4503 op-snap---monthly-publication-december-2025.pdf   631 2025-12 Car Audi A4 White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Island Road Island Road Sandwell Sandwell Warning Letter N/A   52.4634433 -1.9965278
4523 op-snap---monthly-publication-december-2025.pdf   651 2025-12 Car Audi s3 Black Cause vehicle to be left in a dangerous position None coleshill road Coleshill Road Birmingham Birmingham Warning Letter N/A   52.4967329 -1.8097462
4713 op-snap---monthly-publication-december-2025.pdf   841 2025-12 Car Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4743 op-snap---monthly-publication-december-2025.pdf   871 2025-12 Car Audi A3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4746 op-snap---monthly-publication-december-2025.pdf   874 2025-12 Car Audi A5 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4942 op-snap---monthly-publication-december-2025.pdf   1070 2025-12 Car Audi etron Black Cause vehicle to be left in a dangerous position None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
5067 op-snap---monthly-publication-december-2025.pdf   1195 2025-12 Car Audi A5 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
5171 op-snap---monthly-publication-december-2025.pdf   1299 2025-12 Car Audi A6 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bell Lane Northfield Bell Lane Northfield Birmingham Birmingham Warning Letter N/A   52.4171259 -1.9700288
5174 op-snap---monthly-publication-december-2025.pdf   1302 2025-12 Car Audi Q3 Grey Stop a vehicle within pelican pedestrian crossing limits None High St Tettenhall High Street Tettenhall Wolverhampton Wolverhampton Warning Letter N/A   52.5980906 -2.168057
20479 op-snap---monthly-publication-november-2025.pdf   21 2025-11 Car Audi Q3. White Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Church Street at Edmund Street Church Street at Edmund Street Birmingham Birmingham Warning Letter N/A   52.5020781 -1.9122368
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      
20752 op-snap---monthly-publication-november-2025.pdf   294 2025-11 Car Audi A6 Black Driving a vehicle wholly or partly on a footpath None Reservoir Road Reservoir Road Birmingham Birmingham Warning Letter N/A   52.5242452 -1.8572541
20830 op-snap---monthly-publication-november-2025.pdf   372 2025-11 Car Audi A7 White VRM fails to conform to Regulations None Sedgley Town Centre Sedgley Town Centre Dudley Dudley Warning Letter N/A      
20849 op-snap---monthly-publication-november-2025.pdf   391 2025-11 Car Audi A4 Grey Contravening a Red Traffic Light None Black Country New Road Black Country New Road Sandwell Sandwell Warning Letter N/A   52.5527191 -2.0312967
20877 op-snap---monthly-publication-november-2025.pdf   419 2025-11 Car Audi A6 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
20913 op-snap---monthly-publication-november-2025.pdf   455 2025-11 Car Audi A4 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
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
21015 op-snap---monthly-publication-november-2025.pdf   557 2025-11 Car Audi A5 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
21016 op-snap---monthly-publication-november-2025.pdf   558 2025-11 Car Audi A5 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
21216 op-snap---monthly-publication-november-2025.pdf   758 2025-11 Car Audi A6 Grey Stop a vehicle on pedestrian crossing None Coleshill Road Coleshill Road Birmingham Birmingham Warning Letter N/A   52.4967329 -1.8097462
21309 op-snap---monthly-publication-november-2025.pdf   851 2025-11 Car Audi a6 Black Cause vehicle to be left in a dangerous position None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
21446 op-snap---monthly-publication-november-2025.pdf   988 2025-11 Car Audi a1 White Cause vehicle to be left in a dangerous position None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
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
21828 op-snap---monthly-publication-november-2025.pdf   1370 2025-11 Car Audi q4 Black Cause vehicle to be left in a dangerous position None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
21877 op-snap---monthly-publication-november-2025.pdf   1419 2025-11 Car Audi a3 Grey Cause vehicle to be left in a dangerous position None witton road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
21969 op-snap---monthly-publication-november-2025.pdf   1511 2025-11 Car Audi Q7 Grey Contravening a Red Traffic Light None Friary Road Friary Road Birmingham Birmingham Warning Letter N/A   52.5162814 -1.9395798
22021 op-snap---monthly-publication-november-2025.pdf   1563 2025-11 Car Audi A3 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
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
22206 op-snap---monthly-publication-october-2025.pdf   156 2025-10 Car Audi Q5 Black Contravening a Red Traffic Light None Wentworth Way Wentworth Way Birmingham Birmingham Warning Letter N/A   52.4474041 -1.9733473
22348 op-snap---monthly-publication-october-2025.pdf   298 2025-10 Car Audi A4 Black Contravening a Red Traffic Light None Longbridge Lane Longbridge Lane Birmingham Birmingham Warning Letter N/A   52.3962003 -1.9821252
22442 op-snap---monthly-publication-october-2025.pdf   392 2025-10 Car Audi Q3 Grey Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Highgate Road Highgate Road Birmingham Birmingham Warning Letter N/A   52.4606652 -1.8791145
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
23175 op-snap---monthly-publication-october-2025.pdf   1125 2025-10 Car Audi S3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23211 op-snap---monthly-publication-october-2025.pdf   1161 2025-10 Car Audi a4 White Cause vehicle to be left in a dangerous position None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
23254 op-snap---monthly-publication-october-2025.pdf   1204 2025-10 Car Audi A1 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None New John St New John Street Dudley Dudley Warning Letter N/A   52.4713277 -2.0384732
23328 op-snap---monthly-publication-october-2025.pdf   1278 2025-10 Car Audi Saloon Grey Cause vehicle to be left in a dangerous position None Montgomery Street Montgomery Street Birmingham Birmingham Warning Letter N/A   52.4644472 -1.8668879
23356 op-snap---monthly-publication-october-2025.pdf   1306 2025-10 Car Audi S3 Black Drive on hard shoulder None M6 M6 Birmingham Birmingham Warning Letter N/A      
23396 op-snap---monthly-publication-october-2025.pdf   1346 2025-10 Car Audi A5 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Robin Hood Road Robin Hood Road Birmingham Birmingham Warning Letter N/A   52.4254885 -1.8309796
23431 op-snap---monthly-publication-october-2025.pdf   1381 2025-10 Car Audi RS6 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23432 op-snap---monthly-publication-october-2025.pdf   1382 2025-10 Car Audi A3 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23465 op-snap---monthly-publication-october-2025.pdf   1415 2025-10 Car Audi A3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hob Moor Road Hob Moor Road Birmingham Birmingham Warning Letter N/A   52.467637 -1.8151581
23503 op-snap---monthly-publication-october-2025.pdf   1453 2025-10 Car Audi a4 Black Cause vehicle to be left in a dangerous position None anthony road Anthony Road Birmingham Birmingham Warning Letter N/A   52.4843724 -1.8470805
23546 op-snap---monthly-publication-october-2025.pdf   1496 2025-10 Car Audi A3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A   52.4865107 -1.9386263
23580 op-snap---monthly-publication-october-2025.pdf   1530 2025-10 Car Audi A5 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Whithymoor Primary School Whithymoor Primary School Dudley Dudley Warning Letter N/A      
23582 op-snap---monthly-publication-october-2025.pdf   1532 2025-10 Car Audi A4 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Whithymoor Primary School Whithymoor Primary School Dudley Dudley Warning Letter N/A      
23597 op-snap---monthly-publication-october-2025.pdf   1547 2025-10 Car Audi   Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
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
23719 op-snap---monthly-publication-october-2025.pdf   1669 2025-10 Car Audi A1 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23822 op-snap---monthly-publication-september-2025.pdf   41 2025-09 Car Audi A4 White Driving without Reasonable Consideration None a45 A45 Coventry Coventry Warning Letter N/A      
23950 op-snap---monthly-publication-september-2025.pdf   169 2025-09 Car Audi A6 White Contravening a Red Traffic Light None A4150 Wolverhampton Wolverhampton Wolverhampton Wolverhampton Warning Letter N/A   52.5879884 -2.120242
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
24049 op-snap---monthly-publication-september-2025.pdf   268 2025-09 Car Audi Q2 Black Contravening a Red Traffic Light None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Warning Letter N/A   52.4720132 -1.9142946
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
24336 op-snap---monthly-publication-september-2025.pdf   555 2025-09 Car Audi S3 Black Driving without Reasonable Consideration None Meadway Meadway Birmingham Birmingham Warning Letter N/A   52.4783348 -1.8007708
24373 op-snap---monthly-publication-september-2025.pdf   592 2025-09 Car Audi   Black Contravening a Red Traffic Light None Cox Street Cox Street Coventry Coventry Warning Letter N/A   52.4092228 -1.5034119
24998 op-snap---monthly-publication-september-2025.pdf   1217 2025-09 Car Audi Q2 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
25018 op-snap---monthly-publication-september-2025.pdf   1237 2025-09 Car Audi Q4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
25084 op-snap---monthly-publication-september-2025.pdf   1303 2025-09 Car Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Witton road Witton road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
25095 op-snap---monthly-publication-september-2025.pdf   1314 2025-09 Car Audi A3 Brown Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Pitmaston road Pitmaston road Birmingham Birmingham Warning Letter N/A   52.4254701 -1.8322218
25111 op-snap---monthly-publication-september-2025.pdf   1330 2025-09 Car Audi SQ5 Black Contravene Lane Closure Red X None M6 Motorway M6 Motorway Birmingham Birmingham Warning Letter N/A   52.5327447 -1.899844
25113 op-snap---monthly-publication-september-2025.pdf   1332 2025-09 Car Audi A1 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
25119 op-snap---monthly-publication-september-2025.pdf   1338 2025-09 Car Audi A5 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area selly oak road Selly Oak Road Birmingham Birmingham Warning Letter N/A   52.4263875 -1.9397954
25123 op-snap---monthly-publication-september-2025.pdf   1342 2025-09 Car Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
25143 op-snap---monthly-publication-september-2025.pdf   1362 2025-09 Car Audi TT Grey Stop a vehicle on pedestrian crossing None Darwin St Darwin Street Birmingham Birmingham Warning Letter N/A   52.468128 -1.8848315
25151 op-snap---monthly-publication-september-2025.pdf   1370 2025-09 Car Audi Q5 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Dower road Dower road Birmingham Birmingham Warning Letter N/A   52.5779855 -1.8253507

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