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'}
215 rows where reporter_transport_mode = "Car" and vehicle_make = "Kia" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
offence 25
- Driving without Due Care and Attention 73
- Contravening a Red Traffic Light 41
- Driving without Reasonable Consideration 16
- Stop a vehicle within pelican pedestrian crossing limits 16
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 14
- Cause vehicle to be left in a dangerous position 12
- Using a Mobile Phone Whilst Driving 12
- Contravene Lane Closure Red X 5
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 4
- Stop a vehicle on pedestrian crossing 3
- Drive a vehicle other than on the carriageway of a motorway 2
- Misc - Non Traffic Offences 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- Drive a vehicle other than on the carriageway of a 1
- Drive on hard shoulder 1
- Driver not in position to have Proper Control 1
- Driving a vehicle wholly or partly on a footpath 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
- Waiting on a road in a prohibited area 1
month 14
council_area 11
- Birmingham 114
- Out of Force Area 22
- Walsall 16
- Dudley 13
- Sandwell 13
- Coventry 12
- Solihull 10
- Wolverhampton 9
- Sutton Coldfield 4
- Edldu Dalveey Brierley Hill 1
- Metropolitan Borough Of Dudley 1
disposal 7
- NFA 78
- Warning Letter 53
- Education 45
- Fixed Penalty 30
- Court 4
- RTC - Actioned 4
- Other Action Taken 1
vehicle_make 1
- Kia · 215 ✖
reporter_transport_mode 1
- Car · 215 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 8662 | op-snap---monthly-publication-february-2026.pdf | 1409 | 2026-02 | Car | Kia | Silver | Driving without Due Care and Attention | None | A4440 | A4440 | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 8545 | op-snap---monthly-publication-february-2026.pdf | 1292 | 2026-02 | Car | Kia | Red | Using a Mobile Phone Whilst Driving | None | Burton Upon Trent | Burton Upon Trent | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 8398 | op-snap---monthly-publication-february-2026.pdf | 1145 | 2026-02 | Car | Kia | Niro | Grey | Contravening a Red Traffic Light | None | Parkfield Road | Parkfield Road | Wolverhampton | Wolverhampton | Education | N/A | 52.567016 | -2.1208485 | ||
| 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 | ||
| 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 | ||
| 7836 | op-snap---monthly-publication-february-2026.pdf | 583 | 2026-02 | Car | Kia | Picanto | Blue | Driving without Due Care and Attention | None | Windsor to Watford | Windsor to Watford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7723 | op-snap---monthly-publication-february-2026.pdf | 470 | 2026-02 | Car | Kia | EV3 | Green | Driving without Due Care and Attention | None | Tanworth Lane | Tanworth Lane | Solihull | Solihull | Education | N/A | 52.4014694 | -1.8220541 | ||
| 7670 | op-snap---monthly-publication-february-2026.pdf | 417 | 2026-02 | Car | Kia | Sportage | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Sharman's Cross Road | Sharman's Cross Road | Solihull | Solihull | Warning Letter | N/A | ||||
| 7622 | op-snap---monthly-publication-february-2026.pdf | 369 | 2026-02 | Car | Kia | Sportage | Brown | Driving without Due Care and Attention | None | M42 Jct 11 Roundabout | M42 Junction 11 Roundabout | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7579 | op-snap---monthly-publication-february-2026.pdf | 326 | 2026-02 | Car | Kia | Xceed | Grey | Driving without Due Care and Attention | None | Birmingham New Road | Birmingham New Road | Dudley | Dudley | Education | N/A | 52.5478387 | -2.0943116 | ||
| 7397 | op-snap---monthly-publication-february-2026.pdf | 144 | 2026-02 | Car | Kia | Stonic | Red | Driving without Reasonable Consideration | None | Telford Town Centre | Telford Town Centre | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7322 | op-snap---monthly-publication-february-2026.pdf | 69 | 2026-02 | Car | Kia | Rio | White | Driving without Due Care and Attention | None | A16 Kirton | Kirton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7314 | op-snap---monthly-publication-february-2026.pdf | 61 | 2026-02 | Car | Kia | Ceed | Silver | Using a Mobile Phone Whilst Driving | None | Moorfield Road | Moorfield Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4981538 | -1.7875516 | ||
| 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 | ||||
| 11728 | op-snap---monthly-publication-january-2026.pdf | 1189 | 2026-01 | Car | Kia | Sedona | Black | Driving without Due Care and Attention | No Insurance | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Court | N/A | 52.6083917 | -2.1033365 | ||
| 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 | ||
| 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 | ||
| 11539 | op-snap---monthly-publication-january-2026.pdf | 1000 | 2026-01 | Car | Kia | Ceed | Red | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Education | N/A | 52.396476 | -1.5561348 | ||
| 11529 | op-snap---monthly-publication-january-2026.pdf | 990 | 2026-01 | Car | Kia | Sportage | Blue | Driving without Due Care and Attention | None | Solihull Bypass | Solihull Bypass | Solihull | Solihull | NFA | No Offence | 52.4207529 | -1.7757467 | ||
| 11461 | op-snap---monthly-publication-january-2026.pdf | 922 | 2026-01 | Car | Kia | Xceed | Black | Driving without Due Care and Attention | None | Lowr Queen Street | Lowr Queen Street | Sutton Coldfield | Sutton Coldfield | Education | N/A | ||||
| 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 | ||
| 11417 | op-snap---monthly-publication-january-2026.pdf | 878 | 2026-01 | Car | Kia | Black | Driving without Due Care and Attention | None | Monmouth Drive | Monmouth Drive | Sutton Coldfield | Sutton Coldfield | RTC - Actioned | N/A | 52.5575249 | -1.8640053 | |||
| 11353 | op-snap---monthly-publication-january-2026.pdf | 814 | 2026-01 | Car | Kia | Niro | Grey | Using a Mobile Phone Whilst Driving | None | Enfield, London | Enfield, London | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||||
| 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 | ||
| 11034 | op-snap---monthly-publication-january-2026.pdf | 495 | 2026-01 | Car | Kia | EV - 9 | Blue | Using a Mobile Phone Whilst Driving | None | M6 South | M6 South | Metropolitan Borough of Walsall | Walsall | Other Action Taken | N/A | 52.6170728 | -2.030393 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 10797 | op-snap---monthly-publication-january-2026.pdf | 258 | 2026-01 | Car | Kia | Picanto | Blue | Driving without Due Care and Attention | None | A380 Malvern Link | Malvern Link | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 10650 | op-snap---monthly-publication-january-2026.pdf | 111 | 2026-01 | Car | Kia | Sportage | Black | Driving without Due Care and Attention | None | A5 Oswestry | Oswestry | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||||
| 5156 | op-snap---monthly-publication-december-2025.pdf | 1284 | 2025-12 | Car | Kia | Niro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wolverhampton Street | Wolverhampton Street | Walsall | Walsall | Warning Letter | N/A | 52.5674241 | -2.0426354 | ||
| 5137 | op-snap---monthly-publication-december-2025.pdf | 1265 | 2025-12 | Car | Kia | Nero | Black | Driving without Due Care and Attention | None | A444 | A444 | Coventry | Coventry | NFA | Not in Public Interest | ||||
| 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 | ||
| 4904 | op-snap---monthly-publication-december-2025.pdf | 1032 | 2025-12 | Car | Kia | Sportage | White | Contravening a Red Traffic Light | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No VRM | 52.4214017 | -1.4870278 | ||
| 4867 | op-snap---monthly-publication-december-2025.pdf | 995 | 2025-12 | Car | Kia | EV9 | Black | Driving without Due Care and Attention | None | Navigation Roundabout A41 | Navigation Roundabout A41 | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5318418 | -2.0304157 | ||
| 4800 | op-snap---monthly-publication-december-2025.pdf | 928 | 2025-12 | Car | Kia | Sportage | Blue | Driving without Due Care and Attention | None | M6 | M6 | Walsall | Walsall | Warning Letter | N/A | ||||
| 4677 | op-snap---monthly-publication-december-2025.pdf | 805 | 2025-12 | Car | Kia | Ceed | Black | Using a Mobile Phone Whilst Driving | None | M6 | M6 | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 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 | ||
| 4580 | op-snap---monthly-publication-december-2025.pdf | 708 | 2025-12 | Car | Kia | XCeed | Black | Driving without Due Care and Attention | None | A53 Shrewsbury | Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6195535 | -2.0193824 | ||
| 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 | ||
| 4514 | op-snap---monthly-publication-december-2025.pdf | 642 | 2025-12 | Car | Kia | rio | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | silvertrees road | Silvertrees Road | Dudley | Dudley | Warning Letter | N/A | 52.5263871 | -2.0677928 | ||
| 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 | ||
| 4419 | op-snap---monthly-publication-december-2025.pdf | 547 | 2025-12 | Car | Kia | Niro | Red | Cause vehicle to be left in a dangerous position | None | Opposite Withymoor School Gayfi | Opposite Withymoor School Gayfi | eDldu dAlveey Brierley Hill | Edldu Dalveey Brierley Hill | Warning Letter | N/A | ||||
| 4343 | op-snap---monthly-publication-december-2025.pdf | 471 | 2025-12 | Car | Kia | Rio | Silver | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Education | N/A | 52.418488 | -1.5472387 | ||
| 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 | ||||
| 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 | ||
| 4115 | op-snap---monthly-publication-december-2025.pdf | 243 | 2025-12 | Car | Kia | Sportage | Yellow | Driving without Due Care and Attention | None | New Cross Hospital | New Cross Hospital | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6000052 | -2.0954966 | ||
| 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 | ||
| 4069 | op-snap---monthly-publication-december-2025.pdf | 197 | 2025-12 | Car | Kia | Picanto | White | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 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 | ||
| 3985 | op-snap---monthly-publication-december-2025.pdf | 113 | 2025-12 | Car | Kia | Sportage | White | Driving without Due Care and Attention | None | M42 Junction 4 | M42 Junction 4 | Solihull | Solihull | Education | N/A | ||||
| 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 | ||
| 21928 | op-snap---monthly-publication-november-2025.pdf | 1470 | 2025-11 | Car | Kia | Sportage | White | Driving without Due Care and Attention | None | Stainland Road (Halifax) | Stainland Road (Halifax) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 21582 | op-snap---monthly-publication-november-2025.pdf | 1124 | 2025-11 | Car | Kia | Sportage | Brown | Driving without Due Care and Attention | None | St Johns Road Stourbridge | Street Johns Road Stourbridge | Dudley | Dudley | Fixed Penalty | N/A | ||||
| 21507 | op-snap---monthly-publication-november-2025.pdf | 1049 | 2025-11 | Car | Kia | Niro | Black | Contravening a Red Traffic Light | None | Swan Lane | Swan Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4180375 | -1.4895028 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 20676 | op-snap---monthly-publication-november-2025.pdf | 218 | 2025-11 | Car | Kia | Rio 2 | Blue | Driving without Due Care and Attention | None | M25 | M25 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20559 | op-snap---monthly-publication-november-2025.pdf | 101 | 2025-11 | Car | Kia | Ceed | Red | Contravening a Red Traffic Light | None | M6 J10 RA | M6 J10 Ra | Wolverhampton | Wolverhampton | Education | N/A | 52.6760749 | -2.0862582 | ||
| 23446 | op-snap---monthly-publication-october-2025.pdf | 1396 | 2025-10 | Car | Kia | Sportage | Grey | Driving without Due Care and Attention | None | Hanley, Staffs | Hanley, Staffs | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23051 | op-snap---monthly-publication-october-2025.pdf | 1001 | 2025-10 | Car | Kia | Sportage | Black | Driving without Due Care and Attention | None | M5 NB J1 - M6 | M5 Northbound J1 - M6 | Sandwell | Sandwell | RTC - Actioned | N/A | ||||
| 22994 | op-snap---monthly-publication-october-2025.pdf | 944 | 2025-10 | Car | Kia | Sportage | Blue | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Education | N/A | 52.396476 | -1.5561348 | ||
| 22894 | op-snap---monthly-publication-october-2025.pdf | 844 | 2025-10 | Car | Kia | Picanto | Silver | Driving without Due Care and Attention | None | Portway Hill | Portway Hill | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4990342 | -2.0424359 | ||
| 22804 | op-snap---monthly-publication-october-2025.pdf | 754 | 2025-10 | Car | Kia | Sportage | Grey | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4428606 | -1.812114 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 22384 | op-snap---monthly-publication-october-2025.pdf | 334 | 2025-10 | Car | Kia | Soul | Black | Driving without Due Care and Attention | None | A4440 Grove Way, Worcester | Grove Way, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 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 | ||
| 22078 | op-snap---monthly-publication-october-2025.pdf | 28 | 2025-10 | Car | Kia | Sportage | Black | Contravening a Red Traffic Light | None | M42 J9 Island | M42 J9 Island | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3601724 | -1.8062199 | ||
| 25478 | op-snap---monthly-publication-september-2025.pdf | 1697 | 2025-09 | Car | Kia | niro | Grey | Cause vehicle to be left in a dangerous position | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 25280 | op-snap---monthly-publication-september-2025.pdf | 1499 | 2025-09 | Car | Kia | Ceed | Black | Driving without Due Care and Attention | None | Lower queen street | Lower queen street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 25269 | op-snap---monthly-publication-september-2025.pdf | 1488 | 2025-09 | Car | Kia | Rio | Blue | Contravene Lane Closure Red X | None | M6 Southbound | M6 Southbound | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 25165 | op-snap---monthly-publication-september-2025.pdf | 1384 | 2025-09 | Car | Kia | Silver | Contravene Lane Closure Red X | None | M6 Southbound | M6 Southbound | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 25057 | op-snap---monthly-publication-september-2025.pdf | 1276 | 2025-09 | Car | Kia | Stonic | Grey | Misc - Non Traffic Offences | None | Park avenue, | Park avenue | Walsall | Walsall | RTC - Actioned | N/A | 52.5853624 | -2.0632143 | ||
| 25000 | op-snap---monthly-publication-september-2025.pdf | 1219 | 2025-09 | Car | Kia | Sportage | Grey | Driving without Due Care and Attention | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 24795 | op-snap---monthly-publication-september-2025.pdf | 1014 | 2025-09 | Car | Kia | Venga | Silver | Driving without Due Care and Attention | None | Bowers Lane | Bowers Lane | Dudley | Dudley | Warning Letter | N/A | ||||
| 24672 | op-snap---monthly-publication-september-2025.pdf | 891 | 2025-09 | Car | Kia | Picanto | Black | Driving without Due Care and Attention | None | M5 motorway | M5 motorway | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5368223 | -1.96752 | ||
| 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 | |||||
| 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 | ||||
| 24308 | op-snap---monthly-publication-september-2025.pdf | 527 | 2025-09 | Car | Kia | Picanto | White | Drive a vehicle other than on the carriageway of a | motorway None | M6 Motorway | M6 Motorway | Sandwell | Sandwell | Education | N/A | ||||
| 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 | ||
| 24190 | op-snap---monthly-publication-september-2025.pdf | 409 | 2025-09 | Car | Kia | Ceed | White | Driving without Reasonable Consideration | None | Neachells Lane, | Neachells Lane | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.597459 | -2.0791894 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 3822 | op-snap---monthly-publication-august-2025.pdf | 1797 | 2025-08 | Car | Kia | Sportage | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Vicarage Rd | Vicarage Road | Birmingham | Birmingham | Warning Letter | N/A | 52.470423 | -1.9304786 | ||
| 3812 | op-snap---monthly-publication-august-2025.pdf | 1787 | 2025-08 | Car | Kia | Sportage | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hill Village Road | Hill Village Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5959906 | -1.8345802 | ||
| 3457 | op-snap---monthly-publication-august-2025.pdf | 1432 | 2025-08 | Car | Kia | Niro | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Bernards Road | Street Bernards Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3245 | op-snap---monthly-publication-august-2025.pdf | 1220 | 2025-08 | Car | Kia | Picanto | White | Cause vehicle to be left in a dangerous position | None | Brays Lane | Brays Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4587041 | -1.7911368 | ||
| 3219 | op-snap---monthly-publication-august-2025.pdf | 1194 | 2025-08 | Car | Kia | Sportage | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Street, Brownhills | High Street, Brownhills | Walsall | Walsall | Warning Letter | N/A | 52.6252131 | -1.9338823 |
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);