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'}
224 rows where council_area = "Walsall" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 28
offence 20
- Contravening a Red Traffic Light 127
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 23
- Cause vehicle to be left in a dangerous position 12
- Using a Mobile Phone Whilst Driving 12
- Misc - Non Traffic Offences 10
- Driving without Due Care and Attention 8
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 8
- No Seat Belt 6
- Stop a vehicle within pelican pedestrian crossing limits 4
- Stop a vehicle on pedestrian crossing 3
- Driving without Reasonable Consideration 2
- Contravene Lane Closure Red X 1
- Dangerous Driving 1
- Drive / Ride / Lead an animal on a footpath 1
- Driving a vehicle wholly or partly on a footpath 1
- Keeping a vehicle with registration marks obscured 1
- No Insurance 1
- Use a motor vehicle / trailer in a condition likely t 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
month 13
disposal 8
- NFA 75
- Fixed Penalty 67
- Education 37
- Warning Letter 37
- Court 4
- Other Action Taken 2
- Duplicate Submission 1
- RTC - Actioned 1
reporter_transport_mode 1
- Pedestrian · 224 ✖
council_area 1
- Walsall · 224 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7504 | op-snap---monthly-publication-february-2026.pdf | 251 | 2026-02 | Pedestrian | Mg | ZS | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Maple Road | Maple Road | Walsall | Walsall | Warning Letter | N/A | 52.6232088 | -1.9735008 | ||
| 8174 | op-snap---monthly-publication-february-2026.pdf | 921 | 2026-02 | Pedestrian | Volkswagen | Golf | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Reservoir Street | Reservoir Street | Walsall | Walsall | Warning Letter | N/A | 52.5793129 | -2.0042116 | ||
| 8179 | op-snap---monthly-publication-february-2026.pdf | 926 | 2026-02 | Pedestrian | Volkswagen | Golf | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Reservoir Street | Reservoir Street | Walsall | Walsall | Duplicate Submission | Duplicate Submission | 52.5793129 | -2.0042116 | ||
| 8482 | op-snap---monthly-publication-february-2026.pdf | 1229 | 2026-02 | Pedestrian | Vauxhall | Adam | Black | Driving without Due Care and Attention | None | Mcdonalds Car Park | Mcdonalds Car Park | Walsall | Walsall | NFA | No Independent Evidence Available | ||||
| 8730 | op-snap---monthly-publication-february-2026.pdf | 1477 | 2026-02 | Pedestrian | Kia | sorento | Grey | Misc - Non Traffic Offences | None | broadmeadow | Broadmeadow | Walsall | Walsall | Warning Letter | N/A | 52.6100022 | -1.9177041 | ||
| 8874 | op-snap---monthly-publication-february-2026.pdf | 1621 | 2026-02 | Pedestrian | Ford | puma | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | broad meadow | Broad Meadow | Walsall | Walsall | Warning Letter | N/A | 52.6118773 | -1.9173068 | ||
| 10630 | op-snap---monthly-publication-january-2026.pdf | 91 | 2026-01 | Pedestrian | BMW | 3 series | White | Driving without Due Care and Attention | None | Navigation Street | Navigation Street | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5842791 | -1.9872353 | ||
| 10715 | op-snap---monthly-publication-january-2026.pdf | 176 | 2026-01 | Pedestrian | Peugeot | 107.. | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Street | Dudley Street | Metropolitan Borough of Walsall | Walsall | Other Action Taken | N/A | 52.5813674 | -1.9810905 | ||
| 10748 | op-snap---monthly-publication-january-2026.pdf | 209 | 2026-01 | Pedestrian | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Laburnum Road | Laburnum Road | Walsall | Walsall | NFA | Not in Public Interest | 52.6274757 | -1.9249011 | ||
| 10871 | op-snap---monthly-publication-january-2026.pdf | 332 | 2026-01 | Pedestrian | Ford | Transit | White | Keeping a vehicle with registration marks obscured | None | Poplar Av | Poplar Avenue | Walsall | Walsall | NFA | No VRM | 52.5945052 | -2.0227343 | ||
| 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 | ||
| 11287 | op-snap---monthly-publication-january-2026.pdf | 748 | 2026-01 | Pedestrian | Toyota | Prius | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bradford Street | Bradford Street | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5831181 | -1.9834255 | ||
| 11289 | op-snap---monthly-publication-january-2026.pdf | 750 | 2026-01 | Pedestrian | Toyota | Yaris | Red | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bradford Street | Bradford Street | Walsall | Walsall | Warning Letter | N/A | 52.5831181 | -1.9834255 | ||
| 11487 | op-snap---monthly-publication-january-2026.pdf | 948 | 2026-01 | Pedestrian | Toyota | Prius | White | Contravening a Red Traffic Light | None | Wolverhampton Road A454 Walsall | Wolverhampton Road A454 Walsall | Walsall | Walsall | Education | N/A | 52.5868952 | -2.0036453 | ||
| 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 | ||
| 20835 | op-snap---monthly-publication-november-2025.pdf | 377 | 2025-11 | Pedestrian | Vauxhall | Movano | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Weston St | Weston Street | Walsall | Walsall | Warning Letter | N/A | 52.5717464 | -1.9801677 | ||
| 21121 | op-snap---monthly-publication-november-2025.pdf | 663 | 2025-11 | Pedestrian | Mercedes-Benz | A200 | White | No Seat Belt | None | Wood End Road | Wood End Road | Walsall | Walsall | Warning Letter | N/A | 52.5769485 | -1.94702 | ||
| 22180 | op-snap---monthly-publication-october-2025.pdf | 130 | 2025-10 | Pedestrian | Volkswagen | Passat | Grey | Cause vehicle to be left in a dangerous position | None | Hobbs Road | Hobbs Road | Walsall | Walsall | Education | N/A | ||||
| 22297 | op-snap---monthly-publication-october-2025.pdf | 247 | 2025-10 | Pedestrian | BMW | 218i | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hobbs Road, Wednesbury | Hobbs Road, Wednesbury | Walsall | Walsall | NFA | No Independent Evidence Available | ||||
| 22350 | op-snap---monthly-publication-october-2025.pdf | 300 | 2025-10 | Pedestrian | Land Rover | Velar | Silver | Cause vehicle to be left in a dangerous position | None | Hobbs Road | Hobbs Road | Walsall | Walsall | Education | N/A | ||||
| 22383 | op-snap---monthly-publication-october-2025.pdf | 333 | 2025-10 | Pedestrian | Fiat | Scudo | Silver | Cause vehicle to be left in a dangerous position | None | Hobbs Road | Hobbs Road | Walsall | Walsall | Education | N/A | ||||
| 22629 | op-snap---monthly-publication-october-2025.pdf | 579 | 2025-10 | Pedestrian | Land Rover | Velar | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hobbs Road, Wednesbury | Hobbs Road, Wednesbury | Walsall | Walsall | NFA | No Independent Evidence Available | ||||
| 22800 | op-snap---monthly-publication-october-2025.pdf | 750 | 2025-10 | Pedestrian | Mercedes-Benz | Grey | Using a Mobile Phone Whilst Driving | None | Pleck Road | Pleck Road | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5827033 | -1.9960274 | |||
| 23223 | op-snap---monthly-publication-october-2025.pdf | 1173 | 2025-10 | Pedestrian | Ford | Fiesta | Blue | Misc - Non Traffic Offences | None | Goals, Bilston | Goals, Bilston | Walsall | Walsall | RTC - Actioned | N/A | 52.5737571 | -2.0513855 | ||
| 23850 | op-snap---monthly-publication-september-2025.pdf | 69 | 2025-09 | Pedestrian | Nissan | Note | Orange | Drive / Ride / Lead an animal on a footpath | None | Greaves Crescent | Greaves Crescent | Walsall | Walsall | Warning Letter | N/A | 52.6120444 | -2.0439285 | ||
| 24177 | op-snap---monthly-publication-september-2025.pdf | 396 | 2025-09 | Pedestrian | Nissan | Micra | Green | Using a Mobile Phone Whilst Driving | No Seat Belt | Littleton Street West | Littleton Street West | Walsall | Walsall | Other Action Taken | N/A | 52.588379 | -1.9843635 | ||
| 24576 | op-snap---monthly-publication-september-2025.pdf | 795 | 2025-09 | Pedestrian | Land Rover | Black | Using a Mobile Phone Whilst Driving | None | Walsall Road | Walsall Road | Walsall | Walsall | NFA | No VRM | 52.6166864 | -1.9660822 | |||
| 24594 | op-snap---monthly-publication-september-2025.pdf | 813 | 2025-09 | Pedestrian | Seat | Ibiza | Black | Use a motor vehicle / trailer in a condition likely t | o cause danger of injuryNone | Wisemore | Wisemore | Walsall | Walsall | NFA | No VRM | 52.5883993 | -1.9818244 | ||
| 25245 | op-snap---monthly-publication-september-2025.pdf | 1464 | 2025-09 | Pedestrian | Honda | CBF | Red | Driving without Due Care and Attention | None | Wood Common Grange | Wood Common Grange | Walsall | Walsall | Warning Letter | N/A | 52.6319931 | -1.9785842 | ||
| 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 | ||
| 2901 | op-snap---monthly-publication-august-2025.pdf | 876 | 2025-08 | Pedestrian | Vauxhall | Insignia | Silver | Contravening a Red Traffic Light | None | Littleton Street East | Littleton Street East | Walsall | Walsall | Education | N/A | 52.5887823 | -1.9801166 | ||
| 3274 | op-snap---monthly-publication-august-2025.pdf | 1249 | 2025-08 | Pedestrian | Peugeot | 3008 | Black | Cause vehicle to be left in a dangerous position | None | Gurney Road | Gurney Road | Walsall | Walsall | Warning Letter | N/A | 52.6010218 | -2.0119092 | ||
| 3452 | op-snap---monthly-publication-august-2025.pdf | 1427 | 2025-08 | Pedestrian | Misc - Non Traffic Offences | None | Walsall Palfrey | Walsall Palfrey | Walsall | Walsall | NFA | No Offence | 52.5805622 | -1.9769245 | |||||
| 3577 | op-snap---monthly-publication-august-2025.pdf | 1552 | 2025-08 | Pedestrian | Other | Misc - Non Traffic Offences | None | Churchill road | Churchill road | Walsall | Walsall | NFA | Misc Inc Crimes | 52.5887964 | -2.0253617 | ||||
| 12150 | op-snap---monthly-publication-july-2025.pdf | 202 | 2025-07 | Pedestrian | Hyundai | Santa Fe | Black | Contravening a Red Traffic Light | None | McDonalds, Walsall | Mc Donalds, Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 12152 | op-snap---monthly-publication-july-2025.pdf | 204 | 2025-07 | Pedestrian | Nissan | Ariya | Black | Contravening a Red Traffic Light | None | McDonalds, Walsall | Mc Donalds, Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 12153 | op-snap---monthly-publication-july-2025.pdf | 205 | 2025-07 | Pedestrian | Peugeot | Expert | Blue | Contravening a Red Traffic Light | None | McDonalds, Walsall | Mc Donalds, Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 12154 | op-snap---monthly-publication-july-2025.pdf | 206 | 2025-07 | Pedestrian | Vauxhall | Corsa | Black | Contravening a Red Traffic Light | None | McDonalds, Walsall | Mc Donalds, Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 12156 | op-snap---monthly-publication-july-2025.pdf | 208 | 2025-07 | Pedestrian | Renault | Captur | Blue | Contravening a Red Traffic Light | None | McDonalds, Walsall | Mc Donalds, Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 12360 | op-snap---monthly-publication-july-2025.pdf | 412 | 2025-07 | Pedestrian | Volkswagen | Polo | Grey | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 12362 | op-snap---monthly-publication-july-2025.pdf | 414 | 2025-07 | Pedestrian | Volvo | Lorry | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 12364 | op-snap---monthly-publication-july-2025.pdf | 416 | 2025-07 | Pedestrian | Honda | Civic | Silver | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 13387 | op-snap---monthly-publication-july-2025.pdf | 1439 | 2025-07 | Pedestrian | BMW | 325CI | Silver | No Seat Belt | No Insurance | Rushall mcdonalds | Rushall mcdonalds | Walsall | Walsall | NFA | Misc Inc Crimes | ||||
| 13415 | op-snap---monthly-publication-july-2025.pdf | 1467 | 2025-07 | Pedestrian | Ford | ranger | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ganton Road | Ganton Road | Walsall | Walsall | Warning Letter | N/A | 52.6293068 | -2.0106252 | ||
| 13441 | op-snap---monthly-publication-july-2025.pdf | 1493 | 2025-07 | Pedestrian | BMW | X5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Alexndra Road | Alexndra Road | Walsall | Walsall | NFA | Misc Inc Crimes | ||||
| 13474 | op-snap---monthly-publication-july-2025.pdf | 1526 | 2025-07 | Pedestrian | Volkswagen | Passat | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Broadway North | Broadway North | Walsall | Walsall | Warning Letter | N/A | 52.5886007 | -1.9741222 | ||
| 13495 | op-snap---monthly-publication-july-2025.pdf | 1547 | 2025-07 | Pedestrian | Volkswagen | golf | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Evelyn Road | Evelyn Road | Walsall | Walsall | NFA | Misc Inc Crimes | ||||
| 13499 | op-snap---monthly-publication-july-2025.pdf | 1551 | 2025-07 | Pedestrian | BMW | 118D | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13500 | op-snap---monthly-publication-july-2025.pdf | 1552 | 2025-07 | Pedestrian | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13501 | op-snap---monthly-publication-july-2025.pdf | 1553 | 2025-07 | Pedestrian | BMW | 330E | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13502 | op-snap---monthly-publication-july-2025.pdf | 1554 | 2025-07 | Pedestrian | Peugeot | 3008 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13503 | op-snap---monthly-publication-july-2025.pdf | 1555 | 2025-07 | Pedestrian | Kia | Sportage | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13597 | op-snap---monthly-publication-july-2025.pdf | 1649 | 2025-07 | Pedestrian | Volkswagen | Black | Cause vehicle to be left in a dangerous position | None | Walstead Road | Walstead Road | Walsall | Walsall | NFA | No VRM | 52.5648629 | -1.9517624 | |||
| 13598 | op-snap---monthly-publication-july-2025.pdf | 1650 | 2025-07 | Pedestrian | Mercedes-Benz | C63 | White | Cause vehicle to be left in a dangerous position | No Insurance | Walstead Road | Walstead Road | Walsall | Walsall | Warning Letter | N/A | 52.5648629 | -1.9517624 | ||
| 13667 | op-snap---monthly-publication-july-2025.pdf | 1719 | 2025-07 | Pedestrian | Volvo | xc90 | Green | Cause vehicle to be left in a dangerous position | none | Lynn Lane | Lynn Lane | Walsall | Walsall | Warning Letter | N/A | ||||
| 13985 | op-snap---monthly-publication-july-2025.pdf | 2037 | 2025-07 | Pedestrian | BMW | X5 | Black | Cause vehicle to be left in a dangerous position | None | Alexandra Road, Walsall | Alexandra Road, Walsall | Walsall | Walsall | NFA | Misc Inc Crimes | 52.5668557 | -1.9835611 | ||
| 14039 | op-snap---monthly-publication-july-2025.pdf | 2091 | 2025-07 | Pedestrian | Mercedes-Benz | C220 | Grey | Cause vehicle to be left in a dangerous position | None | Butts Lane, Walsall | Butts Lane, Walsall | Walsall | Walsall | Warning Letter | N/A | 52.5932553 | -1.9764743 | ||
| 14080 | op-snap---monthly-publication-june-2025.pdf | 9 | 2025-06 | Pedestrian | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Broadway North | Broadway North | Walsall | Walsall | Education | N/A | 52.5886007 | -1.9741222 | ||
| 14081 | op-snap---monthly-publication-june-2025.pdf | 10 | 2025-06 | Pedestrian | Nissan | micra | Grey | Contravening a Red Traffic Light | None | Broadway North | Broadway North | Walsall | Walsall | Education | N/A | 52.5886007 | -1.9741222 | ||
| 14082 | op-snap---monthly-publication-june-2025.pdf | 11 | 2025-06 | Pedestrian | Toyota | Prius | White | Contravening a Red Traffic Light | None | Broadway North | Broadway North | Walsall | Walsall | Education | N/A | 52.5886007 | -1.9741222 | ||
| 14083 | op-snap---monthly-publication-june-2025.pdf | 12 | 2025-06 | Pedestrian | Skoda | Octavia | White | No Seat Belt | None | Broadway North | Broadway North | Walsall | Walsall | Education | N/A | 52.5886007 | -1.9741222 | ||
| 14541 | op-snap---monthly-publication-june-2025.pdf | 470 | 2025-06 | Pedestrian | Ford | Kuga | Blue | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14542 | op-snap---monthly-publication-june-2025.pdf | 471 | 2025-06 | Pedestrian | BMW | 320D.. | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14543 | op-snap---monthly-publication-june-2025.pdf | 472 | 2025-06 | Pedestrian | Renault | Clio | Silver | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Warning Letter | N/A | 52.6068849 | -1.9611652 | ||
| 14547 | op-snap---monthly-publication-june-2025.pdf | 476 | 2025-06 | Pedestrian | Renault | Trafic | Beige | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14548 | op-snap---monthly-publication-june-2025.pdf | 477 | 2025-06 | Pedestrian | Mercedes-Benz | A200 | White | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14549 | op-snap---monthly-publication-june-2025.pdf | 478 | 2025-06 | Pedestrian | Toyota | Auris | White | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 15104 | op-snap---monthly-publication-june-2025.pdf | 1033 | 2025-06 | Pedestrian | Unknown | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Walsall | Walsall | NFA | No VRM | 52.5692139 | -1.8799672 | |||
| 15351 | op-snap---monthly-publication-june-2025.pdf | 1280 | 2025-06 | Pedestrian | Toyota | Aygo | Blue | No Seat Belt | None | Daw End Lane | Daw End Lane | Walsall | Walsall | NFA | No Independent Evidence Available | 52.6068849 | -1.9611652 | ||
| 15366 | op-snap---monthly-publication-june-2025.pdf | 1295 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alexandra Way | Alexandra Way | Walsall | Walsall | Warning Letter | N/A | 52.6019098 | -1.9160042 | ||
| 15369 | op-snap---monthly-publication-june-2025.pdf | 1298 | 2025-06 | Pedestrian | BMW | 5 series | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | School Walk | School Walk | Walsall | Walsall | Warning Letter | N/A | 52.6276567 | -1.9224045 | ||
| 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 | ||
| 16080 | op-snap---monthly-publication-june-2025.pdf | 2009 | 2025-06 | Pedestrian | Kia | Sportage | Black | Cause vehicle to be left in a dangerous position | None | Outside Leckie School, Walsall | Outside Leckie School, Walsall | Walsall | Walsall | Warning Letter | N/A | ||||
| 16089 | op-snap---monthly-publication-june-2025.pdf | 2018 | 2025-06 | Pedestrian | Iveco | Daily | White | Driving without Due Care and Attention | None | Steelpark Way | Steelpark Way | Walsall | Walsall | Warning Letter | N/A | ||||
| 16234 | op-snap---monthly-publication-june-2025.pdf | 2163 | 2025-06 | Pedestrian | Iveco | Eurocargo | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Dangerfield Lane | Dangerfield Lane | Walsall | Walsall | Warning Letter | N/A | 52.5612848 | -2.0385837 | ||
| 18799 | op-snap---monthly-publication-may-2025.pdf | 161 | 2025-05 | Pedestrian | Iveco | White | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Birmingham Road Aldridge | Birmingham Road Aldridge | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5766298 | -1.9685663 | |||
| 18883 | op-snap---monthly-publication-may-2025.pdf | 245 | 2025-05 | Pedestrian | Ford | Transit | Blue | No Seat Belt | None | A$148 Walsall | A$148 Walsall | Walsall | Walsall | Warning Letter | N/A | 52.629207 | -1.9300274 | ||
| 18884 | op-snap---monthly-publication-may-2025.pdf | 246 | 2025-05 | Pedestrian | Jaguar | XF... | Grey | Contravening a Red Traffic Light | None | A4148 Walsall | Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5841365 | -1.9852679 | ||
| 18887 | op-snap---monthly-publication-may-2025.pdf | 249 | 2025-05 | Pedestrian | BMW | 535 D | Silver | Contravening a Red Traffic Light | None | A4148 Walsall | Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5841365 | -1.9852679 | ||
| 18889 | op-snap---monthly-publication-may-2025.pdf | 251 | 2025-05 | Pedestrian | Audi | A5 | Grey | Contravening a Red Traffic Light | None | A4148 | A4148 | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 19032 | op-snap---monthly-publication-may-2025.pdf | 394 | 2025-05 | Pedestrian | Land Rover | Range Rover | Black | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19033 | op-snap---monthly-publication-may-2025.pdf | 395 | 2025-05 | Pedestrian | Ford | Puma | Red | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19035 | op-snap---monthly-publication-may-2025.pdf | 397 | 2025-05 | Pedestrian | Vauxhall | Corsa | Red | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19039 | op-snap---monthly-publication-may-2025.pdf | 401 | 2025-05 | Pedestrian | Toyota | MPV | White | Contravening a Red Traffic Light | None | LICHFIELD STREET | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19040 | op-snap---monthly-publication-may-2025.pdf | 402 | 2025-05 | Pedestrian | Grey | Contravening a Red Traffic Light | None | LICHFIELD STREET | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||||
| 19189 | op-snap---monthly-publication-may-2025.pdf | 551 | 2025-05 | Pedestrian | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Bosty Lane | Bosty Lane | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5948329 | -1.927787 | ||
| 19337 | op-snap---monthly-publication-may-2025.pdf | 699 | 2025-05 | Pedestrian | Mazda | CX-5 | Grey | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19338 | op-snap---monthly-publication-may-2025.pdf | 700 | 2025-05 | Pedestrian | Mazda | CX-30 | White | Contravening a Red Traffic Light | None | Daw End lane | Daw End lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19339 | op-snap---monthly-publication-may-2025.pdf | 701 | 2025-05 | Pedestrian | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Daw End lane | Daw End lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 19900 | op-snap---monthly-publication-may-2025.pdf | 1262 | 2025-05 | Pedestrian | Nissan | Black | Contravening a Red Traffic Light | None | Daw end Lane , Walsall | Daw end Lane , Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.6069179 | -1.9610677 | |||
| 20132 | op-snap---monthly-publication-may-2025.pdf | 1494 | 2025-05 | Pedestrian | Audi | SQ8 | Black | Cause vehicle to be left in a dangerous position | None | Hobbs Road | Hobbs Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 20222 | op-snap---monthly-publication-may-2025.pdf | 1584 | 2025-05 | Pedestrian | Ford | Fiesta | Grey | Contravening a Red Traffic Light | None | Station Road | Station Road | Walsall | Walsall | Warning Letter | N/A | 52.6281831 | -1.9664494 | ||
| 20223 | op-snap---monthly-publication-may-2025.pdf | 1585 | 2025-05 | Pedestrian | Vauxhall | Corsa | Blue | Contravening a Red Traffic Light | None | Station Road | Station Road | Walsall | Walsall | Warning Letter | N/A | 52.6281831 | -1.9664494 | ||
| 20225 | op-snap---monthly-publication-may-2025.pdf | 1587 | 2025-05 | Pedestrian | White | Driving without Due Care and Attention | None | Poplar Avenue, Walsall | Poplar Avenue, Walsall | Walsall | Walsall | NFA | No VRM | 52.5945052 | -2.0227343 | ||||
| 58 | op-snap---monthly-publication-april-2025.pdf | 57 | 2025-04 | Pedestrian | NP | Dangerous Driving | None | Pelsall High Street | Pelsall High Street | Walsall | Walsall | NFA | No Independent Evidence Available | 52.628914 | -1.9675162 | ||||
| 103 | op-snap---monthly-publication-april-2025.pdf | 102 | 2025-04 | Pedestrian | Porsche | Macan | Silver | Contravening a Red Traffic Light | None | Littleton St | Littleton Street | Walsall | Walsall | Education | N/A | 52.5885092 | -1.9817997 |
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);