🚗 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 58 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

Edit SQL

This data as json, CSV

MakeTotal reportsFinesCourtNFAAction rate %
Ford 3333 591 124 1127 66.0
Volkswagen 2920 525 165 904 68.0
Mercedes-Benz 2855 517 107 874 69.0
BMW 2661 475 133 894 66.0
Audi 2438 469 119 763 68.0
Toyota 2395 445 66 626 73.0
Vauxhall 1874 307 83 594 68.0
Nissan 1190 228 34 316 73.0
Seat 957 171 58 276 71.0
Peugeot 936 182 42 289 69.0
Land Rover 695 142 31 244 65.0
Honda 654 121 23 201 69.0
Hyundai 652 115 21 187 71.0
Renault 634 126 25 223 65.0
Skoda 562 88 26 197 65.0
Citroen 537 108 15 158 70.0
Kia 508 92 14 155 69.0
Volvo 399 64 15 149 62.0
Fiat 286 55 7 89 69.0
Mini 242 47 9 87 64.0
Mg 214 34 1 66 67.0
Mazda 212 46 6 60 71.0
Jaguar 207 31 11 69 66.0
Tesla 186 49 7 66 65.0
Porsche 185 33 3 70 61.0
Suzuki 162 28 7 56 65.0
Lexus 149 29 5 42 71.0
Daf 144 14 1 71 51.0
Mitsubishi 122 20 9 41 66.0
Yamaha 100 12 12 37 62.0
Iveco 79 12 3 32 58.0
Dacia 73 10 2 27 63.0
Scania 56 3 1 29 48.0
Cupra 53 10 1 15 72.0
Other 50 1 0 27 46.0
Alfa Romeo 43 7 0 23 47.0
Byd 33 4 1 15 55.0
Lamborghini 30 3 3 13 57.0
Isuzu 27 3 1 12 56.0
Chevrolet 26 4 0 6 77.0
Man 24 2 0 16 33.0
Jeep 19 2 3 5 74.0
Chysler 19 5 3 3 84.0
Dennis 18 0 0 8 50.0
Rolls-Royce 15 5 0 3 80.0
Jaecoo 10 1 1 2 80.0
Ferrari 10 2 0 5 50.0
Polestar 8 1 0 3 63.0
S Sangyong 7 1 0 2 71.0
Maxus 7 1 1 4 43.0
London Taxi 7 0 0 3 57.0
Leximoto 7 1 2 4 43.0
Omoda 6 1 0 2 67.0
Kawasaki 5 0 1 2 60.0
Saab 4 1 0 2 50.0
Triumph 1 0 0 1 0.0
Mclaren 1 0 0 0 100.0
Kgm 1 0 0 0 100.0