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'}
116 rows where council_area = "Solihull" and month = "2025-06" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 24
offence 17
- Driving without Due Care and Attention 45
- Contravening a Red Traffic Light 18
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 12
- Misc - Non Traffic Offences 8
- Cause vehicle to be left in a dangerous position 7
- Using a Mobile Phone Whilst Driving 7
- Driving without Reasonable Consideration 6
- Stop a vehicle within pelican pedestrian crossing limits 3
- Motor vehicle fail to accord precedence at a pelican crossing 2
- Dangerous Driving 1
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Drive a vehicle other than on the carriageway of a motorway 1
- Fail to display front VRM plate 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- Stop a vehicle on pedestrian crossing 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- VRM fails to conform to Regulations 1
disposal 6
- NFA 45
- Warning Letter 29
- Education 23
- Fixed Penalty 13
- Court 5
- RTC - Actioned 1
reporter_transport_mode 5
- Car 75
- Pedestrian 20
- Pedal Bike 18
- Lorry 2
- Other 1
month 1
- 2025-06 · 116 ✖
council_area 1
- Solihull · 116 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14077 | op-snap---monthly-publication-june-2025.pdf | 6 | 2025-06 | Car | Vauxhall | Corsa | White | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4428606 | -1.812114 | ||
| 14084 | op-snap---monthly-publication-june-2025.pdf | 13 | 2025-06 | Pedal Bike | Audi | Q5 | Silver | Driving without Reasonable Consideration | None | GRANGE ROAD | Grange Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4285724 | -1.8019101 | ||
| 14093 | op-snap---monthly-publication-june-2025.pdf | 22 | 2025-06 | Car | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Shadowbrook lane | Shadowbrook lane | Solihull | Solihull | RTC - Actioned | N/A | 52.4306532 | -1.723655 | ||
| 14115 | op-snap---monthly-publication-june-2025.pdf | 44 | 2025-06 | Car | Audi | A3 | Blue | Contravening a Red Traffic Light | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4223176 | -1.8253145 | ||
| 14138 | op-snap---monthly-publication-june-2025.pdf | 67 | 2025-06 | Lorry | Jaguar | XF | Blue | Driving without Due Care and Attention | None | Bickenhill Interchange | Bickenhill Interchange | Solihull | Solihull | Education | N/A | 52.4457674 | -1.7082354 | ||
| 14144 | op-snap---monthly-publication-june-2025.pdf | 73 | 2025-06 | Car | BMW | 320i | Blue | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Solihull | Solihull | Education | N/A | 52.4428606 | -1.812114 | ||
| 14179 | op-snap---monthly-publication-june-2025.pdf | 108 | 2025-06 | Pedal Bike | BMW | X5 | Silver | Driving without Due Care and Attention | None | Danford Lane | Danford Lane | Solihull | Solihull | Education | N/A | 52.4092804 | -1.8056214 | ||
| 14203 | op-snap---monthly-publication-june-2025.pdf | 132 | 2025-06 | Car | BMW | 440i | Blue | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Solihull | Solihull | Warning Letter | N/A | 52.4428606 | -1.812114 | ||
| 14246 | op-snap---monthly-publication-june-2025.pdf | 175 | 2025-06 | Car | Daf | HGV | Yellow | Driving without Reasonable Consideration | None | M42 | M42 | Solihull | Solihull | NFA | No Independent Evidence Available | ||||
| 14279 | op-snap---monthly-publication-june-2025.pdf | 208 | 2025-06 | Car | Audi | S3 | Grey | Driving without Due Care and Attention | None | Richmond Road | Richmond Road | Solihull | Solihull | Court | N/A | 52.4430188 | -1.8022218 | ||
| 14286 | op-snap---monthly-publication-june-2025.pdf | 215 | 2025-06 | Pedal Bike | Volkswagen | Sharan | Silver | Driving without Due Care and Attention | None | Old Dickens Heath Road | Old Dickens Heath Road | Solihull | Solihull | Warning Letter | N/A | 52.3864791 | -1.8355922 | ||
| 14325 | op-snap---monthly-publication-june-2025.pdf | 254 | 2025-06 | Car | Honda | Civic | Blue | Driving without Due Care and Attention | None | Dingle Lane | Dingle Lane | Solihull | Solihull | Warning Letter | N/A | 52.4044204 | -1.7965379 | ||
| 14326 | op-snap---monthly-publication-june-2025.pdf | 255 | 2025-06 | Car | Ford | Fiesta | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Widney Lane | Widney Lane | Solihull | Solihull | Warning Letter | N/A | 52.3975737 | -1.7857722 | ||
| 14334 | op-snap---monthly-publication-june-2025.pdf | 263 | 2025-06 | Car | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Warning Letter | N/A | 52.4191184 | -1.8326637 | ||
| 14362 | op-snap---monthly-publication-june-2025.pdf | 291 | 2025-06 | Car | Mini | Cooper | Red | Driving without Reasonable Consideration | None | Stratford Road | Stratford Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4191184 | -1.8326637 | ||
| 14412 | op-snap---monthly-publication-june-2025.pdf | 341 | 2025-06 | Car | BMW | 218I | Black | Driving without Due Care and Attention | None | Olton Road | Olton Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4193964 | -1.8252207 | ||
| 14422 | op-snap---monthly-publication-june-2025.pdf | 351 | 2025-06 | Car | Vauxhall | Astra | Black | Using a Mobile Phone Whilst Driving | None | M42 North | M42 North | Solihull | Solihull | Court | N/A | 52.4734164 | -1.711338 | ||
| 14437 | op-snap---monthly-publication-june-2025.pdf | 366 | 2025-06 | Pedestrian | Kia | Ceed | White | Driving without Due Care and Attention | None | Sharmans Cross Road | Sharmans Cross Road | Solihull | Solihull | NFA | Outside of 14 DAYS Late Submission | 52.4167172 | -1.7990388 | ||
| 14453 | op-snap---monthly-publication-june-2025.pdf | 382 | 2025-06 | Car | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | A4141 | A4141 | Solihull | Solihull | NFA | No VRM | ||||
| 14454 | op-snap---monthly-publication-june-2025.pdf | 383 | 2025-06 | Car | BMW | 1 Series | Black | Driving without Due Care and Attention | None | A4141 | A4141 | Solihull | Solihull | Education | N/A | ||||
| 14460 | op-snap---monthly-publication-june-2025.pdf | 389 | 2025-06 | Car | Nissan | Juke | Black | Using a Mobile Phone Whilst Driving | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 14464 | op-snap---monthly-publication-june-2025.pdf | 393 | 2025-06 | Car | Land Rover | Range Rover | Grey | Driving without Due Care and Attention | None | Stratford Road Shirley | Stratford Road Shirley | Solihull | Solihull | Fixed Penalty | N/A | 52.4171404 | -1.830877 | ||
| 14465 | op-snap---monthly-publication-june-2025.pdf | 394 | 2025-06 | Pedal Bike | BMW | 340I | Black | Driving without Due Care and Attention | None | Blossomfield Road | Blossomfield Road | Solihull | Solihull | Education | N/A | 52.4144779 | -1.7848758 | ||
| 14530 | op-snap---monthly-publication-june-2025.pdf | 459 | 2025-06 | Pedal Bike | BMW | M235 | White | Driving without Due Care and Attention | None | Norton Lane | Norton Lane | Solihull | Solihull | Education | N/A | 52.3778771 | -1.8581547 | ||
| 14574 | op-snap---monthly-publication-june-2025.pdf | 503 | 2025-06 | Pedal Bike | Audi | A4 | Black | Driving without Due Care and Attention | None | Windward Way | Windward Way | Solihull | Solihull | NFA | No Offence | 52.5023715 | -1.7555515 | ||
| 14650 | op-snap---monthly-publication-june-2025.pdf | 579 | 2025-06 | Pedestrian | Mercedes-Benz | GLA | Grey | Cause vehicle to be left in a dangerous position | None | Station Road | Station Road | Solihull | Solihull | NFA | Out of Force | 52.3927253 | -1.6455823 | ||
| 14655 | op-snap---monthly-publication-june-2025.pdf | 584 | 2025-06 | Pedestrian | Land Rover | Discovery | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Longmore Road | Longmore Road | Solihull | Solihull | NFA | Not in Public Interest | 52.4078616 | -1.8211577 | ||
| 14663 | op-snap---monthly-publication-june-2025.pdf | 592 | 2025-06 | Pedestrian | Nissan | Qashqai | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Highwood Avenue | Highwood Avenue | Solihull | Solihull | Warning Letter | N/A | 52.434852 | -1.7860069 | ||
| 14664 | op-snap---monthly-publication-june-2025.pdf | 593 | 2025-06 | Pedestrian | Nissan | Qashqai | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Highwood Avenue | Highwood Avenue | Solihull | Solihull | Warning Letter | N/A | 52.434852 | -1.7860069 | ||
| 14682 | op-snap---monthly-publication-june-2025.pdf | 611 | 2025-06 | Car | Porsche | Macan | Grey | Drive a vehicle other than on the carriageway of a motorway | None | M42 | M42 | Solihull | Solihull | NFA | Not in Public Interest | ||||
| 14684 | op-snap---monthly-publication-june-2025.pdf | 613 | 2025-06 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Solihull Road | Solihull Road | Solihull | Solihull | Education | N/A | 52.4114159 | -1.8197732 | ||
| 14729 | op-snap---monthly-publication-june-2025.pdf | 658 | 2025-06 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4428606 | -1.812114 | ||
| 14747 | op-snap---monthly-publication-june-2025.pdf | 676 | 2025-06 | Pedal Bike | Toyota | Yaris | Red | Misc - Non Traffic Offences | None | Sarehole Rd | Sarehole Road | Solihull | Solihull | NFA | No Offence | ||||
| 14773 | op-snap---monthly-publication-june-2025.pdf | 702 | 2025-06 | Car | BMW | 8401 | Black | Driving without Due Care and Attention | VRM fails to conform to Regulations | Blossomfield Road | Blossomfield Road | Solihull | Solihull | Court | N/A | 52.4144779 | -1.7848758 | ||
| 14792 | op-snap---monthly-publication-june-2025.pdf | 721 | 2025-06 | Car | Skoda | Fabia | White | Contravening a Red Traffic Light | None | Longdon Road Knowle | Longdon Road Knowle | Solihull | Solihull | Education | N/A | 52.3895144 | -1.7388418 | ||
| 14793 | op-snap---monthly-publication-june-2025.pdf | 722 | 2025-06 | Car | Honda | Jazz | Red | Contravening a Red Traffic Light | None | Longdon Road Knowle | Longdon Road Knowle | Solihull | Solihull | Education | N/A | 52.3895144 | -1.7388418 | ||
| 14794 | op-snap---monthly-publication-june-2025.pdf | 723 | 2025-06 | Car | BMW | 535D | Grey | Driving without Reasonable Consideration | None | Marshlake Road | Marshlake Road | Solihull | Solihull | Warning Letter | N/A | ||||
| 14800 | op-snap---monthly-publication-june-2025.pdf | 729 | 2025-06 | Car | Land Rover | Discovery | White | Contravening a Red Traffic Light | None | Solihull Road | Solihull Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4114159 | -1.8197732 | ||
| 14804 | op-snap---monthly-publication-june-2025.pdf | 733 | 2025-06 | Car | Audi | A6 | Black | Driving without Due Care and Attention | None | Blossomfield Road | Blossomfield Road | Solihull | Solihull | Warning Letter | N/A | 52.4144779 | -1.7848758 | ||
| 14815 | op-snap---monthly-publication-june-2025.pdf | 744 | 2025-06 | Car | Kia | Sportage | Black | Using a Mobile Phone Whilst Driving | None | Longdon Road | Longdon Road | Solihull | Solihull | Fixed Penalty | N/A | 52.389832 | -1.7492294 | ||
| 14816 | op-snap---monthly-publication-june-2025.pdf | 745 | 2025-06 | Car | BMW | X3 | Black | Driving without Due Care and Attention | None | Manor Road | Manor Road | Solihull | Solihull | Education | N/A | 52.4193737 | -1.7798629 | ||
| 14820 | op-snap---monthly-publication-june-2025.pdf | 749 | 2025-06 | Car | Audi | Q4 | Silver | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Solihull | Solihull | Warning Letter | N/A | 52.4322443 | -1.6746508 | ||
| 14841 | op-snap---monthly-publication-june-2025.pdf | 770 | 2025-06 | Car | Mercedes-Benz | E220 | White | Driving without Due Care and Attention | None | Hamptonn Lane | Hamptonn Lane | Solihull | Solihull | Court | N/A | ||||
| 14844 | op-snap---monthly-publication-june-2025.pdf | 773 | 2025-06 | Car | Porsche | Cayenne | Black | Contravening a Red Traffic Light | None | Haslucks Green Road | Haslucks Green Road | Solihull | Solihull | Education | N/A | 52.4145149 | -1.8301272 | ||
| 14851 | op-snap---monthly-publication-june-2025.pdf | 780 | 2025-06 | Pedal Bike | Land Rover | Defender | Black | Driving without Due Care and Attention | None | Spring Hill | Spring Hill | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 14870 | op-snap---monthly-publication-june-2025.pdf | 799 | 2025-06 | Car | BMW | 530d | Grey | Driving without Due Care and Attention | None | Monkspath Hall Road | Monkspath Hall Road | Solihull | Solihull | Warning Letter | N/A | 52.3900358 | -1.8026595 | ||
| 14880 | op-snap---monthly-publication-june-2025.pdf | 809 | 2025-06 | Pedal Bike | Mercedes-Benz | sprint | Grey | Driving without Due Care and Attention | None | High Street | High Street | Solihull | Solihull | NFA | Outside of 14 DAYS Late Submission | 52.4064169 | -1.8557215 | ||
| 14900 | op-snap---monthly-publication-june-2025.pdf | 829 | 2025-06 | Car | Peugeot | 3008 | Blue | Driving without Due Care and Attention | None | Netherwood Lane | Netherwood Lane | Solihull | Solihull | Warning Letter | N/A | 52.3572751 | -1.7083402 | ||
| 14903 | op-snap---monthly-publication-june-2025.pdf | 832 | 2025-06 | Car | Volkswagen | Sharan | Grey | Contravening a Red Traffic Light | None | Poplar Road | Poplar Road | Solihull | Solihull | Warning Letter | N/A | 52.4140607 | -1.7792472 | ||
| 14946 | op-snap---monthly-publication-june-2025.pdf | 875 | 2025-06 | Car | Land Rover | Land Rover | Black | Driving without Due Care and Attention | None | Eggington Road Shirley | Eggington Road Shirley | Solihull | Solihull | NFA | No Independent Evidence Available | ||||
| 14952 | op-snap---monthly-publication-june-2025.pdf | 881 | 2025-06 | Pedestrian | Tesla | Model X | Grey | VRM fails to conform to Regulations | None | St Bernards Drive | Street Bernards Drive | Solihull | Solihull | Warning Letter | N/A | ||||
| 14954 | op-snap---monthly-publication-june-2025.pdf | 883 | 2025-06 | Pedestrian | Audi | A3 | Black | Misc - Non Traffic Offences | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | NFA | No Offence | ||||
| 15017 | op-snap---monthly-publication-june-2025.pdf | 946 | 2025-06 | Car | Land Rover | Range Rover | Green | Contravening a Red Traffic Light | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Warning Letter | N/A | 52.4223176 | -1.8253145 | ||
| 15019 | op-snap---monthly-publication-june-2025.pdf | 948 | 2025-06 | Car | Vauxhall | Astra | Silver | Using a Mobile Phone Whilst Driving | None | Hockley Heath | Hockley Heath | Solihull | Solihull | NFA | No Independent Evidence Available | 52.3515699 | -1.7767319 | ||
| 15031 | op-snap---monthly-publication-june-2025.pdf | 960 | 2025-06 | Car | E Deliever | White | Driving without Due Care and Attention | None | Cranmore Boulevard | Cranmore Boulevard | Solihull | Solihull | Court | N/A | 52.3947549 | -1.8141729 | |||
| 15054 | op-snap---monthly-publication-june-2025.pdf | 983 | 2025-06 | Pedal Bike | Peugeot | Partner | White | Driving without Reasonable Consideration | Littering | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 15066 | op-snap---monthly-publication-june-2025.pdf | 995 | 2025-06 | Car | Honda | Civic | Silver | Driving without Due Care and Attention | None | Silhill Hall Road | Silhill Hall Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4201252 | -1.7916238 | ||
| 15132 | op-snap---monthly-publication-june-2025.pdf | 1061 | 2025-06 | Car | Seat | White | Contravening a Red Traffic Light | None | Princes Way | Princes Way | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4130801 | -1.784461 | |||
| 15144 | op-snap---monthly-publication-june-2025.pdf | 1073 | 2025-06 | Car | Audi | A3 | Grey | Using a Mobile Phone Whilst Driving | None | St Margarets Road | Street Margarets Road | Solihull | Solihull | NFA | No Independent Evidence Available | ||||
| 15173 | op-snap---monthly-publication-june-2025.pdf | 1102 | 2025-06 | Pedal Bike | Ford | Focus | Blue | Driving without Due Care and Attention | None | Barston Lane | Barston Lane | Solihull | Solihull | Education | N/A | 52.4022999 | -1.685635 | ||
| 15177 | op-snap---monthly-publication-june-2025.pdf | 1106 | 2025-06 | Car | Audi | A4 | Black | Contravening a Red Traffic Light | None | Homer Road | Homer Road | Solihull | Solihull | Education | N/A | 52.4103123 | -1.7790808 | ||
| 15194 | op-snap---monthly-publication-june-2025.pdf | 1123 | 2025-06 | Car | Rolls-Royce | Ghost | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Solihull | Solihull | NFA | No Offence | 52.4505232 | -1.7606378 | ||
| 15195 | op-snap---monthly-publication-june-2025.pdf | 1124 | 2025-06 | Car | Audi | R8 | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Solihull | Solihull | NFA | No Offence | 52.4505232 | -1.7606378 | ||
| 15196 | op-snap---monthly-publication-june-2025.pdf | 1125 | 2025-06 | Lorry | Volkswagen | Armarok | Grey | Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway | None | M42 South | M42 South | Solihull | Solihull | Education | N/A | 52.4473832 | -1.7140496 | ||
| 15197 | op-snap---monthly-publication-june-2025.pdf | 1126 | 2025-06 | Car | Audi | S3 | White | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Solihull | Solihull | NFA | No Offence | 52.4505232 | -1.7606378 | ||
| 15198 | op-snap---monthly-publication-june-2025.pdf | 1127 | 2025-06 | Car | Mercedes-Benz | G63 | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Solihull | Solihull | NFA | No Offence | 52.4505232 | -1.7606378 | ||
| 15203 | op-snap---monthly-publication-june-2025.pdf | 1132 | 2025-06 | Car | Ford | Transit | White | Misc - Non Traffic Offences | None | Warwick Road | Warwick Road | Solihull | Solihull | NFA | Misc Inc Crimes | 52.4428606 | -1.812114 | ||
| 15209 | op-snap---monthly-publication-june-2025.pdf | 1138 | 2025-06 | Car | BMW | 320d | Grey | Driving without Due Care and Attention | None | Widney Manor Road | Widney Manor Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.3902967 | -1.7659209 | ||
| 15213 | op-snap---monthly-publication-june-2025.pdf | 1142 | 2025-06 | Car | Yamaha | X Max | Black | Driving without Due Care and Attention | None | Lode Lane | Lode Lane | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4149064 | -1.7832364 | ||
| 15258 | op-snap---monthly-publication-june-2025.pdf | 1187 | 2025-06 | Car | BMW | M135i | Black | Driving without Due Care and Attention | None | M42 SB J5 | M42 Southbound J5 | Solihull | Solihull | Education | N/A | ||||
| 15284 | op-snap---monthly-publication-june-2025.pdf | 1213 | 2025-06 | Car | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | Old Dickens Heath Road | Old Dickens Heath Road | Solihull | Solihull | Education | N/A | 52.3864791 | -1.8355922 | ||
| 15285 | op-snap---monthly-publication-june-2025.pdf | 1214 | 2025-06 | Car | BMW | 540i | White | Driving without Due Care and Attention | None | Old Dickens Heath Road | Old Dickens Heath Road | Solihull | Solihull | NFA | No Offence | 52.3864791 | -1.8355922 | ||
| 15291 | op-snap---monthly-publication-june-2025.pdf | 1220 | 2025-06 | Pedal Bike | Volvo | XC40 | Black | Driving without Due Care and Attention | None | Hampton Lane | Hampton Lane | Solihull | Solihull | NFA | Outside of 14 DAYS Late Submission | 52.4190728 | -1.7449943 | ||
| 15293 | op-snap---monthly-publication-june-2025.pdf | 1222 | 2025-06 | Pedal Bike | Volvo | XC90 | Silver | Driving without Due Care and Attention | None | Hampton Lane | Hampton Lane | Solihull | Solihull | NFA | Outside of 14 DAYS Late Submission | 52.4190728 | -1.7449943 | ||
| 15301 | op-snap---monthly-publication-june-2025.pdf | 1230 | 2025-06 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Streetbrook Road | Streetbrook Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 15329 | op-snap---monthly-publication-june-2025.pdf | 1258 | 2025-06 | Pedestrian | Vauxhall | Astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bills More Green | Bills More Green | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 15330 | op-snap---monthly-publication-june-2025.pdf | 1259 | 2025-06 | Car | Mercedes-Benz | CLC220 | Grey | Driving without Due Care and Attention | None | A3400 | A3400 | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 15389 | op-snap---monthly-publication-june-2025.pdf | 1318 | 2025-06 | Pedestrian | Vauxhall | Astra | Blue | Cause vehicle to be left in a dangerous position | None | Winschombe Road | Winschombe Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 15417 | op-snap---monthly-publication-june-2025.pdf | 1346 | 2025-06 | Pedestrian | Toyota | Aygo | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Solihull Train Station | Solihull Train Station | Solihull | Solihull | Warning Letter | N/A | 52.4147491 | -1.7879378 | ||
| 15526 | op-snap---monthly-publication-june-2025.pdf | 1455 | 2025-06 | Pedal Bike | Ford | Transit | Grey | Driving without Due Care and Attention | None | Haslucks Green Road | Haslucks Green Road | Solihull | Solihull | Education | N/A | 52.4145149 | -1.8301272 | ||
| 15537 | op-snap---monthly-publication-june-2025.pdf | 1466 | 2025-06 | Car | Mazda | 3 | Grey | Contravening a Red Traffic Light | None | New Road | New Road | Solihull | Solihull | Education | N/A | 52.4119526 | -1.773235 | ||
| 15573 | op-snap---monthly-publication-june-2025.pdf | 1502 | 2025-06 | Car | Toyota | Auris | Silver | Driving without Due Care and Attention | None | Balsall Street East | Balsall Street East | Solihull | Solihull | Warning Letter | N/A | 52.3854087 | -1.6550831 | ||
| 15585 | op-snap---monthly-publication-june-2025.pdf | 1514 | 2025-06 | Car | Toyota | Hilux | Blue | Misc - Non Traffic Offences | None | M42 S/B Jn 5 to 4 | M42 Southbound Junction 5 to 4 | Solihull | Solihull | NFA | No Offence | ||||
| 15590 | op-snap---monthly-publication-june-2025.pdf | 1519 | 2025-06 | Pedal Bike | Volvo | Coach | Grey | Driving without Reasonable Consideration | None | Damson Parkway | Damson Parkway | Solihull | Solihull | Education | N/A | 52.437016 | -1.7578446 | ||
| 15613 | op-snap---monthly-publication-june-2025.pdf | 1542 | 2025-06 | Pedal Bike | Audi | A1 | Blue | Using a Mobile Phone Whilst Driving | None | Warwick Road | Warwick Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4428606 | -1.812114 | ||
| 15636 | op-snap---monthly-publication-june-2025.pdf | 1565 | 2025-06 | Car | Nissan | Micra | Red | Driving without Due Care and Attention | None | Blackdown Road | Blackdown Road | Solihull | Solihull | Education | N/A | 52.3907081 | -1.7406271 | ||
| 15647 | op-snap---monthly-publication-june-2025.pdf | 1576 | 2025-06 | Pedal Bike | Volkswagen | Golf | Red | Driving without Due Care and Attention | None | Olton Road | Olton Road | Solihull | Solihull | Education | N/A | 52.4193964 | -1.8252207 | ||
| 15650 | op-snap---monthly-publication-june-2025.pdf | 1579 | 2025-06 | Car | Toyota | Prius | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No Offence | 52.4191184 | -1.8326637 | ||
| 15651 | op-snap---monthly-publication-june-2025.pdf | 1580 | 2025-06 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | No Seat Belt | A41 Warwick Road | Warwick Road | Solihull | Solihull | Education | N/A | 52.4428606 | -1.812114 | ||
| 15728 | op-snap---monthly-publication-june-2025.pdf | 1657 | 2025-06 | Car | Toyota | Avensis | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Balsall Street East | Balsall Street East | Solihull | Solihull | Fixed Penalty | N/A | 52.3854087 | -1.6550831 | ||
| 15731 | op-snap---monthly-publication-june-2025.pdf | 1660 | 2025-06 | Car | Tesla | Model Y | White | Using a Mobile Phone Whilst Driving | None | M42 motorway | M42 motorway | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 15768 | op-snap---monthly-publication-june-2025.pdf | 1697 | 2025-06 | Other | Ford | Ecosport | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wagon Lane | Wagon Lane | Solihull | Solihull | Warning Letter | N/A | 52.4525076 | -1.7981031 | ||
| 15778 | op-snap---monthly-publication-june-2025.pdf | 1707 | 2025-06 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chalgrove Crescent | Chalgrove Crescent | Solihull | Solihull | NFA | Not in Public Interest | 52.4016325 | -1.7830609 | |||||
| 15837 | op-snap---monthly-publication-june-2025.pdf | 1766 | 2025-06 | Pedestrian | BMW | 1 Series | Grey | Cause vehicle to be left in a dangerous position | None | Dovehouse Lane | Dovehouse Lane | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4319915 | -1.7915192 | ||
| 15838 | op-snap---monthly-publication-june-2025.pdf | 1767 | 2025-06 | Pedestrian | BMW | 320 | Black | Cause vehicle to be left in a dangerous position | None | Dovehouse Lane | Dovehouse Lane | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4319915 | -1.7915192 | ||
| 15918 | op-snap---monthly-publication-june-2025.pdf | 1847 | 2025-06 | Car | Audi | A4 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Knowles high street | Knowles high street | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 15923 | op-snap---monthly-publication-june-2025.pdf | 1852 | 2025-06 | Car | Ford | Transit | White | Misc - Non Traffic Offences | None | A45 towards Kenilworth | A45 towards Kenilworth | Solihull | Solihull | NFA | No Offence | ||||
| 15928 | op-snap---monthly-publication-june-2025.pdf | 1857 | 2025-06 | Pedestrian | Ford | Transit | Blue | Cause vehicle to be left in a dangerous position | None | Dovehouse Parade | Dovehouse Parade | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4292175 | -1.7980801 | ||
| 15981 | op-snap---monthly-publication-june-2025.pdf | 1910 | 2025-06 | Car | Moped | Misc - Non Traffic Offences | None | Church Hill Rd | Church Hill Road | Solihull | Solihull | NFA | No Offence | 52.4078582 | -1.7777439 | ||||
| 15987 | op-snap---monthly-publication-june-2025.pdf | 1916 | 2025-06 | Car | Skoda | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Robin Hood Lane | Robin Hood Lane | Solihull | Solihull | NFA | Not in Public Interest | 52.422933 | -1.8352662 |
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);