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

105 rows where month = "2025-06" and offence = "Driving without Reasonable Consideration" 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 5

disposal 5

offence 1

  • Driving without Reasonable Consideration · 105 ✖

month 1

  • 2025-06 · 105 ✖
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
14078 op-snap---monthly-publication-june-2025.pdf   7 2025-06 Car Renault Van Blue Driving without Reasonable Consideration None M5 M5 Out of Force Area Out of Force Area NFA Out of Force      
14084 op-snap---monthly-publication-june-2025.pdf   13 2025-06 Pedal Bike Audi Q5 Silver Driving without Reasonable Consideration None GRANGE ROAD Grange Road Solihull Solihull NFA No Independent Evidence Available   52.4285724 -1.8019101
14097 op-snap---monthly-publication-june-2025.pdf   26 2025-06 Car Ford Transit White Driving without Reasonable Consideration None Bloxwich Lane Bloxwich Lane Walsall Walsall Warning Letter N/A   52.6020474 -2.014682
14130 op-snap---monthly-publication-june-2025.pdf   59 2025-06 Car BMW 3 series Grey Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
14131 op-snap---monthly-publication-june-2025.pdf   60 2025-06 Car Fiat 500 Black Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
14135 op-snap---monthly-publication-june-2025.pdf   64 2025-06 Car Audi A4 Grey Driving without Reasonable Consideration None B4101 B4101 Birmingham Birmingham NFA No Offence   52.5079951 -1.9495377
14146 op-snap---monthly-publication-june-2025.pdf   75 2025-06 Car Toyota Aygo Silver Driving without Reasonable Consideration None Radford Road Radford Road Coventry Coventry Education N/A   52.4235908 -1.5226276
14148 op-snap---monthly-publication-june-2025.pdf   77 2025-06 Car Mg three Black Driving without Reasonable Consideration None Avenue Road Avenue Road Birmingham Birmingham Warning Letter N/A   52.4941712 -1.8795158
14150 op-snap---monthly-publication-june-2025.pdf   79 2025-06 Car Land Rover Vogue Gold Driving without Reasonable Consideration None M5 South M5 South Sandwell Sandwell NFA Outside of 14 Days NIP   52.5228877 -2.0650728
14155 op-snap---monthly-publication-june-2025.pdf   84 2025-06 Car Ford Ranger White Driving without Reasonable Consideration None Smithy Lane Smithy Lane Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5094086 -2.1346957
14157 op-snap---monthly-publication-june-2025.pdf   86 2025-06 Car Vauxhall Corsa White Driving without Reasonable Consideration None Milking Bank Milking Bank Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5182185 -2.1123641
14158 op-snap---monthly-publication-june-2025.pdf   87 2025-06 Car Yamaha ns50 Grey Driving without Reasonable Consideration None A4152 at A452 A4152 at A452 Walsall Walsall Warning Letter N/A   52.5805622 -1.9769245
14178 op-snap---monthly-publication-june-2025.pdf   107 2025-06 Pedal Bike Porsche 911 Blue Driving without Reasonable Consideration None Highlands Road Highlands Road Birmingham Birmingham NFA No Offence      
14223 op-snap---monthly-publication-june-2025.pdf   152 2025-06 Pedestrian Peugeot Partner White Driving without Reasonable Consideration None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
14227 op-snap---monthly-publication-june-2025.pdf   156 2025-06 Car Peugeot 207 Blue Driving without Reasonable Consideration None Coleshill Road Coleshill Road Birmingham Birmingham Education N/A   52.4967329 -1.8097462
14232 op-snap---monthly-publication-june-2025.pdf   161 2025-06 Pedal Bike Audi A1 S LINE White Driving without Reasonable Consideration None STRATFORD ROAD Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
14246 op-snap---monthly-publication-june-2025.pdf   175 2025-06 Car Daf HGV Yellow Driving without Reasonable Consideration None M42 M42 Solihull Solihull NFA No Independent Evidence Available      
14248 op-snap---monthly-publication-june-2025.pdf   177 2025-06 Car   NP   Driving without Reasonable Consideration None Great Barr Great Barr Birmingham Birmingham NFA No VRM   52.5309945 -1.9288687
14249 op-snap---monthly-publication-june-2025.pdf   178 2025-06 Car BMW 1 series White Driving without Reasonable Consideration None Leamington Spa Leamington Spa Out of Force Area Out of Force Area NFA Out of Force      
14257 op-snap---monthly-publication-june-2025.pdf   186 2025-06 Car Seat Ibiza White Driving without Reasonable Consideration None Mintague St Mintague Street Birmingham Birmingham NFA Not in Public Interest      
14263 op-snap---monthly-publication-june-2025.pdf   192 2025-06 Car Toyota Yaris Silver Driving without Reasonable Consideration None Belgrave Road Belgrave Road Birmingham Birmingham Warning Letter N/A   52.4669004 -1.9011385
14265 op-snap---monthly-publication-june-2025.pdf   194 2025-06 Pedal Bike Hyundai I30.. White Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
14266 op-snap---monthly-publication-june-2025.pdf   195 2025-06 Pedal Bike Volkswagen Transporter White Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
14270 op-snap---monthly-publication-june-2025.pdf   199 2025-06 Car BMW 3 Series Red Driving without Reasonable Consideration None Horsely Fields Horsely Fields Sandwell Sandwell Education N/A      
14284 op-snap---monthly-publication-june-2025.pdf   213 2025-06 Car Ford Ranger White Driving without Reasonable Consideration None Highbridge Road Highbridge Road Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5472182 -1.8359595
14298 op-snap---monthly-publication-june-2025.pdf   227 2025-06 Car Daf HGV White Driving without Reasonable Consideration None Newport Road Newport Road Out of Force Area Out of Force Area NFA Out of Force   52.5024739 -1.7975977
14317 op-snap---monthly-publication-june-2025.pdf   246 2025-06 Car   Lotus Black Driving without Reasonable Consideration None Tyburn Island Tyburn Island Birmingham Birmingham Education N/A   52.5193542 -1.800381
14327 op-snap---monthly-publication-june-2025.pdf   256 2025-06 Car Volvo XC60 Grey Driving without Reasonable Consideration None Spring Lane Spring Lane Birmingham Birmingham Warning Letter N/A   52.5182019 -1.8336169
14329 op-snap---monthly-publication-june-2025.pdf   258 2025-06 Car Volkswagen Touran Grey Driving without Reasonable Consideration None New John Street West New John Street West Birmingham Birmingham NFA Outside of 14 Days NIP   52.4944784 -1.9122329
14330 op-snap---monthly-publication-june-2025.pdf   259 2025-06 Car BMW 3 series Grey Driving without Reasonable Consideration No vehicle excise licence New John Street West New John Street West Birmingham Birmingham NFA Outside of 14 Days NIP   52.4944784 -1.9122329
14338 op-snap---monthly-publication-june-2025.pdf   267 2025-06 Car Ford Puma Blue Driving without Reasonable Consideration None Kingston Road Kingston Road Birmingham Birmingham Warning Letter N/A   52.4747333 -1.8728345
14340 op-snap---monthly-publication-june-2025.pdf   269 2025-06 Car Mercedes-Benz A180 Black Driving without Reasonable Consideration None Kingston Road Kingston Road Birmingham Birmingham Warning Letter N/A   52.4747333 -1.8728345
14341 op-snap---monthly-publication-june-2025.pdf   270 2025-06 Car Audi A3 Green Driving without Reasonable Consideration None Kington Road Kington Road Birmingham Birmingham Warning Letter N/A      
14342 op-snap---monthly-publication-june-2025.pdf   271 2025-06 Car Hyundai I20 Grey Driving without Reasonable Consideration None Kington Road Kington Road Birmingham Birmingham Warning Letter N/A      
14343 op-snap---monthly-publication-june-2025.pdf   272 2025-06 Car Audi Q3 Silver Driving without Reasonable Consideration None Kington Road Kington Road Birmingham Birmingham Warning Letter N/A      
14362 op-snap---monthly-publication-june-2025.pdf   291 2025-06 Car Mini Cooper Red Driving without Reasonable Consideration None Stratford Road Stratford Road Solihull Solihull Fixed Penalty N/A   52.4191184 -1.8326637
14378 op-snap---monthly-publication-june-2025.pdf   307 2025-06 Car Toyota Prius White Driving without Reasonable Consideration None Hill Street Hill Street Birmingham Birmingham NFA No Offence   52.4777765 -1.901321
14409 op-snap---monthly-publication-june-2025.pdf   338 2025-06 Car   Scancia White Driving without Reasonable Consideration None Cinder Bank Cinder Bank Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.4951209 -2.0924902
14418 op-snap---monthly-publication-june-2025.pdf   347 2025-06 Car BMW 218I Black Driving without Reasonable Consideration None Kenpas Highway Kenpas Highway Birmingham Birmingham NFA Outside of 14 Days NIP      
14424 op-snap---monthly-publication-june-2025.pdf   353 2025-06 Car Volvo HGV Grey Driving without Reasonable Consideration None Heartlands Parkway Heartlands Parkway Birmingham Birmingham NFA No Independent Evidence Available   52.5038363 -1.8432663
14436 op-snap---monthly-publication-june-2025.pdf   365 2025-06 Car Audi S3 Yellow Driving without Reasonable Consideration None Bath Row Bath Row Birmingham Birmingham NFA No VRM   52.472238 -1.9127983
14441 op-snap---monthly-publication-june-2025.pdf   370 2025-06 Pedal Bike BMW 3 SERIES Blue Driving without Reasonable Consideration None LICHFIELD ROAD Lichfield Road Birmingham Birmingham Education N/A   52.5012458 -1.8780942
14452 op-snap---monthly-publication-june-2025.pdf   381 2025-06 Car Ford transit Grey Driving without Reasonable Consideration None Cat Lane Cat Lane Birmingham Birmingham NFA No Independent Evidence Available   52.5000715 -1.7840322
14472 op-snap---monthly-publication-june-2025.pdf   401 2025-06 Car Seat Ateca Grey Driving without Reasonable Consideration None Hawbush Road Hawbush Road Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.6037191 -1.9834465
14481 op-snap---monthly-publication-june-2025.pdf   410 2025-06 Pedal Bike Seat Ibiza Grey Driving without Reasonable Consideration None Wrentham St Wrentham Street Birmingham Birmingham Warning Letter N/A   52.4708757 -1.8966158
14503 op-snap---monthly-publication-june-2025.pdf   432 2025-06 Car Land Rover HSE Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
14558 op-snap---monthly-publication-june-2025.pdf   487 2025-06 Car Seat Arona Red Driving without Reasonable Consideration None Yorkminster Drive Yorkminster Drive Birmingham Birmingham Warning Letter N/A      
14693 op-snap---monthly-publication-june-2025.pdf   622 2025-06 Car Porsche Panamera Black Driving without Reasonable Consideration None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
14701 op-snap---monthly-publication-june-2025.pdf   630 2025-06 Pedestrian Jaguar XE Sport Red Driving without Reasonable Consideration None Cotsymore Road Cotsymore Road Sutton Coldfield Sutton Coldfield Warning Letter N/A      
14745 op-snap---monthly-publication-june-2025.pdf   674 2025-06 Car Volkswagen Golf Black Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham NFA Misc Inc Crimes      
14772 op-snap---monthly-publication-june-2025.pdf   701 2025-06 Car Ford Fiesta Red Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham Warning Letter N/A      
14789 op-snap---monthly-publication-june-2025.pdf   718 2025-06 Pedal Bike Peugeot Bipper White Driving without Reasonable Consideration None A38 Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
14791 op-snap---monthly-publication-june-2025.pdf   720 2025-06 Car Vauxhall Corsa Grey Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham Court N/A      
14794 op-snap---monthly-publication-june-2025.pdf   723 2025-06 Car BMW 535D Grey Driving without Reasonable Consideration None Marshlake Road Marshlake Road Solihull Solihull Warning Letter N/A      
14833 op-snap---monthly-publication-june-2025.pdf   762 2025-06 Car Volkswagen Golf White Driving without Reasonable Consideration None Hodge Hill Hodge Hill Birmingham Birmingham NFA No VRM   52.4981788 -1.8112796
14836 op-snap---monthly-publication-june-2025.pdf   765 2025-06 Car Volkswagen LT35 Red Driving without Reasonable Consideration None Upper Green Upper Green Wolverhampton Wolverhampton Warning Letter N/A   52.5991066 -2.168802
14842 op-snap---monthly-publication-june-2025.pdf   771 2025-06 Car Seat   Blue Driving without Reasonable Consideration None Oxford Oxford Out of Force Area Out of Force Area NFA Out of Force      
14845 op-snap---monthly-publication-june-2025.pdf   774 2025-06 Car Skoda Rapid Blue Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham NFA No Offence   52.4543565 -1.9114004
14865 op-snap---monthly-publication-june-2025.pdf   794 2025-06 Car BMW M3 White Driving without Reasonable Consideration None Holly Road Holly Road Birmingham Birmingham Warning Letter N/A   52.473564 -1.94941
15030 op-snap---monthly-publication-june-2025.pdf   959 2025-06 Pedal Bike Vauxhall INSIGNIA Green Driving without Reasonable Consideration None HALLAM STREET Hallam Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4563937 -1.8933429
15034 op-snap---monthly-publication-june-2025.pdf   963 2025-06 Pedal Bike Mg 5 EXCITE Silver Driving without Reasonable Consideration None SPON LANE Spon Lane Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5071465 -2.0049226
15036 op-snap---monthly-publication-june-2025.pdf   965 2025-06 Pedal Bike Jaguar Pace Silver Driving without Reasonable Consideration None Sedgley Road East Sedgley Road East Dudley Dudley Education N/A   52.5209977 -2.0552776
15054 op-snap---monthly-publication-june-2025.pdf   983 2025-06 Pedal Bike Peugeot Partner White Driving without Reasonable Consideration Littering Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
15074 op-snap---monthly-publication-june-2025.pdf   1003 2025-06 Pedal Bike Fiat TRANSIT White Driving without Reasonable Consideration None HURST LANE Hurst Lane Birmingham Birmingham Education N/A   52.4967785 -1.7667723
15087 op-snap---monthly-publication-june-2025.pdf   1016 2025-06 Car Vauxhall Corsa Orange Driving without Reasonable Consideration None Warstock Lane Warstock Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4175988 -1.8774655
15089 op-snap---monthly-publication-june-2025.pdf   1018 2025-06 Car Ford Focus Grey Driving without Reasonable Consideration None Dudley Road East Dudley Road East Sandwell Sandwell Warning Letter N/A   52.5111988 -2.0318469
15101 op-snap---monthly-publication-june-2025.pdf   1030 2025-06 Van BMW 140i blue Driving without Reasonable Consideration None Holbrook Lane Holbrook Lane Coventry Coventry Warning Letter N/A   52.436155 -1.5064002
15115 op-snap---monthly-publication-june-2025.pdf   1044 2025-06 Pedal Bike Renault Kangoo White Driving without Reasonable Consideration None Sutton Park Road Sutton Park Road Out of Force Area Out of Force Area NFA Out of Force   52.5298146 -1.7902196
15121 op-snap---monthly-publication-june-2025.pdf   1050 2025-06 Car Tesla Model Y White Driving without Reasonable Consideration None M6 Jn5 M6 Jn5 Birmingham Birmingham Warning Letter N/A      
15139 op-snap---monthly-publication-june-2025.pdf   1068 2025-06 Pedal Bike Kia Sorento Silver Driving without Reasonable Consideration None Henley In Arden (Wottoon Wawen) Henley In Arden (Wottoon Wawen) Out of Force Area Out of Force Area NFA Out of Force      
15143 op-snap---monthly-publication-june-2025.pdf   1072 2025-06 Car Renault Megane White Driving without Reasonable Consideration None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5940902 -1.843503
15185 op-snap---monthly-publication-june-2025.pdf   1114 2025-06 Pedal Bike Volvo BUS RED Driving without Reasonable Consideration None LAWLEY MIDDLEWAY Lawley Middleway Birmingham Birmingham NFA No Offence   52.4801772 -1.8769185
15190 op-snap---monthly-publication-june-2025.pdf   1119 2025-06 Car Kia NIRO Silver Driving without Reasonable Consideration None WHITTAL STREET Whittal Street Birmingham Birmingham NFA No Offence   52.4847569 -1.8962965
15200 op-snap---monthly-publication-june-2025.pdf   1129 2025-06 Pedal Bike Skoda Octavia White Driving without Reasonable Consideration None Myton Road Myton Road Out of Force Area Out of Force Area NFA Out of Force   52.4106096 -1.4829312
15212 op-snap---monthly-publication-june-2025.pdf   1141 2025-06 Car Citroen c4 Red Driving without Reasonable Consideration None Coronation Road Coronation Road Walsall Walsall Education N/A   52.6234357 -1.955744
15218 op-snap---monthly-publication-june-2025.pdf   1147 2025-06 Car Volkswagen golf Grey Driving without Reasonable Consideration None Woodbridge Road Woodbridge Road Birmingham Birmingham NFA No Offence   52.4482076 -1.8864335
15226 op-snap---monthly-publication-june-2025.pdf   1155 2025-06 Car Volkswagen Tiguan White Driving without Reasonable Consideration None Collector Road Collector Road Birmingham Birmingham Warning Letter N/A   52.5139393 -1.7600186
15239 op-snap---monthly-publication-june-2025.pdf   1168 2025-06 Car Land Rover Discovery Beige Driving without Reasonable Consideration None Maypole Island Maypole Island Birmingham Birmingham Warning Letter N/A   52.4047413 -1.8859323
15259 op-snap---monthly-publication-june-2025.pdf   1188 2025-06 Car Citroen C4 Grey Driving without Reasonable Consideration None A452 Collector Road Collector Road Birmingham Birmingham Warning Letter N/A   52.5139393 -1.7600186
15334 op-snap---monthly-publication-june-2025.pdf   1263 2025-06 Car Mercedes-Benz GLC Black Driving without Reasonable Consideration None M6 M6 Walsall Walsall NFA Outside of 14 Days NIP      
15446 op-snap---monthly-publication-june-2025.pdf   1375 2025-06 Pedal Bike Mercedes-Benz A Class Silver Driving without Reasonable Consideration None Wednesfield Way Wednesfield Way Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.59548 -2.0896906
15456 op-snap---monthly-publication-june-2025.pdf   1385 2025-06 Pedal Bike Ford Ka White Driving without Reasonable Consideration None City Road City Road Birmingham Birmingham Education N/A   52.4763176 -1.9584897
15467 op-snap---monthly-publication-june-2025.pdf   1396 2025-06 Car Peugeot 307 Silver Driving without Reasonable Consideration None Holyhead Road Holyhead Road Birmingham Birmingham Warning Letter N/A   52.505233 -1.9446276
15470 op-snap---monthly-publication-june-2025.pdf   1399 2025-06 Car Ford Mondeo Blue Driving without Reasonable Consideration None A452 towards Erdington A452 towards Erdington Birmingham Birmingham Warning Letter N/A      
15471 op-snap---monthly-publication-june-2025.pdf   1400 2025-06 Car Volkswagen Tiguan Silver Driving without Reasonable Consideration None A452 towards Erdington A452 towards Erdington Birmingham Birmingham Warning Letter N/A      
15472 op-snap---monthly-publication-june-2025.pdf   1401 2025-06 Car Renault Scenic Red Driving without Reasonable Consideration None Tyburn House roundabout Tyburn House roundabout Birmingham Birmingham Warning Letter N/A      
15473 op-snap---monthly-publication-june-2025.pdf   1402 2025-06 Pedal Bike Hyundai I10 White Driving without Reasonable Consideration None Newton Road Newton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4541102 -1.8710993
15474 op-snap---monthly-publication-june-2025.pdf   1403 2025-06 Pedal Bike Volkswagen Golf White Driving without Reasonable Consideration None Newton Road Newton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4541102 -1.8710993
15479 op-snap---monthly-publication-june-2025.pdf   1408 2025-06 Motorbike Volkswagen Polo Silver Driving without Reasonable Consideration None Commandery Road, Worcester Commandery Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
15507 op-snap---monthly-publication-june-2025.pdf   1436 2025-06 Car BMW 320D Grey Driving without Reasonable Consideration None Hamstead Road Hamstead Road Birmingham Birmingham Fixed Penalty N/A   52.505832 -1.92002
15581 op-snap---monthly-publication-june-2025.pdf   1510 2025-06 Car Volkswagen Golf Grey Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
15590 op-snap---monthly-publication-june-2025.pdf   1519 2025-06 Pedal Bike Volvo Coach Grey Driving without Reasonable Consideration None Damson Parkway Damson Parkway Solihull Solihull Education N/A   52.437016 -1.7578446
15633 op-snap---monthly-publication-june-2025.pdf   1562 2025-06 Car Nissan Qashqai Black Driving without Reasonable Consideration None Henwood Road Henwood Road Wolverhampton Wolverhampton Warning Letter N/A   52.5930037 -2.1685306
15634 op-snap---monthly-publication-june-2025.pdf   1563 2025-06 Pedal Bike Ford Puma White Driving without Reasonable Consideration None Long Mynd Road Long Mynd Road Birmingham Birmingham Warning Letter N/A   52.4257286 -1.9769008
15637 op-snap---monthly-publication-june-2025.pdf   1566 2025-06 Pedal Bike   WM BUS Red Driving without Reasonable Consideration None Gilson Way Gilson Way Birmingham Birmingham Warning Letter N/A      
15648 op-snap---monthly-publication-june-2025.pdf   1577 2025-06 Car Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Bilston Road Bilston Road Wolverhampton Wolverhampton Education N/A   52.5801329 -2.1138283
15649 op-snap---monthly-publication-june-2025.pdf   1578 2025-06 Car BMW 1 series Grey Driving without Reasonable Consideration None A435 HGigh Street, Kings Heath A435 HGigh Street, Kings Heath Birmingham Birmingham Warning Letter N/A      
15665 op-snap---monthly-publication-june-2025.pdf   1594 2025-06 Car Peugeot 207 White Driving without Reasonable Consideration No Insurance Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Court N/A      
15672 op-snap---monthly-publication-june-2025.pdf   1601 2025-06 Car BMW 320 Blue Driving without Reasonable Consideration No Insurance Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A   52.4929304 -1.8229092
15704 op-snap---monthly-publication-june-2025.pdf   1633 2025-06 Car BMW 1 series Grey Driving without Reasonable Consideration None A41 A41 Sandwell Sandwell Warning Letter N/A      

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