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'}
120 rows where disposal = "NFA", month = "2025-05" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 24
offence 19
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 34
- Misc - Non Traffic Offences 16
- Contravening a Red Traffic Light 13
- Cause vehicle to be left in a dangerous position 11
- Driving without Due Care and Attention 9
- Stop a vehicle on pedestrian crossing 6
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 5
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 4
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 4
- No Insurance 4
- Driving a vehicle wholly or partly on a footpath 3
- Dangerous Driving 2
- Motor vehicle fail to comply with solid white line road markings 2
- Using a Mobile Phone Whilst Driving 2
- Fail to Conform to Cycle Lane 1
- Fail to display front VRM plate 1
- Keeping a vehicle with registration marks obscured 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
council_area 11
reporter_transport_mode 1
- Pedestrian · 120 ✖
month 1
- 2025-05 · 120 ✖
disposal 1
- NFA · 120 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18641 | op-snap---monthly-publication-may-2025.pdf | 3 | 2025-05 | Pedestrian | Citroen | c5 | Silver | No Seat Belt | None | Hannah Road | Hannah Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 18642 | op-snap---monthly-publication-may-2025.pdf | 4 | 2025-05 | Pedestrian | Citroen | C5 | Silver | Using a Mobile Phone Whilst Driving | None | Hannah Road | Hannah Road | Wolverhampton | Wolverhampton | NFA | Not in Public Interest | ||||
| 18653 | op-snap---monthly-publication-may-2025.pdf | 15 | 2025-05 | Pedestrian | Volvo | XC60 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Clent Road | Clent Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4725947 | -1.9952306 | ||
| 18655 | op-snap---monthly-publication-may-2025.pdf | 17 | 2025-05 | Pedestrian | Mercedes-Benz | C220 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road | Castle Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5258312 | -2.0768625 | ||
| 18656 | op-snap---monthly-publication-may-2025.pdf | 18 | 2025-05 | Pedestrian | Kia | Sportage | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheatley Road | Wheatley Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4705903 | -1.9933164 | ||
| 18665 | op-snap---monthly-publication-may-2025.pdf | 27 | 2025-05 | Pedestrian | 720s | Orange | Fail to display front VRM plate | None | Anchorage Road | Anchorage Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.5699381 | -1.8249539 | |||
| 18696 | op-snap---monthly-publication-may-2025.pdf | 58 | 2025-05 | Pedestrian | Audi | A6.. | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 18706 | op-snap---monthly-publication-may-2025.pdf | 68 | 2025-05 | Pedestrian | Nissan | Qashqai | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Field Lane | Field Lane | Dudley | Dudley | NFA | Not in Public Interest | 52.4469063 | -2.1430048 | ||
| 18733 | op-snap---monthly-publication-may-2025.pdf | 95 | 2025-05 | Pedestrian | Renault | CAPTUR | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | PETERSFIELD ROAD | Petersfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4307 | -1.8494663 | ||
| 18738 | op-snap---monthly-publication-may-2025.pdf | 100 | 2025-05 | Pedestrian | Ford | Transit | Silver | Cause vehicle to be left in a dangerous position | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4878246 | -1.9421047 | ||
| 18740 | op-snap---monthly-publication-may-2025.pdf | 102 | 2025-05 | Pedestrian | BMW | 218M | White | Contravening a Red Traffic Light | None | WARSTONE LANE | Warstone Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4870496 | -1.912873 | ||
| 18743 | op-snap---monthly-publication-may-2025.pdf | 105 | 2025-05 | Pedestrian | Toyota | Prius | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Frederick Street | Frederick Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4863384 | -1.9123011 | ||
| 18744 | op-snap---monthly-publication-may-2025.pdf | 106 | 2025-05 | Pedestrian | Mercedes-Benz | CLA | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Frederick Street | Frederick Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4863384 | -1.9123011 | ||
| 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 | ||
| 18747 | op-snap---monthly-publication-may-2025.pdf | 109 | 2025-05 | Pedestrian | Volvo | S60 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Trossachs Road | Trossachs Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.412542 | -1.5757615 | ||
| 18799 | op-snap---monthly-publication-may-2025.pdf | 161 | 2025-05 | Pedestrian | Iveco | White | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Birmingham Road Aldridge | Birmingham Road Aldridge | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5766298 | -1.9685663 | |||
| 18800 | op-snap---monthly-publication-may-2025.pdf | 162 | 2025-05 | Pedestrian | London Taxi | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Heath Road | Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4220874 | -1.9409615 | |||
| 18817 | op-snap---monthly-publication-may-2025.pdf | 179 | 2025-05 | Pedestrian | Volkswagen | Golf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hey Lane | Hey Lane | Solihull | Solihull | NFA | No VRM | ||||
| 18832 | op-snap---monthly-publication-may-2025.pdf | 194 | 2025-05 | Pedestrian | Peugeot | BVoxer | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Broadway | Broadway | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3999339 | -1.5249817 | ||
| 18859 | op-snap---monthly-publication-may-2025.pdf | 221 | 2025-05 | Pedestrian | Toyota | Prius | Red | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Acces Road between Metchley Lane | Acces Road between Metchley Lane | Banirdm tinhgeh QaEm Hospital | Banirdm Tinhgeh Qaem Hospital | NFA | Outside of 14 Days NIP | ||||
| 18866 | op-snap---monthly-publication-may-2025.pdf | 228 | 2025-05 | Pedestrian | Seat | Ibiza | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennal Road | Tennal Road | Birmingham | Birmingham | NFA | No Offence | 52.4578511 | -1.9734988 | ||
| 18869 | op-snap---monthly-publication-may-2025.pdf | 231 | 2025-05 | Pedestrian | Ford | Transit | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lightswood Hill | Lightswood Hill | Birmingham | Birmingham | NFA | No Offence | ||||
| 18884 | op-snap---monthly-publication-may-2025.pdf | 246 | 2025-05 | Pedestrian | Jaguar | XF... | Grey | Contravening a Red Traffic Light | None | A4148 Walsall | Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5841365 | -1.9852679 | ||
| 18887 | op-snap---monthly-publication-may-2025.pdf | 249 | 2025-05 | Pedestrian | BMW | 535 D | Silver | Contravening a Red Traffic Light | None | A4148 Walsall | Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5841365 | -1.9852679 | ||
| 18889 | op-snap---monthly-publication-may-2025.pdf | 251 | 2025-05 | Pedestrian | Audi | A5 | Grey | Contravening a Red Traffic Light | None | A4148 | A4148 | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 18964 | op-snap---monthly-publication-may-2025.pdf | 326 | 2025-05 | Pedestrian | Ford | Ecosport | Blue | Cause vehicle to be left in a dangerous position | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4470686 | -1.8880749 | ||
| 18970 | op-snap---monthly-publication-may-2025.pdf | 332 | 2025-05 | Pedestrian | Vauxhall | Mokka | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | City Road | City Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4763176 | -1.9584897 | ||
| 18986 | op-snap---monthly-publication-may-2025.pdf | 348 | 2025-05 | Pedestrian | BMW | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | NFA | No VRM | 52.4762433 | -1.9176665 | |||
| 18988 | op-snap---monthly-publication-may-2025.pdf | 350 | 2025-05 | Pedestrian | Seat | Leon | Silver | Driving without Due Care and Attention | None | Worcester | Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3101165 | -2.0442678 | ||
| 19032 | op-snap---monthly-publication-may-2025.pdf | 394 | 2025-05 | Pedestrian | Land Rover | Range Rover | Black | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19033 | op-snap---monthly-publication-may-2025.pdf | 395 | 2025-05 | Pedestrian | Ford | Puma | Red | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19035 | op-snap---monthly-publication-may-2025.pdf | 397 | 2025-05 | Pedestrian | Vauxhall | Corsa | Red | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19039 | op-snap---monthly-publication-may-2025.pdf | 401 | 2025-05 | Pedestrian | Toyota | MPV | White | Contravening a Red Traffic Light | None | LICHFIELD STREET | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19040 | op-snap---monthly-publication-may-2025.pdf | 402 | 2025-05 | Pedestrian | Grey | Contravening a Red Traffic Light | None | LICHFIELD STREET | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||||
| 19041 | op-snap---monthly-publication-may-2025.pdf | 403 | 2025-05 | Pedestrian | Ford | various makes | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | 52.5690681 | -1.8271174 | ||
| 19045 | op-snap---monthly-publication-may-2025.pdf | 407 | 2025-05 | Pedestrian | Misc - Non Traffic Offences | None | WILLOW AVENUE | Willow Avenue | Birmingham | Birmingham | NFA | No Offence | 52.4792236 | -1.9652858 | |||||
| 19046 | op-snap---monthly-publication-may-2025.pdf | 408 | 2025-05 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Battery Way | Battery Way | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4493988 | -1.8476406 | ||
| 19086 | op-snap---monthly-publication-may-2025.pdf | 448 | 2025-05 | Pedestrian | Mitsubishi | Fuso | White | Misc - Non Traffic Offences | None | Addison Road | Addison Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4313296 | -1.8882575 | ||
| 19096 | op-snap---monthly-publication-may-2025.pdf | 458 | 2025-05 | Pedestrian | Contravening a Red Traffic Light | None | PEDMORE ROAD | Pedmore Road | Dudley | Dudley | NFA | No VRM | 52.4897451 | -2.1069141 | |||||
| 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 | ||
| 19116 | op-snap---monthly-publication-may-2025.pdf | 478 | 2025-05 | Pedestrian | Volkswagen | polo | White | Driving without Due Care and Attention | None | Robin Hood Road | Robin Hood Road | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4781594 | -2.1049925 | ||
| 19130 | op-snap---monthly-publication-may-2025.pdf | 492 | 2025-05 | Pedestrian | BMW | M4 | White | Driving without Due Care and Attention | None | Valentine Road | Valentine Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4381959 | -1.8907391 | ||
| 19155 | op-snap---monthly-publication-may-2025.pdf | 517 | 2025-05 | Pedestrian | Suzuki | Splash | Grey | Contravening a Red Traffic Light | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4668753 | -1.8996143 | ||
| 19159 | op-snap---monthly-publication-may-2025.pdf | 521 | 2025-05 | Pedestrian | Ford | Galaxy | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Regent Parade | Regent Parade | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4863585 | -1.9094435 | ||
| 19171 | op-snap---monthly-publication-may-2025.pdf | 533 | 2025-05 | Pedestrian | Vauxhall | CORSA | Silver | Fail to Conform to Cycle Lane | None | CANN HILL ROAD | Cann Hill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 19174 | op-snap---monthly-publication-may-2025.pdf | 536 | 2025-05 | Pedestrian | Ford | Fiesta | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4860376 | -1.9095854 | ||
| 19189 | op-snap---monthly-publication-may-2025.pdf | 551 | 2025-05 | Pedestrian | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Bosty Lane | Bosty Lane | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5948329 | -1.927787 | ||
| 19192 | op-snap---monthly-publication-may-2025.pdf | 554 | 2025-05 | Pedestrian | Ford | Puma | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wyatt Road | Wyatt Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5664484 | -1.7828946 | ||
| 19198 | op-snap---monthly-publication-may-2025.pdf | 560 | 2025-05 | Pedestrian | Dangerous Driving | none | Commonside road | Commonside road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||||
| 19212 | op-snap---monthly-publication-may-2025.pdf | 574 | 2025-05 | Pedestrian | Audi | A5.. | White | Misc - Non Traffic Offences | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4693896 | -2.1251602 | ||
| 19220 | op-snap---monthly-publication-may-2025.pdf | 582 | 2025-05 | Pedestrian | Daf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wyatt Road | Wyatt Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5664484 | -1.7828946 | |||
| 19284 | op-snap---monthly-publication-may-2025.pdf | 646 | 2025-05 | Pedestrian | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Shottery Road, Stratford Upon Avon | Shottery Road, Stratford Upon Avon | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19322 | op-snap---monthly-publication-may-2025.pdf | 684 | 2025-05 | Pedestrian | Mini | Cooper | Red | Misc - Non Traffic Offences | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | NFA | No Offence | 52.5012458 | -1.8780942 | ||
| 19395 | op-snap---monthly-publication-may-2025.pdf | 757 | 2025-05 | Pedestrian | Honda | Civic | Silver | Driving without Due Care and Attention | None | Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | ||
| 19451 | op-snap---monthly-publication-may-2025.pdf | 813 | 2025-05 | Pedestrian | BMW | Grey | Misc - Non Traffic Offences | None | Avenue Road | Avenue Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4941712 | -1.8795158 | |||
| 19485 | op-snap---monthly-publication-may-2025.pdf | 847 | 2025-05 | Pedestrian | Ford | Tourneo | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | 52.561 | -1.8187105 | ||
| 19647 | op-snap---monthly-publication-may-2025.pdf | 1009 | 2025-05 | Pedestrian | BMW | ? | Blue | Driving without Due Care and Attention | None | REDDINGS LANE | Reddings Lane | Birmingham | Birmingham | NFA | No VRM | 52.4506039 | -1.8463952 | ||
| 19664 | op-snap---monthly-publication-may-2025.pdf | 1026 | 2025-05 | Pedestrian | Toyota | Yaris | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Alcester Road South | Alcester Road South | Birmingham | Birmingham | NFA | No Offence | 52.4170522 | -1.8906187 | ||
| 19695 | op-snap---monthly-publication-may-2025.pdf | 1057 | 2025-05 | Pedestrian | Nissan | Navara | Silver | Misc - Non Traffic Offences | None | Heeley Road | Heeley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4401847 | -1.9331572 | ||
| 19698 | op-snap---monthly-publication-may-2025.pdf | 1060 | 2025-05 | Pedestrian | Audi | A3 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Private Land | Private Land | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 19778 | op-snap---monthly-publication-may-2025.pdf | 1140 | 2025-05 | Pedestrian | Honda | Civic | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lozells Street | Lozells Street | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5007454 | -1.9067107 | ||
| 19796 | op-snap---monthly-publication-may-2025.pdf | 1158 | 2025-05 | Pedestrian | Ford | ST | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4878246 | -1.9421047 | ||
| 19799 | op-snap---monthly-publication-may-2025.pdf | 1161 | 2025-05 | Pedestrian | Dacia | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotton Park Road | Rotton Park Road | Birmingham | Birmingham | NFA | No Offence | 52.4851072 | -1.9468115 | |||
| 19835 | op-snap---monthly-publication-may-2025.pdf | 1197 | 2025-05 | Pedestrian | Toyota | Aygo | black | No Insurance | No vehicle excise lice | nHceandsworth | n Hceandsworth | Birmingham | Birmingham | NFA | No Offence | ||||
| 19836 | op-snap---monthly-publication-may-2025.pdf | 1198 | 2025-05 | Pedestrian | BMW | various | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Longbridge Road | Longbridge Road | Birmingham | Birmingham | NFA | No Offence | 52.3951676 | -1.990718 | ||
| 19837 | op-snap---monthly-publication-may-2025.pdf | 1199 | 2025-05 | Pedestrian | Nissan | Micra | Silver | No Insurance | No vehicle excise lice | nHceandsworth | n Hceandsworth | Birmingham | Birmingham | NFA | No Offence | ||||
| 19839 | op-snap---monthly-publication-may-2025.pdf | 1201 | 2025-05 | Pedestrian | Mg | HS.. | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Manor Farm Road | Manor Farm Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4539235 | -1.8493825 | ||
| 19847 | op-snap---monthly-publication-may-2025.pdf | 1209 | 2025-05 | Pedestrian | Mercedes-Benz | EQC | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holliday St | Holliday Street | Birmingham | Birmingham | NFA | No Offence | 52.4780205 | -1.9047506 | ||
| 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 | ||
| 19854 | op-snap---monthly-publication-may-2025.pdf | 1216 | 2025-05 | Pedestrian | Jaguar | S type | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Heaton Road | Heaton Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4284827 | -1.7951002 | ||
| 19859 | op-snap---monthly-publication-may-2025.pdf | 1221 | 2025-05 | Pedestrian | Vauxhall | Corsa | Black | Misc - Non Traffic Offences | None | Highgate Road | Highgate Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4606652 | -1.8791145 | ||
| 19880 | op-snap---monthly-publication-may-2025.pdf | 1242 | 2025-05 | Pedestrian | Peugeot | 208GT | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tame Rd East | Tame Road East | Sandwell | Sandwell | NFA | No Offence | ||||
| 19883 | op-snap---monthly-publication-may-2025.pdf | 1245 | 2025-05 | Pedestrian | Citroen | Picasso | Blue | Misc - Non Traffic Offences | None | High St | High Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5254588 | -1.8373064 | ||
| 19886 | op-snap---monthly-publication-may-2025.pdf | 1248 | 2025-05 | Pedestrian | Toyota | Hiace | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bowden Road | Bowden Road | Sandwell | Sandwell | NFA | Not in Public Interest | 52.4980696 | -1.9805738 | ||
| 19887 | op-snap---monthly-publication-may-2025.pdf | 1249 | 2025-05 | Pedestrian | BMW | 120D | Black | No Insurance | None | TUDOR ROAD | Tudor Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5655772 | -1.8268728 | ||
| 19898 | op-snap---monthly-publication-may-2025.pdf | 1260 | 2025-05 | Pedestrian | Ford | KA | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Brighton Road | Brighton Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4543156 | -1.8840717 | ||
| 19900 | op-snap---monthly-publication-may-2025.pdf | 1262 | 2025-05 | Pedestrian | Nissan | Black | Contravening a Red Traffic Light | None | Daw end Lane , Walsall | Daw end Lane , Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.6069179 | -1.9610677 | |||
| 19908 | op-snap---monthly-publication-may-2025.pdf | 1270 | 2025-05 | Pedestrian | Jaguar | NP | Black | Stop a vehicle on pedestrian crossing | None | Crossing Barrington road | Crossing Barrington road | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 19916 | op-snap---monthly-publication-may-2025.pdf | 1278 | 2025-05 | Pedestrian | Kia | Rio | Black | Dangerous Driving | None | Kenilworth road | Kenilworth road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3833298 | -1.5379214 | ||
| 19925 | op-snap---monthly-publication-may-2025.pdf | 1287 | 2025-05 | Pedestrian | Ford | NP | Black | Misc - Non Traffic Offences | None | Stratford road south | Stratford road south | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 19935 | op-snap---monthly-publication-may-2025.pdf | 1297 | 2025-05 | Pedestrian | Ford | Transit | White | Misc - Non Traffic Offences | None | Larch avenue | Larch avenue | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5153484 | -1.9438891 | ||
| 19936 | op-snap---monthly-publication-may-2025.pdf | 1298 | 2025-05 | Pedestrian | Ford | Transit 350 | White | Misc - Non Traffic Offences | None | Larch Avenue | Larch Avenue | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5153484 | -1.9438891 | ||
| 19939 | op-snap---monthly-publication-may-2025.pdf | 1301 | 2025-05 | Pedestrian | Seat | Ateca | White | Stop a vehicle on pedestrian crossing | None | Corner of Falstaff road, at JCT of Sh | Corner of Falstaff road, at JCT of Sh | aSkoelsihpuellare drive | Askoelsihpuellare Drive | NFA | Outside of 14 Days NIP | ||||
| 19950 | op-snap---monthly-publication-may-2025.pdf | 1312 | 2025-05 | Pedestrian | Seat | NP | White | Driving a vehicle wholly or partly on a footpath | None | Kings heath high street | Kings heath high street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4391028 | -1.893289 | ||
| 19951 | op-snap---monthly-publication-may-2025.pdf | 1313 | 2025-05 | Pedestrian | Mercedes-Benz | NP | Silver | Driving a vehicle wholly or partly on a footpath | None | Alcester Road , Birmingham | Alcester Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.452635 | -1.8874738 | ||
| 19952 | op-snap---monthly-publication-may-2025.pdf | 1314 | 2025-05 | Pedestrian | Volkswagen | GOLF | Silver | Stop a vehicle on pedestrian crossing | None | A435 King heath high street | King heath high street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.435978 | -1.8925342 | ||
| 19974 | op-snap---monthly-publication-may-2025.pdf | 1336 | 2025-05 | Pedestrian | Ford | Van | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | All Saints Road , Kings Heath | All Saints Road , Kings Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4312552 | -1.8943977 | ||
| 19987 | op-snap---monthly-publication-may-2025.pdf | 1349 | 2025-05 | Pedestrian | BMW | NP | Grey | Stop a vehicle on pedestrian crossing | None | Aston street | Aston street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4860595 | -1.8878051 | ||
| 19996 | op-snap---monthly-publication-may-2025.pdf | 1358 | 2025-05 | Pedestrian | BMW | NP | Black | Driving a vehicle wholly or partly on a footpath | None | A435 | A435 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 20001 | op-snap---monthly-publication-may-2025.pdf | 1363 | 2025-05 | Pedestrian | Audi | NP | Grey | Misc - Non Traffic Offences | None | station road, kings heath road | Station Road, Kings Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4303068 | -1.9077938 | ||
| 20002 | op-snap---monthly-publication-may-2025.pdf | 1364 | 2025-05 | Pedestrian | Ford | transit 115 | White | Misc - Non Traffic Offences | None | 19 Friary road | 19 Friary road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5178599 | -1.9363435 | ||
| 20003 | op-snap---monthly-publication-may-2025.pdf | 1365 | 2025-05 | Pedestrian | Ford | Transit custom | Silver | Misc - Non Traffic Offences | None | b21 8et, handsworth | B21 8Et, Handsworth | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5079951 | -1.9495377 | ||
| 20015 | op-snap---monthly-publication-may-2025.pdf | 1377 | 2025-05 | Pedestrian | Mercedes-Benz | NP | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ramsay road | Ramsay road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4723061 | -1.9942558 | ||
| 20016 | op-snap---monthly-publication-may-2025.pdf | 1378 | 2025-05 | Pedestrian | Mercedes-Benz | NP | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Clent road | Clent road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4725947 | -1.9952306 | ||
| 20021 | op-snap---monthly-publication-may-2025.pdf | 1383 | 2025-05 | Pedestrian | Toyota | Celica | Silver | Misc - Non Traffic Offences | None | 48 OSCOTT ROAD PERRY BARR | 48 Oscott Road Perry Barr | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5168187 | -1.893834 | ||
| 20022 | op-snap---monthly-publication-may-2025.pdf | 1384 | 2025-05 | Pedestrian | Toyota | yaris | Silver | Keeping a vehicle with registration marks obscured | None | ARDEN CROFT ROAD | Arden Croft Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 20023 | op-snap---monthly-publication-may-2025.pdf | 1385 | 2025-05 | Pedestrian | Mercedes-Benz | NP | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | ARDEN CROFT ROAD | Arden Croft Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 20025 | op-snap---monthly-publication-may-2025.pdf | 1387 | 2025-05 | Pedestrian | BMW | NP | Silver | Stop a vehicle on pedestrian crossing | None | Wattville road | Wattville road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5063926 | -1.9548648 | ||
| 20036 | op-snap---monthly-publication-may-2025.pdf | 1398 | 2025-05 | Pedestrian | Ford | Focus | Red | Motor vehicle fail to comply with solid white line road markings | None | Turners lane | Turners lane | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4721372 | -2.1243522 | ||
| 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 |
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);