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

368 rows where disposal = "NFA", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedal Bike" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make >30

  • Ford 43
  • Mercedes-Benz 31
  • BMW 29
  • Vauxhall 29
  • Volkswagen 21
  • Toyota 20
  • Audi 19
  • Nissan 12
  • Renault 12
  • Citroen 10
  • Land Rover 10
  • Peugeot 10
  • Seat 9
  • Honda 8
  • Mini 8
  • Kia 7
  • Fiat 6
  • Hyundai 6
  • Skoda 6
  • Mazda 5
  • Mitsubishi 5
  • Volvo 5
  • Daf 4
  • Mg 4
  • Suzuki 4
  • Jaguar 3
  • Byd 2
  • Dacia 2
  • Lexus 2
  • Porsche 2
  • …

month 14

  • 2025-07 63
  • 2025-05 56
  • 2025-06 46
  • 2025-10 44
  • 2025-04 36
  • 2025-08 23
  • 2025-09 20
  • 2025-11 17
  • 2025-12 17
  • 2026-02 16
  • 2026-01 13
  • 2025-03 9
  • 2025-01 6
  • 2025-02 2

council_area 12

  • Birmingham 172
  • Out of Force Area 68
  • Coventry 45
  • Solihull 29
  • Sutton Coldfield 17
  • Walsall 13
  • Dudley 9
  • Wolverhampton 6
  • Sandwell 5
  • Area 2
  • Halesowen 1
  • Metropolitan Borough Of Dudley 1

reporter_transport_mode 1

  • Pedal Bike · 368 ✖

offence 1

  • Driving without Due Care and Attention · 368 ✖

