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

275 rows where disposal = "NFA", 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

reporter_transport_mode 8

offence 1

  • Driving without Due Care and Attention · 275 ✖

month 1

  • 2025-05 · 275 ✖

disposal 1

  • NFA · 275 ✖
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      
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
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
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
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
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
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
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      
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      
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      
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      
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
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      
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      
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
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
19100 op-snap---monthly-publication-may-2025.pdf   462 2025-05 Car Kia Rio Red Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham NFA Outside of 14 Days NIP      
19112 op-snap---monthly-publication-may-2025.pdf   474 2025-05 Car Ford Transit White Driving without Due Care and Attention None Shawbirch Roundabout Shawbirch Roundabout Out of Force Area Out of Force Area NFA Out of Force      
19116 op-snap---monthly-publication-may-2025.pdf   478 2025-05 Pedestrian Volkswagen polo White Driving without Due Care and Attention None Robin Hood Road Robin Hood Road Dudley Dudley NFA No Independent Evidence Available   52.4781594 -2.1049925
19120 op-snap---monthly-publication-may-2025.pdf   482 2025-05 Car Honda CBR 500 Black Driving without Due Care and Attention None A46 A46 Out of Force Area Out of Force Area NFA Out of Force      
19126 op-snap---monthly-publication-may-2025.pdf   488 2025-05 Car Nissan Micra Blue Driving without Due Care and Attention No Insurance East Meadway East Meadway Birmingham Birmingham NFA No VRM   52.4813031 -1.7670825
19130 op-snap---monthly-publication-may-2025.pdf   492 2025-05 Pedestrian BMW M4 White Driving without Due Care and Attention None Valentine Road Valentine Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4381959 -1.8907391
19131 op-snap---monthly-publication-may-2025.pdf   493 2025-05 Car Hyundai I30 White Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Wolverhampton Wolverhampton NFA No Offence   52.5560698 -2.1044322
19133 op-snap---monthly-publication-may-2025.pdf   495 2025-05 Pedal Bike Ford FIESTA White Driving without Due Care and Attention None Merritts Brook lane Merritts Brook lane Birmingham Birmingham NFA No Offence   52.4159246 -1.9848186
19143 op-snap---monthly-publication-may-2025.pdf   505 2025-05 Car Ford Ranger Black Driving without Due Care and Attention None level street, Level Street Dudley Dudley NFA Outside of 14 Days NIP   52.4850236 -2.1088919
19157 op-snap---monthly-publication-may-2025.pdf   519 2025-05 Car Audi A1 Black Driving without Due Care and Attention None Victoria street Victoria street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4751651 -1.8559775
19175 op-snap---monthly-publication-may-2025.pdf   537 2025-05 Car Toyota Yaris Blue Driving without Due Care and Attention None Lode Lane at Warwick Road Lode Lane at Warwick Road Solihull Solihull NFA Outside of 14 Days NIP   52.4286691 -1.7775374
19180 op-snap---monthly-publication-may-2025.pdf   542 2025-05 Car   Bucher White Driving without Due Care and Attention None Sky Blue Way Sky Blue Way Coventry Coventry NFA Outside of 14 Days NIP   52.4085943 -1.4943275
19188 op-snap---monthly-publication-may-2025.pdf   550 2025-05 Pedal Bike Citroen C3 Orange Driving without Due Care and Attention None Edward Road Edward Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4580901 -1.894458
19193 op-snap---monthly-publication-may-2025.pdf   555 2025-05 Car Volkswagen GOLF Grey Driving without Due Care and Attention None STRATFORD ROAD Stratford Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4203897 -1.8338574
19194 op-snap---monthly-publication-may-2025.pdf   556 2025-05 Car Land Rover SPORT Black Driving without Due Care and Attention None BEMBRIDGE ROAD Bembridge Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4809806 -1.7928106
19197 op-snap---monthly-publication-may-2025.pdf   559 2025-05 Other Ford C Max Black Driving without Due Care and Attention None Riversdale Road Riversdale Road Birmingham Birmingham NFA No VRM   52.4113809 -1.8568702
19229 op-snap---monthly-publication-may-2025.pdf   591 2025-05 Car Honda CRV Red Driving without Due Care and Attention None Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force   52.4047807 -2.0101216
19238 op-snap---monthly-publication-may-2025.pdf   600 2025-05 Car Nissan Micra Red Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
19245 op-snap---monthly-publication-may-2025.pdf   607 2025-05 Car Ford Transit Silver Driving without Due Care and Attention None St Margarets Road Street Margarets Road Birmingham Birmingham NFA Outside of 14 Days NIP      
19252 op-snap---monthly-publication-may-2025.pdf   614 2025-05 Car Audi A5 Blue Driving without Due Care and Attention None Birmingham Road Lichfield Birmingham Road Lichfield Out of Force Area Out of Force Area NFA no offence   52.5675481 -1.8213094
19262 op-snap---monthly-publication-may-2025.pdf   624 2025-05 Other Nissan Datsun 240Z Red Driving without Due Care and Attention No Insurance Bromsgrove Road, Halesowen Bromsgrove Road, Halesowen Halesowen Halesowen NFA No Independent Evidence Available   52.4473174 -2.0452886
19271 op-snap---monthly-publication-may-2025.pdf   633 2025-05 Pedal Bike Peugeot partner White Driving without Due Care and Attention None George Road George Road Birmingham Birmingham NFA No Offence   52.5155831 -1.8598862
19272 op-snap---monthly-publication-may-2025.pdf   634 2025-05 Car Mercedes-Benz Bus Red Driving without Due Care and Attention None A41 Expressway Expressway Sandwell Sandwell NFA Outside of 14 Days NIP   52.5256969 -2.004455
19277 op-snap---monthly-publication-may-2025.pdf   639 2025-05 Car Ford Mustang Yellow Driving without Due Care and Attention None Bromsgrove Bromsgrove Out of Force Area Out of Force Area NFA Out of Force   52.4728322 -1.897536
19280 op-snap---monthly-publication-may-2025.pdf   642 2025-05 Pedal Bike Audi A5 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull NFA No VRM   52.4191184 -1.8326637
19284 op-snap---monthly-publication-may-2025.pdf   646 2025-05 Pedestrian Ford Fiesta Red Driving without Due Care and Attention None Shottery Road, Stratford Upon Avon Shottery Road, Stratford Upon Avon Out of Force Area Out of Force Area NFA Out of Force      
19293 op-snap---monthly-publication-may-2025.pdf   655 2025-05 Car Peugeot Partner White Driving without Due Care and Attention None Collector Road Collector Road Birmingham Birmingham NFA No Offence   52.5139393 -1.7600186
19294 op-snap---monthly-publication-may-2025.pdf   656 2025-05 Car Vauxhall Corsa Grey Driving without Due Care and Attention None M42 M42 Birmingham Birmingham NFA Outside of 14 Days NIP      
19296 op-snap---monthly-publication-may-2025.pdf   658 2025-05 Car Porsche Cayman Grey Driving without Due Care and Attention None M1 Lutterworth M1 Lutterworth Out of Force Area Out of Force Area NFA Out of Force   52.4173372 -1.4677589
19301 op-snap---monthly-publication-may-2025.pdf   663 2025-05 Car BMW 216 D Silver Driving without Due Care and Attention None Ring Road St Davids W`ton Ring Road Street Davids W`ton Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
19302 op-snap---monthly-publication-may-2025.pdf   664 2025-05 Car Ford Mustang Grey Driving without Due Care and Attention None M42, Henley in Arden M42, Henley in Arden Solihull Solihull NFA Outside of 14 DAYS Late Submission      
19316 op-snap---monthly-publication-may-2025.pdf   678 2025-05 Car Audi A5 Grey Driving without Due Care and Attention None Station Road, Stafford Station Road, Stafford Out of Force Area Out of Force Area NFA Out of Force   52.5033053 -1.9308616

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