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

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

offence 1

  • Driving without Due Care and Attention · 396 ✖

month 1

  • 2025-05 · 396 ✖
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
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
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
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
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
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      
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
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
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
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
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      
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
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
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
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
19098 op-snap---monthly-publication-may-2025.pdf   460 2025-05 Car Volkswagen golf Blue Driving without Due Care and Attention None Taylor Road Taylor Road Birmingham Birmingham Court N/A   52.4224243 -1.8885105
19099 op-snap---monthly-publication-may-2025.pdf   461 2025-05 Car Audi A1 Silver Driving without Due Care and Attention None A45 BIRMINGHAM ROAD NORTH A45 Birmingham Road North Birmingham Birmingham Fixed Penalty N/A   52.5162527 -1.7527478
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      
19101 op-snap---monthly-publication-may-2025.pdf   463 2025-05 Car BMW 3 series Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
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      
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      
19125 op-snap---monthly-publication-may-2025.pdf   487 2025-05 Car Renault Megane Silver Driving without Due Care and Attention None Ashmore Lake Road Ashmore Lake Road Walsall Walsall Education N/A   52.5961284 -2.0497272
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
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
19140 op-snap---monthly-publication-may-2025.pdf   502 2025-05 Car Ford FIESTA White Driving without Due Care and Attention No Insurance TINTERN ROAD Tintern Road Birmingham Birmingham Court N/A   52.5120672 -1.890936
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
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
19200 op-snap---monthly-publication-may-2025.pdf   562 2025-05 Car BMW 530.. Blue Driving without Due Care and Attention None Bickenhill parkway Bickenhill parkway Birmingham Birmingham Warning Letter N/A      
19201 op-snap---monthly-publication-may-2025.pdf   563 2025-05 Car Volvo XC40. Grey Driving without Due Care and Attention None Bickenhill Parkway Bickenhill Parkway Birmingham Birmingham Warning Letter N/A      
19207 op-snap---monthly-publication-may-2025.pdf   569 2025-05 Car Volkswagen Tiguan Silver Driving without Due Care and Attention None B4096 Rose Hill Rose Hill Birmingham Birmingham Education N/A   52.5016894 -1.923467

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