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'}
109 rows where disposal = "NFA", month = "2025-07" and offence = "Driving without Reasonable Consideration" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
council_area 24
- Birmingham 52
- Out of Force Area 16
- Sandwell 7
- Coventry 5
- Dudley 4
- Solihull 3
- Wolverhampton 3
- Sutton Coldfield 2
- Walsall 2
- Bafifromrdin Grhoaamd 1
- Bdirmingham 1
- Ebirmingham 1
- Lsouwtetor Nq Cuoelednfi Esldtreet , Sutton Col 1
- Mbirmingham 1
- Msolihull 1
- Obtti Rrmoinagdh ,A Bmirmingham 1
- Oguret Eonf Force Area 1
- Osnutton Coldfield 1
- Rocuht Sotfr Eftotorcne Area 1
- Sowutetor Nq Cueoeldnf Iseltdreet 1
- Vceonvtreyntry 1
- Woaurtd Osf Dfeovrcoen Area 1
- Yout Of Force Area 1
- Ysandwell 1
vehicle_make 23
reporter_transport_mode 5
- Car 84
- Pedal Bike 14
- Pedestrian 8
- Other 2
- Bus 1
offence 1
- Driving without Reasonable Consideration · 109 ✖
month 1
- 2025-07 · 109 ✖
disposal 1
- NFA · 109 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11953 | op-snap---monthly-publication-july-2025.pdf | 5 | 2025-07 | Car | Ford | Fiesta | Orange | Driving without Reasonable Consideration | None | Oldbury Ring Way | Oldbury Ring Way | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 11962 | op-snap---monthly-publication-july-2025.pdf | 14 | 2025-07 | Car | Nissan | Micra | Red | Driving without Reasonable Consideration | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4470686 | -1.8880749 | ||
| 11977 | op-snap---monthly-publication-july-2025.pdf | 29 | 2025-07 | Car | Volkswagen | PX15PHF | White | Driving without Reasonable Consideration | None | Parkfields Road | Parkfields Road | Wolverhampton | Wolverhampton | NFA | Outside of 14 DAYS Late Submission | ||||
| 12062 | op-snap---monthly-publication-july-2025.pdf | 114 | 2025-07 | Car | Byd | Seal | Blue | Driving without Reasonable Consideration | None | Kenilworth Road | Kenilworth Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5124557 | -1.8917609 | ||
| 12065 | op-snap---monthly-publication-july-2025.pdf | 117 | 2025-07 | Car | BMW | 330E | Grey | Driving without Reasonable Consideration | None | M42 Junction 3 West Mercia | M42 Junction 3 West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4846642 | -1.9297585 | ||
| 12085 | op-snap---monthly-publication-july-2025.pdf | 137 | 2025-07 | Car | Honda | jazz | Blue | Driving without Reasonable Consideration | None | Shenley Fields Road | Shenley Fields Road | Birmingham | Birmingham | NFA | No Offence | 52.4373076 | -1.9543847 | ||
| 12148 | op-snap---monthly-publication-july-2025.pdf | 200 | 2025-07 | Car | Ford | Fiesta | Yellow | Driving without Reasonable Consideration | None | Queen Elizabeth Hospital | Queen Elizabeth Hospital | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4517147 | -1.9423655 | ||
| 12199 | op-snap---monthly-publication-july-2025.pdf | 251 | 2025-07 | Car | Toyota | Police car | White | Driving without Reasonable Consideration | None | Anderton Park Road | Anderton Park Road | Birmingham | Birmingham | NFA | No Offence | 52.4481342 | -1.8776139 | ||
| 12304 | op-snap---monthly-publication-july-2025.pdf | 356 | 2025-07 | Car | Ford | Mondeo | Black | Driving without Reasonable Consideration | None | Coventry | Coventry | Birmingham | Birmingham | NFA | No Offence | 52.4527138 | -1.7656635 | ||
| 12500 | op-snap---monthly-publication-july-2025.pdf | 552 | 2025-07 | Car | Toyota | Yaris | Silver | Driving without Reasonable Consideration | None | Ulverley Green Road, Olton | Ulverley Green Road, Olton | Solihull | Solihull | NFA | No VRM | 52.4374545 | -1.803861 | ||
| 12567 | op-snap---monthly-publication-july-2025.pdf | 619 | 2025-07 | Pedal Bike | Honda | Jazz | Green | Driving without Reasonable Consideration | None | Saltway | Saltway | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12568 | op-snap---monthly-publication-july-2025.pdf | 620 | 2025-07 | Pedal Bike | BMW | 5 Series | Black | Driving without Reasonable Consideration | None | Redcap Heath Road | Red Cap Heath Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | ||||
| 12588 | op-snap---monthly-publication-july-2025.pdf | 640 | 2025-07 | Car | BMW | 4 series | Black | Driving without Reasonable Consideration | None | Chelmsley Wood | Chelmsley Wood | Birmingham | Birmingham | NFA | No Offence | ||||
| 12611 | op-snap---monthly-publication-july-2025.pdf | 663 | 2025-07 | Car | Volkswagen | Golf | White | Driving without Reasonable Consideration | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | NFA | No Offence | 52.5170745 | -1.9012542 | ||
| 12612 | op-snap---monthly-publication-july-2025.pdf | 664 | 2025-07 | Car | Seat | Leon | Silver | Driving without Reasonable Consideration | Use vehicle on a road without | Bvairlcidh ftieesldt cReoratifdicate | Bvairlcidh ftieesldt c Reoratifdicate | Birmingham | Birmingham | NFA | No Offence | ||||
| 12649 | op-snap---monthly-publication-july-2025.pdf | 701 | 2025-07 | Pedal Bike | Citroen | C3 | White | Driving without Reasonable Consideration | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.513336 | -1.8833226 | ||
| 12650 | op-snap---monthly-publication-july-2025.pdf | 702 | 2025-07 | Pedal Bike | Hyundai | Red | Driving without Reasonable Consideration | None | Wellington Road | Wellington Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5133725 | -1.9193405 | |||
| 12651 | op-snap---monthly-publication-july-2025.pdf | 703 | 2025-07 | Pedal Bike | Seat | Leon | Green | Driving without Reasonable Consideration | None | Wellinngton Road | Wellinngton Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 12652 | op-snap---monthly-publication-july-2025.pdf | 704 | 2025-07 | Pedal Bike | Nissan | Qashqai | Black | Driving without Reasonable Consideration | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.513336 | -1.8833226 | ||
| 12653 | op-snap---monthly-publication-july-2025.pdf | 705 | 2025-07 | Pedal Bike | Skoda | C3 | Blue | Driving without Reasonable Consideration | None | City Road | City Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4763176 | -1.9584897 | ||
| 12656 | op-snap---monthly-publication-july-2025.pdf | 708 | 2025-07 | Car | Hyundai | i30 | Grey | Driving without Reasonable Consideration | None | Chester Road | Chester Road | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5692139 | -1.8799672 | ||
| 12688 | op-snap---monthly-publication-july-2025.pdf | 740 | 2025-07 | Car | BMW | 118 | Black | Driving without Reasonable Consideration | None | A514 Bedford | Bedford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12752 | op-snap---monthly-publication-july-2025.pdf | 804 | 2025-07 | Car | Ford | Focus | Grey | Driving without Reasonable Consideration | None | Coventry Street, Kidderminster | Coventry Street, Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12802 | op-snap---monthly-publication-july-2025.pdf | 854 | 2025-07 | Car | Toyota | Prius | Silver | Driving without Reasonable Consideration | None | Lobe Lane | Lobe Lane | Solihull | Solihull | NFA | No Offence | ||||
| 12804 | op-snap---monthly-publication-july-2025.pdf | 856 | 2025-07 | Car | Toyota | Prius | Silver | Driving without Reasonable Consideration | None | Lode Lane | Lode Lane | Solihull | Solihull | NFA | No Offence | 52.4149064 | -1.7832364 | ||
| 12832 | op-snap---monthly-publication-july-2025.pdf | 884 | 2025-07 | Car | Hyundai | ioniq | White | Driving without Reasonable Consideration | None | M5 West Brom | M5 West Brom | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 12858 | op-snap---monthly-publication-july-2025.pdf | 910 | 2025-07 | Car | Vauxhall | Corsa | White | Driving without Reasonable Consideration | None | Biddling Lane | Biddling Lane | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 12861 | op-snap---monthly-publication-july-2025.pdf | 913 | 2025-07 | Car | Mazda | Black | Driving without Reasonable Consideration | None | Clifford Street , Newton | Clifford Street , Newton | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 12866 | op-snap---monthly-publication-july-2025.pdf | 918 | 2025-07 | Car | Audi | Estima | Silver | Driving without Reasonable Consideration | None | Somerville Road | Somerville Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5555545 | -1.8329387 | ||
| 12868 | op-snap---monthly-publication-july-2025.pdf | 920 | 2025-07 | Car | Volkswagen | Polo | White | Driving without Reasonable Consideration | None | Kings Road , Tyseley ,Birmingham | Kings Road , Tyseley , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4572996 | -1.8391692 | ||
| 12869 | op-snap---monthly-publication-july-2025.pdf | 921 | 2025-07 | Pedestrian | BMW | 420 | White | Driving without Reasonable Consideration | None | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||||
| 12870 | op-snap---monthly-publication-july-2025.pdf | 922 | 2025-07 | Pedestrian | Audi | Grey | Driving without Reasonable Consideration | None | York Road , Birmingham | York Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5231321 | -1.8415573 | |||
| 12871 | op-snap---monthly-publication-july-2025.pdf | 923 | 2025-07 | Pedestrian | Toyota | Yaris | Black | Driving without Reasonable Consideration | None | Bradford Road , Birmingham | Bradford Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5024148 | -1.7961753 | ||
| 12886 | op-snap---monthly-publication-july-2025.pdf | 938 | 2025-07 | Car | Audi | A4 | Black | Driving without Reasonable Consideration | None | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||||
| 12887 | op-snap---monthly-publication-july-2025.pdf | 939 | 2025-07 | Car | Audi | A5 | Red | Driving without Reasonable Consideration | None | M40 Southbound | M40 Southbound | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 12888 | op-snap---monthly-publication-july-2025.pdf | 940 | 2025-07 | Car | Scania | White | Driving without Reasonable Consideration | None | M6 Northbound | M6 Northbound | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.4316701 | -2.0178238 | |||
| 12889 | op-snap---monthly-publication-july-2025.pdf | 941 | 2025-07 | Car | BMW | Red | Driving without Reasonable Consideration | None | York Road , Birmingham | York Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5231321 | -1.8415573 | |||
| 12890 | op-snap---monthly-publication-july-2025.pdf | 942 | 2025-07 | Car | Vauxhall | Mokka | Grey | Driving without Reasonable Consideration | None | A4040 , Birmingham | A4040 , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5150323 | -1.9007149 | ||
| 12891 | op-snap---monthly-publication-july-2025.pdf | 943 | 2025-07 | Car | Audi | Black | Driving without Reasonable Consideration | None | Warwick Road , Birmingham | Warwick Road , Birmingham | Birmingham | Birmingham | NFA | Out of Force | 52.551985 | -1.860445 | |||
| 12892 | op-snap---monthly-publication-july-2025.pdf | 944 | 2025-07 | Car | Volvo | Black | Driving without Reasonable Consideration | None | M6 Northbound | M6 Northbound | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 12893 | op-snap---monthly-publication-july-2025.pdf | 945 | 2025-07 | Car | Vauxhall | Silver | Driving without Reasonable Consideration | None | M5 Northbound | M5 Northbound | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 12894 | op-snap---monthly-publication-july-2025.pdf | 946 | 2025-07 | Car | BMW | White | Driving without Reasonable Consideration | None | M42 close to Junction 8 | M42 close to Junction 8 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 12895 | op-snap---monthly-publication-july-2025.pdf | 947 | 2025-07 | Car | Renault | clio | Red | Driving without Reasonable Consideration | None | Walsall Road , West Bromwich | Walsall Road , West Bromwich | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5366137 | -1.9867997 | ||
| 12896 | op-snap---monthly-publication-july-2025.pdf | 948 | 2025-07 | Pedestrian | Ford | Fiesta | Black | Driving without Reasonable Consideration | None | Level Street , Merry Hill | Level Street , Merry Hill | Dudley | Dudley | NFA | Outside of 14 Days NIP | ||||
| 12898 | op-snap---monthly-publication-july-2025.pdf | 950 | 2025-07 | Car | Mercedes-Benz | sprinter | Orange | Driving without Reasonable Consideration | None | Caynton Road | Caynton Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12905 | op-snap---monthly-publication-july-2025.pdf | 957 | 2025-07 | Car | Contera MDI | Red | Driving without Reasonable Consideration | None | A46 Evesham | Evesham | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3837388 | -1.5529669 | |||
| 12907 | op-snap---monthly-publication-july-2025.pdf | 959 | 2025-07 | Car | Land Rover | Evoque | Black | Driving without Reasonable Consideration | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6291998 | -2.126312 | ||
| 12916 | op-snap---monthly-publication-july-2025.pdf | 968 | 2025-07 | Car | Land Rover | Discovery | Red | Driving without Reasonable Consideration | None | Melrose Avenue , Sutton | Melrose Avenue , Sutton | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.5511462 | -1.8479052 | ||
| 12917 | op-snap---monthly-publication-july-2025.pdf | 969 | 2025-07 | Car | Land Rover | Black | Driving without Reasonable Consideration | None | M5 North | M5 North | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5151103 | -1.8501538 | |||
| 12918 | op-snap---monthly-publication-july-2025.pdf | 970 | 2025-07 | Car | Ford | Transit | Blue | Driving without Reasonable Consideration | None | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||||
| 12919 | op-snap---monthly-publication-july-2025.pdf | 971 | 2025-07 | Car | Vauxhall | Insignia | Blue | Driving without Reasonable Consideration | None | Eastern Green Road , Coventry | Eastern Green Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4131188 | -1.5784769 | ||
| 12922 | op-snap---monthly-publication-july-2025.pdf | 974 | 2025-07 | Car | Honda | Silver | Driving without Reasonable Consideration | None | Third Avenue , Pensnett | Third Avenue , Pensnett | Dudley | Dudley | NFA | Out of Force | 52.5046812 | -2.1550209 | |||
| 12923 | op-snap---monthly-publication-july-2025.pdf | 975 | 2025-07 | Car | Toyota | Grey | Driving without Reasonable Consideration | None | Dudley Road , A4101 , Kingswinford | Dudley Road , A4101 , Kingswinford | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.5003036 | -2.1593541 | |||
| 12924 | op-snap---monthly-publication-july-2025.pdf | 976 | 2025-07 | Car | Skoda | Fabia | Black | Driving without Reasonable Consideration | None | Cole Hall Lane , Birmingham | Cole Hall Lane , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4877244 | -1.787883 | ||
| 12925 | op-snap---monthly-publication-july-2025.pdf | 977 | 2025-07 | Car | Vauxhall | Corsa | Red | Driving without Reasonable Consideration | None | Stourbridge Road , Colley Gate | Stourbridge Road , Colley Gate | Dudley | Dudley | NFA | Outside of 14 Days NIP | ||||
| 12926 | op-snap---monthly-publication-july-2025.pdf | 978 | 2025-07 | Pedestrian | Ford | Transit | Silver | Driving without Reasonable Consideration | None | Cole Hall Lane , Kitts Green | Cole Hall Lane , Kitts Green | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4877244 | -1.787883 | ||
| 12950 | op-snap---monthly-publication-july-2025.pdf | 1002 | 2025-07 | Other | Volkswagen | Bora | Black | Driving without Reasonable Consideration | None | M54 | M54 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12953 | op-snap---monthly-publication-july-2025.pdf | 1005 | 2025-07 | Car | Ford | Focus | White | Driving without Reasonable Consideration | None | Westcote Avenue , twoartds Frankley | Westcote Avenue , twoartds Frankley | OGuret eonf Force Area | Oguret Eonf Force Area | NFA | Outside of 14 Days NIP | ||||
| 12954 | op-snap---monthly-publication-july-2025.pdf | 1006 | 2025-07 | Car | BMW | White | Driving without Reasonable Consideration | None | Birmingham Road , Stratford | Birmingham Road , Stratford | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.4496153 | -1.8646204 | |||
| 12957 | op-snap---monthly-publication-july-2025.pdf | 1009 | 2025-07 | Car | Audi | A8 | Black | Driving without Reasonable Consideration | None | Stratford Road , Birmingham | Stratford Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4447583 | -1.8592059 | ||
| 12960 | op-snap---monthly-publication-july-2025.pdf | 1012 | 2025-07 | Car | BMW | Silver | Driving without Reasonable Consideration | None | Mini Roundabout , Bacchus Road | Mini Roundabout , Bacchus Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 12961 | op-snap---monthly-publication-july-2025.pdf | 1013 | 2025-07 | Car | BMW | 530d M Sport | Black | Driving without Reasonable Consideration | None | Star City , Birmingham | Star City , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5054363 | -1.8556273 | ||
| 12962 | op-snap---monthly-publication-july-2025.pdf | 1014 | 2025-07 | Pedestrian | Audi | Blue | Driving without Reasonable Consideration | None | Newton Middleway , Birmingham | Newton Middleway , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 12965 | op-snap---monthly-publication-july-2025.pdf | 1017 | 2025-07 | Pedestrian | Toyota | Yaris | Grey | Driving without Reasonable Consideration | None | Paradise Street , Birmingham | Paradise Street , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4790667 | -1.9039768 | ||
| 12967 | op-snap---monthly-publication-july-2025.pdf | 1019 | 2025-07 | Car | BMW | X5 | White | Driving without Reasonable Consideration | None | Wolverhampton - Heading towards ST | Wolverhampton - Heading towards ST | Bafifromrdin gRhoaamd | Bafifromrdin Grhoaamd | NFA | Outside of 14 Days NIP | ||||
| 12969 | op-snap---monthly-publication-july-2025.pdf | 1021 | 2025-07 | Other | Volkswagen | Golf | White | Driving without Reasonable Consideration | No Insurance | Prince of Wales Road , Coventry | Prince of Wales Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4103298 | -1.5412458 | ||
| 12972 | op-snap---monthly-publication-july-2025.pdf | 1024 | 2025-07 | Pedal Bike | Ford | Red | Driving without Reasonable Consideration | None | Gibbins Road , Selly Oak , Birmingha | Gibbins Road , Selly Oak , Birmingha | mSolihull | Msolihull | NFA | Outside of 14 Days NIP | |||||
| 12973 | op-snap---monthly-publication-july-2025.pdf | 1025 | 2025-07 | Pedal Bike | Peugeot | Grey | Driving without Reasonable Consideration | None | Gibbins Road , Selly Oak , Birmingha | Gibbins Road , Selly Oak , Birmingha | mBirmingham | Mbirmingham | NFA | Outside of 14 DAYS Late Submission | |||||
| 12979 | op-snap---monthly-publication-july-2025.pdf | 1031 | 2025-07 | Car | BMW | x1 | Black | Driving without Reasonable Consideration | None | M6 J13 | M6 J13 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6760749 | -2.0862582 | ||
| 12986 | op-snap---monthly-publication-july-2025.pdf | 1038 | 2025-07 | Car | Yamaha | Blue | Driving without Reasonable Consideration | None | Chester Road North , Birmingham | Chester Road North , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5666061 | -1.879083 | |||
| 12989 | op-snap---monthly-publication-july-2025.pdf | 1041 | 2025-07 | Car | Toyota | Corolla | Silver | Driving without Reasonable Consideration | None | Walsall Road , Stone Cross | Walsall Road , Stone Cross | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.54591 | -1.9841049 | ||
| 12991 | op-snap---monthly-publication-july-2025.pdf | 1043 | 2025-07 | Car | Land Rover | Grey | Driving without Reasonable Consideration | None | Spring Lane South | Spring Lane South | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 12992 | op-snap---monthly-publication-july-2025.pdf | 1044 | 2025-07 | Car | Audi | A3 Sport | Grey | Driving without Reasonable Consideration | No Insurance | Hockett Street , Coventry | Hockett Street , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3981697 | -1.5050109 | ||
| 12993 | op-snap---monthly-publication-july-2025.pdf | 1045 | 2025-07 | Car | Ford | Escort | Grey | Driving without Reasonable Consideration | None | A38M towards Birmingham City Centr | A38M towards Birmingham City Centr | eBirmingham | Ebirmingham | NFA | Outside of 14 Days NIP | ||||
| 12995 | op-snap---monthly-publication-july-2025.pdf | 1047 | 2025-07 | Car | Ford | Focus | Blue | Driving without Reasonable Consideration | None | Bridge Street , Worcester | Bridge Street , Worcester | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 12996 | op-snap---monthly-publication-july-2025.pdf | 1048 | 2025-07 | Car | Volkswagen | White | Driving without Reasonable Consideration | None | Umberslade Road , Birmingham | Umberslade Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4304526 | -1.9216716 | |||
| 13009 | op-snap---monthly-publication-july-2025.pdf | 1061 | 2025-07 | Car | Vauxhall | Vivaro | White | Driving without Reasonable Consideration | None | Cakemore Road , Rowley regis | Cakemore Road , Rowley regis | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 13012 | op-snap---monthly-publication-july-2025.pdf | 1064 | 2025-07 | Car | Ford | Transit | White | Driving without Reasonable Consideration | None | Joseph Road , Churchbridge , Oldbur | Joseph Road , Churchbridge , Oldbur | ySandwell | Ysandwell | NFA | Outside of 14 Days NIP | ||||
| 13015 | op-snap---monthly-publication-july-2025.pdf | 1067 | 2025-07 | Pedal Bike | Ford | Independance | Blue | Driving without Reasonable Consideration | None | Friar Park Road , Wednesbury | Friar Park Road , Wednesbury | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5538676 | -1.9965667 | ||
| 13016 | op-snap---monthly-publication-july-2025.pdf | 1068 | 2025-07 | Car | Hyundai | Black | Driving without Reasonable Consideration | None | Meole Brace roundabout , Shrewsbur | Meole Brace roundabout , Shrewsbur | yOut of Force Area | Yout Of Force Area | NFA | Outside of 14 Days NIP | |||||
| 13027 | op-snap---monthly-publication-july-2025.pdf | 1079 | 2025-07 | Car | Tesla | White | Driving without Reasonable Consideration | None | A49 Junction with B5477 towards Chu | Junction with B5477 towards Chu | rOcuht Sotfr eFtotorcne Area | Rocuht Sotfr Eftotorcne Area | NFA | Outside of 14 Days NIP | |||||
| 13032 | op-snap---monthly-publication-july-2025.pdf | 1084 | 2025-07 | Car | Audi | A3 | Grey | Driving without Reasonable Consideration | None | Stecthford Lane , Birmingham | Stecthford Lane , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 13033 | op-snap---monthly-publication-july-2025.pdf | 1085 | 2025-07 | Car | Hyundai | Blue | Driving without Reasonable Consideration | None | Broadway North , Walsall | Broadway North , Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5886101 | -1.9749676 | |||
| 13034 | op-snap---monthly-publication-july-2025.pdf | 1086 | 2025-07 | Car | Mercedes-Benz | White | Driving without Reasonable Consideration | None | Sherbourne Street , Coventry | Sherbourne Street , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4080688 | -1.5236936 | |||
| 13045 | op-snap---monthly-publication-july-2025.pdf | 1097 | 2025-07 | Car | Land Rover | Evoque | White | Driving without Reasonable Consideration | None | Unknown - Country Lane, Coleshill | Unknown - Country Lane, Coleshill | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 13059 | op-snap---monthly-publication-july-2025.pdf | 1111 | 2025-07 | Car | BMW | White | Driving without Reasonable Consideration | Contravening a Red Traffic Li | gShhtaw Road , A463 | g Shhtaw Road , A463 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 13060 | op-snap---monthly-publication-july-2025.pdf | 1112 | 2025-07 | Car | Mercedes-Benz | Black | Driving without Reasonable Consideration | None | Bromford Lane , Stetchford | Bromford Lane , Stetchford | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 13062 | op-snap---monthly-publication-july-2025.pdf | 1114 | 2025-07 | Car | Volkswagen | White | Driving without Reasonable Consideration | None | M42 Southbound | M42 Southbound | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 13073 | op-snap---monthly-publication-july-2025.pdf | 1125 | 2025-07 | Car | Kia | Cee'd | Black | Driving without Reasonable Consideration | None | Fort Parkway | Fort Parkway | Birmingham | Birmingham | NFA | No Offence | 52.50787 | -1.8195713 | ||
| 13092 | op-snap---monthly-publication-july-2025.pdf | 1144 | 2025-07 | Car | Vauxhall | Black | Driving without Reasonable Consideration | None | Near Selly Oak , Birmingham | Near Selly Oak , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 13095 | op-snap---monthly-publication-july-2025.pdf | 1147 | 2025-07 | Pedestrian | Nissan | Black | Driving without Reasonable Consideration | None | The Parade , Boldmere | The Parade , Boldmere | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 13096 | op-snap---monthly-publication-july-2025.pdf | 1148 | 2025-07 | Car | Volkswagen | Polo | Black | Driving without Reasonable Consideration | None | SChool Road , Yardley Wood | SChool Road , Yardley Wood | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4161736 | -1.8619692 | ||
| 13097 | op-snap---monthly-publication-july-2025.pdf | 1149 | 2025-07 | Car | Ford | Focus | White | Driving without Reasonable Consideration | None | Junction of Upper Holland Road and L | Junction of Upper Holland Road and L | Sowutetor nQ Cueoeldnf iSeltdreet | Sowutetor Nq Cueoeldnf Iseltdreet | NFA | Outside of 14 Days NIP | ||||
| 13098 | op-snap---monthly-publication-july-2025.pdf | 1150 | 2025-07 | Car | Volkswagen | Black | Driving without Reasonable Consideration | None | Park way Ruberey | Park way Ruberey | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 13100 | op-snap---monthly-publication-july-2025.pdf | 1152 | 2025-07 | Bus | Ford | Tourneo | Silver | Driving without Reasonable Consideration | None | JUnction of Upper Holland Road and | JUnction of Upper Holland Road and | LSouwtetor nQ Cuoelednfi eSldtreet , Sutton Col | Lsouwtetor Nq Cuoelednfi Esldtreet , Sutton Col | NFA | Outside of 14 Days NIP | ||||
| 13101 | op-snap---monthly-publication-july-2025.pdf | 1153 | 2025-07 | Car | Hyundai | Kona | Red | Driving without Reasonable Consideration | None | A5 between Shrewsbury and Wellingt | A5 between Shrewsbury and Wellingt | oSnutton Coldfield | Osnutton Coldfield | NFA | Outside of 14 Days NIP | ||||
| 13125 | op-snap---monthly-publication-july-2025.pdf | 1177 | 2025-07 | Car | Van Red/White/ | Blue | Driving without Reasonable Consideration | None | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||||
| 13127 | op-snap---monthly-publication-july-2025.pdf | 1179 | 2025-07 | Pedal Bike | BMW | White | Driving without Reasonable Consideration | None | Junction of Colmore Crescent and Dy | Junction of Colmore Crescent and Dy | oBtti rRmoinagdh ,a Bmirmingham | Obtti Rrmoinagdh ,A Bmirmingham | NFA | Outside of 14 Days NIP | |||||
| 13129 | op-snap---monthly-publication-july-2025.pdf | 1181 | 2025-07 | Car | BMW | 1 Series | White | Driving without Reasonable Consideration | None | Junction 3 M5 Southbound heading to | Junction 3 M5 Southbound heading to | wOaurtd osf DFeovrcoen Area | Woaurtd Osf Dfeovrcoen Area | NFA | Outside of 14 Days NIP | ||||
| 13130 | op-snap---monthly-publication-july-2025.pdf | 1182 | 2025-07 | Pedal Bike | Toyota | Auris | Blue | Driving without Reasonable Consideration | None | Stockfield Road towards Warwick Roa | Stockfield Road towards Warwick Roa | Bdirmingham | Bdirmingham | NFA | Outside of 14 Days NIP |
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);