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'}
404 rows where council_area = "Birmingham", disposal = "NFA" and vehicle_make = "Ford" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
offence 28
- Driving without Due Care and Attention 95
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 63
- Contravening a Red Traffic Light 63
- Cause vehicle to be left in a dangerous position 42
- Misc - Non Traffic Offences 38
- Driving without Reasonable Consideration 31
- Using a Mobile Phone Whilst Driving 19
- Stop a vehicle within pelican pedestrian crossing limits 17
- Stop a vehicle on pedestrian crossing 9
- Motor vehicle fail to comply with a non endorsab 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- Driving a vehicle wholly or partly on a footpath 2
- Fail to Conform to Cycle Lane 2
- Motor vehicle fail to accord precedence at a pelican crossing 2
- No Seat Belt 2
- / trailer outside of the Greater London area 1
- Cause unnecessary obstruction by motor vehicle 1
- Contravene Lane Closure Red X 1
- Duplicate Submission 1
- Fail to display front VRM plate 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
- Motor vehicle fail to comply with solid white line road markings 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
- Use vehicle on a road without valid test certificate 1
- driving without due care/attention 1
month 14
reporter_transport_mode 7
- Car 223
- Pedestrian 104
- Pedal Bike 53
- Other 18
- Lorry 3
- Motorbike 2
- Van 1
vehicle_make 1
- Ford · 404 ✖
disposal 1
- NFA · 404 ✖
council_area 1
- Birmingham · 404 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7406 | op-snap---monthly-publication-february-2026.pdf | 153 | 2026-02 | Pedestrian | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Offence | 52.4470686 | -1.8880749 | ||
| 7469 | op-snap---monthly-publication-february-2026.pdf | 216 | 2026-02 | Pedestrian | Ford | C Maxx | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 7511 | op-snap---monthly-publication-february-2026.pdf | 258 | 2026-02 | Pedestrian | Ford | Tourneo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cubley Road | Cubley Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.43878 | -1.8509412 | ||
| 7530 | op-snap---monthly-publication-february-2026.pdf | 277 | 2026-02 | Pedestrian | Ford | Fiesta | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Yardley Green Road | Yardley Green Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4764154 | -1.8311418 | ||
| 7914 | op-snap---monthly-publication-february-2026.pdf | 661 | 2026-02 | Pedestrian | Ford | Focus | Black | Driving without Due Care and Attention | None | Wedgewood Road | Wedgewood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4560365 | -1.9936623 | ||
| 7940 | op-snap---monthly-publication-february-2026.pdf | 687 | 2026-02 | Other | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Longbridge | Longbridge | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.3940521 | -1.9807506 | ||
| 8127 | op-snap---monthly-publication-february-2026.pdf | 874 | 2026-02 | Pedestrian | Ford | Tourneo | 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 | ||
| 8164 | op-snap---monthly-publication-february-2026.pdf | 911 | 2026-02 | Car | Ford | Fiesta | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | No Offence | 52.502683 | -1.9033516 | ||
| 8317 | op-snap---monthly-publication-february-2026.pdf | 1064 | 2026-02 | Other | Ford | Transit | White | Driving a vehicle wholly or partly on a footpath | None | Highters Heath Lane. | Highters Heath Lane | Birmingham | Birmingham | NFA | No VRM | 52.4100972 | -1.8742772 | ||
| 8356 | op-snap---monthly-publication-february-2026.pdf | 1103 | 2026-02 | Other | Ford | Fiesta | Blue | Misc - Non Traffic Offences | None | Star City | Star City | Birmingham | Birmingham | NFA | No Offence | 52.5054363 | -1.8556273 | ||
| 8455 | op-snap---monthly-publication-february-2026.pdf | 1202 | 2026-02 | Car | Ford | Transit | White | Contravene Lane Closure Red X | None | M6 | M6 | Birmingham | Birmingham | NFA | No Offence | ||||
| 8882 | op-snap---monthly-publication-february-2026.pdf | 1629 | 2026-02 | Car | Ford | mondeo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath | Washwood Heath | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4957234 | -1.8538937 | ||
| 10589 | op-snap---monthly-publication-january-2026.pdf | 50 | 2026-01 | Van | Ford | transit | White | Misc - Non Traffic Offences | None | m42 NB airport | m42 Northbound airport | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 10637 | op-snap---monthly-publication-january-2026.pdf | 98 | 2026-01 | Car | Ford | Ranger | White | Driving without Due Care and Attention | None | Collector Road | Collector Road | Birmingham | Birmingham | NFA | No Offence | 52.5139393 | -1.7600186 | ||
| 10668 | op-snap---monthly-publication-january-2026.pdf | 129 | 2026-01 | Car | Ford | Ranger | Black | Driving without Due Care and Attention | None | Royal Road | Royal Road | Birmingham | Birmingham | NFA | No Offence | 52.5609478 | -1.8170275 | ||
| 10679 | op-snap---monthly-publication-january-2026.pdf | 140 | 2026-01 | Car | Ford | Focus | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 10739 | op-snap---monthly-publication-january-2026.pdf | 200 | 2026-01 | Car | Ford | Fiesta | Red | Using a Mobile Phone Whilst Driving | None | Boardsley Middleway | Boardsley Middleway | Birmingham | Birmingham | NFA | No VRM | ||||
| 10814 | op-snap---monthly-publication-january-2026.pdf | 275 | 2026-01 | Car | Ford | Ranger | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road, Handsworth | Island Road, Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.509612 | -1.9513666 | ||
| 10965 | op-snap---monthly-publication-january-2026.pdf | 426 | 2026-01 | Car | Ford | Fiesta | Grey | Stop a vehicle within pelican pedestrian crossing limits | No Insurance | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 11154 | op-snap---monthly-publication-january-2026.pdf | 615 | 2026-01 | Pedestrian | Ford | Mondeo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Nursery Road | Nursery Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4979836 | -1.9118163 | ||
| 11158 | op-snap---monthly-publication-january-2026.pdf | 619 | 2026-01 | Pedestrian | Ford | B-max | Blue | Cause vehicle to be left in a dangerous position | None | Nursery Road, Hockley | Nursery Road, Hockley | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5008517 | -1.9238292 | ||
| 11257 | op-snap---monthly-publication-january-2026.pdf | 718 | 2026-01 | Pedestrian | Ford | Focus | Blue | Misc - Non Traffic Offences | None | Freer Road | Freer Road | Birmingham | Birmingham | NFA | No Offence | 52.5074462 | -1.8979307 | ||
| 11276 | op-snap---monthly-publication-january-2026.pdf | 737 | 2026-01 | Car | Ford | Fiesta | Black | Using a Mobile Phone Whilst Driving | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4860376 | -1.9095854 | ||
| 11316 | op-snap---monthly-publication-january-2026.pdf | 777 | 2026-01 | Car | Ford | Transit 350 | White | Using a Mobile Phone Whilst Driving | None | Graham St | Graham Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4843802 | -1.9108415 | ||
| 11343 | op-snap---monthly-publication-january-2026.pdf | 804 | 2026-01 | Pedestrian | Ford | Fiesta | Blue | Cause vehicle to be left in a dangerous position | None | Hobmoor Road | Hobmoor Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4709249 | -1.8295416 | ||
| 11655 | op-snap---monthly-publication-january-2026.pdf | 1116 | 2026-01 | Car | Ford | Ka | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Vauxhall Road | Vauxhall Road | Birmingham | Birmingham | NFA | No Offence | 52.4834623 | -1.8796522 | ||
| 11659 | op-snap---monthly-publication-january-2026.pdf | 1120 | 2026-01 | Other | Ford | transit | White | Stop a vehicle within pelican pedestrian crossing limits | none | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | ||
| 11727 | op-snap---monthly-publication-january-2026.pdf | 1188 | 2026-01 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Heartlands Parkway | Heartlands Parkway | Birmingham | Birmingham | NFA | No Offence | 52.5038363 | -1.8432663 | ||
| 11855 | op-snap---monthly-publication-january-2026.pdf | 1316 | 2026-01 | Pedestrian | Ford | Toureno | 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 | ||
| 11859 | op-snap---monthly-publication-january-2026.pdf | 1320 | 2026-01 | Other | Ford | Transit | White | Contravening a Red Traffic Light | None | Avenue road | Avenue road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4941712 | -1.8795158 | ||
| 11902 | op-snap---monthly-publication-january-2026.pdf | 1363 | 2026-01 | Other | Ford | Transit | Grey | Misc - Non Traffic Offences | None | ladywood | Ladywood | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4774932 | -1.9233654 | ||
| 11941 | op-snap---monthly-publication-january-2026.pdf | 1402 | 2026-01 | Car | Ford | focus | Grey | Misc - Non Traffic Offences | None | eddish road | Eddish Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4833672 | -1.7871439 | ||
| 4098 | op-snap---monthly-publication-december-2025.pdf | 226 | 2025-12 | Car | Ford | Ranger | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | ||
| 4128 | op-snap---monthly-publication-december-2025.pdf | 256 | 2025-12 | Pedestrian | Ford | S Max | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | NFA | No Offence | 52.4700545 | -1.834436 | ||
| 4167 | op-snap---monthly-publication-december-2025.pdf | 295 | 2025-12 | Car | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Bordsley Circus Roundabout | Bordsley Circus Roundabout | Birmingham | Birmingham | NFA | No Offence | ||||
| 4171 | op-snap---monthly-publication-december-2025.pdf | 299 | 2025-12 | Car | Ford | Transit | White | 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 | ||
| 4178 | op-snap---monthly-publication-december-2025.pdf | 306 | 2025-12 | Other | Ford | focus | Black | Misc - Non Traffic Offences | None | Arundel Road | Arundel Road | Birmingham | Birmingham | NFA | No Offence | 52.4032204 | -1.8821733 | ||
| 4240 | op-snap---monthly-publication-december-2025.pdf | 368 | 2025-12 | Pedestrian | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodville Road | Woodville Road | Birmingham | Birmingham | NFA | No Offence | 52.4616763 | -1.9653016 | ||
| 4371 | op-snap---monthly-publication-december-2025.pdf | 499 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | hunters road | Hunters Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5011362 | -1.9175837 | ||
| 4487 | op-snap---monthly-publication-december-2025.pdf | 615 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | ||
| 4490 | op-snap---monthly-publication-december-2025.pdf | 618 | 2025-12 | Pedestrian | Ford | transit | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | ||
| 4772 | op-snap---monthly-publication-december-2025.pdf | 900 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Bordesley Green Road | Bordesley Green Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4804926 | -1.8563658 | ||
| 4817 | op-snap---monthly-publication-december-2025.pdf | 945 | 2025-12 | Pedal Bike | Ford | Focus | Black | Misc - Non Traffic Offences | Driving without Due Care and | M Atatsesnhtoiounse Lane, Kings Norton | M Atatsesnhtoiounse Lane, Kings Norton | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 4845 | op-snap---monthly-publication-december-2025.pdf | 973 | 2025-12 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Perry barr | Perry barr | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.516903 | -1.9012399 | ||
| 4931 | op-snap---monthly-publication-december-2025.pdf | 1059 | 2025-12 | Car | Ford | Fiesta | Black | Using a Mobile Phone Whilst Driving | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4726661 | -1.8769032 | ||
| 4945 | op-snap---monthly-publication-december-2025.pdf | 1073 | 2025-12 | Pedestrian | Ford | transit | White | Misc - Non Traffic Offences | None | outmore road | Outmore Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4767211 | -1.7814678 | ||
| 5003 | op-snap---monthly-publication-december-2025.pdf | 1131 | 2025-12 | Car | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath | Washwood Heath | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4957234 | -1.8538937 | ||
| 5030 | op-snap---monthly-publication-december-2025.pdf | 1158 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | ||
| 5039 | op-snap---monthly-publication-december-2025.pdf | 1167 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | bunbury road | Bunbury Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4142089 | -1.9587147 | ||
| 20708 | op-snap---monthly-publication-november-2025.pdf | 250 | 2025-11 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4391028 | -1.893289 | ||
| 20739 | op-snap---monthly-publication-november-2025.pdf | 281 | 2025-11 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | Oxhill Road Handsworth | Oxhill Road Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.513857 | -1.9367367 | ||
| 20795 | op-snap---monthly-publication-november-2025.pdf | 337 | 2025-11 | Car | Ford | Ranger | Blue | Driving without Due Care and Attention | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.5274116 | -1.9287273 | ||
| 20847 | op-snap---monthly-publication-november-2025.pdf | 389 | 2025-11 | Car | Ford | Mondeo | Black | Driving without Due Care and Attention | None | A452 | A452 | Birmingham | Birmingham | NFA | No Offence | ||||
| 20862 | op-snap---monthly-publication-november-2025.pdf | 404 | 2025-11 | Car | Ford | cmax | Black | Misc - Non Traffic Offences | None | gilpin close | Gilpin Close | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4990396 | -1.8229018 | ||
| 20908 | op-snap---monthly-publication-november-2025.pdf | 450 | 2025-11 | Pedestrian | Ford | Fiesta | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holly Lane | Holly Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5236889 | -1.8253311 | ||
| 21062 | op-snap---monthly-publication-november-2025.pdf | 604 | 2025-11 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No VRM | 52.471632 | -1.9456776 | ||
| 21287 | op-snap---monthly-publication-november-2025.pdf | 829 | 2025-11 | Pedestrian | Ford | fiesta | Silver | Misc - Non Traffic Offences | None | sir hiltons road | Sir Hiltons Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.3932637 | -1.9575554 | ||
| 21311 | op-snap---monthly-publication-november-2025.pdf | 853 | 2025-11 | Car | Ford | toureno | Blue | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 21340 | op-snap---monthly-publication-november-2025.pdf | 882 | 2025-11 | Pedestrian | Ford | transit | White | Misc - Non Traffic Offences | None | handsworth road | Handsworth Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5137414 | -1.9222827 | ||
| 21398 | op-snap---monthly-publication-november-2025.pdf | 940 | 2025-11 | Car | Ford | explorer | Blue | Misc - Non Traffic Offences | None | titford road | Titford Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21414 | op-snap---monthly-publication-november-2025.pdf | 956 | 2025-11 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.513336 | -1.8833226 | ||
| 21435 | op-snap---monthly-publication-november-2025.pdf | 977 | 2025-11 | Car | Ford | Fiesta | Black | Misc - Non Traffic Offences | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | No Offence | 52.5919543 | -1.8517118 | ||
| 21501 | op-snap---monthly-publication-november-2025.pdf | 1043 | 2025-11 | Car | Ford | cmax | White | Cause vehicle to be left in a dangerous position | None | witton road | Witton Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.513336 | -1.8833226 | ||
| 21514 | op-snap---monthly-publication-november-2025.pdf | 1056 | 2025-11 | Car | Ford | Focus | Silver | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5359496 | -1.8324115 | ||
| 21710 | op-snap---monthly-publication-november-2025.pdf | 1252 | 2025-11 | Car | Ford | Puma | Grey | Driving without Due Care and Attention | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | NFA | No Offence | 52.5170745 | -1.9012542 | ||
| 22003 | op-snap---monthly-publication-november-2025.pdf | 1545 | 2025-11 | Pedal Bike | Ford | Brown | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4708802 | -1.8792135 | |||
| 22115 | op-snap---monthly-publication-october-2025.pdf | 65 | 2025-10 | Car | Ford | Transit | Silver | Driving without Due Care and Attention | None | Bickenhill Lane | Bickenhill Lane | Birmingham | Birmingham | NFA | No Offence | ||||
| 22116 | op-snap---monthly-publication-october-2025.pdf | 66 | 2025-10 | Car | Ford | Transit | Silver | Driving without Due Care and Attention | None | Bickenhill Lane | Bickenhill Lane | Birmingham | Birmingham | NFA | No Offence | ||||
| 22168 | op-snap---monthly-publication-october-2025.pdf | 118 | 2025-10 | Car | Ford | Focus | Red | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | ||
| 22249 | op-snap---monthly-publication-october-2025.pdf | 199 | 2025-10 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4543565 | -1.9114004 | ||
| 22274 | op-snap---monthly-publication-october-2025.pdf | 224 | 2025-10 | Car | Ford | Fiesta | Blue | Motor vehicle fail to accord precedence at a pelican crossing | None | UK | Uk | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.45124 | -1.937937 | ||
| 22281 | op-snap---monthly-publication-october-2025.pdf | 231 | 2025-10 | Other | Ford | Kuga | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hugh Road | Hugh Road | Birmingham | Birmingham | NFA | No Offence | 52.4724029 | -1.8527024 | ||
| 22288 | op-snap---monthly-publication-october-2025.pdf | 238 | 2025-10 | Car | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.471632 | -1.9456776 | ||
| 22303 | op-snap---monthly-publication-october-2025.pdf | 253 | 2025-10 | Lorry | Ford | Transit | White | Contravening a Red Traffic Light | None | Cole Hall Lane | Cole Hall Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4877244 | -1.787883 | ||
| 22309 | op-snap---monthly-publication-october-2025.pdf | 259 | 2025-10 | Car | Ford | Transit | Silver | Driving without Due Care and Attention | None | Winson Green Road | Winson Green Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4870332 | -1.9373713 | ||
| 22330 | op-snap---monthly-publication-october-2025.pdf | 280 | 2025-10 | Car | Ford | KA.. | Red | Driving without Due Care and Attention | None | Berkeley Road East | Berkeley Road East | Birmingham | Birmingham | NFA | No Offence | 52.4658801 | -1.8290005 | ||
| 22342 | op-snap---monthly-publication-october-2025.pdf | 292 | 2025-10 | Car | Ford | Van | White | Contravening a Red Traffic Light | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | No Offence | 52.4679402 | -1.881408 | ||
| 22374 | op-snap---monthly-publication-october-2025.pdf | 324 | 2025-10 | Car | Ford | fiesta | silver | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4543565 | -1.9114004 | ||
| 22417 | op-snap---monthly-publication-october-2025.pdf | 367 | 2025-10 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Dartmouth Middleway | Dartmouth Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4861917 | -1.8829748 | ||
| 22427 | op-snap---monthly-publication-october-2025.pdf | 377 | 2025-10 | Pedestrian | Ford | Transit | blue | Contravening a Red Traffic Light | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552785 | -1.906384 | ||
| 22462 | op-snap---monthly-publication-october-2025.pdf | 412 | 2025-10 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Brighton Road Balsall Heath | Brighton Road Balsall Heath | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4543156 | -1.8840717 | ||
| 22471 | op-snap---monthly-publication-october-2025.pdf | 421 | 2025-10 | Car | Ford | Fiesta | Black | Misc - Non Traffic Offences | None | M42 Jct 4 | M42 Junction 4 | Birmingham | Birmingham | NFA | No Offence | ||||
| 22558 | op-snap---monthly-publication-october-2025.pdf | 508 | 2025-10 | Car | Ford | Kuga | Brown | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | ||
| 22606 | op-snap---monthly-publication-october-2025.pdf | 556 | 2025-10 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Wrentham Street | Wrentham Street | Birmingham | Birmingham | NFA | No VRM | 52.4708757 | -1.8966158 | ||
| 22612 | op-snap---monthly-publication-october-2025.pdf | 562 | 2025-10 | Pedal Bike | Ford | Fiesta | Grey | Contravening a Red Traffic Light | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Offence | 52.4543565 | -1.9114004 | ||
| 22655 | op-snap---monthly-publication-october-2025.pdf | 605 | 2025-10 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Chester Road A452 | Chester Road A452 | Birmingham | Birmingham | NFA | No Offence | 52.5338529 | -1.8296813 | ||
| 22671 | op-snap---monthly-publication-october-2025.pdf | 621 | 2025-10 | Other | Ford | minibus | White | Misc - Non Traffic Offences | None | Whittington Oval, Stechford | Whittington Oval, Stechford | Birmingham | Birmingham | NFA | No Offence | 52.4800782 | -1.7942034 | ||
| 22828 | op-snap---monthly-publication-october-2025.pdf | 778 | 2025-10 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Offence | 52.4543565 | -1.9114004 | ||
| 23052 | op-snap---monthly-publication-october-2025.pdf | 1002 | 2025-10 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | M5 J3 | M5 J3 | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4846642 | -1.9297585 | ||
| 23104 | op-snap---monthly-publication-october-2025.pdf | 1054 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Patrons Road | Patrons Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 23173 | op-snap---monthly-publication-october-2025.pdf | 1123 | 2025-10 | Car | Ford | Transit | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 23196 | op-snap---monthly-publication-october-2025.pdf | 1146 | 2025-10 | Car | Ford | Pickup | White | Misc - Non Traffic Offences | None | m6 south | M6 South | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4031308 | -2.0142003 | ||
| 23244 | op-snap---monthly-publication-october-2025.pdf | 1194 | 2025-10 | Car | Ford | Ranger | Blue | Misc - Non Traffic Offences | None | Warwick Road | Warwick Road | Birmingham | Birmingham | NFA | No Offence | 52.4555288 | -1.8613929 | ||
| 23250 | op-snap---monthly-publication-october-2025.pdf | 1200 | 2025-10 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4308271 | -1.920078 | ||
| 23267 | op-snap---monthly-publication-october-2025.pdf | 1217 | 2025-10 | Pedestrian | Ford | Galaxy | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Unknown | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||
| 23444 | op-snap---monthly-publication-october-2025.pdf | 1394 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lyons Grove | Lyons Grove | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4471223 | -1.8664309 | ||
| 23466 | op-snap---monthly-publication-october-2025.pdf | 1416 | 2025-10 | Pedestrian | Ford | focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | reddings lane | Reddings Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4506039 | -1.8463952 | ||
| 23508 | op-snap---monthly-publication-october-2025.pdf | 1458 | 2025-10 | Car | Ford | Transit | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4830179 | -1.783876 | ||
| 23516 | op-snap---monthly-publication-october-2025.pdf | 1466 | 2025-10 | Pedestrian | Ford | Transit | Silver | Cause vehicle to be left in a dangerous position | None | Tower Hill | Tower Hill | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5335541 | -1.9186098 | ||
| 23613 | op-snap---monthly-publication-october-2025.pdf | 1563 | 2025-10 | Pedestrian | Ford | Puma | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Russell Road | Russell Road | Birmingham | Birmingham | NFA | No Offence | 52.4398245 | -1.8469786 |
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);