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'}
154 rows where council_area = "Birmingham", disposal = "NFA" and reporter_transport_mode = "Other" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make 25
- Volkswagen 19
- BMW 18
- Ford 18
- Mercedes-Benz 17
- Toyota 12
- Audi 5
- Nissan 5
- Renault 5
- Skoda 5
- Vauxhall 5
- Hyundai 4
- Volvo 4
- Honda 3
- Kia 3
- Land Rover 3
- Seat 2
- Citroen 1
- Daf 1
- Fiat 1
- Jaguar 1
- Lamborghini 1
- Lexus 1
- Peugeot 1
- Rolls-Royce 1
- Yamaha 1
offence 21
- Driving without Due Care and Attention 34
- Misc - Non Traffic Offences 33
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 25
- Using a Mobile Phone Whilst Driving 16
- Cause vehicle to be left in a dangerous position 12
- Driving a vehicle wholly or partly on a footpath 9
- Contravening a Red Traffic Light 3
- Drive / Ride / Lead an animal on a footpath 3
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 3
- Stop a vehicle within pelican pedestrian crossing limits 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- No Insurance 2
- Dangerous Driving 1
- Driver not in position to have Proper Control 1
- Driving without Reasonable Consideration 1
- Motor vehicle fail to comply with endorsable sect 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
- No Seat Belt 1
- Offence to be added 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
month 14
reporter_transport_mode 1
- Other · 154 ✖
disposal 1
- NFA · 154 ✖
council_area 1
- Birmingham · 154 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7420 | op-snap---monthly-publication-february-2026.pdf | 167 | 2026-02 | Other | Volkswagen | Crafter | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | t None | Church St | Church Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5020781 | -1.9122368 | ||
| 7421 | op-snap---monthly-publication-february-2026.pdf | 168 | 2026-02 | Other | Jaguar | XF | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Pauls Square | Street Pauls Square | Birmingham | Birmingham | NFA | No Offence | ||||
| 7506 | op-snap---monthly-publication-february-2026.pdf | 253 | 2026-02 | Other | Volvo | C40 | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | ||
| 7584 | op-snap---monthly-publication-february-2026.pdf | 331 | 2026-02 | Other | Nissan | Xtrail | Orange | Misc - Non Traffic Offences | None | Unett Street | Unett Street | Birmingham | Birmingham | NFA | No Offence | 52.4921149 | -1.9071925 | ||
| 7623 | op-snap---monthly-publication-february-2026.pdf | 370 | 2026-02 | Other | Lamborghini | Silver | Using a Mobile Phone Whilst Driving | None | Birmingham | Birmingham | Birmingham | Birmingham | NFA | No VRM | 52.4796992 | -1.9026911 | |||
| 7704 | op-snap---monthly-publication-february-2026.pdf | 451 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5521118 | -1.8845138 | ||
| 7719 | op-snap---monthly-publication-february-2026.pdf | 466 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5521118 | -1.8845138 | ||
| 7768 | op-snap---monthly-publication-february-2026.pdf | 515 | 2026-02 | Other | Nissan | Navara | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Montgomery Street | Montgomery Street | Birmingham | Birmingham | NFA | No Offence | 52.4644472 | -1.8668879 | ||
| 7791 | op-snap---monthly-publication-february-2026.pdf | 538 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5521118 | -1.8845138 | ||
| 7880 | op-snap---monthly-publication-february-2026.pdf | 627 | 2026-02 | Other | Skoda | Kodiaq | White | Misc - Non Traffic Offences | None | Welhead Road | Welhead Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 7881 | op-snap---monthly-publication-february-2026.pdf | 628 | 2026-02 | Other | multiple | Misc - Non Traffic Offences | None | Perry Barr Village | Perry Barr Village | Birmingham | Birmingham | NFA | No Offence | 52.5243314 | -1.8819868 | ||||
| 7940 | op-snap---monthly-publication-february-2026.pdf | 687 | 2026-02 | Other | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Longbridge | Longbridge | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.3940521 | -1.9807506 | ||
| 8202 | op-snap---monthly-publication-february-2026.pdf | 949 | 2026-02 | Other | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4103191 | -1.8670224 | |||||
| 8221 | op-snap---monthly-publication-february-2026.pdf | 968 | 2026-02 | Other | Kia | Sportage | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5521118 | -1.8845138 | ||
| 8223 | op-snap---monthly-publication-february-2026.pdf | 970 | 2026-02 | Other | Mercedes-Benz | Sprinter | Red | Offence to be added | None | Uplands Road | Uplands Road | Birmingham | Birmingham | NFA | No Offence | 52.5131738 | -1.9434941 | ||
| 8284 | op-snap---monthly-publication-february-2026.pdf | 1031 | 2026-02 | Other | BMW | 420.. | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 8286 | op-snap---monthly-publication-february-2026.pdf | 1033 | 2026-02 | Other | Audi | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||
| 8288 | op-snap---monthly-publication-february-2026.pdf | 1035 | 2026-02 | Other | Skoda | Superb | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotton Park Road | Rotton Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4851072 | -1.9468115 | ||
| 8310 | op-snap---monthly-publication-february-2026.pdf | 1057 | 2026-02 | Other | Volkswagen | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotton Park Road | Rotton Park Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4851072 | -1.9468115 | |||
| 8317 | op-snap---monthly-publication-february-2026.pdf | 1064 | 2026-02 | Other | Ford | Transit | White | Driving a vehicle wholly or partly on a footpath | None | Highters Heath Lane. | Highters Heath Lane | Birmingham | Birmingham | NFA | No VRM | 52.4100972 | -1.8742772 | ||
| 8340 | op-snap---monthly-publication-february-2026.pdf | 1087 | 2026-02 | Other | Driving a vehicle wholly or partly on a footpath | None | Highters Heath Lane | Highters Heath Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4100972 | -1.8742772 | |||||
| 8356 | op-snap---monthly-publication-february-2026.pdf | 1103 | 2026-02 | Other | Ford | Fiesta | Blue | Misc - Non Traffic Offences | None | Star City | Star City | Birmingham | Birmingham | NFA | No Offence | 52.5054363 | -1.8556273 | ||
| 8389 | op-snap---monthly-publication-february-2026.pdf | 1136 | 2026-02 | Other | Volkswagen | Polo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotton Park Road | Rotton Park Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4851072 | -1.9468115 | ||
| 8690 | op-snap---monthly-publication-february-2026.pdf | 1437 | 2026-02 | Other | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552055 | -1.9461279 | ||||
| 10656 | op-snap---monthly-publication-january-2026.pdf | 117 | 2026-01 | Other | Daf | Truck | White | Using a Mobile Phone Whilst Driving | None | Northcote Road | Northcote Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4862344 | -1.8128298 | ||
| 10753 | op-snap---monthly-publication-january-2026.pdf | 214 | 2026-01 | Other | Vauxhall | Vivaro | Black | Using a Mobile Phone Whilst Driving | None | Fifield Road | Fifield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 10771 | op-snap---monthly-publication-january-2026.pdf | 232 | 2026-01 | Other | Land Rover | Discovery | Green | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Chantry Road, Moseley | Chantry Road, Moseley | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4496376 | -1.8915224 | ||
| 10847 | op-snap---monthly-publication-january-2026.pdf | 308 | 2026-01 | Other | Skoda | Kodiaq | White | Driving without Due Care and Attention | None | Star City | Star City | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5054363 | -1.8556273 | ||
| 10849 | op-snap---monthly-publication-january-2026.pdf | 310 | 2026-01 | Other | Unknown VRM | Misc - Non Traffic Offences | None | Kingstanding Circle | Kingstanding Circle | Birmingham | Birmingham | NFA | No VRM | 52.5536651 | -1.8826944 | ||||
| 10935 | op-snap---monthly-publication-january-2026.pdf | 396 | 2026-01 | Other | Toyota | Yaris | Red | Cause vehicle to be left in a dangerous position | None | Rotton Park Road | Rotton Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4851072 | -1.9468115 | ||
| 10986 | op-snap---monthly-publication-january-2026.pdf | 447 | 2026-01 | Other | Mercedes-Benz | A Class | Silver | Driving without Due Care and Attention | None | A38 | A38 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 11004 | op-snap---monthly-publication-january-2026.pdf | 465 | 2026-01 | Other | BMW | X3 M | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cambridge Crescent | Cambridge Crescent | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4652475 | -1.9056734 | ||
| 11007 | op-snap---monthly-publication-january-2026.pdf | 468 | 2026-01 | Other | BMW | White | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | Canal Court | Canal Court | Birmingham | Birmingham | NFA | No VRM | 52.4486586 | -1.8085554 | |||
| 11408 | op-snap---monthly-publication-january-2026.pdf | 869 | 2026-01 | Other | Volkswagen | T Roc | Black | Driving without Due Care and Attention | None | Lysander Road | Lysander Road | Birmingham | Birmingham | NFA | No Offence | 52.4066385 | -2.0128329 | ||
| 11482 | op-snap---monthly-publication-january-2026.pdf | 943 | 2026-01 | Other | BMW | 5 Series | Silver | Dangerous Driving | None | Spring road Tyseley | Spring road Tyseley | Birmingham | Birmingham | NFA | No VRM | 52.444262 | -1.8362585 | ||
| 11624 | op-snap---monthly-publication-january-2026.pdf | 1085 | 2026-01 | Other | Using a Mobile Phone Whilst Driving | None | No exact location given. Taken from social media. | No exact location given. Taken from social media | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||||
| 11659 | op-snap---monthly-publication-january-2026.pdf | 1120 | 2026-01 | Other | Ford | transit | White | Stop a vehicle within pelican pedestrian crossing limits | none | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | ||
| 11807 | op-snap---monthly-publication-january-2026.pdf | 1268 | 2026-01 | Other | Hyundai | Tucson | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 11830 | op-snap---monthly-publication-january-2026.pdf | 1291 | 2026-01 | Other | Mercedes-Benz | C Class | Grey | Drive / Ride / Lead an animal on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | No VRM | 52.5521118 | -1.8845138 | ||
| 11845 | op-snap---monthly-publication-january-2026.pdf | 1306 | 2026-01 | Other | Volvo | XC60 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotton Park Road | Rotton Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4851072 | -1.9468115 | ||
| 11846 | op-snap---monthly-publication-january-2026.pdf | 1307 | 2026-01 | Other | Volkswagen | Golf | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No vehicle excise licence | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 11850 | op-snap---monthly-publication-january-2026.pdf | 1311 | 2026-01 | Other | Mercedes-Benz | C Class | Grey | Drive / Ride / Lead an animal on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | No VRM | 52.5521118 | -1.8845138 | ||
| 11859 | op-snap---monthly-publication-january-2026.pdf | 1320 | 2026-01 | Other | Ford | Transit | White | Contravening a Red Traffic Light | None | Avenue road | Avenue road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4941712 | -1.8795158 | ||
| 11902 | op-snap---monthly-publication-january-2026.pdf | 1363 | 2026-01 | Other | Ford | Transit | Grey | Misc - Non Traffic Offences | None | ladywood | Ladywood | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4774932 | -1.9233654 | ||
| 11925 | op-snap---monthly-publication-january-2026.pdf | 1386 | 2026-01 | Other | Mercedes-Benz | c class | Grey | Driving a vehicle wholly or partly on a footpath | None | kingstanding road | Kingstanding Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5521118 | -1.8845138 | ||
| 4064 | op-snap---monthly-publication-december-2025.pdf | 192 | 2025-12 | Other | Volkswagen | Caddy | White | Driving without Due Care and Attention | None | Gravelly HIll | Gravelly HIll | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5153884 | -1.8527437 | ||
| 4178 | op-snap---monthly-publication-december-2025.pdf | 306 | 2025-12 | Other | Ford | focus | Black | Misc - Non Traffic Offences | None | Arundel Road | Arundel Road | Birmingham | Birmingham | NFA | No Offence | 52.4032204 | -1.8821733 | ||
| 4179 | op-snap---monthly-publication-december-2025.pdf | 307 | 2025-12 | Other | BMW | 330E | White | Driving without Due Care and Attention | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552055 | -1.9461279 | ||
| 4187 | op-snap---monthly-publication-december-2025.pdf | 315 | 2025-12 | Other | Land Rover | SE | Black | Using a Mobile Phone Whilst Driving | Use vehicle on a road withou | tB viramlidin tgehsat mcertificate | t B viramlidin tgehsat mcertificate | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4407 | op-snap---monthly-publication-december-2025.pdf | 535 | 2025-12 | Other | Vauxhall | Corsa | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | UK | Uk | Birmingham | Birmingham | NFA | No Offence | 52.45124 | -1.937937 | ||
| 4437 | op-snap---monthly-publication-december-2025.pdf | 565 | 2025-12 | Other | Volkswagen | Misc - Non Traffic Offences | None | edmund road | Edmund Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4876113 | -1.8542201 | ||||
| 4536 | op-snap---monthly-publication-december-2025.pdf | 664 | 2025-12 | Other | Peugeot | 208 | White | Misc - Non Traffic Offences | None | Merlin Grove | Merlin Grove | Birmingham | Birmingham | NFA | No Offence | 52.4578935 | -1.7820619 | ||
| 4553 | op-snap---monthly-publication-december-2025.pdf | 681 | 2025-12 | Other | BMW | X1 | Grey | Using a Mobile Phone Whilst Driving | None | B4124 ROcky Lane | B4124 ROcky Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 20485 | op-snap---monthly-publication-november-2025.pdf | 27 | 2025-11 | Other | Volkswagen | Polo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Beauchamp Road | Beauchamp Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4209386 | -1.8699242 | ||
| 21315 | op-snap---monthly-publication-november-2025.pdf | 857 | 2025-11 | Other | Yamaha | GPD 125 | Red | Driving without Due Care and Attention | None | No Offence Location given | No Offence Location given | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 21590 | op-snap---monthly-publication-november-2025.pdf | 1132 | 2025-11 | Other | Unknown | Driving without Due Care and Attention | None | Unknown | Birmingham | Birmingham | NFA | No VRM | |||||||
| 21678 | op-snap---monthly-publication-november-2025.pdf | 1220 | 2025-11 | Other | Mercedes-Benz | A45 AMG | White | Driving without Due Care and Attention | None | Inverclyde | Inverclyde | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5218439 | -1.9215045 | ||
| 21689 | op-snap---monthly-publication-november-2025.pdf | 1231 | 2025-11 | Other | Misc - Non Traffic Offences | None | poplar avenue | Poplar Avenue | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5723052 | -1.8003041 | |||||
| 21764 | op-snap---monthly-publication-november-2025.pdf | 1306 | 2025-11 | Other | NP | Using a Mobile Phone Whilst Driving | None | Redditch Road | Redditch Road | Birmingham | Birmingham | NFA | No VRM | 52.3954946 | -1.9516557 | ||||
| 21837 | op-snap---monthly-publication-november-2025.pdf | 1379 | 2025-11 | Other | Mercedes-Benz | C 220 AMG | Grey | Driving without Due Care and Attention | None | Repton Road, Birmingham | Repton Road, Birmingham | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4819583 | -1.829677 | ||
| 21867 | op-snap---monthly-publication-november-2025.pdf | 1409 | 2025-11 | Other | Hyundai | i20 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | blakeley hall road | Blakeley Hall Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 22137 | op-snap---monthly-publication-october-2025.pdf | 87 | 2025-10 | Other | Seat | Ibiza | Red | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552055 | -1.9461279 | ||
| 22138 | op-snap---monthly-publication-october-2025.pdf | 88 | 2025-10 | Other | Toyota | Yaris | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552055 | -1.9461279 | ||
| 22178 | op-snap---monthly-publication-october-2025.pdf | 128 | 2025-10 | Other | Volkswagen | N/K | Black | Misc - Non Traffic Offences | None | N/K | N/K | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5684524 | -1.879732 | ||
| 22281 | op-snap---monthly-publication-october-2025.pdf | 231 | 2025-10 | Other | Ford | Kuga | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hugh Road | Hugh Road | Birmingham | Birmingham | NFA | No Offence | 52.4724029 | -1.8527024 | ||
| 22335 | op-snap---monthly-publication-october-2025.pdf | 285 | 2025-10 | Other | Honda | Grey | Contravening a Red Traffic Light | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | NFA | No VRM | |||||
| 22375 | op-snap---monthly-publication-october-2025.pdf | 325 | 2025-10 | Other | Renault | Grey | Driving without Due Care and Attention | None | Station Road | Station Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5054559 | -1.9506109 | |||
| 22651 | op-snap---monthly-publication-october-2025.pdf | 601 | 2025-10 | Other | BMW | X6 | White | Driving without Due Care and Attention | None | Star City Car Park | Star City Car Park | Birmingham | Birmingham | NFA | No Offence | ||||
| 22671 | op-snap---monthly-publication-october-2025.pdf | 621 | 2025-10 | Other | Ford | minibus | White | Misc - Non Traffic Offences | None | Whittington Oval, Stechford | Whittington Oval, Stechford | Birmingham | Birmingham | NFA | No Offence | 52.4800782 | -1.7942034 | ||
| 22708 | op-snap---monthly-publication-october-2025.pdf | 658 | 2025-10 | Other | Fiat | 500 | Green | No Seat Belt | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4700545 | -1.834436 | ||
| 22786 | op-snap---monthly-publication-october-2025.pdf | 736 | 2025-10 | Other | Rolls-Royce | Cullinan | Black | Using a Mobile Phone Whilst Driving | None | UK | Uk | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.45124 | -1.937937 | ||
| 23311 | op-snap---monthly-publication-october-2025.pdf | 1261 | 2025-10 | Other | Volkswagen | golf | Red | Misc - Non Traffic Offences | None | Grove Avenue | Grove Avenue | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4422494 | -1.8820898 | ||
| 23903 | op-snap---monthly-publication-september-2025.pdf | 122 | 2025-09 | Other | BMW | X6 | White | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 24026 | op-snap---monthly-publication-september-2025.pdf | 245 | 2025-09 | Other | Kia | Creed | Black | Driving without Due Care and Attention | None | M6 Motorway | M6 Motorway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5327447 | -1.899844 | ||
| 24046 | op-snap---monthly-publication-september-2025.pdf | 265 | 2025-09 | Other | Motor vehicle fail to comply with endorsable sect | ion 36 traffic sign -otheNr othnaen manned or automatic | Meqeuticphmleeyn Ltane | Meqeuticphmleeyn Ltane | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 24091 | op-snap---monthly-publication-september-2025.pdf | 310 | 2025-09 | Other | Skoda | Octavia | Grey | Misc - Non Traffic Offences | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4552055 | -1.9461279 | ||
| 24092 | op-snap---monthly-publication-september-2025.pdf | 311 | 2025-09 | Other | Land Rover | Discovery | Black | Misc - Non Traffic Offences | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4552055 | -1.9461279 | ||
| 24097 | op-snap---monthly-publication-september-2025.pdf | 316 | 2025-09 | Other | Driving without Due Care and Attention | None | Wharf Road | Wharf Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4075531 | -1.927329 | |||||
| 24254 | op-snap---monthly-publication-september-2025.pdf | 473 | 2025-09 | Other | Cycle | Misc - Non Traffic Offences | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | ||||
| 24298 | op-snap---monthly-publication-september-2025.pdf | 517 | 2025-09 | Other | Mercedes-Benz | Vito | Black | Misc - Non Traffic Offences | None | Russell Road by Cannon Hill Park | Russell Road by Cannon Hill Park | Birmingham | Birmingham | NFA | No Offence | ||||
| 24533 | op-snap---monthly-publication-september-2025.pdf | 752 | 2025-09 | Other | Honda | Accord | Silver | No Insurance | No vehicle excise licence | Parkdale Close | Parkdale Close | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.513341 | -1.8406439 | ||
| 24670 | op-snap---monthly-publication-september-2025.pdf | 889 | 2025-09 | Other | BMW | M140 | Black | Driving without Due Care and Attention | None | War Lane | War Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4569552 | -1.9616483 | ||
| 2077 | op-snap---monthly-publication-august-2025.pdf | 52 | 2025-08 | Other | N/K | Misc - Non Traffic Offences | None | Holiday Street | Holiday Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4757071 | -1.8988573 | ||||
| 2196 | op-snap---monthly-publication-august-2025.pdf | 171 | 2025-08 | Other | Renault | unknown | Using a Mobile Phone Whilst Driving | Driving without Due Care and Attention | Kingstanding | Kingstanding | Birmingham | Birmingham | NFA | No VRM | 52.5530147 | -1.8843477 | |||
| 2223 | op-snap---monthly-publication-august-2025.pdf | 198 | 2025-08 | Other | Ford | S Max | Blue | Misc - Non Traffic Offences | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4700545 | -1.834436 | ||
| 2325 | op-snap---monthly-publication-august-2025.pdf | 300 | 2025-08 | Other | Volkswagen | golf | Blue | Driving without Due Care and Attention | None | Reddings Lane | Reddings Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4506039 | -1.8463952 | ||
| 2402 | op-snap---monthly-publication-august-2025.pdf | 377 | 2025-08 | Other | Audi | A6 | Grey | Using a Mobile Phone Whilst Driving | None | Motorway? Unknown | Motorway? Unknown | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 2683 | op-snap---monthly-publication-august-2025.pdf | 658 | 2025-08 | Other | BMW | 3 Series | Blue | Misc - Non Traffic Offences | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | ||
| 3066 | op-snap---monthly-publication-august-2025.pdf | 1041 | 2025-08 | Other | Ford | Fiesta | Silver | Misc - Non Traffic Offences | No Insurance | Baltimore Road | Baltimore Road | Birmingham | Birmingham | NFA | No Offence | 52.5286702 | -1.9241545 | ||
| 3856 | op-snap---monthly-publication-august-2025.pdf | 1831 | 2025-08 | Other | Ford | fiesta | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | john street | John Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5010537 | -1.9155739 | ||
| 12075 | op-snap---monthly-publication-july-2025.pdf | 127 | 2025-07 | Other | Hyundai | Tucson | White | Cause vehicle to be left in a dangerous position | None | Institute Road | Institute Road | Birmingham | Birmingham | NFA | No Offence | 52.4334781 | -1.8892337 | ||
| 12076 | op-snap---monthly-publication-july-2025.pdf | 128 | 2025-07 | Other | Mercedes-Benz | C class | Blue | Driving without Due Care and Attention | None | Star City | Star City | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5054363 | -1.8556273 | ||
| 12149 | op-snap---monthly-publication-july-2025.pdf | 201 | 2025-07 | Other | NP | Misc - Non Traffic Offences | No Insurance | Unknown | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||||
| 12165 | op-snap---monthly-publication-july-2025.pdf | 217 | 2025-07 | Other | BMW | 3 series | Black | Misc - Non Traffic Offences | None | A38 | A38 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 12434 | op-snap---monthly-publication-july-2025.pdf | 486 | 2025-07 | Other | Nissan | Qashqai | Grey | Driving without Due Care and Attention | None | UK | Uk | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.45124 | -1.937937 | ||
| 12571 | op-snap---monthly-publication-july-2025.pdf | 623 | 2025-07 | Other | BMW | 4 series | Grey | Misc - Non Traffic Offences | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Offence | 52.4726661 | -1.8769032 | ||
| 12718 | op-snap---monthly-publication-july-2025.pdf | 770 | 2025-07 | Other | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Lee Bank Middleway | Lee Bank Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4677721 | -1.9037358 | ||
| 12830 | op-snap---monthly-publication-july-2025.pdf | 882 | 2025-07 | Other | BMW | 520 | Black | Driving without Due Care and Attention | No Insurance | Star City | Star City | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5054363 | -1.8556273 | ||
| 12857 | op-snap---monthly-publication-july-2025.pdf | 909 | 2025-07 | Other | Using a Mobile Phone Whilst Driving | None | U/K | U/K | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4882696 | -1.9143495 | |||||
| 13063 | op-snap---monthly-publication-july-2025.pdf | 1115 | 2025-07 | Other | Ford | Fiesta | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | SYcamore Road , Bournville | SYcamore Road , Bournville | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.430564 | -1.9341477 |
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);