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

7,151 rows where offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale

vehicle_make >30

month 14

reporter_transport_mode 11

offence 1

  • Driving without Due Care and Attention · 7,151 ✖
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
7256 op-snap---monthly-publication-february-2026.pdf   3 2026-02 Car Audi A5 Black Driving without Due Care and Attention None A38 A38 Out of Force Area Out of Force Area NFA Out of Force      
7257 op-snap---monthly-publication-february-2026.pdf   4 2026-02 Car Mazda CX30 Grey Driving without Due Care and Attention None High Street, Quarry Bank High Street, Quarry Bank Dudley Dudley Education N/A   52.4576453 -2.1150716
7259 op-snap---monthly-publication-february-2026.pdf   6 2026-02 Car Ford Focus Grey Driving without Due Care and Attention None A46 off force A46 off force Out of Force Area Out of Force Area NFA Out of Force      
7266 op-snap---monthly-publication-february-2026.pdf   13 2026-02 Car Mercedes-Benz CLA 250.. White Driving without Due Care and Attention None Solihull Bypass Solihull Bypass Solihull Solihull Fixed Penalty N/A   52.4207529 -1.7757467
7270 op-snap---monthly-publication-february-2026.pdf   17 2026-02 Car Volkswagen Golf Black Driving without Due Care and Attention None Hydes Road Hydes Road Sandwell Sandwell Court N/A   52.5538064 -2.0139199
7272 op-snap---monthly-publication-february-2026.pdf   19 2026-02 Car Mg HS Black Driving without Due Care and Attention None Russelsheim Way, Rugby Russelsheim Way, Rugby Out of Force Area Out of Force Area NFA Out of Force      
7273 op-snap---monthly-publication-february-2026.pdf   20 2026-02 Car Land Rover Range Rover Black Driving without Due Care and Attention None Footscray Road Footscray Road Out of Force Area Out of Force Area NFA Out of Force      
7275 op-snap---monthly-publication-february-2026.pdf   22 2026-02 Pedal Bike Audi   Silver Driving without Due Care and Attention None B4101 Spring Lane Spring Lane Out of Force Area Out of Force Area NFA Out of Force      
7276 op-snap---monthly-publication-february-2026.pdf   23 2026-02 Car Suzuki Jimny Red Driving without Due Care and Attention None Trumpet Terrace (Cumbria) Trumpet Terrace (Cumbria) Out of Force Area Out of Force Area NFA Out of Force      
7278 op-snap---monthly-publication-february-2026.pdf   25 2026-02 Lorry Mercedes-Benz C220 Grey Driving without Due Care and Attention None M6 north M6 north Solihull Solihull Court N/A   52.4991559 -1.7380439
7281 op-snap---monthly-publication-february-2026.pdf   28 2026-02 Car Mercedes-Benz G63 Black Driving without Due Care and Attention None M6 Toll T8 M6 Toll T8 Out of Force Area Out of Force Area NFA Out of Force   52.5804962 -1.7833098
7282 op-snap---monthly-publication-february-2026.pdf   29 2026-02 Car Toyota Prius White Driving without Due Care and Attention None Telford Trench Telford Trench Out of Force Area Out of Force Area NFA Out of Force      
7291 op-snap---monthly-publication-february-2026.pdf   38 2026-02 Car Peugeot 208 Black Driving without Due Care and Attention None St Peters Drive, Worcester Street Peters Drive, Worcester Out of Force Area Out of Force Area NFA Out of Force      
7297 op-snap---monthly-publication-february-2026.pdf   44 2026-02 Pedal Bike Toyota Prius Red Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
7298 op-snap---monthly-publication-february-2026.pdf   45 2026-02 Pedal Bike Peugeot 3008 Grey Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
7299 op-snap---monthly-publication-february-2026.pdf   46 2026-02 Pedal Bike Toyota Auris Brown Driving without Due Care and Attention None Franklin Road Franklin Road Birmingham Birmingham Education N/A   52.4195456 -1.9350703
7305 op-snap---monthly-publication-february-2026.pdf   52 2026-02 Pedal Bike BMW   Black Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
7311 op-snap---monthly-publication-february-2026.pdf   58 2026-02 Car Audi A7 Black Driving without Due Care and Attention None Aldridge Road Aldridge Road Walsall Walsall NFA No Independent Evidence Available   52.5668693 -1.8879364
7312 op-snap---monthly-publication-february-2026.pdf   59 2026-02 Pedal Bike BMW 218i Blue Driving without Due Care and Attention None Bird Street at White Street Bird Street at White Street Coventry Coventry Education N/A   52.4124171 -1.5065021
7318 op-snap---monthly-publication-february-2026.pdf   65 2026-02 Other BMW 116 Silver Driving without Due Care and Attention None London Road Shrewsbury London Road Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
7319 op-snap---monthly-publication-february-2026.pdf   66 2026-02 Car Mercedes-Benz 160 White Driving without Due Care and Attention None Ringway Queens Ringway Queens Coventry Coventry NFA No Offence   52.4039782 -1.5161639
7322 op-snap---monthly-publication-february-2026.pdf   69 2026-02 Car Kia Rio White Driving without Due Care and Attention None A16 Kirton Kirton Out of Force Area Out of Force Area NFA Out of Force      
7326 op-snap---monthly-publication-february-2026.pdf   73 2026-02 Lorry Volkswagen Crafter Silver Driving without Due Care and Attention None Newport, Staffs Newport, Staffs Out of Force Area Out of Force Area NFA Out of Force      
7330 op-snap---monthly-publication-february-2026.pdf   77 2026-02 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Trittiford Road Trittiford Road Birmingham Birmingham Education N/A   52.4248084 -1.8660294
7342 op-snap---monthly-publication-february-2026.pdf   89 2026-02 Car BMW 116D Red Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham NFA No Offence   52.5170745 -1.9012542
7344 op-snap---monthly-publication-february-2026.pdf   91 2026-02 Car Mini Cooper Black Driving without Due Care and Attention None Telford Way Telford Way Out of Force Area Out of Force Area NFA Out of Force   52.5060705 -1.9763452
7345 op-snap---monthly-publication-february-2026.pdf   92 2026-02 Car BMW X4 White Driving without Due Care and Attention None Witton Road Witton Road Birmingham Birmingham NFA No Offence   52.513336 -1.8833226
7346 op-snap---monthly-publication-february-2026.pdf   93 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None witton road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
7347 op-snap---monthly-publication-february-2026.pdf   94 2026-02 Car Ford Transit White Driving without Due Care and Attention None Streetly Road, Short Heath Streetly Road, Short Heath Birmingham Birmingham Education N/A   52.5316018 -1.8581289
7349 op-snap---monthly-publication-february-2026.pdf   96 2026-02 Pedestrian Nissan Juke Black Driving without Due Care and Attention None Walmley Road Walmley Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5405351 -1.8002219
7353 op-snap---monthly-publication-february-2026.pdf   100 2026-02 Pedal Bike Vauxhall Corsa Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
7356 op-snap---monthly-publication-february-2026.pdf   103 2026-02 Car BMW M340i Grey Driving without Due Care and Attention None Great North Road, Retford Great North Road, Retford Out of Force Area Out of Force Area NFA Out of Force      
7359 op-snap---monthly-publication-february-2026.pdf   106 2026-02 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Greens Road Greens Road Coventry Coventry Education N/A   52.4381927 -1.5291209
7365 op-snap---monthly-publication-february-2026.pdf   112 2026-02 Car Toyota Prius Black Driving without Due Care and Attention None Booth Street, Handsworth Booth Street, Handsworth Birmingham Birmingham Education N/A   52.5039035 -1.9447084
7370 op-snap---monthly-publication-february-2026.pdf   117 2026-02 Car Honda Jazz Red Driving without Due Care and Attention None Birchfield Island Olbury Birchfield Island Olbury Sandwell Sandwell Court N/A      
7372 op-snap---monthly-publication-february-2026.pdf   119 2026-02 Car Vauxhall corsa Red Driving without Due Care and Attention None High Street High Street Dudley Dudley NFA No Offence   52.4779764 -2.1598371
7378 op-snap---monthly-publication-february-2026.pdf   125 2026-02 Bus Vauxhall Astra Grey Driving without Due Care and Attention None Aston Road Aston Road Wolverhampton Wolverhampton Court N/A      
7380 op-snap---monthly-publication-february-2026.pdf   127 2026-02 Pedal Bike Honda Civic Grey Driving without Due Care and Attention None War Lane War Lane Birmingham Birmingham Education N/A   52.4569552 -1.9616483
7381 op-snap---monthly-publication-february-2026.pdf   128 2026-02 Pedal Bike Volvo V60 Black Driving without Due Care and Attention None War Lane War Lane Birmingham Birmingham Education N/A   52.4569552 -1.9616483
7383 op-snap---monthly-publication-february-2026.pdf   130 2026-02 Pedal Bike Mercedes-Benz 180 Grey Driving without Due Care and Attention None Weoley Castle Weoley Castle Birmingham Birmingham Education N/A   52.4428373 -1.9698276
7384 op-snap---monthly-publication-february-2026.pdf   131 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
7387 op-snap---monthly-publication-february-2026.pdf   134 2026-02 Other Volkswagen Golf Blue Driving without Due Care and Attention None Star City Star City Birmingham Birmingham Other Action Taken N/A   52.5054363 -1.8556273
7389 op-snap---monthly-publication-february-2026.pdf   136 2026-02 Pedal Bike Ford Mondeo Grey Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
7390 op-snap---monthly-publication-february-2026.pdf   137 2026-02 Car Volkswagen Tiguan Grey Driving without Due Care and Attention None Church Street Church Street Birmingham Birmingham Education N/A   52.5020781 -1.9122368
7393 op-snap---monthly-publication-february-2026.pdf   140 2026-02 Car Toyota Auris Grey Driving without Due Care and Attention No Insurance Crampers Field Crampers Field Coventry Coventry Court N/A   52.4176927 -1.5257854
7403 op-snap---monthly-publication-february-2026.pdf   150 2026-02 Car Skoda fabia Blue Driving without Due Care and Attention None A45, Kenilworth Road A45, Kenilworth Road Out of Force Area Out of Force Area NFA Out of Force   52.5124557 -1.8917609
7404 op-snap---monthly-publication-february-2026.pdf   151 2026-02 Car Volkswagen Golf Black Driving without Due Care and Attention None A34 Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
7407 op-snap---monthly-publication-february-2026.pdf   154 2026-02 Car Skoda Superb Black Driving without Due Care and Attention None Darmouth Middleway Darmouth Middleway Birmingham Birmingham Fixed Penalty N/A      
7408 op-snap---monthly-publication-february-2026.pdf   155 2026-02 Car BMW 118I Grey Driving without Due Care and Attention None Hall Green Road Hall Green Road Sandwell Sandwell Court N/A   52.5457385 -1.9935809
7413 op-snap---monthly-publication-february-2026.pdf   160 2026-02 Car Ford Kuga Green Driving without Due Care and Attention None Tipton Street Tipton Street Dudley Dudley RTC - Actioned N/A   52.5387558 -2.1179869
7414 op-snap---monthly-publication-february-2026.pdf   161 2026-02 Car       Driving without Due Care and Attention None Walsall Road Walsall Road Walsall Walsall NFA No VRM   52.6166864 -1.9660822
7418 op-snap---monthly-publication-february-2026.pdf   165 2026-02 Car Toyota Prius Silver Driving without Due Care and Attention None Venture Way Venture Way Dudley Dudley Warning Letter N/A   52.4836603 -2.1189326
7419 op-snap---monthly-publication-february-2026.pdf   166 2026-02 Pedal Bike Volvo XC60 White Driving without Due Care and Attention None Bournville Lane Bournville Lane Birmingham Birmingham Education N/A   52.4271614 -1.9302862
7422 op-snap---monthly-publication-february-2026.pdf   169 2026-02 Car Skoda Fabia Blue Driving without Due Care and Attention None Vine Street (Cannock) Vine Street (Cannock) Out of Force Area Out of Force Area NFA Out of Force      
7426 op-snap---monthly-publication-february-2026.pdf   173 2026-02 Pedal Bike Toyota Estima Silver Driving without Due Care and Attention None Weoley Park Road Weoley Park Road Birmingham Birmingham Warning Letter N/A   52.4368136 -1.9495478
7427 op-snap---monthly-publication-february-2026.pdf   174 2026-02 Pedal Bike Chysler Grand Voyager Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
7430 op-snap---monthly-publication-february-2026.pdf   177 2026-02 Pedal Bike Mg ZR Black Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Warning Letter N/A   52.4390303 -1.9512931
7441 op-snap---monthly-publication-february-2026.pdf   188 2026-02 Pedestrian Hyundai I30 Black Driving without Due Care and Attention None Tachbrook Road Tachbrook Road Out of Force Area Out of Force Area NFA Out of Force      
7442 op-snap---monthly-publication-february-2026.pdf   189 2026-02 Pedal Bike Mercedes-Benz E220 Silver Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Court N/A   52.4708802 -1.8792135
7450 op-snap---monthly-publication-february-2026.pdf   197 2026-02 Car Fiat 500 Blue Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Walsall Walsall NFA     52.5867763 -2.0104342
7454 op-snap---monthly-publication-february-2026.pdf   201 2026-02 Pedal Bike Volkswagen Tayron Grey Driving without Due Care and Attention None Hallam Street Hallam Street Birmingham Birmingham Education N/A   52.4563937 -1.8933429
7470 op-snap---monthly-publication-february-2026.pdf   217 2026-02 Pedal Bike Kia Rio Blue Driving without Due Care and Attention None Ansty Road Ansty Road Coventry Coventry Education N/A   52.4205675 -1.4520187
7475 op-snap---monthly-publication-february-2026.pdf   222 2026-02 Car Alfa Romeo Spider White Driving without Due Care and Attention None B4455 B4455 Out of Force Area Out of Force Area NFA Out of Force   52.3994858 -1.4923603
7480 op-snap---monthly-publication-february-2026.pdf   227 2026-02 Car Toyota C-HR Blue Driving without Due Care and Attention None Guarlford Road, Malvern Guarlford Road, Malvern Out of Force Area Out of Force Area NFA Out of Force      
7482 op-snap---monthly-publication-february-2026.pdf   229 2026-02 Pedal Bike Citroen C8 Blue Driving without Due Care and Attention None Ashwood Road (Worcs) Ashwood Road (Worcs) Out of Force Area Out of Force Area NFA Out of Force      
7484 op-snap---monthly-publication-february-2026.pdf   231 2026-02 Car Volkswagen T-Cross Grey Driving without Due Care and Attention None A4040 Church Lane, Perry barr Church Lane, Perry barr Birmingham Birmingham Warning Letter N/A   52.5130255 -1.9220091
7485 op-snap---monthly-publication-february-2026.pdf   232 2026-02 Car Peugeot 2008.. Blue Driving without Due Care and Attention None Island Road Island Road Birmingham Birmingham NFA No Offence   52.5095686 -1.9544485
7489 op-snap---monthly-publication-february-2026.pdf   236 2026-02 Car Toyota Yaris Blue Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
7496 op-snap---monthly-publication-february-2026.pdf   243 2026-02 Car Hyundai I10 Silver Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham Education N/A   52.4622646 -1.8599985
7497 op-snap---monthly-publication-february-2026.pdf   244 2026-02 Car BMW X1 Blue Driving without Due Care and Attention None Torcross Avenue Torcross Avenue Coventry Coventry Education N/A   52.4218194 -1.46546
7498 op-snap---monthly-publication-february-2026.pdf   245 2026-02 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Westwood WAY Westwood WAY Coventry Coventry Education N/A   52.3880214 -1.5797132
7503 op-snap---monthly-publication-february-2026.pdf   250 2026-02 Car Fiat 500 White Driving without Due Care and Attention None M54 Motorway, jn4 M54 Motorway, jn4 Out of Force Area Out of Force Area NFA Out of Force      
7505 op-snap---monthly-publication-february-2026.pdf   252 2026-02 Car Seat Cupra Grey Driving without Due Care and Attention None Sand Pits Sand Pits Birmingham Birmingham Education N/A      
7508 op-snap---monthly-publication-february-2026.pdf   255 2026-02 Pedestrian BMW 325D Blue Driving without Due Care and Attention None Stratford Upon Avon Stratford Upon Avon Out of Force Area Out of Force Area NFA Out of Force   52.3499075 -1.7812051
7509 op-snap---monthly-publication-february-2026.pdf   256 2026-02 Car Skoda Octavia White Driving without Due Care and Attention None Fort Parkway Fort Parkway Birmingham Birmingham Education N/A   52.50787 -1.8195713
7513 op-snap---monthly-publication-february-2026.pdf   260 2026-02 Car Nissan Qashqai Grey Driving without Due Care and Attention None Newport Road Newport Road Birmingham Birmingham Education N/A   52.5027779 -1.7982159
7514 op-snap---monthly-publication-february-2026.pdf   261 2026-02 Pedal Bike Volkswagen Golf Silver Driving without Due Care and Attention None Ridgacre Road Ridgacre Road Birmingham Birmingham Education N/A   52.4593367 -2.0000298
7517 op-snap---monthly-publication-february-2026.pdf   264 2026-02 Pedal Bike Jaguar i-Pace Black Driving without Due Care and Attention None South Road, Stourbridge South Road, Stourbridge Dudley Dudley Education N/A   52.4530371 -2.1660216
7532 op-snap---monthly-publication-february-2026.pdf   279 2026-02 Car Lexus CT200 White Driving without Due Care and Attention None Cross Street South Cross Street South Wolverhampton Wolverhampton Education N/A   52.570955 -2.130838
7534 op-snap---monthly-publication-february-2026.pdf   281 2026-02 Car Mercedes-Benz SLK200 Silver Driving without Due Care and Attention None A51 Birmingham Road Birmingham Road Out of Force Area Out of Force Area NFA Out of Force      
7535 op-snap---monthly-publication-february-2026.pdf   282 2026-02 Car Peugeot 206 Silver Driving without Due Care and Attention None Winding House Lane Winding House Lane Coventry Coventry Education N/A   52.4490457 -1.5001195
7536 op-snap---monthly-publication-february-2026.pdf   283 2026-02 Pedal Bike Mercedes-Benz ML320 Black Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
7537 op-snap---monthly-publication-february-2026.pdf   284 2026-02 Car Renault Megane Silver Driving without Due Care and Attention None Bradley Lane Bradley Lane Birmingham Birmingham NFA No VRM      
7538 op-snap---monthly-publication-february-2026.pdf   285 2026-02 Pedal Bike Ford Transit White Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry Education N/A   52.418488 -1.5472387
7546 op-snap---monthly-publication-february-2026.pdf   293 2026-02 Car Ford Transit Grey Driving without Due Care and Attention None Diss Aldi Carpark (Norfolk) Diss Aldi Carpark (Norfolk) Out of Force Area Out of Force Area NFA Out of Force      
7567 op-snap---monthly-publication-february-2026.pdf   314 2026-02 Car Ford Transit Grey Driving without Due Care and Attention None Friary Road Friary Road Out of Force Area Out of Force Area NFA Out of Force   52.5162814 -1.9395798
7573 op-snap---monthly-publication-february-2026.pdf   320 2026-02 Car Peugeot 2008GT Grey Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
7575 op-snap---monthly-publication-february-2026.pdf   322 2026-02 Other Seat Alteca Grey Driving without Due Care and Attention None Orphange Road / Chester Road Orphange Road / Chester Road Birmingham Birmingham Education N/A      
7576 op-snap---monthly-publication-february-2026.pdf   323 2026-02 Bus Vauxhall Mokka Silver Driving without Due Care and Attention None Brookside Road Brookside Road Out of Force Area Out of Force Area NFA Out of Force      
7577 op-snap---monthly-publication-february-2026.pdf   324 2026-02 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Bromyard Road Bromyard Road Birmingham Birmingham Education N/A   52.4457403 -1.8536648
7579 op-snap---monthly-publication-february-2026.pdf   326 2026-02 Car Kia Xceed Grey Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
7581 op-snap---monthly-publication-february-2026.pdf   328 2026-02 Other Jaguar u/k Blue Driving without Due Care and Attention None Long Bank Long Bank Out of Force Area Out of Force Area NFA Out of Force   52.5785967 -2.0581007
7590 op-snap---monthly-publication-february-2026.pdf   337 2026-02 Car Volkswagen Polo White Driving without Due Care and Attention None Cole Bank Road Cole Bank Road Birmingham Birmingham Court N/A   52.4349375 -1.8510007
7593 op-snap---monthly-publication-february-2026.pdf   340 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None Walford Road Walford Road Birmingham Birmingham Court N/A   52.4594072 -1.8658859
7596 op-snap---monthly-publication-february-2026.pdf   343 2026-02 Car Citroen C3.. White Driving without Due Care and Attention None New John Street West New John Street West Birmingham Birmingham Education N/A   52.4944784 -1.9122329
7597 op-snap---monthly-publication-february-2026.pdf   344 2026-02 Car Citroen C3 Silver Driving without Due Care and Attention None Barnes Hill Barnes Hill Birmingham Birmingham Warning Letter N/A   52.4401325 -1.9785938
7600 op-snap---monthly-publication-february-2026.pdf   347 2026-02 Car Peugeot 208 Silver Driving without Due Care and Attention None KENT Kent Out of Force Area Out of Force Area NFA Out of Force   52.4719651 -1.8980931
7601 op-snap---monthly-publication-february-2026.pdf   348 2026-02 Pedestrian Fiat Mylife Blue Driving without Due Care and Attention None Briar Close Briar Close Out of Force Area Out of Force Area NFA Out of Force   52.5215268 -1.8348724
7603 op-snap---monthly-publication-february-2026.pdf   350 2026-02 Car Hyundai 130 Blue Driving without Due Care and Attention None A46 Coventry Coventry Coventry Coventry Education N/A   52.400739 -1.5135474
7604 op-snap---monthly-publication-february-2026.pdf   351 2026-02 Car BMW X5 Grey Driving without Due Care and Attention None M6 Junction 15 M6 Junction 15 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582

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