home / opsnap

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

220 rows where month = "2025-01" 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, witness_contacted

vehicle_make 24

  • Ford 30
  • Vauxhall 20
  • Volkswagen 20
  • Mercedes-Benz 19
  • Audi 16
  • Toyota 16
  • BMW 15
  • Hyundai 10
  • Seat 9
  • Kia 6
  • Renault 6
  • Land Rover 5
  • Nissan 5
  • Peugeot 5
  • Skoda 5
  • Citroen 4
  • Honda 4
  • Fiat 3
  • Mazda 3
  • Mini 3
  • Suzuki 3
  • Volvo 3
  • Daf 2
  • Jaguar 1

council_area 9

  • Birmingham 111
  • Coventry 53
  • Dudley 13
  • Solihull 12
  • Sutton Coldfield 10
  • Walsall 9
  • Out of Force Area 6
  • Wolverhampton 5
  • Sandwell 1

reporter_transport_mode 6

  • Pedal Bike 144
  • Car 70
  • Horse Rider 2
  • Pedestrian 2
  • Other 1
  • pedal bike 1

disposal 6

  • Education 113
  • Warning Letter 49
  • Fixed Penalty 29
  • NFA 15
  • Court 11
  • Other Action Taken 3

offence 1

  • Driving without Reasonable Consideration · 220 ✖

