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

312 rows where disposal = "NFA", offence = "Using a Mobile Phone Whilst Driving" and reporter_transport_mode = "Car" 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, witness_contacted

vehicle_make >30

  • Ford 42
  • Mercedes-Benz 33
  • Volkswagen 26
  • BMW 22
  • Vauxhall 18
  • Toyota 16
  • Audi 15
  • Peugeot 15
  • Renault 14
  • Land Rover 13
  • Nissan 10
  • Honda 9
  • Seat 6
  • Citroen 5
  • Fiat 5
  • Hyundai 5
  • Volvo 5
  • Daf 4
  • Kia 4
  • Skoda 4
  • Man 3
  • Mitsubishi 3
  • Suzuki 3
  • Alfa Romeo 2
  • Mini 2
  • Tesla 2
  • Chevrolet 1
  • Iveco 1
  • Jaguar 1
  • Jeep 1
  • …

month 14

  • 2025-08 39
  • 2025-07 30
  • 2025-09 30
  • 2025-10 29
  • 2025-11 27
  • 2025-12 26
  • 2025-06 25
  • 2026-01 24
  • 2025-04 23
  • 2026-02 23
  • 2025-05 16
  • 2025-03 8
  • 2025-01 7
  • 2025-02 5

council_area 10

  • Out of Force Area 127
  • Birmingham 83
  • Sandwell 22
  • Coventry 19
  • Walsall 18
  • Dudley 15
  • Solihull 10
  • Wolverhampton 10
  • Sutton Coldfield 3
  • Out Of Force Area 1

reporter_transport_mode 1

  • Car · 312 ✖

offence 1

  • Using a Mobile Phone Whilst Driving · 312 ✖

