📱 Mobile phone enforcement

What happens when someone reports a driver using their phone. With a 65% fine rate, mobile phone use is the most aggressively penalised common offence. Only 27% result in no action. Submitting dashcam evidence of phone use genuinely works.

Custom SQL query returning 8 rows (hide)

select disposal as Outcome, count(*) as Reports, round(100.0 * count(*) / (select count(*) from reports where offence like '%Mobile Phone%'), 1) as [% of phone reports] from reports where offence like '%Mobile Phone%' group by disposal order by Reports desc

Edit SQL

This data as json, CSV

Outcome	Reports	% of phone reports
Fixed Penalty	1216	65.0
NFA	511	27.3
Warning Letter	80	4.3
Court	50	2.7
Education	7	0.4
Other Action Taken	6	0.3
Duplicate Submission	1	0.1
RTC - Actioned	1	0.1