month 1

  • 2025-01 · 220 ✖
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
8896 op-snap---monthly-publication-january-2025.pdf   4 2025-01 Pedal Bike Mercedes-Benz E 220 White Driving without Reasonable Consideration None Chester Road, Streetly Chester Road, Streetly Walsall Walsall Education N/A Yes - Via Email 52.5774374 -1.8842966
8908 op-snap---monthly-publication-january-2025.pdf   16 2025-01 Pedal Bike Ford TRANSIT White Driving without Reasonable Consideration None COLE BANK ROAD Cole Bank Road Birmingham Birmingham Education N/A Yes - Via Email 52.4349375 -1.8510007
8909 op-snap---monthly-publication-january-2025.pdf   17 2025-01 Pedal Bike Nissan MICRA Black Driving without Reasonable Consideration None SCHOOL ROAD School Road Birmingham Birmingham Education N/A Yes - Via Email 52.4161736 -1.8619692
8911 op-snap---monthly-publication-january-2025.pdf   19 2025-01 Pedal Bike Mazda CX5 Black Driving without Reasonable Consideration None BROADWAY Broadway Dudley Dudley Education N/A Yes - Via Email 52.5147445 -2.0836401
8914 op-snap---monthly-publication-january-2025.pdf   22 2025-01 Car Suzuki Swift White Driving without Reasonable Consideration None Templar Avenue Templar Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4004407 -1.5709058
8948 op-snap---monthly-publication-january-2025.pdf   56 2025-01 Pedal Bike Hyundai I20 S Black Driving without Reasonable Consideration None CARTLAND AVENUE Cartland Avenue Birmingham Birmingham Education N/A Yes - Via Email    
8966 op-snap---monthly-publication-january-2025.pdf   74 2025-01 Pedal Bike Volkswagen Golf Black Driving without Reasonable Consideration None The Oval The Oval Birmingham Birmingham Education N/A Yes - Via Email 52.4577754 -1.8692099
8971 op-snap---monthly-publication-january-2025.pdf   79 2025-01 Pedal Bike Vauxhall Zaffira Brown Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
8974 op-snap---monthly-publication-january-2025.pdf   82 2025-01 Pedal Bike BMW 320D Blue Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4274335 -1.5002381
9005 op-snap---monthly-publication-january-2025.pdf   113 2025-01 Car Daf HGV White Driving without Reasonable Consideration None M6 M6 Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9020 op-snap---monthly-publication-january-2025.pdf   128 2025-01 Car Ford Fiesta Black Driving without Reasonable Consideration None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5521118 -1.8845138
9027 op-snap---monthly-publication-january-2025.pdf   135 2025-01 Pedal Bike BMW 11D White Driving without Reasonable Consideration None The Broadway The Broadway Dudley Dudley Education N/A Yes - Via Email 52.515445 -2.0885791
9033 op-snap---monthly-publication-january-2025.pdf   141 2025-01 Car Peugeot 3008 Blue Driving without Reasonable Consideration None M42 J5-6 M42 J5-6 Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9052 op-snap---monthly-publication-january-2025.pdf   160 2025-01 Car Fiat Truck Red Driving without Reasonable Consideration None Binley Road Binley Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4070602 -1.4732469
9053 op-snap---monthly-publication-january-2025.pdf   161 2025-01 Pedal Bike BMW 520D Grey Driving without Reasonable Consideration None Walmey Ash Road Walmey Ash Road Birmingham Birmingham Education N/A Yes - Via Email    
9054 op-snap---monthly-publication-january-2025.pdf   162 2025-01 Pedal Bike Peugeot Expert Red Driving without Reasonable Consideration None Walmley Ash Road Walmley Ash Road Birmingham Birmingham Education N/A Yes - Via Email 52.5376726 -1.7973346
9056 op-snap---monthly-publication-january-2025.pdf   164 2025-01 Pedal Bike Mercedes-Benz EQA White Driving without Reasonable Consideration None Walmley Ash Road Walmley Ash Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5376726 -1.7973346
9057 op-snap---monthly-publication-january-2025.pdf   165 2025-01 Pedal Bike Nissan Note Blue Driving without Reasonable Consideration None Walmley Ash Road Walmley Ash Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5376726 -1.7973346
9059 op-snap---monthly-publication-january-2025.pdf   167 2025-01 Pedal Bike Volkswagen Crafter Grey Driving without Reasonable Consideration None Walmley Ash Road Walmley Ash Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5376726 -1.7973346
9072 op-snap---monthly-publication-january-2025.pdf   180 2025-01 Car Ford Focus Black Driving without Reasonable Consideration None Queensbridge Road Queensbridge Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4415108 -1.8971434
9080 op-snap---monthly-publication-january-2025.pdf   188 2025-01 Car Ford Transit White Driving without Reasonable Consideration None Himbleton Road Worcestershire Himbleton Road Worcestershire Birmingham Birmingham NFA Out of Force Yes - Via Email    
9085 op-snap---monthly-publication-january-2025.pdf   193 2025-01 Car Volkswagen Golf Black Driving without Reasonable Consideration None Tyburn Island Tyburn Island Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5193542 -1.800381
9086 op-snap---monthly-publication-january-2025.pdf   194 2025-01 Car Mercedes-Benz A Class Grey Driving without Reasonable Consideration None M42 Warwickshire M42 Warwickshire Birmingham Birmingham NFA Out of Force Yes - Via Email    
9092 op-snap---monthly-publication-january-2025.pdf   200 2025-01 Car Daf HGV Blue Driving without Reasonable Consideration None Unknown not given Unknown not given Birmingham Birmingham NFA No VRM Yes - Via Email    
9108 op-snap---monthly-publication-january-2025.pdf   216 2025-01 Car BMW X5 Black Driving without Reasonable Consideration None Stratford Road Stratford Road Birmingham Birmingham Education N/A Yes - Via Email 52.4203897 -1.8338574
9110 op-snap---monthly-publication-january-2025.pdf   218 2025-01 Other Audi U/K Black Driving without Reasonable Consideration None A38 Expressway (outbound towards A38) Expressway (outbound towards A38) Birmingham Birmingham NFA Not in Public Interest Yes - Via Email    
9119 op-snap---monthly-publication-january-2025.pdf   227 2025-01 Car BMW 520D Blue Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham Education N/A Yes - Via Email 52.5919543 -1.8517118
9121 op-snap---monthly-publication-january-2025.pdf   229 2025-01 Car Toyota Yaris Silver Driving without Reasonable Consideration No Insurance Dudley Road Dudley Road Birmingham Birmingham Other Action Taken eNn/A Yes - Via Email 52.4865107 -1.9386263
9122 op-snap---monthly-publication-january-2025.pdf   230 2025-01 Car Seat Ateca Black Driving without Reasonable Consideration None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4929304 -1.8229092
9133 op-snap---monthly-publication-january-2025.pdf   241 2025-01 Car Mercedes-Benz E220 Blue Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4470686 -1.8880749
9145 op-snap---monthly-publication-january-2025.pdf   253 2025-01 Pedal Bike Land Rover SPORT White Driving without Reasonable Consideration None MOSELEY AVENUE Moseley Avenue Coventry Coventry Education N/A Yes - Via Email 52.417344 -1.5264979
9153 op-snap---monthly-publication-january-2025.pdf   261 2025-01 Car Land Rover Defender Black Driving without Reasonable Consideration None M54 Jct 2 to 3, Coven, Staffs M54 Junction 2 to 3, Coven, Staffs Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9154 op-snap---monthly-publication-january-2025.pdf   262 2025-01 Car Mercedes-Benz A180 White Driving without Reasonable Consideration None Victoria Road R/A at Park lane East Victoria Road R/A at Park lane East Dudley Dudley Education N/A Yes - Via Email    
9164 op-snap---monthly-publication-january-2025.pdf   272 2025-01 Car Seat Leon Black Driving without Reasonable Consideration None Stratford Road Stratford Road Birmingham Birmingham Education N/A Yes - Via Email 52.4203897 -1.8338574
9187 op-snap---monthly-publication-january-2025.pdf   295 2025-01 Car Audi A3 Black Driving without Reasonable Consideration None Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A Yes - Via Email 52.4214017 -1.4870278
9208 op-snap---monthly-publication-january-2025.pdf   316 2025-01 Car Hyundai I20 Black Driving without Reasonable Consideration None LEA VILLAGE ISLAND Lea Village Island Birmingham Birmingham Education N/A Yes - Via Email 52.4836058 -1.77661
9210 op-snap---monthly-publication-january-2025.pdf   318 2025-01 Pedal Bike BMW 118 Black Driving without Reasonable Consideration None Chester Roads Chester Roads Birmingham Birmingham Education N/A Yes - Via Email    
9222 op-snap---monthly-publication-january-2025.pdf   330 2025-01 Car BMW 530M Grey Driving without Reasonable Consideration None PRIORY ROAD Priory Road Birmingham Birmingham Education N/A Yes - Via Email 52.4132696 -1.8555008
9227 op-snap---monthly-publication-january-2025.pdf   335 2025-01 Pedal Bike Volkswagen Transporter Silver Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115
9263 op-snap---monthly-publication-january-2025.pdf   371 2025-01 Pedal Bike Audi A4 Green Driving without Reasonable Consideration None LORDSWOOD ROAD Lordswood Road Birmingham Birmingham Education N/A Yes - Via Email 52.4591339 -1.9601054
9282 op-snap---monthly-publication-january-2025.pdf   390 2025-01 Pedal Bike Mercedes-Benz C250 AMG Grey Driving without Reasonable Consideration None Much Park Street Much Park Street Coventry Coventry Education N/A Yes - Via Email 52.4061531 -1.505845
9284 op-snap---monthly-publication-january-2025.pdf   392 2025-01 Pedal Bike Toyota Auris White Driving without Reasonable Consideration None The Ridgeway The Ridgeway Birmingham Birmingham Education N/A Yes - Via Email 52.5252536 -1.8765786
9290 op-snap---monthly-publication-january-2025.pdf   398 2025-01 Pedal Bike Volkswagen Caravelle Silver Driving without Reasonable Consideration None Frankly Beeches Road Frankly Beeches Road Birmingham Birmingham Education N/A Yes - Via Email    
9291 op-snap---monthly-publication-january-2025.pdf   399 2025-01 Car Vauxhall Movano White Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A Yes - Via Email 52.5083238 -1.8332287
9303 op-snap---monthly-publication-january-2025.pdf   411 2025-01 Pedal Bike Seat LEON Grey Driving without Reasonable Consideration None COLDBATH ROAD Coldbath Road Birmingham Birmingham Education N/A Yes - Via Email 52.4330535 -1.8731794
9304 op-snap---monthly-publication-january-2025.pdf   412 2025-01 Pedal Bike Vauxhall Crossland Red Driving without Reasonable Consideration None Jervoise Lane Jervoise Lane Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email    
9312 op-snap---monthly-publication-january-2025.pdf   420 2025-01 Pedal Bike Nissan Note Blue Driving without Reasonable Consideration None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4103191 -1.8670224
9313 op-snap---monthly-publication-january-2025.pdf   421 2025-01 Car Audi Q4 E-Tron Grey Driving without Reasonable Consideration None Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4861917 -1.8829748
9324 op-snap---monthly-publication-january-2025.pdf   432 2025-01 Car BMW 116 D White Driving without Reasonable Consideration None High Street A491 High Street A491 Dudley Dudley Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4790749 -2.1233254
9326 op-snap---monthly-publication-january-2025.pdf   434 2025-01 Pedal Bike Ford Transit 100 White Driving without Reasonable Consideration None Walsall Road Walsall Road Walsall Walsall Education N/A Yes - Via Email 52.6166864 -1.9660822
9327 op-snap---monthly-publication-january-2025.pdf   435 2025-01 Car Citroen Berlingo Black Driving without Reasonable Consideration None M42, J4 Island M42, J4 Island Solihull Solihull Warning Letter N/A Yes - Via Email    
9332 op-snap---monthly-publication-january-2025.pdf   440 2025-01 Car Fiat Punto White Driving without Reasonable Consideration None Pickford Way Pickford Way Coventry Coventry Warning Letter N/A Yes - Via Email 52.4220824 -1.5625669
9339 op-snap---monthly-publication-january-2025.pdf   447 2025-01 Car BMW I4 M50 Black Driving without Reasonable Consideration None Stratford Road Stratford Road Solihull Solihull Education N/A Yes - Via Email 52.4191184 -1.8326637
9355 op-snap---monthly-publication-january-2025.pdf   463 2025-01 Car Renault CAPTUR White Driving without Reasonable Consideration None PARK LANE,ASTON Park Lane, Aston Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4984903 -1.8861447
9364 op-snap---monthly-publication-january-2025.pdf   472 2025-01 Pedal Bike Peugeot 307 Silver Driving without Reasonable Consideration None Carrington Road Carrington Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5519066 -1.9860981
9369 op-snap---monthly-publication-january-2025.pdf   477 2025-01 Pedal Bike Volkswagen GOLF Grey Driving without Reasonable Consideration None BRADFORD ROAD Bradford Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5024148 -1.7961753
9387 op-snap---monthly-publication-january-2025.pdf   495 2025-01 Pedal Bike Land Rover FREELANDER Black Driving without Reasonable Consideration None Middlemarch Road Middlemarch Road Coventry Coventry Education N/A Yes - Via Email 52.4316434 -1.5142862
9388 op-snap---monthly-publication-january-2025.pdf   496 2025-01 Car Vauxhall Meriva Grey Driving without Reasonable Consideration None Birchfield Road, Perry Barr Birchfield Road, Perry Barr Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5170745 -1.9012542
9389 op-snap---monthly-publication-january-2025.pdf   497 2025-01 Pedal Bike Ford Fiesta Grey Driving without Reasonable Consideration None Spon End Spon End Coventry Coventry Education N/A Yes - Via Email 52.4069072 -1.5247498
9392 op-snap---monthly-publication-january-2025.pdf   500 2025-01 Pedal Bike Hyundai I10 Blue Driving without Reasonable Consideration None Browns Lane Browns Lane Coventry Coventry Education N/A Yes - Via Email 52.435719 -1.5617089
9397 op-snap---monthly-publication-january-2025.pdf   505 2025-01 Pedal Bike Toyota Verso Black Driving without Reasonable Consideration None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A Yes - Via Email 52.4103191 -1.8670224
9399 op-snap---monthly-publication-january-2025.pdf   507 2025-01 Pedal Bike Hyundai I20 Grey Driving without Reasonable Consideration None Court Oak Road Court Oak Road Birmingham Birmingham Education N/A Yes - Via Email 52.4604383 -1.9760104
9400 op-snap---monthly-publication-january-2025.pdf   508 2025-01 Pedestrian Mercedes-Benz A160 Black Driving without Reasonable Consideration None George Street George Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5048075 -1.9545728
9410 op-snap---monthly-publication-january-2025.pdf   518 2025-01 Pedal Bike Skoda FABIA Blue Driving without Reasonable Consideration None KINGSBURY ROAD, ERDINGTON Kingsbury Road, Erdington Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email    
9415 op-snap---monthly-publication-january-2025.pdf   523 2025-01 Pedal Bike Vauxhall Corsa Black Driving without Reasonable Consideration None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.5872149 -1.8300386
9417 op-snap---monthly-publication-january-2025.pdf   525 2025-01 Pedal Bike Skoda Kodiaq Grey Driving without Reasonable Consideration None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5872149 -1.8300386
9422 op-snap---monthly-publication-january-2025.pdf   530 2025-01 Pedal Bike Vauxhall MOVANO White Driving without Reasonable Consideration None HAGLEY ROAD, STOURBRIDGE Hagley Road, Stourbridge Dudley Dudley Education N/A Yes - Via Email 52.4357078 -2.1323185
9436 op-snap---monthly-publication-january-2025.pdf   544 2025-01 Pedal Bike Ford Focus Blue Driving without Reasonable Consideration None Watford Road Watford Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4182952 -1.9316395
9442 op-snap---monthly-publication-january-2025.pdf   550 2025-01 Pedal Bike Vauxhall Corsa Silver Driving without Reasonable Consideration None Crocketts Lane Crocketts Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9443 op-snap---monthly-publication-january-2025.pdf   551 2025-01 Pedal Bike Mercedes-Benz E220 Silver Driving without Reasonable Consideration None Scotland Lane Scotland Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4277732 -2.0022005
9458 op-snap---monthly-publication-january-2025.pdf   566 2025-01 Car Ford FIESTA Black Driving without Reasonable Consideration None HIGH STREET, KINGS HEATH High Street, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4353506 -1.8927483
9467 op-snap---monthly-publication-january-2025.pdf   575 2025-01 Car BMW 330D Black Driving without Reasonable Consideration No Insurance MOSELEY AVENUE Moseley Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.417344 -1.5264979
9470 op-snap---monthly-publication-january-2025.pdf   578 2025-01 pedal bike Kia SPORTAGE White Driving without Reasonable Consideration None STONEY STANTON ROAD Stoney Stanton Road Coventry Coventry Education N/A Yes - Via Email 52.4221152 -1.4959475
9480 op-snap---monthly-publication-january-2025.pdf   588 2025-01 Pedal Bike Mercedes-Benz GLA250 Silver Driving without Reasonable Consideration None Earlsdon Avenue North Earlsdon Avenue North Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4025196 -1.5327802
9481 op-snap---monthly-publication-january-2025.pdf   589 2025-01 Pedal Bike Ford Transit Black Driving without Reasonable Consideration None Earlsdon Avenue South Earlsdon Avenue South Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3960991 -1.5255671
9484 op-snap---monthly-publication-january-2025.pdf   592 2025-01 Pedal Bike Suzuki Jimny Blue Driving without Reasonable Consideration None Chester Road, Streetly Chester Road, Streetly Birmingham Birmingham Education N/A Yes - Via Email    
9521 op-snap---monthly-publication-january-2025.pdf   629 2025-01 Car Audi A6 Silver Driving without Reasonable Consideration None Melchett Road Melchett Road Birmingham Birmingham Education N/A Yes - Via Email 52.413984 -1.9251511
9538 op-snap---monthly-publication-january-2025.pdf   646 2025-01 Pedal Bike Audi A4 Red Driving without Reasonable Consideration None B4510 OFFENHAM B4510 Offenham Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9544 op-snap---monthly-publication-january-2025.pdf   652 2025-01 Pedal Bike Suzuki SX4 Blue Driving without Reasonable Consideration None Mile Lane Mile Lane Coventry Coventry Education N/A Yes - Via Email 52.3992732 -1.5044832
9545 op-snap---monthly-publication-january-2025.pdf   653 2025-01 Pedal Bike Kia Ceed White Driving without Reasonable Consideration None Lichfield Street Lichfield Street Walsall Walsall Education N/A Yes - Via Email 52.5882772 -1.9761264
9555 op-snap---monthly-publication-january-2025.pdf   663 2025-01 Car Toyota Corolla Black Driving without Reasonable Consideration None Radford Road Radford Road Coventry Coventry Education N/A Yes - Via Email 52.4235908 -1.5226276
9579 op-snap---monthly-publication-january-2025.pdf   687 2025-01 Pedal Bike Mercedes-Benz SPRINTER Blue Driving without Reasonable Consideration None GILLHURST ROAD Gillhurst Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.467676 -1.9548345
9586 op-snap---monthly-publication-january-2025.pdf   694 2025-01 Car Seat Leon Black Driving without Reasonable Consideration No Insurance Lower City Rd, Tividale Lower City Road, Tividale Dudley Dudley Court N/A Yes - Via Email    
9593 op-snap---monthly-publication-january-2025.pdf   701 2025-01 Pedal Bike Mercedes-Benz C200 Grey Driving without Reasonable Consideration None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A Yes - Via Email 52.4221152 -1.4959475
9594 op-snap---monthly-publication-january-2025.pdf   702 2025-01 Pedal Bike Ford Focus Silver Driving without Reasonable Consideration Use vehicle on a road without valid test c eCrotixf iSctarteeet e Crotixf i Sctarteeet Coventry Coventry Court N/A Yes - Via Email    
9605 op-snap---monthly-publication-january-2025.pdf   713 2025-01 Pedal Bike Peugeot 3008 Grey Driving without Reasonable Consideration None Beechwood Avenue Beechwood Avenue Coventry Coventry Warning Letter N/A Yes - Via Email 52.3960292 -1.5340332
9606 op-snap---monthly-publication-january-2025.pdf   714 2025-01 Car Honda JAZZ Silver Driving without Reasonable Consideration None BRISTOL ROAD Bristol Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4543565 -1.9114004
9612 op-snap---monthly-publication-january-2025.pdf   720 2025-01 Car Volvo Tractor White Driving without Reasonable Consideration None M5 J5-J6 Worcestershire M5 J5-J6 Worcestershire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9615 op-snap---monthly-publication-january-2025.pdf   723 2025-01 Pedal Bike Hyundai Ioniq White Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
9616 op-snap---monthly-publication-january-2025.pdf   724 2025-01 Pedal Bike Ford Ranger Orange Driving without Reasonable Consideration No Insurance Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
9634 op-snap---monthly-publication-january-2025.pdf   742 2025-01 Car Vauxhall Grandland Purple Driving without Reasonable Consideration None Aldridge Road Aldridge Road Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.5368764 -1.8976461
9645 op-snap---monthly-publication-january-2025.pdf   753 2025-01 Pedal Bike Hyundai Tuscon Grey Driving without Reasonable Consideration None A38 upton upon severn A38 upton upon severn Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9646 op-snap---monthly-publication-january-2025.pdf   754 2025-01 Pedal Bike Toyota chr Grey Driving without Reasonable Consideration None A4101 upton upon severn A4101 upton upon severn Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9651 op-snap---monthly-publication-january-2025.pdf   759 2025-01 Pedal Bike Volkswagen Transporter Grey Driving without Reasonable Consideration None Camp Hill Camp Hill Dudley Dudley Education N/A Yes - Via Email 52.475022 -2.1566273
9652 op-snap---monthly-publication-january-2025.pdf   760 2025-01 Pedal Bike Volvo S80 Silver Driving without Reasonable Consideration None Swindon Road Swindon Road Dudley Dudley Education N/A Yes - Via Email 52.5003933 -2.1846445
9653 op-snap---monthly-publication-january-2025.pdf   761 2025-01 Horse Rider Audi A3 Grey Driving without Reasonable Consideration None Manor Road Manor Road Solihull Solihull Education N/A Yes - Via Email 52.4193737 -1.7798629
9655 op-snap---monthly-publication-january-2025.pdf   763 2025-01 Pedal Bike Volkswagen Golf Black Driving without Reasonable Consideration None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Warning Letter N/A Yes - Via Email 52.396476 -1.5561348
9659 op-snap---monthly-publication-january-2025.pdf   767 2025-01 Pedal Bike Skoda Fabia Blue Driving without Reasonable Consideration None Merritts Hill Merritts Hill Birmingham Birmingham Education N/A Yes - Via Email 52.424853 -1.9814275
9661 op-snap---monthly-publication-january-2025.pdf   769 2025-01 Car BMW 320D Blue Driving without Reasonable Consideration None Flaxley Road Flaxley Road Birmingham Birmingham Education N/A Yes - Via Email 52.487709 -1.8077323
9669 op-snap---monthly-publication-january-2025.pdf   777 2025-01 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4119174 -1.9735247

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