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'}
3,985 rows where reporter_transport_mode = "Pedal Bike" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale, witness_contacted
vehicle_make >30
- Ford 487
- Mercedes-Benz 373
- Volkswagen 360
- BMW 315
- Toyota 297
- Audi 286
- Vauxhall 244
- Peugeot 150
- Nissan 149
- Seat 106
- Hyundai 101
- Land Rover 101
- Renault 88
- Kia 87
- Citroen 83
- Skoda 77
- Honda 76
- Volvo 59
- Mini 45
- Fiat 42
- Jaguar 37
- Mazda 34
- Tesla 33
- Mg 29
- Porsche 28
- Suzuki 25
- Lexus 21
- Daf 20
- Mitsubishi 20
- Other 15
- …
offence >30
- Driving without Due Care and Attention 1,232
- Using a Mobile Phone Whilst Driving 889
- Driving without Reasonable Consideration 788
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 276
- Contravening a Red Traffic Light 190
- Stop a vehicle within pelican pedestrian crossing limits 139
- Cause vehicle to be left in a dangerous position 125
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 76
- Stop a vehicle on pedestrian crossing 49
- Misc - Non Traffic Offences 46
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 37
- Cause unnecessary obstruction by motor vehicle 30
- Fail to Conform to Cycle Lane 19
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 11
- Driver not in position to have Proper Control 7
- Driving a vehicle wholly or partly on a footpath 7
- Contravene Lane Closure Red X 6
- Fail to display front VRM plate 5
- Motor vehicle fail to comply with a non endorsab 5
- Motor vehicle fail to comply with solid white line road markings 5
- No Insurance 5
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 5
- Dangerous Driving 4
- Motor vehicle fail to accord precedence at a pelican crossing 4
- No Seat Belt 4
- Vehicle overtake within crossing limits 4
- Duplicate Submission 3
- Fail to display rear VRM plate 3
- Use vehicle on a road without valid test certificate 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 2
- …
council_area 30
- Birmingham 2,150
- Coventry 1,023
- Solihull 175
- Out of Force Area 117
- Sutton Coldfield 104
- Walsall 104
- Dudley 100
- Wolverhampton 94
- Sandwell 80
- Halesowen 8
- Area 4
- Metropolitan Borough Of Dudley 4
- Coouvt Eonft Fryorce 2
- Metropolitan Borough 2
- Abyirmingham 1
- Bdirmingham 1
- C O V E N T R Y 1
- Cbtiiromningham 1
- Ecnoventry 1
- Mbinirgmhianmgham 1
- Mbirmingham 1
- Metropolitan Boroug 1
- Msolihull 1
- Nsolihull 1
- Obtti Rrmoinagdh ,A Bmirmingham 1
- Sbtirremeitn,G Bhiarmmingham 1
- Soauntd Owf Eflolrce 1
- Tbirmingham 1
- Ubeiernmsiwngahyam 1
- Vceostveern Rtreystaurant) 1
month 14
disposal 8
- Fixed Penalty 1,147
- Education 1,012
- NFA 992
- Warning Letter 663
- Court 138
- Other Action Taken 25
- Duplicate Submission 7
- Taken 1
reporter_transport_mode 1
- Pedal Bike · 3,985 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8891 | op-snap---monthly-publication-february-2026.pdf | 1638 | 2026-02 | Pedal Bike | Peugeot | 107 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Warning Letter | N/A | 52.3988977 | -1.5323674 | ||
| 8890 | op-snap---monthly-publication-february-2026.pdf | 1637 | 2026-02 | Pedal Bike | Jaguar | xj | Black | Stop a vehicle within pelican pedestrian crossing limits | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4221152 | -1.4959475 | ||
| 8889 | op-snap---monthly-publication-february-2026.pdf | 1636 | 2026-02 | Pedal Bike | Toyota | prius | White | Stop a vehicle on pedestrian crossing | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 8888 | op-snap---monthly-publication-february-2026.pdf | 1635 | 2026-02 | Pedal Bike | Toyota | prius | Grey | Stop a vehicle on pedestrian crossing | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 8872 | op-snap---monthly-publication-february-2026.pdf | 1619 | 2026-02 | Pedal Bike | Volvo | V40 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | bradford street | Bradford Street | Coventry | Coventry | Warning Letter | N/A | ||||
| 8871 | op-snap---monthly-publication-february-2026.pdf | 1618 | 2026-02 | Pedal Bike | Seat | altea | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gordon road | Gordon Road | Coventry | Coventry | Warning Letter | N/A | ||||
| 8857 | op-snap---monthly-publication-february-2026.pdf | 1604 | 2026-02 | Pedal Bike | Volkswagen | caddy | Black | Misc - Non Traffic Offences | None | black haynes road | Black Haynes Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4260755 | -1.9679443 | ||
| 8856 | op-snap---monthly-publication-february-2026.pdf | 1603 | 2026-02 | Pedal Bike | Audi | A5 | Black | Using a Mobile Phone Whilst Driving | None | shenley hill | Shenley Hill | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4267534 | -1.9790765 | ||
| 8821 | op-snap---monthly-publication-february-2026.pdf | 1568 | 2026-02 | Pedal Bike | Honda | NSC | White | Driving without Due Care and Attention | None | Yew Tree Lane | Yew Tree Lane | Birmingham | Birmingham | NFA | No Offence | 52.4631 | -1.8082055 | ||
| 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 | ||
| 8817 | op-snap---monthly-publication-february-2026.pdf | 1564 | 2026-02 | Pedal Bike | Nissan | Qashqai | White | Driving without Due Care and Attention | None | New John Street West | New John Street West | Birmingham | Birmingham | Education | N/A | 52.4944784 | -1.9122329 | ||
| 8816 | op-snap---monthly-publication-february-2026.pdf | 1563 | 2026-02 | Pedal Bike | Audi | A5 | Silver | Driving without Due Care and Attention | No Insurance | Lawley Middleway | Lawley Middleway | Birmingham | Birmingham | Court | N/A | 52.4801772 | -1.8769185 | ||
| 8815 | op-snap---monthly-publication-february-2026.pdf | 1562 | 2026-02 | Pedal Bike | BMW | M3.. | Grey | Contravening a Red Traffic Light | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | Education | N/A | 52.4214017 | -1.4870278 | ||
| 8814 | op-snap---monthly-publication-february-2026.pdf | 1561 | 2026-02 | Pedal Bike | Seat | Leon | Grey | Driving without Due Care and Attention | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | 52.4071231 | -1.4985178 | ||
| 8813 | op-snap---monthly-publication-february-2026.pdf | 1560 | 2026-02 | Pedal Bike | Audi | A4 | Grey | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 8812 | op-snap---monthly-publication-february-2026.pdf | 1559 | 2026-02 | Pedal Bike | Toyota | Prius | White | Using a Mobile Phone Whilst Driving | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4274335 | -1.5002381 | ||
| 8790 | op-snap---monthly-publication-february-2026.pdf | 1537 | 2026-02 | Pedal Bike | Jaguar | fpace | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | bristol road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 8789 | op-snap---monthly-publication-february-2026.pdf | 1536 | 2026-02 | Pedal Bike | Peugeot | 207 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | bristol road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 8787 | op-snap---monthly-publication-february-2026.pdf | 1534 | 2026-02 | Pedal Bike | Audi | Q3.. | Blue | Driving without Due Care and Attention | None | Wagon Lane | Wagon Lane | Birmingham | Birmingham | Education | N/A | 52.4546868 | -1.793848 | ||
| 8772 | op-snap---monthly-publication-february-2026.pdf | 1519 | 2026-02 | Pedal Bike | Fiat | 500.. | Black | Driving without Due Care and Attention | None | Solihull Road | Solihull Road | Solihull | Solihull | Warning Letter | N/A | 52.4114159 | -1.8197732 | ||
| 8769 | op-snap---monthly-publication-february-2026.pdf | 1516 | 2026-02 | Pedal Bike | Nissan | Qashqai | Blue | Driving without Due Care and Attention | None | Hampton Lane | Hampton Lane | Solihull | Solihull | Warning Letter | N/A | 52.4190728 | -1.7449943 | ||
| 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 | ||
| 8766 | op-snap---monthly-publication-february-2026.pdf | 1513 | 2026-02 | Pedal Bike | Toyota | Prius | Black | Driving without Due Care and Attention | None | Spon End | Spon End | Coventry | Coventry | Education | N/A | 52.4069072 | -1.5247498 | ||
| 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 | ||
| 8747 | op-snap---monthly-publication-february-2026.pdf | 1494 | 2026-02 | Pedal Bike | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Valentine Road | Valentine Road | Birmingham | Birmingham | Court | N/A | 52.4381959 | -1.8907391 | ||
| 8733 | op-snap---monthly-publication-february-2026.pdf | 1480 | 2026-02 | Pedal Bike | Suzuki | Swift | Blue | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 8732 | op-snap---monthly-publication-february-2026.pdf | 1479 | 2026-02 | Pedal Bike | Peugeot | Partner | White | Using a Mobile Phone Whilst Driving | None | Granville Street | Granville Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4762076 | -1.9124263 | ||
| 8728 | op-snap---monthly-publication-february-2026.pdf | 1475 | 2026-02 | Pedal Bike | Mercedes-Benz | spinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 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 | ||
| 8701 | op-snap---monthly-publication-february-2026.pdf | 1448 | 2026-02 | Pedal Bike | Honda | Civic | Red | Using a Mobile Phone Whilst Driving | None | Park Hill Road | Park Hill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4612518 | -1.9515542 | ||
| 8700 | op-snap---monthly-publication-february-2026.pdf | 1447 | 2026-02 | Pedal Bike | BMW | 1 Series | Blue | Driving without Due Care and Attention | None | Dads Lane | Dads Lane | Birmingham | Birmingham | Court | N/A | 52.4375913 | -1.9068522 | ||
| 8671 | op-snap---monthly-publication-february-2026.pdf | 1418 | 2026-02 | Pedal Bike | Peugeot | 3008 | Silver | Driving without Due Care and Attention | None | Maxstroke Road | Maxstroke Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | ||||
| 8665 | op-snap---monthly-publication-february-2026.pdf | 1412 | 2026-02 | Pedal Bike | Kia | Sportage | Black | Using a Mobile Phone Whilst Driving | None | Lyon Queensway | Lyon Queensway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4785129 | -1.9047486 | ||
| 8663 | op-snap---monthly-publication-february-2026.pdf | 1410 | 2026-02 | Pedal Bike | Mercedes-Benz | A180 | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 8655 | op-snap---monthly-publication-february-2026.pdf | 1402 | 2026-02 | Pedal Bike | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | Valley Road | Valley Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4501305 | -1.7742157 | ||
| 8618 | op-snap---monthly-publication-february-2026.pdf | 1365 | 2026-02 | Pedal Bike | Hyundai | I30 | Grey | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4718503 | -1.9195423 | ||
| 8617 | op-snap---monthly-publication-february-2026.pdf | 1364 | 2026-02 | Pedal Bike | Lexus | IS 300H | Red | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 8616 | op-snap---monthly-publication-february-2026.pdf | 1363 | 2026-02 | Pedal Bike | Toyota | Van | Grey | Driving without Due Care and Attention | None | California Way | California Way | Birmingham | Birmingham | NFA | No Offence | 52.4454714 | -1.9753804 | ||
| 8612 | op-snap---monthly-publication-february-2026.pdf | 1359 | 2026-02 | Pedal Bike | BMW | 118d | Silver | Driving without Due Care and Attention | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Education | N/A | 52.4468506 | -1.9395619 | ||
| 8579 | op-snap---monthly-publication-february-2026.pdf | 1326 | 2026-02 | Pedal Bike | Audi | A6 | Grey | Driving without Due Care and Attention | None | Olton Boulevard East | Olton Boulevard East | Birmingham | Birmingham | Education | N/A | 52.4421599 | -1.829532 | ||
| 8577 | op-snap---monthly-publication-february-2026.pdf | 1324 | 2026-02 | Pedal Bike | Mercedes-Benz | GLA 200 | Black | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | ||
| 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 | ||
| 8571 | op-snap---monthly-publication-february-2026.pdf | 1318 | 2026-02 | Pedal Bike | Renault | Truck Master | White | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4415108 | -1.8971434 | ||
| 8570 | op-snap---monthly-publication-february-2026.pdf | 1317 | 2026-02 | Pedal Bike | Driving without Due Care and Attention | None | George Road towards Brookvale Road | George Road towards Brookvale Road | Birmingham | Birmingham | NFA | No VRM | |||||||
| 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 | ||
| 8549 | op-snap---monthly-publication-february-2026.pdf | 1296 | 2026-02 | Pedal Bike | Porsche | Cayenne | Grey | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 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 | ||
| 8546 | op-snap---monthly-publication-february-2026.pdf | 1293 | 2026-02 | Pedal Bike | Nissan | Juke | Blue | Driving without Due Care and Attention | None | Corporation Street | Corporation Street | Coventry | Coventry | Education | N/A | 52.4086244 | -1.515132 | ||
| 8543 | op-snap---monthly-publication-february-2026.pdf | 1290 | 2026-02 | Pedal Bike | Mercedes-Benz | C220 | Black | Driving without Due Care and Attention | None | Westwood Way | Westwood Way | Coventry | Coventry | Warning Letter | N/A | 52.3880214 | -1.5797132 | ||
| 8542 | op-snap---monthly-publication-february-2026.pdf | 1289 | 2026-02 | Pedal Bike | Nissan | Qashqai | Silver | Driving without Due Care and Attention | None | Broad Lane Coventry | Broad Lane Coventry | Coventry | Coventry | Education | N/A | 52.4144409 | -1.5990259 | ||
| 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 | |||
| 8527 | op-snap---monthly-publication-february-2026.pdf | 1274 | 2026-02 | Pedal Bike | Citroen | C1 | Grey | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 8526 | op-snap---monthly-publication-february-2026.pdf | 1273 | 2026-02 | Pedal Bike | Volkswagen | Golf GTD | Black | Using a Mobile Phone Whilst Driving | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4708802 | -1.8792135 | ||
| 8524 | op-snap---monthly-publication-february-2026.pdf | 1271 | 2026-02 | Pedal Bike | Dacia | Duster | Orange | Driving without Due Care and Attention | None | Camp Hill Circus | Camp Hill Circus | Birmingham | Birmingham | Court | N/A | 52.4682339 | -1.8793662 | ||
| 8521 | op-snap---monthly-publication-february-2026.pdf | 1268 | 2026-02 | Pedal Bike | Mercedes-Benz | Smart Fortwo | Blue | Driving without Due Care and Attention | None | Streetbrook Road | Streetbrook Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 8515 | op-snap---monthly-publication-february-2026.pdf | 1262 | 2026-02 | Pedal Bike | Peugeot | Expert | White | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Education | N/A | 52.4103629 | -1.5441218 | ||
| 8514 | op-snap---monthly-publication-february-2026.pdf | 1261 | 2026-02 | Pedal Bike | Mercedes-Benz | C220 | Silver | Driving without Due Care and Attention | None | White Street | White Street | Coventry | Coventry | Education | N/A | 52.4122951 | -1.5045181 | ||
| 8508 | op-snap---monthly-publication-february-2026.pdf | 1255 | 2026-02 | Pedal Bike | Skoda | Octavia | White | Driving without Due Care and Attention | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Education | N/A | 52.47753 | -1.9774758 | ||
| 8507 | op-snap---monthly-publication-february-2026.pdf | 1254 | 2026-02 | Pedal Bike | Audi | TT | Black | Using a Mobile Phone Whilst Driving | None | Sandon Road | Sandon Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4763582 | -1.9676181 | ||
| 8506 | op-snap---monthly-publication-february-2026.pdf | 1253 | 2026-02 | Pedal Bike | Volkswagen | Polo | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | City Road Bearwood | City Road Bearwood | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4825977 | -1.9621948 | ||
| 8498 | op-snap---monthly-publication-february-2026.pdf | 1245 | 2026-02 | Pedal Bike | Jaguar | XF | White | Driving without Reasonable Consideration | None | The Broadway | The Broadway | Dudley | Dudley | Education | N/A | 52.515445 | -2.0885791 | ||
| 8491 | op-snap---monthly-publication-february-2026.pdf | 1238 | 2026-02 | Pedal Bike | Volvo | XC90 | Red | Using a Mobile Phone Whilst Driving | None | Swarthmore Road | Swarthmore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4299657 | -1.9599121 | ||
| 8490 | op-snap---monthly-publication-february-2026.pdf | 1237 | 2026-02 | Pedal Bike | Audi | Q5 | White | Driving without Due Care and Attention | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4390303 | -1.9512931 | ||
| 8477 | op-snap---monthly-publication-february-2026.pdf | 1224 | 2026-02 | Pedal Bike | Volvo | S40 | Black | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 8475 | op-snap---monthly-publication-february-2026.pdf | 1222 | 2026-02 | Pedal Bike | Peugeot | 208 | Blue | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 8474 | op-snap---monthly-publication-february-2026.pdf | 1221 | 2026-02 | Pedal Bike | Lexus | IS 300H | Silver | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | NFA | No Offence | 52.4167654 | -1.9411244 | ||
| 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 | ||
| 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 | ||
| 8383 | op-snap---monthly-publication-february-2026.pdf | 1130 | 2026-02 | Pedal Bike | Volkswagen | Beetle | Black | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | NFA | No Offence | 52.4223176 | -1.8253145 | ||
| 8378 | op-snap---monthly-publication-february-2026.pdf | 1125 | 2026-02 | Pedal Bike | Kia | Sportage | Orange | Driving without Due Care and Attention | None | Love Lane | Love Lane | Dudley | Dudley | Education | N/A | 52.448434 | -2.1478173 | ||
| 8368 | op-snap---monthly-publication-february-2026.pdf | 1115 | 2026-02 | Pedal Bike | Hyundai | Bayen | Red | Driving without Due Care and Attention | None | Rubery Lane, Frankley | Rubery Lane, Frankley | Birmingham | Birmingham | Education | N/A | 52.4022216 | -2.0074676 | ||
| 8357 | op-snap---monthly-publication-february-2026.pdf | 1104 | 2026-02 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Sandpits | Sandpits | Birmingham | Birmingham | Court | N/A | 52.482308 | -1.9133277 | ||
| 8354 | op-snap---monthly-publication-february-2026.pdf | 1101 | 2026-02 | Pedal Bike | Citroen | C4.. | White | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Education | N/A | 52.4041117 | -1.5595662 | ||
| 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 | ||
| 8350 | op-snap---monthly-publication-february-2026.pdf | 1097 | 2026-02 | Pedal Bike | Vauxhall | Astra | Grey | Driving without Due Care and Attention | None | Cornets End Lane | Cornets End Lane | Solihull | Solihull | Warning Letter | N/A | 52.4269547 | -1.6668911 | ||
| 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 | ||
| 8326 | op-snap---monthly-publication-february-2026.pdf | 1073 | 2026-02 | Pedal Bike | Tesla | Model 3 | Grey | Using a Mobile Phone Whilst Driving | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552785 | -1.906384 | ||
| 8321 | op-snap---monthly-publication-february-2026.pdf | 1068 | 2026-02 | Pedal Bike | Toyota | Prius | Black | Driving without Due Care and Attention | None | Butts Road | Butts Road | Coventry | Coventry | Education | N/A | 52.4073149 | -1.5250454 | ||
| 8318 | op-snap---monthly-publication-february-2026.pdf | 1065 | 2026-02 | Pedal Bike | Fiat | 500 | White | Driving without Due Care and Attention | None | Meriden Road | Meriden Road | Solihull | Solihull | NFA | No Offence | 52.4137518 | -1.6414448 | ||
| 8299 | op-snap---monthly-publication-february-2026.pdf | 1046 | 2026-02 | Pedal Bike | Land Rover | Evoque | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5359496 | -1.8324115 | ||
| 8295 | op-snap---monthly-publication-february-2026.pdf | 1042 | 2026-02 | Pedal Bike | Dennis | Bus | Grey | Driving without Due Care and Attention | None | St Martins | Street Martins | Birmingham | Birmingham | Warning Letter | N/A | 52.477697 | -1.8962719 | ||
| 8282 | op-snap---monthly-publication-february-2026.pdf | 1029 | 2026-02 | Pedal Bike | Audi | A6 | Silver | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Education | N/A | 52.5292752 | -1.7618805 | ||
| 8270 | op-snap---monthly-publication-february-2026.pdf | 1017 | 2026-02 | Pedal Bike | Mazda | CX5 | Black | Driving without Due Care and Attention | None | Off force | Off force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8261 | op-snap---monthly-publication-february-2026.pdf | 1008 | 2026-02 | Pedal Bike | Mercedes-Benz | Benz | White | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Dudley | Dudley | Education | N/A | 52.4514139 | -2.1423625 | ||
| 8246 | op-snap---monthly-publication-february-2026.pdf | 993 | 2026-02 | Pedal Bike | Byd | Enviro | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 8227 | op-snap---monthly-publication-february-2026.pdf | 974 | 2026-02 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Clevedon Road, Balsall Heath | Clevedon Road, Balsall Heath | Birmingham | Birmingham | Education | N/A | 52.4618531 | -1.894645 | ||
| 8207 | op-snap---monthly-publication-february-2026.pdf | 954 | 2026-02 | Pedal Bike | Peugeot | Expert | White | Driving without Due Care and Attention | None | Cock Hill Lane, Rubery | Cock Hill Lane, Rubery | Birmingham | Birmingham | Education | N/A | ||||
| 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 | ||||
| 8205 | op-snap---monthly-publication-february-2026.pdf | 952 | 2026-02 | Pedal Bike | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Gibbins Road, Selly Oak | Gibbins Road, Selly Oak | Birmingham | Birmingham | Education | N/A | 52.4390303 | -1.9512931 | ||
| 8203 | op-snap---monthly-publication-february-2026.pdf | 950 | 2026-02 | Pedal Bike | Mercedes-Benz | C180 | Silver | Driving without Due Care and Attention | None | Hobls Hole Lane | Hobls Hole Lane | Walsall | Walsall | Education | N/A | ||||
| 8160 | op-snap---monthly-publication-february-2026.pdf | 907 | 2026-02 | Pedal Bike | Mg | ZS | White | Stop a vehicle on pedestrian crossing | None | Sycamore Road | Sycamore Road | Birmingham | Birmingham | Education | N/A | 52.5398019 | -1.8455792 | ||
| 8159 | op-snap---monthly-publication-february-2026.pdf | 906 | 2026-02 | Pedal Bike | Mercedes-Benz | CLA 180 | White | Stop a vehicle on pedestrian crossing | None | Sycamore Road | Sycamore Road | Birmingham | Birmingham | Education | N/A | 52.5398019 | -1.8455792 | ||
| 8155 | op-snap---monthly-publication-february-2026.pdf | 902 | 2026-02 | Pedal Bike | Mercedes-Benz | Vito | White | Contravening a Red Traffic Light | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Education | N/A | 52.5113867 | -1.8337258 | ||
| 8148 | op-snap---monthly-publication-february-2026.pdf | 895 | 2026-02 | Pedal Bike | Peugeot | 207 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 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 | ||
| 8103 | op-snap---monthly-publication-february-2026.pdf | 850 | 2026-02 | Pedal Bike | Audi | Q3 | White | Driving without Due Care and Attention | None | Hearsall Lane | Hearsall Lane | Coventry | Coventry | Education | N/A | 52.4064125 | -1.5320113 | ||
| 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 | ||||
| 8081 | op-snap---monthly-publication-february-2026.pdf | 828 | 2026-02 | Pedal Bike | Vauxhall | Vicaro | silver | Driving without Due Care and Attention | none | A491 Hagley Road | Hagley Road | Dudley | Dudley | Education | N/A | 52.4514139 | -2.1423625 | ||
| 8077 | op-snap---monthly-publication-february-2026.pdf | 824 | 2026-02 | Pedal Bike | Audi | A3 | Black | Contravening a Red Traffic Light | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Education | N/A | 52.4591339 | -1.9601054 | ||
| 8076 | op-snap---monthly-publication-february-2026.pdf | 823 | 2026-02 | Pedal Bike | Toyota | Corolla | Silver | Contravening a Red Traffic Light | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Education | N/A | 52.4591339 | -1.9601054 |
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);