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,037 rows where vehicle_make = "Toyota" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
offence >30
- Driving without Due Care and Attention 401
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 360
- Contravening a Red Traffic Light 274
- Cause vehicle to be left in a dangerous position 219
- Stop a vehicle within pelican pedestrian crossing limits 157
- Using a Mobile Phone Whilst Driving 114
- Driving without Reasonable Consideration 108
- Misc - Non Traffic Offences 72
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 66
- Stop a vehicle on pedestrian crossing 55
- Cause unnecessary obstruction by motor vehicle 43
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 32
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 30
- Motor vehicle fail to accord precedence at a pelican crossing 11
- Contravene Lane Closure Red X 10
- Driving a vehicle wholly or partly on a footpath 9
- Drive on hard shoulder 7
- Driver not in position to have Proper Control 7
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 7
- Drive a vehicle other than on the carriageway of a motorway 5
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 5
- No Insurance 5
- Vehicle overtake within crossing limits 4
- Duplicate Submission 3
- VRM fails to conform to Regulations 3
- Dangerous Driving 2
- Driver parked on pedestrian road marked by a white “Zig-zag line” 2
- Motor vehicle fail to comply with endorsable sect 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- Motor vehicle fail to comply with solid white line road markings 2
- …
council_area 29
- Birmingham 1,352
- Coventry 195
- Sandwell 88
- Out of Force Area 72
- Dudley 68
- Solihull 62
- Walsall 62
- Sutton Coldfield 53
- Wolverhampton 52
- Halesowen 8
- Metropolitan Borough Of Dudley 4
- Area 2
- Metropolitan Borough 2
- 6B Itromwianrgdhsa Smalford C 1
- Abyirmingham 1
- B34Ir Mwianlgshaallm Road 1
- Banirdm Tinhgeh Qaem Hospital 1
- Basirtmingham 1
- Bdirmingham 1
- Boiurmt Oinf Gfhoarmce 1
- Ds Rutotoand Coldfield 1
- Eb Ihrmilli)Ngham 1
- Ebtisrm Cinogrhnamer 1
- Hsoaunsdew Welaly 1
- Nbdir)Mingham 1
- Obsierm ,I Nbgirhmaimngham 1
- Osru Cttloons Ecoldfield 1
- Tbanirtmonin Rghda Nmr Junction With Cambrid 1
- Tbirmingham 1
month 14
reporter_transport_mode 10
- Car 1,147
- Pedestrian 512
- Pedal Bike 297
- Other 66
- Motorbike 4
- Bus 3
- Van 3
- Lorry 2
- car 2
- CAR 1
disposal 8
- Warning Letter 624
- NFA 567
- Fixed Penalty 396
- Education 373
- Court 57
- Other Action Taken 8
- Duplicate Submission 7
- RTC - Actioned 5
vehicle_make 1
- Toyota · 2,037 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8889 | op-snap---monthly-publication-february-2026.pdf | 1636 | 2026-02 | Pedal Bike | Toyota | prius | White | Stop a vehicle on pedestrian crossing | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 8888 | op-snap---monthly-publication-february-2026.pdf | 1635 | 2026-02 | Pedal Bike | Toyota | prius | Grey | Stop a vehicle on pedestrian crossing | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 8886 | op-snap---monthly-publication-february-2026.pdf | 1633 | 2026-02 | Pedestrian | Toyota | auris | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | holly lane | Holly Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5236889 | -1.8253311 | ||
| 8864 | op-snap---monthly-publication-february-2026.pdf | 1611 | 2026-02 | Car | Toyota | yaris | Green | 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 | ||
| 8859 | op-snap---monthly-publication-february-2026.pdf | 1606 | 2026-02 | Pedestrian | Toyota | hilux | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8838 | op-snap---monthly-publication-february-2026.pdf | 1585 | 2026-02 | Car | Toyota | aygo | White | Cause vehicle to be left in a dangerous position | None | De Montfort road | De Montfort road | Coventry | Coventry | Warning Letter | N/A | ||||
| 8825 | op-snap---monthly-publication-february-2026.pdf | 1572 | 2026-02 | Pedestrian | Toyota | Prius | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Thornhill ROad | Thornhill ROad | Birmingham | Birmingham | Warning Letter | N/A | 52.5042818 | -1.9279918 | ||
| 8820 | op-snap---monthly-publication-february-2026.pdf | 1567 | 2026-02 | Car | Toyota | Hilux | Silver | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4191184 | -1.8326637 | ||
| 8812 | op-snap---monthly-publication-february-2026.pdf | 1559 | 2026-02 | Pedal Bike | Toyota | Prius | White | Using a Mobile Phone Whilst Driving | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4274335 | -1.5002381 | ||
| 8807 | op-snap---monthly-publication-february-2026.pdf | 1554 | 2026-02 | Car | Toyota | Yaris | White | Driving without Due Care and Attention | None | Bickenhill Road | Bickenhill Road | Birmingham | Birmingham | Education | N/A | ||||
| 8803 | op-snap---monthly-publication-february-2026.pdf | 1550 | 2026-02 | Car | Toyota | Prius | Blue | Driving without Due Care and Attention | None | M6 motorway, Staffs | M6 motorway, Staffs | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8802 | op-snap---monthly-publication-february-2026.pdf | 1549 | 2026-02 | Car | Toyota | Hilux | Brown | Driving without Due Care and Attention | None | M6 Jct 18 | M6 Junction 18 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8788 | op-snap---monthly-publication-february-2026.pdf | 1535 | 2026-02 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Somerset Road / Richmond Hill Road | Somerset Road / Richmond Hill Road | Birmingham | Birmingham | Education | N/A | 52.5161872 | -1.9315221 | ||
| 8783 | op-snap---monthly-publication-february-2026.pdf | 1530 | 2026-02 | Car | Toyota | Rav 4 | Silver | Driving without Due Care and Attention | None | Duncan Edwards Way | Duncan Edwards Way | Dudley | Dudley | NFA | No Independent Evidence Available | 52.5047428 | -2.0823754 | ||
| 8776 | op-snap---monthly-publication-february-2026.pdf | 1523 | 2026-02 | Car | Toyota | ESTIMA | Black | Driving without Due Care and Attention | No Insurance | Warwick Road / Battery Way | Warwick Road / Battery Way | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.551985 | -1.860445 | ||
| 8771 | op-snap---monthly-publication-february-2026.pdf | 1518 | 2026-02 | Car | Toyota | Prius | White | Driving without Reasonable Consideration | None | Newton Road Great Barr | Newton Road Great Barr | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5429259 | -1.9534939 | ||
| 8767 | op-snap---monthly-publication-february-2026.pdf | 1514 | 2026-02 | Car | Toyota | Yaris | Black | Driving without Due Care and Attention | None | Heath Street Winson Green | Heath Street Winson Green | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4869563 | -1.9351596 | ||
| 8766 | op-snap---monthly-publication-february-2026.pdf | 1513 | 2026-02 | Pedal Bike | Toyota | Prius | Black | Driving without Due Care and Attention | None | Spon End | Spon End | Coventry | Coventry | Education | N/A | 52.4069072 | -1.5247498 | ||
| 8747 | op-snap---monthly-publication-february-2026.pdf | 1494 | 2026-02 | Pedal Bike | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Valentine Road | Valentine Road | Birmingham | Birmingham | Court | N/A | 52.4381959 | -1.8907391 | ||
| 8718 | op-snap---monthly-publication-february-2026.pdf | 1465 | 2026-02 | Pedestrian | Toyota | mpv | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | rockingham gardens | Rockingham Gardens | Birmingham | Birmingham | Warning Letter | N/A | 52.5690681 | -1.8271174 | ||
| 8707 | op-snap---monthly-publication-february-2026.pdf | 1454 | 2026-02 | Pedestrian | Toyota | CHR | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | swanshurt lane | Swanshurt Lane | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8699 | op-snap---monthly-publication-february-2026.pdf | 1446 | 2026-02 | Pedestrian | Toyota | Black | Contravening a Red Traffic Light | None | Cole Bank Road | Cole Bank Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4349375 | -1.8510007 | |||
| 8687 | op-snap---monthly-publication-february-2026.pdf | 1434 | 2026-02 | Car | Toyota | Verso | Grey | Driving without Due Care and Attention | None | Upton Road | Upton Road | Birmingham | Birmingham | Education | N/A | 52.4773477 | -1.8187617 | ||
| 8667 | op-snap---monthly-publication-february-2026.pdf | 1414 | 2026-02 | Car | Toyota | Avenisi | Beige | Driving without Due Care and Attention | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 8645 | op-snap---monthly-publication-february-2026.pdf | 1392 | 2026-02 | Car | Toyota | White | 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 | |||
| 8644 | op-snap---monthly-publication-february-2026.pdf | 1391 | 2026-02 | Car | Toyota | estima | Silver | 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 | ||
| 8641 | op-snap---monthly-publication-february-2026.pdf | 1388 | 2026-02 | Pedestrian | Toyota | yaris | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | deepmore road | Deepmore Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8628 | op-snap---monthly-publication-february-2026.pdf | 1375 | 2026-02 | Car | Toyota | verso | 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 | ||
| 8616 | op-snap---monthly-publication-february-2026.pdf | 1363 | 2026-02 | Pedal Bike | Toyota | Van | Grey | Driving without Due Care and Attention | None | California Way | California Way | Birmingham | Birmingham | NFA | No Offence | 52.4454714 | -1.9753804 | ||
| 8606 | op-snap---monthly-publication-february-2026.pdf | 1353 | 2026-02 | Car | Toyota | Auris | White | Stop a vehicle on pedestrian crossing | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8605 | op-snap---monthly-publication-february-2026.pdf | 1352 | 2026-02 | Car | Toyota | Auris | Grey | Stop a vehicle on pedestrian crossing | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8602 | op-snap---monthly-publication-february-2026.pdf | 1349 | 2026-02 | Car | Toyota | prius | Silver | Stop a vehicle on pedestrian crossing | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8597 | op-snap---monthly-publication-february-2026.pdf | 1344 | 2026-02 | Car | Toyota | Prius | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen St | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 8585 | op-snap---monthly-publication-february-2026.pdf | 1332 | 2026-02 | Pedestrian | Toyota | yaris | Grey | Driving without Due Care and Attention | None | Tenbury Road | Tenbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4264041 | -1.8966768 | ||
| 8583 | op-snap---monthly-publication-february-2026.pdf | 1330 | 2026-02 | Car | Toyota | Auris | Red | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | t None | Holland Street | Holland Street | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5594346 | -1.8239493 | ||
| 8581 | op-snap---monthly-publication-february-2026.pdf | 1328 | 2026-02 | Car | Toyota | Verso | White | Misc - Non Traffic Offences | None | Foxlydaite Crescent | Foxlydaite Crescent | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8568 | op-snap---monthly-publication-february-2026.pdf | 1315 | 2026-02 | Pedestrian | Toyota | Blue | Driving without Due Care and Attention | None | Sherlock Street | Sherlock Street | Birmingham | Birmingham | NFA | 52.4702385 | -1.895011 | ||||
| 8567 | op-snap---monthly-publication-february-2026.pdf | 1314 | 2026-02 | Pedestrian | Toyota | White | Driving without Due Care and Attention | None | Sherlock Street | Sherlock Street | Birmingham | Birmingham | Education | N/A | 52.4702385 | -1.895011 | |||
| 8550 | op-snap---monthly-publication-february-2026.pdf | 1297 | 2026-02 | Car | Toyota | Yaris | Red | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Warning Letter | N/A | 52.396476 | -1.5561348 | ||
| 8535 | op-snap---monthly-publication-february-2026.pdf | 1282 | 2026-02 | Car | Toyota | Avensis | White | Contravening a Red Traffic Light | None | Robin Hood Island | Robin Hood Island | Birmingham | Birmingham | Education | N/A | 52.4220705 | -1.8372335 | ||
| 8531 | op-snap---monthly-publication-february-2026.pdf | 1278 | 2026-02 | Car | Toyota | Estima | White | Driving without Due Care and Attention | None | Hurst Lane at Green Lane | Hurst Lane at Green Lane | Birmingham | Birmingham | Education | N/A | 52.4967785 | -1.7667723 | ||
| 8512 | op-snap---monthly-publication-february-2026.pdf | 1259 | 2026-02 | Car | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Education | N/A | 52.5113867 | -1.8337258 | ||
| 8510 | op-snap---monthly-publication-february-2026.pdf | 1257 | 2026-02 | Car | Toyota | Yaris | Black | Driving without Due Care and Attention | None | Fairhome Road | Fairhome Road | Birmingham | Birmingham | Education | N/A | ||||
| 8495 | op-snap---monthly-publication-february-2026.pdf | 1242 | 2026-02 | Car | Toyota | C-HR | Grey | Contravening a Red Traffic Light | None | Bristol Road, Longbridge | Bristol Road, Longbridge | Birmingham | Birmingham | Warning Letter | N/A | 52.3959871 | -2.0019629 | ||
| 8459 | op-snap---monthly-publication-february-2026.pdf | 1206 | 2026-02 | Car | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Education | N/A | 52.5083238 | -1.8332287 | ||
| 8451 | op-snap---monthly-publication-february-2026.pdf | 1198 | 2026-02 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Tudor Street | Tudor Street | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 8442 | op-snap---monthly-publication-february-2026.pdf | 1189 | 2026-02 | Pedestrian | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ladywood | Ladywood | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4774932 | -1.9233654 | ||
| 8441 | op-snap---monthly-publication-february-2026.pdf | 1188 | 2026-02 | Pedestrian | Toyota | Avensis | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 8431 | op-snap---monthly-publication-february-2026.pdf | 1178 | 2026-02 | Car | Toyota | Avenis | Black | Driving without Due Care and Attention | None | Tyburn House Island | Tyburn House Island | Birmingham | Birmingham | Warning Letter | N/A | 52.5194011 | -1.8008643 | ||
| 8409 | op-snap---monthly-publication-february-2026.pdf | 1156 | 2026-02 | Pedestrian | Toyota | Rav 4 | Green | Misc - Non Traffic Offences | No Insurance | Woodstock Road | Woodstock Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4486205 | -1.8740822 | ||
| 8401 | op-snap---monthly-publication-february-2026.pdf | 1148 | 2026-02 | Car | Toyota | Yaris | White | Driving without Due Care and Attention | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4745488 | -1.8065911 | ||
| 8392 | op-snap---monthly-publication-february-2026.pdf | 1139 | 2026-02 | Pedestrian | Toyota | Hiace | Silver | Cause vehicle to be left in a dangerous position | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 8358 | op-snap---monthly-publication-february-2026.pdf | 1105 | 2026-02 | Car | Toyota | Corolla | Grey | Driving without Due Care and Attention | None | Kingstown Road Carlisle | Kingstown Road Carlisle | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8357 | op-snap---monthly-publication-february-2026.pdf | 1104 | 2026-02 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Sandpits | Sandpits | Birmingham | Birmingham | Court | N/A | 52.482308 | -1.9133277 | ||
| 8353 | op-snap---monthly-publication-february-2026.pdf | 1100 | 2026-02 | Car | Toyota | Yaris | White | Driving without Due Care and Attention | None | Green Lane | Green Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4618966 | -1.9955421 | ||
| 8321 | op-snap---monthly-publication-february-2026.pdf | 1068 | 2026-02 | Pedal Bike | Toyota | Prius | Black | Driving without Due Care and Attention | None | Butts Road | Butts Road | Coventry | Coventry | Education | N/A | 52.4073149 | -1.5250454 | ||
| 8314 | op-snap---monthly-publication-february-2026.pdf | 1061 | 2026-02 | Pedestrian | Toyota | Proace | White | Stop a vehicle within pelican pedestrian crossing limits | None | Castle Square | Castle Square | Birmingham | Birmingham | Education | N/A | 52.4380168 | -1.9700439 | ||
| 8291 | op-snap---monthly-publication-february-2026.pdf | 1038 | 2026-02 | Car | Toyota | Auris | Silver | Contravening a Red Traffic Light | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Education | N/A | 52.5113867 | -1.8337258 | ||
| 8278 | op-snap---monthly-publication-february-2026.pdf | 1025 | 2026-02 | Car | Toyota | Auris | Grey | Driving without Due Care and Attention | None | Ebrook Road | Ebrook Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5557273 | -1.8159805 | ||
| 8275 | op-snap---monthly-publication-february-2026.pdf | 1022 | 2026-02 | Car | Toyota | Corolla | White | Stop a vehicle within pelican pedestrian crossing limits | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 8272 | op-snap---monthly-publication-february-2026.pdf | 1019 | 2026-02 | Car | Toyota | Auris | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 8254 | op-snap---monthly-publication-february-2026.pdf | 1001 | 2026-02 | Car | Toyota | Prius | White | Contravening a Red Traffic Light | None | All Saints Way | All Saints Way | Sandwell | Sandwell | Education | N/A | 52.5344405 | -1.985568 | ||
| 8230 | op-snap---monthly-publication-february-2026.pdf | 977 | 2026-02 | Car | Toyota | Prius | Blue | Contravening a Red Traffic Light | None | Green Lane, | Green Lane | Walsall | Walsall | NFA | 52.5995834 | -1.9971273 | |||
| 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 | ||
| 8224 | op-snap---monthly-publication-february-2026.pdf | 971 | 2026-02 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | NFA | 52.5012458 | -1.8780942 | |||
| 8219 | op-snap---monthly-publication-february-2026.pdf | 966 | 2026-02 | Car | Toyota | Prius | 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 | ||
| 8210 | op-snap---monthly-publication-february-2026.pdf | 957 | 2026-02 | Car | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Foundry lane | Foundry lane | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 8201 | op-snap---monthly-publication-february-2026.pdf | 948 | 2026-02 | Car | Toyota | White | Stop a vehicle within pelican pedestrian crossing limits | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Education | N/A | 52.4967329 | -1.8097462 | |||
| 8196 | op-snap---monthly-publication-february-2026.pdf | 943 | 2026-02 | Car | Toyota | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | |||
| 8194 | op-snap---monthly-publication-february-2026.pdf | 941 | 2026-02 | Car | Toyota | C-HR | Blue | Driving without Due Care and Attention | None | Birmingham Street | Birmingham Street | Dudley | Dudley | Education | N/A | 52.5122152 | -2.0791208 | ||
| 8190 | op-snap---monthly-publication-february-2026.pdf | 937 | 2026-02 | Car | Toyota | Estima | 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 | ||
| 8182 | op-snap---monthly-publication-february-2026.pdf | 929 | 2026-02 | Pedestrian | Toyota | Corolla | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4745488 | -1.8065911 | ||
| 8165 | op-snap---monthly-publication-february-2026.pdf | 912 | 2026-02 | Car | Toyota | Yaris | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 8144 | op-snap---monthly-publication-february-2026.pdf | 891 | 2026-02 | Pedestrian | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Alum Rock Road | Alum Rock Road | Birmingham | Birmingham | Education | N/A | 52.4883936 | -1.8310056 | ||
| 8141 | op-snap---monthly-publication-february-2026.pdf | 888 | 2026-02 | Car | Toyota | C-HR | White | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 8140 | op-snap---monthly-publication-february-2026.pdf | 887 | 2026-02 | Car | Toyota | cOROLLA | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Queenshead Road | Queenshead Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8130 | op-snap---monthly-publication-february-2026.pdf | 877 | 2026-02 | Pedestrian | Toyota | Estima | Black | Stop a vehicle on pedestrian crossing | None | Booths Farm Road | Booths Farm Road | Birmingham | Birmingham | Education | N/A | 52.541377 | -1.9175615 | ||
| 8119 | op-snap---monthly-publication-february-2026.pdf | 866 | 2026-02 | Car | Toyota | Yaris | Black | Driving without Due Care and Attention | None | Olton Road | Olton Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.4458625 | -1.8174911 | ||
| 8115 | op-snap---monthly-publication-february-2026.pdf | 862 | 2026-02 | Car | Toyota | Corolla | Silver | Driving without Due Care and Attention | None | Stourbridge Road | Stourbridge Road | Wolverhampton | Wolverhampton | NFA | No Offence | ||||
| 8107 | op-snap---monthly-publication-february-2026.pdf | 854 | 2026-02 | Car | Toyota | Auris | Blue | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Solihull | Solihull | Warning Letter | N/A | 52.4191184 | -1.8326637 | ||
| 8089 | op-snap---monthly-publication-february-2026.pdf | 836 | 2026-02 | Car | Toyota | Yaris | Black | Contravening a Red Traffic Light | None | Hamstead Road | Hamstead Road | Birmingham | Birmingham | Warning Letter | N/A | 52.505832 | -1.92002 | ||
| 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 | ||
| 8069 | op-snap---monthly-publication-february-2026.pdf | 816 | 2026-02 | Car | Toyota | Yaris | Red | Driving without Due Care and Attention | None | Church Hill Road | Church Hill Road | Solihull | Solihull | Education | N/A | 52.4078582 | -1.7777439 | ||
| 8059 | op-snap---monthly-publication-february-2026.pdf | 806 | 2026-02 | Car | Toyota | Corolla | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 8041 | op-snap---monthly-publication-february-2026.pdf | 788 | 2026-02 | Car | Toyota | CHR | Grey | Driving without Due Care and Attention | None | St Chads Queensway | Street Chads Queensway | Birmingham | Birmingham | NFA | No Offence | ||||
| 8016 | op-snap---monthly-publication-february-2026.pdf | 763 | 2026-02 | Car | Toyota | Yaris | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Highgate Road | Highgate Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4606652 | -1.8791145 | ||
| 8010 | op-snap---monthly-publication-february-2026.pdf | 757 | 2026-02 | Car | Toyota | Auris | Black | Contravening a Red Traffic Light | None | Salford Circus Roundabout, Erdington | Salford Circus Roundabout, Erdington | Birmingham | Birmingham | Education | N/A | ||||
| 8003 | op-snap---monthly-publication-february-2026.pdf | 750 | 2026-02 | Car | Toyota | Corolla | White | Stop a vehicle within pelican pedestrian crossing limits | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | Education | N/A | 52.4520441 | -1.8787544 | ||
| 7998 | op-snap---monthly-publication-february-2026.pdf | 745 | 2026-02 | Car | Toyota | Yaris | Grey | Driving without Due Care and Attention | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5170745 | -1.9012542 | ||
| 7994 | op-snap---monthly-publication-february-2026.pdf | 741 | 2026-02 | Car | Toyota | Corrolla | Black | Driving without Due Care and Attention | None | Halesowen Road | Halesowen Road | Halesowen | Halesowen | Court | N/A | 52.4624413 | -2.0175178 | ||
| 7990 | op-snap---monthly-publication-february-2026.pdf | 737 | 2026-02 | Car | Toyota | Estima | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | NFA | No Offence | ||||
| 7986 | op-snap---monthly-publication-february-2026.pdf | 733 | 2026-02 | Pedestrian | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Oswalds Road | Street Oswalds Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7979 | op-snap---monthly-publication-february-2026.pdf | 726 | 2026-02 | Other | Toyota | Prius | 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 | ||
| 7976 | op-snap---monthly-publication-february-2026.pdf | 723 | 2026-02 | Car | Toyota | Prius | Black | Using a Mobile Phone Whilst Driving | Driving without Due Care and Attention | A45 Coventry | Coventry | Coventry | Coventry | Fixed Penalty | N/A | 52.400739 | -1.5135474 | ||
| 7972 | op-snap---monthly-publication-february-2026.pdf | 719 | 2026-02 | Car | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Scotts Green Island | Scotts Green Island | Dudley | Dudley | Fixed Penalty | N/A | 52.5029355 | -2.1051117 | ||
| 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 | ||
| 7927 | op-snap---monthly-publication-february-2026.pdf | 674 | 2026-02 | Car | Toyota | MPV | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7920 | op-snap---monthly-publication-february-2026.pdf | 667 | 2026-02 | Pedal Bike | Toyota | Corolla | Silver | Contravening a Red Traffic Light | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 7898 | op-snap---monthly-publication-february-2026.pdf | 645 | 2026-02 | Other | Toyota | Prius | White | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Education | N/A | 52.5265939 | -1.8509884 |
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);