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'}
243 rows where month = "2026-02" 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 >30
offence 15
- Driving without Due Care and Attention 122
- Using a Mobile Phone Whilst Driving 57
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 26
- Contravening a Red Traffic Light 13
- Stop a vehicle within pelican pedestrian crossing limits 9
- Stop a vehicle on pedestrian crossing 6
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Cause vehicle to be left in a dangerous position 1
- Contravene Lane Closure Red X 1
- Driving without Reasonable Consideration 1
- Duplicate Submission 1
- Fail to display front VRM plate 1
- Misc - Non Traffic Offences 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- No Insurance 1
council_area 10
- Birmingham 141
- Coventry 58
- Solihull 16
- Sutton Coldfield 7
- Dudley 6
- Wolverhampton 5
- Out of Force Area 4
- Sandwell 3
- Halesowen 2
- Walsall 1
disposal 6
- Education 98
- Fixed Penalty 59
- Warning Letter 40
- NFA 31
- Court 12
- Duplicate Submission 3
reporter_transport_mode 1
- Pedal Bike · 243 ✖
month 1
- 2026-02 · 243 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7275 | op-snap---monthly-publication-february-2026.pdf | 22 | 2026-02 | Pedal Bike | Audi | Silver | Driving without Due Care and Attention | None | B4101 Spring Lane | Spring Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 7293 | op-snap---monthly-publication-february-2026.pdf | 40 | 2026-02 | Pedal Bike | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4119174 | -1.9735247 | ||
| 7294 | op-snap---monthly-publication-february-2026.pdf | 41 | 2026-02 | Pedal Bike | Mercedes-Benz | Sprinter | White | Cause vehicle to be left in a dangerous position | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Education | N/A | 52.4119174 | -1.9735247 | ||
| 7295 | op-snap---monthly-publication-february-2026.pdf | 42 | 2026-02 | Pedal Bike | Toyota | Corolla | Grey | Using a Mobile Phone Whilst Driving | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4390303 | -1.9512931 | ||
| 7297 | op-snap---monthly-publication-february-2026.pdf | 44 | 2026-02 | Pedal Bike | Toyota | Prius | Red | Driving without Due Care and Attention | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Education | N/A | 52.4150779 | -1.930901 | ||
| 7298 | op-snap---monthly-publication-february-2026.pdf | 45 | 2026-02 | Pedal Bike | Peugeot | 3008 | Grey | Driving without Due Care and Attention | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Education | N/A | 52.4150779 | -1.930901 | ||
| 7299 | op-snap---monthly-publication-february-2026.pdf | 46 | 2026-02 | Pedal Bike | Toyota | Auris | Brown | Driving without Due Care and Attention | None | Franklin Road | Franklin Road | Birmingham | Birmingham | Education | N/A | 52.4195456 | -1.9350703 | ||
| 7301 | op-snap---monthly-publication-february-2026.pdf | 48 | 2026-02 | Pedal Bike | Mercedes-Benz | GL350 | White | Contravening a Red Traffic Light | None | Penn Road | Penn Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5599616 | -2.1556338 | ||
| 7305 | op-snap---monthly-publication-february-2026.pdf | 52 | 2026-02 | Pedal Bike | BMW | Black | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Education | N/A | 52.4415108 | -1.8971434 | |||
| 7309 | op-snap---monthly-publication-february-2026.pdf | 56 | 2026-02 | Pedal Bike | Nissan | Qashqai | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4306504 | -1.878052 | ||
| 7312 | op-snap---monthly-publication-february-2026.pdf | 59 | 2026-02 | Pedal Bike | BMW | 218i | Blue | Driving without Due Care and Attention | None | Bird Street at White Street | Bird Street at White Street | Coventry | Coventry | Education | N/A | 52.4124171 | -1.5065021 | ||
| 7330 | op-snap---monthly-publication-february-2026.pdf | 77 | 2026-02 | Pedal Bike | Ford | Focus | Grey | Driving without Due Care and Attention | None | Trittiford Road | Trittiford Road | Birmingham | Birmingham | Education | N/A | 52.4248084 | -1.8660294 | ||
| 7334 | op-snap---monthly-publication-february-2026.pdf | 81 | 2026-02 | Pedal Bike | Ford | Fiesta | Silver | Using a Mobile Phone Whilst Driving | None | Church Road | Church Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4624743 | -1.7763934 | ||
| 7353 | op-snap---monthly-publication-february-2026.pdf | 100 | 2026-02 | Pedal Bike | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 7358 | op-snap---monthly-publication-february-2026.pdf | 105 | 2026-02 | Pedal Bike | Mercedes-Benz | E220 | Black | Using a Mobile Phone Whilst Driving | None | Norfolk Road | Norfolk Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4672547 | -1.9435381 | ||
| 7359 | op-snap---monthly-publication-february-2026.pdf | 106 | 2026-02 | Pedal Bike | Ford | Focus | Silver | Driving without Due Care and Attention | None | Greens Road | Greens Road | Coventry | Coventry | Education | N/A | 52.4381927 | -1.5291209 | ||
| 7360 | op-snap---monthly-publication-february-2026.pdf | 107 | 2026-02 | Pedal Bike | Vauxhall | Astra | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 7364 | op-snap---monthly-publication-february-2026.pdf | 111 | 2026-02 | Pedal Bike | Volkswagen | Golf R | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4695793 | -1.9378608 | ||
| 7366 | op-snap---monthly-publication-february-2026.pdf | 113 | 2026-02 | Pedal Bike | Volkswagen | polo | Grey | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 7376 | op-snap---monthly-publication-february-2026.pdf | 123 | 2026-02 | Pedal Bike | Hyundai | Ioniq | Black | Stop a vehicle on pedestrian crossing | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Education | N/A | 52.3988977 | -1.5323674 | ||
| 7380 | op-snap---monthly-publication-february-2026.pdf | 127 | 2026-02 | Pedal Bike | Honda | Civic | Grey | Driving without Due Care and Attention | None | War Lane | War Lane | Birmingham | Birmingham | Education | N/A | 52.4569552 | -1.9616483 | ||
| 7381 | op-snap---monthly-publication-february-2026.pdf | 128 | 2026-02 | Pedal Bike | Volvo | V60 | Black | Driving without Due Care and Attention | None | War Lane | War Lane | Birmingham | Birmingham | Education | N/A | 52.4569552 | -1.9616483 | ||
| 7382 | op-snap---monthly-publication-february-2026.pdf | 129 | 2026-02 | Pedal Bike | Seat | Arona | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4591339 | -1.9601054 | ||
| 7383 | op-snap---monthly-publication-february-2026.pdf | 130 | 2026-02 | Pedal Bike | Mercedes-Benz | 180 | Grey | Driving without Due Care and Attention | None | Weoley Castle | Weoley Castle | Birmingham | Birmingham | Education | N/A | 52.4428373 | -1.9698276 | ||
| 7384 | op-snap---monthly-publication-february-2026.pdf | 131 | 2026-02 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 7389 | op-snap---monthly-publication-february-2026.pdf | 136 | 2026-02 | Pedal Bike | Ford | Mondeo | Grey | Driving without Due Care and Attention | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 7396 | op-snap---monthly-publication-february-2026.pdf | 143 | 2026-02 | Pedal Bike | Peugeot | 3008 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lustone Road | Lustone Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 7398 | op-snap---monthly-publication-february-2026.pdf | 145 | 2026-02 | Pedal Bike | Hyundai | I30.. | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Marys Row Moseley | Street Marys Row Moseley | Birmingham | Birmingham | Education | N/A | ||||
| 7399 | op-snap---monthly-publication-february-2026.pdf | 146 | 2026-02 | Pedal Bike | Volkswagen | Polo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 7400 | op-snap---monthly-publication-february-2026.pdf | 147 | 2026-02 | Pedal Bike | BMW | I4 | Grey | Using a Mobile Phone Whilst Driving | None | Granville Street | Granville Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4762076 | -1.9124263 | ||
| 7401 | op-snap---monthly-publication-february-2026.pdf | 148 | 2026-02 | Pedal Bike | Audi | Q3 | Grey | Using a Mobile Phone Whilst Driving | None | Homer Road | Homer Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4103123 | -1.7790808 | ||
| 7402 | op-snap---monthly-publication-february-2026.pdf | 149 | 2026-02 | Pedal Bike | Mg | 5 | Blue | Using a Mobile Phone Whilst Driving | None | Homer Road | Homer Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4103123 | -1.7790808 | ||
| 7419 | op-snap---monthly-publication-february-2026.pdf | 166 | 2026-02 | Pedal Bike | Volvo | XC60 | White | Driving without Due Care and Attention | None | Bournville Lane | Bournville Lane | Birmingham | Birmingham | Education | N/A | 52.4271614 | -1.9302862 | ||
| 7426 | op-snap---monthly-publication-february-2026.pdf | 173 | 2026-02 | Pedal Bike | Toyota | Estima | Silver | Driving without Due Care and Attention | None | Weoley Park Road | Weoley Park Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4368136 | -1.9495478 | ||
| 7427 | op-snap---monthly-publication-february-2026.pdf | 174 | 2026-02 | Pedal Bike | Chysler | Grand Voyager | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Court | N/A | 52.4203897 | -1.8338574 | ||
| 7429 | op-snap---monthly-publication-february-2026.pdf | 176 | 2026-02 | Pedal Bike | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 7430 | op-snap---monthly-publication-february-2026.pdf | 177 | 2026-02 | Pedal Bike | Mg | ZR | Black | Driving without Due Care and Attention | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4390303 | -1.9512931 | ||
| 7442 | op-snap---monthly-publication-february-2026.pdf | 189 | 2026-02 | Pedal Bike | Mercedes-Benz | E220 | Silver | Driving without Due Care and Attention | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Court | N/A | 52.4708802 | -1.8792135 | ||
| 7454 | op-snap---monthly-publication-february-2026.pdf | 201 | 2026-02 | Pedal Bike | Volkswagen | Tayron | Grey | Driving without Due Care and Attention | None | Hallam Street | Hallam Street | Birmingham | Birmingham | Education | N/A | 52.4563937 | -1.8933429 | ||
| 7468 | op-snap---monthly-publication-february-2026.pdf | 215 | 2026-02 | Pedal Bike | Audi | A5 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 7470 | op-snap---monthly-publication-february-2026.pdf | 217 | 2026-02 | Pedal Bike | Kia | Rio | Blue | Driving without Due Care and Attention | None | Ansty Road | Ansty Road | Coventry | Coventry | Education | N/A | 52.4205675 | -1.4520187 | ||
| 7482 | op-snap---monthly-publication-february-2026.pdf | 229 | 2026-02 | Pedal Bike | Citroen | C8 | Blue | Driving without Due Care and Attention | None | Ashwood Road (Worcs) | Ashwood Road (Worcs) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7498 | op-snap---monthly-publication-february-2026.pdf | 245 | 2026-02 | Pedal Bike | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Westwood WAY | Westwood WAY | Coventry | Coventry | Education | N/A | 52.3880214 | -1.5797132 | ||
| 7499 | op-snap---monthly-publication-february-2026.pdf | 246 | 2026-02 | Pedal Bike | Audi | A3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4708802 | -1.8792135 | ||
| 7514 | op-snap---monthly-publication-february-2026.pdf | 261 | 2026-02 | Pedal Bike | Volkswagen | Golf | Silver | Driving without Due Care and Attention | None | Ridgacre Road | Ridgacre Road | Birmingham | Birmingham | Education | N/A | 52.4593367 | -2.0000298 | ||
| 7517 | op-snap---monthly-publication-february-2026.pdf | 264 | 2026-02 | Pedal Bike | Jaguar | i-Pace | Black | Driving without Due Care and Attention | None | South Road, Stourbridge | South Road, Stourbridge | Dudley | Dudley | Education | N/A | 52.4530371 | -2.1660216 | ||
| 7528 | op-snap---monthly-publication-february-2026.pdf | 275 | 2026-02 | Pedal Bike | Audi | SQ5 | Blue | Contravening a Red Traffic Light | None | Longmore Street | Longmore Street | Birmingham | Birmingham | Education | N/A | 52.464484 | -1.8923374 | ||
| 7536 | op-snap---monthly-publication-february-2026.pdf | 283 | 2026-02 | Pedal Bike | Mercedes-Benz | ML320 | Black | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 7538 | op-snap---monthly-publication-february-2026.pdf | 285 | 2026-02 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Education | N/A | 52.418488 | -1.5472387 | ||
| 7539 | op-snap---monthly-publication-february-2026.pdf | 286 | 2026-02 | Pedal Bike | Mercedes-Benz | Brown | Using a Mobile Phone Whilst Driving | None | Alceseter Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | |||
| 7540 | op-snap---monthly-publication-february-2026.pdf | 287 | 2026-02 | Pedal Bike | Mazda | 2 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 7541 | op-snap---monthly-publication-february-2026.pdf | 288 | 2026-02 | Pedal Bike | Ford | Fiesta | Blue | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 7542 | op-snap---monthly-publication-february-2026.pdf | 289 | 2026-02 | Pedal Bike | Volkswagen | Golf | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 7543 | op-snap---monthly-publication-february-2026.pdf | 290 | 2026-02 | Pedal Bike | Honda | Civic | White | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 7544 | op-snap---monthly-publication-february-2026.pdf | 291 | 2026-02 | Pedal Bike | Kia | Ceed | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 7545 | op-snap---monthly-publication-february-2026.pdf | 292 | 2026-02 | Pedal Bike | Seat | Leon | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 7548 | op-snap---monthly-publication-february-2026.pdf | 295 | 2026-02 | Pedal Bike | Land Rover | Range Rover | Black | Using a Mobile Phone Whilst Driving | No Insurance | Five ways Island | Five ways Island | Birmingham | Birmingham | Court | N/A | ||||
| 7549 | op-snap---monthly-publication-february-2026.pdf | 296 | 2026-02 | Pedal Bike | Mini | Mini | Blue | Using a Mobile Phone Whilst Driving | None | New Fosse Way | New Fosse Way | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4473373 | -1.9392405 | ||
| 7550 | op-snap---monthly-publication-february-2026.pdf | 297 | 2026-02 | Pedal Bike | BMW | IX | Grey | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4591339 | -1.9601054 | ||
| 7553 | op-snap---monthly-publication-february-2026.pdf | 300 | 2026-02 | Pedal Bike | Seat | Leon | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Braford Street | Braford Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7554 | op-snap---monthly-publication-february-2026.pdf | 301 | 2026-02 | Pedal Bike | Toyota | Yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Braford Street | Braford Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7555 | op-snap---monthly-publication-february-2026.pdf | 302 | 2026-02 | Pedal Bike | Ford | Transit | Orange | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Braford Street | Braford Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7557 | op-snap---monthly-publication-february-2026.pdf | 304 | 2026-02 | Pedal Bike | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 7558 | op-snap---monthly-publication-february-2026.pdf | 305 | 2026-02 | Pedal Bike | Audi | A3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 7559 | op-snap---monthly-publication-february-2026.pdf | 306 | 2026-02 | Pedal Bike | Audi | a3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.4708802 | -1.8792135 | ||
| 7560 | op-snap---monthly-publication-february-2026.pdf | 307 | 2026-02 | Pedal Bike | Volkswagen | Golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4708802 | -1.8792135 | ||
| 7561 | op-snap---monthly-publication-february-2026.pdf | 308 | 2026-02 | Pedal Bike | Citroen | C3 | Grey | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4470686 | -1.8880749 | ||
| 7562 | op-snap---monthly-publication-february-2026.pdf | 309 | 2026-02 | Pedal Bike | Kia | Ceed | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4708802 | -1.8792135 | ||
| 7563 | op-snap---monthly-publication-february-2026.pdf | 310 | 2026-02 | Pedal Bike | Seat | Leon | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4708802 | -1.8792135 | ||
| 7564 | op-snap---monthly-publication-february-2026.pdf | 311 | 2026-02 | Pedal Bike | Seat | Leon | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4708802 | -1.8792135 | ||
| 7577 | op-snap---monthly-publication-february-2026.pdf | 324 | 2026-02 | Pedal Bike | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | Bromyard Road | Bromyard Road | Birmingham | Birmingham | Education | N/A | 52.4457403 | -1.8536648 | ||
| 7578 | op-snap---monthly-publication-february-2026.pdf | 325 | 2026-02 | Pedal Bike | Nissan | Note | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Albany Road | Albany Road | Coventry | Coventry | Education | N/A | 52.4006218 | -1.5284125 | ||
| 7595 | op-snap---monthly-publication-february-2026.pdf | 342 | 2026-02 | Pedal Bike | BMW | X1.. | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4119174 | -1.9735247 | ||
| 7631 | op-snap---monthly-publication-february-2026.pdf | 378 | 2026-02 | Pedal Bike | Mercedes-Benz | GLA 200 | Grey | Contravening a Red Traffic Light | None | Mere Green Road | Mere Green Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5874888 | -1.8297106 | ||
| 7632 | op-snap---monthly-publication-february-2026.pdf | 379 | 2026-02 | Pedal Bike | Seat | Leon | Silver | Driving without Due Care and Attention | None | Woodstock Road | Woodstock Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3919059 | -1.5026146 | ||
| 7648 | op-snap---monthly-publication-february-2026.pdf | 395 | 2026-02 | Pedal Bike | Toyota | yaris | White | Using a Mobile Phone Whilst Driving | None | A45 | A45 | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 7651 | op-snap---monthly-publication-february-2026.pdf | 398 | 2026-02 | Pedal Bike | BMW | 640D | Blue | Using a Mobile Phone Whilst Driving | None | A429 nr A45 | A429 nr A45 | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 7652 | op-snap---monthly-publication-february-2026.pdf | 399 | 2026-02 | Pedal Bike | Mercedes-Benz | A180 | Grey | Using a Mobile Phone Whilst Driving | None | Bell Green Road nr A444 | Bell Green Road nr A444 | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 7653 | op-snap---monthly-publication-february-2026.pdf | 400 | 2026-02 | Pedal Bike | Peugeot | 208 Tech | Red | Using a Mobile Phone Whilst Driving | None | A45 nr A429 | A45 nr A429 | Coventry | Coventry | Fixed Penalty | N/A | 52.3791309 | -1.4740067 | ||
| 7654 | op-snap---monthly-publication-february-2026.pdf | 401 | 2026-02 | Pedal Bike | Peugeot | 308 S | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 7655 | op-snap---monthly-publication-february-2026.pdf | 402 | 2026-02 | Pedal Bike | Vauxhall | Astra | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 7682 | op-snap---monthly-publication-february-2026.pdf | 429 | 2026-02 | Pedal Bike | Land Rover | Discovery | Brown | Driving without Due Care and Attention | None | Redhill Road | Redhill Road | Birmingham | Birmingham | Education | N/A | 52.4618364 | -1.8328803 | ||
| 7694 | op-snap---monthly-publication-february-2026.pdf | 441 | 2026-02 | Pedal Bike | Audi | A5 | Black | Using a Mobile Phone Whilst Driving | None | Park Lane | Park Lane | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5687807 | -2.0165653 | ||
| 7696 | op-snap---monthly-publication-february-2026.pdf | 443 | 2026-02 | Pedal Bike | Mercedes-Benz | A Class | Silver | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Warning Letter | N/A | 52.4041117 | -1.5595662 | ||
| 7697 | op-snap---monthly-publication-february-2026.pdf | 444 | 2026-02 | Pedal Bike | Kia | Sportage | Silver | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Warning Letter | N/A | 52.4041117 | -1.5595662 | ||
| 7699 | op-snap---monthly-publication-february-2026.pdf | 446 | 2026-02 | Pedal Bike | Mercedes-Benz | Sprinter | white | Driving without Due Care and Attention | None | Broad Lane, Tile Hill | Broad Lane, Tile Hill | Coventry | Coventry | Education | N/A | 52.4112706 | -1.5792697 | ||
| 7700 | op-snap---monthly-publication-february-2026.pdf | 447 | 2026-02 | Pedal Bike | Kia | Niro | White | Driving without Due Care and Attention | None | Bloomfield Road, Earlsdon | Bloomfield Road, Earlsdon | Coventry | Coventry | Education | N/A | ||||
| 7701 | op-snap---monthly-publication-february-2026.pdf | 448 | 2026-02 | Pedal Bike | Skoda | Fabia | Grey | Driving without Due Care and Attention | None | Hampton Lane | Hampton Lane | Solihull | Solihull | Warning Letter | N/A | 52.4190728 | -1.7449943 | ||
| 7714 | op-snap---monthly-publication-february-2026.pdf | 461 | 2026-02 | Pedal Bike | BMW | M3 | Red | Fail to display front VRM plate | None | Watford Road | Watford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4182952 | -1.9316395 | ||
| 7772 | op-snap---monthly-publication-february-2026.pdf | 519 | 2026-02 | Pedal Bike | Volkswagen | Transporter | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Woodfield Avenue | Woodfield Avenue | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5668728 | -2.1489012 | ||
| 7783 | op-snap---monthly-publication-february-2026.pdf | 530 | 2026-02 | Pedal Bike | Mercedes-Benz | 180 | White | Driving without Due Care and Attention | None | Cornetts End Lane | Cornetts End Lane | Solihull | Solihull | Education | N/A | ||||
| 7785 | op-snap---monthly-publication-february-2026.pdf | 532 | 2026-02 | Pedal Bike | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | High Street, Hampton in Arden | High Street, Hampton in Arden | Solihull | Solihull | NFA | No Offence | 52.4291828 | -1.7000245 | ||
| 7786 | op-snap---monthly-publication-february-2026.pdf | 533 | 2026-02 | Pedal Bike | Citroen | Nemo | Blue | Driving without Due Care and Attention | None | Linthouse Lane | Linthouse Lane | Wolverhampton | Wolverhampton | Education | N/A | 52.6118187 | -2.0810618 | ||
| 7789 | op-snap---monthly-publication-february-2026.pdf | 536 | 2026-02 | Pedal Bike | Vauxhall | Corsa | Blue | No Insurance | None | Wood End Road | Wood End Road | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | 52.605993 | -2.0805938 | ||
| 7796 | op-snap---monthly-publication-february-2026.pdf | 543 | 2026-02 | Pedal Bike | Mitsubishi | Colt | Silver | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 7821 | op-snap---monthly-publication-february-2026.pdf | 568 | 2026-02 | Pedal Bike | Mercedes-Benz | Lorry | Blue | Driving without Due Care and Attention | None | Grange Hill, near Manor Way roundabout, Halesowen | Grange Hill, near Manor Way roundabout, Halesowen | Halesowen | Halesowen | Fixed Penalty | N/A | 52.4417713 | -2.0434182 | ||
| 7828 | op-snap---monthly-publication-february-2026.pdf | 575 | 2026-02 | Pedal Bike | Toyota | CHR | Silver | Driving without Due Care and Attention | None | Hagley Causeway, Halesowen | Hagley Causeway, Halesowen | Halesowen | Halesowen | Fixed Penalty | N/A | 52.4349292 | -2.0850774 | ||
| 7831 | op-snap---monthly-publication-february-2026.pdf | 578 | 2026-02 | Pedal Bike | Daf | White | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | NFA | No Offence | 52.4103629 | -1.5441218 | |||
| 7833 | op-snap---monthly-publication-february-2026.pdf | 580 | 2026-02 | Pedal Bike | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Corporation Street | Corporation Street | Coventry | Coventry | Education | N/A | 52.4086244 | -1.515132 | ||
| 7839 | op-snap---monthly-publication-february-2026.pdf | 586 | 2026-02 | Pedal Bike | Skoda | Octavia | Blue | Driving without Due Care and Attention | No Insurance | Dads Lane | Dads Lane | Birmingham | Birmingham | Court | N/A | 52.4375913 | -1.9068522 |
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);