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

331 rows where disposal = "Fixed Penalty", month = "2025-01" and reporter_transport_mode = "Pedestrian" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, witness_contacted

vehicle_make 28

  • Ford 42
  • BMW 41
  • Mercedes-Benz 35
  • Toyota 34
  • Audi 29
  • Volkswagen 29
  • Vauxhall 18
  • Nissan 13
  • Renault 12
  • Seat 11
  • Peugeot 9
  • Land Rover 7
  • Citroen 6
  • Honda 6
  • Hyundai 5
  • Mg 5
  • Mazda 4
  • Porsche 4
  • Mini 3
  • Volvo 3
  • Fiat 2
  • Kia 2
  • Lexus 2
  • Mitsubishi 2
  • Skoda 2
  • Chysler 1
  • Lamborghini 1
  • Tesla 1

offence 18

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 117
  • Cause vehicle to be left in a dangerous position 95
  • Stop a vehicle within pelican pedestrian crossing limits 36
  • Using a Mobile Phone Whilst Driving 30
  • Stop a vehicle on pedestrian crossing 15
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 12
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 9
  • Driving without Due Care and Attention 4
  • Waiting on a road in a prohibited area 3
  • Contravening a Red Traffic Light 2
  • Driving a vehicle wholly or partly on a footpath 1
  • Driving without Reasonable Consideration 1
  • Fail to display front VRM plate 1
  • Keeping a vehicle with registration marks obscured 1
  • Motor vehicle fail to accord precedence at a pelican crossing 1
  • Use vehicle on a road without valid test certificate 1
  • VRM fails to conform to Regulations 1
  • fail to comply with a non endorsable traffic sign 1

council_area 8

  • Birmingham 252
  • Sutton Coldfield 20
  • Sandwell 15
  • Coventry 14
  • Dudley 11
  • Solihull 9
  • Wolverhampton 6
  • Walsall 4

reporter_transport_mode 1

  • Pedestrian · 331 ✖

month 1

  • 2025-01 · 331 ✖

