👁️ What different road users report

Pedestrians, cyclists, and drivers report different offences. 63% of pedestrian reports are pavement obstruction or a vehicle left in a dangerous position. 22% of cyclist reports are mobile phone use. Drivers mostly report careless driving and red light violations.

Custom SQL query returning 74 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 6223
Car Contravening a Red Traffic Light 3085
Car Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 1485
Car Stop a vehicle within pelican pedestrian crossing limits 1122
Car Driving without Reasonable Consideration 910
Car Using a Mobile Phone Whilst Driving 785
Car Cause vehicle to be left in a dangerous position 748
Car Misc - Non Traffic Offences 520
Car Stop a vehicle on pedestrian crossing 327
Car Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 256
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 147
Car VRM fails to conform to Regulations 122
Car Contravene Lane Closure Red X 108
Car Drive on hard shoulder 105
Car Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 94
Car Dangerous Driving 88
Car Drive a vehicle other than on the carriageway of a motorway 67
Car Motor vehicle fail to accord precedence at a pelican crossing 62
Car Use a motor vehicle / trailer in a condition likely to cause danger of injury 53
Car Driving a vehicle wholly or partly on a footpath 48
Car No Insurance 40
Car Vehicle overtake within crossing limits 38
Car Driver not in position to have Proper Control 34
Car Prohibited vehicle in offside lane of motorway 31
Car No Seat Belt 30
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 20
Car Fail to display front VRM plate 20
Car Duplicate Submission 18
Car Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 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 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
Car No vehicle excise licence 10
Car Drive / Ride / Lead an animal on a footpath 10
Pedal Bike Driving without Due Care and Attention 1615
Pedal Bike Using a Mobile Phone Whilst Driving 1029
Pedal Bike Driving without Reasonable Consideration 788
Pedal Bike Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 309
Pedal Bike Contravening a Red Traffic Light 212
Pedal Bike Stop a vehicle within pelican pedestrian crossing limits 161
Pedal Bike Cause vehicle to be left in a dangerous position 127
Pedal Bike Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 83
Pedal Bike Misc - Non Traffic Offences 56
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 39
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 2791
Pedestrian Cause vehicle to be left in a dangerous position 1258
Pedestrian Misc - Non Traffic Offences 383
Pedestrian Driving without Due Care and Attention 346
Pedestrian Stop a vehicle within pelican pedestrian crossing limits 342
Pedestrian Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 292
Pedestrian Contravening a Red Traffic Light 280
Pedestrian Using a Mobile Phone Whilst Driving 255
Pedestrian Cause unnecessary obstruction by motor vehicle 196
Pedestrian Stop a vehicle on pedestrian crossing 120
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 64
Pedestrian Driving a vehicle wholly or partly on a footpath 54
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 28
Pedestrian No Insurance 20
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 13
Pedestrian Dangerous Driving 12
Pedestrian Fail to display front VRM plate 11