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'}
220 rows where council_area = "Solihull" and disposal = "Education" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence
vehicle_make 30
month 14
offence 12
- Driving without Due Care and Attention 112
- Contravening a Red Traffic Light 56
- Driving without Reasonable Consideration 30
- Cause vehicle to be left in a dangerous position 6
- Stop a vehicle within pelican pedestrian crossing limits 5
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 2
- Drive a vehicle other than on the carriageway of a motorway 2
- Drive on hard shoulder 2
- Stop a vehicle on pedestrian crossing 2
- Contravene Lane Closure Red X 1
- Drive mechanically propelled vehicle without reasonable consideration 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
reporter_transport_mode 8
- Car 125
- Pedal Bike 73
- Pedestrian 14
- Lorry 3
- car 2
- Horse Rider 1
- Motorbike 1
- Other 1
disposal 1
- Education · 220 ✖
council_area 1
- Solihull · 220 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7572 | op-snap---monthly-publication-february-2026.pdf | 319 | 2026-02 | Car | BMW | 325D | Black | Contravening a Red Traffic Light | None | Danford Lane at Blossomfield Road | Danford Lane at Blossomfield Road | Solihull | Solihull | Education | N/A | 52.4092804 | -1.8056214 | ||
| 7580 | op-snap---monthly-publication-february-2026.pdf | 327 | 2026-02 | Car | Honda | CR-V | Blue | Contravening a Red Traffic Light | None | Damson Parkway | Damson Parkway | Solihull | Solihull | Education | N/A | 52.437016 | -1.7578446 | ||
| 7723 | op-snap---monthly-publication-february-2026.pdf | 470 | 2026-02 | Car | Kia | EV3 | Green | Driving without Due Care and Attention | None | Tanworth Lane | Tanworth Lane | Solihull | Solihull | Education | N/A | 52.4014694 | -1.8220541 | ||
| 7783 | op-snap---monthly-publication-february-2026.pdf | 530 | 2026-02 | Pedal Bike | Mercedes-Benz | 180 | White | Driving without Due Care and Attention | None | Cornetts End Lane | Cornetts End Lane | Solihull | Solihull | Education | N/A | ||||
| 7933 | op-snap---monthly-publication-february-2026.pdf | 680 | 2026-02 | Pedal Bike | Porsche | Cayenne | Grey | Driving without Due Care and Attention | None | Streetbrook Road Solihull | Streetbrook Road Solihull | Solihull | Solihull | Education | N/A | ||||
| 8022 | op-snap---monthly-publication-february-2026.pdf | 769 | 2026-02 | Car | Citroen | C3 | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Widney Lane | Widney Lane | Solihull | Solihull | Education | N/A | 52.3975737 | -1.7857722 | ||
| 8025 | op-snap---monthly-publication-february-2026.pdf | 772 | 2026-02 | Pedal Bike | Audi | Q2 | White | Driving without Due Care and Attention | None | High Street | High Street | Solihull | Solihull | Education | N/A | 52.4064169 | -1.8557215 | ||
| 8042 | op-snap---monthly-publication-february-2026.pdf | 789 | 2026-02 | Pedal Bike | Tesla | Model S | White | Driving without Due Care and Attention | None | Shutt Lane | Shutt Lane | Solihull | Solihull | Education | N/A | 52.367795 | -1.8250635 | ||
| 8047 | op-snap---monthly-publication-february-2026.pdf | 794 | 2026-02 | Pedal Bike | Ford | Puma | Red | Driving without Due Care and Attention | None | Hampton Lane | Hampton Lane | Solihull | Solihull | Education | N/A | 52.4190728 | -1.7449943 | ||
| 8069 | op-snap---monthly-publication-february-2026.pdf | 816 | 2026-02 | Car | Toyota | Yaris | Red | Driving without Due Care and Attention | None | Church Hill Road | Church Hill Road | Solihull | Solihull | Education | N/A | 52.4078582 | -1.7777439 | ||
| 8137 | op-snap---monthly-publication-february-2026.pdf | 884 | 2026-02 | Pedestrian | Audi | A3 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Lyndon Road | Lyndon Road | Solihull | Solihull | Education | N/A | 52.4527113 | -1.789438 | ||
| 8184 | op-snap---monthly-publication-february-2026.pdf | 931 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Bills Lane | Bills Lane | Solihull | Solihull | Education | N/A | 52.3998632 | -1.8392819 | ||
| 8247 | op-snap---monthly-publication-february-2026.pdf | 994 | 2026-02 | Car | Lexus | RX450H | Black | Driving without Due Care and Attention | No vehicle excise licence | Solihull Bypass | Solihull Bypass | Solihull | Solihull | Education | N/A | 52.4207529 | -1.7757467 | ||
| 8355 | op-snap---monthly-publication-february-2026.pdf | 1102 | 2026-02 | Car | BMW | 435 | Black | Contravening a Red Traffic Light | None | Robin Hood Lane | Robin Hood Lane | Solihull | Solihull | Education | N/A | 52.422933 | -1.8352662 | ||
| 8416 | op-snap---monthly-publication-february-2026.pdf | 1163 | 2026-02 | Car | Mini | One | Grey | Contravening a Red Traffic Light | None | A4545 Bickenhill | Bickenhill | Solihull | Solihull | Education | N/A | 52.4390963 | -1.7239955 | ||
| 8811 | op-snap---monthly-publication-february-2026.pdf | 1558 | 2026-02 | Car | Mini | Cooper | Silver | Driving without Due Care and Attention | None | Chester Road, Kingshurst | Chester Road, Kingshurst | Solihull | Solihull | Education | N/A | 52.5013241 | -1.7644355 | ||
| 10762 | op-snap---monthly-publication-january-2026.pdf | 223 | 2026-01 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Education | N/A | 52.4223176 | -1.8253145 | ||
| 10792 | op-snap---monthly-publication-january-2026.pdf | 253 | 2026-01 | car | Audi | A3 | White | Contravening a Red Traffic Light | None | M42 j4 to A34 | M42 j4 to A34 | Solihull | Solihull | Education | N/A | ||||
| 10809 | op-snap---monthly-publication-january-2026.pdf | 270 | 2026-01 | Car | Mercedes-Benz | A35 | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Station Approach | Station Approach | Solihull | Solihull | Education | N/A | 52.4146834 | -1.7879896 | ||
| 10915 | op-snap---monthly-publication-january-2026.pdf | 376 | 2026-01 | Car | Toyota | Avensis | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Education | N/A | 52.4223176 | -1.8253145 | ||
| 10930 | op-snap---monthly-publication-january-2026.pdf | 391 | 2026-01 | Pedestrian | BMW | X3 | White | Cause vehicle to be left in a dangerous position | None | Beechwood Park Road | Beechwood Park Road | Solihull | Solihull | Education | N/A | 52.4223881 | -1.8055835 | ||
| 10977 | op-snap---monthly-publication-january-2026.pdf | 438 | 2026-01 | Pedal Bike | BMW | 330 E | Black | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Education | N/A | 52.4223176 | -1.8253145 | ||
| 10979 | op-snap---monthly-publication-january-2026.pdf | 440 | 2026-01 | Pedal Bike | Citroen | DS3 | White | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Education | N/A | 52.4223176 | -1.8253145 | ||
| 10999 | op-snap---monthly-publication-january-2026.pdf | 460 | 2026-01 | Car | BMW | 1 Series | Grey | Driving without Due Care and Attention | None | Blossomfield Road | Blossomfield Road | Solihull | Solihull | Education | N/A | 52.4144779 | -1.7848758 | ||
| 11013 | op-snap---monthly-publication-january-2026.pdf | 474 | 2026-01 | Pedestrian | BMW | 1 Series | Red | Cause vehicle to be left in a dangerous position | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Education | N/A | ||||
| 11133 | op-snap---monthly-publication-january-2026.pdf | 594 | 2026-01 | Pedestrian | Audi | A5 | White | Cause vehicle to be left in a dangerous position | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Education | N/A | ||||
| 11285 | op-snap---monthly-publication-january-2026.pdf | 746 | 2026-01 | Pedal Bike | Volvo | V40.. | Grey | Driving without Due Care and Attention | None | Cranmore Boulevard | Cranmore Boulevard | Solihull | Solihull | Education | N/A | 52.3947549 | -1.8141729 | ||
| 11302 | op-snap---monthly-publication-january-2026.pdf | 763 | 2026-01 | Car | Mercedes-Benz | C220 | Silver | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Solihull | Solihull | Education | N/A | 52.4428606 | -1.812114 | ||
| 11387 | op-snap---monthly-publication-january-2026.pdf | 848 | 2026-01 | Other | Fiat | DOBLO | Grey | Driving without Due Care and Attention | None | Miall Park Road | Miall Park Road | Solihull | Solihull | Education | N/A | 52.4214617 | -1.8086577 | ||
| 11470 | op-snap---monthly-publication-january-2026.pdf | 931 | 2026-01 | Car | Vauxhall | Astra | Grey | Driving without Due Care and Attention | None | Balsall Street East | Balsall Street East | Solihull | Solihull | Education | N/A | 52.3854087 | -1.6550831 | ||
| 11576 | op-snap---monthly-publication-january-2026.pdf | 1037 | 2026-01 | Car | Toyota | Yaris | Grey | Contravening a Red Traffic Light | None | Lode Lane | Lode Lane | Solihull | Solihull | Education | N/A | 52.4149064 | -1.7832364 | ||
| 11605 | op-snap---monthly-publication-january-2026.pdf | 1066 | 2026-01 | Pedal Bike | Skoda | Superb | Black | Driving without Due Care and Attention | None | Kineton Green Road | Kineton Green Road | Solihull | Solihull | Education | N/A | 52.4332233 | -1.812229 | ||
| 11625 | op-snap---monthly-publication-january-2026.pdf | 1086 | 2026-01 | Car | Mercedes-Benz | EQC | Blue | Driving without Due Care and Attention | None | Bosworth Drive | Bosworth Drive | Solihull | Solihull | Education | N/A | 52.4780944 | -1.7586668 | ||
| 11784 | op-snap---monthly-publication-january-2026.pdf | 1245 | 2026-01 | Pedestrian | Ford | B Max | White | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Education | N/A | 52.4223176 | -1.8253145 | ||
| 11899 | op-snap---monthly-publication-january-2026.pdf | 1360 | 2026-01 | Car | Land Rover | Evoque | White | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 11900 | op-snap---monthly-publication-january-2026.pdf | 1361 | 2026-01 | Car | Land Rover | Sport | Blue | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 11924 | op-snap---monthly-publication-january-2026.pdf | 1385 | 2026-01 | Pedal Bike | Vauxhall | Astra | Red | Driving without Due Care and Attention | None | B4102 Solihull Road | Solihull Road | Solihull | Solihull | Education | N/A | 52.4114159 | -1.8197732 | ||
| 3985 | op-snap---monthly-publication-december-2025.pdf | 113 | 2025-12 | Car | Kia | Sportage | White | Driving without Due Care and Attention | None | M42 Junction 4 | M42 Junction 4 | Solihull | Solihull | Education | N/A | ||||
| 4007 | op-snap---monthly-publication-december-2025.pdf | 135 | 2025-12 | Car | Audi | A5 | Silver | Contravening a Red Traffic Light | None | Church Hill Road | Church Hill Road | Solihull | Solihull | Education | N/A | 52.4078582 | -1.7777439 | ||
| 4014 | op-snap---monthly-publication-december-2025.pdf | 142 | 2025-12 | Car | BMW | 2 series | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 4446 | op-snap---monthly-publication-december-2025.pdf | 574 | 2025-12 | Car | Audi | q3 | Blue | Contravene Lane Closure Red X | None | m42 NB junction 3 | m42 Northbound junction 3 | Solihull | Solihull | Education | N/A | 52.4846642 | -1.9297585 | ||
| 4584 | op-snap---monthly-publication-december-2025.pdf | 712 | 2025-12 | Pedal Bike | Seat | Arona | Black | Driving without Due Care and Attention | None | Broad Lane, Balsall Common | Broad Lane, Balsall Common | Solihull | Solihull | Education | N/A | ||||
| 4715 | op-snap---monthly-publication-december-2025.pdf | 843 | 2025-12 | Pedal Bike | Toyota | Auris | Brown | Driving without Due Care and Attention | None | Ralph Road, Shirley, Solihull | Ralph Road, Shirley, Solihull | Solihull | Solihull | Education | N/A | 52.4156768 | -1.8193235 | ||
| 4760 | op-snap---monthly-publication-december-2025.pdf | 888 | 2025-12 | Car | Honda | CRV | Blue | Driving without Due Care and Attention | None | Oakenshaw Road | Oakenshaw Road | Solihull | Solihull | Education | N/A | 52.4017754 | -1.8151522 | ||
| 4813 | op-snap---monthly-publication-december-2025.pdf | 941 | 2025-12 | Car | BMW | 420 | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 4816 | op-snap---monthly-publication-december-2025.pdf | 944 | 2025-12 | Pedal Bike | BMW | IX | Grey | Driving without Due Care and Attention | None | Whitefields Road | Whitefields Road | Solihull | Solihull | Education | N/A | 52.4060267 | -1.7849657 | ||
| 4848 | op-snap---monthly-publication-december-2025.pdf | 976 | 2025-12 | Car | Vauxhall | Mokka | White | Contravening a Red Traffic Light | None | Homer Road | Homer Road | Solihull | Solihull | Education | N/A | 52.4103123 | -1.7790808 | ||
| 5009 | op-snap---monthly-publication-december-2025.pdf | 1137 | 2025-12 | Car | Mercedes-Benz | A180 | Black | Contravening a Red Traffic Light | None | Marshall Lake Road | Marshall Lake Road | Solihull | Solihull | Education | N/A | 52.3975426 | -1.818252 | ||
| 5161 | op-snap---monthly-publication-december-2025.pdf | 1289 | 2025-12 | Car | Nissan | Qashqai | Red | Driving without Due Care and Attention | None | Longmore Road | Longmore Road | Solihull | Solihull | Education | N/A | 52.4078616 | -1.8211577 | ||
| 20497 | op-snap---monthly-publication-november-2025.pdf | 39 | 2025-11 | Car | Volkswagen | Tiguan | Grey | Contravening a Red Traffic Light | None | Homer Road | Homer Road | Solihull | Solihull | Education | N/A | 52.4103123 | -1.7790808 | ||
| 20610 | op-snap---monthly-publication-november-2025.pdf | 152 | 2025-11 | Pedal Bike | Land Rover | Discovery | Grey | Driving without Due Care and Attention | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Education | N/A | ||||
| 20621 | op-snap---monthly-publication-november-2025.pdf | 163 | 2025-11 | Pedal Bike | Kia | Picanto | Silver | Driving without Due Care and Attention | None | Widney Manor Road | Widney Manor Road | Solihull | Solihull | Education | N/A | 52.3902967 | -1.7659209 | ||
| 20652 | op-snap---monthly-publication-november-2025.pdf | 194 | 2025-11 | Car | Mercedes-Benz | AMG | Blue | Driving without Due Care and Attention | None | Richmond Road Olton | Richmond Road Olton | Solihull | Solihull | Education | N/A | 52.4430827 | -1.8006217 | ||
| 20664 | op-snap---monthly-publication-november-2025.pdf | 206 | 2025-11 | Car | Volvo | V90 | Grey | Contravening a Red Traffic Light | None | Dovehouse Lane | Dovehouse Lane | Solihull | Solihull | Education | N/A | 52.4319915 | -1.7915192 | ||
| 20690 | op-snap---monthly-publication-november-2025.pdf | 232 | 2025-11 | Car | Nissan | Micra | Gold | Driving without Due Care and Attention | None | M42 SB J6 | M42 Southbound J6 | Solihull | Solihull | Education | N/A | ||||
| 20824 | op-snap---monthly-publication-november-2025.pdf | 366 | 2025-11 | Car | BMW | 520I | Black | Driving without Due Care and Attention | None | M42 Juncution 5 | M42 Juncution 5 | Solihull | Solihull | Education | N/A | ||||
| 20860 | op-snap---monthly-publication-november-2025.pdf | 402 | 2025-11 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Coleshill Heath Road | Coleshill Heath Road | Solihull | Solihull | Education | N/A | 52.4667242 | -1.7283592 | ||
| 21034 | op-snap---monthly-publication-november-2025.pdf | 576 | 2025-11 | Pedestrian | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 21412 | op-snap---monthly-publication-november-2025.pdf | 954 | 2025-11 | Car | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Lode Lane | Lode Lane | Solihull | Solihull | Education | N/A | 52.4149064 | -1.7832364 | ||
| 21416 | op-snap---monthly-publication-november-2025.pdf | 958 | 2025-11 | Car | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Richmond Road | Richmond Road | Solihull | Solihull | Education | N/A | 52.4430188 | -1.8022218 | ||
| 21475 | op-snap---monthly-publication-november-2025.pdf | 1017 | 2025-11 | Car | Land Rover | Discovery | Grey | Drive a vehicle other than on the carriageway of a motorway | None | M42 J6 | M42 J6 | Solihull | Solihull | Education | N/A | ||||
| 21640 | op-snap---monthly-publication-november-2025.pdf | 1182 | 2025-11 | Car | Audi | A5 | Grey | Contravening a Red Traffic Light | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Education | N/A | 52.4223176 | -1.8253145 | ||
| 21670 | op-snap---monthly-publication-november-2025.pdf | 1212 | 2025-11 | Car | Mazda | 6 Sport Nav D | Red | Driving without Due Care and Attention | None | Solihull Bypass A41 | Solihull Bypass A41 | Solihull | Solihull | Education | N/A | 52.4201188 | -1.7735079 | ||
| 21701 | op-snap---monthly-publication-november-2025.pdf | 1243 | 2025-11 | Car | Seat | Ibiza | White | Contravening a Red Traffic Light | None | Stratford Road, Shirley, at entrance to Tesco Store | Stratford Road, Shirley, at entrance to Tesco Store | Solihull | Solihull | Education | N/A | 52.4171404 | -1.830877 | ||
| 21723 | op-snap---monthly-publication-november-2025.pdf | 1265 | 2025-11 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | High Street Jct Windmill Road | High Street Junction Windmill Road | Solihull | Solihull | Education | N/A | ||||
| 21865 | op-snap---monthly-publication-november-2025.pdf | 1407 | 2025-11 | Car | Vauxhall | Mokka | Black | Driving without Due Care and Attention | None | Station Road, Dorridge | Station Road, Dorridge | Solihull | Solihull | Education | N/A | 52.3737352 | -1.7528435 | ||
| 21978 | op-snap---monthly-publication-november-2025.pdf | 1520 | 2025-11 | Car | Dennis | Enviro | Driving without Due Care and Attention | None | Sharmans Cross Road | Sharmans Cross Road | Solihull | Solihull | Education | N/A | 52.4167172 | -1.7990388 | |||
| 22155 | op-snap---monthly-publication-october-2025.pdf | 105 | 2025-10 | Car | Fiat | 500l | Red | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 22286 | op-snap---monthly-publication-october-2025.pdf | 236 | 2025-10 | Pedal Bike | Nissan | Qashqai | Silver | Driving without Due Care and Attention | None | Friday Lane | Friday Lane | Solihull | Solihull | Education | N/A | 52.4142542 | -1.7217662 | ||
| 22290 | op-snap---monthly-publication-october-2025.pdf | 240 | 2025-10 | Car | Volkswagen | Crafter | White | Contravening a Red Traffic Light | Use vehicle on a road without valid test certificate | Hobs Moat Road | Hobs Moat Road | Solihull | Solihull | Education | N/A | 52.4497735 | -1.7831925 | ||
| 22431 | op-snap---monthly-publication-october-2025.pdf | 381 | 2025-10 | Pedal Bike | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Balsall Street | Balsall Street | Solihull | Solihull | Education | N/A | 52.3826029 | -1.6998649 | ||
| 22495 | op-snap---monthly-publication-october-2025.pdf | 445 | 2025-10 | Car | Hyundai | I10 | Grey | Driving without Due Care and Attention | None | Stonebridge Island | Stonebridge Island | Solihull | Solihull | Education | N/A | 52.445911 | -1.68657 | ||
| 22549 | op-snap---monthly-publication-october-2025.pdf | 499 | 2025-10 | Car | Peugeot | 208 | grey | Contravening a Red Traffic Light | None | Lode Lane | Lode Lane | Solihull | Solihull | Education | N/A | 52.4149064 | -1.7832364 | ||
| 22595 | op-snap---monthly-publication-october-2025.pdf | 545 | 2025-10 | Pedal Bike | Audi | Q3 | Silver | Driving without Due Care and Attention | None | Lode Lane | Lode Lane | Solihull | Solihull | Education | N/A | 52.4149064 | -1.7832364 | ||
| 22598 | op-snap---monthly-publication-october-2025.pdf | 548 | 2025-10 | Pedal Bike | Volkswagen | Fox | Black | Driving without Due Care and Attention | None | Friday Lane | Friday Lane | Solihull | Solihull | Education | N/A | 52.4142542 | -1.7217662 | ||
| 22705 | op-snap---monthly-publication-october-2025.pdf | 655 | 2025-10 | Car | Audi | A3 | Red | Driving without Due Care and Attention | None | Damson Parkway | Damson Parkway | Solihull | Solihull | Education | N/A | 52.437016 | -1.7578446 | ||
| 22781 | op-snap---monthly-publication-october-2025.pdf | 731 | 2025-10 | Pedal Bike | BMW | 218I | Grey | Driving without Due Care and Attention | None | Highlands Road | Highlands Road | Solihull | Solihull | Education | N/A | 52.3909869 | -1.8032499 | ||
| 22867 | op-snap---monthly-publication-october-2025.pdf | 817 | 2025-10 | Pedal Bike | Mini | Mini | Silver | Driving without Due Care and Attention | None | A3400 Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 22931 | op-snap---monthly-publication-october-2025.pdf | 881 | 2025-10 | Car | Ford | Transit | Silver | Driving without Due Care and Attention | None | M42 SB J5 | M42 Southbound J5 | Solihull | Solihull | Education | N/A | ||||
| 23064 | op-snap---monthly-publication-october-2025.pdf | 1014 | 2025-10 | Pedal Bike | Hyundai | Tucson | Black | Driving without Due Care and Attention | None | Rumbush Lane | Rumbush Lane | Solihull | Solihull | Education | N/A | 52.3807937 | -1.8418159 | ||
| 23883 | op-snap---monthly-publication-september-2025.pdf | 102 | 2025-09 | Car | BMW | X6 | Grey | Contravening a Red Traffic Light | None | Nailcote Lane | Nailcote Lane | Solihull | Solihull | Education | N/A | 52.3948197 | -1.6142205 | ||
| 23947 | op-snap---monthly-publication-september-2025.pdf | 166 | 2025-09 | Car | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Ulverley Green Road | Ulverley Green Road | Solihull | Solihull | Education | N/A | 52.4367749 | -1.80129 | ||
| 23952 | op-snap---monthly-publication-september-2025.pdf | 171 | 2025-09 | Car | Ford | Transit | Grey | Driving without Due Care and Attention | None | Wagon Lane | Wagon Lane | Solihull | Solihull | Education | N/A | 52.4525076 | -1.7981031 | ||
| 23984 | op-snap---monthly-publication-september-2025.pdf | 203 | 2025-09 | Car | Mercedes-Benz | AMG C | White | Driving without Due Care and Attention | None | Lode Lane | Lode Lane | Solihull | Solihull | Education | N/A | 52.4149064 | -1.7832364 | ||
| 24105 | op-snap---monthly-publication-september-2025.pdf | 324 | 2025-09 | Pedal Bike | Renault | Traffic | Black | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Solihull | Solihull | Education | N/A | 52.4322443 | -1.6746508 | ||
| 24212 | op-snap---monthly-publication-september-2025.pdf | 431 | 2025-09 | Car | Audi | Q4 | Black | Contravening a Red Traffic Light | None | A3400 Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 24305 | op-snap---monthly-publication-september-2025.pdf | 524 | 2025-09 | Pedal Bike | Volkswagen | Polo | Black | Driving without Reasonable Consideration | None | School Road | School Road | Solihull | Solihull | Education | N/A | 52.3517888 | -1.7783232 | ||
| 24357 | op-snap---monthly-publication-september-2025.pdf | 576 | 2025-09 | Pedal Bike | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Hob Lane | Hob Lane | Solihull | Solihull | Education | N/A | 52.377539 | -1.6201491 | ||
| 24438 | op-snap---monthly-publication-september-2025.pdf | 657 | 2025-09 | Car | Volkswagen | Passat | Black | Contravening a Red Traffic Light | None | A45 Coventry Road | Coventry Road | Solihull | Solihull | Education | N/A | 52.4505232 | -1.7606378 | ||
| 24469 | op-snap---monthly-publication-september-2025.pdf | 688 | 2025-09 | Car | BMW | X3 | Black | Driving without Due Care and Attention | None | M42 junction 6 | M42 junction 6 | Solihull | Solihull | Education | N/A | ||||
| 24470 | op-snap---monthly-publication-september-2025.pdf | 689 | 2025-09 | Car | Ford | Transit | White | Contravening a Red Traffic Light | No vehicle excise licence | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 24517 | op-snap---monthly-publication-september-2025.pdf | 736 | 2025-09 | Car | Skoda | Fabia | Blue | Driving without Due Care and Attention | None | Dickens Heath Road | Dickens Heath Road | Solihull | Solihull | Education | N/A | 52.3875525 | -1.8339426 | ||
| 24518 | op-snap---monthly-publication-september-2025.pdf | 737 | 2025-09 | Car | Hyundai | I30 | Black | Driving without Due Care and Attention | None | Dickens Heath Road | Dickens Heath Road | Solihull | Solihull | Education | N/A | 52.3875525 | -1.8339426 | ||
| 24634 | op-snap---monthly-publication-september-2025.pdf | 853 | 2025-09 | Pedestrian | Audi | E TRon | Blue | Contravening a Red Traffic Light | None | Lode Lane | Lode Lane | Solihull | Solihull | Education | N/A | 52.4149064 | -1.7832364 | ||
| 24657 | op-snap---monthly-publication-september-2025.pdf | 876 | 2025-09 | Car | Volkswagen | Sharan | White | Contravening a Red Traffic Light | None | Homer Road | Homer Road | Solihull | Solihull | Education | N/A | 52.4103123 | -1.7790808 | ||
| 24696 | op-snap---monthly-publication-september-2025.pdf | 915 | 2025-09 | Pedal Bike | Peugeot | 208.. | Red | Driving without Reasonable Consideration | None | Tanworth Lane | Tanworth Lane | Solihull | Solihull | Education | N/A | 52.4014694 | -1.8220541 | ||
| 24721 | op-snap---monthly-publication-september-2025.pdf | 940 | 2025-09 | Car | Hyundai | IX32. | White | Driving without Due Care and Attention | None | Prospect Lane | Prospect Lane | Solihull | Solihull | Education | N/A | 52.4163536 | -1.8123298 | ||
| 2123 | op-snap---monthly-publication-august-2025.pdf | 98 | 2025-08 | Lorry | Jaguar | I Pace | Blue | Driving without Due Care and Attention | None | M42 | M42 | Solihull | Solihull | Education | N/A | ||||
| 2263 | op-snap---monthly-publication-august-2025.pdf | 238 | 2025-08 | Car | Toyota | Yaris | Black | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Solihull | Solihull | Education | N/A | 52.4505232 | -1.7606378 | ||
| 2284 | op-snap---monthly-publication-august-2025.pdf | 259 | 2025-08 | Pedal Bike | Ford | B Max | Blue | Driving without Due Care and Attention | None | Station Road | Station Road | Solihull | Solihull | Education | N/A | 52.3927253 | -1.6455823 |
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);