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'}
170 rows where council_area = "Walsall" and disposal = "Fixed Penalty" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw
vehicle_make 29
offence 21
- Contravening a Red Traffic Light 75
- Driving without Due Care and Attention 29
- Using a Mobile Phone Whilst Driving 29
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 7
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 7
- Cause vehicle to be left in a dangerous position 3
- Stop a vehicle on pedestrian crossing 3
- Prohibited vehicle in offside lane of motorway 2
- Stop a vehicle within pelican pedestrian crossing limits 2
- VRM fails to conform to Regulations 2
- Contravene Lane Closure Red X 1
- Drive on hard shoulder 1
- Driving a vehicle wholly or partly on a footpath 1
- Driving without Reasonable Consideration 1
- Fail to display front VRM plate 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- No Insurance 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
- Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 1
- Use vehicle on a road without valid test certificate 1
- Vehicle overtake within crossing limits 1
month 14
reporter_transport_mode 5
- Car 83
- Pedestrian 67
- Pedal Bike 16
- Lorry 3
- Bus 1
disposal 1
- Fixed Penalty · 170 ✖
council_area 1
- Walsall · 170 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7328 | op-snap---monthly-publication-february-2026.pdf | 75 | 2026-02 | Bus | Kia | Niro | Red | Using a Mobile Phone Whilst Driving | None | Lichfield Street | Lichfield Street | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5882772 | -1.9761264 | ||
| 7814 | op-snap---monthly-publication-february-2026.pdf | 561 | 2026-02 | Car | Volvo | C30 | White | No Insurance | None | The Parade, Brownhills | The Parade, Brownhills | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.6529719 | -1.9369793 | ||
| 10873 | op-snap---monthly-publication-january-2026.pdf | 334 | 2026-01 | Car | Volvo | Truck | White | Prohibited vehicle in offside lane of motorway | None | M6 | M6 | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | ||||
| 11175 | op-snap---monthly-publication-january-2026.pdf | 636 | 2026-01 | Pedestrian | Honda | Jazz | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bradford Place Walsall | Bradford Place Walsall | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5831708 | -1.9837299 | ||
| 11176 | op-snap---monthly-publication-january-2026.pdf | 637 | 2026-01 | Pedestrian | Land Rover | Discovery | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bradford Place Walsall | Bradford Place Walsall | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5831708 | -1.9837299 | ||
| 11177 | op-snap---monthly-publication-january-2026.pdf | 638 | 2026-01 | Pedestrian | Hyundai | I10.. | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bradford Place Walsall | Bradford Place Walsall | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5831708 | -1.9837299 | ||
| 11178 | op-snap---monthly-publication-january-2026.pdf | 639 | 2026-01 | Pedestrian | Fiat | 500.. | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bradford Place Walsall | Bradford Place Walsall | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5831708 | -1.9837299 | ||
| 11772 | op-snap---monthly-publication-january-2026.pdf | 1233 | 2026-01 | Car | BMW | 420 D | Black | VRM fails to conform to Regulations | None | Wallows Lane | Wallows Lane | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5699435 | -2.0008354 | ||
| 11773 | op-snap---monthly-publication-january-2026.pdf | 1234 | 2026-01 | Car | Audi | A3 | Grey | VRM fails to conform to Regulations | None | Wallows Lane | Wallows Lane | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5699435 | -2.0008354 | ||
| 11779 | op-snap---monthly-publication-january-2026.pdf | 1240 | 2026-01 | Pedestrian | Hyundai | I10 | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bradford Street | Bradford Street | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5831181 | -1.9834255 | ||
| 11780 | op-snap---monthly-publication-january-2026.pdf | 1241 | 2026-01 | Pedestrian | Mercedes-Benz | GLC | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bradford Street | Bradford Street | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5831181 | -1.9834255 | ||
| 4025 | op-snap---monthly-publication-december-2025.pdf | 153 | 2025-12 | Car | Hyundai | Amica | black | Using a Mobile Phone Whilst Driving | None | M6 Junction 9 | M6 Junction 9 | Walsall | Walsall | Fixed Penalty | N/A | 52.676119 | -2.0858425 | ||
| 4269 | op-snap---monthly-publication-december-2025.pdf | 397 | 2025-12 | Car | Toyota | Avensis | Silver | Driving without Due Care and Attention | None | Lichfield Road | Lichfield Road | Walsall | Walsall | Fixed Penalty | N/A | 52.6095168 | -2.0493009 | ||
| 4677 | op-snap---monthly-publication-december-2025.pdf | 805 | 2025-12 | Car | Kia | Ceed | Black | Using a Mobile Phone Whilst Driving | None | M6 | M6 | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 5168 | op-snap---monthly-publication-december-2025.pdf | 1296 | 2025-12 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | Leamore | Leamore | Walsall | Walsall | Fixed Penalty | N/A | 52.6017244 | -2.0081529 | ||
| 20746 | op-snap---monthly-publication-november-2025.pdf | 288 | 2025-11 | Car | Peugeot | 308.. | Blue | Driving without Due Care and Attention | None | Broadway North | Broadway North | Walsall | Walsall | Fixed Penalty | N/A | 52.5886007 | -1.9741222 | ||
| 20858 | op-snap---monthly-publication-november-2025.pdf | 400 | 2025-11 | Car | Seat | LEON | White | Fail to display front VRM plate | None | Brockenhurst Crecent | Brockenhurst Crecent | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 21547 | op-snap---monthly-publication-november-2025.pdf | 1089 | 2025-11 | Car | Toyota | Yaris | Silver | Using a Mobile Phone Whilst Driving | None | Broadway | Broadway | Walsall | Walsall | Fixed Penalty | N/A | 52.5719937 | -1.9639882 | ||
| 21573 | op-snap---monthly-publication-november-2025.pdf | 1115 | 2025-11 | Car | Vauxhall | Astra | Brown | Driving without Due Care and Attention | None | M6 Jct 8 | M6 Junction 8 | Walsall | Walsall | Fixed Penalty | N/A | 52.6760749 | -2.0862582 | ||
| 21681 | op-snap---monthly-publication-november-2025.pdf | 1223 | 2025-11 | Lorry | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | M6 Jn 8 | M6 Junction 8 | Walsall | Walsall | Fixed Penalty | N/A | 52.6760749 | -2.0862582 | ||
| 22181 | op-snap---monthly-publication-october-2025.pdf | 131 | 2025-10 | Car | Volkswagen | Golf | Grey | Cause vehicle to be left in a dangerous position | None | Hobbs Road | Hobbs Road | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 22238 | op-snap---monthly-publication-october-2025.pdf | 188 | 2025-10 | Car | Audi | A1 | Black | Contravening a Red Traffic Light | None | Stafford Street | Stafford Street | Walsall | Walsall | Fixed Penalty | N/A | 52.5899955 | -1.9853333 | ||
| 23025 | op-snap---monthly-publication-october-2025.pdf | 975 | 2025-10 | Car | Audi | Q3 | White | Contravening a Red Traffic Light | None | Broadway North | Broadway North | Walsall | Walsall | Fixed Penalty | N/A | 52.5886007 | -1.9741222 | ||
| 23882 | op-snap---monthly-publication-september-2025.pdf | 101 | 2025-09 | Car | Scania | HGV | White | Prohibited vehicle in offside lane of motorway | None | M6 Motorway approaching Junction 9 | M6 Motorway approaching Junction 9 | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 24056 | op-snap---monthly-publication-september-2025.pdf | 275 | 2025-09 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Lime Lane, Pelsall | Lime Lane, Pelsall | Walsall | Walsall | Fixed Penalty | N/A | 52.6394826 | -1.9681327 | ||
| 24113 | op-snap---monthly-publication-september-2025.pdf | 332 | 2025-09 | Car | Toyota | Prius | White | Contravening a Red Traffic Light | None | Lichfield Road | Lichfield Road | Walsall | Walsall | Fixed Penalty | N/A | 52.6095168 | -2.0493009 | ||
| 24116 | op-snap---monthly-publication-september-2025.pdf | 335 | 2025-09 | Car | Volkswagen | Passat | Silver | Contravening a Red Traffic Light | None | Lichfield Road, jn Hawley Close | Lichfield Road, jn Hawley Close | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 24132 | op-snap---monthly-publication-september-2025.pdf | 351 | 2025-09 | Car | Audi | A4.. | White | Using a Mobile Phone Whilst Driving | None | Chester Road Brownhills | Chester Road Brownhills | Walsall | Walsall | Fixed Penalty | N/A | 52.6298869 | -1.9079971 | ||
| 24492 | op-snap---monthly-publication-september-2025.pdf | 711 | 2025-09 | Car | Hyundai | I30 | Black | Contravening a Red Traffic Light | None | Bescot Road | Bescot Road | Walsall | Walsall | Fixed Penalty | N/A | 52.5707373 | -2.0014215 | ||
| 24626 | op-snap---monthly-publication-september-2025.pdf | 845 | 2025-09 | Lorry | Mercedes-Benz | A class | Grey | Contravening a Red Traffic Light | None | Black Country Route at M6 Jn10 | Black Country Route at M6 Jn10 | Walsall | Walsall | Fixed Penalty | N/A | 52.5736488 | -2.0492151 | ||
| 24705 | op-snap---monthly-publication-september-2025.pdf | 924 | 2025-09 | Car | Mercedes-Benz | Vito | White | Driving without Due Care and Attention | None | A34 Stafford Road | Stafford Road | Walsall | Walsall | Fixed Penalty | N/A | 52.6308664 | -2.0061816 | ||
| 24842 | op-snap---monthly-publication-september-2025.pdf | 1061 | 2025-09 | Car | Seat | Arona | Grey | Driving without Due Care and Attention | None | m6 jnuction 9 | M6 Jnuction 9 | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 2144 | op-snap---monthly-publication-august-2025.pdf | 119 | 2025-08 | Lorry | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | M6 North | M6 North | Walsall | Walsall | Fixed Penalty | N/A | 52.5859649 | -1.9897914 | ||
| 2146 | op-snap---monthly-publication-august-2025.pdf | 121 | 2025-08 | Pedestrian | Volkswagen | Tiguan | Grey | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Walsall | Walsall | Fixed Penalty | N/A | 52.5723244 | -1.9607214 | ||
| 2331 | op-snap---monthly-publication-august-2025.pdf | 306 | 2025-08 | Car | Nissan | Micra | Black | Using a Mobile Phone Whilst Driving | None | A4148 | A4148 | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 2421 | op-snap---monthly-publication-august-2025.pdf | 396 | 2025-08 | Car | Mercedes-Benz | C220. | White | Vehicle overtake within crossing limits | None | A41 Moxley | Moxley | Walsall | Walsall | Fixed Penalty | N/A | 52.5573644 | -2.0465687 | ||
| 2598 | op-snap---monthly-publication-august-2025.pdf | 573 | 2025-08 | Car | Toyota | Corolla | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Proffitt Street | Proffitt Street | Walsall | Walsall | Fixed Penalty | N/A | 52.5939862 | -1.9849197 | ||
| 2843 | op-snap---monthly-publication-august-2025.pdf | 818 | 2025-08 | Car | Ford | Cmax | Blue | Contravening a Red Traffic Light | Use vehicle on a road without valid test ce | rBtiirfmicaintegham Road A34 | r Btiirfmicaintegham Road A34 | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 2976 | op-snap---monthly-publication-august-2025.pdf | 951 | 2025-08 | Car | Mercedes-Benz | A class | Black | Using a Mobile Phone Whilst Driving | None | Cherry Tree Avenue | Cherry Tree Avenue | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 12249 | op-snap---monthly-publication-july-2025.pdf | 301 | 2025-07 | Car | Vauxhall | Insignia | Black | Using a Mobile Phone Whilst Driving | None | Walsall Road/ Stone cross | Walsall Road/ Stone cross | Walsall | Walsall | Fixed Penalty | N/A | 52.5417047 | -1.984378 | ||
| 12356 | op-snap---monthly-publication-july-2025.pdf | 408 | 2025-07 | Pedal Bike | BMW | 3 series | White | Driving without Reasonable Consideration | No Insurance | Butts Road | Butts Road | Walsall | Walsall | Fixed Penalty | N/A | 52.592263 | -1.9743536 | ||
| 12959 | op-snap---monthly-publication-july-2025.pdf | 1011 | 2025-07 | Car | Peugeot | 207 | Silver | Using a Mobile Phone Whilst Driving | None | Red House Lane , | Red House Lane | Walsall | Walsall | Fixed Penalty | N/A | 52.5995075 | -1.9332763 | ||
| 14079 | op-snap---monthly-publication-june-2025.pdf | 8 | 2025-06 | Car | Audi | A3 | Black | Contravening a Red Traffic Light | None | Broadway | Broadway | Walsall | Walsall | Fixed Penalty | N/A | 52.5719937 | -1.9639882 | ||
| 14162 | op-snap---monthly-publication-june-2025.pdf | 91 | 2025-06 | Car | Toyota | Corolla | White | Using a Mobile Phone Whilst Driving | None | Newtoen Road | Newtoen Road | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 14695 | op-snap---monthly-publication-june-2025.pdf | 624 | 2025-06 | Car | Volvo | S90... | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fallwofield Road | Fallwofield Road | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 15040 | op-snap---monthly-publication-june-2025.pdf | 969 | 2025-06 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Melish Road | Melish Road | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 15846 | op-snap---monthly-publication-june-2025.pdf | 1775 | 2025-06 | Pedestrian | Audi | A1... | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Eagleworks Drive | Eagleworks Drive | Walsall | Walsall | Fixed Penalty | N/A | 52.603908 | -1.9880181 | ||
| 18673 | op-snap---monthly-publication-may-2025.pdf | 35 | 2025-05 | Car | Ford | Focus | Black | Using a Mobile Phone Whilst Driving | None | Field Road | Field Road | Walsall | Walsall | Fixed Penalty | N/A | 52.6185043 | -1.9962803 | ||
| 18705 | op-snap---monthly-publication-may-2025.pdf | 67 | 2025-05 | Car | Vauxhall | Corsa | Black | Using a Mobile Phone Whilst Driving | None | Lord Street Walsall | Lord Street Walsall | Walsall | Walsall | Fixed Penalty | N/A | 52.5700579 | -1.9889188 | ||
| 18768 | op-snap---monthly-publication-may-2025.pdf | 130 | 2025-05 | Car | Renault | TRAFIC | Silver | Driving without Due Care and Attention | None | WATLING STREET A5 | Watling Street A5 | Walsall | Walsall | Fixed Penalty | N/A | 52.6562907 | -1.9111505 | ||
| 18893 | op-snap---monthly-publication-may-2025.pdf | 255 | 2025-05 | Car | Volkswagen | Golf | Silver | Using a Mobile Phone Whilst Driving | None | A34 Walsall Road | Walsall Road | Walsall | Walsall | Fixed Penalty | N/A | 52.6166864 | -1.9660822 | ||
| 19071 | op-snap---monthly-publication-may-2025.pdf | 433 | 2025-05 | Car | BMW | M4 | Grey | Using a Mobile Phone Whilst Driving | NONE | M6 JUNCTION 9 | M6 Junction 9 | Walsall | Walsall | Fixed Penalty | N/A | 52.676119 | -2.0858425 | ||
| 19247 | op-snap---monthly-publication-may-2025.pdf | 609 | 2025-05 | Car | BMW | 3 series | White | Using a Mobile Phone Whilst Driving | None | Wilkin Road, Brownhills | Wilkin Road, Brownhills | Walsall | Walsall | Fixed Penalty | N/A | 52.6580428 | -1.9502105 | ||
| 19828 | op-snap---monthly-publication-may-2025.pdf | 1190 | 2025-05 | Car | Honda | Jazz | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodwards Road | Woodwards Road | Walsall | Walsall | Fixed Penalty | N/A | 52.5783717 | -2.0074744 | ||
| 20031 | op-snap---monthly-publication-may-2025.pdf | 1393 | 2025-05 | Pedal Bike | BMW | NP | Black | Using a Mobile Phone Whilst Driving | None | Daw end lane | Daw end lane | Walsall | Walsall | Fixed Penalty | N/A | 52.6068849 | -1.9611652 | ||
| 20032 | op-snap---monthly-publication-may-2025.pdf | 1394 | 2025-05 | Pedal Bike | Ford | NP | Grey | Using a Mobile Phone Whilst Driving | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | 52.6068849 | -1.9611652 | ||
| 131 | op-snap---monthly-publication-april-2025.pdf | 130 | 2025-04 | Car | Peugeot | 3008.. | Red | Contravening a Red Traffic Light | None | Walstead Road | Walstead Road | Walsall | Walsall | Fixed Penalty | N/A | 52.5648629 | -1.9517624 | ||
| 173 | op-snap---monthly-publication-april-2025.pdf | 172 | 2025-04 | Car | Mercedes-Benz | A CLASS | White | Contravening a Red Traffic Light | None | BENTLEY MILL WAY | Bentley Mill Way | Walsall | Walsall | Fixed Penalty | N/A | 52.5786876 | -2.0165115 | ||
| 175 | op-snap---monthly-publication-april-2025.pdf | 174 | 2025-04 | Car | BMW | 320i | White | Contravening a Red Traffic Light | None | TOWNEND STREET | Townend Street | Walsall | Walsall | Fixed Penalty | N/A | 52.5863213 | -1.9852108 | ||
| 351 | op-snap---monthly-publication-april-2025.pdf | 350 | 2025-04 | Pedestrian | Yamaha | Taxi | Black | Using a Mobile Phone Whilst Driving | None | Lichfield Street | Lichfield Street | Walsall | Walsall | Fixed Penalty | N/A | 52.5882772 | -1.9761264 | ||
| 728 | op-snap---monthly-publication-april-2025.pdf | 727 | 2025-04 | Car | Audi | A3 | White | Contravene Lane Closure Red X | None | Townend Street | Townend Street | Walsall | Walsall | Fixed Penalty | N/A | 52.5863213 | -1.9852108 | ||
| 730 | op-snap---monthly-publication-april-2025.pdf | 729 | 2025-04 | Car | Skoda | Fabia | Green | Cause vehicle to be left in a dangerous position | None | Croft Street | Croft Street | Walsall | Walsall | Fixed Penalty | N/A | 52.5929393 | -1.9884291 | ||
| 763 | op-snap---monthly-publication-april-2025.pdf | 762 | 2025-04 | Pedal Bike | Hyundai | Tucson | White | Using a Mobile Phone Whilst Driving | None | Lichfield Road | Lichfield Road | Walsall | Walsall | Fixed Penalty | N/A | 52.6095168 | -2.0493009 | ||
| 16325 | op-snap---monthly-publication-march-2025.pdf | 82 | 2025-03 | Pedestrian | Volvo | XC40 | Grey | Contravening a Red Traffic Light | None | Daw End Lane, Rushall | Daw End Lane, Rushall | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6051634 | -1.956872 | |
| 16335 | op-snap---monthly-publication-march-2025.pdf | 92 | 2025-03 | Pedestrian | Vauxhall | Vivaro | White | Using a Mobile Phone Whilst Driving | None | Daw End Lane at Lichfield Road | Daw End Lane at Lichfield Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6057559 | -1.9583791 | |
| 16428 | op-snap---monthly-publication-march-2025.pdf | 185 | 2025-03 | Pedestrian | Jaguar | XF. | Red | Contravening a Red Traffic Light | None | Daw End Lane at Lichfield Road | Daw End Lane at Lichfield Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6057559 | -1.9583791 | |
| 16429 | op-snap---monthly-publication-march-2025.pdf | 186 | 2025-03 | Pedestrian | BMW | 530 | Red | Contravening a Red Traffic Light | None | Daw End Lane at Lichfield Road | Daw End Lane at Lichfield Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6057559 | -1.9583791 | |
| 16430 | op-snap---monthly-publication-march-2025.pdf | 187 | 2025-03 | Pedestrian | Honda | Jazz | Blue | Contravening a Red Traffic Light | None | Daw End Lane at Lichfield Road | Daw End Lane at Lichfield Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6057559 | -1.9583791 | |
| 16469 | op-snap---monthly-publication-march-2025.pdf | 226 | 2025-03 | Pedestrian | Toyota | Proace | White | Contravening a Red Traffic Light | None | Daw End Lane at Lichfield Road | Daw End Lane at Lichfield Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6057559 | -1.9583791 | |
| 16470 | op-snap---monthly-publication-march-2025.pdf | 227 | 2025-03 | Pedestrian | Ford | Transit | White | Contravening a Red Traffic Light | None | Daw End Lane at Lichfield Road | Daw End Lane at Lichfield Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6057559 | -1.9583791 | |
| 16473 | op-snap---monthly-publication-march-2025.pdf | 230 | 2025-03 | Pedestrian | Ford | Transit | White | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16475 | op-snap---monthly-publication-march-2025.pdf | 232 | 2025-03 | Pedestrian | Vauxhall | Insignia | White | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16477 | op-snap---monthly-publication-march-2025.pdf | 234 | 2025-03 | Pedestrian | Audi | A4 | Red | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16493 | op-snap---monthly-publication-march-2025.pdf | 250 | 2025-03 | Pedestrian | Nissan | Juke | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16495 | op-snap---monthly-publication-march-2025.pdf | 252 | 2025-03 | Car | Lexus | ES | Grey | Driving without Due Care and Attention | None | Whittemere Street | Whittemere Street | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16511 | op-snap---monthly-publication-march-2025.pdf | 268 | 2025-03 | Car | Ford | cmax | Silver | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.5723244 | -1.9607214 | |
| 16549 | op-snap---monthly-publication-march-2025.pdf | 306 | 2025-03 | Car | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | Broadway North | Broadway North | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.5886007 | -1.9741222 | |
| 16606 | op-snap---monthly-publication-march-2025.pdf | 363 | 2025-03 | Car | BMW | 320I | Orange | Driving without Due Care and Attention | None | Greaves Avenue | Greaves Avenue | Walsall | Walsall | Fixed Penalty | N/A | 52.5773135 | -1.9525262 | ||
| 16614 | op-snap---monthly-publication-march-2025.pdf | 371 | 2025-03 | Pedestrian | Mercedes-Benz | C200 | Grey | Using a Mobile Phone Whilst Driving | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16617 | op-snap---monthly-publication-march-2025.pdf | 374 | 2025-03 | Pedestrian | Vauxhall | Movano | Black | Contravening a Red Traffic Light | None | Dw End Lane | Dw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16618 | op-snap---monthly-publication-march-2025.pdf | 375 | 2025-03 | Pedestrian | Land Rover | Velar | Grey | Contravening a Red Traffic Light | None | Dw End Lane | Dw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16619 | op-snap---monthly-publication-march-2025.pdf | 376 | 2025-03 | Pedestrian | Ford | Connect | Silver | Contravening a Red Traffic Light | None | Dw End Lane | Dw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16628 | op-snap---monthly-publication-march-2025.pdf | 385 | 2025-03 | Pedal Bike | Mercedes-Benz | clk 200 | Silver | Cause vehicle to be left in a dangerous position | None | Hobs Road | Hobs Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16727 | op-snap---monthly-publication-march-2025.pdf | 484 | 2025-03 | Car | Volkswagen | Transporter | Blue | Using a Mobile Phone Whilst Driving | None | Milton Street Walsall | Milton Street Walsall | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.5718856 | -1.9899635 | |
| 16760 | op-snap---monthly-publication-march-2025.pdf | 517 | 2025-03 | Car | Volkswagen | Golf | Black | Using a Mobile Phone Whilst Driving | None | Walsall Rd jct 7 | Walsall Road jct 7 | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16814 | op-snap---monthly-publication-march-2025.pdf | 571 | 2025-03 | Pedal Bike | Mercedes-Benz | Coach | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cherry Tree Avenue, Walsall | Cherry Tree Avenue, Walsall | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16818 | op-snap---monthly-publication-march-2025.pdf | 575 | 2025-03 | Pedal Bike | Audi | A5 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Highgate Road | Highgate Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.574104 | -1.9740515 | |
| 16899 | op-snap---monthly-publication-march-2025.pdf | 656 | 2025-03 | Pedestrian | Volvo | S60 | White | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16905 | op-snap---monthly-publication-march-2025.pdf | 662 | 2025-03 | Pedestrian | Ford | Transit | Blue | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16909 | op-snap---monthly-publication-march-2025.pdf | 666 | 2025-03 | Pedestrian | Peugeot | 308 | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16913 | op-snap---monthly-publication-march-2025.pdf | 670 | 2025-03 | Pedestrian | Vauxhall | Zafira | Silver | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16914 | op-snap---monthly-publication-march-2025.pdf | 671 | 2025-03 | Pedestrian | Hyundai | I10. | Grey | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16915 | op-snap---monthly-publication-march-2025.pdf | 672 | 2025-03 | Pedestrian | Peugeot | 207.. | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 16979 | op-snap---monthly-publication-march-2025.pdf | 736 | 2025-03 | Car | Peugeot | 207 | Grey | Using a Mobile Phone Whilst Driving | None | Wolverhampton Road | Wolverhampton Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.5867763 | -2.0104342 | |
| 17034 | op-snap---monthly-publication-march-2025.pdf | 791 | 2025-03 | Car | Peugeot | Expert | Red | Contravening a Red Traffic Light | None | Wolverhampton Street | Wolverhampton Street | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.5674241 | -2.0426354 | |
| 17065 | op-snap---monthly-publication-march-2025.pdf | 822 | 2025-03 | Pedestrian | Audi | Q7 | Grey | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 17066 | op-snap---monthly-publication-march-2025.pdf | 823 | 2025-03 | Pedestrian | Volvo | XC40 | Blue | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 17067 | op-snap---monthly-publication-march-2025.pdf | 824 | 2025-03 | Pedestrian | Hyundai | i40 | Red | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 17068 | op-snap---monthly-publication-march-2025.pdf | 825 | 2025-03 | Pedestrian | Toyota | Yaris | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 | |
| 17069 | op-snap---monthly-publication-march-2025.pdf | 826 | 2025-03 | Pedestrian | Mercedes-Benz | 300 AMG | White | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6068849 | -1.9611652 |
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);