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'}
51 rows where month = "2025-05", offence = "Using a Mobile Phone Whilst Driving" and reporter_transport_mode = "Pedal Bike" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 19
council_area 5
- Birmingham 40
- Coventry 6
- Sandwell 2
- Walsall 2
- Solihull 1
disposal 4
- Fixed Penalty 35
- NFA 11
- Warning Letter 4
- Court 1
reporter_transport_mode 1
- Pedal Bike · 51 ✖
offence 1
- Using a Mobile Phone Whilst Driving · 51 ✖
month 1
- 2025-05 · 51 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18654 | op-snap---monthly-publication-may-2025.pdf | 16 | 2025-05 | Pedal Bike | Tesla | White | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | |||
| 18659 | op-snap---monthly-publication-may-2025.pdf | 21 | 2025-05 | Pedal Bike | Land Rover | Range Rover | Green | Using a Mobile Phone Whilst Driving | None | Widney Road Solihull | Widney Road Solihull | Solihull | Solihull | NFA | Not in Public Interest | 52.3795667 | -1.7478958 | ||
| 18699 | op-snap---monthly-publication-may-2025.pdf | 61 | 2025-05 | Pedal Bike | Toyota | Auris | Blue | Using a Mobile Phone Whilst Driving | None | Bath Row | Bath Row | Birmingham | Birmingham | Fixed Penalty | N/A | 52.472238 | -1.9127983 | ||
| 18702 | op-snap---monthly-publication-may-2025.pdf | 64 | 2025-05 | Pedal Bike | BMW | 330d | Black | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 18704 | op-snap---monthly-publication-may-2025.pdf | 66 | 2025-05 | Pedal Bike | Volkswagen | Golf | Grey | Using a Mobile Phone Whilst Driving | None | Harbourne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 18713 | op-snap---monthly-publication-may-2025.pdf | 75 | 2025-05 | Pedal Bike | Seat | ibiza | Silver | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 18764 | op-snap---monthly-publication-may-2025.pdf | 126 | 2025-05 | Pedal Bike | Toyota | CH R | White | Using a Mobile Phone Whilst Driving | No Insurance | High Street Kings Heath | High Street Kings Heath | Birmingham | Birmingham | Court | N/A | 52.4375456 | -1.8926849 | ||
| 18774 | op-snap---monthly-publication-may-2025.pdf | 136 | 2025-05 | Pedal Bike | Ford | S-MAX | Black | Using a Mobile Phone Whilst Driving | None | ASTON WEBB, SELLY OAK | Aston Webb, Selly Oak | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468669 | -1.9397041 | ||
| 18789 | op-snap---monthly-publication-may-2025.pdf | 151 | 2025-05 | Pedal Bike | Mini | One | Grey | Using a Mobile Phone Whilst Driving | None | Shenley Lane | Shenley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.430111 | -1.9753703 | ||
| 18792 | op-snap---monthly-publication-may-2025.pdf | 154 | 2025-05 | Pedal Bike | Mercedes-Benz | G63.. | Black | Using a Mobile Phone Whilst Driving | None | Masshouse Lane | Masshouse Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4072996 | -1.9273914 | ||
| 18875 | op-snap---monthly-publication-may-2025.pdf | 237 | 2025-05 | Pedal Bike | Renault | clio | Red | Using a Mobile Phone Whilst Driving | none | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 18963 | op-snap---monthly-publication-may-2025.pdf | 325 | 2025-05 | Pedal Bike | Peugeot | 408 | Blue | Using a Mobile Phone Whilst Driving | None | Highgate Middleway | Highgate Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4661171 | -1.8832818 | ||
| 18974 | op-snap---monthly-publication-may-2025.pdf | 336 | 2025-05 | Pedal Bike | Toyota | Prius | Grey | Using a Mobile Phone Whilst Driving | None | Northfield Rd | Northfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4167654 | -1.9411244 | ||
| 18979 | op-snap---monthly-publication-may-2025.pdf | 341 | 2025-05 | Pedal Bike | Volkswagen | Passat | Grey | Using a Mobile Phone Whilst Driving | None | Myvod Road | Myvod Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.562989 | -2.0085973 | ||
| 19012 | op-snap---monthly-publication-may-2025.pdf | 374 | 2025-05 | Pedal Bike | Toyota | VERSO | Silver | Using a Mobile Phone Whilst Driving | None | OXFORD ROAD | Oxford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4456323 | -1.8858352 | ||
| 19013 | op-snap---monthly-publication-may-2025.pdf | 375 | 2025-05 | Pedal Bike | Citroen | C4 | Black | Using a Mobile Phone Whilst Driving | None | OXFORD ROAD | Oxford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4456323 | -1.8858352 | ||
| 19109 | op-snap---monthly-publication-may-2025.pdf | 471 | 2025-05 | Pedal Bike | Mercedes-Benz | 180 | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 19124 | op-snap---monthly-publication-may-2025.pdf | 486 | 2025-05 | Pedal Bike | Suzuki | Ignis | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 19170 | op-snap---monthly-publication-may-2025.pdf | 532 | 2025-05 | Pedal Bike | Volvo | XC40 | Silver | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 19172 | op-snap---monthly-publication-may-2025.pdf | 534 | 2025-05 | Pedal Bike | Nissan | E-nV200 | White | Using a Mobile Phone Whilst Driving | None | Highgate Middleway | Highgate Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4661171 | -1.8832818 | ||
| 19259 | op-snap---monthly-publication-may-2025.pdf | 621 | 2025-05 | Pedal Bike | Volkswagen | T Roc.. | White | Using a Mobile Phone Whilst Driving | None | Elmdon Road | Elmdon Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4418657 | -1.9240253 | ||
| 19261 | op-snap---monthly-publication-may-2025.pdf | 623 | 2025-05 | Pedal Bike | Audi | A3..` | Black | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Offence | 52.4308271 | -1.920078 | ||
| 19274 | op-snap---monthly-publication-may-2025.pdf | 636 | 2025-05 | Pedal Bike | BMW | 116I | White | Using a Mobile Phone Whilst Driving | None | Harborne High St | Harborne High Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.459563 | -1.946922 | ||
| 19275 | op-snap---monthly-publication-may-2025.pdf | 637 | 2025-05 | Pedal Bike | BMW | X4 | Blue | Using a Mobile Phone Whilst Driving | Use vehicle on a road | wHiitghho uStt rveaelitd test certificate | w Hiitghho u Stt rveaelitd test certificate | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19287 | op-snap---monthly-publication-may-2025.pdf | 649 | 2025-05 | Pedal Bike | Toyota | Yaris | Black | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 19288 | op-snap---monthly-publication-may-2025.pdf | 650 | 2025-05 | Pedal Bike | Honda | Civic | Blue | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Offence | 52.4470686 | -1.8880749 | ||
| 19304 | op-snap---monthly-publication-may-2025.pdf | 666 | 2025-05 | Pedal Bike | Honda | Civic | Silver | Using a Mobile Phone Whilst Driving | None | Oxford Road | Oxford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4456323 | -1.8858352 | ||
| 19327 | op-snap---monthly-publication-may-2025.pdf | 689 | 2025-05 | Pedal Bike | Volkswagen | Golf | White | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4134557 | -1.4442138 | ||
| 19329 | op-snap---monthly-publication-may-2025.pdf | 691 | 2025-05 | Pedal Bike | Suzuki | Alto | Red | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 19330 | op-snap---monthly-publication-may-2025.pdf | 692 | 2025-05 | Pedal Bike | Vauxhall | Corsa | Black | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 19331 | op-snap---monthly-publication-may-2025.pdf | 693 | 2025-05 | Pedal Bike | Audi | A6 | Grey | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 19443 | op-snap---monthly-publication-may-2025.pdf | 805 | 2025-05 | Pedal Bike | Vauxhall | Adam | Blue | Using a Mobile Phone Whilst Driving | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 | ||
| 19531 | op-snap---monthly-publication-may-2025.pdf | 893 | 2025-05 | Pedal Bike | Audi | Etron | Black | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 19533 | op-snap---monthly-publication-may-2025.pdf | 895 | 2025-05 | Pedal Bike | Volkswagen | Tiguan | Black | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 19534 | op-snap---monthly-publication-may-2025.pdf | 896 | 2025-05 | Pedal Bike | Audi | A3 | Black | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 19625 | op-snap---monthly-publication-may-2025.pdf | 987 | 2025-05 | Pedal Bike | Volkswagen | Golf | Black | Using a Mobile Phone Whilst Driving | None | Bearwood Road | Bearwood Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.4725977 | -1.9684448 | ||
| 19669 | op-snap---monthly-publication-may-2025.pdf | 1031 | 2025-05 | Pedal Bike | Audi | SQ2 | Black | Using a Mobile Phone Whilst Driving | None | Tile Cross Road | Tile Cross Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4792894 | -1.7605934 | ||
| 19674 | op-snap---monthly-publication-may-2025.pdf | 1036 | 2025-05 | Pedal Bike | Toyota | Aygo | Red | Using a Mobile Phone Whilst Driving | None | New Union Street | New Union Street | Coventry | Coventry | Fixed Penalty | N/A | 52.4048717 | -1.5098536 | ||
| 19679 | op-snap---monthly-publication-may-2025.pdf | 1041 | 2025-05 | Pedal Bike | Ford | Puma | Grey | Using a Mobile Phone Whilst Driving | None | Broad Lane | Broad Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4074716 | -1.5620671 | ||
| 19680 | op-snap---monthly-publication-may-2025.pdf | 1042 | 2025-05 | Pedal Bike | Audi | A5 | Silver | Using a Mobile Phone Whilst Driving | None | Meriden Road | Meriden Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4233575 | -1.4380372 | ||
| 19915 | op-snap---monthly-publication-may-2025.pdf | 1277 | 2025-05 | Pedal Bike | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | JTC New strreet/frogmill road | JTC New strreet/frogmill road | Birmingham | Birmingham | NFA | Out of Force | ||||
| 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 | ||
| 20052 | op-snap---monthly-publication-may-2025.pdf | 1414 | 2025-05 | Pedal Bike | golf | Grey | Using a Mobile Phone Whilst Driving | None | Smallbrook queensway | Smallbrook queensway | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4772584 | -1.8965734 | |||
| 20142 | op-snap---monthly-publication-may-2025.pdf | 1504 | 2025-05 | Pedal Bike | Hyundai | Getz | Silver | Using a Mobile Phone Whilst Driving | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4943878 | -1.8504211 | ||
| 20143 | op-snap---monthly-publication-may-2025.pdf | 1505 | 2025-05 | Pedal Bike | BMW | 218I | Black | Using a Mobile Phone Whilst Driving | None | salisbury road | Salisbury Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4943878 | -1.8504211 | ||
| 20145 | op-snap---monthly-publication-may-2025.pdf | 1507 | 2025-05 | Pedal Bike | BMW | 118i | Silver | Using a Mobile Phone Whilst Driving | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4943878 | -1.8504211 | ||
| 20151 | op-snap---monthly-publication-may-2025.pdf | 1513 | 2025-05 | Pedal Bike | Volkswagen | Golf | Grey | Using a Mobile Phone Whilst Driving | None | Kings Road | Kings Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5531351 | -1.8852761 | ||
| 20174 | op-snap---monthly-publication-may-2025.pdf | 1536 | 2025-05 | Pedal Bike | Red | Using a Mobile Phone Whilst Driving | None | Selly Oak Road | Selly Oak Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4263875 | -1.9397954 | ||||
| 20335 | op-snap---monthly-publication-may-2025.pdf | 1697 | 2025-05 | Pedal Bike | Mercedes-Benz | C200 | Grey | Using a Mobile Phone Whilst Driving | None | Harborne High Street | Harborne High Street | Birmingham | Birmingham | Warning Letter | N/A | 52.459563 | -1.946922 | ||
| 20457 | op-snap---monthly-publication-may-2025.pdf | 1819 | 2025-05 | Pedal Bike | Ford | TRANSIT | White | Using a Mobile Phone Whilst Driving | None | Hereford Close, Frankley | Hereford Close, Frankley | Birmingham | Birmingham | Warning Letter | N/A | 52.4047807 | -2.0101216 |
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);