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

133 rows where council_area = "Birmingham", disposal = "Warning Letter" and vehicle_make = "Seat" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

offence 16

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 45
  • Driving without Due Care and Attention 24
  • Cause vehicle to be left in a dangerous position 22
  • Cause unnecessary obstruction by motor vehicle 13
  • Contravening a Red Traffic Light 9
  • Driving without Reasonable Consideration 7
  • Misc - Non Traffic Offences 2
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
  • Stop a vehicle within pelican pedestrian crossing limits 2
  • /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 1
  • Driving a vehicle wholly or partly on a footpath 1
  • Motor vehicle fail to comply with a non endorsab 1
  • Stop a vehicle on pedestrian crossing 1
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
  • Using a Mobile Phone Whilst Driving 1
  • VRM fails to conform to Regulations 1

month 14

  • 2025-09 22
  • 2025-06 17
  • 2025-07 15
  • 2025-10 13
  • 2025-11 13
  • 2025-08 9
  • 2026-02 9
  • 2025-03 8
  • 2025-05 8
  • 2025-01 5
  • 2025-02 5
  • 2025-12 5
  • 2025-04 2
  • 2026-01 2

reporter_transport_mode 4

  • Car 67
  • Pedestrian 52
  • Pedal Bike 11
  • Other 3

vehicle_make 1

  • Seat · 133 ✖

disposal 1

  • Warning Letter · 133 ✖

