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'}
775 rows where council_area = "Birmingham", reporter_transport_mode = "Car" and vehicle_make = "Toyota" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
offence >30
- Driving without Due Care and Attention 160
- Contravening a Red Traffic Light 142
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 95
- Stop a vehicle within pelican pedestrian crossing limits 95
- Cause vehicle to be left in a dangerous position 72
- Stop a vehicle on pedestrian crossing 32
- Driving without Reasonable Consideration 31
- Cause unnecessary obstruction by motor vehicle 23
- Misc - Non Traffic Offences 20
- Using a Mobile Phone Whilst Driving 20
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 18
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 14
- Contravene Lane Closure Red X 9
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 6
- Motor vehicle fail to accord precedence at a pelican crossing 5
- Drive a vehicle other than on the carriageway of a motorway 4
- Drive on hard shoulder 4
- Driving a vehicle wholly or partly on a footpath 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 3
- Driver not in position to have Proper Control 2
- Driver parked on pedestrian road marked by a white “Zig-zag line” 2
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 1
- Dangerous Driving 1
- Drive / Ride / Lead an animal on a footpath 1
- Duplicate Submission 1
- Motor vehicle fail to accord precedence at a pelic 1
- Motor vehicle fail to comply with a non endorsab 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
- Motor vehicle fail to comply with solid white line road markings 1
- …
month 14
disposal 8
- Warning Letter 270
- NFA 189
- Education 182
- Fixed Penalty 101
- Court 23
- Other Action Taken 4
- RTC - Actioned 4
- Duplicate Submission 2
vehicle_make 1
- Toyota · 775 ✖
reporter_transport_mode 1
- Car · 775 ✖
council_area 1
- Birmingham · 775 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7341 | op-snap---monthly-publication-february-2026.pdf | 88 | 2026-02 | Car | Toyota | Corolla | Silver | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7365 | op-snap---monthly-publication-february-2026.pdf | 112 | 2026-02 | Car | Toyota | Prius | Black | Driving without Due Care and Attention | None | Booth Street, Handsworth | Booth Street, Handsworth | Birmingham | Birmingham | Education | N/A | 52.5039035 | -1.9447084 | ||
| 7395 | op-snap---monthly-publication-february-2026.pdf | 142 | 2026-02 | Car | Toyota | Yaris | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Darwin Street | Darwin Street | Birmingham | Birmingham | Warning Letter | N/A | 52.468128 | -1.8848315 | ||
| 7489 | op-snap---monthly-publication-february-2026.pdf | 236 | 2026-02 | Car | Toyota | Yaris | Blue | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 7507 | op-snap---monthly-publication-february-2026.pdf | 254 | 2026-02 | Car | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alexander Road | Alexander Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4524008 | -1.8262343 | ||
| 7661 | op-snap---monthly-publication-february-2026.pdf | 408 | 2026-02 | Car | Toyota | Auris | Black | Cause vehicle to be left in a dangerous position | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | Education | N/A | 52.4830179 | -1.783876 | ||
| 7743 | op-snap---monthly-publication-february-2026.pdf | 490 | 2026-02 | Car | Toyota | Previa | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7758 | op-snap---monthly-publication-february-2026.pdf | 505 | 2026-02 | Car | Toyota | RAV4 | Silver | No Insurance | No vehicle excise licence | Bridge Road, Alum Rock | Bridge Road, Alum Rock | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4835737 | -1.8489514 | ||
| 7803 | op-snap---monthly-publication-february-2026.pdf | 550 | 2026-02 | Car | Toyota | Corolla | White | Driving without Due Care and Attention | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Education | N/A | 52.5274116 | -1.9287273 | ||
| 7808 | op-snap---monthly-publication-february-2026.pdf | 555 | 2026-02 | Car | Toyota | Corolla | White | Driving without Due Care and Attention | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.5274116 | -1.9287273 | ||
| 7876 | op-snap---monthly-publication-february-2026.pdf | 623 | 2026-02 | Car | Toyota | Prius | Black | Driving without Due Care and Attention | None | Anglesey Street, Lozells | Anglesey Street, Lozells | Birmingham | Birmingham | Education | N/A | 52.5000379 | -1.9102942 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 10550 | op-snap---monthly-publication-january-2026.pdf | 11 | 2026-01 | Car | Toyota | Hi-lux | Green | Drive a vehicle other than on the carriageway of a motorway | None | M6 NB J6 | M6 Northbound J6 | Birmingham | Birmingham | Education | N/A | 52.676119 | -2.0858425 | ||
| 10571 | op-snap---monthly-publication-january-2026.pdf | 32 | 2026-01 | Car | Toyota | Estima | White | Contravening a Red Traffic Light | None | Bordesley Green Road | Bordesley Green Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4804926 | -1.8563658 | ||
| 10583 | op-snap---monthly-publication-january-2026.pdf | 44 | 2026-01 | Car | Toyota | Aygo | Grey | Contravening a Red Traffic Light | No Insurance | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 10602 | op-snap---monthly-publication-january-2026.pdf | 63 | 2026-01 | Car | Toyota | Yaris | Black | Contravene Lane Closure Red X | None | Green Lane | Green Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4618966 | -1.9955421 | ||
| 10631 | op-snap---monthly-publication-january-2026.pdf | 92 | 2026-01 | Car | Toyota | Corolla | Silver | Contravening a Red Traffic Light | None | Chester Road / Hurst Lane North | Chester Road / Hurst Lane North | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 10655 | op-snap---monthly-publication-january-2026.pdf | 116 | 2026-01 | Car | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Clay Lane | Clay Lane | Birmingham | Birmingham | Education | N/A | 52.4509038 | -1.8083784 | ||
| 10664 | op-snap---monthly-publication-january-2026.pdf | 125 | 2026-01 | Car | Toyota | yaris | Grey | Cause vehicle to be left in a dangerous position | None | witton road | Witton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513336 | -1.8833226 | ||
| 10670 | op-snap---monthly-publication-january-2026.pdf | 131 | 2026-01 | Car | Toyota | Yaris | Silver | Duplicate Submission | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.4470686 | -1.8880749 | ||
| 10671 | op-snap---monthly-publication-january-2026.pdf | 132 | 2026-01 | Car | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Offence | 52.4470686 | -1.8880749 | ||
| 10682 | op-snap---monthly-publication-january-2026.pdf | 143 | 2026-01 | 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 | ||
| 10688 | op-snap---monthly-publication-january-2026.pdf | 149 | 2026-01 | Car | Toyota | Auris | Brown | Stop a vehicle on pedestrian crossing | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 10690 | op-snap---monthly-publication-january-2026.pdf | 151 | 2026-01 | Car | Toyota | Yaris | Grey | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 10691 | op-snap---monthly-publication-january-2026.pdf | 152 | 2026-01 | Car | Toyota | Auris | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Church Street Lozells | Church Street Lozells | Birmingham | Birmingham | Warning Letter | N/A | 52.4997378 | -1.9113714 | ||
| 10804 | op-snap---monthly-publication-january-2026.pdf | 265 | 2026-01 | Car | Toyota | Auris | Black | Driving without Due Care and Attention | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5170745 | -1.9012542 | ||
| 10854 | op-snap---monthly-publication-january-2026.pdf | 315 | 2026-01 | Car | Toyota | Verso | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 10859 | op-snap---monthly-publication-january-2026.pdf | 320 | 2026-01 | Car | Toyota | Yaris | Green | Contravening a Red Traffic Light | No Insurance | Alcester Road | Alcester Road | Birmingham | Birmingham | Court | N/A | 52.4470686 | -1.8880749 | ||
| 10946 | op-snap---monthly-publication-january-2026.pdf | 407 | 2026-01 | Car | Toyota | yaris | Grey | Driving without Due Care and Attention | None | The Green | The Green | Birmingham | Birmingham | Education | N/A | 52.547254 | -1.8143667 | ||
| 10968 | op-snap---monthly-publication-january-2026.pdf | 429 | 2026-01 | Car | Toyota | Aygo | 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 | ||
| 11012 | op-snap---monthly-publication-january-2026.pdf | 473 | 2026-01 | Car | Toyota | Yaris | Silver | Contravening a Red Traffic Light | None | harrier Way to A34 | harrier Way to A34 | Birmingham | Birmingham | Education | N/A | ||||
| 11037 | op-snap---monthly-publication-january-2026.pdf | 498 | 2026-01 | Car | Toyota | Corolla | Black | Driving without Due Care and Attention | None | Linden Lea junction | Linden Lea junction | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 11044 | op-snap---monthly-publication-january-2026.pdf | 505 | 2026-01 | Car | Toyota | Verso | 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 | ||
| 11050 | op-snap---monthly-publication-january-2026.pdf | 511 | 2026-01 | Car | Toyota | Corolla | silver | Driving without Due Care and Attention | None | Sutton Road, Erdington | Sutton Road, Erdington | Birmingham | Birmingham | Court | N/A | 52.5339483 | -1.8285296 | ||
| 11067 | op-snap---monthly-publication-january-2026.pdf | 528 | 2026-01 | Car | Toyota | Avensis | Blue | Driving without Due Care and Attention | None | Berkeley Road East | Berkeley Road East | Birmingham | Birmingham | Education | N/A | 52.4658801 | -1.8290005 | ||
| 11099 | op-snap---monthly-publication-january-2026.pdf | 560 | 2026-01 | Car | Toyota | Prius | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11100 | op-snap---monthly-publication-january-2026.pdf | 561 | 2026-01 | Car | Toyota | Yaris | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11102 | op-snap---monthly-publication-january-2026.pdf | 563 | 2026-01 | Car | Toyota | Prius | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11164 | op-snap---monthly-publication-january-2026.pdf | 625 | 2026-01 | Car | Toyota | Prius | White | Driving without Due Care and Attention | Driving without Due Care and Attention | Five Ways Roundabout, Birmingham | Five Ways Roundabout, Birmingham | Birmingham | Birmingham | Court | N/A | ||||
| 11180 | op-snap---monthly-publication-january-2026.pdf | 641 | 2026-01 | Car | Toyota | Aygo | Purple | Driving without Due Care and Attention | None | Yardley Green Road | Yardley Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4764154 | -1.8311418 | ||
| 11184 | op-snap---monthly-publication-january-2026.pdf | 645 | 2026-01 | Car | Toyota | ... | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 11202 | op-snap---monthly-publication-january-2026.pdf | 663 | 2026-01 | Car | Toyota | Corolla | Silver | Contravening a Red Traffic Light | None | Reddings Lane Tysley | Reddings Lane Tysley | Birmingham | Birmingham | Education | N/A | ||||
| 11204 | op-snap---monthly-publication-january-2026.pdf | 665 | 2026-01 | Car | Toyota | Prius | Black | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4726661 | -1.8769032 | ||
| 11230 | op-snap---monthly-publication-january-2026.pdf | 691 | 2026-01 | Car | Toyota | Yaris | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11240 | op-snap---monthly-publication-january-2026.pdf | 701 | 2026-01 | Car | Toyota | Yaris | Silver | Cause vehicle to be left in a dangerous position | None | Ellesmere Road | Ellesmere Road | Birmingham | Birmingham | Education | N/A | 52.4881533 | -1.8553625 | ||
| 11269 | op-snap---monthly-publication-january-2026.pdf | 730 | 2026-01 | Car | Toyota | Yaris | 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 | ||
| 11291 | op-snap---monthly-publication-january-2026.pdf | 752 | 2026-01 | Car | Toyota | C-HR | Grey | Driving without Due Care and Attention | None | Bordesley Green Road | Bordesley Green Road | Birmingham | Birmingham | Education | N/A | 52.4804926 | -1.8563658 | ||
| 11319 | op-snap---monthly-publication-january-2026.pdf | 780 | 2026-01 | Car | Toyota | Auris | White | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11320 | op-snap---monthly-publication-january-2026.pdf | 781 | 2026-01 | Car | Toyota | Prius | Grey | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11325 | op-snap---monthly-publication-january-2026.pdf | 786 | 2026-01 | Car | Toyota | Yaris | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 11391 | op-snap---monthly-publication-january-2026.pdf | 852 | 2026-01 | Car | Toyota | Yaris | White | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | ||
| 11497 | op-snap---monthly-publication-january-2026.pdf | 958 | 2026-01 | Car | Toyota | Yaris | Grey | Driving without Due Care and Attention | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Education | N/A | 52.4679402 | -1.881408 | ||
| 11509 | op-snap---monthly-publication-january-2026.pdf | 970 | 2026-01 | Car | Toyota | Prius | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 11520 | op-snap---monthly-publication-january-2026.pdf | 981 | 2026-01 | Car | Toyota | Auris | Red | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 11561 | op-snap---monthly-publication-january-2026.pdf | 1022 | 2026-01 | Car | Toyota | Yaris | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11601 | op-snap---monthly-publication-january-2026.pdf | 1062 | 2026-01 | Car | Toyota | Aygo | White | Contravening a Red Traffic Light | None | Meadway | Meadway | Birmingham | Birmingham | Education | N/A | 52.4783348 | -1.8007708 |
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);