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'}
322 rows where reporter_transport_mode = "Car" and vehicle_make = "Land Rover" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
offence >30
- Driving without Due Care and Attention 113
- Contravening a Red Traffic Light 76
- Using a Mobile Phone Whilst Driving 22
- Driving without Reasonable Consideration 17
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 14
- VRM fails to conform to Regulations 13
- Cause vehicle to be left in a dangerous position 10
- Misc - Non Traffic Offences 9
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 6
- Stop a vehicle within pelican pedestrian crossing limits 5
- Cause unnecessary obstruction by motor vehicle 4
- Drive a vehicle other than on the carriageway of a motorway 4
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 4
- Stop a vehicle on pedestrian crossing 4
- Drive on hard shoulder 2
- Driving a vehicle wholly or partly on a footpath 2
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
- Vehicle overtake within crossing limits 2
- Dangerous Driving 1
- Drive / Ride / Lead an animal on a footpath 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 1
- Driver not in position to have Proper Control 1
- Fail to accord precedence to pedestrian at zebra crossing 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with a non endorsab 1
- No Insurance 1
- No Seat Belt 1
- No vehicle excise licence 1
- Offence to be added 1
- …
council_area 15
- Birmingham 124
- Out of Force Area 56
- Solihull 31
- Sandwell 21
- Coventry 17
- Dudley 17
- Wolverhampton 17
- Sutton Coldfield 15
- Walsall 15
- Halesowen 4
- Askust Rtoona Dcoldfield 1
- Edldu Dalveey Brierley Hill 1
- Edwud Rleoyad 1
- Hc Sotventry 1
- Metropolitan Borough 1
month 14
disposal 6
- NFA 137
- Warning Letter 71
- Fixed Penalty 56
- Education 37
- Court 19
- Other Action Taken 2
vehicle_make 1
- Land Rover · 322 ✖
reporter_transport_mode 1
- Car · 322 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8852 | op-snap---monthly-publication-february-2026.pdf | 1599 | 2026-02 | Car | Land Rover | defender | Black | Cause vehicle to be left in a dangerous position | none | high street, kingswinford | High Street, Kingswinford | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8770 | op-snap---monthly-publication-february-2026.pdf | 1517 | 2026-02 | Car | Land Rover | discovery | Black | Driving a vehicle wholly or partly on a footpath | None | Hollyfield Road | Hollyfield Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5620486 | -1.8030784 | ||
| 8729 | op-snap---monthly-publication-february-2026.pdf | 1476 | 2026-02 | Car | Land Rover | discovery | Black | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 8660 | op-snap---monthly-publication-february-2026.pdf | 1407 | 2026-02 | Car | Land Rover | Evoque | White | Using a Mobile Phone Whilst Driving | None | Shard End Crescent | Shard End Crescent | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4927744 | -1.7781391 | ||
| 8562 | op-snap---monthly-publication-february-2026.pdf | 1309 | 2026-02 | Car | Land Rover | Freelander | Grey | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 8551 | op-snap---monthly-publication-february-2026.pdf | 1298 | 2026-02 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | Summerhill Road, Bilston | Summerhill Road, Bilston | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 8423 | op-snap---monthly-publication-february-2026.pdf | 1170 | 2026-02 | Car | Land Rover | Velar | White | Driving without Due Care and Attention | None | On Warwickshire police | On Warwickshire police | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8420 | op-snap---monthly-publication-february-2026.pdf | 1167 | 2026-02 | Car | Land Rover | Sport | Black | VRM fails to conform to Regulations | None | Harborne Lane Island | Harborne Lane Island | Birmingham | Birmingham | Warning Letter | N/A | 52.4439777 | -1.9418736 | ||
| 8362 | op-snap---monthly-publication-february-2026.pdf | 1109 | 2026-02 | Car | Land Rover | Defender | Grey | Driving without Due Care and Attention | None | M5 near Glocester | M5 near Glocester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8216 | op-snap---monthly-publication-february-2026.pdf | 963 | 2026-02 | Car | Land Rover | Range | Black | Driving without Due Care and Attention | None | Henley on Thames | Henley on Thames | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8187 | op-snap---monthly-publication-february-2026.pdf | 934 | 2026-02 | Car | Land Rover | Autobio | Gold | Driving without Due Care and Attention | None | Lower Eggleton, Worcester | Lower Eggleton, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8146 | op-snap---monthly-publication-february-2026.pdf | 893 | 2026-02 | Car | Land Rover | range Rover | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830179 | -1.783876 | ||
| 8000 | op-snap---monthly-publication-february-2026.pdf | 747 | 2026-02 | Car | Land Rover | Range | Black | Driving without Due Care and Attention | None | Bridgnorth Road | Bridgnorth Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4758675 | -1.7882992 | ||
| 7932 | op-snap---monthly-publication-february-2026.pdf | 679 | 2026-02 | Car | Land Rover | Sport | Black | Driving without Due Care and Attention | None | Off force | Off force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7923 | op-snap---monthly-publication-february-2026.pdf | 670 | 2026-02 | Car | Land Rover | Discovery | Silver | Driving without Due Care and Attention | None | Holt, Worcester to Hallow | Holt, Worcester to Hallow | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7879 | op-snap---monthly-publication-february-2026.pdf | 626 | 2026-02 | Car | Land Rover | Evoque | Black | Driving without Due Care and Attention | None | Cannock Road | Cannock Road | Walsall | Walsall | Court | N/A | 52.610689 | -2.0405006 | ||
| 7860 | op-snap---monthly-publication-february-2026.pdf | 607 | 2026-02 | Car | Land Rover | Range | White | Using a Mobile Phone Whilst Driving | None | A19 | A19 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7855 | op-snap---monthly-publication-february-2026.pdf | 602 | 2026-02 | Car | Land Rover | Range Rover | Blue | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 7815 | op-snap---monthly-publication-february-2026.pdf | 562 | 2026-02 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Yardley Road | Yardley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4613544 | -1.8160137 | ||
| 7805 | op-snap---monthly-publication-february-2026.pdf | 552 | 2026-02 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Court | N/A | 52.4198291 | -1.9241732 | ||
| 7695 | op-snap---monthly-publication-february-2026.pdf | 442 | 2026-02 | Car | Land Rover | Evoque | Black | Driving without Due Care and Attention | None | M6 SB J19 | M6 Southbound J19 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7585 | op-snap---monthly-publication-february-2026.pdf | 332 | 2026-02 | Car | Land Rover | Land Rover | Blue | Contravening a Red Traffic Light | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Education | N/A | 52.4041117 | -1.5595662 | ||
| 7417 | op-snap---monthly-publication-february-2026.pdf | 164 | 2026-02 | Car | Land Rover | Range Rover | Brown | VRM fails to conform to Regulations | No Insurance | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4119174 | -1.9735247 | ||
| 7392 | op-snap---monthly-publication-february-2026.pdf | 139 | 2026-02 | Car | Land Rover | Range Rover | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Darwin Street | Darwin Street | Birmingham | Birmingham | Warning Letter | N/A | 52.468128 | -1.8848315 | ||
| 7371 | op-snap---monthly-publication-february-2026.pdf | 118 | 2026-02 | Car | Land Rover | Evoque | Beige | Contravening a Red Traffic Light | None | Venture Way | Venture Way | Dudley | Dudley | Education | N/A | 52.4836603 | -2.1189326 | ||
| 7331 | op-snap---monthly-publication-february-2026.pdf | 78 | 2026-02 | Car | Land Rover | Discovery | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Burnaby Road | Burnaby Road | Coventry | Coventry | Warning Letter | N/A | 52.4352 | -1.5194238 | ||
| 7273 | op-snap---monthly-publication-february-2026.pdf | 20 | 2026-02 | Car | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Footscray Road | Footscray Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7264 | op-snap---monthly-publication-february-2026.pdf | 11 | 2026-02 | Car | Land Rover | Discovery | Blue | Offence to be added | None | M6 | M6 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 11910 | op-snap---monthly-publication-january-2026.pdf | 1371 | 2026-01 | Car | Land Rover | evoque | Grey | Misc - Non Traffic Offences | None | plough and harrow road | Plough And Harrow Road | Halesowen | Halesowen | NFA | Misc Inc Crimes | 52.5899123 | -1.8057069 | ||
| 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 | ||
| 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 | ||
| 11897 | op-snap---monthly-publication-january-2026.pdf | 1358 | 2026-01 | Car | Land Rover | Discovery | White | Driving without Due Care and Attention | No Seat Belt | A4117 Callow Hill, between Ludlow and Kidderminster | Callow Hill, between Ludlow and Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11892 | op-snap---monthly-publication-january-2026.pdf | 1353 | 2026-01 | Car | Land Rover | Range Rover | Blue | Driving without Due Care and Attention | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6291998 | -2.126312 | ||
| 11827 | op-snap---monthly-publication-january-2026.pdf | 1288 | 2026-01 | Car | Land Rover | Disco | White | Stop a vehicle within pelican pedestrian crossing limits | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Education | N/A | 52.4967329 | -1.8097462 | ||
| 11733 | op-snap---monthly-publication-january-2026.pdf | 1194 | 2026-01 | Car | Land Rover | Defender | Black | Using a Mobile Phone Whilst Driving | None | M3 near Bracknell | M3 near Bracknell | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11638 | op-snap---monthly-publication-january-2026.pdf | 1099 | 2026-01 | Car | Land Rover | Land Rover | Red | Driving without Due Care and Attention | None | west mercia | West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5827653 | -2.0983246 | ||
| 11588 | op-snap---monthly-publication-january-2026.pdf | 1049 | 2026-01 | Car | Land Rover | Defender | Black | Driving without Due Care and Attention | None | Stivichall Highway | Stivichall Highway | Coventry | Coventry | Education | N/A | 52.3774003 | -1.493293 | ||
| 11548 | op-snap---monthly-publication-january-2026.pdf | 1009 | 2026-01 | Car | Land Rover | Evoque | White | Stop a vehicle within pelican pedestrian crossing limits | No Insurance | Bearwood Road | Bearwood Road | Sandwell | Sandwell | Court | N/A | 52.4725977 | -1.9684448 | ||
| 11526 | op-snap---monthly-publication-january-2026.pdf | 987 | 2026-01 | Car | Land Rover | Range Rover | grey | Contravening a Red Traffic Light | None | Union Road Solihull | Union Road Solihull | Solihull | Solihull | Fixed Penalty | N/A | 52.4044229 | -1.8141776 | ||
| 11331 | op-snap---monthly-publication-january-2026.pdf | 792 | 2026-01 | Car | Land Rover | Discovery | Grey | VRM fails to conform to Regulations | None | Birmingham New Road | Birmingham New Road | Dudley | Dudley | Fixed Penalty | N/A | 52.5478387 | -2.0943116 | ||
| 11211 | op-snap---monthly-publication-january-2026.pdf | 672 | 2026-01 | Car | Land Rover | Discovery | Red | Driving without Due Care and Attention | None | Binley Road | Binley Road | Coventry | Coventry | Education | N/A | 52.4070602 | -1.4732469 | ||
| 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 | ||
| 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 | ||||
| 11064 | op-snap---monthly-publication-january-2026.pdf | 525 | 2026-01 | Car | Land Rover | Range | Blue | Driving without Due Care and Attention | None | Charles Road | Charles Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5094492 | -1.9113648 | ||
| 10904 | op-snap---monthly-publication-january-2026.pdf | 365 | 2026-01 | Car | Land Rover | Land Rover | Black | Vehicle overtake within crossing limits | None | Highfield Road | Highfield Road | Birmingham | Birmingham | Education | N/A | 52.4216321 | -1.855984 | ||
| 10799 | op-snap---monthly-publication-january-2026.pdf | 260 | 2026-01 | Car | Land Rover | Velar | Blue | Driving without Due Care and Attention | None | Manor Way | Manor Way | Halesowen | Halesowen | Warning Letter | N/A | 52.5203602 | -1.824434 | ||
| 10790 | op-snap---monthly-publication-january-2026.pdf | 251 | 2026-01 | Car | Land Rover | Discovery | Black | Contravening a Red Traffic Light | None | Duncan Edwards Way | Duncan Edwards Way | Dudley | Dudley | NFA | No Independent Evidence Available | 52.5047428 | -2.0823754 | ||
| 10699 | op-snap---monthly-publication-january-2026.pdf | 160 | 2026-01 | Car | Land Rover | Range | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Education | N/A | 52.5919543 | -1.8517118 | ||
| 10663 | op-snap---monthly-publication-january-2026.pdf | 124 | 2026-01 | Car | Land Rover | defender | Green | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 10573 | op-snap---monthly-publication-january-2026.pdf | 34 | 2026-01 | Car | Land Rover | Discovery | Grey | Using a Mobile Phone Whilst Driving | None | A48 Gloucester | Gloucester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.405214 | -1.9708282 | ||
| 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 | ||
| 4952 | op-snap---monthly-publication-december-2025.pdf | 1080 | 2025-12 | Car | Land Rover | range rover | Black | Cause vehicle to be left in a dangerous position | None | Dawson Road | Dawson Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5048623 | -1.9349662 | ||
| 4870 | op-snap---monthly-publication-december-2025.pdf | 998 | 2025-12 | Car | Land Rover | defender | Grey | Driving without Due Care and Attention | None | Warwick | Warwick | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3813073 | -1.5639569 | ||
| 4853 | op-snap---monthly-publication-december-2025.pdf | 981 | 2025-12 | Car | Land Rover | Defender | Grey | Driving without Due Care and Attention | VRM fails to conform to Regu | Mlat5io jn4s | Mlat5io jn4s | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4836 | op-snap---monthly-publication-december-2025.pdf | 964 | 2025-12 | Car | Land Rover | Sport | Blue | Using a Mobile Phone Whilst Driving | No Insurance | M42, nothing more specific | M42, nothing more specific | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4646 | op-snap---monthly-publication-december-2025.pdf | 774 | 2025-12 | Car | Land Rover | Range | Black | Drive a vehicle other than on the carriageway of a motorway | None | M6 j6 | M6 j6 | Birmingham | Birmingham | Fixed Penalty | N/A | 52.676119 | -2.0858425 | ||
| 4635 | op-snap---monthly-publication-december-2025.pdf | 763 | 2025-12 | Car | Land Rover | Freelander | Gold | Driving without Due Care and Attention | None | Qeensway Telford | Qeensway Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4582 | op-snap---monthly-publication-december-2025.pdf | 710 | 2025-12 | Car | Land Rover | Evoque | Black | Contravening a Red Traffic Light | None | West Bromwich Interchange | West Bromwich Interchange | Sandwell | Sandwell | Warning Letter | N/A | 52.5109262 | -1.9753718 | ||
| 4548 | op-snap---monthly-publication-december-2025.pdf | 676 | 2025-12 | Car | Land Rover | Range Rover Sport | Grey | Contravening a Red Traffic Light | None | Tipton Road jn with Birmingham N | Tipton Road jn with Birmingham N | eDwud Rleoyad | Edwud Rleoyad | Fixed Penalty | N/A | ||||
| 4466 | op-snap---monthly-publication-december-2025.pdf | 594 | 2025-12 | Car | Land Rover | Defender | Brown | Vehicle overtake within crossing limits | None | Solihull lane | Solihull lane | Birmingham | Birmingham | Education | N/A | 52.4230862 | -1.8347873 | ||
| 4464 | op-snap---monthly-publication-december-2025.pdf | 592 | 2025-12 | Car | Land Rover | Range | Grey | Driving without Due Care and Attention | No Insurance | Garrision Lane | Garrision Lane | Birmingham | Birmingham | Other Action Taken | Misc Inc Crimes | ||||
| 4421 | op-snap---monthly-publication-december-2025.pdf | 549 | 2025-12 | Car | Land Rover | Evoque Dynamics | Black | Cause vehicle to be left in a dangerous position | None | Opposite Withymoor School Gayfi | Opposite Withymoor School Gayfi | eDldu dAlveey Brierley Hill | Edldu Dalveey Brierley Hill | Warning Letter | N/A | ||||
| 4383 | op-snap---monthly-publication-december-2025.pdf | 511 | 2025-12 | Car | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4308271 | -1.920078 | ||
| 4100 | op-snap---monthly-publication-december-2025.pdf | 228 | 2025-12 | Car | Land Rover | Discovery | Grey | Driving without Due Care and Attention | None | Heathcote Lane | Heathcote Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4000 | op-snap---monthly-publication-december-2025.pdf | 128 | 2025-12 | Car | Land Rover | Range Rover | Brown | Driving without Due Care and Attention | None | Goldieslie Road | Goldieslie Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5511935 | -1.8298782 | ||
| 3908 | op-snap---monthly-publication-december-2025.pdf | 36 | 2025-12 | Car | Land Rover | Sport | Black | Driving without Due Care and Attention | None | M6 South | M6 South | Sandwell | Sandwell | NFA | No VRM | 52.5228877 | -2.0650728 | ||
| 21957 | op-snap---monthly-publication-november-2025.pdf | 1499 | 2025-11 | Car | Land Rover | Discovery | Silver | Using a Mobile Phone Whilst Driving | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 | ||
| 21920 | op-snap---monthly-publication-november-2025.pdf | 1462 | 2025-11 | Car | Land Rover | Evoque | Brown | Contravening a Red Traffic Light | None | M54 J2 | M54 J2 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4945433 | -2.0190848 | ||
| 21668 | op-snap---monthly-publication-november-2025.pdf | 1210 | 2025-11 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Haslucks Green Road | Haslucks Green Road | Solihull | Solihull | Court | N/A | 52.4145149 | -1.8301272 | ||
| 21631 | op-snap---monthly-publication-november-2025.pdf | 1173 | 2025-11 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | Blackford Road | Blackford Road | Solihull | Solihull | Warning Letter | N/A | 52.3971653 | -1.8189489 | ||
| 21513 | op-snap---monthly-publication-november-2025.pdf | 1055 | 2025-11 | Car | Land Rover | Velar | Black | Misc - Non Traffic Offences | None | Ryemarket Car Park, Stourbridge | Ryemarket Car Park, Stourbridge | Dudley | Dudley | NFA | No Offence | ||||
| 21511 | op-snap---monthly-publication-november-2025.pdf | 1053 | 2025-11 | Car | Land Rover | Range | Grey | Using a Mobile Phone Whilst Driving | None | Highgate Road | Highgate Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4606652 | -1.8791145 | ||
| 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 | ||||
| 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 | ||
| 21368 | op-snap---monthly-publication-november-2025.pdf | 910 | 2025-11 | Car | Land Rover | Velar | Grey | Driving without Due Care and Attention | None | Montpellier Street | Montpellier Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.462686 | -1.8824475 | ||
| 21326 | op-snap---monthly-publication-november-2025.pdf | 868 | 2025-11 | Car | Land Rover | Land Rover | Black | Driving without Due Care and Attention | None | Billesley Lane | Billesley Lane | Birmingham | Birmingham | Court | N/A | 52.4344402 | -1.8845368 | ||
| 21253 | op-snap---monthly-publication-november-2025.pdf | 795 | 2025-11 | Car | Land Rover | Evoque | Grey | Driving without Due Care and Attention | None | Washford Drive | Washford Drive | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21085 | op-snap---monthly-publication-november-2025.pdf | 627 | 2025-11 | Car | Land Rover | discovery | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | White Farm Road | White Farm Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5965459 | -1.8476527 | ||
| 21044 | op-snap---monthly-publication-november-2025.pdf | 586 | 2025-11 | Car | Land Rover | discovery | White | Cause vehicle to be left in a dangerous position | None | pershore road | Pershore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4308271 | -1.920078 | ||
| 21036 | op-snap---monthly-publication-november-2025.pdf | 578 | 2025-11 | Car | Land Rover | Evoque | White | Stop a vehicle on pedestrian crossing | None | Lower Church Lane | Lower Church Lane | Dudley | Dudley | Warning Letter | N/A | 52.5264111 | -2.0472971 | ||
| 20921 | op-snap---monthly-publication-november-2025.pdf | 463 | 2025-11 | Car | Land Rover | Range Rover | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 20846 | op-snap---monthly-publication-november-2025.pdf | 388 | 2025-11 | Car | Land Rover | Discovery | Red | Driving without Due Care and Attention | None | A452 Collector | Collector | Birmingham | Birmingham | NFA | No Offence | 52.5139393 | -1.7600186 | ||
| 20719 | op-snap---monthly-publication-november-2025.pdf | 261 | 2025-11 | Car | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5458699 | -1.9304484 | ||
| 20486 | op-snap---monthly-publication-november-2025.pdf | 28 | 2025-11 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | Congleton | Congleton | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4408597 | -1.4953575 | ||
| 23744 | op-snap---monthly-publication-october-2025.pdf | 1694 | 2025-10 | Car | Land Rover | Evoque | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Willenhall Road | Willenhall Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5836778 | -2.0894997 | ||
| 23491 | op-snap---monthly-publication-october-2025.pdf | 1441 | 2025-10 | Car | Land Rover | Discovery | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.502683 | -1.9033516 | ||
| 23292 | op-snap---monthly-publication-october-2025.pdf | 1242 | 2025-10 | Car | Land Rover | discovery | Grey | Misc - Non Traffic Offences | None | hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | 52.4047807 | -2.0101216 | ||
| 23082 | op-snap---monthly-publication-october-2025.pdf | 1032 | 2025-10 | Car | Land Rover | Discovery | Silver | Contravening a Red Traffic Light | None | Castle Street, Hadley | Castle Street, Hadley | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22672 | op-snap---monthly-publication-october-2025.pdf | 622 | 2025-10 | Car | Land Rover | Defender | Black | Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway | None | M6 (S/B) Jn10a to Jn8 | M6 (Southbound) Jn10a to Jn8 | Walsall | Walsall | NFA | No Offence | ||||
| 22610 | op-snap---monthly-publication-october-2025.pdf | 560 | 2025-10 | Car | Land Rover | Range Rover | Black | Contravening a Red Traffic Light | None | Little Sutton Lane | Little Sutton Lane | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.584913 | -1.8197066 | ||
| 22566 | op-snap---monthly-publication-october-2025.pdf | 516 | 2025-10 | Car | Land Rover | Defender | Brown | Driving without Due Care and Attention | None | M6 motorway, junction 6 SB | M6 motorway, junction 6 Southbound | Birmingham | Birmingham | Court | N/A | ||||
| 22510 | op-snap---monthly-publication-october-2025.pdf | 460 | 2025-10 | Car | Land Rover | Vogue | Blue | Driving without Due Care and Attention | None | London Road / Gypsy Lane | London Road / Gypsy Lane | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5746321 | -1.7679076 | ||
| 22460 | op-snap---monthly-publication-october-2025.pdf | 410 | 2025-10 | Car | Land Rover | Sport | Black | Driving without Due Care and Attention | None | Collector Road | Collector Road | Birmingham | Birmingham | NFA | No Offence | 52.5139393 | -1.7600186 | ||
| 22421 | op-snap---monthly-publication-october-2025.pdf | 371 | 2025-10 | Car | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Warwick Highway, Redditch | Warwick Highway, Redditch | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22380 | op-snap---monthly-publication-october-2025.pdf | 330 | 2025-10 | Car | Land Rover | Range Rover | Grey | Contravening a Red Traffic Light | None | Holyhead Road Wednesbury | Holyhead Road Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | 52.5567885 | -2.035824 | ||
| 22359 | op-snap---monthly-publication-october-2025.pdf | 309 | 2025-10 | Car | Land Rover | Vogue | Brown | Driving without Due Care and Attention | None | M40 NB | M40 Northbound | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22349 | op-snap---monthly-publication-october-2025.pdf | 299 | 2025-10 | Car | Land Rover | Range Rover | Gold | Driving without Due Care and Attention | None | M6 Staffs | M6 Staffs | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6170728 | -2.030393 | ||
| 22214 | op-snap---monthly-publication-october-2025.pdf | 164 | 2025-10 | Car | Land Rover | Discovery | Red | Driving without Due Care and Attention | None | Mill Street, Evesham, | Mill Street, Evesham | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22197 | op-snap---monthly-publication-october-2025.pdf | 147 | 2025-10 | Car | Land Rover | Land Rover | Grey | Driving without Due Care and Attention | None | Old Snow Hill | Old Snow Hill | Birmingham | Birmingham | NFA | No Offence | 52.4858844 | -1.9003652 | ||
| 22183 | op-snap---monthly-publication-october-2025.pdf | 133 | 2025-10 | Car | Land Rover | Range Over | Black | Contravening a Red Traffic Light | None | A452 Collector Road | Collector Road | Birmingham | Birmingham | Education | N/A | 52.5139393 | -1.7600186 |
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);