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

261 rows where disposal = "NFA", month = "2025-10" 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 · 261 ✖

month 1

  • 2025-10 · 261 ✖

disposal 1

  • NFA · 261 ✖
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
22055 op-snap---monthly-publication-october-2025.pdf   5 2025-10 Car BMW 116d White Driving without Due Care and Attention None B4188 Belbroughton Belbroughton Out of Force Area Out of Force Area NFA Out of Force      
22058 op-snap---monthly-publication-october-2025.pdf   8 2025-10 Car Audi SQ7 Blue Driving without Due Care and Attention None Bilston Street Bilston Street Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.5838892 -2.1231759
22066 op-snap---monthly-publication-october-2025.pdf   16 2025-10 Car Skoda Octavia Silver Driving without Due Care and Attention None Harmer Hill Harmer Hill Out of Force Area Out of Force Area NFA Out of Force      
22067 op-snap---monthly-publication-october-2025.pdf   17 2025-10 Car Nissan Micra Silver Driving without Due Care and Attention None M6 SB J6 M6 Southbound J6 Birmingham Birmingham NFA No Independent Evidence Available   52.676119 -2.0858425
22069 op-snap---monthly-publication-october-2025.pdf   19 2025-10 Car Skoda Fabia Red Driving without Due Care and Attention None A642, Wakefield A642, Wakefield Out of Force Area Out of Force Area NFA Out of Force   52.5496838 -1.8385006
22071 op-snap---monthly-publication-october-2025.pdf   21 2025-10 Car Suzuki Swift Red Driving without Due Care and Attention None A5 Oswestry Oswestry Out of Force Area Out of Force Area NFA Out of Force      
22072 op-snap---monthly-publication-october-2025.pdf   22 2025-10 Car BMW X5 Black Driving without Due Care and Attention None Styvechale Styvechale Coventry Coventry NFA No Offence   52.3834202 -1.5132278
22075 op-snap---monthly-publication-october-2025.pdf   25 2025-10 Car BMW   Silver Driving without Due Care and Attention None M54 M54 Out of Force Area Out of Force Area NFA Out of Force      
22081 op-snap---monthly-publication-october-2025.pdf   31 2025-10 Car Vauxhall Corsa White Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham NFA No Independent Evidence Available   52.4804926 -1.8563658
22102 op-snap---monthly-publication-october-2025.pdf   52 2025-10 Pedal Bike BMW 435.. Black Driving without Due Care and Attention None Allesley Road Allesley Road Coventry Coventry NFA Outside of 14 Days NIP   52.412663 -1.5443742
22115 op-snap---monthly-publication-october-2025.pdf   65 2025-10 Car Ford Transit Silver Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham NFA No Offence      
22116 op-snap---monthly-publication-october-2025.pdf   66 2025-10 Car Ford Transit Silver Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham NFA No Offence      
22117 op-snap---monthly-publication-october-2025.pdf   67 2025-10 Car Volkswagen Golf Grey Driving without Due Care and Attention None A435 A435 Birmingham Birmingham NFA Outside of 14 Days NIP      
22122 op-snap---monthly-publication-october-2025.pdf   72 2025-10 Pedal Bike Skoda Octavia Silver Driving without Due Care and Attention None Hurst Road Hurst Road Coventry Coventry NFA No Offence   52.4496884 -1.4816181
22127 op-snap---monthly-publication-october-2025.pdf   77 2025-10 Car   Electric Scooter Black Driving without Due Care and Attention None Marshbrook Way Telford (West Mercia) Marshbrook Way Telford (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
22128 op-snap---monthly-publication-october-2025.pdf   78 2025-10 Car Vauxhall Combo White Driving without Due Care and Attention None Lozells Road Lozells Road Birmingham Birmingham NFA No Offence   52.502683 -1.9033516
22140 op-snap---monthly-publication-october-2025.pdf   90 2025-10 Car Volkswagen Polo Black Driving without Due Care and Attention None M51 J1-J2 M51 J1-J2 Out of Force Area Out of Force Area NFA Out of Force      
22145 op-snap---monthly-publication-october-2025.pdf   95 2025-10 Car Ford   White Driving without Due Care and Attention None Chesterton Way, Tamworth Chesterton Way, Tamworth Out of Force Area Out of Force Area NFA Out of Force      
22146 op-snap---monthly-publication-october-2025.pdf   96 2025-10 Car Hyundai   Grey Driving without Due Care and Attention None Donnington Wood Way, Telford Donnington Wood Way, Telford Out of Force Area Out of Force Area NFA Out of Force      
22157 op-snap---monthly-publication-october-2025.pdf   107 2025-10 Pedal Bike Mazda 3 Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5872149 -1.8300386
22159 op-snap---monthly-publication-october-2025.pdf   109 2025-10 Car Ford Focus Black Driving without Due Care and Attention None B4387 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
22174 op-snap---monthly-publication-october-2025.pdf   124 2025-10 Car Mini Mini Grey Driving without Due Care and Attention None Dudley Road Dudley Road Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.4877352 -1.9494469
22175 op-snap---monthly-publication-october-2025.pdf   125 2025-10 Motorbike BMW 330d White Driving without Due Care and Attention None A46 Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force   52.3837388 -1.5529669
22184 op-snap---monthly-publication-october-2025.pdf   134 2025-10 Car Citroen C4 Blue Driving without Due Care and Attention None Essington Road New Invention Essington Road New Invention Wolverhampton Wolverhampton NFA No VRM      
22192 op-snap---monthly-publication-october-2025.pdf   142 2025-10 Car Mercedes-Benz   White Driving without Due Care and Attention None Green Street Green Street Out of Force Area Out of Force Area NFA Out of Force   52.4737217 -1.8844945
22195 op-snap---monthly-publication-october-2025.pdf   145 2025-10 Pedal Bike Dennis Alexander White Driving without Due Care and Attention None Sharmans Cross Sharmans Cross Solihull Solihull NFA Outside of 14 Days NIP   52.4151594 -1.8062462
22196 op-snap---monthly-publication-october-2025.pdf   146 2025-10 Pedal Bike Renault Modus Silver Driving without Due Care and Attention None Stroud Road Stroud Road Solihull Solihull NFA Outside of 14 Days NIP   52.4085712 -1.8432138
22197 op-snap---monthly-publication-october-2025.pdf   147 2025-10 Car Land Rover Land Rover Grey Driving without Due Care and Attention None Old Snow Hill Old Snow Hill Birmingham Birmingham NFA No Offence   52.4858844 -1.9003652
22204 op-snap---monthly-publication-october-2025.pdf   154 2025-10 Pedal Bike   Bus Grey Driving without Due Care and Attention None White Street White Street Birmingham Birmingham NFA No VRM   52.4555554 -1.8782841
22210 op-snap---monthly-publication-october-2025.pdf   160 2025-10 Pedestrian   Subara Blue Driving without Due Care and Attention None Tesco Car Park, Stourbridge Tesco Car Park, Stourbridge Dudley Dudley NFA Outside of 14 Days NIP   52.4530893 -2.0628772
22212 op-snap---monthly-publication-october-2025.pdf   162 2025-10 Car Toyota C-HR Black Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA Outside of 14 Days NIP   52.4235908 -1.5226276
22213 op-snap---monthly-publication-october-2025.pdf   163 2025-10 Car Volkswagen   Grey Driving without Due Care and Attention None Ring Road Ring Road Coventry Coventry NFA Outside of 14 DAYS Late Submission      
22214 op-snap---monthly-publication-october-2025.pdf   164 2025-10 Car Land Rover Discovery Red Driving without Due Care and Attention None Mill Street, Evesham, Mill Street, Evesham Out of Force Area Out of Force Area NFA Out of Force      
22219 op-snap---monthly-publication-october-2025.pdf   169 2025-10 Car Toyota Yaris Grey Driving without Due Care and Attention None A491 High Street Stourbridge High Street Stourbridge Dudley Dudley NFA Not in Public Interest   52.4570763 -2.1136199
22222 op-snap---monthly-publication-october-2025.pdf   172 2025-10 Car Toyota Auris Silver Driving without Due Care and Attention None Wood Green Road Wood Green Road Walsall Walsall NFA No Offence   52.6248989 -1.9343969
22224 op-snap---monthly-publication-october-2025.pdf   174 2025-10 Car BMW   Blue Driving without Due Care and Attention None Upper Eastern Green Lane, Upper Eastern Green Lane Coventry Coventry NFA No VRM   52.4171593 -1.5860076
22228 op-snap---monthly-publication-october-2025.pdf   178 2025-10 Car BMW 320D White Driving without Due Care and Attention None Anderton Road Anderton Road Coventry Coventry NFA Outside of 14 Days NIP   52.4519205 -1.4736655
22229 op-snap---monthly-publication-october-2025.pdf   179 2025-10 Car Volvo V40 Blue Driving without Due Care and Attention None A4540 Monument Road Monument Road Birmingham Birmingham NFA No Offence   52.4731312 -1.930947
22231 op-snap---monthly-publication-october-2025.pdf   181 2025-10 Car Toyota Auris Silver Driving without Due Care and Attention None Woodrow Drive Woodrow Drive Out of Force Area Out of Force Area NFA Out of Force      
22235 op-snap---monthly-publication-october-2025.pdf   185 2025-10 Pedestrian     White Driving without Due Care and Attention None Newtown Newtown Birmingham Birmingham NFA No Independent Evidence Available   52.4978509 -1.8963733
22243 op-snap---monthly-publication-october-2025.pdf   193 2025-10 Car Tesla   White Driving without Due Care and Attention None Common Road Common Road Out of Force Area Out of Force Area NFA Out of Force   52.6253951 -1.9696087
22249 op-snap---monthly-publication-october-2025.pdf   199 2025-10 Car Ford Focus Silver Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
22252 op-snap---monthly-publication-october-2025.pdf   202 2025-10 Car Volvo   Green Driving without Due Care and Attention None A5 A5 Out of Force Area Out of Force Area NFA Out of Force      
22255 op-snap---monthly-publication-october-2025.pdf   205 2025-10 car Audi A3 White Driving without Due Care and Attention None Three Tuns Island Three Tuns Island Birmingham Birmingham NFA No Offence      
22256 op-snap---monthly-publication-october-2025.pdf   206 2025-10 Car BMW 330 Sport Grey Driving without Due Care and Attention None Stafford Road Stafford Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.6291998 -2.126312
22260 op-snap---monthly-publication-october-2025.pdf   210 2025-10 Car Mercedes-Benz E63 S Black Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham NFA No Independent Evidence Available   52.5517052 -1.7825505
22261 op-snap---monthly-publication-october-2025.pdf   211 2025-10 Car BMW 3 series Grey Driving without Due Care and Attention None Bosworth Road Bosworth Road Birmingham Birmingham NFA No Independent Evidence Available   52.4515515 -1.8074346
22262 op-snap---monthly-publication-october-2025.pdf   212 2025-10 Car Tesla Y White Driving without Due Care and Attention None Richmond Road Richmond Road Birmingham Birmingham NFA No Independent Evidence Available   52.566947 -1.8291809
22267 op-snap---monthly-publication-october-2025.pdf   217 2025-10 Car Ford Transit White Driving without Due Care and Attention None M42 Motorway northbound 5-6 M42 Motorway northbound 5-6 Solihull Solihull NFA No VRM      
22271 op-snap---monthly-publication-october-2025.pdf   221 2025-10 Pedal Bike Daf Lorry white Driving without Due Care and Attention None Broad Lane, Coventry Broad Lane, Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4144409 -1.5990259
22272 op-snap---monthly-publication-october-2025.pdf   222 2025-10 Car Mercedes-Benz E250 Silver Driving without Due Care and Attention None Kingston Road Kingston Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4747333 -1.8728345
22285 op-snap---monthly-publication-october-2025.pdf   235 2025-10 Pedal Bike Lexus ES300 Black Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.5020639 -1.9026192
22288 op-snap---monthly-publication-october-2025.pdf   238 2025-10 Car Ford Fiesta Red Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.471632 -1.9456776
22293 op-snap---monthly-publication-october-2025.pdf   243 2025-10 Other Ford Fiesta Grey Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley NFA No Offence      
22295 op-snap---monthly-publication-october-2025.pdf   245 2025-10 Pedal Bike Hyundai I20 Black Driving without Due Care and Attention None Brookvale Road Brookvale Road Birmingham Birmingham NFA No VRM   52.5219365 -1.8755325
22296 op-snap---monthly-publication-october-2025.pdf   246 2025-10 Car BMW M140i White Driving without Due Care and Attention None M6 EB J3 M6 Eb J3 Out of Force Area Out of Force Area NFA Out of Force   52.6912652 -2.1043715
22298 op-snap---monthly-publication-october-2025.pdf   248 2025-10 Car Toyota Yaris Red Driving without Due Care and Attention None A452 A452 Birmingham Birmingham NFA Not in Public Interest      
22307 op-snap---monthly-publication-october-2025.pdf   257 2025-10 Car BMW 330e Black Driving without Due Care and Attention None Small Heath bypass Small Heath bypass Birmingham Birmingham NFA No Offence      
22309 op-snap---monthly-publication-october-2025.pdf   259 2025-10 Car Ford Transit Silver Driving without Due Care and Attention None Winson Green Road Winson Green Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4870332 -1.9373713
22313 op-snap---monthly-publication-october-2025.pdf   263 2025-10 Car Volkswagen Tiguan Grey Driving without Due Care and Attention None M54 WB J6-7 M54 Wb J6-7 Out of Force Area Out of Force Area NFA Out of Force      
22323 op-snap---monthly-publication-october-2025.pdf   273 2025-10 Car Volkswagen Golf White Driving without Due Care and Attention None M42 J10 Tamworth M42 J10 Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.6020492 -1.6329003
22326 op-snap---monthly-publication-october-2025.pdf   276 2025-10 Car Volkswagen Golf Silver Driving without Due Care and Attention None Witton Lane Witton Lane Birmingham Birmingham NFA No Offence   52.5066691 -1.8808253
22328 op-snap---monthly-publication-october-2025.pdf   278 2025-10 Pedal Bike Toyota   Black Driving without Due Care and Attention None 6 Ways 6 Ways Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4728311 -1.9185712
22330 op-snap---monthly-publication-october-2025.pdf   280 2025-10 Car Ford KA.. Red Driving without Due Care and Attention None Berkeley Road East Berkeley Road East Birmingham Birmingham NFA No Offence   52.4658801 -1.8290005
22331 op-snap---monthly-publication-october-2025.pdf   281 2025-10 Other Audi A3 Black Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley NFA No Offence      
22336 op-snap---monthly-publication-october-2025.pdf   286 2025-10 Pedal Bike   Bus White Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull NFA No Offence   52.4144779 -1.7848758
22344 op-snap---monthly-publication-october-2025.pdf   294 2025-10 Lorry Ford S-max Red Driving without Due Care and Attention None Sandford Avenue, Church Stretton Sandford Avenue, Church Stretton Out of Force Area Out of Force Area NFA Out of Force      
22345 op-snap---monthly-publication-october-2025.pdf   295 2025-10 Pedal Bike Hyundai Ioniq White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
22346 op-snap---monthly-publication-october-2025.pdf   296 2025-10 Pedal Bike Peugeot 2008.. Grey Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5359496 -1.8324115
22349 op-snap---monthly-publication-october-2025.pdf   299 2025-10 Car Land Rover Range Rover Gold Driving without Due Care and Attention None M6 Staffs M6 Staffs Out of Force Area Out of Force Area NFA Out of Force   52.6170728 -2.030393
22351 op-snap---monthly-publication-october-2025.pdf   301 2025-10 Car Toyota Prius Silver Driving without Due Care and Attention None School Road, Yardley Wood School Road, Yardley Wood Birmingham Birmingham NFA No Independent Evidence Available   52.4135867 -1.8703299
22353 op-snap---monthly-publication-october-2025.pdf   303 2025-10 Car Volvo XC60. Gold Driving without Due Care and Attention None Berskwell Road Berskwell Road Coventry Coventry NFA No Offence      
22358 op-snap---monthly-publication-october-2025.pdf   308 2025-10 Car Mercedes-Benz HGV White Driving without Due Care and Attention None M40 NB M40 Northbound Out of Force Area Out of Force Area NFA Out of Force      
22359 op-snap---monthly-publication-october-2025.pdf   309 2025-10 Car Land Rover Vogue Brown Driving without Due Care and Attention None M40 NB M40 Northbound Out of Force Area Out of Force Area NFA Out of Force      
22361 op-snap---monthly-publication-october-2025.pdf   311 2025-10 Car Porsche Cayenne Grey Driving without Due Care and Attention None Ladywood Middleway Ladywood Middleway Birmingham Birmingham NFA No Offence   52.473883 -1.9198244
22362 op-snap---monthly-publication-october-2025.pdf   312 2025-10 Car Ford tansit White Driving without Due Care and Attention None M42 Tamworth M42 Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.5751647 -1.8118902
22363 op-snap---monthly-publication-october-2025.pdf   313 2025-10 Car Ford Transit Grey Driving without Due Care and Attention None Manor Way / Hagley Road Manor Way / Hagley Road Dudley Dudley NFA No Offence   52.4493861 -2.0168307
22364 op-snap---monthly-publication-october-2025.pdf   314 2025-10 Car Audi   Grey Driving without Due Care and Attention None Jockey Road Jockey Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5535276 -1.8302584
22373 op-snap---monthly-publication-october-2025.pdf   323 2025-10 Pedal Bike BMW M340 Grey Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
22374 op-snap---monthly-publication-october-2025.pdf   324 2025-10 Car Ford fiesta silver Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
22375 op-snap---monthly-publication-october-2025.pdf   325 2025-10 Other Renault   Grey Driving without Due Care and Attention None Station Road Station Road Birmingham Birmingham NFA No Independent Evidence Available   52.5054559 -1.9506109
22376 op-snap---monthly-publication-october-2025.pdf   326 2025-10 Car BMW X3 M White Driving without Due Care and Attention None M5 S/B, Jn3 M5 Southbound, Jn3 Birmingham Birmingham NFA Outside of 14 Days NIP      
22384 op-snap---monthly-publication-october-2025.pdf   334 2025-10 Car Kia Soul Black Driving without Due Care and Attention None A4440 Grove Way, Worcester Grove Way, Worcester Out of Force Area Out of Force Area NFA Out of Force      
22385 op-snap---monthly-publication-october-2025.pdf   335 2025-10 Pedal Bike Kia Picanto Blue Driving without Due Care and Attention None Boleyn Road, Rubery Boleyn Road, Rubery Birmingham Birmingham NFA No Offence      
22386 op-snap---monthly-publication-october-2025.pdf   336 2025-10 Pedal Bike   Wrightbus Blue Driving without Due Care and Attention None Gannow Green Lane Gannow Green Lane Birmingham Birmingham NFA No Offence   52.4023845 -2.0336492
22388 op-snap---monthly-publication-october-2025.pdf   338 2025-10 Car Renault Twingo Black Driving without Due Care and Attention None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley NFA No VRM   52.4590366 -2.1465735
22396 op-snap---monthly-publication-october-2025.pdf   346 2025-10 Car Seat Leon White Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham NFA No Independent Evidence Available   52.5194011 -1.8008643
22403 op-snap---monthly-publication-october-2025.pdf   353 2025-10 Car Skoda Kodiaq Grey Driving without Due Care and Attention None Eastern Green Road Eastern Green Road Coventry Coventry NFA No Independent Evidence Available   52.4131188 -1.5784769
22414 op-snap---monthly-publication-october-2025.pdf   364 2025-10 Car Peugeot Boxer Grey Driving without Due Care and Attention None Joynes Road, Droitwich Joynes Road, Droitwich Out of Force Area Out of Force Area NFA Out of Force      
22418 op-snap---monthly-publication-october-2025.pdf   368 2025-10 Car Audi A6 Black Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA No Offence      
22419 op-snap---monthly-publication-october-2025.pdf   369 2025-10 Car Toyota Yaris Black Driving without Due Care and Attention None Berkley Road East Berkley Road East Birmingham Birmingham NFA Outside of 14 Days NIP      
22421 op-snap---monthly-publication-october-2025.pdf   371 2025-10 Car Land Rover Range Rover Black Driving without Due Care and Attention None Warwick Highway, Redditch Warwick Highway, Redditch Out of Force Area Out of Force Area NFA Out of Force      
22430 op-snap---monthly-publication-october-2025.pdf   380 2025-10 Pedal Bike Audi Q2 Grey Driving without Due Care and Attention None Wychwood Avenue Wychwood Avenue Solihull Solihull NFA No Independent Evidence Available   52.3973125 -1.7370127
22434 op-snap---monthly-publication-october-2025.pdf   384 2025-10 Car Audi A3 Grey Driving without Due Care and Attention None Heathcote Road Heathcote Road Birmingham Birmingham NFA No VRM   52.4202959 -1.9249997
22437 op-snap---monthly-publication-october-2025.pdf   387 2025-10 Pedal Bike Renault Master White Driving without Due Care and Attention None Wood Lane, Lower Stonnall Wood Lane, Lower Stonnall Out of Force Area Out of Force Area NFA Out of Force      
22440 op-snap---monthly-publication-october-2025.pdf   390 2025-10 Car Audi A5 Black Driving without Due Care and Attention None Coleshill Heath Road Coleshill Heath Road Solihull Solihull NFA No Offence   52.4667242 -1.7283592
22441 op-snap---monthly-publication-october-2025.pdf   391 2025-10 Car Peugeot 3008GT Red Driving without Due Care and Attention None Bridgenorth Bridgenorth Out of Force Area Out of Force Area NFA Out of Force      
22444 op-snap---monthly-publication-october-2025.pdf   394 2025-10 Pedal Bike BMW 320d Silver Driving without Due Care and Attention None Coventry Road, Tamworth Coventry Road, Tamworth Out of Force Area Out of Force Area NFA Out of Force      
22449 op-snap---monthly-publication-october-2025.pdf   399 2025-10 Pedal Bike Renault Clio White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry NFA No Offence   52.4047134 -1.5351834
22450 op-snap---monthly-publication-october-2025.pdf   400 2025-10 Car Lexus   White Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA No Independent Evidence Available   52.4235908 -1.5226276

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