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

121 rows where disposal = "Education", month = "2025-11" and offence = "Driving without Due Care and Attention" 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 25

  • Ford 17
  • Vauxhall 15
  • Volkswagen 15
  • BMW 11
  • Mercedes-Benz 10
  • Audi 8
  • Nissan 5
  • Peugeot 5
  • Toyota 4
  • Fiat 3
  • Honda 3
  • Kia 3
  • Land Rover 3
  • Skoda 3
  • Volvo 3
  • Citroen 2
  • Dennis 2
  • London Taxi 2
  • Byd 1
  • Hyundai 1
  • Jaguar 1
  • Mazda 1
  • Mg 1
  • Porsche 1
  • Suzuki 1

council_area 9

  • Birmingham 64
  • Coventry 16
  • Solihull 12
  • Dudley 10
  • Walsall 6
  • Sandwell 5
  • Sutton Coldfield 4
  • Wolverhampton 3
  • Halesowen 1

reporter_transport_mode 5

  • Car 69
  • Pedal Bike 43
  • Other 4
  • Pedestrian 3
  • Motorbike 2

offence 1

  • Driving without Due Care and Attention · 121 ✖

month 1

  • 2025-11 · 121 ✖

disposal 1

  • Education · 121 ✖
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
20464 op-snap---monthly-publication-november-2025.pdf   6 2025-11 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Upper Clifton Road Upper Clifton Road Sutton Coldfield Sutton Coldfield Education N/A   52.5664481 -1.8270564
20468 op-snap---monthly-publication-november-2025.pdf   10 2025-11 Pedal Bike Audi A3.. White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
20469 op-snap---monthly-publication-november-2025.pdf   11 2025-11 Car Peugeot 2008 Orange Driving without Due Care and Attention None Great Bridge LIONS roundabout Great Bridge LIONS roundabout Sandwell Sandwell Education N/A      
20482 op-snap---monthly-publication-november-2025.pdf   24 2025-11 Car Ford Focus Grey Driving without Due Care and Attention None Clarks Lane Clarks Lane Walsall Walsall Education N/A      
20483 op-snap---monthly-publication-november-2025.pdf   25 2025-11 Car Vauxhall astra Red Driving without Due Care and Attention None M6 /M42 M6 /M42 Birmingham Birmingham Education N/A   52.5183642 -1.8724942
20488 op-snap---monthly-publication-november-2025.pdf   30 2025-11 Pedal Bike London Taxi taxi Black Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
20491 op-snap---monthly-publication-november-2025.pdf   33 2025-11 Car Ford Fiesta White Driving without Due Care and Attention None Walmley Ash Road Walmley Ash Road Sutton Coldfield Sutton Coldfield Education N/A   52.5376726 -1.7973346
20498 op-snap---monthly-publication-november-2025.pdf   40 2025-11 Car Vauxhall corsa Grey Driving without Due Care and Attention None Booth Street Booth Street Birmingham Birmingham Education N/A   52.5039035 -1.9447084
20502 op-snap---monthly-publication-november-2025.pdf   44 2025-11 Car Audi A3 Blue Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
20510 op-snap---monthly-publication-november-2025.pdf   52 2025-11 Other Fiat Punto White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
20511 op-snap---monthly-publication-november-2025.pdf   53 2025-11 Car Volkswagen Polo White Driving without Due Care and Attention None Cartland Road Cartland Road Birmingham Birmingham Education N/A   52.4298554 -1.9086629
20515 op-snap---monthly-publication-november-2025.pdf   57 2025-11 Other Audi   Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
20517 op-snap---monthly-publication-november-2025.pdf   59 2025-11 Pedal Bike Kia Ceed Brown Driving without Due Care and Attention None A444 Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A   52.4214017 -1.4870278
20524 op-snap---monthly-publication-november-2025.pdf   66 2025-11 Car Audi Q3 Grey Driving without Due Care and Attention None Priory Road / Bristol Road Priory Road / Bristol Road Birmingham Birmingham Education N/A   52.4552604 -1.9104552
20540 op-snap---monthly-publication-november-2025.pdf   82 2025-11 Car BMW 750E Grey Driving without Due Care and Attention None Edgbaston Road Edgbaston Road Birmingham Birmingham Education N/A   52.4552785 -1.906384
20564 op-snap---monthly-publication-november-2025.pdf   106 2025-11 Other Volkswagen Tiago Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
20577 op-snap---monthly-publication-november-2025.pdf   119 2025-11 Car Honda CR V Black Driving without Due Care and Attention None Hermes Crescent Hermes Crescent Coventry Coventry Education N/A   52.4257211 -1.4566304
20609 op-snap---monthly-publication-november-2025.pdf   151 2025-11 Pedal Bike Citroen Berlingo Silver Driving without Due Care and Attention None Solihull Lane Solihull Lane Birmingham Birmingham Education N/A   52.4230862 -1.8347873
20610 op-snap---monthly-publication-november-2025.pdf   152 2025-11 Pedal Bike Land Rover Discovery Grey Driving without Due Care and Attention None St Bernards Road Street Bernards Road Solihull Solihull Education N/A      
20614 op-snap---monthly-publication-november-2025.pdf   156 2025-11 Pedal Bike Ford Focus White Driving without Due Care and Attention None Counden Wedge Drive Counden Wedge Drive Coventry Coventry Education N/A      
20621 op-snap---monthly-publication-november-2025.pdf   163 2025-11 Pedal Bike Kia Picanto Silver Driving without Due Care and Attention None Widney Manor Road Widney Manor Road Solihull Solihull Education N/A   52.3902967 -1.7659209
20623 op-snap---monthly-publication-november-2025.pdf   165 2025-11 Car Volkswagen ID7 Blue Driving without Due Care and Attention None M6 North M6 North Wolverhampton Wolverhampton Education N/A   52.6049795 -2.085282
20626 op-snap---monthly-publication-november-2025.pdf   168 2025-11 Car Audi A4 Black Driving without Due Care and Attention None Coventry Ring Road Coventry Ring Road Coventry Coventry Education N/A      
20628 op-snap---monthly-publication-november-2025.pdf   170 2025-11 Car Skoda Yeti Grey Driving without Due Care and Attention None Bells Lane Bells Lane Birmingham Birmingham Education N/A   52.4053419 -1.8944602
20630 op-snap---monthly-publication-november-2025.pdf   172 2025-11 Car Byd Seal Black Driving without Due Care and Attention None Victoria Road Victoria Road Sutton Coldfield Sutton Coldfield Education N/A   52.5615573 -1.820549
20637 op-snap---monthly-publication-november-2025.pdf   179 2025-11 Car Hyundai Tucson Grey Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham Education N/A   52.5020639 -1.9026192
20640 op-snap---monthly-publication-november-2025.pdf   182 2025-11 Car BMW 440.. Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
20641 op-snap---monthly-publication-november-2025.pdf   183 2025-11 Car BMW 320.. Grey Driving without Due Care and Attention Use vehicle on a road without valid test certificate High Street Sedgley High Street Sedgley Dudley Dudley Education N/A   52.543975 -2.122501
20644 op-snap---monthly-publication-november-2025.pdf   186 2025-11 Car Volkswagen Tayron Silver Driving without Due Care and Attention None Edward Road Edward Road Birmingham Birmingham Education N/A   52.4580901 -1.894458
20652 op-snap---monthly-publication-november-2025.pdf   194 2025-11 Car Mercedes-Benz AMG Blue Driving without Due Care and Attention None Richmond Road Olton Richmond Road Olton Solihull Solihull Education N/A   52.4430827 -1.8006217
20671 op-snap---monthly-publication-november-2025.pdf   213 2025-11 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Rolfe Street Rolfe Street Sandwell Sandwell Education N/A   52.4972172 -1.9607539
20690 op-snap---monthly-publication-november-2025.pdf   232 2025-11 Car Nissan Micra Gold Driving without Due Care and Attention None M42 SB J6 M42 Southbound J6 Solihull Solihull Education N/A      
20700 op-snap---monthly-publication-november-2025.pdf   242 2025-11 Pedal Bike Mercedes-Benz C180 Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
20710 op-snap---monthly-publication-november-2025.pdf   252 2025-11 Car Volkswagen Golf Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Coventry Coventry Education N/A   52.4272882 -1.5753221
20720 op-snap---monthly-publication-november-2025.pdf   262 2025-11 Car Ford Focus Red Driving without Due Care and Attention No vehicle excise licence Corngreaves Road Corngreaves Road Sandwell Sandwell Education N/A   52.4686695 -2.0776976
20750 op-snap---monthly-publication-november-2025.pdf   292 2025-11 Pedal Bike Mercedes-Benz Sprinter Silver Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
20751 op-snap---monthly-publication-november-2025.pdf   293 2025-11 Pedal Bike Volkswagen Golf Black Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
20754 op-snap---monthly-publication-november-2025.pdf   296 2025-11 Car Mercedes-Benz A200 Silver Driving without Due Care and Attention None Selly Oak Road Selly Oak Road Birmingham Birmingham Education N/A   52.4263875 -1.9397954
20759 op-snap---monthly-publication-november-2025.pdf   301 2025-11 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Wretham Street Wretham Street Birmingham Birmingham Education N/A      
20761 op-snap---monthly-publication-november-2025.pdf   303 2025-11 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Umberslade Road Umberslade Road Birmingham Birmingham Education N/A   52.4304526 -1.9216716
20762 op-snap---monthly-publication-november-2025.pdf   304 2025-11 Pedal Bike Kia Niro Grey Driving without Due Care and Attention None Moat Road Moat Road Walsall Walsall Education N/A   52.5848413 -1.9996882
20769 op-snap---monthly-publication-november-2025.pdf   311 2025-11 Car Mg HS Black Driving without Due Care and Attention None Six Ways Island, Erdington Six Ways Island, Erdington Birmingham Birmingham Education N/A      
20772 op-snap---monthly-publication-november-2025.pdf   314 2025-11 Car Volvo Tractor Orange Driving without Due Care and Attention None M42 NB towards J9 M42 Northbound towards J9 Birmingham Birmingham Education N/A      
20778 op-snap---monthly-publication-november-2025.pdf   320 2025-11 Car Ford GALAXY White Driving without Due Care and Attention None A444 A444 Coventry Coventry Education N/A      
20790 op-snap---monthly-publication-november-2025.pdf   332 2025-11 Pedal Bike BMW 520D Grey Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
20791 op-snap---monthly-publication-november-2025.pdf   333 2025-11 Pedal Bike Peugeot 208GT Yellow Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
20792 op-snap---monthly-publication-november-2025.pdf   334 2025-11 Pedal Bike Suzuki Swift Silver Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
20796 op-snap---monthly-publication-november-2025.pdf   338 2025-11 Car Vauxhall Astra Black Driving without Due Care and Attention None Merry Hill Merry Hill Dudley Dudley Education N/A   52.4817646 -2.1113435
20814 op-snap---monthly-publication-november-2025.pdf   356 2025-11 Car Volkswagen Crafter White Driving without Due Care and Attention None St Mary's Road Street Mary's Road Birmingham Birmingham Education N/A      
20817 op-snap---monthly-publication-november-2025.pdf   359 2025-11 Car Toyota Auris Grey Driving without Due Care and Attention None Pickford Way Pickford Way Coventry Coventry Education N/A   52.4220824 -1.5625669
20824 op-snap---monthly-publication-november-2025.pdf   366 2025-11 Car BMW 520I Black Driving without Due Care and Attention None M42 Juncution 5 M42 Juncution 5 Solihull Solihull Education N/A      
20839 op-snap---monthly-publication-november-2025.pdf   381 2025-11 Pedal Bike Mercedes-Benz S350 Black Driving without Due Care and Attention None Highfield Road Highfield Road Birmingham Birmingham Education N/A   52.4216321 -1.855984
20856 op-snap---monthly-publication-november-2025.pdf   398 2025-11 Car Fiat Ducato White Driving without Due Care and Attention None Jockey Road Jockey Road Birmingham Birmingham Education N/A   52.5512291 -1.8357776
20860 op-snap---monthly-publication-november-2025.pdf   402 2025-11 Pedal Bike Ford Transit White Driving without Due Care and Attention None Coleshill Heath Road Coleshill Heath Road Solihull Solihull Education N/A   52.4667242 -1.7283592
21032 op-snap---monthly-publication-november-2025.pdf   574 2025-11 Car BMW 435D Blue Driving without Due Care and Attention None Kingston Road Kingston Road Birmingham Birmingham Education N/A   52.4747333 -1.8728345
21033 op-snap---monthly-publication-november-2025.pdf   575 2025-11 Car Volkswagen Polo White Driving without Due Care and Attention None Kingston Road Kingston Road Birmingham Birmingham Education N/A   52.4747333 -1.8728345
21052 op-snap---monthly-publication-november-2025.pdf   594 2025-11 Car Vauxhall Corsa Grey Driving without Due Care and Attention None Lower Queen Street Lower Queen Street Sutton Coldfield Sutton Coldfield Education N/A   52.5603978 -1.8227403
21066 op-snap---monthly-publication-november-2025.pdf   608 2025-11 Car Volkswagen polo Grey Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
21079 op-snap---monthly-publication-november-2025.pdf   621 2025-11 Car Volvo V40 Blue Driving without Due Care and Attention None Aston Road, from Dartmouth Circus Aston Road, from Dartmouth Circus Birmingham Birmingham Education N/A      
21084 op-snap---monthly-publication-november-2025.pdf   626 2025-11 Pedal Bike Honda HR-V Grey Driving without Due Care and Attention None Spiceland Road, Northfield Spiceland Road, Northfield Birmingham Birmingham Education N/A   52.4240276 -1.9735466
21236 op-snap---monthly-publication-november-2025.pdf   778 2025-11 Pedal Bike Ford Transit White Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
21237 op-snap---monthly-publication-november-2025.pdf   779 2025-11 Pedal Bike Audi A4 Black Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
21273 op-snap---monthly-publication-november-2025.pdf   815 2025-11 Car Volkswagen Golf Silver Driving without Due Care and Attention None High Street Great Bridge... not sure where that is yet High Street Great Bridge. not sure where that is yet Sandwell Sandwell Education N/A      
21295 op-snap---monthly-publication-november-2025.pdf   837 2025-11 Car Volkswagen Golf Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
21306 op-snap---monthly-publication-november-2025.pdf   848 2025-11 Car Nissan Qashqai Grey Driving without Due Care and Attention None Sir Herbert Austin Way Sir Herbert Austin Way Birmingham Birmingham Education N/A   52.4132666 -1.9735631
21318 op-snap---monthly-publication-november-2025.pdf   860 2025-11 Motorbike Audi A3 Grey Driving without Due Care and Attention None M42 J7 M42 J7 Birmingham Birmingham Education N/A      
21371 op-snap---monthly-publication-november-2025.pdf   913 2025-11 Car Peugeot 208 Grey Driving without Due Care and Attention None Gravelly Hill Gravelly Hill Birmingham Birmingham Education N/A   52.5153884 -1.8527437
21389 op-snap---monthly-publication-november-2025.pdf   931 2025-11 Pedal Bike Volkswagen Scirocco Red Driving without Due Care and Attention None Linthouse Lane Linthouse Lane Wolverhampton Wolverhampton Education N/A   52.6118187 -2.0810618
21394 op-snap---monthly-publication-november-2025.pdf   936 2025-11 Car Fiat Punto White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
21405 op-snap---monthly-publication-november-2025.pdf   947 2025-11 Pedal Bike Ford Ranger Orange Driving without Due Care and Attention None A456 Manor Way Manor Way Halesowen Halesowen Education N/A   52.5203602 -1.824434
21411 op-snap---monthly-publication-november-2025.pdf   953 2025-11 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham Education N/A   52.4422505 -1.8539684
21412 op-snap---monthly-publication-november-2025.pdf   954 2025-11 Car Vauxhall Corsa Black Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Education N/A   52.4149064 -1.7832364
21413 op-snap---monthly-publication-november-2025.pdf   955 2025-11 Pedal Bike Nissan Juke Black Driving without Due Care and Attention None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
21416 op-snap---monthly-publication-november-2025.pdf   958 2025-11 Car Land Rover Range Rover Black Driving without Due Care and Attention None Richmond Road Richmond Road Solihull Solihull Education N/A   52.4430188 -1.8022218
21418 op-snap---monthly-publication-november-2025.pdf   960 2025-11 Car Citroen Belingo black Driving without Due Care and Attention None Bushbury Lane Bushbury Lane Wolverhampton Wolverhampton Education N/A   52.6107589 -2.1231693
21432 op-snap---monthly-publication-november-2025.pdf   974 2025-11 Car Vauxhall Zafira Silver Driving without Due Care and Attention None Walsall Road, Perry Barr Walsall Road, Perry Barr Birmingham Birmingham Education N/A   52.5290137 -1.9098939
21436 op-snap---monthly-publication-november-2025.pdf   978 2025-11 Car Audi A3 Black Driving without Due Care and Attention None Bentley Mill Way Bentley Mill Way Walsall Walsall Education N/A   52.5786876 -2.0165115
21438 op-snap---monthly-publication-november-2025.pdf   980 2025-11 Car Peugeot 106 Black Driving without Due Care and Attention None Ringway St Johns Ringway Street Johns Coventry Coventry Education N/A      
21458 op-snap---monthly-publication-november-2025.pdf   1000 2025-11 Pedal Bike Ford Transit Black Driving without Due Care and Attention None Leighswood Road Leighswood Road Walsall Walsall Education N/A   52.6071662 -1.9231466
21459 op-snap---monthly-publication-november-2025.pdf   1001 2025-11 Pedal Bike BMW 1 series black Driving without Due Care and Attention None Dalmuir Road, Longbridge Dalmuir Road, Longbridge Birmingham Birmingham Education N/A   52.3921725 -1.9876776
21467 op-snap---monthly-publication-november-2025.pdf   1009 2025-11 Pedal Bike Mercedes-Benz Citan grey Driving without Due Care and Attention None South Road, B4186, Stourbridge South Road, B4186, Stourbridge Dudley Dudley Education N/A   52.45108 -2.1531606
21471 op-snap---monthly-publication-november-2025.pdf   1013 2025-11 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
21492 op-snap---monthly-publication-november-2025.pdf   1034 2025-11 Car Volkswagen Golf Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
21543 op-snap---monthly-publication-november-2025.pdf   1085 2025-11 Car Dennis Bus   Driving without Due Care and Attention None Dudley Stree, Carters Green, West Bromwich Dudley Stree, Carters Green, West Bromwich Sandwell Sandwell Education N/A      
21545 op-snap---monthly-publication-november-2025.pdf   1087 2025-11 Pedal Bike Ford Mondeo Black Driving without Due Care and Attention None School Road, Kings Heath School Road, Kings Heath Birmingham Birmingham Education N/A   52.4384417 -1.8875299
21551 op-snap---monthly-publication-november-2025.pdf   1093 2025-11 Pedal Bike London Taxi Taxi Black Driving without Due Care and Attention None Croft Road Croft Road Coventry Coventry Education N/A   52.4064698 -1.5167474
21554 op-snap---monthly-publication-november-2025.pdf   1096 2025-11 Car Vauxhall Vivaro White Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Dudley Dudley Education N/A   52.5063917 -2.1711502
21558 op-snap---monthly-publication-november-2025.pdf   1100 2025-11 Pedal Bike Nissan Micra Blue Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham Education N/A   52.4422505 -1.8539684
21562 op-snap---monthly-publication-november-2025.pdf   1104 2025-11 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
21585 op-snap---monthly-publication-november-2025.pdf   1127 2025-11 Car Volkswagen Golf Blue Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
21613 op-snap---monthly-publication-november-2025.pdf   1155 2025-11 Car Mercedes-Benz C220 Black Driving without Due Care and Attention None Nunts Lane Nunts Lane Coventry Coventry Education N/A   52.4483335 -1.5168597
21629 op-snap---monthly-publication-november-2025.pdf   1171 2025-11 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Holly Hill Road Holly Hill Road Birmingham Birmingham Education N/A   52.408161 -2.008839
21665 op-snap---monthly-publication-november-2025.pdf   1207 2025-11 Car Ford B-Max Blue Driving without Due Care and Attention   Foleshill Road, Coventry Foleshill Road, Coventry Coventry Coventry Education N/A   52.4363104 -1.4936555
21670 op-snap---monthly-publication-november-2025.pdf   1212 2025-11 Car Mazda 6 Sport Nav D Red Driving without Due Care and Attention None Solihull Bypass A41 Solihull Bypass A41 Solihull Solihull Education N/A   52.4201188 -1.7735079
21671 op-snap---monthly-publication-november-2025.pdf   1213 2025-11 Car Vauxhall Corsa White Driving without Due Care and Attention None Drew's Lane, Washwood Heath Drew's Lane, Washwood Heath Birmingham Birmingham Education N/A      
21672 op-snap---monthly-publication-november-2025.pdf   1214 2025-11 Car Toyota Yaris Silver Driving without Due Care and Attention None Drew's Lane, Washwood Heath Drew's Lane, Washwood Heath Birmingham Birmingham Education N/A      
21674 op-snap---monthly-publication-november-2025.pdf   1216 2025-11 Car Toyota C-HR White Driving without Due Care and Attention None Ogley Road Ogley Road Walsall Walsall Education N/A   52.6449907 -1.9244475
21677 op-snap---monthly-publication-november-2025.pdf   1219 2025-11 Car Jaguar XE Grey Driving without Due Care and Attention None Birmingham Road, Walsall Birmingham Road, Walsall Walsall Walsall Education N/A   52.5643557 -1.9468417
21685 op-snap---monthly-publication-november-2025.pdf   1227 2025-11 Pedal Bike Peugeot 208 Grey Driving without Due Care and Attention None The Broadway, Stourbridge The Broadway, Stourbridge Dudley Dudley Education N/A   52.4411413 -2.1695219
21693 op-snap---monthly-publication-november-2025.pdf   1235 2025-11 Car Ford galaxy Silver Driving without Due Care and Attention None crampers field Crampers Field Coventry Coventry Education N/A   52.4176927 -1.5257854

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