Database of Car Makes and Models. List of UK Vehicle Manufacturers and Types

Preview
CREATE TABLE `car_makes_models` (
  `id` int(11) NOT NULL auto_increment,
  `make` varchar(255) NOT NULL,
  `model` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=740 ;

INSERT INTO `car_makes_models` (`id`, `make`, `model`) VALUES
("1", "AC", "Cobra"),
("2", "Aixam", "500"),
("3", "Aixam", "500.5"),
("4", "Aixam", "A751"),
("5", "Alfa Romeo", "145"),
("6", "Alfa Romeo", "147"),
("7", "Alfa Romeo", "156"),
("8", "Alfa Romeo", "159"),
("9", "Alfa Romeo", "166"),
("10", "Alfa Romeo", "Brera"),
("11", "Alfa Romeo", "Giulietta"),
("12", "Alfa Romeo", "GT"),
("13", "Alfa Romeo", "GTV"),
("14", "Alfa Romeo", "Mito"),
("15", "Alfa Romeo", "RZ"),
("16", "Alfa Romeo", "Spider"),
("17", "Alfa Romeo", "Sportwagon"),
("18", "Asia", "Rocsta"),
("19", "Aston Martin", "DB7"),
("20", "Aston Martin", "DB9"),
("21", "Aston Martin", "DBS"),
("22", "Aston Martin", "V8"),
("23", "Aston Martin", "Vantage"),
("24", "Aston Martin", "Virage"),
("25", "Aston Martin", "Volante"),
("26", "Audi", "80"),
("27", "Audi", "A2"),
("28", "Audi", "A3"),
("29", "Audi", "A4"),
("30", "Audi", "A4 Avant"),
("31", "Audi", "A4 Cabriolet"),
("32", "Audi", "A5"),
("33", "Audi", "A6"),
("34", "Audi", "A6 Avant"),
("35", "Audi", "A8"),
("36", "Audi", "Allroad"),
("37", "Audi", "Cabriolet"),
("38", "Audi", "Convertible"),
("39", "Audi", "Coupe"),
("40", "Audi", "Q5"),
("41", "Audi", "Q7"),
("42", "Audi", "R8"),
("43", "Audi", "RS4"),
("44", "Audi", "RS4 Avant"),
("45", "Audi", "RS5"),
("46", "Audi", "RS6"),
("47", "Audi", "S3"),
("48", "Audi", "S4"),
("49", "Audi", "S5"),
("50", "Audi", "S8"),
("51", "Audi", "TT"),
("52", "Audi", "V8"),
("53", "Austin", "1300"),
("54", "Austin", "Healey"),
("55", "Austin", "Metro"),
("56", "Austin", "Mini"),
("57", "Bentley", "Arnage"),
("58", "Bentley", "Azure"),
("59", "Bentley", "Brooklands"),
("60", "Bentley", "Continental"),
("61", "Bentley", "Eight"),
("62", "Bentley", "Turbo R"),
("63", "BMW", "1 Series"),
("64", "BMW", "3 Series"),
("65", "BMW", "5 Series"),
("66", "BMW", "6 Series"),
("67", "BMW", "7 Series"),
("68", "BMW", "8 Series"),
("69", "BMW", "Alpina"),
("70", "BMW", "M Coupe"),
("71", "BMW", "M3"),
("72", "BMW", "M5"),
("73", "BMW", "M6"),
("74", "BMW", "X1"),
("75", "BMW", "X3"),
("76", "BMW", "X5"),
("77", "BMW", "X6"),
("78", "BMW", "Z3"),
("79", "BMW", "Z4"),
("80", "Bristol", ),
("81", "Buick", "Skylark"),
("82", "Cadillac", "CTS"),
("83", "Cadillac", "Escalade"),
("84", "Chevrolet", "Aveo"),
("
To view the full dump, please login
SQL database dumps

UK car makes and models

Navigation

Popular databases
