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

1,763 rows where offence = "Driving without Reasonable Consideration" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

vehicle_make >30

month 14

reporter_transport_mode 12

offence 1

  • Driving without Reasonable Consideration · 1,763 ✖
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
8006 op-snap---monthly-publication-february-2026.pdf   753 2026-02 Bus Ford puma Black Driving without Reasonable Consideration None Castle square Castle square Sandwell Sandwell Other Action Taken N/A      
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
8498 op-snap---monthly-publication-february-2026.pdf   1245 2026-02 Pedal Bike Jaguar XF White Driving without Reasonable Consideration None The Broadway The Broadway Dudley Dudley Education N/A   52.515445 -2.0885791
8522 op-snap---monthly-publication-february-2026.pdf   1269 2026-02 Horse Rider Porsche Boxter Red Driving without Reasonable Consideration None Worcester Lane Worcester Lane Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5908671 -1.8140277
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
11000 op-snap---monthly-publication-january-2026.pdf   461 2026-01 Pedal Bike Volkswagen   Silver Driving without Reasonable Consideration None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
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
11515 op-snap---monthly-publication-january-2026.pdf   976 2026-01 Lorry Volkswagen Tiguan Grey Driving without Reasonable Consideration None M1 J24 - Leicester M1 J24 - Leicester Out of Force Area Out of Force Area NFA Out of Force      
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
20635 op-snap---monthly-publication-november-2025.pdf   177 2025-11 Pedal Bike Toyota Auris Blue Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
20694 op-snap---monthly-publication-november-2025.pdf   236 2025-11 Pedal Bike Audi TT Silver Driving without Reasonable Consideration None Sedgley Rd West Sedgley Road West Dudley Dudley Education N/A   52.5301627 -2.0799509
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      
21496 op-snap---monthly-publication-november-2025.pdf   1038 2025-11 Pedal Bike Nissan Qashqai Blue Driving without Reasonable Consideration None Norfolk Road Norfolk Road Birmingham Birmingham Education N/A   52.4672547 -1.9435381
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      
22065 op-snap---monthly-publication-october-2025.pdf   15 2025-10 Pedal Bike Audi   Black Driving without Reasonable Consideration None Castle Road Castle Road Out of Force Area Out of Force Area NFA Out of Force   52.4358056 -1.9593904
22095 op-snap---monthly-publication-october-2025.pdf   45 2025-10 Pedal Bike Volkswagen ID Yellow Driving without Reasonable Consideration None Weoley Park Weoley Park Birmingham Birmingham NFA No Offence   52.4353726 -1.9460178
22111 op-snap---monthly-publication-october-2025.pdf   61 2025-10 Pedal Bike Citroen   Silver Driving without Reasonable Consideration None Earlsdon Ave Earlsdon Ave Coventry Coventry NFA No Independent Evidence Available   52.4047134 -1.5351834
22190 op-snap---monthly-publication-october-2025.pdf   140 2025-10 Pedal Bike Mercedes-Benz   White Driving without Reasonable Consideration None Cornets End Lane Cornets End Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4269547 -1.6668911
22193 op-snap---monthly-publication-october-2025.pdf   143 2025-10 Pedal Bike Audi A3 Grey Driving without Reasonable Consideration None Broad Lane Broad Lane Coventry Coventry NFA Outside of 14 Days NIP   52.4074716 -1.5620671
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
22624 op-snap---monthly-publication-october-2025.pdf   574 2025-10 Pedal Bike Vauxhall Crossland White Driving without Reasonable Consideration None Hagley Road Halesowen Hagley Road Halesowen Dudley Dudley Education N/A   52.4476209 -2.051289
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
22795 op-snap---monthly-publication-october-2025.pdf   745 2025-10 Motorbike Audi S4 Blue Driving without Reasonable Consideration None Astwood Bank Astwood Bank Out of Force Area Out of Force Area NFA Out of Force      
22926 op-snap---monthly-publication-october-2025.pdf   876 2025-10 Pedal Bike Vauxhall Insigia Silver Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
22985 op-snap---monthly-publication-october-2025.pdf   935 2025-10 Horse Rider BMW 225xe Blue Driving without Reasonable Consideration None Withybrook Road, Bedworth Withybrook Road, Bedworth Out of Force Area Out of Force Area NFA Out of Force      
23299 op-snap---monthly-publication-october-2025.pdf   1249 2025-10 Pedestrian Iveco Daily White Driving without Reasonable Consideration None Cockshed Lane Cockshed Lane Halesowen Halesowen Warning Letter N/A      
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
23380 op-snap---monthly-publication-october-2025.pdf   1330 2025-10 Pedestrian Ford Transit White Driving without Reasonable Consideration None Cheveral Avenue Cheveral Avenue Coventry Coventry Warning Letter N/A   52.4257402 -1.5185037
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      
23791 op-snap---monthly-publication-september-2025.pdf   10 2025-09 Pedal Bike Nissan NV400 White Driving without Reasonable Consideration None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
23800 op-snap---monthly-publication-september-2025.pdf   19 2025-09 Pedal Bike Ford Fiesta Black Driving without Reasonable Consideration None West Heath Road West Heath Road Birmingham Birmingham Education N/A   52.402785 -1.9620058
23801 op-snap---monthly-publication-september-2025.pdf   20 2025-09 Pedal Bike BMW   Blue Driving without Reasonable Consideration None West Heath Road West Heath Road Birmingham Birmingham Education N/A   52.402785 -1.9620058
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      
23830 op-snap---monthly-publication-september-2025.pdf   49 2025-09 Pedal Bike Audi A1 Grey Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Warning Letter N/A   52.4086244 -1.515132
23832 op-snap---monthly-publication-september-2025.pdf   51 2025-09 Pedal Bike Chevrolet Matiz Orange Driving without Reasonable Consideration None Cheveral Avenue Cheveral Avenue Coventry Coventry NFA No Offence   52.4257402 -1.5185037
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
23909 op-snap---monthly-publication-september-2025.pdf   128 2025-09 Pedal Bike Skoda Rapid Grey Driving without Reasonable Consideration None New Street New Street Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4791344 -1.8986915
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
23961 op-snap---monthly-publication-september-2025.pdf   180 2025-09 Pedal Bike Peugeot Partner White Driving without Reasonable Consideration None Merritts Hill Merritts Hill Birmingham Birmingham Education N/A   52.424853 -1.9814275
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
23965 op-snap---monthly-publication-september-2025.pdf   184 2025-09 Pedal Bike Vauxhall Insignia Silver Driving without Reasonable Consideration None Station Road Marston Green Station Road Marston Green Solihull Solihull Warning Letter N/A   52.4667342 -1.747421
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
24013 op-snap---monthly-publication-september-2025.pdf   232 2025-09 Pedal Bike Peugeot 207 Black Driving without Reasonable Consideration None St Marys Row Street Marys Row Birmingham Birmingham Warning Letter N/A      
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      
24289 op-snap---monthly-publication-september-2025.pdf   508 2025-09 Pedal Bike Volvo V40 Blue Driving without Reasonable Consideration None Henwick Road Henwick Road Out of Force Area Out of Force Area NFA Out of Force      
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
24305 op-snap---monthly-publication-september-2025.pdf   524 2025-09 Pedal Bike Volkswagen Polo Black Driving without Reasonable Consideration None School Road School Road Solihull Solihull Education N/A   52.3517888 -1.7783232
24312 op-snap---monthly-publication-september-2025.pdf   531 2025-09 Pedal Bike Toyota yaris Silver Driving without Reasonable Consideration None Radford Road/Wallace Road Radford Road/Wallace Road Coventry Coventry Education N/A   52.4235908 -1.5226276
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
24578 op-snap---monthly-publication-september-2025.pdf   797 2025-09 Pedal Bike Peugeot 308 Silver Driving without Reasonable Consideration None Marston Lane Marston Lane Out of Force Area Out of Force Area NFA Out of Force   52.4670062 -1.7548427
24581 op-snap---monthly-publication-september-2025.pdf   800 2025-09 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Wrentham Street Wrentham Street Birmingham Birmingham Education N/A   52.4708757 -1.8966158
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
24633 op-snap---monthly-publication-september-2025.pdf   852 2025-09 Pedal Bike Volkswagen Crafter White Driving without Reasonable Consideration None Earlsdon Avenue North Earlsdon Avenue North Coventry Coventry Education N/A   52.4025196 -1.5327802
24641 op-snap---monthly-publication-september-2025.pdf   860 2025-09 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration No Insurance Harborne Road Harborne Road Birmingham Birmingham Court N/A   52.4718503 -1.9195423
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
24696 op-snap---monthly-publication-september-2025.pdf   915 2025-09 Pedal Bike Peugeot 208.. Red Driving without Reasonable Consideration None Tanworth Lane Tanworth Lane Solihull Solihull Education N/A   52.4014694 -1.8220541
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
24800 op-snap---monthly-publication-september-2025.pdf   1019 2025-09 Pedal Bike Byd Bus Grey Driving without Reasonable Consideration None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter n/a   52.4221152 -1.4959475
24808 op-snap---monthly-publication-september-2025.pdf   1027 2025-09 Other Volkswagen Taigo Blue Driving without Reasonable Consideration None Thorns Hill Thorns Hill Dudley Dudley Fixed Penalty N/A   52.4679374 -2.1184626
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
24815 op-snap---monthly-publication-september-2025.pdf   1034 2025-09 Pedal Bike Land Rover Range Rover White Driving without Reasonable Consideration None Cut Throat Lane Cut Throat Lane Solihull Solihull Court N/A      
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

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