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

117 rows where disposal = "NFA", month = "2025-06" 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

reporter_transport_mode 1

  • Pedal Bike · 117 ✖

month 1

  • 2025-06 · 117 ✖

disposal 1

  • NFA · 117 ✖
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
14084 op-snap---monthly-publication-june-2025.pdf   13 2025-06 Pedal Bike Audi Q5 Silver Driving without Reasonable Consideration None GRANGE ROAD Grange Road Solihull Solihull NFA No Independent Evidence Available   52.4285724 -1.8019101
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
14123 op-snap---monthly-publication-june-2025.pdf   52 2025-06 Pedal Bike Citroen C3 Grey Using a Mobile Phone Whilst Driving None Popular Road Popular Road Out of Force Area Out of Force Area NFA Out of Force   52.454374 -1.8774689
14178 op-snap---monthly-publication-june-2025.pdf   107 2025-06 Pedal Bike Porsche 911 Blue Driving without Reasonable Consideration None Highlands Road Highlands Road Birmingham Birmingham NFA No Offence      
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
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
14258 op-snap---monthly-publication-june-2025.pdf   187 2025-06 Pedal Bike Mercedes-Benz nk White Misc - Non Traffic Offences None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
14262 op-snap---monthly-publication-june-2025.pdf   191 2025-06 Pedal Bike Mercedes-Benz A180 Grey Misc - Non Traffic Offences None Startford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
14265 op-snap---monthly-publication-june-2025.pdf   194 2025-06 Pedal Bike Hyundai I30.. White Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
14266 op-snap---monthly-publication-june-2025.pdf   195 2025-06 Pedal Bike Volkswagen Transporter White Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
14289 op-snap---monthly-publication-june-2025.pdf   218 2025-06 Pedal Bike Peugeot 2008 Red Contravening a Red Traffic Light None Beake Avenue Beake Avenue Coventry Coventry NFA No Offence   52.4388246 -1.5229308
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
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
14482 op-snap---monthly-publication-june-2025.pdf   411 2025-06 Pedal Bike Toyota Avensis White Using a Mobile Phone Whilst Driving None Smallbrooks Queensway Smallbrooks Queensway Birmingham Birmingham NFA No Offence      
14496 op-snap---monthly-publication-june-2025.pdf   425 2025-06 Pedal Bike Audi A3 Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
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
14555 op-snap---monthly-publication-june-2025.pdf   484 2025-06 Pedal Bike Vauxhall Zafira Black Contravening a Red Traffic Light None Skidmore Rpad Skidmore Rpad Wolverhampton Wolverhampton NFA No Offence      
14573 op-snap---monthly-publication-june-2025.pdf   502 2025-06 Pedal Bike   MAN White Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
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
14587 op-snap---monthly-publication-june-2025.pdf   516 2025-06 Pedal Bike Skoda fabia Grey Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Gooch Street Gooch Street Birmingham Birmingham NFA No Offence   52.4686609 -1.8945007
14652 op-snap---monthly-publication-june-2025.pdf   581 2025-06 Pedal Bike Ford Transit White Cause vehicle to be left in a dangerous position None Hallen Drive Hallen Drive Sandwell Sandwell NFA Outside of 14 Days NIP      
14658 op-snap---monthly-publication-june-2025.pdf   587 2025-06 Pedal Bike Toyota Auris White Cause vehicle to be left in a dangerous position None Ladypool Road Ladypool Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4520441 -1.8787544
14670 op-snap---monthly-publication-june-2025.pdf   599 2025-06 Pedal Bike Mercedes-Benz GLE 350 Black Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
14671 op-snap---monthly-publication-june-2025.pdf   600 2025-06 Pedal Bike Ford Transit White Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
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      
14687 op-snap---monthly-publication-june-2025.pdf   616 2025-06 Pedal Bike BMW x4 White Contravening a Red Traffic Light None Holloway Circus Holloway Circus Birmingham Birmingham NFA No Independent Evidence Available   52.474604 -1.89977
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
14719 op-snap---monthly-publication-june-2025.pdf   648 2025-06 Pedal Bike BMW 420d White Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Broad Street Broad Street Birmingham Birmingham NFA No Offence   52.4749212 -1.9147497
14747 op-snap---monthly-publication-june-2025.pdf   676 2025-06 Pedal Bike Toyota Yaris Red Misc - Non Traffic Offences None Sarehole Rd Sarehole Road Solihull Solihull NFA No Offence      
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
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
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
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
14886 op-snap---monthly-publication-june-2025.pdf   815 2025-06 Pedal Bike BMW 520d Grey Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Holyhead Road Holyhead Road Coventry Coventry NFA No Independent Evidence Available   52.418488 -1.5472387
14902 op-snap---monthly-publication-june-2025.pdf   831 2025-06 Pedal Bike Mercedes-Benz GLC Silver Contravening a Red Traffic Light None Gooch St Gooch Street Birmingham Birmingham NFA No Independent Evidence Available   52.4686609 -1.8945007
14919 op-snap---monthly-publication-june-2025.pdf   848 2025-06 Pedal Bike Renault Traffic White Using a Mobile Phone Whilst Driving None Shenley Hill Shenley Hill Birmingham Birmingham NFA No Independent Evidence Available   52.4267534 -1.9790765
14921 op-snap---monthly-publication-june-2025.pdf   850 2025-06 Pedal Bike   Cupra Grey Using a Mobile Phone Whilst Driving None Shenley Hill Shenley Hill Birmingham Birmingham NFA No Offence   52.4267534 -1.9790765
14922 op-snap---monthly-publication-june-2025.pdf   851 2025-06 Pedal Bike Vauxhall Zafira Black Using a Mobile Phone Whilst Driving None Shenley Hill Shenley Hill Birmingham Birmingham NFA No Offence   52.4267534 -1.9790765
14923 op-snap---monthly-publication-june-2025.pdf   852 2025-06 Pedal Bike Audi A3 Grey Using a Mobile Phone Whilst Driving None Vincent Drive Vincent Drive Birmingham Birmingham NFA No Offence   52.4528789 -1.9354459
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
14964 op-snap---monthly-publication-june-2025.pdf   893 2025-06 Pedal Bike Toyota Corolla White Cause vehicle to be left in a dangerous position None Gayfield Avenue Gayfield Avenue Dudley Dudley NFA Outside of 14 Days NIP   52.4693896 -2.1251602
14965 op-snap---monthly-publication-june-2025.pdf   894 2025-06 Pedal Bike Vauxhall Astra Red Cause vehicle to be left in a dangerous position None Gayfield Av Gayfield Avenue Dudley Dudley NFA Outside of 14 Days NIP   52.4693896 -2.1251602
14971 op-snap---monthly-publication-june-2025.pdf   900 2025-06 Pedal Bike Hyundai I10 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Long Mill South Long Mill South Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.6095019 -2.0915196
14973 op-snap---monthly-publication-june-2025.pdf   902 2025-06 Pedal Bike Iveco Daily White Use vehicle on a road without valid test certificate None Steelpark Way Steelpark Way Walsall Walsall NFA No Independent Evidence Available      
14981 op-snap---monthly-publication-june-2025.pdf   910 2025-06 Pedal Bike Volkswagen Arteon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Legge Legge Birmingham Birmingham NFA No Offence   52.4843538 -1.9127963
14990 op-snap---monthly-publication-june-2025.pdf   919 2025-06 Pedal Bike Audi A4 Grey Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Station Road Station Road Birmingham Birmingham NFA No Independent Evidence Available   52.5054559 -1.9506109
15030 op-snap---monthly-publication-june-2025.pdf   959 2025-06 Pedal Bike Vauxhall INSIGNIA Green Driving without Reasonable Consideration None HALLAM STREET Hallam Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4563937 -1.8933429
15034 op-snap---monthly-publication-june-2025.pdf   963 2025-06 Pedal Bike Mg 5 EXCITE Silver Driving without Reasonable Consideration None SPON LANE Spon Lane Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5071465 -2.0049226
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
15038 op-snap---monthly-publication-june-2025.pdf   967 2025-06 Pedal Bike Isuzu   White Contravening a Red Traffic Light None Sedgley Road West Sedgley Road West Sandwell Sandwell NFA No Independent Evidence Available   52.5296941 -2.0777252
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
15060 op-snap---monthly-publication-june-2025.pdf   989 2025-06 Pedal Bike BMW 402 I.. Blue Using a Mobile Phone Whilst Driving None Herbert Road Herbert Road Birmingham Birmingham NFA No Independent Evidence Available   52.5097834 -1.9317114
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
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
15115 op-snap---monthly-publication-june-2025.pdf   1044 2025-06 Pedal Bike Renault Kangoo White Driving without Reasonable Consideration None Sutton Park Road Sutton Park Road Out of Force Area Out of Force Area NFA Out of Force   52.5298146 -1.7902196
15127 op-snap---monthly-publication-june-2025.pdf   1056 2025-06 Pedal Bike Mazda 2 Black Using a Mobile Phone Whilst Driving None Sherlock Street Sherlock Street Birmingham Birmingham NFA No Independent Evidence Available   52.4702385 -1.895011
15139 op-snap---monthly-publication-june-2025.pdf   1068 2025-06 Pedal Bike Kia Sorento Silver Driving without Reasonable Consideration None Henley In Arden (Wottoon Wawen) Henley In Arden (Wottoon Wawen) Out of Force Area Out of Force Area NFA Out of Force      
15185 op-snap---monthly-publication-june-2025.pdf   1114 2025-06 Pedal Bike Volvo BUS RED Driving without Reasonable Consideration None LAWLEY MIDDLEWAY Lawley Middleway Birmingham Birmingham NFA No Offence   52.4801772 -1.8769185
15200 op-snap---monthly-publication-june-2025.pdf   1129 2025-06 Pedal Bike Skoda Octavia White Driving without Reasonable Consideration None Myton Road Myton Road Out of Force Area Out of Force Area NFA Out of Force   52.4106096 -1.4829312
15208 op-snap---monthly-publication-june-2025.pdf   1137 2025-06 Pedal Bike Vauxhall Mokka Grey Contravening a Red Traffic Light None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
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      
15250 op-snap---monthly-publication-june-2025.pdf   1179 2025-06 Pedal Bike BMW 316d Black Using a Mobile Phone Whilst Driving None Smallbrook Queensway Smallbrook Queensway Birmingham Birmingham NFA No Offence   52.4772584 -1.8965734
15253 op-snap---monthly-publication-june-2025.pdf   1182 2025-06 Pedal Bike Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bristol Road Bristol Road Birmingham Birmingham NFA Not in Public Interest   52.4543565 -1.9114004
15265 op-snap---monthly-publication-june-2025.pdf   1194 2025-06 Pedal Bike Toyota aygo Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Hill Street Hill Street Birmingham Birmingham NFA No Independent Evidence Available   52.4777765 -1.901321
15274 op-snap---monthly-publication-june-2025.pdf   1203 2025-06 Pedal Bike Dacia Duster Blue Contravene Lane Closure Red X None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
15281 op-snap---monthly-publication-june-2025.pdf   1210 2025-06 Pedal Bike BMW X5 Black Driving without Due Care and Attention None Ox Leys Road Ox Leys Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5545836 -1.7767153
15291 op-snap---monthly-publication-june-2025.pdf   1220 2025-06 Pedal Bike Volvo XC40 Black Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4190728 -1.7449943
15293 op-snap---monthly-publication-june-2025.pdf   1222 2025-06 Pedal Bike Volvo XC90 Silver Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4190728 -1.7449943
15299 op-snap---monthly-publication-june-2025.pdf   1228 2025-06 Pedal Bike Ford Focus Blue Using a Mobile Phone Whilst Driving None Clarence Road Clarence Road Birmingham Birmingham NFA No Offence   52.5940902 -1.843503
15309 op-snap---monthly-publication-june-2025.pdf   1238 2025-06 Pedal Bike Vauxhall Corsa Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham NFA Not in Public Interest   52.4760986 -1.9018641
15310 op-snap---monthly-publication-june-2025.pdf   1239 2025-06 Pedal Bike Suzuki Vitara Red Cause vehicle to be left in a dangerous position None Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham NFA Outside of 14 Days NIP   52.4760986 -1.9018641
15333 op-snap---monthly-publication-june-2025.pdf   1262 2025-06 Pedal Bike Mercedes-Benz B CLASS Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Station Road Station Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5054559 -1.9506109
15376 op-snap---monthly-publication-june-2025.pdf   1305 2025-06 Pedal Bike Vauxhall Corsa Red Fail to display rear VRM plate None Dawes Avenue Dawes Avenue Sandwell Sandwell NFA Outside of 14 Days NIP   52.5088521 -2.000161
15393 op-snap---monthly-publication-june-2025.pdf   1322 2025-06 Pedal Bike Toyota Prius Black Cause vehicle to be left in a dangerous position None College Road College Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5151832 -1.9361664
15411 op-snap---monthly-publication-june-2025.pdf   1340 2025-06 Pedal Bike Peugeot 3008 Black Cause vehicle to be left in a dangerous position None Hamstead Road Hamstead Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.505832 -1.92002
15420 op-snap---monthly-publication-june-2025.pdf   1349 2025-06 Pedal Bike Land Rover Range Rover Grey Cause vehicle to be left in a dangerous position None Ladypool Road Ladypool Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4520441 -1.8787544
15422 op-snap---monthly-publication-june-2025.pdf   1351 2025-06 Pedal Bike Toyota Auris Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4203897 -1.8338574
15446 op-snap---monthly-publication-june-2025.pdf   1375 2025-06 Pedal Bike Mercedes-Benz A Class Silver Driving without Reasonable Consideration None Wednesfield Way Wednesfield Way Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.59548 -2.0896906
15473 op-snap---monthly-publication-june-2025.pdf   1402 2025-06 Pedal Bike Hyundai I10 White Driving without Reasonable Consideration None Newton Road Newton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4541102 -1.8710993
15474 op-snap---monthly-publication-june-2025.pdf   1403 2025-06 Pedal Bike Volkswagen Golf White Driving without Reasonable Consideration None Newton Road Newton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4541102 -1.8710993
15475 op-snap---monthly-publication-june-2025.pdf   1404 2025-06 Pedal Bike Toyota Auris Silver Misc - Non Traffic Offences None Witton Road Witton Road Birmingham Birmingham NFA No Offence   52.513336 -1.8833226
15501 op-snap---monthly-publication-june-2025.pdf   1430 2025-06 Pedal Bike Ford transit White Driving without Due Care and Attention None Cornwall Street Cornwall Street Birmingham Birmingham NFA No Offence   52.4815054 -1.9032499
15527 op-snap---monthly-publication-june-2025.pdf   1456 2025-06 Pedal Bike Renault Master White Driving without Due Care and Attention None Brownshill Green Road Brownshill Green Road Coventry Coventry NFA Outside of 14 Days NIP   52.4345915 -1.5376734
15544 op-snap---monthly-publication-june-2025.pdf   1473 2025-06 Pedal Bike Fiat Panda White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
15569 op-snap---monthly-publication-june-2025.pdf   1498 2025-06 Pedal Bike Mercedes-Benz Sprinter Grey Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry NFA Outside of 14 Days NIP   52.4074716 -1.5620671
15570 op-snap---monthly-publication-june-2025.pdf   1499 2025-06 Pedal Bike Vauxhall Zafira Silver Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Coventry Coventry NFA Outside of 14 Days NIP      
15619 op-snap---monthly-publication-june-2025.pdf   1548 2025-06 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Alwod Road Alwod Road Birmingham Birmingham NFA Outside of 14 Days NIP      
15620 op-snap---monthly-publication-june-2025.pdf   1549 2025-06 Pedal Bike Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Priory Road Priory Road Birmingham Birmingham NFA No Independent Evidence Available   52.4132696 -1.8555008
15621 op-snap---monthly-publication-june-2025.pdf   1550 2025-06 Pedal Bike Mazda 3 Blue Driving without Due Care and Attention None War Lane War Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4569552 -1.9616483

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