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

106 rows where disposal = "Fixed Penalty", offence = "Stop a vehicle within pelican pedestrian crossing limits" and reporter_transport_mode = "Pedestrian" 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

reporter_transport_mode 1

  • Pedestrian · 106 ✖

offence 1

  • Stop a vehicle within pelican pedestrian crossing limits · 106 ✖

disposal 1

  • Fixed Penalty · 106 ✖
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
11744 op-snap---monthly-publication-january-2026.pdf   1205 2026-01 Pedestrian Ford Focus White Stop a vehicle within pelican pedestrian crossing limits None Cherry Orchard Road Cherry Orchard Road Birmingham Birmingham Fixed Penalty N/A   52.5206297 -1.9208426
4568 op-snap---monthly-publication-december-2025.pdf   696 2025-12 Pedestrian Renault Clio Blue Stop a vehicle within pelican pedestrian crossing limits None Bromford Road, Hodge Hill Bromford Road, Hodge Hill Birmingham Birmingham Fixed Penalty N/A   52.503036 -1.8289972
4933 op-snap---monthly-publication-december-2025.pdf   1061 2025-12 Pedestrian Toyota Yaris blue Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Fixed Penalty N/A   52.4929304 -1.8229092
4934 op-snap---monthly-publication-december-2025.pdf   1062 2025-12 Pedestrian Hyundai Ionic Silver Stop a vehicle within pelican pedestrian crossing limits None Wasgwood Heath Road Wasgwood Heath Road Birmingham Birmingham Fixed Penalty N/A      
5004 op-snap---monthly-publication-december-2025.pdf   1132 2025-12 Pedestrian Renault Scenic Red Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Fixed Penalty N/A   52.4929304 -1.8229092
21714 op-snap---monthly-publication-november-2025.pdf   1256 2025-11 Pedestrian Toyota Auris Grey Stop a vehicle within pelican pedestrian crossing limits No vehicle excise licence Washwood Heath Road Washwood Heath Road Birmingham Birmingham Fixed Penalty N/A   52.4929304 -1.8229092
14616 op-snap---monthly-publication-june-2025.pdf   545 2025-06 Pedestrian BMW I4 White Stop a vehicle within pelican pedestrian crossing limits None A38 Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A   52.5113867 -1.8337258
14976 op-snap---monthly-publication-june-2025.pdf   905 2025-06 Pedestrian Ford Transit White Stop a vehicle within pelican pedestrian crossing limits None Kings heath high st at Institute Road Kings heath high st at Institute Road Birmingham Birmingham Fixed Penalty N/A   52.4391028 -1.893289
14998 op-snap---monthly-publication-june-2025.pdf   927 2025-06 Pedestrian Mercedes-Benz Sprinter White Stop a vehicle within pelican pedestrian crossing limits None Cherry Orchard Road Cherry Orchard Road Birmingham Birmingham Fixed Penalty N/A   52.5206297 -1.9208426
16024 op-snap---monthly-publication-june-2025.pdf   1953 2025-06 Pedestrian Volkswagen Touran Silver Stop a vehicle within pelican pedestrian crossing limits None Albany Road Albany Road Birmingham Birmingham Fixed Penalty N/A   52.4591259 -1.9506139
18802 op-snap---monthly-publication-may-2025.pdf   164 2025-05 Pedestrian Lexus 300 H White Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
19869 op-snap---monthly-publication-may-2025.pdf   1231 2025-05 Pedestrian Peugeot 3008 Red Stop a vehicle within pelican pedestrian crossing limits None Avenue Road Avenue Road Birmingham Birmingham Fixed Penalty N/A   52.4941712 -1.8795158
19895 op-snap---monthly-publication-may-2025.pdf   1257 2025-05 Pedestrian Ford RANGER Black Stop a vehicle within pelican pedestrian crossing limits None KINGS HEATH HIGH STREET Kings Heath High Street Birmingham Birmingham Fixed Penalty N/A   52.4391028 -1.893289
69 op-snap---monthly-publication-april-2025.pdf   68 2025-04 Pedestrian Volkswagen Touraeg Black Stop a vehicle within pelican pedestrian crossing limits None Bell Hill Northfield Bell Hill Northfield Birmingham Birmingham Fixed Penalty N/A   52.4187936 -1.9691213
292 op-snap---monthly-publication-april-2025.pdf   291 2025-04 Pedestrian Mercedes-Benz C220 White Stop a vehicle within pelican pedestrian crossing limits None High Street, Kings Heath High Street, Kings Heath BOiurmt oinf gFhoarmce Boiurmt Oinf Gfhoarmce Fixed Penalty N/A   52.4353506 -1.8927483
372 op-snap---monthly-publication-april-2025.pdf   371 2025-04 Pedestrian Toyota Estima Silver Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A   52.4242527 -1.910803
384 op-snap---monthly-publication-april-2025.pdf   383 2025-04 Pedestrian Toyota Prius Black Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A   52.4242527 -1.910803
457 op-snap---monthly-publication-april-2025.pdf   456 2025-04 Pedestrian Volkswagen Polo Grey Stop a vehicle within pelican pedestrian crossing limits None Springfield Road Birmingham Springfield Road Birmingham Birmingham Birmingham Fixed Penalty N/A   52.4496153 -1.8646204
16252 op-snap---monthly-publication-march-2025.pdf   9 2025-03 Pedestrian   Panel Van White 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
16305 op-snap---monthly-publication-march-2025.pdf   62 2025-03 Pedestrian Skoda superb Grey Stop a vehicle within pelican pedestrian crossing limits None Dudley Rd, Winson Green Dudley Road, Winson Green Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4869559 -1.9311316
16544 op-snap---monthly-publication-march-2025.pdf   301 2025-03 Pedestrian Vauxhall van Silver Stop a vehicle within pelican pedestrian crossing limits None Bounrville Lane Bounrville Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
16644 op-snap---monthly-publication-march-2025.pdf   401 2025-03 Pedestrian Toyota Prius Black Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
16646 op-snap---monthly-publication-march-2025.pdf   403 2025-03 Pedestrian Volvo XC 90 Grey Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
16647 op-snap---monthly-publication-march-2025.pdf   404 2025-03 Pedestrian Mercedes-Benz E350 Grey Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
16648 op-snap---monthly-publication-march-2025.pdf   405 2025-03 Pedestrian Mitsubishi ASX 2 White Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
16649 op-snap---monthly-publication-march-2025.pdf   406 2025-03 Pedestrian Nissan Note Black Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
16650 op-snap---monthly-publication-march-2025.pdf   407 2025-03 Pedestrian Nissan Juke Grey Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
16701 op-snap---monthly-publication-march-2025.pdf   458 2025-03 Pedestrian Vauxhall corsa White Stop a vehicle within pelican pedestrian crossing limits None Poplar Rd Poplar Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.436035 -1.891685
16733 op-snap---monthly-publication-march-2025.pdf   490 2025-03 Pedestrian Nissan Qashqai Black Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Coventry Earlsdon Street Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3988977 -1.5323674
16766 op-snap---monthly-publication-march-2025.pdf   523 2025-03 Pedestrian BMW 520d Black 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
16826 op-snap---monthly-publication-march-2025.pdf   583 2025-03 Pedestrian Toyota Alphard Green Stop a vehicle within pelican pedestrian crossing limits None Coneybere Street Coneybere Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
17081 op-snap---monthly-publication-march-2025.pdf   838 2025-03 Pedestrian Fiat Ducato Yellow Stop a vehicle within pelican pedestrian crossing limits None Church Road Church Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4624743 -1.7763934
17346 op-snap---monthly-publication-march-2025.pdf   1103 2025-03 Pedestrian Audi A4 Black Stop a vehicle within pelican pedestrian crossing limits None Springfield Road Springfield Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4327486 -1.8844997
17347 op-snap---monthly-publication-march-2025.pdf   1104 2025-03 Pedestrian BMW 118 Black Stop a vehicle within pelican pedestrian crossing limits None Springfield Road Springfield Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4327486 -1.8844997
17422 op-snap---monthly-publication-march-2025.pdf   1179 2025-03 Pedestrian Mercedes-Benz Sprinter White 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
17455 op-snap---monthly-publication-march-2025.pdf   1212 2025-03 Pedestrian Ford Fiesta Blue Stop a vehicle within pelican pedestrian crossing limits None Albany Road Albany Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4006218 -1.5284125
17545 op-snap---monthly-publication-march-2025.pdf   1302 2025-03 Pedestrian Hyundai I10 Silver Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3988977 -1.5323674
17861 op-snap---monthly-publication-march-2025.pdf   1618 2025-03 Pedestrian Kia Picanto White Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3988977 -1.5323674
18080 op-snap---monthly-publication-march-2025.pdf   1837 2025-03 Pedestrian Ford C-Max Black Stop a vehicle within pelican pedestrian crossing limits None Hill Village Road Hill Village Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5959906 -1.8345802
18224 op-snap---monthly-publication-march-2025.pdf   1981 2025-03 Pedestrian Tesla Model Y White Stop a vehicle within pelican pedestrian crossing limits None Station Approach Station Approach Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.4146834 -1.7879896
5259 op-snap---monthly-publication-february-2025.pdf   76 2025-02 Pedestrian BMW X5 Black 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
5310 op-snap---monthly-publication-february-2025.pdf   127 2025-02 Pedestrian Ford Fiesta White Stop a vehicle within pelican pedestrian crossing limits None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4308271 -1.920078
5395 op-snap---monthly-publication-february-2025.pdf   212 2025-02 Pedestrian Toyota AURIS Silver Stop a vehicle within pelican pedestrian crossing limits None GARRETS GREEN LANE Garrets Green Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4657981 -1.7964101
5672 op-snap---monthly-publication-february-2025.pdf   489 2025-02 Pedestrian Seat Cupra Black Stop a vehicle within pelican pedestrian crossing limits None Pershore Road, Stirchley Pershore Road, Stirchley Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4274734 -1.9223167
5716 op-snap---monthly-publication-february-2025.pdf   533 2025-02 Pedestrian BMW 520d Blue Stop a vehicle within pelican pedestrian crossing limits None Olton Boulevard East Olton Boulevard East Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4421599 -1.829532
5836 op-snap---monthly-publication-february-2025.pdf   653 2025-02 Pedestrian BMW X6 Black Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Avenue, Coventry Earlsdon Avenue, Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.398248 -1.528263
5837 op-snap---monthly-publication-february-2025.pdf   654 2025-02 Pedestrian Peugeot 206 Blue Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Avenue, Coventry Earlsdon Avenue, Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.398248 -1.528263
5843 op-snap---monthly-publication-february-2025.pdf   660 2025-02 Pedestrian   Van White Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3988977 -1.5323674
5879 op-snap---monthly-publication-february-2025.pdf   696 2025-02 Pedestrian Toyota Auris Grey Stop a vehicle within pelican pedestrian crossing limits None Birmingham Road near Jockey Road Birmingham Road near Jockey Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.553171 -1.8275916
5946 op-snap---monthly-publication-february-2025.pdf   763 2025-02 Pedestrian Mazda 3 TS Silver Stop a vehicle within pelican pedestrian crossing limits None Leckie Road Leckie Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
6026 op-snap---monthly-publication-february-2025.pdf   843 2025-02 Pedestrian Toyota AURIS Black Stop a vehicle within pelican pedestrian crossing limits None DUDLEY ROAD,BLOXWICH Dudley Road, Bloxwich Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5813423 -1.9824315
6029 op-snap---monthly-publication-february-2025.pdf   846 2025-02 Pedestrian Audi A6 Red Stop a vehicle within pelican pedestrian crossing limits None DUDLEY ROAD Dudley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4865107 -1.9386263
6030 op-snap---monthly-publication-february-2025.pdf   847 2025-02 Pedestrian Mercedes-Benz A White Stop a vehicle within pelican pedestrian crossing limits None DUDLEY ROAD Dudley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4865107 -1.9386263
6134 op-snap---monthly-publication-february-2025.pdf   951 2025-02 Pedestrian Toyota Prius Silver Stop a vehicle within pelican pedestrian crossing limits None Dudley Road Dudley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4865107 -1.9386263
6147 op-snap---monthly-publication-february-2025.pdf   964 2025-02 Pedestrian Jaguar F PACE Black Stop a vehicle within pelican pedestrian crossing limits None EARLSDON STREET Earlsdon Street Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3988977 -1.5323674
6149 op-snap---monthly-publication-february-2025.pdf   966 2025-02 Pedestrian Nissan QASHQUI Black Stop a vehicle within pelican pedestrian crossing limits None EARLSDON STREET Earlsdon Street Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3988977 -1.5323674
6283 op-snap---monthly-publication-february-2025.pdf   1100 2025-02 Pedestrian Volkswagen AMAROK Grey Stop a vehicle within pelican pedestrian crossing limits None WEST HEATH ROAD West Heath Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.402785 -1.9620058
6303 op-snap---monthly-publication-february-2025.pdf   1120 2025-02 Pedestrian Skoda Octavia Grey Stop a vehicle within pelican pedestrian crossing limits None St Mary's Row, Moseley Street Mary's Row, Moseley Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
6304 op-snap---monthly-publication-february-2025.pdf   1121 2025-02 Pedestrian Peugeot 408 Grey Stop a vehicle within pelican pedestrian crossing limits None St Mary's Row, Moseley Street Mary's Row, Moseley Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
6502 op-snap---monthly-publication-february-2025.pdf   1319 2025-02 Pedestrian Ford S Max Black 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
6547 op-snap---monthly-publication-february-2025.pdf   1364 2025-02 Pedestrian Seat Arona Red Stop a vehicle within pelican pedestrian crossing limits None Daylesford Road Daylesford Road Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.4479743 -1.7897267
6593 op-snap---monthly-publication-february-2025.pdf   1410 2025-02 Pedestrian Ford Focus Black Stop a vehicle within pelican pedestrian crossing limits None Crankhall Lane, Wednesbury Crankhall Lane, Wednesbury Walsall Walsall Fixed Penalty N/A Yes - Via Email    
6650 op-snap---monthly-publication-february-2025.pdf   1467 2025-02 Pedestrian Ford Fiesta White 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
6771 op-snap---monthly-publication-february-2025.pdf   1588 2025-02 Pedestrian BMW X7 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
6782 op-snap---monthly-publication-february-2025.pdf   1599 2025-02 Pedestrian Mercedes-Benz Van White Stop a vehicle within pelican pedestrian crossing limits None Alcester Road, Kings Heath Alcester Road, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4467439 -1.8881358
6917 op-snap---monthly-publication-february-2025.pdf   1734 2025-02 Pedestrian Honda CR Black Stop a vehicle within pelican pedestrian crossing limits None Bordsley Green Bordsley Green Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
7151 op-snap---monthly-publication-february-2025.pdf   1968 2025-02 Pedestrian Volkswagen TOURAN Silver Stop a vehicle within pelican pedestrian crossing limits None ALBANY ROAD Albany Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4006218 -1.5284125
7160 op-snap---monthly-publication-february-2025.pdf   1977 2025-02 Pedestrian Audi A6 Grey Stop a vehicle within pelican pedestrian crossing limits No vehicle excise licence BOURNVILLE LANE Bournville Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4271614 -1.9302862
7161 op-snap---monthly-publication-february-2025.pdf   1978 2025-02 Pedestrian Vauxhall COMBO Silver Stop a vehicle within pelican pedestrian crossing limits None BOURNVILLE LANE Bournville Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4271614 -1.9302862
7230 op-snap---monthly-publication-february-2025.pdf   2047 2025-02 Pedestrian Tesla Model Y White Stop a vehicle within pelican pedestrian crossing limits None Alcester Road South Alcester Road South Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4170522 -1.8906187
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
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    
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
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
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
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
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
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
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
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
9424 op-snap---monthly-publication-january-2025.pdf   532 2025-01 Pedestrian Hyundai I10 White Stop a vehicle within pelican pedestrian crossing limits None Edward Road Edward Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4580901 -1.894458
9469 op-snap---monthly-publication-january-2025.pdf   577 2025-01 Pedestrian Mercedes-Benz SPRINTER DROPSIDE White Stop a vehicle within pelican pedestrian crossing limits None DUDLEY ROAD Dudley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4865107 -1.9386263
9488 op-snap---monthly-publication-january-2025.pdf   596 2025-01 Pedestrian Audi A1 White Stop a vehicle within pelican pedestrian crossing limits None Linden Road Linden Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4263156 -1.9351622
9531 op-snap---monthly-publication-january-2025.pdf   639 2025-01 Pedestrian Toyota Yaris Silver Stop a vehicle within pelican pedestrian crossing limits None While Road While Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5577767 -1.825114
9598 op-snap---monthly-publication-january-2025.pdf   706 2025-01 Pedestrian Toyota Auris Silver Stop a vehicle within pelican pedestrian crossing limits None Dudley RD Dudley RD Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4865107 -1.9386263
9603 op-snap---monthly-publication-january-2025.pdf   711 2025-01 Pedestrian Vauxhall TOURAN SILVER Stop a vehicle within pelican pedestrian crossing limits None ALBANY ROAD Albany Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4006218 -1.5284125
9663 op-snap---monthly-publication-january-2025.pdf   771 2025-01 Pedestrian BMW X2 Grey Stop a vehicle within pelican pedestrian crossing limits None Francis Road Francis Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4798453 -1.8147402
9707 op-snap---monthly-publication-january-2025.pdf   815 2025-01 Pedestrian Seat Ateca Black Stop a vehicle within pelican pedestrian crossing limits None Allens Croft Road Allens Croft Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4242527 -1.910803
9713 op-snap---monthly-publication-january-2025.pdf   821 2025-01 Pedestrian Kia CEED 3 ISG Black Stop a vehicle within pelican pedestrian crossing limits None Moseley Road, Birmingham Moseley Road, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4679402 -1.881408
9729 op-snap---monthly-publication-january-2025.pdf   837 2025-01 Pedestrian   Sandero White Stop a vehicle within pelican pedestrian crossing limits None Kingstanding Road Kingstanding Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email    
9731 op-snap---monthly-publication-january-2025.pdf   839 2025-01 Pedestrian Land Rover Sport Black 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
9801 op-snap---monthly-publication-january-2025.pdf   909 2025-01 Pedestrian Ford Transit White Stop a vehicle within pelican pedestrian crossing limits None Crankhall Lane Crankhall Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9847 op-snap---monthly-publication-january-2025.pdf   955 2025-01 Pedestrian Ford Fiesta White Stop a vehicle within pelican pedestrian crossing limits None Barford Road Barford Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4850957 -1.9350668
9859 op-snap---monthly-publication-january-2025.pdf   967 2025-01 Pedestrian Ford Fiesta Blue Stop a vehicle within pelican pedestrian crossing limits None Albany Road Coventry Albany Road Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4006218 -1.5284125
9905 op-snap---monthly-publication-january-2025.pdf   1013 2025-01 Pedestrian Hyundai IONIQ Silver Stop a vehicle within pelican pedestrian crossing limits None HIGH STREET High Street Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.5635963 -2.0827567
9967 op-snap---monthly-publication-january-2025.pdf   1075 2025-01 Pedestrian Renault Megane Silver Stop a vehicle within pelican pedestrian crossing limits None uk Uk Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.45124 -1.937937
10031 op-snap---monthly-publication-january-2025.pdf   1139 2025-01 Pedestrian BMW 3 SERIES White Stop a vehicle within pelican pedestrian crossing limits None Antrobus Rd Antrobus Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5457851 -1.8457052
10038 op-snap---monthly-publication-january-2025.pdf   1146 2025-01 Pedestrian Skoda Fabia Beige Stop a vehicle within pelican pedestrian crossing limits None Crankhall Lane Crankhall Lane Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5489715 -1.9927402

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