disposal 1

  • Fixed Penalty · 331 ✖
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
8893 op-snap---monthly-publication-january-2025.pdf   1 2025-01 Pedestrian Ford Fiesta Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Mapleton Road, Birmingham Mapleton Road, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4278334 -1.8282582
8894 op-snap---monthly-publication-january-2025.pdf   2 2025-01 Pedestrian Mazda 6TS Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Mapleton Road, Birmingham Mapleton Road, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4278334 -1.8282582
8915 op-snap---monthly-publication-january-2025.pdf   23 2025-01 Pedestrian Mercedes-Benz C220 Silver Cause vehicle to be left in a dangerous position None Avon Street Avon Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4556565 -1.8643304
8921 op-snap---monthly-publication-january-2025.pdf   29 2025-01 Pedestrian Volkswagen Golf Black Stop a vehicle within pelican pedestrian crossing limits None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
8939 op-snap---monthly-publication-january-2025.pdf   47 2025-01 Pedestrian Volkswagen Golf Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None STRATFORD ROAD Stratford Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4203897 -1.8338574
8957 op-snap---monthly-publication-january-2025.pdf   65 2025-01 Pedestrian Toyota NOAH White Stop a vehicle within pelican pedestrian crossing limits None OULTON BOULEVARD Oulton Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
8958 op-snap---monthly-publication-january-2025.pdf   66 2025-01 Pedestrian Mercedes-Benz C300 White Stop a vehicle within pelican pedestrian crossing limits None OULTON BOULEVARD Oulton Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
8959 op-snap---monthly-publication-january-2025.pdf   67 2025-01 Pedestrian Toyota YARIS Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None WARWICK ROAD Warwick Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4555288 -1.8613929
8965 op-snap---monthly-publication-january-2025.pdf   73 2025-01 Pedestrian BMW 740D Blue Cause vehicle to be left in a dangerous position None ST PAULS ROAD St Pauls Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4591176 -1.8850574
8981 op-snap---monthly-publication-january-2025.pdf   89 2025-01 Pedestrian Audi A6 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cotterills Lane Cotterills Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4884297 -1.817811
8990 op-snap---monthly-publication-january-2025.pdf   98 2025-01 Pedestrian Nissan X-trail Orange Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4274335 -1.5002381
8991 op-snap---monthly-publication-january-2025.pdf   99 2025-01 Pedestrian Ford Focus Blue Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4274335 -1.5002381
8999 op-snap---monthly-publication-january-2025.pdf   107 2025-01 Pedestrian Toyota Yaris Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Charles Road Charles Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5094492 -1.9113648
9000 op-snap---monthly-publication-january-2025.pdf   108 2025-01 Pedestrian BMW COMPETITION Blue Driving without Due Care and Attention VRM fails to conform to Regulations MERRYHILL CENTRE CAR PARK 7 Merryhill Centre Car Park 7 Dudley Dudley Fixed Penalty N/A Yes - Via Email    
9002 op-snap---monthly-publication-january-2025.pdf   110 2025-01 Pedestrian Vauxhall Insignia Grey Stop a vehicle within pelican pedestrian crossing limits None Kingstanding Road Kingstanding Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5521118 -1.8845138
9003 op-snap---monthly-publication-january-2025.pdf   111 2025-01 Pedestrian Ford Focus Grey Stop a vehicle within pelican pedestrian crossing limits None Kingstanding Road Kingstanding Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5521118 -1.8845138
9008 op-snap---monthly-publication-january-2025.pdf   116 2025-01 Pedestrian Mercedes-Benz Sprinter White Cause vehicle to be left in a dangerous position None Alcester Road South Alcester Road South Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4170522 -1.8906187
9017 op-snap---monthly-publication-january-2025.pdf   125 2025-01 Pedestrian Mg HS TROPHY Black Stop a vehicle within pelican pedestrian crossing limits None HIGH STREET,KINGS HEATH High Street, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4353506 -1.8927483
9032 op-snap---monthly-publication-january-2025.pdf   140 2025-01 Pedestrian Peugeot Expert Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wordsworth Road Wordsworth Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4671767 -1.8562212
9035 op-snap---monthly-publication-january-2025.pdf   143 2025-01 Pedestrian Mercedes-Benz C220 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Roseberry Street Roseberry Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9040 op-snap---monthly-publication-january-2025.pdf   148 2025-01 Pedestrian BMW 520D Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9041 op-snap---monthly-publication-january-2025.pdf   149 2025-01 Pedestrian Nissan Xtrail Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9042 op-snap---monthly-publication-january-2025.pdf   150 2025-01 Pedestrian BMW 420D Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9044 op-snap---monthly-publication-january-2025.pdf   152 2025-01 Pedestrian Toyota Prius White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9045 op-snap---monthly-publication-january-2025.pdf   153 2025-01 Pedestrian Audi A3 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9046 op-snap---monthly-publication-january-2025.pdf   154 2025-01 Pedestrian Nissan Micra Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9048 op-snap---monthly-publication-january-2025.pdf   156 2025-01 Pedestrian Toyota Prius White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9049 op-snap---monthly-publication-january-2025.pdf   157 2025-01 Pedestrian Honda CRV Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9050 op-snap---monthly-publication-january-2025.pdf   158 2025-01 Pedestrian Honda Jazz Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9051 op-snap---monthly-publication-january-2025.pdf   159 2025-01 Pedestrian Renault Arkana Orange Stop a vehicle on pedestrian crossing None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9055 op-snap---monthly-publication-january-2025.pdf   163 2025-01 Pedestrian Volkswagen TIGUAN Grey Stop a vehicle on pedestrian crossing None Church Road, Moseley Church Road, Moseley Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4494933 -1.8812882
9062 op-snap---monthly-publication-january-2025.pdf   170 2025-01 Pedestrian Volkswagen Tiguan Black Stop a vehicle on pedestrian crossing None Hollyfast Road Hollyfast Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4230701 -1.5346523
9070 op-snap---monthly-publication-january-2025.pdf   178 2025-01 Pedestrian Nissan Micra Red Stop a vehicle within pelican pedestrian crossing limits None Birmingham Road Birmingham Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5505398 -1.8252993
9071 op-snap---monthly-publication-january-2025.pdf   179 2025-01 Pedestrian BMW I8 Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
9073 op-snap---monthly-publication-january-2025.pdf   181 2025-01 Pedestrian Peugeot 2008 Grey Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5265939 -1.8509884
9074 op-snap---monthly-publication-january-2025.pdf   182 2025-01 Pedestrian Peugeot 2008GT Black Stop a vehicle on pedestrian crossing None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
9075 op-snap---monthly-publication-january-2025.pdf   183 2025-01 Pedestrian Renault Arkana White Stop a vehicle on pedestrian crossing None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
9077 op-snap---monthly-publication-january-2025.pdf   185 2025-01 Pedestrian Volkswagen Golf Silver Stop a vehicle on pedestrian crossing None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
9078 op-snap---monthly-publication-january-2025.pdf   186 2025-01 Pedestrian Ford Fiesta White Stop a vehicle on pedestrian crossing None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
9079 op-snap---monthly-publication-january-2025.pdf   187 2025-01 Pedestrian Mg three White Stop a vehicle on pedestrian crossing None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
9082 op-snap---monthly-publication-january-2025.pdf   190 2025-01 Pedestrian Vauxhall Zafira Black Stop a vehicle on pedestrian crossing None St Marys Row Street Marys Row Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9083 op-snap---monthly-publication-january-2025.pdf   191 2025-01 Pedestrian Audi A6 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4306504 -1.878052
9084 op-snap---monthly-publication-january-2025.pdf   192 2025-01 Pedestrian BMW X5 White Cause vehicle to be left in a dangerous position None Hollie Lucas Road Hollie Lucas Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4263502 -1.8840926
9100 op-snap---monthly-publication-january-2025.pdf   208 2025-01 Pedestrian Seat Ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Marsham Road, Birmingham Marsham Road, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4117052 -1.888565
9101 op-snap---monthly-publication-january-2025.pdf   209 2025-01 Pedestrian Toyota Corolla Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Howard Road, Birmingham Howard Road, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4632124 -1.8211129
9116 op-snap---monthly-publication-january-2025.pdf   224 2025-01 Pedestrian Audi Q7 Black Stop a vehicle within pelican pedestrian crossing limits None High Street, Kings Heath High Street, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4353506 -1.8927483
9126 op-snap---monthly-publication-january-2025.pdf   234 2025-01 Pedestrian Volkswagen Troc Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Silver Street Silver Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.433129 -1.8963794
9130 op-snap---monthly-publication-january-2025.pdf   238 2025-01 Pedestrian Ford Fiesta Black Cause vehicle to be left in a dangerous position None Colmore Road Colmore Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4296373 -1.8993161
9134 op-snap---monthly-publication-january-2025.pdf   242 2025-01 Pedestrian BMW 320 White Stop a vehicle within pelican pedestrian crossing limits None STONEY STANTON ROAD Stoney Stanton Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4221152 -1.4959475
9138 op-snap---monthly-publication-january-2025.pdf   246 2025-01 Pedestrian Seat Ateca Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None A34 Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4203897 -1.8338574
9142 op-snap---monthly-publication-january-2025.pdf   250 2025-01 Pedestrian Vauxhall Corsa Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Alcester Road, Moseley Alcester Road, Moseley Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4445135 -1.8907323
9148 op-snap---monthly-publication-january-2025.pdf   256 2025-01 Pedestrian Ford Fiesta Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None School Road, Kings Heath School Road, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4384417 -1.8875299
9149 op-snap---monthly-publication-january-2025.pdf   257 2025-01 Pedestrian BMW 218 Grey Cause vehicle to be left in a dangerous position None Prospect Street, Tipton Prospect Street, Tipton Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9152 op-snap---monthly-publication-january-2025.pdf   260 2025-01 Pedestrian Ford Transit White Cause vehicle to be left in a dangerous position None Sherlock Street Sherlock Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4702385 -1.895011
9171 op-snap---monthly-publication-january-2025.pdf   279 2025-01 Pedestrian BMW 318 Black Driving without Due Care and Attention None Sherborne Street Sherborne Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4762433 -1.9176665
9178 op-snap---monthly-publication-january-2025.pdf   286 2025-01 Pedestrian Mg HS Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Warwick Road Warwick Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4555288 -1.8613929
9179 op-snap---monthly-publication-january-2025.pdf   287 2025-01 Pedestrian Audi RS4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Warwick Road Warwick Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4555288 -1.8613929
9189 op-snap---monthly-publication-january-2025.pdf   297 2025-01 Pedestrian Ford Fiesta Silver Using a Mobile Phone Whilst Driving None Sandon Rd, Edgbaston Sandon Road, Edgbaston Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4733908 -1.9577579
9190 op-snap---monthly-publication-january-2025.pdf   298 2025-01 Pedestrian BMW IX2 Black Cause vehicle to be left in a dangerous position None Colmore Rd, Kings Heath Colmore Road, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4275798 -1.8997048
9199 op-snap---monthly-publication-january-2025.pdf   307 2025-01 Pedestrian Vauxhall Astra Blue Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Glenville Drive Glenville Drive Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5265939 -1.8509884
9201 op-snap---monthly-publication-january-2025.pdf   309 2025-01 Pedestrian Seat Leon Silver Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5265939 -1.8509884
9202 op-snap---monthly-publication-january-2025.pdf   310 2025-01 Pedestrian Mercedes-Benz A220 Grey Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5265939 -1.8509884
9203 op-snap---monthly-publication-january-2025.pdf   311 2025-01 Pedestrian Mercedes-Benz GLB-200 Blue Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5265939 -1.8509884
9204 op-snap---monthly-publication-january-2025.pdf   312 2025-01 Pedestrian Renault Clio Red Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5265939 -1.8509884
9212 op-snap---monthly-publication-january-2025.pdf   320 2025-01 Pedestrian Ford GALAXY Blue Cause vehicle to be left in a dangerous position None NORTHFIELD ROAD Northfield Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4167654 -1.9411244
9213 op-snap---monthly-publication-january-2025.pdf   321 2025-01 Pedestrian BMW X5 Black Stop a vehicle within pelican pedestrian crossing limits None WARSTONE LANE Warstone Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4870496 -1.912873
9224 op-snap---monthly-publication-january-2025.pdf   332 2025-01 Pedestrian Porsche CAYENNE Grey Cause vehicle to be left in a dangerous position None ST MARYS ROW St Marys Row Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4854305 -1.8963964
9265 op-snap---monthly-publication-january-2025.pdf   373 2025-01 Pedestrian BMW 420 Black Cause vehicle to be left in a dangerous position None Colmore Road Colmore Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4296373 -1.8993161
9273 op-snap---monthly-publication-january-2025.pdf   381 2025-01 Pedestrian Vauxhall VIVARO White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None OULTON BOULEVARD Oulton Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9275 op-snap---monthly-publication-january-2025.pdf   383 2025-01 Pedestrian Toyota YARIS Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None OULTON BOULEVARD Oulton Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9276 op-snap---monthly-publication-january-2025.pdf   384 2025-01 Pedestrian Chysler YPSILON White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None SHAFTMOOR LANE Shaftmoor Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4418944 -1.8407335
9277 op-snap---monthly-publication-january-2025.pdf   385 2025-01 Pedestrian Nissan NOTE Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None SHAFTMOOR LANE Shaftmoor Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4418944 -1.8407335
9279 op-snap---monthly-publication-january-2025.pdf   387 2025-01 Pedestrian Toyota ESTIMA White Cause vehicle to be left in a dangerous position None SHAFTMOOR LANE Shaftmoor Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4418944 -1.8407335
9283 op-snap---monthly-publication-january-2025.pdf   391 2025-01 Pedestrian Ford C Max Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
9293 op-snap---monthly-publication-january-2025.pdf   401 2025-01 Pedestrian Volkswagen Golf Grey Stop a vehicle within pelican pedestrian crossing limits None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
9306 op-snap---monthly-publication-january-2025.pdf   414 2025-01 Pedestrian Ford Kuga Grey Cause vehicle to be left in a dangerous position None Warstock Road Warstock Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.413031 -1.8782144
9314 op-snap---monthly-publication-january-2025.pdf   422 2025-01 Pedestrian Mercedes-Benz benz Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Formans Road Formans Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4482024 -1.8507493
9317 op-snap---monthly-publication-january-2025.pdf   425 2025-01 Pedestrian Mercedes-Benz BENZ C220 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None ST OSWALDS ROAD St Oswalds Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4689144 -1.8518155
9318 op-snap---monthly-publication-january-2025.pdf   426 2025-01 Pedestrian Toyota YARIS Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None SOMERVILLE ROAD Somerville Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5555545 -1.8329387
9319 op-snap---monthly-publication-january-2025.pdf   427 2025-01 Pedestrian BMW 320I Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None SOMERVILLE ROAD Somerville Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5555545 -1.8329387
9320 op-snap---monthly-publication-january-2025.pdf   428 2025-01 Pedestrian Nissan QASHQUI Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area NONE COVENTRY ROAD Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032
9321 op-snap---monthly-publication-january-2025.pdf   429 2025-01 Pedestrian Mercedes-Benz SPRINTER White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None MARCOT ROAD Marcot Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4565799 -1.7982778
9329 op-snap---monthly-publication-january-2025.pdf   437 2025-01 Pedestrian BMW X5 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Brandwood Park Road Brandwood Park Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4138206 -1.9041686
9333 op-snap---monthly-publication-january-2025.pdf   441 2025-01 Pedestrian BMW 320D Black Stop a vehicle on pedestrian crossing None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5361464 -1.8270283
9334 op-snap---monthly-publication-january-2025.pdf   442 2025-01 Pedestrian BMW 218D White Stop a vehicle within pelican pedestrian crossing limits None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5361464 -1.8270283
9342 op-snap---monthly-publication-january-2025.pdf   450 2025-01 Pedestrian Vauxhall CORSA White Cause vehicle to be left in a dangerous position No Insurance WINDSOR STREET Windsor Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4897606 -1.8829894
9343 op-snap---monthly-publication-january-2025.pdf   451 2025-01 Pedestrian Mercedes-Benz BENZ Grey Cause vehicle to be left in a dangerous position None FORSTER STREET Forster Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4851164 -1.8813304
9344 op-snap---monthly-publication-january-2025.pdf   452 2025-01 Pedestrian Land Rover VELAR Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None FORSTER STREET Forster Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4851164 -1.8813304
9353 op-snap---monthly-publication-january-2025.pdf   461 2025-01 Pedestrian Nissan QASHQAI Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Station Road, MArston Green Station Road, MArston Green Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.4667342 -1.747421
9354 op-snap---monthly-publication-january-2025.pdf   462 2025-01 Pedestrian Nissan MICRA Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None COTTESBROOKE ROAD Cottesbrooke Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4525779 -1.8169991
9356 op-snap---monthly-publication-january-2025.pdf   464 2025-01 Pedestrian Seat LEON Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Breedon Road Breedon Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4191978 -1.9251219
9362 op-snap---monthly-publication-january-2025.pdf   470 2025-01 Pedestrian Mercedes-Benz Sprinter White Stop a vehicle on pedestrian crossing None Crankhall Lane Crankhall Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email    
9370 op-snap---monthly-publication-january-2025.pdf   478 2025-01 Pedestrian Ford Fiesta Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None School Road School Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4161736 -1.8619692
9380 op-snap---monthly-publication-january-2025.pdf   488 2025-01 Pedestrian BMW 335 Black Using a Mobile Phone Whilst Driving None Lavender Avenue Lavender Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4186136 -1.5338521
9385 op-snap---monthly-publication-january-2025.pdf   493 2025-01 Pedestrian Mazda Mazda 2 Red Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Regent Place Regent Place Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4860376 -1.9095854
9394 op-snap---monthly-publication-january-2025.pdf   502 2025-01 Pedestrian BMW X5 White Cause vehicle to be left in a dangerous position None Hollie Lucas Road Hollie Lucas Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4263502 -1.8840926
9400 op-snap---monthly-publication-january-2025.pdf   508 2025-01 Pedestrian Mercedes-Benz A160 Black Driving without Reasonable Consideration None George Street George Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5048075 -1.9545728
9406 op-snap---monthly-publication-january-2025.pdf   514 2025-01 Pedestrian Toyota Yaris Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None ALCESTER ROAD, KINGS HEATH Alcester Road, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4467439 -1.8881358
9414 op-snap---monthly-publication-january-2025.pdf   522 2025-01 Pedestrian Ford TRANSIT White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None SCHOOL ROAD, MOSELEY School Road, Moseley Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4422276 -1.8844845
9418 op-snap---monthly-publication-january-2025.pdf   526 2025-01 Pedestrian Toyota Auris Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Vicarage road Vicarage road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.470423 -1.9304786

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