👁️ 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 70 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 type	Offence	Total
Car	Driving without Due Care and Attention	5123
Car	Contravening a Red Traffic Light	2675
Car	Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area	910
Car	Driving without Reasonable Consideration	893
Car	Stop a vehicle within pelican pedestrian crossing limits	884
Car	Cause vehicle to be left in a dangerous position	705
Car	Using a Mobile Phone Whilst Driving	633
Car	Misc - Non Traffic Offences	472
Car	Stop a vehicle on pedestrian crossing	315
Car	Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD	205
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	137
Car	VRM fails to conform to Regulations	110
Car	Contravene Lane Closure Red X	98
Car	Drive on hard shoulder	94
Car	Dangerous Driving	79
Car	Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment	75
Car	Motor vehicle fail to accord precedence at a pelican crossing	50
Car	Use a motor vehicle / trailer in a condition likely to cause danger of injury	45
Car	Driving a vehicle wholly or partly on a footpath	41
Car	Drive a vehicle other than on the carriageway of a motorway	38
Car	No Insurance	33
Car	Vehicle overtake within crossing limits	32
Car	Driver not in position to have Proper Control	30
Car	Prohibited vehicle in offside lane of motorway	28
Car	No Seat Belt	25
Car	Motor vehicle fail to comply with solid white line road markings	20
Car	Motor vehicle fail to comply with endorsable sect	15
Car	Fail to display front VRM plate	15
Car	Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger	14
Car	Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic	13
Car	Use vehicle on a road without valid test certificate	11
Car	Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway	10
Pedal Bike	Driving without Due Care and Attention	1232
Pedal Bike	Using a Mobile Phone Whilst Driving	889
Pedal Bike	Driving without Reasonable Consideration	788
Pedal Bike	Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area	276
Pedal Bike	Contravening a Red Traffic Light	190
Pedal Bike	Stop a vehicle within pelican pedestrian crossing limits	139
Pedal Bike	Cause vehicle to be left in a dangerous position	125
Pedal Bike	Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD	76
Pedal Bike	Stop a vehicle on pedestrian crossing	49
Pedal Bike	Misc - Non Traffic Offences	46
Pedal Bike	Use a vehicle / cycle on a road and contravene a local traffic order other than parking	37
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	2426
Pedestrian	Cause vehicle to be left in a dangerous position	1223
Pedestrian	Misc - Non Traffic Offences	337
Pedestrian	Driving without Due Care and Attention	311
Pedestrian	Stop a vehicle within pelican pedestrian crossing limits	297
Pedestrian	Contravening a Red Traffic Light	272
Pedestrian	Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD	260
Pedestrian	Using a Mobile Phone Whilst Driving	237
Pedestrian	Cause unnecessary obstruction by motor vehicle	196
Pedestrian	Stop a vehicle on pedestrian crossing	117
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	59
Pedestrian	Driving a vehicle wholly or partly on a footpath	47
Pedestrian	Driving without Reasonable Consideration	43
Pedestrian	VRM fails to conform to Regulations	27
Pedestrian	Motor vehicle fail to accord precedence at a pelican crossing	21
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	Dangerous Driving	12
Pedestrian	Use a motor vehicle / trailer in a condition likely to cause danger of injury	10
Pedestrian	Fail to display front VRM plate	10