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'}
226 rows where council_area = "Solihull", disposal = "NFA" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence 21
- Driving without Due Care and Attention 88
- Contravening a Red Traffic Light 42
- Misc - Non Traffic Offences 22
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 21
- Driving without Reasonable Consideration 15
- Using a Mobile Phone Whilst Driving 10
- Cause vehicle to be left in a dangerous position 8
- Cause unnecessary obstruction by motor vehicle 3
- Dangerous Driving 2
- Drive a vehicle other than on the carriageway of a motorway 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
- Duplicate Submission 1
- Fail to display front VRM plate 1
- Fail to display rear VRM plate 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 1
- Car · 226 ✖
disposal 1
- NFA · 226 ✖
council_area 1
- Solihull · 226 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||||
| 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 | |||||
| 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 | ||
| 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 | |||||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 24313 | op-snap---monthly-publication-september-2025.pdf | 532 | 2025-09 | Car | Land Rover | Discovery | Grey | Contravening a Red Traffic Light | None | A35 | A35 | Solihull | Solihull | NFA | No Offence | ||||
| 24394 | op-snap---monthly-publication-september-2025.pdf | 613 | 2025-09 | Car | Mercedes-Benz | CLA | Black | Driving without Due Care and Attention | None | o/s Tidbury Green Primary School | o/s Tidbury Green Primary School | Solihull | Solihull | NFA | No Offence | ||||
| 24442 | op-snap---monthly-publication-september-2025.pdf | 661 | 2025-09 | Car | Renault | Scenic | Blue | Driving without Due Care and Attention | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 24689 | op-snap---monthly-publication-september-2025.pdf | 908 | 2025-09 | Car | Ford | Transit | Blue | Driving without Due Care and Attention | None | Stratford Road Shirley | Stratford Road Shirley | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4171404 | -1.830877 | ||
| 24778 | op-snap---monthly-publication-september-2025.pdf | 997 | 2025-09 | Car | Audi | S5 | Blue | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | NFA | Outside of 14 DAYS Late Submission | 52.4223176 | -1.8253145 | ||
| 24781 | op-snap---monthly-publication-september-2025.pdf | 1000 | 2025-09 | Car | Toyota | Prius | Silver | Motor vehicle fail to comply with solid white line | road markings None | A4141 | A4141 | Solihull | Solihull | NFA | No VRM | ||||
| 25070 | op-snap---monthly-publication-september-2025.pdf | 1289 | 2025-09 | Car | Porsche | panerma | Black | Misc - Non Traffic Offences | None | Lady Byron Lane | Lady Byron Lane | Solihull | Solihull | NFA | Misc Inc Crimes | 52.4026126 | -1.7503668 | ||
| 25189 | op-snap---monthly-publication-september-2025.pdf | 1408 | 2025-09 | Car | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Highwood Avenue | Highwood Avenue | Solihull | Solihull | NFA | No VRM | 52.434852 | -1.7860069 | |||||
| 25259 | op-snap---monthly-publication-september-2025.pdf | 1478 | 2025-09 | Car | Volkswagen | golf | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Redlands Road | Redlands Road | Solihull | Solihull | NFA | Misc Inc Crimes | 52.421415 | -1.7726632 | ||
| 2121 | op-snap---monthly-publication-august-2025.pdf | 96 | 2025-08 | Car | Ford | Transit | Black | Driving without Due Care and Attention | None | Illshaw Heath Road | Illshaw Heath Road | Solihull | Solihull | NFA | No Offence | 52.3735755 | -1.8129528 | ||
| 2124 | op-snap---monthly-publication-august-2025.pdf | 99 | 2025-08 | Car | Mercedes-Benz | White | Driving without Due Care and Attention | None | Horseshoes Lane | Horseshoes Lane | Solihull | Solihull | NFA | No VRM | |||||
| 2142 | op-snap---monthly-publication-august-2025.pdf | 117 | 2025-08 | Car | Audi | Q5 | Grey | Driving without Due Care and Attention | None | Shutt Lane | Shutt Lane | Solihull | Solihull | NFA | No Offence | 52.367795 | -1.8250635 | ||
| 2330 | op-snap---monthly-publication-august-2025.pdf | 305 | 2025-08 | Car | Vauxhall | Corsa | Red | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4191184 | -1.8326637 | ||
| 2399 | op-snap---monthly-publication-august-2025.pdf | 374 | 2025-08 | Car | Volkswagen | Tiguan | White | Contravening a Red Traffic Light | None | Blackford Road | Blackford Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.3971653 | -1.8189489 | ||
| 2430 | op-snap---monthly-publication-august-2025.pdf | 405 | 2025-08 | Car | Ford | Escort | White | Driving without Due Care and Attention | None | Barn Lane | Barn Lane | Solihull | Solihull | NFA | No VRM | 52.449441 | -1.8026941 | ||
| 2536 | op-snap---monthly-publication-august-2025.pdf | 511 | 2025-08 | Car | Renault | Gscenic | Blue | Cause vehicle to be left in a dangerous position | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 2537 | op-snap---monthly-publication-august-2025.pdf | 512 | 2025-08 | Car | Toyota | 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 | |||
| 2551 | op-snap---monthly-publication-august-2025.pdf | 526 | 2025-08 | Car | Lorry | White | Driving without Due Care and Attention | None | M42 | M42 | Solihull | Solihull | NFA | Not in Public Interest | |||||
| 2626 | op-snap---monthly-publication-august-2025.pdf | 601 | 2025-08 | Car | Fiat | 500 | Black | Driving without Due Care and Attention | None | Startford rd | Startford rd | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 2920 | op-snap---monthly-publication-august-2025.pdf | 895 | 2025-08 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Portway Island | Portway Island | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 2971 | op-snap---monthly-publication-august-2025.pdf | 946 | 2025-08 | Car | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | No Insurance | Sheaf Lane | Sheaf Lane | Solihull | Solihull | NFA | Not in Public Interest | ||||
| 3019 | op-snap---monthly-publication-august-2025.pdf | 994 | 2025-08 | Car | Seat | Leon | 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 | ||
| 3098 | op-snap---monthly-publication-august-2025.pdf | 1073 | 2025-08 | Car | Renault | Kajar | Red | Contravening a Red Traffic Light | None | Blossomfield Road | Blossomfield Road | Solihull | Solihull | NFA | No Offence | 52.4144779 | -1.7848758 | ||
| 3100 | op-snap---monthly-publication-august-2025.pdf | 1075 | 2025-08 | Car | Renault | Scenic | Blue | Misc - Non Traffic Offences | None | Hertford Way . Balkwill Crescent | Hertford Way . Balkwill Crescent | Solihull | Solihull | NFA | No Offence | ||||
| 3102 | op-snap---monthly-publication-august-2025.pdf | 1077 | 2025-08 | Car | Seat | Leon | Silver | Misc - Non Traffic Offences | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 |
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);