Vehicle Makes and Models (SQL and Generator Script)

makes-and-models.sql

-- Generated on 2021-04-08

insert into "make" ("id", "name") values (1, 'Abarth');
insert into "model" ("brand", "name") values (1, '124 Spider');
insert into "model" ("brand", "name") values (1, '500');
insert into "model" ("brand", "name") values (1, '500C');
insert into "model" ("brand", "name") values (1, '595');
insert into "model" ("brand", "name") values (1, '595 Competizione');
insert into "model" ("brand", "name") values (1, '595 Turismo');
insert into "model" ("brand", "name") values (1, '595C');
insert into "model" ("brand", "name") values (1, '695');
insert into "model" ("brand", "name") values (1, '695C');
insert into "model" ("brand", "name") values (1, 'Grande Punto');
insert into "model" ("brand", "name") values (1, 'Punto Evo');
insert into "model" ("brand", "name") values (1, 'Other');
insert into "make" ("id", "name") values (2, 'AC');
insert into "model" ("brand", "name") values (2, 'Other');
insert into "make" ("id", "name") values (3, 'Acura');
insert into "model" ("brand", "name") values (3, 'MDX');
insert into "model" ("brand", "name") values (3, 'NSX');
insert into "model" ("brand", "name") values (3, 'RL');
insert into "model" ("brand", "name") values (3, 'RSX');
insert into "model" ("brand", "name") values (3, 'TL');
insert into "model" ("brand", "name") values (3, 'TSX');
insert into "model" ("brand", "name") values (3, 'Other');
insert into "make" ("id", "name") values (4, 'Aixam');
insert into "model" ("brand", "name") values (4, 'City');
insert into "model" ("brand", "name") values (4, 'Crossline');
insert into "model" ("brand", "name") values (4, 'Roadline');
insert into "model" ("brand", "name") values (4, 'Scouty R');
insert into "model" ("brand", "name") values (4, 'Other');
insert into "make" ("id", "name") values (5, 'Alfa Romeo');
insert into "model" ("brand", "name") values (5, '4C');
insert into "model" ("brand", "name") values (5, '8C');
insert into "model" ("brand", "name") values (5, 'Alfa 145');
insert into "model" ("brand", "name") values (5, 'Alfa 146');
insert into "model" ("brand", "name") values (5, 'Alfa 147');
insert into "model" ("brand", "name") values (5, 'Alfa 155');
insert into "model" ("brand", "name") values (5, 'Alfa 156');
insert into "model" ("brand", "name") values (5, 'Alfa 159');
insert into "model" ("brand", "name") values (5, 'Alfa 164');
insert into "model" ("brand", "name") values (5, 'Alfa 166');
insert into "model" ("brand", "name") values (5, 'Alfa 33');
insert into "model" ("brand", "name") values (5, 'Alfa 75');
insert into "model" ("brand", "name") values (5, 'Alfa 90');
insert into "model" ("brand", "name") values (5, 'Alfasud');
insert into "model" ("brand", "name") values (5, 'Alfetta');
insert into "model" ("brand", "name") values (5, 'Brera');
insert into "model" ("brand", "name") values (5, 'Crosswagon');
insert into "model" ("brand", "name") values (5, 'GT');
insert into "model" ("brand", "name") values (5, 'GTV');
insert into "model" ("brand", "name") values (5, 'Giulia');
insert into "model" ("brand", "name") values (5, 'Giulietta');
insert into "model" ("brand", "name") values (5, 'Junior');
insert into "model" ("brand", "name") values (5, 'MiTo');
insert into "model" ("brand", "name") values (5, 'Spider');
insert into "model" ("brand", "name") values (5, 'Sprint');
insert into "model" ("brand", "name") values (5, 'Stelvio');
insert into "model" ("brand", "name") values (5, 'Other');
insert into "make" ("id", "name") values (6, 'ALPINA');
insert into "model" ("brand", "name") values (6, 'B10');
insert into "model" ("brand", "name") values (6, 'B12');
insert into "model" ("brand", "name") values (6, 'B3');
insert into "model" ("brand", "name") values (6, 'B4');
insert into "model" ("brand", "name") values (6, 'B5');
insert into "model" ("brand", "name") values (6, 'B6');
insert into "model" ("brand", "name") values (6, 'B7');
insert into "model" ("brand", "name") values (6, 'B8');
insert into "model" ("brand", "name") values (6, 'D10');
insert into "model" ("brand", "name") values (6, 'D3');
insert into "model" ("brand", "name") values (6, 'D4');
insert into "model" ("brand", "name") values (6, 'D5');
insert into "model" ("brand", "name") values (6, 'Roadster S');
insert into "model" ("brand", "name") values (6, 'XD3');
insert into "model" ("brand", "name") values (6, 'XD4');
insert into "model" ("brand", "name") values (6, 'Other');
insert into "make" ("id", "name") values (7, 'Artega');
insert into "model" ("brand", "name") values (7, 'GT');
insert into "model" ("brand", "name") values (7, 'Other');
insert into "make" ("id", "name") values (8, 'Asia Motors');
insert into "model" ("brand", "name") values (8, 'Rocsta');
insert into "model" ("brand", "name") values (8, 'Other');
insert into "make" ("id", "name") values (9, 'Aston Martin');
insert into "model" ("brand", "name") values (9, 'AR1');
insert into "model" ("brand", "name") values (9, 'Cygnet');
insert into "model" ("brand", "name") values (9, 'DB');
insert into "model" ("brand", "name") values (9, 'DB11');
insert into "model" ("brand", "name") values (9, 'DB7');
insert into "model" ("brand", "name") values (9, 'DB9');
insert into "model" ("brand", "name") values (9, 'DBS');
insert into "model" ("brand", "name") values (9, 'DBX');
insert into "model" ("brand", "name") values (9, 'Lagonda');
insert into "model" ("brand", "name") values (9, 'Rapide');
insert into "model" ("brand", "name") values (9, 'V12 Vantage');
insert into "model" ("brand", "name") values (9, 'V8 Vantage');
insert into "model" ("brand", "name") values (9, 'Vanquish');
insert into "model" ("brand", "name") values (9, 'Virage');
insert into "model" ("brand", "name") values (9, 'Other');
insert into "make" ("id", "name") values (10, 'Audi');
insert into "model" ("brand", "name") values (10, '100');
insert into "model" ("brand", "name") values (10, '200');
insert into "model" ("brand", "name") values (10, '80');
insert into "model" ("brand", "name") values (10, '90');
insert into "model" ("brand", "name") values (10, 'A1');
insert into "model" ("brand", "name") values (10, 'A2');
insert into "model" ("brand", "name") values (10, 'A3');
insert into "model" ("brand", "name") values (10, 'A4');
insert into "model" ("brand", "name") values (10, 'A4 Allroad');
insert into "model" ("brand", "name") values (10, 'A5');
insert into "model" ("brand", "name") values (10, 'A6');
insert into "model" ("brand", "name") values (10, 'A6 Allroad');
insert into "model" ("brand", "name") values (10, 'A7');
insert into "model" ("brand", "name") values (10, 'A8');
insert into "model" ("brand", "name") values (10, 'Cabriolet');
insert into "model" ("brand", "name") values (10, 'Coupé');
insert into "model" ("brand", "name") values (10, 'Q1');
insert into "model" ("brand", "name") values (10, 'Q2');
insert into "model" ("brand", "name") values (10, 'Q3');
insert into "model" ("brand", "name") values (10, 'Q5');
insert into "model" ("brand", "name") values (10, 'Q7');
insert into "model" ("brand", "name") values (10, 'Q8');
insert into "model" ("brand", "name") values (10, 'quattro');
insert into "model" ("brand", "name") values (10, 'R8');
insert into "model" ("brand", "name") values (10, 'RS2');
insert into "model" ("brand", "name") values (10, 'RS3');
insert into "model" ("brand", "name") values (10, 'RS4');
insert into "model" ("brand", "name") values (10, 'RS5');
insert into "model" ("brand", "name") values (10, 'RS6');
insert into "model" ("brand", "name") values (10, 'RS7');
insert into "model" ("brand", "name") values (10, 'RSQ3');
insert into "model" ("brand", "name") values (10, 'RSQ8');
insert into "model" ("brand", "name") values (10, 'S1');
insert into "model" ("brand", "name") values (10, 'S2');
insert into "model" ("brand", "name") values (10, 'S3');
insert into "model" ("brand", "name") values (10, 'S4');
insert into "model" ("brand", "name") values (10, 'S5');
insert into "model" ("brand", "name") values (10, 'S6');
insert into "model" ("brand", "name") values (10, 'S7');
insert into "model" ("brand", "name") values (10, 'S8');
insert into "model" ("brand", "name") values (10, 'SQ2');
insert into "model" ("brand", "name") values (10, 'SQ5');
insert into "model" ("brand", "name") values (10, 'SQ7');
insert into "model" ("brand", "name") values (10, 'SQ8');
insert into "model" ("brand", "name") values (10, 'TT');
insert into "model" ("brand", "name") values (10, 'TT RS');
insert into "model" ("brand", "name") values (10, 'TTS');
insert into "model" ("brand", "name") values (10, 'V8');
insert into "model" ("brand", "name") values (10, 'e-tron');
insert into "model" ("brand", "name") values (10, 'Other');
insert into "make" ("id", "name") values (11, 'Austin');
insert into "model" ("brand", "name") values (11, 'Other');
insert into "make" ("id", "name") values (12, 'Austin Healey');
insert into "model" ("brand", "name") values (12, 'Other');
insert into "make" ("id", "name") values (13, 'BAIC');
insert into "model" ("brand", "name") values (13, 'BJ20');
insert into "model" ("brand", "name") values (13, 'X55');
insert into "model" ("brand", "name") values (13, 'Other');
insert into "make" ("id", "name") values (14, 'Bentley');
insert into "model" ("brand", "name") values (14, 'Arnage');
insert into "model" ("brand", "name") values (14, 'Azure');
insert into "model" ("brand", "name") values (14, 'Bentayga');
insert into "model" ("brand", "name") values (14, 'Brooklands');
insert into "model" ("brand", "name") values (14, 'Continental');
insert into "model" ("brand", "name") values (14, 'Continental Flying Spur');
insert into "model" ("brand", "name") values (14, 'Continental GT');
insert into "model" ("brand", "name") values (14, 'Continental GTC');
insert into "model" ("brand", "name") values (14, 'Continental Supersports');
insert into "model" ("brand", "name") values (14, 'Eight');
insert into "model" ("brand", "name") values (14, 'Flying Spur');
insert into "model" ("brand", "name") values (14, 'Mulsanne');
insert into "model" ("brand", "name") values (14, 'Turbo R');
insert into "model" ("brand", "name") values (14, 'Turbo RT');
insert into "model" ("brand", "name") values (14, 'Turbo S');
insert into "model" ("brand", "name") values (14, 'Other');
insert into "make" ("id", "name") values (15, 'BMW');
insert into "model" ("brand", "name") values (15, '114');
insert into "model" ("brand", "name") values (15, '116');
insert into "model" ("brand", "name") values (15, '118');
insert into "model" ("brand", "name") values (15, '120');
insert into "model" ("brand", "name") values (15, '123');
insert into "model" ("brand", "name") values (15, '125');
insert into "model" ("brand", "name") values (15, '128');
insert into "model" ("brand", "name") values (15, '130');
insert into "model" ("brand", "name") values (15, '135');
insert into "model" ("brand", "name") values (15, '1er M Coupé');
insert into "model" ("brand", "name") values (15, '2er Gran Coupé');
insert into "model" ("brand", "name") values (15, '2002');
insert into "model" ("brand", "name") values (15, '214 Active Tourer');
insert into "model" ("brand", "name") values (15, '214 Gran Tourer');
insert into "model" ("brand", "name") values (15, '216');
insert into "model" ("brand", "name") values (15, '216 Active Tourer');
insert into "model" ("brand", "name") values (15, '216 Gran Tourer');
insert into "model" ("brand", "name") values (15, '218');
insert into "model" ("brand", "name") values (15, '218 Active Tourer');
insert into "model" ("brand", "name") values (15, '218 Gran Tourer');
insert into "model" ("brand", "name") values (15, '220');
insert into "model" ("brand", "name") values (15, '220 Active Tourer');
insert into "model" ("brand", "name") values (15, '220 Gran Tourer');
insert into "model" ("brand", "name") values (15, '225');
insert into "model" ("brand", "name") values (15, '225 Active Tourer');
insert into "model" ("brand", "name") values (15, '228');
insert into "model" ("brand", "name") values (15, '230');
insert into "model" ("brand", "name") values (15, '315');
insert into "model" ("brand", "name") values (15, '316');
insert into "model" ("brand", "name") values (15, '318');
insert into "model" ("brand", "name") values (15, '318 Gran Turismo');
insert into "model" ("brand", "name") values (15, '320');
insert into "model" ("brand", "name") values (15, '320 Gran Turismo');
insert into "model" ("brand", "name") values (15, '323');
insert into "model" ("brand", "name") values (15, '324');
insert into "model" ("brand", "name") values (15, '325');
insert into "model" ("brand", "name") values (15, '325 Gran Turismo');
insert into "model" ("brand", "name") values (15, '328');
insert into "model" ("brand", "name") values (15, '328 Gran Turismo');
insert into "model" ("brand", "name") values (15, '330');
insert into "model" ("brand", "name") values (15, '330 Gran Turismo');
insert into "model" ("brand", "name") values (15, '335');
insert into "model" ("brand", "name") values (15, '335 Gran Turismo');
insert into "model" ("brand", "name") values (15, '340');
insert into "model" ("brand", "name") values (15, '340 Gran Turismo');
insert into "model" ("brand", "name") values (15, '418');
insert into "model" ("brand", "name") values (15, '418 Gran Coupé');
insert into "model" ("brand", "name") values (15, '420');
insert into "model" ("brand", "name") values (15, '420 Gran Coupé');
insert into "model" ("brand", "name") values (15, '425');
insert into "model" ("brand", "name") values (15, '425 Gran Coupé');
insert into "model" ("brand", "name") values (15, '428');
insert into "model" ("brand", "name") values (15, '428 Gran Coupé');
insert into "model" ("brand", "name") values (15, '430');
insert into "model" ("brand", "name") values (15, '430 Gran Coupé');
insert into "model" ("brand", "name") values (15, '435');
insert into "model" ("brand", "name") values (15, '435 Gran Coupé');
insert into "model" ("brand", "name") values (15, '440');
insert into "model" ("brand", "name") values (15, '440 Gran Coupé');
insert into "model" ("brand", "name") values (15, '518');
insert into "model" ("brand", "name") values (15, '520');
insert into "model" ("brand", "name") values (15, '520 Gran Turismo');
insert into "model" ("brand", "name") values (15, '523');
insert into "model" ("brand", "name") values (15, '524');
insert into "model" ("brand", "name") values (15, '525');
insert into "model" ("brand", "name") values (15, '528');
insert into "model" ("brand", "name") values (15, '530');
insert into "model" ("brand", "name") values (15, '530 Gran Turismo');
insert into "model" ("brand", "name") values (15, '535');
insert into "model" ("brand", "name") values (15, '535 Gran Turismo');
insert into "model" ("brand", "name") values (15, '540');
insert into "model" ("brand", "name") values (15, '545');
insert into "model" ("brand", "name") values (15, '550');
insert into "model" ("brand", "name") values (15, '550 Gran Turismo');
insert into "model" ("brand", "name") values (15, '620 Gran Turismo');
insert into "model" ("brand", "name") values (15, '628');
insert into "model" ("brand", "name") values (15, '630');
insert into "model" ("brand", "name") values (15, '630 Gran Turismo');
insert into "model" ("brand", "name") values (15, '633');
insert into "model" ("brand", "name") values (15, '635');
insert into "model" ("brand", "name") values (15, '640');
insert into "model" ("brand", "name") values (15, '640 Gran Coupé');
insert into "model" ("brand", "name") values (15, '640 Gran Turismo');
insert into "model" ("brand", "name") values (15, '645');
insert into "model" ("brand", "name") values (15, '650');
insert into "model" ("brand", "name") values (15, '650 Gran Coupé');
insert into "model" ("brand", "name") values (15, '725');
insert into "model" ("brand", "name") values (15, '728');
insert into "model" ("brand", "name") values (15, '730');
insert into "model" ("brand", "name") values (15, '732');
insert into "model" ("brand", "name") values (15, '735');
insert into "model" ("brand", "name") values (15, '740');
insert into "model" ("brand", "name") values (15, '745');
insert into "model" ("brand", "name") values (15, '750');
insert into "model" ("brand", "name") values (15, '760');
insert into "model" ("brand", "name") values (15, '840');
insert into "model" ("brand", "name") values (15, '850');
insert into "model" ("brand", "name") values (15, 'ActiveHybrid 3');
insert into "model" ("brand", "name") values (15, 'ActiveHybrid 5');
insert into "model" ("brand", "name") values (15, 'ActiveHybrid 7');
insert into "model" ("brand", "name") values (15, 'ActiveHybrid X6');
insert into "model" ("brand", "name") values (15, 'M135');
insert into "model" ("brand", "name") values (15, 'M140i');
insert into "model" ("brand", "name") values (15, 'M2');
insert into "model" ("brand", "name") values (15, 'M235');
insert into "model" ("brand", "name") values (15, 'M240i');
insert into "model" ("brand", "name") values (15, 'M3');
insert into "model" ("brand", "name") values (15, 'M340i');
insert into "model" ("brand", "name") values (15, 'M4');
insert into "model" ("brand", "name") values (15, 'M5');
insert into "model" ("brand", "name") values (15, 'M550');
insert into "model" ("brand", "name") values (15, 'M6');
insert into "model" ("brand", "name") values (15, 'M760');
insert into "model" ("brand", "name") values (15, 'M8');
insert into "model" ("brand", "name") values (15, 'M850');
insert into "model" ("brand", "name") values (15, 'X1');
insert into "model" ("brand", "name") values (15, 'X2');
insert into "model" ("brand", "name") values (15, 'X3');
insert into "model" ("brand", "name") values (15, 'X3 M');
insert into "model" ("brand", "name") values (15, 'X3 M40');
insert into "model" ("brand", "name") values (15, 'X4');
insert into "model" ("brand", "name") values (15, 'X4 M');
insert into "model" ("brand", "name") values (15, 'X4 M40');
insert into "model" ("brand", "name") values (15, 'X5');
insert into "model" ("brand", "name") values (15, 'X5 M');
insert into "model" ("brand", "name") values (15, 'X5 M50');
insert into "model" ("brand", "name") values (15, 'X6');
insert into "model" ("brand", "name") values (15, 'X6 M');
insert into "model" ("brand", "name") values (15, 'X6 M50');
insert into "model" ("brand", "name") values (15, 'X7');
insert into "model" ("brand", "name") values (15, 'Z1');
insert into "model" ("brand", "name") values (15, 'Z3');
insert into "model" ("brand", "name") values (15, 'Z3 M');
insert into "model" ("brand", "name") values (15, 'Z4');
insert into "model" ("brand", "name") values (15, 'Z4 M');
insert into "model" ("brand", "name") values (15, 'Z8');
insert into "model" ("brand", "name") values (15, 'i3');
insert into "model" ("brand", "name") values (15, 'i8');
insert into "model" ("brand", "name") values (15, 'Other');
insert into "make" ("id", "name") values (16, 'Borgward');
insert into "model" ("brand", "name") values (16, 'Other');
insert into "make" ("id", "name") values (17, 'Brilliance');
insert into "model" ("brand", "name") values (17, 'BC3');
insert into "model" ("brand", "name") values (17, 'BS2');
insert into "model" ("brand", "name") values (17, 'BS4');
insert into "model" ("brand", "name") values (17, 'BS6');
insert into "model" ("brand", "name") values (17, 'Other');
insert into "make" ("id", "name") values (18, 'Bugatti');
insert into "model" ("brand", "name") values (18, 'Chiron');
insert into "model" ("brand", "name") values (18, 'EB 110');
insert into "model" ("brand", "name") values (18, 'Veyron');
insert into "model" ("brand", "name") values (18, 'Other');
insert into "make" ("id", "name") values (19, 'Buick');
insert into "model" ("brand", "name") values (19, 'Century');
insert into "model" ("brand", "name") values (19, 'Electra');
insert into "model" ("brand", "name") values (19, 'Enclave');
insert into "model" ("brand", "name") values (19, 'La Crosse');
insert into "model" ("brand", "name") values (19, 'Le Sabre');
insert into "model" ("brand", "name") values (19, 'Park Avenue');
insert into "model" ("brand", "name") values (19, 'Regal');
insert into "model" ("brand", "name") values (19, 'Riviera');
insert into "model" ("brand", "name") values (19, 'Roadmaster');
insert into "model" ("brand", "name") values (19, 'Skylark');
insert into "model" ("brand", "name") values (19, 'Other');
insert into "make" ("id", "name") values (20, 'Cadillac');
insert into "model" ("brand", "name") values (20, 'ATS');
insert into "model" ("brand", "name") values (20, 'Allante');
insert into "model" ("brand", "name") values (20, 'BLS');
insert into "model" ("brand", "name") values (20, 'CT6');
insert into "model" ("brand", "name") values (20, 'CTS');
insert into "model" ("brand", "name") values (20, 'Deville');
insert into "model" ("brand", "name") values (20, 'Eldorado');
insert into "model" ("brand", "name") values (20, 'Escalade');
insert into "model" ("brand", "name") values (20, 'Fleetwood');
insert into "model" ("brand", "name") values (20, 'SRX');
insert into "model" ("brand", "name") values (20, 'STS');
insert into "model" ("brand", "name") values (20, 'Seville');
insert into "model" ("brand", "name") values (20, 'XLR');
insert into "model" ("brand", "name") values (20, 'XT4');
insert into "model" ("brand", "name") values (20, 'XT5');
insert into "model" ("brand", "name") values (20, 'Other');
insert into "make" ("id", "name") values (21, 'Casalini');
insert into "model" ("brand", "name") values (21, 'Other');
insert into "make" ("id", "name") values (22, 'Caterham');
insert into "model" ("brand", "name") values (22, 'Other');
insert into "make" ("id", "name") values (23, 'Chatenet');
insert into "model" ("brand", "name") values (23, 'Other');
insert into "make" ("id", "name") values (24, 'Chevrolet');
insert into "model" ("brand", "name") values (24, '2500');
insert into "model" ("brand", "name") values (24, 'Alero');
insert into "model" ("brand", "name") values (24, 'Astro');
insert into "model" ("brand", "name") values (24, 'Avalanche');
insert into "model" ("brand", "name") values (24, 'Aveo');
insert into "model" ("brand", "name") values (24, 'Beretta');
insert into "model" ("brand", "name") values (24, 'Blazer');
insert into "model" ("brand", "name") values (24, 'C1500');
insert into "model" ("brand", "name") values (24, 'Camaro');
insert into "model" ("brand", "name") values (24, 'Caprice');
insert into "model" ("brand", "name") values (24, 'Captiva');
insert into "model" ("brand", "name") values (24, 'Cavalier');
insert into "model" ("brand", "name") values (24, 'Chevelle');
insert into "model" ("brand", "name") values (24, 'Chevy Van');
insert into "model" ("brand", "name") values (24, 'Citation');
insert into "model" ("brand", "name") values (24, 'Colorado');
insert into "model" ("brand", "name") values (24, 'Corsica');
insert into "model" ("brand", "name") values (24, 'Cruze');
insert into "model" ("brand", "name") values (24, 'El Camino');
insert into "model" ("brand", "name") values (24, 'Epica');
insert into "model" ("brand", "name") values (24, 'Evanda');
insert into "model" ("brand", "name") values (24, 'Express');
insert into "model" ("brand", "name") values (24, 'G');
insert into "model" ("brand", "name") values (24, 'HHR');
insert into "model" ("brand", "name") values (24, 'Impala');
insert into "model" ("brand", "name") values (24, 'K1500');
insert into "model" ("brand", "name") values (24, 'K30');
insert into "model" ("brand", "name") values (24, 'Kalos');
insert into "model" ("brand", "name") values (24, 'Lacetti');
insert into "model" ("brand", "name") values (24, 'Lumina');
insert into "model" ("brand", "name") values (24, 'Malibu');
insert into "model" ("brand", "name") values (24, 'Matiz');
insert into "model" ("brand", "name") values (24, 'Niva');
insert into "model" ("brand", "name") values (24, 'Nubira');
insert into "model" ("brand", "name") values (24, 'Orlando');
insert into "model" ("brand", "name") values (24, 'Rezzo');
insert into "model" ("brand", "name") values (24, 'S-10');
insert into "model" ("brand", "name") values (24, 'SSR');
insert into "model" ("brand", "name") values (24, 'Silverado');
insert into "model" ("brand", "name") values (24, 'Spark');
insert into "model" ("brand", "name") values (24, 'Suburban');
insert into "model" ("brand", "name") values (24, 'Tahoe');
insert into "model" ("brand", "name") values (24, 'Trailblazer');
insert into "model" ("brand", "name") values (24, 'Trans Sport');
insert into "model" ("brand", "name") values (24, 'Traverse');
insert into "model" ("brand", "name") values (24, 'Trax');
insert into "model" ("brand", "name") values (24, 'Venture');
insert into "model" ("brand", "name") values (24, 'Volt');
insert into "model" ("brand", "name") values (24, 'Other');
insert into "make" ("id", "name") values (25, 'Chrysler');
insert into "model" ("brand", "name") values (25, '200');
insert into "model" ("brand", "name") values (25, '300 M');
insert into "model" ("brand", "name") values (25, '300C');
insert into "model" ("brand", "name") values (25, 'Aspen');
insert into "model" ("brand", "name") values (25, 'Crossfire');
insert into "model" ("brand", "name") values (25, 'Daytona');
insert into "model" ("brand", "name") values (25, 'ES');
insert into "model" ("brand", "name") values (25, 'GS');
insert into "model" ("brand", "name") values (25, 'GTS');
insert into "model" ("brand", "name") values (25, 'Grand Voyager');
insert into "model" ("brand", "name") values (25, 'Imperial');
insert into "model" ("brand", "name") values (25, 'Le Baron');
insert into "model" ("brand", "name") values (25, 'Neon');
insert into "model" ("brand", "name") values (25, 'New Yorker');
insert into "model" ("brand", "name") values (25, 'PT Cruiser');
insert into "model" ("brand", "name") values (25, 'Pacifica');
insert into "model" ("brand", "name") values (25, 'Saratoga');
insert into "model" ("brand", "name") values (25, 'Sebring');
insert into "model" ("brand", "name") values (25, 'Stratus');
insert into "model" ("brand", "name") values (25, 'Valiant');
insert into "model" ("brand", "name") values (25, 'Viper');
insert into "model" ("brand", "name") values (25, 'Vision');
insert into "model" ("brand", "name") values (25, 'Voyager');
insert into "model" ("brand", "name") values (25, 'Other');
insert into "make" ("id", "name") values (26, 'Citroën');
insert into "model" ("brand", "name") values (26, '2 CV');
insert into "model" ("brand", "name") values (26, 'AX');
insert into "model" ("brand", "name") values (26, 'BX');
insert into "model" ("brand", "name") values (26, 'Berlingo');
insert into "model" ("brand", "name") values (26, 'C-Crosser');
insert into "model" ("brand", "name") values (26, 'C-Elysée');
insert into "model" ("brand", "name") values (26, 'C-Zero');
insert into "model" ("brand", "name") values (26, 'C1');
insert into "model" ("brand", "name") values (26, 'C2');
insert into "model" ("brand", "name") values (26, 'C3');
insert into "model" ("brand", "name") values (26, 'C3 Aircross');
insert into "model" ("brand", "name") values (26, 'C3 Picasso');
insert into "model" ("brand", "name") values (26, 'C4');
insert into "model" ("brand", "name") values (26, 'C4 Aircross');
insert into "model" ("brand", "name") values (26, 'C4 Cactus');
insert into "model" ("brand", "name") values (26, 'C4 Picasso');
insert into "model" ("brand", "name") values (26, 'C4 SpaceTourer');
insert into "model" ("brand", "name") values (26, 'C5');
insert into "model" ("brand", "name") values (26, 'C5 Aircross');
insert into "model" ("brand", "name") values (26, 'C6');
insert into "model" ("brand", "name") values (26, 'C8');
insert into "model" ("brand", "name") values (26, 'CX');
insert into "model" ("brand", "name") values (26, 'DS');
insert into "model" ("brand", "name") values (26, 'DS3');
insert into "model" ("brand", "name") values (26, 'DS4');
insert into "model" ("brand", "name") values (26, 'DS4 Crossback');
insert into "model" ("brand", "name") values (26, 'DS5');
insert into "model" ("brand", "name") values (26, 'E-MEHARI');
insert into "model" ("brand", "name") values (26, 'Evasion');
insert into "model" ("brand", "name") values (26, 'GSA');
insert into "model" ("brand", "name") values (26, 'Grand C4 Picasso / SpaceTourer');
insert into "model" ("brand", "name") values (26, 'Jumper');
insert into "model" ("brand", "name") values (26, 'Jumpy');
insert into "model" ("brand", "name") values (26, 'Nemo');
insert into "model" ("brand", "name") values (26, 'SAXO');
insert into "model" ("brand", "name") values (26, 'SM');
insert into "model" ("brand", "name") values (26, 'SpaceTourer');
insert into "model" ("brand", "name") values (26, 'Visa');
insert into "model" ("brand", "name") values (26, 'XM');
insert into "model" ("brand", "name") values (26, 'Xantia');
insert into "model" ("brand", "name") values (26, 'Xsara');
insert into "model" ("brand", "name") values (26, 'Xsara Picasso');
insert into "model" ("brand", "name") values (26, 'ZX');
insert into "model" ("brand", "name") values (26, 'Other');
insert into "make" ("id", "name") values (27, 'Cobra');
insert into "model" ("brand", "name") values (27, 'Other');
insert into "make" ("id", "name") values (28, 'Corvette');
insert into "model" ("brand", "name") values (28, 'C1');
insert into "model" ("brand", "name") values (28, 'C2');
insert into "model" ("brand", "name") values (28, 'C3');
insert into "model" ("brand", "name") values (28, 'C4');
insert into "model" ("brand", "name") values (28, 'C5');
insert into "model" ("brand", "name") values (28, 'C6');
insert into "model" ("brand", "name") values (28, 'C7');
insert into "model" ("brand", "name") values (28, 'C8');
insert into "model" ("brand", "name") values (28, 'Z06');
insert into "model" ("brand", "name") values (28, 'ZR 1');
insert into "model" ("brand", "name") values (28, 'Other');
insert into "make" ("id", "name") values (29, 'Cupra');
insert into "model" ("brand", "name") values (29, 'Arona');
insert into "model" ("brand", "name") values (29, 'Ateca');
insert into "model" ("brand", "name") values (29, 'Formentor');
insert into "model" ("brand", "name") values (29, 'Ibiza');
insert into "model" ("brand", "name") values (29, 'Leon');
insert into "model" ("brand", "name") values (29, 'Other');
insert into "make" ("id", "name") values (30, 'Dacia');
insert into "model" ("brand", "name") values (30, 'Dokker');
insert into "model" ("brand", "name") values (30, 'Duster');
insert into "model" ("brand", "name") values (30, 'Lodgy');
insert into "model" ("brand", "name") values (30, 'Logan');
insert into "model" ("brand", "name") values (30, 'Logan Pick-Up');
insert into "model" ("brand", "name") values (30, 'Pick Up');
insert into "model" ("brand", "name") values (30, 'Sandero');
insert into "model" ("brand", "name") values (30, 'Other');
insert into "make" ("id", "name") values (31, 'Daewoo');
insert into "model" ("brand", "name") values (31, 'Espero');
insert into "model" ("brand", "name") values (31, 'Evanda');
insert into "model" ("brand", "name") values (31, 'Kalos');
insert into "model" ("brand", "name") values (31, 'Korando');
insert into "model" ("brand", "name") values (31, 'Lacetti');
insert into "model" ("brand", "name") values (31, 'Lanos');
insert into "model" ("brand", "name") values (31, 'Leganza');
insert into "model" ("brand", "name") values (31, 'Matiz');
insert into "model" ("brand", "name") values (31, 'Musso');
insert into "model" ("brand", "name") values (31, 'Nexia');
insert into "model" ("brand", "name") values (31, 'Nubira');
insert into "model" ("brand", "name") values (31, 'Rezzo');
insert into "model" ("brand", "name") values (31, 'Tacuma');
insert into "model" ("brand", "name") values (31, 'Other');
insert into "make" ("id", "name") values (32, 'Daihatsu');
insert into "model" ("brand", "name") values (32, 'Applause');
insert into "model" ("brand", "name") values (32, 'Charade');
insert into "model" ("brand", "name") values (32, 'Charmant');
insert into "model" ("brand", "name") values (32, 'Copen');
insert into "model" ("brand", "name") values (32, 'Cuore');
insert into "model" ("brand", "name") values (32, 'Feroza/Sportrak');
insert into "model" ("brand", "name") values (32, 'Freeclimber');
insert into "model" ("brand", "name") values (32, 'Gran Move');
insert into "model" ("brand", "name") values (32, 'Hijet');
insert into "model" ("brand", "name") values (32, 'MATERIA');
insert into "model" ("brand", "name") values (32, 'Move');
insert into "model" ("brand", "name") values (32, 'Rocky/Fourtrak');
insert into "model" ("brand", "name") values (32, 'Sirion');
insert into "model" ("brand", "name") values (32, 'TREVIS');
insert into "model" ("brand", "name") values (32, 'Terios');
insert into "model" ("brand", "name") values (32, 'YRV');
insert into "model" ("brand", "name") values (32, 'Other');
insert into "make" ("id", "name") values (33, 'DeTomaso');
insert into "model" ("brand", "name") values (33, 'Guarà');
insert into "model" ("brand", "name") values (33, 'Pantera');
insert into "model" ("brand", "name") values (33, 'Other');
insert into "make" ("id", "name") values (34, 'DFSK');
insert into "model" ("brand", "name") values (34, 'Fengo');
insert into "model" ("brand", "name") values (34, 'Glory');
insert into "model" ("brand", "name") values (34, 'Seres 3');
insert into "model" ("brand", "name") values (34, 'Other');
insert into "make" ("id", "name") values (35, 'Dodge');
insert into "model" ("brand", "name") values (35, 'Avenger');
insert into "model" ("brand", "name") values (35, 'Caliber');
insert into "model" ("brand", "name") values (35, 'Challenger');
insert into "model" ("brand", "name") values (35, 'Charger');
insert into "model" ("brand", "name") values (35, 'Dakota');
insert into "model" ("brand", "name") values (35, 'Dart');
insert into "model" ("brand", "name") values (35, 'Demon');
insert into "model" ("brand", "name") values (35, 'Durango');
insert into "model" ("brand", "name") values (35, 'Grand Caravan');
insert into "model" ("brand", "name") values (35, 'Hornet');
insert into "model" ("brand", "name") values (35, 'Journey');
insert into "model" ("brand", "name") values (35, 'Magnum');
insert into "model" ("brand", "name") values (35, 'Neon');
insert into "model" ("brand", "name") values (35, 'Nitro');
insert into "model" ("brand", "name") values (35, 'RAM');
insert into "model" ("brand", "name") values (35, 'Stealth');
insert into "model" ("brand", "name") values (35, 'Viper');
insert into "model" ("brand", "name") values (35, 'Other');
insert into "make" ("id", "name") values (36, 'Donkervoort');
insert into "model" ("brand", "name") values (36, 'D8');
insert into "model" ("brand", "name") values (36, 'S7');
insert into "model" ("brand", "name") values (36, 'S8');
insert into "model" ("brand", "name") values (36, 'Other');
insert into "make" ("id", "name") values (37, 'DS Automobiles');
insert into "model" ("brand", "name") values (37, 'DS3');
insert into "model" ("brand", "name") values (37, 'DS3 Crossback');
insert into "model" ("brand", "name") values (37, 'DS4');
insert into "model" ("brand", "name") values (37, 'DS4 Crossback');
insert into "model" ("brand", "name") values (37, 'DS5');
insert into "model" ("brand", "name") values (37, 'DS7 Crossback');
insert into "model" ("brand", "name") values (37, 'DS9');
insert into "model" ("brand", "name") values (37, 'Other');
insert into "make" ("id", "name") values (38, 'Ferrari');
insert into "model" ("brand", "name") values (38, '208');
insert into "model" ("brand", "name") values (38, '246');
insert into "model" ("brand", "name") values (38, '250');
insert into "model" ("brand", "name") values (38, '275');
insert into "model" ("brand", "name") values (38, '288');
insert into "model" ("brand", "name") values (38, '308');
insert into "model" ("brand", "name") values (38, '328');
insert into "model" ("brand", "name") values (38, '330');
insert into "model" ("brand", "name") values (38, '348');
insert into "model" ("brand", "name") values (38, '360');
insert into "model" ("brand", "name") values (38, '365');
insert into "model" ("brand", "name") values (38, '400');
insert into "model" ("brand", "name") values (38, '412');
insert into "model" ("brand", "name") values (38, '456');
insert into "model" ("brand", "name") values (38, '458');
insert into "model" ("brand", "name") values (38, '488 GTB');
insert into "model" ("brand", "name") values (38, '488 Pista');
insert into "model" ("brand", "name") values (38, '488 Spider');
insert into "model" ("brand", "name") values (38, '512');
insert into "model" ("brand", "name") values (38, '550');
insert into "model" ("brand", "name") values (38, '575');
insert into "model" ("brand", "name") values (38, '599 GTB');
insert into "model" ("brand", "name") values (38, '599 GTO');
insert into "model" ("brand", "name") values (38, '599 SA Aperta');
insert into "model" ("brand", "name") values (38, '612');
insert into "model" ("brand", "name") values (38, '750');
insert into "model" ("brand", "name") values (38, '812');
insert into "model" ("brand", "name") values (38, 'California');
insert into "model" ("brand", "name") values (38, 'Daytona');
insert into "model" ("brand", "name") values (38, 'Dino GT4');
insert into "model" ("brand", "name") values (38, 'Enzo Ferrari');
insert into "model" ("brand", "name") values (38, 'F12');
insert into "model" ("brand", "name") values (38, 'F355');
insert into "model" ("brand", "name") values (38, 'F40');
insert into "model" ("brand", "name") values (38, 'F430');
insert into "model" ("brand", "name") values (38, 'F50');
insert into "model" ("brand", "name") values (38, 'F8');
insert into "model" ("brand", "name") values (38, 'FF');
insert into "model" ("brand", "name") values (38, 'GTC4Lusso');
insert into "model" ("brand", "name") values (38, 'LaFerrari');
insert into "model" ("brand", "name") values (38, 'Mondial');
insert into "model" ("brand", "name") values (38, 'Portofino');
insert into "model" ("brand", "name") values (38, 'Roma');
insert into "model" ("brand", "name") values (38, 'Superamerica');
insert into "model" ("brand", "name") values (38, 'Testarossa');
insert into "model" ("brand", "name") values (38, 'Other');
insert into "make" ("id", "name") values (39, 'Fiat');
insert into "model" ("brand", "name") values (39, '124');
insert into "model" ("brand", "name") values (39, '124 Spider');
insert into "model" ("brand", "name") values (39, '126');
insert into "model" ("brand", "name") values (39, '127');
insert into "model" ("brand", "name") values (39, '130');
insert into "model" ("brand", "name") values (39, '131');
insert into "model" ("brand", "name") values (39, '500');
insert into "model" ("brand", "name") values (39, '500C');
insert into "model" ("brand", "name") values (39, '500L');
insert into "model" ("brand", "name") values (39, '500L Cross');
insert into "model" ("brand", "name") values (39, '500L Living');
insert into "model" ("brand", "name") values (39, '500L Trekking');
insert into "model" ("brand", "name") values (39, '500L Urban');
insert into "model" ("brand", "name") values (39, '500L Wagon');
insert into "model" ("brand", "name") values (39, '500S');
insert into "model" ("brand", "name") values (39, '500X');
insert into "model" ("brand", "name") values (39, 'Albea');
insert into "model" ("brand", "name") values (39, 'Barchetta');
insert into "model" ("brand", "name") values (39, 'Brava');
insert into "model" ("brand", "name") values (39, 'Bravo');
insert into "model" ("brand", "name") values (39, 'Cinquecento');
insert into "model" ("brand", "name") values (39, 'Coupe');
insert into "model" ("brand", "name") values (39, 'Croma');
insert into "model" ("brand", "name") values (39, 'Dino');
insert into "model" ("brand", "name") values (39, 'Doblo');
insert into "model" ("brand", "name") values (39, 'Ducato');
insert into "model" ("brand", "name") values (39, 'Fiorino');
insert into "model" ("brand", "name") values (39, 'Freemont');
insert into "model" ("brand", "name") values (39, 'Fullback');
insert into "model" ("brand", "name") values (39, 'Grande Punto');
insert into "model" ("brand", "name") values (39, 'Idea');
insert into "model" ("brand", "name") values (39, 'Linea');
insert into "model" ("brand", "name") values (39, 'Marea');
insert into "model" ("brand", "name") values (39, 'Marengo');
insert into "model" ("brand", "name") values (39, 'Multipla');
insert into "model" ("brand", "name") values (39, 'New Panda');
insert into "model" ("brand", "name") values (39, 'Palio');
insert into "model" ("brand", "name") values (39, 'Panda');
insert into "model" ("brand", "name") values (39, 'Punto');
insert into "model" ("brand", "name") values (39, 'Punto Evo');
insert into "model" ("brand", "name") values (39, 'Qubo');
insert into "model" ("brand", "name") values (39, 'Regata');
insert into "model" ("brand", "name") values (39, 'Ritmo');
insert into "model" ("brand", "name") values (39, 'Scudo');
insert into "model" ("brand", "name") values (39, 'Sedici');
insert into "model" ("brand", "name") values (39, 'Seicento');
insert into "model" ("brand", "name") values (39, 'Siena');
insert into "model" ("brand", "name") values (39, 'Spider Europa');
insert into "model" ("brand", "name") values (39, 'Stilo');
insert into "model" ("brand", "name") values (39, 'Strada');
insert into "model" ("brand", "name") values (39, 'Talento');
insert into "model" ("brand", "name") values (39, 'Tempra');
insert into "model" ("brand", "name") values (39, 'Tipo');
insert into "model" ("brand", "name") values (39, 'Ulysse');
insert into "model" ("brand", "name") values (39, 'Uno');
insert into "model" ("brand", "name") values (39, 'X 1/9');
insert into "model" ("brand", "name") values (39, 'Other');
insert into "make" ("id", "name") values (40, 'Fisker');
insert into "model" ("brand", "name") values (40, 'Karma');
insert into "model" ("brand", "name") values (40, 'Other');
insert into "make" ("id", "name") values (41, 'Ford');
insert into "model" ("brand", "name") values (41, 'Aerostar');
insert into "model" ("brand", "name") values (41, 'B-Max');
insert into "model" ("brand", "name") values (41, 'Bronco');
insert into "model" ("brand", "name") values (41, 'C-Max');
insert into "model" ("brand", "name") values (41, 'Capri');
insert into "model" ("brand", "name") values (41, 'Cougar');
insert into "model" ("brand", "name") values (41, 'Courier');
insert into "model" ("brand", "name") values (41, 'Crown');
insert into "model" ("brand", "name") values (41, 'EcoSport');
insert into "model" ("brand", "name") values (41, 'Econoline');
insert into "model" ("brand", "name") values (41, 'Econovan');
insert into "model" ("brand", "name") values (41, 'Edge');
insert into "model" ("brand", "name") values (41, 'Escape');
insert into "model" ("brand", "name") values (41, 'Escort');
insert into "model" ("brand", "name") values (41, 'Excursion');
insert into "model" ("brand", "name") values (41, 'Expedition');
insert into "model" ("brand", "name") values (41, 'Explorer');
insert into "model" ("brand", "name") values (41, 'Express');
insert into "model" ("brand", "name") values (41, 'F 100');
insert into "model" ("brand", "name") values (41, 'F 150');
insert into "model" ("brand", "name") values (41, 'F 250');
insert into "model" ("brand", "name") values (41, 'F 350');
insert into "model" ("brand", "name") values (41, 'Fairlane');
insert into "model" ("brand", "name") values (41, 'Falcon');
insert into "model" ("brand", "name") values (41, 'Fiesta');
insert into "model" ("brand", "name") values (41, 'Flex');
insert into "model" ("brand", "name") values (41, 'Focus');
insert into "model" ("brand", "name") values (41, 'Fusion');
insert into "model" ("brand", "name") values (41, 'GT');
insert into "model" ("brand", "name") values (41, 'Galaxy');
insert into "model" ("brand", "name") values (41, 'Granada');
insert into "model" ("brand", "name") values (41, 'Grand C-Max');
insert into "model" ("brand", "name") values (41, 'Grand Tourneo');
insert into "model" ("brand", "name") values (41, 'Ka/Ka+');
insert into "model" ("brand", "name") values (41, 'Kuga');
insert into "model" ("brand", "name") values (41, 'Maverick');
insert into "model" ("brand", "name") values (41, 'Mercury');
insert into "model" ("brand", "name") values (41, 'Mondeo');
insert into "model" ("brand", "name") values (41, 'Mustang');
insert into "model" ("brand", "name") values (41, 'Mustang Mach-E');
insert into "model" ("brand", "name") values (41, 'Orion');
insert into "model" ("brand", "name") values (41, 'Probe');
insert into "model" ("brand", "name") values (41, 'Puma');
insert into "model" ("brand", "name") values (41, 'Ranger');
insert into "model" ("brand", "name") values (41, 'Raptor');
insert into "model" ("brand", "name") values (41, 'S-Max');
insert into "model" ("brand", "name") values (41, 'Scorpio');
insert into "model" ("brand", "name") values (41, 'Sierra');
insert into "model" ("brand", "name") values (41, 'Sportka');
insert into "model" ("brand", "name") values (41, 'Streetka');
insert into "model" ("brand", "name") values (41, 'Taunus');
insert into "model" ("brand", "name") values (41, 'Taurus');
insert into "model" ("brand", "name") values (41, 'Thunderbird');
insert into "model" ("brand", "name") values (41, 'Tourneo');
insert into "model" ("brand", "name") values (41, 'Tourneo Connect');
insert into "model" ("brand", "name") values (41, 'Tourneo Courier');
insert into "model" ("brand", "name") values (41, 'Tourneo Custom');
insert into "model" ("brand", "name") values (41, 'Transit');
insert into "model" ("brand", "name") values (41, 'Transit Connect');
insert into "model" ("brand", "name") values (41, 'Transit Courier');
insert into "model" ("brand", "name") values (41, 'Transit Custom');
insert into "model" ("brand", "name") values (41, 'Windstar');
insert into "model" ("brand", "name") values (41, 'Other');
insert into "make" ("id", "name") values (42, 'GAC Gonow');
insert into "model" ("brand", "name") values (42, 'Other');
insert into "make" ("id", "name") values (43, 'Gemballa');
insert into "model" ("brand", "name") values (43, 'Other');
insert into "make" ("id", "name") values (44, 'GMC');
insert into "model" ("brand", "name") values (44, 'Acadia');
insert into "model" ("brand", "name") values (44, 'Envoy');
insert into "model" ("brand", "name") values (44, 'Safari');
insert into "model" ("brand", "name") values (44, 'Savana');
insert into "model" ("brand", "name") values (44, 'Sierra');
insert into "model" ("brand", "name") values (44, 'Sonoma');
insert into "model" ("brand", "name") values (44, 'Syclone');
insert into "model" ("brand", "name") values (44, 'Terrain');
insert into "model" ("brand", "name") values (44, 'Typhoon');
insert into "model" ("brand", "name") values (44, 'Vandura');
insert into "model" ("brand", "name") values (44, 'Yukon');
insert into "model" ("brand", "name") values (44, 'Other');
insert into "make" ("id", "name") values (45, 'Grecav');
insert into "model" ("brand", "name") values (45, 'Sonique');
insert into "model" ("brand", "name") values (45, 'Other');
insert into "make" ("id", "name") values (46, 'Hamann');
insert into "model" ("brand", "name") values (46, 'Other');
insert into "make" ("id", "name") values (47, 'Holden');
insert into "model" ("brand", "name") values (47, 'Other');
insert into "make" ("id", "name") values (48, 'Honda');
insert into "model" ("brand", "name") values (48, 'Accord');
insert into "model" ("brand", "name") values (48, 'Aerodeck');
insert into "model" ("brand", "name") values (48, 'CR-V');
insert into "model" ("brand", "name") values (48, 'CR-Z');
insert into "model" ("brand", "name") values (48, 'CRX');
insert into "model" ("brand", "name") values (48, 'City');
insert into "model" ("brand", "name") values (48, 'Civic');
insert into "model" ("brand", "name") values (48, 'Clarity');
insert into "model" ("brand", "name") values (48, 'Concerto');
insert into "model" ("brand", "name") values (48, 'Element');
insert into "model" ("brand", "name") values (48, 'FR-V');
insert into "model" ("brand", "name") values (48, 'HR-V');
insert into "model" ("brand", "name") values (48, 'Insight');
insert into "model" ("brand", "name") values (48, 'Integra');
insert into "model" ("brand", "name") values (48, 'Jazz');
insert into "model" ("brand", "name") values (48, 'Legend');
insert into "model" ("brand", "name") values (48, 'Logo');
insert into "model" ("brand", "name") values (48, 'NSX');
insert into "model" ("brand", "name") values (48, 'Odyssey');
insert into "model" ("brand", "name") values (48, 'Pilot');
insert into "model" ("brand", "name") values (48, 'Prelude');
insert into "model" ("brand", "name") values (48, 'Ridgeline');
insert into "model" ("brand", "name") values (48, 'S2000');
insert into "model" ("brand", "name") values (48, 'Shuttle');
insert into "model" ("brand", "name") values (48, 'Stream');
insert into "model" ("brand", "name") values (48, 'e');
insert into "model" ("brand", "name") values (48, 'Other');
insert into "make" ("id", "name") values (49, 'Hummer');
insert into "model" ("brand", "name") values (49, 'H1');
insert into "model" ("brand", "name") values (49, 'H2');
insert into "model" ("brand", "name") values (49, 'H3');
insert into "model" ("brand", "name") values (49, 'Other');
insert into "make" ("id", "name") values (50, 'Hyundai');
insert into "model" ("brand", "name") values (50, 'Accent');
insert into "model" ("brand", "name") values (50, 'Atos');
insert into "model" ("brand", "name") values (50, 'Azera');
insert into "model" ("brand", "name") values (50, 'Coupe');
insert into "model" ("brand", "name") values (50, 'Elantra');
insert into "model" ("brand", "name") values (50, 'Excel');
insert into "model" ("brand", "name") values (50, 'Galloper');
insert into "model" ("brand", "name") values (50, 'Genesis');
insert into "model" ("brand", "name") values (50, 'Getz');
insert into "model" ("brand", "name") values (50, 'Grand Santa Fe');
insert into "model" ("brand", "name") values (50, 'Grandeur');
insert into "model" ("brand", "name") values (50, 'H 100');
insert into "model" ("brand", "name") values (50, 'H 200');
insert into "model" ("brand", "name") values (50, 'H-1');
insert into "model" ("brand", "name") values (50, 'H-1 Starex');
insert into "model" ("brand", "name") values (50, 'H350');
insert into "model" ("brand", "name") values (50, 'IONIQ');
insert into "model" ("brand", "name") values (50, 'Kona');
insert into "model" ("brand", "name") values (50, 'Lantra');
insert into "model" ("brand", "name") values (50, 'Matrix');
insert into "model" ("brand", "name") values (50, 'Nexo');
insert into "model" ("brand", "name") values (50, 'Pony');
insert into "model" ("brand", "name") values (50, 'S-Coupe');
insert into "model" ("brand", "name") values (50, 'Santa Fe');
insert into "model" ("brand", "name") values (50, 'Santamo');
insert into "model" ("brand", "name") values (50, 'Sonata');
insert into "model" ("brand", "name") values (50, 'Terracan');
insert into "model" ("brand", "name") values (50, 'Trajet');
insert into "model" ("brand", "name") values (50, 'Tucson');
insert into "model" ("brand", "name") values (50, 'Veloster');
insert into "model" ("brand", "name") values (50, 'Veracruz');
insert into "model" ("brand", "name") values (50, 'XG 30');
insert into "model" ("brand", "name") values (50, 'XG 350');
insert into "model" ("brand", "name") values (50, 'i10');
insert into "model" ("brand", "name") values (50, 'i20');
insert into "model" ("brand", "name") values (50, 'i30');
insert into "model" ("brand", "name") values (50, 'i40');
insert into "model" ("brand", "name") values (50, 'i50');
insert into "model" ("brand", "name") values (50, 'ix20');
insert into "model" ("brand", "name") values (50, 'ix35');
insert into "model" ("brand", "name") values (50, 'ix55');
insert into "model" ("brand", "name") values (50, 'Other');
insert into "make" ("id", "name") values (51, 'Infiniti');
insert into "model" ("brand", "name") values (51, 'EX30');
insert into "model" ("brand", "name") values (51, 'EX35');
insert into "model" ("brand", "name") values (51, 'EX37');
insert into "model" ("brand", "name") values (51, 'FX');
insert into "model" ("brand", "name") values (51, 'G35');
insert into "model" ("brand", "name") values (51, 'G37');
insert into "model" ("brand", "name") values (51, 'M30');
insert into "model" ("brand", "name") values (51, 'M35');
insert into "model" ("brand", "name") values (51, 'M37');
insert into "model" ("brand", "name") values (51, 'Q30');
insert into "model" ("brand", "name") values (51, 'Q45');
insert into "model" ("brand", "name") values (51, 'Q50');
insert into "model" ("brand", "name") values (51, 'Q60');
insert into "model" ("brand", "name") values (51, 'Q70');
insert into "model" ("brand", "name") values (51, 'QX30');
insert into "model" ("brand", "name") values (51, 'QX50');
insert into "model" ("brand", "name") values (51, 'QX56');
insert into "model" ("brand", "name") values (51, 'QX60');
insert into "model" ("brand", "name") values (51, 'QX70');
insert into "model" ("brand", "name") values (51, 'QX80');
insert into "model" ("brand", "name") values (51, 'Other');
insert into "make" ("id", "name") values (52, 'Isuzu');
insert into "model" ("brand", "name") values (52, 'Campo');
insert into "model" ("brand", "name") values (52, 'D-Max');
insert into "model" ("brand", "name") values (52, 'Gemini');
insert into "model" ("brand", "name") values (52, 'Midi');
insert into "model" ("brand", "name") values (52, 'PICK UP');
insert into "model" ("brand", "name") values (52, 'Trooper');
insert into "model" ("brand", "name") values (52, 'Other');
insert into "make" ("id", "name") values (53, 'Iveco');
insert into "model" ("brand", "name") values (53, 'Massif');
insert into "model" ("brand", "name") values (53, 'Other');
insert into "make" ("id", "name") values (54, 'Jaguar');
insert into "model" ("brand", "name") values (54, 'Daimler');
insert into "model" ("brand", "name") values (54, 'E-Pace');
insert into "model" ("brand", "name") values (54, 'E-Type');
insert into "model" ("brand", "name") values (54, 'F-Pace');
insert into "model" ("brand", "name") values (54, 'F-Type');
insert into "model" ("brand", "name") values (54, 'I-Pace');
insert into "model" ("brand", "name") values (54, 'MK II');
insert into "model" ("brand", "name") values (54, 'S-Type');
insert into "model" ("brand", "name") values (54, 'X-Type');
insert into "model" ("brand", "name") values (54, 'XE');
insert into "model" ("brand", "name") values (54, 'XF');
insert into "model" ("brand", "name") values (54, 'XJ');
insert into "model" ("brand", "name") values (54, 'XJ12');
insert into "model" ("brand", "name") values (54, 'XJ40');
insert into "model" ("brand", "name") values (54, 'XJ6');
insert into "model" ("brand", "name") values (54, 'XJ8');
insert into "model" ("brand", "name") values (54, 'XJR');
insert into "model" ("brand", "name") values (54, 'XJS');
insert into "model" ("brand", "name") values (54, 'XJSC');
insert into "model" ("brand", "name") values (54, 'XK');
insert into "model" ("brand", "name") values (54, 'XK8');
insert into "model" ("brand", "name") values (54, 'XKR');
insert into "model" ("brand", "name") values (54, 'Other');
insert into "make" ("id", "name") values (55, 'Jeep');
insert into "model" ("brand", "name") values (55, 'CJ');
insert into "model" ("brand", "name") values (55, 'Cherokee');
insert into "model" ("brand", "name") values (55, 'Comanche');
insert into "model" ("brand", "name") values (55, 'Commander');
insert into "model" ("brand", "name") values (55, 'Compass');
insert into "model" ("brand", "name") values (55, 'Gladiator');
insert into "model" ("brand", "name") values (55, 'Grand Cherokee');
insert into "model" ("brand", "name") values (55, 'Patriot');
insert into "model" ("brand", "name") values (55, 'Renegade');
insert into "model" ("brand", "name") values (55, 'Wagoneer');
insert into "model" ("brand", "name") values (55, 'Willys');
insert into "model" ("brand", "name") values (55, 'Wrangler');
insert into "model" ("brand", "name") values (55, 'Other');
insert into "make" ("id", "name") values (56, 'Kia');
insert into "model" ("brand", "name") values (56, 'Besta');
insert into "model" ("brand", "name") values (56, 'Borrego');
insert into "model" ("brand", "name") values (56, 'Carens');
insert into "model" ("brand", "name") values (56, 'Carnival');
insert into "model" ("brand", "name") values (56, 'Cerato');
insert into "model" ("brand", "name") values (56, 'Clarus');
insert into "model" ("brand", "name") values (56, 'Elan');
insert into "model" ("brand", "name") values (56, 'Joice');
insert into "model" ("brand", "name") values (56, 'K2500');
insert into "model" ("brand", "name") values (56, 'K2700');
insert into "model" ("brand", "name") values (56, 'Leo');
insert into "model" ("brand", "name") values (56, 'Magentis');
insert into "model" ("brand", "name") values (56, 'Mentor');
insert into "model" ("brand", "name") values (56, 'Mini');
insert into "model" ("brand", "name") values (56, 'Niro');
insert into "model" ("brand", "name") values (56, 'Opirus');
insert into "model" ("brand", "name") values (56, 'Optima');
insert into "model" ("brand", "name") values (56, 'Picanto');
insert into "model" ("brand", "name") values (56, 'Pregio');
insert into "model" ("brand", "name") values (56, 'Pride');
insert into "model" ("brand", "name") values (56, 'Retona');
insert into "model" ("brand", "name") values (56, 'Rio');
insert into "model" ("brand", "name") values (56, 'Roadster');
insert into "model" ("brand", "name") values (56, 'Rocsta');
insert into "model" ("brand", "name") values (56, 'Sephia');
insert into "model" ("brand", "name") values (56, 'Shuma');
insert into "model" ("brand", "name") values (56, 'Sorento');
insert into "model" ("brand", "name") values (56, 'Soul');
insert into "model" ("brand", "name") values (56, 'Sportage');
insert into "model" ("brand", "name") values (56, 'Stinger');
insert into "model" ("brand", "name") values (56, 'Stonic');
insert into "model" ("brand", "name") values (56, 'Venga');
insert into "model" ("brand", "name") values (56, 'XCeed');
insert into "model" ("brand", "name") values (56, 'cee''d / Ceed');
insert into "model" ("brand", "name") values (56, 'cee''d Sportswagon');
insert into "model" ("brand", "name") values (56, 'pro_cee''d / ProCeed');
insert into "model" ("brand", "name") values (56, 'Other');
insert into "make" ("id", "name") values (57, 'Koenigsegg');
insert into "model" ("brand", "name") values (57, 'Agera');
insert into "model" ("brand", "name") values (57, 'CCR');
insert into "model" ("brand", "name") values (57, 'CCXR');
insert into "model" ("brand", "name") values (57, 'Other');
insert into "make" ("id", "name") values (58, 'KTM');
insert into "model" ("brand", "name") values (58, 'X-BOW');
insert into "model" ("brand", "name") values (58, 'Other');
insert into "make" ("id", "name") values (59, 'Lada');
insert into "model" ("brand", "name") values (59, '110');
insert into "model" ("brand", "name") values (59, '111');
insert into "model" ("brand", "name") values (59, '112');
insert into "model" ("brand", "name") values (59, '1200');
insert into "model" ("brand", "name") values (59, '2107');
insert into "model" ("brand", "name") values (59, '2110');
insert into "model" ("brand", "name") values (59, '2111');
insert into "model" ("brand", "name") values (59, '2112');
insert into "model" ("brand", "name") values (59, 'Aleko');
insert into "model" ("brand", "name") values (59, 'Forma');
insert into "model" ("brand", "name") values (59, 'Granta');
insert into "model" ("brand", "name") values (59, 'Kalina');
insert into "model" ("brand", "name") values (59, 'Niva');
insert into "model" ("brand", "name") values (59, 'Nova');
insert into "model" ("brand", "name") values (59, 'Priora');
insert into "model" ("brand", "name") values (59, 'Samara');
insert into "model" ("brand", "name") values (59, 'Taiga');
insert into "model" ("brand", "name") values (59, 'Urban');
insert into "model" ("brand", "name") values (59, 'Vesta');
insert into "model" ("brand", "name") values (59, 'X-Ray');
insert into "model" ("brand", "name") values (59, 'Other');
insert into "make" ("id", "name") values (60, 'Lamborghini');
insert into "model" ("brand", "name") values (60, 'Aventador');
insert into "model" ("brand", "name") values (60, 'Countach');
insert into "model" ("brand", "name") values (60, 'Diablo');
insert into "model" ("brand", "name") values (60, 'Espada');
insert into "model" ("brand", "name") values (60, 'Gallardo');
insert into "model" ("brand", "name") values (60, 'Huracán');
insert into "model" ("brand", "name") values (60, 'Jalpa');
insert into "model" ("brand", "name") values (60, 'LM');
insert into "model" ("brand", "name") values (60, 'Miura');
insert into "model" ("brand", "name") values (60, 'Murciélago');
insert into "model" ("brand", "name") values (60, 'Urraco');
insert into "model" ("brand", "name") values (60, 'Urus');
insert into "model" ("brand", "name") values (60, 'Other');
insert into "make" ("id", "name") values (61, 'Lancia');
insert into "model" ("brand", "name") values (61, 'Beta');
insert into "model" ("brand", "name") values (61, 'Dedra');
insert into "model" ("brand", "name") values (61, 'Delta');
insert into "model" ("brand", "name") values (61, 'Flaminia');
insert into "model" ("brand", "name") values (61, 'Flavia');
insert into "model" ("brand", "name") values (61, 'Fulvia');
insert into "model" ("brand", "name") values (61, 'Gamma');
insert into "model" ("brand", "name") values (61, 'Kappa');
insert into "model" ("brand", "name") values (61, 'Lybra');
insert into "model" ("brand", "name") values (61, 'MUSA');
insert into "model" ("brand", "name") values (61, 'Phedra');
insert into "model" ("brand", "name") values (61, 'Prisma');
insert into "model" ("brand", "name") values (61, 'Stratos');
insert into "model" ("brand", "name") values (61, 'Thema');
insert into "model" ("brand", "name") values (61, 'Thesis');
insert into "model" ("brand", "name") values (61, 'Voyager');
insert into "model" ("brand", "name") values (61, 'Ypsilon');
insert into "model" ("brand", "name") values (61, 'Zeta');
insert into "model" ("brand", "name") values (61, 'Other');
insert into "make" ("id", "name") values (62, 'Land Rover');
insert into "model" ("brand", "name") values (62, 'Defender');
insert into "model" ("brand", "name") values (62, 'Discovery');
insert into "model" ("brand", "name") values (62, 'Discovery Sport');
insert into "model" ("brand", "name") values (62, 'Freelander');
insert into "model" ("brand", "name") values (62, 'Range Rover');
insert into "model" ("brand", "name") values (62, 'Range Rover Evoque');
insert into "model" ("brand", "name") values (62, 'Range Rover Sport');
insert into "model" ("brand", "name") values (62, 'Range Rover Velar');
insert into "model" ("brand", "name") values (62, 'Serie I');
insert into "model" ("brand", "name") values (62, 'Serie II');
insert into "model" ("brand", "name") values (62, 'Serie III');
insert into "model" ("brand", "name") values (62, 'Other');
insert into "make" ("id", "name") values (63, 'Landwind');
insert into "model" ("brand", "name") values (63, 'CV-9');
insert into "model" ("brand", "name") values (63, 'S');
insert into "model" ("brand", "name") values (63, 'SC2');
insert into "model" ("brand", "name") values (63, 'SC4');
insert into "model" ("brand", "name") values (63, 'Other');
insert into "make" ("id", "name") values (64, 'Lexus');
insert into "model" ("brand", "name") values (64, 'CT 200h');
insert into "model" ("brand", "name") values (64, 'ES 300');
insert into "model" ("brand", "name") values (64, 'ES 330');
insert into "model" ("brand", "name") values (64, 'ES 350');
insert into "model" ("brand", "name") values (64, 'GS 250');
insert into "model" ("brand", "name") values (64, 'GS 300');
insert into "model" ("brand", "name") values (64, 'GS 350');
insert into "model" ("brand", "name") values (64, 'GS 430');
insert into "model" ("brand", "name") values (64, 'GS 450');
insert into "model" ("brand", "name") values (64, 'GS 460');
insert into "model" ("brand", "name") values (64, 'GS F');
insert into "model" ("brand", "name") values (64, 'GX 460');
insert into "model" ("brand", "name") values (64, 'GX 470');
insert into "model" ("brand", "name") values (64, 'IS 200');
insert into "model" ("brand", "name") values (64, 'IS 220');
insert into "model" ("brand", "name") values (64, 'IS 250');
insert into "model" ("brand", "name") values (64, 'IS 300');
insert into "model" ("brand", "name") values (64, 'IS 350');
insert into "model" ("brand", "name") values (64, 'IS-F');
insert into "model" ("brand", "name") values (64, 'LC 500');
insert into "model" ("brand", "name") values (64, 'LC 500h');
insert into "model" ("brand", "name") values (64, 'LFA');
insert into "model" ("brand", "name") values (64, 'LS 400');
insert into "model" ("brand", "name") values (64, 'LS 430');
insert into "model" ("brand", "name") values (64, 'LS 460');
insert into "model" ("brand", "name") values (64, 'LS 500');
insert into "model" ("brand", "name") values (64, 'LS 600');
insert into "model" ("brand", "name") values (64, 'LX 450');
insert into "model" ("brand", "name") values (64, 'LX 470');
insert into "model" ("brand", "name") values (64, 'LX 570');
insert into "model" ("brand", "name") values (64, 'NX 200');
insert into "model" ("brand", "name") values (64, 'NX 300');
insert into "model" ("brand", "name") values (64, 'RC 200');
insert into "model" ("brand", "name") values (64, 'RC 300');
insert into "model" ("brand", "name") values (64, 'RC 350');
insert into "model" ("brand", "name") values (64, 'RC F');
insert into "model" ("brand", "name") values (64, 'RX 200');
insert into "model" ("brand", "name") values (64, 'RX 300');
insert into "model" ("brand", "name") values (64, 'RX 330');
insert into "model" ("brand", "name") values (64, 'RX 350');
insert into "model" ("brand", "name") values (64, 'RX 400');
insert into "model" ("brand", "name") values (64, 'RX 450');
insert into "model" ("brand", "name") values (64, 'SC 400');
insert into "model" ("brand", "name") values (64, 'SC 430');
insert into "model" ("brand", "name") values (64, 'UX');
insert into "model" ("brand", "name") values (64, 'Other');
insert into "make" ("id", "name") values (65, 'Ligier');
insert into "model" ("brand", "name") values (65, 'Ambra');
insert into "model" ("brand", "name") values (65, 'Be Sun');
insert into "model" ("brand", "name") values (65, 'JS 50');
insert into "model" ("brand", "name") values (65, 'JS 50 L');
insert into "model" ("brand", "name") values (65, 'JS RC');
insert into "model" ("brand", "name") values (65, 'Nova');
insert into "model" ("brand", "name") values (65, 'Optima');
insert into "model" ("brand", "name") values (65, 'X - Too');
insert into "model" ("brand", "name") values (65, 'Other');
insert into "make" ("id", "name") values (66, 'Lincoln');
insert into "model" ("brand", "name") values (66, 'Aviator');
insert into "model" ("brand", "name") values (66, 'Continental');
insert into "model" ("brand", "name") values (66, 'LS');
insert into "model" ("brand", "name") values (66, 'Mark');
insert into "model" ("brand", "name") values (66, 'Navigator');
insert into "model" ("brand", "name") values (66, 'Town Car');
insert into "model" ("brand", "name") values (66, 'Other');
insert into "make" ("id", "name") values (67, 'Lotus');
insert into "model" ("brand", "name") values (67, '340 R');
insert into "model" ("brand", "name") values (67, 'Cortina');
insert into "model" ("brand", "name") values (67, 'Elan');
insert into "model" ("brand", "name") values (67, 'Elise');
insert into "model" ("brand", "name") values (67, 'Elite');
insert into "model" ("brand", "name") values (67, 'Esprit');
insert into "model" ("brand", "name") values (67, 'Europa');
insert into "model" ("brand", "name") values (67, 'Evora');
insert into "model" ("brand", "name") values (67, 'Excel');
insert into "model" ("brand", "name") values (67, 'Exige');
insert into "model" ("brand", "name") values (67, 'Super Seven');
insert into "model" ("brand", "name") values (67, 'Other');
insert into "make" ("id", "name") values (68, 'Mahindra');
insert into "model" ("brand", "name") values (68, 'Other');
insert into "make" ("id", "name") values (69, 'Maserati');
insert into "model" ("brand", "name") values (69, '222');
insert into "model" ("brand", "name") values (69, '224');
insert into "model" ("brand", "name") values (69, '228');
insert into "model" ("brand", "name") values (69, '3200');
insert into "model" ("brand", "name") values (69, '418');
insert into "model" ("brand", "name") values (69, '420');
insert into "model" ("brand", "name") values (69, '4200');
insert into "model" ("brand", "name") values (69, '422');
insert into "model" ("brand", "name") values (69, '424');
insert into "model" ("brand", "name") values (69, '430');
insert into "model" ("brand", "name") values (69, 'Biturbo');
insert into "model" ("brand", "name") values (69, 'Ghibli');
insert into "model" ("brand", "name") values (69, 'GranCabrio');
insert into "model" ("brand", "name") values (69, 'Gransport');
insert into "model" ("brand", "name") values (69, 'Granturismo');
insert into "model" ("brand", "name") values (69, 'Indy');
insert into "model" ("brand", "name") values (69, 'Karif');
insert into "model" ("brand", "name") values (69, 'Levante');
insert into "model" ("brand", "name") values (69, 'MC12');
insert into "model" ("brand", "name") values (69, 'Merak');
insert into "model" ("brand", "name") values (69, 'Quattroporte');
insert into "model" ("brand", "name") values (69, 'Shamal');
insert into "model" ("brand", "name") values (69, 'Spyder');
insert into "model" ("brand", "name") values (69, 'Other');
insert into "make" ("id", "name") values (70, 'Maybach');
insert into "model" ("brand", "name") values (70, '57');
insert into "model" ("brand", "name") values (70, '62');
insert into "model" ("brand", "name") values (70, 'Pullman');
insert into "model" ("brand", "name") values (70, 'Other');
insert into "make" ("id", "name") values (71, 'Mazda');
insert into "model" ("brand", "name") values (71, '121');
insert into "model" ("brand", "name") values (71, '2');
insert into "model" ("brand", "name") values (71, '3');
insert into "model" ("brand", "name") values (71, '323');
insert into "model" ("brand", "name") values (71, '5');
insert into "model" ("brand", "name") values (71, '6');
insert into "model" ("brand", "name") values (71, '626');
insert into "model" ("brand", "name") values (71, '929');
insert into "model" ("brand", "name") values (71, 'B series');
insert into "model" ("brand", "name") values (71, 'BT-50');
insert into "model" ("brand", "name") values (71, 'Bongo');
insert into "model" ("brand", "name") values (71, 'CX-3');
insert into "model" ("brand", "name") values (71, 'CX-30');
insert into "model" ("brand", "name") values (71, 'CX-5');
insert into "model" ("brand", "name") values (71, 'CX-7');
insert into "model" ("brand", "name") values (71, 'CX-9');
insert into "model" ("brand", "name") values (71, 'Demio');
insert into "model" ("brand", "name") values (71, 'E series');
insert into "model" ("brand", "name") values (71, 'MPV');
insert into "model" ("brand", "name") values (71, 'MX-3');
insert into "model" ("brand", "name") values (71, 'MX-30');
insert into "model" ("brand", "name") values (71, 'MX-5');
insert into "model" ("brand", "name") values (71, 'MX-6');
insert into "model" ("brand", "name") values (71, 'Millenia');
insert into "model" ("brand", "name") values (71, 'Premacy');
insert into "model" ("brand", "name") values (71, 'Protege');
insert into "model" ("brand", "name") values (71, 'RX-6');
insert into "model" ("brand", "name") values (71, 'RX-7');
insert into "model" ("brand", "name") values (71, 'RX-8');
insert into "model" ("brand", "name") values (71, 'Tribute');
insert into "model" ("brand", "name") values (71, 'Xedos');
insert into "model" ("brand", "name") values (71, 'Other');
insert into "make" ("id", "name") values (72, 'McLaren');
insert into "model" ("brand", "name") values (72, '540C');
insert into "model" ("brand", "name") values (72, '570GT');
insert into "model" ("brand", "name") values (72, '570S');
insert into "model" ("brand", "name") values (72, '600LT');
insert into "model" ("brand", "name") values (72, '620R');
insert into "model" ("brand", "name") values (72, '650S');
insert into "model" ("brand", "name") values (72, '650S Coupé');
insert into "model" ("brand", "name") values (72, '650S Spider');
insert into "model" ("brand", "name") values (72, '675LT');
insert into "model" ("brand", "name") values (72, '675LT Spider');
insert into "model" ("brand", "name") values (72, '720S');
insert into "model" ("brand", "name") values (72, '750S');
insert into "model" ("brand", "name") values (72, '765');
insert into "model" ("brand", "name") values (72, '765LT');
insert into "model" ("brand", "name") values (72, 'Artura');
insert into "model" ("brand", "name") values (72, 'Elva');
insert into "model" ("brand", "name") values (72, 'GT');
insert into "model" ("brand", "name") values (72, 'MP4-12C');
insert into "model" ("brand", "name") values (72, 'P1');
insert into "model" ("brand", "name") values (72, 'Senna GTR');
insert into "model" ("brand", "name") values (72, 'Speedtail');
insert into "model" ("brand", "name") values (72, 'Other');
insert into "make" ("id", "name") values (73, 'Mercedes-Benz');
insert into "model" ("brand", "name") values (73, '190');
insert into "model" ("brand", "name") values (73, '200');
insert into "model" ("brand", "name") values (73, '220');
insert into "model" ("brand", "name") values (73, '230');
insert into "model" ("brand", "name") values (73, '240');
insert into "model" ("brand", "name") values (73, '250');
insert into "model" ("brand", "name") values (73, '260');
insert into "model" ("brand", "name") values (73, '270');
insert into "model" ("brand", "name") values (73, '280');
insert into "model" ("brand", "name") values (73, '290');
insert into "model" ("brand", "name") values (73, '300');
insert into "model" ("brand", "name") values (73, '320');
insert into "model" ("brand", "name") values (73, '350');
insert into "model" ("brand", "name") values (73, '380');
insert into "model" ("brand", "name") values (73, '400');
insert into "model" ("brand", "name") values (73, '416');
insert into "model" ("brand", "name") values (73, '420');
insert into "model" ("brand", "name") values (73, '450');
insert into "model" ("brand", "name") values (73, '500');
insert into "model" ("brand", "name") values (73, '560');
insert into "model" ("brand", "name") values (73, '600');
insert into "model" ("brand", "name") values (73, 'A 140');
insert into "model" ("brand", "name") values (73, 'A 150');
insert into "model" ("brand", "name") values (73, 'A 160');
insert into "model" ("brand", "name") values (73, 'A 170');
insert into "model" ("brand", "name") values (73, 'A 180');
insert into "model" ("brand", "name") values (73, 'A 190');
insert into "model" ("brand", "name") values (73, 'A 200');
insert into "model" ("brand", "name") values (73, 'A 210');
insert into "model" ("brand", "name") values (73, 'A 220');
insert into "model" ("brand", "name") values (73, 'A 250');
insert into "model" ("brand", "name") values (73, 'A 35 AMG');
insert into "model" ("brand", "name") values (73, 'A 45 AMG');
insert into "model" ("brand", "name") values (73, 'AMG GT');
insert into "model" ("brand", "name") values (73, 'AMG GT C');
insert into "model" ("brand", "name") values (73, 'AMG GT R');
insert into "model" ("brand", "name") values (73, 'AMG GT S');
insert into "model" ("brand", "name") values (73, 'B 150');
insert into "model" ("brand", "name") values (73, 'B 160');
insert into "model" ("brand", "name") values (73, 'B 170');
insert into "model" ("brand", "name") values (73, 'B 180');
insert into "model" ("brand", "name") values (73, 'B 200');
insert into "model" ("brand", "name") values (73, 'B 220');
insert into "model" ("brand", "name") values (73, 'B 250');
insert into "model" ("brand", "name") values (73, 'B Electric Drive');
insert into "model" ("brand", "name") values (73, 'C 160');
insert into "model" ("brand", "name") values (73, 'C 180');
insert into "model" ("brand", "name") values (73, 'C 200');
insert into "model" ("brand", "name") values (73, 'C 220');
insert into "model" ("brand", "name") values (73, 'C 230');
insert into "model" ("brand", "name") values (73, 'C 240');
insert into "model" ("brand", "name") values (73, 'C 250');
insert into "model" ("brand", "name") values (73, 'C 270');
insert into "model" ("brand", "name") values (73, 'C 280');
insert into "model" ("brand", "name") values (73, 'C 30 AMG');
insert into "model" ("brand", "name") values (73, 'C 300');
insert into "model" ("brand", "name") values (73, 'C 32 AMG');
insert into "model" ("brand", "name") values (73, 'C 320');
insert into "model" ("brand", "name") values (73, 'C 350');
insert into "model" ("brand", "name") values (73, 'C 36 AMG');
insert into "model" ("brand", "name") values (73, 'C 400');
insert into "model" ("brand", "name") values (73, 'C 43 AMG');
insert into "model" ("brand", "name") values (73, 'C 450 AMG');
insert into "model" ("brand", "name") values (73, 'C 55 AMG');
insert into "model" ("brand", "name") values (73, 'C 63 AMG');
insert into "model" ("brand", "name") values (73, 'CE 200');
insert into "model" ("brand", "name") values (73, 'CE 220');
insert into "model" ("brand", "name") values (73, 'CE 230');
insert into "model" ("brand", "name") values (73, 'CE 280');
insert into "model" ("brand", "name") values (73, 'CE 300');
insert into "model" ("brand", "name") values (73, 'CE 320');
insert into "model" ("brand", "name") values (73, 'CL 160');
insert into "model" ("brand", "name") values (73, 'CL 180');
insert into "model" ("brand", "name") values (73, 'CL 200');
insert into "model" ("brand", "name") values (73, 'CL 220');
insert into "model" ("brand", "name") values (73, 'CL 230');
insert into "model" ("brand", "name") values (73, 'CL 320');
insert into "model" ("brand", "name") values (73, 'CL 420');
insert into "model" ("brand", "name") values (73, 'CL 500');
insert into "model" ("brand", "name") values (73, 'CL 55 AMG');
insert into "model" ("brand", "name") values (73, 'CL 600');
insert into "model" ("brand", "name") values (73, 'CL 63 AMG');
insert into "model" ("brand", "name") values (73, 'CL 65 AMG');
insert into "model" ("brand", "name") values (73, 'CLA 180');
insert into "model" ("brand", "name") values (73, 'CLA 180 Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLA 200');
insert into "model" ("brand", "name") values (73, 'CLA 200 Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLA 220');
insert into "model" ("brand", "name") values (73, 'CLA 220 Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLA 250');
insert into "model" ("brand", "name") values (73, 'CLA 250 Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLA 35 AMG');
insert into "model" ("brand", "name") values (73, 'CLA 45 AMG');
insert into "model" ("brand", "name") values (73, 'CLA 45 AMG Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLA Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLC 160');
insert into "model" ("brand", "name") values (73, 'CLC 180');
insert into "model" ("brand", "name") values (73, 'CLC 200');
insert into "model" ("brand", "name") values (73, 'CLC 220');
insert into "model" ("brand", "name") values (73, 'CLC 230');
insert into "model" ("brand", "name") values (73, 'CLC 250');
insert into "model" ("brand", "name") values (73, 'CLC 350');
insert into "model" ("brand", "name") values (73, 'CLK 200');
insert into "model" ("brand", "name") values (73, 'CLK 220');
insert into "model" ("brand", "name") values (73, 'CLK 230');
insert into "model" ("brand", "name") values (73, 'CLK 240');
insert into "model" ("brand", "name") values (73, 'CLK 270');
insert into "model" ("brand", "name") values (73, 'CLK 280');
insert into "model" ("brand", "name") values (73, 'CLK 320');
insert into "model" ("brand", "name") values (73, 'CLK 350');
insert into "model" ("brand", "name") values (73, 'CLK 430');
insert into "model" ("brand", "name") values (73, 'CLK 500');
insert into "model" ("brand", "name") values (73, 'CLK 55 AMG');
insert into "model" ("brand", "name") values (73, 'CLK 63 AMG');
insert into "model" ("brand", "name") values (73, 'CLS 220');
insert into "model" ("brand", "name") values (73, 'CLS 220 Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLS 250');
insert into "model" ("brand", "name") values (73, 'CLS 250 Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLS 280');
insert into "model" ("brand", "name") values (73, 'CLS 300');
insert into "model" ("brand", "name") values (73, 'CLS 320');
insert into "model" ("brand", "name") values (73, 'CLS 350');
insert into "model" ("brand", "name") values (73, 'CLS 350 Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLS 400');
insert into "model" ("brand", "name") values (73, 'CLS 400 Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLS 450');
insert into "model" ("brand", "name") values (73, 'CLS 500');
insert into "model" ("brand", "name") values (73, 'CLS 500 Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLS 53 AMG');
insert into "model" ("brand", "name") values (73, 'CLS 55 AMG');
insert into "model" ("brand", "name") values (73, 'CLS 63 AMG');
insert into "model" ("brand", "name") values (73, 'CLS 63 AMG Shooting Brake');
insert into "model" ("brand", "name") values (73, 'CLS Shooting Brake');
insert into "model" ("brand", "name") values (73, 'Citan');
insert into "model" ("brand", "name") values (73, 'E 200');
insert into "model" ("brand", "name") values (73, 'E 220');
insert into "model" ("brand", "name") values (73, 'E 230');
insert into "model" ("brand", "name") values (73, 'E 240');
insert into "model" ("brand", "name") values (73, 'E 250');
insert into "model" ("brand", "name") values (73, 'E 260');
insert into "model" ("brand", "name") values (73, 'E 270');
insert into "model" ("brand", "name") values (73, 'E 280');
insert into "model" ("brand", "name") values (73, 'E 290');
insert into "model" ("brand", "name") values (73, 'E 300');
insert into "model" ("brand", "name") values (73, 'E 320');
insert into "model" ("brand", "name") values (73, 'E 350');
insert into "model" ("brand", "name") values (73, 'E 36 AMG');
insert into "model" ("brand", "name") values (73, 'E 400');
insert into "model" ("brand", "name") values (73, 'E 420');
insert into "model" ("brand", "name") values (73, 'E 43 AMG');
insert into "model" ("brand", "name") values (73, 'E 430');
insert into "model" ("brand", "name") values (73, 'E 450');
insert into "model" ("brand", "name") values (73, 'E 50');
insert into "model" ("brand", "name") values (73, 'E 500');
insert into "model" ("brand", "name") values (73, 'E 53 AMG');
insert into "model" ("brand", "name") values (73, 'E 55 AMG');
insert into "model" ("brand", "name") values (73, 'E 60 AMG');
insert into "model" ("brand", "name") values (73, 'E 63 AMG');
insert into "model" ("brand", "name") values (73, 'EQA');
insert into "model" ("brand", "name") values (73, 'EQC');
insert into "model" ("brand", "name") values (73, 'EQV');
insert into "model" ("brand", "name") values (73, 'G 230');
insert into "model" ("brand", "name") values (73, 'G 240');
insert into "model" ("brand", "name") values (73, 'G 250');
insert into "model" ("brand", "name") values (73, 'G 270');
insert into "model" ("brand", "name") values (73, 'G 280');
insert into "model" ("brand", "name") values (73, 'G 290');
insert into "model" ("brand", "name") values (73, 'G 300');
insert into "model" ("brand", "name") values (73, 'G 320');
insert into "model" ("brand", "name") values (73, 'G 350');
insert into "model" ("brand", "name") values (73, 'G 400');
insert into "model" ("brand", "name") values (73, 'G 500');
insert into "model" ("brand", "name") values (73, 'G 55 AMG');
insert into "model" ("brand", "name") values (73, 'G 63 AMG');
insert into "model" ("brand", "name") values (73, 'G 65 AMG');
insert into "model" ("brand", "name") values (73, 'GL 320');
insert into "model" ("brand", "name") values (73, 'GL 350');
insert into "model" ("brand", "name") values (73, 'GL 400');
insert into "model" ("brand", "name") values (73, 'GL 420');
insert into "model" ("brand", "name") values (73, 'GL 450');
insert into "model" ("brand", "name") values (73, 'GL 500');
insert into "model" ("brand", "name") values (73, 'GL 55 AMG');
insert into "model" ("brand", "name") values (73, 'GL 63 AMG');
insert into "model" ("brand", "name") values (73, 'GLA 180');
insert into "model" ("brand", "name") values (73, 'GLA 200');
insert into "model" ("brand", "name") values (73, 'GLA 220');
insert into "model" ("brand", "name") values (73, 'GLA 250');
insert into "model" ("brand", "name") values (73, 'GLA 35 AMG');
insert into "model" ("brand", "name") values (73, 'GLA 45 AMG');
insert into "model" ("brand", "name") values (73, 'GLB 180');
insert into "model" ("brand", "name") values (73, 'GLB 200');
insert into "model" ("brand", "name") values (73, 'GLB 220');
insert into "model" ("brand", "name") values (73, 'GLB 250');
insert into "model" ("brand", "name") values (73, 'GLB 35 AMG');
insert into "model" ("brand", "name") values (73, 'GLC 200');
insert into "model" ("brand", "name") values (73, 'GLC 220');
insert into "model" ("brand", "name") values (73, 'GLC 250');
insert into "model" ("brand", "name") values (73, 'GLC 300');
insert into "model" ("brand", "name") values (73, 'GLC 350');
insert into "model" ("brand", "name") values (73, 'GLC 400');
insert into "model" ("brand", "name") values (73, 'GLC 43 AMG');
insert into "model" ("brand", "name") values (73, 'GLC 63 AMG');
insert into "model" ("brand", "name") values (73, 'GLE 250');
insert into "model" ("brand", "name") values (73, 'GLE 300');
insert into "model" ("brand", "name") values (73, 'GLE 350');
insert into "model" ("brand", "name") values (73, 'GLE 400');
insert into "model" ("brand", "name") values (73, 'GLE 43 AMG');
insert into "model" ("brand", "name") values (73, 'GLE 450');
insert into "model" ("brand", "name") values (73, 'GLE 500');
insert into "model" ("brand", "name") values (73, 'GLE 53 AMG');
insert into "model" ("brand", "name") values (73, 'GLE 580');
insert into "model" ("brand", "name") values (73, 'GLE 63 AMG');
insert into "model" ("brand", "name") values (73, 'GLK 200');
insert into "model" ("brand", "name") values (73, 'GLK 220');
insert into "model" ("brand", "name") values (73, 'GLK 250');
insert into "model" ("brand", "name") values (73, 'GLK 280');
insert into "model" ("brand", "name") values (73, 'GLK 300');
insert into "model" ("brand", "name") values (73, 'GLK 320');
insert into "model" ("brand", "name") values (73, 'GLK 350');
insert into "model" ("brand", "name") values (73, 'GLS 350');
insert into "model" ("brand", "name") values (73, 'GLS 400');
insert into "model" ("brand", "name") values (73, 'GLS 450');
insert into "model" ("brand", "name") values (73, 'GLS 500');
insert into "model" ("brand", "name") values (73, 'GLS 580');
insert into "model" ("brand", "name") values (73, 'GLS 600');
insert into "model" ("brand", "name") values (73, 'GLS 63');
insert into "model" ("brand", "name") values (73, 'MB 100');
insert into "model" ("brand", "name") values (73, 'ML 230');
insert into "model" ("brand", "name") values (73, 'ML 250');
insert into "model" ("brand", "name") values (73, 'ML 270');
insert into "model" ("brand", "name") values (73, 'ML 280');
insert into "model" ("brand", "name") values (73, 'ML 300');
insert into "model" ("brand", "name") values (73, 'ML 320');
insert into "model" ("brand", "name") values (73, 'ML 350');
insert into "model" ("brand", "name") values (73, 'ML 400');
insert into "model" ("brand", "name") values (73, 'ML 420');
insert into "model" ("brand", "name") values (73, 'ML 430');
insert into "model" ("brand", "name") values (73, 'ML 450');
insert into "model" ("brand", "name") values (73, 'ML 500');
insert into "model" ("brand", "name") values (73, 'ML 55 AMG');
insert into "model" ("brand", "name") values (73, 'ML 63 AMG');
insert into "model" ("brand", "name") values (73, 'R 280');
insert into "model" ("brand", "name") values (73, 'R 300');
insert into "model" ("brand", "name") values (73, 'R 320');
insert into "model" ("brand", "name") values (73, 'R 350');
insert into "model" ("brand", "name") values (73, 'R 500');
insert into "model" ("brand", "name") values (73, 'R 63 AMG');
insert into "model" ("brand", "name") values (73, 'S 250');
insert into "model" ("brand", "name") values (73, 'S 260');
insert into "model" ("brand", "name") values (73, 'S 280');
insert into "model" ("brand", "name") values (73, 'S 300');
insert into "model" ("brand", "name") values (73, 'S 320');
insert into "model" ("brand", "name") values (73, 'S 350');
insert into "model" ("brand", "name") values (73, 'S 400');
insert into "model" ("brand", "name") values (73, 'S 420');
insert into "model" ("brand", "name") values (73, 'S 430');
insert into "model" ("brand", "name") values (73, 'S 450');
insert into "model" ("brand", "name") values (73, 'S 500');
insert into "model" ("brand", "name") values (73, 'S 55');
insert into "model" ("brand", "name") values (73, 'S 550');
insert into "model" ("brand", "name") values (73, 'S 560');
insert into "model" ("brand", "name") values (73, 'S 600');
insert into "model" ("brand", "name") values (73, 'S 63 AMG');
insert into "model" ("brand", "name") values (73, 'S 65 AMG');
insert into "model" ("brand", "name") values (73, 'S 650');
insert into "model" ("brand", "name") values (73, 'SL 280');
insert into "model" ("brand", "name") values (73, 'SL 300');
insert into "model" ("brand", "name") values (73, 'SL 320');
insert into "model" ("brand", "name") values (73, 'SL 350');
insert into "model" ("brand", "name") values (73, 'SL 380');
insert into "model" ("brand", "name") values (73, 'SL 400');
insert into "model" ("brand", "name") values (73, 'SL 420');
insert into "model" ("brand", "name") values (73, 'SL 450');
insert into "model" ("brand", "name") values (73, 'SL 500');
insert into "model" ("brand", "name") values (73, 'SL 55 AMG');
insert into "model" ("brand", "name") values (73, 'SL 560');
insert into "model" ("brand", "name") values (73, 'SL 60 AMG');
insert into "model" ("brand", "name") values (73, 'SL 600');
insert into "model" ("brand", "name") values (73, 'SL 63 AMG');
insert into "model" ("brand", "name") values (73, 'SL 65 AMG');
insert into "model" ("brand", "name") values (73, 'SL 70 AMG');
insert into "model" ("brand", "name") values (73, 'SL 73 AMG');
insert into "model" ("brand", "name") values (73, 'SLC 180');
insert into "model" ("brand", "name") values (73, 'SLC 200');
insert into "model" ("brand", "name") values (73, 'SLC 250');
insert into "model" ("brand", "name") values (73, 'SLC 280');
insert into "model" ("brand", "name") values (73, 'SLC 300');
insert into "model" ("brand", "name") values (73, 'SLC 43 AMG');
insert into "model" ("brand", "name") values (73, 'SLK 200');
insert into "model" ("brand", "name") values (73, 'SLK 230');
insert into "model" ("brand", "name") values (73, 'SLK 250');
insert into "model" ("brand", "name") values (73, 'SLK 280');
insert into "model" ("brand", "name") values (73, 'SLK 300');
insert into "model" ("brand", "name") values (73, 'SLK 32 AMG');
insert into "model" ("brand", "name") values (73, 'SLK 320');
insert into "model" ("brand", "name") values (73, 'SLK 350');
insert into "model" ("brand", "name") values (73, 'SLK 55 AMG');
insert into "model" ("brand", "name") values (73, 'SLR');
insert into "model" ("brand", "name") values (73, 'SLS AMG');
insert into "model" ("brand", "name") values (73, 'Sprinter');
insert into "model" ("brand", "name") values (73, 'V 200');
insert into "model" ("brand", "name") values (73, 'V 220');
insert into "model" ("brand", "name") values (73, 'V 230');
insert into "model" ("brand", "name") values (73, 'V 250');
insert into "model" ("brand", "name") values (73, 'V 280');
insert into "model" ("brand", "name") values (73, 'V 300');
insert into "model" ("brand", "name") values (73, 'Vaneo');
insert into "model" ("brand", "name") values (73, 'Vario');
insert into "model" ("brand", "name") values (73, 'Viano');
insert into "model" ("brand", "name") values (73, 'Vito');
insert into "model" ("brand", "name") values (73, 'X 220');
insert into "model" ("brand", "name") values (73, 'X 250');
insert into "model" ("brand", "name") values (73, 'X 350');
insert into "model" ("brand", "name") values (73, 'Other');
insert into "make" ("id", "name") values (74, 'MG');
insert into "model" ("brand", "name") values (74, 'EHS');
insert into "model" ("brand", "name") values (74, 'MGA');
insert into "model" ("brand", "name") values (74, 'MGB');
insert into "model" ("brand", "name") values (74, 'MGF');
insert into "model" ("brand", "name") values (74, 'Midget');
insert into "model" ("brand", "name") values (74, 'Montego');
insert into "model" ("brand", "name") values (74, 'TD');
insert into "model" ("brand", "name") values (74, 'TF');
insert into "model" ("brand", "name") values (74, 'ZR');
insert into "model" ("brand", "name") values (74, 'ZS');
insert into "model" ("brand", "name") values (74, 'ZT');
insert into "model" ("brand", "name") values (74, 'Other');
insert into "make" ("id", "name") values (75, 'Microcar');
insert into "model" ("brand", "name") values (75, 'DUÈ');
insert into "model" ("brand", "name") values (75, 'Flex');
insert into "model" ("brand", "name") values (75, 'M.Go');
insert into "model" ("brand", "name") values (75, 'M-8');
insert into "model" ("brand", "name") values (75, 'MC1');
insert into "model" ("brand", "name") values (75, 'MC2');
insert into "model" ("brand", "name") values (75, 'Virgo');
insert into "model" ("brand", "name") values (75, 'Other');
insert into "make" ("id", "name") values (76, 'MINI');
insert into "model" ("brand", "name") values (76, '1000');
insert into "model" ("brand", "name") values (76, '1300');
insert into "model" ("brand", "name") values (76, 'Clubvan');
insert into "model" ("brand", "name") values (76, 'Cooper');
insert into "model" ("brand", "name") values (76, 'Cooper Cabrio');
insert into "model" ("brand", "name") values (76, 'Cooper Clubman');
insert into "model" ("brand", "name") values (76, 'Cooper Countryman');
insert into "model" ("brand", "name") values (76, 'Cooper Coupé');
insert into "model" ("brand", "name") values (76, 'Cooper D');
insert into "model" ("brand", "name") values (76, 'Cooper D Cabrio');
insert into "model" ("brand", "name") values (76, 'Cooper D Clubman');
insert into "model" ("brand", "name") values (76, 'Cooper D Countryman');
insert into "model" ("brand", "name") values (76, 'Cooper D Paceman');
insert into "model" ("brand", "name") values (76, 'Cooper Paceman');
insert into "model" ("brand", "name") values (76, 'Cooper Roadster');
insert into "model" ("brand", "name") values (76, 'Cooper S');
insert into "model" ("brand", "name") values (76, 'Cooper SD');
insert into "model" ("brand", "name") values (76, 'Cooper SD Cabrio');
insert into "model" ("brand", "name") values (76, 'Cooper SD Clubman');
insert into "model" ("brand", "name") values (76, 'Cooper SD Countryman');
insert into "model" ("brand", "name") values (76, 'Cooper SD Coupé');
insert into "model" ("brand", "name") values (76, 'Cooper SD Paceman');
insert into "model" ("brand", "name") values (76, 'Cooper SD Roadster');
insert into "model" ("brand", "name") values (76, 'Cooper S Cabrio');
insert into "model" ("brand", "name") values (76, 'Cooper S Clubman');
insert into "model" ("brand", "name") values (76, 'Cooper S Countryman');
insert into "model" ("brand", "name") values (76, 'Cooper S Coupé');
insert into "model" ("brand", "name") values (76, 'Cooper S Paceman');
insert into "model" ("brand", "name") values (76, 'Cooper S Roadster');
insert into "model" ("brand", "name") values (76, 'John Cooper Works');
insert into "model" ("brand", "name") values (76, 'John Cooper Works Cabrio');
insert into "model" ("brand", "name") values (76, 'John Cooper Works Clubman');
insert into "model" ("brand", "name") values (76, 'John Cooper Works Countryman');
insert into "model" ("brand", "name") values (76, 'John Cooper Works Coupé');
insert into "model" ("brand", "name") values (76, 'John Cooper Works Paceman');
insert into "model" ("brand", "name") values (76, 'John Cooper Works Roadster');
insert into "model" ("brand", "name") values (76, 'ONE');
insert into "model" ("brand", "name") values (76, 'One Cabrio');
insert into "model" ("brand", "name") values (76, 'One Clubman');
insert into "model" ("brand", "name") values (76, 'One Countryman');
insert into "model" ("brand", "name") values (76, 'One D');
insert into "model" ("brand", "name") values (76, 'One D Clubman');
insert into "model" ("brand", "name") values (76, 'One D Countryman');
insert into "model" ("brand", "name") values (76, 'One First');
insert into "model" ("brand", "name") values (76, 'Other');
insert into "make" ("id", "name") values (77, 'Mitsubishi');
insert into "model" ("brand", "name") values (77, '3000 GT');
insert into "model" ("brand", "name") values (77, 'ASX');
insert into "model" ("brand", "name") values (77, 'Canter');
insert into "model" ("brand", "name") values (77, 'Carisma');
insert into "model" ("brand", "name") values (77, 'Colt');
insert into "model" ("brand", "name") values (77, 'Cordia');
insert into "model" ("brand", "name") values (77, 'Cosmos');
insert into "model" ("brand", "name") values (77, 'Diamante');
insert into "model" ("brand", "name") values (77, 'Eclipse');
insert into "model" ("brand", "name") values (77, 'Eclipse Cross');
insert into "model" ("brand", "name") values (77, 'Galant');
insert into "model" ("brand", "name") values (77, 'Galloper');
insert into "model" ("brand", "name") values (77, 'Grandis');
insert into "model" ("brand", "name") values (77, 'L200');
insert into "model" ("brand", "name") values (77, 'L300');
insert into "model" ("brand", "name") values (77, 'L400');
insert into "model" ("brand", "name") values (77, 'Lancer');
insert into "model" ("brand", "name") values (77, 'Mirage');
insert into "model" ("brand", "name") values (77, 'Montero');
insert into "model" ("brand", "name") values (77, 'Outlander');
insert into "model" ("brand", "name") values (77, 'Pajero');
insert into "model" ("brand", "name") values (77, 'Pajero Pinin');
insert into "model" ("brand", "name") values (77, 'Pick-up');
insert into "model" ("brand", "name") values (77, 'Plug-in Hybrid Outlander');
insert into "model" ("brand", "name") values (77, 'Santamo');
insert into "model" ("brand", "name") values (77, 'Sapporo');
insert into "model" ("brand", "name") values (77, 'Sigma');
insert into "model" ("brand", "name") values (77, 'Space Gear');
insert into "model" ("brand", "name") values (77, 'Space Runner');
insert into "model" ("brand", "name") values (77, 'Space Star');
insert into "model" ("brand", "name") values (77, 'Space Wagon');
insert into "model" ("brand", "name") values (77, 'Starion');
insert into "model" ("brand", "name") values (77, 'Tredia');
insert into "model" ("brand", "name") values (77, 'i-MiEV');
insert into "model" ("brand", "name") values (77, 'Other');
insert into "make" ("id", "name") values (78, 'Morgan');
insert into "model" ("brand", "name") values (78, '3 Wheeler');
insert into "model" ("brand", "name") values (78, '4/4');
insert into "model" ("brand", "name") values (78, 'Aero 8');
insert into "model" ("brand", "name") values (78, 'Plus 4');
insert into "model" ("brand", "name") values (78, 'Plus 6');
insert into "model" ("brand", "name") values (78, 'Plus 8');
insert into "model" ("brand", "name") values (78, 'Roadster');
insert into "model" ("brand", "name") values (78, 'Other');
insert into "make" ("id", "name") values (79, 'Nissan');
insert into "model" ("brand", "name") values (79, '100 NX');
insert into "model" ("brand", "name") values (79, '200 SX');
insert into "model" ("brand", "name") values (79, '240 SX');
insert into "model" ("brand", "name") values (79, '280 ZX');
insert into "model" ("brand", "name") values (79, '300 ZX');
insert into "model" ("brand", "name") values (79, '350Z');
insert into "model" ("brand", "name") values (79, '370Z');
insert into "model" ("brand", "name") values (79, 'Almera');
insert into "model" ("brand", "name") values (79, 'Almera Tino');
insert into "model" ("brand", "name") values (79, 'Altima');
insert into "model" ("brand", "name") values (79, 'Armada');
insert into "model" ("brand", "name") values (79, 'Bluebird');
insert into "model" ("brand", "name") values (79, 'Cabstar');
insert into "model" ("brand", "name") values (79, 'Cargo');
insert into "model" ("brand", "name") values (79, 'Cherry');
insert into "model" ("brand", "name") values (79, 'Cube');
insert into "model" ("brand", "name") values (79, 'Evalia');
insert into "model" ("brand", "name") values (79, 'Frontier');
insert into "model" ("brand", "name") values (79, 'GT-R');
insert into "model" ("brand", "name") values (79, 'Interstar');
insert into "model" ("brand", "name") values (79, 'Juke');
insert into "model" ("brand", "name") values (79, 'King Cab');
insert into "model" ("brand", "name") values (79, 'Kubistar');
insert into "model" ("brand", "name") values (79, 'Laurel');
insert into "model" ("brand", "name") values (79, 'Leaf');
insert into "model" ("brand", "name") values (79, 'Maxima');
insert into "model" ("brand", "name") values (79, 'Micra');
insert into "model" ("brand", "name") values (79, 'Murano');
insert into "model" ("brand", "name") values (79, 'NP 300');
insert into "model" ("brand", "name") values (79, 'NV200');
insert into "model" ("brand", "name") values (79, 'NV250');
insert into "model" ("brand", "name") values (79, 'NV300');
insert into "model" ("brand", "name") values (79, 'NV400');
insert into "model" ("brand", "name") values (79, 'Navara');
insert into "model" ("brand", "name") values (79, 'Note');
insert into "model" ("brand", "name") values (79, 'Pathfinder');
insert into "model" ("brand", "name") values (79, 'Patrol');
insert into "model" ("brand", "name") values (79, 'PickUp');
insert into "model" ("brand", "name") values (79, 'Pixo');
insert into "model" ("brand", "name") values (79, 'Prairie');
insert into "model" ("brand", "name") values (79, 'Primastar');
insert into "model" ("brand", "name") values (79, 'Primera');
insert into "model" ("brand", "name") values (79, 'Pulsar');
insert into "model" ("brand", "name") values (79, 'Qashqai');
insert into "model" ("brand", "name") values (79, 'Qashqai+2');
insert into "model" ("brand", "name") values (79, 'Quest');
insert into "model" ("brand", "name") values (79, 'Sentra');
insert into "model" ("brand", "name") values (79, 'Serena');
insert into "model" ("brand", "name") values (79, 'Silvia');
insert into "model" ("brand", "name") values (79, 'Skyline');
insert into "model" ("brand", "name") values (79, 'Sunny');
insert into "model" ("brand", "name") values (79, 'Terrano');
insert into "model" ("brand", "name") values (79, 'Tiida');
insert into "model" ("brand", "name") values (79, 'Titan');
insert into "model" ("brand", "name") values (79, 'Trade');
insert into "model" ("brand", "name") values (79, 'Urvan');
insert into "model" ("brand", "name") values (79, 'Vanette');
insert into "model" ("brand", "name") values (79, 'X-Trail');
insert into "model" ("brand", "name") values (79, 'e-NV200');
insert into "model" ("brand", "name") values (79, 'Other');
insert into "make" ("id", "name") values (80, 'NSU');
insert into "model" ("brand", "name") values (80, 'Other');
insert into "make" ("id", "name") values (81, 'Oldsmobile');
insert into "model" ("brand", "name") values (81, 'Bravada');
insert into "model" ("brand", "name") values (81, 'Custom Cruiser');
insert into "model" ("brand", "name") values (81, 'Cutlass');
insert into "model" ("brand", "name") values (81, 'Delta 88');
insert into "model" ("brand", "name") values (81, 'Silhouette');
insert into "model" ("brand", "name") values (81, 'Supreme');
insert into "model" ("brand", "name") values (81, 'Toronado');
insert into "model" ("brand", "name") values (81, 'Other');
insert into "make" ("id", "name") values (82, 'Opel');
insert into "model" ("brand", "name") values (82, 'Adam');
insert into "model" ("brand", "name") values (82, 'Agila');
insert into "model" ("brand", "name") values (82, 'Ampera');
insert into "model" ("brand", "name") values (82, 'Ampera-e');
insert into "model" ("brand", "name") values (82, 'Antara');
insert into "model" ("brand", "name") values (82, 'Arena');
insert into "model" ("brand", "name") values (82, 'Ascona');
insert into "model" ("brand", "name") values (82, 'Astra');
insert into "model" ("brand", "name") values (82, 'Calibra');
insert into "model" ("brand", "name") values (82, 'Campo');
insert into "model" ("brand", "name") values (82, 'Cascada');
insert into "model" ("brand", "name") values (82, 'Cavalier');
insert into "model" ("brand", "name") values (82, 'Combo');
insert into "model" ("brand", "name") values (82, 'Commodore');
insert into "model" ("brand", "name") values (82, 'Corsa');
insert into "model" ("brand", "name") values (82, 'Crossland X');
insert into "model" ("brand", "name") values (82, 'Diplomat');
insert into "model" ("brand", "name") values (82, 'Frontera');
insert into "model" ("brand", "name") values (82, 'GT');
insert into "model" ("brand", "name") values (82, 'Grandland X');
insert into "model" ("brand", "name") values (82, 'Insignia');
insert into "model" ("brand", "name") values (82, 'Insignia CT');
insert into "model" ("brand", "name") values (82, 'Kadett');
insert into "model" ("brand", "name") values (82, 'Karl');
insert into "model" ("brand", "name") values (82, 'Manta');
insert into "model" ("brand", "name") values (82, 'Meriva');
insert into "model" ("brand", "name") values (82, 'Mokka');
insert into "model" ("brand", "name") values (82, 'Mokka X');
insert into "model" ("brand", "name") values (82, 'Monterey');
insert into "model" ("brand", "name") values (82, 'Monza');
insert into "model" ("brand", "name") values (82, 'Movano');
insert into "model" ("brand", "name") values (82, 'Nova');
insert into "model" ("brand", "name") values (82, 'Omega');
insert into "model" ("brand", "name") values (82, 'Pick Up Sportscap');
insert into "model" ("brand", "name") values (82, 'Rekord');
insert into "model" ("brand", "name") values (82, 'Senator');
insert into "model" ("brand", "name") values (82, 'Signum');
insert into "model" ("brand", "name") values (82, 'Sintra');
insert into "model" ("brand", "name") values (82, 'Speedster');
insert into "model" ("brand", "name") values (82, 'Tigra');
insert into "model" ("brand", "name") values (82, 'Vectra');
insert into "model" ("brand", "name") values (82, 'Vivaro');
insert into "model" ("brand", "name") values (82, 'Zafira');
insert into "model" ("brand", "name") values (82, 'Zafira Life');
insert into "model" ("brand", "name") values (82, 'Zafira Tourer');
insert into "model" ("brand", "name") values (82, 'Other');
insert into "make" ("id", "name") values (83, 'Pagani');
insert into "model" ("brand", "name") values (83, 'Huayra');
insert into "model" ("brand", "name") values (83, 'Zonda');
insert into "model" ("brand", "name") values (83, 'Other');
insert into "make" ("id", "name") values (84, 'Peugeot');
insert into "model" ("brand", "name") values (84, '1007');
insert into "model" ("brand", "name") values (84, '104');
insert into "model" ("brand", "name") values (84, '106');
insert into "model" ("brand", "name") values (84, '107');
insert into "model" ("brand", "name") values (84, '108');
insert into "model" ("brand", "name") values (84, '2008');
insert into "model" ("brand", "name") values (84, '204');
insert into "model" ("brand", "name") values (84, '205');
insert into "model" ("brand", "name") values (84, '206');
insert into "model" ("brand", "name") values (84, '207');
insert into "model" ("brand", "name") values (84, '208');
insert into "model" ("brand", "name") values (84, '3008');
insert into "model" ("brand", "name") values (84, '301');
insert into "model" ("brand", "name") values (84, '304');
insert into "model" ("brand", "name") values (84, '305');
insert into "model" ("brand", "name") values (84, '306');
insert into "model" ("brand", "name") values (84, '307');
insert into "model" ("brand", "name") values (84, '308');
insert into "model" ("brand", "name") values (84, '309');
insert into "model" ("brand", "name") values (84, '4007');
insert into "model" ("brand", "name") values (84, '4008');
insert into "model" ("brand", "name") values (84, '404');
insert into "model" ("brand", "name") values (84, '405');
insert into "model" ("brand", "name") values (84, '406');
insert into "model" ("brand", "name") values (84, '407');
insert into "model" ("brand", "name") values (84, '5008');
insert into "model" ("brand", "name") values (84, '504');
insert into "model" ("brand", "name") values (84, '505');
insert into "model" ("brand", "name") values (84, '508');
insert into "model" ("brand", "name") values (84, '604');
insert into "model" ("brand", "name") values (84, '605');
insert into "model" ("brand", "name") values (84, '607');
insert into "model" ("brand", "name") values (84, '806');
insert into "model" ("brand", "name") values (84, '807');
insert into "model" ("brand", "name") values (84, 'Bipper');
insert into "model" ("brand", "name") values (84, 'Bipper Tepee');
insert into "model" ("brand", "name") values (84, 'Boxer');
insert into "model" ("brand", "name") values (84, 'Expert');
insert into "model" ("brand", "name") values (84, 'Expert Tepee');
insert into "model" ("brand", "name") values (84, 'J5');
insert into "model" ("brand", "name") values (84, 'Partner');
insert into "model" ("brand", "name") values (84, 'Partner Tepee');
insert into "model" ("brand", "name") values (84, 'RCZ');
insert into "model" ("brand", "name") values (84, 'Rifter');
insert into "model" ("brand", "name") values (84, 'TePee');
insert into "model" ("brand", "name") values (84, 'Traveller');
insert into "model" ("brand", "name") values (84, 'iOn');
insert into "model" ("brand", "name") values (84, 'Other');
insert into "make" ("id", "name") values (85, 'Piaggio');
insert into "model" ("brand", "name") values (85, 'APE');
insert into "model" ("brand", "name") values (85, 'APE TM');
insert into "model" ("brand", "name") values (85, 'Porter');
insert into "model" ("brand", "name") values (85, 'Other');
insert into "make" ("id", "name") values (86, 'Plymouth');
insert into "model" ("brand", "name") values (86, 'Prowler');
insert into "model" ("brand", "name") values (86, 'Other');
insert into "make" ("id", "name") values (87, 'Polestar');
insert into "model" ("brand", "name") values (87, '1');
insert into "model" ("brand", "name") values (87, '2');
insert into "model" ("brand", "name") values (87, 'Other');
insert into "make" ("id", "name") values (88, 'Pontiac');
insert into "model" ("brand", "name") values (88, '6000');
insert into "model" ("brand", "name") values (88, 'Bonneville');
insert into "model" ("brand", "name") values (88, 'Fiero');
insert into "model" ("brand", "name") values (88, 'Firebird');
insert into "model" ("brand", "name") values (88, 'G6');
insert into "model" ("brand", "name") values (88, 'GTO');
insert into "model" ("brand", "name") values (88, 'Grand-Am');
insert into "model" ("brand", "name") values (88, 'Grand-Prix');
insert into "model" ("brand", "name") values (88, 'Montana');
insert into "model" ("brand", "name") values (88, 'Solstice');
insert into "model" ("brand", "name") values (88, 'Sunbird');
insert into "model" ("brand", "name") values (88, 'Sunfire');
insert into "model" ("brand", "name") values (88, 'Targa');
insert into "model" ("brand", "name") values (88, 'Trans Am');
insert into "model" ("brand", "name") values (88, 'Trans Sport');
insert into "model" ("brand", "name") values (88, 'Vibe');
insert into "model" ("brand", "name") values (88, 'Other');
insert into "make" ("id", "name") values (89, 'Porsche');
insert into "model" ("brand", "name") values (89, '356');
insert into "model" ("brand", "name") values (89, '911');
insert into "model" ("brand", "name") values (89, '912');
insert into "model" ("brand", "name") values (89, '914');
insert into "model" ("brand", "name") values (89, '918');
insert into "model" ("brand", "name") values (89, '924');
insert into "model" ("brand", "name") values (89, '928');
insert into "model" ("brand", "name") values (89, '930');
insert into "model" ("brand", "name") values (89, '944');
insert into "model" ("brand", "name") values (89, '959');
insert into "model" ("brand", "name") values (89, '962');
insert into "model" ("brand", "name") values (89, '964');
insert into "model" ("brand", "name") values (89, '968');
insert into "model" ("brand", "name") values (89, '991');
insert into "model" ("brand", "name") values (89, '992');
insert into "model" ("brand", "name") values (89, '993');
insert into "model" ("brand", "name") values (89, '996');
insert into "model" ("brand", "name") values (89, '997');
insert into "model" ("brand", "name") values (89, 'Boxster');
insert into "model" ("brand", "name") values (89, 'Carrera GT');
insert into "model" ("brand", "name") values (89, 'Cayenne');
insert into "model" ("brand", "name") values (89, 'Cayman');
insert into "model" ("brand", "name") values (89, 'Macan');
insert into "model" ("brand", "name") values (89, 'Panamera');
insert into "model" ("brand", "name") values (89, 'Taycan');
insert into "model" ("brand", "name") values (89, 'Other');
insert into "make" ("id", "name") values (90, 'Proton');
insert into "model" ("brand", "name") values (90, '300 Serie');
insert into "model" ("brand", "name") values (90, '400 Serie');
insert into "model" ("brand", "name") values (90, 'Other');
insert into "make" ("id", "name") values (91, 'Renault');
insert into "model" ("brand", "name") values (91, 'Alaskan');
insert into "model" ("brand", "name") values (91, 'Alpine A110');
insert into "model" ("brand", "name") values (91, 'Alpine A310');
insert into "model" ("brand", "name") values (91, 'Alpine V6');
insert into "model" ("brand", "name") values (91, 'Arkana');
insert into "model" ("brand", "name") values (91, 'Avantime');
insert into "model" ("brand", "name") values (91, 'Captur');
insert into "model" ("brand", "name") values (91, 'Clio');
insert into "model" ("brand", "name") values (91, 'Coupe');
insert into "model" ("brand", "name") values (91, 'Espace');
insert into "model" ("brand", "name") values (91, 'Express');
insert into "model" ("brand", "name") values (91, 'Fluence');
insert into "model" ("brand", "name") values (91, 'Fuego');
insert into "model" ("brand", "name") values (91, 'Grand Espace');
insert into "model" ("brand", "name") values (91, 'Grand Modus');
insert into "model" ("brand", "name") values (91, 'Grand Scenic');
insert into "model" ("brand", "name") values (91, 'Kadjar');
insert into "model" ("brand", "name") values (91, 'Kangoo');
insert into "model" ("brand", "name") values (91, 'Koleos');
insert into "model" ("brand", "name") values (91, 'Laguna');
insert into "model" ("brand", "name") values (91, 'Latitude');
insert into "model" ("brand", "name") values (91, 'Mascott');
insert into "model" ("brand", "name") values (91, 'Master');
insert into "model" ("brand", "name") values (91, 'Megane');
insert into "model" ("brand", "name") values (91, 'Modus');
insert into "model" ("brand", "name") values (91, 'P 1400');
insert into "model" ("brand", "name") values (91, 'R 11');
insert into "model" ("brand", "name") values (91, 'R 14');
insert into "model" ("brand", "name") values (91, 'R 18');
insert into "model" ("brand", "name") values (91, 'R 19');
insert into "model" ("brand", "name") values (91, 'R 20');
insert into "model" ("brand", "name") values (91, 'R 21');
insert into "model" ("brand", "name") values (91, 'R 25');
insert into "model" ("brand", "name") values (91, 'R 30');
insert into "model" ("brand", "name") values (91, 'R 4');
insert into "model" ("brand", "name") values (91, 'R 5');
insert into "model" ("brand", "name") values (91, 'R 6');
insert into "model" ("brand", "name") values (91, 'R 9');
insert into "model" ("brand", "name") values (91, 'Rapid');
insert into "model" ("brand", "name") values (91, 'Safrane');
insert into "model" ("brand", "name") values (91, 'Scenic');
insert into "model" ("brand", "name") values (91, 'Spider');
insert into "model" ("brand", "name") values (91, 'Talisman');
insert into "model" ("brand", "name") values (91, 'Trafic');
insert into "model" ("brand", "name") values (91, 'Twingo');
insert into "model" ("brand", "name") values (91, 'Twizy');
insert into "model" ("brand", "name") values (91, 'Vel Satis');
insert into "model" ("brand", "name") values (91, 'Wind');
insert into "model" ("brand", "name") values (91, 'ZOE');
insert into "model" ("brand", "name") values (91, 'Other');
insert into "make" ("id", "name") values (92, 'Rolls-Royce');
insert into "model" ("brand", "name") values (92, 'Corniche');
insert into "model" ("brand", "name") values (92, 'Cullinan');
insert into "model" ("brand", "name") values (92, 'Dawn');
insert into "model" ("brand", "name") values (92, 'Flying Spur');
insert into "model" ("brand", "name") values (92, 'Ghost');
insert into "model" ("brand", "name") values (92, 'Park Ward');
insert into "model" ("brand", "name") values (92, 'Phantom');
insert into "model" ("brand", "name") values (92, 'Silver Cloud');
insert into "model" ("brand", "name") values (92, 'Silver Dawn');
insert into "model" ("brand", "name") values (92, 'Silver Seraph');
insert into "model" ("brand", "name") values (92, 'Silver Shadow');
insert into "model" ("brand", "name") values (92, 'Silver Spirit');
insert into "model" ("brand", "name") values (92, 'Silver Spur');
insert into "model" ("brand", "name") values (92, 'Wraith');
insert into "model" ("brand", "name") values (92, 'Other');
insert into "make" ("id", "name") values (93, 'Rover');
insert into "model" ("brand", "name") values (93, '100');
insert into "model" ("brand", "name") values (93, '111');
insert into "model" ("brand", "name") values (93, '114');
insert into "model" ("brand", "name") values (93, '115');
insert into "model" ("brand", "name") values (93, '200');
insert into "model" ("brand", "name") values (93, '213');
insert into "model" ("brand", "name") values (93, '214');
insert into "model" ("brand", "name") values (93, '216');
insert into "model" ("brand", "name") values (93, '218');
insert into "model" ("brand", "name") values (93, '220');
insert into "model" ("brand", "name") values (93, '25');
insert into "model" ("brand", "name") values (93, '400');
insert into "model" ("brand", "name") values (93, '414');
insert into "model" ("brand", "name") values (93, '416');
insert into "model" ("brand", "name") values (93, '418');
insert into "model" ("brand", "name") values (93, '420');
insert into "model" ("brand", "name") values (93, '45');
insert into "model" ("brand", "name") values (93, '600');
insert into "model" ("brand", "name") values (93, '618');
insert into "model" ("brand", "name") values (93, '620');
insert into "model" ("brand", "name") values (93, '623');
insert into "model" ("brand", "name") values (93, '75');
insert into "model" ("brand", "name") values (93, '800');
insert into "model" ("brand", "name") values (93, '820');
insert into "model" ("brand", "name") values (93, '825');
insert into "model" ("brand", "name") values (93, '827');
insert into "model" ("brand", "name") values (93, 'City Rover');
insert into "model" ("brand", "name") values (93, 'Metro');
insert into "model" ("brand", "name") values (93, 'Montego');
insert into "model" ("brand", "name") values (93, 'SD');
insert into "model" ("brand", "name") values (93, 'Streetwise');
insert into "model" ("brand", "name") values (93, 'Other');
insert into "make" ("id", "name") values (94, 'Ruf');
insert into "model" ("brand", "name") values (94, 'Other');
insert into "make" ("id", "name") values (95, 'Saab');
insert into "model" ("brand", "name") values (95, '9-3');
insert into "model" ("brand", "name") values (95, '9-4X');
insert into "model" ("brand", "name") values (95, '9-5');
insert into "model" ("brand", "name") values (95, '9-7X');
insert into "model" ("brand", "name") values (95, '90');
insert into "model" ("brand", "name") values (95, '900');
insert into "model" ("brand", "name") values (95, '9000');
insert into "model" ("brand", "name") values (95, '96');
insert into "model" ("brand", "name") values (95, '99');
insert into "model" ("brand", "name") values (95, 'Other');
insert into "make" ("id", "name") values (96, 'Santana');
insert into "model" ("brand", "name") values (96, 'Other');
insert into "make" ("id", "name") values (97, 'Seat');
insert into "model" ("brand", "name") values (97, 'Alhambra');
insert into "model" ("brand", "name") values (97, 'Altea');
insert into "model" ("brand", "name") values (97, 'Arona');
insert into "model" ("brand", "name") values (97, 'Arosa');
insert into "model" ("brand", "name") values (97, 'Ateca');
insert into "model" ("brand", "name") values (97, 'Cordoba');
insert into "model" ("brand", "name") values (97, 'Exeo');
insert into "model" ("brand", "name") values (97, 'Ibiza');
insert into "model" ("brand", "name") values (97, 'Inca');
insert into "model" ("brand", "name") values (97, 'Leon');
insert into "model" ("brand", "name") values (97, 'Malaga');
insert into "model" ("brand", "name") values (97, 'Marbella');
insert into "model" ("brand", "name") values (97, 'Mii');
insert into "model" ("brand", "name") values (97, 'Tarraco');
insert into "model" ("brand", "name") values (97, 'Terra');
insert into "model" ("brand", "name") values (97, 'Toledo');
insert into "model" ("brand", "name") values (97, 'Other');
insert into "make" ("id", "name") values (98, 'Skoda');
insert into "model" ("brand", "name") values (98, '105');
insert into "model" ("brand", "name") values (98, '120');
insert into "model" ("brand", "name") values (98, '130');
insert into "model" ("brand", "name") values (98, '135');
insert into "model" ("brand", "name") values (98, 'Citigo');
insert into "model" ("brand", "name") values (98, 'Enyaq');
insert into "model" ("brand", "name") values (98, 'Fabia');
insert into "model" ("brand", "name") values (98, 'Favorit');
insert into "model" ("brand", "name") values (98, 'Felicia');
insert into "model" ("brand", "name") values (98, 'Forman');
insert into "model" ("brand", "name") values (98, 'Kamiq');
insert into "model" ("brand", "name") values (98, 'Karoq');
insert into "model" ("brand", "name") values (98, 'Kodiaq');
insert into "model" ("brand", "name") values (98, 'Octavia');
insert into "model" ("brand", "name") values (98, 'Pick-up');
insert into "model" ("brand", "name") values (98, 'Praktik');
insert into "model" ("brand", "name") values (98, 'Rapid');
insert into "model" ("brand", "name") values (98, 'Roomster');
insert into "model" ("brand", "name") values (98, 'Scala');
insert into "model" ("brand", "name") values (98, 'Superb');
insert into "model" ("brand", "name") values (98, 'Yeti');
insert into "model" ("brand", "name") values (98, 'Other');
insert into "make" ("id", "name") values (99, 'Smart');
insert into "model" ("brand", "name") values (99, 'Crossblade');
insert into "model" ("brand", "name") values (99, 'ForFour');
insert into "model" ("brand", "name") values (99, 'ForTwo');
insert into "model" ("brand", "name") values (99, 'Roadster');
insert into "model" ("brand", "name") values (99, 'Other');
insert into "make" ("id", "name") values (100, 'speedART');
insert into "model" ("brand", "name") values (100, 'Other');
insert into "make" ("id", "name") values (101, 'Spyker');
insert into "model" ("brand", "name") values (101, 'C8');
insert into "model" ("brand", "name") values (101, 'C8 AILERON');
insert into "model" ("brand", "name") values (101, 'C8 DOUBLE 12 S');
insert into "model" ("brand", "name") values (101, 'C8 LAVIOLETTE SWB');
insert into "model" ("brand", "name") values (101, 'C8 SPYDER SWB');
insert into "model" ("brand", "name") values (101, 'Other');
insert into "make" ("id", "name") values (102, 'Ssangyong');
insert into "model" ("brand", "name") values (102, 'Actyon');
insert into "model" ("brand", "name") values (102, 'Family');
insert into "model" ("brand", "name") values (102, 'Korando');
insert into "model" ("brand", "name") values (102, 'Kyron');
insert into "model" ("brand", "name") values (102, 'MUSSO');
insert into "model" ("brand", "name") values (102, 'REXTON');
insert into "model" ("brand", "name") values (102, 'Rodius');
insert into "model" ("brand", "name") values (102, 'Tivoli');
insert into "model" ("brand", "name") values (102, 'XLV');
insert into "model" ("brand", "name") values (102, 'Other');
insert into "make" ("id", "name") values (103, 'Subaru');
insert into "model" ("brand", "name") values (103, 'B9 Tribeca');
insert into "model" ("brand", "name") values (103, 'BRZ');
insert into "model" ("brand", "name") values (103, 'Baja');
insert into "model" ("brand", "name") values (103, 'Forester');
insert into "model" ("brand", "name") values (103, 'Impreza');
insert into "model" ("brand", "name") values (103, 'Justy');
insert into "model" ("brand", "name") values (103, 'Legacy');
insert into "model" ("brand", "name") values (103, 'Levorg');
insert into "model" ("brand", "name") values (103, 'Libero');
insert into "model" ("brand", "name") values (103, 'Outback');
insert into "model" ("brand", "name") values (103, 'SVX');
insert into "model" ("brand", "name") values (103, 'Trezia');
insert into "model" ("brand", "name") values (103, 'Tribeca');
insert into "model" ("brand", "name") values (103, 'Vivio');
insert into "model" ("brand", "name") values (103, 'WRX STI');
insert into "model" ("brand", "name") values (103, 'XT');
insert into "model" ("brand", "name") values (103, 'XV');
insert into "model" ("brand", "name") values (103, 'Other');
insert into "make" ("id", "name") values (104, 'Suzuki');
insert into "model" ("brand", "name") values (104, 'Across');
insert into "model" ("brand", "name") values (104, 'Alto');
insert into "model" ("brand", "name") values (104, 'Baleno');
insert into "model" ("brand", "name") values (104, 'Cappuccino');
insert into "model" ("brand", "name") values (104, 'Carry');
insert into "model" ("brand", "name") values (104, 'Celerio');
insert into "model" ("brand", "name") values (104, 'Grand Vitara');
insert into "model" ("brand", "name") values (104, 'Ignis');
insert into "model" ("brand", "name") values (104, 'Jimny');
insert into "model" ("brand", "name") values (104, 'Kizashi');
insert into "model" ("brand", "name") values (104, 'LJ');
insert into "model" ("brand", "name") values (104, 'Liana');
insert into "model" ("brand", "name") values (104, 'SJ Samurai');
insert into "model" ("brand", "name") values (104, 'SX4');
insert into "model" ("brand", "name") values (104, 'SX4 S-Cross');
insert into "model" ("brand", "name") values (104, 'Splash');
insert into "model" ("brand", "name") values (104, 'Super-Carry');
insert into "model" ("brand", "name") values (104, 'Swace');
insert into "model" ("brand", "name") values (104, 'Swift');
insert into "model" ("brand", "name") values (104, 'Vitara');
insert into "model" ("brand", "name") values (104, 'Wagon R+');
insert into "model" ("brand", "name") values (104, 'X-90');
insert into "model" ("brand", "name") values (104, 'iK-2');
insert into "model" ("brand", "name") values (104, 'Other');
insert into "make" ("id", "name") values (105, 'Talbot');
insert into "model" ("brand", "name") values (105, 'Horizon');
insert into "model" ("brand", "name") values (105, 'Samba');
insert into "model" ("brand", "name") values (105, 'Other');
insert into "make" ("id", "name") values (106, 'Tata');
insert into "model" ("brand", "name") values (106, 'Indica');
insert into "model" ("brand", "name") values (106, 'Indigo');
insert into "model" ("brand", "name") values (106, 'Nano');
insert into "model" ("brand", "name") values (106, 'Safari');
insert into "model" ("brand", "name") values (106, 'Sumo');
insert into "model" ("brand", "name") values (106, 'Telcoline');
insert into "model" ("brand", "name") values (106, 'Telcosport');
insert into "model" ("brand", "name") values (106, 'Xenon');
insert into "model" ("brand", "name") values (106, 'Other');
insert into "make" ("id", "name") values (107, 'TECHART');
insert into "model" ("brand", "name") values (107, 'Other');
insert into "make" ("id", "name") values (108, 'Tesla');
insert into "model" ("brand", "name") values (108, 'Model 3');
insert into "model" ("brand", "name") values (108, 'Model S');
insert into "model" ("brand", "name") values (108, 'Model X');
insert into "model" ("brand", "name") values (108, 'Model Y');
insert into "model" ("brand", "name") values (108, 'Roadster');
insert into "model" ("brand", "name") values (108, 'Other');
insert into "make" ("id", "name") values (109, 'Toyota');
insert into "model" ("brand", "name") values (109, '4-Runner');
insert into "model" ("brand", "name") values (109, 'Alphard');
insert into "model" ("brand", "name") values (109, 'Auris');
insert into "model" ("brand", "name") values (109, 'Auris Touring Sports');
insert into "model" ("brand", "name") values (109, 'Avalon');
insert into "model" ("brand", "name") values (109, 'Avensis');
insert into "model" ("brand", "name") values (109, 'Avensis Verso');
insert into "model" ("brand", "name") values (109, 'Aygo');
insert into "model" ("brand", "name") values (109, 'C-HR');
insert into "model" ("brand", "name") values (109, 'Camry');
insert into "model" ("brand", "name") values (109, 'Carina');
insert into "model" ("brand", "name") values (109, 'Celica');
insert into "model" ("brand", "name") values (109, 'Corolla');
insert into "model" ("brand", "name") values (109, 'Corolla Verso');
insert into "model" ("brand", "name") values (109, 'Cressida');
insert into "model" ("brand", "name") values (109, 'Crown');
insert into "model" ("brand", "name") values (109, 'Dyna');
insert into "model" ("brand", "name") values (109, 'FCV');
insert into "model" ("brand", "name") values (109, 'FJ');
insert into "model" ("brand", "name") values (109, 'Fortuner');
insert into "model" ("brand", "name") values (109, 'GT86');
insert into "model" ("brand", "name") values (109, 'Hiace');
insert into "model" ("brand", "name") values (109, 'Highlander');
insert into "model" ("brand", "name") values (109, 'Hilux');
insert into "model" ("brand", "name") values (109, 'IQ');
insert into "model" ("brand", "name") values (109, 'Land Cruiser');
insert into "model" ("brand", "name") values (109, 'Lite-Ace');
insert into "model" ("brand", "name") values (109, 'MR 2');
insert into "model" ("brand", "name") values (109, 'Matrix');
insert into "model" ("brand", "name") values (109, 'Mirai');
insert into "model" ("brand", "name") values (109, 'PROACE CITY');
insert into "model" ("brand", "name") values (109, 'Paseo');
insert into "model" ("brand", "name") values (109, 'Picnic');
insert into "model" ("brand", "name") values (109, 'Previa');
insert into "model" ("brand", "name") values (109, 'Prius');
insert into "model" ("brand", "name") values (109, 'Prius+');
insert into "model" ("brand", "name") values (109, 'Proace (Verso)');
insert into "model" ("brand", "name") values (109, 'RAV 4');
insert into "model" ("brand", "name") values (109, 'Sequoia');
insert into "model" ("brand", "name") values (109, 'Sienna');
insert into "model" ("brand", "name") values (109, 'Starlet');
insert into "model" ("brand", "name") values (109, 'Supra');
insert into "model" ("brand", "name") values (109, 'Tacoma');
insert into "model" ("brand", "name") values (109, 'Tercel');
insert into "model" ("brand", "name") values (109, 'Tundra');
insert into "model" ("brand", "name") values (109, 'Urban Cruiser');
insert into "model" ("brand", "name") values (109, 'Verso');
insert into "model" ("brand", "name") values (109, 'Verso-S');
insert into "model" ("brand", "name") values (109, 'Yaris');
insert into "model" ("brand", "name") values (109, 'Other');
insert into "make" ("id", "name") values (110, 'Trabant');
insert into "model" ("brand", "name") values (110, '601');
insert into "model" ("brand", "name") values (110, 'Other');
insert into "make" ("id", "name") values (111, 'Triumph');
insert into "model" ("brand", "name") values (111, 'Dolomite');
insert into "model" ("brand", "name") values (111, 'Moss');
insert into "model" ("brand", "name") values (111, 'Spitfire');
insert into "model" ("brand", "name") values (111, 'TR3');
insert into "model" ("brand", "name") values (111, 'TR4');
insert into "model" ("brand", "name") values (111, 'TR5');
insert into "model" ("brand", "name") values (111, 'TR6');
insert into "model" ("brand", "name") values (111, 'TR7');
insert into "model" ("brand", "name") values (111, 'TR8');
insert into "model" ("brand", "name") values (111, 'Other');
insert into "make" ("id", "name") values (112, 'TVR');
insert into "model" ("brand", "name") values (112, 'Chimaera');
insert into "model" ("brand", "name") values (112, 'Griffith');
insert into "model" ("brand", "name") values (112, 'Tuscan');
insert into "model" ("brand", "name") values (112, 'Other');
insert into "make" ("id", "name") values (113, 'Volvo');
insert into "model" ("brand", "name") values (113, '240');
insert into "model" ("brand", "name") values (113, '244');
insert into "model" ("brand", "name") values (113, '245');
insert into "model" ("brand", "name") values (113, '262');
insert into "model" ("brand", "name") values (113, '264');
insert into "model" ("brand", "name") values (113, '340');
insert into "model" ("brand", "name") values (113, '360');
insert into "model" ("brand", "name") values (113, '440');
insert into "model" ("brand", "name") values (113, '460');
insert into "model" ("brand", "name") values (113, '480');
insert into "model" ("brand", "name") values (113, '740');
insert into "model" ("brand", "name") values (113, '744');
insert into "model" ("brand", "name") values (113, '745');
insert into "model" ("brand", "name") values (113, '760');
insert into "model" ("brand", "name") values (113, '780');
insert into "model" ("brand", "name") values (113, '850');
insert into "model" ("brand", "name") values (113, '855');
insert into "model" ("brand", "name") values (113, '940');
insert into "model" ("brand", "name") values (113, '944');
insert into "model" ("brand", "name") values (113, '945');
insert into "model" ("brand", "name") values (113, '960');
insert into "model" ("brand", "name") values (113, '965');
insert into "model" ("brand", "name") values (113, 'Amazon');
insert into "model" ("brand", "name") values (113, 'C30');
insert into "model" ("brand", "name") values (113, 'C70');
insert into "model" ("brand", "name") values (113, 'Polar');
insert into "model" ("brand", "name") values (113, 'S40');
insert into "model" ("brand", "name") values (113, 'S60');
insert into "model" ("brand", "name") values (113, 'S60 Cross Country');
insert into "model" ("brand", "name") values (113, 'S70');
insert into "model" ("brand", "name") values (113, 'S80');
insert into "model" ("brand", "name") values (113, 'S90');
insert into "model" ("brand", "name") values (113, 'V40');
insert into "model" ("brand", "name") values (113, 'V40 Cross Country');
insert into "model" ("brand", "name") values (113, 'V50');
insert into "model" ("brand", "name") values (113, 'V60');
insert into "model" ("brand", "name") values (113, 'V60 Cross Country');
insert into "model" ("brand", "name") values (113, 'V70');
insert into "model" ("brand", "name") values (113, 'V90');
insert into "model" ("brand", "name") values (113, 'V90 Cross Country');
insert into "model" ("brand", "name") values (113, 'XC40');
insert into "model" ("brand", "name") values (113, 'XC60');
insert into "model" ("brand", "name") values (113, 'XC70');
insert into "model" ("brand", "name") values (113, 'XC90');
insert into "model" ("brand", "name") values (113, 'Other');
insert into "make" ("id", "name") values (114, 'Volkswagen');
insert into "model" ("brand", "name") values (114, '181');
insert into "model" ("brand", "name") values (114, 'Amarok');
insert into "model" ("brand", "name") values (114, 'Arteon');
insert into "model" ("brand", "name") values (114, 'Beetle');
insert into "model" ("brand", "name") values (114, 'Bora');
insert into "model" ("brand", "name") values (114, 'Buggy');
insert into "model" ("brand", "name") values (114, 'CC');
insert into "model" ("brand", "name") values (114, 'Caddy');
insert into "model" ("brand", "name") values (114, 'Corrado');
insert into "model" ("brand", "name") values (114, 'Crafter');
insert into "model" ("brand", "name") values (114, 'Eos');
insert into "model" ("brand", "name") values (114, 'Fox');
insert into "model" ("brand", "name") values (114, 'Golf');
insert into "model" ("brand", "name") values (114, 'Golf Plus');
insert into "model" ("brand", "name") values (114, 'Golf Sportsvan');
insert into "model" ("brand", "name") values (114, 'ID.3');
insert into "model" ("brand", "name") values (114, 'ID.4');
insert into "model" ("brand", "name") values (114, 'Iltis');
insert into "model" ("brand", "name") values (114, 'Jetta');
insert into "model" ("brand", "name") values (114, 'Karmann Ghia');
insert into "model" ("brand", "name") values (114, 'LT');
insert into "model" ("brand", "name") values (114, 'Lupo');
insert into "model" ("brand", "name") values (114, 'New Beetle');
insert into "model" ("brand", "name") values (114, 'Passat');
insert into "model" ("brand", "name") values (114, 'Passat Alltrack');
insert into "model" ("brand", "name") values (114, 'Passat CC');
insert into "model" ("brand", "name") values (114, 'Passat Variant');
insert into "model" ("brand", "name") values (114, 'Phaeton');
insert into "model" ("brand", "name") values (114, 'Polo');
insert into "model" ("brand", "name") values (114, 'Routan');
insert into "model" ("brand", "name") values (114, 'Santana');
insert into "model" ("brand", "name") values (114, 'Scirocco');
insert into "model" ("brand", "name") values (114, 'Sharan');
insert into "model" ("brand", "name") values (114, 'T-Cross');
insert into "model" ("brand", "name") values (114, 'T-Roc');
insert into "model" ("brand", "name") values (114, 'T1');
insert into "model" ("brand", "name") values (114, 'T2');
insert into "model" ("brand", "name") values (114, 'T3 Caravelle');
insert into "model" ("brand", "name") values (114, 'T3 Multivan');
insert into "model" ("brand", "name") values (114, 'T3 Kombi');
insert into "model" ("brand", "name") values (114, 'T4 California');
insert into "model" ("brand", "name") values (114, 'T4 Caravelle');
insert into "model" ("brand", "name") values (114, 'T4 Multivan');
insert into "model" ("brand", "name") values (114, 'T4 Kombi');
insert into "model" ("brand", "name") values (114, 'T5 California');
insert into "model" ("brand", "name") values (114, 'T5 Caravelle');
insert into "model" ("brand", "name") values (114, 'T5 Multivan');
insert into "model" ("brand", "name") values (114, 'T5 Shuttle');
insert into "model" ("brand", "name") values (114, 'T5 Transporter');
insert into "model" ("brand", "name") values (114, 'T5 Kombi');
insert into "model" ("brand", "name") values (114, 'T6 California');
insert into "model" ("brand", "name") values (114, 'T6 Caravelle');
insert into "model" ("brand", "name") values (114, 'T6 Kombi');
insert into "model" ("brand", "name") values (114, 'T6 Multivan');
insert into "model" ("brand", "name") values (114, 'T6 Transporter');
insert into "model" ("brand", "name") values (114, 'Taro');
insert into "model" ("brand", "name") values (114, 'Tiguan');
insert into "model" ("brand", "name") values (114, 'Tiguan Allspace');
insert into "model" ("brand", "name") values (114, 'Touareg');
insert into "model" ("brand", "name") values (114, 'Touran');
insert into "model" ("brand", "name") values (114, 'Vento');
insert into "model" ("brand", "name") values (114, 'XL1');
insert into "model" ("brand", "name") values (114, 'up!');
insert into "model" ("brand", "name") values (114, 'T4 other');
insert into "model" ("brand", "name") values (114, 'T3 other');
insert into "model" ("brand", "name") values (114, 'Other');
insert into "model" ("brand", "name") values (114, 'T6 other');
insert into "model" ("brand", "name") values (114, 'T5 other');
insert into "make" ("id", "name") values (115, 'Wartburg');
insert into "model" ("brand", "name") values (115, '311');
insert into "model" ("brand", "name") values (115, '353');
insert into "model" ("brand", "name") values (115, 'Other');
insert into "make" ("id", "name") values (116, 'Westfield');
insert into "model" ("brand", "name") values (116, 'Other');
insert into "make" ("id", "name") values (117, 'Wiesmann');
insert into "model" ("brand", "name") values (117, 'MF 25');
insert into "model" ("brand", "name") values (117, 'MF 28');
insert into "model" ("brand", "name") values (117, 'MF 3');
insert into "model" ("brand", "name") values (117, 'MF 30');
insert into "model" ("brand", "name") values (117, 'MF 35');
insert into "model" ("brand", "name") values (117, 'MF 4');
insert into "model" ("brand", "name") values (117, 'MF 5');
insert into "model" ("brand", "name") values (117, 'Other');
insert into "make" ("id", "name") values (118, 'Other');
insert into "model" ("brand", "name") values (118, 'Other');

