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

165 rows where disposal = "Education", month = "2025-09" and reporter_transport_mode = "Car" 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 28

  • Ford 21
  • Volkswagen 21
  • BMW 16
  • Mercedes-Benz 14
  • Toyota 12
  • Audi 9
  • Seat 9
  • Vauxhall 7
  • Nissan 6
  • Skoda 6
  • Citroen 4
  • Honda 4
  • Hyundai 4
  • Peugeot 4
  • Kia 3
  • Land Rover 3
  • Volvo 3
  • Jaguar 2
  • Lexus 2
  • Renault 2
  • Cupra 1
  • Daf 1
  • Fiat 1
  • Lamborghini 1
  • Mg 1
  • Mitsubishi 1
  • Porsche 1
  • Suzuki 1

offence 9

  • Contravening a Red Traffic Light 75
  • Driving without Due Care and Attention 71
  • Driving without Reasonable Consideration 7
  • Drive a vehicle other than on the carriageway of a 6
  • Contravene Lane Closure Red X 2
  • DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 1
  • Drive on hard shoulder 1
  • Driving a vehicle wholly or partly on a footpath 1
  • Stop a vehicle within pelican pedestrian crossing l 1

council_area 8

  • Birmingham 90
  • Dudley 14
  • Coventry 13
  • Solihull 12
  • Sandwell 11
  • Walsall 11
  • Wolverhampton 8
  • Sutton Coldfield 6

reporter_transport_mode 1

  • Car · 165 ✖

month 1

  • 2025-09 · 165 ✖

