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'}
240 rows where council_area = "Birmingham" and vehicle_make = "Kia" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
offence 28
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 53
- Driving without Due Care and Attention 47
- Cause vehicle to be left in a dangerous position 25
- Contravening a Red Traffic Light 22
- Driving without Reasonable Consideration 19
- Using a Mobile Phone Whilst Driving 18
- Stop a vehicle within pelican pedestrian crossing limits 14
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 6
- Contravene Lane Closure Red X 5
- Misc - Non Traffic Offences 5
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 4
- Drive a vehicle other than on the carriageway of a motorway 2
- Driving a vehicle wholly or partly on a footpath 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- No Insurance 2
- Stop a vehicle on pedestrian crossing 2
- / trailer outside of the Greater London area 1
- Cause unnecessary obstruction by motor vehicle 1
- Dangerous Driving 1
- Drive on hard shoulder 1
- Driver not in position to have Proper Control 1
- Fail to Conform to Cycle Lane 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 1
- Motor vehicle fail to comply with solid white line road markings 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Vehicle overtake within crossing limits 1
month 14
disposal 7
- Warning Letter 72
- NFA 70
- Fixed Penalty 47
- Education 43
- Court 5
- Other Action Taken 2
- RTC - Actioned 1
reporter_transport_mode 6
- Car 114
- Pedestrian 64
- Pedal Bike 49
- Other 11
- Lorry 1
- Van 1
vehicle_make 1
- Kia · 240 ✖
council_area 1
- Birmingham · 240 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7287 | op-snap---monthly-publication-february-2026.pdf | 34 | 2026-02 | Pedestrian | Kia | Sportage | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bournville Lane | Bournville Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4271614 | -1.9302862 | ||
| 7288 | op-snap---monthly-publication-february-2026.pdf | 35 | 2026-02 | Pedestrian | Kia | Sportage | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bournville Lane | Bournville Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4271614 | -1.9302862 | ||
| 7315 | op-snap---monthly-publication-february-2026.pdf | 62 | 2026-02 | Other | Kia | Sportage | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5265939 | -1.8509884 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 7896 | op-snap---monthly-publication-february-2026.pdf | 643 | 2026-02 | Other | Kia | Sportage | Black | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Education | N/A | 52.5265939 | -1.8509884 | ||
| 8011 | op-snap---monthly-publication-february-2026.pdf | 758 | 2026-02 | Car | Kia | Ceed | Grey | Contravening a Red Traffic Light | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Education | N/A | 52.5113867 | -1.8337258 | ||
| 8169 | op-snap---monthly-publication-february-2026.pdf | 916 | 2026-02 | Car | Kia | Stonic | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 8212 | op-snap---monthly-publication-february-2026.pdf | 959 | 2026-02 | Pedestrian | Kia | Picanto | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Maitland Road | Maitland Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4868494 | -1.8448776 | ||
| 8221 | op-snap---monthly-publication-february-2026.pdf | 968 | 2026-02 | Other | Kia | Sportage | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5521118 | -1.8845138 | ||
| 8244 | op-snap---monthly-publication-february-2026.pdf | 991 | 2026-02 | Pedestrian | Kia | Ceed | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Education | N/A | ||||
| 8345 | op-snap---monthly-publication-february-2026.pdf | 1092 | 2026-02 | Other | Kia | Sportage | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.5521118 | -1.8845138 | ||
| 8665 | op-snap---monthly-publication-february-2026.pdf | 1412 | 2026-02 | Pedal Bike | Kia | Sportage | Black | Using a Mobile Phone Whilst Driving | None | Lyon Queensway | Lyon Queensway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4785129 | -1.9047486 | ||
| 8686 | op-snap---monthly-publication-february-2026.pdf | 1433 | 2026-02 | Car | Kia | Niro | Grey | Contravening a Red Traffic Light | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | Education | N/A | 52.5012458 | -1.8780942 | ||
| 8832 | op-snap---monthly-publication-february-2026.pdf | 1579 | 2026-02 | Pedestrian | Kia | sportage | Green | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | drapers field | Drapers Field | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8833 | op-snap---monthly-publication-february-2026.pdf | 1580 | 2026-02 | Pedestrian | Kia | ev6 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | station approach | Station Approach | Birmingham | Birmingham | Warning Letter | N/A | 52.6036307 | -1.8446735 | ||
| 8861 | op-snap---monthly-publication-february-2026.pdf | 1608 | 2026-02 | Pedestrian | Kia | ceed | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | bradford street | Bradford Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4708802 | -1.8792135 | ||
| 10555 | op-snap---monthly-publication-january-2026.pdf | 16 | 2026-01 | Car | Kia | Sportage | Silver | Contravene Lane Closure Red X | None | M6 | M6 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 10714 | op-snap---monthly-publication-january-2026.pdf | 175 | 2026-01 | Pedestrian | Kia | Niro | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ellesmere Road | Ellesmere Road | Birmingham | Birmingham | NFA | No Offence | 52.4881533 | -1.8553625 | ||
| 10772 | op-snap---monthly-publication-january-2026.pdf | 233 | 2026-01 | Pedestrian | Kia | Niro | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Elms Rd | Elms Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5560676 | -1.8234017 | ||
| 10842 | op-snap---monthly-publication-january-2026.pdf | 303 | 2026-01 | Car | Kia | Niro | White | Cause vehicle to be left in a dangerous position | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4929304 | -1.8229092 | ||
| 10969 | op-snap---monthly-publication-january-2026.pdf | 430 | 2026-01 | Car | Kia | Sportage | white | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 11030 | op-snap---monthly-publication-january-2026.pdf | 491 | 2026-01 | Car | Kia | Sportage | Black | Driving without Due Care and Attention | None | Hollywell Road | Hollywell Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4594803 | -1.7866201 | ||
| 11089 | op-snap---monthly-publication-january-2026.pdf | 550 | 2026-01 | Other | Kia | Sportage | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 11238 | op-snap---monthly-publication-january-2026.pdf | 699 | 2026-01 | Pedestrian | Kia | Picanto | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bells Lane | Bells Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4053419 | -1.8944602 | ||
| 11270 | op-snap---monthly-publication-january-2026.pdf | 731 | 2026-01 | Car | Kia | Niro | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 11313 | op-snap---monthly-publication-january-2026.pdf | 774 | 2026-01 | Car | Kia | Soul | Black | Driving without Due Care and Attention | None | Bills Lane | Bills Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 11337 | op-snap---monthly-publication-january-2026.pdf | 798 | 2026-01 | Other | Kia | Sportage | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 11400 | op-snap---monthly-publication-january-2026.pdf | 861 | 2026-01 | Pedestrian | Kia | Picanto | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodstock Road | Woodstock Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4486205 | -1.8740822 | ||
| 11402 | op-snap---monthly-publication-january-2026.pdf | 863 | 2026-01 | Pedal Bike | Kia | Sportage | Black | Driving without Due Care and Attention | None | Park Road | Park Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5641687 | -1.8272087 | ||
| 11457 | op-snap---monthly-publication-january-2026.pdf | 918 | 2026-01 | Car | Kia | Stonic | Grey | Driving without Due Care and Attention | None | Dennis Road | Dennis Road | Birmingham | Birmingham | Education | N/A | 52.4524736 | -1.8748228 | ||
| 11552 | op-snap---monthly-publication-january-2026.pdf | 1013 | 2026-01 | Pedal Bike | Kia | Sportage | Grey | Driving without Due Care and Attention | None | Black Haynes Road | Black Haynes Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4260755 | -1.9679443 | ||
| 11568 | op-snap---monthly-publication-january-2026.pdf | 1029 | 2026-01 | Car | Kia | Ceed | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11609 | op-snap---monthly-publication-january-2026.pdf | 1070 | 2026-01 | Car | Kia | Picanto | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 11723 | op-snap---monthly-publication-january-2026.pdf | 1184 | 2026-01 | Pedestrian | Kia | Sportage | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5521118 | -1.8845138 | ||
| 11767 | op-snap---monthly-publication-january-2026.pdf | 1228 | 2026-01 | Van | Kia | Sportage | Green | Driving without Due Care and Attention | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Court | N/A | 52.4198291 | -1.9241732 | ||
| 11789 | op-snap---monthly-publication-january-2026.pdf | 1250 | 2026-01 | Car | Kia | picanto | White | Drive a vehicle other than on the carriageway of a motorway | None | Dartmouth Circus to A38 | Dartmouth Circus to A38 | Birmingham | Birmingham | Education | N/A | ||||
| 11808 | op-snap---monthly-publication-january-2026.pdf | 1269 | 2026-01 | Other | Kia | Ceed | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 11840 | op-snap---monthly-publication-january-2026.pdf | 1301 | 2026-01 | Pedestrian | Kia | Sportage | Black | Driving without Due Care and Attention | No Insurance | Floodgate Street | Floodgate Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4752856 | -1.8858047 | ||
| 11868 | op-snap---monthly-publication-january-2026.pdf | 1329 | 2026-01 | Pedal Bike | Kia | Stonic | White | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 3910 | op-snap---monthly-publication-december-2025.pdf | 38 | 2025-12 | Pedal Bike | Kia | Blue | Driving without Due Care and Attention | None | Woodville Road | Woodville Road | Birmingham | Birmingham | NFA | No Offence | 52.4616763 | -1.9653016 | |||
| 3949 | op-snap---monthly-publication-december-2025.pdf | 77 | 2025-12 | Pedestrian | Kia | Venga | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Braymoor Road | Braymoor Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4756937 | -1.762603 | ||
| 3984 | op-snap---monthly-publication-december-2025.pdf | 112 | 2025-12 | Pedal Bike | Kia | Venga | Silver | Using a Mobile Phone Whilst Driving | None | Stratford Road towards Shirley | Stratford Road towards Shirley | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 4037 | op-snap---monthly-publication-december-2025.pdf | 165 | 2025-12 | Car | Kia | Niro | Black | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 4105 | op-snap---monthly-publication-december-2025.pdf | 233 | 2025-12 | Car | Kia | Niro.. | Black | Driving without Due Care and Attention | None | Hawthorn Road | Hawthorn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5436609 | -1.8214668 | ||
| 4213 | op-snap---monthly-publication-december-2025.pdf | 341 | 2025-12 | Pedestrian | Kia | Picanto | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cranford Street | Cranford Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 4237 | op-snap---monthly-publication-december-2025.pdf | 365 | 2025-12 | Car | Kia | Ceed | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 4339 | op-snap---monthly-publication-december-2025.pdf | 467 | 2025-12 | Car | Kia | sportag | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | haslucks green road | Haslucks Green Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4375 | op-snap---monthly-publication-december-2025.pdf | 503 | 2025-12 | Pedal Bike | Kia | Ceed | Red | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 4448 | op-snap---monthly-publication-december-2025.pdf | 576 | 2025-12 | Car | Kia | Ceed | Red | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | ||
| 4556 | op-snap---monthly-publication-december-2025.pdf | 684 | 2025-12 | Pedal Bike | Kia | Proceed | White | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 4574 | op-snap---monthly-publication-december-2025.pdf | 702 | 2025-12 | Car | Kia | Stinger | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High St, Aston | High Street, Aston | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4973154 | -1.8956143 | ||
| 4617 | op-snap---monthly-publication-december-2025.pdf | 745 | 2025-12 | Car | Kia | carens | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4762 | op-snap---monthly-publication-december-2025.pdf | 890 | 2025-12 | Pedal Bike | Kia | Carens | Silver | Driving without Due Care and Attention | None | Camp Hill Middleway | Camp Hill Middleway | Birmingham | Birmingham | Education | N/A | 52.468339 | -1.8796724 | ||
| 4929 | op-snap---monthly-publication-december-2025.pdf | 1057 | 2025-12 | Pedal Bike | Kia | Picanto | Silver | Driving without Due Care and Attention | None | Russell Road / Edgbaston Road | Russell Road / Edgbaston Road | Birmingham | Birmingham | Education | N/A | 52.4398245 | -1.8469786 | ||
| 4956 | op-snap---monthly-publication-december-2025.pdf | 1084 | 2025-12 | Pedal Bike | Kia | picanto | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | bradford street | Bradford Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4708802 | -1.8792135 | ||
| 4972 | op-snap---monthly-publication-december-2025.pdf | 1100 | 2025-12 | Pedal Bike | Kia | picanto | White | Misc - Non Traffic Offences | None | bradford street | Bradford Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4708802 | -1.8792135 | ||
| 5084 | op-snap---monthly-publication-december-2025.pdf | 1212 | 2025-12 | Car | Kia | Ceed | White | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 5099 | op-snap---monthly-publication-december-2025.pdf | 1227 | 2025-12 | Pedal Bike | Kia | Picanto | White | 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 | ||
| 20688 | op-snap---monthly-publication-november-2025.pdf | 230 | 2025-11 | Pedal Bike | Kia | Sportage | White | Using a Mobile Phone Whilst Driving | None | Harborne High Street | Harborne High Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.459563 | -1.946922 | ||
| 20866 | op-snap---monthly-publication-november-2025.pdf | 408 | 2025-11 | Car | Kia | Picanto | Black | Driving without Due Care and Attention | None | M6 Junction 7 | M6 Junction 7 | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.676119 | -2.0858425 | ||
| 20914 | op-snap---monthly-publication-november-2025.pdf | 456 | 2025-11 | Car | Kia | Niro | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 20942 | op-snap---monthly-publication-november-2025.pdf | 484 | 2025-11 | Pedestrian | Kia | Stonic | Red | No Seat Belt | None | Martineau Drive | Martineau Drive | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4621711 | -1.9776235 | ||
| 20999 | op-snap---monthly-publication-november-2025.pdf | 541 | 2025-11 | Car | Kia | niro | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | hagley road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | ||
| 21022 | op-snap---monthly-publication-november-2025.pdf | 564 | 2025-11 | Pedestrian | Kia | Sportage | Black | No Insurance | None | B37 6JP | B37 6Jp | Birmingham | Birmingham | Warning Letter | N/A | 52.5298147 | -1.7902196 | ||
| 21026 | op-snap---monthly-publication-november-2025.pdf | 568 | 2025-11 | Pedestrian | Kia | Sportage | Silver | 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 | ||
| 21423 | op-snap---monthly-publication-november-2025.pdf | 965 | 2025-11 | Car | Kia | sportage | White | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 21583 | op-snap---monthly-publication-november-2025.pdf | 1125 | 2025-11 | Car | Kia | Sportage | White | Using a Mobile Phone Whilst Driving | None | Suffolk Street | Suffolk Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4749336 | -1.9003475 | ||
| 21697 | op-snap---monthly-publication-november-2025.pdf | 1239 | 2025-11 | 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 | Misc Inc Crimes | 52.4708802 | -1.8792135 | ||
| 21729 | op-snap---monthly-publication-november-2025.pdf | 1271 | 2025-11 | 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 | Misc Inc Crimes | 52.4708802 | -1.8792135 | ||
| 21827 | op-snap---monthly-publication-november-2025.pdf | 1369 | 2025-11 | Car | Kia | rio | Silver | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 21832 | op-snap---monthly-publication-november-2025.pdf | 1374 | 2025-11 | Car | Kia | Ceed | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 21915 | op-snap---monthly-publication-november-2025.pdf | 1457 | 2025-11 | Pedestrian | Kia | ceed | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | church street | Church Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5020781 | -1.9122368 | ||
| 22005 | op-snap---monthly-publication-november-2025.pdf | 1547 | 2025-11 | 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 | ||
| 22020 | op-snap---monthly-publication-november-2025.pdf | 1562 | 2025-11 | Car | Kia | Niro | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 22106 | op-snap---monthly-publication-october-2025.pdf | 56 | 2025-10 | Pedal Bike | Kia | Sportage | Green | Using a Mobile Phone Whilst Driving | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4943878 | -1.8504211 | ||
| 22173 | op-snap---monthly-publication-october-2025.pdf | 123 | 2025-10 | Car | Kia | Ce'ed | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 22334 | op-snap---monthly-publication-october-2025.pdf | 284 | 2025-10 | Car | Kia | Sportage | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4745488 | -1.8065911 | ||
| 22385 | op-snap---monthly-publication-october-2025.pdf | 335 | 2025-10 | Pedal Bike | Kia | Picanto | Blue | Driving without Due Care and Attention | None | Boleyn Road, Rubery | Boleyn Road, Rubery | Birmingham | Birmingham | NFA | No Offence | ||||
| 22603 | op-snap---monthly-publication-october-2025.pdf | 553 | 2025-10 | Pedal Bike | Kia | Sportage | Grey | Using a Mobile Phone Whilst Driving | None | Hill Street | Hill Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4777765 | -1.901321 | ||
| 22609 | op-snap---monthly-publication-october-2025.pdf | 559 | 2025-10 | Pedal Bike | Kia | Xceed | Silver | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 22684 | op-snap---monthly-publication-october-2025.pdf | 634 | 2025-10 | Car | Kia | Niro | Blue | Contravening a Red Traffic Light | None | Dartmouth Circus | Dartmouth Circus | Birmingham | Birmingham | Education | N/A | 52.4926487 | -1.8879638 | ||
| 22692 | op-snap---monthly-publication-october-2025.pdf | 642 | 2025-10 | Pedal Bike | Kia | Sportage | Green | Using a Mobile Phone Whilst Driving | None | Hill Street | Hill Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4777765 | -1.901321 | ||
| 22715 | op-snap---monthly-publication-october-2025.pdf | 665 | 2025-10 | Car | Kia | Ceed | Black | Contravening a Red Traffic Light | None | Spitfire Island | Spitfire Island | Birmingham | Birmingham | Education | N/A | 52.5138106 | -1.797297 | ||
| 22745 | op-snap---monthly-publication-october-2025.pdf | 695 | 2025-10 | Car | Kia | Venga | Silver | Contravening a Red Traffic Light | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | Education | N/A | 52.473883 | -1.9198244 | ||
| 23164 | op-snap---monthly-publication-october-2025.pdf | 1114 | 2025-10 | Pedal Bike | Kia | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | No VRM | 52.4708802 | -1.8792135 | ||||
| 23320 | op-snap---monthly-publication-october-2025.pdf | 1270 | 2025-10 | Pedestrian | Kia | Picanto | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Darwin St, Birmingham | Darwin Street, Birmingham | Birmingham | Birmingham | Warning Letter | N/A | 52.468128 | -1.8848315 | ||
| 23418 | op-snap---monthly-publication-october-2025.pdf | 1368 | 2025-10 | Pedestrian | Kia | Niro | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bernards Road | Bernards Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5498382 | -1.8219962 | ||
| 23600 | op-snap---monthly-publication-october-2025.pdf | 1550 | 2025-10 | Pedestrian | Kia | Picanto | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Colmore Road | Colmore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4296373 | -1.8993161 | ||
| 23614 | op-snap---monthly-publication-october-2025.pdf | 1564 | 2025-10 | Pedestrian | Kia | Stonic | Grey | No Insurance | None | Anglessey Primary School | Anglessey Primary School | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 23764 | op-snap---monthly-publication-october-2025.pdf | 1714 | 2025-10 | Pedestrian | Kia | venga | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | braymoor road | Braymoor Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4756937 | -1.762603 | ||
| 23802 | op-snap---monthly-publication-september-2025.pdf | 21 | 2025-09 | Pedal Bike | Kia | Sportage | Green | Driving without Due Care and Attention | None | Belgrave Road | Belgrave Road | Birmingham | Birmingham | Education | N/A | 52.4669004 | -1.9011385 | ||
| 24002 | op-snap---monthly-publication-september-2025.pdf | 221 | 2025-09 | Car | Kia | Xceed | Silver | Driving a vehicle wholly or partly on a footpath | None | Oxford Road | Oxford Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4456323 | -1.8858352 | ||
| 24026 | op-snap---monthly-publication-september-2025.pdf | 245 | 2025-09 | Other | Kia | Creed | Black | Driving without Due Care and Attention | None | M6 Motorway | M6 Motorway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5327447 | -1.899844 | ||
| 24109 | op-snap---monthly-publication-september-2025.pdf | 328 | 2025-09 | Car | Kia | Sportage | Black | Driving without Due Care and Attention | None | Finchley Road | Finchley Road | Birmingham | Birmingham | Education | N/A | 52.5488456 | -1.8735092 | ||
| 24159 | op-snap---monthly-publication-september-2025.pdf | 378 | 2025-09 | Car | Kia | Ceed | Grey | Driving without Due Care and Attention | None | Queslett Road Great Barr | Queslett Road Great Barr | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5518873 | -1.9122043 | ||
| 24300 | op-snap---monthly-publication-september-2025.pdf | 519 | 2025-09 | Car | Kia | sportage | Silver | Driving without Reasonable Consideration | None | Cateswell Road | Cateswell Road | Birmingham | Birmingham | Education | N/A | 52.4387009 | -1.8454267 | ||
| 24486 | op-snap---monthly-publication-september-2025.pdf | 705 | 2025-09 | Car | Kia | Optima | White | Driving without Due Care and Attention | No vehicle excise licence | A38(M) inbound to Birmingham | A38(M) inbound to Birmingham | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24504 | op-snap---monthly-publication-september-2025.pdf | 723 | 2025-09 | Car | Kia | Grey | Contravene Lane Closure Red X | None | A38 | A38 | Birmingham | Birmingham | NFA | No Offence |
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);