reports
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'}
101 rows where council_area = "Sutton Coldfield" and month = "2025-03" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale, latitude, longitude
vehicle_make 25
offence 12
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 25
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 15
- Driving without Reasonable Consideration 14
- Stop a vehicle within pelican pedestrian crossing limits 12
- Contravening a Red Traffic Light 11
- Driving without Due Care and Attention 11
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 5
- Cause vehicle to be left in a dangerous position 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- Stop a vehicle on pedestrian crossing 2
- Fail to display front VRM plate 1
- Using a Mobile Phone Whilst Driving 1
disposal 6
- Fixed Penalty 44
- Warning Letter 24
- Education 22
- NFA 8
- Court 2
- Other Action Taken 1
reporter_transport_mode 4
- Pedestrian 42
- Car 36
- Pedal Bike 22
- Bus 1
month 1
- 2025-03 · 101 ✖
council_area 1
- Sutton Coldfield · 101 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16253 | op-snap---monthly-publication-march-2025.pdf | 10 | 2025-03 | Pedestrian | Dacia | Sandero | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street, Sutton Coldfield | Lower Queen Street, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5596343 | -1.8225298 | |
| 16255 | op-snap---monthly-publication-march-2025.pdf | 12 | 2025-03 | Pedestrian | Skoda | Fabia | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 16256 | op-snap---monthly-publication-march-2025.pdf | 13 | 2025-03 | Pedestrian | Mg | 3 | white | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 16257 | op-snap---monthly-publication-march-2025.pdf | 14 | 2025-03 | Pedestrian | Mercedes-Benz | A-class | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 16258 | op-snap---monthly-publication-march-2025.pdf | 15 | 2025-03 | Pedestrian | Ford | Ranger | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 16275 | op-snap---monthly-publication-march-2025.pdf | 32 | 2025-03 | Car | Mercedes-Benz | X350 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 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 | |
| 16422 | op-snap---monthly-publication-march-2025.pdf | 179 | 2025-03 | Car | Volkswagen | T Roc | Grey | Driving without Due Care and Attention | None | Oxleys Road | Oxleys Road | Sutton Coldfield | Sutton Coldfield | Court | N/A | Yes - Via Email | |||
| 16438 | op-snap---monthly-publication-march-2025.pdf | 195 | 2025-03 | Car | Vauxhall | UK | Silver | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Sutton Coldfield | Sutton Coldfield | NFA | No VRM | Yes - Via Email | |||
| 16474 | op-snap---monthly-publication-march-2025.pdf | 231 | 2025-03 | Pedal Bike | Bentley Bentayga | Blue | Driving without Reasonable Consideration | None | Walsall Road | Walsall Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5910363 | -1.8499297 | ||
| 16478 | op-snap---monthly-publication-march-2025.pdf | 235 | 2025-03 | Pedal Bike | Skoda | Rapid | Black | Driving without Due Care and Attention | None | Stonehouse Road | Stonehouse Road | Sutton Coldfield | Sutton Coldfield | Other Action Taken | N/A | Yes - Via Email | 52.5554307 | -1.8439169 | |
| 16480 | op-snap---monthly-publication-march-2025.pdf | 237 | 2025-03 | Pedestrian | Mazda | 2 SE-L | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chester Road, Boldmere (Sutton Coldfield) | Chester Road, Boldmere (Sutton Coldfield) | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 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 | |
| 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 | |||
| 16653 | op-snap---monthly-publication-march-2025.pdf | 410 | 2025-03 | Pedestrian | BMW | 225 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 16656 | op-snap---monthly-publication-march-2025.pdf | 413 | 2025-03 | Pedestrian | Peugeot | 208 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 16715 | op-snap---monthly-publication-march-2025.pdf | 472 | 2025-03 | Car | Citroen | Berlingo 1000 | Grey | Driving without Due Care and Attention | None | A446 Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 16778 | op-snap---monthly-publication-march-2025.pdf | 535 | 2025-03 | Pedal Bike | Land Rover | EVOQUE | Black | Driving without Reasonable Consideration | None | UPPER HOLLAND ROAD | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 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 | |
| 16946 | op-snap---monthly-publication-march-2025.pdf | 703 | 2025-03 | Pedal Bike | Land Rover | Defender | Grey | Contravening a Red Traffic Light | None | Wylde Green Road | Wylde Green Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.546976 | -1.8098124 | |
| 16948 | op-snap---monthly-publication-march-2025.pdf | 705 | 2025-03 | Pedal Bike | Volkswagen | Crafter | Black | Contravening a Red Traffic Light | None | Walmley Road | Walmley Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5405351 | -1.8002219 | |
| 16951 | op-snap---monthly-publication-march-2025.pdf | 708 | 2025-03 | Pedal Bike | Tesla | Model Y | White | Driving without Reasonable Consideration | None | Anchorage Road | Anchorage Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5699381 | -1.8249539 | |
| 16965 | op-snap---monthly-publication-march-2025.pdf | 722 | 2025-03 | Pedal Bike | Peugeot | 308CC | Blue | Fail to display front VRM plate | None | Worcester Lane | Worcester Lane | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5908671 | -1.8140277 | |
| 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 | ||||
| 16969 | op-snap---monthly-publication-march-2025.pdf | 726 | 2025-03 | Pedal Bike | Peugeot | 308 | Grey | Driving without Reasonable Consideration | None | Cliff Road Road | Cliff Road Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | |||
| 17003 | op-snap---monthly-publication-march-2025.pdf | 760 | 2025-03 | Pedestrian | BMW | 318i | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 17004 | op-snap---monthly-publication-march-2025.pdf | 761 | 2025-03 | Pedestrian | Ford | Focus | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 17113 | op-snap---monthly-publication-march-2025.pdf | 870 | 2025-03 | Car | Toyota | Corolla | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Victoria Road | Victoria Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5615573 | -1.820549 | |
| 17115 | op-snap---monthly-publication-march-2025.pdf | 872 | 2025-03 | Car | Ford | Ka | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Victoria Road | Victoria Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5615573 | -1.820549 | |
| 17116 | op-snap---monthly-publication-march-2025.pdf | 873 | 2025-03 | Car | Vauxhall | Insignia | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Victoria Road | Victoria Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5615573 | -1.820549 | |
| 17188 | op-snap---monthly-publication-march-2025.pdf | 945 | 2025-03 | Pedestrian | Toyota | Prius | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 17189 | op-snap---monthly-publication-march-2025.pdf | 946 | 2025-03 | Pedestrian | Volkswagen | Golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 17190 | op-snap---monthly-publication-march-2025.pdf | 947 | 2025-03 | Pedestrian | Land Rover | Range Rover | Grey | Cause vehicle to be left in a dangerous position | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 17241 | op-snap---monthly-publication-march-2025.pdf | 998 | 2025-03 | Pedestrian | Jaguar | iPACE | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lichfield Road Mere Green | Lichfield Road Mere Green | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 17242 | op-snap---monthly-publication-march-2025.pdf | 999 | 2025-03 | Pedestrian | Kia | Picanto | Green | Stop a vehicle within pelican pedestrian crossing limits | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5959906 | -1.8345802 | |
| 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 | |||
| 17284 | op-snap---monthly-publication-march-2025.pdf | 1041 | 2025-03 | Car | Cadillac | Red | Contravening a Red Traffic Light | No Insurance | Wylde Green Road | Wylde Green Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.546976 | -1.8098124 | ||
| 17285 | op-snap---monthly-publication-march-2025.pdf | 1042 | 2025-03 | Pedal Bike | Vauxhall | Zafira | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 17297 | op-snap---monthly-publication-march-2025.pdf | 1054 | 2025-03 | Car | Volkswagen | Tiguan | Black | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 17394 | op-snap---monthly-publication-march-2025.pdf | 1151 | 2025-03 | Pedestrian | Toyota | Yaris | Blue | Contravening a Red Traffic Light | None | Chester Road North | Chester Road North | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.548449 | -1.8594603 | |
| 17397 | op-snap---monthly-publication-march-2025.pdf | 1154 | 2025-03 | Pedestrian | Honda | Civic | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ashfurlong Crescent, | Ashfurlong Crescent | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5753987 | -1.8068712 | |
| 17398 | op-snap---monthly-publication-march-2025.pdf | 1155 | 2025-03 | Bus | Kia | Picanto | Red | Using a Mobile Phone Whilst Driving | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 17425 | op-snap---monthly-publication-march-2025.pdf | 1182 | 2025-03 | Car | Toyota | Cotolla | Silver | Stop a vehicle on pedestrian crossing | None | Victoria Road | Victoria Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5615573 | -1.820549 | |
| 17428 | op-snap---monthly-publication-march-2025.pdf | 1185 | 2025-03 | Car | Hyundai | I20 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 17430 | op-snap---monthly-publication-march-2025.pdf | 1187 | 2025-03 | Car | Peugeot | 207... | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 17432 | op-snap---monthly-publication-march-2025.pdf | 1189 | 2025-03 | Car | Ford | C MAX | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 17433 | op-snap---monthly-publication-march-2025.pdf | 1190 | 2025-03 | Car | Peugeot | EXPORT | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 17473 | op-snap---monthly-publication-march-2025.pdf | 1230 | 2025-03 | Pedestrian | BMW | X4 | White | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 17546 | op-snap---monthly-publication-march-2025.pdf | 1303 | 2025-03 | Car | Toyota | Yaris | Red | Driving without Due Care and Attention | None | Walmley Ash Road | Walmley Ash Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5376726 | -1.7973346 | |
| 17567 | op-snap---monthly-publication-march-2025.pdf | 1324 | 2025-03 | Pedestrian | Renault | Captur | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Whitehouse Common Road | Whitehouse Common Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.574907 | -1.8032902 | |
| 17586 | op-snap---monthly-publication-march-2025.pdf | 1343 | 2025-03 | Pedestrian | Dacia | Sandero | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 17589 | op-snap---monthly-publication-march-2025.pdf | 1346 | 2025-03 | Pedestrian | Toyota | Prius | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 17667 | op-snap---monthly-publication-march-2025.pdf | 1424 | 2025-03 | Pedestrian | Ford | Kuga | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street jn Upper Holland Road | Lower Queen Street jn Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | |||
| 17758 | op-snap---monthly-publication-march-2025.pdf | 1515 | 2025-03 | Car | Ford | Transit | Silver | Driving without Due Care and Attention | None | Wylde Green Road | Wylde Green Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | Yes - Via Email | 52.546976 | -1.8098124 | |
| 17760 | op-snap---monthly-publication-march-2025.pdf | 1517 | 2025-03 | Car | - | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | NFA | Misc Inc Crimes | Yes - Via Email | 52.5359496 | -1.8324115 | |||
| 17762 | op-snap---monthly-publication-march-2025.pdf | 1519 | 2025-03 | Car | BMW | 520 | Grey | Contravening a Red Traffic Light | None | Walmley Road at Fox Hollies Road | Walmley Road at Fox Hollies Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5405351 | -1.8002219 | |
| 17793 | op-snap---monthly-publication-march-2025.pdf | 1550 | 2025-03 | Car | Peugeot | 3008 | Red | Contravening a Red Traffic Light | None | Penns lane/ Walmley Road | Penns lane/ Walmley Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.538898 | -1.8004185 | |
| 17800 | op-snap---monthly-publication-march-2025.pdf | 1557 | 2025-03 | Pedestrian | Volkswagen | Golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 17801 | op-snap---monthly-publication-march-2025.pdf | 1558 | 2025-03 | Pedestrian | Mercedes-Benz | C200 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 17802 | op-snap---monthly-publication-march-2025.pdf | 1559 | 2025-03 | Pedestrian | Ford | Fiesta | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5361464 | -1.8270283 | |
| 17803 | op-snap---monthly-publication-march-2025.pdf | 1560 | 2025-03 | Pedestrian | Fiat | 500 | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5361464 | -1.8270283 | |
| 17805 | op-snap---monthly-publication-march-2025.pdf | 1562 | 2025-03 | Pedestrian | Ford | Fiesta | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5361464 | -1.8270283 | |
| 17807 | op-snap---monthly-publication-march-2025.pdf | 1564 | 2025-03 | Pedestrian | Citroen | C1 | White | Stop a vehicle within pelican pedestrian crossing limits | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5361464 | -1.8270283 | |
| 17809 | op-snap---monthly-publication-march-2025.pdf | 1566 | 2025-03 | Pedestrian | Audi | A6 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 17810 | op-snap---monthly-publication-march-2025.pdf | 1567 | 2025-03 | Pedestrian | Audi | Q2 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | NFA | No VRM | Yes - Via Email | 52.5959906 | -1.8345802 | |
| 17811 | op-snap---monthly-publication-march-2025.pdf | 1568 | 2025-03 | Pedestrian | Audi | Q4 | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5959906 | -1.8345802 | |
| 17812 | op-snap---monthly-publication-march-2025.pdf | 1569 | 2025-03 | Pedestrian | Mercedes-Benz | C class | White | Stop a vehicle within pelican pedestrian crossing limits | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5959906 | -1.8345802 | |
| 17814 | op-snap---monthly-publication-march-2025.pdf | 1571 | 2025-03 | Pedestrian | Mercedes-Benz | A-class | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5959906 | -1.8345802 | |
| 17847 | op-snap---monthly-publication-march-2025.pdf | 1604 | 2025-03 | Car | Ford | Mondeo | Red | Driving without Due Care and Attention | None | Eachelhurst Road | Eachelhurst Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5376965 | -1.80033 | |
| 17854 | op-snap---monthly-publication-march-2025.pdf | 1611 | 2025-03 | Pedal Bike | Volkswagen | Sharan | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 17863 | op-snap---monthly-publication-march-2025.pdf | 1620 | 2025-03 | Pedestrian | Tesla | model 3 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 17864 | op-snap---monthly-publication-march-2025.pdf | 1621 | 2025-03 | Pedestrian | Volkswagen | Polo | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 17869 | op-snap---monthly-publication-march-2025.pdf | 1626 | 2025-03 | Pedal Bike | Ford | Transit | White | Cause vehicle to be left in a dangerous position | None | Kings Road B4149 | Kings Road B4149 | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5496587 | -1.8665906 | |
| 17959 | op-snap---monthly-publication-march-2025.pdf | 1716 | 2025-03 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Russell Bank Road | Russell Bank Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5941017 | -1.8521585 | |
| 18057 | op-snap---monthly-publication-march-2025.pdf | 1814 | 2025-03 | Car | Toyota | Aygo | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 18067 | op-snap---monthly-publication-march-2025.pdf | 1824 | 2025-03 | Car | Nissan | Juke | Grey | Contravening a Red Traffic Light | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 18080 | op-snap---monthly-publication-march-2025.pdf | 1837 | 2025-03 | Pedestrian | Ford | C-Max | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5959906 | -1.8345802 | |
| 18099 | op-snap---monthly-publication-march-2025.pdf | 1856 | 2025-03 | Car | BMW | IX1 | Blue | Contravening a Red Traffic Light | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 18100 | op-snap---monthly-publication-march-2025.pdf | 1857 | 2025-03 | Car | Seat | Leon | Grey | Driving without Due Care and Attention | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Court | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 18163 | op-snap---monthly-publication-march-2025.pdf | 1920 | 2025-03 | Car | Ford | PUMA | Black | Driving without Due Care and Attention | None | CHESTER ROAD | Chester Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 18177 | op-snap---monthly-publication-march-2025.pdf | 1934 | 2025-03 | Car | Fiat | TIPO | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | UPPER HOLLAND ROAD | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 18244 | op-snap---monthly-publication-march-2025.pdf | 2001 | 2025-03 | Pedestrian | Ford | Ranger | Orange | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tower Road / Grange Road | Tower Road / Grange Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5897916 | -1.8249226 | |
| 18342 | op-snap---monthly-publication-march-2025.pdf | 2099 | 2025-03 | Pedestrian | Suzuki | SWIFT | RED | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | UPPER HOLLAND ROAD | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 18344 | op-snap---monthly-publication-march-2025.pdf | 2101 | 2025-03 | Pedestrian | Hyundai | I30 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | UPPER HOLLAND ROAD | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 18360 | op-snap---monthly-publication-march-2025.pdf | 2117 | 2025-03 | Pedestrian | Vauxhall | CROSSLAND | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | UPPER HOLLAND ROAD | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.561 | -1.8187105 | |
| 18380 | op-snap---monthly-publication-march-2025.pdf | 2137 | 2025-03 | Pedestrian | Tesla | Model Y | White | Stop a vehicle on pedestrian crossing | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5959906 | -1.8345802 | |
| 18388 | op-snap---monthly-publication-march-2025.pdf | 2145 | 2025-03 | Car | BMW | 420d | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 18407 | op-snap---monthly-publication-march-2025.pdf | 2164 | 2025-03 | Car | Land Rover | Defender | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Jockey Road | Jockey Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5535276 | -1.8302584 | |
| 18408 | op-snap---monthly-publication-march-2025.pdf | 2165 | 2025-03 | Car | Land Rover | Defender | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Jockey Road | Jockey Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5535276 | -1.8302584 | |
| 18410 | op-snap---monthly-publication-march-2025.pdf | 2167 | 2025-03 | Car | Seat | Leon | Black | Driving without Due Care and Attention | None | Thimble End Road | Thimble End Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5523209 | -1.7936899 | |
| 18446 | op-snap---monthly-publication-march-2025.pdf | 2203 | 2025-03 | Pedal Bike | Hyundai | Tucson | Brown | Driving without Due Care and Attention | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 18575 | op-snap---monthly-publication-march-2025.pdf | 2332 | 2025-03 | Car | Mercedes-Benz | Sprinter | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | NFA | No VRM | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 18596 | op-snap---monthly-publication-march-2025.pdf | 2353 | 2025-03 | Car | HGV | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Victoria Road | Victoria Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | Yes - Via Email | 52.5615573 | -1.820549 | ||
| 18597 | op-snap---monthly-publication-march-2025.pdf | 2354 | 2025-03 | Car | Mercedes-Benz | GLA 250 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 18598 | op-snap---monthly-publication-march-2025.pdf | 2355 | 2025-03 | Car | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 18600 | op-snap---monthly-publication-march-2025.pdf | 2357 | 2025-03 | Car | Volkswagen | Taigo | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5603978 | -1.8227403 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);