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'}
338 rows where council_area = "Solihull" and disposal = "NFA" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence 24
- Driving without Due Care and Attention 130
- Contravening a Red Traffic Light 44
- Misc - Non Traffic Offences 35
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 34
- Driving without Reasonable Consideration 31
- Cause vehicle to be left in a dangerous position 17
- Using a Mobile Phone Whilst Driving 16
- Cause unnecessary obstruction by motor vehicle 8
- Stop a vehicle on pedestrian crossing 3
- Dangerous Driving 2
- Drive a vehicle other than on the carriageway of a motorway 2
- Fail to display front VRM plate 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- VRM fails to conform to Regulations 2
- Contravene Lane Closure Red X 1
- Driving a vehicle wholly or partly on a footpath 1
- Duplicate Submission 1
- Fail to display rear VRM plate 1
- Keeping a vehicle with registration marks obscured 1
- Motor vehicle fail to comply with endorsable sect 1
- Motor vehicle fail to comply with solid white line 1
- Motor vehicle fail to comply with solid white line road markings 1
- Stop a vehicle within pelican pedestrian crossing limits 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
month 14
reporter_transport_mode 7
- Car 226
- Pedal Bike 50
- Pedestrian 48
- Other 10
- Motorbike 2
- Horse Rider 1
- Lorry 1
disposal 1
- NFA · 338 ✖
council_area 1
- Solihull · 338 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7254 | op-snap---monthly-publication-february-2026.pdf | 1 | 2026-02 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gresolde Road | Gresolde Road | Solihull | Solihull | NFA | Not in Public Interest | ||||
| 7401 | op-snap---monthly-publication-february-2026.pdf | 148 | 2026-02 | Pedal Bike | Audi | Q3 | Grey | Using a Mobile Phone Whilst Driving | None | Homer Road | Homer Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4103123 | -1.7790808 | ||
| 7452 | op-snap---monthly-publication-february-2026.pdf | 199 | 2026-02 | Car | Peugeot | Expert | White | Misc - Non Traffic Offences | None | Hertford Way / Balkwell Crescent | Hertford Way / Balkwell Crescent | Solihull | Solihull | NFA | Not in Public Interest | 52.3778812 | -1.7427424 | ||
| 7523 | op-snap---monthly-publication-february-2026.pdf | 270 | 2026-02 | Other | UK | Using a Mobile Phone Whilst Driving | None | UK | Uk | Solihull | Solihull | NFA | No Independent Evidence Available | 52.3864526 | -1.6495655 | ||||
| 7785 | op-snap---monthly-publication-february-2026.pdf | 532 | 2026-02 | Pedal Bike | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | High Street, Hampton in Arden | High Street, Hampton in Arden | Solihull | Solihull | NFA | No Offence | 52.4291828 | -1.7000245 | ||
| 7935 | op-snap---monthly-publication-february-2026.pdf | 682 | 2026-02 | Car | Mercedes-Benz | HGV | White | Driving without Due Care and Attention | None | M42 jct 7 - 7A | M42 jct 7 - 7A | Solihull | Solihull | NFA | Out of Force | ||||
| 8024 | op-snap---monthly-publication-february-2026.pdf | 771 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | School Road | School Road | Solihull | Solihull | NFA | No Offence | 52.3517888 | -1.7783232 | ||
| 8318 | op-snap---monthly-publication-february-2026.pdf | 1065 | 2026-02 | Pedal Bike | Fiat | 500 | White | Driving without Due Care and Attention | None | Meriden Road | Meriden Road | Solihull | Solihull | NFA | No Offence | 52.4137518 | -1.6414448 | ||
| 8383 | op-snap---monthly-publication-february-2026.pdf | 1130 | 2026-02 | Pedal Bike | Volkswagen | Beetle | Black | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | NFA | No Offence | 52.4223176 | -1.8253145 | ||
| 8426 | op-snap---monthly-publication-february-2026.pdf | 1173 | 2026-02 | Car | Peugeot | 3008 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 8427 | op-snap---monthly-publication-february-2026.pdf | 1174 | 2026-02 | Car | Peugeot | Expert | White | Misc - Non Traffic Offences | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 8428 | op-snap---monthly-publication-february-2026.pdf | 1175 | 2026-02 | Car | Ford | Transit | White | Misc - Non Traffic Offences | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 8456 | op-snap---monthly-publication-february-2026.pdf | 1203 | 2026-02 | Car | Porsche | Cayenne | White | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Solihull | Solihull | NFA | No Offence | 52.4322443 | -1.6746508 | ||
| 8521 | op-snap---monthly-publication-february-2026.pdf | 1268 | 2026-02 | Pedal Bike | Mercedes-Benz | Smart Fortwo | Blue | Driving without Due Care and Attention | None | Streetbrook Road | Streetbrook Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 8657 | op-snap---monthly-publication-february-2026.pdf | 1404 | 2026-02 | Car | Mercedes-Benz | Black | Driving without Due Care and Attention | None | M42 SB J6 | M42 Southbound J6 | Solihull | Solihull | NFA | No VRM | |||||
| 8713 | op-snap---monthly-publication-february-2026.pdf | 1460 | 2026-02 | Pedestrian | BMW | 320d | White | Misc - Non Traffic Offences | None | homer street | Homer Street | Solihull | Solihull | NFA | Misc Inc Crimes | ||||
| 8820 | op-snap---monthly-publication-february-2026.pdf | 1567 | 2026-02 | Car | Toyota | Hilux | Silver | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4191184 | -1.8326637 | ||
| 10546 | op-snap---monthly-publication-january-2026.pdf | 7 | 2026-01 | Car | Mitsubishi | Eclipse | Black | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No Offence | 52.4191184 | -1.8326637 | ||
| 10559 | op-snap---monthly-publication-january-2026.pdf | 20 | 2026-01 | Car | Land Rover | Range | White | Contravening a Red Traffic Light | None | Marshall Lake Road | Marshall Lake Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.3975426 | -1.818252 | ||
| 10645 | op-snap---monthly-publication-january-2026.pdf | 106 | 2026-01 | Car | Honda | Blue | Driving without Due Care and Attention | None | New Road | New Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4119526 | -1.773235 | |||
| 10839 | op-snap---monthly-publication-january-2026.pdf | 300 | 2026-01 | Car | Unknown Tipper wagon | White | Driving without Due Care and Attention | None | M42 NB Jct 5a | M42 Northbound Junction 5a | Solihull | Solihull | NFA | No Independent Evidence Available | |||||
| 10927 | op-snap---monthly-publication-january-2026.pdf | 388 | 2026-01 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Solihull | Solihull | NFA | No Offence | 52.4505232 | -1.7606378 | ||
| 11084 | op-snap---monthly-publication-january-2026.pdf | 545 | 2026-01 | Car | Land Rover | Range | White | Drive a vehicle other than on the carriageway of a motorway | None | M42 | M42 | Solihull | Solihull | NFA | No Independent Evidence Available | ||||
| 11196 | op-snap---monthly-publication-january-2026.pdf | 657 | 2026-01 | Car | Land Rover | Evoque | Brown | Driving without Due Care and Attention | None | Lode Lane | Lode Lane | Solihull | Solihull | NFA | No Offence | 52.4149064 | -1.7832364 | ||
| 11490 | op-snap---monthly-publication-january-2026.pdf | 951 | 2026-01 | Car | Daf | truck | White | Driving without Due Care and Attention | None | M42 J6 | M42 J6 | Solihull | Solihull | NFA | No Offence | ||||
| 11529 | op-snap---monthly-publication-january-2026.pdf | 990 | 2026-01 | Car | Kia | Sportage | Blue | Driving without Due Care and Attention | None | Solihull Bypass | Solihull Bypass | Solihull | Solihull | NFA | No Offence | 52.4207529 | -1.7757467 | ||
| 11577 | op-snap---monthly-publication-january-2026.pdf | 1038 | 2026-01 | Car | BMW | 1 SERIS | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No VRM | 52.4191184 | -1.8326637 | ||
| 11598 | op-snap---monthly-publication-january-2026.pdf | 1059 | 2026-01 | Car | BMW | M3 | Blue | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4191184 | -1.8326637 | ||
| 11839 | op-snap---monthly-publication-january-2026.pdf | 1300 | 2026-01 | Car | Vauxhall | Astra | Black | Using a Mobile Phone Whilst Driving | No vehicle excise licence | M42 | M42 | Solihull | Solihull | NFA | No Offence | ||||
| 3887 | op-snap---monthly-publication-december-2025.pdf | 15 | 2025-12 | Car | Tesla | model Y | White | Contravening a Red Traffic Light | None | Monkspath Interchange | Monkspath Interchange | Solihull | Solihull | NFA | No Independent Evidence Available | 52.3792737 | -1.7869373 | ||
| 3889 | op-snap---monthly-publication-december-2025.pdf | 17 | 2025-12 | Car | Renault | Scenic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barton Drive | Barton Drive | Solihull | Solihull | NFA | No Offence | 52.3770722 | -1.7420909 | ||
| 4019 | op-snap---monthly-publication-december-2025.pdf | 147 | 2025-12 | Car | HGV | Red | Driving without Due Care and Attention | None | M42 Westbound | M42 Westbound | Solihull | Solihull | NFA | No VRM | |||||
| 4166 | op-snap---monthly-publication-december-2025.pdf | 294 | 2025-12 | Car | Seat | Ibiza | Blue | Using a Mobile Phone Whilst Driving | None | A45 B'ham airport | A45 B'ham airport | Solihull | Solihull | NFA | No Independent Evidence Available | ||||
| 4286 | op-snap---monthly-publication-december-2025.pdf | 414 | 2025-12 | Car | NP | White | Driving without Due Care and Attention | None | M42 | M42 | Solihull | Solihull | NFA | No VRM | |||||
| 4388 | op-snap---monthly-publication-december-2025.pdf | 516 | 2025-12 | Pedal Bike | Nissan | Juke | Black | Driving without Due Care and Attention | None | Corners End Lane | Corners End Lane | Solihull | Solihull | NFA | No Offence | ||||
| 4408 | op-snap---monthly-publication-december-2025.pdf | 536 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Brook Lane | Brook Lane | Solihull | Solihull | NFA | No Offence | 52.4328972 | -1.8147602 | ||
| 4533 | op-snap---monthly-publication-december-2025.pdf | 661 | 2025-12 | Pedal Bike | Toyota | Yaris | Grey | Driving without Due Care and Attention | None | Hampton Lane | Hampton Lane | Solihull | Solihull | NFA | No Offence | 52.4190728 | -1.7449943 | ||
| 4549 | op-snap---monthly-publication-december-2025.pdf | 677 | 2025-12 | Car | Nissan | Cube | White | Contravening a Red Traffic Light | None | Longmore Road Shirley | Longmore Road Shirley | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4044532 | -1.8136222 | ||
| 4606 | op-snap---monthly-publication-december-2025.pdf | 734 | 2025-12 | Car | Audi | SQ7 | Blue | Contravening a Red Traffic Light | None | A3400 Stratford Road | Stratford Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4191184 | -1.8326637 | ||
| 4802 | op-snap---monthly-publication-december-2025.pdf | 930 | 2025-12 | Car | Nissan | Pulsar | Blue | Driving without Due Care and Attention | None | Darley Green Road | Darley Green Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.3639234 | -1.7399953 | ||
| 5001 | op-snap---monthly-publication-december-2025.pdf | 1129 | 2025-12 | Car | Peugeot | Black | Using a Mobile Phone Whilst Driving | None | Lord Lane | Lord Lane | Solihull | Solihull | NFA | No Independent Evidence Available | |||||
| 5021 | op-snap---monthly-publication-december-2025.pdf | 1149 | 2025-12 | Pedestrian | Honda | crv | Blue | Misc - Non Traffic Offences | None | rowood drive | Rowood Drive | Solihull | Solihull | NFA | Misc Inc Crimes | 52.4285752 | -1.7757399 | ||
| 5028 | op-snap---monthly-publication-december-2025.pdf | 1156 | 2025-12 | Car | Mercedes-Benz | na | Black | Misc - Non Traffic Offences | None | blosomfield road | Blosomfield Road | Solihull | Solihull | NFA | No VRM | ||||
| 20507 | op-snap---monthly-publication-november-2025.pdf | 49 | 2025-11 | Car | Renault | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Independent Evidence Available | 52.3778812 | -1.7427424 | |||
| 20508 | op-snap---monthly-publication-november-2025.pdf | 50 | 2025-11 | Car | Renault | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | |||
| 20550 | op-snap---monthly-publication-november-2025.pdf | 92 | 2025-11 | Car | Renault | Scenic | Blue | Cause vehicle to be left in a dangerous position | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 20568 | op-snap---monthly-publication-november-2025.pdf | 110 | 2025-11 | Car | Volvo | V90 | Silver | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Solihull | Solihull | NFA | Not in Public Interest | 52.4428606 | -1.812114 | ||
| 20578 | op-snap---monthly-publication-november-2025.pdf | 120 | 2025-11 | Car | Misc - Non Traffic Offences | None | Warwick Road | Warwick Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4428606 | -1.812114 | |||||
| 20615 | op-snap---monthly-publication-november-2025.pdf | 157 | 2025-11 | Car | Renault | Scenic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Road | Hertford Road | Solihull | Solihull | NFA | Not in Public Interest | ||||
| 20722 | op-snap---monthly-publication-november-2025.pdf | 264 | 2025-11 | Pedal Bike | Mg | HS | Red | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4322443 | -1.6746508 | ||
| 20749 | op-snap---monthly-publication-november-2025.pdf | 291 | 2025-11 | Car | Mg | Black | Driving without Due Care and Attention | None | Bickenhill Lane | Bickenhill Lane | Solihull | Solihull | NFA | No Offence | 52.4490463 | -1.7296897 | |||
| 20774 | op-snap---monthly-publication-november-2025.pdf | 316 | 2025-11 | Car | Audi | A3 | Blue | Driving without Due Care and Attention | None | Lode Lane, | Lode Lane | Solihull | Solihull | NFA | No Offence | 52.4149064 | -1.7832364 | ||
| 21000 | op-snap---monthly-publication-november-2025.pdf | 542 | 2025-11 | Car | Renault | gscenic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | hertford way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 21005 | op-snap---monthly-publication-november-2025.pdf | 547 | 2025-11 | Car | Renault | Scenic | Blue | Misc - Non Traffic Offences | Use vehicle on a road without valid test certificate | Balkwill Crescent | Balkwill Crescent | Solihull | Solihull | NFA | No offence | 52.3786268 | -1.7420081 | ||
| 21007 | op-snap---monthly-publication-november-2025.pdf | 549 | 2025-11 | Car | Toyota | Estima | White | Misc - Non Traffic Offences | None | Balkwill Crescent | Balkwill Crescent | Solihull | Solihull | NFA | No offence | 52.3786268 | -1.7420081 | ||
| 21204 | op-snap---monthly-publication-november-2025.pdf | 746 | 2025-11 | Pedestrian | Mercedes-Benz | C180 | Black | Fail to display front VRM plate | None | Greswold Road | Greswold Road | Solihull | Solihull | NFA | Not in Public Interest | 52.4232089 | -1.7804289 | ||
| 21212 | op-snap---monthly-publication-november-2025.pdf | 754 | 2025-11 | Car | Ford | Transit | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bryanston Road | Bryanston Road | Solihull | Solihull | NFA | Not in Public Interest | 52.4251326 | -1.8006633 | ||
| 21243 | op-snap---monthly-publication-november-2025.pdf | 785 | 2025-11 | Car | BMW | 520D | Grey | Misc - Non Traffic Offences | None | windwatd way | Windwatd Way | Solihull | Solihull | NFA | Misc Inc Crimes | ||||
| 21341 | op-snap---monthly-publication-november-2025.pdf | 883 | 2025-11 | Other | Renault | scenic | Black | Misc - Non Traffic Offences | None | hertford way | Hertford Way | Solihull | Solihull | NFA | Misc Inc Crimes | 52.3778812 | -1.7427424 | ||
| 21391 | op-snap---monthly-publication-november-2025.pdf | 933 | 2025-11 | Car | Yamaha | motorbike | Green | Driving without Due Care and Attention | None | DDamson Parkway | DDamson Parkway | Solihull | Solihull | NFA | No VRM | ||||
| 21452 | op-snap---monthly-publication-november-2025.pdf | 994 | 2025-11 | Car | Renault | Scenic | blue | Misc - Non Traffic Offences | None | Barton Drive | Barton Drive | Solihull | Solihull | NFA | No Offence | 52.3770722 | -1.7420909 | ||
| 21572 | op-snap---monthly-publication-november-2025.pdf | 1114 | 2025-11 | Car | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Stratford Road, Shirley | Stratford Road, Shirley | Solihull | Solihull | NFA | No Offence | 52.4191731 | -1.8324357 | ||
| 21612 | op-snap---monthly-publication-november-2025.pdf | 1154 | 2025-11 | Car | HGV | White | Driving without Due Care and Attention | None | M42 | M42 | Solihull | Solihull | NFA | No VRM | |||||
| 21682 | op-snap---monthly-publication-november-2025.pdf | 1224 | 2025-11 | Car | Hyundai | Tucson | Blue | Driving without Due Care and Attention | None | New Road | New Road | Solihull | Solihull | NFA | No Offence | 52.4119526 | -1.773235 | ||
| 21691 | op-snap---monthly-publication-november-2025.pdf | 1233 | 2025-11 | Other | Audi | A1 | Silver | Misc - Non Traffic Offences | None | solihull | Solihull | Solihull | Solihull | NFA | Misc Inc Crimes | 52.4130189 | -1.7768935 | ||
| 21804 | op-snap---monthly-publication-november-2025.pdf | 1346 | 2025-11 | Other | Misc - Non Traffic Offences | None | wharf lane | Wharf Lane | Solihull | Solihull | NFA | Misc Inc Crimes | 52.4253754 | -1.7728933 | |||||
| 21811 | op-snap---monthly-publication-november-2025.pdf | 1353 | 2025-11 | Car | Volkswagen | Golf | Silver | Contravening a Red Traffic Light | None | Barn Lane | Barn Lane | Solihull | Solihull | NFA | No Independent Evidence Available | 52.449441 | -1.8026941 | ||
| 22190 | op-snap---monthly-publication-october-2025.pdf | 140 | 2025-10 | Pedal Bike | Mercedes-Benz | White | Driving without Reasonable Consideration | None | Cornets End Lane | Cornets End Lane | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4269547 | -1.6668911 | |||
| 22195 | op-snap---monthly-publication-october-2025.pdf | 145 | 2025-10 | Pedal Bike | Dennis | Alexander | White | Driving without Due Care and Attention | None | Sharmans Cross | Sharmans Cross | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4151594 | -1.8062462 | ||
| 22196 | op-snap---monthly-publication-october-2025.pdf | 146 | 2025-10 | Pedal Bike | Renault | Modus | Silver | Driving without Due Care and Attention | None | Stroud Road | Stroud Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4085712 | -1.8432138 | ||
| 22267 | op-snap---monthly-publication-october-2025.pdf | 217 | 2025-10 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | M42 Motorway northbound 5-6 | M42 Motorway northbound 5-6 | Solihull | Solihull | NFA | No VRM | ||||
| 22336 | op-snap---monthly-publication-october-2025.pdf | 286 | 2025-10 | Pedal Bike | Bus | White | Driving without Due Care and Attention | None | Blossomfield Road | Blossomfield Road | Solihull | Solihull | NFA | No Offence | 52.4144779 | -1.7848758 | |||
| 22430 | op-snap---monthly-publication-october-2025.pdf | 380 | 2025-10 | Pedal Bike | Audi | Q2 | Grey | Driving without Due Care and Attention | None | Wychwood Avenue | Wychwood Avenue | Solihull | Solihull | NFA | No Independent Evidence Available | 52.3973125 | -1.7370127 | ||
| 22440 | op-snap---monthly-publication-october-2025.pdf | 390 | 2025-10 | Car | Audi | A5 | Black | Driving without Due Care and Attention | None | Coleshill Heath Road | Coleshill Heath Road | Solihull | Solihull | NFA | No Offence | 52.4667242 | -1.7283592 | ||
| 22547 | op-snap---monthly-publication-october-2025.pdf | 497 | 2025-10 | Car | Tesla | Model 3 | Black | Contravening a Red Traffic Light | None | Lode Lane | Lode Lane | Solihull | Solihull | NFA | No Offence | 52.4149064 | -1.7832364 | ||
| 22576 | op-snap---monthly-publication-october-2025.pdf | 526 | 2025-10 | Car | Volvo | XC40 | Grey | Driving without Due Care and Attention | None | Jn6 M42 | Jn6 M42 | Solihull | Solihull | NFA | No VRM | ||||
| 22626 | op-snap---monthly-publication-october-2025.pdf | 576 | 2025-10 | Car | Ford | C-Max | Red | Driving without Due Care and Attention | None | M42 4-3a | M42 4-3a | Solihull | Solihull | NFA | No Offence | 52.3757082 | -1.7893409 | ||
| 22752 | op-snap---monthly-publication-october-2025.pdf | 702 | 2025-10 | Pedestrian | Ford | Kuga | White | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Longmore Road, Shirley | Longmore Road, Shirley | Solihull | Solihull | NFA | No Offence | 52.4078616 | -1.8211577 | ||
| 22785 | op-snap---monthly-publication-october-2025.pdf | 735 | 2025-10 | Car | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No VRM | 52.4191184 | -1.8326637 | |||||
| 22804 | op-snap---monthly-publication-october-2025.pdf | 754 | 2025-10 | Car | Kia | Sportage | Grey | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4428606 | -1.812114 | ||
| 22895 | op-snap---monthly-publication-october-2025.pdf | 845 | 2025-10 | Car | Audi | RS3 | Grey | Driving without Due Care and Attention | None | Lawnswood Avenue | Lawnswood Avenue | Solihull | Solihull | NFA | No Offence | 52.4102564 | -1.815224 | ||
| 22899 | op-snap---monthly-publication-october-2025.pdf | 849 | 2025-10 | Car | BMW | Black | Motor vehicle fail to comply with solid white line road markings | None | London Road | London Road | Solihull | Solihull | NFA | No VRM | |||||
| 22962 | op-snap---monthly-publication-october-2025.pdf | 912 | 2025-10 | Car | Volkswagen | T-roc | Grey | Using a Mobile Phone Whilst Driving | None | Ulleries Road | Ulleries Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4441219 | -1.7926173 | ||
| 22989 | op-snap---monthly-publication-october-2025.pdf | 939 | 2025-10 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4223176 | -1.8253145 | ||
| 23009 | op-snap---monthly-publication-october-2025.pdf | 959 | 2025-10 | Pedestrian | Renault | Scenic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | Not in Public Interest | 52.3778812 | -1.7427424 | ||
| 23027 | op-snap---monthly-publication-october-2025.pdf | 977 | 2025-10 | Car | Renault | Scenic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 23028 | op-snap---monthly-publication-october-2025.pdf | 978 | 2025-10 | Car | Ford | Fiesta | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 23030 | op-snap---monthly-publication-october-2025.pdf | 980 | 2025-10 | Pedal Bike | Porsche | Macan | Grey | Driving without Due Care and Attention | None | Fridal lane | Fridal lane | Solihull | Solihull | NFA | No Offence | ||||
| 23086 | op-snap---monthly-publication-october-2025.pdf | 1036 | 2025-10 | Car | Volkswagen | Transporter | Red | Driving without Due Care and Attention | None | Longmore Road | Longmore Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4078616 | -1.8211577 | ||
| 23780 | op-snap---monthly-publication-october-2025.pdf | 1730 | 2025-10 | Car | Mercedes-Benz | A 180 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Daylesford Rd | Daylesford Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4479743 | -1.7897267 | ||
| 23797 | op-snap---monthly-publication-september-2025.pdf | 16 | 2025-09 | Car | Ford | Focus | Blue | Driving without Due Care and Attention | None | Lugtrout Lane | Lugtrout Lane | Solihull | Solihull | NFA | Outside of 14 DAYS Late Submission | 52.4227108 | -1.7443257 | ||
| 23798 | op-snap---monthly-publication-september-2025.pdf | 17 | 2025-09 | Car | BMW | 3 | Blue | Driving without Due Care and Attention | None | Lugtrout Lane | Lugtrout Lane | Solihull | Solihull | NFA | Outside of 14 DAYS Late Submission | 52.4227108 | -1.7443257 | ||
| 23838 | op-snap---monthly-publication-september-2025.pdf | 57 | 2025-09 | Car | Volvo | HGV | Red | Driving without Due Care and Attention | None | M42? | M42? | Solihull | Solihull | NFA | Outside of 14 DAYS Late Submission | 52.3757082 | -1.7893409 | ||
| 23845 | op-snap---monthly-publication-september-2025.pdf | 64 | 2025-09 | Car | Renault | Blue | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Balkwill Crescent | Balkwill Crescent | Solihull | Solihull | NFA | No Offence | 52.3786268 | -1.7420081 | |||
| 23879 | op-snap---monthly-publication-september-2025.pdf | 98 | 2025-09 | Car | Renault | Scenic | Blue | Misc - Non Traffic Offences | None | Hertford Way . Balkwill Crescent | Hertford Way . Balkwill Crescent | Solihull | Solihull | NFA | No Offence | ||||
| 23884 | op-snap---monthly-publication-september-2025.pdf | 103 | 2025-09 | Car | Polestar | Black | Driving without Reasonable Consideration | None | Bickenhill Lane | Bickenhill Lane | Solihull | Solihull | NFA | No Offence | 52.4490463 | -1.7296897 | |||
| 23895 | op-snap---monthly-publication-september-2025.pdf | 114 | 2025-09 | Car | Daf | Lorry | Red | Driving without Due Care and Attention | None | M42 | M42 | Solihull | Solihull | NFA | No Independent Evidence Available | ||||
| 24020 | op-snap---monthly-publication-september-2025.pdf | 239 | 2025-09 | Pedal Bike | Honda | Civic | Black | Driving without Due Care and Attention | None | Sampson Road | Sampson Road | Solihull | Solihull | NFA | No Offence | ||||
| 24068 | op-snap---monthly-publication-september-2025.pdf | 287 | 2025-09 | Car | Mini | One | Blue | Driving without Due Care and Attention | None | Barn Lane | Barn Lane | Solihull | Solihull | NFA | No Offence | 52.449441 | -1.8026941 | ||
| 24237 | op-snap---monthly-publication-september-2025.pdf | 456 | 2025-09 | Car | Daf | HGV | White | Motor vehicle fail to comply with endorsable sect | ion 36 traffic sign -otheNr othnaen manned or automatic | Meq4u2ip ment | Meq4u2ip ment | Solihull | Solihull | NFA | Not in Public Interest |
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);