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

893 rows where offence = "Driving without Reasonable Consideration" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make >30

reporter_transport_mode 1

  • Car · 893 ✖

offence 1

  • Driving without Reasonable Consideration · 893 ✖
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
7397 op-snap---monthly-publication-february-2026.pdf   144 2026-02 Car Kia Stonic Red Driving without Reasonable Consideration None Telford Town Centre Telford Town Centre Out of Force Area Out of Force Area NFA Out of Force      
7412 op-snap---monthly-publication-february-2026.pdf   159 2026-02 Car Peugeot 208 Grey Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
7529 op-snap---monthly-publication-february-2026.pdf   276 2026-02 Car BMW 320 White Driving without Reasonable Consideration None Small Heath Bridge Small Heath Bridge Birmingham Birmingham Fixed Penalty N/A   52.4675008 -1.8693303
7810 op-snap---monthly-publication-february-2026.pdf   557 2026-02 Car Volkswagen golf White Driving without Reasonable Consideration None Stafford Road Stafford Road Wolverhampton Wolverhampton Education N/A   52.6291998 -2.126312
7958 op-snap---monthly-publication-february-2026.pdf   705 2026-02 Car Mercedes-Benz EAQ 350 Grey Driving without Reasonable Consideration None Five ways Five ways Birmingham Birmingham Warning Letter N/A   52.4710941 -1.9130708
7964 op-snap---monthly-publication-february-2026.pdf   711 2026-02 Car Audi A3 Red Driving without Reasonable Consideration None Queslett Road / Kings Road Queslett Road / Kings Road Birmingham Birmingham NFA No Offence   52.5461661 -1.9204363
8494 op-snap---monthly-publication-february-2026.pdf   1241 2026-02 Car Mercedes-Benz 400 AMG Black Driving without Reasonable Consideration None Hockley Lane Hockley Lane Coventry Coventry Education N/A   52.4165323 -1.6001601
8763 op-snap---monthly-publication-february-2026.pdf   1510 2026-02 Car Tesla model 3 Grey Driving without Reasonable Consideration None Jn3 M42, West Mercia Jn3 M42, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
8771 op-snap---monthly-publication-february-2026.pdf   1518 2026-02 Car Toyota Prius White Driving without Reasonable Consideration None Newton Road Great Barr Newton Road Great Barr Birmingham Birmingham NFA No Independent Evidence Available   52.5429259 -1.9534939
8804 op-snap---monthly-publication-february-2026.pdf   1551 2026-02 Car Ford transit Black Driving without Reasonable Consideration None A45 Heartlands parkway Heartlands parkway Birmingham Birmingham Warning Letter N/A   52.5038363 -1.8432663
11290 op-snap---monthly-publication-january-2026.pdf   751 2026-01 Car Renault Austral White Driving without Reasonable Consideration None Bescor Road M6 j9 Bescor Road M6 j9 Walsall Walsall Education N/A      
11504 op-snap---monthly-publication-january-2026.pdf   965 2026-01 Car Seat leon White Driving without Reasonable Consideration No Insurance Wrens Nest Road Wrens Nest Road Dudley Dudley Court N/A   52.5253252 -2.0995407
4039 op-snap---monthly-publication-december-2025.pdf   167 2025-12 Car Ford Fiesta White Driving without Reasonable Consideration None Black Country New Road Black Country New Road Sandwell Sandwell Education N/A   52.5527191 -2.0312967
4619 op-snap---monthly-publication-december-2025.pdf   747 2025-12 Car Volkswagen Passat Grey Driving without Reasonable Consideration None M6 NB 4-5 M6 Northbound 4-5 Birmingham Birmingham Education N/A      
4724 op-snap---monthly-publication-december-2025.pdf   852 2025-12 Car Nissan Qashqai White Driving without Reasonable Consideration None Stafford Rd Stafford Road Wolverhampton Wolverhampton NFA No Offence   52.6291998 -2.126312
20481 op-snap---monthly-publication-november-2025.pdf   23 2025-11 Car Skoda Kodiaq Black Driving without Reasonable Consideration None Lawley Middleway Lawley Middleway Birmingham Birmingham Warning Letter N/A   52.4801772 -1.8769185
20489 op-snap---monthly-publication-november-2025.pdf   31 2025-11 Car Jaecoo Delux Black Driving without Reasonable Consideration None M42 Solihull M42 Solihull Birmingham Birmingham NFA No Offence   52.4711059 -1.8461809
20695 op-snap---monthly-publication-november-2025.pdf   237 2025-11 Car Renault Clio Silver Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
20697 op-snap---monthly-publication-november-2025.pdf   239 2025-11 Car Renault Megane Black Driving without Reasonable Consideration None M6 10A M6 10A Walsall Walsall Education N/A   52.6082749 -2.021764
21240 op-snap---monthly-publication-november-2025.pdf   782 2025-11 Car Hyundai i30 blue Driving without Reasonable Consideration None M5 Northbound, West Mercia M5 Northbound, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
22023 op-snap---monthly-publication-november-2025.pdf   1565 2025-11 Car BMW 520 Grey Driving without Reasonable Consideration None A45 A45 Coventry Coventry Warning Letter N/A      
22198 op-snap---monthly-publication-october-2025.pdf   148 2025-10 Car Ford Fiesta Red Driving without Reasonable Consideration None A4053 RIng Road A4053 RIng Road Coventry Coventry Education N/A      
22365 op-snap---monthly-publication-october-2025.pdf   315 2025-10 Car Peugeot 107 Black Driving without Reasonable Consideration None Heeley Road Heeley Road Birmingham Birmingham Court N/A   52.4401847 -1.9331572
22762 op-snap---monthly-publication-october-2025.pdf   712 2025-10 Car BMW 330 Black Driving without Reasonable Consideration None Grove Lane Grove Lane Birmingham Birmingham Warning Letter N/A   52.5055208 -1.9328067
22793 op-snap---monthly-publication-october-2025.pdf   743 2025-10 Car BMW 530 Black Driving without Reasonable Consideration None Grove Lane Grove Lane Birmingham Birmingham Education N/A   52.5055208 -1.9328067
23321 op-snap---monthly-publication-october-2025.pdf   1271 2025-10 Car Daf Tipper White Driving without Reasonable Consideration None Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
23790 op-snap---monthly-publication-september-2025.pdf   9 2025-09 Car Volkswagen Crafter Grey Driving without Reasonable Consideration None St Peters Driv, Worcester Street Peters Driv, Worcester Out of Force Area Out of Force Area NFA Out of Force      
23822 op-snap---monthly-publication-september-2025.pdf   41 2025-09 Car Audi A4 White Driving without Reasonable Consideration None a45 A45 Coventry Coventry Warning Letter N/A      
23865 op-snap---monthly-publication-september-2025.pdf   84 2025-09 Car Audi A3 Black Driving without Reasonable Consideration None M6 J12 M6 J12 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
23884 op-snap---monthly-publication-september-2025.pdf   103 2025-09 Car   Polestar Black Driving without Reasonable Consideration None Bickenhill Lane Bickenhill Lane Solihull Solihull NFA No Offence   52.4490463 -1.7296897
23933 op-snap---monthly-publication-september-2025.pdf   152 2025-09 Car Volvo S40 Silver Driving without Reasonable Consideration Use vehicle on a road without valid test certificate Hinckley Road Hinckley Road Coventry Coventry Warning Letter N/A   52.435502 -1.4327166
23963 op-snap---monthly-publication-september-2025.pdf   182 2025-09 Car Ford Transit Silver Driving without Reasonable Consideration No Seat Belt Foleshill Road Foleshill Road Coventry Coventry Court N/A   52.4274335 -1.5002381
23979 op-snap---monthly-publication-september-2025.pdf   198 2025-09 Car Toyota Yaris Black Driving without Reasonable Consideration None Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham NFA No Offence   52.4650893 -1.8425008
24062 op-snap---monthly-publication-september-2025.pdf   281 2025-09 Car Nissan Qashqai Black Driving without Reasonable Consideration None Clifford Street, Newtown Clifford Street, Newtown Birmingham Birmingham Warning Letter N/A   52.4989738 -1.9005402
24063 op-snap---monthly-publication-september-2025.pdf   282 2025-09 Car Mercedes-Benz B180 Blue Driving without Reasonable Consideration None A38 Minworth Island Minworth Island Birmingham Birmingham Education N/A   52.5316279 -1.7762358
24075 op-snap---monthly-publication-september-2025.pdf   294 2025-09 Car Land Rover Range Black Driving without Reasonable Consideration None Hereford Ring Road Hereford Ring Road Out of Force Area Out of Force Area NFA Out of Force      
24167 op-snap---monthly-publication-september-2025.pdf   386 2025-09 Car Honda civic White Driving without Reasonable Consideration None M5 J3 M5 J3 Birmingham Birmingham Education N/A   52.4846642 -1.9297585
24190 op-snap---monthly-publication-september-2025.pdf   409 2025-09 Car Kia Ceed White Driving without Reasonable Consideration None Neachells Lane, Neachells Lane Wolverhampton Wolverhampton Warning Letter N/A   52.597459 -2.0791894
24203 op-snap---monthly-publication-september-2025.pdf   422 2025-09 Car Peugeot 208 Grey Driving without Reasonable Consideration None M1 J21 - Leicester M1 J21 - Leicester Out of Force Area Out of Force Area NFA Out of Force      
24205 op-snap---monthly-publication-september-2025.pdf   424 2025-09 Car Scania HGV white Driving without Reasonable Consideration None Tyburn House Island Tyburn House Island Birmingham Birmingham Warning Letter N/A   52.5194011 -1.8008643
24255 op-snap---monthly-publication-september-2025.pdf   474 2025-09 Car Lexus RX400 Blue Driving without Reasonable Consideration None Alum Rock Road Alum Rock Road Birmingham Birmingham Education N/A   52.4883936 -1.8310056
24285 op-snap---monthly-publication-september-2025.pdf   504 2025-09 Car BMW 320 White Driving without Reasonable Consideration None Princetorpe Way Princetorpe Way Coventry Coventry Education N/A      
24300 op-snap---monthly-publication-september-2025.pdf   519 2025-09 Car Kia sportage Silver Driving without Reasonable Consideration None Cateswell Road Cateswell Road Birmingham Birmingham Education N/A   52.4387009 -1.8454267
24320 op-snap---monthly-publication-september-2025.pdf   539 2025-09 Car Ford Transit White Driving without Reasonable Consideration None Gravelly Hil Gravelly Hil Birmingham Birmingham Warning Letter N/A      
24324 op-snap---monthly-publication-september-2025.pdf   543 2025-09 Car Mercedes-Benz GLC 300 Black Driving without Reasonable Consideration No Insurance Solihull bypass Solihull bypass Solihull Solihull Court N/A   52.4207529 -1.7757467
24330 op-snap---monthly-publication-september-2025.pdf   549 2025-09 Car Volkswagen Crafter White Driving without Reasonable Consideration None Black Country New Road Black Country New Road Sandwell Sandwell NFA No Offence   52.5527191 -2.0312967
24332 op-snap---monthly-publication-september-2025.pdf   551 2025-09 Car Mercedes-Benz Smart Car Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
24336 op-snap---monthly-publication-september-2025.pdf   555 2025-09 Car Audi S3 Black Driving without Reasonable Consideration None Meadway Meadway Birmingham Birmingham Warning Letter N/A   52.4783348 -1.8007708
24376 op-snap---monthly-publication-september-2025.pdf   595 2025-09 Car Volkswagen crafter White Driving without Reasonable Consideration No Insurance College Road College Road Birmingham Birmingham Court N/A   52.5151832 -1.9361664
24505 op-snap---monthly-publication-september-2025.pdf   724 2025-09 Car Volvo XC90 Black Driving without Reasonable Consideration None Webster Way Webster Way Sutton Coldfield Sutton Coldfield Court N/A   52.5445328 -1.7884784
24509 op-snap---monthly-publication-september-2025.pdf   728 2025-09 Car Daf Trucks White Driving without Reasonable Consideration None M42 J9 M42 J9 Out of Force Area Out of Force Area NFA Out of Force   52.3601724 -1.8062199
24625 op-snap---monthly-publication-september-2025.pdf   844 2025-09 Car Ford Smax Grey Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A   52.4134557 -1.4442138
24629 op-snap---monthly-publication-september-2025.pdf   848 2025-09 Car Mercedes-Benz GLC220 White Driving without Reasonable Consideration None High Street High Street Sandwell Sandwell Education N/A   52.5128738 -1.9842054
24688 op-snap---monthly-publication-september-2025.pdf   907 2025-09 Car Ford Fiesta Black Driving without Reasonable Consideration None Birmingham Road Birmingham Road Walsall Walsall Warning Letter N/A   52.5723244 -1.9607214
24692 op-snap---monthly-publication-september-2025.pdf   911 2025-09 Car Vauxhall Grandland Black Driving without Reasonable Consideration None Robin Hood Island Robin Hood Island Birmingham Birmingham Warning Letter N/A   52.4220705 -1.8372335
24727 op-snap---monthly-publication-september-2025.pdf   946 2025-09 Car Ford Transit White Driving without Reasonable Consideration None Bickenhill Lane / Station Link Road Island Bickenhill Lane / Station Link Road Island Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
24728 op-snap---monthly-publication-september-2025.pdf   947 2025-09 Car Volkswagen T-Roc Grey Driving without Reasonable Consideration None Bickenhill Lane / Station Link Road Island Bickenhill Lane / Station Link Road Island Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
24729 op-snap---monthly-publication-september-2025.pdf   948 2025-09 Car Honda Jazz Blue Driving without Reasonable Consideration None Bickenhill Lane / Station Link Road Island Bickenhill Lane / Station Link Road Island Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
24813 op-snap---monthly-publication-september-2025.pdf   1032 2025-09 Car Nissan NOTE Black Driving without Reasonable Consideration None Yardley wood Road Yardley wood Road Birmingham Birmingham Fixed Penalty N/A   52.4103191 -1.8670224
24869 op-snap---monthly-publication-september-2025.pdf   1088 2025-09 Car Hyundai Kona Grey Driving without Reasonable Consideration None A45 A45 Birmingham Birmingham Warning Letter N/A      
24879 op-snap---monthly-publication-september-2025.pdf   1098 2025-09 Car Peugeot Expert White Driving without Reasonable Consideration None Monument Road Monument Road Birmingham Birmingham NFA No Offence   52.4731312 -1.930947
2055 op-snap---monthly-publication-august-2025.pdf   30 2025-08 Car Ford Fiesta Grey Driving without Reasonable Consideration None Friston Av Friston Avenue Birmingham Birmingham Warning Letter N/A   52.4744592 -1.9198786
2143 op-snap---monthly-publication-august-2025.pdf   118 2025-08 Car Honda civic Silver Driving without Reasonable Consideration No Insurance Haslucks Green Road Haslucks Green Road Birmingham Birmingham Court N/A      
2189 op-snap---monthly-publication-august-2025.pdf   164 2025-08 Car Ford fiesta Black Driving without Reasonable Consideration None Fenton Street Fenton Street Sandwell Sandwell Education N/A   52.5004036 -1.9790049
2275 op-snap---monthly-publication-august-2025.pdf   250 2025-08 Car Toyota Prius Silver Driving without Reasonable Consideration None Alum Rock Road Alum Rock Road Birmingham Birmingham NFA No Offence   52.4883936 -1.8310056
2312 op-snap---monthly-publication-august-2025.pdf   287 2025-08 Car Ford kuga Grey Driving without Reasonable Consideration None M6 J10 M6 J10 Walsall Walsall NFA No Independent Evidence Available   52.676119 -2.0858425
2327 op-snap---monthly-publication-august-2025.pdf   302 2025-08 Car Audi S3 Grey Driving without Reasonable Consideration None M242 J5 M242 J5 Solihull Solihull Education N/A      
2378 op-snap---monthly-publication-august-2025.pdf   353 2025-08 Car Ford Transit White Driving without Reasonable Consideration None Station Road, Marston Green Station Road, Marston Green Solihull Solihull Education N/A   52.4667342 -1.747421
2388 op-snap---monthly-publication-august-2025.pdf   363 2025-08 Car Volkswagen Golf Grey Driving without Reasonable Consideration None Heybarnes Road Heybarnes Road Birmingham Birmingham NFA No Independent Evidence Available   52.4677423 -1.8351236
2393 op-snap---monthly-publication-august-2025.pdf   368 2025-08 Car Kia Sportage Grey Driving without Reasonable Consideration None Wolverhampton Road Wolverhampton Road Dudley Dudley Warning Letter N/A   52.5063917 -2.1711502
2408 op-snap---monthly-publication-august-2025.pdf   383 2025-08 Car Nissan Juke Silver Driving without Reasonable Consideration None M5 Motorway SB M5 Motorway Southbound Sandwell Sandwell Warning Letter N/A      
2432 op-snap---monthly-publication-august-2025.pdf   407 2025-08 Car Nissan X-Trail Silver Driving without Reasonable Consideration None A45 Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
2513 op-snap---monthly-publication-august-2025.pdf   488 2025-08 Car Toyota Corolla Grey Driving without Reasonable Consideration None Hamstead Hill Hamstead Hill Birmingham Birmingham Warning Letter N/A   52.5274116 -1.9287273
2550 op-snap---monthly-publication-august-2025.pdf   525 2025-08 Car Audi A1 Grey Driving without Reasonable Consideration None Woodgreen Drive (Worcester) Woodgreen Drive (Worcester) Out of Force Are Out of Force Area NFA Out of Force      
2556 op-snap---monthly-publication-august-2025.pdf   531 2025-08 Car Ford Kuga Blue Driving without Reasonable Consideration None Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
2699 op-snap---monthly-publication-august-2025.pdf   674 2025-08 Car Mg Exclusive White Driving without Reasonable Consideration None Icknield Street Icknield Street Birmingham Birmingham Education N/A   52.5709191 -1.8759339
2710 op-snap---monthly-publication-august-2025.pdf   685 2025-08 Car Volkswagen Golf Grey Driving without Reasonable Consideration None Jimmy Hill WAY Jimmy Hill WAY Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
2799 op-snap---monthly-publication-august-2025.pdf   774 2025-08 Car Citroen Dispatch White Driving without Reasonable Consideration None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Education N/A   52.5517052 -1.7825505
2810 op-snap---monthly-publication-august-2025.pdf   785 2025-08 Car Vauxhall Corsa Silver Driving without Reasonable Consideration None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton NFA No Offence   52.5847884 -2.1341887
2816 op-snap---monthly-publication-august-2025.pdf   791 2025-08 Car Audi A5 Black Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.5919543 -1.8517118
2826 op-snap---monthly-publication-august-2025.pdf   801 2025-08 Car Audi A3 Grey Driving without Reasonable Consideration None Mere Green Road Mere Green Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5874888 -1.8297106
2827 op-snap---monthly-publication-august-2025.pdf   802 2025-08 Car Renault   White Driving without Reasonable Consideration None A447 Ashby Road Ashby Road Out of Force Are Out of Force Area NFA Out of Force      
2829 op-snap---monthly-publication-august-2025.pdf   804 2025-08 Car Porsche Cayenne Blue Driving without Reasonable Consideration None Kirby Corner Island Kirby Corner Island Coventry Coventry Warning Letter N/A      
2855 op-snap---monthly-publication-august-2025.pdf   830 2025-08 Car Nissan Primastar Grey Driving without Reasonable Consideration None St Andrews Road Street Andrews Road Dudley Dudley Warning Letter N/A      
2857 op-snap---monthly-publication-august-2025.pdf   832 2025-08 Car Mercedes-Benz A class Silver Driving without Reasonable Consideration None St Andrews Street, Netherton Street Andrews Street, Netherton Dudley Dudley Warning Letter N/A   52.4905847 -2.0868385
2860 op-snap---monthly-publication-august-2025.pdf   835 2025-08 Car Skoda Karoq White Driving without Reasonable Consideration None St Andrews Road Street Andrews Road Dudley Dudley Warning Letter N/A      
2914 op-snap---monthly-publication-august-2025.pdf   889 2025-08 Car Kia   Grey Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham NFA No Offence   52.4543565 -1.9114004
2919 op-snap---monthly-publication-august-2025.pdf   894 2025-08 Car Volkswagen Touran Black Driving without Reasonable Consideration None Battery Way Battery Way Birmingham Birmingham Warning Letter N/A   52.4493988 -1.8476406
2933 op-snap---monthly-publication-august-2025.pdf   908 2025-08 Car Audi Q3 Blue Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
3058 op-snap---monthly-publication-august-2025.pdf   1033 2025-08 Car Seat Alhambra Silver Driving without Reasonable Consideration None High Bullen Roundabout High Bullen Roundabout Sandwell Sandwell Education N/A   52.5539516 -2.0223468
3120 op-snap---monthly-publication-august-2025.pdf   1095 2025-08 Car Ford Fiesta Blue Driving without Reasonable Consideration None Bickenhill Lane Bickenhill Lane Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
3153 op-snap---monthly-publication-august-2025.pdf   1128 2025-08 Car Citroen Relay Grey Driving without Reasonable Consideration None Coleshill Road Coleshill Road Birmingham Birmingham NFA No Offence   52.4967329 -1.8097462
3187 op-snap---monthly-publication-august-2025.pdf   1162 2025-08 Car Peugeot Van White Driving without Reasonable Consideration None Thornhill Road Thornhill Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5690586 -1.8794686
3196 op-snap---monthly-publication-august-2025.pdf   1171 2025-08 Car Vauxhall Adam Red Driving without Reasonable Consideration None M42 Jn 10, Warwickshire M42 Junction 10, Warwickshire Out of Force Are Out of Force Area NFA Out of Force      
3199 op-snap---monthly-publication-august-2025.pdf   1174 2025-08 Car Audi A3 White Driving without Reasonable Consideration None Chester Road, New Oscott Chester Road, New Oscott Birmingham Birmingham Warning Letter N/A   52.5459731 -1.8568254
3201 op-snap---monthly-publication-august-2025.pdf   1176 2025-08 Car Ford puma White Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
3784 op-snap---monthly-publication-august-2025.pdf   1759 2025-08 Car Ford Focus Blue Driving without Reasonable Consideration None Torrington Avenue Torrington Avenue Coventry Coventry Warning Letter N/A   52.3987354 -1.567693
11953 op-snap---monthly-publication-july-2025.pdf   5 2025-07 Car Ford Fiesta Orange Driving without Reasonable Consideration None Oldbury Ring Way Oldbury Ring Way Sandwell Sandwell NFA Outside of 14 Days NIP      
11962 op-snap---monthly-publication-july-2025.pdf   14 2025-07 Car Nissan Micra Red Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4470686 -1.8880749
11977 op-snap---monthly-publication-july-2025.pdf   29 2025-07 Car Volkswagen PX15PHF White Driving without Reasonable Consideration None Parkfields Road Parkfields Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission      

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