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

198 rows where council_area = "Sutton Coldfield" and disposal = "NFA" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

vehicle_make 30

  • Ford 17
  • Audi 16
  • Mercedes-Benz 16
  • BMW 15
  • Vauxhall 14
  • Volkswagen 13
  • Land Rover 8
  • Toyota 8
  • Skoda 6
  • Citroen 4
  • Lexus 4
  • Nissan 4
  • Peugeot 4
  • Porsche 4
  • Seat 4
  • Alfa Romeo 3
  • Kia 3
  • Mg 3
  • Mini 3
  • Daf 2
  • Fiat 2
  • Hyundai 2
  • Mazda 2
  • Renault 2
  • Tesla 2
  • Volvo 2
  • Yamaha 2
  • Honda 1
  • Jaguar 1
  • Suzuki 1

offence 17

  • Driving without Due Care and Attention 63
  • Contravening a Red Traffic Light 25
  • Driving without Reasonable Consideration 18
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 17
  • Cause vehicle to be left in a dangerous position 16
  • Misc - Non Traffic Offences 16
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 13
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 11
  • Using a Mobile Phone Whilst Driving 7
  • Stop a vehicle within pelican pedestrian crossing limits 3
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
  • No Insurance 2
  • Dangerous Driving 1
  • Driving a vehicle wholly or partly on a footpath 1
  • Fail to display front VRM plate 1
  • Stop a vehicle on pedestrian crossing 1
  • Use a motor vehicle / trailer in a condition likely to cause danger of injury 1

month 14

  • 2025-04 50
  • 2025-06 26
  • 2025-10 19
  • 2025-05 18
  • 2025-07 15
  • 2025-08 14
  • 2025-11 10
  • 2025-02 9
  • 2025-03 8
  • 2025-12 8
  • 2025-09 6
  • 2025-01 5
  • 2026-01 5
  • 2026-02 5

reporter_transport_mode 6

  • Car 121
  • Pedestrian 49
  • Pedal Bike 23
  • Horse Rider 2
  • Other 2
  • Bus 1

disposal 1

  • NFA · 198 ✖