disposal 1

  • NFA · 368 ✖
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
7275 op-snap---monthly-publication-february-2026.pdf   22 2026-02 Pedal Bike Audi   Silver Driving without Due Care and Attention None B4101 Spring Lane Spring Lane Out of Force Area Out of Force Area NFA Out of Force      
7482 op-snap---monthly-publication-february-2026.pdf   229 2026-02 Pedal Bike Citroen C8 Blue Driving without Due Care and Attention None Ashwood Road (Worcs) Ashwood Road (Worcs) Out of Force Area Out of Force Area NFA Out of Force      
7632 op-snap---monthly-publication-february-2026.pdf   379 2026-02 Pedal Bike Seat Leon Silver Driving without Due Care and Attention None Woodstock Road Woodstock Road Coventry Coventry NFA No Independent Evidence Available   52.3919059 -1.5026146
7785 op-snap---monthly-publication-february-2026.pdf   532 2026-02 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None High Street, Hampton in Arden High Street, Hampton in Arden Solihull Solihull NFA No Offence   52.4291828 -1.7000245
7831 op-snap---monthly-publication-february-2026.pdf   578 2026-02 Pedal Bike Daf   White Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA No Offence   52.4103629 -1.5441218
8056 op-snap---monthly-publication-february-2026.pdf   803 2026-02 Pedal Bike Vauxhall Vivaro White Driving without Due Care and Attention None Brinklow Road Brinklow Road Coventry Coventry NFA Outside of 14 Days NIP   52.4028059 -1.4461048
8270 op-snap---monthly-publication-february-2026.pdf   1017 2026-02 Pedal Bike Mazda CX5 Black Driving without Due Care and Attention None Off force Off force Out of Force Area Out of Force Area NFA Out of Force      
8318 op-snap---monthly-publication-february-2026.pdf   1065 2026-02 Pedal Bike Fiat 500 White Driving without Due Care and Attention None Meriden Road Meriden Road Solihull Solihull NFA No Offence   52.4137518 -1.6414448
8383 op-snap---monthly-publication-february-2026.pdf   1130 2026-02 Pedal Bike Volkswagen Beetle Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull NFA No Offence   52.4223176 -1.8253145
8521 op-snap---monthly-publication-february-2026.pdf   1268 2026-02 Pedal Bike Mercedes-Benz Smart Fortwo Blue Driving without Due Care and Attention None Streetbrook Road Streetbrook Road Solihull Solihull NFA Outside of 14 Days NIP      
8528 op-snap---monthly-publication-february-2026.pdf   1275 2026-02 Pedal Bike Ford Ranger White Driving without Due Care and Attention None Lower Street Lower Street Wolverhampton Wolverhampton NFA     52.6017311 -2.1598475
8570 op-snap---monthly-publication-february-2026.pdf   1317 2026-02 Pedal Bike       Driving without Due Care and Attention None George Road towards Brookvale Road George Road towards Brookvale Road Birmingham Birmingham NFA No VRM      
8616 op-snap---monthly-publication-february-2026.pdf   1363 2026-02 Pedal Bike Toyota Van Grey Driving without Due Care and Attention None California Way California Way Birmingham Birmingham NFA No Offence   52.4454714 -1.9753804
8655 op-snap---monthly-publication-february-2026.pdf   1402 2026-02 Pedal Bike Volkswagen Polo Black Driving without Due Care and Attention None Valley Road Valley Road Out of Force Area Out of Force Area NFA Out of Force   52.4501305 -1.7742157
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      
8821 op-snap---monthly-publication-february-2026.pdf   1568 2026-02 Pedal Bike Honda NSC White Driving without Due Care and Attention None Yew Tree Lane Yew Tree Lane Birmingham Birmingham NFA No Offence   52.4631 -1.8082055
10607 op-snap---monthly-publication-january-2026.pdf   68 2026-01 Pedal Bike Vauxhall Insignia White Driving without Due Care and Attention None Lower Broad Heath (worcester) Lower Broad Heath (worcester) Out of Force Area Out of Force Area NFA Out of Force      
10825 op-snap---monthly-publication-january-2026.pdf   286 2026-01 Pedal Bike Mercedes-Benz Sprinter Red Driving without Due Care and Attention None Quinton Island Quinton Island Birmingham Birmingham NFA No Independent Evidence Available   52.4617515 -2.0079008
11098 op-snap---monthly-publication-january-2026.pdf   559 2026-01 Pedal Bike Toyota Avensis Silver Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry NFA Not in Public Interest   52.4073149 -1.5250454
11194 op-snap---monthly-publication-january-2026.pdf   655 2026-01 Pedal Bike BMW 428i Blue Driving without Due Care and Attention None Fosse Way, Warwick Fosse Way, Warwick Out of Force Area Out of Force Area NFA Out of Force      
11213 op-snap---monthly-publication-january-2026.pdf   674 2026-01 Pedal Bike Mg hatchback White Driving without Due Care and Attention None Lickey Road Lickey Road Birmingham Birmingham NFA No Independent Evidence Available   52.3868298 -2.0003781
11286 op-snap---monthly-publication-january-2026.pdf   747 2026-01 Pedal Bike Volvo XC40 Black Driving without Due Care and Attention None Augustus Road Augustus Road Birmingham Birmingham NFA No Offence   52.4695793 -1.9378608
11356 op-snap---monthly-publication-january-2026.pdf   817 2026-01 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Wenlock Road, Shrewsbury Wenlock Road, Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
11432 op-snap---monthly-publication-january-2026.pdf   893 2026-01 Pedal Bike Honda Civic Grey Driving without Due Care and Attention None Belford Road Belford Road Out of Force Area Out of Force Area NFA Out of Force      
11507 op-snap---monthly-publication-january-2026.pdf   968 2026-01 Pedal Bike Volkswagen Golf Red Driving without Due Care and Attention None Norton Road Norton Road Dudley Dudley NFA No Offence   52.4483733 -2.1546673
11627 op-snap---monthly-publication-january-2026.pdf   1088 2026-01 Pedal Bike Nissan Juke Blue Driving without Due Care and Attention None Maynard Avenue Maynard Avenue Dudley Dudley NFA No Offence   52.4464709 -2.1663682
11844 op-snap---monthly-publication-january-2026.pdf   1305 2026-01 Pedal Bike Audi   White Driving without Due Care and Attention None Albany Road Albany Road Birmingham Birmingham NFA No VRM   52.4591259 -1.9506139
11937 op-snap---monthly-publication-january-2026.pdf   1398 2026-01 Pedal Bike Peugeot 2008 White Driving without Due Care and Attention None Burlton, Shropshire Burlton, Shropshire Out of Force Area Out of Force Area NFA Out of Force      
11939 op-snap---monthly-publication-january-2026.pdf   1400 2026-01 Pedal Bike Audi   White Driving without Due Care and Attention None off force Off Force Out of Force Area Out of Force Area NFA Out of Force      
3910 op-snap---monthly-publication-december-2025.pdf   38 2025-12 Pedal Bike Kia   Blue Driving without Due Care and Attention None Woodville Road Woodville Road Birmingham Birmingham NFA No Offence   52.4616763 -1.9653016
3994 op-snap---monthly-publication-december-2025.pdf   122 2025-12 Pedal Bike Kia Sportage Blue Driving without Due Care and Attention None Cressage Cressage Out of Force Area Out of Force Area NFA Out of Force   52.40435 -1.9677367
3995 op-snap---monthly-publication-december-2025.pdf   123 2025-12 Pedal Bike Volkswagen   Red Driving without Due Care and Attention None Atcham Atcham Out of Force Area Out of Force Area NFA Out of Force      
4079 op-snap---monthly-publication-december-2025.pdf   207 2025-12 Pedal Bike Toyota Rav4 Black Driving without Due Care and Attention None Spiceland Road Northfield Spiceland Road Northfield Birmingham Birmingham NFA No Independent Evidence Available   52.4243001 -1.9747504
4080 op-snap---monthly-publication-december-2025.pdf   208 2025-12 Pedal Bike BMW   White Driving without Due Care and Attention None B5063 West Mercia West Mercia Out of Force Area Out of Force Area NFA Out of Force   52.5827653 -2.0983246
4082 op-snap---monthly-publication-december-2025.pdf   210 2025-12 Pedal Bike BMW   White Driving without Due Care and Attention None B5063 West Mercia West Mercia Out of Force Area Out of Force Area NFA Duplicate Submission   52.5827653 -2.0983246
4117 op-snap---monthly-publication-december-2025.pdf   245 2025-12 Pedal Bike Volkswagen Touran Black Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham NFA No Independent Evidence Available   52.4422505 -1.8539684
4311 op-snap---monthly-publication-december-2025.pdf   439 2025-12 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Hereford Road Shrewsbury Hereford Road Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
4378 op-snap---monthly-publication-december-2025.pdf   506 2025-12 Pedal Bike   U/K White Driving without Due Care and Attention None Belgrave Road Belgrave Road Coventry Coventry NFA No Independent Evidence Available   52.4141017 -1.4571973
4379 op-snap---monthly-publication-december-2025.pdf   507 2025-12 Pedal Bike Volkswagen Polo Black Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Offence   52.5113867 -1.8337258
4388 op-snap---monthly-publication-december-2025.pdf   516 2025-12 Pedal Bike Nissan Juke Black Driving without Due Care and Attention None Corners End Lane Corners End Lane Solihull Solihull NFA No Offence      
4413 op-snap---monthly-publication-december-2025.pdf   541 2025-12 Pedal Bike Audi A5 Grey Driving without Due Care and Attention None Frankly Beeches Road Frankly Beeches Road Birmingham Birmingham NFA No Offence      
4414 op-snap---monthly-publication-december-2025.pdf   542 2025-12 Pedal Bike Audi A4.. Black Driving without Due Care and Attention None Church Road Northfield Church Road Northfield Birmingham Birmingham NFA No Offence   52.4143428 -1.966939
4533 op-snap---monthly-publication-december-2025.pdf   661 2025-12 Pedal Bike Toyota Yaris Grey Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull NFA No Offence   52.4190728 -1.7449943
4586 op-snap---monthly-publication-december-2025.pdf   714 2025-12 Pedal Bike Ford Focus Blue Driving without Due Care and Attention None Waste Lane, Balsall Common Waste Lane, Balsall Common Coventry Coventry NFA No Offence      
4810 op-snap---monthly-publication-december-2025.pdf   938 2025-12 Pedal Bike Mercedes-Benz C180 Silver Driving without Due Care and Attention None Moseley road Moseley road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4679402 -1.881408
4964 op-snap---monthly-publication-december-2025.pdf   1092 2025-12 Pedal Bike Citroen C3 Grey Driving without Due Care and Attention None Watford Road Watford Road Birmingham Birmingham NFA No Offence   52.4182952 -1.9316395
20492 op-snap---monthly-publication-november-2025.pdf   34 2025-11 Pedal Bike Byd Bus Grey Driving without Due Care and Attention None Hale Street Hale Street Coventry Coventry NFA No Offence      
20520 op-snap---monthly-publication-november-2025.pdf   62 2025-11 Pedal Bike Jaguar XF Black Driving without Due Care and Attention No Insurance Stretton Sugwas (Hereford) Stretton Sugwas (Hereford) Out of Force Area Out of Force Area NFA Out of Force      
20722 op-snap---monthly-publication-november-2025.pdf   264 2025-11 Pedal Bike Mg HS Red Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Solihull Solihull NFA No Independent Evidence Available   52.4322443 -1.6746508
20724 op-snap---monthly-publication-november-2025.pdf   266 2025-11 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Blackhalve Lane Blackhalve Lane Out of Force Area Out of Force Area NFA Out of Force   52.6139368 -2.0960778
20725 op-snap---monthly-publication-november-2025.pdf   267 2025-11 Pedal Bike Dacia Sandero Blue Driving without Due Care and Attention None Teddesley Road (Staffs) Teddesley Road (Staffs) Out of Force Area Out of Force Area NFA Out of Force      
20968 op-snap---monthly-publication-november-2025.pdf   510 2025-11 Pedal Bike Mini One White Driving without Due Care and Attention None Ledbury, West Mercia Ledbury, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
21298 op-snap---monthly-publication-november-2025.pdf   840 2025-11 Pedal Bike Peugeot 2008 Grey Driving without Due Care and Attention None Rochester Road Rochester Road Coventry Coventry NFA No Offence   52.3974085 -1.5422796
21388 op-snap---monthly-publication-november-2025.pdf   930 2025-11 Pedal Bike Byd Temsa Coach White Driving without Due Care and Attention None Lawrence Sanders Road Lawrence Sanders Road Coventry Coventry NFA No Offence      
21414 op-snap---monthly-publication-november-2025.pdf   956 2025-11 Pedal Bike Ford Transit White Driving without Due Care and Attention None Witton Road Witton Road Birmingham Birmingham NFA No Independent Evidence Available   52.513336 -1.8833226
21568 op-snap---monthly-publication-november-2025.pdf   1110 2025-11 Pedal Bike Seat Leon White Driving without Due Care and Attention None Frederick Street Frederick Street Birmingham Birmingham NFA No Offence   52.4863384 -1.9123011
21575 op-snap---monthly-publication-november-2025.pdf   1117 2025-11 Pedal Bike Volkswagen   Grey Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA Not in Public Interest   52.4103629 -1.5441218
21669 op-snap---monthly-publication-november-2025.pdf   1211 2025-11 Pedal Bike Honda Civic White Driving without Due Care and Attention None B4100 Banbury Road, Ashbourne Hill, Warwick Banbury Road, Ashbourne Hill, Warwick Out of Force Area Out of Force Area NFA Out of Force      
21684 op-snap---monthly-publication-november-2025.pdf   1226 2025-11 Pedal Bike Vauxhall Corsa Yellow Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham NFA No Offence   52.4390303 -1.9512931
21829 op-snap---monthly-publication-november-2025.pdf   1371 2025-11 Pedal Bike BMW X1 Grey Driving without Due Care and Attention None Upper Astrop Road, Astrop Upper Astrop Road, Astrop Out of Force Area Out of Force Area NFA Out of Force      
21835 op-snap---monthly-publication-november-2025.pdf   1377 2025-11 Pedal Bike Honda   Silver Driving without Due Care and Attention None Stourport Road Stourport Road Out of Force Area Out of Force Area NFA Out of Force      
21960 op-snap---monthly-publication-november-2025.pdf   1502 2025-11 Pedal Bike Lexus   White Driving without Due Care and Attention None Sir Herbert Austin Way Sir Herbert Austin Way Birmingham Birmingham NFA No VRM   52.4132666 -1.9735631
21967 op-snap---monthly-publication-november-2025.pdf   1509 2025-11 Pedal Bike   Levc White Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA No Offence   52.4103629 -1.5441218
22102 op-snap---monthly-publication-october-2025.pdf   52 2025-10 Pedal Bike BMW 435.. Black Driving without Due Care and Attention None Allesley Road Allesley Road Coventry Coventry NFA Outside of 14 Days NIP   52.412663 -1.5443742
22122 op-snap---monthly-publication-october-2025.pdf   72 2025-10 Pedal Bike Skoda Octavia Silver Driving without Due Care and Attention None Hurst Road Hurst Road Coventry Coventry NFA No Offence   52.4496884 -1.4816181
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
22195 op-snap---monthly-publication-october-2025.pdf   145 2025-10 Pedal Bike Dennis Alexander White Driving without Due Care and Attention None Sharmans Cross Sharmans Cross Solihull Solihull NFA Outside of 14 Days NIP   52.4151594 -1.8062462
22196 op-snap---monthly-publication-october-2025.pdf   146 2025-10 Pedal Bike Renault Modus Silver Driving without Due Care and Attention None Stroud Road Stroud Road Solihull Solihull NFA Outside of 14 Days NIP   52.4085712 -1.8432138
22204 op-snap---monthly-publication-october-2025.pdf   154 2025-10 Pedal Bike   Bus Grey Driving without Due Care and Attention None White Street White Street Birmingham Birmingham NFA No VRM   52.4555554 -1.8782841
22271 op-snap---monthly-publication-october-2025.pdf   221 2025-10 Pedal Bike Daf Lorry white Driving without Due Care and Attention None Broad Lane, Coventry Broad Lane, Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4144409 -1.5990259
22285 op-snap---monthly-publication-october-2025.pdf   235 2025-10 Pedal Bike Lexus ES300 Black Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.5020639 -1.9026192
22295 op-snap---monthly-publication-october-2025.pdf   245 2025-10 Pedal Bike Hyundai I20 Black Driving without Due Care and Attention None Brookvale Road Brookvale Road Birmingham Birmingham NFA No VRM   52.5219365 -1.8755325
22328 op-snap---monthly-publication-october-2025.pdf   278 2025-10 Pedal Bike Toyota   Black Driving without Due Care and Attention None 6 Ways 6 Ways Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4728311 -1.9185712
22336 op-snap---monthly-publication-october-2025.pdf   286 2025-10 Pedal Bike   Bus White Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull NFA No Offence   52.4144779 -1.7848758
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
22373 op-snap---monthly-publication-october-2025.pdf   323 2025-10 Pedal Bike BMW M340 Grey Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
22385 op-snap---monthly-publication-october-2025.pdf   335 2025-10 Pedal Bike Kia Picanto Blue Driving without Due Care and Attention None Boleyn Road, Rubery Boleyn Road, Rubery Birmingham Birmingham NFA No Offence      
22386 op-snap---monthly-publication-october-2025.pdf   336 2025-10 Pedal Bike   Wrightbus Blue Driving without Due Care and Attention None Gannow Green Lane Gannow Green Lane Birmingham Birmingham NFA No Offence   52.4023845 -2.0336492
22430 op-snap---monthly-publication-october-2025.pdf   380 2025-10 Pedal Bike Audi Q2 Grey Driving without Due Care and Attention None Wychwood Avenue Wychwood Avenue Solihull Solihull NFA No Independent Evidence Available   52.3973125 -1.7370127
22437 op-snap---monthly-publication-october-2025.pdf   387 2025-10 Pedal Bike Renault Master White Driving without Due Care and Attention None Wood Lane, Lower Stonnall Wood Lane, Lower Stonnall Out of Force Area Out of Force Area NFA Out of Force      
22444 op-snap---monthly-publication-october-2025.pdf   394 2025-10 Pedal Bike BMW 320d Silver Driving without Due Care and Attention None Coventry Road, Tamworth Coventry Road, Tamworth Out of Force Area Out of Force Area NFA Out of Force      
22449 op-snap---monthly-publication-october-2025.pdf   399 2025-10 Pedal Bike Renault Clio White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry NFA No Offence   52.4047134 -1.5351834
22519 op-snap---monthly-publication-october-2025.pdf   469 2025-10 Pedal Bike Seat Arona Silver Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
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
22546 op-snap---monthly-publication-october-2025.pdf   496 2025-10 Pedal Bike Mercedes-Benz C220 Grey Driving without Due Care and Attention None Hales Street / White Street Hales Street / White Street Coventry Coventry NFA No Offence   52.4107158 -1.5078486
22606 op-snap---monthly-publication-october-2025.pdf   556 2025-10 Pedal Bike Ford Transit White Driving without Due Care and Attention None Wrentham Street Wrentham Street Birmingham Birmingham NFA No VRM   52.4708757 -1.8966158
22607 op-snap---monthly-publication-october-2025.pdf   557 2025-10 Pedal Bike Skoda   Grey Driving without Due Care and Attention None Alwold Road Alwold Road Birmingham Birmingham NFA No Independent Evidence Available   52.4436471 -1.9604594
22621 op-snap---monthly-publication-october-2025.pdf   571 2025-10 Pedal Bike Mercedes-Benz A35 Black Driving without Due Care and Attention None Shorncliffe Road Shorncliffe Road Coventry Coventry NFA Outside of 14 Days NIP   52.4243896 -1.5433694
22622 op-snap---monthly-publication-october-2025.pdf   572 2025-10 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Shorncliffe Road Shorncliffe Road Coventry Coventry NFA Outside of 14 Days NIP   52.4243896 -1.5433694
22645 op-snap---monthly-publication-october-2025.pdf   595 2025-10 Pedal Bike Renault Trafic Yellow Driving without Due Care and Attention None Main Road, Lower Quinton, near Stratford Main Road, Lower Quinton, near Stratford Out of Force Area Out of Force Area NFA Out of Force      
22654 op-snap---monthly-publication-october-2025.pdf   604 2025-10 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Bakers Lane Bakers Lane Birmingham Birmingham NFA No Offence   52.5632567 -1.8782299
22655 op-snap---monthly-publication-october-2025.pdf   605 2025-10 Pedal Bike Ford Transit White Driving without Due Care and Attention None Chester Road A452 Chester Road A452 Birmingham Birmingham NFA No Offence   52.5338529 -1.8296813
22668 op-snap---monthly-publication-october-2025.pdf   618 2025-10 Pedal Bike Skoda Octavia Black Driving without Due Care and Attention None St Agnes Road Street Agnes Road Birmingham Birmingham NFA No Independent Evidence Available      
22674 op-snap---monthly-publication-october-2025.pdf   624 2025-10 Pedal Bike Land Rover Land Rover Black Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham NFA No Offence   52.4103191 -1.8670224
22677 op-snap---monthly-publication-october-2025.pdf   627 2025-10 Pedal Bike Nissan Qashqai Grey Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham NFA No Offence   52.4103191 -1.8670224
22682 op-snap---monthly-publication-october-2025.pdf   632 2025-10 Pedal Bike Renault Capture Grey Driving without Due Care and Attention None Easemore Road Redditch Easemore Road Redditch Out of Force Area Out of Force Area NFA Out of Force      
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      
22897 op-snap---monthly-publication-october-2025.pdf   847 2025-10 Pedal Bike BMW X5 Blue Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Independent Evidence Available   52.5113867 -1.8337258

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