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

199 rows where month = "2025-02" 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 6

disposal 5

offence 1

  • Driving without Reasonable Consideration · 199 ✖

month 1

  • 2025-02 · 199 ✖
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
5209 op-snap---monthly-publication-february-2025.pdf   26 2025-02 Pedal Bike BMW 3351 Blue Driving without Reasonable Consideration No Insurance Forge Lane Forge Lane Sandwell Sandwell Court N/A Yes - Via Email 52.5355846 -1.9687064
5210 op-snap---monthly-publication-february-2025.pdf   27 2025-02 Car BMW M3 Comp. Green Driving without Reasonable Consideration None Turnberry Road Turnberry Road Walsall Walsall Education N/A Yes - Via Email 52.6309849 -2.0134248
5211 op-snap---monthly-publication-february-2025.pdf   28 2025-02 Pedal Bike Vauxhall Combo White Driving without Reasonable Consideration None Cot Lane Cot Lane Dudley Dudley Education N/A Yes - Via Email 52.4939289 -2.1730601
5212 op-snap---monthly-publication-february-2025.pdf   29 2025-02 Car       Driving without Reasonable Consideration None Talbot Way Talbot Way Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4637899 -1.8456215
5214 op-snap---monthly-publication-february-2025.pdf   31 2025-02 Pedal Bike BMW 320D Silver Driving without Reasonable Consideration None Wall Hill Road Wall Hill Road Coventry Coventry Education N/A Yes - Via Email 52.4459445 -1.5552508
5217 op-snap---monthly-publication-february-2025.pdf   34 2025-02 Car Mazda 6 Sport Blue Driving without Reasonable Consideration None M5 South, Frankley Services- J4, Wor M5 South, Frankley Services- J4, Wor cOeustte orfs hFiorrece Area Coeustte Orfs Hfiorrece Area NFA Out of Force Yes - Via Email    
5230 op-snap---monthly-publication-february-2025.pdf   47 2025-02 Car Audi Q5 Grey Driving without Reasonable Consideration None Montague Street Montague Street Birmingham Birmingham Education N/A Yes - Via Email 52.4816806 -1.8788939
5231 op-snap---monthly-publication-february-2025.pdf   48 2025-02 Car Nissan Juke White Driving without Reasonable Consideration None Montague Street Montague Street Birmingham Birmingham Education N/A Yes - Via Email 52.4816806 -1.8788939
5260 op-snap---monthly-publication-february-2025.pdf   77 2025-02 Pedal Bike Vauxhall ZAFIRA Silver Driving without Reasonable Consideration None BARROWS ROAD Barrows Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4580926 -1.8627344
5261 op-snap---monthly-publication-february-2025.pdf   78 2025-02 Pedal Bike Audi Q3 Silver Driving without Reasonable Consideration None BILLS LANE Bills Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5272 op-snap---monthly-publication-february-2025.pdf   89 2025-02 Pedal Bike Volkswagen Taigo White Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
5292 op-snap---monthly-publication-february-2025.pdf   109 2025-02 Pedal Bike Hyundai Tuscan White Driving without Reasonable Consideration None Walsall Road, West Bromwich Walsall Road, West Bromwich Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5366137 -1.9867997
5295 op-snap---monthly-publication-february-2025.pdf   112 2025-02 Pedal Bike Audi A1 Black Driving without Reasonable Consideration None Spring Lane Spring Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.3492615 -1.7783838
5303 op-snap---monthly-publication-february-2025.pdf   120 2025-02 Pedal Bike Seat Leon Black Driving without Reasonable Consideration None Lordswood Road Lordswood Road Birmingham Birmingham Education N/A Yes - Via Email 52.4591339 -1.9601054
5315 op-snap---monthly-publication-february-2025.pdf   132 2025-02 Pedal Bike Ford Focus White Driving without Reasonable Consideration None Blackwood Avenue, Willenhall Blackwood Avenue, Willenhall Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email    
5316 op-snap---monthly-publication-february-2025.pdf   133 2025-02 Car Vauxhall van Silver Driving without Reasonable Consideration None Long Knowle Lane Long Knowle Lane Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.6117401 -2.0918955
5317 op-snap---monthly-publication-february-2025.pdf   134 2025-02 Car Audi A3 Black Driving without Reasonable Consideration None Long Knowle Lane Long Knowle Lane Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.6117401 -2.0918955
5319 op-snap---monthly-publication-february-2025.pdf   136 2025-02 Pedal Bike Volvo V90 Black Driving without Reasonable Consideration None HEATH LANE, OLDSWINFORD Heath Lane, Oldswinford Dudley Dudley Education N/A Yes - Via Email 52.4485529 -2.1410808
5337 op-snap---monthly-publication-february-2025.pdf   154 2025-02 Pedal Bike Ford Focus Black Driving without Reasonable Consideration None The Broadway, Stourbridge The Broadway, Stourbridge Dudley Dudley Education N/A Yes - Via Email 52.4411413 -2.1695219
5340 op-snap---monthly-publication-february-2025.pdf   157 2025-02 Pedal Bike Ford Transit White Driving without Reasonable Consideration VRM fails to conform to Regulations Park Road Park Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5648824 -1.8293486
5341 op-snap---monthly-publication-february-2025.pdf   158 2025-02 Pedal Bike Tesla Model Y Red Driving without Reasonable Consideration None The Broadway, Stourbridge The Broadway, Stourbridge Dudley Dudley Education N/A Yes - Via Email 52.4411413 -2.1695219
5342 op-snap---monthly-publication-february-2025.pdf   159 2025-02 Pedal Bike Volkswagen Passat Silver Driving without Reasonable Consideration None Woodway Lane Woodway Lane Coventry Coventry Education N/A Yes - Via Email 52.4275505 -1.4448681
5344 op-snap---monthly-publication-february-2025.pdf   161 2025-02 Pedal Bike Nissan   Red Driving without Reasonable Consideration None Deedmore Road Deedmore Road Coventry Coventry Education N/A Yes - Via Email 52.4373935 -1.4615405
5345 op-snap---monthly-publication-february-2025.pdf   162 2025-02 Pedal Bike Audi S3 Black Driving without Reasonable Consideration None Deedmore Road Deedmore Road Coventry Coventry Education N/A Yes - Via Email 52.4373935 -1.4615405
5348 op-snap---monthly-publication-february-2025.pdf   165 2025-02 Pedal Bike Ford Mondeo Red Driving without Reasonable Consideration None Deedmore Road Deedmore Road Coventry Coventry Education N/A Yes - Via Email 52.4373935 -1.4615405
5362 op-snap---monthly-publication-february-2025.pdf   179 2025-02 Pedal Bike Renault Captur Grey Driving without Reasonable Consideration None Waste Lane Waste Lane Coventry Coventry Education N/A Yes - Via Email 52.437361 -1.5371291
5414 op-snap---monthly-publication-february-2025.pdf   231 2025-02 Pedal Bike Ford FOCUS Black Driving without Reasonable Consideration None GIBBINS ROAD Gibbins Road Birmingham Birmingham Education N/A Yes - Via Email 52.4390303 -1.9512931
5417 op-snap---monthly-publication-february-2025.pdf   234 2025-02 Pedal Bike BMW 320d Silver Driving without Reasonable Consideration None Bournville Lane Bournville Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4271614 -1.9302862
5451 op-snap---monthly-publication-february-2025.pdf   268 2025-02 Pedal Bike Land Rover Range Rover Black Driving without Reasonable Consideration None Charter Avenue Charter Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3928409 -1.5888076
5473 op-snap---monthly-publication-february-2025.pdf   290 2025-02 Pedal Bike Hyundai I10 White Driving without Reasonable Consideration None TANSLEY ROAD Tansley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5443788 -1.8837074
5479 op-snap---monthly-publication-february-2025.pdf   296 2025-02 Pedal Bike Toyota Yaris Blue Driving without Reasonable Consideration None Bordesley Green East Bordesley Green East Birmingham Birmingham Education N/A Yes - Via Email 52.4802441 -1.8327073
5495 op-snap---monthly-publication-february-2025.pdf   312 2025-02 Car Seat Leon White Driving without Reasonable Consideration None Wharfdale Road Wharfdale Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4554916 -1.8300959
5502 op-snap---monthly-publication-february-2025.pdf   319 2025-02 Car Ford Fiesta Black Driving without Reasonable Consideration None Bordesley Green Bordesley Green Birmingham Birmingham Education N/A Yes - Via Email 52.4758869 -1.8512072
5503 op-snap---monthly-publication-february-2025.pdf   320 2025-02 Pedal Bike BMW X5 Black Driving without Reasonable Consideration None Westbourne Road Westbourne Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5083818 -1.9447229
5510 op-snap---monthly-publication-february-2025.pdf   327 2025-02 Pedal Bike Ford Fiesta Blue Driving without Reasonable Consideration None Willenhall Lane Willenhall Lane Coventry Coventry Education N/A Yes - Via Email 52.3983962 -1.4423958
5518 op-snap---monthly-publication-february-2025.pdf   335 2025-02 Pedal Bike Peugeot Boxer White Driving without Reasonable Consideration None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4552055 -1.9461279
5530 op-snap---monthly-publication-february-2025.pdf   347 2025-02 Pedal Bike BMW 118I Grey Driving without Reasonable Consideration None A491 Hagley Road Hagley Road Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.4514139 -2.1423625
5532 op-snap---monthly-publication-february-2025.pdf   349 2025-02 Pedal Bike Hyundai IONIQ 5 Grey Driving without Reasonable Consideration None Hagley Raod [A491], Stourbridge Hagley Raod [A491], Stourbridge Dudley Dudley Fixed Penalty N/A Yes - Via Email    
5555 op-snap---monthly-publication-february-2025.pdf   372 2025-02 Car Volkswagen Polo White Driving without Reasonable Consideration none Adams Street Adams Street Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.5206781 -2.0082357
5560 op-snap---monthly-publication-february-2025.pdf   377 2025-02 Pedal Bike Toyota Auris White Driving without Reasonable Consideration No Insurance Chester Road Birmingham Chester Road Birmingham Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115
5561 op-snap---monthly-publication-february-2025.pdf   378 2025-02 Pedal Bike   Mauxs White Driving without Reasonable Consideration None Little Aston Road Birmingham Little Aston Road Birmingham Birmingham Birmingham Education N/A Yes - Via Email    
5667 op-snap---monthly-publication-february-2025.pdf   484 2025-02 Car Peugeot   Grey Driving without Reasonable Consideration None Lytham Croft Lytham Croft Birmingham Birmingham NFA No VRM Yes - Via Email 52.4717297 -1.9029093
5670 op-snap---monthly-publication-february-2025.pdf   487 2025-02 Pedal Bike Nissan QASHQUI Blue Driving without Reasonable Consideration None QUEENSBRIDGE ROAD Queensbridge Road Birmingham Birmingham Court N/A Yes - Via Email 52.4415108 -1.8971434
5671 op-snap---monthly-publication-february-2025.pdf   488 2025-02 Car Ford Fiesta Black Driving without Reasonable Consideration None Granville Street Granville Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4762076 -1.9124263
5678 op-snap---monthly-publication-february-2025.pdf   495 2025-02 Car Volkswagen Golf Blue Driving without Reasonable Consideration None Hockley Circus Hockley Circus Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4952382 -1.9146705
5689 op-snap---monthly-publication-february-2025.pdf   506 2025-02 Car Mercedes-Benz Vito White Driving without Reasonable Consideration None Bordesley Circus Bordesley Circus Birmingham Birmingham Education N/A Yes - Via Email 52.4728608 -1.8754722
5690 op-snap---monthly-publication-february-2025.pdf   507 2025-02 Pedal Bike Vauxhall Astra Red Driving without Reasonable Consideration None Box Tree Road, Solihul Box Tree Road, Solihul Solihull Solihull Fixed Penalty N/A Yes - Via Email    
5697 op-snap---monthly-publication-february-2025.pdf   514 2025-02 Pedal Bike Mercedes-Benz A180 White Driving without Reasonable Consideration None Allesley OId Road Allesley OId Road Coventry Coventry Education N/A Yes - Via Email    
5702 op-snap---monthly-publication-february-2025.pdf   519 2025-02 Car Seat Arona Grey Driving without Reasonable Consideration None A45 Coventry Road Coventry Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
5731 op-snap---monthly-publication-february-2025.pdf   548 2025-02 Pedal Bike Renault traffic van White Driving without Reasonable Consideration None Ravenhayes Lane Ravenhayes Lane Birmingham Birmingham Court N/A Yes - Via Email 52.4298965 -2.0130164
5784 op-snap---monthly-publication-february-2025.pdf   601 2025-02 Pedal Bike Toyota Prius White Driving without Reasonable Consideration Contravening a Red Traffic Light King Edwards Road, Birmingham King Edwards Road, Birmingham Birmingham Birmingham Court N/A Yes - Via Email 52.4805719 -1.9144313
5787 op-snap---monthly-publication-february-2025.pdf   604 2025-02 Car BMW 3series Grey Driving without Reasonable Consideration None Walsgrove Road, Coventry Walsgrove Road, Coventry Coventry Coventry NFA No VRM Yes - Via Email    
5814 op-snap---monthly-publication-february-2025.pdf   631 2025-02 Pedal Bike Skoda Karoq Grey Driving without Reasonable Consideration None Gibbins Road, Selly Oak Gibbins Road, Selly Oak Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4390303 -1.9512931
5839 op-snap---monthly-publication-february-2025.pdf   656 2025-02 Pedal Bike Kia Ceed White Driving without Reasonable Consideration None Wychall Lane, Northfield Wychall Lane, Northfield Birmingham Birmingham Education N/A Yes - Via Email 52.4088717 -1.947472
5841 op-snap---monthly-publication-february-2025.pdf   658 2025-02 Pedal Bike Land Rover   Black Driving without Reasonable Consideration None Walsall Rd nr to Four Oaks Walsall Road nr to Four Oaks Birmingham Birmingham Education N/A Yes - Via Email    
5851 op-snap---monthly-publication-february-2025.pdf   668 2025-02 Pedal Bike BMW 435 Blue Driving without Reasonable Consideration None A41 The Expressway The Expressway Sandwell Sandwell Education N/A Yes - Via Email 52.5138709 -1.9785481
5852 op-snap---monthly-publication-february-2025.pdf   669 2025-02 Car Mercedes-Benz E220 Grey Driving without Reasonable Consideration None Island Road Birmingham Island Road Birmingham Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.509612 -1.9513666
5853 op-snap---monthly-publication-february-2025.pdf   670 2025-02 Car       Driving without Reasonable Consideration None Island Road Birmingham Island Road Birmingham Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.509612 -1.9513666
5899 op-snap---monthly-publication-february-2025.pdf   716 2025-02 Pedal Bike Renault Megane Black Driving without Reasonable Consideration None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A Yes - Via Email 52.4103191 -1.8670224
5903 op-snap---monthly-publication-february-2025.pdf   720 2025-02 Pedal Bike Toyota   Grey Driving without Reasonable Consideration None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A Yes - Via Email 52.4103191 -1.8670224
5914 op-snap---monthly-publication-february-2025.pdf   731 2025-02 Pedal Bike Mercedes-Benz E220 Grey Driving without Reasonable Consideration None Avenue Road, Kings Heath Avenue Road, Kings Heath Birmingham Birmingham Education N/A Yes - Via Email 52.4328354 -1.8999608
5931 op-snap---monthly-publication-february-2025.pdf   748 2025-02 Car Toyota Corolla Silver Driving without Reasonable Consideration None New John Street West New John Street West Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4944784 -1.9122329
5933 op-snap---monthly-publication-february-2025.pdf   750 2025-02 Car Audi Q3 Grey Driving without Reasonable Consideration None Heathfield Road Heathfield Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.5905365 -1.8453418
5940 op-snap---monthly-publication-february-2025.pdf   757 2025-02 Car Toyota Corolla White Driving without Reasonable Consideration None Lower Rushall Street Lower Rushall Street Walsall Walsall NFA No VRM Yes - Via Email 52.588273 -1.9750947
5948 op-snap---monthly-publication-february-2025.pdf   765 2025-02 Pedestrian Volkswagen Golf Black Driving without Reasonable Consideration None Heath Road South Heath Road South Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.415858 -1.9632649
5950 op-snap---monthly-publication-february-2025.pdf   767 2025-02 Car Ford Mondeo Grey Driving without Reasonable Consideration No Insurance Gillott Road Birmingham Gillott Road Birmingham Birmingham Birmingham Court N/A Yes - Via Email 52.4817869 -1.9409282
5982 op-snap---monthly-publication-february-2025.pdf   799 2025-02 Pedal Bike BMW I4 Grey Driving without Reasonable Consideration None Foleshill Rd Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
5986 op-snap---monthly-publication-february-2025.pdf   803 2025-02 Pedal Bike Mercedes-Benz C-class Silver Driving without Reasonable Consideration None Kidderminster Kidderminster Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4331313 -2.1702262
5992 op-snap---monthly-publication-february-2025.pdf   809 2025-02 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Bournville Lane Bournville Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4271614 -1.9302862
6003 op-snap---monthly-publication-february-2025.pdf   820 2025-02 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Coventry Road, near to Upper Trinity Coventry Road, near to Upper Trinity SBtirremeitn,g Bhiarmmingham Sbtirremeitn,G Bhiarmmingham Education N/A Yes - Via Email 52.4597928 -1.8020015
6035 op-snap---monthly-publication-february-2025.pdf   852 2025-02 Pedal Bike Land Rover Discovery Grey Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
6036 op-snap---monthly-publication-february-2025.pdf   853 2025-02 Car Volkswagen Tiguan Grey Driving without Reasonable Consideration No vehicle excise licence Hamstead Hill Hamstead Hill Birmingham Birmingham Education N/A Yes - Via Email 52.5274116 -1.9287273
6050 op-snap---monthly-publication-february-2025.pdf   867 2025-02 Car Ford Transit Silver Driving without Reasonable Consideration None Tyburn House Island Tyburn House Island Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5194011 -1.8008643
6052 op-snap---monthly-publication-february-2025.pdf   869 2025-02 Pedal Bike Volkswagen Golf Grey Driving without Reasonable Consideration None Ravenhayes Lane Ravenhayes Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4298965 -2.0130164
6058 op-snap---monthly-publication-february-2025.pdf   875 2025-02 Other Mercedes-Benz GLB 200 Blue Driving without Reasonable Consideration None Glenville Drive Glenville Drive Birmingham Birmingham Education N/A Yes - Via Email 52.5265939 -1.8509884
6060 op-snap---monthly-publication-february-2025.pdf   877 2025-02 Other Vauxhall Corsa Red Driving without Reasonable Consideration None Glenville Drive Glenville Drive Birmingham Birmingham Education N/A Yes - Via Email 52.5265939 -1.8509884
6063 op-snap---monthly-publication-february-2025.pdf   880 2025-02 Pedal Bike Audi Q2 Grey Driving without Reasonable Consideration None Farnborough Road Farnborough Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5148331 -1.79231
6107 op-snap---monthly-publication-february-2025.pdf   924 2025-02 Pedal Bike BMW X3 Grey Driving without Reasonable Consideration None Vicarage Hill Vicarage Hill Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4295732 -1.9009634
6108 op-snap---monthly-publication-february-2025.pdf   925 2025-02 Pedal Bike BMW X5 Green Driving without Reasonable Consideration None Hampton Road Hampton Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3985342 -1.7240581
6117 op-snap---monthly-publication-february-2025.pdf   934 2025-02 Car Skoda Enyaq Grey Driving without Reasonable Consideration None Lyndon Road Lyndon Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.5649901 -1.8274858
6120 op-snap---monthly-publication-february-2025.pdf   937 2025-02 Pedal Bike Volvo Car Transporter Orange Driving without Reasonable Consideration None Ansty Road Ansty Road Coventry Coventry Education N/A Yes - Via Email 52.4205675 -1.4520187
6121 op-snap---monthly-publication-february-2025.pdf   938 2025-02 Pedal Bike BMW 320d Black Driving without Reasonable Consideration None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5872149 -1.8300386
6122 op-snap---monthly-publication-february-2025.pdf   939 2025-02 Pedal Bike Mercedes-Benz GLC 220 White Driving without Reasonable Consideration None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5872149 -1.8300386
6124 op-snap---monthly-publication-february-2025.pdf   941 2025-02 Pedal Bike Nissan Qashqai Grey Driving without Reasonable Consideration None Walsgrave Road Walsgrave Road Coventry Coventry Education N/A Yes - Via Email 52.4096725 -1.487901
6132 op-snap---monthly-publication-february-2025.pdf   949 2025-02 Lorry Tesla Model Y Black Driving without Reasonable Consideration None A456, Birmingham Road, Blakedown A456, Birmingham Road, Blakedown Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
6143 op-snap---monthly-publication-february-2025.pdf   960 2025-02 Pedal Bike Volkswagen passatt Silver Driving without Reasonable Consideration None Vicarage Rd, Kings Heath Vicarage Road, Kings Heath Birmingham Birmingham Education N/A Yes - Via Email 52.4301512 -1.8996659
6154 op-snap---monthly-publication-february-2025.pdf   971 2025-02 Car Skoda Fabia White Driving without Reasonable Consideration None Dudley Road Dudley Road Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.4881161 -2.1199108
6186 op-snap---monthly-publication-february-2025.pdf   1003 2025-02 Pedal Bike Vauxhall Corsa Black Driving without Reasonable Consideration None Bradford Street Bradford Street Birmingham Birmingham NFA No Offence Yes - Via Email 52.4708802 -1.8792135
6188 op-snap---monthly-publication-february-2025.pdf   1005 2025-02 Pedal Bike Honda Jazz Blue Driving without Reasonable Consideration None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4203897 -1.8338574
6189 op-snap---monthly-publication-february-2025.pdf   1006 2025-02 Pedal Bike Peugeot   Grey Driving without Reasonable Consideration None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4203897 -1.8338574
6190 op-snap---monthly-publication-february-2025.pdf   1007 2025-02 Pedal Bike Mercedes-Benz SLK Silver Driving without Reasonable Consideration No Insurance Sarehole Road Sarehole Road Birmingham Birmingham NFA Misc Inc Crimes Yes - Via Email 52.4422505 -1.8539684
6192 op-snap---monthly-publication-february-2025.pdf   1009 2025-02 Pedal Bike Mercedes-Benz E300 Black Driving without Reasonable Consideration No Insurance Sarehole Road Sarehole Road Birmingham Birmingham Education N/A Yes - Via Email 52.4422505 -1.8539684
6214 op-snap---monthly-publication-february-2025.pdf   1031 2025-02 Pedal Bike BMW 330E Blue Driving without Reasonable Consideration None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5872149 -1.8300386
6218 op-snap---monthly-publication-february-2025.pdf   1035 2025-02 Car Volkswagen Transporter Grey Driving without Reasonable Consideration None Clive Road, Harborne Clive Road, Harborne Birmingham Birmingham Warning Letter N/A Yes - Via Email    
6219 op-snap---monthly-publication-february-2025.pdf   1036 2025-02 Car Hyundai Tucson White Driving without Reasonable Consideration None Clive Road, Harborne Clive Road, Harborne Birmingham Birmingham Warning Letter N/A Yes - Via Email    
6224 op-snap---monthly-publication-february-2025.pdf   1041 2025-02 Car Volkswagen Golf Blue Driving without Reasonable Consideration None Hagley Road West Hagley Road West Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4656414 -1.9852276
6239 op-snap---monthly-publication-february-2025.pdf   1056 2025-02 Pedal Bike Vauxhall Astra Black Driving without Reasonable Consideration None Vicarage Road Walsall Vicarage Road Walsall Walsall Walsall Education N/A Yes - Via Email 52.64682 -1.9259844
6250 op-snap---monthly-publication-february-2025.pdf   1067 2025-02 Pedal Bike   London Taxi Black Driving without Reasonable Consideration None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.459563 -1.946922
6279 op-snap---monthly-publication-february-2025.pdf   1096 2025-02 Pedal Bike Fiat Punto White Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5359496 -1.8324115
6280 op-snap---monthly-publication-february-2025.pdf   1097 2025-02 Pedal Bike Vauxhall Astra Grey Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115

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