council_area 1

  • Birmingham · 133 ✖
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
7346 op-snap---monthly-publication-february-2026.pdf   93 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None witton road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
7382 op-snap---monthly-publication-february-2026.pdf   129 2026-02 Pedal Bike Seat Arona Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lordswood Road Lordswood Road Birmingham Birmingham Warning Letter N/A   52.4591339 -1.9601054
7545 op-snap---monthly-publication-february-2026.pdf   292 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
7553 op-snap---monthly-publication-february-2026.pdf   300 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braford Street Braford Street Birmingham Birmingham Warning Letter N/A      
7702 op-snap---monthly-publication-february-2026.pdf   449 2026-02 Car Seat Alhambra Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cambridge Crescent Cambridge Crescent Birmingham Birmingham Warning Letter N/A   52.4652475 -1.9056734
7712 op-snap---monthly-publication-february-2026.pdf   459 2026-02 Pedestrian Seat   Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kings Heath Kings Heath Birmingham Birmingham Warning Letter N/A   52.4388601 -1.8936667
7779 op-snap---monthly-publication-february-2026.pdf   526 2026-02 Car Seat Ibiza Red Driving without Due Care and Attention None Curzon Circle Curzon Circle Birmingham Birmingham Warning Letter N/A   52.4834655 -1.8801763
8394 op-snap---monthly-publication-february-2026.pdf   1141 2026-02 Car Seat Ibiza Black Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Warning Letter N/A   52.470423 -1.9304786
8727 op-snap---monthly-publication-february-2026.pdf   1474 2026-02 Car Seat ateca Blue Stop a vehicle within pelican pedestrian crossing limits None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
10903 op-snap---monthly-publication-january-2026.pdf   364 2026-01 Car Seat Ibiza Black Driving without Due Care and Attention None Five ways roundabout Five ways roundabout Birmingham Birmingham Warning Letter N/A      
11929 op-snap---monthly-publication-january-2026.pdf   1390 2026-01 Pedestrian Seat Ateca Black Cause vehicle to be left in a dangerous position None Birmingham Road Birmingham Road Birmingham Birmingham Warning Letter N/A   52.5505398 -1.8252993
4305 op-snap---monthly-publication-december-2025.pdf   433 2025-12 Car Seat Leon Silver Driving without Due Care and Attention None A452 A452 Birmingham Birmingham Warning Letter N/A      
4355 op-snap---monthly-publication-december-2025.pdf   483 2025-12 Car Seat ibiza 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
4604 op-snap---monthly-publication-december-2025.pdf   732 2025-12 Car Seat Arona White Driving without Due Care and Attention None Hagley Road A456 Hagley Road A456 Birmingham Birmingham Warning Letter N/A   52.471632 -1.9456776
4994 op-snap---monthly-publication-december-2025.pdf   1122 2025-12 Pedestrian Seat leon Blue Cause vehicle to be left in a dangerous position None kingstanding road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
5102 op-snap---monthly-publication-december-2025.pdf   1230 2025-12 Car Seat leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A   52.4833672 -1.7871439
20729 op-snap---monthly-publication-november-2025.pdf   271 2025-11 Car Seat Leon Blue Driving without Due Care and Attention None a45 A45 Birmingham Birmingham Warning Letter N/A      
20922 op-snap---monthly-publication-november-2025.pdf   464 2025-11 Car Seat Exeo 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
20936 op-snap---monthly-publication-november-2025.pdf   478 2025-11 Pedestrian Seat Ibiza White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wooton Road Wooton Road Birmingham Birmingham Warning Letter N/A      
20958 op-snap---monthly-publication-november-2025.pdf   500 2025-11 Pedestrian Seat arona Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None stratford road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
20978 op-snap---monthly-publication-november-2025.pdf   520 2025-11 Pedestrian Seat Ibiza White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barclay Road Barclay Road Birmingham Birmingham Warning Letter N/A      
20979 op-snap---monthly-publication-november-2025.pdf   521 2025-11 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hamstead Road Hamstead Road Birmingham Birmingham Warning Letter N/A   52.505832 -1.92002
21027 op-snap---monthly-publication-november-2025.pdf   569 2025-11 Pedestrian Seat Ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Freer Road Freer Road Birmingham Birmingham Warning Letter N/A   52.5074462 -1.8979307
21100 op-snap---monthly-publication-november-2025.pdf   642 2025-11 Pedestrian Seat Ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dolphin Road Dolphin Road Birmingham Birmingham Warning Letter N/A   52.4542174 -1.8608812
21120 op-snap---monthly-publication-november-2025.pdf   662 2025-11 Pedestrian Seat Leon Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Russell Road Russell Road Birmingham Birmingham Warning Letter N/A   52.4398245 -1.8469786
21198 op-snap---monthly-publication-november-2025.pdf   740 2025-11 Car Seat Leon Grey Stop a vehicle on pedestrian crossing None Witton Road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
21625 op-snap---monthly-publication-november-2025.pdf   1167 2025-11 Pedestrian Seat ateca Black Cause vehicle to be left in a dangerous position None chilcote primary school Chilcote Primary School Birmingham Birmingham Warning Letter N/A   52.4164355 -1.8434429
21990 op-snap---monthly-publication-november-2025.pdf   1532 2025-11 Pedestrian Seat Ibiza Grey Cause vehicle to be left in a dangerous position None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
22004 op-snap---monthly-publication-november-2025.pdf   1546 2025-11 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
22648 op-snap---monthly-publication-october-2025.pdf   598 2025-10 Car Seat Arona White Driving without Due Care and Attention None Camp Hill Circus Camp Hill Circus Birmingham Birmingham Warning Letter N/A   52.4682339 -1.8793662
23163 op-snap---monthly-publication-october-2025.pdf   1113 2025-10 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23334 op-snap---monthly-publication-october-2025.pdf   1284 2025-10 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Belchers Lane Belchers Lane Birmingham Birmingham Warning Letter N/A   52.4800061 -1.833007
23364 op-snap---monthly-publication-october-2025.pdf   1314 2025-10 Car Seat alhambra Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
23373 op-snap---monthly-publication-october-2025.pdf   1323 2025-10 Car Seat Leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A   52.4833672 -1.7871439
23374 op-snap---monthly-publication-october-2025.pdf   1324 2025-10 Pedestrian Seat Alhambra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None REginald Road REginald Road Birmingham Birmingham Warning Letter N/A   52.4893183 -1.8578906
23390 op-snap---monthly-publication-october-2025.pdf   1340 2025-10 Pedestrian Seat Toledo Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None College Road College Road Birmingham Birmingham Warning Letter N/A   52.5151832 -1.9361664
23404 op-snap---monthly-publication-october-2025.pdf   1354 2025-10 Pedestrian Seat Ibiza Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wentworth Road Wentworth Road Birmingham Birmingham Warning Letter N/A   52.5773229 -1.8324449
23484 op-snap---monthly-publication-october-2025.pdf   1434 2025-10 Pedestrian Seat ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None oak treen lane Oak Treen Lane Birmingham Birmingham Warning Letter N/A      
23604 op-snap---monthly-publication-october-2025.pdf   1554 2025-10 Car Seat Leon Black Misc - Non Traffic Offences None A452 A452 Birmingham Birmingham Warning Letter N/A      
23702 op-snap---monthly-publication-october-2025.pdf   1652 2025-10 Car Seat ibiza 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
23715 op-snap---monthly-publication-october-2025.pdf   1665 2025-10 Car Seat Ibiza 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
23745 op-snap---monthly-publication-october-2025.pdf   1695 2025-10 Pedestrian Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
23831 op-snap---monthly-publication-september-2025.pdf   50 2025-09 Pedestrian Seat Leon Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
23997 op-snap---monthly-publication-september-2025.pdf   216 2025-09 Pedestrian Seat Leon Black Contravening a Red Traffic Light None Sandon Road Sandon Road Birmingham Birmingham Warning Letter N/A   52.4733908 -1.9577579
24057 op-snap---monthly-publication-september-2025.pdf   276 2025-09 Car Seat Leon Black Driving without Due Care and Attention None Nursery Road Nursery Road Birmingham Birmingham Warning Letter N/A   52.4979836 -1.9118163
24420 op-snap---monthly-publication-september-2025.pdf   639 2025-09 Car Seat Leon White Driving without Due Care and Attention None Grove Road Grove Road Birmingham Birmingham Warning Letter N/A   52.4453942 -1.8644982
24789 op-snap---monthly-publication-september-2025.pdf   1008 2025-09 Other Seat MII Red Driving without Due Care and Attention None St Margarets Avenue Street Margarets Avenue Birmingham Birmingham Warning Letter N/A      
24883 op-snap---monthly-publication-september-2025.pdf   1102 2025-09 Other Seat Leon Red Driving without Due Care and Attention None Star City Star City Birmingham Birmingham Warning Letter N/A   52.5054363 -1.8556273
25087 op-snap---monthly-publication-september-2025.pdf   1306 2025-09 Car Seat Arona Orange Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
25089 op-snap---monthly-publication-september-2025.pdf   1308 2025-09 Car Seat Ibiza White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
25094 op-snap---monthly-publication-september-2025.pdf   1313 2025-09 Car Seat leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
25100 op-snap---monthly-publication-september-2025.pdf   1319 2025-09 Pedestrian Seat Leon Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Gnroenaeter London area Walford Road Walford Road Birmingham Birmingham Warning Letter N/A   52.4594072 -1.8658859
25106 op-snap---monthly-publication-september-2025.pdf   1325 2025-09 Pedestrian Seat Arona Black Cause vehicle to be left in a dangerous position None Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
25112 op-snap---monthly-publication-september-2025.pdf   1331 2025-09 Car Seat Leon White 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
25139 op-snap---monthly-publication-september-2025.pdf   1358 2025-09 Pedestrian Seat Ibiza White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
25228 op-snap---monthly-publication-september-2025.pdf   1447 2025-09 Pedal Bike Seat Ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Weoley Park Road Weoley Park Road Birmingham Birmingham Warning Letter N/A   52.4368136 -1.9495478
25254 op-snap---monthly-publication-september-2025.pdf   1473 2025-09 Pedestrian Seat leon Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
25339 op-snap---monthly-publication-september-2025.pdf   1558 2025-09 Car Seat leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
25361 op-snap---monthly-publication-september-2025.pdf   1580 2025-09 Car Seat Leon Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Berwood Road Berwood Road Birmingham Birmingham Warning Letter N/A   52.5342947 -1.8155375
25440 op-snap---monthly-publication-september-2025.pdf   1659 2025-09 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Law cliff road Law cliff road Birmingham Birmingham Warning Letter N/A   52.5333535 -1.9189815
25474 op-snap---monthly-publication-september-2025.pdf   1693 2025-09 Car Seat altea Blue Motor vehicle fail to comply with a non endorsab le traffic sign - detectedN boyn meeans other than ACD high street High Street Birmingham Birmingham Warning Letter N/A   52.5254588 -1.8373064
25487 op-snap---monthly-publication-september-2025.pdf   1706 2025-09 Car Seat arona Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area washwood heath raod Washwood Heath Raod Birmingham Birmingham Warning Letter N/A      
25563 op-snap---monthly-publication-september-2025.pdf   1782 2025-09 Pedestrian Seat arona Silver Cause vehicle to be left in a dangerous position None westley road Westley Road Birmingham Birmingham Warning Letter N/A   52.4456462 -1.827993
25607 op-snap---monthly-publication-september-2025.pdf   1826 2025-09 Car Seat Leon White /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
3151 op-snap---monthly-publication-august-2025.pdf   1126 2025-08 Car Seat Ibiza Blue Driving a vehicle wholly or partly on a footpath None Church Hill Church Hill Birmingham Birmingham Warning Letter N/A   52.4112239 -1.9643143
3241 op-snap---monthly-publication-august-2025.pdf   1216 2025-08 Pedestrian Seat Leon Blue Cause vehicle to be left in a dangerous position None Barnsley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
3243 op-snap---monthly-publication-august-2025.pdf   1218 2025-08 Pedestrian Seat Leon Blue Cause vehicle to be left in a dangerous position None Barnsley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
3375 op-snap---monthly-publication-august-2025.pdf   1350 2025-08 Car Seat Alhambra 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
3588 op-snap---monthly-publication-august-2025.pdf   1563 2025-08 Pedestrian Seat ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None cannon hill road Cannon Hill Road Birmingham Birmingham Warning Letter N/A   52.4569873 -1.8971744
3591 op-snap---monthly-publication-august-2025.pdf   1566 2025-08 Car Seat leon Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Stoney Lane Stoney Lane Birmingham Birmingham Warning Letter N/A   52.4745488 -1.8065911
3595 op-snap---monthly-publication-august-2025.pdf   1570 2025-08 Pedestrian Seat Ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cannon Hill Rd Cannon Hill Road Birmingham Birmingham Warning Letter N/A   52.4569873 -1.8971744
3643 op-snap---monthly-publication-august-2025.pdf   1618 2025-08 Pedestrian Seat Leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3866 op-snap---monthly-publication-august-2025.pdf   1841 2025-08 Pedal Bike Seat Leon Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
13124 op-snap---monthly-publication-july-2025.pdf   1176 2025-07 Car Seat Ibiza Grey Contravening a Red Traffic Light None Kings Road at Speedwell Road Kings Road at Speedwell Road Birmingham Birmingham Warning Letter N/A   52.5531351 -1.8852761
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
13275 op-snap---monthly-publication-july-2025.pdf   1327 2025-07 Pedestrian Seat Leon Blue Cause vehicle to be left in a dangerous position None Witton Road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
13286 op-snap---monthly-publication-july-2025.pdf   1338 2025-07 Pedestrian Seat Leon Grey Cause vehicle to be left in a dangerous position None shadwell street Shadwell Street Birmingham Birmingham Warning Letter N/A   52.4860038 -1.8987257
13291 op-snap---monthly-publication-july-2025.pdf   1343 2025-07 Pedestrian Seat Ibiza Red Cause vehicle to be left in a dangerous position none shadwell street Shadwell Street Birmingham Birmingham Warning Letter N/A   52.4860038 -1.8987257
13353 op-snap---monthly-publication-july-2025.pdf   1405 2025-07 Car Seat Ibiza Blue Cause vehicle to be left in a dangerous position None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Warning Letter N/A   52.473883 -1.9198244
13607 op-snap---monthly-publication-july-2025.pdf   1659 2025-07 Pedestrian Seat Ibiza Silver Cause vehicle to be left in a dangerous position None Bayston Road Bayston Road Birmingham Birmingham Warning Letter N/A   52.4131998 -1.8910749
13622 op-snap---monthly-publication-july-2025.pdf   1674 2025-07 Pedestrian Seat Ibiza White Cause vehicle to be left in a dangerous position None Petersfield Road Petersfield Road Birmingham Birmingham Warning Letter N/A   52.4307 -1.8494663
13674 op-snap---monthly-publication-july-2025.pdf   1726 2025-07 Car Seat Leon 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
13695 op-snap---monthly-publication-july-2025.pdf   1747 2025-07 Car Seat tarraco Black VRM fails to conform to Regulations None Stechford Stechford Birmingham Birmingham Warning Letter N/A   52.4851563 -1.8110345
13722 op-snap---monthly-publication-july-2025.pdf   1774 2025-07 Car Seat ateca Grey 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
13845 op-snap---monthly-publication-july-2025.pdf   1897 2025-07 Pedestrian Seat Iniza Black Cause vehicle to be left in a dangerous position None Tudor Road Tudor Road Birmingham Birmingham Warning Letter N/A   52.5655772 -1.8268728
13973 op-snap---monthly-publication-july-2025.pdf   2025 2025-07 Car Seat Ibiza Silver Contravening a Red Traffic Light None Kingsbury Road Kingsbury Road Birmingham Birmingham Warning Letter N/A   52.5292752 -1.7618805
14023 op-snap---monthly-publication-july-2025.pdf   2075 2025-07 Car Seat Ibiza White Driving without Due Care and Attention None Longbiridge Lane Longbiridge Lane Birmingham Birmingham Warning Letter N/A      
14035 op-snap---monthly-publication-july-2025.pdf   2087 2025-07 Car Seat Ibiza Black Cause vehicle to be left in a dangerous position None Warwick Road Warwick Road Birmingham Birmingham Warning Letter N/A   52.4555288 -1.8613929
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      
14177 op-snap---monthly-publication-june-2025.pdf   106 2025-06 Car Seat Ibiza White Contravening a Red Traffic Light None Vicarage Road Vicarage Road Birmingham Birmingham Warning Letter N/A   52.470423 -1.9304786
14481 op-snap---monthly-publication-june-2025.pdf   410 2025-06 Pedal Bike Seat Ibiza Grey Driving without Reasonable Consideration None Wrentham St Wrentham Street Birmingham Birmingham Warning Letter N/A   52.4708757 -1.8966158
14558 op-snap---monthly-publication-june-2025.pdf   487 2025-06 Car Seat Arona Red Driving without Reasonable Consideration None Yorkminster Drive Yorkminster Drive Birmingham Birmingham Warning Letter N/A      
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
14912 op-snap---monthly-publication-june-2025.pdf   841 2025-06 Car Seat Toledo Beige Contravening a Red Traffic Light None NP Np Birmingham Birmingham 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
15002 op-snap---monthly-publication-june-2025.pdf   931 2025-06 Car Seat Ibiza Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A   52.4833672 -1.7871439
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
15674 op-snap---monthly-publication-june-2025.pdf   1603 2025-06 Pedal Bike Seat Leon Grey Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Gibbins Road Gibbins Road Birmingham Birmingham Warning Letter N/A   52.4390303 -1.9512931
15910 op-snap---monthly-publication-june-2025.pdf   1839 2025-06 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Road, Yardley Church Road, Yardley Birmingham Birmingham Warning Letter N/A   52.4655896 -1.8112542
15911 op-snap---monthly-publication-june-2025.pdf   1840 2025-06 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Road, Yardley Church Road, Yardley Birmingham Birmingham Warning Letter N/A   52.4655896 -1.8112542

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