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'}
22 rows where council_area = "Walsall", disposal = "Fixed Penalty" and vehicle_make = "Ford" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_model, vehicle_colour, second_offence, offence_location_raw, offence_location, latitude, longitude
offence 7
reporter_transport_mode 4
- Pedestrian 10
- Car 8
- Pedal Bike 3
- Lorry 1
vehicle_make 1
- Ford · 22 ✖
disposal 1
- Fixed Penalty · 22 ✖
council_area 1
- Walsall · 22 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | |
| 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 | |||
| 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 | |
| 17168 | op-snap---monthly-publication-march-2025.pdf | 925 | 2025-03 | Pedestrian | Ford | Fiesta | 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 | |
| 17267 | op-snap---monthly-publication-march-2025.pdf | 1024 | 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 | |
| 18039 | op-snap---monthly-publication-march-2025.pdf | 1796 | 2025-03 | Pedal Bike | 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 | |
| 18302 | op-snap---monthly-publication-march-2025.pdf | 2059 | 2025-03 | Pedestrian | Ford | Transit | White | 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 | |
| 5425 | op-snap---monthly-publication-february-2025.pdf | 242 | 2025-02 | Pedal Bike | Ford | CMAX | Brown | Driving a vehicle wholly or partly on a footpath | None | Chester Road, Brownhills | Chester Road, Brownhills | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6298869 | -1.9079971 | |
| 6193 | op-snap---monthly-publication-february-2025.pdf | 1010 | 2025-02 | Car | Ford | Transit | White | Contravening a Red Traffic Light | No Insurance | Lichfield Road Walsall | Lichfield Road Walsall | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6099659 | -2.0445263 | |
| 6347 | op-snap---monthly-publication-february-2025.pdf | 1164 | 2025-02 | Car | Ford | Puma | White | Drive on hard shoulder | None | M6 North Junction 8-9 | M6 North Junction 8-9 | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 6593 | op-snap---monthly-publication-february-2025.pdf | 1410 | 2025-02 | Pedestrian | Ford | Focus | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Crankhall Lane, Wednesbury | Crankhall Lane, Wednesbury | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 6839 | op-snap---monthly-publication-february-2025.pdf | 1656 | 2025-02 | Car | Ford | transit | Grey | Driving without Due Care and Attention | None | Chhester Road Aldridge | Chhester Road Aldridge | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 7041 | op-snap---monthly-publication-february-2025.pdf | 1858 | 2025-02 | Pedestrian | Ford | Fiesta | Red | Stop a vehicle on pedestrian crossing | None | Crankhall Lane | Crankhall Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 10054 | op-snap---monthly-publication-january-2025.pdf | 1162 | 2025-01 | Pedestrian | Ford | Transit | White | Contravening a Red Traffic Light | None | Station Road | Station Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.6281831 | -1.9664494 |
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);