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

102 rows where council_area = "Sandwell" and month = "2025-05" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 6

month 1

  • 2025-05 · 102 ✖

council_area 1

  • Sandwell · 102 ✖
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
18653 op-snap---monthly-publication-may-2025.pdf   15 2025-05 Pedestrian Volvo XC60 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Clent Road Clent Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4725947 -1.9952306
18655 op-snap---monthly-publication-may-2025.pdf   17 2025-05 Pedestrian Mercedes-Benz C220 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Castle Road Castle Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5258312 -2.0768625
18656 op-snap---monthly-publication-may-2025.pdf   18 2025-05 Pedestrian Kia Sportage Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheatley Road Wheatley Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4705903 -1.9933164
18677 op-snap---monthly-publication-may-2025.pdf   39 2025-05 Car Tesla Model 3 White Using a Mobile Phone Whilst Driving None Olbury Road Olbury Road Sandwell Sandwell Fixed Penalty N/A      
18679 op-snap---monthly-publication-may-2025.pdf   41 2025-05 Car Volvo XC60 White Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell NFA Outside of 14 Days NIP   52.4926604 -2.0216743
18684 op-snap---monthly-publication-may-2025.pdf   46 2025-05 Motorbike Hyundai IX35 Grey Driving without Due Care and Attention None M5 NB 2-1 M5 Northbound 2-1 Sandwell Sandwell NFA Outside of 14 Days NIP      
18688 op-snap---monthly-publication-may-2025.pdf   50 2025-05 Car BMW X3.. Grey Using a Mobile Phone Whilst Driving None Seagar Street West Bromwich Seagar Street West Bromwich Sandwell Sandwell Fixed Penalty N/A   52.5223981 -1.9866132
18689 op-snap---monthly-publication-may-2025.pdf   51 2025-05 Motorbike BMW 320d Blue Driving without Due Care and Attention None M5 NB 2-1 M5 Northbound 2-1 Sandwell Sandwell NFA Outside of 14 Days NIP      
18691 op-snap---monthly-publication-may-2025.pdf   53 2025-05 Car Audi A4 White Contravening a Red Traffic Light None A41 A41 Sandwell Sandwell NFA Outside of 14 Days NIP      
18692 op-snap---monthly-publication-may-2025.pdf   54 2025-05 Car Honda Jazz Blue Using a Mobile Phone Whilst Driving None M5 North towards M6 M5 North towards M6 Sandwell Sandwell Fixed Penalty N/A      
18721 op-snap---monthly-publication-may-2025.pdf   83 2025-05 Car Toyota C-HR Grey Contravening a Red Traffic Light None A461 Birmingham Road Birmingham Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5461417 -1.9334193
18722 op-snap---monthly-publication-may-2025.pdf   84 2025-05 Car Ford Fiesta Silver Contravening a Red Traffic Light None Bromford Lane Bromford Lane Sandwell Sandwell NFA Outside of 14 Days NIP   52.5141069 -2.003425
18724 op-snap---monthly-publication-may-2025.pdf   86 2025-05 Car Mercedes-Benz EQC Grey Driving without Due Care and Attention None Telford Way West Bromwich Telford Way West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP   52.5065282 -1.976582
18759 op-snap---monthly-publication-may-2025.pdf   121 2025-05 Car Kia XCEED White Contravening a Red Traffic Light None BRADLEYS LANE Bradleys Lane Sandwell Sandwell Education N/A      
18779 op-snap---monthly-publication-may-2025.pdf   141 2025-05 Car Ford CONNECT White Contravening a Red Traffic Light None TIPTON ROAD Tipton Road Sandwell Sandwell Education N/A   52.5157798 -2.0437191
18793 op-snap---monthly-publication-may-2025.pdf   155 2025-05 Car Mazda THREE Blue Driving without Due Care and Attention None Beacon Road Beacon Road Sandwell Sandwell NFA No VRM   52.5499696 -1.9797407
18803 op-snap---monthly-publication-may-2025.pdf   165 2025-05 Car BMW X1 Black Driving without Reasonable Consideration None M5 M5 Sandwell Sandwell NFA Outside of 14 Days NIP      
18844 op-snap---monthly-publication-may-2025.pdf   206 2025-05 Car Toyota Prius White Driving without Due Care and Attention None Great Barr Interchange Great Barr Interchange Sandwell Sandwell NFA Outside of 14 Days NIP   52.5526943 -1.9321372
18848 op-snap---monthly-publication-may-2025.pdf   210 2025-05 Car Vauxhall Corsa Black Driving without Due Care and Attention None Wilford Road West West Bromwich Wilford Road West West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP   52.5310242 -1.9925982
18865 op-snap---monthly-publication-may-2025.pdf   227 2025-05 Car Vauxhall corsa Black Using a Mobile Phone Whilst Driving None Pound Road Pound Road Sandwell Sandwell Fixed Penalty N/A   52.5541213 -2.0098297
18930 op-snap---monthly-publication-may-2025.pdf   292 2025-05 Car Audi A5.. Blue Driving without Due Care and Attention None M5 North Junction 1 M5 North Junction 1 Sandwell Sandwell NFA No Independent Evidence Available      
18979 op-snap---monthly-publication-may-2025.pdf   341 2025-05 Pedal Bike Volkswagen Passat Grey Using a Mobile Phone Whilst Driving None Myvod Road Myvod Road Sandwell Sandwell Fixed Penalty N/A   52.562989 -2.0085973
18980 op-snap---monthly-publication-may-2025.pdf   342 2025-05 Pedal Bike Toyota Yaris Blue Stop a vehicle on pedestrian crossing None Crankhall Lane Crankhall Lane Sandwell Sandwell Education N/A   52.5489715 -1.9927402
18987 op-snap---monthly-publication-may-2025.pdf   349 2025-05 car Honda 125 Silver Using a Mobile Phone Whilst Driving None Bromford Lane, West Bromwich Bromford Lane, West Bromwich Sandwell Sandwell Fixed Penalty N/A   52.5138332 -2.0029321
19064 op-snap---monthly-publication-may-2025.pdf   426 2025-05 Car BMW 7 SERIES Grey Driving without Due Care and Attention None BLACK COUNTRY NEW ROAD Black Country New Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5527191 -2.0312967
19068 op-snap---monthly-publication-may-2025.pdf   430 2025-05 Car Citroen BERLINGO Grey Contravening a Red Traffic Light None BLACK COUNTRY NEW ROAD Black Country New Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5527191 -2.0312967
19069 op-snap---monthly-publication-may-2025.pdf   431 2025-05 Car BMW 320.. Blue Driving without Due Care and Attention None M5 South Jct 1 M5 South Junction 1 Sandwell Sandwell NFA Outside of 14 Days NIP      
19080 op-snap---monthly-publication-may-2025.pdf   442 2025-05 Car Vauxhall Corsa Green Contravening a Red Traffic Light None Cronehills Linkway Cronehills Linkway Sandwell Sandwell Education N/A   52.5216057 -1.9934283
19135 op-snap---monthly-publication-may-2025.pdf   497 2025-05 Car Audi A3 Black Cause vehicle to be left in a dangerous position none WATVILLE ROAD Watville Road Sandwell Sandwell Fixed Penalty N/A      
19144 op-snap---monthly-publication-may-2025.pdf   506 2025-05 Car Volkswagen Golf Black Misc - Non Traffic Offences None Cockshed Lane Cockshed Lane Sandwell Sandwell NFA No Offence      
19146 op-snap---monthly-publication-may-2025.pdf   508 2025-05 Car Toyota Prius Black Contravening a Red Traffic Light None Foxoak Street Foxoak Street Sandwell Sandwell Fixed Penalty N/A      
19179 op-snap---monthly-publication-may-2025.pdf   541 2025-05 Pedestrian Vauxhall Zafira Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Woodland Street Woodland Street Sandwell Sandwell Other Action Taken nN/A      
19185 op-snap---monthly-publication-may-2025.pdf   547 2025-05 Car Audi S4 Grey Misc - Non Traffic Offences None Merry Hill Car Park Merry Hill Car Park Sandwell Sandwell NFA No Offence      
19186 op-snap---monthly-publication-may-2025.pdf   548 2025-05 Car Ford Transit Grey Using a Mobile Phone Whilst Driving None Merry Hill Merry Hill Sandwell Sandwell Fixed Penalty N/A   52.5262964 -2.0021527
19224 op-snap---monthly-publication-may-2025.pdf   586 2025-05 Car Mercedes-Benz 310 Blue Driving without Due Care and Attention None Heath Street Heath Street Sandwell Sandwell Warning Letter n/a   52.4919542 -1.9467735
19251 op-snap---monthly-publication-may-2025.pdf   613 2025-05 Pedal Bike Renault Scenic Silver Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Roebuck Lane Roebuck Lane Sandwell Sandwell Warning Letter N/A   52.5027291 -1.9781818
19272 op-snap---monthly-publication-may-2025.pdf   634 2025-05 Car Mercedes-Benz Bus Red Driving without Due Care and Attention None A41 Expressway Expressway Sandwell Sandwell NFA Outside of 14 Days NIP   52.5256969 -2.004455
19290 op-snap---monthly-publication-may-2025.pdf   652 2025-05 Other Toyota Aygo Silver Misc - Non Traffic Offences None Walter Road Walter Road Sandwell Sandwell NFA No Offence   52.4958886 -1.9822933
19292 op-snap---monthly-publication-may-2025.pdf   654 2025-05 Car Seat Ibiza Black Contravening a Red Traffic Light None Ringway Ringway Sandwell Sandwell NFA Outside of 14 Days NIP   52.5021337 -2.0133861
19328 op-snap---monthly-publication-may-2025.pdf   690 2025-05 Car BMW 530e Grey Driving without Due Care and Attention No Insurance Hamstead Road Hamstead Road Sandwell Sandwell Court N/A   52.5330374 -1.9304577
19378 op-snap---monthly-publication-may-2025.pdf   740 2025-05 Car Yamaha   Yellow Contravening a Red Traffic Light None Pound Road Pound Road Sandwell Sandwell Education N/A   52.5541213 -2.0098297
19404 op-snap---monthly-publication-may-2025.pdf   766 2025-05 car Audi Q2 Red Contravening a Red Traffic Light None Dartmouth road Dartmouth road Sandwell Sandwell Education N/A   52.5035988 -1.972107
19405 op-snap---monthly-publication-may-2025.pdf   767 2025-05 car BMW X1 White Contravening a Red Traffic Light None Dartmouth road Dartmouth road Sandwell Sandwell Education N/A   52.5035988 -1.972107
19410 op-snap---monthly-publication-may-2025.pdf   772 2025-05 Car Mitsubishi Outlander Black Driving without Due Care and Attention None A40137 Tipton Tipton Sandwell Sandwell Education N/A   52.5290396 -2.0693747
19423 op-snap---monthly-publication-may-2025.pdf   785 2025-05 Car Honda Civic Grey Stop a vehicle within pelican pedestrian crossing limits None Bearwood Road Bearwood Road Sandwell Sandwell Education N/A   52.4725977 -1.9684448
19429 op-snap---monthly-publication-may-2025.pdf   791 2025-05 Car Volkswagen Golf Silver Driving without Due Care and Attention None A4123 Birmingham New Road Birmingham New Road Sandwell Sandwell Warning Letter N/A   52.5151598 -2.064717
19433 op-snap---monthly-publication-may-2025.pdf   795 2025-05 Car BMW 5 Series Grey Driving without Due Care and Attention None Cape Hill Cape Hill Sandwell Sandwell Fixed Penalty N/A   52.4867919 -1.9604535
19434 op-snap---monthly-publication-may-2025.pdf   796 2025-05 Car Mercedes-Benz GLC Blue Driving without Due Care and Attention None M5 NB to M6 SB slip road M5 Northbound to M6 Southbound slip road Sandwell Sandwell Education N/A      
19446 op-snap---monthly-publication-may-2025.pdf   808 2025-05 Car Toyota Prius White Driving without Due Care and Attention None Perry Hill Road Perry Hill Road Sandwell Sandwell Education N/A   52.4633031 -2.0036421
19450 op-snap---monthly-publication-may-2025.pdf   812 2025-05 Car Audi A3 Black Driving without Due Care and Attention None Cranford Street Cranford Street Sandwell Sandwell Fixed Penalty N/A   52.4945899 -1.9534417
19453 op-snap---monthly-publication-may-2025.pdf   815 2025-05 Car Vauxhall Corsa Green Driving without Due Care and Attention None Tollhouse Way Tollhouse Way Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.5003461 -1.9782389
19454 op-snap---monthly-publication-may-2025.pdf   816 2025-05 Car BMW 116I Green Driving without Reasonable Consideration None Tollhouse Way Tollhouse Way Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.5003461 -1.9782389
19457 op-snap---monthly-publication-may-2025.pdf   819 2025-05 Pedal Bike Ford Fiesta Black Driving without Due Care and Attention None High Street High Street Sandwell Sandwell Education N/A   52.5128738 -1.9842054
19466 op-snap---monthly-publication-may-2025.pdf   828 2025-05 Car Volvo HGV White Driving without Due Care and Attention None Great Bridge St Great Bridge Street Sandwell Sandwell NFA No Offence   52.5292014 -2.0306229
19471 op-snap---monthly-publication-may-2025.pdf   833 2025-05 Car Fiat Ducato recovery White Driving without Due Care and Attention None M5 motorway M5 motorway Sandwell Sandwell NFA No Offence   52.5368223 -1.96752
19476 op-snap---monthly-publication-may-2025.pdf   838 2025-05 Car Toyota MPV White Contravening a Red Traffic Light None Londerry Lane Londerry Lane Sandwell Sandwell Warning Letter N/A      
19482 op-snap---monthly-publication-may-2025.pdf   844 2025-05 Car Audi A3 Black Driving without Due Care and Attention None M5 South M5 South Sandwell Sandwell Education N/A   52.5228877 -2.0650728
19517 op-snap---monthly-publication-may-2025.pdf   879 2025-05 Car Vauxhall Insignia Green Contravening a Red Traffic Light None More Street, Brierley Hill More Street, Brierley Hill Sandwell Sandwell NFA No VRM      
19563 op-snap---monthly-publication-may-2025.pdf   925 2025-05 Car Ford Mondeo Silver Contravening a Red Traffic Light None Birchley Island Birchley Island Sandwell Sandwell Education N/A   52.4926604 -2.0216743
19566 op-snap---monthly-publication-may-2025.pdf   928 2025-05 Car Ford Focus White Driving without Due Care and Attention None Stony Lane Stony Lane Sandwell Sandwell Court N/A   52.49546 -1.9747508
19572 op-snap---monthly-publication-may-2025.pdf   934 2025-05 Car Honda Civic Black Contravening a Red Traffic Light None Portway Road, Oldbury Portway Road, Oldbury Sandwell Sandwell Education N/A   52.5004096 -2.0189226
19594 op-snap---monthly-publication-may-2025.pdf   956 2025-05 Car Fiat 500 White Contravening a Red Traffic Light None Market Place, Tipton Market Place, Tipton Sandwell Sandwell NFA No Independent Evidence Available   52.5303627 -2.0353018
19615 op-snap---monthly-publication-may-2025.pdf   977 2025-05 Car Ford Transit Red Contravening a Red Traffic Light None Wolverhampton Road, Oldbury Wolverhampton Road, Oldbury Sandwell Sandwell Education N/A   52.5028787 -2.0328384
19622 op-snap---monthly-publication-may-2025.pdf   984 2025-05 Pedal Bike Skoda Octavia White Contravening a Red Traffic Light None Bearwood Road Bearwood Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4725977 -1.9684448
19625 op-snap---monthly-publication-may-2025.pdf   987 2025-05 Pedal Bike Volkswagen Golf Black Using a Mobile Phone Whilst Driving None Bearwood Road Bearwood Road Sandwell Sandwell NFA No Independent Evidence Available   52.4725977 -1.9684448
19629 op-snap---monthly-publication-may-2025.pdf   991 2025-05 Car Mercedes-Benz BENZ Grey Driving without Reasonable Consideration None OLDBURY INTERCHANGE Oldbury Interchange Sandwell Sandwell Education N/A   52.5032925 -2.0167285
19697 op-snap---monthly-publication-may-2025.pdf   1059 2025-05 Pedestrian Volkswagen Scirocco Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Castle Road Easat Castle Road Easat Sandwell Sandwell Warning Letter N/A      
19843 op-snap---monthly-publication-may-2025.pdf   1205 2025-05 Pedestrian Toyota Yaris Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Springfield Road Springfield Road Sandwell Sandwell Fixed Penalty N/A   52.4865171 -1.9991074
19845 op-snap---monthly-publication-may-2025.pdf   1207 2025-05 Pedestrian Hyundai Santa Fe Blue Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Springfield Road Springfield Road Sandwell Sandwell Fixed Penalty N/A   52.4865171 -1.9991074
19867 op-snap---monthly-publication-may-2025.pdf   1229 2025-05 Pedestrian Mercedes-Benz Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High Street Smethwick High Street Smethwick Sandwell Sandwell Warning Letter N/A   52.4955266 -1.9697742
19880 op-snap---monthly-publication-may-2025.pdf   1242 2025-05 Pedestrian Peugeot 208GT Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Tame Rd East Tame Road East Sandwell Sandwell NFA No Offence      
19886 op-snap---monthly-publication-may-2025.pdf   1248 2025-05 Pedestrian Toyota Hiace Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bowden Road Bowden Road Sandwell Sandwell NFA Not in Public Interest   52.4980696 -1.9805738
19924 op-snap---monthly-publication-may-2025.pdf   1286 2025-05 Car BMW NP Black Driving without Due Care and Attention None A34 A34 Sandwell Sandwell NFA Outside of 14 Days NIP      
20015 op-snap---monthly-publication-may-2025.pdf   1377 2025-05 Pedestrian Mercedes-Benz NP Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ramsay road Ramsay road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4723061 -1.9942558
20016 op-snap---monthly-publication-may-2025.pdf   1378 2025-05 Pedestrian Mercedes-Benz NP Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Clent road Clent road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4725947 -1.9952306
20043 op-snap---monthly-publication-may-2025.pdf   1405 2025-05 Car Ford np Orange Motor vehicle fail to comply with solid white line road markings None West bromwhich Albion ground West bromwhich Albion ground Sandwell Sandwell NFA Outside of 14 Days NIP      
20045 op-snap---monthly-publication-may-2025.pdf   1407 2025-05 Car   NP White Contravening a Red Traffic Light None A38 A38 Sandwell Sandwell NFA Outside of 14 Days NIP      
20058 op-snap---monthly-publication-may-2025.pdf   1420 2025-05 car Ford S/C-Max Silver Driving without Due Care and Attention None rood end road Rood End Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4964103 -1.9993677
20067 op-snap---monthly-publication-may-2025.pdf   1429 2025-05 Car Audi NP White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None exit of churchfields estate Exit Of Churchfields Estate Sandwell Sandwell NFA Outside of 14 Days NIP      
20075 op-snap---monthly-publication-may-2025.pdf   1437 2025-05 Car Audi NP Black Contravening a Red Traffic Light None Junction of trinity street Junction of trinity street Sandwell Sandwell NFA Outside of 14 Days NIP      
20101 op-snap---monthly-publication-may-2025.pdf   1463 2025-05 Car   NP Black Driving without Due Care and Attention None Trinity way road Trinity way road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5117624 -1.9888638
20104 op-snap---monthly-publication-may-2025.pdf   1466 2025-05 Pedal Bike Peugeot Canal and river t rBuslute Driving without Due Care and Attention None Birmingham road Birmingham road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5461417 -1.9334193
20154 op-snap---monthly-publication-may-2025.pdf   1516 2025-05 Pedal Bike Volkswagen Caddy Grey Driving without Due Care and Attention None Shidas Lane Shidas Lane Sandwell Sandwell Warning Letter N/A   52.501103 -2.0254412
20155 op-snap---monthly-publication-may-2025.pdf   1517 2025-05 Pedestrian Toyota Yaris Silver Driving a vehicle wholly or partly on a footpath None Dog Kennel Lane Dog Kennel Lane Sandwell Sandwell Warning Letter N/A   52.4901007 -1.9986317
20159 op-snap---monthly-publication-may-2025.pdf   1521 2025-05 Pedal Bike Audi q7 White Driving without Due Care and Attention None Price Street Price Street Sandwell Sandwell Warning Letter N/A   52.5173895 -1.9973426
20160 op-snap---monthly-publication-may-2025.pdf   1522 2025-05 Car Suzuki sx4 Black Driving without Due Care and Attention None Park Lane West Park Lane West Sandwell Sandwell Warning Letter N/A   52.5227061 -2.0617482
20161 op-snap---monthly-publication-may-2025.pdf   1523 2025-05 Car Mini Cooper Black Driving without Due Care and Attention None Halesowen Road Halesowen Road Sandwell Sandwell Warning Letter N/A   52.4727241 -2.0645309
20176 op-snap---monthly-publication-may-2025.pdf   1538 2025-05 Car Nissan NV200 White Contravening a Red Traffic Light None Winson Green Road Winson Green Road Sandwell Sandwell Warning Letter N/A   52.5079951 -1.9495377
20178 op-snap---monthly-publication-may-2025.pdf   1540 2025-05 Car Vauxhall Movano White Using a Mobile Phone Whilst Driving None M5, Northbound M5, Northbound Sandwell Sandwell Warning Letter N/A      
20255 op-snap---monthly-publication-may-2025.pdf   1617 2025-05 Car BMW 520D Grey Dangerous Driving None Lewisham Road Lewisham Road Sandwell Sandwell Warning Letter N/A   52.5007274 -1.9661248
20269 op-snap---monthly-publication-may-2025.pdf   1631 2025-05 Car Seat Ibiza White Dangerous Driving None Market Place, Tipton Market Place, Tipton Sandwell Sandwell Warning Letter N/A   52.5303627 -2.0353018
20277 op-snap---monthly-publication-may-2025.pdf   1639 2025-05 Car Mitsubishi outlander Silver Driving without Due Care and Attention None New Swan Lane New Swan Lane Sandwell Sandwell Warning Letter N/A   52.5293372 -2.0107584
20289 op-snap---monthly-publication-may-2025.pdf   1651 2025-05 Car Seat Leon Brown Driving without Due Care and Attention None M5 M5 Sandwell Sandwell Warning Letter N/A      
20291 op-snap---monthly-publication-may-2025.pdf   1653 2025-05 Car       Misc - Non Traffic Offences None M5 M5 Sandwell Sandwell NFA Misc Inc Crimes      
20355 op-snap---monthly-publication-may-2025.pdf   1717 2025-05 Car Mitsubishi eclipse Black Driving without Due Care and Attention None Castle Road West Castle Road West Sandwell Sandwell Warning Letter N/A   52.4686934 -1.9974957
20357 op-snap---monthly-publication-may-2025.pdf   1719 2025-05 Pedestrian Toyota MPV White Cause vehicle to be left in a dangerous position None Bearwood road Bearwood road Sandwell Sandwell Warning Letter N/A   52.4725977 -1.9684448
20364 op-snap---monthly-publication-may-2025.pdf   1726 2025-05 Car Hyundai i10 Grey Driving without Due Care and Attention None hillwood Common hillwood Common Sandwell Sandwell Warning Letter N/A      
20367 op-snap---monthly-publication-may-2025.pdf   1729 2025-05 Car Volkswagen Passat Grey Driving without Due Care and Attention None Londonderry Road Londonderry Road Sandwell Sandwell Warning Letter N/A   52.4879743 -1.9926164
20374 op-snap---monthly-publication-may-2025.pdf   1736 2025-05 Car Toyota Estima Silver Driving without Due Care and Attention None All Saints Way All Saints Way Sandwell Sandwell Warning Letter N/A   52.5344405 -1.985568
20382 op-snap---monthly-publication-may-2025.pdf   1744 2025-05 Pedal Bike Peugeot 2008 Black Driving without Due Care and Attention none Crankhall Lane Crankhall Lane Sandwell Sandwell Warning Letter N/A   52.5489715 -1.9927402

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