makes-and-models.ts

import fetch from 'node-fetch';
import escape from 'pg-escape';
import { toJson } from 'xml2json';

/**
 * Uses the mobile.de API to fetch makes and models
 * and returns them to stdout.
 * 
 * @see https://services.mobile.de/manual/reference-data.html
 */
async function main(tableNames: {
    make: string;
    model: string;
} = {
    make: '"make"',
    model: '"model"'
}) {
    const makes = await getMakes();
    console.log(`Found ${makes.length} makes.`);

    let sql = ``;

    for (const { key, label } of makes) {
        const index = makes.findIndex(m => m.key === key);
        const makeId = index + 1;
        sql += getInsertStatement(tableNames.make, {
            id: makeId,
            name: label
        });
        sql += '\n';
        const models = await getModels(key);
        console.log(`--> (${index} / ${makes.length}) Found ${models.length} models for ${label}`);
        for (const { label : modelName } of models) {
            sql += getInsertStatement(tableNames.model, {
                brand: makeId,
                name: modelName
            });
            sql += '\n';
        }
    }

    process.stdout.write(sql);
}

function getInsertStatement(table: string, payload: { [field: string]: string | number }) {
    const numericField = [];
    const stringField = [];
    const numericValues = [];
    const stringValues = [];
    
    for (const [field, value] of Object.entries(payload)) {
        if (typeof value === 'number') {
            numericField.push(field);
            numericValues.push(value)
        } else {
            stringField.push(field);
            stringValues.push(value);
        }
    }
    
    const fields = [
        ...numericField,
        ...stringField
    ].map(f => `"${f}"`).join(', ');

    const valuePlaceholders = numericValues.map(_ => '%L').join(', ');
    const tmp = `insert into ${table} (${fields}) values (${numericValues.join(', ')}, ${valuePlaceholders});`;
    const stm = escape(tmp, ...stringValues);
    return stm;
}

async function getMakes(): Promise<{
    key: string;
    label: string;
}[]> {
    const url = 'https://services.mobile.de/refdata/sites/GERMANY/classes/Car/makes';
    const response = await fetch(url);
    const xml = await response.buffer();
    const json = JSON.parse(toJson(xml, {
        trim: true
    }));
    // @ts-ignore
    const makes = json['reference:reference']['reference:item'].map(item => {
        return {
            key: item.key,
            label: item['resource:local-description']['$t']
        }
    })
    return makes;
}

async function getModels(make: string): Promise<{
    key: string;
    label: string;
}[]> {
    const url = `https://services.mobile.de/refdata/sites/GERMANY/classes/Car/makes/${make}/models`;
    const response = await fetch(url);
    const xml = await response.buffer();
    const json = JSON.parse(toJson(xml, {
        trim: true,
        arrayNotation: true
    }));
    try {
        // @ts-ignore
        const models = json['reference:reference'][0]['reference:item'].map(item => {
            return {
                key: item.key,
                label: item['resource:local-description'][0]['$t']
            }
        })
        return models;
    } catch {
        console.log(JSON.stringify(json, undefined, 2))
        return []
    }
}

main();