🚗 Top vehicle makes (raw count)

Which vehicle makes appear most in offence reports by raw count. See Which car makes offend most? (normalised) for a fairer comparison that accounts for how many of each make are on the road.

Custom SQL query returning 30 rows (hide) 

select vehicle_make as Make, count(*) as [Total reports], sum(case when disposal = 'Fixed Penalty' then 1 else 0 end) as Fines, sum(case when disposal = 'Court' then 1 else 0 end) as Court, sum(case when disposal = 'NFA' then 1 else 0 end) as NFA, round(100.0 * sum(case when disposal not in ('NFA', 'Duplicate Submission') then 1 else 0 end) / count(*), 0) as [Action rate %] from reports where vehicle_make is not null group by vehicle_make order by [Total reports] desc limit 30

Edit SQL

This data as json, CSV

MakeTotal reportsFinesCourtNFAAction rate %
Ford 2827 515 106 972 66.0
Volkswagen 2540 479 146 806 68.0
Mercedes-Benz 2405 466 95 765 68.0
BMW 2254 414 118 774 66.0
Audi 2093 421 100 664 68.0
Toyota 2037 396 57 567 72.0
Vauxhall 1593 280 70 512 68.0
Nissan 1004 203 27 280 72.0
Peugeot 817 171 35 251 69.0
Seat 797 152 46 243 70.0
Land Rover 591 123 30 211 64.0
Honda 565 108 20 184 67.0
Hyundai 553 99 17 167 70.0
Renault 547 115 21 195 64.0
Skoda 486 82 22 178 63.0
Citroen 467 99 14 140 70.0
Kia 441 79 12 140 68.0
Volvo 336 54 13 129 62.0
Fiat 246 50 7 76 69.0
Mini 209 43 8 75 64.0
Mg 178 30 1 60 66.0
Jaguar 171 26 10 58 66.0
Mazda 167 40 4 51 69.0
Tesla 160 45 6 57 64.0
Porsche 154 29 3 62 60.0
Suzuki 140 27 6 51 64.0
Lexus 129 27 4 38 70.0
Daf 125 12 1 65 48.0
Mitsubishi 99 20 6 37 63.0
Yamaha 88 12 9 34 61.0