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'}
81 rows where disposal = "Warning Letter" and offence = "Misc - Non Traffic Offences" 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 24
month 14
council_area 10
- Birmingham 58
- Sandwell 7
- Sutton Coldfield 5
- Wolverhampton 3
- Coventry 2
- Walsall 2
- Dudley 1
- Halesowen 1
- Osru Cttloons Ecoldfield 1
- Solihull 1
reporter_transport_mode 4
- Car 41
- Pedestrian 33
- Other 4
- Pedal Bike 3
offence 1
- Misc - Non Traffic Offences · 81 ✖
disposal 1
- Warning Letter · 81 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7955 | op-snap---monthly-publication-february-2026.pdf | 702 | 2026-02 | Pedestrian | Mercedes-Benz | E300.. | Blue | Misc - Non Traffic Offences | None | Edward Street | Edward Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4816233 | -1.9124334 | ||
| 8730 | op-snap---monthly-publication-february-2026.pdf | 1477 | 2026-02 | Pedestrian | Kia | sorento | Grey | Misc - Non Traffic Offences | None | broadmeadow | Broadmeadow | Walsall | Walsall | Warning Letter | N/A | 52.6100022 | -1.9177041 | ||
| 10692 | op-snap---monthly-publication-january-2026.pdf | 153 | 2026-01 | Other | BMW | X3.. | White | Misc - Non Traffic Offences | None | Canal Court | Canal Court | Birmingham | Birmingham | Warning Letter | N/A | 52.4486586 | -1.8085554 | ||
| 10867 | op-snap---monthly-publication-january-2026.pdf | 328 | 2026-01 | Pedestrian | Mercedes-Benz | 330 | White | Misc - Non Traffic Offences | None | Barclay Road | Barclay Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4722765 | -1.9787531 | ||
| 10998 | op-snap---monthly-publication-january-2026.pdf | 459 | 2026-01 | Car | Audi | Q5 | Grey | Misc - Non Traffic Offences | None | Colley Gate | Colley Gate | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3899 | op-snap---monthly-publication-december-2025.pdf | 27 | 2025-12 | Pedestrian | Toyota | Yaris | Silver | Misc - Non Traffic Offences | None | Gibson Drive | Gibson Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.507404 | -1.9170214 | ||
| 4123 | op-snap---monthly-publication-december-2025.pdf | 251 | 2025-12 | Car | Honda | Civic | Grey | Misc - Non Traffic Offences | None | Maple Tree Lane | Maple Tree Lane | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4127 | op-snap---monthly-publication-december-2025.pdf | 255 | 2025-12 | Car | Volkswagen | Golf | Grey | Misc - Non Traffic Offences | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 4254 | op-snap---monthly-publication-december-2025.pdf | 382 | 2025-12 | Pedestrian | Mg | hs | Blue | Misc - Non Traffic Offences | None | teazel avenue | Teazel Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.4247795 | -1.9433534 | ||
| 4274 | op-snap---monthly-publication-december-2025.pdf | 402 | 2025-12 | Other | Audi | a4 | Blue | Misc - Non Traffic Offences | None | a45 small heath highway | A45 Small Heath Highway | Birmingham | Birmingham | Warning Letter | N/A | 52.4601838 | -1.8488291 | ||
| 4627 | op-snap---monthly-publication-december-2025.pdf | 755 | 2025-12 | Car | Honda | Civic | Grey | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4875 | op-snap---monthly-publication-december-2025.pdf | 1003 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4946 | op-snap---monthly-publication-december-2025.pdf | 1074 | 2025-12 | Car | Peugeot | 3008 | Red | Misc - Non Traffic Offences | None | A4040 | A4040 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4947 | op-snap---monthly-publication-december-2025.pdf | 1075 | 2025-12 | Car | Porsche | Cayenne | Silver | Misc - Non Traffic Offences | None | A4040 | A4040 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4960 | op-snap---monthly-publication-december-2025.pdf | 1088 | 2025-12 | Car | Porsche | Cayenne | Silver | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4995 | op-snap---monthly-publication-december-2025.pdf | 1123 | 2025-12 | Car | Peugeot | 107 | Black | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 5084 | op-snap---monthly-publication-december-2025.pdf | 1212 | 2025-12 | Car | Kia | Ceed | White | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 5118 | op-snap---monthly-publication-december-2025.pdf | 1246 | 2025-12 | Car | Ford | Kuga | Blue | Misc - Non Traffic Offences | None | Waterloo Road | Waterloo Road | Wolverhampton | Wolverhampton | Warning Letter | No Offence | 52.5960155 | -2.1295068 | ||
| 20897 | op-snap---monthly-publication-november-2025.pdf | 439 | 2025-11 | Pedestrian | Audi | A3 | Grey | Misc - Non Traffic Offences | None | Whittington Oval | Whittington Oval | Birmingham | Birmingham | Warning Letter | N/A | 52.4800782 | -1.7942034 | ||
| 21030 | op-snap---monthly-publication-november-2025.pdf | 572 | 2025-11 | Car | Mercedes-Benz | C220 | Silver | Misc - Non Traffic Offences | None | Lincoln Street | Lincoln Street | Birmingham | Birmingham | Warning Letter | N/A | 52.459298 | -1.8933648 | ||
| 22018 | op-snap---monthly-publication-november-2025.pdf | 1560 | 2025-11 | Pedal Bike | Toyota | Corolla | Blue | Misc - Non Traffic Offences | None | New Town Row | New Town Row | Birmingham | Birmingham | Warning Letter | N/A | 52.4896513 | -1.8947514 | ||
| 23152 | op-snap---monthly-publication-october-2025.pdf | 1102 | 2025-10 | Car | Vauxhall | Astra | White | Misc - Non Traffic Offences | None | Eachlehurst Road | Eachlehurst Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23604 | op-snap---monthly-publication-october-2025.pdf | 1554 | 2025-10 | Car | Seat | Leon | Black | Misc - Non Traffic Offences | None | A452 | A452 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23690 | op-snap---monthly-publication-october-2025.pdf | 1640 | 2025-10 | Pedestrian | Vauxhall | Black | Misc - Non Traffic Offences | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | |||
| 24022 | op-snap---monthly-publication-september-2025.pdf | 241 | 2025-09 | Pedestrian | Hyundai | Getz | Blue | Misc - Non Traffic Offences | None | Butt Lane | Butt Lane | Coventry | Coventry | Warning Letter | N/A | 52.4303178 | -1.5668089 | ||
| 24621 | op-snap---monthly-publication-september-2025.pdf | 840 | 2025-09 | Car | Mazda | 3.. | Silver | Misc - Non Traffic Offences | None | Newton Road | Newton Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5428224 | -1.9569444 | ||
| 24988 | op-snap---monthly-publication-september-2025.pdf | 1207 | 2025-09 | Car | Skoda | karoq | White | Misc - Non Traffic Offences | None | A45 coventry road | A45 coventry road | Birmingham | Birmingham | Warning Letter | N/A | 52.4714538 | -1.8627901 | ||
| 25061 | op-snap---monthly-publication-september-2025.pdf | 1280 | 2025-09 | Pedestrian | Other | Lomousine | White | Misc - Non Traffic Offences | None | ELmdon Road | ELmdon Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4418657 | -1.9240253 | ||
| 25272 | op-snap---monthly-publication-september-2025.pdf | 1491 | 2025-09 | Pedestrian | Vauxhall | Vectra | Red | Misc - Non Traffic Offences | None | Hockley Heath | Hockley Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4921873 | -1.9258317 | ||
| 25303 | op-snap---monthly-publication-september-2025.pdf | 1522 | 2025-09 | Pedestrian | Honda | Accord | Silver | Misc - Non Traffic Offences | None | Unknown | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 25465 | op-snap---monthly-publication-september-2025.pdf | 1684 | 2025-09 | Pedestrian | Honda | accord | Silver | Misc - Non Traffic Offences | None | parkdale close | Parkdale Close | Birmingham | Birmingham | Warning Letter | N/A | 52.513341 | -1.8406439 | ||
| 2850 | op-snap---monthly-publication-august-2025.pdf | 825 | 2025-08 | Car | Audi | A1 | Black | Misc - Non Traffic Offences | No vehicle excise licence | M5 | M5 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 3770 | op-snap---monthly-publication-august-2025.pdf | 1745 | 2025-08 | Pedestrian | Kia | Sedona | Black | Misc - Non Traffic Offences | None | Alcester Road South, Kings Heath | Alcester Road South, Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4234086 | -1.8922587 | ||
| 3785 | op-snap---monthly-publication-august-2025.pdf | 1760 | 2025-08 | Car | Audi | A3 | Grey | Misc - Non Traffic Offences | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4967329 | -1.8097462 | ||
| 3792 | op-snap---monthly-publication-august-2025.pdf | 1767 | 2025-08 | Car | Fiat | Punto | Black | Misc - Non Traffic Offences | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4390303 | -1.9512931 | ||
| 12729 | op-snap---monthly-publication-july-2025.pdf | 781 | 2025-07 | Other | Kawasaki | Blue | Misc - Non Traffic Offences | None | Moathouse Park (Cov) | Moathouse Park (Cov) | Coventry | Coventry | Warning Letter | N/A | 52.4352858 | -1.4634999 | |||
| 14002 | op-snap---monthly-publication-july-2025.pdf | 2054 | 2025-07 | Car | BMW | M3 | Black | Misc - Non Traffic Offences | None | Friary Road | Friary Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5162814 | -1.9395798 | ||
| 14498 | op-snap---monthly-publication-june-2025.pdf | 427 | 2025-06 | Car | Audi | S3 | Grey | Misc - Non Traffic Offences | None | Botany Road | Botany Road | Walsall | Walsall | Warning Letter | N/A | 52.563834 | -1.9719203 | ||
| 15233 | op-snap---monthly-publication-june-2025.pdf | 1162 | 2025-06 | Car | Audi | TT | Silver | Misc - Non Traffic Offences | None | School Road | School Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4161736 | -1.8619692 | ||
| 15663 | op-snap---monthly-publication-june-2025.pdf | 1592 | 2025-06 | Car | BMW | 3 series | Blue | Misc - Non Traffic Offences | None | A45 Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Warning Letter | N/A | 52.4709298 | -1.8722585 | ||
| 15921 | op-snap---monthly-publication-june-2025.pdf | 1850 | 2025-06 | Car | Volkswagen | Tiguan | Green | Misc - Non Traffic Offences | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 16026 | op-snap---monthly-publication-june-2025.pdf | 1955 | 2025-06 | Car | Fiat | Silver | Misc - Non Traffic Offences | None | M5 | M5 | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 16149 | op-snap---monthly-publication-june-2025.pdf | 2078 | 2025-06 | Car | BMW | 3 series | Blue | Misc - Non Traffic Offences | None | St Peters Road | Street Peters Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 16215 | op-snap---monthly-publication-june-2025.pdf | 2144 | 2025-06 | Car | Citroen | DS3 | Blue | Misc - Non Traffic Offences | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 20390 | op-snap---monthly-publication-may-2025.pdf | 1752 | 2025-05 | Pedestrian | Toyota | Prius | Blue | Misc - Non Traffic Offences | None | Bewdley Road | Bewdley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4330724 | -1.9181313 | ||
| 47 | op-snap---monthly-publication-april-2025.pdf | 46 | 2025-04 | Pedal Bike | Ford | Transit | White | Misc - Non Traffic Offences | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4321165 | -1.8902667 | ||
| 283 | op-snap---monthly-publication-april-2025.pdf | 282 | 2025-04 | Car | Vauxhall | vIVARO | Blue | Misc - Non Traffic Offences | None | Burton Road | Burton Road | Dudley | Dudley | Warning Letter | N/A | 52.5248087 | -2.1098939 | ||
| 16503 | op-snap---monthly-publication-march-2025.pdf | 260 | 2025-03 | Pedestrian | Seat | Leon | Grey | Misc - Non Traffic Offences | None | Pound Lane | Pound Lane | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.5541031 | -2.0107085 | |
| 17327 | op-snap---monthly-publication-march-2025.pdf | 1084 | 2025-03 | Pedestrian | Lexus | IS250 | Blue | Misc - Non Traffic Offences | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||||
| 17830 | op-snap---monthly-publication-march-2025.pdf | 1587 | 2025-03 | Car | Toyota | Prius | White | Misc - Non Traffic Offences | None | Hurst Street | Hurst Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4714381 | -1.893243 | |
| 17941 | op-snap---monthly-publication-march-2025.pdf | 1698 | 2025-03 | Pedestrian | Nissan | Qashqai | Red | Misc - Non Traffic Offences | None | Landsdale Road | Landsdale Road | Solihull | Solihull | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | |||
| 17975 | op-snap---monthly-publication-march-2025.pdf | 1732 | 2025-03 | Car | Peugeot | PARTNER | Silver | Misc - Non Traffic Offences | Littering | Bromsgrove Road | Bromsgrove Road | Halesowen | Halesowen | Warning Letter | N/A | Yes - Via Email | 52.449941 | -2.0446291 | |
| 18456 | op-snap---monthly-publication-march-2025.pdf | 2213 | 2025-03 | Car | Ford | Transit | White | Misc - Non Traffic Offences | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 5549 | op-snap---monthly-publication-february-2025.pdf | 366 | 2025-02 | Car | Volvo | XC40 | Black | Misc - Non Traffic Offences | Littering | CARROWAY HEAD | Carroway Head | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | |||
| 5738 | op-snap---monthly-publication-february-2025.pdf | 555 | 2025-02 | Pedestrian | Vauxhall | Mokka | Grey | Misc - Non Traffic Offences | None | Chantry Road | Chantry Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4496376 | -1.8915224 | |
| 5739 | op-snap---monthly-publication-february-2025.pdf | 556 | 2025-02 | Pedestrian | Hyundai | I30 | Blue | Misc - Non Traffic Offences | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 5740 | op-snap---monthly-publication-february-2025.pdf | 557 | 2025-02 | Pedestrian | Toyota | C-HR | White | Misc - Non Traffic Offences | None | Grange Road | Grange Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5065077 | -1.892207 | |
| 5756 | op-snap---monthly-publication-february-2025.pdf | 573 | 2025-02 | Pedal Bike | Mercedes-Benz | Van | White | Misc - Non Traffic Offences | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4552785 | -1.906384 | |
| 5794 | op-snap---monthly-publication-february-2025.pdf | 611 | 2025-02 | Pedestrian | Mazda | 2 | Black | Misc - Non Traffic Offences | None | Alcester Road, Moseley | Alcester Road, Moseley | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4445135 | -1.8907323 | |
| 5795 | op-snap---monthly-publication-february-2025.pdf | 612 | 2025-02 | Pedestrian | Toyota | Aygo | Black | Misc - Non Traffic Offences | None | Alcester Road, Moseley | Alcester Road, Moseley | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4445135 | -1.8907323 | |
| 5797 | op-snap---monthly-publication-february-2025.pdf | 614 | 2025-02 | Pedestrian | Mercedes-Benz | CLA 200 | Blue | Misc - Non Traffic Offences | None | Alcester Road, Moseley | Alcester Road, Moseley | Birmingham | Birmingham | Warning Letter | No Independent Evidence Available | Yes - Via Email | 52.4445135 | -1.8907323 | |
| 5799 | op-snap---monthly-publication-february-2025.pdf | 616 | 2025-02 | Pedestrian | Toyota | Yaris | Black | Misc - Non Traffic Offences | None | Alcester Road, Moseley | Alcester Road, Moseley | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4445135 | -1.8907323 | |
| 5800 | op-snap---monthly-publication-february-2025.pdf | 617 | 2025-02 | Pedestrian | Nissan | Note | Black | Misc - Non Traffic Offences | None | Alcester Road, Moseley | Alcester Road, Moseley | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4445135 | -1.8907323 | |
| 5804 | op-snap---monthly-publication-february-2025.pdf | 621 | 2025-02 | Pedestrian | Toyota | Corolla | Grey | Misc - Non Traffic Offences | None | Alcester Road, Moseley | Alcester Road, Moseley | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4445135 | -1.8907323 | |
| 5806 | op-snap---monthly-publication-february-2025.pdf | 623 | 2025-02 | Pedestrian | Mercedes-Benz | A150 | Grey | Misc - Non Traffic Offences | None | Alcester Road, Moseley | Alcester Road, Moseley | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4445135 | -1.8907323 | |
| 5808 | op-snap---monthly-publication-february-2025.pdf | 625 | 2025-02 | Car | Nissan | 350Z | Grey | Misc - Non Traffic Offences | None | A4040 at A38 junction, Selly Oak | A4040 at A38 junction, Selly Oak | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.480771 | -1.8086714 | |
| 6106 | op-snap---monthly-publication-february-2025.pdf | 923 | 2025-02 | Car | Suzuki | Celerio | White | Misc - Non Traffic Offences | Littering | Ring Road WV | Ring Road WV | Wolverhampton | Wolverhampton | Warning Letter | N/A | Yes - Via Email | |||
| 6173 | op-snap---monthly-publication-february-2025.pdf | 990 | 2025-02 | Other | Land Rover | Range Rover | Black | Misc - Non Traffic Offences | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5265939 | -1.8509884 | |
| 6294 | op-snap---monthly-publication-february-2025.pdf | 1111 | 2025-02 | Pedestrian | Ford | VAN | White | Misc - Non Traffic Offences | Use vehicle on a road without valid test certificate | Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4726661 | -1.8769032 | |
| 6409 | op-snap---monthly-publication-february-2025.pdf | 1226 | 2025-02 | Car | Audi | A3 | Grey | Misc - Non Traffic Offences | None | Craig Croft | Craig Croft | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 6562 | op-snap---monthly-publication-february-2025.pdf | 1379 | 2025-02 | Pedestrian | Nissan | Juke | Silver | Misc - Non Traffic Offences | None | Evelyn Road | Evelyn Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4515664 | -1.8624266 | |
| 6628 | op-snap---monthly-publication-february-2025.pdf | 1445 | 2025-02 | Pedestrian | Volkswagen | Golf | Silver | Misc - Non Traffic Offences | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 6629 | op-snap---monthly-publication-february-2025.pdf | 1446 | 2025-02 | Pedestrian | Toyota | Corolla | Black | Misc - Non Traffic Offences | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 6638 | op-snap---monthly-publication-february-2025.pdf | 1455 | 2025-02 | Pedestrian | Hyundai | I30 | Blue | Misc - Non Traffic Offences | None | Rockingham Gardens or Rushmo | Rockingham Gardens or Rushmo | oSru Cttloons eColdfield | Osru Cttloons Ecoldfield | Warning Letter | N/A | Yes - Via Email | |||
| 6676 | op-snap---monthly-publication-february-2025.pdf | 1493 | 2025-02 | Car | Vauxhall | Astra | Red | Misc - Non Traffic Offences | None | Stowheath Lane | Stowheath Lane | Wolverhampton | Wolverhampton | Warning Letter | N/A | Yes - Via Email | 52.5795873 | -2.0900583 | |
| 6741 | op-snap---monthly-publication-february-2025.pdf | 1558 | 2025-02 | Car | Ford | TRANSIT | White | Misc - Non Traffic Offences | None | BIRMINGHAM ROAD | Birmingham Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5505398 | -1.8252993 | |
| 7235 | op-snap---monthly-publication-february-2025.pdf | 2052 | 2025-02 | Car | Seat | Ibiza | White | Misc - Non Traffic Offences | None | Nechells Park Road | Nechells Park Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5039353 | -1.8613576 | |
| 10375 | op-snap---monthly-publication-january-2025.pdf | 1483 | 2025-01 | Car | Nissan | Black | Misc - Non Traffic Offences | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | ||
| 10377 | op-snap---monthly-publication-january-2025.pdf | 1485 | 2025-01 | Car | Audi | Q7 | Black | Misc - Non Traffic Offences | No vehicle excise licence | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 10378 | op-snap---monthly-publication-january-2025.pdf | 1486 | 2025-01 | Car | Toyota | Avensis | Grey | Misc - Non Traffic Offences | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 10506 | op-snap---monthly-publication-january-2025.pdf | 1614 | 2025-01 | Pedestrian | Nissan | NOTE | Blue | Misc - Non Traffic Offences | None | SHAFTMOOR LANE | Shaftmoor Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4418944 | -1.8407335 |
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);