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

144 rows where disposal = "NFA", month = "2025-05" 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 · 144 ✖

month 1

  • 2025-05 · 144 ✖

disposal 1

  • NFA · 144 ✖
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
18643 op-snap---monthly-publication-may-2025.pdf   5 2025-05 Pedal Bike BMW 118I White Driving without Reasonable Consideration None Birmingham New Road Birmingham New Road Dudley Dudley NFA Outside of 14 Days NIP   52.5478387 -2.0943116
18659 op-snap---monthly-publication-may-2025.pdf   21 2025-05 Pedal Bike Land Rover Range Rover Green Using a Mobile Phone Whilst Driving None Widney Road Solihull Widney Road Solihull Solihull Solihull NFA Not in Public Interest   52.3795667 -1.7478958
18669 op-snap---monthly-publication-may-2025.pdf   31 2025-05 Pedal Bike Volkswagen Polo Blue Cause vehicle to be left in a dangerous position None Mary Vale Road Mary Vale Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.425105 -1.9312861
18678 op-snap---monthly-publication-may-2025.pdf   40 2025-05 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Cliff Rock Road Cliff Rock Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.3937169 -2.0011078
18695 op-snap---monthly-publication-may-2025.pdf   57 2025-05 Pedal Bike Ford Tourneo Silver Driving without Due Care and Attention None Wherretts Well Lane Wherretts Well Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4225399 -1.763283
18698 op-snap---monthly-publication-may-2025.pdf   60 2025-05 Pedal Bike Audi A6 Black Driving without Reasonable Consideration None Slade Road Slade Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5894461 -1.8082962
18707 op-snap---monthly-publication-may-2025.pdf   69 2025-05 Pedal Bike BMW 535d Black Driving without Reasonable Consideration None Cambridge Street Cambridge Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4802932 -1.9079609
18708 op-snap---monthly-publication-may-2025.pdf   70 2025-05 Pedal Bike BMW 430d Grey Driving without Reasonable Consideration None Ridgeacre Road Ridgeacre Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4620871 -2.0123436
18716 op-snap---monthly-publication-may-2025.pdf   78 2025-05 Pedal Bike Mazda 2 Purple Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bradford Street Bradford Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4708802 -1.8792135
18717 op-snap---monthly-publication-may-2025.pdf   79 2025-05 Pedal Bike Mercedes-Benz 200 AMG Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bradford Street Bradford Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4708802 -1.8792135
18719 op-snap---monthly-publication-may-2025.pdf   81 2025-05 Pedal Bike Audi s4 Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bradford Street Bradford Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4708802 -1.8792135
18720 op-snap---monthly-publication-may-2025.pdf   82 2025-05 Pedal Bike Mercedes-Benz AMG Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bradford Street Bradford Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4708802 -1.8792135
18725 op-snap---monthly-publication-may-2025.pdf   87 2025-05 Pedal Bike Peugeot Partner Red Driving without Due Care and Attention None Ring Road Ring Road Coventry Coventry NFA No Offence      
18726 op-snap---monthly-publication-may-2025.pdf   88 2025-05 Pedal Bike Mercedes-Benz ML350 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Westhill Road Westhill Road Coventry Coventry NFA No Offence   52.4225058 -1.5356916
18735 op-snap---monthly-publication-may-2025.pdf   97 2025-05 Pedal Bike   KYM Duke Orange Driving without Reasonable Consideration None Gosford Street Gosford Street Coventry Coventry NFA Outside of 14 Days NIP   52.4068712 -1.4994695
18769 op-snap---monthly-publication-may-2025.pdf   131 2025-05 Pedal Bike Skoda Fabia White Driving without Reasonable Consideration None Chester Rd Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
18771 op-snap---monthly-publication-may-2025.pdf   133 2025-05 Pedal Bike Jaguar X Pace Grey Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
18783 op-snap---monthly-publication-may-2025.pdf   145 2025-05 Pedal Bike Tesla Model 3 White Driving without Reasonable Consideration None Priory Road Priory Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4132696 -1.8555008
18785 op-snap---monthly-publication-may-2025.pdf   147 2025-05 Pedal Bike Toyota AURIS Grey Driving without Reasonable Consideration None NEWHALL STREET Newhall Street Birmingham Birmingham NFA No Offence   52.4830482 -1.905069
18786 op-snap---monthly-publication-may-2025.pdf   148 2025-05 Pedal Bike Ford FIESTA Blue Driving without Reasonable Consideration None GUNNERS LANE Gunners Lane Birmingham Birmingham NFA Outside of 14 Days NIP      
18787 op-snap---monthly-publication-may-2025.pdf   149 2025-05 Pedal Bike Toyota MPV Silver Driving without Reasonable Consideration None MERRITTS HILL ROAD Merritts Hill Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4216997 -1.9756752
18788 op-snap---monthly-publication-may-2025.pdf   150 2025-05 Pedal Bike Toyota Yaris Silver Driving without Reasonable Consideration None Genners Lane Genners Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4282602 -1.9861769
18790 op-snap---monthly-publication-may-2025.pdf   152 2025-05 Pedal Bike Toyota MPV White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Small Brook Queensway Small Brook Queensway Birmingham Birmingham NFA Not in Public Interest      
18828 op-snap---monthly-publication-may-2025.pdf   190 2025-05 Pedal Bike Mercedes-Benz E400. White Driving without Reasonable Consideration None The Radleys The Radleys Birmingham Birmingham NFA Outside of 14 Days NIP   52.4698717 -1.7649619
18837 op-snap---monthly-publication-may-2025.pdf   199 2025-05 Pedal Bike Tesla Y Black Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4308271 -1.920078
18849 op-snap---monthly-publication-may-2025.pdf   211 2025-05 Pedal Bike   Scancia Red Driving without Reasonable Consideration None Ventura Park Ventura Park Out of Force Area Out of Force Area NFA Out of Force      
18888 op-snap---monthly-publication-may-2025.pdf   250 2025-05 Pedal Bike Mercedes-Benz A class Black Driving without Reasonable Consideration None Cromer Road Cromer Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4549149 -1.8880392
18891 op-snap---monthly-publication-may-2025.pdf   253 2025-05 Pedal Bike Renault Austral Grey Driving without Reasonable Consideration None Erdington Road Erdington Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5133989 -1.8448231
18894 op-snap---monthly-publication-may-2025.pdf   256 2025-05 Pedal Bike BMW 320 Blue Stop a vehicle within pelican pedestrian crossing limits None High Street High Street Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.5635963 -2.0827567
18905 op-snap---monthly-publication-may-2025.pdf   267 2025-05 Pedal Bike       Driving without Due Care and Attention None Corporation street Corporation street Walsall Walsall NFA No VRM   52.5773099 -1.9850716
18906 op-snap---monthly-publication-may-2025.pdf   268 2025-05 Pedal Bike Mercedes-Benz A class Red Contravening a Red Traffic Light None Walstead Road Walstead Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5648629 -1.9517624
18921 op-snap---monthly-publication-may-2025.pdf   283 2025-05 Pedal Bike BMW X4 Black Driving without Due Care and Attention None Flaxley Road Flaxley Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.487709 -1.8077323
18938 op-snap---monthly-publication-may-2025.pdf   300 2025-05 Pedal Bike BMW   Black Driving without Reasonable Consideration None Gilhurst Road Gilhurst Road Dudley Dudley NFA Outside of 14 Days NIP      
18942 op-snap---monthly-publication-may-2025.pdf   304 2025-05 Pedal Bike Peugeot 5008 Blue Contravening a Red Traffic Light None Gooch Street Gooch Street Birmingham Birmingham NFA No VRM   52.4686609 -1.8945007
18974 op-snap---monthly-publication-may-2025.pdf   336 2025-05 Pedal Bike Toyota Prius Grey Using a Mobile Phone Whilst Driving None Northfield Rd Northfield Road Birmingham Birmingham NFA No Independent Evidence Available   52.4167654 -1.9411244
18981 op-snap---monthly-publication-may-2025.pdf   343 2025-05 Pedal Bike Honda Civic Silver Driving without Reasonable Consideration None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4580375 -1.9261777
19006 op-snap---monthly-publication-may-2025.pdf   368 2025-05 Pedal Bike Fiat 500 White Cause vehicle to be left in a dangerous position None St Bernard Road Street Bernard Road Solihull Solihull NFA Outside of 14 Days NIP      
19037 op-snap---monthly-publication-may-2025.pdf   399 2025-05 Pedal Bike Ford Transit White Driving without Due Care and Attention None Malvern area Malvern area Out of Force Area Out of Force Area NFA Out of Force      
19038 op-snap---monthly-publication-may-2025.pdf   400 2025-05 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Malvern area Malvern area Out of Force Area Out of Force Area NFA Out of Force      
19054 op-snap---monthly-publication-may-2025.pdf   416 2025-05 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention No Insurance Hinksford Lane Swindon Hinksford Lane Swindon Out of Force Area Out of Force Area NFA Out of Force   52.5079592 -2.1966932
19077 op-snap---monthly-publication-may-2025.pdf   439 2025-05 Pedal Bike Nissan Juke Silver Driving without Reasonable Consideration None Little Park Street Little Park Street Coventry Coventry NFA Outside of 14 Days NIP   52.4051331 -1.5085642
19108 op-snap---monthly-publication-may-2025.pdf   470 2025-05 Pedal Bike   Impreza Blue Driving without Reasonable Consideration None Wheelers Lane Wheelers Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4306504 -1.878052
19122 op-snap---monthly-publication-may-2025.pdf   484 2025-05 Pedal Bike Kia Picanto Black Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
19123 op-snap---monthly-publication-may-2025.pdf   485 2025-05 Pedal Bike Toyota CHR Black Driving without Reasonable Consideration None Dickens Heath Road Dickens Heath Road Solihull Solihull NFA No Offence   52.3875525 -1.8339426
19133 op-snap---monthly-publication-may-2025.pdf   495 2025-05 Pedal Bike Ford FIESTA White Driving without Due Care and Attention None Merritts Brook lane Merritts Brook lane Birmingham Birmingham NFA No Offence   52.4159246 -1.9848186
19153 op-snap---monthly-publication-may-2025.pdf   515 2025-05 Pedal Bike Toyota Prius White Stop a vehicle within pelican pedestrian crossing limits None Trinity Street Trinity Street Coventry Coventry NFA Misc Inc Crimes   52.4086572 -1.5097176
19154 op-snap---monthly-publication-may-2025.pdf   516 2025-05 Pedal Bike BMW X1 Grey Contravening a Red Traffic Light None Barker Butt Lane Barker Butt Lane Coventry Coventry NFA No Independent Evidence Available      
19166 op-snap---monthly-publication-may-2025.pdf   528 2025-05 Pedal Bike Hyundai Tucson Grey Driving without Reasonable Consideration None Balsall Street Balsall Street Solihull Solihull NFA Outside of 14 Days NIP   52.3826029 -1.6998649
19169 op-snap---monthly-publication-may-2025.pdf   531 2025-05 Pedal Bike Ford Fiesta Black Driving without Reasonable Consideration None Station Road Station Road Solihull Solihull NFA Outside of 14 Days NIP   52.3927253 -1.6455823
19181 op-snap---monthly-publication-may-2025.pdf   543 2025-05 Pedal Bike Peugeot 306 Black Driving without Reasonable Consideration None Tanners Lane Tanners Lane Solihull Solihull NFA Outside of 14 Days NIP   52.3999016 -1.6082403
19183 op-snap---monthly-publication-may-2025.pdf   545 2025-05 Pedal Bike Ford pUMA Black Driving without Reasonable Consideration None Tile Hill Lane Tile Hill Lane Solihull Solihull NFA Outside of 14 Days NIP      
19188 op-snap---monthly-publication-may-2025.pdf   550 2025-05 Pedal Bike Citroen C3 Orange Driving without Due Care and Attention None Edward Road Edward Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4580901 -1.894458
19255 op-snap---monthly-publication-may-2025.pdf   617 2025-05 Pedal Bike Hyundai Tucson Beige Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bulls Head Lane Bulls Head Lane Coventry Coventry NFA No Offence   52.4026553 -1.4800859
19261 op-snap---monthly-publication-may-2025.pdf   623 2025-05 Pedal Bike Audi A3..` Black Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham NFA No Offence   52.4308271 -1.920078
19271 op-snap---monthly-publication-may-2025.pdf   633 2025-05 Pedal Bike Peugeot partner White Driving without Due Care and Attention None George Road George Road Birmingham Birmingham NFA No Offence   52.5155831 -1.8598862
19280 op-snap---monthly-publication-may-2025.pdf   642 2025-05 Pedal Bike Audi A5 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull NFA No VRM   52.4191184 -1.8326637
19288 op-snap---monthly-publication-may-2025.pdf   650 2025-05 Pedal Bike Honda Civic Blue Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
19360 op-snap---monthly-publication-may-2025.pdf   722 2025-05 Pedal Bike Nissan Leaf Grey Driving without Due Care and Attention None Maidenhead Road Maidenhead Road Dudley Dudley NFA Outside of 14 Days NIP      
19361 op-snap---monthly-publication-may-2025.pdf   723 2025-05 Pedal Bike Suzuki Vitara Red Driving without Due Care and Attention None Mile Flat Mile Flat Dudley Dudley NFA Outside of 14 Days NIP   52.5000458 -2.1979547
19375 op-snap---monthly-publication-may-2025.pdf   737 2025-05 Pedal Bike Seat Leon Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Vicarage Road Kings Heath Vicarage Road Kings Heath Birmingham Birmingham NFA No Independent Evidence Available   52.4280281 -1.9066654
19412 op-snap---monthly-publication-may-2025.pdf   774 2025-05 Pedal Bike Vauxhall Astra White Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA No Independent Evidence Available   52.4552785 -1.906384
19419 op-snap---monthly-publication-may-2025.pdf   781 2025-05 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5359496 -1.8324115
19436 op-snap---monthly-publication-may-2025.pdf   798 2025-05 Pedal Bike Vauxhall Corsa Grey Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4282602 -1.9861769
19437 op-snap---monthly-publication-may-2025.pdf   799 2025-05 Pedal Bike BMW 116d White Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
19438 op-snap---monthly-publication-may-2025.pdf   800 2025-05 Pedal Bike Ford Transit Blue Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.430111 -1.9753703
19439 op-snap---monthly-publication-may-2025.pdf   801 2025-05 Pedal Bike BMW M340i Black Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.430111 -1.9753703
19440 op-snap---monthly-publication-may-2025.pdf   802 2025-05 Pedal Bike Nissan Juke Blue Driving without Due Care and Attention None Stonehouse Lane Stonehouse Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4440435 -1.9818872
19441 op-snap---monthly-publication-may-2025.pdf   803 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.430111 -1.9753703
19442 op-snap---monthly-publication-may-2025.pdf   804 2025-05 Pedal Bike Mitsubishi L200 Grey Driving without Due Care and Attention None Merritts Hill Merritts Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.424853 -1.9814275
19444 op-snap---monthly-publication-may-2025.pdf   806 2025-05 Pedal Bike Nissan Juke Blue Driving without Due Care and Attention None Stonehouse Road Stonehouse Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5507024 -1.8418964
19449 op-snap---monthly-publication-may-2025.pdf   811 2025-05 Pedal Bike Ford Puma Blue Stop a vehicle within pelican pedestrian crossing limits None Gooch St Gooch Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4686609 -1.8945007
19474 op-snap---monthly-publication-may-2025.pdf   836 2025-05 Pedal Bike Toyota Prius White Contravening a Red Traffic Light None Belgrave Middleway Belgrave Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4668753 -1.8996143
19502 op-snap---monthly-publication-may-2025.pdf   864 2025-05 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Fairfax Street Fairfax Street Coventry Coventry NFA Outside of 14 Days NIP   52.4097547 -1.5065519
19524 op-snap---monthly-publication-may-2025.pdf   886 2025-05 Pedal Bike Mercedes-Benz CLA 220 Grey Driving without Reasonable Consideration None A458 Bridgnorth Bridgnorth Out of Force Area Out of Force Area NFA Out of Force      
19622 op-snap---monthly-publication-may-2025.pdf   984 2025-05 Pedal Bike Skoda Octavia White Contravening a Red Traffic Light None Bearwood Road Bearwood Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4725977 -1.9684448
19625 op-snap---monthly-publication-may-2025.pdf   987 2025-05 Pedal Bike Volkswagen Golf Black Using a Mobile Phone Whilst Driving None Bearwood Road Bearwood Road Sandwell Sandwell NFA No Independent Evidence Available   52.4725977 -1.9684448
19659 op-snap---monthly-publication-may-2025.pdf   1021 2025-05 Pedal Bike Mercedes-Benz GLC 250 White Motor vehicle fail to comply with solid white line road markings None Wesbury Road Wesbury Road Out of Force Area Out of Force Area NFA Out of Force      
19660 op-snap---monthly-publication-may-2025.pdf   1022 2025-05 Pedal Bike Ford C-Max Blue Motor vehicle fail to comply with solid white line road markings None Wesbury Road Wesbury Road Out of Force Area Out of Force Area NFA Out of Force      
19661 op-snap---monthly-publication-may-2025.pdf   1023 2025-05 Pedal Bike Ford Ecosport Grey Motor vehicle fail to comply with solid white line road markings None Wesbury Road Wesbury Road Out of Force Area Out of Force Area NFA Out of Force      
19662 op-snap---monthly-publication-may-2025.pdf   1024 2025-05 Pedal Bike Mazda MX5 Red Motor vehicle fail to comply with solid white line road markings None Webury Road Webury Road Out of Force Area Out of Force Area NFA Out of Force      
19663 op-snap---monthly-publication-may-2025.pdf   1025 2025-05 Pedal Bike Audi Q2 Silver Motor vehicle fail to comply with solid white line road markings None Wesbury Road Wesbury Road Out of Force Area Out of Force Area NFA Out of Force      
19667 op-snap---monthly-publication-may-2025.pdf   1029 2025-05 Pedal Bike Toyota Auris Blue Driving without Reasonable Consideration None Station Road Station Road Birmingham Birmingham NFA No Offence   52.5054559 -1.9506109
19802 op-snap---monthly-publication-may-2025.pdf   1164 2025-05 Pedal Bike BMW X5 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Jubilee Crescent Jubilee Crescent Coventry Coventry NFA No Offence   52.4307567 -1.5167147
19803 op-snap---monthly-publication-may-2025.pdf   1165 2025-05 Pedal Bike Ford Capri Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Jubilee Crescent Jubilee Crescent Coventry Coventry NFA No Offence   52.4307567 -1.5167147
19804 op-snap---monthly-publication-may-2025.pdf   1166 2025-05 Pedal Bike Jaguar XE Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None The Barley Lea The Barley Lea Coventry Coventry NFA No Offence   52.3952661 -1.4705187
19805 op-snap---monthly-publication-may-2025.pdf   1167 2025-05 Pedal Bike Volkswagen Passat Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Far Gosford Street Far Gosford Street Coventry Coventry NFA Not in Public Interest   52.4071231 -1.4985178
19807 op-snap---monthly-publication-may-2025.pdf   1169 2025-05 Pedal Bike Mg ZS Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hales Street Hales Street Coventry Coventry NFA Not in Public Interest   52.4110271 -1.5074539
19808 op-snap---monthly-publication-may-2025.pdf   1170 2025-05 Pedal Bike Honda Accord Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Far Gosford Street Far Gosford Street Coventry Coventry NFA Not in Public Interest   52.4071231 -1.4985178
19902 op-snap---monthly-publication-may-2025.pdf   1264 2025-05 Pedal Bike Vauxhall NP White Driving without Due Care and Attention None Birmingham road, A5127 Birmingham road, A5127 Birmingham Birmingham NFA Outside of 14 Days NIP   52.5519132 -1.8267718
19903 op-snap---monthly-publication-may-2025.pdf   1265 2025-05 Pedal Bike Renault NP Grey Driving without Due Care and Attention None hoggs lane, frankley Hoggs Lane, Frankley Birmingham Birmingham NFA Outside of 14 Days NIP   52.4158643 -1.9846878
19904 op-snap---monthly-publication-may-2025.pdf   1266 2025-05 Pedal Bike Mini NP Red Driving without Due Care and Attention None JCT Dimsdale road JCT Dimsdale road Birmingham Birmingham NFA Outside of 14 Days NIP      
19905 op-snap---monthly-publication-may-2025.pdf   1267 2025-05 Pedal Bike Mini NP Red Driving without Due Care and Attention None jct frankley beeches road Jct Frankley Beeches Road Birmingham Birmingham NFA Outside of 14 Days NIP      
19907 op-snap---monthly-publication-may-2025.pdf   1269 2025-05 Pedal Bike Renault NP White Driving without Due Care and Attention None RAB A38, lickey road RAB A38, lickey road Birmingham Birmingham NFA Outside of 14 Days NIP      
19914 op-snap---monthly-publication-may-2025.pdf   1276 2025-05 Pedal Bike Vauxhall Combo White Driving without Due Care and Attention None JTC cock hll lane/sandstone avenue JTC cock hll lane/sandstone avenue Birmingham Birmingham NFA Outside of 14 Days NIP      
19915 op-snap---monthly-publication-may-2025.pdf   1277 2025-05 Pedal Bike Ford Transit White Using a Mobile Phone Whilst Driving None JTC New strreet/frogmill road JTC New strreet/frogmill road Birmingham Birmingham NFA Out of Force      
19918 op-snap---monthly-publication-may-2025.pdf   1280 2025-05 Pedal Bike Citroen C4 Grey Contravening a Red Traffic Light None Foleshill road, at A444 roundabout Foleshill road, at A444 roundabout Coventry Coventry NFA Outside of 14 Days NIP   52.4363104 -1.4936555
19933 op-snap---monthly-publication-may-2025.pdf   1295 2025-05 Pedal Bike Mitsubishi L200 Black Driving without Due Care and Attention None holyhead road Holyhead Road Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5967563 -2.1605854
19953 op-snap---monthly-publication-may-2025.pdf   1315 2025-05 Pedal Bike Daf Truck White Driving without Due Care and Attention None Chester road Chester road Walsall Walsall NFA Outside of 14 Days NIP   52.5692139 -1.8799672
19958 op-snap---monthly-publication-may-2025.pdf   1320 2025-05 Pedal Bike Toyota Prius White Contravening a Red Traffic Light None Gosford Street , Coventry Gosford Street , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4068712 -1.4994695
19963 op-snap---monthly-publication-may-2025.pdf   1325 2025-05 Pedal Bike Peugeot Boxer White Stop a vehicle within pelican pedestrian crossing limits None Stoney STanton Road , Coventry Stoney STanton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4295082 -1.4871963

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