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'}
165 rows where council_area = "Birmingham" and offence = "Use a vehicle / cycle on a road and contravene a local traffic order other than parking" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make 26
month 12
disposal 6
- Warning Letter 69
- Fixed Penalty 52
- NFA 40
- Education 2
- Court 1
- Duplicate Submission 1
reporter_transport_mode 5
- Car 94
- Pedestrian 46
- Pedal Bike 22
- Other 2
- car 1
offence 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking · 165 ✖
council_area 1
- Birmingham · 165 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10556 | op-snap---monthly-publication-january-2026.pdf | 17 | 2026-01 | car | Mercedes-Benz | GLE | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Newhall St | Newhall Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830482 | -1.905069 | ||
| 10634 | op-snap---monthly-publication-january-2026.pdf | 95 | 2026-01 | Pedestrian | Nissan | X Trail | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4762433 | -1.9176665 | ||
| 10647 | op-snap---monthly-publication-january-2026.pdf | 108 | 2026-01 | Pedal Bike | Mercedes-Benz | Vito | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | New Street | New Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4791344 | -1.8986915 | ||
| 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 | ||
| 10841 | op-snap---monthly-publication-january-2026.pdf | 302 | 2026-01 | Pedestrian | Vauxhall | Insignia | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | none | Belgrade Middleway | Belgrave Middleway | Birmingham | Birmingham | NFA | No Offence | 52.4668753 | -1.8996143 | ||
| 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 | ||
| 11446 | op-snap---monthly-publication-january-2026.pdf | 907 | 2026-01 | Pedestrian | Peugeot | 2008 | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bells Lane | Bells Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4053419 | -1.8944602 | ||
| 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 | ||
| 11736 | op-snap---monthly-publication-january-2026.pdf | 1197 | 2026-01 | Pedestrian | Volkswagen | Polo | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.4321165 | -1.8902667 | ||
| 4099 | op-snap---monthly-publication-december-2025.pdf | 227 | 2025-12 | Pedal Bike | BMW | 335.. | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Raddlebarn Road | Raddlebarn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4397168 | -1.9260414 | ||
| 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 | ||
| 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 | ||
| 20972 | op-snap---monthly-publication-november-2025.pdf | 514 | 2025-11 | Pedestrian | Peugeot | 2008 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Street | Regent Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4291721 | -1.9250565 | ||
| 20973 | op-snap---monthly-publication-november-2025.pdf | 515 | 2025-11 | Pedal Bike | Mercedes-Benz | GLC | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fredrick Street | Fredrick Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 21086 | op-snap---monthly-publication-november-2025.pdf | 628 | 2025-11 | Pedestrian | BMW | 520D | Black | 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 | ||
| 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 | ||
| 22220 | op-snap---monthly-publication-october-2025.pdf | 170 | 2025-10 | Pedestrian | BMW | 330e | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4762433 | -1.9176665 | ||
| 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 | ||
| 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 | ||
| 23725 | op-snap---monthly-publication-october-2025.pdf | 1675 | 2025-10 | Pedestrian | Volvo | C70 | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | ||
| 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 | ||
| 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 | ||||
| 3109 | op-snap---monthly-publication-august-2025.pdf | 1084 | 2025-08 | Pedal Bike | Toyota | Avensis | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Poplar Road, Kings Heath | Poplar Road, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.436035 | -1.891685 | ||
| 3122 | op-snap---monthly-publication-august-2025.pdf | 1097 | 2025-08 | Pedal Bike | Skoda | Octavia | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 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 | ||
| 12059 | op-snap---monthly-publication-july-2025.pdf | 111 | 2025-07 | Pedal Bike | BMW | 4 series | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 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 | |||||
| 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 | ||
| 13194 | op-snap---monthly-publication-july-2025.pdf | 1246 | 2025-07 | Pedestrian | BMW | 330e | 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 | ||
| 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 | ||
| 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 | ||
| 14201 | op-snap---monthly-publication-june-2025.pdf | 130 | 2025-06 | Other | Citroen | C3 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Education | N/A | 52.5390972 | -1.9319478 | ||
| 14242 | op-snap---monthly-publication-june-2025.pdf | 171 | 2025-06 | Pedal Bike | Volkswagen | Tiguan | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Newhall Street | Newhall Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830482 | -1.905069 | ||
| 14352 | op-snap---monthly-publication-june-2025.pdf | 281 | 2025-06 | Pedestrian | Ford | Fiesta | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4762433 | -1.9176665 | ||
| 14373 | op-snap---monthly-publication-june-2025.pdf | 302 | 2025-06 | Pedestrian | Toyota | Prius | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4762433 | -1.9176665 | ||
| 14431 | op-snap---monthly-publication-june-2025.pdf | 360 | 2025-06 | Pedestrian | Nissan | Xtrail | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4762433 | -1.9176665 | ||
| 14573 | op-snap---monthly-publication-june-2025.pdf | 502 | 2025-06 | Pedal Bike | MAN | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | |||
| 14587 | op-snap---monthly-publication-june-2025.pdf | 516 | 2025-06 | Pedal Bike | Skoda | fabia | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Gooch Street | Gooch Street | Birmingham | Birmingham | NFA | No Offence | 52.4686609 | -1.8945007 | ||
| 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 | |||
| 14591 | op-snap---monthly-publication-june-2025.pdf | 520 | 2025-06 | Pedestrian | Mercedes-Benz | A180 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Ashdale Drive | Ashdale Drive | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4027335 | -1.876125 | ||
| 14719 | op-snap---monthly-publication-june-2025.pdf | 648 | 2025-06 | Pedal Bike | BMW | 420d | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Broad Street | Broad Street | Birmingham | Birmingham | NFA | No Offence | 52.4749212 | -1.9147497 | ||
| 14801 | op-snap---monthly-publication-june-2025.pdf | 730 | 2025-06 | Pedal Bike | Skoda | Karoq | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Leaford Road | Leaford Road | Birmingham | Birmingham | Warning Letter | 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 | |||
| 14847 | op-snap---monthly-publication-june-2025.pdf | 776 | 2025-06 | Pedestrian | Volkswagen | Golf | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | NFA | No Offence | 52.4762433 | -1.9176665 | ||
| 14872 | op-snap---monthly-publication-june-2025.pdf | 801 | 2025-06 | Pedestrian | Toyota | Prius | White | 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 Offence | 52.4762433 | -1.9176665 | ||
| 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 | ||
| 15265 | op-snap---monthly-publication-june-2025.pdf | 1194 | 2025-06 | Pedal Bike | Toyota | aygo | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Hill Street | Hill Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4777765 | -1.901321 | ||
| 15346 | op-snap---monthly-publication-june-2025.pdf | 1275 | 2025-06 | Pedestrian | Land Rover | Sport | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Frederick Street | Frederick Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4863384 | -1.9123011 | ||
| 15348 | op-snap---monthly-publication-june-2025.pdf | 1277 | 2025-06 | Pedestrian | Mini | One | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | ||
| 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 | ||
| 15674 | op-snap---monthly-publication-june-2025.pdf | 1603 | 2025-06 | Pedal Bike | Seat | Leon | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4390303 | -1.9512931 | ||
| 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 | ||
| 15872 | op-snap---monthly-publication-june-2025.pdf | 1801 | 2025-06 | Pedestrian | Toyota | CHR | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.470423 | -1.9304786 | ||
| 15874 | op-snap---monthly-publication-june-2025.pdf | 1803 | 2025-06 | Pedestrian | BMW | 218 | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.470423 | -1.9304786 | ||
| 15875 | op-snap---monthly-publication-june-2025.pdf | 1804 | 2025-06 | Pedestrian | BMW | I5 | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.470423 | -1.9304786 | ||
| 15877 | op-snap---monthly-publication-june-2025.pdf | 1806 | 2025-06 | Pedestrian | Audi | S7 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.470423 | -1.9304786 | ||
| 15878 | op-snap---monthly-publication-june-2025.pdf | 1807 | 2025-06 | Pedestrian | Toyota | Auris | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.470423 | -1.9304786 | ||
| 15879 | op-snap---monthly-publication-june-2025.pdf | 1808 | 2025-06 | Pedestrian | Ford | Focus | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.470423 | -1.9304786 | ||
| 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 | ||
| 15888 | op-snap---monthly-publication-june-2025.pdf | 1817 | 2025-06 | Pedestrian | BMW | I 20 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Addison Road | Addison Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4313296 | -1.8882575 | ||
| 15902 | op-snap---monthly-publication-june-2025.pdf | 1831 | 2025-06 | Pedestrian | BMW | 116.. | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A38 Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 |
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);