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'}
2,150 rows where council_area = "Birmingham" and reporter_transport_mode = "Pedal Bike" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale, witness_contacted
vehicle_make >30
- Ford 242
- Mercedes-Benz 217
- Volkswagen 209
- Audi 168
- Toyota 166
- BMW 157
- Vauxhall 123
- Nissan 79
- Peugeot 66
- Seat 65
- Hyundai 59
- Skoda 54
- Renault 51
- Kia 49
- Honda 47
- Land Rover 47
- Citroen 35
- Volvo 33
- Fiat 27
- Mini 22
- Porsche 22
- Tesla 22
- Mazda 21
- Jaguar 16
- Mg 14
- Suzuki 13
- Lexus 12
- Mitsubishi 9
- Daf 7
- Lamborghini 6
- …
offence 30
- Driving without Due Care and Attention 643
- Using a Mobile Phone Whilst Driving 603
- Driving without Reasonable Consideration 399
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 166
- Contravening a Red Traffic Light 75
- Cause vehicle to be left in a dangerous position 73
- Stop a vehicle within pelican pedestrian crossing limits 46
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 28
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 22
- Misc - Non Traffic Offences 18
- Stop a vehicle on pedestrian crossing 15
- Fail to Conform to Cycle Lane 9
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 8
- Contravene Lane Closure Red X 4
- Driver not in position to have Proper Control 4
- Fail to display front VRM plate 4
- Motor vehicle fail to comply with a non endorsab 4
- No Insurance 4
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 4
- Vehicle overtake within crossing limits 4
- Cause unnecessary obstruction by motor vehicle 3
- Duplicate Submission 3
- Driving a vehicle wholly or partly on a footpath 2
- Motor vehicle fail to accord precedence at a pelican crossing 2
- Use vehicle on a road without valid test certificate 2
- Fail to display rear VRM plate 1
- Motor vehicle fail to comply with endorsable sect 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
- No Seat Belt 1
- VRM fails to conform to Regulations 1
month 14
disposal 8
- Fixed Penalty 708
- Education 498
- NFA 496
- Warning Letter 352
- Court 85
- Duplicate Submission 6
- Other Action Taken 4
- Taken 1
reporter_transport_mode 1
- Pedal Bike · 2,150 ✖
council_area 1
- Birmingham · 2,150 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 7841 | op-snap---monthly-publication-february-2026.pdf | 588 | 2026-02 | Pedal Bike | Kia | Sport | White | Driving without Due Care and Attention | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Education | N/A | 52.4656414 | -1.9852276 | ||
| 7843 | op-snap---monthly-publication-february-2026.pdf | 590 | 2026-02 | Pedal Bike | Toyota | Prius | Black | Driving without Due Care and Attention | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | Education | N/A | 52.4391028 | -1.893289 | ||
| 7849 | op-snap---monthly-publication-february-2026.pdf | 596 | 2026-02 | Pedal Bike | Mercedes-Benz | A180 | Grey | Driving without Due Care and Attention | None | Gillhurst Road | Gillhurst Road | Birmingham | Birmingham | Court | N/A | 52.467676 | -1.9548345 | ||
| 7854 | op-snap---monthly-publication-february-2026.pdf | 601 | 2026-02 | Pedal Bike | Seat | Leon | Black | Contravene Lane Closure Red X | None | Longmore Street | Longmore Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.464484 | -1.8923374 | ||
| 7862 | op-snap---monthly-publication-february-2026.pdf | 609 | 2026-02 | Pedal Bike | Audi | TT | Blue | Driving without Due Care and Attention | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Education | N/A | 52.4656414 | -1.9852276 | ||
| 7866 | op-snap---monthly-publication-february-2026.pdf | 613 | 2026-02 | Pedal Bike | BMW | m3 | Blue | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 7868 | op-snap---monthly-publication-february-2026.pdf | 615 | 2026-02 | Pedal Bike | Audi | Q4 | Grey | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 7869 | op-snap---monthly-publication-february-2026.pdf | 616 | 2026-02 | Pedal Bike | Volvo | XC60 | Red | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 7870 | op-snap---monthly-publication-february-2026.pdf | 617 | 2026-02 | Pedal Bike | Tesla | y | Blue | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 7871 | op-snap---monthly-publication-february-2026.pdf | 618 | 2026-02 | Pedal Bike | Volkswagen | Golf | Blue | Using a Mobile Phone Whilst Driving | None | Harborne High Street | Harborne High Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.459563 | -1.946922 | ||
| 7924 | op-snap---monthly-publication-february-2026.pdf | 671 | 2026-02 | Pedal Bike | Lexus | NX300H | Black | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 7925 | op-snap---monthly-publication-february-2026.pdf | 672 | 2026-02 | Pedal Bike | Renault | Clio | White | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 7946 | op-snap---monthly-publication-february-2026.pdf | 693 | 2026-02 | Pedal Bike | Toyota | Aygo | White | Using a Mobile Phone Whilst Driving | None | Highgate Middleway | Highgate Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4661171 | -1.8832818 | ||
| 7947 | op-snap---monthly-publication-february-2026.pdf | 694 | 2026-02 | Pedal Bike | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | Highgate Middleway | Highgate Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4661171 | -1.8832818 | ||
| 7949 | op-snap---monthly-publication-february-2026.pdf | 696 | 2026-02 | Pedal Bike | Byd | Atto | White | Using a Mobile Phone Whilst Driving | None | Highgate Middleway | Highgate Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4661171 | -1.8832818 | ||
| 7950 | op-snap---monthly-publication-february-2026.pdf | 697 | 2026-02 | Pedal Bike | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Education | N/A | 52.436035 | -1.891685 | ||
| 7951 | op-snap---monthly-publication-february-2026.pdf | 698 | 2026-02 | Pedal Bike | BMW | 118.. | Black | Using a Mobile Phone Whilst Driving | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4103191 | -1.8670224 | ||
| 7953 | op-snap---monthly-publication-february-2026.pdf | 700 | 2026-02 | Pedal Bike | Hyundai | I10. | Red | Using a Mobile Phone Whilst Driving | None | Brook Lane | Brook Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4297007 | -1.8668846 | ||
| 7960 | op-snap---monthly-publication-february-2026.pdf | 707 | 2026-02 | Pedal Bike | Honda | Jazz | Blue | Stop a vehicle on pedestrian crossing | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | Education | N/A | 52.4745488 | -1.8065911 | ||
| 8015 | op-snap---monthly-publication-february-2026.pdf | 762 | 2026-02 | Pedal Bike | Audi | A3 | Green | Driving without Due Care and Attention | None | Pritchatts Road, Edgbaston | Pritchatts Road, Edgbaston | Birmingham | Birmingham | Court | N/A | 52.4563161 | -1.934895 | ||
| 8018 | op-snap---monthly-publication-february-2026.pdf | 765 | 2026-02 | Pedal Bike | Volkswagen | Up | Blue | Using a Mobile Phone Whilst Driving | None | Norfolk Road | Norfolk Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4672547 | -1.9435381 | ||
| 8019 | op-snap---monthly-publication-february-2026.pdf | 766 | 2026-02 | Pedal Bike | Ford | Blue | Using a Mobile Phone Whilst Driving | None | Aston Wedd | Aston Wedd | Birmingham | Birmingham | Fixed Penalty | N/A | |||||
| 8020 | op-snap---monthly-publication-february-2026.pdf | 767 | 2026-02 | Pedal Bike | Mercedes-Benz | E220 | Black | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 8023 | op-snap---monthly-publication-february-2026.pdf | 770 | 2026-02 | Pedal Bike | BMW | 520d | White | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 8040 | op-snap---monthly-publication-february-2026.pdf | 787 | 2026-02 | Pedal Bike | Peugeot | 5008 | Silver | Driving without Due Care and Attention | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Education | N/A | 52.4390303 | -1.9512931 | ||
| 8043 | op-snap---monthly-publication-february-2026.pdf | 790 | 2026-02 | Pedal Bike | Volkswagen | Life | Black | Using a Mobile Phone Whilst Driving | None | Masshouse lane at Wharf Road | Masshouse lane at Wharf Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4072996 | -1.9273914 | ||
| 8044 | op-snap---monthly-publication-february-2026.pdf | 791 | 2026-02 | Pedal Bike | Volkswagen | Life | Black | Duplicate Submission | None | Masshouse Lane | Masshouse Lane | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.4072996 | -1.9273914 | ||
| 8076 | op-snap---monthly-publication-february-2026.pdf | 823 | 2026-02 | Pedal Bike | Toyota | Corolla | Silver | Contravening a Red Traffic Light | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Education | N/A | 52.4591339 | -1.9601054 | ||
| 8077 | op-snap---monthly-publication-february-2026.pdf | 824 | 2026-02 | Pedal Bike | Audi | A3 | Black | Contravening a Red Traffic Light | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Education | N/A | 52.4591339 | -1.9601054 | ||
| 8155 | op-snap---monthly-publication-february-2026.pdf | 902 | 2026-02 | Pedal Bike | Mercedes-Benz | Vito | White | Contravening a Red Traffic Light | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Education | N/A | 52.5113867 | -1.8337258 | ||
| 8159 | op-snap---monthly-publication-february-2026.pdf | 906 | 2026-02 | Pedal Bike | Mercedes-Benz | CLA 180 | White | Stop a vehicle on pedestrian crossing | None | Sycamore Road | Sycamore Road | Birmingham | Birmingham | Education | N/A | 52.5398019 | -1.8455792 | ||
| 8160 | op-snap---monthly-publication-february-2026.pdf | 907 | 2026-02 | Pedal Bike | Mg | ZS | White | Stop a vehicle on pedestrian crossing | None | Sycamore Road | Sycamore Road | Birmingham | Birmingham | Education | N/A | 52.5398019 | -1.8455792 | ||
| 8205 | op-snap---monthly-publication-february-2026.pdf | 952 | 2026-02 | Pedal Bike | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Gibbins Road, Selly Oak | Gibbins Road, Selly Oak | Birmingham | Birmingham | Education | N/A | 52.4390303 | -1.9512931 | ||
| 8206 | op-snap---monthly-publication-february-2026.pdf | 953 | 2026-02 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Bristol Road, Bourneville | Bristol Road, Bourneville | Birmingham | Birmingham | Education | N/A | ||||
| 8207 | op-snap---monthly-publication-february-2026.pdf | 954 | 2026-02 | Pedal Bike | Peugeot | Expert | White | Driving without Due Care and Attention | None | Cock Hill Lane, Rubery | Cock Hill Lane, Rubery | Birmingham | Birmingham | Education | N/A | ||||
| 8227 | op-snap---monthly-publication-february-2026.pdf | 974 | 2026-02 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Clevedon Road, Balsall Heath | Clevedon Road, Balsall Heath | Birmingham | Birmingham | Education | N/A | 52.4618531 | -1.894645 | ||
| 8246 | op-snap---monthly-publication-february-2026.pdf | 993 | 2026-02 | Pedal Bike | Byd | Enviro | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 8282 | op-snap---monthly-publication-february-2026.pdf | 1029 | 2026-02 | Pedal Bike | Audi | A6 | Silver | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Education | N/A | 52.5292752 | -1.7618805 |
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);