home / opsnap

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

189 rows where disposal = "NFA" and month = "2025-01" 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

vehicle_make 27

  • Ford 28
  • BMW 22
  • Mercedes-Benz 17
  • Volkswagen 14
  • Audi 12
  • Vauxhall 10
  • Toyota 8
  • Seat 7
  • Land Rover 5
  • Nissan 5
  • Honda 4
  • Jaguar 4
  • Renault 4
  • Hyundai 3
  • Lexus 3
  • Mini 3
  • Peugeot 3
  • Volvo 3
  • Daf 2
  • Isuzu 2
  • Kia 2
  • Mg 2
  • Skoda 2
  • Citroen 1
  • Fiat 1
  • Tesla 1
  • Yamaha 1

offence 23

  • Driving without Due Care and Attention 67
  • Contravening a Red Traffic Light 28
  • Misc - Non Traffic Offences 23
  • Using a Mobile Phone Whilst Driving 16
  • Driving without Reasonable Consideration 15
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 13
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 3
  • Stop a vehicle within pelican pedestrian crossing limits 3
  • VRM fails to conform to Regulations 3
  • Dangerous Driving 2
  • Motor vehicle fail to accord precedence at a pelican crossing 2
  • No Insurance 2
  • Use vehicle on a road without valid test certificate 2
  • Cause vehicle to be left in a dangerous position 1
  • Drive on hard shoulder 1
  • Motor vehicle fail to comply with solid white line road markings 1
  • No Seat Belt 1
  • No vehicle excise licence 1
  • Stop a vehicle on pedestrian crossing 1
  • Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
  • Use a motor vehicle / trailer the number of passenger / manner carried likely to cause danger 1
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
  • Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1

council_area 10

  • Birmingham 74
  • Out of Force Area 36
  • Sandwell 15
  • Coventry 14
  • Out Of Force Area 11
  • Wolverhampton 9
  • Dudley 7
  • Solihull 7
  • Walsall 7
  • Sutton Coldfield 5

reporter_transport_mode 6

  • Car 127
  • Pedestrian 29
  • Pedal Bike 22
  • Other 6
  • Lorry 4
  • car 1

month 1

  • 2025-01 · 189 ✖