disposal 1

  • Education · 165 ✖
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
23784 op-snap---monthly-publication-september-2025.pdf   3 2025-09 Car Cupra Formentor Black Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
23789 op-snap---monthly-publication-september-2025.pdf   8 2025-09 Car   Jaecoo Silver Driving without Due Care and Attention None B4154 Norton Road - Pelsall Norton Road - Pelsall Walsall Walsall Education N/A   52.6337623 -1.9674818
23815 op-snap---monthly-publication-september-2025.pdf   34 2025-09 Car Skoda Octavia Blue Driving without Due Care and Attention None Consitiution Hill Consitiution Hill Birmingham Birmingham Education N/A      
23818 op-snap---monthly-publication-september-2025.pdf   37 2025-09 Car Land Rover Evoque White Contravening a Red Traffic Light None Spitfire Island Spitfire Island Birmingham Birmingham Education N/A   52.5138106 -1.797297
23825 op-snap---monthly-publication-september-2025.pdf   44 2025-09 Car Nissan X Trail Black Contravene Lane Closure Red X None Kings Heath High Street Kings Heath High Street Birmingham Birmingham Education N/A   52.4391028 -1.893289
23839 op-snap---monthly-publication-september-2025.pdf   58 2025-09 Car BMW M3 Black Contravening a Red Traffic Light None A4036 Merry Hill Merry Hill Dudley Dudley Education N/A   52.4817646 -2.1113435
23847 op-snap---monthly-publication-september-2025.pdf   66 2025-09 Car Nissan Juke Grey Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
23854 op-snap---monthly-publication-september-2025.pdf   73 2025-09 Car Volkswagen Golf Black Contravening a Red Traffic Light None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
23856 op-snap---monthly-publication-september-2025.pdf   75 2025-09 Car Renault Clio Blue Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell Education N/A   52.4926604 -2.0216743
23861 op-snap---monthly-publication-september-2025.pdf   80 2025-09 Car Audi SQ5 Black Contravening a Red Traffic Light None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
23876 op-snap---monthly-publication-september-2025.pdf   95 2025-09 Car Audi A3 Silver Contravening a Red Traffic Light None Leighswood Road Aldridge Leighswood Road Aldridge Walsall Walsall Education N/A   52.6071662 -1.9231466
23883 op-snap---monthly-publication-september-2025.pdf   102 2025-09 Car BMW X6 Grey Contravening a Red Traffic Light None Nailcote Lane Nailcote Lane Solihull Solihull Education N/A   52.3948197 -1.6142205
23889 op-snap---monthly-publication-september-2025.pdf   108 2025-09 Car Mercedes-Benz A35 AMG Yellow Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
23898 op-snap---monthly-publication-september-2025.pdf   117 2025-09 Car BMW 3 series Black Driving without Due Care and Attention None Aldridge Road Aldridge Road Birmingham Birmingham Education N/A   52.5368764 -1.8976461
23900 op-snap---monthly-publication-september-2025.pdf   119 2025-09 Car Ford Transit White Drive on hard shoulder None M5 Jct 1 Northbound M5 Junction 1 Northbound Walsall Walsall Education N/A      
23910 op-snap---monthly-publication-september-2025.pdf   129 2025-09 Car Mercedes-Benz   Black Contravening a Red Traffic Light None Birmingham Road Birmingham Road Birmingham Birmingham Education N/A   52.5505398 -1.8252993
23911 op-snap---monthly-publication-september-2025.pdf   130 2025-09 Car Ford Mach Black Driving without Due Care and Attention None Littleton Street East Littleton Street East Walsall Walsall Education N/A   52.5887823 -1.9801166
23932 op-snap---monthly-publication-september-2025.pdf   151 2025-09 Car Audi Q7.. Grey Driving without Due Care and Attention None Spitfire island Spitfire island Birmingham Birmingham Education N/A   52.5138106 -1.797297
23942 op-snap---monthly-publication-september-2025.pdf   161 2025-09 Car Volkswagen Polo White Contravening a Red Traffic Light None A41 Express way Express way Sandwell Sandwell Education N/A      
23943 op-snap---monthly-publication-september-2025.pdf   162 2025-09 Car Seat Ibiza Black Driving without Due Care and Attention None Yardley Green Road Yardley Green Road Birmingham Birmingham Education N/A   52.4764154 -1.8311418
23947 op-snap---monthly-publication-september-2025.pdf   166 2025-09 Car Ford Fiesta Silver Driving without Due Care and Attention None Ulverley Green Road Ulverley Green Road Solihull Solihull Education N/A   52.4367749 -1.80129
23948 op-snap---monthly-publication-september-2025.pdf   167 2025-09 Car Land Rover Sport Grey Drive a vehicle other than on the carriageway of a motorway None M6 Motorway, Southbound. Jn 7A M6 Motorway, Southbound. Junction 7A Birmingham Birmingham Education N/A      
23952 op-snap---monthly-publication-september-2025.pdf   171 2025-09 Car Ford Transit Grey Driving without Due Care and Attention None Wagon Lane Wagon Lane Solihull Solihull Education N/A   52.4525076 -1.7981031
23955 op-snap---monthly-publication-september-2025.pdf   174 2025-09 Car Toyota Corolla Black Driving without Due Care and Attention None Warwick Road Acocks Green Warwick Road Acocks Green Birmingham Birmingham Education N/A   52.4468495 -1.8244484
23956 op-snap---monthly-publication-september-2025.pdf   175 2025-09 Car Ford Focus Black Contravening a Red Traffic Light None Wake Green Road Wake Green Road Birmingham Birmingham Education N/A   52.4437078 -1.8783408
23958 op-snap---monthly-publication-september-2025.pdf   177 2025-09 Car Seat Ibiza Grey Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
23967 op-snap---monthly-publication-september-2025.pdf   186 2025-09 Car Skoda Kodiaq Silver Contravening a Red Traffic Light None Holloway Head Holloway Head Birmingham Birmingham Education N/A   52.474258 -1.9019723
23969 op-snap---monthly-publication-september-2025.pdf   188 2025-09 Car Nissan Note Orange Contravening a Red Traffic Light None Broad Lane Kings Heath Broad Lane Kings Heath Birmingham Birmingham Education N/A   52.410787 -1.918202
23976 op-snap---monthly-publication-september-2025.pdf   195 2025-09 Car BMW 320.. White Driving without Due Care and Attention None A38 Aston Expressway Aston Expressway Birmingham Birmingham Education N/A   52.493793 -1.8881773
23980 op-snap---monthly-publication-september-2025.pdf   199 2025-09 Car   Polestar Blue Contravening a Red Traffic Light No vehicle excise licence Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A   52.4103191 -1.8670224
23981 op-snap---monthly-publication-september-2025.pdf   200 2025-09 Car   Husqvarna White Driving without Due Care and Attention None Melchett Road Melchett Road Birmingham Birmingham Education N/A   52.413984 -1.9251511
23983 op-snap---monthly-publication-september-2025.pdf   202 2025-09 Car Ford Ka Red Driving without Due Care and Attention None Grange Road, Halesowen Grange Road, Halesowen Sandwell Sandwell Education N/A      
23984 op-snap---monthly-publication-september-2025.pdf   203 2025-09 Car Mercedes-Benz AMG C White Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Education N/A   52.4149064 -1.7832364
23987 op-snap---monthly-publication-september-2025.pdf   206 2025-09 Car Volvo V90 White Driving without Due Care and Attention None Broadmeadow Lane Broadmeadow Lane Birmingham Birmingham Education N/A      
24005 op-snap---monthly-publication-september-2025.pdf   224 2025-09 Car Ford Focus Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
24006 op-snap---monthly-publication-september-2025.pdf   225 2025-09 Car Peugeot 308 Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
24007 op-snap---monthly-publication-september-2025.pdf   226 2025-09 Car Toyota yaris Red Contravening a Red Traffic Light None Northfied Road Northfied Road Birmingham Birmingham Education N/A      
24012 op-snap---monthly-publication-september-2025.pdf   231 2025-09 Car Volkswagen Golf Grey Driving without Due Care and Attention None Leamington Road Leamington Road Coventry Coventry Education N/A   52.3921304 -1.5156601
24019 op-snap---monthly-publication-september-2025.pdf   238 2025-09 Car Mercedes-Benz E200 Blue Driving without Due Care and Attention None M6 Motorway M6 Motorway Coventry Coventry Education N/A      
24050 op-snap---monthly-publication-september-2025.pdf   269 2025-09 Car Mg ZS Grey Driving without Due Care and Attention None Broadway Road Broadway Road Walsall Walsall Education N/A   52.5740759 -1.9628886
24054 op-snap---monthly-publication-september-2025.pdf   273 2025-09 Car BMW S1000RR White Driving without Due Care and Attention None Sundial Lane Sundial Lane Birmingham Birmingham Education N/A   52.5471217 -1.9336068
24063 op-snap---monthly-publication-september-2025.pdf   282 2025-09 Car Mercedes-Benz B180 Blue Driving without Reasonable Consideration None A38 Minworth Island Minworth Island Birmingham Birmingham Education N/A   52.5316279 -1.7762358
24070 op-snap---monthly-publication-september-2025.pdf   289 2025-09 Car Ford C-max White Contravening a Red Traffic Light None Coundon Wedge Drive Coundon Wedge Drive Coventry Coventry Education N/A   52.4385402 -1.5483746
24077 op-snap---monthly-publication-september-2025.pdf   296 2025-09 Car Audi SQ5 Silver Contravening a Red Traffic Light None Jenkins Street Jenkins Street Birmingham Birmingham Education N/A   52.4705155 -1.8650312
24081 op-snap---monthly-publication-september-2025.pdf   300 2025-09 Car Seat Leon White Driving without Due Care and Attention None Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A   52.4214017 -1.4870278
24087 op-snap---monthly-publication-september-2025.pdf   306 2025-09 Car Citroen C3 Grey Driving without Due Care and Attention None Moorend Avenue Moorend Avenue Birmingham Birmingham Education N/A      
24095 op-snap---monthly-publication-september-2025.pdf   314 2025-09 Car BMW 420d White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
24109 op-snap---monthly-publication-september-2025.pdf   328 2025-09 Car Kia Sportage Black Driving without Due Care and Attention None Finchley Road Finchley Road Birmingham Birmingham Education N/A   52.5488456 -1.8735092
24111 op-snap---monthly-publication-september-2025.pdf   330 2025-09 Car Vauxhall Mokka White Contravening a Red Traffic Light None Stonehouse Road Stonehouse Road Sutton Coldfield Sutton Coldfield Education N/A   52.5554307 -1.8439169
24130 op-snap---monthly-publication-september-2025.pdf   349 2025-09 Car Ford Transit Silver Contravening a Red Traffic Light None Chester Road at Jockey Road Chester Road at Jockey Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
24139 op-snap---monthly-publication-september-2025.pdf   358 2025-09 Car Ford Transit Red Driving without Due Care and Attention None Baldwin Lane Baldwin Lane Birmingham Birmingham Education N/A   52.4151192 -1.84291
24142 op-snap---monthly-publication-september-2025.pdf   361 2025-09 Car BMW 118.. White Contravening a Red Traffic Light None Blue Lane West Walsall Blue Lane West Walsall Walsall Walsall Education N/A   52.5872883 -1.9906083
24143 op-snap---monthly-publication-september-2025.pdf   362 2025-09 Car Ford Transit Grey Contravening a Red Traffic Light None Queslett Road Queslett Road Birmingham Birmingham Education N/A   52.5458699 -1.9304484
24144 op-snap---monthly-publication-september-2025.pdf   363 2025-09 Car Citroen C4 Black Contravening a Red Traffic Light None Walsall Road Walsall Road Sandwell Sandwell Education N/A   52.5439824 -1.9306805
24147 op-snap---monthly-publication-september-2025.pdf   366 2025-09 Car Ford focus Silver Contravening a Red Traffic Light None Tessell Lane Tessell Lane Birmingham Birmingham Education N/A      
24156 op-snap---monthly-publication-september-2025.pdf   375 2025-09 Car Seat Alhambra Silver Driving without Due Care and Attention None Monument Road Monument Road Birmingham Birmingham Education N/A   52.4731312 -1.930947
24165 op-snap---monthly-publication-september-2025.pdf   384 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None Chester Road North, Streetly Chester Road North, Streetly Sutton Coldfield Sutton Coldfield Education N/A      
24167 op-snap---monthly-publication-september-2025.pdf   386 2025-09 Car Honda civic White Driving without Reasonable Consideration None M5 J3 M5 J3 Birmingham Birmingham Education N/A   52.4846642 -1.9297585
24170 op-snap---monthly-publication-september-2025.pdf   389 2025-09 Car   Dennis lorry White Driving without Due Care and Attention None Stubbers Green Road / Brickyard Road Stubbers Green Road / Brickyard Road Walsall Walsall Education N/A   52.615148 -1.9423921
24182 op-snap---monthly-publication-september-2025.pdf   401 2025-09 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Walmley Road Walmley Road Sutton Coldfield Sutton Coldfield Education N/A   52.5405351 -1.8002219
24192 op-snap---monthly-publication-september-2025.pdf   411 2025-09 Car Nissan Pulsar Blue Contravening a Red Traffic Light None Stafford Road, Jn2 M54 Stafford Road, Jn2 M54 Wolverhampton Wolverhampton Education N/A      
24195 op-snap---monthly-publication-september-2025.pdf   414 2025-09 Car Seat Leon White Contravening a Red Traffic Light None Level Street Brierley Hill Level Street Brierley Hill Dudley Dudley Education N/A   52.4842017 -2.116248
24199 op-snap---monthly-publication-september-2025.pdf   418 2025-09 Car BMW IX Blue Contravene Lane Closure Red X None A38M A38M Birmingham Birmingham Education N/A      
24210 op-snap---monthly-publication-september-2025.pdf   429 2025-09 Car Seat Alhambra Blue Contravening a Red Traffic Light None Redford Road Redford Road Coventry Coventry Education N/A      
24212 op-snap---monthly-publication-september-2025.pdf   431 2025-09 Car Audi Q4 Black Contravening a Red Traffic Light None A3400 Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
24213 op-snap---monthly-publication-september-2025.pdf   432 2025-09 Car Mercedes-Benz GLC White Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
24215 op-snap---monthly-publication-september-2025.pdf   434 2025-09 Car Volkswagen Golf Black Contravening a Red Traffic Light None Queslett Road Queslett Road Birmingham Birmingham Education N/A   52.5458699 -1.9304484
24216 op-snap---monthly-publication-september-2025.pdf   435 2025-09 Car Honda Civic Blue Contravening a Red Traffic Light None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
24226 op-snap---monthly-publication-september-2025.pdf   445 2025-09 Car Mitsubishi Hi-Lux Black Contravening a Red Traffic Light None Minworth Island Minworth Island Birmingham Birmingham Education N/A   52.5316279 -1.7762358
24229 op-snap---monthly-publication-september-2025.pdf   448 2025-09 Car Peugeot Partner White Contravening a Red Traffic Light None High Street / A491, Audnam, Stourbridge High Street / A491, Audnam, Stourbridge Dudley Dudley Education N/A   52.4722518 -2.1552954
24232 op-snap---monthly-publication-september-2025.pdf   451 2025-09 Car Nissan Qashqai Black Contravening a Red Traffic Light None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield Education N/A   52.5361464 -1.8270283
24238 op-snap---monthly-publication-september-2025.pdf   457 2025-09 Car Porsche Taycan White Contravening a Red Traffic Light None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A   52.5872149 -1.8300386
24243 op-snap---monthly-publication-september-2025.pdf   462 2025-09 Car Ford Focus Blue Driving without Due Care and Attention None M6 Jct 6 Southbound M6 Junction 6 Southbound Birmingham Birmingham Education N/A   52.676119 -2.0858425
24245 op-snap---monthly-publication-september-2025.pdf   464 2025-09 Car Toyota Yaris Blue Driving without Due Care and Attention None Preston Road Preston Road Birmingham Birmingham Education N/A   52.4633325 -1.8102488
24246 op-snap---monthly-publication-september-2025.pdf   465 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
24255 op-snap---monthly-publication-september-2025.pdf   474 2025-09 Car Lexus RX400 Blue Driving without Reasonable Consideration None Alum Rock Road Alum Rock Road Birmingham Birmingham Education N/A   52.4883936 -1.8310056
24256 op-snap---monthly-publication-september-2025.pdf   475 2025-09 Car Volvo XC40 Black Contravening a Red Traffic Light None Turves Green Turves Green Birmingham Birmingham Education N/A   52.4035104 -1.9666324
24261 op-snap---monthly-publication-september-2025.pdf   480 2025-09 Car BMW 1 Series Black Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Education N/A   52.4879006 -2.1188734
24282 op-snap---monthly-publication-september-2025.pdf   501 2025-09 Car Volkswagen Polo White Contravening a Red Traffic Light None Walsall Road Perry Barr Walsall Road Perry Barr Birmingham Birmingham Education N/A   52.5219655 -1.9010321
24285 op-snap---monthly-publication-september-2025.pdf   504 2025-09 Car BMW 320 White Driving without Reasonable Consideration None Princetorpe Way Princetorpe Way Coventry Coventry Education N/A      
24288 op-snap---monthly-publication-september-2025.pdf   507 2025-09 Car Mercedes-Benz c200 Red Contravening a Red Traffic Light None Cole Hill Lane Cole Hill Lane Birmingham Birmingham Education N/A   52.4951084 -1.7913851
24290 op-snap---monthly-publication-september-2025.pdf   509 2025-09 Car Vauxhall Vivaro White Driving without Due Care and Attention None All Saints Way All Saints Way Sandwell Sandwell Education N/A   52.5344405 -1.985568
24300 op-snap---monthly-publication-september-2025.pdf   519 2025-09 Car Kia sportage Silver Driving without Reasonable Consideration None Cateswell Road Cateswell Road Birmingham Birmingham Education N/A   52.4387009 -1.8454267
24303 op-snap---monthly-publication-september-2025.pdf   522 2025-09 Car Volkswagen Polo Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
24308 op-snap---monthly-publication-september-2025.pdf   527 2025-09 Car Kia Picanto White Drive a vehicle other than on the carriageway of a motorway None M6 Motorway M6 Motorway Sandwell Sandwell Education N/A      
24321 op-snap---monthly-publication-september-2025.pdf   540 2025-09 Car Volkswagen Touran Red Contravening a Red Traffic Light None M6 J10 Island M6 J10 Island Walsall Walsall Education N/A   52.6760749 -2.0862582
24326 op-snap---monthly-publication-september-2025.pdf   545 2025-09 Car Ford Kuga Silver Contravening a Red Traffic Light None Bromford Road, Oldbury Bromford Road, Oldbury Sandwell Sandwell Education N/A   52.509645 -2.0106692
24334 op-snap---monthly-publication-september-2025.pdf   553 2025-09 Car BMW   White Driving without Due Care and Attention None A491 High Street High Street Dudley Dudley Education N/A   52.4779764 -2.1598371
24343 op-snap---monthly-publication-september-2025.pdf   562 2025-09 Car Mercedes-Benz A Class Red Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
24344 op-snap---monthly-publication-september-2025.pdf   563 2025-09 Car Volkswagen Polo White Drive a vehicle other than on the carriageway of a motorway None M6 Motorway M6 Motorway Birmingham Birmingham Education N/A   52.5327447 -1.899844
24345 op-snap---monthly-publication-september-2025.pdf   564 2025-09 Car Mercedes-Benz   White Drive a vehicle other than on the carriageway of a motorway None M6 Motorway M6 Motorway Birmingham Birmingham Education N/A   52.5327447 -1.899844
24350 op-snap---monthly-publication-september-2025.pdf   569 2025-09 Car Hyundai Tuscon Black Drive a vehicle other than on the carriageway of a motorway None M42 Motorway M42 Motorway Birmingham Birmingham Education N/A   52.490826 -1.8882034
24356 op-snap---monthly-publication-september-2025.pdf   575 2025-09 Car Toyota   Black Driving without Due Care and Attention None A461 Lichfield Road Lichfield Road Walsall Walsall Education N/A   52.6095168 -2.0493009
24361 op-snap---monthly-publication-september-2025.pdf   580 2025-09 Car Vauxhall Mokka White Contravening a Red Traffic Light None A41 Oxford Street Oxford Street Wolverhampton Wolverhampton Education N/A   52.5651361 -2.0707545
24363 op-snap---monthly-publication-september-2025.pdf   582 2025-09 Car Ford Fiesta Silver Driving without Due Care and Attention None Halesowen Road Halesowen Road Dudley Dudley Education N/A   52.4624413 -2.0175178
24368 op-snap---monthly-publication-september-2025.pdf   587 2025-09 Car Seat Leon Blue Driving without Due Care and Attention None Clay Lane Clay Lane Birmingham Birmingham Education N/A   52.4509038 -1.8083784
24375 op-snap---monthly-publication-september-2025.pdf   594 2025-09 Car BMW   Blue Contravening a Red Traffic Light None Brettell Lane Brettell Lane Dudley Dudley Education N/A   52.4706676 -2.1545486
24400 op-snap---monthly-publication-september-2025.pdf   619 2025-09 Car Vauxhall Zafira Black Contravening a Red Traffic Light None Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A   52.4214017 -1.4870278
24402 op-snap---monthly-publication-september-2025.pdf   621 2025-09 Car Honda civic Black Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham Education N/A      
24403 op-snap---monthly-publication-september-2025.pdf   622 2025-09 Car Vauxhall Zafira Brown Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham Education N/A      

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE reports (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            source_file TEXT NOT NULL,
            source_page INTEGER,
            source_row INTEGER,
            month TEXT NOT NULL,
            reporter_transport_mode TEXT,
            vehicle_make TEXT,
            vehicle_model TEXT,
            vehicle_colour TEXT,
            offence TEXT,
            second_offence TEXT,
            offence_location_raw TEXT,
            offence_location TEXT,
            council_area_raw TEXT,
            council_area TEXT,
            disposal TEXT,
            nfa_rationale TEXT,
            witness_contacted TEXT
        , latitude REAL, longitude REAL);
CREATE INDEX idx_month ON reports(month);
CREATE INDEX idx_council_area ON reports(council_area);
CREATE INDEX idx_offence ON reports(offence);
CREATE INDEX idx_disposal ON reports(disposal);
CREATE INDEX idx_location ON reports(offence_location);