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

442 rows where month = "2026-01" 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 9

offence 1

  • Driving without Due Care and Attention · 442 ✖

month 1

  • 2026-01 · 442 ✖
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
10539 op-snap---monthly-publication-january-2026.pdf   0 2026-01 Car Mercedes-Benz GLC 300 Silver Driving without Due Care and Attention None High Street, Bloxwich High Street, Bloxwich Walsall Walsall Education N/A   52.6142343 -2.0043397
10542 op-snap---monthly-publication-january-2026.pdf   3 2026-01 Car Volkswagen Golf Silver Driving without Due Care and Attention None M42 near birmingham airport M42 near birmingham airport Birmingham Birmingham Warning Letter N/A      
10546 op-snap---monthly-publication-january-2026.pdf   7 2026-01 Car Mitsubishi Eclipse Black Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull NFA No Offence   52.4191184 -1.8326637
10551 op-snap---monthly-publication-january-2026.pdf   12 2026-01 Car Lexus IS 250 Grey Driving without Due Care and Attention None Coventry Ring Road Coventry Ring Road Coventry Coventry Education N/A      
10552 op-snap---monthly-publication-january-2026.pdf   13 2026-01 Other Audi A5 Grey Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
10553 op-snap---monthly-publication-january-2026.pdf   14 2026-01 Car Toyota Avensis Silver Driving without Due Care and Attention None M6 NB J3 M6 Northbound J3 Coventry Coventry NFA No Independent Evidence Available   52.6760749 -2.0862582
10557 op-snap---monthly-publication-january-2026.pdf   18 2026-01 Pedal Bike Toyota Avensis Silver Driving without Due Care and Attention None Robin Hood lane Robin Hood lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
10558 op-snap---monthly-publication-january-2026.pdf   19 2026-01 Pedal Bike Volkswagen Polo Black Driving without Due Care and Attention No vehicle excise licence Brook Lane Brook Lane Birmingham Birmingham Court N/A   52.4297007 -1.8668846
10560 op-snap---monthly-publication-january-2026.pdf   21 2026-01 Car Honda Civic Grey Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall Education N/A   52.5692139 -1.8799672
10563 op-snap---monthly-publication-january-2026.pdf   24 2026-01 Car Mercedes-Benz C220. Grey Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Fixed Penalty N/A   52.4092804 -1.8056214
10566 op-snap---monthly-publication-january-2026.pdf   27 2026-01 Car Audi A4.. Black Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Fixed Penalty N/A   52.4092804 -1.8056214
10569 op-snap---monthly-publication-january-2026.pdf   30 2026-01 Other Seat Ibiza Red Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
10570 op-snap---monthly-publication-january-2026.pdf   31 2026-01 Car Mazda 6 SE-L Grey Driving without Due Care and Attention None Foleshill Road Foleshill Road Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4274335 -1.5002381
10572 op-snap---monthly-publication-january-2026.pdf   33 2026-01 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Unknown   Birmingham Birmingham NFA No Independent Evidence Available      
10574 op-snap---monthly-publication-january-2026.pdf   35 2026-01 Car Audi A1 Black Driving without Due Care and Attention None M5 SB J3 M5 Southbound J3 Birmingham Birmingham NFA No Offence   52.4846642 -1.9297585
10575 op-snap---monthly-publication-january-2026.pdf   36 2026-01 Other BMW NK White Driving without Due Care and Attention None Unknown   Dudley Dudley NFA No Independent Evidence Available      
10576 op-snap---monthly-publication-january-2026.pdf   37 2026-01 Other BMW 330E White Driving without Due Care and Attention No vehicle excise licence Tulip Avenue Tulip Avenue Dudley Dudley NFA No Independent Evidence Available      
10577 op-snap---monthly-publication-january-2026.pdf   38 2026-01 Car Audi A3 Blue Driving without Due Care and Attention None Cuckoo Road Cuckoo Road Birmingham Birmingham Fixed Penalty N/A   52.5049023 -1.8603659
10578 op-snap---monthly-publication-january-2026.pdf   39 2026-01 Other BMW 330E White Driving without Due Care and Attention No vehicle excise licence Tulip Avenue Tulip Avenue Dudley Dudley NFA No Independent Evidence Available      
10579 op-snap---monthly-publication-january-2026.pdf   40 2026-01 Pedal Bike Ford Transit Green Driving without Due Care and Attention None Alwood Road Alwood Road Birmingham Birmingham Warning Letter N/A      
10580 op-snap---monthly-publication-january-2026.pdf   41 2026-01 Pedal Bike Honda CR-V Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
10581 op-snap---monthly-publication-january-2026.pdf   42 2026-01 Pedal Bike   Bus   Driving without Due Care and Attention None War Lane War Lane Birmingham Birmingham Warning Letter N/A   52.4569552 -1.9616483
10582 op-snap---monthly-publication-january-2026.pdf   43 2026-01 Car Polestar   White Driving without Due Care and Attention None A45 A45 Coventry Coventry Warning Letter N/A      
10584 op-snap---monthly-publication-january-2026.pdf   45 2026-01 Car Audi Q3.. Black Driving without Due Care and Attention None Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
10585 op-snap---monthly-publication-january-2026.pdf   46 2026-01 Car Nissan Micra White Driving without Due Care and Attention No Insurance Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
10587 op-snap---monthly-publication-january-2026.pdf   48 2026-01 Pedestrian Yamaha gpd125 Grey Driving without Due Care and Attention None bishopsgate street Bishopsgate Street Birmingham Birmingham Warning Letter N/A   52.473986 -1.9147087
10597 op-snap---monthly-publication-january-2026.pdf   58 2026-01 Other Land Rover 414.. Red Driving without Due Care and Attention None Waterfront main car park Waterfront main car park Dudley Dudley Warning Letter N/A      
10598 op-snap---monthly-publication-january-2026.pdf   59 2026-01 Car Mercedes-Benz A200.. Grey Driving without Due Care and Attention None A41 Newport towards Market Drayton Newport towards Market Drayton Out of Force Area Out of Force Area NFA Out of Force      
10599 op-snap---monthly-publication-january-2026.pdf   60 2026-01 Car Man HGV White Driving without Due Care and Attention None A46 Stratford towards Evesham Stratford towards Evesham Out of Force Area Out of Force Area NFA Out of Force      
10600 op-snap---monthly-publication-january-2026.pdf   61 2026-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Swan Island Swan Island Birmingham Birmingham RTC - Actioned N/A   52.4616042 -1.8154705
10601 op-snap---monthly-publication-january-2026.pdf   62 2026-01 Car Audi RSQ7 White Driving without Due Care and Attention None M42 near M40 junc M42 near M40 junc Solihull Solihull Warning Letter N/A      
10603 op-snap---monthly-publication-january-2026.pdf   64 2026-01 Car Seat Leon Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
10604 op-snap---monthly-publication-january-2026.pdf   65 2026-01 Other Audi Q7 Blue Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
10605 op-snap---monthly-publication-january-2026.pdf   66 2026-01 Car   Irizar Coach White Driving without Due Care and Attention None St Chads Queensway Street Chads Queensway Birmingham Birmingham Warning Letter N/A      
10607 op-snap---monthly-publication-january-2026.pdf   68 2026-01 Pedal Bike Vauxhall Insignia White Driving without Due Care and Attention None Lower Broad Heath (worcester) Lower Broad Heath (worcester) Out of Force Area Out of Force Area NFA Out of Force      
10608 op-snap---monthly-publication-january-2026.pdf   69 2026-01 Car Volkswagen Scirocco Black Driving without Due Care and Attention None M6 to M5 junction M6 to M5 junction Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.6912891 -2.1046372
10609 op-snap---monthly-publication-january-2026.pdf   70 2026-01 Car Mercedes-Benz CLA250.. White Driving without Due Care and Attention None M5 Jct 23 (Weston) M5 Junction 23 (Weston) Out of Force Area Out of Force Area NFA Out of Force      
10611 op-snap---monthly-publication-january-2026.pdf   72 2026-01 Car Toyota Yaris Silver Driving without Due Care and Attention None Lincoln Morland Avenue, Lincoln Lincoln Morland Avenue, Lincoln Out of Force Area Out of Force Area NFA Out of Force      
10612 op-snap---monthly-publication-january-2026.pdf   73 2026-01 Car Suzuki SX4 white Driving without Due Care and Attention None Jn9 M6 Jn9 M6 Walsall Walsall Education N/A      
10628 op-snap---monthly-publication-january-2026.pdf   89 2026-01 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Warning Letter N/A   52.4297007 -1.8668846
10629 op-snap---monthly-publication-january-2026.pdf   90 2026-01 Car Mazda 3 TS Black Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4470686 -1.8880749
10630 op-snap---monthly-publication-january-2026.pdf   91 2026-01 Pedestrian BMW 3 series White Driving without Due Care and Attention None Navigation Street Navigation Street Walsall Walsall NFA No Independent Evidence Available   52.5842791 -1.9872353
10637 op-snap---monthly-publication-january-2026.pdf   98 2026-01 Car Ford Ranger White Driving without Due Care and Attention None Collector Road Collector Road Birmingham Birmingham NFA No Offence   52.5139393 -1.7600186
10639 op-snap---monthly-publication-january-2026.pdf   100 2026-01 Car Mitsubishi Outlander Grey Driving without Due Care and Attention None School Road School Road Birmingham Birmingham Education N/A   52.4161736 -1.8619692
10640 op-snap---monthly-publication-january-2026.pdf   101 2026-01 Other BMW 3 series blue Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10641 op-snap---monthly-publication-january-2026.pdf   102 2026-01 Other BMW 3 series black Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10642 op-snap---monthly-publication-january-2026.pdf   103 2026-01 Car Volkswagen Golf Grey Driving without Due Care and Attention None Wolverhampton Road South Wolverhampton Road South Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.463146 -1.9844677
10643 op-snap---monthly-publication-january-2026.pdf   104 2026-01 Car Volkswagen Arteon Black Driving without Due Care and Attention None M6 SB J9 M6 Southbound J9 Walsall Walsall NFA No Independent Evidence Available   52.676119 -2.0858425
10645 op-snap---monthly-publication-january-2026.pdf   106 2026-01 Car Honda   Blue Driving without Due Care and Attention None New Road New Road Solihull Solihull NFA No Independent Evidence Available   52.4119526 -1.773235
10646 op-snap---monthly-publication-january-2026.pdf   107 2026-01 Car BMW 318D White Driving without Due Care and Attention None Underhill Lane Underhill Lane Wolverhampton Wolverhampton Court N/A   52.6184526 -2.0954562
10648 op-snap---monthly-publication-january-2026.pdf   109 2026-01 Car Nissan Qashqai Black Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham Education N/A   52.5020639 -1.9026192
10650 op-snap---monthly-publication-january-2026.pdf   111 2026-01 Car Kia Sportage Black Driving without Due Care and Attention None A5 Oswestry Oswestry Out of Force Area Out of Force Area NFA Out of Force      
10651 op-snap---monthly-publication-january-2026.pdf   112 2026-01 Car Daf HGV White Driving without Due Care and Attention None M6 SB J16-15 M6 Southbound J16-15 Out of Force Area Out of Force Area NFA Out of Force      
10652 op-snap---monthly-publication-january-2026.pdf   113 2026-01 Other Audi A3.. Grey Driving without Due Care and Attention None Star City Car Park Star City Car Park Birmingham Birmingham Warning Letter N/A      
10653 op-snap---monthly-publication-january-2026.pdf   114 2026-01 Pedestrian Hyundai I20 Grey Driving without Due Care and Attention None Sherborne Street Sherborne Street Birmingham Birmingham NFA No Independent Evidence Available   52.4762433 -1.9176665
10654 op-snap---monthly-publication-january-2026.pdf   115 2026-01 Car Ford Fiesta Blue Driving without Due Care and Attention None Spring Bank, Hull Spring Bank, Hull Out of Force Area Out of Force Area NFA Out of Force      
10655 op-snap---monthly-publication-january-2026.pdf   116 2026-01 Car Toyota Prius Silver Driving without Due Care and Attention None Clay Lane Clay Lane Birmingham Birmingham Education N/A   52.4509038 -1.8083784
10657 op-snap---monthly-publication-january-2026.pdf   118 2026-01 Car BMW 318.. Silver Driving without Due Care and Attention No Insurance A41 Birmingham Road Birmingham Road Sandwell Sandwell Court N/A   52.5461417 -1.9334193
10668 op-snap---monthly-publication-january-2026.pdf   129 2026-01 Car Ford Ranger Black Driving without Due Care and Attention None Royal Road Royal Road Birmingham Birmingham NFA No Offence   52.5609478 -1.8170275
10732 op-snap---monthly-publication-january-2026.pdf   193 2026-01 Car Volvo XC90 Black Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham NFA No Offence   52.5517052 -1.7825505
10762 op-snap---monthly-publication-january-2026.pdf   223 2026-01 Pedal Bike Ford Transit White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10763 op-snap---monthly-publication-january-2026.pdf   224 2026-01 Car Mercedes-Benz A200 Grey Driving without Due Care and Attention None Lower City Road Lower City Road Birmingham Birmingham Other Action Taken N/A      
10768 op-snap---monthly-publication-january-2026.pdf   229 2026-01 Car BMW X6 White Driving without Due Care and Attention None Green lane Green lane Birmingham Birmingham NFA No Independent Evidence Available   52.4618966 -1.9955421
10774 op-snap---monthly-publication-january-2026.pdf   235 2026-01 Car Audi A1 Grey Driving without Due Care and Attention None Sneyd Lane Sneyd Lane Metropolitan Borough of Walsall Walsall RTC - Actioned N/A   52.6198941 -2.0150184
10776 op-snap---monthly-publication-january-2026.pdf   237 2026-01 Other       Driving without Due Care and Attention None Broadmoor Road Broadmoor Road Sandwell Sandwell RTC - Actioned N/A      
10788 op-snap---monthly-publication-january-2026.pdf   249 2026-01 Car Daf   Red Driving without Due Care and Attention None Christchurch Christchurch Out of Force Area Out of Force Area NFA Out of Force   52.4057502 -1.5115258
10791 op-snap---monthly-publication-january-2026.pdf   252 2026-01 Car Mercedes-Benz C350 Black Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Education N/A   52.396476 -1.5561348
10797 op-snap---monthly-publication-january-2026.pdf   258 2026-01 Car Kia Picanto Blue Driving without Due Care and Attention None A380 Malvern Link Malvern Link Out of Force Area Out of Force Area NFA Out of Force      
10799 op-snap---monthly-publication-january-2026.pdf   260 2026-01 Car Land Rover Velar Blue Driving without Due Care and Attention None Manor Way Manor Way Halesowen Halesowen Warning Letter N/A   52.5203602 -1.824434
10801 op-snap---monthly-publication-january-2026.pdf   262 2026-01 Car Mercedes-Benz   White Driving without Due Care and Attention None London Road London Road Coventry Coventry Warning Letter N/A   52.3916468 -1.4925995
10802 op-snap---monthly-publication-january-2026.pdf   263 2026-01 Car Daf   Orange Driving without Due Care and Attention None Beake Avenue/ Rupert Road Beake Avenue/ Rupert Road Coventry Coventry Fixed Penalty N/A   52.4242259 -1.5233419
10803 op-snap---monthly-publication-january-2026.pdf   264 2026-01 Car Mercedes-Benz E250 Grey Driving without Due Care and Attention None London Road London Road Coventry Coventry NFA No Offence   52.3916468 -1.4925995
10804 op-snap---monthly-publication-january-2026.pdf   265 2026-01 Car Toyota Auris Black Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham Warning Letter N/A   52.5170745 -1.9012542
10807 op-snap---monthly-publication-january-2026.pdf   268 2026-01 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA Not in Public Interest   52.5919543 -1.8517118
10808 op-snap---monthly-publication-january-2026.pdf   269 2026-01 Car Suzuki Vitara Green Driving without Due Care and Attention None Newcastle upon Tyne Newcastle upon Tyne Out of Force Area Out of Force Area NFA Out of Force      
10810 op-snap---monthly-publication-january-2026.pdf   271 2026-01 Car Mercedes-Benz G 63 Black Driving without Due Care and Attention None Church Lane Church Lane Sandwell Sandwell Education N/A   52.5311655 -2.0008707
10817 op-snap---monthly-publication-january-2026.pdf   278 2026-01 Other Volkswagen Amarok Black Driving without Due Care and Attention None Castlegate Way, Dudley Castlegate Way, Dudley Dudley Dudley Education N/A   52.5152644 -2.07245
10819 op-snap---monthly-publication-january-2026.pdf   280 2026-01 Car Mazda 2 Grey Driving without Due Care and Attention None McKean Road, Oldbury Mc Kean Road, Oldbury Sandwell Sandwell NFA No Independent Evidence Available   52.5077405 -2.0124813
10820 op-snap---monthly-publication-january-2026.pdf   281 2026-01 Car BMW 320 Black Driving without Due Care and Attention Offence to be added A435 Alcester Road/M42 Roundabout Alcester Road/M42 Roundabout Out of Force Area Out of Force Area NFA Out of Force      
10824 op-snap---monthly-publication-january-2026.pdf   285 2026-01 Car Vauxhall Astra Red Driving without Due Care and Attention None Darlaston Road, Pleck Darlaston Road, Pleck Walsall Walsall Education N/A   52.5746221 -2.0037353
10825 op-snap---monthly-publication-january-2026.pdf   286 2026-01 Pedal Bike Mercedes-Benz Sprinter Red Driving without Due Care and Attention None Quinton Island Quinton Island Birmingham Birmingham NFA No Independent Evidence Available   52.4617515 -2.0079008
10828 op-snap---monthly-publication-january-2026.pdf   289 2026-01 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Tyburn Road, Gravely Hill Tyburn Road, Gravely Hill Birmingham Birmingham Education N/A      
10830 op-snap---monthly-publication-january-2026.pdf   291 2026-01 Car BMW   White Driving without Due Care and Attention None Cotheridge Cotheridge Out of Force Area Out of Force Area NFA Out of Force   52.3899442 -1.7798813
10833 op-snap---monthly-publication-january-2026.pdf   294 2026-01 Car BMW 118 Grey Driving without Due Care and Attention none Chetwynd Bridge, Croxall, Staffordshire Chetwynd Bridge, Croxall, Staffordshire Out of Force Area Out of Force Area NFA Out of Force      
10836 op-snap---monthly-publication-january-2026.pdf   297 2026-01 Car Tesla Model 3 Grey Driving without Due Care and Attention None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham NFA No Offence   52.4468506 -1.9395619
10839 op-snap---monthly-publication-january-2026.pdf   300 2026-01 Car   Unknown Tipper wagon White Driving without Due Care and Attention None M42 NB Jct 5a M42 Northbound Junction 5a Solihull Solihull NFA No Independent Evidence Available      
10843 op-snap---monthly-publication-january-2026.pdf   304 2026-01 Other Ford Fiesta Blue Driving without Due Care and Attention None Dudley Cinema Dudley Cinema Dudley Dudley NFA No Independent Evidence Available      
10844 op-snap---monthly-publication-january-2026.pdf   305 2026-01 Other Volkswagen Golf White Driving without Due Care and Attention None Dudley Cinema Dudley Cinema Dudley Dudley NFA No Independent Evidence Available      
10845 op-snap---monthly-publication-january-2026.pdf   306 2026-01 Pedal Bike   Irizar Coach Grey Driving without Due Care and Attention None Lawley Middleway, Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10846 op-snap---monthly-publication-january-2026.pdf   307 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Lawley Middleway Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10847 op-snap---monthly-publication-january-2026.pdf   308 2026-01 Other Skoda Kodiaq White Driving without Due Care and Attention None Star City Star City Birmingham Birmingham NFA Misc Inc Crimes   52.5054363 -1.8556273
10853 op-snap---monthly-publication-january-2026.pdf   314 2026-01 Car BMW 439I White Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry NFA No Independent Evidence Available   52.4068712 -1.4994695
10858 op-snap---monthly-publication-january-2026.pdf   319 2026-01 Car Vauxhall Insignia Black Driving without Due Care and Attention None Wolverhampton Road Oldbury Wolverhampton Road Oldbury Sandwell Sandwell Education N/A   52.5010052 -2.0306321
10862 op-snap---monthly-publication-january-2026.pdf   323 2026-01 Car Mini Cooper Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
10865 op-snap---monthly-publication-january-2026.pdf   326 2026-01 Car Ford Focus Blue Driving without Due Care and Attention None M42 M42 Birmingham Birmingham Fixed Penalty N/A      
10884 op-snap---monthly-publication-january-2026.pdf   345 2026-01 Pedal Bike Volkswagen Crafter White Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
10885 op-snap---monthly-publication-january-2026.pdf   346 2026-01 Car Ford Galaxy Blue Driving without Due Care and Attention None Magna Park Magna Park Out of Force Area Out of Force Area NFA Out of Force      
10887 op-snap---monthly-publication-january-2026.pdf   348 2026-01 Car Hyundai Tucson White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
10889 op-snap---monthly-publication-january-2026.pdf   350 2026-01 Car Audi A8 Grey Driving without Due Care and Attention None Asda Hereford Asda Hereford Out of Force Area Out of Force Area NFA Out of Force      
10890 op-snap---monthly-publication-january-2026.pdf   351 2026-01 Car Volkswagen Tiguan R White Driving without Due Care and Attention None Warwick Highway Warwick Highway 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);