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'}
72 rows where council_area = "Sutton Coldfield" and month = "2025-02" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale, latitude, longitude
vehicle_make 24
- Ford 10
- Mercedes-Benz 9
- BMW 8
- Audi 5
- Volkswagen 5
- Vauxhall 4
- Land Rover 3
- Peugeot 3
- Toyota 3
- Citroen 2
- Honda 2
- Mini 2
- Porsche 2
- Skoda 2
- Alfa Romeo 1
- Chevrolet 1
- Dacia 1
- Hyundai 1
- Jaguar 1
- Kia 1
- Mitsubishi 1
- Seat 1
- Suzuki 1
- Volvo 1
offence 14
- Using a Mobile Phone Whilst Driving 20
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 8
- Stop a vehicle within pelican pedestrian crossing limits 8
- Contravening a Red Traffic Light 6
- Driving without Due Care and Attention 6
- Misc - Non Traffic Offences 6
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 5
- Cause vehicle to be left in a dangerous position 4
- Driving without Reasonable Consideration 4
- Drive / Ride / Lead an animal on a footpath 1
- Drive a vehicle on common land 1
- Fail to display front VRM plate 1
- VRM fails to conform to Regulations 1
- Waiting on a road in a prohibited area 1
disposal 5
- Fixed Penalty 37
- Warning Letter 19
- NFA 9
- Education 6
- Court 1
reporter_transport_mode 4
- Pedestrian 41
- Car 25
- Pedal Bike 5
- Other 1
month 1
- 2025-02 · 72 ✖
council_area 1
- Sutton Coldfield · 72 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5259 | op-snap---monthly-publication-february-2025.pdf | 76 | 2025-02 | Pedestrian | BMW | X5 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5361464 | -1.8270283 | |
| 5340 | op-snap---monthly-publication-february-2025.pdf | 157 | 2025-02 | Pedal Bike | Ford | Transit | White | Driving without Reasonable Consideration | VRM fails to conform to Regulations | Park Road | Park Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5648824 | -1.8293486 | |
| 5343 | op-snap---monthly-publication-february-2025.pdf | 160 | 2025-02 | Car | Volkswagen | Crafter | White | Contravening a Red Traffic Light | None | Digby Road | Digby Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5573003 | -1.8317101 | |
| 5446 | op-snap---monthly-publication-february-2025.pdf | 263 | 2025-02 | Car | Scania | White | Driving without Due Care and Attention | None | Jockey Road | Jockey Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | Yes - Via Email | 52.5535276 | -1.8302584 | ||
| 5468 | op-snap---monthly-publication-february-2025.pdf | 285 | 2025-02 | Car | Suzuki | BALENO | White | Driving without Due Care and Attention | None | A38 | A38 | Sutton Coldfield | Sutton Coldfield | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 5469 | op-snap---monthly-publication-february-2025.pdf | 286 | 2025-02 | Car | Citroen | C3 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | A5127 HIGH STREET | A5127 High Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | |||
| 5474 | op-snap---monthly-publication-february-2025.pdf | 291 | 2025-02 | Car | Toyota | Auris | Blue | Contravening a Red Traffic Light | None | Eachlehurst Road | Eachlehurst Road | Sutton Coldfield | Sutton Coldfield | NFA | No VRM | Yes - Via Email | |||
| 5515 | op-snap---monthly-publication-february-2025.pdf | 332 | 2025-02 | Pedestrian | Honda | CR-V | Grey | Using a Mobile Phone Whilst Driving | None | Upper Clifton Road | Upper Clifton Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5664481 | -1.8270564 | |
| 5527 | op-snap---monthly-publication-february-2025.pdf | 344 | 2025-02 | Pedestrian | Ford | Focus | Blue | Cause vehicle to be left in a dangerous position | None | Birmingham Road, Sutton Coldfield | Birmingham Road, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5432869 | -1.8249079 | |
| 5549 | op-snap---monthly-publication-february-2025.pdf | 366 | 2025-02 | Car | Volvo | XC40 | Black | Misc - Non Traffic Offences | Littering | CARROWAY HEAD | Carroway Head | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | |||
| 5614 | op-snap---monthly-publication-february-2025.pdf | 431 | 2025-02 | Car | Audi | Q4 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Brooks Road | Brooks Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5427104 | -1.8202297 | |
| 5622 | op-snap---monthly-publication-february-2025.pdf | 439 | 2025-02 | Pedestrian | BMW | X4 | Black | VRM fails to conform to Regulations | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 5623 | op-snap---monthly-publication-february-2025.pdf | 440 | 2025-02 | Pedestrian | Ford | Fiesta | Silver | Using a Mobile Phone Whilst Driving | None | Clifton Road | Clifton Road | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 5660 | op-snap---monthly-publication-february-2025.pdf | 477 | 2025-02 | Car | Porsche | Taycan | Black | Contravening a Red Traffic Light | No vehicle excise licence | Chester Rd, Boldmere | Chester Road, Boldmere | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 5661 | op-snap---monthly-publication-february-2025.pdf | 478 | 2025-02 | Car | Ford | focus | Red | 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 | |
| 5662 | op-snap---monthly-publication-february-2025.pdf | 479 | 2025-02 | Car | Peugeot | 5008 | 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 | |
| 5845 | op-snap---monthly-publication-february-2025.pdf | 662 | 2025-02 | Pedestrian | Land Rover | Evoque | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Jockey Rd | Jockey Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5535276 | -1.8302584 | |
| 5846 | op-snap---monthly-publication-february-2025.pdf | 663 | 2025-02 | Car | Mercedes-Benz | B200 | Silver | Contravening a Red Traffic Light | None | Minworth Island A38 and A4097 | Minworth Island A38 and A4097 | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5316279 | -1.7762358 | |
| 5871 | op-snap---monthly-publication-february-2025.pdf | 688 | 2025-02 | Pedestrian | BMW | 120d | White | Using a Mobile Phone Whilst Driving | None | Clifton Road | Clifton Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 5872 | op-snap---monthly-publication-february-2025.pdf | 689 | 2025-02 | Pedestrian | Audi | A6 | White | Using a Mobile Phone Whilst Driving | None | Clifton Road | Clifton Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 5875 | op-snap---monthly-publication-february-2025.pdf | 692 | 2025-02 | Pedestrian | Volkswagen | Golf | Grey | Using a Mobile Phone Whilst Driving | None | Clifton Road | Clifton Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 5877 | op-snap---monthly-publication-february-2025.pdf | 694 | 2025-02 | Pedestrian | Vauxhall | AstrA | Red | Using a Mobile Phone Whilst Driving | None | Clifton Road | Clifton Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 5879 | op-snap---monthly-publication-february-2025.pdf | 696 | 2025-02 | Pedestrian | Toyota | Auris | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Birmingham Road near Jockey Road | Birmingham Road near Jockey Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.553171 | -1.8275916 | |
| 5960 | op-snap---monthly-publication-february-2025.pdf | 777 | 2025-02 | Car | Jaguar | X-type | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Victoria Road, Sutton Coldfield | Victoria Road, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5615573 | -1.820549 | |
| 5962 | op-snap---monthly-publication-february-2025.pdf | 779 | 2025-02 | Car | Mercedes-Benz | van | White | 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 | NFA | No VRM | Yes - Via Email | 52.5596343 | -1.8225298 | |
| 6071 | op-snap---monthly-publication-february-2025.pdf | 888 | 2025-02 | Pedestrian | Honda | Moped | Orange | Drive a vehicle on common land | None | Sutton Park | Sutton Park | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5637101 | -1.822451 | |
| 6121 | op-snap---monthly-publication-february-2025.pdf | 938 | 2025-02 | Pedal Bike | BMW | 320d | Black | Driving without Reasonable Consideration | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 6122 | op-snap---monthly-publication-february-2025.pdf | 939 | 2025-02 | Pedal Bike | Mercedes-Benz | GLC 220 | White | Driving without Reasonable Consideration | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 6187 | op-snap---monthly-publication-february-2025.pdf | 1004 | 2025-02 | Pedestrian | Land Rover | Black | Waiting on a road in a prohibited area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | ||
| 6205 | op-snap---monthly-publication-february-2025.pdf | 1022 | 2025-02 | Pedestrian | Porsche | Macan | Black | 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 | |
| 6214 | op-snap---monthly-publication-february-2025.pdf | 1031 | 2025-02 | Pedal Bike | BMW | 330E | Blue | Driving without Reasonable Consideration | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 6228 | op-snap---monthly-publication-february-2025.pdf | 1045 | 2025-02 | Pedestrian | Mercedes-Benz | E-class | Blue | Using a Mobile Phone Whilst Driving | None | Clifton Road, Sutton Coldfield | Clifton Road, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | Yes - Via Email | 52.5636072 | -1.8297629 | |
| 6229 | op-snap---monthly-publication-february-2025.pdf | 1046 | 2025-02 | Pedestrian | Skoda | Roomster | Red | Using a Mobile Phone Whilst Driving | None | Clifton Road, Sutton Coldfield | Clifton Road, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5636072 | -1.8297629 | |
| 6231 | op-snap---monthly-publication-february-2025.pdf | 1048 | 2025-02 | Pedestrian | Mini | COOPER | Silver | Using a Mobile Phone Whilst Driving | None | DIGBY ROAD | Digby Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5573003 | -1.8317101 | |
| 6232 | op-snap---monthly-publication-february-2025.pdf | 1049 | 2025-02 | Pedestrian | Vauxhall | CORSA | Black | Using a Mobile Phone Whilst Driving | None | CLIFTON ROAD | Clifton Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 6233 | op-snap---monthly-publication-february-2025.pdf | 1050 | 2025-02 | Pedestrian | Ford | KUGA | Black | Using a Mobile Phone Whilst Driving | None | CLIFTON ROAD | Clifton Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 6235 | op-snap---monthly-publication-february-2025.pdf | 1052 | 2025-02 | Pedestrian | Skoda | OCTAVIA | Blue | Using a Mobile Phone Whilst Driving | None | CLIFTON ROAD | Clifton Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 6327 | op-snap---monthly-publication-february-2025.pdf | 1144 | 2025-02 | Pedestrian | Mini | COOPER | Black | Using a Mobile Phone Whilst Driving | None | CLIFTON ROAD | Clifton Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 6329 | op-snap---monthly-publication-february-2025.pdf | 1146 | 2025-02 | Pedestrian | BMW | 3 SERIES | Silver | Using a Mobile Phone Whilst Driving | None | C LIFTON ROAD | C Lifton Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | |||
| 6341 | op-snap---monthly-publication-february-2025.pdf | 1158 | 2025-02 | Car | Chevrolet | cruze | Blue | Drive / Ride / Lead an animal on a footpath | None | WYLDE GREEN ROAD | Wylde Green Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.546976 | -1.8098124 | |
| 6346 | op-snap---monthly-publication-february-2025.pdf | 1163 | 2025-02 | Pedestrian | Seat | Leon | Red | Cause vehicle to be left in a dangerous position | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5361464 | -1.8270283 | |
| 6368 | op-snap---monthly-publication-february-2025.pdf | 1185 | 2025-02 | Pedestrian | Mercedes-Benz | A200 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | While Road | While Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5577767 | -1.825114 | |
| 6371 | op-snap---monthly-publication-february-2025.pdf | 1188 | 2025-02 | Car | Mitsubishi | AURIS | Silver | 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 | |
| 6391 | op-snap---monthly-publication-february-2025.pdf | 1208 | 2025-02 | Pedestrian | Kia | SORRENTO | Grey | Using a Mobile Phone Whilst Driving | None | CLIFTON ROAD | Clifton Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 6393 | op-snap---monthly-publication-february-2025.pdf | 1210 | 2025-02 | Pedestrian | Citroen | PURE | Grey | Using a Mobile Phone Whilst Driving | None | CLIFTON ROAD | Clifton Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 6394 | op-snap---monthly-publication-february-2025.pdf | 1211 | 2025-02 | Pedestrian | Ford | FIESTA | Silver | Using a Mobile Phone Whilst Driving | None | CLIFTON ROAD | Clifton Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5609895 | -1.8319819 | |
| 6397 | op-snap---monthly-publication-february-2025.pdf | 1214 | 2025-02 | Car | Ford | C-Max | Silver | Contravening a Red Traffic Light | None | Boldmere Road, jn Jockey Road | Boldmere Road, jn Jockey Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | |||
| 6425 | op-snap---monthly-publication-february-2025.pdf | 1242 | 2025-02 | Pedestrian | Mercedes-Benz | GLE | White | Using a Mobile Phone Whilst Driving | None | Boldmere Road | Boldmere Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.548309 | -1.8411769 | |
| 6426 | op-snap---monthly-publication-february-2025.pdf | 1243 | 2025-02 | Pedestrian | Ford | GT | Red | Fail to display front VRM plate | None | Boldmere Road | Boldmere Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.548309 | -1.8411769 | |
| 6428 | op-snap---monthly-publication-february-2025.pdf | 1245 | 2025-02 | Pedestrian | Audi | Q5 | Blue | Misc - Non Traffic Offences | None | Jockey lane | Jockey lane | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | Yes - Via Email | |||
| 6464 | op-snap---monthly-publication-february-2025.pdf | 1281 | 2025-02 | Pedal Bike | Mercedes-Benz | Benz | White | Driving without Due Care and Attention | None | Birmingham Road Sutton Coldfield | Birmingham Road Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Court | N/A | Yes - Via Email | 52.5425506 | -1.7961226 | |
| 6590 | op-snap---monthly-publication-february-2025.pdf | 1407 | 2025-02 | Pedestrian | Volkswagen | Touran | White | Using a Mobile Phone Whilst Driving | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5361464 | -1.8270283 | |
| 6628 | op-snap---monthly-publication-february-2025.pdf | 1445 | 2025-02 | Pedestrian | Volkswagen | Golf | Silver | Misc - Non Traffic Offences | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 6629 | op-snap---monthly-publication-february-2025.pdf | 1446 | 2025-02 | Pedestrian | Toyota | Corolla | Black | Misc - Non Traffic Offences | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 6752 | op-snap---monthly-publication-february-2025.pdf | 1569 | 2025-02 | Car | Volkswagen | Touran | Beige | Stop a vehicle within pelican pedestrian crossing limits | None | Victoria Street Sutton Coldfield | Victoria Street Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5586132 | -1.8260076 | |
| 6753 | op-snap---monthly-publication-february-2025.pdf | 1570 | 2025-02 | Car | Land Rover | Sport | Blue | 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.5611883 | -1.8211471 | |
| 6769 | op-snap---monthly-publication-february-2025.pdf | 1586 | 2025-02 | Pedestrian | Dacia | Sandero | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mere Road Sutton Coldfield | Mere Road Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5874888 | -1.8297106 | |
| 6774 | op-snap---monthly-publication-february-2025.pdf | 1591 | 2025-02 | Pedestrian | Audi | A5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mere Green Road Sutton Coldfield | Mere Green Road Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5874888 | -1.8297106 | |
| 6873 | op-snap---monthly-publication-february-2025.pdf | 1690 | 2025-02 | Car | Peugeot | 408 | Grey | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5311069 | -1.7539854 | |
| 6878 | op-snap---monthly-publication-february-2025.pdf | 1695 | 2025-02 | Car | Hyundai | Kona | Black | Contravening a Red Traffic Light | None | Coleshill Road | Coleshill Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5613155 | -1.8139826 | |
| 6879 | op-snap---monthly-publication-february-2025.pdf | 1696 | 2025-02 | Car | Audi | TT | BLue | Driving without Due Care and Attention | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 6962 | op-snap---monthly-publication-february-2025.pdf | 1779 | 2025-02 | Car | Ford | Fiesta | Blue | 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 | |
| 6966 | op-snap---monthly-publication-february-2025.pdf | 1783 | 2025-02 | Pedestrian | Vauxhall | Insignia | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Jockey Road, Sutton Coldfield | Jockey Road, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5535276 | -1.8302584 | |
| 6968 | op-snap---monthly-publication-february-2025.pdf | 1785 | 2025-02 | Car | Ford | Transit | Silver | Driving without Due Care and Attention | None | Kingsbury Road, Sutton Coldfield | Kingsbury Road, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5311069 | -1.7539854 | |
| 7004 | op-snap---monthly-publication-february-2025.pdf | 1821 | 2025-02 | Pedestrian | BMW | X3 | White | Cause vehicle to be left in a dangerous position | None | Berwood Road | Berwood Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5342947 | -1.8155375 | |
| 7007 | op-snap---monthly-publication-february-2025.pdf | 1824 | 2025-02 | Pedestrian | Mercedes-Benz | C220 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5342947 | -1.8155375 | |
| 7152 | op-snap---monthly-publication-february-2025.pdf | 1969 | 2025-02 | Pedestrian | Peugeot | 308 | White | Cause vehicle to be left in a dangerous position | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 7166 | op-snap---monthly-publication-february-2025.pdf | 1983 | 2025-02 | Pedestrian | Mercedes-Benz | Sprinter | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Honeybourne Road | Honeybourne Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.5737319 | -1.8116726 | |
| 7173 | op-snap---monthly-publication-february-2025.pdf | 1990 | 2025-02 | Car | Alfa Romeo | Red | Using a Mobile Phone Whilst Driving | None | Clifton Road Sutton Coldfield | Clifton Road Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | NFA | No VRM | Yes - Via Email | 52.5636072 | -1.8297629 | ||
| 7199 | op-snap---monthly-publication-february-2025.pdf | 2016 | 2025-02 | Car | BMW | X5 | Black | Misc - Non Traffic Offences | None | Rockingham Gardens Sutton | Rockingham Gardens Sutton | Sutton Coldfield | Sutton Coldfield | NFA | Misc Inc Crimes | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 7219 | op-snap---monthly-publication-february-2025.pdf | 2036 | 2025-02 | Pedestrian | Vauxhall | Vivaro | White | Stop a vehicle within pelican pedestrian crossing limits | None | Mere Green Road | Mere Green Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | Yes - Via Email | 52.5874888 | -1.8297106 | |
| 7228 | op-snap---monthly-publication-february-2025.pdf | 2045 | 2025-02 | Other | Misc - Non Traffic Offences | None | Rushmoor Close | Rushmoor Close | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | Yes - Via Email | 52.5694106 | -1.8262786 |
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);