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

526 rows where disposal = "NFA", offence = "Driving without Reasonable Consideration" 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

vehicle_make >30

reporter_transport_mode 1

  • Car · 526 ✖

offence 1

  • Driving without Reasonable Consideration · 526 ✖

disposal 1

  • NFA · 526 ✖
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
7397 op-snap---monthly-publication-february-2026.pdf   144 2026-02 Car Kia Stonic Red Driving without Reasonable Consideration None Telford Town Centre Telford Town Centre Out of Force Area Out of Force Area NFA Out of Force      
7412 op-snap---monthly-publication-february-2026.pdf   159 2026-02 Car Peugeot 208 Grey Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
7964 op-snap---monthly-publication-february-2026.pdf   711 2026-02 Car Audi A3 Red Driving without Reasonable Consideration None Queslett Road / Kings Road Queslett Road / Kings Road Birmingham Birmingham NFA No Offence   52.5461661 -1.9204363
8763 op-snap---monthly-publication-february-2026.pdf   1510 2026-02 Car Tesla model 3 Grey Driving without Reasonable Consideration None Jn3 M42, West Mercia Jn3 M42, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
8771 op-snap---monthly-publication-february-2026.pdf   1518 2026-02 Car Toyota Prius White Driving without Reasonable Consideration None Newton Road Great Barr Newton Road Great Barr Birmingham Birmingham NFA No Independent Evidence Available   52.5429259 -1.9534939
4724 op-snap---monthly-publication-december-2025.pdf   852 2025-12 Car Nissan Qashqai White Driving without Reasonable Consideration None Stafford Rd Stafford Road Wolverhampton Wolverhampton NFA No Offence   52.6291998 -2.126312
20489 op-snap---monthly-publication-november-2025.pdf   31 2025-11 Car Jaecoo Delux Black Driving without Reasonable Consideration None M42 Solihull M42 Solihull Birmingham Birmingham NFA No Offence   52.4711059 -1.8461809
21240 op-snap---monthly-publication-november-2025.pdf   782 2025-11 Car Hyundai i30 blue Driving without Reasonable Consideration None M5 Northbound, West Mercia M5 Northbound, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
23321 op-snap---monthly-publication-october-2025.pdf   1271 2025-10 Car Daf Tipper White Driving without Reasonable Consideration None Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
23790 op-snap---monthly-publication-september-2025.pdf   9 2025-09 Car Volkswagen Crafter Grey Driving without Reasonable Consideration None St Peters Driv, Worcester Street Peters Driv, Worcester Out of Force Area Out of Force Area NFA Out of Force      
23865 op-snap---monthly-publication-september-2025.pdf   84 2025-09 Car Audi A3 Black Driving without Reasonable Consideration None M6 J12 M6 J12 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
23884 op-snap---monthly-publication-september-2025.pdf   103 2025-09 Car   Polestar Black Driving without Reasonable Consideration None Bickenhill Lane Bickenhill Lane Solihull Solihull NFA No Offence   52.4490463 -1.7296897
23979 op-snap---monthly-publication-september-2025.pdf   198 2025-09 Car Toyota Yaris Black Driving without Reasonable Consideration None Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham NFA No Offence   52.4650893 -1.8425008
24075 op-snap---monthly-publication-september-2025.pdf   294 2025-09 Car Land Rover Range Black Driving without Reasonable Consideration None Hereford Ring Road Hereford Ring Road Out of Force Area Out of Force Area NFA Out of Force      
24203 op-snap---monthly-publication-september-2025.pdf   422 2025-09 Car Peugeot 208 Grey Driving without Reasonable Consideration None M1 J21 - Leicester M1 J21 - Leicester Out of Force Area Out of Force Area NFA Out of Force      
24330 op-snap---monthly-publication-september-2025.pdf   549 2025-09 Car Volkswagen Crafter White Driving without Reasonable Consideration None Black Country New Road Black Country New Road Sandwell Sandwell NFA No Offence   52.5527191 -2.0312967
24332 op-snap---monthly-publication-september-2025.pdf   551 2025-09 Car Mercedes-Benz Smart Car Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
24509 op-snap---monthly-publication-september-2025.pdf   728 2025-09 Car Daf Trucks White Driving without Reasonable Consideration None M42 J9 M42 J9 Out of Force Area Out of Force Area NFA Out of Force   52.3601724 -1.8062199
24879 op-snap---monthly-publication-september-2025.pdf   1098 2025-09 Car Peugeot Expert White Driving without Reasonable Consideration None Monument Road Monument Road Birmingham Birmingham NFA No Offence   52.4731312 -1.930947
2275 op-snap---monthly-publication-august-2025.pdf   250 2025-08 Car Toyota Prius Silver Driving without Reasonable Consideration None Alum Rock Road Alum Rock Road Birmingham Birmingham NFA No Offence   52.4883936 -1.8310056
2312 op-snap---monthly-publication-august-2025.pdf   287 2025-08 Car Ford kuga Grey Driving without Reasonable Consideration None M6 J10 M6 J10 Walsall Walsall NFA No Independent Evidence Available   52.676119 -2.0858425
2388 op-snap---monthly-publication-august-2025.pdf   363 2025-08 Car Volkswagen Golf Grey Driving without Reasonable Consideration None Heybarnes Road Heybarnes Road Birmingham Birmingham NFA No Independent Evidence Available   52.4677423 -1.8351236
2550 op-snap---monthly-publication-august-2025.pdf   525 2025-08 Car Audi A1 Grey Driving without Reasonable Consideration None Woodgreen Drive (Worcester) Woodgreen Drive (Worcester) Out of Force Are Out of Force Area NFA Out of Force      
2810 op-snap---monthly-publication-august-2025.pdf   785 2025-08 Car Vauxhall Corsa Silver Driving without Reasonable Consideration None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton NFA No Offence   52.5847884 -2.1341887
2816 op-snap---monthly-publication-august-2025.pdf   791 2025-08 Car Audi A5 Black Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.5919543 -1.8517118
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
2827 op-snap---monthly-publication-august-2025.pdf   802 2025-08 Car Renault   White Driving without Reasonable Consideration None A447 Ashby Road Ashby Road Out of Force Are Out of Force Area NFA Out of Force      
2914 op-snap---monthly-publication-august-2025.pdf   889 2025-08 Car Kia   Grey Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham NFA No Offence   52.4543565 -1.9114004
2933 op-snap---monthly-publication-august-2025.pdf   908 2025-08 Car Audi Q3 Blue Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
3153 op-snap---monthly-publication-august-2025.pdf   1128 2025-08 Car Citroen Relay Grey Driving without Reasonable Consideration None Coleshill Road Coleshill Road Birmingham Birmingham NFA No Offence   52.4967329 -1.8097462
3196 op-snap---monthly-publication-august-2025.pdf   1171 2025-08 Car Vauxhall Adam Red Driving without Reasonable Consideration None M42 Jn 10, Warwickshire M42 Junction 10, Warwickshire Out of Force Are Out of Force Area NFA Out of Force      
11953 op-snap---monthly-publication-july-2025.pdf   5 2025-07 Car Ford Fiesta Orange Driving without Reasonable Consideration None Oldbury Ring Way Oldbury Ring Way Sandwell Sandwell NFA Outside of 14 Days NIP      
11962 op-snap---monthly-publication-july-2025.pdf   14 2025-07 Car Nissan Micra Red Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4470686 -1.8880749
11977 op-snap---monthly-publication-july-2025.pdf   29 2025-07 Car Volkswagen PX15PHF White Driving without Reasonable Consideration None Parkfields Road Parkfields Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission      
12062 op-snap---monthly-publication-july-2025.pdf   114 2025-07 Car Byd Seal Blue Driving without Reasonable Consideration None Kenilworth Road Kenilworth Road Out of Force Area Out of Force Area NFA Out of Force   52.5124557 -1.8917609
12065 op-snap---monthly-publication-july-2025.pdf   117 2025-07 Car BMW 330E Grey Driving without Reasonable Consideration None M42 Junction 3 West Mercia M42 Junction 3 West Mercia Out of Force Area Out of Force Area NFA Out of Force   52.4846642 -1.9297585
12085 op-snap---monthly-publication-july-2025.pdf   137 2025-07 Car Honda jazz Blue Driving without Reasonable Consideration None Shenley Fields Road Shenley Fields Road Birmingham Birmingham NFA No Offence   52.4373076 -1.9543847
12148 op-snap---monthly-publication-july-2025.pdf   200 2025-07 Car Ford Fiesta Yellow Driving without Reasonable Consideration None Queen Elizabeth Hospital Queen Elizabeth Hospital Birmingham Birmingham NFA Outside of 14 Days NIP   52.4517147 -1.9423655
12199 op-snap---monthly-publication-july-2025.pdf   251 2025-07 Car Toyota Police car White Driving without Reasonable Consideration None Anderton Park Road Anderton Park Road Birmingham Birmingham NFA No Offence   52.4481342 -1.8776139
12304 op-snap---monthly-publication-july-2025.pdf   356 2025-07 Car Ford Mondeo Black Driving without Reasonable Consideration None Coventry Coventry Birmingham Birmingham NFA No Offence   52.4527138 -1.7656635
12500 op-snap---monthly-publication-july-2025.pdf   552 2025-07 Car Toyota Yaris Silver Driving without Reasonable Consideration None Ulverley Green Road, Olton Ulverley Green Road, Olton Solihull Solihull NFA No VRM   52.4374545 -1.803861
12588 op-snap---monthly-publication-july-2025.pdf   640 2025-07 Car BMW 4 series Black Driving without Reasonable Consideration None Chelmsley Wood Chelmsley Wood Birmingham Birmingham NFA No Offence      
12611 op-snap---monthly-publication-july-2025.pdf   663 2025-07 Car Volkswagen Golf White Driving without Reasonable Consideration None Birchfield Road Birchfield Road Birmingham Birmingham NFA No Offence   52.5170745 -1.9012542
12612 op-snap---monthly-publication-july-2025.pdf   664 2025-07 Car Seat Leon Silver Driving without Reasonable Consideration Use vehicle on a road without Bvairlcidh ftieesldt cReoratifdicate Bvairlcidh ftieesldt c Reoratifdicate Birmingham Birmingham NFA No Offence      
12656 op-snap---monthly-publication-july-2025.pdf   708 2025-07 Car Hyundai i30 Grey Driving without Reasonable Consideration None Chester Road Chester Road Walsall Walsall NFA Outside of 14 Days NIP   52.5692139 -1.8799672
12688 op-snap---monthly-publication-july-2025.pdf   740 2025-07 Car BMW 118 Black Driving without Reasonable Consideration None A514 Bedford Bedford Out of Force Area Out of Force Area NFA Out of Force      
12752 op-snap---monthly-publication-july-2025.pdf   804 2025-07 Car Ford Focus Grey Driving without Reasonable Consideration None Coventry Street, Kidderminster Coventry Street, Kidderminster Out of Force Area Out of Force Area NFA Out of Force      
12802 op-snap---monthly-publication-july-2025.pdf   854 2025-07 Car Toyota Prius Silver Driving without Reasonable Consideration None Lobe Lane Lobe Lane Solihull Solihull NFA No Offence      
12804 op-snap---monthly-publication-july-2025.pdf   856 2025-07 Car Toyota Prius Silver Driving without Reasonable Consideration None Lode Lane Lode Lane Solihull Solihull NFA No Offence   52.4149064 -1.7832364
12832 op-snap---monthly-publication-july-2025.pdf   884 2025-07 Car Hyundai ioniq White Driving without Reasonable Consideration None M5 West Brom M5 West Brom Sandwell Sandwell NFA Outside of 14 Days NIP      
12858 op-snap---monthly-publication-july-2025.pdf   910 2025-07 Car Vauxhall Corsa White Driving without Reasonable Consideration None Biddling Lane Biddling Lane Wolverhampton Wolverhampton NFA No Independent Evidence Available      
12861 op-snap---monthly-publication-july-2025.pdf   913 2025-07 Car Mazda   Black Driving without Reasonable Consideration None Clifford Street , Newton Clifford Street , Newton Birmingham Birmingham NFA Outside of 14 Days NIP      
12866 op-snap---monthly-publication-july-2025.pdf   918 2025-07 Car Audi Estima Silver Driving without Reasonable Consideration None Somerville Road Somerville Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5555545 -1.8329387
12868 op-snap---monthly-publication-july-2025.pdf   920 2025-07 Car Volkswagen Polo White Driving without Reasonable Consideration None Kings Road , Tyseley ,Birmingham Kings Road , Tyseley , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4572996 -1.8391692
12886 op-snap---monthly-publication-july-2025.pdf   938 2025-07 Car Audi A4 Black Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
12887 op-snap---monthly-publication-july-2025.pdf   939 2025-07 Car Audi A5 Red Driving without Reasonable Consideration None M40 Southbound M40 Southbound Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
12888 op-snap---monthly-publication-july-2025.pdf   940 2025-07 Car Scania   White Driving without Reasonable Consideration None M6 Northbound M6 Northbound Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4316701 -2.0178238
12889 op-snap---monthly-publication-july-2025.pdf   941 2025-07 Car BMW   Red Driving without Reasonable Consideration None York Road , Birmingham York Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5231321 -1.8415573
12890 op-snap---monthly-publication-july-2025.pdf   942 2025-07 Car Vauxhall Mokka Grey Driving without Reasonable Consideration None A4040 , Birmingham A4040 , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5150323 -1.9007149
12891 op-snap---monthly-publication-july-2025.pdf   943 2025-07 Car Audi   Black Driving without Reasonable Consideration None Warwick Road , Birmingham Warwick Road , Birmingham Birmingham Birmingham NFA Out of Force   52.551985 -1.860445
12892 op-snap---monthly-publication-july-2025.pdf   944 2025-07 Car Volvo   Black Driving without Reasonable Consideration None M6 Northbound M6 Northbound Birmingham Birmingham NFA Outside of 14 Days NIP      
12893 op-snap---monthly-publication-july-2025.pdf   945 2025-07 Car Vauxhall   Silver Driving without Reasonable Consideration None M5 Northbound M5 Northbound Birmingham Birmingham NFA Outside of 14 Days NIP      
12894 op-snap---monthly-publication-july-2025.pdf   946 2025-07 Car BMW   White Driving without Reasonable Consideration None M42 close to Junction 8 M42 close to Junction 8 Birmingham Birmingham NFA Outside of 14 Days NIP      
12895 op-snap---monthly-publication-july-2025.pdf   947 2025-07 Car Renault clio Red Driving without Reasonable Consideration None Walsall Road , West Bromwich Walsall Road , West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP   52.5366137 -1.9867997
12898 op-snap---monthly-publication-july-2025.pdf   950 2025-07 Car Mercedes-Benz sprinter Orange Driving without Reasonable Consideration None Caynton Road Caynton Road Out of Force Area Out of Force Area NFA Out of Force      
12905 op-snap---monthly-publication-july-2025.pdf   957 2025-07 Car   Contera MDI Red Driving without Reasonable Consideration None A46 Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force   52.3837388 -1.5529669
12907 op-snap---monthly-publication-july-2025.pdf   959 2025-07 Car Land Rover Evoque Black Driving without Reasonable Consideration None Stafford Road Stafford Road Wolverhampton Wolverhampton NFA No Offence   52.6291998 -2.126312
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
12917 op-snap---monthly-publication-july-2025.pdf   969 2025-07 Car Land Rover   Black Driving without Reasonable Consideration None M5 North M5 North Birmingham Birmingham NFA Outside of 14 Days NIP   52.5151103 -1.8501538
12918 op-snap---monthly-publication-july-2025.pdf   970 2025-07 Car Ford Transit Blue Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
12919 op-snap---monthly-publication-july-2025.pdf   971 2025-07 Car Vauxhall Insignia Blue Driving without Reasonable Consideration None Eastern Green Road , Coventry Eastern Green Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4131188 -1.5784769
12922 op-snap---monthly-publication-july-2025.pdf   974 2025-07 Car Honda   Silver Driving without Reasonable Consideration None Third Avenue , Pensnett Third Avenue , Pensnett Dudley Dudley NFA Out of Force   52.5046812 -2.1550209
12923 op-snap---monthly-publication-july-2025.pdf   975 2025-07 Car Toyota   Grey Driving without Reasonable Consideration None Dudley Road , A4101 , Kingswinford Dudley Road , A4101 , Kingswinford Dudley Dudley NFA Outside of 14 Days NIP   52.5003036 -2.1593541
12924 op-snap---monthly-publication-july-2025.pdf   976 2025-07 Car Skoda Fabia Black Driving without Reasonable Consideration None Cole Hall Lane , Birmingham Cole Hall Lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4877244 -1.787883
12925 op-snap---monthly-publication-july-2025.pdf   977 2025-07 Car Vauxhall Corsa Red Driving without Reasonable Consideration None Stourbridge Road , Colley Gate Stourbridge Road , Colley Gate Dudley Dudley NFA Outside of 14 Days NIP      
12953 op-snap---monthly-publication-july-2025.pdf   1005 2025-07 Car Ford Focus White Driving without Reasonable Consideration None Westcote Avenue , twoartds Frankley Westcote Avenue , twoartds Frankley OGuret eonf Force Area Oguret Eonf Force Area NFA Outside of 14 Days NIP      
12954 op-snap---monthly-publication-july-2025.pdf   1006 2025-07 Car BMW   White Driving without Reasonable Consideration None Birmingham Road , Stratford Birmingham Road , Stratford Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4496153 -1.8646204
12957 op-snap---monthly-publication-july-2025.pdf   1009 2025-07 Car Audi A8 Black Driving without Reasonable Consideration None Stratford Road , Birmingham Stratford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4447583 -1.8592059
12960 op-snap---monthly-publication-july-2025.pdf   1012 2025-07 Car BMW   Silver Driving without Reasonable Consideration None Mini Roundabout , Bacchus Road Mini Roundabout , Bacchus Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12961 op-snap---monthly-publication-july-2025.pdf   1013 2025-07 Car BMW 530d M Sport Black Driving without Reasonable Consideration None Star City , Birmingham Star City , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5054363 -1.8556273
12967 op-snap---monthly-publication-july-2025.pdf   1019 2025-07 Car BMW X5 White Driving without Reasonable Consideration None Wolverhampton - Heading towards ST Wolverhampton - Heading towards ST Bafifromrdin gRhoaamd Bafifromrdin Grhoaamd NFA Outside of 14 Days NIP      
12979 op-snap---monthly-publication-july-2025.pdf   1031 2025-07 Car BMW x1 Black Driving without Reasonable Consideration None M6 J13 M6 J13 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
12986 op-snap---monthly-publication-july-2025.pdf   1038 2025-07 Car Yamaha   Blue Driving without Reasonable Consideration None Chester Road North , Birmingham Chester Road North , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5666061 -1.879083
12989 op-snap---monthly-publication-july-2025.pdf   1041 2025-07 Car Toyota Corolla Silver Driving without Reasonable Consideration None Walsall Road , Stone Cross Walsall Road , Stone Cross Sandwell Sandwell NFA Outside of 14 Days NIP   52.54591 -1.9841049
12991 op-snap---monthly-publication-july-2025.pdf   1043 2025-07 Car Land Rover   Grey Driving without Reasonable Consideration None Spring Lane South Spring Lane South Sandwell Sandwell NFA Outside of 14 Days NIP      
12992 op-snap---monthly-publication-july-2025.pdf   1044 2025-07 Car Audi A3 Sport Grey Driving without Reasonable Consideration No Insurance Hockett Street , Coventry Hockett Street , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.3981697 -1.5050109
12993 op-snap---monthly-publication-july-2025.pdf   1045 2025-07 Car Ford Escort Grey Driving without Reasonable Consideration None A38M towards Birmingham City Centr A38M towards Birmingham City Centr eBirmingham Ebirmingham NFA Outside of 14 Days NIP      
12995 op-snap---monthly-publication-july-2025.pdf   1047 2025-07 Car Ford Focus Blue Driving without Reasonable Consideration None Bridge Street , Worcester Bridge Street , Worcester Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
12996 op-snap---monthly-publication-july-2025.pdf   1048 2025-07 Car Volkswagen   White Driving without Reasonable Consideration None Umberslade Road , Birmingham Umberslade Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4304526 -1.9216716
13009 op-snap---monthly-publication-july-2025.pdf   1061 2025-07 Car Vauxhall Vivaro White Driving without Reasonable Consideration None Cakemore Road , Rowley regis Cakemore Road , Rowley regis Sandwell Sandwell NFA Outside of 14 Days NIP      
13012 op-snap---monthly-publication-july-2025.pdf   1064 2025-07 Car Ford Transit White Driving without Reasonable Consideration None Joseph Road , Churchbridge , Oldbur Joseph Road , Churchbridge , Oldbur ySandwell Ysandwell NFA Outside of 14 Days NIP      
13016 op-snap---monthly-publication-july-2025.pdf   1068 2025-07 Car Hyundai   Black Driving without Reasonable Consideration None Meole Brace roundabout , Shrewsbur Meole Brace roundabout , Shrewsbur yOut of Force Area Yout Of Force Area NFA Outside of 14 Days NIP      
13027 op-snap---monthly-publication-july-2025.pdf   1079 2025-07 Car Tesla   White Driving without Reasonable Consideration None A49 Junction with B5477 towards Chu Junction with B5477 towards Chu rOcuht Sotfr eFtotorcne Area Rocuht Sotfr Eftotorcne Area NFA Outside of 14 Days NIP      
13032 op-snap---monthly-publication-july-2025.pdf   1084 2025-07 Car Audi A3 Grey Driving without Reasonable Consideration None Stecthford Lane , Birmingham Stecthford Lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
13033 op-snap---monthly-publication-july-2025.pdf   1085 2025-07 Car Hyundai   Blue Driving without Reasonable Consideration None Broadway North , Walsall Broadway North , Walsall Walsall Walsall NFA Outside of 14 Days NIP   52.5886101 -1.9749676
13034 op-snap---monthly-publication-july-2025.pdf   1086 2025-07 Car Mercedes-Benz   White Driving without Reasonable Consideration None Sherbourne Street , Coventry Sherbourne Street , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4080688 -1.5236936
13045 op-snap---monthly-publication-july-2025.pdf   1097 2025-07 Car Land Rover Evoque White Driving without Reasonable Consideration None Unknown - Country Lane, Coleshill Unknown - Country Lane, Coleshill Out of Force Area Out of Force Area NFA Out of Force      
13059 op-snap---monthly-publication-july-2025.pdf   1111 2025-07 Car BMW   White Driving without Reasonable Consideration Contravening a Red Traffic Li gShhtaw Road , A463 g Shhtaw Road , A463 Birmingham Birmingham NFA Outside of 14 Days NIP      
13060 op-snap---monthly-publication-july-2025.pdf   1112 2025-07 Car Mercedes-Benz   Black Driving without Reasonable Consideration None Bromford Lane , Stetchford Bromford Lane , Stetchford Birmingham Birmingham NFA Outside of 14 Days NIP      
13062 op-snap---monthly-publication-july-2025.pdf   1114 2025-07 Car Volkswagen   White Driving without Reasonable Consideration None M42 Southbound M42 Southbound Birmingham Birmingham NFA Outside of 14 Days NIP      

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