disposal 1

  • NFA · 312 ✖
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
7314 op-snap---monthly-publication-february-2026.pdf   61 2026-02 Car Kia Ceed Silver Using a Mobile Phone Whilst Driving None Moorfield Road Moorfield Road Out of Force Area Out of Force Area NFA Out of Force   52.4981538 -1.7875516
7352 op-snap---monthly-publication-february-2026.pdf   99 2026-02 Car Volkswagen Tiguan White Using a Mobile Phone Whilst Driving None M621 (Greater Manchester) M621 (Greater Manchester) Out of Force Area Out of Force Area NFA Out of Force      
7456 op-snap---monthly-publication-february-2026.pdf   203 2026-02 Car Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None Rugy Road Rugby Rugy Road Rugby Out of Force Area Out of Force Area NFA Out of Force      
7524 op-snap---monthly-publication-february-2026.pdf   271 2026-02 Car Audi A4 Black Using a Mobile Phone Whilst Driving None Tesco Petrol Station, Stone Cross Tesco Petrol Station, Stone Cross Sandwell Sandwell NFA No Independent Evidence Available      
7639 op-snap---monthly-publication-february-2026.pdf   386 2026-02 Car Ford Transit Black Using a Mobile Phone Whilst Driving None A529 Hinstock Hinstock Out of Force Area Out of Force Area NFA Out of Force      
7829 op-snap---monthly-publication-february-2026.pdf   576 2026-02 Car Peugeot 308.. Grey Using a Mobile Phone Whilst Driving None Cato Street Cato Street Birmingham Birmingham NFA No Independent Evidence Available   52.4904718 -1.8693759
7860 op-snap---monthly-publication-february-2026.pdf   607 2026-02 Car Land Rover Range White Using a Mobile Phone Whilst Driving None A19 A19 Out of Force Area Out of Force Area NFA Out of Force      
8108 op-snap---monthly-publication-february-2026.pdf   855 2026-02 Car Vauxhall Astra Blue Using a Mobile Phone Whilst Driving None Wyrley Brook Retail Park Wyrley Brook Retail Park Out of Force Area Out of Force Area NFA Out of Force      
8199 op-snap---monthly-publication-february-2026.pdf   946 2026-02 Car   Van White Using a Mobile Phone Whilst Driving None Desford Road Desford Road Out of Force Area Out of Force Area NFA Out of Force      
8249 op-snap---monthly-publication-february-2026.pdf   996 2026-02 Car BMW 120 Sport White Using a Mobile Phone Whilst Driving None Scimitar Way Scimitar Way Coventry Coventry NFA No Independent Evidence Available   52.3836203 -1.4862458
8274 op-snap---monthly-publication-february-2026.pdf   1021 2026-02 Car Alfa Romeo Romeo Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham NFA No Independent Evidence Available   52.4470686 -1.8880749
8361 op-snap---monthly-publication-february-2026.pdf   1108 2026-02 Car Nissan note Red Using a Mobile Phone Whilst Driving None A460 four ashes A460 four ashes Out of Force Area Out of Force Area NFA Out of Force   52.3828826 -1.7624844
8381 op-snap---monthly-publication-february-2026.pdf   1128 2026-02 Car Volkswagen Polo Blue Using a Mobile Phone Whilst Driving None A5 Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
8415 op-snap---monthly-publication-february-2026.pdf   1162 2026-02 Car Mercedes-Benz sprinter White Using a Mobile Phone Whilst Driving None M42 J3 M42 J3 Out of Force Area Out of Force Area NFA Out of Force   52.4846642 -1.9297585
8438 op-snap---monthly-publication-february-2026.pdf   1185 2026-02 Car Fiat 500 Green Using a Mobile Phone Whilst Driving None Dudley Road East Dudley Road East Birmingham Birmingham NFA No Offence      
8458 op-snap---monthly-publication-february-2026.pdf   1205 2026-02 Car BMW 5 series White Using a Mobile Phone Whilst Driving None Kidderminster Road Kidderminster Road Dudley Dudley NFA No Independent Evidence Available   52.5000055 -2.1844503
8467 op-snap---monthly-publication-february-2026.pdf   1214 2026-02 Car Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Wollescote Road Wollescote Road Dudley Dudley NFA No Independent Evidence Available   52.4471527 -2.1236271
8472 op-snap---monthly-publication-february-2026.pdf   1219 2026-02 Car BMW 3 series Black Using a Mobile Phone Whilst Driving None M4 M4 Out of Force Area Out of Force Area NFA Out of Force      
8545 op-snap---monthly-publication-february-2026.pdf   1292 2026-02 Car Kia   Red Using a Mobile Phone Whilst Driving None Burton Upon Trent Burton Upon Trent Out of Force Area Out of Force Area NFA Out of Force      
8582 op-snap---monthly-publication-february-2026.pdf   1329 2026-02 Car Skoda Fabia Blue Using a Mobile Phone Whilst Driving None Town Walls, Shrewbury Town Walls, Shrewbury Out of Force Area Out of Force Area NFA Out of Force      
8588 op-snap---monthly-publication-february-2026.pdf   1335 2026-02 Car Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None M6 J18-19 M6 J18-19 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
8660 op-snap---monthly-publication-february-2026.pdf   1407 2026-02 Car Land Rover Evoque White Using a Mobile Phone Whilst Driving None Shard End Crescent Shard End Crescent Birmingham Birmingham NFA No Independent Evidence Available   52.4927744 -1.7781391
8666 op-snap---monthly-publication-february-2026.pdf   1413 2026-02 Car Ford   White Using a Mobile Phone Whilst Driving None IIminster Road IIminster Road Out of Force Area Out of Force Area NFA Out of Force      
10548 op-snap---monthly-publication-january-2026.pdf   9 2026-01 Car Mercedes-Benz A200 Black Using a Mobile Phone Whilst Driving None Binley Road Binley Road Coventry Coventry NFA No Independent Evidence Available   52.4070602 -1.4732469
10573 op-snap---monthly-publication-january-2026.pdf   34 2026-01 Car Land Rover Discovery Grey Using a Mobile Phone Whilst Driving None A48 Gloucester Gloucester Out of Force Area Out of Force Area NFA Out of Force   52.405214 -1.9708282
10610 op-snap---monthly-publication-january-2026.pdf   71 2026-01 Car Toyota Corolla Grey Using a Mobile Phone Whilst Driving None Stourbridge Road Wombourne Stourbridge Road Wombourne Out of Force Area Out of Force Area NFA Out of Force      
10739 op-snap---monthly-publication-january-2026.pdf   200 2026-01 Car Ford Fiesta Red Using a Mobile Phone Whilst Driving None Boardsley Middleway Boardsley Middleway Birmingham Birmingham NFA No VRM      
10740 op-snap---monthly-publication-january-2026.pdf   201 2026-01 Car Ford Ka White Using a Mobile Phone Whilst Driving None B4215 Ross on Wye Ross on Wye Out of Force Area Out of Force Area NFA Out of Force      
10777 op-snap---monthly-publication-january-2026.pdf   238 2026-01 Car Chevrolet Cruz Black Using a Mobile Phone Whilst Driving None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Independent Evidence Available   52.5113867 -1.8337258
10848 op-snap---monthly-publication-january-2026.pdf   309 2026-01 Car Ford Fiesta Red Using a Mobile Phone Whilst Driving None Warwick Warwick Out of Force Area Out of Force Area NFA Out of Force   52.3813073 -1.5639569
10905 op-snap---monthly-publication-january-2026.pdf   366 2026-01 Car BMW 6 Series Black Using a Mobile Phone Whilst Driving None M6 J14 M6 J14 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
11061 op-snap---monthly-publication-january-2026.pdf   522 2026-01 Car Nissan Juke Silver Using a Mobile Phone Whilst Driving None M1 J15 Northhampton M1 J15 Northhampton Out of Force Area Out of Force Area NFA Out of Force      
11082 op-snap---monthly-publication-january-2026.pdf   543 2026-01 Car Honda   Red Using a Mobile Phone Whilst Driving None M60 M60 Out of Force Area Out of Force Area NFA Out of Force      
11276 op-snap---monthly-publication-january-2026.pdf   737 2026-01 Car Ford Fiesta Black Using a Mobile Phone Whilst Driving None Regent Place Regent Place Birmingham Birmingham NFA Not in Public Interest   52.4860376 -1.9095854
11316 op-snap---monthly-publication-january-2026.pdf   777 2026-01 Car Ford Transit 350 White Using a Mobile Phone Whilst Driving None Graham St Graham Street Birmingham Birmingham NFA No Independent Evidence Available   52.4843802 -1.9108415
11346 op-snap---monthly-publication-january-2026.pdf   807 2026-01 Car Volvo   Silver Using a Mobile Phone Whilst Driving None High Street High Street Out of Force Area Out of Force Area NFA Out of Force   52.4993921 -1.8955888
11353 op-snap---monthly-publication-january-2026.pdf   814 2026-01 Car Kia Niro Grey Using a Mobile Phone Whilst Driving None Enfield, London Enfield, London Out of Force Area Out of Force Area NFA Out of Force      
11494 op-snap---monthly-publication-january-2026.pdf   955 2026-01 Car BMW X5 Black Using a Mobile Phone Whilst Driving None A6182 Doncatser Doncatser Out of Force Area Out of Force Area NFA Out of Force      
11509 op-snap---monthly-publication-january-2026.pdf   970 2026-01 Car Toyota Prius Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham NFA No Offence   52.471632 -1.9456776
11543 op-snap---monthly-publication-january-2026.pdf   1004 2026-01 Car Ford Transit White Using a Mobile Phone Whilst Driving No Insurance M25 Dartford M25 Dartford Out of Force Area Out of Force Area NFA Out of Force   52.6162979 -2.0165105
11648 op-snap---monthly-publication-january-2026.pdf   1109 2026-01 Car Toyota Aygo Red Using a Mobile Phone Whilst Driving None George Street Newcastle George Street Newcastle Out of Force Area Out of Force Area NFA Out of Force      
11653 op-snap---monthly-publication-january-2026.pdf   1114 2026-01 Car Peugeot 3008.. Grey Using a Mobile Phone Whilst Driving None M5 Jct 6 M5 Junction 6 Out of Force Area Out of Force Area NFA Out of Force      
11683 op-snap---monthly-publication-january-2026.pdf   1144 2026-01 Car Audi TT Grey Using a Mobile Phone Whilst Driving None M53 Mersey Side M53 Mersey Side Out of Force Area Out of Force Area NFA Out of Force      
11732 op-snap---monthly-publication-january-2026.pdf   1193 2026-01 Car Seat . Green Using a Mobile Phone Whilst Driving None Stratford Upon Avon Stratford Upon Avon Out of Force Area Out of Force Area NFA Out of Force   52.3499075 -1.7812051
11733 op-snap---monthly-publication-january-2026.pdf   1194 2026-01 Car Land Rover Defender Black Using a Mobile Phone Whilst Driving None M3 near Bracknell M3 near Bracknell Out of Force Area Out of Force Area NFA Out of Force      
11839 op-snap---monthly-publication-january-2026.pdf   1300 2026-01 Car Vauxhall Astra Black Using a Mobile Phone Whilst Driving No vehicle excise licence M42 M42 Solihull Solihull NFA No Offence      
11874 op-snap---monthly-publication-january-2026.pdf   1335 2026-01 Car Audi A4.. Black Using a Mobile Phone Whilst Driving None Hill Top Road Hill Top Road Sandwell Sandwell NFA No Offence   52.4782626 -1.9987277
3909 op-snap---monthly-publication-december-2025.pdf   37 2025-12 Car Mercedes-Benz Benz White Using a Mobile Phone Whilst Driving None Alcester Street Alcester Street Birmingham Birmingham NFA No Independent Evidence Available   52.4696096 -1.8871873
3911 op-snap---monthly-publication-december-2025.pdf   39 2025-12 Car Renault Twingo Red Using a Mobile Phone Whilst Driving None Bloomfield Road Bloomfield Road Birmingham Birmingham NFA No Offence   52.4480767 -1.8755275
3999 op-snap---monthly-publication-december-2025.pdf   127 2025-12 Car   Bentley Grey Using a Mobile Phone Whilst Driving None M42 West Mercia M42 West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4004 op-snap---monthly-publication-december-2025.pdf   132 2025-12 Car Vauxhall Corsa Silver Using a Mobile Phone Whilst Driving None Coles Hill Road Coles Hill Road Birmingham Birmingham NFA No Independent Evidence Available      
4043 op-snap---monthly-publication-december-2025.pdf   171 2025-12 Car Ford   White Using a Mobile Phone Whilst Driving None Leamington Road Leamington Road Coventry Coventry NFA No Independent Evidence Available   52.3921304 -1.5156601
4059 op-snap---monthly-publication-december-2025.pdf   187 2025-12 Car Vauxhall Vivaro Grey Using a Mobile Phone Whilst Driving None M1 / M45 Watford Gap M1 / M45 Watford Gap Out of Force Area Out of Force Area NFA Out of Force      
4166 op-snap---monthly-publication-december-2025.pdf   294 2025-12 Car Seat Ibiza Blue Using a Mobile Phone Whilst Driving None A45 B'ham airport A45 B'ham airport Solihull Solihull NFA No Independent Evidence Available      
4412 op-snap---monthly-publication-december-2025.pdf   540 2025-12 Car Honda CR-V Black Using a Mobile Phone Whilst Driving No Insurance Battlefield Road Battlefield Road Out of Force Area Out of Force Area NFA Out of Force      
4628 op-snap---monthly-publication-december-2025.pdf   756 2025-12 Car Renault Captur Black Using a Mobile Phone Whilst Driving None M5 Southbound, jn 6 to 7 M5 Southbound, jn 6 to 7 Out of Force Area Out of Force Area NFA Out of Force      
4757 op-snap---monthly-publication-december-2025.pdf   885 2025-12 Car Audi TT Black Using a Mobile Phone Whilst Driving None Stonebridge Island Stonebridge Island Coventry Coventry NFA No Independent Evidence Available   52.4459998 -1.6949291
4797 op-snap---monthly-publication-december-2025.pdf   925 2025-12 Car Toyota Corolla Grey Using a Mobile Phone Whilst Driving None M40 near Banbury M40 near Banbury Out of Force Area Out of Force Area NFA Out of Force      
4822 op-snap---monthly-publication-december-2025.pdf   950 2025-12 Car   Ford White Using a Mobile Phone Whilst Driving Driving without Due Care and M At2t5ention M At2t5ention Out of Force Area Out of Force Area NFA Out of Force      
4830 op-snap---monthly-publication-december-2025.pdf   958 2025-12 Car Hyundai TUCSON White Using a Mobile Phone Whilst Driving None M6 near Willenhall M6 near Willenhall Walsall Walsall NFA No Independent Evidence Available      
4836 op-snap---monthly-publication-december-2025.pdf   964 2025-12 Car Land Rover Sport Blue Using a Mobile Phone Whilst Driving No Insurance M42, nothing more specific M42, nothing more specific Out of Force Area Out of Force Area NFA Out of Force      
4837 op-snap---monthly-publication-december-2025.pdf   965 2025-12 Car Volkswagen   Red Using a Mobile Phone Whilst Driving None Warrington Warrington Out of Force Area Out of Force Area NFA Out of Force   52.5389668 -1.856967
4872 op-snap---monthly-publication-december-2025.pdf   1000 2025-12 Car Tesla s Black Using a Mobile Phone Whilst Driving None waterloo road bushbury Waterloo Road Bushbury Wolverhampton Wolverhampton NFA No Independent Evidence Available      
4883 op-snap---monthly-publication-december-2025.pdf   1011 2025-12 Car Volkswagen Crafter white Using a Mobile Phone Whilst Driving None M5 jn4-jn5 M5 jn4-jn5 Out of Force Area Out of Force Area NFA Out of Force      
4885 op-snap---monthly-publication-december-2025.pdf   1013 2025-12 Car Toyota Auris Black Using a Mobile Phone Whilst Driving None A6 in Leicester A6 in Leicester Out of Force Area Out of Force Area NFA Out of Force      
4917 op-snap---monthly-publication-december-2025.pdf   1045 2025-12 Car Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None M1 NB J10, Luton M1 Northbound J10, Luton Out of Force Area Out of Force Area NFA Out of Force      
4927 op-snap---monthly-publication-december-2025.pdf   1055 2025-12 Car Citroen   White Using a Mobile Phone Whilst Driving None M5 M5     NFA No Independent Evidence Available      
4928 op-snap---monthly-publication-december-2025.pdf   1056 2025-12 Car Mercedes-Benz Splinter White Using a Mobile Phone Whilst Driving None M1 J10 M1 J10 Out of Force Area Out of Force Area NFA Out of Force      
4931 op-snap---monthly-publication-december-2025.pdf   1059 2025-12 Car Ford Fiesta Black Using a Mobile Phone Whilst Driving None A45 Coventry Road Coventry Road Birmingham Birmingham NFA No Independent Evidence Available   52.4726661 -1.8769032
4997 op-snap---monthly-publication-december-2025.pdf   1125 2025-12 Car Peugeot Partner White Using a Mobile Phone Whilst Driving None Queslett Road Queslett Road Birmingham Birmingham NFA No Independent Evidence Available   52.5458699 -1.9304484
5000 op-snap---monthly-publication-december-2025.pdf   1128 2025-12 Car BMW   Purple Using a Mobile Phone Whilst Driving None Guildford Guildford Out of Force Area Out of Force Area NFA Out of Force   52.4970635 -1.9013006
5001 op-snap---monthly-publication-december-2025.pdf   1129 2025-12 Car Peugeot   Black Using a Mobile Phone Whilst Driving None Lord Lane Lord Lane Solihull Solihull NFA No Independent Evidence Available      
5056 op-snap---monthly-publication-december-2025.pdf   1184 2025-12 Car Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Arbury Road Arbury Road Out of Force Area Out of Force Area NFA Out of Force   52.3979577 -1.8129541
20466 op-snap---monthly-publication-november-2025.pdf   8 2025-11 Car Renault   White Using a Mobile Phone Whilst Driving None M1 M1     NFA Out of Force      
20484 op-snap---monthly-publication-november-2025.pdf   26 2025-11 Car Toyota Yaris Black Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
20533 op-snap---monthly-publication-november-2025.pdf   75 2025-11 Car Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None M6 M6 Birmingham Birmingham NFA No Independent Evidence Available      
20553 op-snap---monthly-publication-november-2025.pdf   95 2025-11 Car Volkswagen Amarok Black Using a Mobile Phone Whilst Driving None Watery Lane Middleway Watery Lane Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4752679 -1.8748608
20555 op-snap---monthly-publication-november-2025.pdf   97 2025-11 Car Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Belmont Row Belmont Row Birmingham Birmingham NFA No Independent Evidence Available   52.4840765 -1.8819479
20569 op-snap---monthly-publication-november-2025.pdf   111 2025-11 Car Honda   Silver Using a Mobile Phone Whilst Driving None M6 Toll NB M6 Toll Northbound Out of Force Area Out of Force Area NFA Out of Force      
20592 op-snap---monthly-publication-november-2025.pdf   134 2025-11 Car Jeep Avenger   Using a Mobile Phone Whilst Driving None M40 J4 M40 J4 Out of Force Area Out of Force Area NFA Out of Force      
20657 op-snap---monthly-publication-november-2025.pdf   199 2025-11 Car Renault Trafic White Using a Mobile Phone Whilst Driving None Tomkinson Road Tomkinson Road Out of Force Area Out of Force Area NFA Out of Force      
20678 op-snap---monthly-publication-november-2025.pdf   220 2025-11 Car Ford Focus Black Using a Mobile Phone Whilst Driving None Bramah Way Tipton Bramah Way Tipton Sandwell Sandwell NFA No Independent Evidence Available   52.5315656 -2.0388495
20713 op-snap---monthly-publication-november-2025.pdf   255 2025-11 Car Mercedes-Benz A Class White Using a Mobile Phone Whilst Driving None Sutton New Road Sutton New Road Birmingham Birmingham NFA No Independent Evidence Available   52.5260956 -1.8379401
20738 op-snap---monthly-publication-november-2025.pdf   280 2025-11 Car Vauxhall Meriva Black Using a Mobile Phone Whilst Driving None Burley Road, Leeds Burley Road, Leeds Out of Force Area Out of Force Area NFA Out of Force      
20808 op-snap---monthly-publication-november-2025.pdf   350 2025-11 Car BMW 118D Black Using a Mobile Phone Whilst Driving None A45 A45 Birmingham Birmingham NFA No Independent Evidence Available      
20852 op-snap---monthly-publication-november-2025.pdf   394 2025-11 Car   Genesis Black Using a Mobile Phone Whilst Driving None M1 Junction 18 M1 Junction 18 Out of Force Area Out of Force Area NFA Out of Force      
20857 op-snap---monthly-publication-november-2025.pdf   399 2025-11 Car Suzuki Ibiza Grey Using a Mobile Phone Whilst Driving None Queensbridge Road Queensbridge Road Birmingham Birmingham NFA No Offence   52.4415108 -1.8971434
20967 op-snap---monthly-publication-november-2025.pdf   509 2025-11 Car Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Springfield Road, Worcester Springfield Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
21037 op-snap---monthly-publication-november-2025.pdf   579 2025-11 Car Mercedes-Benz   Black Using a Mobile Phone Whilst Driving None Brighton Road Brighton Road Out of Force Area Out of Force Area NFA Out of Force   52.4543156 -1.8840717
21065 op-snap---monthly-publication-november-2025.pdf   607 2025-11 Car Mercedes-Benz EQE Black Using a Mobile Phone Whilst Driving None M1. M1 Out of Force Area Out of Force Area NFA Out of Force      
21487 op-snap---monthly-publication-november-2025.pdf   1029 2025-11 Car Mitsubishi L200 White Using a Mobile Phone Whilst Driving None Hereford City Centre Hereford City Centre Out of Force Area Out of Force Area NFA Out of Force      
21511 op-snap---monthly-publication-november-2025.pdf   1053 2025-11 Car Land Rover Range Grey Using a Mobile Phone Whilst Driving None Highgate Road Highgate Road Birmingham Birmingham NFA No Independent Evidence Available   52.4606652 -1.8791145
21525 op-snap---monthly-publication-november-2025.pdf   1067 2025-11 Car Vauxhall Mokka Blue Using a Mobile Phone Whilst Driving None Stephson Street Stephson Street Walsall Walsall NFA No Independent Evidence Available      
21557 op-snap---monthly-publication-november-2025.pdf   1099 2025-11 Car Maxus E Deliver White Using a Mobile Phone Whilst Driving None Park Lane Park Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4986532 -1.8873443
21583 op-snap---monthly-publication-november-2025.pdf   1125 2025-11 Car Kia Sportage White Using a Mobile Phone Whilst Driving None Suffolk Street Suffolk Street Birmingham Birmingham NFA No Independent Evidence Available   52.4749336 -1.9003475
21636 op-snap---monthly-publication-november-2025.pdf   1178 2025-11 Car Volvo XC90 White Using a Mobile Phone Whilst Driving None A43 A43 Out of Force Area Out of Force Area NFA Out of Force      
21675 op-snap---monthly-publication-november-2025.pdf   1217 2025-11 Car Ford Transit White Using a Mobile Phone Whilst Driving None Lawnswood Road, Wordsley Lawnswood Road, Wordsley Dudley Dudley NFA No VRM   52.4818392 -2.1676551
21741 op-snap---monthly-publication-november-2025.pdf   1283 2025-11 Car BMW 120d Grey Using a Mobile Phone Whilst Driving None Reddings Lane Reddings Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4506039 -1.8463952
21760 op-snap---monthly-publication-november-2025.pdf   1302 2025-11 Car       Using a Mobile Phone Whilst Driving None UK Uk Birmingham Birmingham NFA No Independent Evidence Available   52.45124 -1.937937
21945 op-snap---monthly-publication-november-2025.pdf   1487 2025-11 Car Honda CR-V Grey Using a Mobile Phone Whilst Driving None M25 - Jct 15-16 (Thames Valley) M25 - Junction 15-16 (Thames Valley) Out of Force Area Out of Force Area NFA Out of Force      

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