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'}
102 rows where disposal = "NFA" and offence = "Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD" 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 13
council_area 9
- Birmingham 49
- Sutton Coldfield 13
- Coventry 11
- Dudley 8
- Out of Force Area 8
- Sandwell 8
- Mcoy)Ventry 2
- Walsall 2
- Wolverhampton 1
reporter_transport_mode 5
- Pedestrian 42
- Car 39
- Pedal Bike 15
- Other 5
- Horse Rider 1
offence 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD · 102 ✖
disposal 1
- NFA · 102 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7332 | op-snap---monthly-publication-february-2026.pdf | 79 | 2026-02 | Pedestrian | Dacia | Jogger | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Queens Road Kenilworth | Queens Road Kenilworth | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 7790 | op-snap---monthly-publication-february-2026.pdf | 537 | 2026-02 | Pedestrian | Mg | HS | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5342947 | -1.8155375 | ||
| 7793 | op-snap---monthly-publication-february-2026.pdf | 540 | 2026-02 | Pedestrian | Volkswagen | Fox | Yellow | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5342947 | -1.8155375 | ||
| 7993 | op-snap---monthly-publication-february-2026.pdf | 740 | 2026-02 | Car | Mercedes-Benz | GLC | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hobbs Road | Hobbs Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 8005 | op-snap---monthly-publication-february-2026.pdf | 752 | 2026-02 | Pedestrian | Volkswagen | Tiguan | Gold | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lea Lane | Lea Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4835462 | -1.7767904 | ||
| 8131 | op-snap---monthly-publication-february-2026.pdf | 878 | 2026-02 | Pedestrian | Jaguar | F Pace | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Emerson Road | Emerson Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4589005 | -1.9541717 | ||
| 8162 | op-snap---monthly-publication-february-2026.pdf | 909 | 2026-02 | Car | Nissan | Juke | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Wheelwright Road | Wheelwright Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5096312 | -1.8353508 | ||
| 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 | ||||
| 10724 | op-snap---monthly-publication-january-2026.pdf | 185 | 2026-01 | Pedestrian | Land Rover | Discovery | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chilcote Close | Chilcote Close | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4167178 | -1.8457291 | ||
| 10814 | op-snap---monthly-publication-january-2026.pdf | 275 | 2026-01 | Car | Ford | Ranger | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road, Handsworth | Island Road, Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.509612 | -1.9513666 | ||
| 10816 | op-snap---monthly-publication-january-2026.pdf | 277 | 2026-01 | Car | Volkswagen | Polo | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road, Handsworth | Island Road, Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.509612 | -1.9513666 | ||
| 11633 | op-snap---monthly-publication-january-2026.pdf | 1094 | 2026-01 | Car | Skoda | Kodiaq | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Leamington | Leamington | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4562055 | -1.8762502 | ||
| 11856 | op-snap---monthly-publication-january-2026.pdf | 1317 | 2026-01 | Car | Audi | Q3 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | NFA | No Offence | 52.4634433 | -1.9965278 | ||
| 4181 | op-snap---monthly-publication-december-2025.pdf | 309 | 2025-12 | Car | Ford | Transit | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | A46 Warwick Road | Warwick Road | Coventry | Coventry | NFA | No VRM | 52.401916 | -1.5154953 | ||
| 4497 | op-snap---monthly-publication-december-2025.pdf | 625 | 2025-12 | Car | BMW | 3 Series | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4967329 | -1.8097462 | ||
| 4773 | op-snap---monthly-publication-december-2025.pdf | 901 | 2025-12 | Pedestrian | Vauxhall | Meriva | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Sherbourne St | Sherborne Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4762433 | -1.9176665 | ||
| 4846 | op-snap---monthly-publication-december-2025.pdf | 974 | 2025-12 | Car | Toyota | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Birmingham | Birmingham | NFA | No Offence | 52.5095686 | -1.9544485 | |||
| 5093 | op-snap---monthly-publication-december-2025.pdf | 1221 | 2025-12 | Pedestrian | Vauxhall | Astra | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Abbey Road | Abbey Road | Sandwell | Sandwell | NFA | No Offence | 52.47753 | -1.9774758 | ||
| 21407 | op-snap---monthly-publication-november-2025.pdf | 949 | 2025-11 | Pedestrian | Vauxhall | Grandland | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane | Turners Lane | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4721372 | -2.1243522 | ||
| 22505 | op-snap---monthly-publication-october-2025.pdf | 455 | 2025-10 | Car | Mercedes-Benz | E220 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | No Offence | 52.5919543 | -1.8517118 | ||
| 22516 | op-snap---monthly-publication-october-2025.pdf | 466 | 2025-10 | Car | Toyota | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4071231 | -1.4985178 | |||
| 22938 | op-snap---monthly-publication-october-2025.pdf | 888 | 2025-10 | Pedal Bike | Ford | Focus | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Far Gosford St | Far Gosford Street | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4071231 | -1.4985178 | ||
| 23413 | op-snap---monthly-publication-october-2025.pdf | 1363 | 2025-10 | Pedestrian | Cupra | Born | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Ryland Street | Ryland Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4757111 | -1.9189009 | ||
| 23548 | op-snap---monthly-publication-october-2025.pdf | 1498 | 2025-10 | Pedestrian | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4851181 | -1.9106263 | ||||
| 23635 | op-snap---monthly-publication-october-2025.pdf | 1585 | 2025-10 | Pedestrian | BMW | 3 Series | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | High St | High Street | Birmingham | Birmingham | NFA | No Offence | 52.5254588 | -1.8373064 | ||
| 2916 | op-snap---monthly-publication-august-2025.pdf | 891 | 2025-08 | Pedestrian | Audi | Q8 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Alcester Street | Alcester Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4696096 | -1.8871873 | ||
| 3309 | op-snap---monthly-publication-august-2025.pdf | 1284 | 2025-08 | Car | Toyota | MPV | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | out of force | Out Of Force | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3697 | op-snap---monthly-publication-august-2025.pdf | 1672 | 2025-08 | Pedestrian | BMW | I4 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place, city centre | Regent Place, city centre | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 12068 | op-snap---monthly-publication-july-2025.pdf | 120 | 2025-07 | Car | Mercedes-Benz | E220 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Edward Road | Edward Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4580901 | -1.894458 | ||
| 13439 | op-snap---monthly-publication-july-2025.pdf | 1491 | 2025-07 | Pedestrian | Toyota | Avensis | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Brdige Street | Brdige Street | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 13904 | op-snap---monthly-publication-july-2025.pdf | 1956 | 2025-07 | Car | Toyota | estima | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Merry Hill | Merry Hill | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4817646 | -2.1113435 | ||
| 14267 | op-snap---monthly-publication-june-2025.pdf | 196 | 2025-06 | Pedestrian | Alfa Romeo | Mito | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | 52.561 | -1.8187105 | ||
| 14496 | op-snap---monthly-publication-june-2025.pdf | 425 | 2025-06 | Pedal Bike | Audi | A3 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 14668 | op-snap---monthly-publication-june-2025.pdf | 597 | 2025-06 | Pedestrian | Audi | A1... | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Mitchell Avenue (Near to Charter Acade | Mitchell Avenue (Near to Charter Acade | mCoy)ventry | Mcoy)Ventry | NFA | No Independent Evidence Available | ||||
| 14669 | op-snap---monthly-publication-june-2025.pdf | 598 | 2025-06 | Pedestrian | Volvo | XC60 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Mitchell Avenue (Near to Charter Acade | Mitchell Avenue (Near to Charter Acade | mCoy)ventry | Mcoy)Ventry | NFA | No Independent Evidence Available | ||||
| 14966 | op-snap---monthly-publication-june-2025.pdf | 895 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Thynne Street | Thynne Street | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5145422 | -1.9842613 | ||
| 15001 | op-snap---monthly-publication-june-2025.pdf | 930 | 2025-06 | Car | Yamaha | MT09 | Purple | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bells Lane | Bells Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4053419 | -1.8944602 | ||
| 15119 | op-snap---monthly-publication-june-2025.pdf | 1048 | 2025-06 | Car | Seat | Ibiza | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4726661 | -1.8769032 | ||
| 15333 | op-snap---monthly-publication-june-2025.pdf | 1262 | 2025-06 | Pedal Bike | Mercedes-Benz | B CLASS | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Station Road | Station Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5054559 | -1.9506109 | ||
| 15361 | op-snap---monthly-publication-june-2025.pdf | 1290 | 2025-06 | Pedestrian | Volkswagen | Passat | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | York Road | York Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5231321 | -1.8415573 | ||
| 15386 | op-snap---monthly-publication-june-2025.pdf | 1315 | 2025-06 | Pedestrian | Toyota | Auris | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4860376 | -1.9095854 | ||
| 15462 | op-snap---monthly-publication-june-2025.pdf | 1391 | 2025-06 | Car | Audi | Q5 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | a452 | A452 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 15709 | op-snap---monthly-publication-june-2025.pdf | 1638 | 2025-06 | Car | Seat | Leon | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5919543 | -1.8517118 | ||
| 15762 | op-snap---monthly-publication-june-2025.pdf | 1691 | 2025-06 | Pedestrian | Kia | niro | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chapel house street | Chapel house street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.474429 | -1.8854816 | ||
| 15763 | op-snap---monthly-publication-june-2025.pdf | 1692 | 2025-06 | Pedestrian | Kia | Picanto | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chapel house street | Chapel house street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.474429 | -1.8854816 | ||
| 15774 | op-snap---monthly-publication-june-2025.pdf | 1703 | 2025-06 | Pedestrian | Skoda | Kadiq | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4693896 | -2.1251602 | ||
| 15967 | op-snap---monthly-publication-june-2025.pdf | 1896 | 2025-06 | Car | Vauxhall | Mokka | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Norwood Road | Norwood Road | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4831397 | -2.1309273 | ||
| 16013 | op-snap---monthly-publication-june-2025.pdf | 1942 | 2025-06 | Pedestrian | Toyota | Verso | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4679402 | -1.881408 | ||
| 16053 | op-snap---monthly-publication-june-2025.pdf | 1982 | 2025-06 | Horse Rider | MAN | Yellow | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Kerly Close | Kerly Close | Coventry | Coventry | NFA | No Independent Evidence Available | |||||
| 18716 | op-snap---monthly-publication-may-2025.pdf | 78 | 2025-05 | Pedal Bike | Mazda | 2 | Purple | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4708802 | -1.8792135 | ||
| 18717 | op-snap---monthly-publication-may-2025.pdf | 79 | 2025-05 | Pedal Bike | Mercedes-Benz | 200 AMG | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4708802 | -1.8792135 | ||
| 18719 | op-snap---monthly-publication-may-2025.pdf | 81 | 2025-05 | Pedal Bike | Audi | s4 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4708802 | -1.8792135 | ||
| 18720 | op-snap---monthly-publication-may-2025.pdf | 82 | 2025-05 | Pedal Bike | Mercedes-Benz | AMG | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4708802 | -1.8792135 | ||
| 18745 | op-snap---monthly-publication-may-2025.pdf | 107 | 2025-05 | Pedestrian | BMW | 1 Series | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane | Turners Lane | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4721372 | -2.1243522 | ||
| 18836 | op-snap---monthly-publication-may-2025.pdf | 198 | 2025-05 | Car | Mercedes-Benz | A CLASS | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Frederick Street | Frederick Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4863384 | -1.9123011 | ||
| 19103 | op-snap---monthly-publication-may-2025.pdf | 465 | 2025-05 | Car | Audi | A3 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | ROOKERY LANE . ALDRIDGE | Rookery Lane . Aldridge | Walsall | Walsall | NFA | No Offence | 52.6036562 | -1.9157561 | ||
| 19105 | op-snap---monthly-publication-may-2025.pdf | 467 | 2025-05 | Pedestrian | Peugeot | 308 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Longford Bridge Road | Longford Bridge Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4524222 | -1.485562 | ||
| 19567 | op-snap---monthly-publication-may-2025.pdf | 929 | 2025-05 | Car | Volkswagen | PASSAT | White | 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 | ||
| 19568 | op-snap---monthly-publication-may-2025.pdf | 930 | 2025-05 | Car | Citroen | ? | Grey | 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 | ||
| 19850 | op-snap---monthly-publication-may-2025.pdf | 1212 | 2025-05 | Pedestrian | Kia | Ceed | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | NFA | No Offence | 52.4851181 | -1.9106263 | ||
| 19985 | op-snap---monthly-publication-may-2025.pdf | 1347 | 2025-05 | Pedal Bike | Toyota | np | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stoney stanton road | Stoney stanton road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4221152 | -1.4959475 | ||
| 20057 | op-snap---monthly-publication-may-2025.pdf | 1419 | 2025-05 | Car | Mercedes-Benz | benz e22od salo | oBnlack | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Traffic light of bescott road | Traffic light of bescott road | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 20066 | op-snap---monthly-publication-may-2025.pdf | 1428 | 2025-05 | Pedestrian | Nissan | NP | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | sherborne street | Sherborne Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4762433 | -1.9176665 | ||
| 20067 | op-snap---monthly-publication-may-2025.pdf | 1429 | 2025-05 | Car | Audi | NP | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | exit of churchfields estate | Exit Of Churchfields Estate | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 20099 | op-snap---monthly-publication-may-2025.pdf | 1461 | 2025-05 | Other | Vauxhall | NP | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Norwood road brierley hill | Norwood road brierley hill | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4831397 | -2.1309273 | ||
| 20121 | op-snap---monthly-publication-may-2025.pdf | 1483 | 2025-05 | Car | BMW | NP | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | 29 ansley road | 29 Ansley Road | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 282 | op-snap---monthly-publication-april-2025.pdf | 281 | 2025-04 | Pedestrian | Kia | Picanto | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland RD | Upper Holland RD | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.561 | -1.8187105 | ||
| 284 | op-snap---monthly-publication-april-2025.pdf | 283 | 2025-04 | Pedestrian | Mercedes-Benz | C330 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.561 | -1.8187105 | ||
| 285 | op-snap---monthly-publication-april-2025.pdf | 284 | 2025-04 | Pedestrian | Mercedes-Benz | Sprinter | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.561 | -1.8187105 | ||
| 288 | op-snap---monthly-publication-april-2025.pdf | 287 | 2025-04 | Pedestrian | Tesla | Model Y | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.561 | -1.8187105 | ||
| 392 | op-snap---monthly-publication-april-2025.pdf | 391 | 2025-04 | Pedestrian | Toyota | Yaris | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.561 | -1.8187105 | ||
| 393 | op-snap---monthly-publication-april-2025.pdf | 392 | 2025-04 | Pedestrian | Mg | ZS | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.561 | -1.8187105 | ||
| 396 | op-snap---monthly-publication-april-2025.pdf | 395 | 2025-04 | Pedestrian | Porsche | Cayenne | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.561 | -1.8187105 | ||
| 397 | op-snap---monthly-publication-april-2025.pdf | 396 | 2025-04 | Pedestrian | Suzuki | Celeiro | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.561 | -1.8187105 | ||
| 449 | op-snap---monthly-publication-april-2025.pdf | 448 | 2025-04 | Pedal Bike | Ford | Ranger | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | none | Barras Lane | Barras Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4109877 | -1.5203488 | ||
| 498 | op-snap---monthly-publication-april-2025.pdf | 497 | 2025-04 | Car | Volkswagen | Caddy | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bristol Rd | Bristol Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4543565 | -1.9114004 | ||
| 565 | op-snap---monthly-publication-april-2025.pdf | 564 | 2025-04 | Pedal Bike | Audi | A1 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Friar Park Road | Friar Park Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5538676 | -1.9965667 | ||
| 566 | op-snap---monthly-publication-april-2025.pdf | 565 | 2025-04 | Pedal Bike | BMW | M5 | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Friar Park Rd | Friar Park Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5538676 | -1.9965667 | |||
| 672 | op-snap---monthly-publication-april-2025.pdf | 671 | 2025-04 | Pedestrian | Volkswagen | Golf | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place at Victoria Street | Regent Place at Victoria Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4860376 | -1.9095854 | ||
| 775 | op-snap---monthly-publication-april-2025.pdf | 774 | 2025-04 | Car | Toyota | Aygo | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Road | Foleshill Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4274335 | -1.5002381 | ||
| 787 | op-snap---monthly-publication-april-2025.pdf | 786 | 2025-04 | Pedal Bike | BMW | X1 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Barras Road | Barras Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4150239 | -1.4843313 | ||
| 788 | op-snap---monthly-publication-april-2025.pdf | 787 | 2025-04 | Pedal Bike | Mini | Cooper | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Barras Road | Barras Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4150239 | -1.4843313 | ||
| 1299 | op-snap---monthly-publication-april-2025.pdf | 1298 | 2025-04 | Car | Audi | Q5 Sport | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Junction of Upper Holland Road and Lower queen street | Junction of Upper Holland Road and Lower queen street | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | ||||
| 1314 | op-snap---monthly-publication-april-2025.pdf | 1313 | 2025-04 | Pedestrian | Toyota | Aygo | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Woodfield Avenue , Penn Wolverhampton | Woodfield Avenue , Penn Wolverhampton | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5668728 | -2.1489012 | ||
| 1436 | op-snap---monthly-publication-april-2025.pdf | 1435 | 2025-04 | Car | Volkswagen | NP | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Sherbone street | Sherbone street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 1456 | op-snap---monthly-publication-april-2025.pdf | 1455 | 2025-04 | Car | Hyundai | NP | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Junction of Broad Street and Gas Street | Junction of Broad Street and Gas Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 1594 | op-snap---monthly-publication-april-2025.pdf | 1593 | 2025-04 | Pedestrian | Toyota | NP | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bishopsgate street | Bishopsgate street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.473986 | -1.9147087 | ||
| 1632 | op-snap---monthly-publication-april-2025.pdf | 1631 | 2025-04 | Car | Seat | NP | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Farren road | Farren road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4032097 | -1.9872219 | ||
| 1772 | op-snap---monthly-publication-april-2025.pdf | 1771 | 2025-04 | Pedestrian | Tesla | NP | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Alcester road | Alcester road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4470686 | -1.8880749 | ||
| 1812 | op-snap---monthly-publication-april-2025.pdf | 1811 | 2025-04 | Other | Toyota | NP | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tower street | Tower street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.490562 | -1.9003853 | ||
| 1940 | op-snap---monthly-publication-april-2025.pdf | 1939 | 2025-04 | Pedal Bike | Ford | NP | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill road | Foleshill road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4274335 | -1.5002381 | ||
| 16652 | op-snap---monthly-publication-march-2025.pdf | 409 | 2025-03 | Other | Nissan | UK | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tower Street | Tower Street | Dudley | Dudley | NFA | No Independent Evidence Available | Yes - Via Email | 52.5112053 | -2.0833165 | |
| 17606 | op-snap---monthly-publication-march-2025.pdf | 1363 | 2025-03 | Pedal Bike | BMW | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4437078 | -1.8783408 | ||
| 17939 | op-snap---monthly-publication-march-2025.pdf | 1696 | 2025-03 | Car | Nissan | Note | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Albert Street Newcatsle Under Lyme | Albert Street Newcatsle Under Lyme | Out of Force Area | Out of Force Area | NFA | Out of Force | Yes - Via Email | |||
| 18237 | op-snap---monthly-publication-march-2025.pdf | 1994 | 2025-03 | Car | Ford | Fiesta | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Castle Road | Castle Road | Dudley | Dudley | NFA | No VRM | Yes - Via Email | 52.5258312 | -2.0768625 | |
| 5542 | op-snap---monthly-publication-february-2025.pdf | 359 | 2025-02 | Car | Maxus T90 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lombard Street | Lombard Street | Sandwell | Sandwell | NFA | No Independent Evidence Available | Yes - Via Email | 52.5206097 | -1.9962056 | ||
| 5962 | op-snap---monthly-publication-february-2025.pdf | 779 | 2025-02 | Car | Mercedes-Benz | van | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street, Sutton Coldfield | Lower Queen Street, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | NFA | No VRM | Yes - Via Email | 52.5596343 | -1.8225298 | |
| 6577 | op-snap---monthly-publication-february-2025.pdf | 1394 | 2025-02 | Pedestrian | Seat | Leon | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Alcester Road, Kings Heath | Alcester Road, Kings Heath | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4467439 | -1.8881358 | |
| 8950 | op-snap---monthly-publication-january-2025.pdf | 58 | 2025-01 | Car | UK | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | NFA | No VRM | Yes - Via Email | 52.5603978 | -1.8227403 |
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);