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'}
547 rows where vehicle_make = "Renault" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale, witness_contacted
offence >30
- Driving without Due Care and Attention 149
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 70
- Contravening a Red Traffic Light 56
- Using a Mobile Phone Whilst Driving 53
- Cause vehicle to be left in a dangerous position 49
- Driving without Reasonable Consideration 39
- Stop a vehicle within pelican pedestrian crossing limits 38
- Misc - Non Traffic Offences 22
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 10
- Stop a vehicle on pedestrian crossing 9
- Cause unnecessary obstruction by motor vehicle 8
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 5
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 5
- Drive on hard shoulder 4
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 3
- 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 equipmen 3
- No Insurance 3
- Prohibited vehicle in offside lane of motorway 3
- Motor vehicle fail to accord precedence at a pelican crossing 2
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
- / trailer outside of the Greater London area 1
- Drive / Ride / Lead an animal on a footpath 1
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Drive a vehicle other than on the carriageway of a motorway 1
- Fail to Conform to Cycle Lane 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq 1
- Stop a vehicle within pelican pedestrian crossing l 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
- …
council_area 17
- Birmingham 285
- Out of Force Area 45
- Coventry 41
- Wolverhampton 40
- Dudley 36
- Solihull 33
- Sandwell 27
- Walsall 19
- Sutton Coldfield 10
- Banirdm Tinhgeh Qaem Hospital 1
- Boiurmt Oinf Gfhoarmce 1
- Halesowen 1
- Hbeiramthingham 1
- Metropolitan Borough 1
- Rsohuirte O)F Force Area 1
- Ublilrmingham 1
- Wcaoyventry 1
month 14
reporter_transport_mode 7
- Car 291
- Pedestrian 144
- Pedal Bike 88
- Other 19
- Lorry 2
- car 2
- Motorbike 1
disposal 7
- NFA 195
- Warning Letter 142
- Fixed Penalty 115
- Education 71
- Court 21
- RTC - Actioned 2
- Other Action Taken 1
vehicle_make 1
- Renault · 547 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8849 | op-snap---monthly-publication-february-2026.pdf | 1596 | 2026-02 | Car | Renault | master | White | Stop a vehicle within pelican pedestrian crossing limits | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 8741 | op-snap---monthly-publication-february-2026.pdf | 1488 | 2026-02 | Car | Renault | Traffic | Grey | Driving without Due Care and Attention | None | Hawford Lock Lane (West Mercia) | Hawford Lock Lane (West Mercia) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8598 | op-snap---monthly-publication-february-2026.pdf | 1345 | 2026-02 | Car | Renault | Clio | Grey | Contravening a Red Traffic Light | None | Green Lane | Green Lane | Walsall | Walsall | Education | N/A | 52.5995834 | -1.9971273 | ||
| 8571 | op-snap---monthly-publication-february-2026.pdf | 1318 | 2026-02 | Pedal Bike | Renault | Truck Master | White | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4415108 | -1.8971434 | ||
| 8520 | op-snap---monthly-publication-february-2026.pdf | 1267 | 2026-02 | Car | Renault | Kadjar | Grey | Driving without Due Care and Attention | None | Cinder Bank Island | Cinder Bank Island | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.5004694 | -2.0904035 | ||
| 8406 | op-snap---monthly-publication-february-2026.pdf | 1153 | 2026-02 | Car | Renault | Clio | Black | Driving without Due Care and Attention | None | Cumberland Avenue (Slough) | Cumberland Avenue (Slough) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8385 | op-snap---monthly-publication-february-2026.pdf | 1132 | 2026-02 | Car | Renault | Master | White | Driving without Due Care and Attention | None | A5 Shropshire | Shropshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8197 | op-snap---monthly-publication-february-2026.pdf | 944 | 2026-02 | Car | Renault | Austral | 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 | ||
| 8157 | op-snap---monthly-publication-february-2026.pdf | 904 | 2026-02 | Pedestrian | Renault | Clio | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holybank Road | Holybank Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 8121 | op-snap---monthly-publication-february-2026.pdf | 868 | 2026-02 | Car | Renault | trafic | White | Driving without Due Care and Attention | None | Bordesley Circus | Bordesley Circus | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4728608 | -1.8754722 | ||
| 7961 | op-snap---monthly-publication-february-2026.pdf | 708 | 2026-02 | Pedestrian | Renault | Zoe | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Springfield Road | Springfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4327486 | -1.8844997 | ||
| 7925 | op-snap---monthly-publication-february-2026.pdf | 672 | 2026-02 | Pedal Bike | Renault | Clio | White | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 7740 | op-snap---monthly-publication-february-2026.pdf | 487 | 2026-02 | Pedestrian | Renault | Clio | Silver | Cause vehicle to be left in a dangerous position | None | Somerset Road Erdington | Somerset Road Erdington | Birmingham | Birmingham | Education | N/A | 52.5312115 | -1.8440446 | ||
| 7642 | op-snap---monthly-publication-february-2026.pdf | 389 | 2026-02 | Car | Renault | Trafic | White | Driving without Due Care and Attention | None | A38M | A38M | Birmingham | Birmingham | NFA | No Offence | ||||
| 7589 | op-snap---monthly-publication-february-2026.pdf | 336 | 2026-02 | Car | Renault | Clio | Blue | Misc - Non Traffic Offences | None | Basford (Staffs) | Basford (Staffs) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7537 | op-snap---monthly-publication-february-2026.pdf | 284 | 2026-02 | Car | Renault | Megane | Silver | Driving without Due Care and Attention | None | Bradley Lane | Bradley Lane | Birmingham | Birmingham | NFA | No VRM | ||||
| 7439 | op-snap---monthly-publication-february-2026.pdf | 186 | 2026-02 | Car | Renault | Captur | Black | Using a Mobile Phone Whilst Driving | None | New Birmingham Road, Oldbury | New Birmingham Road, Oldbury | Sandwell | Sandwell | Fixed Penalty | N/A | 52.504392 | -2.0346032 | ||
| 7394 | op-snap---monthly-publication-february-2026.pdf | 141 | 2026-02 | Car | Renault | Clio | Grey | 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 | ||
| 11893 | op-snap---monthly-publication-january-2026.pdf | 1354 | 2026-01 | Car | Renault | Master | Grey | Contravening a Red Traffic Light | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6291998 | -2.126312 | ||
| 11879 | op-snap---monthly-publication-january-2026.pdf | 1340 | 2026-01 | Motorbike | Renault | Zoe | White | Using a Mobile Phone Whilst Driving | None | Frank Street | Frank Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4643146 | -1.8879566 | ||
| 11847 | op-snap---monthly-publication-january-2026.pdf | 1308 | 2026-01 | Car | Renault | cLIO | White | Driving without Due Care and Attention | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6291998 | -2.126312 | ||
| 11820 | op-snap---monthly-publication-january-2026.pdf | 1281 | 2026-01 | Car | Renault | Master | 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 | ||
| 11645 | op-snap---monthly-publication-january-2026.pdf | 1106 | 2026-01 | Pedestrian | Renault | Clio | Orange | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 11440 | op-snap---monthly-publication-january-2026.pdf | 901 | 2026-01 | Other | Renault | Clio | Blue | Driving without Due Care and Attention | None | Waterfront Carpark 7 | Waterfront Carpark 7 | Dudley | Dudley | Warning Letter | N/A | ||||
| 11407 | op-snap---monthly-publication-january-2026.pdf | 868 | 2026-01 | Pedestrian | Renault | Megane | Black | Cause vehicle to be left in a dangerous position | None | Marlpool Lane, Kidderminster | Marlpool Lane, Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11322 | op-snap---monthly-publication-january-2026.pdf | 783 | 2026-01 | Car | Renault | Captur | White | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.502683 | -1.9033516 | ||
| 11321 | op-snap---monthly-publication-january-2026.pdf | 782 | 2026-01 | Car | Renault | Captur | Black | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Grosvenor Road | Grosvenor Road | Birmingham | Birmingham | Court | N/A | 52.4613204 | -1.9681665 | ||
| 11298 | op-snap---monthly-publication-january-2026.pdf | 759 | 2026-01 | Pedestrian | Renault | Megane | Silver | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 11290 | op-snap---monthly-publication-january-2026.pdf | 751 | 2026-01 | Car | Renault | Austral | White | Driving without Reasonable Consideration | None | Bescor Road M6 j9 | Bescor Road M6 j9 | Walsall | Walsall | Education | N/A | ||||
| 11280 | op-snap---monthly-publication-january-2026.pdf | 741 | 2026-01 | Car | Renault | Clio | Beige | Contravening a Red Traffic Light | None | Venture Way Brierley Hill | Venture Way Brierley Hill | Dudley | Dudley | Education | N/A | 52.4845535 | -2.1206737 | ||
| 11278 | op-snap---monthly-publication-january-2026.pdf | 739 | 2026-01 | Car | Renault | Modus | Blue | Driving without Due Care and Attention | None | Willnhall (no exact location) | Willnhall (no exact location) | Wolverhampton | Wolverhampton | NFA | Outside of 14 DAYS Late Submission | ||||
| 11259 | op-snap---monthly-publication-january-2026.pdf | 720 | 2026-01 | Car | Renault | Trafic | Silver | Driving without Due Care and Attention | None | Tyburn House Island | Tyburn House Island | Birmingham | Birmingham | Warning Letter | N/A | 52.5194011 | -1.8008643 | ||
| 11254 | op-snap---monthly-publication-january-2026.pdf | 715 | 2026-01 | Pedestrian | Renault | Megane | Silver | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 11248 | op-snap---monthly-publication-january-2026.pdf | 709 | 2026-01 | Car | Renault | Trafic | White | Driving without Due Care and Attention | None | Shenstone | Shenstone | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4511925 | -2.0425648 | ||
| 11216 | op-snap---monthly-publication-january-2026.pdf | 677 | 2026-01 | Pedal Bike | Renault | Megane | Grey | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 11090 | op-snap---monthly-publication-january-2026.pdf | 551 | 2026-01 | Pedestrian | Renault | Clio | Blue | Using a Mobile Phone Whilst Driving | None | out of force blackpool | Out Of Force Blackpool | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11077 | op-snap---monthly-publication-january-2026.pdf | 538 | 2026-01 | Pedal Bike | Renault | Megane | Gold | Using a Mobile Phone Whilst Driving | No Seat Belt | Alcester Road | Alcester Road | Birmingham | Birmingham | Court | N/A | 52.4470686 | -1.8880749 | ||
| 11065 | op-snap---monthly-publication-january-2026.pdf | 526 | 2026-01 | Pedal Bike | Renault | HGV | White | Contravening a Red Traffic Light | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Offence | 52.4552785 | -1.906384 | ||
| 11029 | op-snap---monthly-publication-january-2026.pdf | 490 | 2026-01 | Car | Renault | Traffic | White | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 10976 | op-snap---monthly-publication-january-2026.pdf | 437 | 2026-01 | Car | Renault | Megane | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 10877 | op-snap---monthly-publication-january-2026.pdf | 338 | 2026-01 | Car | Renault | Master | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 10689 | op-snap---monthly-publication-january-2026.pdf | 150 | 2026-01 | Car | Renault | Clio | Silver | Stop a vehicle on pedestrian crossing | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 10675 | op-snap---monthly-publication-january-2026.pdf | 136 | 2026-01 | Car | Renault | Clio | 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 | ||
| 5058 | op-snap---monthly-publication-december-2025.pdf | 1186 | 2025-12 | Car | Renault | Trafic | White | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Court | N/A | 52.5458699 | -1.9304484 | ||
| 5036 | op-snap---monthly-publication-december-2025.pdf | 1164 | 2025-12 | Pedestrian | Renault | clio | black | Cause vehicle to be left in a dangerous position | None | wattville road | Wattville Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5063926 | -1.9548648 | ||
| 5004 | op-snap---monthly-publication-december-2025.pdf | 1132 | 2025-12 | Pedestrian | Renault | Scenic | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4929304 | -1.8229092 | ||
| 4971 | op-snap---monthly-publication-december-2025.pdf | 1099 | 2025-12 | Pedestrian | Renault | captur | Black | Misc - Non Traffic Offences | None | petersfield road | Petersfield Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4307 | -1.8494663 | ||
| 4955 | op-snap---monthly-publication-december-2025.pdf | 1083 | 2025-12 | Pedestrian | Renault | scenic | Grey | Misc - Non Traffic Offences | None | flavell avenue | Flavell Avenue | Wolverhampton | Wolverhampton | NFA | No Offence | ||||
| 4901 | op-snap---monthly-publication-december-2025.pdf | 1029 | 2025-12 | Car | Renault | Kangoo | White | Driving without Due Care and Attention | None | M1 Luton | M1 Luton | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4460842 | -1.9286676 | ||
| 4890 | op-snap---monthly-publication-december-2025.pdf | 1018 | 2025-12 | Car | Renault | Megane | Blue | Misc - Non Traffic Offences | None | Lauderdale Gardens | Lauderdale Gardens | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | 52.6283075 | -2.1143864 | ||
| 4874 | op-snap---monthly-publication-december-2025.pdf | 1002 | 2025-12 | Car | Renault | Captur | Black | Misc - Non Traffic Offences | Use vehicle on a road withou | tI lvsaalnidd tReosat dc ertificate | t I lvsaalnidd t Reosat dc ertificate | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 4827 | op-snap---monthly-publication-december-2025.pdf | 955 | 2025-12 | Car | Renault | Captur | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Warning Letter | N/A | 52.4191184 | -1.8326637 | ||
| 4665 | op-snap---monthly-publication-december-2025.pdf | 793 | 2025-12 | Pedal Bike | Renault | Master | White | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 4660 | op-snap---monthly-publication-december-2025.pdf | 788 | 2025-12 | Car | Renault | Arkana | Grey | Driving without Due Care and Attention | None | A5 Shrewsbury | Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6195535 | -2.0193824 | ||
| 4628 | op-snap---monthly-publication-december-2025.pdf | 756 | 2025-12 | Car | Renault | Captur | Black | Using a Mobile Phone Whilst Driving | None | M5 Southbound, jn 6 to 7 | M5 Southbound, jn 6 to 7 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4602 | op-snap---monthly-publication-december-2025.pdf | 730 | 2025-12 | Pedestrian | Renault | Clio | Black | Driving without Due Care and Attention | None | Shrewsbury Road | Shrewsbury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4589 | op-snap---monthly-publication-december-2025.pdf | 717 | 2025-12 | Pedestrian | Renault | Clio | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq | Nuiopnmeent | Rosebery Road, Cape Hill | Rosebery Road, Cape Hill | Sandwell | Sandwell | Warning Letter | N/A | 52.4878382 | -1.9570553 | ||
| 4568 | op-snap---monthly-publication-december-2025.pdf | 696 | 2025-12 | Pedestrian | Renault | Clio | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Bromford Road, Hodge Hill | Bromford Road, Hodge Hill | Birmingham | Birmingham | Fixed Penalty | N/A | 52.503036 | -1.8289972 | ||
| 4517 | op-snap---monthly-publication-december-2025.pdf | 645 | 2025-12 | Pedestrian | Renault | traffic | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | regent road | Regent Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5077359 | -1.9452509 | ||
| 4494 | op-snap---monthly-publication-december-2025.pdf | 622 | 2025-12 | Car | Renault | Master | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | OOF Worcester | OOF Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4475 | op-snap---monthly-publication-december-2025.pdf | 603 | 2025-12 | Car | Renault | Trafic | Silver | Driving without Due Care and Attention | None | Finchfield Road | Finchfield Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.5805119 | -2.1581621 | ||
| 4403 | op-snap---monthly-publication-december-2025.pdf | 531 | 2025-12 | Car | Renault | Kangoo | White | Driving without Due Care and Attention | None | M6 SB 10a-10 | M6 Southbound 10a-10 | Wolverhampton | Wolverhampton | Court | N/A | ||||
| 4331 | op-snap---monthly-publication-december-2025.pdf | 459 | 2025-12 | Pedal Bike | Renault | Master | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 4288 | op-snap---monthly-publication-december-2025.pdf | 416 | 2025-12 | Pedal Bike | Renault | Megane | Grey | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 4265 | op-snap---monthly-publication-december-2025.pdf | 393 | 2025-12 | Car | Renault | G-ESPACE | Grey | Using a Mobile Phone Whilst Driving | None | Alder Drive | Alder Drive | Solihull | Solihull | Fixed Penalty | N/A | 52.4752281 | -1.7368602 | ||
| 4185 | op-snap---monthly-publication-december-2025.pdf | 313 | 2025-12 | Car | Renault | Traffic | White | Driving without Due Care and Attention | None | Darthmouth middleway | Darthmouth middleway | Birmingham | Birmingham | Education | N/A | ||||
| 4176 | op-snap---monthly-publication-december-2025.pdf | 304 | 2025-12 | Car | Renault | Master | White | Using a Mobile Phone Whilst Driving | None | Pale Street Upper Gornal | Pale Street Upper Gornal | Dudley | Dudley | Fixed Penalty | N/A | 52.525959 | -2.1142205 | ||
| 4132 | op-snap---monthly-publication-december-2025.pdf | 260 | 2025-12 | Pedestrian | Renault | Captur | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Petersfield Road | Petersfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4307 | -1.8494663 | ||
| 4124 | op-snap---monthly-publication-december-2025.pdf | 252 | 2025-12 | Car | Renault | Master | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 4061 | op-snap---monthly-publication-december-2025.pdf | 189 | 2025-12 | Car | Renault | Clio | Blue | Driving without Due Care and Attention | None | A41 Black Country New Road | Black Country New Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5527191 | -2.0312967 | ||
| 4049 | op-snap---monthly-publication-december-2025.pdf | 177 | 2025-12 | Pedal Bike | Renault | Black | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | |||
| 4047 | op-snap---monthly-publication-december-2025.pdf | 175 | 2025-12 | Pedal Bike | Renault | Clio | Black | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 4041 | op-snap---monthly-publication-december-2025.pdf | 169 | 2025-12 | Pedal Bike | Renault | Kadjar | Black | Driving without Due Care and Attention | None | Lincoln Street | Lincoln Street | Birmingham | Birmingham | Court | N/A | 52.459298 | -1.8933648 | ||
| 4026 | op-snap---monthly-publication-december-2025.pdf | 154 | 2025-12 | Other | Renault | Clio | Blue | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Education | N/A | 52.4831397 | -2.1309273 | ||
| 4005 | op-snap---monthly-publication-december-2025.pdf | 133 | 2025-12 | Car | Renault | Capture | Red | Driving without Due Care and Attention | None | Shenley Fields Road | Shenley Fields Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4373076 | -1.9543847 | ||
| 3997 | op-snap---monthly-publication-december-2025.pdf | 125 | 2025-12 | Car | Renault | Truck | White | Contravening a Red Traffic Light | None | Newport Road, Castle Bromwich | Newport Road, Castle Bromwich | Birmingham | Birmingham | Education | N/A | ||||
| 3962 | op-snap---monthly-publication-december-2025.pdf | 90 | 2025-12 | Pedestrian | Renault | Captur | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Huntingree road | Huntingree road | Dudley | Dudley | Warning Letter | N/A | ||||
| 3950 | op-snap---monthly-publication-december-2025.pdf | 78 | 2025-12 | Pedestrian | Renault | Master | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Withymoor Road | Withymoor Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4871674 | -2.0702998 | ||
| 3911 | op-snap---monthly-publication-december-2025.pdf | 39 | 2025-12 | Car | Renault | Twingo | Red | Using a Mobile Phone Whilst Driving | None | Bloomfield Road | Bloomfield Road | Birmingham | Birmingham | NFA | No Offence | 52.4480767 | -1.8755275 | ||
| 3901 | op-snap---monthly-publication-december-2025.pdf | 29 | 2025-12 | Pedestrian | Renault | Scenic | Blue | Misc - Non Traffic Offences | None | Barton Drive | Barton Drive | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 3889 | op-snap---monthly-publication-december-2025.pdf | 17 | 2025-12 | Car | Renault | Scenic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barton Drive | Barton Drive | Solihull | Solihull | NFA | No Offence | 52.3770722 | -1.7420909 | ||
| 3879 | op-snap---monthly-publication-december-2025.pdf | 7 | 2025-12 | Car | Renault | Lorry | White | Driving without Due Care and Attention | None | M6 | M6 | Coventry | Coventry | NFA | No Offence | ||||
| 21941 | op-snap---monthly-publication-november-2025.pdf | 1483 | 2025-11 | Pedestrian | Renault | megane | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | castle bromwhich | Castle Bromwhich | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 21784 | op-snap---monthly-publication-november-2025.pdf | 1326 | 2025-11 | Pedestrian | Renault | clio | Blue | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 21753 | op-snap---monthly-publication-november-2025.pdf | 1295 | 2025-11 | Pedal Bike | Renault | traffic | Silver | Cause vehicle to be left in a dangerous position | None | easrlsdon street | Easrlsdon Street | Coventry | Coventry | Warning Letter | N/A | ||||
| 21747 | op-snap---monthly-publication-november-2025.pdf | 1289 | 2025-11 | Pedestrian | Renault | traffic | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | ash street | Ash Street | Dudley | Dudley | Warning Letter | N/A | 52.6194553 | -1.9924281 | ||
| 21746 | op-snap---monthly-publication-november-2025.pdf | 1288 | 2025-11 | Pedestrian | Renault | traffic | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lawrense lane | Lawrense Lane | Dudley | Dudley | Warning Letter | N/A | ||||
| 21730 | op-snap---monthly-publication-november-2025.pdf | 1272 | 2025-11 | Pedestrian | Renault | clio | Blue | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4552786 | -1.824914 | ||
| 21536 | op-snap---monthly-publication-november-2025.pdf | 1078 | 2025-11 | Pedestrian | Renault | traffic | White | Cause vehicle to be left in a dangerous position | None | startford road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 21452 | op-snap---monthly-publication-november-2025.pdf | 994 | 2025-11 | Car | Renault | Scenic | blue | Misc - Non Traffic Offences | None | Barton Drive | Barton Drive | Solihull | Solihull | NFA | No Offence | 52.3770722 | -1.7420909 | ||
| 21390 | op-snap---monthly-publication-november-2025.pdf | 932 | 2025-11 | Car | Renault | Blue | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | A442 | A442 | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 21384 | op-snap---monthly-publication-november-2025.pdf | 926 | 2025-11 | Pedal Bike | Renault | Megane | Black | Using a Mobile Phone Whilst Driving | None | Hinckley Road | Hinckley Road | Coventry | Coventry | Fixed Penalty | N/A | 52.435502 | -1.4327166 | ||
| 21358 | op-snap---monthly-publication-november-2025.pdf | 900 | 2025-11 | Pedestrian | Renault | megane | blue | Cause vehicle to be left in a dangerous position | None | the oval | The Oval | Birmingham | Birmingham | Warning Letter | N/A | 52.4577754 | -1.8692099 | ||
| 21341 | op-snap---monthly-publication-november-2025.pdf | 883 | 2025-11 | Other | Renault | scenic | Black | Misc - Non Traffic Offences | None | hertford way | Hertford Way | Solihull | Solihull | NFA | Misc Inc Crimes | 52.3778812 | -1.7427424 | ||
| 21284 | op-snap---monthly-publication-november-2025.pdf | 826 | 2025-11 | Pedestrian | Renault | master | White | Cause vehicle to be left in a dangerous position | None | wentworth road | Wentworth Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5773229 | -1.8324449 | ||
| 21279 | op-snap---monthly-publication-november-2025.pdf | 821 | 2025-11 | Pedestrian | Renault | clio | Red | Misc - Non Traffic Offences | None | fenton raod | Fenton Raod | Coventry | Coventry | NFA | Misc Inc Crimes | ||||
| 21214 | op-snap---monthly-publication-november-2025.pdf | 756 | 2025-11 | Pedal Bike | Renault | Captur | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Camp Lane | Camp Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5144871 | -1.9539012 | ||
| 21211 | op-snap---monthly-publication-november-2025.pdf | 753 | 2025-11 | Pedestrian | Renault | Master | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wentworth Road | Wentworth Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5773229 | -1.8324449 | ||
| 21166 | op-snap---monthly-publication-november-2025.pdf | 708 | 2025-11 | Pedestrian | Renault | Megane | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21136 | op-snap---monthly-publication-november-2025.pdf | 678 | 2025-11 | Pedestrian | Renault | Clio | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5521118 | -1.8845138 |
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);