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'}
1,352 rows where council_area = "Birmingham" 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
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 282
- Driving without Due Care and Attention 225
- Cause vehicle to be left in a dangerous position 181
- Contravening a Red Traffic Light 161
- Stop a vehicle within pelican pedestrian crossing limits 120
- Using a Mobile Phone Whilst Driving 74
- Driving without Reasonable Consideration 61
- Misc - Non Traffic Offences 41
- Stop a vehicle on pedestrian crossing 41
- Cause unnecessary obstruction by motor vehicle 34
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 34
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 24
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 12
- Contravene Lane Closure Red X 9
- Motor vehicle fail to accord precedence at a pelican crossing 6
- Driving a vehicle wholly or partly on a footpath 5
- Drive a vehicle other than on the carriageway of a motorway 4
- Drive on hard shoulder 4
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 4
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 4
- Driver not in position to have Proper Control 3
- No Insurance 3
- Driver parked on pedestrian road marked by a white “Zig-zag line” 2
- Duplicate Submission 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- Vehicle overtake within crossing limits 2
- Waiting on a road in a prohibited area 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
- …
month 14
reporter_transport_mode 8
- Car 775
- Pedestrian 367
- Pedal Bike 166
- Other 37
- Bus 3
- Motorbike 2
- CAR 1
- Van 1
disposal 8
- Warning Letter 467
- NFA 317
- Education 261
- Fixed Penalty 258
- Court 33
- Other Action Taken 7
- Duplicate Submission 5
- RTC - Actioned 4
vehicle_make 1
- Toyota · 1,352 ✖
council_area 1
- Birmingham · 1,352 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7279 | op-snap---monthly-publication-february-2026.pdf | 26 | 2026-02 | Pedestrian | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Runcorn Road | Runcorn Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.455063 | -1.8819935 | ||
| 7285 | op-snap---monthly-publication-february-2026.pdf | 32 | 2026-02 | Pedestrian | Toyota | Yaris | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Horrell Road | Horrell Road | Birmingham | Birmingham | Warning Letter | N/A | 52.464186 | -1.7873409 | ||
| 7295 | op-snap---monthly-publication-february-2026.pdf | 42 | 2026-02 | Pedal Bike | Toyota | Corolla | Grey | Using a Mobile Phone Whilst Driving | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4390303 | -1.9512931 | ||
| 7297 | op-snap---monthly-publication-february-2026.pdf | 44 | 2026-02 | Pedal Bike | Toyota | Prius | Red | Driving without Due Care and Attention | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Education | N/A | 52.4150779 | -1.930901 | ||
| 7299 | op-snap---monthly-publication-february-2026.pdf | 46 | 2026-02 | Pedal Bike | Toyota | Auris | Brown | Driving without Due Care and Attention | None | Franklin Road | Franklin Road | Birmingham | Birmingham | Education | N/A | 52.4195456 | -1.9350703 | ||
| 7310 | op-snap---monthly-publication-february-2026.pdf | 57 | 2026-02 | Pedestrian | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4306504 | -1.878052 | ||
| 7321 | op-snap---monthly-publication-february-2026.pdf | 68 | 2026-02 | Pedestrian | Toyota | Corolla | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4306504 | -1.878052 | ||
| 7323 | op-snap---monthly-publication-february-2026.pdf | 70 | 2026-02 | Pedestrian | Toyota | Yaris | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4306504 | -1.878052 | ||
| 7325 | op-snap---monthly-publication-february-2026.pdf | 72 | 2026-02 | Pedestrian | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4306504 | -1.878052 | ||
| 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 | ||
| 7369 | op-snap---monthly-publication-february-2026.pdf | 116 | 2026-02 | Pedestrian | Toyota | Estima | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Showell Green Lane | Showell Green Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4474637 | -1.8691688 | ||
| 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 | ||
| 7426 | op-snap---monthly-publication-february-2026.pdf | 173 | 2026-02 | Pedal Bike | Toyota | Estima | Silver | Driving without Due Care and Attention | None | Weoley Park Road | Weoley Park Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4368136 | -1.9495478 | ||
| 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 | ||
| 7531 | op-snap---monthly-publication-february-2026.pdf | 278 | 2026-02 | Pedestrian | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Yardley Green Road | Yardley Green Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4764154 | -1.8311418 | ||
| 7552 | op-snap---monthly-publication-february-2026.pdf | 299 | 2026-02 | Pedestrian | Toyota | Prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Sheldonfield Road | Sheldonfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4544266 | -1.7678848 | ||
| 7554 | op-snap---monthly-publication-february-2026.pdf | 301 | 2026-02 | Pedal Bike | Toyota | Yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Braford Street | Braford Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 7686 | op-snap---monthly-publication-february-2026.pdf | 433 | 2026-02 | Pedestrian | Toyota | CHR | White | Misc - Non Traffic Offences | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | NFA | No Offence | 52.4221526 | -1.8425617 | ||
| 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 | ||
| 7843 | op-snap---monthly-publication-february-2026.pdf | 590 | 2026-02 | Pedal Bike | Toyota | Prius | Black | Driving without Due Care and Attention | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | Education | N/A | 52.4391028 | -1.893289 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 |
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);