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

474 rows where month = "2025-07", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Car · 474 ✖

offence 1

  • Driving without Due Care and Attention · 474 ✖

month 1

  • 2025-07 · 474 ✖
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
11948 op-snap---monthly-publication-july-2025.pdf   0 2025-07 Car Ford Focus Silver Driving without Due Care and Attention None Russell Road Russell Road Birmingham Birmingham NFA No Offence   52.4398245 -1.8469786
11949 op-snap---monthly-publication-july-2025.pdf   1 2025-07 Car Ford Fiesta White Driving without Due Care and Attention None Airport WAY Airport WAY Birmingham Birmingham Education N/A      
11951 op-snap---monthly-publication-july-2025.pdf   3 2025-07 Car BMW M340 Blue Driving without Due Care and Attention None Downing Street Downing Street Sandwell Sandwell Court N/A   52.5015329 -1.9556094
11952 op-snap---monthly-publication-july-2025.pdf   4 2025-07 Car Volvo XC40 Blue Driving without Due Care and Attention None Metcheley Lane Metcheley Lane Birmingham Birmingham Court N/A      
11958 op-snap---monthly-publication-july-2025.pdf   10 2025-07 Car Toyota Auris Blue Driving without Due Care and Attention No Insurance KIngs Road KIngs Road Birmingham Birmingham Court N/A   52.5531351 -1.8852761
11959 op-snap---monthly-publication-july-2025.pdf   11 2025-07 Car Renault Clio Silver Driving without Due Care and Attention None M54 - M6 Link M54 - M6 Link Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
11971 op-snap---monthly-publication-july-2025.pdf   23 2025-07 Car Skoda Enyaq Blue Driving without Due Care and Attention None A44 Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
11972 op-snap---monthly-publication-july-2025.pdf   24 2025-07 Car Volkswagen   Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
11973 op-snap---monthly-publication-july-2025.pdf   25 2025-07 Car Volvo XC40 Black Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell NFA No Offence   52.4926604 -2.0216743
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
11978 op-snap---monthly-publication-july-2025.pdf   30 2025-07 Car Vauxhall Corsa Red Driving without Due Care and Attention None Queensbury, Bradford Queensbury, Bradford Out of Force Area Out of Force Area NFA Out of Force      
11979 op-snap---monthly-publication-july-2025.pdf   31 2025-07 Car Porsche Cayman Silver Driving without Due Care and Attention None Stratford Road, Wellesbourne Stratford Road, Wellesbourne Out of Force Area Out of Force Area NFA Out of Force      
11980 op-snap---monthly-publication-july-2025.pdf   32 2025-07 Car Mercedes-Benz A Class Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
11984 op-snap---monthly-publication-july-2025.pdf   36 2025-07 Car Mercedes-Benz Sprinter Blue Driving without Due Care and Attention None Off force - west mercia Off force - west mercia Out of Force Area Out of Force Area NFA Out of Force      
11987 op-snap---monthly-publication-july-2025.pdf   39 2025-07 Car Ford Focus Black Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.471632 -1.9456776
11990 op-snap---monthly-publication-july-2025.pdf   42 2025-07 Car Ford Mondeo Blue Driving without Due Care and Attention None A5189 Burton upon Trent Burton upon Trent Out of Force Area Out of Force Area NFA Out of Force      
11995 op-snap---monthly-publication-july-2025.pdf   47 2025-07 Car Mercedes-Benz   Grey Driving without Due Care and Attention None Rocky Lane Rocky Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.5285859 -1.9100513
11996 op-snap---monthly-publication-july-2025.pdf   48 2025-07 Car Seat   Red Driving without Due Care and Attention None Rabone Lane Rabone Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4998908 -1.952631
12000 op-snap---monthly-publication-july-2025.pdf   52 2025-07 Car Audi A6 Silver Driving without Due Care and Attention None Bilford Road Bilford Road Out of Force Area Out of Force Area NFA Out of Force      
12003 op-snap---monthly-publication-july-2025.pdf   55 2025-07 Car Audi A6 Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
12009 op-snap---monthly-publication-july-2025.pdf   61 2025-07 Car Volkswagen Passatt Grey Driving without Due Care and Attention None Richmond Road Richmond Road Solihull Solihull Education N/A   52.4430188 -1.8022218
12016 op-snap---monthly-publication-july-2025.pdf   68 2025-07 Car Volkswagen Polo Red Driving without Due Care and Attention None Berners Street Berners Street Birmingham Birmingham Fixed Penalty N/A   52.5014952 -1.9055936
12017 op-snap---monthly-publication-july-2025.pdf   69 2025-07 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None M5 NB J3-J2 M5 Northbound J3-J2 Birmingham Birmingham Court N/A   52.4846642 -1.9297585
12019 op-snap---monthly-publication-july-2025.pdf   71 2025-07 Car Mg Trophy Grey Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Coventry Coventry NFA No Offence   52.3833298 -1.5379214
12021 op-snap---monthly-publication-july-2025.pdf   73 2025-07 Car Seat Leon Blue Driving without Due Care and Attention None Small Heath Bridge Small Heath Bridge Birmingham Birmingham RTC - Actioned N/A   52.4675008 -1.8693303
12022 op-snap---monthly-publication-july-2025.pdf   74 2025-07 Car Mazda 3 series White Driving without Due Care and Attention None M5 motorway nr Jn1 M5 motorway nr Jn1 Sandwell Sandwell NFA No Independent Evidence Available      
12023 op-snap---monthly-publication-july-2025.pdf   75 2025-07 Car Audi Q3 Blue Driving without Due Care and Attention None M43 WB J3 M43 Wb J3 Out of Force Area Out of Force Area NFA Out of Force   52.4846642 -1.9297585
12025 op-snap---monthly-publication-july-2025.pdf   77 2025-07 Car Nissan Qashqai Black Driving without Due Care and Attention None Beehive Hill Beehive Hill Out of Force Area Out of Force Area NFA Out of Force   52.5518914 -2.0227634
12027 op-snap---monthly-publication-july-2025.pdf   79 2025-07 Car Audi A6 Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4203897 -1.8338574
12032 op-snap---monthly-publication-july-2025.pdf   84 2025-07 Car Toyota Yaris White Driving without Due Care and Attention None Coleshill Road Coleshill Road Birmingham Birmingham Court N/A   52.4967329 -1.8097462
12033 op-snap---monthly-publication-july-2025.pdf   85 2025-07 Car Seat Ateca White Driving without Due Care and Attention None Coleshill Road Coleshill Road Birmingham Birmingham Court N/A   52.4967329 -1.8097462
12035 op-snap---monthly-publication-july-2025.pdf   87 2025-07 Car BMW   Black Driving without Due Care and Attention None Neachells Lane Neachells Lane Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.597459 -2.0791894
12036 op-snap---monthly-publication-july-2025.pdf   88 2025-07 Car Suzuki Swift Blue Driving without Due Care and Attention None Wednesfield Road Wednesfield Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.5885601 -2.122003
12037 op-snap---monthly-publication-july-2025.pdf   89 2025-07 Car Hyundai I20 Grey Driving without Due Care and Attention None SHardend Crescent SHardend Crescent Birmingham Birmingham Fixed Penalty N/A      
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
12048 op-snap---monthly-publication-july-2025.pdf   100 2025-07 Car Audi A3 Grey Driving without Due Care and Attention None St Giles Road Street Giles Road Wolverhampton Wolverhampton Court N/A      
12050 op-snap---monthly-publication-july-2025.pdf   102 2025-07 Car Mercedes-Benz C300 Black Driving without Due Care and Attention None Broad Street Broad Street Birmingham Birmingham Court N/A   52.4749212 -1.9147497
12051 op-snap---monthly-publication-july-2025.pdf   103 2025-07 Car Toyota Prius White Driving without Due Care and Attention None Bristol Street Bristol Street Birmingham Birmingham Fixed Penalty N/A   52.4691145 -1.9003257
12052 op-snap---monthly-publication-july-2025.pdf   104 2025-07 Car Volkswagen Golf R Black Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
12053 op-snap---monthly-publication-july-2025.pdf   105 2025-07 Car Audi RS3 Blue Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
12061 op-snap---monthly-publication-july-2025.pdf   113 2025-07 Car Alfa Romeo Polo Black Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4816806 -1.8788939
12064 op-snap---monthly-publication-july-2025.pdf   116 2025-07 Car Citroen Berlingo White Driving without Due Care and Attention None Daventry Road Daventry Road Coventry Coventry NFA Outside of 14 Days NIP   52.3930931 -1.4976428
12070 op-snap---monthly-publication-july-2025.pdf   122 2025-07 Car Ford Transit White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
12072 op-snap---monthly-publication-july-2025.pdf   124 2025-07 Car Volvo V40.. Grey Driving without Due Care and Attention None East Midway East Midway Birmingham Birmingham NFA Outside of 14 Days NIP      
12074 op-snap---monthly-publication-july-2025.pdf   126 2025-07 Car Volvo XC90 Black Driving without Due Care and Attention None M6 Warwickshire M6 Warwickshire Out of Force Area Out of Force Area NFA Out of Force   52.4572944 -1.4815973
12079 op-snap---monthly-publication-july-2025.pdf   131 2025-07 Car BMW   Black Driving without Due Care and Attention None Church Lane Church Lane Out of Force Area Out of Force Area NFA Out of Force   52.5133161 -1.9278283
12088 op-snap---monthly-publication-july-2025.pdf   140 2025-07 Car Nissan Qashqai Grey Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A   52.4816806 -1.8788939
12091 op-snap---monthly-publication-july-2025.pdf   143 2025-07 Car Mg ZS Black Driving without Due Care and Attention None A4540 Bordesley Middleway Bordesley Middleway Birmingham Birmingham NFA Outside of 14 Days NIP   52.4704236 -1.8769606
12096 op-snap---monthly-publication-july-2025.pdf   148 2025-07 Car Vauxhall Insignia Red Driving without Due Care and Attention None M6 Motorway M6 Motorway Birmingham Birmingham NFA Outside of 14 Days NIP   52.5327447 -1.899844
12097 op-snap---monthly-publication-july-2025.pdf   149 2025-07 Car Volkswagen Golf Blue Driving without Due Care and Attention None M6 Motorway J10 M6 Motorway J10 Walsall Walsall Court N/A      
12098 op-snap---monthly-publication-july-2025.pdf   150 2025-07 Car Land Rover Sport Black Driving without Due Care and Attention None Manor Lane Manor Lane Dudley Dudley Education N/A   52.4500678 -2.0276115
12110 op-snap---monthly-publication-july-2025.pdf   162 2025-07 Car Audi Q7.. Grey Driving without Due Care and Attention None Slip road London Slip road London Out of Force Area Out of Force Area NFA Out of Force      
12111 op-snap---monthly-publication-july-2025.pdf   163 2025-07 Car BMW 3 SERIES Grey Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Warning Letter N/A   52.5517052 -1.7825505
12113 op-snap---monthly-publication-july-2025.pdf   165 2025-07 Car Kia GT.. Grey Driving without Due Care and Attention None B4101 Coventry Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.400739 -1.5135474
12115 op-snap---monthly-publication-july-2025.pdf   167 2025-07 Car Mercedes-Benz C220 Red Driving without Due Care and Attention None Wood End Road Wood End Road Wolverhampton Wolverhampton Education N/A   52.605993 -2.0805938
12116 op-snap---monthly-publication-july-2025.pdf   168 2025-07 Car Ford Ranger White Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Birmingham Birmingham NFA Outside of 14 Days NIP      
12123 op-snap---monthly-publication-july-2025.pdf   175 2025-07 Car Volkswagen T-Roc Black Driving without Due Care and Attention None Garretts Green Lane Garretts Green Lane Birmingham Birmingham Court N/A   52.4675802 -1.7905748
12127 op-snap---monthly-publication-july-2025.pdf   179 2025-07 Car Volkswagen Golf White Driving without Due Care and Attention None Bitterscote Drive Bitterscote Drive Out of Force Area Out of Force Area NFA Out of Force      
12134 op-snap---monthly-publication-july-2025.pdf   186 2025-07 Car Toyota Aygo Silver Driving without Due Care and Attention None Himley Road Himley Road Dudley Dudley Court N/A   52.5142667 -2.1304764
12136 op-snap---monthly-publication-july-2025.pdf   188 2025-07 Car Hyundai Kona Black Driving without Due Care and Attention None A45 A45 Coventry Coventry Education N/A      
12139 op-snap---monthly-publication-july-2025.pdf   191 2025-07 Car Vauxhall Movano White Driving without Due Care and Attention None B4115 near Rocky Lane B4115 near Rocky Lane Out of Force Area Out of Force Area NFA Out of Force      
12141 op-snap---monthly-publication-july-2025.pdf   193 2025-07 Car BMW M2 Blue Driving without Due Care and Attention None Kingshurst Way Kingshurst Way Birmingham Birmingham Court N/A      
12142 op-snap---monthly-publication-july-2025.pdf   194 2025-07 Car Tesla model 3 white Driving without Due Care and Attention None A41, Newport, West Mercia A41, Newport, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
12144 op-snap---monthly-publication-july-2025.pdf   196 2025-07 Car BMW M140i White Driving without Due Care and Attention None Langley Road Langley Road Sandwell Sandwell NFA No Offence   52.488131 -2.0079901
12146 op-snap---monthly-publication-july-2025.pdf   198 2025-07 Car Volkswagen Passatt Black Driving without Due Care and Attention None Uplands Road Uplands Road Dudley Dudley RTC - Actioned N/A   52.5009397 -2.0650922
12147 op-snap---monthly-publication-july-2025.pdf   199 2025-07 Car Mg HS Red Driving without Due Care and Attention None Maypole Lane Maypole Lane Birmingham Birmingham RTC - Actioned N/A   52.4046925 -1.8764112
12155 op-snap---monthly-publication-july-2025.pdf   207 2025-07 Car Porsche   Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
12157 op-snap---monthly-publication-july-2025.pdf   209 2025-07 Car Mercedes-Benz E220 Black Driving without Due Care and Attention None Ediburgh Ediburgh Out of Force Area Out of Force Area NFA Out of Force      
12161 op-snap---monthly-publication-july-2025.pdf   213 2025-07 Car Volkswagen Up White Driving without Due Care and Attention None Swan Lane Swan Lane Dudley Dudley NFA No VRM   52.4790844 -2.1511181
12164 op-snap---monthly-publication-july-2025.pdf   216 2025-07 Car Audi A4... Black Driving without Due Care and Attention None A452 Pype Hayes Pype Hayes Birmingham Birmingham Warning Letter N/A   52.5275673 -1.8101068
12167 op-snap---monthly-publication-july-2025.pdf   219 2025-07 Car Yamaha MT 1000 Black Driving without Due Care and Attention No Insurance Jockey Road Jockey Road Sutton Coldfield Sutton Coldfield Court N/A   52.5535276 -1.8302584
12170 op-snap---monthly-publication-july-2025.pdf   222 2025-07 Car Audi A8 Black Driving without Due Care and Attention None Bearwood Road Bearwood Road Birmingham Birmingham Education N/A   52.4762784 -1.9678366
12171 op-snap---monthly-publication-july-2025.pdf   223 2025-07 Car Seat Ibiza Green Driving without Due Care and Attention None Pershore Road Pershore Road Out of Force Area Out of Force Area NFA Out of Force   52.4653873 -1.8988344
12172 op-snap---monthly-publication-july-2025.pdf   224 2025-07 Car Citroen Berlingo White Driving without Due Care and Attention None Fordge Lane Cradley Heath Fordge Lane Cradley Heath Sandwell Sandwell Education N/A      
12176 op-snap---monthly-publication-july-2025.pdf   228 2025-07 Car Ford Transit White Driving without Due Care and Attention None Widdrington Road Widdrington Road Coventry Coventry Education N/A   52.4191764 -1.5105738
12180 op-snap---monthly-publication-july-2025.pdf   232 2025-07 Car BMW 320d Blue Driving without Due Care and Attention None Slaters Lane Slaters Lane Walsall Walsall Education N/A   52.5719978 -2.0041926
12185 op-snap---monthly-publication-july-2025.pdf   237 2025-07 Car Audi Q8 Blue Driving without Due Care and Attention None M6 Motorway M6 Motorway Walsall Walsall Court N/A   52.6151447 -2.0290522
12192 op-snap---monthly-publication-july-2025.pdf   244 2025-07 Car Mercedes-Benz   Black Driving without Due Care and Attention None Stream Road Stream Road Dudley Dudley NFA Outside of 14 Days NIP   52.4871725 -2.1623764
12194 op-snap---monthly-publication-july-2025.pdf   246 2025-07 Car Volkswagen Golf Grey Driving without Due Care and Attention None Highgate Road at Stratford Road Highgate Road at Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4622664 -1.8829508
12197 op-snap---monthly-publication-july-2025.pdf   249 2025-07 Car Vauxhall Astra Grey Driving without Due Care and Attention None Wharf Road Wharf Road Birmingham Birmingham Education N/A   52.4075531 -1.927329
12198 op-snap---monthly-publication-july-2025.pdf   250 2025-07 Car BMW   Grey Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Warning Letter N/A   52.470423 -1.9304786
12201 op-snap---monthly-publication-july-2025.pdf   253 2025-07 Car Peugeot 206 Grey Driving without Due Care and Attention No Insurance Barn Lane Barn Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4307492 -1.8828708
12203 op-snap---monthly-publication-july-2025.pdf   255 2025-07 Car BMW X Drive Blue Driving without Due Care and Attention None Brassington Avenue Brassington Avenue Sutton Coldfield Sutton Coldfield Education N/A   52.5637812 -1.823481
12204 op-snap---monthly-publication-july-2025.pdf   256 2025-07 Car Renault Clio Blue Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Court N/A   52.4726661 -1.8769032
12211 op-snap---monthly-publication-july-2025.pdf   263 2025-07 Car Volvo Lorry Red Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
12213 op-snap---monthly-publication-july-2025.pdf   265 2025-07 Car BMW 318.. White Driving without Due Care and Attention None Bath Row Bath Row Birmingham Birmingham Warning Letter N/A   52.472238 -1.9127983
12215 op-snap---monthly-publication-july-2025.pdf   267 2025-07 Car Yamaha MT-07 Silver Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Education N/A   52.5517052 -1.7825505
12216 op-snap---monthly-publication-july-2025.pdf   268 2025-07 Car Yamaha Kawasaki ZR750 Blue Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Education N/A   52.5517052 -1.7825505
12221 op-snap---monthly-publication-july-2025.pdf   273 2025-07 Car Nissan GT-R Blue Driving without Due Care and Attention None Rumbush Lane Rumbush Lane Birmingham Birmingham Warning Letter N/A      
12222 op-snap---monthly-publication-july-2025.pdf   274 2025-07 Car Mitsubishi Mirage White Driving without Due Care and Attention None St Mary's Row Street Mary's Row Birmingham Birmingham Warning Letter N/A      
12225 op-snap---monthly-publication-july-2025.pdf   277 2025-07 Car Mg Style Grey Driving without Due Care and Attention None Pedmore Road Pedmore Road Dudley Dudley NFA No Independent Evidence Available   52.4897451 -2.1069141
12226 op-snap---monthly-publication-july-2025.pdf   278 2025-07 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Bradford Road Bradford Road Birmingham Birmingham Fixed Penalty N/A   52.5024148 -1.7961753
12228 op-snap---monthly-publication-july-2025.pdf   280 2025-07 Car Mercedes-Benz C class Blue Driving without Due Care and Attention None Monkspath Hall Road East Monkspath Hall Road East Solihull Solihull NFA Outside of 14 Days NIP      
12229 op-snap---monthly-publication-july-2025.pdf   281 2025-07 Car   Kymco Red Driving without Due Care and Attention None Cheadle - Off force Cheadle - Off force Out of Force Area Out of Force Area NFA Out of Force      
12230 op-snap---monthly-publication-july-2025.pdf   282 2025-07 Car Mg Style Grey Driving without Due Care and Attention None Pedmore Road Pedmore Road Dudley Dudley Court N/A   52.4897451 -2.1069141
12231 op-snap---monthly-publication-july-2025.pdf   283 2025-07 Car Mercedes-Benz A class 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      
12233 op-snap---monthly-publication-july-2025.pdf   285 2025-07 Car Peugeot Partner White Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham RTC - Actioned N/A   52.4656414 -1.9852276
12236 op-snap---monthly-publication-july-2025.pdf   288 2025-07 Car   Motorcycle White Driving without Due Care and Attention None Millenium Plaza Millenium Plaza Coventry Coventry NFA No VRM      
12238 op-snap---monthly-publication-july-2025.pdf   290 2025-07 Car Mini Cooper Grey Driving without Due Care and Attention None Walwyn Road Walwyn Road 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);