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

149 rows where month = "2025-06", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedal Bike" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

disposal 5

reporter_transport_mode 1

  • Pedal Bike · 149 ✖

offence 1

  • Driving without Due Care and Attention · 149 ✖

month 1

  • 2025-06 · 149 ✖
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
14095 op-snap---monthly-publication-june-2025.pdf   24 2025-06 Pedal Bike Mercedes-Benz E300 White Driving without Due Care and Attention None Wake Green Road Wake Green Road Birmingham Birmingham Education N/A   52.4437078 -1.8783408
14109 op-snap---monthly-publication-june-2025.pdf   38 2025-06 Pedal Bike Volvo   Red Driving without Due Care and Attention None B4151 towards Walsall B4151 towards Walsall Walsall Walsall Education N/A      
14117 op-snap---monthly-publication-june-2025.pdf   46 2025-06 Pedal Bike Jaguar XF Red Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Education N/A   52.4718503 -1.9195423
14118 op-snap---monthly-publication-june-2025.pdf   47 2025-06 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
14119 op-snap---monthly-publication-june-2025.pdf   48 2025-06 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Warning Letter N/A   52.4718503 -1.9195423
14120 op-snap---monthly-publication-june-2025.pdf   49 2025-06 Pedal Bike Volkswagen Golf Black Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham Education N/A   52.4282602 -1.9861769
14122 op-snap---monthly-publication-june-2025.pdf   51 2025-06 Pedal Bike Hyundai I10 White Driving without Due Care and Attention None Poplar Road Poplar Road Out of Force Area Out of Force Area NFA Out of Force   52.4744337 -1.9677475
14134 op-snap---monthly-publication-june-2025.pdf   63 2025-06 Pedal Bike Audi A1 White Driving without Due Care and Attention None Birmingham Road Birmingham Road Dudley Dudley Education N/A   52.5131355 -2.0651615
14139 op-snap---monthly-publication-june-2025.pdf   68 2025-06 Pedal Bike Peugeot 2008 Blue Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
14147 op-snap---monthly-publication-june-2025.pdf   76 2025-06 Pedal Bike BMW IX8 White Driving without Due Care and Attention None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Education N/A   52.5940902 -1.843503
14179 op-snap---monthly-publication-june-2025.pdf   108 2025-06 Pedal Bike BMW X5 Silver Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Education N/A   52.4092804 -1.8056214
14194 op-snap---monthly-publication-june-2025.pdf   123 2025-06 Pedal Bike BMW 320d White Driving without Due Care and Attention None The Broadway The Broadway Dudley Dudley Court N/A   52.515445 -2.0885791
14196 op-snap---monthly-publication-june-2025.pdf   125 2025-06 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Waste Lane Waste Lane Coventry Coventry NFA Outside of 14 Days NIP   52.437361 -1.5371291
14216 op-snap---monthly-publication-june-2025.pdf   145 2025-06 Pedal Bike Ford fiesta Black Driving without Due Care and Attention None The Broadway The Broadway Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5108588 -1.8919435
14238 op-snap---monthly-publication-june-2025.pdf   167 2025-06 Pedal Bike Audi Q5 Black Driving without Due Care and Attention None Salibsury Road Salibsury Road Birmingham Birmingham Education N/A      
14244 op-snap---monthly-publication-june-2025.pdf   173 2025-06 Pedal Bike Volkswagen Golf Black Driving without Due Care and Attention None Salisbury Road Salisbury Road Birmingham Birmingham NFA No Independent Evidence Available   52.4943878 -1.8504211
14261 op-snap---monthly-publication-june-2025.pdf   190 2025-06 Pedal Bike Honda Civic Black Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
14277 op-snap---monthly-publication-june-2025.pdf   206 2025-06 Pedal Bike BMW X3 Blue Driving without Due Care and Attention No Insurance Woden Road South Woden Road South Sandwell Sandwell Court N/A   52.546752 -2.0155769
14281 op-snap---monthly-publication-june-2025.pdf   210 2025-06 Pedal Bike BMW X1 Grey Driving without Due Care and Attention No Insurance Holders Lane Holders Lane Birmingham Birmingham Fixed Penalty N/A   52.4446701 -1.9056872
14282 op-snap---monthly-publication-june-2025.pdf   211 2025-06 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
14286 op-snap---monthly-publication-june-2025.pdf   215 2025-06 Pedal Bike Volkswagen Sharan Silver Driving without Due Care and Attention None Old Dickens Heath Road Old Dickens Heath Road Solihull Solihull Warning Letter N/A   52.3864791 -1.8355922
14288 op-snap---monthly-publication-june-2025.pdf   217 2025-06 Pedal Bike Honda E Black Driving without Due Care and Attention None Cliff Rock Road Cliff Rock Road Birmingham Birmingham Warning Letter N/A   52.3937169 -2.0011078
14301 op-snap---monthly-publication-june-2025.pdf   230 2025-06 Pedal Bike BMW 420D Black Driving without Due Care and Attention None Raddlebarn Road Raddlebarn Road Birmingham Birmingham NFA No Offence   52.4397168 -1.9260414
14305 op-snap---monthly-publication-june-2025.pdf   234 2025-06 Pedal Bike Nissan Qashqai Black Driving without Due Care and Attention None Ladypool Road Ladypool Road Birmingham Birmingham NFA No Offence   52.4520441 -1.8787544
14307 op-snap---monthly-publication-june-2025.pdf   236 2025-06 Pedal Bike Toyota Corolla White Driving without Due Care and Attention None Berkswell Road Berkswell Road Coventry Coventry Education N/A   52.4422534 -1.4791016
14366 op-snap---monthly-publication-june-2025.pdf   295 2025-06 Pedal Bike Alfa Romeo Giullietta Red Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry NFA Outside of 14 Days NIP   52.4074716 -1.5620671
14397 op-snap---monthly-publication-june-2025.pdf   326 2025-06 Pedal Bike Ford Ecosport Silver Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
14399 op-snap---monthly-publication-june-2025.pdf   328 2025-06 Pedal Bike Nissan Juke White Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
14426 op-snap---monthly-publication-june-2025.pdf   355 2025-06 Pedal Bike Hyundai Ioniq Silver Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
14430 op-snap---monthly-publication-june-2025.pdf   359 2025-06 Pedal Bike Toyota Yaris Silver Driving without Due Care and Attention None Rotton Park Road Rotton Park Road Birmingham Birmingham Education N/A   52.4851072 -1.9468115
14434 op-snap---monthly-publication-june-2025.pdf   363 2025-06 Pedal Bike BMW X1 White Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
14465 op-snap---monthly-publication-june-2025.pdf   394 2025-06 Pedal Bike BMW 340I Black Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull Education N/A   52.4144779 -1.7848758
14480 op-snap---monthly-publication-june-2025.pdf   409 2025-06 Pedal Bike Vauxhall Vivaro White Driving without Due Care and Attention None Alwod Road Alwod Road Birmingham Birmingham Warning Letter N/A      
14483 op-snap---monthly-publication-june-2025.pdf   412 2025-06 Pedal Bike Kia Cee'd Black Driving without Due Care and Attention None Richmond Hill Road, Harborne Richmond Hill Road, Harborne Birmingham Birmingham Education N/A   52.4607238 -1.935227
14485 op-snap---monthly-publication-june-2025.pdf   414 2025-06 Pedal Bike Toyota Pruis Red Driving without Due Care and Attention None Qunton Road Qunton Road Birmingham Birmingham Education N/A      
14489 op-snap---monthly-publication-june-2025.pdf   418 2025-06 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Burnaby Road Burnaby Road Coventry Coventry Education N/A   52.4352 -1.5194238
14507 op-snap---monthly-publication-june-2025.pdf   436 2025-06 Pedal Bike Toyota Yaris White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
14517 op-snap---monthly-publication-june-2025.pdf   446 2025-06 Pedal Bike Toyota Auris Green Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
14519 op-snap---monthly-publication-june-2025.pdf   448 2025-06 Pedal Bike Suzuki GXSR White Driving without Due Care and Attention None Grange Hill, off Manor Way Grange Hill, off Manor Way Halesowen Halesowen Court N/A      
14527 op-snap---monthly-publication-june-2025.pdf   456 2025-06 Pedal Bike Audi A6 Black Driving without Due Care and Attention None Gibbet Hill Road Gibbet Hill Road Coventry Coventry Warning Letter N/A   52.3749141 -1.5564977
14530 op-snap---monthly-publication-june-2025.pdf   459 2025-06 Pedal Bike BMW M235 White Driving without Due Care and Attention None Norton Lane Norton Lane Solihull Solihull Education N/A   52.3778771 -1.8581547
14539 op-snap---monthly-publication-june-2025.pdf   468 2025-06 Pedal Bike Mercedes-Benz C220 Grey Driving without Due Care and Attention None Rowheath Road, Cotteridge Rowheath Road, Cotteridge Birmingham Birmingham Education N/A   52.4179718 -1.9289891
14540 op-snap---monthly-publication-june-2025.pdf   469 2025-06 Pedal Bike   Infiniti Black Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
14574 op-snap---monthly-publication-june-2025.pdf   503 2025-06 Pedal Bike Audi A4 Black Driving without Due Care and Attention None Windward Way Windward Way Solihull Solihull NFA No Offence   52.5023715 -1.7555515
14674 op-snap---monthly-publication-june-2025.pdf   603 2025-06 Pedal Bike Ford Fiesta Silver Driving without Due Care and Attention None Tile Hill Tile Hill Coventry Coventry Education N/A   52.3951906 -1.5972825
14675 op-snap---monthly-publication-june-2025.pdf   604 2025-06 Pedal Bike Ford Transit White Driving without Due Care and Attention None Westwood Way Westwood Way Coventry Coventry NFA No Offence   52.3880214 -1.5797132
14683 op-snap---monthly-publication-june-2025.pdf   612 2025-06 Pedal Bike Fiat Ducato White Driving without Due Care and Attention None Rotten Park Road Rotten Park Road Birmingham Birmingham NFA No Offence      
14688 op-snap---monthly-publication-june-2025.pdf   617 2025-06 Pedal Bike Peugeot 2008.. White Driving without Due Care and Attention None Broadway, Stourbridge Broadway, Stourbridge Dudley Dudley Education N/A   52.4411413 -2.1695219
14689 op-snap---monthly-publication-june-2025.pdf   618 2025-06 Pedal Bike Fiat Ducato Grey Driving without Due Care and Attention None All Saints Way All Saints Way Sandwell Sandwell Education N/A   52.5344405 -1.985568
14698 op-snap---monthly-publication-june-2025.pdf   627 2025-06 Pedal Bike Audi A5 Black Driving without Due Care and Attention None Rochester Road Rochester Road Coventry Coventry Education N/A   52.3974085 -1.5422796
14700 op-snap---monthly-publication-june-2025.pdf   629 2025-06 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
14707 op-snap---monthly-publication-june-2025.pdf   636 2025-06 Pedal Bike Volkswagen Golf Silver Driving without Due Care and Attention No Insurance Park Lane West Park Lane West Sandwell Sandwell Court N/A   52.5227061 -2.0617482
14708 op-snap---monthly-publication-june-2025.pdf   637 2025-06 Pedal Bike Audi Q3.. Black Driving without Due Care and Attention None Bloomfield Road Bloomfield Road Sandwell Sandwell Education N/A   52.5377733 -2.0733724
14740 op-snap---monthly-publication-june-2025.pdf   669 2025-06 Pedal Bike Mercedes-Benz S 350 Black Driving without Due Care and Attention None A38 Kingsbuy Road Kingsbuy Road Birmingham Birmingham Education N/A      
14746 op-snap---monthly-publication-june-2025.pdf   675 2025-06 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
14748 op-snap---monthly-publication-june-2025.pdf   677 2025-06 Pedal Bike BMW M235I Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
14757 op-snap---monthly-publication-june-2025.pdf   686 2025-06 Pedal Bike Land Rover Range Rover Grey Driving without Due Care and Attention None Wobaston Road Wobaston Road Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.628768 -2.1306154
14760 op-snap---monthly-publication-june-2025.pdf   689 2025-06 Pedal Bike Ford Fiesta Green Driving without Due Care and Attention None A38 Bristol Road Bristol Road Birmingham Birmingham NFA No Offence   52.4543565 -1.9114004
14762 op-snap---monthly-publication-june-2025.pdf   691 2025-06 Pedal Bike Audi Q5 Black Driving without Due Care and Attention None Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
14764 op-snap---monthly-publication-june-2025.pdf   693 2025-06 Pedal Bike Mercedes-Benz E220 Black Driving without Due Care and Attention None Salisbury Road Salisbury Road Birmingham Birmingham NFA No Offence   52.4943878 -1.8504211
14766 op-snap---monthly-publication-june-2025.pdf   695 2025-06 Pedal Bike Fiat Ducato White Driving without Due Care and Attention None Salisbury Road Salisbury Road Birmingham Birmingham NFA No Offence   52.4943878 -1.8504211
14782 op-snap---monthly-publication-june-2025.pdf   711 2025-06 Pedal Bike Citroen C3 Grey Driving without Due Care and Attention None Webster Way Webster Way Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5445328 -1.7884784
14785 op-snap---monthly-publication-june-2025.pdf   714 2025-06 Pedal Bike Seat Cupra Born Grey Driving without Due Care and Attention None Webster Way Webster Way Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5445328 -1.7884784
14787 op-snap---monthly-publication-june-2025.pdf   716 2025-06 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
14806 op-snap---monthly-publication-june-2025.pdf   735 2025-06 Pedal Bike Mercedes-Benz E220 White Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Warning Letter N/A   52.4718503 -1.9195423
14814 op-snap---monthly-publication-june-2025.pdf   743 2025-06 Pedal Bike Seat Ibiza Silver Driving without Due Care and Attention None Beechwood Avenue Beechwood Avenue Coventry Coventry Education N/A   52.3960292 -1.5340332
14851 op-snap---monthly-publication-june-2025.pdf   780 2025-06 Pedal Bike Land Rover Defender Black Driving without Due Care and Attention None Spring Hill Spring Hill Solihull Solihull Fixed Penalty N/A      
14862 op-snap---monthly-publication-june-2025.pdf   791 2025-06 Pedal Bike Tesla   White Driving without Due Care and Attention None Hillsborough Hillsborough Out of Force Area Out of Force Area NFA Out of Force   52.4764378 -1.9522637
14875 op-snap---monthly-publication-june-2025.pdf   804 2025-06 Pedal Bike Citroen DS 3.. Grey Driving without Due Care and Attention None Dartmouth Avenue Dartmouth Avenue Walsall Walsall Education N/A   52.6039645 -1.9797631
14880 op-snap---monthly-publication-june-2025.pdf   809 2025-06 Pedal Bike Mercedes-Benz sprint Grey Driving without Due Care and Attention None High Street High Street Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4064169 -1.8557215
14889 op-snap---monthly-publication-june-2025.pdf   818 2025-06 Pedal Bike Ford Fiesta Black Driving without Due Care and Attention None Doe Bank Lane Doe Bank Lane Birmingham Birmingham Education 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
14925 op-snap---monthly-publication-june-2025.pdf   854 2025-06 Pedal Bike Citroen Picasso Blue Driving without Due Care and Attention None Merritts Hill Merritts Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.424853 -1.9814275
14926 op-snap---monthly-publication-june-2025.pdf   855 2025-06 Pedal Bike Land Rover Discovery White Driving without Due Care and Attention None Scotland Lane Scotland Lane Birmingham Birmingham NFA No Offence   52.4277732 -2.0022005
14927 op-snap---monthly-publication-june-2025.pdf   856 2025-06 Pedal Bike Peugeot 207.. Grey Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
14928 op-snap---monthly-publication-june-2025.pdf   857 2025-06 Pedal Bike BMW 220.. Orange Driving without Due Care and Attention None Merritts Hill Merritts Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.424853 -1.9814275
14929 op-snap---monthly-publication-june-2025.pdf   858 2025-06 Pedal Bike Fiat Panda Grey Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
14931 op-snap---monthly-publication-june-2025.pdf   860 2025-06 Pedal Bike Seat Leon Black Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
14933 op-snap---monthly-publication-june-2025.pdf   862 2025-06 Pedal Bike Jaguar XE Black Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham Education N/A   52.430111 -1.9753703
14937 op-snap---monthly-publication-june-2025.pdf   866 2025-06 Pedal Bike Ford fiesta Blue Driving without Due Care and Attention None A4037 Tipton Tipton Sandwell Sandwell Court N/A   52.5290396 -2.0693747
15033 op-snap---monthly-publication-june-2025.pdf   962 2025-06 Pedal Bike Volkswagen Golf Silver Driving without Due Care and Attention None Bromsgrove Road Bromsgrove Road Birmingham Birmingham Education N/A      
15035 op-snap---monthly-publication-june-2025.pdf   964 2025-06 Pedal Bike Mercedes-Benz ML250 White Driving without Due Care and Attention None High Street, Harborne High Street, Harborne Birmingham Birmingham Education N/A   52.4612733 -1.9430543
15037 op-snap---monthly-publication-june-2025.pdf   966 2025-06 Pedal Bike Ford Transit White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
15043 op-snap---monthly-publication-june-2025.pdf   972 2025-06 Pedal Bike Vauxhall Meriva Grey Driving without Due Care and Attention None Wolverhampton Road West Wolverhampton Road West Walsall Walsall NFA No Offence   52.5866889 -2.0354488
15044 op-snap---monthly-publication-june-2025.pdf   973 2025-06 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Wigston Road Wigston Road Coventry Coventry Fixed Penalty N/A   52.4302822 -1.4386034
15049 op-snap---monthly-publication-june-2025.pdf   978 2025-06 Pedal Bike Mercedes-Benz S320 Silver Driving without Due Care and Attention No Insurance Broad Meadow Road Broad Meadow Road Birmingham Birmingham Court N/A      
15052 op-snap---monthly-publication-june-2025.pdf   981 2025-06 Pedal Bike Suzuki Ignis White Driving without Due Care and Attention None Herald Avenue Herald Avenue Coventry Coventry Warning Letter N/A   52.4029059 -1.5541193
15058 op-snap---monthly-publication-june-2025.pdf   987 2025-06 Pedal Bike Mini Countryman Blue Driving without Due Care and Attention None Worcester Street Worcester Street Dudley Dudley Education N/A   52.4507058 -2.1503743
15064 op-snap---monthly-publication-june-2025.pdf   993 2025-06 Pedal Bike Ford Transit Blue Driving without Due Care and Attention None Swarthmore Road Swarthmore Road Birmingham Birmingham NFA No Offence   52.4299657 -1.9599121
15071 op-snap---monthly-publication-june-2025.pdf   1000 2025-06 Pedal Bike Nissan Qashqai Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Court N/A   52.5359496 -1.8324115
15083 op-snap---monthly-publication-june-2025.pdf   1012 2025-06 Pedal Bike Vauxhall corsa Silver Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 DAYS Late Submission   52.5359496 -1.8324115
15084 op-snap---monthly-publication-june-2025.pdf   1013 2025-06 Pedal Bike Jaguar XE White Driving without Due Care and Attention None Birmingham Road Birmingham Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5505398 -1.8252993
15093 op-snap---monthly-publication-june-2025.pdf   1022 2025-06 Pedal Bike Ford Transit White Driving without Due Care and Attention None Bosty Lane Bosty Lane Walsall Walsall Court N/A   52.5948329 -1.927787
15096 op-snap---monthly-publication-june-2025.pdf   1025 2025-06 Pedal Bike Ford Transit White Driving without Due Care and Attention None Newton Road Newton Road Birmingham Birmingham Education N/A   52.4541102 -1.8710993
15161 op-snap---monthly-publication-june-2025.pdf   1090 2025-06 Pedal Bike Kia Ceed Red Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
15172 op-snap---monthly-publication-june-2025.pdf   1101 2025-06 Pedal Bike Honda Jazz Silver Driving without Due Care and Attention None Highters Heath Lane Highters Heath Lane Birmingham Birmingham Education N/A   52.4100972 -1.8742772
15173 op-snap---monthly-publication-june-2025.pdf   1102 2025-06 Pedal Bike Ford Focus Blue Driving without Due Care and Attention None Barston Lane Barston Lane Solihull Solihull Education N/A   52.4022999 -1.685635
15187 op-snap---monthly-publication-june-2025.pdf   1116 2025-06 Pedal Bike Ford Focus Blue Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Fixed Penalty N/A   52.4668753 -1.8996143
15219 op-snap---monthly-publication-june-2025.pdf   1148 2025-06 Pedal Bike Ford S-Max Silver Driving without Due Care and Attention None Bristol Street Bristol Street Birmingham Birmingham Education N/A   52.4691145 -1.9003257
15223 op-snap---monthly-publication-june-2025.pdf   1152 2025-06 Pedal Bike Seat Leon Red Driving without Due Care and Attention None St Anges Street Anges Birmingham Birmingham NFA No VRM      

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