-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 21, 2022 at 09:16 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `teoalida databases`
--

-- --------------------------------------------------------

--
-- Table structure for table `car_models_list_by_teoalida_sample`
--

CREATE TABLE `car_models_list_by_teoalida_sample` (
  `Make` varchar(120) DEFAULT NULL,
  `Model` varchar(38) DEFAULT NULL,
  `Platform / generation number` varchar(28) DEFAULT NULL,
  `European / World classification` varchar(29) DEFAULT NULL,
  `Production years` varchar(20) DEFAULT NULL,
  `American classification` varchar(24) DEFAULT NULL,
  `Model Years (US/Canada)` varchar(18) DEFAULT NULL,
  `Country of origin` varchar(13) DEFAULT NULL,
  `Sold in Europe` varchar(11) DEFAULT NULL,
  `Sold in North America` varchar(11) DEFAULT NULL,
  `Sold in India` varchar(5) DEFAULT NULL,
  `Units produced` varchar(25) DEFAULT NULL,
  `Notes` varchar(124) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `car_models_list_by_teoalida_sample`
--

INSERT INTO `car_models_list_by_teoalida_sample` (`Make`, `Model`, `Platform / generation number`, `European / World classification`, `Production years`, `American classification`, `Model Years (US/Canada)`, `Country of origin`, `Sold in Europe`, `Sold in North America`, `Sold in India`, `Units produced`, `Notes`) VALUES
('CAR MODELS LIST - Worldwide version', '', '', '', '', '', '', '', '', '', '', '', ''),
('Original research by Teoalida ? cardatabase.teoalida.com', '', '', '', '', '', '', '', '', '', '', '', ''),
('This is a SAMPLE, including 4 makes, one for each continent (295 models)', '', '', '', '', '', '', '', '', '', '', '', ''),
('Visit above website for the FULL database (Worldwide, 220+ makes, 6000+ models or Europe-only, 170+ makes, 3000+ models)', '', '', '', '', '', '', '', '', '', '', '', ''),
('See \"Car manufacturers\" sheet of this sample for list of makes included and number of models for each', '', '', '', '', '', '', '', '', '', '', '', ''),
('BMW', 'Dixi 3/15', '-', '??', '1927-1929', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '3/15', '-', '??', '1929-1932', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '3/20', '-', '??', '1932-1934', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '309', '-', '??', '1934-1936', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '315, 319, 329', '-', '??', '1934-1937', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '320', '-', '??', '1937-1938', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '321', '-', '??', '1938-1941, 1945-1950', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '326', '-', '??', '1936-1941', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '327', '-', '??', '1936-1941, 1946-1955', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '335', '-', '??', '1939-1941', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '328', '-', 'Sports car', '1936-1940', '', '', 'Germany', 'Europe', 'no', 'no', '', 'Old models pre-war'),
('BMW', '250 Isetta, 300 Isetta', '-', 'Bubble car (4-wheeler)', '1955-1962', 'Subcompact car', 'MY 1955-1962', 'Germany', 'Europe', 'America', 'no', '161728', 'Old models post-war'),
('BMW', '600', '-', 'Small car', '1957-1959', 'Subcompact car', 'MY 1957-1960', 'Germany', 'Europe', 'America', 'no', '34813', 'Old models post-war'),
('BMW', '700', '-', 'Small car', '1959-1964', 'Subcompact car', 'MY 1959-1965', 'Germany', 'Europe', 'America', 'no', '188211', 'Old models post-war'),
('BMW', 'i3', 'I01', 'Small car', '2013-____', 'Subcompact car', 'MY 2014-____', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', '1-Series', 'E81, E82, E87, E88', 'Compact car', '2004-2014', '', '', 'Germany', 'Europe', 'no', 'no', '', ''),
('BMW', '1-Series', 'F20, F21', 'Compact car', '2011-2019', '', '', 'Germany', 'Europe', 'no', 'India', '', ''),
('BMW', '1-Series', 'F40', 'Compact car', '2019-____', '', '', 'Germany', 'Europe', 'no', 'India', '', ''),
('BMW', '2-Series', 'F22, F23, F87', 'Compact sports car', '2014-____', 'Compact car', 'MY 2015-____', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', '2-Series Active Tourer, Gran Tourer', 'F45, F46', 'Compact MPV', '2014-____', '', '', 'Germany', 'Europe', 'no', '?', '', ''),
('BMW', '2-Series Active Tourer, Gran Tourer', 'U06', 'Compact MPV', '2021-____', '', '', 'Germany', 'Europe', 'no', '?', '', ''),
('BMW', '2-Series', 'G42', 'Compact sports car', '2021-____', 'Compact car', 'MY ??', 'Germany', 'Europe', '?', 'no', '', ''),
('BMW', '2-Series Gran Coup?,F44', 'Compact car', '2019-____', 'Compact car', 'MY 2020-____', 'Germany', 'Europe', 'America', 'no', '', '', NULL),
('BMW', '1-Series', 'F52', 'Compact car', '2017-____', '', '', 'China', 'no', 'no', 'no', '', ''),
('BMW', 'New Class 1602, 1802, 2002', 'Type 114, E6, E10, E20', 'Medium car', '1966-1975', 'Compact car', 'MY 1968-1976', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', '3-Series', 'E21', 'Medium car', '1975-1983', 'Compact car', 'MY 1975-1983?', 'Germany', 'Europe', 'America', 'no', '1364039', ''),
('BMW', '3-Series, M3', 'E30', 'Medium car', '1982-1994', 'Compact car', 'MY 1984-1991?', 'Germany', 'Europe', 'America', 'no', '2339520', ''),
('BMW', '3-Series, M3', 'E36', 'Medium car', '1990-2000', 'Compact car', 'MY 1992-1999', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', '3-Series, M3', 'E46', 'Medium car', '1998-2006', 'Compact car', 'MY 1999-2006', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '3-Series, M3', 'E90, E91, E92, E93', 'Medium car', '2005-2013', 'Compact car', 'MY 2006-2013', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '3-Series, M3', 'F30, F31, F80,', 'Medium car', '2012-____', 'Compact car', 'MY 2013-____', 'Germany', 'Europe', 'America', 'India', '', 'Also F35 long-wheelbase sedan sold only in China'),
('BMW', '4-Series, M4', 'F32, F33, F36, F82, F83', 'Medium sports car', '2013-____', 'Compact car', 'MY 2014-____', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '3-Series, M3', 'G20, G21', 'Medium car', '2019-____', 'Compact car', 'MY 2020-____', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '4-Series, M4', 'G22, G23, G26', 'Medium sports car', '2020-____', 'Compact car', 'MY ??', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '3-Series GT', 'F34', 'Medium car', '2013-2020', 'Compact car', 'MY 2014-2019', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'i4', 'G26', 'Medium car', '2021-____', 'Compact car', 'MY 2022-____', 'Germany', 'Europe', 'America', '?', '', ''),
('BMW', 'New Class 1500, 1600, 1800, 2000', 'Type 115, 116, 118, 120, 121', 'Large car', '1962-1972', 'Mid-size car', 'MY 1962-1972', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', '5-Series', 'E12', 'Large car', '1972-1981', 'Mid-size car', 'MY 1975-1981', 'Germany', 'Europe', 'America', 'no', '699094', ''),
('BMW', '5-Series, M5', 'E28', 'Large car', '1981-1988', 'Mid-size car', 'MY 1982-1988', 'Germany', 'Europe', 'America', 'no', '722328', ''),
('BMW', '5-Series, M5', 'E34', 'Large car', '1988-1996', 'Mid-size car', 'MY 1989-1996', 'Germany', 'Europe', 'America', 'no', '1333412', ''),
('BMW', '5-Series, M5', 'E39', 'Large car', '1995-2004', 'Mid-size car', 'MY 1997-2003', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', '5-Series, M5', 'E60, E61', 'Large car', '2003-2011', 'Mid-size car', 'MY 2004-2009', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '5-Series, M5', 'F10, F11, ', 'Large car', '2009-2017', 'Mid-size car', 'MY 2010-2016', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '5-Series, M5', 'G30, G31', 'Large car', '2017-____', 'Mid-size car', 'MY 2017-____', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '5-Series GT', 'F07', 'Large car', '2009-2017', 'Mid-size car', 'MY 2010-2017', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '6-Series GT', 'G32', 'Large car', '2017-____', 'Mid-size car', 'MY 2018-____', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'New Six CS', 'E9', 'Large sports car', '1968-1975', 'Grand tourer', 'MY 1968-1973', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', '6-Series, M6', 'E24', 'Large sports car', '1976-1989', 'Grand tourer', 'MY 1977-1989', 'Germany', 'Europe', 'America', 'no', '86216', ''),
('BMW', '8-Series', 'E31', 'Luxury sports car', '1989-1998', 'Grand tourer', 'MY 1991-1997', 'Germany', 'Europe', 'America', 'no', '31062', ''),
('BMW', '6-Series, M6', 'E63, E64', 'Large sports car', '2003-2011', 'Grand tourer', 'MY 2004-2010', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '6-Series, M6', 'F12, F13', 'Large sports car', '2011-2018', 'Grand tourer', 'MY 2012-2018', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '8-Series', 'G14, G15, G16', 'Luxury sports car', '2018-____', 'Grand tourer', 'MY 2019-____', 'Germany', 'Europe', '?', '?', '', ''),
('BMW', '501', '-', 'Luxury car', '1952-1962', 'Full-size car', 'MY 1952-1961', 'Germany', 'Europe', 'America', 'no', '', 'Old models post-war'),
('BMW', '502', '-', 'Luxury car', '1954-1964', 'Full-size car', 'MY 1954-1964', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', '503', '-', 'Luxury sports car', '1956-1959', 'Full-size car', 'MY 1956-1959', 'Germany', 'Europe', 'America', 'no', '', 'Old models post-war'),
('BMW', '3200 CS', '-', 'Luxury sports car', '1962-1965', 'Full-size car', 'MY 1962-1965', 'Germany', 'Europe', 'America', 'no', '', 'Old models post-war'),
('BMW', 'New Six', 'E3', 'Luxury car', '1968-1977', 'Full-size car', 'MY 1971-1976', 'Germany', 'Europe', 'America', 'no', '221991', ''),
('BMW', '7-Series', 'E23', 'Luxury car', '1977-1986', 'Full-size car', 'MY 1978-1987?', 'Germany', 'Europe', 'America', 'no', '285029', ''),
('BMW', '7-Series', 'E32', 'Luxury car', '1986-1994', 'Full-size car', 'MY 1987?-1994', 'Germany', 'Europe', 'America', 'no', '311068', ''),
('BMW', '7-Series', 'E38', 'Luxury car', '1994-2001', 'Full-size car', 'MY 1995-2001', 'Germany', 'Europe', 'America', 'no', '340242', ''),
('BMW', '7-Series', 'E65, E66', 'Luxury car', '2001-2008', 'Full-size car', 'MY 2002-2009', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '7-Series', 'F01, F02', 'Luxury car', '2008-2015', 'Full-size car', 'MY 2010-2015', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '7-Series', 'G10, G11', 'Luxury car', '2015-2022', 'Full-size car', 'MY 2016-2022', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', '7-Series', 'G70', 'Luxury car', '2022-____', 'Full-size car', 'MY 2023-____', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'Z1', 'E30', 'Sports compact / roadster car', '1989-1991', '', '', 'Germany', 'Europe', 'no', 'no', '~8000', ''),
('BMW', 'Z3, M', 'E36', 'Sports compact / roadster car', '1996-2002', 'Roadster car', 'MY 1996-2002', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', 'Z4', 'E85, E86', 'Sports compact / roadster car', '2002-2008', 'Roadster car', 'MY 2003-2008', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', 'Z4', 'E89', 'Sports compact / roadster car', '2009-2016', 'Roadster car', 'MY 2009-2016', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'Z4', 'G29', 'Sports compact / roadster car', '2019-____', 'Roadster car', 'MY 2019-____', 'Germany', 'Europe', 'America', '?', '', ''),
('BMW', '507', '-', 'Roadster car', '1956-1959', 'Roadster car', 'MY 1956-1959', 'Germany', 'Europe', 'America', 'no', '', 'Old models post-war'),
('BMW', 'M1', 'E26', 'Sports car', '1978-1981', 'Sports car', 'MY 1978-1981', 'Germany', 'Europe', 'America', 'no', '456', ''),
('BMW', 'Z8', 'E52', 'Sports car', '1999-2003', 'Sports car', 'MY 2000-2003', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', 'i8', 'I12', 'Sports car', '2013-2020', 'Sports car', 'MY 2014-2020', 'Germany', 'Europe', 'America', 'India', '20465', ''),
('BMW', 'X1', 'E84', 'Compact SUV', '2009-2015', 'Compact SUV', 'MY 2013-2015', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'X1', 'F48', 'Compact SUV', '2015-____', 'Compact SUV', 'MY 2016-____', 'Germany', 'Europe', 'America', '?', '', ''),
('BMW', 'X2', 'F39', 'Compact crossover', '2017-____', 'Compact crossover', 'MY 2018-____', 'Germany', 'Europe', 'America', '?', '', ''),
('BMW', 'X3', 'E83', 'Medium SUV', '2003-2010', 'Compact SUV', 'MY 2004-2010', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'X3', 'F25', 'Medium SUV', '2010-2017', 'Compact SUV', 'MY 2011-2017', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'X3', 'G01', 'Medium SUV', '2017-____', 'Compact SUV', 'MY 2018-____', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'X4', 'F26', 'Medium crossover', '2014-2018', 'Compact crossover', 'MY 2015-____', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', 'X4', 'G02', 'Medium crossover', '2018-____', 'Compact crossover', 'MY ??', 'Germany', 'Europe', 'America', 'no', '', ''),
('BMW', 'X5', 'E53', 'Large SUV', '1999-2006', 'Mid-size SUV', 'MY 2000-2006', 'Germany', 'Europe', 'America', 'no', '', 'Production and sales in North America started in 1999, sales in Europe started in 2000'),
('BMW', 'X5', 'E70', 'Large SUV', '2006-2013', 'Mid-size SUV', 'MY 2007-2013', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'X5', 'F15, F85', 'Large SUV', '2013-2018', 'Mid-size SUV', 'MY 2014-2018', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'X5', 'G05', 'Large SUV', '2018-____', 'Mid-size SUV', 'MY 2019-____', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'X6', 'E71, E72', 'Large crossover', '2008-2014', 'Mid-size crossover SUV', 'MY 2008-2014', 'Germany', 'Europe', 'America', 'India', '', 'Wikipedia shows launch in MY 2009 but Edmunds show MY 2008'),
('BMW', 'X6', 'F16, F86', 'Large crossover', '2014-2018', 'Mid-size crossover SUV', 'MY 2015-2019', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'X6', 'G06', 'Large crossover', '2019-____', 'Mid-size crossover SUV', 'MY 2020-____', 'Germany', 'Europe', 'America', 'India', '', ''),
('BMW', 'iX', 'I20', 'Large crossover', '2021-____', 'Mid-size crossover SUV', 'MY 2022-____', 'Germany', 'Europe', 'America', '?', '', ''),
('BMW', 'X7', 'G07', 'Luxury SUV', '2018-____', 'Luxury SUV', 'MY 2019-____', 'Germany', 'Europe', 'America', 'India', '', ''),
('Cadillac', 'Cimarron', '-', '', '', 'Compact car', 'MY 1982-1988', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'BLS', '-', 'Medium car', '2005-2010', '', '', 'United States', 'Europe', 'no', 'no', '', 'Sold only in Europe 2005-2010'),
('Cadillac', 'ATS', '-', 'Medium car', '2012-2019', 'Compact car', 'MY 2013-2019', 'United States', 'Europe', 'America', 'no', '', 'Imported in Europe 2012-____'),
('Cadillac', 'CT4', '-', '??', '2019-____', 'Compact car', 'MY 2020-____', 'United States', '?', 'America', 'no', '', ''),
('Cadillac', 'ELR', '-', '', '', 'Compact car', 'MY 2014, 2016', 'United States', '?', 'America', 'no', '', ''),
('Cadillac', 'Catera', '-', '', '', 'Mid-size car', 'MY 1997-2001', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'CTS, CTS-V', '1st gen', 'Large car', '2002-2007', 'Mid-size car', 'MY 2003-2007', 'United States', 'Europe', 'America', 'no', '', 'Imported in Europe 2002-2007'),
('Cadillac', 'CTS, CTS-V', '2nd gen', 'Large car', '2007-2010', 'Mid-size car', 'MY 2008-2013', 'United States', 'Europe', 'America', 'no', '', 'Imported in Europe 2007-2010'),
('Cadillac', 'CTS, CTS-V', '3rd gen', '', '', 'Mid-size car', 'MY 2014-2019', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'CT5', '-', '', '', 'Mid-size car', 'MY 2020-____', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60', '-', '', '', 'Mid-size car', 'MY 1936-1938', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 61', '1st gen', '', '', 'Mid-size car', 'MY 1939', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 61', '2nd gen', '', '', 'Mid-size car', 'MY 1941', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 61', '3rd gen', '', '', 'Mid-size car', 'MY 1942-1947', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 61', '4th gen', '', '', 'Mid-size car', 'MY 1948-1951', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 65', '-', '', '', 'Mid-size car', 'MY 1937-1938', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 62', '1st gen', '', '', 'Mid-size car', 'MY 1940-1941', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 62', '2nd gen', '', '', 'Mid-size car', 'MY 1942-1947', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 62', '3rd gen', '', '', 'Mid-size car', 'MY 1948-1953', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 62', '4th gen', '', '', 'Mid-size car', 'MY 1954-1956', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 62', '5th gen', '', '', 'Mid-size car', 'MY 1957-1958', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', '6200', '1st gen', '', '', 'Mid-size car', 'MY 1959-1960', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', '6200', '2nd gen', '', '', 'Mid-size car', 'MY 1961-1964', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Calais', '1st gen', '', '', 'Mid-size car', 'MY 1965-1970', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Calais', '2nd gen', '', '', 'Mid-size car', 'MY 1971-1976', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Seville', '1st gen', '', '', 'Mid-size car', 'MY 1975-1979', 'United States', '?', 'America', 'no', '', ''),
('Cadillac', 'Seville', '2nd gen', '', '', 'Mid-size car', 'MY 1980-1985', 'United States', '?', 'America', 'no', '', ''),
('Cadillac', 'Seville', '3rd gen', 'Luxury car', '??-1992', 'Mid-size car', 'MY 1986-1991', 'United States', 'Europe', 'America', 'no', '', ''),
('Cadillac', 'Seville', '4th gen', 'Luxury car', '1992-1997', 'Mid-size car', 'MY 1992-1997', 'United States', 'Europe', 'America', 'no', '', 'Imported in Europe 1991-1996'),
('Cadillac', 'Seville', '5th gen', 'Luxury car', '1997-2004', 'Mid-size car', 'MY 1998-2004', 'United States', 'Europe', 'America', 'no', '', 'Imported in Europe 1997-2004'),
('Cadillac', 'STS', '-', 'Luxury car', '1994-2010', 'Mid-size car', 'MY 2005-2011', 'United States', 'Europe', 'America', 'no', '', 'Imported in Europe 2004-2010'),
('Cadillac', 'Sedan de Ville', '1st gen', '', '', 'Full-size car', 'MY 1959-1960', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Sedan de Ville', '2nd gen', '', '', 'Full-size car', 'MY 1961-1964', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Sedan de Ville', '3rd gen', '', '', 'Full-size car', 'MY 1965-1970', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Sedan de Ville', '4th gen', '', '', 'Full-size car', 'MY 1971-1976', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Sedan de Ville', '5th gen', '', '', 'Full-size car', 'MY 1977-1984', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Sedan de Ville', '6th gen', '', '', 'Full-size car', 'MY 1985-1993', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Sedan de Ville', '7th gen', '', '', 'Full-size car', 'MY 1994-1999', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Sedan de Ville', '8th gen', '', '', 'Full-size car', 'MY 2000-2005', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'DTS', '-', '', '', 'Full-size car', 'MY 2006-2011', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'XTS', '-', '', '', 'Full-size car', 'MY 2013-2019', 'United States', 'no', 'America', 'no', '', 'Produced also in China 2013-2020'),
('Cadillac', 'CT6', '-', '', '', 'Full-size car', 'MY 2016-2020', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Coupe de Ville', '1st gen', '', '', 'Full-size car', 'MY 1959-1960', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Coupe de Ville', '2nd gen', '', '', 'Full-size car', 'MY 1961-1964', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Coupe de Ville', '3rd gen', '', '', 'Full-size car', 'MY 1965-1970', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Coupe de Ville', '4th gen', '', '', 'Full-size car', 'MY 1971-1976', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Coupe de Ville', '5th gen', '', '', 'Full-size car', 'MY 1977-1984', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Coupe de Ville', '6th gen', '', '', 'Full-size car', 'MY 1985-1993', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '1st gen', '', '', 'Full-size car', 'MY 1938-1941', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '2nd gen', '', '', 'Full-size car', 'MY 1942-1947', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '3rd gen', '', '', 'Full-size car', 'MY 1948-1949', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '4th gen', '', '', 'Full-size car', 'MY 1950-1953', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '5th gen', '', '', 'Full-size car', 'MY 1954-1956', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '6th gen', '', '', 'Full-size car', 'MY 1957-1958', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '7th gen', '', '', 'Full-size car', 'MY 1959-1960', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '8th gen', '', '', 'Full-size car', 'MY 1961-1964', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '9th gen', '', '', 'Full-size car', 'MY 1965-1970', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '10th gen', '', '', 'Full-size car', 'MY 1971-1976', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 60 (Sixty Special)', '11th gen', '', '', 'Full-size car', 'MY 1987-1993', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Fleetwood Brougham', '-', '', '', 'Full-size car', 'MY 1977-1986', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Brougham', '-', '', '', 'Full-size car', 'MY 1987-1992', 'United States', '?', 'America', 'no', '', ''),
('Cadillac', 'Fleetwood', '1st gen', '', '', 'Full-size car', 'MY 1985-1992', 'United States', '?', 'America', 'no', '', 'Imported in Europe ?-1993'),
('Cadillac', 'Fleetwood', '2nd gen', 'Luxury car', '??-1993', 'Full-size car', 'MY 1993-1996', 'United States', 'Europe', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '1st gen', '', '', 'Full-size car', 'MY 1936-1937', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '2nd gen', '', '', 'Full-size car', 'MY 1938-1940', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '3rd gen', '', '', 'Full-size car', 'MY 1941-1949', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '4th gen', '', '', 'Full-size car', 'MY 1950-1953', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '5th gen', '', '', 'Full-size car', 'MY 1954-1956', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '6th gen', '', '', 'Full-size car', 'MY 1957-1958', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '7th gen', '', '', 'Full-size car', 'MY 1959-1960', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '8th gen', '', '', 'Full-size car', 'MY 1961-1965', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '9th gen', '', '', 'Full-size car', 'MY 1966-1970', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Series 75', '10th gen', '', '', 'Full-size car', 'MY 1971-1976', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Fleetwood Limousine', '-', '', '', 'Full-size car', 'MY 1977-1984', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Fleetwood 75', '-', '', '', 'Full-size car', 'MY 1985-1987', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '1st gen', '', '', 'Personal luxury car', 'MY 1953', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '2nd gen', '', '', 'Personal luxury car', 'MY 1954-1956', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '3rd gen', '', '', 'Personal luxury car', 'MY 1957-1958', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '4th gen', '', '', 'Personal luxury car', 'MY 1959-1960', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '5th gen', '', '', 'Personal luxury car', 'MY 1961-1964', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '6th gen', '', '', 'Personal luxury car', 'MY 1965-1966', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '7th gen', '', '', 'Personal luxury car', 'MY 1967-1970', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '8th gen', '', '', 'Personal luxury car', 'MY 1971-1978', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '9th gen', '', '', 'Personal luxury car', 'MY 1979-1985', 'United States', '?', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '10th gen', '', '', 'Personal luxury car', 'MY 1986-1991', 'United States', '?', 'America', 'no', '', ''),
('Cadillac', 'Eldorado', '11th gen', 'Luxury car', '1993-1996', 'Personal luxury car', 'MY 1992-2002', 'United States', 'Europe', 'America', 'no', '', ''),
('Cadillac', 'XT4', '-', '', '', 'Compact SUV', 'MY 2019-____', 'United States', '?', 'America', 'no', '', ''),
('Cadillac', 'SRX', '1st gen', '', '', 'Mid-size SUV', 'MY 2004-2009', 'United States', 'no', 'America', 'no', '', 'Imported in Europe 2004-2010'),
('Cadillac', 'SRX', '2nd gen', '', '', 'Mid-size SUV', 'MY 2010-2016', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'XT5', '-', '', '', 'Mid-size SUV', 'MY 2017-____', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'XT6', '-', '', '', 'Mid-size SUV', 'MY 2020-____', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Lyriq', '-', '', '', 'Mid-size crossover SUV', 'MY 2023-____', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Escalade', '1st gen', '', '', 'Full-size SUV', 'MY 1999-2000', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Escalade', '2nd gen', '', '', 'Full-size SUV', 'MY 2002-2006', 'United States', 'no', 'America', 'no', '', ''),
('Cadillac', 'Escalade', '3rd gen', 'Luxury SUV', '2007-2009', 'Full-size SUV', 'MY 2007-2014', 'United States', 'Europe', 'America', 'no', '', 'Imported in Europe 2007-2009'),
('Cadillac', 'Escalade', '4rd gen', '', '', 'Full-size SUV', 'MY 2015-2020', 'United States', 'no', 'America', 'no', '', 'Imported in Europe 2007-2009'),
('Cadillac', 'Escalade', '5th gen', '', '', 'Full-size SUV', 'MY 2021-____', 'United States', 'no', 'America', 'no', '', 'Imported in Europe 2007-2009'),
('Cadillac', 'Allant?,-', 'Roadster car', '??-1993', 'Roadster car', 'MY 1987-1993', 'United States', 'Europe', 'America', 'no', '', 'Imported in Europe ?-1993', NULL),
('Cadillac', 'XLR', '-', 'Roadster car', '2004-2009', 'Roadster car', 'MY 2004-2009', 'United States', 'Europe', 'America', 'no', '', 'Imported in Europe 2004-2009'),
('Kia', 'Picanto', '1st gen TA', 'Mini car', '2004-2011', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Picanto', '2nd gen SA', 'Mini car', '2011-2017', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Picanto', '3rd gen JA', 'Mini car', '2017-____', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Ray', '-', 'Mini car', '2011-____', '', '', 'South Korea', 'no', 'no', 'no', '', 'Sold only in South Korea'),
('Kia', 'Pride', '1st gen', 'Small car', '1986-1995', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Pride', '2nd gen', 'Small car', '1995-2001', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Rio', '1st gen DC', 'Small car', '2000-2005', 'Subcompact car', 'MY 2001-2005', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Rio', '2nd gen JB', 'Small car', '2005-2011', 'Subcompact car', 'MY 2006-2011', 'South Korea', 'no', 'America', 'no', '', ''),
('Kia', 'Rio', '3rd gen UB', 'Small car', '2011-2017', 'Subcompact car', 'MY 2012-2017', 'South Korea', 'no', 'America', 'no', '', 'Sold in China as Kia K2'),
('Kia', 'Rio', '4th gen SC', 'Small car', '2017-____', 'Subcompact car', 'MY 2018-____', 'South Korea', 'no', 'America', 'no', '', ''),
('Kia', 'Soul', '1st gen AM', 'Small car', '2008-2013', 'Subcompact car', 'MY 2010-2013', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Soul', '2nd gen PS', 'Small car', '2014-2019', 'Subcompact car', 'MY 2014-2019', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Soul', '-', 'Small car', '2019-____', 'Subcompact car', 'MY 2020-____', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Pegas / Soluto', '-', 'Small car', '2017-____', '', '', 'China', 'no', 'no', 'no', '', 'Sold in China and Middle East as Kia Pegas, and in South America and Southeast Asia as Kia Soluto'),
('Kia', 'Avella', '-', 'Compact car', '1994-1998', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Cee\'d', '1st gen ED', 'Compact car', '2006-2012', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Cee\'d', '2nd gen JD', 'Compact car', '2012-2018', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Cee\'d', '3rd gen CD', 'Compact car', '2018-____', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Sephia', '1st gen', 'Compact car', '1992-1997', 'Compact car', 'MY 1994-1997', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Sephia', '2nd gen', 'Compact car', '1997-2003', 'Compact car', 'MY 1998-2001', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Cerato / Spectra', 'LD', 'Compact car', '2003-2008', 'Compact car', 'MY 2005-2009', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in North America as Kia Spectra'),
('Kia', 'Forte', '1st gen TD', 'Compact car', '2008-2013', 'Compact car', 'MY 2010-2013', 'South Korea', 'Only Russia', 'America', 'no', '', ''),
('Kia', 'Forte / K3', '2nd gen YD', 'Compact car', '2013-2018', 'Compact car', 'MY 2014-2018', 'South Korea', 'Only Russia', 'America', 'no', '', ''),
('Kia', 'Forte / K3', '3rd gen BD', 'Compact car', '2018-____', 'Compact car', 'MY 2019-____', 'South Korea', 'Only Russia', 'America', 'no', '', ''),
('Kia', 'Shuma', '-', 'Compact-medium car', '1998-2003', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'K4', '-', 'Compact-medium car', '2014-2021', '', '', 'China', 'no', 'no', 'no', '', 'Sold only in China'),
('Kia', 'Concord', '-', 'Medium car', '1987-1995', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Clarus', '-', 'Medium car', '1995-2001', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Magentis / Optima', '1st gen MS', 'Medium car', '2001-2006', 'Mid-size car', 'MY 2001-2006', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in North America as Kia Optima'),
('Kia', 'Magentis / Optima', '2nd gen MG', 'Medium car', '2006-2010', 'Mid-size car', 'MY 2007-2010', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in North America as Kia Optima'),
('Kia', 'Magentis / Optima / K5', '3rd gen TF', 'Medium car', '2010-2015', 'Mid-size car', 'MY 2011-2015', 'South Korea', 'no', 'America', 'no', '', 'Sold in North America as Kia Optima'),
('Kia', 'Magentis / Optima / K5', '4th gen JF', 'Medium car', '2015-2019', 'Mid-size car', 'MY 2016-2020', 'South Korea', 'no', 'America', 'no', '', 'Sold in North America as Kia Optima'),
('Kia', 'Magentis / Optima / K5', '5th gen', 'Medium car', '2019-____', 'Mid-size car', 'MY 2021-____', 'South Korea', 'no', 'America', 'no', '', 'Sold in North America as Kia K5'),
('Kia', 'Stinger', '-', 'Medium car', '2017-____', 'Mid-size car', 'MY 2018-____', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Potentia', '1st gen', 'Large-luxury car', '1992-1997', '', '', 'South Korea', 'no', 'no', 'no', '', 'Rebadged Mazda Luce'),
('Kia', 'Potentia', '2nd gen', 'Large-luxury car', '1997-2002', '', '', 'South Korea', 'no', 'no', 'no', '', 'Rebadged Mazda Luce'),
('Kia', 'Enterprise', '-', 'Large-luxury car', '1997-2002', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Opirus / Amanti', '-', 'Large-luxury car', '2002-2011', 'Full-size car', 'MY 2004-2010', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in North America as Kia Amanti'),
('Kia', 'Cadenza / K7', '1st gen VG', 'Large-luxury car', '2010-2016', 'Full-size car', 'MY 2014-2016', 'South Korea', 'no', 'America', 'no', '', ''),
('Kia', 'Cadenza / K7', '2nd gen YG', 'Large-luxury car', '2016-2021', 'Full-size car', 'MY 2017-2021', 'South Korea', 'no', 'America', 'no', '', ''),
('Kia', 'K8', '-', 'Large-luxury car', '2021-____', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Quoris / K9 / K900', '1st gen KH', 'Luxury car', '2012-2018', 'Full-size car', 'MY 2015-2018', 'South Korea', 'Only Russia', 'America', 'no', '', ''),
('Kia', 'Quoris / K9 / K900', '2nd gen RJ', 'Luxury car', '2018-____', 'Full-size car', 'MY 2019-____', 'South Korea', 'Only Russia', 'America', 'no', '', ''),
('Kia', 'Elan / Vegato', '-', 'Roadster car', '1996-1999', '', '', 'South Korea', 'no', 'no', 'no', '1056', 'Rebadged Lotus Elan, sold in Japan as Kia Vegato'),
('Kia', 'Venga', '-', 'Small MPV', '2009-____', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Carens', '1st gen RS', 'Compact MPV', '2001-2006', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Carens / Rondo', '2nd gen UN', 'Compact MPV', '2006-2013', 'Compact MPV', 'MY 2007-2012', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in North America and Australia as Kia Rondo, US sales ended MY 2009, Canada continue'),
('Kia', 'Carens / Rondo', '3rd gen RP', 'Compact MPV', '2013-2019', 'Compact MPV', 'MY 2014-2017', 'South Korea', 'Europe', 'Only Canada', 'no', '', 'Sold in Canada and Australia as Kia Rondo'),
('Kia', 'Joice', '-', 'Medium MPV', '1999-2002', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Carnival / Sedona', '1st gen KV-II', 'Large MPV', '1998-2006', 'Minivan', 'MY 2002-2005', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in North America as Kia Sedona'),
('Kia', 'Carnival / Sedona', '2nd gen VQ', 'Large MPV', '2006-2014', 'Minivan', 'MY 2006-2012, 2014', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in North America as Kia Sedona'),
('Kia', 'Carnival / Sedona', '3rd gen YP', 'Large MPV', '2014-____', 'Minivan', 'MY 2015-2021', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in North America as Kia Sedona'),
('Kia', 'Carnival', '4th gen KA4', 'Large MPV', '2020-____', 'Minivan', 'MY 2022-____', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in North America as Kia Carnival'),
('Kia', 'Retona', '-', 'Light off-road vehicle', '1998-2003', '', '', 'South Korea', 'Europe', 'no', 'no', '', ''),
('Kia', 'Stonic', '-', 'Small crossover', '2017-____', '', '', 'South Korea', 'Europe', 'no', 'no', '', 'Sold in China as Kia KX1'),
('Kia', 'KX Cross', '-', 'Small crossover', '2017-____', '', '', 'China', 'no', 'no', 'no', '', 'Sold only in China'),
('Kia', 'Seltos', '-', 'Small crossover', '2019-____', 'Subcompact crossover SUV', 'MY 2021-____', 'South Korea', 'no', 'America', 'no', '', ''),
('Kia', 'Niro', '1st gen DE', 'Compact crossover', '2016-____', 'Compact crossover SUV', 'MY 2017-____', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Niro', '2nd gen SG2', 'Compact crossover', '2021-____', 'Compact crossover SUV', 'MY ??', 'South Korea', 'Europe', '?', 'no', '', ''),
('Kia', 'EV6', '-', 'Compact crossover', '2021-____', 'Compact crossover SUV', 'MY 2022-____', 'South Korea', '?', 'America', 'no', '', ''),
('Kia', 'Sonet', '-', 'Small SUV', '2020-____', '', '', 'India', 'no', 'no', 'India', '', ''),
('Kia', 'KX3 / Aopao', '1st gen KC', 'Small crossover', '2015-2019', '', '', 'China', 'no', 'no', 'no', '', ''),
('Kia', 'KX3 / Aopao', '2nd gen SP2C', 'Small crossover', '2019-____', '', '', 'China', 'no', 'no', 'no', '', ''),
('Kia', 'Sportage', '1st gen JA', 'Compact SUV', '1995-2002', 'Compact SUV', 'MY 1995-2002', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Sportage', '2nd gen SE', 'Compact SUV', '2004-2010', 'Compact SUV', 'MY 2005-2010', 'South Korea', 'Europe', 'America', 'no', '', 'China 2005-2015'),
('Kia', 'Sportage', '3rd gen SL', 'Compact SUV', '2010-2015', 'Compact SUV', 'MY 2011-2016', 'South Korea', 'Europe', 'America', 'no', '', 'China 2010-2018'),
('Kia', 'Sportage / KX5', '4th gen QL', 'Compact SUV', '2015-2021', 'Compact SUV', 'MY 2017-2022', 'South Korea', 'Europe', 'America', 'no', '', 'Sold in China as Kia KX5'),
('Kia', 'Sportage', '5th gen NQ5', 'Compact SUV', '2021-____', 'Compact SUV', 'MY 2023-____', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Sorento', '1st gen BL', 'Medium SUV', '2002-2009', 'Mid-size SUV', 'MY 2003-2009', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Sorento', '2nd gen XM', 'Medium SUV', '2009-2015', 'Mid-size SUV', 'MY 2011-2015', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Sorento', '3rd gen UM', 'Medium SUV', '2015-____', 'Mid-size SUV', 'MY 2016-2020', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'Sorento', '4th gen MQ4', 'Medium SUV', '2020-____', 'Mid-size SUV', 'MY 2021-____', 'South Korea', 'Europe', 'America', 'no', '', ''),
('Kia', 'KX7', '-', 'Medium SUV', '2016-2021', '', '', 'China', 'no', 'no', 'no', '', ''),
('Kia', 'Mohave / Borrego', '1st gen HM', 'Large SUV', '2008-2019', 'Full-size SUV', 'MY 2009-2011', 'South Korea', 'no', 'America', 'no', '', 'Sold in North America and China as Kia Borrego'),
('Kia', 'Mohave', '2nd gen HM2', 'Large SUV', '2019-____', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Telluride', '-', 'Large SUV', '2019-____', 'Full-size SUV', 'MY 2020-____', 'South Korea', 'no', 'America', 'no', '', ''),
('Kia', 'Bongo', '1st gen', 'Pickup truck', '1980-1994', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Bongo', '2nd gen', 'Pickup truck', '1990-1997', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Bongo Frontier', '3rd gen', 'Pickup truck', '1997-2004', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Bongo', '4th gen', 'Pickup truck', '2005-____', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'BestA', '-', 'Van', '1990-1997', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Kia', 'Pregio', '-', 'Van', '1995-2006', '', '', 'South Korea', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Fusca', '-', 'Economic car', '?-1986, 1993-1996', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Gol', 'G1', 'Small car', '1980-1994', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Gol', 'G2, G3, G4', 'Small car', '1994-2013', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Gol', 'G5', 'Small car', '2008-____', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Voyage / Fox', 'G1', 'Small car', '1983-1994', 'Subcompact car', 'MY 1987-1993', 'Brazil', 'no', 'America', 'no', '', 'Sold in North America as Volkswagen Fox'),
('Volkswagen', 'Voyage', 'G5', 'Small car', '2008-____', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Parati', 'G1', 'Small car', '1982-1994', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Parati', 'G2', 'Small car', '1994-1999', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Fox', '-', 'Small car', '2003-____', '', '', 'Brazil', 'no', 'no', 'no', '', 'Sold in Mexico as Volkswagen Lupo, due to the last name of then current President Vicente Fox.'),
('Volkswagen', 'Virtus (Polo Sedan)', '-', 'Small car', '2019-____', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Brasilia', '-', 'Compact car', '1973-1982', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Apollo', '-', 'Compact car', '1990-1992', '', '', 'Brazil', 'no', 'no', 'no', '', 'Rebadged Ford Verona'),
('Volkswagen', 'Logus', '-', 'Compact car', '1993-1997', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Pointer', '-', 'Compact car', '1994-1996', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Santana / Corsar', '-', 'Medium car', '1984-2006', '', '', 'Brazil', 'no', 'no', 'no', '', 'Sold in Mexico as Volkswagen Corsar'),
('Volkswagen', 'Quantum', '-', 'Medium car', '1985-2002', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Carat', '-', 'Medium car', '1987-1991', '', '', 'Argentina', 'no', 'no', 'no', '', ''),
('Volkswagen', 'SP2', '-', 'Sports car', '1972-1976', '', '', 'Brazil', 'no', 'no', 'no', '10205', ''),
('Volkswagen', 'SpaceFox / Suran / SportVan / Fox Plus', '-', 'Small MPV', '2006-2019', '', '', 'Brazil', 'no', 'no', 'no', '', 'Sold in Brazil and Peru as SpaceFox, in Argentina, Chile, Uruguay as Suran, in Mexico as SportVan and in Algeria as Fox Plus'),
('Volkswagen', 'T1 Kombi', '-', 'Large MPV', '1957-1975', '', '', 'Brazil', 'no', 'no', 'no', '', 'Name for Volkswagen Transporter sold in Brazil'),
('Volkswagen', 'T2 Kombi', '-', 'Large MPV', '1976-2013', '', '', 'Brazil', 'no', 'no', 'no', '', 'Name for Volkswagen Transporter sold in Brazil'),
('Volkswagen', 'Nivus', '-', 'Small crossover', '2020-____', '', '', 'Brazil', 'no', 'no', 'no', '', 'Volkswagen Taigo in Europe'),
('Volkswagen', 'Saveiro', 'G1', 'Coup? utility', '1983-1994', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('Volkswagen', 'Saveiro', 'G5', 'Coup? utility', '2008-____', '', '', 'Brazil', 'no', 'no', 'no', '', ''),
('', '', '', '', '', '', '', '', '', '', '', '', '');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
