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'}
2,827 rows where vehicle_make = "Ford" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale, witness_contacted
offence >30
- Driving without Due Care and Attention 754
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 445
- Contravening a Red Traffic Light 361
- Driving without Reasonable Consideration 240
- Cause vehicle to be left in a dangerous position 234
- Using a Mobile Phone Whilst Driving 214
- Stop a vehicle within pelican pedestrian crossing limits 126
- Misc - Non Traffic Offences 91
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 56
- Stop a vehicle on pedestrian crossing 41
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 39
- Cause unnecessary obstruction by motor vehicle 37
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 19
- Drive on hard shoulder 16
- Driving a vehicle wholly or partly on a footpath 15
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 12
- Dangerous Driving 11
- Contravene Lane Closure Red X 10
- Motor vehicle fail to accord precedence at a pelican crossing 10
- No Seat Belt 8
- No Insurance 7
- VRM fails to conform to Regulations 7
- Driver not in position to have Proper Control 6
- Fail to Conform to Cycle Lane 6
- Motor vehicle fail to comply with a non endorsab 6
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 6
- Motor vehicle fail to comply with solid white line road markings 6
- Drive a vehicle other than on the carriageway of a motorway 4
- Fail to display front VRM plate 4
- Vehicle overtake within crossing limits 4
- …
council_area >30
- Birmingham 1,423
- Coventry 321
- Out of Force Area 228
- Dudley 190
- Sandwell 162
- Wolverhampton 131
- Walsall 124
- Solihull 118
- Sutton Coldfield 78
- Halesowen 9
- Metropolitan Borough 7
- Area 6
- Metropolitan Borough Of Dudley 5
- Coe Ulot Coaf Tfioonrce Area 1
- Coouvt Eonft Fryorce 1
- Ds Bainrcdhwleeyll Island 1
- Eb Ivrmaleingham 1
- Ebirmingham 1
- Edr Uwditlhe Ystaffs Police 1
- Gsautteto N Coldfield 1
- Hbiirrlmeyingham 1
- Lsouwtetor Nq Cuoelednfi Esldtreet , Sutton Col 1
- Msolihull 1
- Nostuetr Of Force Area 1
- Oguret Eonf Force Area 1
- Optuotn Of Force Area 1
- Osmanwdiwchell 1
- Osru Cttloons Ecoldfield 1
- Sbtirremeitn,G Bhiarmmingham 1
- So Tuotp Of Force Area 1
- …
month 14
reporter_transport_mode 10
- Car 1,476
- Pedestrian 707
- Pedal Bike 487
- Other 105
- Lorry 17
- Motorbike 13
- Bus 7
- Van 7
- car 6
- Horse Rider 2
disposal 9
- NFA 972
- Warning Letter 721
- Fixed Penalty 515
- Education 473
- Court 106
- Other Action Taken 22
- RTC - Actioned 15
- Duplicate Submission 2
- Taken 1
vehicle_make 1
- Ford · 2,827 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 8881 | op-snap---monthly-publication-february-2026.pdf | 1628 | 2026-02 | Car | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath | Washwood Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4957234 | -1.8538937 | ||
| 8874 | op-snap---monthly-publication-february-2026.pdf | 1621 | 2026-02 | Pedestrian | Ford | puma | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | broad meadow | Broad Meadow | Walsall | Walsall | Warning Letter | N/A | 52.6118773 | -1.9173068 | ||
| 8860 | op-snap---monthly-publication-february-2026.pdf | 1607 | 2026-02 | Pedestrian | Ford | Kuga | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | westley road | Westley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4456462 | -1.827993 | ||
| 8858 | op-snap---monthly-publication-february-2026.pdf | 1605 | 2026-02 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dyas road | Dyas Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5424796 | -1.8885732 | ||
| 8855 | op-snap---monthly-publication-february-2026.pdf | 1602 | 2026-02 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | grainger street | Grainger Street | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8840 | op-snap---monthly-publication-february-2026.pdf | 1587 | 2026-02 | Car | Ford | mondeo | Silver | 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 | ||
| 8831 | op-snap---monthly-publication-february-2026.pdf | 1578 | 2026-02 | Pedestrian | Ford | fiesta | Grey | VRM fails to conform to Regulations | None | egghill road | Egghill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.408976 | -2.0002999 | ||
| 8818 | op-snap---monthly-publication-february-2026.pdf | 1565 | 2026-02 | Pedal Bike | Ford | Focus | Blue | Driving without Due Care and Attention | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Education | N/A | 52.4668753 | -1.8996143 | ||
| 8809 | op-snap---monthly-publication-february-2026.pdf | 1556 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Brickhouse Lane | Brickhouse Lane | Sandwell | Sandwell | Court | N/A | 52.5331011 | -2.0206711 | ||
| 8804 | op-snap---monthly-publication-february-2026.pdf | 1551 | 2026-02 | Car | Ford | transit | Black | Driving without Reasonable Consideration | None | A45 Heartlands parkway | Heartlands parkway | Birmingham | Birmingham | Warning Letter | N/A | 52.5038363 | -1.8432663 | ||
| 8781 | op-snap---monthly-publication-february-2026.pdf | 1528 | 2026-02 | Other | Ford | Fiesta | Black | Misc - Non Traffic Offences | None | Waterfrotn car park | Waterfrotn car park | Dudley | Dudley | NFA | No Offence | ||||
| 8779 | op-snap---monthly-publication-february-2026.pdf | 1526 | 2026-02 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Kelvin Way | Kelvin Way | Sandwell | Sandwell | RTC - Actioned | N/A | 52.5090464 | -1.9938896 | ||
| 8768 | op-snap---monthly-publication-february-2026.pdf | 1515 | 2026-02 | Pedal Bike | Ford | Ka | White | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 8760 | op-snap---monthly-publication-february-2026.pdf | 1507 | 2026-02 | Pedal Bike | Ford | Puma | Red | Driving without Due Care and Attention | None | Wall Hill Road | Wall Hill Road | Coventry | Coventry | Education | N/A | 52.4459445 | -1.5552508 | ||
| 8745 | op-snap---monthly-publication-february-2026.pdf | 1492 | 2026-02 | Car | Ford | Connect | White | Driving without Due Care and Attention | None | Middlemore Road | Middlemore Road | Sandwell | Sandwell | Duplicate Submission | Duplicate Submission | 52.5056493 | -1.9624063 | ||
| 8744 | op-snap---monthly-publication-february-2026.pdf | 1491 | 2026-02 | Car | Ford | Connect | White | Driving without Due Care and Attention | None | Middlemore Road | Middlemore Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5056493 | -1.9624063 | ||
| 8742 | op-snap---monthly-publication-february-2026.pdf | 1489 | 2026-02 | Car | Ford | Fiesta | Black | Contravening a Red Traffic Light | None | Austin Road | Austin Road | Birmingham | Birmingham | Education | N/A | 52.5086851 | -1.9532014 | ||
| 8725 | op-snap---monthly-publication-february-2026.pdf | 1472 | 2026-02 | Pedal Bike | Ford | kuga | White | Motor vehicle fail to accord precedence at a pelican crossing | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 8676 | op-snap---monthly-publication-february-2026.pdf | 1423 | 2026-02 | Car | Ford | Transit | Black | Driving without Due Care and Attention | None | Throne Road | Throne Road | Sandwell | Sandwell | NFA | No Offence | 52.4875572 | -2.0284052 | ||
| 8672 | op-snap---monthly-publication-february-2026.pdf | 1419 | 2026-02 | Car | Ford | Kuga | Black | Contravening a Red Traffic Light | None | Handsworth Wood Road | Handsworth Wood Road | Birmingham | Birmingham | Education | N/A | 52.5162348 | -1.9245419 | ||
| 8670 | op-snap---monthly-publication-february-2026.pdf | 1417 | 2026-02 | Car | Ford | Mondeo | Grey | Using a Mobile Phone Whilst Driving | None | M42 SB J5-4 | M42 Southbound J5-4 | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 8666 | op-snap---monthly-publication-february-2026.pdf | 1413 | 2026-02 | Car | Ford | White | Using a Mobile Phone Whilst Driving | None | IIminster Road | IIminster Road | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 8658 | op-snap---monthly-publication-february-2026.pdf | 1405 | 2026-02 | Other | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Education | N/A | ||||
| 8656 | op-snap---monthly-publication-february-2026.pdf | 1403 | 2026-02 | Car | Ford | Puma | White | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Birmingham | Birmingham | Education | N/A | 52.5027779 | -1.7982159 | ||
| 8639 | op-snap---monthly-publication-february-2026.pdf | 1386 | 2026-02 | Pedestrian | Ford | focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | berwood | Berwood | Birmingham | Birmingham | Warning Letter | N/A | 52.5314135 | -1.8193863 | ||
| 8627 | op-snap---monthly-publication-february-2026.pdf | 1374 | 2026-02 | Car | Ford | fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8621 | op-snap---monthly-publication-february-2026.pdf | 1368 | 2026-02 | Pedestrian | Ford | focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | willis street | Willis Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8619 | op-snap---monthly-publication-february-2026.pdf | 1366 | 2026-02 | Car | Ford | Ranger | Black | Contravening a Red Traffic Light | None | Essington Road | Essington Road | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 8611 | op-snap---monthly-publication-february-2026.pdf | 1358 | 2026-02 | Pedestrian | Ford | fiesta | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | stanbrook road | Stanbrook Road | Solihull | Solihull | Warning Letter | N/A | 52.3856249 | -1.7909292 | ||
| 8609 | op-snap---monthly-publication-february-2026.pdf | 1356 | 2026-02 | Pedestrian | Ford | Fiesta | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Warple Road | Warple Road | Birmingham | Birmingham | Warning Letter | N/A | 52.457865 | -2.000085 | ||
| 8595 | op-snap---monthly-publication-february-2026.pdf | 1342 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | M5 J4 | M5 J4 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8594 | op-snap---monthly-publication-february-2026.pdf | 1341 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Ludgate Road | Ludgate Road | Coventry | Coventry | Education | N/A | ||||
| 8587 | op-snap---monthly-publication-february-2026.pdf | 1334 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Whitchurch Road, Whitchurch | Whitchurch Road, Whitchurch | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8584 | op-snap---monthly-publication-february-2026.pdf | 1331 | 2026-02 | Car | Ford | Mondeo | Black | Driving without Due Care and Attention | None | Coldhams Lane, Cambridgeshire | Coldhams Lane, Cambridgeshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8580 | op-snap---monthly-publication-february-2026.pdf | 1327 | 2026-02 | Other | Ford | Transit tipper | Blue | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Spring Vale Street, Willenhall | Spring Vale Street, Willenhall | Walsall | Walsall | Court | N/A | ||||
| 8578 | op-snap---monthly-publication-february-2026.pdf | 1325 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Bridlewood | Bridlewood | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5756112 | -1.8865562 | ||
| 8572 | op-snap---monthly-publication-february-2026.pdf | 1319 | 2026-02 | Pedal Bike | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Education | N/A | 52.5113867 | -1.8337258 | ||
| 8560 | op-snap---monthly-publication-february-2026.pdf | 1307 | 2026-02 | Car | Ford | Transit | Silver | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 8558 | op-snap---monthly-publication-february-2026.pdf | 1305 | 2026-02 | Pedal Bike | Ford | Cmax | Blue | Driving without Due Care and Attention | None | Cranmore Bvd | Cranmore Bvd | Solihull | Solihull | Court | N/A | 52.3947549 | -1.8141729 | ||
| 8548 | op-snap---monthly-publication-february-2026.pdf | 1295 | 2026-02 | Pedal Bike | Ford | Fiesta | Silver | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 8528 | op-snap---monthly-publication-february-2026.pdf | 1275 | 2026-02 | Pedal Bike | Ford | Ranger | White | Driving without Due Care and Attention | None | Lower Street | Lower Street | Wolverhampton | Wolverhampton | NFA | 52.6017311 | -2.1598475 | |||
| 8502 | op-snap---monthly-publication-february-2026.pdf | 1249 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Moor Lane at Brookvale Road (Perry Barr) | Moor Lane at Brookvale Road (Perry Barr) | Birmingham | Birmingham | Court | N/A | 52.5276389 | -1.8831953 | ||
| 8473 | op-snap---monthly-publication-february-2026.pdf | 1220 | 2026-02 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Greenmoor Road | Greenmoor Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8468 | op-snap---monthly-publication-february-2026.pdf | 1215 | 2026-02 | Car | Ford | Blue | Contravening a Red Traffic Light | None | Fort Parkway | Fort Parkway | Birmingham | Birmingham | Education | N/A | 52.50787 | -1.8195713 | |||
| 8465 | op-snap---monthly-publication-february-2026.pdf | 1212 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | M1, Brinsworth | M1, Brinsworth | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||||
| 8445 | op-snap---monthly-publication-february-2026.pdf | 1192 | 2026-02 | Car | Ford | Focus | White | Stop a vehicle within pelican pedestrian crossing limits | None | washwood Heath Road | washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 8443 | op-snap---monthly-publication-february-2026.pdf | 1190 | 2026-02 | Car | Ford | Fiesta | Silver | Contravening a Red Traffic Light | Drive otherwise than in accordance with a licence | Walsall Road | Walsall Road | Birmingham | Birmingham | Court | N/A | 52.5919543 | -1.8517118 | ||
| 8440 | op-snap---monthly-publication-february-2026.pdf | 1187 | 2026-02 | Pedal Bike | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5359496 | -1.8324115 | ||
| 8429 | op-snap---monthly-publication-february-2026.pdf | 1176 | 2026-02 | Car | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Dudley Port at Sedgley Road | Dudley Port at Sedgley Road | Sandwell | Sandwell | Court | N/A | 52.524461 | -2.0492538 | ||
| 8428 | op-snap---monthly-publication-february-2026.pdf | 1175 | 2026-02 | Car | Ford | Transit | White | Misc - Non Traffic Offences | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 8425 | op-snap---monthly-publication-february-2026.pdf | 1172 | 2026-02 | Car | Ford | Transit | Grey | Contravening a Red Traffic Light | None | Europa Way (Warwickshire) | Europa Way (Warwickshire) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8414 | op-snap---monthly-publication-february-2026.pdf | 1161 | 2026-02 | Pedal Bike | Ford | Focus | Grey | Driving without Due Care and Attention | None | Bakers Lane | Bakers Lane | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5632567 | -1.8782299 | ||
| 8413 | op-snap---monthly-publication-february-2026.pdf | 1160 | 2026-02 | Pedestrian | Ford | Focus | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Monica Road at Kings Cliff Road | Monica Road at Kings Cliff Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4714936 | -1.8386654 | ||
| 8408 | op-snap---monthly-publication-february-2026.pdf | 1155 | 2026-02 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Friars Street, Warwick | Friars Street, Warwick | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8404 | op-snap---monthly-publication-february-2026.pdf | 1151 | 2026-02 | Pedestrian | Ford | Transit | White | Cause vehicle to be left in a dangerous position | None | Lentons Lane | Lentons Lane | Coventry | Coventry | Education | N/A | 52.4503238 | -1.4546397 | ||
| 8400 | op-snap---monthly-publication-february-2026.pdf | 1147 | 2026-02 | Car | Ford | Transit | White | Stop a vehicle within pelican pedestrian crossing limits | None | Perry Hill Road | Perry Hill Road | Birmingham | Birmingham | Education | N/A | 52.5317443 | -1.8620841 | ||
| 8379 | op-snap---monthly-publication-february-2026.pdf | 1126 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | Education | N/A | 52.4762433 | -1.9176665 | ||
| 8377 | op-snap---monthly-publication-february-2026.pdf | 1124 | 2026-02 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.502683 | -1.9033516 | ||
| 8376 | op-snap---monthly-publication-february-2026.pdf | 1123 | 2026-02 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | None | Stechford Lane | Stechford Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4930549 | -1.8179571 | ||
| 8375 | op-snap---monthly-publication-february-2026.pdf | 1122 | 2026-02 | Car | Ford | Fiesta | Purple | Driving without Due Care and Attention | None | Newborough Road | Newborough Road | Solihull | Solihull | Court | N/A | 52.4123031 | -1.83781 | ||
| 8371 | op-snap---monthly-publication-february-2026.pdf | 1118 | 2026-02 | Car | Ford | Puma | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 8370 | op-snap---monthly-publication-february-2026.pdf | 1117 | 2026-02 | Other | Ford | Transit | White | Stop a vehicle within pelican pedestrian crossing limits | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | Education | N/A | 52.4391028 | -1.893289 | ||
| 8360 | op-snap---monthly-publication-february-2026.pdf | 1107 | 2026-02 | Car | Ford | Transit | Blue | Contravening a Red Traffic Light | No Insurance | Brookvale Road | Brookvale Road | Birmingham | Birmingham | Court | N/A | 52.5219365 | -1.8755325 | ||
| 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 | ||
| 8351 | op-snap---monthly-publication-february-2026.pdf | 1098 | 2026-02 | Pedal Bike | Ford | Fiesta | White | Driving without Due Care and Attention | None | Ladywood Road | Ladywood Road | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.5783972 | -1.8355593 | ||
| 8349 | op-snap---monthly-publication-february-2026.pdf | 1096 | 2026-02 | Pedal Bike | Ford | Fiesta | White | Driving without Due Care and Attention | None | Ladywood Road | Ladywood Road | Birmingham | Birmingham | Education | N/A | 52.5783972 | -1.8355593 | ||
| 8342 | op-snap---monthly-publication-february-2026.pdf | 1089 | 2026-02 | Pedestrian | Ford | Etransit | White | Using a Mobile Phone Whilst Driving | None | Woodleigh Avenue | Woodleigh Avenue | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4501564 | -1.9468853 | ||
| 8322 | op-snap---monthly-publication-february-2026.pdf | 1069 | 2026-02 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Wilderspool Causeway | Wilderspool Causeway | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 8311 | op-snap---monthly-publication-february-2026.pdf | 1058 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Chase Road | Chase Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6148036 | -2.0138379 | ||
| 8301 | op-snap---monthly-publication-february-2026.pdf | 1048 | 2026-02 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | M6 Motorway | M6 Motorway | Birmingham | Birmingham | Warning Letter | N/A | 52.5327447 | -1.899844 | ||
| 8293 | op-snap---monthly-publication-february-2026.pdf | 1040 | 2026-02 | Pedestrian | Ford | B-Max | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513857 | -1.9367367 | ||
| 8292 | op-snap---monthly-publication-february-2026.pdf | 1039 | 2026-02 | Pedestrian | Ford | Focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513857 | -1.9367367 | ||
| 8287 | op-snap---monthly-publication-february-2026.pdf | 1034 | 2026-02 | Pedestrian | Ford | Focus | Silver | Cause vehicle to be left in a dangerous position | None | Burbury Street | Burbury Street | Birmingham | Birmingham | Education | N/A | 52.5010617 | -1.9095433 | ||
| 8277 | op-snap---monthly-publication-february-2026.pdf | 1024 | 2026-02 | Car | Ford | Puma | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Witton Road | Witton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513336 | -1.8833226 | ||
| 8273 | op-snap---monthly-publication-february-2026.pdf | 1020 | 2026-02 | Car | Ford | Mondeo | White | Misc - Non Traffic Offences | None | Manor Way Halesowen | Manor Way Halesowen | Dudley | Dudley | NFA | Not in Public Interest | 52.443598 | -2.0464887 | ||
| 8269 | op-snap---monthly-publication-february-2026.pdf | 1016 | 2026-02 | Car | Ford | Transit | Blue | Driving without Due Care and Attention | No Insurance | Halesowen Road Netherton | Halesowen Road Netherton | Dudley | Dudley | Court | N/A | 52.4904317 | -2.0833451 | ||
| 8267 | op-snap---monthly-publication-february-2026.pdf | 1014 | 2026-02 | Car | Ford | Toureno | Grey | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Solihull | Solihull | Warning Letter | N/A | 52.4428606 | -1.812114 | ||
| 8262 | op-snap---monthly-publication-february-2026.pdf | 1009 | 2026-02 | Car | Ford | White | Driving without Due Care and Attention | None | J6 M6 | J6 M6 | Birmingham | Birmingham | RTC - Actioned | N/A | 52.5113331 | -1.8652091 | |||
| 8255 | op-snap---monthly-publication-february-2026.pdf | 1002 | 2026-02 | Car | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Island Road | Island Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4634433 | -1.9965278 | ||
| 8248 | op-snap---monthly-publication-february-2026.pdf | 995 | 2026-02 | Car | Ford | Kuga | Black | Contravening a Red Traffic Light | None | B4632 | B4632 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3994858 | -1.4923603 | ||
| 8214 | op-snap---monthly-publication-february-2026.pdf | 961 | 2026-02 | Car | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Silverthorne Lane | Silverthorne Lane | Dudley | Dudley | NFA | No Offence | ||||
| 8206 | op-snap---monthly-publication-february-2026.pdf | 953 | 2026-02 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Bristol Road, Bourneville | Bristol Road, Bourneville | Birmingham | Birmingham | Education | N/A | ||||
| 8189 | op-snap---monthly-publication-february-2026.pdf | 936 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | A1, Newcastle | A1, Newcastle | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5203232 | -1.7785979 | ||
| 8180 | op-snap---monthly-publication-february-2026.pdf | 927 | 2026-02 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | York Road | York Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5231321 | -1.8415573 | ||
| 8167 | op-snap---monthly-publication-february-2026.pdf | 914 | 2026-02 | Car | Ford | Focus | Black | Driving without Due Care and Attention | None | Toll Bar End | Toll Bar End | Coventry | Coventry | Other Action Taken | N/A | 52.377406 | -1.4651313 | ||
| 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 | ||
| 8161 | op-snap---monthly-publication-february-2026.pdf | 908 | 2026-02 | Lorry | Ford | Transit | White | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5461417 | -1.9334193 | ||
| 8150 | op-snap---monthly-publication-february-2026.pdf | 897 | 2026-02 | Car | Ford | Focus | Red | 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 | ||
| 8147 | op-snap---monthly-publication-february-2026.pdf | 894 | 2026-02 | Pedal Bike | Ford | Fiesta | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 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 | ||
| 8116 | op-snap---monthly-publication-february-2026.pdf | 863 | 2026-02 | Car | Ford | Transit | Blue | Driving without Due Care and Attention | None | Kitts Green | Kitts Green | Birmingham | Birmingham | Other Action Taken | N/A | 52.4834707 | -1.7757966 | ||
| 8105 | op-snap---monthly-publication-february-2026.pdf | 852 | 2026-02 | Car | Ford | Transit | Silver | Misc - Non Traffic Offences | None | Wolverley Crescent, Lion Farm | Wolverley Crescent, Lion Farm | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4919463 | -2.0292691 | ||
| 8095 | op-snap---monthly-publication-february-2026.pdf | 842 | 2026-02 | Bus | Ford | Fiesta | White | Driving without Due Care and Attention | None | M6 J10 | M6 J10 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6760749 | -2.0862582 | ||
| 8084 | op-snap---monthly-publication-february-2026.pdf | 831 | 2026-02 | Pedal Bike | Ford | KA | White | Driving without Due Care and Attention | None | Heath Lane towards Norton | Heath Lane towards Norton | Dudley | Dudley | Education | N/A | ||||
| 8083 | op-snap---monthly-publication-february-2026.pdf | 830 | 2026-02 | Car | Ford | Focus | Red | Driving without Due Care and Attention | None | Lamb Street | Lamb Street | Coventry | Coventry | Education | N/A | 52.4110367 | -1.5143617 | ||
| 8080 | op-snap---monthly-publication-february-2026.pdf | 827 | 2026-02 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Beech Road | Beech Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6155037 | -2.1354987 | ||
| 8068 | op-snap---monthly-publication-february-2026.pdf | 815 | 2026-02 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | None | Lee Bank Middleway | Lee Bank Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4677721 | -1.9037358 |
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);