👁️ What different road users report

Pedestrians, cyclists, and drivers witness completely different offences. 62% of pedestrian reports are pavement obstruction — they see a different city. Cyclists disproportionately report mobile phone use (22% of their submissions). Drivers mostly report careless driving and red light violations.

Custom SQL query returning 72 rows (hide) 

select reporter_transport_mode as [Reporter type], offence as Offence, count(*) as Total from reports where reporter_transport_mode in ('Car', 'Pedestrian', 'Pedal Bike') group by reporter_transport_mode, offence having count(*) >= 10 order by reporter_transport_mode, Total desc

Edit SQL

This data as json, CSV

Reporter typeOffenceTotal
Car Driving without Due Care and Attention 5698
Car Contravening a Red Traffic Light 2892
Car Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 1025
Car Stop a vehicle within pelican pedestrian crossing limits 948
Car Driving without Reasonable Consideration 903
Car Cause vehicle to be left in a dangerous position 731
Car Using a Mobile Phone Whilst Driving 716
Car Misc - Non Traffic Offences 495
Car Stop a vehicle on pedestrian crossing 317
Car Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 247
Car Cause unnecessary obstruction by motor vehicle 199
Car Use a vehicle / cycle on a road and contravene a local traffic order other than parking 143
Car VRM fails to conform to Regulations 119
Car Contravene Lane Closure Red X 106
Car Drive on hard shoulder 101
Car Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 85
Car Dangerous Driving 83
Car Drive a vehicle other than on the carriageway of a motorway 62
Car Motor vehicle fail to accord precedence at a pelican crossing 59
Car Driving a vehicle wholly or partly on a footpath 46
Car Use a motor vehicle / trailer in a condition likely to cause danger of injury 45
Car No Insurance 36
Car Vehicle overtake within crossing limits 35
Car Driver not in position to have Proper Control 31
Car Prohibited vehicle in offside lane of motorway 30
Car No Seat Belt 28
Car Motor vehicle fail to comply with solid white line road markings 22
Car Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 19
Car Fail to display front VRM plate 17
Car Motor vehicle fail to comply with endorsable sect 15
Car Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 13
Car Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 13
Car Duplicate Submission 12
Car Use vehicle on a road without valid test certificate 11
Car Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 10
Pedal Bike Driving without Due Care and Attention 1426
Pedal Bike Using a Mobile Phone Whilst Driving 946
Pedal Bike Driving without Reasonable Consideration 788
Pedal Bike Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 303
Pedal Bike Contravening a Red Traffic Light 200
Pedal Bike Stop a vehicle within pelican pedestrian crossing limits 156
Pedal Bike Cause vehicle to be left in a dangerous position 126
Pedal Bike Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 78
Pedal Bike Misc - Non Traffic Offences 54
Pedal Bike Stop a vehicle on pedestrian crossing 49
Pedal Bike Use a vehicle / cycle on a road and contravene a local traffic order other than parking 38
Pedal Bike Cause unnecessary obstruction by motor vehicle 30
Pedal Bike Fail to Conform to Cycle Lane 19
Pedal Bike Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 11
Pedestrian Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 2698
Pedestrian Cause vehicle to be left in a dangerous position 1255
Pedestrian Misc - Non Traffic Offences 369
Pedestrian Stop a vehicle within pelican pedestrian crossing limits 335
Pedestrian Driving without Due Care and Attention 335
Pedestrian Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 291
Pedestrian Contravening a Red Traffic Light 276
Pedestrian Using a Mobile Phone Whilst Driving 247
Pedestrian Cause unnecessary obstruction by motor vehicle 196
Pedestrian Stop a vehicle on pedestrian crossing 119
Pedestrian Use a vehicle / cycle on a road and contravene a local traffic order other than parking 93
Pedestrian Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 63
Pedestrian Driving a vehicle wholly or partly on a footpath 50
Pedestrian Driving without Reasonable Consideration 43
Pedestrian VRM fails to conform to Regulations 32
Pedestrian Motor vehicle fail to accord precedence at a pelican crossing 27
Pedestrian No Insurance 19
Pedestrian Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 18
Pedestrian /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 17
Pedestrian No Seat Belt 14
Pedestrian Use a motor vehicle / trailer in a condition likely to cause danger of injury 12
Pedestrian Dangerous Driving 12
Pedestrian Fail to display front VRM plate 11