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

684 rows where month = "2025-07" and offence = "Driving without Due Care and Attention" 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

vehicle_make >30

reporter_transport_mode 8

offence 1

  • Driving without Due Care and Attention · 684 ✖

month 1

  • 2025-07 · 684 ✖
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      
11960 op-snap---monthly-publication-july-2025.pdf   12 2025-07 Pedal Bike Vauxhall Zafira Black Driving without Due Care and Attention None Bearwood Road Bearwood Road Birmingham Birmingham Warning Letter N/A   52.4762784 -1.9678366
11967 op-snap---monthly-publication-july-2025.pdf   19 2025-07 Pedestrian Seat Leon Blue Driving without Due Care and Attention None Heath Road South Heath Road South Birmingham Birmingham NFA No VRM   52.415858 -1.9632649
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
11974 op-snap---monthly-publication-july-2025.pdf   26 2025-07 Pedestrian Kia Sportage White Driving without Due Care and Attention None Heath Road Heath Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.5977729 -2.1078698
11975 op-snap---monthly-publication-july-2025.pdf   27 2025-07 Motorbike Vauxhall Corsa Grey Driving without Due Care and Attention None Tamworth Road Tamworth Road Sutton Coldfield Sutton Coldfield Education N/A   52.5750404 -1.8129485
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
11982 op-snap---monthly-publication-july-2025.pdf   34 2025-07 Pedal Bike   Scania White Driving without Due Care and Attention None Cornets End Lane Cornets End Lane Coventry Coventry Education N/A      
11983 op-snap---monthly-publication-july-2025.pdf   35 2025-07 Pedal Bike Peugeot 208 Black Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
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      
11991 op-snap---monthly-publication-july-2025.pdf   43 2025-07 Pedal Bike Audi A3 Silver Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Wolverhampton Wolverhampton Education N/A   52.5968709 -2.0954054
11992 op-snap---monthly-publication-july-2025.pdf   44 2025-07 Pedal Bike Kia Rio Silver Driving without Due Care and Attention None A38 Tyburn Road Tyburn Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5113867 -1.8337258
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
12007 op-snap---monthly-publication-july-2025.pdf   59 2025-07 Other Audi TT Black Driving without Due Care and Attention None Holbrook Lane Holbrook Lane Coventry Coventry Court N/A   52.436155 -1.5064002
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
12010 op-snap---monthly-publication-july-2025.pdf   62 2025-07 Pedal Bike Volvo V40 Blue Driving without Due Care and Attention None Meer End Road Meer End Road Solihull Solihull Education N/A   52.373396 -1.6335409
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      
12038 op-snap---monthly-publication-july-2025.pdf   90 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull NFA Outside of 14 Days NIP   52.4193964 -1.8252207
12039 op-snap---monthly-publication-july-2025.pdf   91 2025-07 Motorbike Vauxhall Corsa Grey Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5919543 -1.8517118
12040 op-snap---monthly-publication-july-2025.pdf   92 2025-07 Pedal Bike BMW 520.. Black Driving without Due Care and Attention None St Bernards Road Street Bernards Road Solihull Solihull NFA Outside of 14 Days NIP      
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      
12049 op-snap---monthly-publication-july-2025.pdf   101 2025-07 Pedal Bike BMW 320d Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Court N/A   52.5292752 -1.7618805
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
12067 op-snap---monthly-publication-july-2025.pdf   119 2025-07 Pedal Bike Toyota Aygo Silver Driving without Due Care and Attention None Bickenhill Road Bickenhill Road Solihull Solihull Court N/A   52.4640893 -1.7362681
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      
12073 op-snap---monthly-publication-july-2025.pdf   125 2025-07 Pedal Bike Vauxhall astra Red Driving without Due Care and Attention None Forest Road Forest Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4467275 -1.8804014
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
12076 op-snap---monthly-publication-july-2025.pdf   128 2025-07 Other Mercedes-Benz C class Blue Driving without Due Care and Attention None Star City Star City Birmingham Birmingham NFA Not in Public Interest   52.5054363 -1.8556273
12078 op-snap---monthly-publication-july-2025.pdf   130 2025-07 Motorbike Nissan Qashqai Black Driving without Due Care and Attention None Aldersley Road Aldersley Road Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.6058472 -2.1521123
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
12087 op-snap---monthly-publication-july-2025.pdf   139 2025-07 Pedal Bike BMW 116.. White Driving without Due Care and Attention None Bearwood Road Bearwood Road Sandwell Sandwell Education N/A   52.4725977 -1.9684448
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
12092 op-snap---monthly-publication-july-2025.pdf   144 2025-07 Pedestrian     White Driving without Due Care and Attention None Millennium Place Millennium Place Coventry Coventry NFA No VRM   52.4105671 -1.5087697
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
12099 op-snap---monthly-publication-july-2025.pdf   151 2025-07 Pedestrian Nissan Juke Red Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham NFA No Independent Evidence Available   52.4622646 -1.8599985
12107 op-snap---monthly-publication-july-2025.pdf   159 2025-07 Pedestrian Mini Mini Blue Driving without Due Care and Attention None Thorns Road Thorns Road Dudley Dudley NFA Outside of 14 Days NIP   52.4628538 -2.1160108
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
12114 op-snap---monthly-publication-july-2025.pdf   166 2025-07 Other Citroen Berlingo White Driving without Due Care and Attention None Ward Street Ward Street Walsall Walsall NFA Outside of 14 Days NIP   52.5918096 -2.0485738
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      
12121 op-snap---monthly-publication-july-2025.pdf   173 2025-07 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Dorchester Road Dorchester Road Solihull Solihull Court N/A   52.4157911 -1.7926505
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
12125 op-snap---monthly-publication-july-2025.pdf   177 2025-07 Pedal Bike Audi Q5 Blue Driving without Due Care and Attention None Bookvale Road Bookvale Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12126 op-snap---monthly-publication-july-2025.pdf   178 2025-07 Pedal Bike Citroen C3 Blue Driving without Due Care and Attention None City Road City Road Birmingham Birmingham NFA No Offence   52.4763176 -1.9584897
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      
12130 op-snap---monthly-publication-july-2025.pdf   182 2025-07 Pedal Bike Skoda   Black Driving without Due Care and Attention None Witton Road, Witton Lane Witton Road, Witton Lane Birmingham Birmingham NFA No VRM      
12132 op-snap---monthly-publication-july-2025.pdf   184 2025-07 Pedal Bike Daf   White Driving without Due Care and Attention None Gooch st at Bissell St Gooch st at Bissell Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4696234 -1.8952392
12133 op-snap---monthly-publication-july-2025.pdf   185 2025-07 Pedal Bike Volvo Bus Red Driving without Due Care and Attention None Moorend Avenue Moorend Avenue Birmingham Birmingham NFA No Offence      
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

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