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'}
137 rows where offence = "Use a vehicle / cycle on a road and contravene a local traffic order other than parking" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 27
month 12
council_area 10
- Birmingham 94
- Coventry 12
- Sandwell 10
- Sutton Coldfield 9
- Dudley 3
- Out of Force Area 3
- Solihull 2
- Wolverhampton 2
- Metropolitan Borough 1
- Walsall 1
disposal 5
- Warning Letter 68
- Fixed Penalty 34
- NFA 33
- Court 1
- Education 1
reporter_transport_mode 1
- Car · 137 ✖
offence 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking · 137 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10672 | op-snap---monthly-publication-january-2026.pdf | 133 | 2026-01 | Car | BMW | 320d | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High Street, Deritend | High Street, Deritend | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4746492 | -1.8839977 | ||
| 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 | ||
| 10733 | op-snap---monthly-publication-january-2026.pdf | 194 | 2026-01 | Car | Citroen | C4 | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Walmley Road | Walmley Road | Birmingham | Birmingham | NFA | No Offence | 52.5534398 | -1.7987049 | ||
| 10756 | op-snap---monthly-publication-january-2026.pdf | 217 | 2026-01 | Car | Vauxhall | Corsa | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 10960 | op-snap---monthly-publication-january-2026.pdf | 421 | 2026-01 | Car | Toyota | Estima | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | McKean Road | Mc Kean Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5077405 | -2.0124813 | ||
| 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 | ||
| 11127 | op-snap---monthly-publication-january-2026.pdf | 588 | 2026-01 | Car | Nissan | Note | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Island Road | Island Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5095686 | -1.9544485 | ||
| 11644 | op-snap---monthly-publication-january-2026.pdf | 1105 | 2026-01 | Car | Citroen | C4.. | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road at Edwards Road. | Moseley Road at Edwards Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4679402 | -1.881408 | ||
| 11720 | op-snap---monthly-publication-january-2026.pdf | 1181 | 2026-01 | Car | Honda | Civic | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bordesley Green East | Bordesley Green East | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4802441 | -1.8327073 | ||
| 4382 | op-snap---monthly-publication-december-2025.pdf | 510 | 2025-12 | Car | Toyota | Corolla | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4450 | op-snap---monthly-publication-december-2025.pdf | 578 | 2025-12 | Car | BMW | Mini | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Long Street, Atherstone | Long Street, Atherstone | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4574 | op-snap---monthly-publication-december-2025.pdf | 702 | 2025-12 | Car | Kia | Stinger | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High St, Aston | High Street, Aston | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4973154 | -1.8956143 | ||
| 4575 | op-snap---monthly-publication-december-2025.pdf | 703 | 2025-12 | Car | Toyota | Prius | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High St Aston | High Street Aston | Birmingham | Birmingham | Fixed Penalty | N/A | 52.500816 | -1.8965601 | ||
| 5006 | op-snap---monthly-publication-december-2025.pdf | 1134 | 2025-12 | Car | Hyundai | I10 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4762433 | -1.9176665 | ||
| 20465 | op-snap---monthly-publication-november-2025.pdf | 7 | 2025-11 | Car | Ferrari | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bath Row, Birmingham | Bath Row, Birmingham | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4729953 | -1.905901 | |||
| 20479 | op-snap---monthly-publication-november-2025.pdf | 21 | 2025-11 | Car | Audi | Q3. | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Church Street at Edmund Street | Church Street at Edmund Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5020781 | -1.9122368 | ||
| 20776 | op-snap---monthly-publication-november-2025.pdf | 318 | 2025-11 | Car | Toyota | Prius | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | No Offence | 52.4679402 | -1.881408 | ||
| 20834 | op-snap---monthly-publication-november-2025.pdf | 376 | 2025-11 | Car | Citroen | C3 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Alcester Rd | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 20940 | op-snap---monthly-publication-november-2025.pdf | 482 | 2025-11 | Car | Nissan | Leaf | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Midlands Road | Midlands Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4525632 | -1.8279809 | ||
| 20971 | op-snap---monthly-publication-november-2025.pdf | 513 | 2025-11 | Car | Toyota | Prius | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 21153 | op-snap---monthly-publication-november-2025.pdf | 695 | 2025-11 | Car | Peugeot | 3008 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 21154 | op-snap---monthly-publication-november-2025.pdf | 696 | 2025-11 | Car | Suzuki | Swift | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4555288 | -1.8613929 | ||
| 21158 | op-snap---monthly-publication-november-2025.pdf | 700 | 2025-11 | Car | Mercedes-Benz | Dropside | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Soho Road | Soho Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502568 | -1.9305447 | ||
| 21765 | op-snap---monthly-publication-november-2025.pdf | 1307 | 2025-11 | Car | Skoda | Kamiq | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A452 Collector Road | Collector Road | Birmingham | Birmingham | NFA | No Offence | 52.5139393 | -1.7600186 | ||
| 21775 | op-snap---monthly-publication-november-2025.pdf | 1317 | 2025-11 | Car | Seat | Ibiza | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Nechells Parkway | Nechells Parkway | Birmingham | Birmingham | Education | N/A | 52.4922722 | -1.8711754 | ||
| 21947 | op-snap---monthly-publication-november-2025.pdf | 1489 | 2025-11 | Car | Nissan | Qashqai | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Warning Letter | N/A | 52.470423 | -1.9304786 | ||
| 22173 | op-snap---monthly-publication-october-2025.pdf | 123 | 2025-10 | Car | Kia | Ce'ed | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 22279 | op-snap---monthly-publication-october-2025.pdf | 229 | 2025-10 | Car | Volkswagen | Golf | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Warning Letter | N/A | 52.418488 | -1.5472387 | ||
| 22334 | op-snap---monthly-publication-october-2025.pdf | 284 | 2025-10 | Car | Kia | Sportage | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4745488 | -1.8065911 | ||
| 22391 | op-snap---monthly-publication-october-2025.pdf | 341 | 2025-10 | Car | Hyundai | I30 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Warren Farm Road | Warren Farm Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5424846 | -1.8794625 | ||
| 22422 | op-snap---monthly-publication-october-2025.pdf | 372 | 2025-10 | Car | Ford | C Max | Brown | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4679402 | -1.881408 | ||
| 22442 | op-snap---monthly-publication-october-2025.pdf | 392 | 2025-10 | Car | Audi | Q3 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Highgate Road | Highgate Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4606652 | -1.8791145 | ||
| 22543 | op-snap---monthly-publication-october-2025.pdf | 493 | 2025-10 | Car | Volkswagen | Golf | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4709298 | -1.8722585 | ||
| 22544 | op-snap---monthly-publication-october-2025.pdf | 494 | 2025-10 | Car | Mercedes-Benz | C220 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4709298 | -1.8722585 | ||
| 22625 | op-snap---monthly-publication-october-2025.pdf | 575 | 2025-10 | Car | Peugeot | Eurotaxi | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 22638 | op-snap---monthly-publication-october-2025.pdf | 588 | 2025-10 | Car | BMW | 116i | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 22724 | op-snap---monthly-publication-october-2025.pdf | 674 | 2025-10 | Car | Nissan | X-Trail | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Gulson Road | Gulson Road | Coventry | Coventry | NFA | No VRM | 52.4076795 | -1.4911676 | ||
| 22843 | op-snap---monthly-publication-october-2025.pdf | 793 | 2025-10 | Car | BMW | 118.. | Orange | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5170745 | -1.9012542 | ||
| 22873 | op-snap---monthly-publication-october-2025.pdf | 823 | 2025-10 | Car | Mini | Cooper | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Warning Letter | N/A | 52.470423 | -1.9304786 | ||
| 22916 | op-snap---monthly-publication-october-2025.pdf | 866 | 2025-10 | Car | Mercedes-Benz | Sprinter | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High Street, | High Street | Dudley | Dudley | Warning Letter | N/A | 52.4779764 | -2.1598371 | ||
| 23001 | op-snap---monthly-publication-october-2025.pdf | 951 | 2025-10 | Car | Peugeot | Partner | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Chester Road | Chester Road | Solihull | Solihull | Warning Letter | N/A | 52.5021946 | -1.7719526 | ||
| 23092 | op-snap---monthly-publication-october-2025.pdf | 1042 | 2025-10 | Car | Audi | A3 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | St Martins Road | Street Martins Road | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 23322 | op-snap---monthly-publication-october-2025.pdf | 1272 | 2025-10 | Car | Toyota | Pirus | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stontey Stanton | Stontey Stanton | Coventry | Coventry | Warning Letter | N/A | ||||
| 23731 | op-snap---monthly-publication-october-2025.pdf | 1681 | 2025-10 | Car | Cupra | Ateca | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | none | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 23732 | op-snap---monthly-publication-october-2025.pdf | 1682 | 2025-10 | Car | Mercedes-Benz | C220 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 23776 | op-snap---monthly-publication-october-2025.pdf | 1726 | 2025-10 | Car | Toyota | Prius | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Walsall Rd | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 2137 | op-snap---monthly-publication-august-2025.pdf | 112 | 2025-08 | Car | Ford | Kuga | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lottie Road | Lottie Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4393277 | -1.9383576 | ||
| 2457 | op-snap---monthly-publication-august-2025.pdf | 432 | 2025-08 | Car | Audi | Q3 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | New John Street West | New John Street West | Birmingham | Birmingham | Warning Letter | N/A | 52.4944784 | -1.9122329 | ||
| 2691 | op-snap---monthly-publication-august-2025.pdf | 666 | 2025-08 | Car | BMW | 520.. | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4221152 | -1.4959475 | ||
| 2703 | op-snap---monthly-publication-august-2025.pdf | 678 | 2025-08 | Car | Toyota | Prius | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bishops gate Street | Bishops gate Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 2910 | op-snap---monthly-publication-august-2025.pdf | 885 | 2025-08 | Car | Volkswagen | Passat | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A41 Newport | Newport | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.5027779 | -1.7982159 | ||
| 3150 | op-snap---monthly-publication-august-2025.pdf | 1125 | 2025-08 | Car | Audi | A3 | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bromford Road | Bromford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.503036 | -1.8289972 | ||
| 3335 | op-snap---monthly-publication-august-2025.pdf | 1310 | 2025-08 | Car | Ford | Transit | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4119174 | -1.9735247 | ||
| 12060 | op-snap---monthly-publication-july-2025.pdf | 112 | 2025-07 | Car | Mercedes-Benz | A 180.. | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bell Lane | Bell Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4178465 | -1.968864 | ||
| 12128 | op-snap---monthly-publication-july-2025.pdf | 180 | 2025-07 | Car | Skoda | Elroq | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Church Road | Church Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4624743 | -1.7763934 | ||
| 12177 | op-snap---monthly-publication-july-2025.pdf | 229 | 2025-07 | Car | Ssangyong taxi | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stetchford Lesiure Centre | Stetchford Lesiure Centre | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 12181 | op-snap---monthly-publication-july-2025.pdf | 233 | 2025-07 | Car | Ford | Puma | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Broadwell Road | Broadwell Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5043614 | -2.0104333 | ||
| 12182 | op-snap---monthly-publication-july-2025.pdf | 234 | 2025-07 | Car | Ford | Fiesta | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Braodwell Road | Braodwell Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 12530 | op-snap---monthly-publication-july-2025.pdf | 582 | 2025-07 | Car | Audi | TT | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Eardley Road, Streatham | Eardley Road, Streatham | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12540 | op-snap---monthly-publication-july-2025.pdf | 592 | 2025-07 | Car | Vauxhall | Astra | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Wednesfield Road | Wednesfield Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.5885601 | -2.122003 | ||
| 12628 | op-snap---monthly-publication-july-2025.pdf | 680 | 2025-07 | Car | Volkswagen | Tiguan | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 12681 | op-snap---monthly-publication-july-2025.pdf | 733 | 2025-07 | Car | Chysler | Grand Voyager | Beige | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | School Road | School Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4161736 | -1.8619692 | ||
| 12818 | op-snap---monthly-publication-july-2025.pdf | 870 | 2025-07 | Car | Skoda | Kamiq | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5919543 | -1.8517118 | ||
| 12976 | op-snap---monthly-publication-july-2025.pdf | 1028 | 2025-07 | Car | Mercedes-Benz | C250 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Spring Hill | Spring Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4854232 | -1.9218159 | ||
| 13022 | op-snap---monthly-publication-july-2025.pdf | 1074 | 2025-07 | Car | Mercedes-Benz | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | McKean Road Oldbury | Mc Kean Road Oldbury | Sandwell | Sandwell | NFA | No Independent Evidence Available | |||||
| 13322 | op-snap---monthly-publication-july-2025.pdf | 1374 | 2025-07 | Car | Mg | HS | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lee Bank Middleway | Lee Bank Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4677721 | -1.9037358 | ||
| 13324 | op-snap---monthly-publication-july-2025.pdf | 1376 | 2025-07 | Car | Ford | Transit | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Camp Hill Circus | Camp Hill Circus | Birmingham | Birmingham | Warning Letter | N/A | 52.4682339 | -1.8793662 | ||
| 13335 | op-snap---monthly-publication-july-2025.pdf | 1387 | 2025-07 | Car | Citroen | Dispatch | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Upper Holland Road | Upper Holland Road | Birmingham | Birmingham | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 13338 | op-snap---monthly-publication-july-2025.pdf | 1390 | 2025-07 | Car | Volvo | XC90 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | none | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 13358 | op-snap---monthly-publication-july-2025.pdf | 1410 | 2025-07 | Car | Volvo | Skip | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | none | M6 SOuth Jct 6 | M6 SOuth Junction 6 | Solihull | Solihull | Warning Letter | N/A | ||||
| 13759 | op-snap---monthly-publication-july-2025.pdf | 1811 | 2025-07 | Car | Ford | BMAX | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Barras Lane | Barras Lane | Coventry | Coventry | Warning Letter | N/A | 52.4109877 | -1.5203488 | ||
| 14001 | op-snap---monthly-publication-july-2025.pdf | 2053 | 2025-07 | Car | Seat | Leon | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Raynor Road | Raynor Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6043868 | -2.1046385 | ||
| 14129 | op-snap---monthly-publication-june-2025.pdf | 58 | 2025-06 | Car | Citroen | Berlingo | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5012458 | -1.8780942 | ||
| 14516 | op-snap---monthly-publication-june-2025.pdf | 445 | 2025-06 | Car | Ford | Focus | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Wolverhampton Road | Wolverhampton Road | Metropolitan Borough | Metropolitan Borough | Warning Letter | N/A | 52.4702299 | -1.9948976 | ||
| 14590 | op-snap---monthly-publication-june-2025.pdf | 519 | 2025-06 | Car | Mini | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Birmingham Road | Birmingham Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5505398 | -1.8252993 | |||
| 14695 | op-snap---monthly-publication-june-2025.pdf | 624 | 2025-06 | Car | Volvo | S90... | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fallwofield Road | Fallwofield Road | Walsall | Walsall | Fixed Penalty | N/A | ||||
| 14829 | op-snap---monthly-publication-june-2025.pdf | 758 | 2025-06 | Car | Vmoto | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bishopsgate Street | Bishopsgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | |||
| 14835 | op-snap---monthly-publication-june-2025.pdf | 764 | 2025-06 | Car | Triumph | Green | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A4037 Tipton | Tipton | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5290396 | -2.0693747 | |||
| 14915 | op-snap---monthly-publication-june-2025.pdf | 844 | 2025-06 | Car | Land Rover | Green | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A452 | A452 | Coventry | Coventry | Warning Letter | N/A | |||||
| 15137 | op-snap---monthly-publication-june-2025.pdf | 1066 | 2025-06 | Car | Volkswagen | Golf | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Chapel Lane | Chapel Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4409424 | -1.9387702 | ||
| 15257 | op-snap---monthly-publication-june-2025.pdf | 1186 | 2025-06 | Car | Toyota | Corolla | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4726661 | -1.8769032 | ||
| 15654 | op-snap---monthly-publication-june-2025.pdf | 1583 | 2025-06 | Car | Peugeot | Boxer | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4679402 | -1.881408 | ||
| 15691 | op-snap---monthly-publication-june-2025.pdf | 1620 | 2025-06 | Car | Ford | Fiesta | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Thynne Street | Thynne Street | Sandwell | Sandwell | Warning Letter | N/A | 52.5145422 | -1.9842613 | ||
| 15743 | op-snap---monthly-publication-june-2025.pdf | 1672 | 2025-06 | Car | Ford | Mustang E | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Great Charles Street | Great Charles Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4837518 | -1.901874 | ||
| 15785 | op-snap---monthly-publication-june-2025.pdf | 1714 | 2025-06 | Car | BMW | 320d | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Great Charles Street | Great Charles Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4837518 | -1.901874 | ||
| 15887 | op-snap---monthly-publication-june-2025.pdf | 1816 | 2025-06 | Car | Toyota | CH-R | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Leopold Street | Leopold Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4673764 | -1.8862823 | ||
| 15935 | op-snap---monthly-publication-june-2025.pdf | 1864 | 2025-06 | Car | Toyota | Yaris | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Upper Holland Road | Upper Holland Road | Birmingham | Birmingham | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 15943 | op-snap---monthly-publication-june-2025.pdf | 1872 | 2025-06 | Car | Vauxhall | Astra | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | darwin Street | darwin Street | Birmingham | Birmingham | Warning Letter | N/A | 52.468128 | -1.8848315 | ||
| 16075 | op-snap---monthly-publication-june-2025.pdf | 2004 | 2025-06 | Car | BMW | M240i | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 16076 | op-snap---monthly-publication-june-2025.pdf | 2005 | 2025-06 | Car | Mini | Cooper | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 16077 | op-snap---monthly-publication-june-2025.pdf | 2006 | 2025-06 | Car | Honda | NSC-110 | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Tower Street | Tower Street | Dudley | Dudley | Warning Letter | N/A | 52.5112053 | -2.0833165 | ||
| 16083 | op-snap---monthly-publication-june-2025.pdf | 2012 | 2025-06 | Car | Ford | Ecosport | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Norwood Road | Norwood Road | Dudley | Dudley | Warning Letter | N/A | 52.4831397 | -2.1309273 | ||
| 18729 | op-snap---monthly-publication-may-2025.pdf | 91 | 2025-05 | Car | Lexus | IS300H | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Kings Road at Chester Road | Kings Road at Chester Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.5496587 | -1.8665906 | ||
| 18944 | op-snap---monthly-publication-may-2025.pdf | 306 | 2025-05 | Car | Skoda | Spaceback | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A45 Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4709298 | -1.8722585 | ||
| 19177 | op-snap---monthly-publication-may-2025.pdf | 539 | 2025-05 | Car | Volkswagen | Golf | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.471632 | -1.9456776 | ||
| 19178 | op-snap---monthly-publication-may-2025.pdf | 540 | 2025-05 | Car | Seat | Ibiza | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.471632 | -1.9456776 | ||
| 19269 | op-snap---monthly-publication-may-2025.pdf | 631 | 2025-05 | Car | Mazda | CX30 | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | London Road / Chase Road | London Road / Chase Road | Coventry | Coventry | Fixed Penalty | N/A | 52.3946775 | -1.4952751 | ||
| 19325 | op-snap---monthly-publication-may-2025.pdf | 687 | 2025-05 | Car | Renault | Master | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Kenpass Highway | Kenpass Highway | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 19347 | op-snap---monthly-publication-may-2025.pdf | 709 | 2025-05 | Car | Yamaha | Taxi | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Park Street | Park Street | Birmingham | Birmingham | NFA | No Offence | 52.4814275 | -1.8888778 | ||
| 19422 | op-snap---monthly-publication-may-2025.pdf | 784 | 2025-05 | Car | Audi | Q5.. | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Upper Holland Road | Upper Holland Road | Birmingham | Birmingham | Court | N/A | 52.561 | -1.8187105 |
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);