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

301 rows where month = "2026-01", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Car · 301 ✖

offence 1

  • Driving without Due Care and Attention · 301 ✖

month 1

  • 2026-01 · 301 ✖
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      
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
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
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
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
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
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
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      
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      
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
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
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      
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
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
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
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
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      
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      
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      
10896 op-snap---monthly-publication-january-2026.pdf   357 2026-01 Car Vauxhall Movano White Driving without Due Care and Attention None M5 Southbound J7 M5 Southbound J7 Out of Force Area Out of Force Area NFA Out of Force      
10898 op-snap---monthly-publication-january-2026.pdf   359 2026-01 Car Volvo XC60 Black Driving without Due Care and Attention None M62 Leeds M62 Leeds Out of Force Area Out of Force Area NFA Out of Force      
10901 op-snap---monthly-publication-january-2026.pdf   362 2026-01 Car Audi A5 Black Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
10902 op-snap---monthly-publication-january-2026.pdf   363 2026-01 Car Ford Fiesta Black Driving without Due Care and Attention None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Education N/A   52.473883 -1.9198244
10903 op-snap---monthly-publication-january-2026.pdf   364 2026-01 Car Seat Ibiza Black Driving without Due Care and Attention None Five ways roundabout Five ways roundabout Birmingham Birmingham Warning Letter N/A      
10910 op-snap---monthly-publication-january-2026.pdf   371 2026-01 Car Volvo C30 Silver Driving without Due Care and Attention None Barkers Butt Lane Barkers Butt Lane Coventry Coventry Warning Letter N/A      
10913 op-snap---monthly-publication-january-2026.pdf   374 2026-01 Car Audi Q5 Grey Driving without Due Care and Attention None Suffolk Suffolk Out of Force Area Out of Force Area NFA Out of Force   52.4776755 -1.9038118
10917 op-snap---monthly-publication-january-2026.pdf   378 2026-01 Car Audi   Blue Driving without Due Care and Attention None Taunton Taunton Out of Force Area Out of Force Area NFA Out of Force   52.4086881 -1.9988156
10921 op-snap---monthly-publication-january-2026.pdf   382 2026-01 Car Mercedes-Benz G-Wagon Black Driving without Due Care and Attention None Chester Road North Chester Road North Birmingham Birmingham NFA No Independent Evidence Available   52.548449 -1.8594603
10922 op-snap---monthly-publication-january-2026.pdf   383 2026-01 Car Volkswagen Polo White Driving without Due Care and Attention None Olton Boulevard Olton Boulevard Birmingham Birmingham Court N/A   52.443439 -1.8180486
10927 op-snap---monthly-publication-january-2026.pdf   388 2026-01 Car Volkswagen Golf White Driving without Due Care and Attention None Coventry Road Coventry Road Solihull Solihull NFA No Offence   52.4505232 -1.7606378
10939 op-snap---monthly-publication-january-2026.pdf   400 2026-01 Car BMW 320d Black Driving without Due Care and Attention None M5 SB J1-2 M5 Southbound J1-2 Sandwell Sandwell Education N/A      
10941 op-snap---monthly-publication-january-2026.pdf   402 2026-01 Car Mini Mini Black Driving without Due Care and Attention None Western Road Western Road Birmingham Birmingham Education N/A   52.5461182 -1.8340257
10946 op-snap---monthly-publication-january-2026.pdf   407 2026-01 Car Toyota yaris Grey Driving without Due Care and Attention None The Green The Green Birmingham Birmingham Education N/A   52.547254 -1.8143667
10947 op-snap---monthly-publication-january-2026.pdf   408 2026-01 Car Mercedes-Benz G63 Black Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham Warning Letter N/A   52.4622646 -1.8599985
10953 op-snap---monthly-publication-january-2026.pdf   414 2026-01 Car Volkswagen Golf Silver Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
10958 op-snap---monthly-publication-january-2026.pdf   419 2026-01 Car Audi A3 grey Driving without Due Care and Attention Use vehicle on a road without valid test certificate Cinder Bank Island, Netherton Cinder Bank Island, Netherton Dudley Dudley Warning Letter N/A   52.5004694 -2.0904035
10962 op-snap---monthly-publication-january-2026.pdf   423 2026-01 Car Mg HS White Driving without Due Care and Attention None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham NFA No Offence   52.4580375 -1.9261777
10966 op-snap---monthly-publication-january-2026.pdf   427 2026-01 Car Mercedes-Benz Vito Silver Driving without Due Care and Attention None Sandy Lane, Bromsgrove Sandy Lane, Bromsgrove Out of Force Area Out of Force Area NFA Out of Force      
10982 op-snap---monthly-publication-january-2026.pdf   443 2026-01 Car Fiat 500L White Driving without Due Care and Attention None Wylde Green Road Wylde Green Road Sutton Coldfield Sutton Coldfield Education N/A   52.546976 -1.8098124
10985 op-snap---monthly-publication-january-2026.pdf   446 2026-01 Car Hyundai i40 Silver Driving without Due Care and Attention None Links Road Links Road Coventry Coventry Warning Letter N/A   52.4310925 -1.5197728
10999 op-snap---monthly-publication-january-2026.pdf   460 2026-01 Car BMW 1 Series Grey Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull Education N/A   52.4144779 -1.7848758
11008 op-snap---monthly-publication-january-2026.pdf   469 2026-01 Car Nissan Juke Black Driving without Due Care and Attention None Bolton Road at Arthur Street Bolton Road at Arthur Street Birmingham Birmingham Education N/A   52.4667482 -1.8642338
11011 op-snap---monthly-publication-january-2026.pdf   472 2026-01 Car BMW 1 Series Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
11015 op-snap---monthly-publication-january-2026.pdf   476 2026-01 Car BMW M3 Black Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham NFA No Independent Evidence Available   52.505832 -1.92002
11017 op-snap---monthly-publication-january-2026.pdf   478 2026-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Shipston Road, Warwickshire Shipston Road, Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
11020 op-snap---monthly-publication-january-2026.pdf   481 2026-01 Car Volkswagen Tiguan Black Driving without Due Care and Attention None A452 Collector Road Collector Road Birmingham Birmingham Fixed Penalty N/A   52.5139393 -1.7600186
11027 op-snap---monthly-publication-january-2026.pdf   488 2026-01 Car Suzuki GSXS 125 Black Driving without Due Care and Attention Drive otherwise than in accordance with a licence Bristol Road South Bristol Road South Birmingham Birmingham Court N/A   52.4119174 -1.9735247
11029 op-snap---monthly-publication-january-2026.pdf   490 2026-01 Car Renault Traffic White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
11030 op-snap---monthly-publication-january-2026.pdf   491 2026-01 Car Kia Sportage Black Driving without Due Care and Attention None Hollywell Road Hollywell Road Birmingham Birmingham NFA No Independent Evidence Available   52.4594803 -1.7866201

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