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

141 rows where disposal = "Education", month = "2025-03" 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

vehicle_make 27

  • Ford 26
  • Volkswagen 17
  • Toyota 12
  • BMW 11
  • Vauxhall 10
  • Audi 8
  • Mercedes-Benz 7
  • Hyundai 5
  • Nissan 5
  • Peugeot 5
  • Honda 4
  • Citroen 3
  • Fiat 3
  • Land Rover 3
  • Mazda 3
  • Seat 3
  • Kia 2
  • Mg 2
  • Dacia 1
  • Jaguar 1
  • Lexus 1
  • Mini 1
  • Mitsubishi 1
  • Porsche 1
  • Renault 1
  • Skoda 1
  • Volvo 1

council_area 10

  • Birmingham 69
  • Coventry 27
  • Dudley 17
  • Sutton Coldfield 10
  • Solihull 8
  • Walsall 5
  • Wolverhampton 2
  • Ecnoventry 1
  • Out of Force Area 1
  • Sandwell 1

reporter_transport_mode 3

  • Pedal Bike 114
  • Car 26
  • Pedestrian 1

offence 1

  • Driving without Reasonable Consideration · 141 ✖

month 1

  • 2025-03 · 141 ✖

disposal 1

  • Education · 141 ✖
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
16244 op-snap---monthly-publication-march-2025.pdf   1 2025-03 Pedal Bike Vauxhall Zafira Blue Driving without Reasonable Consideration No vehicle excise licence Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
16298 op-snap---monthly-publication-march-2025.pdf   55 2025-03 Pedal Bike Citroen C2 Blue Driving without Reasonable Consideration None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Education N/A Yes - Via Email 52.4047134 -1.5351834
16308 op-snap---monthly-publication-march-2025.pdf   65 2025-03 Pedal Bike BMW 3 series White Driving without Reasonable Consideration None Stoney Stanton Rd Stoney Stanton Road Coventry Coventry Education N/A Yes - Via Email 52.4221152 -1.4959475
16321 op-snap---monthly-publication-march-2025.pdf   78 2025-03 Pedal Bike Peugeot 308 Black Driving without Reasonable Consideration None Masshouse Lane Masshouse Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4072996 -1.9273914
16341 op-snap---monthly-publication-march-2025.pdf   98 2025-03 Pedal Bike Dacia Sandero White Driving without Reasonable Consideration None Digbeth Coach Station, B4100 Digbeth Coach Station, B4100 Birmingham Birmingham Education N/A Yes - Via Email 52.4753014 -1.8884997
16357 op-snap---monthly-publication-march-2025.pdf   114 2025-03 Pedal Bike Ford Transit Black Driving without Reasonable Consideration None Barston Lane Barston Lane Solihull Solihull Education N/A Yes - Via Email 52.4022999 -1.685635
16370 op-snap---monthly-publication-march-2025.pdf   127 2025-03 Pedal Bike Volvo XC90 Silver Driving without Reasonable Consideration None The Broadway The Broadway Dudley Dudley Education N/A Yes - Via Email 52.515445 -2.0885791
16382 op-snap---monthly-publication-march-2025.pdf   139 2025-03 Pedal Bike BMW 420I Grey Driving without Reasonable Consideration None A5127 Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5872149 -1.8300386
16385 op-snap---monthly-publication-march-2025.pdf   142 2025-03 Pedal Bike Volkswagen Golf Grey Driving without Reasonable Consideration None A5127 Mill Street Mill Street Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.56374 -1.8230904
16402 op-snap---monthly-publication-march-2025.pdf   159 2025-03 Pedal Bike Hyundai I30. Red Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham Education N/A Yes - Via Email 52.4543565 -1.9114004
16404 op-snap---monthly-publication-march-2025.pdf   161 2025-03 Pedal Bike Ford Ranger White Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham Education N/A Yes - Via Email 52.4543565 -1.9114004
16419 op-snap---monthly-publication-march-2025.pdf   176 2025-03 Pedal Bike Honda Crv Grey Driving without Reasonable Consideration None Highfield Road Highfield Road Birmingham Birmingham Education N/A Yes - Via Email 52.4216321 -1.855984
16421 op-snap---monthly-publication-march-2025.pdf   178 2025-03 Pedal Bike Ford Transit Black Driving without Reasonable Consideration None Millisoms Road Millisoms Road Birmingham Birmingham Education N/A Yes - Via Email    
16447 op-snap---monthly-publication-march-2025.pdf   204 2025-03 Pedal Bike Nissan Cube Black Driving without Reasonable Consideration None Dads Lane Dads Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4375913 -1.9068522
16462 op-snap---monthly-publication-march-2025.pdf   219 2025-03 Pedal Bike Mg 3 Blue Driving without Reasonable Consideration None Heathcote Lane, Leamington Spa Heathcote Lane, Leamington Spa Out of Force Area Out of Force Area Education N/A Yes - Via Email    
16483 op-snap---monthly-publication-march-2025.pdf   240 2025-03 Car Audi Q7 Blue Driving without Reasonable Consideration None School Road, Yardley Wood School Road, Yardley Wood Birmingham Birmingham Education N/A Yes - Via Email 52.4135867 -1.8703299
16491 op-snap---monthly-publication-march-2025.pdf   248 2025-03 Car Vauxhall Insignia Silver Driving without Reasonable Consideration None Featherstone Road / Alcester Road Featherstone Road / Alcester Road Birmingham Birmingham Education N/A Yes - Via Email 52.4261289 -1.8929741
16492 op-snap---monthly-publication-march-2025.pdf   249 2025-03 Car Fiat 500 Grey Driving without Reasonable Consideration None Featherstone Road / Alcester Road Featherstone Road / Alcester Road Birmingham Birmingham Education N/A Yes - Via Email 52.4261289 -1.8929741
16517 op-snap---monthly-publication-march-2025.pdf   274 2025-03 Pedal Bike Honda Jazz Blue Driving without Reasonable Consideration None Wigston Road Wigston Road Coventry Coventry Education N/A Yes - Via Email 52.4302822 -1.4386034
16519 op-snap---monthly-publication-march-2025.pdf   276 2025-03 Pedal Bike Toyota Prius Silver Driving without Reasonable Consideration None Smallbrook Queensway Smallbrook Queensway Birmingham Birmingham Education N/A Yes - Via Email 52.4772584 -1.8965734
16534 op-snap---monthly-publication-march-2025.pdf   291 2025-03 Car Audi TT Black Driving without Reasonable Consideration None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A Yes - Via Email 52.4804926 -1.8563658
16566 op-snap---monthly-publication-march-2025.pdf   323 2025-03 Pedal Bike Toyota Prius White Driving without Reasonable Consideration None Northfield Road Northfield Road Birmingham Birmingham Education N/A Yes - Via Email 52.4167654 -1.9411244
16580 op-snap---monthly-publication-march-2025.pdf   337 2025-03 Pedal Bike Seat Arona Blue Driving without Reasonable Consideration None Hardwick Road Hardwick Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
16581 op-snap---monthly-publication-march-2025.pdf   338 2025-03 Pedal Bike Kia Sportage Grey Driving without Reasonable Consideration None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5359496 -1.8324115
16604 op-snap---monthly-publication-march-2025.pdf   361 2025-03 Pedal Bike Fiat 500 Blue Driving without Reasonable Consideration None Hagley Road Hagley Road Dudley Dudley Education N/A Yes - Via Email 52.4514139 -2.1423625
16634 op-snap---monthly-publication-march-2025.pdf   391 2025-03 Pedal Bike Audi Q5 Blue Driving without Reasonable Consideration None Goldeslie Road Goldeslie Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
16655 op-snap---monthly-publication-march-2025.pdf   412 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Graingers Lane Graingers Lane Dudley Dudley Education N/A Yes - Via Email 52.4840702 -2.0657046
16661 op-snap---monthly-publication-march-2025.pdf   418 2025-03 Pedal Bike Ford Focus Red Driving without Reasonable Consideration None A456 Manor Way Haleswoen Manor Way Haleswoen Dudley Dudley Education N/A Yes - Via Email    
16687 op-snap---monthly-publication-march-2025.pdf   444 2025-03 Pedal Bike Vauxhall Insignia Silver Driving without Reasonable Consideration None Vicarage Road Vicarage Road Walsall Walsall Education N/A Yes - Via Email 52.64682 -1.9259844
16692 op-snap---monthly-publication-march-2025.pdf   449 2025-03 Car Volkswagen T-Roc Black Driving without Reasonable Consideration None Trafalgar Road Trafalgar Road Birmingham Birmingham Education N/A Yes - Via Email 52.5205313 -1.8399396
16702 op-snap---monthly-publication-march-2025.pdf   459 2025-03 Car Toyota   Silver Driving without Reasonable Consideration None A461 Birmingham Road Birmingham Road Dudley Dudley Education N/A Yes - Via Email 52.5131355 -2.0651615
16708 op-snap---monthly-publication-march-2025.pdf   465 2025-03 Pedal Bike Honda CR-V Black Driving without Reasonable Consideration None A4100 Mount Pleasant Mount Pleasant Dudley Dudley Education N/A Yes - Via Email 52.4734063 -2.1135639
16710 op-snap---monthly-publication-march-2025.pdf   467 2025-03 Pedal Bike Peugeot 108 Purple Driving without Reasonable Consideration None Camp Hill, Wordsley Camp Hill, Wordsley Dudley Dudley Education N/A Yes - Via Email 52.475022 -2.1566273
16711 op-snap---monthly-publication-march-2025.pdf   468 2025-03 Pedal Bike Honda Civic Black Driving without Reasonable Consideration None Brettell Lane Brettell Lane Dudley Dudley Education N/A Yes - Via Email 52.4706676 -2.1545486
16713 op-snap---monthly-publication-march-2025.pdf   470 2025-03 Pedal Bike BMW 118D White Driving without Reasonable Consideration None A491 High Street High Street Dudley Dudley Education N/A Yes - Via Email 52.4779764 -2.1598371
16740 op-snap---monthly-publication-march-2025.pdf   497 2025-03 Pedal Bike Toyota Corolla White Driving without Reasonable Consideration None Priory Road Priory Road Birmingham Birmingham Education N/A Yes - Via Email 52.4132696 -1.8555008
16742 op-snap---monthly-publication-march-2025.pdf   499 2025-03 Pedal Bike Citroen C4 Silver Driving without Reasonable Consideration None Park Street Birmingham Park Street Birmingham Birmingham Birmingham Education N/A Yes - Via Email 52.4720381 -1.9046266
16761 op-snap---monthly-publication-march-2025.pdf   518 2025-03 Pedal Bike   Scania White Driving without Reasonable Consideration None A4124 Wednesfield Road Wednesfield Road Walsall Walsall Education N/A Yes - Via Email 52.5907858 -2.0584063
16768 op-snap---monthly-publication-march-2025.pdf   525 2025-03 Car Peugeot 308 Silver Driving without Reasonable Consideration None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A Yes - Via Email 52.4103191 -1.8670224
16776 op-snap---monthly-publication-march-2025.pdf   533 2025-03 Car Mercedes-Benz E200 Grey Driving without Reasonable Consideration None Queslett Road Queslett Road Birmingham Birmingham Education N/A Yes - Via Email 52.5458699 -1.9304484
16779 op-snap---monthly-publication-march-2025.pdf   536 2025-03 Car Ford Transit White Driving without Reasonable Consideration None Birchley Island Birchley Island Sandwell Sandwell Education N/A Yes - Via Email 52.4926604 -2.0216743
16783 op-snap---monthly-publication-march-2025.pdf   540 2025-03 Pedal Bike Toyota Auris Blue Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4119174 -1.9735247
16785 op-snap---monthly-publication-march-2025.pdf   542 2025-03 Pedal Bike Mini COOPER Grey Driving without Reasonable Consideration None VICARAGE HILL Vicarage Hill Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.55511 -1.825953
16787 op-snap---monthly-publication-march-2025.pdf   544 2025-03 Pedal Bike Ford Focus Red Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4119174 -1.9735247
16805 op-snap---monthly-publication-march-2025.pdf   562 2025-03 Car Peugeot 208 Red Driving without Reasonable Consideration None CAMP HILL Camp Hill Birmingham Birmingham Education N/A Yes - Via Email 52.4702894 -1.8786299
16807 op-snap---monthly-publication-march-2025.pdf   564 2025-03 Pedal Bike Volkswagen TRANSPORTER Black Driving without Reasonable Consideration Use vehicle on a road without valid test certificate WYCHALL ROAD Wychall Road Birmingham Birmingham Education N/A Yes - Via Email 52.4089092 -1.9498562
16829 op-snap---monthly-publication-march-2025.pdf   586 2025-03 Pedal Bike Ford Transit Blue Driving without Reasonable Consideration None Gilhurst Road Gilhurst Road Birmingham Birmingham Education N/A Yes - Via Email    
16853 op-snap---monthly-publication-march-2025.pdf   610 2025-03 Pedal Bike   Smart Fourtwo Black Driving without Reasonable Consideration None Damson Parkway Damson Parkway Solihull Solihull Education N/A Yes - Via Email 52.437016 -1.7578446
16856 op-snap---monthly-publication-march-2025.pdf   613 2025-03 Pedal Bike Land Rover Sport Grey Driving without Reasonable Consideration None Damson Parkway Damson Parkway Solihull Solihull Education N/A Yes - Via Email 52.437016 -1.7578446
16858 op-snap---monthly-publication-march-2025.pdf   615 2025-03 Pedal Bike Toyota Corolla White Driving without Reasonable Consideration None Damson Parkway Damson Parkway Solihull Solihull Education N/A Yes - Via Email 52.437016 -1.7578446
16882 op-snap---monthly-publication-march-2025.pdf   639 2025-03 Pedal Bike Vauxhall Insignia Blue Driving without Reasonable Consideration None A38 Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A Yes - Via Email 52.5292752 -1.7618805
16890 op-snap---monthly-publication-march-2025.pdf   647 2025-03 Pedal Bike Volkswagen Golf White Driving without Reasonable Consideration None Knoll Drive Knoll Drive Coventry Coventry Education N/A Yes - Via Email 52.3875878 -1.5129201
16894 op-snap---monthly-publication-march-2025.pdf   651 2025-03 Pedal Bike BMW 520 Black Driving without Reasonable Consideration None Bridge Road Bridge Road Coventry Coventry Education N/A Yes - Via Email 52.4211632 -1.4473468
16920 op-snap---monthly-publication-march-2025.pdf   677 2025-03 Pedal Bike Ford Puma Black Driving without Reasonable Consideration None A45 Small Heath Highway Small Heath Highway Birmingham Birmingham Education N/A Yes - Via Email 52.4709298 -1.8722585
16967 op-snap---monthly-publication-march-2025.pdf   724 2025-03 Pedal Bike   Valtra Red Driving without Reasonable Consideration None Barston Lane Barston Lane Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
17028 op-snap---monthly-publication-march-2025.pdf   785 2025-03 Pedal Bike Mercedes-Benz E220... Black Driving without Reasonable Consideration None Hollie Lucas Road Hollie Lucas Road Birmingham Birmingham Education N/A Yes - Via Email 52.4263502 -1.8840926
17029 op-snap---monthly-publication-march-2025.pdf   786 2025-03 Pedal Bike Porsche Macan Black Driving without Reasonable Consideration None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A Yes - Via Email 52.4415108 -1.8971434
17049 op-snap---monthly-publication-march-2025.pdf   806 2025-03 Pedal Bike Audi A3 Black Driving without Reasonable Consideration None Tixall Road Tixall Road Solihull Solihull Education N/A Yes - Via Email    
17053 op-snap---monthly-publication-march-2025.pdf   810 2025-03 Pedal Bike Mercedes-Benz Box Van Brown Driving without Reasonable Consideration None Foles Hill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
17055 op-snap---monthly-publication-march-2025.pdf   812 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Earlsdon Road Earlsdon Road Coventry Coventry Education N/A Yes - Via Email 52.3972344 -1.5388569
17107 op-snap---monthly-publication-march-2025.pdf   864 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Langleys Road Langleys Road Birmingham Birmingham Education N/A Yes - Via Email 52.4358093 -1.9411176
17108 op-snap---monthly-publication-march-2025.pdf   865 2025-03 Pedal Bike Citroen Grand Picasso Blue Driving without Reasonable Consideration None Oak Tree Lane Oak Tree Lane Birmingham Birmingham Education N/A Yes - Via Email 52.431258 -1.9394381
17110 op-snap---monthly-publication-march-2025.pdf   867 2025-03 Pedal Bike Hyundai Tucson Red Driving without Reasonable Consideration None A38 Bristol Road Bristol Road Birmingham Birmingham Education N/A Yes - Via Email 52.4543565 -1.9114004
17118 op-snap---monthly-publication-march-2025.pdf   875 2025-03 Pedal Bike Ford Connect White Driving without Reasonable Consideration None dads lane Dads Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4375913 -1.9068522
17119 op-snap---monthly-publication-march-2025.pdf   876 2025-03 Pedal Bike Skoda Superb Silver Driving without Reasonable Consideration None Balsall Street Balsall Street Birmingham Birmingham Education N/A Yes - Via Email 52.4579985 -1.8916996
17149 op-snap---monthly-publication-march-2025.pdf   906 2025-03 Pedal Bike Vauxhall Corsa Grey Driving without Reasonable Consideration None Raddlebarn Road Raddlebarn Road Birmingham Birmingham Education N/A Yes - Via Email 52.4397168 -1.9260414
17150 op-snap---monthly-publication-march-2025.pdf   907 2025-03 Pedal Bike Audi A3 Grey Driving without Reasonable Consideration None Raddlebarn Road Raddlebarn Road Birmingham Birmingham Education N/A Yes - Via Email 52.4397168 -1.9260414
17212 op-snap---monthly-publication-march-2025.pdf   969 2025-03 Pedal Bike Ford Focus Blue Driving without Reasonable Consideration None A441 Pershore Road South Pershore Road South Birmingham Birmingham Education N/A Yes - Via Email 52.4150779 -1.930901
17223 op-snap---monthly-publication-march-2025.pdf   980 2025-03 Pedal Bike Jaguar F Pace White Driving without Reasonable Consideration None Hagley Road Stourbridge Hagley Road Stourbridge Dudley Dudley Education N/A Yes - Via Email 52.4407776 -2.1344067
17273 op-snap---monthly-publication-march-2025.pdf   1030 2025-03 Pedal Bike Toyota Yaris Grey Driving without Reasonable Consideration None Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
17274 op-snap---monthly-publication-march-2025.pdf   1031 2025-03 Pedal Bike Land Rover Evoque Green Driving without Reasonable Consideration None Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
17278 op-snap---monthly-publication-march-2025.pdf   1035 2025-03 Pedal Bike Audi Q3 Grey Driving without Reasonable Consideration None Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
17290 op-snap---monthly-publication-march-2025.pdf   1047 2025-03 Pedal Bike Peugeot 5008 Grey Driving without Reasonable Consideration None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A Yes - Via Email 52.4415108 -1.8971434
17295 op-snap---monthly-publication-march-2025.pdf   1052 2025-03 Pedal Bike Hyundai TUCSON Brown Driving without Reasonable Consideration None MERE GREEN ROAD Mere Green Road Birmingham Birmingham Education N/A Yes - Via Email 52.5874888 -1.8297106
17302 op-snap---monthly-publication-march-2025.pdf   1059 2025-03 Pedal Bike Toyota CHR White Driving without Reasonable Consideration None Wallace Road Wallace Road Coventry Coventry Education N/A Yes - Via Email 52.4315278 -1.5274137
17306 op-snap---monthly-publication-march-2025.pdf   1063 2025-03 Pedestrian Ford Fiesta Grey Driving without Reasonable Consideration None Gosford Street Gosford Street Coventry Coventry Education N/A Yes - Via Email 52.4068712 -1.4994695
17360 op-snap---monthly-publication-march-2025.pdf   1117 2025-03 Pedal Bike Land Rover Defender Grey Driving without Reasonable Consideration None Pershore Rd Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
17361 op-snap---monthly-publication-march-2025.pdf   1118 2025-03 Pedal Bike Fiat 124 spider Blue Driving without Reasonable Consideration None Pershore Rd Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
17368 op-snap---monthly-publication-march-2025.pdf   1125 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Merridale Road Merridale Road Wolverhampton Wolverhampton Education N/A Yes - Via Email 52.5854145 -2.1408114
17399 op-snap---monthly-publication-march-2025.pdf   1156 2025-03 Pedal Bike Toyota BZ4X Grey Driving without Reasonable Consideration None Willenhall Lane Willenhall Lane Coventry Coventry Education N/A Yes - Via Email 52.3983962 -1.4423958
17400 op-snap---monthly-publication-march-2025.pdf   1157 2025-03 Pedal Bike Volkswagen Transporter White Driving without Reasonable Consideration None Cliffoird Bridge Road Cliffoird Bridge Road Coventry Coventry Education N/A Yes - Via Email    
17401 op-snap---monthly-publication-march-2025.pdf   1158 2025-03 Pedal Bike Renault HGV Green Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A Yes - Via Email 52.4134557 -1.4442138
17403 op-snap---monthly-publication-march-2025.pdf   1160 2025-03 Pedal Bike Ford Transit Silver Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A Yes - Via Email 52.4134557 -1.4442138
17409 op-snap---monthly-publication-march-2025.pdf   1166 2025-03 Pedal Bike Toyota   Black Driving without Reasonable Consideration None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A Yes - Via Email 52.4390303 -1.9512931
17466 op-snap---monthly-publication-march-2025.pdf   1223 2025-03 Pedal Bike Toyota Avensis Black Driving without Reasonable Consideration None Torrington Avenue Torrington Avenue Coventry Coventry Education N/A Yes - Via Email 52.3987354 -1.567693
17479 op-snap---monthly-publication-march-2025.pdf   1236 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Quinton Road Quinton Road Birmingham Birmingham Education N/A Yes - Via Email 52.447826 -1.9574468
17506 op-snap---monthly-publication-march-2025.pdf   1263 2025-03 Pedal Bike Mazda MPV Brown Driving without Reasonable Consideration None Edward Road Edward Road Birmingham Birmingham Education N/A Yes - Via Email 52.4580901 -1.894458
17544 op-snap---monthly-publication-march-2025.pdf   1301 2025-03 Car Nissan Note Black Driving without Reasonable Consideration None Kenilworth Road Kenilworth Road Solihull Solihull Education N/A Yes - Via Email 52.4322443 -1.6746508
17551 op-snap---monthly-publication-march-2025.pdf   1308 2025-03 Car Volkswagen Golf Red Driving without Reasonable Consideration None Barker Butts Lane Barker Butts Lane Coventry Coventry Education N/A Yes - Via Email    
17554 op-snap---monthly-publication-march-2025.pdf   1311 2025-03 Pedal Bike BMW X3 White Driving without Reasonable Consideration None BROOMFIELD ROAD Broomfield Road Coventry Coventry Education N/A Yes - Via Email 52.4034143 -1.5300449
17563 op-snap---monthly-publication-march-2025.pdf   1320 2025-03 Car Audi A3 Grey Driving without Reasonable Consideration None Bordesley Circus Bordesley Circus Birmingham Birmingham Education N/A Yes - Via Email 52.4728608 -1.8754722
17571 op-snap---monthly-publication-march-2025.pdf   1328 2025-03 Pedal Bike BMW X4 Black Driving without Reasonable Consideration None STATION ROAD Station Road Solihull Solihull Education N/A Yes - Via Email 52.3927253 -1.6455823
17597 op-snap---monthly-publication-march-2025.pdf   1354 2025-03 Pedal Bike Ford FOCUS Silver Driving without Reasonable Consideration None ROCKY LANE Rocky Lane Birmingham Birmingham Education N/A Yes - Via Email 52.5285859 -1.9100513
17599 op-snap---monthly-publication-march-2025.pdf   1356 2025-03 Pedal Bike Toyota Hilux Silver Driving without Reasonable Consideration None Leach Green Lane Leach Green Lane Birmingham Birmingham Education N/A Yes - Via Email 52.392246 -2.0101736
17641 op-snap---monthly-publication-march-2025.pdf   1398 2025-03 Car BMW 3 series Grey Driving without Reasonable Consideration None M6 Motorway, Northbound, between 6 and 7 M6 Motorway, Northbound, between 6 and 7 Birmingham Birmingham Education N/A Yes - Via Email    
17645 op-snap---monthly-publication-march-2025.pdf   1402 2025-03 Car Volkswagen Passat Grey Driving without Reasonable Consideration None Lichfield Road Lichfield Road Walsall Walsall Education N/A Yes - Via Email 52.6095168 -2.0493009
17671 op-snap---monthly-publication-march-2025.pdf   1428 2025-03 Pedal Bike Hyundai IX20 Silver Driving without Reasonable Consideration None Tennal Road Tennal Road Birmingham Birmingham Education N/A Yes - Via Email 52.4578511 -1.9734988
17704 op-snap---monthly-publication-march-2025.pdf   1461 2025-03 Pedal Bike Nissan NOTE Black Driving without Reasonable Consideration No vehicle excise licence BROWNHILLS ROAD Brownhills Road Walsall Walsall Education N/A Yes - Via Email 52.6328141 -1.9272671
17705 op-snap---monthly-publication-march-2025.pdf   1462 2025-03 Pedal Bike Hyundai I30 White Driving without Reasonable Consideration No vehicle excise licence BROWNHILLS ROAD Brownhills Road Walsall Walsall Education N/A Yes - Via Email 52.6328141 -1.9272671
17713 op-snap---monthly-publication-march-2025.pdf   1470 2025-03 Pedal Bike Ford Transit Grey Driving without Reasonable Consideration None The Scotchill The Scotchill Coventry Coventry Education N/A Yes - Via Email 52.435625 -1.528323

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