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'}
265 rows where council_area = "Birmingham" and vehicle_make = "Land Rover" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
offence 24
- Driving without Due Care and Attention 54
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 50
- Using a Mobile Phone Whilst Driving 31
- Cause vehicle to be left in a dangerous position 29
- Contravening a Red Traffic Light 28
- Driving without Reasonable Consideration 13
- Misc - Non Traffic Offences 10
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 9
- Cause unnecessary obstruction by motor vehicle 8
- Stop a vehicle within pelican pedestrian crossing limits 6
- VRM fails to conform to Regulations 6
- Stop a vehicle on pedestrian crossing 4
- Motor vehicle fail to comply with a non endorsab 3
- Drive a vehicle other than on the carriageway of a motorway 2
- Driving a vehicle wholly or partly on a footpath 2
- Vehicle overtake within crossing limits 2
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 1
- CCaauussee uunnnneecceessssaarryy oobbssttrruuccttiioonn bbyy mmoottoorr vveehhiiccllee 1
- Drive a vehicle other than on the carriageway of a 1
- Drive on hard shoulder 1
- Fail to display front VRM plate 1
- No vehicle excise licence 1
- Offence to be added 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
month 14
reporter_transport_mode 6
- Car 124
- Pedestrian 86
- Pedal Bike 47
- Other 6
- Bus 1
- Lorry 1
disposal 6
- Warning Letter 82
- NFA 74
- Fixed Penalty 60
- Education 33
- Court 15
- Other Action Taken 1
vehicle_make 1
- Land Rover · 265 ✖
council_area 1
- Birmingham · 265 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | ||
| 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 | ||
| 7548 | op-snap---monthly-publication-february-2026.pdf | 295 | 2026-02 | Pedal Bike | Land Rover | Range Rover | Black | Using a Mobile Phone Whilst Driving | No Insurance | Five ways Island | Five ways Island | Birmingham | Birmingham | Court | N/A | ||||
| 7682 | op-snap---monthly-publication-february-2026.pdf | 429 | 2026-02 | Pedal Bike | Land Rover | Discovery | Brown | Driving without Due Care and Attention | None | Redhill Road | Redhill Road | Birmingham | Birmingham | Education | N/A | 52.4618364 | -1.8328803 | ||
| 7715 | op-snap---monthly-publication-february-2026.pdf | 462 | 2026-02 | Pedestrian | Land Rover | Discovery | Green | Cause vehicle to be left in a dangerous position | None | Beech Road | Beech Road | Birmingham | Birmingham | Education | N/A | 52.5393906 | -1.8446767 | ||
| 7780 | op-snap---monthly-publication-february-2026.pdf | 527 | 2026-02 | Pedestrian | Land Rover | Range Rover | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Berwood Road | Berwood Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5342947 | -1.8155375 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 7945 | op-snap---monthly-publication-february-2026.pdf | 692 | 2026-02 | Pedestrian | Land Rover | Discovery | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Education | N/A | 52.436035 | -1.891685 | ||
| 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 | ||
| 8324 | op-snap---monthly-publication-february-2026.pdf | 1071 | 2026-02 | Pedestrian | Land Rover | Range | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cubley Road | Cubley Road | Birmingham | Birmingham | NFA | No Offence | 52.43878 | -1.8509412 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 8830 | op-snap---monthly-publication-february-2026.pdf | 1577 | 2026-02 | Pedestrian | Land Rover | Black | Fail to display front VRM plate | None | edgbaston road | Edgbaston Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4552785 | -1.906384 | |||
| 8876 | op-snap---monthly-publication-february-2026.pdf | 1623 | 2026-02 | Pedestrian | Land Rover | Range Rover | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | rotten park road | Rotten Park Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 10724 | op-snap---monthly-publication-january-2026.pdf | 185 | 2026-01 | Pedestrian | Land Rover | Discovery | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chilcote Close | Chilcote Close | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4167178 | -1.8457291 | ||
| 10771 | op-snap---monthly-publication-january-2026.pdf | 232 | 2026-01 | Other | Land Rover | Discovery | Green | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Chantry Road, Moseley | Chantry Road, Moseley | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4496376 | -1.8915224 | ||
| 10794 | op-snap---monthly-publication-january-2026.pdf | 255 | 2026-01 | Pedestrian | Land Rover | R Rover SPort | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Rd | Rotten Park Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 10908 | op-snap---monthly-publication-january-2026.pdf | 369 | 2026-01 | Pedestrian | Land Rover | Evoque | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Morville Street | Morville Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4771765 | -1.9197019 | ||
| 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 | ||
| 11362 | op-snap---monthly-publication-january-2026.pdf | 823 | 2026-01 | Pedestrian | Land Rover | Land Rover | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Portman Road | Portman Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4306424 | -1.8844833 | ||
| 11538 | op-snap---monthly-publication-january-2026.pdf | 999 | 2026-01 | Pedestrian | Land Rover | Land Rover | Black | Cause vehicle to be left in a dangerous position | None | Woodbridge Road | Woodbridge Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4482076 | -1.8864335 | ||
| 11793 | op-snap---monthly-publication-january-2026.pdf | 1254 | 2026-01 | Pedestrian | Land Rover | Discovery | Green | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Beech Road | Beech Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5393906 | -1.8446767 | ||
| 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 | ||
| 11884 | op-snap---monthly-publication-january-2026.pdf | 1345 | 2026-01 | Pedal Bike | Land Rover | Range Rover | Black | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 3971 | op-snap---monthly-publication-december-2025.pdf | 99 | 2025-12 | Pedestrian | Land Rover | discovery | White | Misc - Non Traffic Offences | None | chilcote close | Chilcote Close | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4167178 | -1.8457291 | ||
| 4011 | op-snap---monthly-publication-december-2025.pdf | 139 | 2025-12 | Pedal Bike | Land Rover | Velar | Black | Driving without Due Care and Attention | None | High Street, Deritend | High Street, Deritend | Birmingham | Birmingham | Warning Letter | N/A | 52.4746492 | -1.8839977 | ||
| 4126 | op-snap---monthly-publication-december-2025.pdf | 254 | 2025-12 | Pedestrian | Land Rover | Discovery | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chilcote Close | Chilcote Close | Birmingham | Birmingham | NFA | No Offence | 52.4167178 | -1.8457291 | ||
| 4187 | op-snap---monthly-publication-december-2025.pdf | 315 | 2025-12 | Other | Land Rover | SE | Black | Using a Mobile Phone Whilst Driving | Use vehicle on a road withou | tB viramlidin tgehsat mcertificate | t B viramlidin tgehsat mcertificate | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4207 | op-snap---monthly-publication-december-2025.pdf | 335 | 2025-12 | Pedestrian | Land Rover | Range Rover | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grove Road | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 4212 | op-snap---monthly-publication-december-2025.pdf | 340 | 2025-12 | Pedestrian | Land Rover | Range Rover | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Old ROad | Moseley Old ROad | Birmingham | Birmingham | NFA | Duplicate Submission | ||||
| 4220 | op-snap---monthly-publication-december-2025.pdf | 348 | 2025-12 | Pedestrian | Land Rover | Sport | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville drive | Glenville drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 4299 | op-snap---monthly-publication-december-2025.pdf | 427 | 2025-12 | Pedestrian | Land Rover | range rover | Black | Cause vehicle to be left in a dangerous position | None | barclay road | Barclay Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 20530 | op-snap---monthly-publication-november-2025.pdf | 72 | 2025-11 | Pedal Bike | Land Rover | Discovery | Black | Using a Mobile Phone Whilst Driving | None | New Fosse Way | New Fosse Way | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4473373 | -1.9392405 | ||
| 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 | ||
| 20785 | op-snap---monthly-publication-november-2025.pdf | 327 | 2025-11 | Pedal Bike | Land Rover | Freelander | Silver | Using a Mobile Phone Whilst Driving | None | Black Haynes Road | Black Haynes Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4260755 | -1.9679443 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 21239 | op-snap---monthly-publication-november-2025.pdf | 781 | 2025-11 | Pedal Bike | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | Frankley Beeches Road | Frankley Beeches Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4094108 | -1.9930633 | ||
| 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 | ||
| 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 | ||
| 21428 | op-snap---monthly-publication-november-2025.pdf | 970 | 2025-11 | Pedestrian | Land Rover | range rover | Black | Cause vehicle to be left in a dangerous position | None | barclay road | Barclay Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 21534 | op-snap---monthly-publication-november-2025.pdf | 1076 | 2025-11 | Pedestrian | Land Rover | Defender | Green | Driving a vehicle wholly or partly on a footpath | None | Kings Heath High Street, Alcester Road | Kings Heath High Street, Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 21606 | op-snap---monthly-publication-november-2025.pdf | 1148 | 2025-11 | Pedestrian | Land Rover | Black | Misc - Non Traffic Offences | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | |||
| 21864 | op-snap---monthly-publication-november-2025.pdf | 1406 | 2025-11 | Pedal Bike | Land Rover | Discovery | Black | Using a Mobile Phone Whilst Driving | None | High Street, Harborne | High Street, Harborne | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4612733 | -1.9430543 | ||
| 21868 | op-snap---monthly-publication-november-2025.pdf | 1410 | 2025-11 | Pedestrian | Land Rover | velar | Blue | Driving without Due Care and Attention | None | regent place | Regent Place | Birmingham | Birmingham | Education | N/A | 52.4860376 | -1.9095854 | ||
| 21869 | op-snap---monthly-publication-november-2025.pdf | 1411 | 2025-11 | Pedestrian | Land Rover | range rover | Black | Cause vehicle to be left in a dangerous position | None | colmore road | Colmore Road | Birmingham | Birmingham | Education | N/A | 52.4296373 | -1.8993161 | ||
| 21893 | op-snap---monthly-publication-november-2025.pdf | 1435 | 2025-11 | Pedestrian | Land Rover | White | Misc - Non Traffic Offences | None | greenwood clsoe | Greenwood Clsoe | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||
| 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 | ||
| 22094 | op-snap---monthly-publication-october-2025.pdf | 44 | 2025-10 | Pedal Bike | Land Rover | Range Rover | Grey | Using a Mobile Phone Whilst Driving | None | Bath Row | Bath Row | Birmingham | Birmingham | Fixed Penalty | N/A | 52.472238 | -1.9127983 | ||
| 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 | ||
| 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 | ||
| 22429 | op-snap---monthly-publication-october-2025.pdf | 379 | 2025-10 | Pedal Bike | Land Rover | Range Rover | Black | Using a Mobile Phone Whilst Driving | None | Harborne High Street | Harborne High Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.459563 | -1.946922 | ||
| 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 | ||
| 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 | ||||
| 22590 | op-snap---monthly-publication-october-2025.pdf | 540 | 2025-10 | Pedal Bike | Land Rover | Evoque | Black | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 22674 | op-snap---monthly-publication-october-2025.pdf | 624 | 2025-10 | Pedal Bike | Land Rover | Land Rover | Black | Driving without Due Care and Attention | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | NFA | No Offence | 52.4103191 | -1.8670224 | ||
| 22731 | op-snap---monthly-publication-october-2025.pdf | 681 | 2025-10 | Pedal Bike | Land Rover | Range Rover | White | Driving without Due Care and Attention | None | Park Way | Park Way | Birmingham | Birmingham | Education | N/A | 52.3990593 | -2.0053459 | ||
| 23103 | op-snap---monthly-publication-october-2025.pdf | 1053 | 2025-10 | Pedestrian | Land Rover | range rover | Black | Cause vehicle to be left in a dangerous position | None | Heath field road | Heath field road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 23549 | op-snap---monthly-publication-october-2025.pdf | 1499 | 2025-10 | Pedestrian | Land Rover | Freelander | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | ||
| 23818 | op-snap---monthly-publication-september-2025.pdf | 37 | 2025-09 | Car | Land Rover | Evoque | White | Contravening a Red Traffic Light | None | Spitfire Island | Spitfire Island | Birmingham | Birmingham | Education | N/A | 52.5138106 | -1.797297 | ||
| 23867 | op-snap---monthly-publication-september-2025.pdf | 86 | 2025-09 | Pedal Bike | Land Rover | Sport | Grey | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 23948 | op-snap---monthly-publication-september-2025.pdf | 167 | 2025-09 | Car | Land Rover | Sport | Grey | Drive a vehicle other than on the carriageway of a | motorway None | M6 Motorway, Southbound. Jn 7A | M6 Motorway, Southbound. Junction 7A | Birmingham | Birmingham | Education | N/A | ||||
| 23957 | op-snap---monthly-publication-september-2025.pdf | 176 | 2025-09 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Bradford Road | Bradford Road | Birmingham | Birmingham | NFA | No Offence | 52.5024148 | -1.7961753 | ||
| 24034 | op-snap---monthly-publication-september-2025.pdf | 253 | 2025-09 | Car | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Court | N/A | 52.4967329 | -1.8097462 | ||
| 24038 | op-snap---monthly-publication-september-2025.pdf | 257 | 2025-09 | Car | Land Rover | Defender | Black | Using a Mobile Phone Whilst Driving | None | M6?? | M6?? | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5264754 | -1.8895798 | ||
| 24071 | op-snap---monthly-publication-september-2025.pdf | 290 | 2025-09 | Car | Land Rover | Range Rover | Black | Contravening a Red Traffic Light | None | Stockfield Road | Stockfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4519414 | -1.831688 | ||
| 24092 | op-snap---monthly-publication-september-2025.pdf | 311 | 2025-09 | Other | Land Rover | Discovery | Black | Misc - Non Traffic Offences | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4552055 | -1.9461279 | ||
| 24136 | op-snap---monthly-publication-september-2025.pdf | 355 | 2025-09 | Car | Land Rover | Sport | Black | Contravening a Red Traffic Light | None | Bridle Lane | Bridle Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 24175 | op-snap---monthly-publication-september-2025.pdf | 394 | 2025-09 | Car | Land Rover | Evoque | Blue | Driving without Due Care and Attention | None | A38 (M) Southbound | A38 (M) Southbound | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 24306 | op-snap---monthly-publication-september-2025.pdf | 525 | 2025-09 | Car | Land Rover | Range Rover | Grey | Contravening a Red Traffic Light | None | Victoria Road | Victoria Road | Birmingham | Birmingham | NFA | No Offence | 52.5615573 | -1.820549 | ||
| 24390 | op-snap---monthly-publication-september-2025.pdf | 609 | 2025-09 | Car | Land Rover | Discovery | Blue | Misc - Non Traffic Offences | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | NFA | No Offence | 52.470423 | -1.9304786 | ||
| 24567 | op-snap---monthly-publication-september-2025.pdf | 786 | 2025-09 | Pedal Bike | Land Rover | Range Rover | Grey | Using a Mobile Phone Whilst Driving | None | Harbourne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 24593 | op-snap---monthly-publication-september-2025.pdf | 812 | 2025-09 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 24715 | op-snap---monthly-publication-september-2025.pdf | 934 | 2025-09 | Car | Land Rover | Freelander | Black | Driving without Due Care and Attention | None | SWmall heath Bridge | SWmall heath Bridge | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 24737 | op-snap---monthly-publication-september-2025.pdf | 956 | 2025-09 | Car | Land Rover | Freelander | Blue | Driving without Due Care and Attention | No Insurance | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4470686 | -1.8880749 | ||
| 24814 | op-snap---monthly-publication-september-2025.pdf | 1033 | 2025-09 | Car | Land Rover | Defender | Black | Contravening a Red Traffic Light | None | Longbridge High Street | Longbridge High Street | Birmingham | Birmingham | Education | N/A | ||||
| 24945 | op-snap---monthly-publication-september-2025.pdf | 1164 | 2025-09 | Pedal Bike | Land Rover | Discovery | Grey | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | ||
| 25085 | op-snap---monthly-publication-september-2025.pdf | 1304 | 2025-09 | Car | Land Rover | Ranger rover | White | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 25086 | op-snap---monthly-publication-september-2025.pdf | 1305 | 2025-09 | Car | Land Rover | Range Rover | Blue | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Lozells road | Lozells road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 25131 | op-snap---monthly-publication-september-2025.pdf | 1350 | 2025-09 | Car | Land Rover | Disovery | Grey | Motor vehicle fail to comply with a non endorsab | le traffic sign - detectedN boyn meeans other than ACD | Harbourne road | Harbourne road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 25152 | op-snap---monthly-publication-september-2025.pdf | 1371 | 2025-09 | Pedestrian | Land Rover | Discovery | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Alexander road | Alexander road | Birmingham | Birmingham | Warning Letter | N/A | 52.4524008 | -1.8262343 | ||
| 25153 | op-snap---monthly-publication-september-2025.pdf | 1372 | 2025-09 | Pedestrian | Land Rover | evoque | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Charingworth road | Charingworth road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 25249 | op-snap---monthly-publication-september-2025.pdf | 1468 | 2025-09 | Pedestrian | Land Rover | Range Rover | Gold | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Glenville Road | Glenville Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 25306 | op-snap---monthly-publication-september-2025.pdf | 1525 | 2025-09 | Car | Land Rover | Discovery | Grey | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Whittington Oval | Whittington Oval | Birmingham | Birmingham | Warning Letter | N/A | 52.4800782 | -1.7942034 | ||
| 25382 | op-snap---monthly-publication-september-2025.pdf | 1601 | 2025-09 | Pedestrian | Land Rover | freelander | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | cotteridge | Cotteridge | Birmingham | Birmingham | Warning Letter | N/A | 52.4162405 | -1.9315079 | ||
| 25398 | op-snap---monthly-publication-september-2025.pdf | 1617 | 2025-09 | Pedestrian | Land Rover | Range Rover | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Pitmaston Rd | Pitmaston Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4254701 | -1.8322218 |
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);