disposal 1

  • NFA · 189 ✖
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
8920 op-snap---monthly-publication-january-2025.pdf   28 2025-01 Car Mercedes-Benz C220 Blue Driving without Due Care and Attention None M42 J3 M42 J3 Solihull Solihull NFA Out of Force Yes - Via Email 52.4846642 -1.9297585
8922 op-snap---monthly-publication-january-2025.pdf   30 2025-01 Pedal Bike BMW X2 Blue Driving without Due Care and Attention None Brandwood Road Brandwood Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4139427 -1.9037653
8924 op-snap---monthly-publication-january-2025.pdf   32 2025-01 Car BMW UK Grey Using a Mobile Phone Whilst Driving None A5 A5 Birmingham Birmingham NFA Out of Force Yes - Via Email    
8934 op-snap---monthly-publication-january-2025.pdf   42 2025-01 Car Mercedes-Benz C43 Grey Driving without Due Care and Attention None Yew Tree Lane Yew Tree Lane Birmingham Birmingham NFA No Offence Yes - Via Email 52.4631 -1.8082055
8944 op-snap---monthly-publication-january-2025.pdf   52 2025-01 Pedestrian Toyota Avenis Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bordsley Green East Bordsley Green East Birmingham Birmingham NFA Not in Public Interest Yes - Via Email    
8946 op-snap---monthly-publication-january-2025.pdf   54 2025-01 Car Mercedes-Benz GLB 200 Black Contravening a Red Traffic Light None Lickey Road Lickey Road Birmingham Birmingham NFA Out of Force Yes - Via Email 52.3868298 -2.0003781
8950 op-snap---monthly-publication-january-2025.pdf   58 2025-01 Car   UK Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Lower Queen Street Lower Queen Street Sutton Coldfield Sutton Coldfield NFA No VRM Yes - Via Email 52.5603978 -1.8227403
8984 op-snap---monthly-publication-january-2025.pdf   92 2025-01 Car Land Rover Vogue Silver VRM fails to conform to Regulations None Streetsbrook Road Streetsbrook Road Solihull Solihull NFA No Independent Evidence Available Yes - Via Email 52.4223176 -1.8253145
8992 op-snap---monthly-publication-january-2025.pdf   100 2025-01 Pedestrian Fiat Panda Blue Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Foleshill Road Foleshill Road Coventry Coventry NFA No VRM Yes - Via Email 52.4274335 -1.5002381
8995 op-snap---monthly-publication-january-2025.pdf   103 2025-01 Pedal Bike Ford FOCUS Blue Using a Mobile Phone Whilst Driving None WALSGRAVE ROAD Walsgrave Road Coventry Coventry NFA No Independent Evidence Available Yes - Via Email 52.4096725 -1.487901
8997 op-snap---monthly-publication-january-2025.pdf   105 2025-01 Pedestrian Ford Fiesta Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None South Roundhay South Roundhay Birmingham Birmingham NFA No VRM Yes - Via Email 52.4841536 -1.7938562
9021 op-snap---monthly-publication-january-2025.pdf   129 2025-01 Car Ford TRANSIT White Contravening a Red Traffic Light None A452 CHESTER ROAD A452 Chester Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.5338529 -1.8296813
9025 op-snap---monthly-publication-january-2025.pdf   133 2025-01 Car Renault N/P   Drive on hard shoulder None M6 NORTH JCT 8-9 M6 North Jct 8-9 Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email    
9028 op-snap---monthly-publication-january-2025.pdf   136 2025-01 Pedestrian Skoda Kamiq Grey Contravening a Red Traffic Light None Rivcer Drive Rivcer Drive Walsall Walsall NFA Out of Force Yes - Via Email    
9031 op-snap---monthly-publication-january-2025.pdf   139 2025-01 Car Jaguar F Pace Black Motor vehicle fail to comply with solid white line road markings None M6 Motorway, Junction with M54 M6 Motorway, Junction with M54 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9058 op-snap---monthly-publication-january-2025.pdf   166 2025-01 Pedestrian BMW Unknown Grey Stop a vehicle within pelican pedestrian crossing limits None Church Road, Moseley Church Road, Moseley Birmingham Birmingham NFA Not in Public Interest Yes - Via Email 52.4494933 -1.8812882
9061 op-snap---monthly-publication-january-2025.pdf   169 2025-01 Pedestrian Hyundai Unknown White Stop a vehicle on pedestrian crossing None Hollyfast Road Hollyfast Road Coventry Coventry NFA No VRM Yes - Via Email 52.4230701 -1.5346523
9063 op-snap---monthly-publication-january-2025.pdf   171 2025-01 Car Volkswagen Golf Black Driving without Due Care and Attention None The Green, Kings Norton The Green, Kings Norton Birmingham Birmingham NFA No Offence Yes - Via Email 52.4065866 -1.9308921
9067 op-snap---monthly-publication-january-2025.pdf   175 2025-01 Pedestrian Jaguar UK Blue Driving without Due Care and Attention None unknown   Birmingham Birmingham NFA No VRM Yes - Via Email    
9068 op-snap---monthly-publication-january-2025.pdf   176 2025-01 Lorry Honda CTV Silver Driving without Due Care and Attention None A448 BROMSGROVE A448 Bromsgrove Birmingham Birmingham NFA Out of Force Yes - Via Email 52.4728322 -1.897536
9080 op-snap---monthly-publication-january-2025.pdf   188 2025-01 Car Ford Transit White Driving without Reasonable Consideration None Himbleton Road Worcestershire Himbleton Road Worcestershire Birmingham Birmingham NFA Out of Force Yes - Via Email    
9081 op-snap---monthly-publication-january-2025.pdf   189 2025-01 Pedestrian Yamaha UK Purple Misc - Non Traffic Offences None Navigation Drive Navigation Drive Birmingham Birmingham NFA No Offence Yes - Via Email 52.4119299 -1.8981368
9086 op-snap---monthly-publication-january-2025.pdf   194 2025-01 Car Mercedes-Benz A Class Grey Driving without Reasonable Consideration None M42 Warwickshire M42 Warwickshire Birmingham Birmingham NFA Out of Force Yes - Via Email    
9089 op-snap---monthly-publication-january-2025.pdf   197 2025-01 Other       Misc - Non Traffic Offences None York, Out of Force York, Out of Force Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9092 op-snap---monthly-publication-january-2025.pdf   200 2025-01 Car Daf HGV Blue Driving without Reasonable Consideration None Unknown not given Unknown not given Birmingham Birmingham NFA No VRM Yes - Via Email    
9093 op-snap---monthly-publication-january-2025.pdf   201 2025-01 Pedestrian Volkswagen Troc White Cause vehicle to be left in a dangerous position None Meadow Road Wythall West Mercia Meadow Road Wythall West Mercia Birmingham Birmingham NFA Out of Force Yes - Via Email    
9110 op-snap---monthly-publication-january-2025.pdf   218 2025-01 Other Audi U/K Black Driving without Reasonable Consideration None A38 Expressway (outbound towards A38) Expressway (outbound towards A38) Birmingham Birmingham NFA Not in Public Interest Yes - Via Email    
9136 op-snap---monthly-publication-january-2025.pdf   244 2025-01 Pedestrian Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Windrush Lane Windrush Lane Solihull Solihull NFA Misc Inc Crimes Yes - Via Email    
9137 op-snap---monthly-publication-january-2025.pdf   245 2025-01 Pedal Bike Lexus GS Black Using a Mobile Phone Whilst Driving None SALISBURY ROAD Salisbury Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4943878 -1.8504211
9139 op-snap---monthly-publication-january-2025.pdf   247 2025-01 Pedal Bike Seat Alhammbra Grey Using a Mobile Phone Whilst Driving None Alcester Rd Alcester Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4470686 -1.8880749
9144 op-snap---monthly-publication-january-2025.pdf   252 2025-01 Pedal Bike Toyota Rav 4 Black Driving without Due Care and Attention None Droitwich Road Droitwich Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9153 op-snap---monthly-publication-january-2025.pdf   261 2025-01 Car Land Rover Defender Black Driving without Reasonable Consideration None M54 Jct 2 to 3, Coven, Staffs M54 Junction 2 to 3, Coven, Staffs Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9155 op-snap---monthly-publication-january-2025.pdf   263 2025-01 Car Renault UNKNOWN Blue Driving without Due Care and Attention None Portland Road Portland Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.4737014 -1.9412436
9158 op-snap---monthly-publication-january-2025.pdf   266 2025-01 Pedal Bike BMW ? White Driving without Due Care and Attention None Birmingham Street, Stourbridge Birmingham Street, Stourbridge Dudley Dudley NFA No VRM Yes - Via Email 52.4571139 -2.1359828
9159 op-snap---monthly-publication-january-2025.pdf   267 2025-01 Pedestrian Vauxhall Corsa White No vehicle excise licence None Canal Court Acocks Green Canal Court Acocks Green Birmingham Birmingham NFA No Offence Yes - Via Email 52.4486586 -1.8085554
9160 op-snap---monthly-publication-january-2025.pdf   268 2025-01 Lorry BMW X1 Silver Driving without Due Care and Attention None Holmer Road, HEREFORD Holmer Road, HEREFORD Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9183 op-snap---monthly-publication-january-2025.pdf   291 2025-01 Pedal Bike Honda Jazz Red Driving without Due Care and Attention None Stoneleigh Road, Stareton, Kenilworth, WARWICKSHIRE Stoneleigh Road, Stareton, Kenilworth, WARWICKSHIRE Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9185 op-snap---monthly-publication-january-2025.pdf   293 2025-01 Car Peugeot   Black Driving without Due Care and Attention None B4121 B4121 Birmingham Birmingham NFA No VRM Yes - Via Email 52.4448693 -1.9772096
9193 op-snap---monthly-publication-january-2025.pdf   301 2025-01 Car Toyota Auris White Driving without Due Care and Attention None A441 Birmingham Road, Alvechurch, WEST MERCIA. Birmingham Road, Alvechurch, WEST MERCIA Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9209 op-snap---monthly-publication-january-2025.pdf   317 2025-01 Car Mercedes-Benz A200 White Use a motor vehicle / trailer the number of passenger / manner carried likely to cause danger None Birmingham Road Stratford Upon Avon Birmingham Road Stratford Upon Avon Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9221 op-snap---monthly-publication-january-2025.pdf   329 2025-01 Car BMW 520 Blue Use a motor vehicle / trailer in a condition likely to cause danger of injury None SWAN ISLAND Swan Island Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4616042 -1.8154705
9258 op-snap---monthly-publication-january-2025.pdf   366 2025-01 Car     Black Driving without Due Care and Attention None STRATFORD ROAD Stratford Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4203897 -1.8338574
9261 op-snap---monthly-publication-january-2025.pdf   369 2025-01 Pedestrian Audi RS Grey VRM fails to conform to Regulations None FRANK HOLMES DRIVE Frank Holmes Drive Birmingham Birmingham NFA No Offence Yes - Via Email    
9268 op-snap---monthly-publication-january-2025.pdf   376 2025-01 Car Ford MONDEO Silver Driving without Due Care and Attention None A34 EARLS BARTON A34 Earls Barton Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9287 op-snap---monthly-publication-january-2025.pdf   395 2025-01 Car Nissan Note Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Hurstcroft Road Hurstcroft Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4830179 -1.783876
9289 op-snap---monthly-publication-january-2025.pdf   397 2025-01 Car Ford Transit White Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.430111 -1.9753703
9300 op-snap---monthly-publication-january-2025.pdf   408 2025-01 Car Land Rover Evoque White Contravening a Red Traffic Light None A491/A456 West Hagley- West Mercia A491/A456 West Hagley- West Mercia Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9323 op-snap---monthly-publication-january-2025.pdf   431 2025-01 Car Nissan Qashqai Grey Driving without Due Care and Attention None Longfellow Road Longfellow Road Coventry Coventry NFA No VRM Yes - Via Email 52.4102345 -1.4609881
9338 op-snap---monthly-publication-january-2025.pdf   446 2025-01 Other Vauxhall Vivaro Red Use vehicle on a road without valid test certificate None Firs Road, Kingswinford Firs Road, Kingswinford Dudley Dudley NFA No Offence Yes - Via Email 52.4950857 -2.159268
9345 op-snap---monthly-publication-january-2025.pdf   453 2025-01 Car Ford TRANSIT White Driving without Due Care and Attention NONE MALBOROUGH WAY, TAMWORTH Malborough Way, Tamworth Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9347 op-snap---monthly-publication-january-2025.pdf   455 2025-01 Car Jaguar XJL Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Mapleton Road Mapleton Road Birmingham Birmingham NFA Misc Inc Crimes Yes - Via Email 52.4278334 -1.8282582
9367 op-snap---monthly-publication-january-2025.pdf   475 2025-01 Car       Driving without Due Care and Attention None Hertford Road Hertford Road Solihull Solihull NFA Misc Inc Crimes Yes - Via Email    
9383 op-snap---monthly-publication-january-2025.pdf   491 2025-01 Car Land Rover Evoque Black Using a Mobile Phone Whilst Driving None Trinity Way Trinity Way Sandwell Sandwell NFA Not in Public Interest Yes - Via Email 52.5119175 -1.9882917
9402 op-snap---monthly-publication-january-2025.pdf   510 2025-01 Car Ford TRANSIT Black Driving without Due Care and Attention None SPON END Spon End Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.5071465 -2.0049226
9403 op-snap---monthly-publication-january-2025.pdf   511 2025-01 Car Isuzu D MAX Grey Contravening a Red Traffic Light None DARTMOUTH CIRCUS Dartmouth Circus Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4926487 -1.8879638
9407 op-snap---monthly-publication-january-2025.pdf   515 2025-01 Car BMW X6 Black Driving without Due Care and Attention None M6 J3 M6 J3 Coventry Coventry NFA Out of Force Yes - Via Email 52.6912652 -2.1043715
9409 op-snap---monthly-publication-january-2025.pdf   517 2025-01 Car Seat LEON CUPRA Grey Driving without Due Care and Attention None M42 SOUTH 3A TO 3 M42 South 3A To 3 Solihull Solihull NFA Out of Force Yes - Via Email    
9412 op-snap---monthly-publication-january-2025.pdf   520 2025-01 Pedal Bike Volkswagen Polo Red Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry NFA No VRM Yes - Via Email 52.3988977 -1.5323674
9413 op-snap---monthly-publication-january-2025.pdf   521 2025-01 Pedestrian       Contravening a Red Traffic Light None Walsall unknown Walsall unknown Walsall Walsall NFA No VRM Yes - Via Email    
9425 op-snap---monthly-publication-january-2025.pdf   533 2025-01 Car Skoda RAPID Silver Using a Mobile Phone Whilst Driving NONE DUDLEY PORT Dudley Port Dudley Dudley NFA No Offence Yes - Via Email 52.524461 -2.0492538
9431 op-snap---monthly-publication-january-2025.pdf   539 2025-01 Car Ford RANGER Black Driving without Due Care and Attention None BONEHILL ROAD,TAMWORTH Bonehill Road, Tamworth Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9432 op-snap---monthly-publication-january-2025.pdf   540 2025-01 Car Ford FIESTA Red Using a Mobile Phone Whilst Driving None M6 NORTH 10 TO 10A M6 North 10 To 10A Walsall Walsall NFA Misc Inc Crimes Yes - Via Email    
9435 op-snap---monthly-publication-january-2025.pdf   543 2025-01 Car Seat IBIZA White Contravening a Red Traffic Light None LOWER TESSAL LANE Lower Tessal Lane Birmingham Birmingham NFA No Offence Yes - Via Email    
9440 op-snap---monthly-publication-january-2025.pdf   548 2025-01 Car Audi A4 Grey Driving without Due Care and Attention None Halfway House Lane, Bridgenorth Halfway House Lane, Bridgenorth Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9444 op-snap---monthly-publication-january-2025.pdf   552 2025-01 Car Volkswagen Polo Blue Driving without Due Care and Attention None Weir Lane, Worcester Weir Lane, Worcester Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9446 op-snap---monthly-publication-january-2025.pdf   554 2025-01 Car Vauxhall Insignia White No Insurance Littering Jockey Road Jockey Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available Yes - Via Email 52.5535276 -1.8302584
9460 op-snap---monthly-publication-january-2025.pdf   568 2025-01 Car BMW M2 Grey Driving without Due Care and Attention No Insurance FAR MOOR LANE, REDDITCH Far Moor Lane, Redditch Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9474 op-snap---monthly-publication-january-2025.pdf   582 2025-01 Car Ford FIESTA Grey Driving without Due Care and Attention None TESSALL LANE Tessall Lane Birmingham Birmingham NFA No VRM Yes - Via Email 52.4045186 -1.9891793
9492 op-snap---monthly-publication-january-2025.pdf   600 2025-01 Car Ford Fiesta Grey Contravening a Red Traffic Light None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton NFA No Independent Evidence Available Yes - Via Email 52.5847884 -2.1341887
9493 op-snap---monthly-publication-january-2025.pdf   601 2025-01 Pedal Bike   N/a Black Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry NFA No VRM Yes - Via Email 52.4134557 -1.4442138
9512 op-snap---monthly-publication-january-2025.pdf   620 2025-01 Pedestrian Renault CLIO White Motor vehicle fail to accord precedence at a pelican crossing None CAUSEWAY GREEN Causeway Green Birmingham Birmingham NFA No Offence Yes - Via Email    
9538 op-snap---monthly-publication-january-2025.pdf   646 2025-01 Pedal Bike Audi A4 Red Driving without Reasonable Consideration None B4510 OFFENHAM B4510 Offenham Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9547 op-snap---monthly-publication-january-2025.pdf   655 2025-01 Car Nissan Qashqai Grey Misc - Non Traffic Offences None Island Road Island Road Sandwell Sandwell NFA No Offence Yes - Via Email 52.4634433 -1.9965278
9548 op-snap---monthly-publication-january-2025.pdf   656 2025-01 Car Volkswagen Polo Orange Misc - Non Traffic Offences None Island Road Island Road Sandwell Sandwell NFA No Offence Yes - Via Email 52.4634433 -1.9965278
9549 op-snap---monthly-publication-january-2025.pdf   657 2025-01 Car Toyota Yaris Silver Misc - Non Traffic Offences None Island Road Island Road Sandwell Sandwell NFA No Offence Yes - Via Email 52.4634433 -1.9965278
9550 op-snap---monthly-publication-january-2025.pdf   658 2025-01 Car Ford Puma Blue Misc - Non Traffic Offences None Island Road Island Road Sandwell Sandwell NFA No Offence Yes - Via Email 52.4634433 -1.9965278
9551 op-snap---monthly-publication-january-2025.pdf   659 2025-01 Pedal Bike Ford Fiesta White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Breedon Road Breedon Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.4191978 -1.9251219
9558 op-snap---monthly-publication-january-2025.pdf   666 2025-01 Pedestrian   MAN White Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.5113867 -1.8337258
9592 op-snap---monthly-publication-january-2025.pdf   700 2025-01 Car Seat Cupra Gold Contravening a Red Traffic Light None Yardley Green Rd Yardley Green Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.4764154 -1.8311418
9595 op-snap---monthly-publication-january-2025.pdf   703 2025-01 Pedestrian Ford Transit White Use vehicle on a road without valid test certificate None Formans Rd Formans Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4482024 -1.8507493
9612 op-snap---monthly-publication-january-2025.pdf   720 2025-01 Car Volvo Tractor White Driving without Reasonable Consideration None M5 J5-J6 Worcestershire M5 J5-J6 Worcestershire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9624 op-snap---monthly-publication-january-2025.pdf   732 2025-01 Car Mercedes-Benz Sprinter White Misc - Non Traffic Offences None Island Road Island Road Sandwell Sandwell NFA No Offence Yes - Via Email 52.4634433 -1.9965278
9631 op-snap---monthly-publication-january-2025.pdf   739 2025-01 Car Mercedes-Benz   Green Driving without Due Care and Attention None St Mary's Row Street Mary's Row Birmingham Birmingham NFA No VRM Yes - Via Email    
9645 op-snap---monthly-publication-january-2025.pdf   753 2025-01 Pedal Bike Hyundai Tuscon Grey Driving without Reasonable Consideration None A38 upton upon severn A38 upton upon severn Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9646 op-snap---monthly-publication-january-2025.pdf   754 2025-01 Pedal Bike Toyota chr Grey Driving without Reasonable Consideration None A4101 upton upon severn A4101 upton upon severn Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9649 op-snap---monthly-publication-january-2025.pdf   757 2025-01 Car Audi q3 Green Driving without Due Care and Attention None A435 Wyhthall Wyhthall Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9657 op-snap---monthly-publication-january-2025.pdf   765 2025-01 Pedal Bike Kia Ceed Brown Contravening a Red Traffic Light None Beake Ave Beake Ave Coventry Coventry NFA No Independent Evidence Available Yes - Via Email 52.4360855 -1.5226352
9673 op-snap---monthly-publication-january-2025.pdf   781 2025-01 Car Volvo XC40 White Stop a vehicle within pelican pedestrian crossing limits None Bearwood Road Bearwood Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.4762784 -1.9678366
9701 op-snap---monthly-publication-january-2025.pdf   809 2025-01 Pedestrian Mercedes-Benz AMG Black Driving without Due Care and Attention None The Crescent The Crescent Solihull Solihull NFA No Independent Evidence Available Yes - Via Email 52.4160704 -1.834411
9724 op-snap---monthly-publication-january-2025.pdf   832 2025-01 Pedestrian Kia Carens Black Misc - Non Traffic Offences None Adams Street Adams Street Sandwell Sandwell NFA No Offence Yes - Via Email 52.5206781 -2.0082357
9743 op-snap---monthly-publication-january-2025.pdf   851 2025-01 Car   UNKNOWN   Driving without Due Care and Attention None UNKNOWN   Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email    
9744 op-snap---monthly-publication-january-2025.pdf   852 2025-01 Car Ford Focus Black Contravening a Red Traffic Light None Aston Road Aston Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.4929386 -1.888744
9750 op-snap---monthly-publication-january-2025.pdf   858 2025-01 Car Mercedes-Benz C63 White Driving without Due Care and Attention None M40 towards 3a M40 towards 3a Birmingham Birmingham NFA Out of Force Yes - Via Email    
9752 op-snap---monthly-publication-january-2025.pdf   860 2025-01 Pedal Bike Peugeot 3008 White Using a Mobile Phone Whilst Driving None Coventry Eastern By-Pass Coventry Eastern By-Pass Coventry Coventry NFA Out of Force Yes - Via Email    
9755 op-snap---monthly-publication-january-2025.pdf   863 2025-01 Pedal Bike BMW 320 white Using a Mobile Phone Whilst Driving None Coventry Eastern By-Pass Coventry Eastern By-Pass Coventry Coventry NFA Out of Force Yes - Via Email    
9756 op-snap---monthly-publication-january-2025.pdf   864 2025-01 Car BMW 5 SERIES Black Contravening a Red Traffic Light None WATERLOO ROAD Waterloo Road Wolverhampton Wolverhampton NFA No VRM Yes - Via Email 52.5960155 -2.1295068
9757 op-snap---monthly-publication-january-2025.pdf   865 2025-01 Pedestrian Volkswagen Golf White Using a Mobile Phone Whilst Driving None Coventry Eastern By-Pass Coventry Eastern By-Pass Coventry Coventry NFA Out of Force Yes - Via Email    
9764 op-snap---monthly-publication-january-2025.pdf   872 2025-01 Car Nissan Qashqai White Driving without Due Care and Attention None Holmer Farm Road, TELFORD Holmer Farm Road, TELFORD     NFA Out of Force Yes - Via Email    
9772 op-snap---monthly-publication-january-2025.pdf   880 2025-01 Car Seat LEON Black Driving without Due Care and Attention VRM fails to conform to Regulations COVENTRY ROAD Coventry Road     NFA No Independent Evidence Available Yes - Via Email 52.4726661 -1.8769032
9779 op-snap---monthly-publication-january-2025.pdf   887 2025-01 Car Ford Transit White Using a Mobile Phone Whilst Driving None Stourbridge Road, Bell Heath- Worcestershire Stourbridge Road, Bell Heath- Worcestershire Out of Force Area Out of Force Area NFA No Independent Evidence Available Yes - Via Email    

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