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'}
33 rows where month = "2025-04", offence = "Contravening a Red Traffic Light" and vehicle_make = "Ford" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_model, vehicle_colour, council_area_raw, nfa_rationale
council_area 9
- Birmingham 15
- Coventry 6
- Walsall 5
- Wolverhampton 2
- Area 1
- Coouvt Eonft Fryorce 1
- Dudley 1
- Out of Force Area 1
- Solihull 1
disposal 4
- NFA 23
- Warning Letter 6
- Fixed Penalty 3
- Education 1
reporter_transport_mode 3
- Car 24
- Pedal Bike 6
- Pedestrian 3
vehicle_make 1
- Ford · 33 ✖
offence 1
- Contravening a Red Traffic Light · 33 ✖
month 1
- 2025-04 · 33 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19 | op-snap---monthly-publication-april-2025.pdf | 18 | 2025-04 | Car | Ford | Toureno | Silver | Contravening a Red Traffic Light | None | Islington Row Middleway | Islington Row Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4720132 | -1.9142946 | ||
| 60 | op-snap---monthly-publication-april-2025.pdf | 59 | 2025-04 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Bunbury Road | Bunbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4142089 | -1.9587147 | ||
| 159 | op-snap---monthly-publication-april-2025.pdf | 158 | 2025-04 | Car | Ford | Fiesta | Black | Contravening a Red Traffic Light | None | Alridge Rd | Aldridge Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5368764 | -1.8976461 | ||
| 163 | op-snap---monthly-publication-april-2025.pdf | 162 | 2025-04 | Car | Ford | KUGA | Grey | Contravening a Red Traffic Light | None | SUN ISLAND BROWNHILLS | Sun Island Brownhills | Walsall | Walsall | Warning Letter | N/A | ||||
| 172 | op-snap---monthly-publication-april-2025.pdf | 171 | 2025-04 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Hanging Lane at Frankley Beeches Road | Hanging Lane at Frankley Beeches Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4091382 | -1.9838016 | ||
| 229 | op-snap---monthly-publication-april-2025.pdf | 228 | 2025-04 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Monkswood Crescent | Monkswood Crescent | Coventry | Coventry | Fixed Penalty | N/A | 52.4326493 | -1.463362 | ||
| 357 | op-snap---monthly-publication-april-2025.pdf | 356 | 2025-04 | Car | Ford | TRANSIT | Silver | Contravening a Red Traffic Light | None | FLETCHAMSTEAD HIGHWAY | Fletchamstead Highway | Birmingham | Birmingham | NFA | No Offence | ||||
| 438 | op-snap---monthly-publication-april-2025.pdf | 437 | 2025-04 | Pedal Bike | Ford | TRANSIT | Blue | Contravening a Red Traffic Light | None | BELL GREEN ROAD | Bell Green Road | COouvt eonft Fryorce | Coouvt Eonft Fryorce | NFA | Outside of 14 Days NIP | 52.4361538 | -1.4756447 | ||
| 491 | op-snap---monthly-publication-april-2025.pdf | 490 | 2025-04 | Car | Ford | Focus | Grey | Contravening a Red Traffic Light | None | A5 Cannock | Cannock | Area | Area | NFA | Out of Force | 52.6115346 | -2.1002311 | ||
| 492 | op-snap---monthly-publication-april-2025.pdf | 491 | 2025-04 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Littleton St East | Littleton Street East | Walsall | Walsall | Warning Letter | N/A | 52.5887823 | -1.9801166 | ||
| 525 | op-snap---monthly-publication-april-2025.pdf | 524 | 2025-04 | Car | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Sky Blue Way | Sky Blue Way | Coventry | Coventry | Fixed Penalty | N/A | 52.4085943 | -1.4943275 | ||
| 607 | op-snap---monthly-publication-april-2025.pdf | 606 | 2025-04 | Car | Ford | Focus | Red | Contravening a Red Traffic Light | None | Nechells Lane | Nechells Lane | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 700 | op-snap---monthly-publication-april-2025.pdf | 699 | 2025-04 | Pedal Bike | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Horton Square | Horton Square | Birmingham | Birmingham | Warning Letter | N/A | 52.4649176 | -1.8918971 | ||
| 703 | op-snap---monthly-publication-april-2025.pdf | 702 | 2025-04 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Bescot Road | Bescot Road | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5707373 | -2.0014215 | ||
| 727 | op-snap---monthly-publication-april-2025.pdf | 726 | 2025-04 | Pedestrian | Ford | Fiesta | White | Contravening a Red Traffic Light | None | Stratford Road, Shirley | Stratford Road, Shirley | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 790 | op-snap---monthly-publication-april-2025.pdf | 789 | 2025-04 | Pedal Bike | Ford | Transit | White | Contravening a Red Traffic Light | None | Kenilworth Road | Kenilworth Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3833298 | -1.5379214 | ||
| 963 | op-snap---monthly-publication-april-2025.pdf | 962 | 2025-04 | Car | Ford | Black | Contravening a Red Traffic Light | None | A45 , Coventry | A45 , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3772596 | -1.4884352 | |||
| 1051 | op-snap---monthly-publication-april-2025.pdf | 1050 | 2025-04 | Pedal Bike | Ford | Van | White | 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 | ||
| 1059 | op-snap---monthly-publication-april-2025.pdf | 1058 | 2025-04 | Pedestrian | Ford | Van | White | Contravening a Red Traffic Light | None | Daw end Lane , Walsall | Daw end Lane , Walsall | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 1199 | op-snap---monthly-publication-april-2025.pdf | 1198 | 2025-04 | Car | Ford | Transit Leader | White | Contravening a Red Traffic Light | None | Wolverhampton Road , Dudley | Wolverhampton Road , Dudley | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.5491587 | -2.1238257 | ||
| 1232 | op-snap---monthly-publication-april-2025.pdf | 1231 | 2025-04 | Car | Ford | White | Contravening a Red Traffic Light | None | Pilkington Avenue , Birmingham | Pilkington Avenue , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5504704 | -1.8195028 | |||
| 1285 | op-snap---monthly-publication-april-2025.pdf | 1284 | 2025-04 | Pedal Bike | Ford | FIESTA | Black | Contravening a Red Traffic Light | None | Bell green road | Bell green road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4324855 | -1.4815548 | ||
| 1321 | op-snap---monthly-publication-april-2025.pdf | 1320 | 2025-04 | Pedestrian | Ford | NP | Black | Contravening a Red Traffic Light | None | Greyfriars Road near the junction with Sheriffs | Greyfriars Road near the junction with Sheriffs | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 1327 | op-snap---monthly-publication-april-2025.pdf | 1326 | 2025-04 | Car | Ford | Fiesta | Grey | Contravening a Red Traffic Light | None | high Street. A4100 | high Street. A4100 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.564965 | -1.8221416 | ||
| 1592 | op-snap---monthly-publication-april-2025.pdf | 1591 | 2025-04 | Car | Ford | Kuga St-line x | Black | Contravening a Red Traffic Light | None | Salford circus | Salford circus | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5095071 | -1.8593732 | ||
| 1649 | op-snap---monthly-publication-april-2025.pdf | 1648 | 2025-04 | Car | Ford | Focus | Grey | Contravening a Red Traffic Light | None | Wake green road | Wake green road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4437078 | -1.8783408 | ||
| 1671 | op-snap---monthly-publication-april-2025.pdf | 1670 | 2025-04 | Car | Ford | Focus | White | Contravening a Red Traffic Light | None | Coventry road | Coventry road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4726661 | -1.8769032 | ||
| 1681 | op-snap---monthly-publication-april-2025.pdf | 1680 | 2025-04 | Car | Ford | NP | Blue | Contravening a Red Traffic Light | None | M42 West bound | M42 West bound | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1722 | op-snap---monthly-publication-april-2025.pdf | 1721 | 2025-04 | Car | Ford | Focus | Silver | Contravening a Red Traffic Light | None | Sky blue way road | Sky blue way road | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 1773 | op-snap---monthly-publication-april-2025.pdf | 1772 | 2025-04 | Pedal Bike | Ford | NP | Red | Contravening a Red Traffic Light | None | Littleton street | Littleton street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5885092 | -1.9817997 | ||
| 1926 | op-snap---monthly-publication-april-2025.pdf | 1925 | 2025-04 | Car | Ford | Fiesta | Black | Contravening a Red Traffic Light | None | Yardley wood road and wake green road | Yardley wood road and wake green road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4163094 | -1.8706151 | ||
| 1953 | op-snap---monthly-publication-april-2025.pdf | 1952 | 2025-04 | Car | Ford | Transit | Grey | Contravening a Red Traffic Light | None | Stratford road | Stratford road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4203897 | -1.8338574 | ||
| 2020 | op-snap---monthly-publication-april-2025.pdf | 2019 | 2025-04 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Wolverhampton Lane , Wolverhampton | Wolverhampton Lane , Wolverhampton | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.590114 | -2.183494 |
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);