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

125 rows where disposal = "Warning Letter", offence = "Driving without Reasonable Consideration" and reporter_transport_mode = "Pedal Bike" 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

reporter_transport_mode 1

  • Pedal Bike · 125 ✖

offence 1

  • Driving without Reasonable Consideration · 125 ✖

disposal 1

  • Warning Letter · 125 ✖
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
11000 op-snap---monthly-publication-january-2026.pdf   461 2026-01 Pedal Bike Volkswagen   Silver Driving without Reasonable Consideration None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
23830 op-snap---monthly-publication-september-2025.pdf   49 2025-09 Pedal Bike Audi A1 Grey Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Warning Letter N/A   52.4086244 -1.515132
23965 op-snap---monthly-publication-september-2025.pdf   184 2025-09 Pedal Bike Vauxhall Insignia Silver Driving without Reasonable Consideration None Station Road Marston Green Station Road Marston Green Solihull Solihull Warning Letter N/A   52.4667342 -1.747421
24013 op-snap---monthly-publication-september-2025.pdf   232 2025-09 Pedal Bike Peugeot 207 Black Driving without Reasonable Consideration None St Marys Row Street Marys Row Birmingham Birmingham Warning Letter N/A      
24800 op-snap---monthly-publication-september-2025.pdf   1019 2025-09 Pedal Bike Byd Bus Grey Driving without Reasonable Consideration None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter n/a   52.4221152 -1.4959475
11985 op-snap---monthly-publication-july-2025.pdf   37 2025-07 Pedal Bike Honda Insight Silver Driving without Reasonable Consideration None Parsonage Street, West Bromwich Parsonage Street, West Bromwich Sandwell Sandwell Warning Letter N/A   52.5306821 -1.9875151
12287 op-snap---monthly-publication-july-2025.pdf   339 2025-07 Pedal Bike Volvo V40 Blue Driving without Reasonable Consideration None 6 ways roundabout 6 Ways Roundabout Birmingham Birmingham Warning Letter N/A      
12687 op-snap---monthly-publication-july-2025.pdf   739 2025-07 Pedal Bike BMW 330E White Driving without Reasonable Consideration None A38 Tyburn Road Tyburn Road Birmingham Birmingham Warning Letter N/A   52.5113867 -1.8337258
14055 op-snap---monthly-publication-july-2025.pdf   2107 2025-07 Pedal Bike Vauxhall Grandland Blue Driving without Reasonable Consideration None Colehill Heath Colehill Heath Birmingham Birmingham Warning Letter N/A      
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
15634 op-snap---monthly-publication-june-2025.pdf   1563 2025-06 Pedal Bike Ford Puma White Driving without Reasonable Consideration None Long Mynd Road Long Mynd Road Birmingham Birmingham Warning Letter N/A   52.4257286 -1.9769008
15637 op-snap---monthly-publication-june-2025.pdf   1566 2025-06 Pedal Bike   WM BUS Red Driving without Reasonable Consideration None Gilson Way Gilson Way Birmingham Birmingham Warning Letter N/A      
18646 op-snap---monthly-publication-may-2025.pdf   8 2025-05 Pedal Bike Ford Puma Blue Driving without Reasonable Consideration None Moor Green Lane Moor Green Lane Birmingham Birmingham Warning Letter N/A   52.4374665 -1.9119895
18829 op-snap---monthly-publication-may-2025.pdf   191 2025-05 Pedal Bike Vauxhall Monovan White Driving without Reasonable Consideration None Racecourse Lane Racecourse Lane Metropolitan Boroug Metropolitan Boroug Warning Letter N/A   52.4377169 -2.1495045
18885 op-snap---monthly-publication-may-2025.pdf   247 2025-05 Pedal Bike Land Rover Sport Grey Driving without Reasonable Consideration None Lady Byron Lane Lady Byron Lane Solihull Solihull Warning Letter N/A   52.4026126 -1.7503668
18937 op-snap---monthly-publication-may-2025.pdf   299 2025-05 Pedal Bike Mercedes-Benz C220 White Driving without Reasonable Consideration None Waterfall Lane Waterfall Lane Dudley Dudley Warning Letter N/A      
19314 op-snap---monthly-publication-may-2025.pdf   676 2025-05 Pedal Bike Mini Countryman Grey Driving without Reasonable Consideration None Chester Road Chester Road Walsall Walsall Warning Letter N/A   52.5692139 -1.8799672
19393 op-snap---monthly-publication-may-2025.pdf   755 2025-05 Pedal Bike Ford Fiesta White Driving without Reasonable Consideration None South Road South Road Dudley Dudley Warning Letter N/A   52.4530371 -2.1660216
19678 op-snap---monthly-publication-may-2025.pdf   1040 2025-05 Pedal Bike Volkswagen Caddy White Driving without Reasonable Consideration None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
83 op-snap---monthly-publication-april-2025.pdf   82 2025-04 Pedal Bike Volkswagen Golf Black Driving without Reasonable Consideration No Insurance Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
88 op-snap---monthly-publication-april-2025.pdf   87 2025-04 Pedal Bike BMW X6 White Driving without Reasonable Consideration None Avenue Road Avenue Road Birmingham Birmingham Warning Letter N/A   52.4941712 -1.8795158
101 op-snap---monthly-publication-april-2025.pdf   100 2025-04 Pedal Bike Volvo V40 Grey Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham Warning Letter N/A   52.4119174 -1.9735247
117 op-snap---monthly-publication-april-2025.pdf   116 2025-04 Pedal Bike Audi A4 Grey Driving without Reasonable Consideration None Henley Road Henley Road Coventry Coventry Warning Letter N/A   52.4307281 -1.462755
118 op-snap---monthly-publication-april-2025.pdf   117 2025-04 Pedal Bike Renault Captur Grey Driving without Reasonable Consideration None Coventry Road Coventry Road Coventry Coventry Warning Letter N/A   52.4111289 -1.5094345
153 op-snap---monthly-publication-april-2025.pdf   152 2025-04 Pedal Bike Renault CLIO Red Driving without Reasonable Consideration No vehicle excise licence LAKEFIELD ROAD Lakefield Road Wolverhampton Wolverhampton Warning Letter N/A   52.6034624 -2.0730393
154 op-snap---monthly-publication-april-2025.pdf   153 2025-04 Pedal Bike Vauxhall Corsa Black Driving without Reasonable Consideration None Oxford Road Oxford Road Birmingham Birmingham Warning Letter N/A   52.4456323 -1.8858352
157 op-snap---monthly-publication-april-2025.pdf   156 2025-04 Pedal Bike   COMPASS Red Driving without Reasonable Consideration None A4030 BEARWOOD ROAD A4030 Bearwood Road Birmingham Birmingham Warning Letter N/A      
254 op-snap---monthly-publication-april-2025.pdf   253 2025-04 Pedal Bike Audi A3 Black Driving without Reasonable Consideration None High St High Street Birmingham Birmingham Warning Letter N/A   52.5254588 -1.8373064
524 op-snap---monthly-publication-april-2025.pdf   523 2025-04 Pedal Bike BMW 840D Black Driving without Reasonable Consideration None Raddlebarn Rd Raddlebarn Road Birmingham Birmingham Warning Letter N/A   52.4397168 -1.9260414
542 op-snap---monthly-publication-april-2025.pdf   541 2025-04 Pedal Bike Vauxhall Corsa Red Driving without Reasonable Consideration None A38 Kingsbury Road Kingsbury Road Birmingham Birmingham Warning Letter N/A   52.5292752 -1.7618805
546 op-snap---monthly-publication-april-2025.pdf   545 2025-04 Pedal Bike BMW X1 Brown Driving without Reasonable Consideration None Shenley Lane Shenley Lane Birmingham Birmingham Warning Letter N/A   52.430111 -1.9753703
737 op-snap---monthly-publication-april-2025.pdf   736 2025-04 Pedal Bike Audi A5 Blue Driving without Reasonable Consideration None Winding House Lane Winding House Lane Coventry Coventry Warning Letter N/A   52.4490457 -1.5001195
738 op-snap---monthly-publication-april-2025.pdf   737 2025-04 Pedal Bike Peugeot 207 Silver Driving without Reasonable Consideration None Sewall Highway Sewall Highway Coventry Coventry Warning Letter N/A   52.4318623 -1.4804069
757 op-snap---monthly-publication-april-2025.pdf   756 2025-04 Pedal Bike BMW X3 White Driving without Reasonable Consideration None Shannon Road Shannon Road Birmingham Birmingham Warning Letter N/A   52.4008254 -1.9287243
16390 op-snap---monthly-publication-march-2025.pdf   147 2025-03 Pedal Bike Audi A5 Grey Driving without Reasonable Consideration None Icknield Port Road Icknield Port Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4792334 -1.92925
16416 op-snap---monthly-publication-march-2025.pdf   173 2025-03 Pedal Bike Renault Clio Silver Driving without Reasonable Consideration None Newton Road, Scott Arms Newton Road, Scott Arms Birmingham Birmingham Warning Letter N/A Yes - Via Email    
16446 op-snap---monthly-publication-march-2025.pdf   203 2025-03 Pedal Bike Daf Ssmart Silver Driving without Reasonable Consideration None Selly Park Road Selly Park Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4390561 -1.9209229
16505 op-snap---monthly-publication-march-2025.pdf   262 2025-03 Pedal Bike Hyundai Kona Black Driving without Reasonable Consideration None Grange Road Grange Road Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A Yes - Via Email 52.4460133 -1.9330868
16579 op-snap---monthly-publication-march-2025.pdf   336 2025-03 Pedal Bike Toyota Yaris Black Driving without Reasonable Consideration None Walsall Wood Road Walsall Wood Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5623476 -1.9436356
16637 op-snap---monthly-publication-march-2025.pdf   394 2025-03 Pedal Bike Mercedes-Benz GLA 220 White Driving without Reasonable Consideration None Dickens Heath Road Dickens Heath Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3875525 -1.8339426
16638 op-snap---monthly-publication-march-2025.pdf   395 2025-03 Pedal Bike Ford Transit Grey Driving without Reasonable Consideration None Frogmill Lane Frogmill Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4023807 -2.0047634
16774 op-snap---monthly-publication-march-2025.pdf   531 2025-03 Pedal Bike Nissan NAVARA White Driving without Reasonable Consideration None BRISTOL ROAD Bristol Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4543565 -1.9114004
16778 op-snap---monthly-publication-march-2025.pdf   535 2025-03 Pedal Bike Land Rover EVOQUE Black Driving without Reasonable Consideration None UPPER HOLLAND ROAD Upper Holland Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.561 -1.8187105
16888 op-snap---monthly-publication-march-2025.pdf   645 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Friday Lane Friday Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.4142542 -1.7217662
16903 op-snap---monthly-publication-march-2025.pdf   660 2025-03 Pedal Bike Volkswagen Caddy White Driving without Reasonable Consideration None Long Acre Long Acre Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5051253 -1.8646383
16969 op-snap---monthly-publication-march-2025.pdf   726 2025-03 Pedal Bike Peugeot 308 Grey Driving without Reasonable Consideration None Cliff Road Road Cliff Road Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email    
17002 op-snap---monthly-publication-march-2025.pdf   759 2025-03 Pedal Bike Toyota Prius White Driving without Reasonable Consideration None Humber Road Humber Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4050667 -1.4866877
17014 op-snap---monthly-publication-march-2025.pdf   771 2025-03 Pedal Bike Mercedes-Benz Box van White Driving without Reasonable Consideration None Holiday Street Holiday Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4757071 -1.8988573
17016 op-snap---monthly-publication-march-2025.pdf   773 2025-03 Pedal Bike Audi A3 Silver Driving without Reasonable Consideration None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.471632 -1.9456776
17050 op-snap---monthly-publication-march-2025.pdf   807 2025-03 Pedal Bike Lexus ch200 Black Driving without Reasonable Consideration None Grantham Road Grantham Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4624098 -1.8708709
17054 op-snap---monthly-publication-march-2025.pdf   811 2025-03 Pedal Bike Vauxhall Astra Blue Driving without Reasonable Consideration None Foles Hill Road Foleshill Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4274335 -1.5002381
17056 op-snap---monthly-publication-march-2025.pdf   813 2025-03 Pedal Bike Honda Jazz Blue Driving without Reasonable Consideration None Warwick Road Warwick Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.401916 -1.5154953
17304 op-snap---monthly-publication-march-2025.pdf   1061 2025-03 Pedal Bike Kia Sportage White Driving without Reasonable Consideration None Holyhead Road Holyhead Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.418488 -1.5472387
17355 op-snap---monthly-publication-march-2025.pdf   1112 2025-03 Pedal Bike Volvo XC40 Blue Driving without Reasonable Consideration None Quinton Rd Quinton Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.447826 -1.9574468
17464 op-snap---monthly-publication-march-2025.pdf   1221 2025-03 Pedal Bike Ford Transit Silver Driving without Reasonable Consideration None Hill Street Hill Street Coventry Coventry Warning Letter N/A Yes - Via Email 52.4094312 -1.51615
17465 op-snap---monthly-publication-march-2025.pdf   1222 2025-03 Pedal Bike Ford Focus Black Driving without Reasonable Consideration None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4063195 -1.5157306
17504 op-snap---monthly-publication-march-2025.pdf   1261 2025-03 Pedal Bike Ford Ranger Black Driving without Reasonable Consideration None Warwick Road Warwick Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.4428606 -1.812114
17514 op-snap---monthly-publication-march-2025.pdf   1271 2025-03 Pedal Bike Chevrolet Trax White Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4543565 -1.9114004
17625 op-snap---monthly-publication-march-2025.pdf   1382 2025-03 Pedal Bike Audi A3 Silver Driving without Reasonable Consideration No vehicle excise licence Lea Road Lea Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4533235 -1.8606305
17747 op-snap---monthly-publication-march-2025.pdf   1504 2025-03 Pedal Bike Ford Fiesta Blue Driving without Reasonable Consideration None Highfield road Highfield road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4216321 -1.855984
17850 op-snap---monthly-publication-march-2025.pdf   1607 2025-03 Pedal Bike Ford Ranger Black Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5359496 -1.8324115
17852 op-snap---monthly-publication-march-2025.pdf   1609 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Chester Rd Chester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5359496 -1.8324115
17908 op-snap---monthly-publication-march-2025.pdf   1665 2025-03 Pedal Bike Ford Minibus White Driving without Reasonable Consideration None Primrose Hill, Kings Norton Primrose Hill, Kings Norton Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.3967197 -1.924102
17977 op-snap---monthly-publication-march-2025.pdf   1734 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Gillhurst Lane Gillhurst Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email    
18011 op-snap---monthly-publication-march-2025.pdf   1768 2025-03 Pedal Bike Volvo XC40 Blue Driving without Reasonable Consideration None Maynard Avenue Maynard Avenue Dudley Dudley Warning Letter N/A Yes - Via Email 52.4464709 -2.1663682
18168 op-snap---monthly-publication-march-2025.pdf   1925 2025-03 Pedal Bike Porsche Taycan White Driving without Reasonable Consideration None Hagley Road Hagley Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.471632 -1.9456776
18181 op-snap---monthly-publication-march-2025.pdf   1938 2025-03 Pedal Bike Volkswagen Golf Blue Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4308271 -1.920078
18187 op-snap---monthly-publication-march-2025.pdf   1944 2025-03 Pedal Bike Toyota Corolla White Driving without Reasonable Consideration None Hil Street Hil Street Birmingham Birmingham Warning Letter N/A Yes - Via Email    
18193 op-snap---monthly-publication-march-2025.pdf   1950 2025-03 Pedal Bike Vauxhall ASTRA Grey Driving without Reasonable Consideration None HEATH LANE Heath Lane Dudley Dudley Warning Letter N/A Yes - Via Email 52.4495524 -2.1459067
18230 op-snap---monthly-publication-march-2025.pdf   1987 2025-03 Pedal Bike Nissan Qashqai Silver Driving without Reasonable Consideration None Booths Lane, Queslett Booths Lane, Queslett Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.5426102 -1.9049087
18235 op-snap---monthly-publication-march-2025.pdf   1992 2025-03 Pedal Bike Volkswagen Arteon Grey Driving without Reasonable Consideration None Birmingham Road, Wylde Green Birmingham Road, Wylde Green Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.5352433 -1.8276127
18280 op-snap---monthly-publication-march-2025.pdf   2037 2025-03 Pedal Bike Toyota Corolla Red Driving without Reasonable Consideration None Ansty Road Ansty Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4205675 -1.4520187
18316 op-snap---monthly-publication-march-2025.pdf   2073 2025-03 Pedal Bike Nissan Note White Driving without Reasonable Consideration None Tanworth Lane Tanworth Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.4014694 -1.8220541
18415 op-snap---monthly-publication-march-2025.pdf   2172 2025-03 Pedal Bike Ford Transit Black Driving without Reasonable Consideration None Much Park Street Much Park Street Coventry Coventry Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4061531 -1.505845
18422 op-snap---monthly-publication-march-2025.pdf   2179 2025-03 Pedal Bike Toyota Auris Grey Driving without Reasonable Consideration None Hospital Way Hospital Way Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4492818 -1.9391685
18429 op-snap---monthly-publication-march-2025.pdf   2186 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None CHESTER ROAD Chester Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.5359496 -1.8324115
18511 op-snap---monthly-publication-march-2025.pdf   2268 2025-03 Pedal Bike Volkswagen CADDY White Driving without Reasonable Consideration None NORTHFIELD ROAD Northfield Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4167654 -1.9411244
18539 op-snap---monthly-publication-march-2025.pdf   2296 2025-03 Pedal Bike Skoda Octavia Silver Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4308271 -1.920078
18544 op-snap---monthly-publication-march-2025.pdf   2301 2025-03 Pedal Bike Volkswagen Transporter Black Driving without Reasonable Consideration None Wake Green Road Wake Green Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4437078 -1.8783408
18549 op-snap---monthly-publication-march-2025.pdf   2306 2025-03 Pedal Bike Lamborghini Urus Blue Driving without Reasonable Consideration No Insurance A38 A38 Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18550 op-snap---monthly-publication-march-2025.pdf   2307 2025-03 Pedal Bike Volvo XC90 Grey Driving without Reasonable Consideration None A38 A38 Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18584 op-snap---monthly-publication-march-2025.pdf   2341 2025-03 Pedal Bike Volkswagen Golf Black Driving without Reasonable Consideration None Wyhcal Lane Wyhcal Lane Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email    
18599 op-snap---monthly-publication-march-2025.pdf   2356 2025-03 Pedal Bike Nissan Juke Purple Driving without Reasonable Consideration None Pritchatts Road Pritchatts Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4522304 -1.9267446
18601 op-snap---monthly-publication-march-2025.pdf   2358 2025-03 Pedal Bike Jaguar XE White Driving without Reasonable Consideration None Edward Road Edward Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4580901 -1.894458
18605 op-snap---monthly-publication-march-2025.pdf   2362 2025-03 Pedal Bike Vauxhall Mokka White Driving without Reasonable Consideration None Dads Lane Kings Heath Dads Lane Kings Heath Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4375914 -1.9068522
18616 op-snap---monthly-publication-march-2025.pdf   2373 2025-03 Pedal Bike Volkswagen Polo Silver Driving without Reasonable Consideration None Wheelers Lane Wheelers Lane Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4306504 -1.878052
5295 op-snap---monthly-publication-february-2025.pdf   112 2025-02 Pedal Bike Audi A1 Black Driving without Reasonable Consideration None Spring Lane Spring Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.3492615 -1.7783838
5417 op-snap---monthly-publication-february-2025.pdf   234 2025-02 Pedal Bike BMW 320d Silver Driving without Reasonable Consideration None Bournville Lane Bournville Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4271614 -1.9302862
6108 op-snap---monthly-publication-february-2025.pdf   925 2025-02 Pedal Bike BMW X5 Green Driving without Reasonable Consideration None Hampton Road Hampton Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3985342 -1.7240581
6188 op-snap---monthly-publication-february-2025.pdf   1005 2025-02 Pedal Bike Honda Jazz Blue Driving without Reasonable Consideration None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4203897 -1.8338574
6189 op-snap---monthly-publication-february-2025.pdf   1006 2025-02 Pedal Bike Peugeot   Grey Driving without Reasonable Consideration None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4203897 -1.8338574
6279 op-snap---monthly-publication-february-2025.pdf   1096 2025-02 Pedal Bike Fiat Punto White Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5359496 -1.8324115
6338 op-snap---monthly-publication-february-2025.pdf   1155 2025-02 Pedal Bike Ford Mondeo Blue Driving without Reasonable Consideration None Stratford Road, Hockley Heath Stratford Road, Hockley Heath Birmingham Birmingham Warning Letter N/A Yes - Via Email    
6357 op-snap---monthly-publication-february-2025.pdf   1174 2025-02 Pedal Bike Porsche 911 Blue Driving without Reasonable Consideration None Prirchatts Road Prirchatts Road Birmingham Birmingham Warning Letter N/A Yes - Via Email    
6412 op-snap---monthly-publication-february-2025.pdf   1229 2025-02 Pedal Bike Volkswagen Golf Black Driving without Reasonable Consideration None Avenue Road, Kings Heath Avenue Road, Kings Heath Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4328354 -1.8999608
6564 op-snap---monthly-publication-february-2025.pdf   1381 2025-02 Pedal Bike Nissan Juke White Driving without Reasonable Consideration None Cliff Rock Road Cliff Rock Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.3937169 -2.0011078
6572 op-snap---monthly-publication-february-2025.pdf   1389 2025-02 Pedal Bike Volkswagen GOLF Silver Driving without Reasonable Consideration None CHESTER ROAD Chester Road Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.5359496 -1.8324115
6573 op-snap---monthly-publication-february-2025.pdf   1390 2025-02 Pedal Bike Ford KUGA Silver Driving without Reasonable Consideration None CHESTER ROAD Chester Road Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.5359496 -1.8324115
6602 op-snap---monthly-publication-february-2025.pdf   1419 2025-02 Pedal Bike Ford Transit Grey Driving without Reasonable Consideration None Kineton Lane Kineton Lane Solihull Solihull Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.3661553 -1.7890942
6605 op-snap---monthly-publication-february-2025.pdf   1422 2025-02 Pedal Bike Honda CR-V Brown Driving without Reasonable Consideration NONE CARPENTER ROAD Carpenter Road Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.46497 -1.9161701

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