📱 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	1331	65.4
NFA	554	27.2
Warning Letter	81	4.0
Court	54	2.7
Education	7	0.3
Other Action Taken	6	0.3
Duplicate Submission	1	0.0
RTC - Actioned	1	0.0