council_area 1

  • Sutton Coldfield · 198 ✖
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
8278 op-snap---monthly-publication-february-2026.pdf   1025 2026-02 Car Toyota Auris Grey Driving without Due Care and Attention None Ebrook Road Ebrook Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5557273 -1.8159805
8433 op-snap---monthly-publication-february-2026.pdf   1180 2026-02 Car Audi   Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield NFA No VRM   52.5872149 -1.8300386
8522 op-snap---monthly-publication-february-2026.pdf   1269 2026-02 Horse Rider Porsche Boxter Red Driving without Reasonable Consideration None Worcester Lane Worcester Lane Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5908671 -1.8140277
8547 op-snap---monthly-publication-february-2026.pdf   1294 2026-02 Car   HGV White Contravening a Red Traffic Light None Walmley Ash Road Walmley Ash Road Sutton Coldfield Sutton Coldfield NFA No VRM   52.5376726 -1.7973346
8671 op-snap---monthly-publication-february-2026.pdf   1418 2026-02 Pedal Bike Peugeot 3008 Silver Driving without Due Care and Attention None Maxstroke Road Maxstroke Road Sutton Coldfield Sutton Coldfield NFA No Offence      
10623 op-snap---monthly-publication-january-2026.pdf   84 2026-01 Pedestrian Tesla model y White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None mulroy road Mulroy Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5705037 -1.8281673
10624 op-snap---monthly-publication-january-2026.pdf   85 2026-01 Pedestrian Nissan juke Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None mulroy road Mulroy Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5705037 -1.8281673
10954 op-snap---monthly-publication-january-2026.pdf   415 2026-01 Pedestrian Fiat 500 White Contravening a Red Traffic Light None Chester Road North Chester Road North Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.548449 -1.8594603
11714 op-snap---monthly-publication-january-2026.pdf   1175 2026-01 Car Ford focus Black No Insurance No vehicle excise licence Slade Road Slade Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.591066 -1.8027604
11729 op-snap---monthly-publication-january-2026.pdf   1190 2026-01 Car Lexus 300 White Driving without Due Care and Attention None Whitehouse Common Whitehouse Common Sutton Coldfield Sutton Coldfield NFA Not in Public Interest   52.5720288 -1.8018459
4000 op-snap---monthly-publication-december-2025.pdf   128 2025-12 Car Land Rover Range Rover Brown Driving without Due Care and Attention None Goldieslie Road Goldieslie Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5511935 -1.8298782
4565 op-snap---monthly-publication-december-2025.pdf   693 2025-12 Car Audi   White Misc - Non Traffic Offences None boldmere road Boldmere Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.548309 -1.8411769
4566 op-snap---monthly-publication-december-2025.pdf   694 2025-12 Car Jaguar epace White Misc - Non Traffic Offences None boldmere road Boldmere Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.548309 -1.8411769
4751 op-snap---monthly-publication-december-2025.pdf   879 2025-12 Car Volkswagen Polo Black Driving without Due Care and Attention None Jockey Road, Jockey Road Sutton Coldfield Sutton Coldfield NFA No VRM   52.5535276 -1.8302584
4756 op-snap---monthly-publication-december-2025.pdf   884 2025-12 Car Mini Cooper Red Contravening a Red Traffic Light None Chester Road / Foley Road Chester Road / Foley Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
4832 op-snap---monthly-publication-december-2025.pdf   960 2025-12 Car BMW 218I Black Contravening a Red Traffic Light None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5872149 -1.8300386
5162 op-snap---monthly-publication-december-2025.pdf   1290 2025-12 Car BMW M3 White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
5163 op-snap---monthly-publication-december-2025.pdf   1291 2025-12 Car Volkswagen Golf Black Driving without Due Care and Attention None Aldridge Road Aldridge Road Sutton Coldfield Sutton Coldfield NFA No Offence      
20591 op-snap---monthly-publication-november-2025.pdf   133 2025-11 Car Volkswagen Golf Black Driving without Due Care and Attention None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5361464 -1.8270283
20833 op-snap---monthly-publication-november-2025.pdf   375 2025-11 Car Yamaha RayZR Red Dangerous Driving None jockey Rd jockey Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5535276 -1.8302584
20981 op-snap---monthly-publication-november-2025.pdf   523 2025-11 Car       Driving without Due Care and Attention None Thimble End Road Thimble End Road Sutton Coldfield Sutton Coldfield NFA No VRM   52.5523209 -1.7936899
21070 op-snap---monthly-publication-november-2025.pdf   612 2025-11 Pedestrian Skoda   Silver Misc - Non Traffic Offences None lichfield road Lichfield Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5872149 -1.8300386
21202 op-snap---monthly-publication-november-2025.pdf   744 2025-11 Pedestrian Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Worcester Close Worcester Close Sutton Coldfield Sutton Coldfield NFA Not in Public Interest   52.5921575 -1.8139344
21530 op-snap---monthly-publication-november-2025.pdf   1072 2025-11 Pedestrian BMW 520D Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None clarence road Clarence Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5940902 -1.843503
21642 op-snap---monthly-publication-november-2025.pdf   1184 2025-11 Pedestrian Volvo xc90 White Misc - Non Traffic Offences None maney hill road Maney Hill Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5498842 -1.8161199
21643 op-snap---monthly-publication-november-2025.pdf   1185 2025-11 Pedestrian Land Rover   Black Misc - Non Traffic Offences None maney hill road Maney Hill Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5498842 -1.8161199
21644 op-snap---monthly-publication-november-2025.pdf   1186 2025-11 Pedestrian Seat leon White Misc - Non Traffic Offences None maney hill road Maney Hill Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5498842 -1.8161199
21879 op-snap---monthly-publication-november-2025.pdf   1421 2025-11 Car Vauxhall Corsa Grey Driving without Due Care and Attention None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5940902 -1.843503
22073 op-snap---monthly-publication-october-2025.pdf   23 2025-10 Car Ford Fiesta Red Contravening a Red Traffic Light None Walmley Ash Walmley Ash Sutton Coldfield Sutton Coldfield NFA No Offence   52.5343587 -1.784782
22157 op-snap---monthly-publication-october-2025.pdf   107 2025-10 Pedal Bike Mazda 3 Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5872149 -1.8300386
22345 op-snap---monthly-publication-october-2025.pdf   295 2025-10 Pedal Bike Hyundai Ioniq White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
22346 op-snap---monthly-publication-october-2025.pdf   296 2025-10 Pedal Bike Peugeot 2008.. Grey Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5359496 -1.8324115
22364 op-snap---monthly-publication-october-2025.pdf   314 2025-10 Car Audi   Grey Driving without Due Care and Attention None Jockey Road Jockey Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5535276 -1.8302584
22366 op-snap---monthly-publication-october-2025.pdf   316 2025-10 Car BMW   Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Goldiesle Road Goldiesle Road Sutton Coldfield Sutton Coldfield NFA No Offence      
22411 op-snap---monthly-publication-october-2025.pdf   361 2025-10 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Little Aston Road / Blake Street Little Aston Road / Blake Street Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available      
22510 op-snap---monthly-publication-october-2025.pdf   460 2025-10 Car Land Rover Vogue Blue Driving without Due Care and Attention None London Road / Gypsy Lane London Road / Gypsy Lane Sutton Coldfield Sutton Coldfield NFA No Offence   52.5746321 -1.7679076
22535 op-snap---monthly-publication-october-2025.pdf   485 2025-10 Pedal Bike Kia Sorento Grey Driving without Due Care and Attention None Maxstoke Road Maxstoke Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.547658 -1.8493169
22687 op-snap---monthly-publication-october-2025.pdf   637 2025-10 Pedal Bike Volkswagen Tiguan White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
22714 op-snap---monthly-publication-october-2025.pdf   664 2025-10 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield NFA No Offence      
22759 op-snap---monthly-publication-october-2025.pdf   709 2025-10 Car Seat Leon Grey Driving without Due Care and Attention None A452 Sutton Coldfield Sutton Coldfield Sutton Coldfield Sutton Coldfield NFA No Offence   52.564801 -1.8251772
22805 op-snap---monthly-publication-october-2025.pdf   755 2025-10 Car Porsche   Black Driving without Due Care and Attention None Camp Road Camp Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.6041476 -1.8111592
22923 op-snap---monthly-publication-october-2025.pdf   873 2025-10 Car Skoda Superb White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Maney Hill Maney Hill Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5544021 -1.8235727
22948 op-snap---monthly-publication-october-2025.pdf   898 2025-10 Car Volkswagen Golf Red Contravening a Red Traffic Light None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5359496 -1.8324115
22973 op-snap---monthly-publication-october-2025.pdf   923 2025-10 Pedal Bike Volkswagen Crafter Silver Driving without Due Care and Attention None Brassington Avenue Brassington Avenue Sutton Coldfield Sutton Coldfield NFA No Offence   52.5637812 -1.823481
23099 op-snap---monthly-publication-october-2025.pdf   1049 2025-10 Car Toyota prius White Driving without Due Care and Attention None Walmey road Walmey road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available      
23296 op-snap---monthly-publication-october-2025.pdf   1246 2025-10 Car Daf   White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lichfield road Lichfield Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5872149 -1.8300386
23779 op-snap---monthly-publication-october-2025.pdf   1729 2025-10 Pedestrian Audi a3 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None chester road Chester Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5359496 -1.8324115
23888 op-snap---monthly-publication-september-2025.pdf   107 2025-09 Car       Driving without Due Care and Attention None Princess Alice Princess Alice Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5499257 -1.859279
24036 op-snap---monthly-publication-september-2025.pdf   255 2025-09 Car Vauxhall corsa Black Contravening a Red Traffic Light None Walmley Road Walmley Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5405351 -1.8002219
24178 op-snap---monthly-publication-september-2025.pdf   397 2025-09 Pedal Bike Vauxhall Vivaro White Using a Mobile Phone Whilst Driving None Chester Road, Stonnall Chester Road, Stonnall Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available      
24251 op-snap---monthly-publication-september-2025.pdf   470 2025-09 Car Ford Focus Blue Driving without Due Care and Attention None Coleshill Road Coleshill Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5613155 -1.8139826
24428 op-snap---monthly-publication-september-2025.pdf   647 2025-09 Car Vauxhall Vivaro White Driving without Due Care and Attention None Blake Street Blake Street Sutton Coldfield Sutton Coldfield NFA No Offence   52.6043776 -1.8446597
25037 op-snap---monthly-publication-september-2025.pdf   1256 2025-09 Pedestrian Audi q2 Black Misc - Non Traffic Offences None station approach Station Approach Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.6036307 -1.8446735
2174 op-snap---monthly-publication-august-2025.pdf   149 2025-08 Car Audi A4 Black Driving without Due Care and Attention None Monmouth Drive Monmouth Drive Sutton Coldfield Sutton Coldfield NFA No Offence   52.5575249 -1.8640053
2315 op-snap---monthly-publication-august-2025.pdf   290 2025-08 Pedal Bike Volvo V60 Silver Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No VRM   52.5359496 -1.8324115
2374 op-snap---monthly-publication-august-2025.pdf   349 2025-08 Other   motorbike black Driving a vehicle wholly or partly on a footpath None Hollingberry Lane Hollingberry Lane Sutton Coldfield Sutton Coldfield NFA No VRM   52.5545601 -1.8009691
2375 op-snap---monthly-publication-august-2025.pdf   350 2025-08 Car Skoda Octavia Grey Driving without Due Care and Attention None Blake Street Blake Street Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.6043776 -1.8446597
2440 op-snap---monthly-publication-august-2025.pdf   415 2025-08 Car BMW 116d Black Contravening a Red Traffic Light None Walmley Ash Road Walmley Ash Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5376726 -1.7973346
2565 op-snap---monthly-publication-august-2025.pdf   540 2025-08 Car Ford S-Max Grey Contravening a Red Traffic Light None Tamworth Road Tamworth Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 DAYS Late Submission   52.5750404 -1.8129485
2826 op-snap---monthly-publication-august-2025.pdf   801 2025-08 Car Audi A3 Grey Driving without Reasonable Consideration None Mere Green Road Mere Green Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5874888 -1.8297106
2833 op-snap---monthly-publication-august-2025.pdf   808 2025-08 Car   Unknown Gold Driving without Due Care and Attention None Tunnel Drive Tunnel Drive Sutton Coldfield Sutton Coldfield NFA No VRM   52.5656403 -1.8231871
2926 op-snap---monthly-publication-august-2025.pdf   901 2025-08 Car   U/K White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5359496 -1.8324115
3025 op-snap---monthly-publication-august-2025.pdf   1000 2025-08 Car Nissan Truck Orange Driving without Due Care and Attention None Green Lanes Green Lanes Sutton Coldfield Sutton Coldfield NFA Outside of 14 DAYS Late Submission   52.5375034 -1.8313115
3030 op-snap---monthly-publication-august-2025.pdf   1005 2025-08 Pedestrian Vauxhall Movano White Driving without Due Care and Attention None Chester Road roundabout Chester Road roundabout Sutton Coldfield Sutton Coldfield NFA Not in Public Interest      
3031 op-snap---monthly-publication-august-2025.pdf   1006 2025-08 Car Alfa Romeo Mito White Contravening a Red Traffic Light None High Street High Street Sutton Coldfield Sutton Coldfield NFA No Offence   52.5669628 -1.8233167
3068 op-snap---monthly-publication-august-2025.pdf   1043 2025-08 Car Volkswagen Polo Black Driving without Due Care and Attention None Victoria Road Victoria Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5615573 -1.820549
3148 op-snap---monthly-publication-august-2025.pdf   1123 2025-08 Car Mercedes-Benz sprinter White Using a Mobile Phone Whilst Driving None Weeford Road Weeford Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.581737 -1.8069637
11976 op-snap---monthly-publication-july-2025.pdf   28 2025-07 Car Volkswagen Golf White Driving without Due Care and Attention None Monmouth Road Monmouth Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5569466 -1.8694159
12044 op-snap---monthly-publication-july-2025.pdf   96 2025-07 Car Volkswagen Caddy White Driving without Due Care and Attention None Thornhill Road, Thornhill Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5690586 -1.8794686
12047 op-snap---monthly-publication-july-2025.pdf   99 2025-07 Car Ford Minibus White Driving without Due Care and Attention None Thornhill Road, Thornhill Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5690586 -1.8794686
12183 op-snap---monthly-publication-july-2025.pdf   235 2025-07 Car Vauxhall Zafira Red Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None A5127 Wylde Gren Wylde Gren Sutton Coldfield Sutton Coldfield NFA No Offence      
12422 op-snap---monthly-publication-july-2025.pdf   474 2025-07 Pedal Bike Mazda 6... Red Driving without Due Care and Attention None Melrose Avenue Melrose Avenue Sutton Coldfield Sutton Coldfield NFA No Offence   52.5511462 -1.8479052
12465 op-snap---monthly-publication-july-2025.pdf   517 2025-07 Car Land Rover Freelander Silver Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5359496 -1.8324115
12483 op-snap---monthly-publication-july-2025.pdf   535 2025-07 Car BMW I4 Grey Driving without Due Care and Attention None Walmley Ash Road Walmley Ash Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 DAYS Late Submission   52.5376726 -1.7973346
12497 op-snap---monthly-publication-july-2025.pdf   549 2025-07 Car Land Rover Range Black Driving without Due Care and Attention None Queslett Road Queslett Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5664077 -1.883903
12568 op-snap---monthly-publication-july-2025.pdf   620 2025-07 Pedal Bike BMW 5 Series Black Driving without Reasonable Consideration None Redcap Heath Road Red Cap Heath Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP      
12643 op-snap---monthly-publication-july-2025.pdf   695 2025-07 Car Skoda Octavia White Contravening a Red Traffic Light None A38 (Minworth Island) A38 (Minworth Island) Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.530527 -1.7748252
12803 op-snap---monthly-publication-july-2025.pdf   855 2025-07 Car Renault Truck Orange Driving without Due Care and Attention None Green Lanes Green Lanes Sutton Coldfield Sutton Coldfield NFA No Offence   52.5375034 -1.8313115
12916 op-snap---monthly-publication-july-2025.pdf   968 2025-07 Car Land Rover Discovery Red Driving without Reasonable Consideration None Melrose Avenue , Sutton Melrose Avenue , Sutton Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5511462 -1.8479052
12951 op-snap---monthly-publication-july-2025.pdf   1003 2025-07 Pedal Bike Mercedes-Benz E220 Grey Driving without Due Care and Attention None Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP      
13479 op-snap---monthly-publication-july-2025.pdf   1531 2025-07 Pedestrian Mercedes-Benz CLC Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Coleshill Street Coleshill Street Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5645717 -1.8214603
13480 op-snap---monthly-publication-july-2025.pdf   1532 2025-07 Pedestrian Renault Megane White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Coleshill Street Coleshill Street Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5645717 -1.8214603
14267 op-snap---monthly-publication-june-2025.pdf   196 2025-06 Pedestrian Alfa Romeo Mito Blue Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Upper Holland Rd Upper Holland Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.561 -1.8187105
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
14589 op-snap---monthly-publication-june-2025.pdf   518 2025-06 Car Toyota   Silver Misc - Non Traffic Offences None Rosemary Hill Road Rosemary Hill Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5918569 -1.8630817
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
14930 op-snap---monthly-publication-june-2025.pdf   859 2025-06 Car Seat Leon White Contravening a Red Traffic Light None Brassington Ave Brassington Ave Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5637812 -1.823481
14945 op-snap---monthly-publication-june-2025.pdf   874 2025-06 Car Yamaha   Black Use a motor vehicle / trailer in a condition likely to cause danger of injury None Lichfield Road towards Canwell Lichfield Road towards Canwell Sutton Coldfield Sutton Coldfield NFA Outside of 14 DAYS Late Submission      
14979 op-snap---monthly-publication-june-2025.pdf   908 2025-06 Pedestrian Honda Civic Blue Misc - Non Traffic Offences None Bedford Road Bedford Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5751987 -1.8081729
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
15103 op-snap---monthly-publication-june-2025.pdf   1032 2025-06 Car Vauxhall corsa Blue Driving without Due Care and Attention None B4148 B4148 Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5529805 -1.7983733
15167 op-snap---monthly-publication-june-2025.pdf   1096 2025-06 Car Volkswagen Fox Black Driving without Due Care and Attention None Fox Hollie Road Fox Hollie Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes      
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
15396 op-snap---monthly-publication-june-2025.pdf   1325 2025-06 Pedestrian Toyota RAV4 Grey Misc - Non Traffic Offences None Berwood Road Berwood Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5342947 -1.8155375
15401 op-snap---monthly-publication-june-2025.pdf   1330 2025-06 Pedestrian BMW X3 White Misc - Non Traffic Offences None Berwood Road Berwood Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5342947 -1.8155375
15466 op-snap---monthly-publication-june-2025.pdf   1395 2025-06 Car Lexus UX250 Black Contravening a Red Traffic Light None Monmouth Drive Monmouth Drive Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5575249 -1.8640053
15492 op-snap---monthly-publication-june-2025.pdf   1421 2025-06 Pedestrian Peugeot 208 White Contravening a Red Traffic Light None Chester Road North Chester Road North Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.548449 -1.8594603
15766 op-snap---monthly-publication-june-2025.pdf   1695 2025-06 Car Nissan Qashqai Blue Cause vehicle to be left in a dangerous position None Sutton Road Sutton Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 DAYS Late Submission   52.5346721 -1.827743
15781 op-snap---monthly-publication-june-2025.pdf   1710 2025-06 Pedestrian Mg HS Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cotysmore Road Cotysmore Road Sutton Coldfield Sutton Coldfield NFA Not in Public Interest   52.5712977 -1.8098984
15811 op-snap---monthly-publication-june-2025.pdf   1740 2025-06 Car Mercedes-Benz EQA 250 Grey Cause vehicle to be left in a dangerous position None Little Sutton Lane Little Sutton Lane Sutton Coldfield Sutton Coldfield NFA Outside of 14 DAYS Late Submission   52.584913 -1.8197066

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