🚗 Which car makes offend most? (normalised)

Offences per 100,000 registered vehicles of each make. Raw offence counts are misleading because Ford has 5.2 million vehicles on UK roads while Porsche has 238,000. This query normalises against DVLA registration data to show which makes are disproportionately reported.

Custom SQL query returning 25 rows (show)

Edit SQL

This data as json, CSV

MakeOffencesUK registered vehiclesOffences per 100kAction rate %
Seat 885 649,262 136.3 71.0
Mercedes-Benz 2648 2,221,253 119.2 68.0
Toyota 2214 1,985,262 111.5 72.0
Audi 2292 2,066,396 110.9 68.0
BMW 2455 2,225,222 110.3 66.0
Volkswagen 2700 3,719,958 72.6 68.0
Porsche 169 238,169 71.0 60.0
Tesla 175 265,955 65.8 65.0
Ford 3091 5,247,116 58.9 65.0
Land Rover 636 1,096,310 58.0 64.0
Nissan 1093 1,893,494 57.7 73.0
Vauxhall 1737 3,114,601 55.8 68.0
Skoda 527 1,002,599 52.6 64.0
Peugeot 881 1,696,282 51.9 69.0
Hyundai 601 1,183,485 50.8 70.0
Jaguar 186 371,478 50.1 66.0
Renault 593 1,215,728 48.8 64.0
Honda 609 1,249,889 48.7 68.0
Mg 194 407,361 47.6 67.0
Volvo 370 826,216 44.8 62.0
Citroen 504 1,152,313 43.7 70.0
Kia 477 1,283,484 37.2 69.0
Mazda 189 593,773 31.8 70.0
Fiat 263 831,805 31.6 69.0
Mini 227 908,231 25.0 64.0