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

599 rows where month = "2025-05" 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 · 599 ✖

month 1

  • 2025-05 · 599 ✖
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
18638 op-snap---monthly-publication-may-2025.pdf   0 2025-05 Car Mercedes-Benz A 200.. Black Driving without Due Care and Attention None Garretts Lane Garretts Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4734898 -1.7799814
18639 op-snap---monthly-publication-may-2025.pdf   1 2025-05 Car Ford Kuga Black Driving without Due Care and Attention None Meadway Meadway Birmingham Birmingham NFA Outside of 14 Days NIP   52.4783348 -1.8007708
18640 op-snap---monthly-publication-may-2025.pdf   2 2025-05 Car Hyundai Kona Grey Driving without Due Care and Attention None Barrows Lane Barrows Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4665114 -1.8010003
18657 op-snap---monthly-publication-may-2025.pdf   19 2025-05 Car   RAM Blue Driving without Due Care and Attention None M42 SB J4 M42 Southbound J4 Solihull Solihull NFA Outside of 14 Days NIP      
18658 op-snap---monthly-publication-may-2025.pdf   20 2025-05 Car Jaguar XJ Black Driving without Due Care and Attention None M42 SB J7 M42 Southbound J7 Solihull Solihull NFA Outside of 14 Days NIP      
18663 op-snap---monthly-publication-may-2025.pdf   25 2025-05 Car Volkswagen Tiguan White Driving without Due Care and Attention None M5 J3 M5 J3 Birmingham Birmingham Court N/A   52.4846642 -1.9297585
18674 op-snap---monthly-publication-may-2025.pdf   36 2025-05 Car Honda Jazz Blue Driving without Due Care and Attention None Barnes Hill Barnes Hill Birmingham Birmingham Education N/A   52.4401325 -1.9785938
18675 op-snap---monthly-publication-may-2025.pdf   37 2025-05 Car Ford Transit White Driving without Due Care and Attention None Eccleshall Road Eccleshall Road Wolverhampton Wolverhampton Warning Letter N/A      
18679 op-snap---monthly-publication-may-2025.pdf   41 2025-05 Car Volvo XC60 White Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell NFA Outside of 14 Days NIP   52.4926604 -2.0216743
18684 op-snap---monthly-publication-may-2025.pdf   46 2025-05 Motorbike Hyundai IX35 Grey Driving without Due Care and Attention None M5 NB 2-1 M5 Northbound 2-1 Sandwell Sandwell NFA Outside of 14 Days NIP      
18685 op-snap---monthly-publication-may-2025.pdf   47 2025-05 Car Honda Jazz Blue Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4415108 -1.8971434
18686 op-snap---monthly-publication-may-2025.pdf   48 2025-05 Car Porsche Cayenne Black Driving without Due Care and Attention None Manor Way Manor Way Dudley Dudley NFA Outside of 14 Days NIP   52.4493861 -2.0168307
18689 op-snap---monthly-publication-may-2025.pdf   51 2025-05 Motorbike BMW 320d Blue Driving without Due Care and Attention None M5 NB 2-1 M5 Northbound 2-1 Sandwell Sandwell NFA Outside of 14 Days NIP      
18695 op-snap---monthly-publication-may-2025.pdf   57 2025-05 Pedal Bike Ford Tourneo Silver Driving without Due Care and Attention None Wherretts Well Lane Wherretts Well Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4225399 -1.763283
18697 op-snap---monthly-publication-may-2025.pdf   59 2025-05 Pedestrian BMW M3 White Driving without Due Care and Attention None Miller Street Miller Street Birmingham Birmingham Fixed Penalty N/A   52.4933043 -1.8927828
18701 op-snap---monthly-publication-may-2025.pdf   63 2025-05 Car Volkswagen Tiguan Blue Driving without Due Care and Attention None A449 Worcestershire Worcestershire Out of Force Area Out of Force Area NFA Out of Force      
18711 op-snap---monthly-publication-may-2025.pdf   73 2025-05 Car Audi A3 Blue Driving without Due Care and Attention None M5 J 2 M5 J 2 Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4945433 -2.0190848
18712 op-snap---monthly-publication-may-2025.pdf   74 2025-05 Car Ford Transit Black Driving without Due Care and Attention None Lillington Avenue Lillington Avenue Out of Force Area Out of Force Area NFA Out of Force      
18724 op-snap---monthly-publication-may-2025.pdf   86 2025-05 Car Mercedes-Benz EQC Grey Driving without Due Care and Attention None Telford Way West Bromwich Telford Way West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP   52.5065282 -1.976582
18725 op-snap---monthly-publication-may-2025.pdf   87 2025-05 Pedal Bike Peugeot Partner Red Driving without Due Care and Attention None Ring Road Ring Road Coventry Coventry NFA No Offence      
18730 op-snap---monthly-publication-may-2025.pdf   92 2025-05 Car Vauxhall Vivaro White Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham NFA Outside of 14 Days NIP      
18742 op-snap---monthly-publication-may-2025.pdf   104 2025-05 Car Tesla Model 3 Grey Driving without Due Care and Attention None M42 EB J2 M42 Eb J2 Out of Force Area Out of Force Area NFA Out of Force   52.4945433 -2.0190848
18749 op-snap---monthly-publication-may-2025.pdf   111 2025-05 Car Vauxhall Mokka Silver Driving without Due Care and Attention None Finch Road Finch Road Birmingham Birmingham Education N/A   52.506108 -1.9083155
18751 op-snap---monthly-publication-may-2025.pdf   113 2025-05 Car Suzuki   White Driving without Due Care and Attention None Kettering Kettering Out of Force Area Out of Force Area NFA Out of Force      
18755 op-snap---monthly-publication-may-2025.pdf   117 2025-05 Car Mercedes-Benz CLA 200 Black Driving without Due Care and Attention None Cregoe Street Cregoe Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4718419 -1.9061401
18762 op-snap---monthly-publication-may-2025.pdf   124 2025-05 Car Mercedes-Benz BENZ Black Driving without Due Care and Attention None ALDRIDGE ROAD Aldridge Road Birmingham Birmingham Education N/A   52.5368764 -1.8976461
18765 op-snap---monthly-publication-may-2025.pdf   127 2025-05 Car       Driving without Due Care and Attention None WATLING STREET A5 Watling Street A5 Walsall Walsall Education N/A   52.6562907 -1.9111505
18766 op-snap---monthly-publication-may-2025.pdf   128 2025-05 Car       Driving without Due Care and Attention None WATLING STREET A5 Watling Street A5 Walsall Walsall Education N/A   52.6562907 -1.9111505
18767 op-snap---monthly-publication-may-2025.pdf   129 2025-05 Car Volkswagen CC Black Driving without Due Care and Attention None Hobmoor Road Hobmoor Road Birmingham Birmingham Court N/A   52.4709249 -1.8295416
18768 op-snap---monthly-publication-may-2025.pdf   130 2025-05 Car Renault TRAFIC Silver Driving without Due Care and Attention None WATLING STREET A5 Watling Street A5 Walsall Walsall Fixed Penalty N/A   52.6562907 -1.9111505
18770 op-snap---monthly-publication-may-2025.pdf   132 2025-05 Car Mercedes-Benz Sprinter Red Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
18782 op-snap---monthly-publication-may-2025.pdf   144 2025-05 CAR Volkswagen GOLF Black Driving without Due Care and Attention None SMALL HEATH HIGHWAY Small Heath Highway Birmingham Birmingham Fixed Penalty N/A   52.4709298 -1.8722585
18793 op-snap---monthly-publication-may-2025.pdf   155 2025-05 Car Mazda THREE Blue Driving without Due Care and Attention None Beacon Road Beacon Road Sandwell Sandwell NFA No VRM   52.5499696 -1.9797407
18797 op-snap---monthly-publication-may-2025.pdf   159 2025-05 Car BMW R 1200 Black Driving without Due Care and Attention None M5 South Junction 2 M5 South Junction 2 Dudley Dudley NFA Outside of 14 Days NIP      
18805 op-snap---monthly-publication-may-2025.pdf   167 2025-05 Car Honda NSC White Driving without Due Care and Attention None Market Street Market Street Dudley Dudley NFA Outside of 14 Days NIP   52.4964695 -2.1680501
18820 op-snap---monthly-publication-may-2025.pdf   182 2025-05 Car Citroen DS3.. Grey Driving without Due Care and Attention None Westbourne Road Edbaston Westbourne Road Edbaston Birmingham Birmingham NFA Outside of 14 Days NIP      
18823 op-snap---monthly-publication-may-2025.pdf   185 2025-05 Car BMW 320.. Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4203897 -1.8338574
18824 op-snap---monthly-publication-may-2025.pdf   186 2025-05 Car BMW $00 AMG Silver Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4726661 -1.8769032
18830 op-snap---monthly-publication-may-2025.pdf   192 2025-05 Car Skoda Octivia Grey Driving without Due Care and Attention None Ansty Road Ansty Road Coventry Coventry NFA Outside of 14 Days NIP   52.4205675 -1.4520187
18834 op-snap---monthly-publication-may-2025.pdf   196 2025-05 Car       Driving without Due Care and Attention None Solihull Bypass. Solihull Bypass Solihull Solihull NFA No VRM   52.4207529 -1.7757467
18835 op-snap---monthly-publication-may-2025.pdf   197 2025-05 Car   Scania Red Driving without Due Care and Attention None M42 Southbound M42 Southbound Birmingham Birmingham Court N/A      
18844 op-snap---monthly-publication-may-2025.pdf   206 2025-05 Car Toyota Prius White Driving without Due Care and Attention None Great Barr Interchange Great Barr Interchange Sandwell Sandwell NFA Outside of 14 Days NIP   52.5526943 -1.9321372
18848 op-snap---monthly-publication-may-2025.pdf   210 2025-05 Car Vauxhall Corsa Black Driving without Due Care and Attention None Wilford Road West West Bromwich Wilford Road West West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP   52.5310242 -1.9925982
18855 op-snap---monthly-publication-may-2025.pdf   217 2025-05 Other Honda moped White Driving without Due Care and Attention None South Road, Erdington South Road, Erdington Birmingham Birmingham NFA No VRM   52.524195 -1.8456434
18858 op-snap---monthly-publication-may-2025.pdf   220 2025-05 Car Toyota Yaris White Driving without Due Care and Attention None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton Warning Letter N/A   52.5847884 -2.1341887
18871 op-snap---monthly-publication-may-2025.pdf   233 2025-05 Car Volvo C40 Black Driving without Due Care and Attention None M42 Jn3 M42 Jn3 Out of Force Area Out of Force Area NFA Out of Force      
18882 op-snap---monthly-publication-may-2025.pdf   244 2025-05 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Black County Route Black County Route Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
18890 op-snap---monthly-publication-may-2025.pdf   252 2025-05 Other BMW M2.. Black Driving without Due Care and Attention None Brockhurts Road Brockhurts Road Birmingham Birmingham NFA Outside of 14 Days NIP      
18896 op-snap---monthly-publication-may-2025.pdf   258 2025-05 Car Mercedes-Benz S class Black Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5867763 -2.0104342
18897 op-snap---monthly-publication-may-2025.pdf   259 2025-05 Car Vauxhall Meriva Silver Driving without Due Care and Attention none Harbourne Park Road Harbourne Park Road Birmingham Birmingham Education N/A      
18900 op-snap---monthly-publication-may-2025.pdf   262 2025-05 Car Renault Captur Blue Driving without Due Care and Attention None Primrose Lane Primrose Lane Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.6126833 -2.1053084
18905 op-snap---monthly-publication-may-2025.pdf   267 2025-05 Pedal Bike       Driving without Due Care and Attention None Corporation street Corporation street Walsall Walsall NFA No VRM   52.5773099 -1.9850716
18907 op-snap---monthly-publication-may-2025.pdf   269 2025-05 Car Audi Q8 Black Driving without Due Care and Attention None BICKENHILL LANE Bickenhill Lane Birmingham Birmingham NFA No Offence      
18908 op-snap---monthly-publication-may-2025.pdf   270 2025-05 Car Audi A8 Grey Driving without Due Care and Attention None BICKENHILL LANE Bickenhill Lane Birmingham Birmingham NFA No Offence      
18916 op-snap---monthly-publication-may-2025.pdf   278 2025-05 Car Mercedes-Benz C200 Black Driving without Due Care and Attention None Worksop Worksop Out of Force Area Out of Force Area NFA Out of Force      
18917 op-snap---monthly-publication-may-2025.pdf   279 2025-05 Car Mercedes-Benz Van White Driving without Due Care and Attention None Sky Blue Way Sky Blue Way Coventry Coventry Warning Letter N/A   52.4085943 -1.4943275
18921 op-snap---monthly-publication-may-2025.pdf   283 2025-05 Pedal Bike BMW X4 Black Driving without Due Care and Attention None Flaxley Road Flaxley Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.487709 -1.8077323
18930 op-snap---monthly-publication-may-2025.pdf   292 2025-05 Car Audi A5.. Blue Driving without Due Care and Attention None M5 North Junction 1 M5 North Junction 1 Sandwell Sandwell NFA No Independent Evidence Available      
18933 op-snap---monthly-publication-may-2025.pdf   295 2025-05 Car Peugeot BIPPER White Driving without Due Care and Attention None HAMSTEAD ROAD Hamstead Road Birmingham Birmingham Education N/A   52.505832 -1.92002
18934 op-snap---monthly-publication-may-2025.pdf   296 2025-05 Car Peugeot van White Driving without Due Care and Attention None Deans Road Deans Road Wolverhampton Wolverhampton Court N/A   52.5930404 -2.1026254
18935 op-snap---monthly-publication-may-2025.pdf   297 2025-05 Car Skoda Citigo Green Driving without Due Care and Attention None Stonebridge Highway Coventry Stonebridge Highway Coventry Coventry Coventry Education N/A   52.3782187 -1.478696
18941 op-snap---monthly-publication-may-2025.pdf   303 2025-05 Car BMW X2.. Black Driving without Due Care and Attention None Walsall Road Great Barr Walsall Road Great Barr Birmingham Birmingham Education N/A   52.5623476 -1.9436356
18946 op-snap---monthly-publication-may-2025.pdf   308 2025-05 Car Volkswagen TIGUAN White Driving without Due Care and Attention None M42 JUNCTION 6 M42 Junction 6 Birmingham Birmingham NFA Outside of 14 DAYS Late Submission      
18957 op-snap---monthly-publication-may-2025.pdf   319 2025-05 Car Yamaha Delight Black Driving without Due Care and Attention None Redicap Heath Road Redicap Heath Road Sutton Coldfield Sutton Coldfield Court N/A      
18965 op-snap---monthly-publication-may-2025.pdf   327 2025-05 Car Audi A4 Grey Driving without Due Care and Attention None A449 A449 Out of Force Area Out of Force Area NFA Out of Force      
18966 op-snap---monthly-publication-may-2025.pdf   328 2025-05 Car Nissan Primera Silver Driving without Due Care and Attention None M1 M1 Out of Force Area Out of Force Area NFA Out of Force      
18967 op-snap---monthly-publication-may-2025.pdf   329 2025-05 Car Mini Cooper Grey Driving without Due Care and Attention None Balsall St Balsall Street Solihull Solihull Warning Letter N/A   52.3826029 -1.6998649
18977 op-snap---monthly-publication-may-2025.pdf   339 2025-05 Other Ford Fiesta Black Driving without Due Care and Attention None Grey 7 Car park, Merry Hill Grey 7 Car park, Merry Hill Dudley Dudley Education N/A      
18983 op-snap---monthly-publication-may-2025.pdf   345 2025-05 Car BMW 530.. Blue Driving without Due Care and Attention None Alum Rock Road Alum Rock Road Birmingham Birmingham Court N/A   52.4883936 -1.8310056
18984 op-snap---monthly-publication-may-2025.pdf   346 2025-05 Car Toyota PRIUS White Driving without Due Care and Attention None Tessall Lane Tessall Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4045186 -1.9891793
18988 op-snap---monthly-publication-may-2025.pdf   350 2025-05 Pedestrian Seat Leon Silver Driving without Due Care and Attention None Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
18989 op-snap---monthly-publication-may-2025.pdf   351 2025-05 Car BMW 330e Blue Driving without Due Care and Attention None High Street, Wordsley High Street, Wordsley Dudley Dudley NFA Outside of 14 Days NIP   52.4778645 -2.1594686
18990 op-snap---monthly-publication-may-2025.pdf   352 2025-05 Car Volkswagen GOLF GTI Grey Driving without Due Care and Attention None Edmund Road Edmund Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4876113 -1.8542201
18993 op-snap---monthly-publication-may-2025.pdf   355 2025-05 Car Mini Copper Red Driving without Due Care and Attention None Warstock Road Warstock Road Birmingham Birmingham Education N/A   52.413031 -1.8782144
18994 op-snap---monthly-publication-may-2025.pdf   356 2025-05 Car Skoda Kodiaq Grey Driving without Due Care and Attention None Maypole Island Maypole Island Birmingham Birmingham Education N/A   52.4047413 -1.8859323
18999 op-snap---monthly-publication-may-2025.pdf   361 2025-05 Car Mercedes-Benz A200 Grey Driving without Due Care and Attention None B4393 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
19011 op-snap---monthly-publication-may-2025.pdf   373 2025-05 Car   Ferrari Red Driving without Due Care and Attention None junction 4 M42 junction 4 M42 Solihull Solihull NFA No VRM      
19014 op-snap---monthly-publication-may-2025.pdf   376 2025-05 Car Volkswagen Golf White Driving without Due Care and Attention None Willenhall Lane Willenhall Lane Wolverhampton Wolverhampton Court N/A   52.5702145 -2.0679602
19016 op-snap---monthly-publication-may-2025.pdf   378 2025-05 Car Audi A3 Red Driving without Due Care and Attention None CINDERBANK ISLAND Cinderbank Island Dudley Dudley NFA No Offence      
19018 op-snap---monthly-publication-may-2025.pdf   380 2025-05 Car Toyota Rav 4 Beige Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham NFA Outside of 14 Days NIP   52.4220705 -1.8372335
19024 op-snap---monthly-publication-may-2025.pdf   386 2025-05 Car Ford Focus Black Driving without Due Care and Attention None M42 Junction 3A Solihull M42 Junction 3A Solihull Solihull Solihull NFA Outside of 14 Days NIP   52.4846642 -1.9297585
19026 op-snap---monthly-publication-may-2025.pdf   388 2025-05 Car Mercedes-Benz Vito Green Driving without Due Care and Attention None Bordsley Circus Bordsley Circus Birmingham Birmingham NFA No Independent Evidence Available      
19030 op-snap---monthly-publication-may-2025.pdf   392 2025-05 Car Renault Traffic Black Driving without Due Care and Attention None M1 Southbound at M6 join (Leiceste M1 Southbound at M6 join (Leiceste rsOhuirte o)f Force Area Rsohuirte O)F Force Area NFA Out of Force      
19031 op-snap---monthly-publication-may-2025.pdf   393 2025-05 Pedal Bike Ford fiesta White Driving without Due Care and Attention None Kiddiminster road Kiddiminster road Solihull Solihull Fixed Penalty N/A      
19034 op-snap---monthly-publication-may-2025.pdf   396 2025-05 Car Toyota Prius Silver Driving without Due Care and Attention No Insurance Holbrook Lane Holbrook Lane Coventry Coventry Fixed Penalty N/A   52.436155 -1.5064002
19037 op-snap---monthly-publication-may-2025.pdf   399 2025-05 Pedal Bike Ford Transit White Driving without Due Care and Attention None Malvern area Malvern area Out of Force Area Out of Force Area NFA Out of Force      
19038 op-snap---monthly-publication-may-2025.pdf   400 2025-05 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Malvern area Malvern area Out of Force Area Out of Force Area NFA Out of Force      
19042 op-snap---monthly-publication-may-2025.pdf   404 2025-05 Car Seat Ibiza Grey Driving without Due Care and Attention None Monument Road Monument Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4731312 -1.930947
19043 op-snap---monthly-publication-may-2025.pdf   405 2025-05 Car Toyota AYGO Red Driving without Due Care and Attention None WHARF ROAD Wharf Road Halesowen Halesowen Court N/A   52.4571689 -1.8277656
19044 op-snap---monthly-publication-may-2025.pdf   406 2025-05 Other BMW 1 series Orange Driving without Due Care and Attention None Birmingham Birmingham Birmingham Birmingham NFA No Independent Evidence Available   52.4796992 -1.9026911
19048 op-snap---monthly-publication-may-2025.pdf   410 2025-05 Car Ford Transit White Driving without Due Care and Attention None Chester Road Chester Road Walsall Walsall NFA Outside of 14 DAYS Late Submission   52.5692139 -1.8799672
19054 op-snap---monthly-publication-may-2025.pdf   416 2025-05 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention No Insurance Hinksford Lane Swindon Hinksford Lane Swindon Out of Force Area Out of Force Area NFA Out of Force   52.5079592 -2.1966932
19062 op-snap---monthly-publication-may-2025.pdf   424 2025-05 Car Mercedes-Benz E220 White Driving without Due Care and Attention None A5 (Out of Force) A5 (Out of Force) Out of Force Area Out of Force Area NFA Out of Force      
19064 op-snap---monthly-publication-may-2025.pdf   426 2025-05 Car BMW 7 SERIES Grey Driving without Due Care and Attention None BLACK COUNTRY NEW ROAD Black Country New Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5527191 -2.0312967
19069 op-snap---monthly-publication-may-2025.pdf   431 2025-05 Car BMW 320.. Blue Driving without Due Care and Attention None M5 South Jct 1 M5 South Junction 1 Sandwell Sandwell NFA Outside of 14 Days NIP      
19074 op-snap---monthly-publication-may-2025.pdf   436 2025-05 Car BMW 330 E Grey Driving without Due Care and Attention None A441 Kings Norton Kings Norton Birmingham Birmingham NFA Outside of 14 Days NIP   52.4072579 -1.9293043
19087 op-snap---monthly-publication-may-2025.pdf   449 2025-05 Car BMW 1 series Black Driving without Due Care and Attention None Russell Road Russell Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4398245 -1.8469786
19088 op-snap---monthly-publication-may-2025.pdf   450 2025-05 Car Volkswagen Golf Blue Driving without Due Care and Attention None Russell Road Russell Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4398245 -1.8469786
19091 op-snap---monthly-publication-may-2025.pdf   453 2025-05 Pedestrian Mini COOPER White Driving without Due Care and Attention None GIBBONS ROAD Gibbons Road Birmingham Birmingham Fixed Penalty N/A   52.5917726 -1.8257003
19097 op-snap---monthly-publication-may-2025.pdf   459 2025-05 Pedal Bike Audi TT Silver Driving without Due Care and Attention None BEDWORTH ROAD Bedworth Road Coventry Coventry Education N/A   52.4554838 -1.4848593

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