INSERT INTO address.canton VALUES (10,E'Remich',E'Réimech');
INSERT INTO address.canton VALUES (11,E'Clervaux',E'Klierf');
INSERT INTO address.canton VALUES (7,E'Esch-sur-Alzette',E'Esch-Uelzecht');
INSERT INTO address.canton VALUES (8,E'Grevenmacher',E'Gréiwemaacher');
INSERT INTO address.canton VALUES (4,E'Redange',E'Réiden');
INSERT INTO address.canton VALUES (1,E'Capellen',E'Kapellen');
INSERT INTO address.canton VALUES (3,E'Echternach',E'Iechternach');
INSERT INTO address.canton VALUES (2,E'Diekirch',E'Dikrech');
INSERT INTO address.canton VALUES (9,E'Wiltz',E'Wolz');
INSERT INTO address.canton VALUES (6,E'Luxembourg',E'Lëtzebuerg');
INSERT INTO address.canton VALUES (12,E'Vianden',E'Veianen');
INSERT INTO address.canton VALUES (5,E'Mersch',E'Miersch');

SELECT setval(E'address.canton_id_seq', (select id from address.canton order by id desc limit 1));

INSERT INTO address.municipality VALUES (1,2,E'Reisdorf',E'Reisduerf');
INSERT INTO address.municipality VALUES (2,8,E'Flaxweiler',E'Fluessweller');
INSERT INTO address.municipality VALUES (3,6,E'Bertrange',E'Bartreng');
INSERT INTO address.municipality VALUES (4,9,E'Goesdorf',E'Géisdref');
INSERT INTO address.municipality VALUES (5,1,E'Garnich',E'Garnech');
INSERT INTO address.municipality VALUES (6,4,E'Redange',E'Réiden');
INSERT INTO address.municipality VALUES (7,9,E'Lac de la Haute-Sûre',E'Stauséigemeng');
INSERT INTO address.municipality VALUES (8,7,E'Dudelange',E'Diddeleng');
INSERT INTO address.municipality VALUES (9,4,E'Rambrouch',E'Rammerech');
INSERT INTO address.municipality VALUES (10,5,E'Tuntange',E'Tënten');
INSERT INTO address.municipality VALUES (11,10,E'Mondorf-les-Bains',E'Munneref');
INSERT INTO address.municipality VALUES (12,8,E'Betzdorf',E'Betzder');
INSERT INTO address.municipality VALUES (13,3,E'Waldbillig',E'Waldbëlleg');
INSERT INTO address.municipality VALUES (14,2,E'Mertzig',E'Mäerzeg');
INSERT INTO address.municipality VALUES (15,11,E'Consthum',E'Konstem');
INSERT INTO address.municipality VALUES (16,7,E'Esch-sur-Alzette',E'Esch-Uelzecht');
INSERT INTO address.municipality VALUES (17,3,E'Berdorf',E'Baërdref');
INSERT INTO address.municipality VALUES (18,1,E'Mamer',E'Mamer');
INSERT INTO address.municipality VALUES (19,1,E'Bascharage',E'Nidderkäerjeng');
INSERT INTO address.municipality VALUES (20,9,E'Neunhausen',E'Néngsen');
INSERT INTO address.municipality VALUES (21,10,E'Waldbredimus',E'Waldbriedemes');
INSERT INTO address.municipality VALUES (22,8,E'Manternach',E'Manternach');
INSERT INTO address.municipality VALUES (23,2,E'Erpeldange',E'Ierpeldeng');
INSERT INTO address.municipality VALUES (24,7,E'Reckange-sur-Mess',E'Reckeng op der Mess');
INSERT INTO address.municipality VALUES (25,10,E'Dalheim',E'Duelem');
INSERT INTO address.municipality VALUES (26,3,E'Rosport',E'Rouspert');
INSERT INTO address.municipality VALUES (27,2,E'Hoscheid',E'Houschent');
INSERT INTO address.municipality VALUES (28,10,E'Bous',E'Bus');
INSERT INTO address.municipality VALUES (29,8,E'Biwer',E'Biwer');
INSERT INTO address.municipality VALUES (30,2,E'Bourscheid',E'Buerschent');
INSERT INTO address.municipality VALUES (31,8,E'Wormeldange',E'Wuermeldeng (Wuermer)');
INSERT INTO address.municipality VALUES (32,1,E'Hobscheid',E'Habscht');
INSERT INTO address.municipality VALUES (33,1,E'Dippach',E'Dippech');
INSERT INTO address.municipality VALUES (34,4,E'Wahl',E'Wal');
INSERT INTO address.municipality VALUES (35,5,E'Colmar-Berg',E'Kolmer-Bierg');
INSERT INTO address.municipality VALUES (36,6,E'Sandweiler',E'Sandweiler');
INSERT INTO address.municipality VALUES (37,4,E'Useldange',E'Useldeng');
INSERT INTO address.municipality VALUES (38,4,E'Grosbous',E'Groussbus');
INSERT INTO address.municipality VALUES (39,4,E'Saeul',E'Sëll');
INSERT INTO address.municipality VALUES (40,1,E'Kopstal',E'Koplescht');
INSERT INTO address.municipality VALUES (41,5,E'Fischbach',E'Fëschbech');
INSERT INTO address.municipality VALUES (42,3,E'Beaufort',E'Beefort');
INSERT INTO address.municipality VALUES (43,9,E'Esch-sur-Sûre',E'Esch-Sauer (Esch am Lach)');
INSERT INTO address.municipality VALUES (44,10,E'Wellenstein',E'Wellesteen');
INSERT INTO address.municipality VALUES (45,9,E'Eschweiler',E'Eschweiler');
INSERT INTO address.municipality VALUES (47,7,E'Schifflange',E'Schëffleng');
INSERT INTO address.municipality VALUES (48,7,E'Leudelange',E'Leideleng');
INSERT INTO address.municipality VALUES (49,7,E'Kayl',E'Keel');
INSERT INTO address.municipality VALUES (50,5,E'Boevange-sur-Attert',E'Béiwen-Atert');
INSERT INTO address.municipality VALUES (51,2,E'Feulen',E'Feelen');
INSERT INTO address.municipality VALUES (52,3,E'Echternach',E'Iechternach');
INSERT INTO address.municipality VALUES (53,5,E'Larochette',E'Fiels (An der)');
INSERT INTO address.municipality VALUES (54,2,E'Diekirch',E'Dikrech');
INSERT INTO address.municipality VALUES (55,6,E'Walferdange',E'Walfer');
INSERT INTO address.municipality VALUES (56,2,E'Ermsdorf',E'Iermsdref');
INSERT INTO address.municipality VALUES (57,5,E'Lintgen',E'Lëntgen');
INSERT INTO address.municipality VALUES (58,3,E'Consdorf',E'Konsdref');
INSERT INTO address.municipality VALUES (59,11,E'Weiswampach',E'Wäisswampech');
INSERT INTO address.municipality VALUES (60,3,E'Mompach',E'Mompech');
INSERT INTO address.municipality VALUES (61,7,E'Sanem',E'Suessem');
INSERT INTO address.municipality VALUES (62,4,E'Ell',E'Ell');
INSERT INTO address.municipality VALUES (63,11,E'Munshausen',E'Munzen');
INSERT INTO address.municipality VALUES (64,7,E'Mondercange',E'Monnerech');
INSERT INTO address.municipality VALUES (65,4,E'Vichten',E'Viichten');
INSERT INTO address.municipality VALUES (66,6,E'Weiler-la-Tour',E'Weiler-la-Tour');
INSERT INTO address.municipality VALUES (67,7,E'Pétange',E'Péiteng');
INSERT INTO address.municipality VALUES (68,1,E'Clemency',E'Kënzeg');
INSERT INTO address.municipality VALUES (69,9,E'Winseler',E'Wanseler');
INSERT INTO address.municipality VALUES (70,10,E'Schengen',E'Schengen');
INSERT INTO address.municipality VALUES (71,7,E'Bettembourg',E'Beetebuerg');
INSERT INTO address.municipality VALUES (72,1,E'Kehlen',E'Kielen');
INSERT INTO address.municipality VALUES (73,6,E'Steinsel',E'Steesel');
INSERT INTO address.municipality VALUES (74,6,E'Schuttrange',E'Schëtter');
INSERT INTO address.municipality VALUES (75,6,E'Contern',E'Konter');
INSERT INTO address.municipality VALUES (76,7,E'Frisange',E'Fréiseng');
INSERT INTO address.municipality VALUES (77,6,E'Niederanven',E'Nidderaanwen');
INSERT INTO address.municipality VALUES (78,6,E'Luxembourg',E'Lëtzebuerg');
INSERT INTO address.municipality VALUES (79,12,E'Vianden',E'Veianen');
INSERT INTO address.municipality VALUES (80,9,E'Kiischpelt',E'Kiischpelt');
INSERT INTO address.municipality VALUES (81,8,E'Junglinster',E'Jonglënster');
INSERT INTO address.municipality VALUES (82,11,E'Heinerscheid',E'Hengescht');
INSERT INTO address.municipality VALUES (83,10,E'Remich',E'Réimech');
INSERT INTO address.municipality VALUES (84,5,E'Nommern',E'Noumer');
INSERT INTO address.municipality VALUES (85,12,E'Tandel',E'Tandel');
INSERT INTO address.municipality VALUES (86,2,E'Medernach',E'Miedernach');
INSERT INTO address.municipality VALUES (88,11,E'Wincrange',E'Wëntger');
INSERT INTO address.municipality VALUES (89,5,E'Heffingen',E'Hiefenech');
INSERT INTO address.municipality VALUES (90,11,E'Troisvierges',E'Ëlwen');
INSERT INTO address.municipality VALUES (91,7,E'Differdange',E'Déifferdeng');
INSERT INTO address.municipality VALUES (92,7,E'Roeser',E'Réiser');
INSERT INTO address.municipality VALUES (93,10,E'Burmerange',E'Biermereng');
INSERT INTO address.municipality VALUES (94,6,E'Hesperange',E'Hesper');
INSERT INTO address.municipality VALUES (95,1,E'Septfontaines',E'Simmer');
INSERT INTO address.municipality VALUES (96,1,E'Steinfort',E'Stengefort');
INSERT INTO address.municipality VALUES (97,4,E'Beckerich',E'Biekerech');
INSERT INTO address.municipality VALUES (98,5,E'Bissen',E'Biissen');
INSERT INTO address.municipality VALUES (99,8,E'Grevenmacher',E'Gréiwemaacher');
INSERT INTO address.municipality VALUES (100,9,E'Heiderscheid',E'Heischent');
INSERT INTO address.municipality VALUES (101,2,E'Bettendorf',E'Bettenduerf');
INSERT INTO address.municipality VALUES (102,6,E'Strassen',E'Stroossen');
INSERT INTO address.municipality VALUES (103,9,E'Wiltz',E'Wolz');
INSERT INTO address.municipality VALUES (104,4,E'Préizerdaul',E'Préizerdaul');
INSERT INTO address.municipality VALUES (105,3,E'Bech',E'Bech');
INSERT INTO address.municipality VALUES (106,8,E'Mertert',E'Mäertert');
INSERT INTO address.municipality VALUES (107,2,E'Schieren',E'Schieren');
INSERT INTO address.municipality VALUES (108,12,E'Putscheid',E'Pëtschent');
INSERT INTO address.municipality VALUES (109,11,E'Hosingen',E'Housen');
INSERT INTO address.municipality VALUES (110,5,E'Mersch',E'Miersch');
INSERT INTO address.municipality VALUES (111,2,E'Ettelbrück',E'Ettelbréck');
INSERT INTO address.municipality VALUES (112,10,E'Lenningen',E'Lenneng');
INSERT INTO address.municipality VALUES (113,11,E'Clervaux',E'Klierf');
INSERT INTO address.municipality VALUES (114,7,E'Rumelange',E'Rëmeleng');
INSERT INTO address.municipality VALUES (115,9,E'Boulaide',E'Bauschelt');
INSERT INTO address.municipality VALUES (116,5,E'Lorentzweiler',E'Luerenzweiler');
INSERT INTO address.municipality VALUES (117,10,E'Stadtbredimus',E'Stadbriedemes');
INSERT INTO address.municipality VALUES (118,1,E'Koerich',E'Käerch');

SELECT setval(E'address.municipality_id_seq', (select id from address.municipality order by id desc limit 1));


INSERT INTO address.locality VALUES (1,71,E'Abweiler',E'Obeler');
INSERT INTO address.locality VALUES (2,31,E'Ahn',E'On');
INSERT INTO address.locality VALUES (3,88,E'Allerborn',E'Allerbur');
INSERT INTO address.locality VALUES (4,80,E'Alscheid',E'Alschent');
INSERT INTO address.locality VALUES (5,81,E'Altlinster',E'Allënster');
INSERT INTO address.locality VALUES (6,105,E'Altrier',E'Altréier (Op der Schanz)');
INSERT INTO address.locality VALUES (7,11,E'Altwies',E'Altwis');
INSERT INTO address.locality VALUES (8,94,E'Alzingen',E'Alzeng');
INSERT INTO address.locality VALUES (9,41,E'Angelsberg',E'Aangelsbierg');
INSERT INTO address.locality VALUES (10,10,E'Ansembourg',E'Aansebuerg');
INSERT INTO address.locality VALUES (11,9,E'Arsdorf',E'Uerschdref');
INSERT INTO address.locality VALUES (12,76,E'Aspelt',E'Uespelt');
INSERT INTO address.locality VALUES (13,28,E'Assel',E'Aassel');
INSERT INTO address.locality VALUES (14,88,E'Asselborn',E'Aasselbur');
INSERT INTO address.locality VALUES (15,116,E'Asselscheuer',E'Aasselscheier');
INSERT INTO address.locality VALUES (16,90,E'Basbellain',E'Kierchen');
INSERT INTO address.locality VALUES (17,19,E'Bascharage',E'Nidderkäerjeng');
INSERT INTO address.locality VALUES (18,115,E'Baschleiden',E'Baschelt');
INSERT INTO address.locality VALUES (19,85,E'Bastendorf',E'Baastenduerf');
INSERT INTO address.locality VALUES (20,7,E'Bavigne',E'Béiwen');
INSERT INTO address.locality VALUES (21,42,E'Beaufort',E'Beefort');
INSERT INTO address.locality VALUES (22,105,E'Bech',E'Bech');
INSERT INTO address.locality VALUES (23,44,E'Bech-Kleinmacher',E'Bech-Maacher');
INSERT INTO address.locality VALUES (24,97,E'Beckerich',E'Biekerech');
INSERT INTO address.locality VALUES (25,81,E'Beidweiler',E'Beidler');
INSERT INTO address.locality VALUES (26,59,E'Beiler',E'Beeler');
INSERT INTO address.locality VALUES (27,61,E'Belvaux',E'Bieles');
INSERT INTO address.locality VALUES (28,22,E'Berbourg',E'Berbuerg');
INSERT INTO address.locality VALUES (29,92,E'Berchem',E'Bierchem');
INSERT INTO address.locality VALUES (30,17,E'Berdorf',E'Baërdref');
INSERT INTO address.locality VALUES (31,55,E'Bereldange',E'Bäreldeng');
INSERT INTO address.locality VALUES (32,12,E'Berg',E'Bierg');
INSERT INTO address.locality VALUES (33,35,E'Berg',E'Bierg');
INSERT INTO address.locality VALUES (34,64,E'Bergem',E'Biergem');
INSERT INTO address.locality VALUES (35,110,E'Beringen',E'Biereng');
INSERT INTO address.locality VALUES (36,69,E'Berlé',E'Bärel');
INSERT INTO address.locality VALUES (37,110,E'Berschbach',E'Bierschbech');
INSERT INTO address.locality VALUES (38,3,E'Bertrange',E'Bartreng');
INSERT INTO address.locality VALUES (39,33,E'Bettange-sur-Mess',E'Betten op der Mess');
INSERT INTO address.locality VALUES (40,104,E'Bettborn',E'Bieberech');
INSERT INTO address.locality VALUES (41,85,E'Bettel',E'Bëttel');
INSERT INTO address.locality VALUES (42,71,E'Bettembourg',E'Beetebuerg');
INSERT INTO address.locality VALUES (43,101,E'Bettendorf',E'Bettenduerf');
INSERT INTO address.locality VALUES (44,12,E'Betzdorf',E'Betzder');
INSERT INTO address.locality VALUES (45,2,E'Beyren',E'Beyeren');
INSERT INTO address.locality VALUES (46,1,E'Bigelbach',E'Bigelbaach');
INSERT INTO address.locality VALUES (47,9,E'Bigonville',E'Bungeref');
INSERT INTO address.locality VALUES (48,50,E'Bill',E'Bill');
INSERT INTO address.locality VALUES (49,9,E'Bilsdorf',E'Bëlschdref');
INSERT INTO address.locality VALUES (50,59,E'Binsfeld',E'Bënzelt');
INSERT INTO address.locality VALUES (51,110,E'Binzrath',E'Bënzelt');
INSERT INTO address.locality VALUES (52,107,E'Birtrange',E'Biertreng');
INSERT INTO address.locality VALUES (53,98,E'Bissen',E'Biissen');
INSERT INTO address.locality VALUES (54,92,E'Bivange',E'Béiweng');
INSERT INTO address.locality VALUES (55,108,E'Bivels',E'Biwels');
INSERT INTO address.locality VALUES (56,29,E'Biwer',E'Biwer');
INSERT INTO address.locality VALUES (57,90,E'Biwisch',E'Biwwesch');
INSERT INTO address.locality VALUES (58,116,E'Blaschette',E'Blaaschent');
INSERT INTO address.locality VALUES (59,101,E'Bleesbrück',E'Bleesbréck');
INSERT INTO address.locality VALUES (60,105,E'Blumenthal',E'Blummendall');
INSERT INTO address.locality VALUES (61,109,E'Bockholtz',E'Buckels');
INSERT INTO address.locality VALUES (62,4,E'Bockholtz',E'Boukels');
INSERT INTO address.locality VALUES (63,113,E'Boevange',E'Béigen');
INSERT INTO address.locality VALUES (64,50,E'Boevange-sur-Attert',E'Béiwen-Atert');
INSERT INTO address.locality VALUES (65,116,E'Bofferdange',E'Boufer (-deng)');
INSERT INTO address.locality VALUES (66,17,E'Bollendorf-Pont',E'Bollendorferbréck');
INSERT INTO address.locality VALUES (67,20,E'Bonnal',E'Bonnal');
INSERT INTO address.locality VALUES (68,60,E'Born',E'Bur');
INSERT INTO address.locality VALUES (69,29,E'Boudler',E'Buddeler');
INSERT INTO address.locality VALUES (70,29,E'Boudlerbach',E'Buddelerbaach');
INSERT INTO address.locality VALUES (71,115,E'Boulaide',E'Bauschelt');
INSERT INTO address.locality VALUES (72,10,E'Bour',E'Bur');
INSERT INTO address.locality VALUES (73,81,E'Bourglinster',E'Buerglënster');
INSERT INTO address.locality VALUES (74,30,E'Bourscheid',E'Buerschent');
INSERT INTO address.locality VALUES (75,60,E'Boursdorf',E'Buerschdref');
INSERT INTO address.locality VALUES (76,28,E'Bous',E'Bus');
INSERT INTO address.locality VALUES (77,88,E'Boxhorn',E'Boxer');
INSERT INTO address.locality VALUES (78,88,E'Brachtenbach',E'Bruechtebaach');
INSERT INTO address.locality VALUES (79,85,E'Brandenbourg',E'Branebuerg');
INSERT INTO address.locality VALUES (80,34,E'Brattert',E'Brattert');
INSERT INTO address.locality VALUES (81,59,E'Breidfeld',E'Breedelt');
INSERT INTO address.locality VALUES (82,58,E'Breidweiler',E'Präiteler');
INSERT INTO address.locality VALUES (83,29,E'Breinert',E'Breinert');
INSERT INTO address.locality VALUES (84,40,E'Bridel',E'Briddel');
INSERT INTO address.locality VALUES (85,101,E'Broderbour',E'Broderbur');
INSERT INTO address.locality VALUES (86,29,E'Brouch',E'Bruch');
INSERT INTO address.locality VALUES (87,50,E'Brouch',E'Bruch');
INSERT INTO address.locality VALUES (88,2,E'Buchholz',E'Buchhotz');
INSERT INTO address.locality VALUES (89,4,E'Buederscheid',E'Bitscht');
INSERT INTO address.locality VALUES (90,23,E'Bürden',E'Bierden');
INSERT INTO address.locality VALUES (91,93,E'Burmerange',E'Biermereng');
INSERT INTO address.locality VALUES (92,50,E'Buschdorf',E'Bëschdref');
INSERT INTO address.locality VALUES (93,34,E'Buschrodt',E'Bëschrued');
INSERT INTO address.locality VALUES (94,39,E'Calmus',E'Kaalmes');
INSERT INTO address.locality VALUES (95,112,E'Canach',E'Kanech');
INSERT INTO address.locality VALUES (96,18,E'Capellen',E'Kapellen');
INSERT INTO address.locality VALUES (97,13,E'Christnach',E'Chrëschtnech');
INSERT INTO address.locality VALUES (98,88,E'Cinqfontaines',E'Pafemillen');
INSERT INTO address.locality VALUES (99,68,E'Clemency',E'Kënzeg');
INSERT INTO address.locality VALUES (100,113,E'Clervaux',E'Klierf');
INSERT INTO address.locality VALUES (101,58,E'Colbette',E'Kolwent');
INSERT INTO address.locality VALUES (102,35,E'Colmar-Berg',E'Kolmar-Bierg');
INSERT INTO address.locality VALUES (103,62,E'Colpach-bas',E'Nidderkolpech');
INSERT INTO address.locality VALUES (104,62,E'Colpach-haut',E'Uewerkolpech');
INSERT INTO address.locality VALUES (105,58,E'Consdorf',E'Konsdref');
INSERT INTO address.locality VALUES (106,15,E'Consthum',E'Konstem');
INSERT INTO address.locality VALUES (107,75,E'Contern',E'Konter');
INSERT INTO address.locality VALUES (108,92,E'Crauthem',E'Krautem');
INSERT INTO address.locality VALUES (109,88,E'Crendal',E'Kréindel');
INSERT INTO address.locality VALUES (110,84,E'Cruchten',E'Kruuchten');
INSERT INTO address.locality VALUES (111,4,E'Dahl',E'Dol');
INSERT INTO address.locality VALUES (112,5,E'Dahlem',E'Duelem');
INSERT INTO address.locality VALUES (113,25,E'Dalheim',E'Duelem');
INSERT INTO address.locality VALUES (114,109,E'Dasbourg-pont',E'Doosber-Bréck');
INSERT INTO address.locality VALUES (115,88,E'Deiffelt',E'Deewelt');
INSERT INTO address.locality VALUES (116,38,E'Dellen',E'Dellen');
INSERT INTO address.locality VALUES (117,88,E'Derenbach',E'Déierbech');
INSERT INTO address.locality VALUES (118,26,E'Dickweiler',E'Dickweiler');
INSERT INTO address.locality VALUES (119,54,E'Diekirch',E'Dikrech');
INSERT INTO address.locality VALUES (120,54,E'Diekirch-centre',E'Dikrech-zentrum');
INSERT INTO address.locality VALUES (121,91,E'Differdange',E'Déifferdeng');
INSERT INTO address.locality VALUES (122,91,E'Differdange - Niederkorn',E'Nidderkuer');
INSERT INTO address.locality VALUES (123,91,E'Differdange - Oberkorn',E'Uewerkuer');
INSERT INTO address.locality VALUES (124,42,E'Dillingen',E'Déiljen');
INSERT INTO address.locality VALUES (125,33,E'Dippach',E'Dippech');
INSERT INTO address.locality VALUES (126,33,E'Dippach-Gare',E'Dippecher-Gare');
INSERT INTO address.locality VALUES (127,100,E'Dirbach',E'Dierbech');
INSERT INTO address.locality VALUES (128,88,E'Doennange',E'Diänjen');
INSERT INTO address.locality VALUES (129,69,E'Doncols',E'Donkels');
INSERT INTO address.locality VALUES (130,72,E'Dondelange',E'Dondel');
INSERT INTO address.locality VALUES (131,109,E'Dorscheid',E'Duerscht');
INSERT INTO address.locality VALUES (132,63,E'Drauffelt',E'Draufelt');
INSERT INTO address.locality VALUES (133,31,E'Dreiborn',E'Dräibur');
INSERT INTO address.locality VALUES (134,90,E'Drinklange',E'Drénkelt');
INSERT INTO address.locality VALUES (135,8,E'Dudelange',E'Diddeleng');
INSERT INTO address.locality VALUES (136,8,E'Dudelange-Burange',E'Diddeleng-Biréng');
INSERT INTO address.locality VALUES (137,7,E'Dunkroth',E'Dénkert');
INSERT INTO address.locality VALUES (138,52,E'Echternach',E'Iechternach');
INSERT INTO address.locality VALUES (139,24,E'Ehlange',E'Éileng');
INSERT INTO address.locality VALUES (140,61,E'Ehlerange',E'Éilereng');
INSERT INTO address.locality VALUES (141,31,E'Ehnen',E'Éinen');
INSERT INTO address.locality VALUES (142,39,E'Ehner',E'Éiner');
INSERT INTO address.locality VALUES (143,32,E'Eischen',E'Äischen');
INSERT INTO address.locality VALUES (144,81,E'Eisenborn',E'Eesebur');
INSERT INTO address.locality VALUES (145,62,E'Ell',E'Ell');
INSERT INTO address.locality VALUES (146,11,E'Ellange',E'Elleng');
INSERT INTO address.locality VALUES (147,6,E'Eltz',E'Elz');
INSERT INTO address.locality VALUES (148,93,E'Elvange',E'Elveng');
INSERT INTO address.locality VALUES (149,97,E'Elvange',E'Ielweng');
INSERT INTO address.locality VALUES (150,93,E'Emerange',E'Éimereng');
INSERT INTO address.locality VALUES (151,80,E'Enscherange',E'Äischer');
INSERT INTO address.locality VALUES (152,56,E'Eppeldorf',E'Eppelduerf');
INSERT INTO address.locality VALUES (153,56,E'Ermsdorf',E'Iermsdref');
INSERT INTO address.locality VALUES (154,77,E'Ernster',E'Iernster');
INSERT INTO address.locality VALUES (155,53,E'Ernzen',E'Ierzen');
INSERT INTO address.locality VALUES (156,28,E'Erpeldange',E'Ierpeldeng');
INSERT INTO address.locality VALUES (157,45,E'Erpeldange',E'Ierpeldang');
INSERT INTO address.locality VALUES (158,23,E'Erpeldange',E'Ierpeldeng');
INSERT INTO address.locality VALUES (159,21,E'Ersange',E'Ierseng (-en)');
INSERT INTO address.locality VALUES (160,16,E'Esch-sur-Alzette',E'Esch-Uelzecht');
INSERT INTO address.locality VALUES (161,43,E'Esch-sur-Sûre',E'Esch-Sauer (Esch am Lach)');
INSERT INTO address.locality VALUES (162,100,E'Eschdorf',E'Eschduerf');
INSERT INTO address.locality VALUES (163,9,E'Eschette',E'Eschent');
INSERT INTO address.locality VALUES (164,81,E'Eschweiler',E'Eeschweller');
INSERT INTO address.locality VALUES (165,45,E'Eschweiler',E'Eschweiler');
INSERT INTO address.locality VALUES (166,113,E'Eselborn',E'Eeselbur');
INSERT INTO address.locality VALUES (167,110,E'Essingen',E'Essen');
INSERT INTO address.locality VALUES (168,111,E'Ettelbrück',E'Ettelbréck');
INSERT INTO address.locality VALUES (169,37,E'Everlange',E'Ierwerleng');
INSERT INTO address.locality VALUES (170,71,E'Fennange',E'Fenneng');
INSERT INTO address.locality VALUES (171,94,E'Fentange',E'Fenteng');
INSERT INTO address.locality VALUES (172,25,E'Filsdorf',E'Fëlschdref');
INSERT INTO address.locality VALUES (173,36,E'Findel',E'Findel');
INSERT INTO address.locality VALUES (174,68,E'Fingig',E'Féngeg');
INSERT INTO address.locality VALUES (175,50,E'Finsterthal',E'Fënsterdall');
INSERT INTO address.locality VALUES (176,41,E'Fischbach',E'Fëschbech');
INSERT INTO address.locality VALUES (177,82,E'Fischbach',E'Fëschbech');
INSERT INTO address.locality VALUES (178,9,E'Flatzbour',E'Flatzbur');
INSERT INTO address.locality VALUES (179,2,E'Flaxweiler',E'Fluessweller');
INSERT INTO address.locality VALUES (180,64,E'Foetz',E'Féiz');
INSERT INTO address.locality VALUES (181,56,E'Folkendange',E'Folkendeng');
INSERT INTO address.locality VALUES (182,9,E'Folschette',E'Folscht');
INSERT INTO address.locality VALUES (183,85,E'Fouhren',E'Furen');
INSERT INTO address.locality VALUES (184,13,E'Freckeisen',E'Freckeisen');
INSERT INTO address.locality VALUES (185,76,E'Frisange',E'Fréiseng');
INSERT INTO address.locality VALUES (186,32,E'Gaichel',E'Gäichel');
INSERT INTO address.locality VALUES (187,5,E'Garnich',E'Garnech');
INSERT INTO address.locality VALUES (188,105,E'Geyershof',E'Geieschaff');
INSERT INTO address.locality VALUES (189,101,E'Gilsdorf',E'Gilsdref');
INSERT INTO address.locality VALUES (190,26,E'Girst',E'Giischt');
INSERT INTO address.locality VALUES (191,26,E'Girsterklaus',E'Giischterklaus');
INSERT INTO address.locality VALUES (192,60,E'Givenich',E'Giwenech');
INSERT INTO address.locality VALUES (193,81,E'Godbrange',E'Guedber');
INSERT INTO address.locality VALUES (194,30,E'Goebelsmuehle',E'Giebelsmillen');
INSERT INTO address.locality VALUES (195,118,E'Goeblange',E'Giewel');
INSERT INTO address.locality VALUES (196,90,E'Goedange',E'Géidgen');
INSERT INTO address.locality VALUES (197,4,E'Goesdorf',E'Géisdref');
INSERT INTO address.locality VALUES (198,118,E'Goetzingen',E'Gëtzen');
INSERT INTO address.locality VALUES (199,81,E'Gonderange',E'Gonnereng');
INSERT INTO address.locality VALUES (200,57,E'Gosseldange',E'Gousseldeng');
INSERT INTO address.locality VALUES (201,2,E'Gostingen',E'Gouschteng');
INSERT INTO address.locality VALUES (202,108,E'Gralingen',E'Grooljen');
INSERT INTO address.locality VALUES (203,96,E'Grass',E'Grass');
INSERT INTO address.locality VALUES (204,81,E'Graulinster',E'Grolënster');
INSERT INTO address.locality VALUES (205,95,E'Greisch',E'Gräisch');
INSERT INTO address.locality VALUES (206,117,E'Greiveldange',E'Greiweldeng');
INSERT INTO address.locality VALUES (207,111,E'Grentzingen',E'Grentzen');
INSERT INTO address.locality VALUES (208,34,E'Grevels',E'Gréiwels');
INSERT INTO address.locality VALUES (209,50,E'Grevenknapp',E'Gréiweknapp');
INSERT INTO address.locality VALUES (210,99,E'Grevenmacher',E'Gréiwemaacher');
INSERT INTO address.locality VALUES (211,82,E'Grindhausen',E'Grandsen');
INSERT INTO address.locality VALUES (212,38,E'Grosbous',E'Groussbus');
INSERT INTO address.locality VALUES (213,69,E'Grümmelscheid',E'Grëmmelescht');
INSERT INTO address.locality VALUES (214,17,E'Grundhof',E'Grondhaff');
INSERT INTO address.locality VALUES (215,88,E'Hachiville',E'Helzen');
INSERT INTO address.locality VALUES (216,29,E'Hagelsdorf',E'Haastert');
INSERT INTO address.locality VALUES (217,96,E'Hagen',E'Hoen');
INSERT INTO address.locality VALUES (218,13,E'Haller',E'Haler');
INSERT INTO address.locality VALUES (219,88,E'Hamiville',E'Heesdref');
INSERT INTO address.locality VALUES (220,7,E'Harlange',E'Harel');
INSERT INTO address.locality VALUES (221,66,E'Hassel',E'Haassel');
INSERT INTO address.locality VALUES (222,90,E'Hautbellain',E'Beesslek');
INSERT INTO address.locality VALUES (223,19,E'Hautcharage',E'Uewerkäerjeng');
INSERT INTO address.locality VALUES (224,89,E'Heffingen',E'Hiefenech');
INSERT INTO address.locality VALUES (225,100,E'Heiderscheid',E'Heischent');
INSERT INTO address.locality VALUES (226,43,E'Fond-de-Heiderscheid',E'Heischtergronn');
INSERT INTO address.locality VALUES (227,82,E'Heinerscheid',E'Hengescht');
INSERT INTO address.locality VALUES (228,73,E'Heisdorf',E'Heeschdref');
INSERT INTO address.locality VALUES (229,34,E'Heispelt',E'Heeschpelt');
INSERT INTO address.locality VALUES (230,3,E'Helfent',E'Helfent');
INSERT INTO address.locality VALUES (231,3,E'Helfent-les-Bertange',E'Helfenterbréck');
INSERT INTO address.locality VALUES (232,76,E'Hellange',E'Helleng');
INSERT INTO address.locality VALUES (233,116,E'Helmdange',E'Hielem');
INSERT INTO address.locality VALUES (234,55,E'Helmsange',E'Hielsem');
INSERT INTO address.locality VALUES (235,105,E'Hemstal',E'Hemstel');
INSERT INTO address.locality VALUES (236,60,E'Herborn',E'Hierber');
INSERT INTO address.locality VALUES (237,105,E'Hersberg',E'Heeschbrech');
INSERT INTO address.locality VALUES (238,94,E'Hesperange',E'Hesper');
INSERT INTO address.locality VALUES (239,100,E'Hierheck',E'Hierheck');
INSERT INTO address.locality VALUES (240,26,E'Hinkel',E'Hénkel');
INSERT INTO address.locality VALUES (241,88,E'Hinterhassel',E'Hannerhaassel');
INSERT INTO address.locality VALUES (242,5,E'Hivange',E'Héiweng');
INSERT INTO address.locality VALUES (243,32,E'Hobscheid',E'Habscht');
INSERT INTO address.locality VALUES (244,1,E'Hoesdorf',E'Héisdref');
INSERT INTO address.locality VALUES (245,88,E'Hoffelt',E'Houfelt');
INSERT INTO address.locality VALUES (246,10,E'Hollenfels',E'Huelmes');
INSERT INTO address.locality VALUES (247,59,E'Holler',E'Holler');
INSERT INTO address.locality VALUES (248,9,E'Holtz',E'Holz');
INSERT INTO address.locality VALUES (249,18,E'Holzem',E'Holzem');
INSERT INTO address.locality VALUES (250,15,E'Holzthum',E'Holztem');
INSERT INTO address.locality VALUES (251,27,E'Hoscheid',E'Houschent');
INSERT INTO address.locality VALUES (252,27,E'Hoscheid-Dickt',E'Houschter-Déckt');
INSERT INTO address.locality VALUES (253,108,E'Hoscherderhof',E'Houschterhaff');
INSERT INTO address.locality VALUES (254,109,E'Hosingen',E'Housen');
INSERT INTO address.locality VALUES (255,77,E'Hostert',E'Hueschtert');
INSERT INTO address.locality VALUES (256,9,E'Hostert',E'Hueschtert');
INSERT INTO address.locality VALUES (257,97,E'Hovelange',E'Huewel');
INSERT INTO address.locality VALUES (258,94,E'Howald',E'Houwald');
INSERT INTO address.locality VALUES (259,90,E'Huldange',E'Huldang');
INSERT INTO address.locality VALUES (260,71,E'Huncherange',E'Hënchereng');
INSERT INTO address.locality VALUES (261,116,E'Hunsdorf',E'Hënsdref');
INSERT INTO address.locality VALUES (262,82,E'Hupperdange',E'Hëpperdang');
INSERT INTO address.locality VALUES (263,97,E'Huttange',E'Hitten');
INSERT INTO address.locality VALUES (264,117,E'Hüttermühle',E'Hettermillen');
INSERT INTO address.locality VALUES (265,81,E'Imbringen',E'Amber');
INSERT INTO address.locality VALUES (266,23,E'Ingeldorf',E'Angelduerf');
INSERT INTO address.locality VALUES (267,20,E'Insenborn',E'Ënsber');
INSERT INTO address.locality VALUES (268,94,E'Itzig',E'Izeg');
INSERT INTO address.locality VALUES (269,81,E'Junglinster',E'Jonglënster');
INSERT INTO address.locality VALUES (270,82,E'Kaesfurt',E'Kiisfurt');
INSERT INTO address.locality VALUES (271,59,E'Kaesfurt',E'Kiisfurt');
INSERT INTO address.locality VALUES (272,5,E'Kahler',E'Koler');
INSERT INTO address.locality VALUES (273,82,E'Kalborn',E'Kaalber');
INSERT INTO address.locality VALUES (274,58,E'Kalkesbach',E'Kalkesbaach');
INSERT INTO address.locality VALUES (275,31,E'Kapenacker',E'Kapenaker');
INSERT INTO address.locality VALUES (276,39,E'Kapweiler',E'Kapweiler');
INSERT INTO address.locality VALUES (277,7,E'Kaundorf',E'kauneref');
INSERT INTO address.locality VALUES (278,80,E'Kautenbach',E'Kautebaach');
INSERT INTO address.locality VALUES (279,49,E'Kayl',E'Keel');
INSERT INTO address.locality VALUES (280,72,E'Kehlen',E'Kielen');
INSERT INTO address.locality VALUES (281,30,E'Kehmen',E'Kiemen');
INSERT INTO address.locality VALUES (282,72,E'Keispelt',E'Keespelt');
INSERT INTO address.locality VALUES (283,101,E'Keiwelbach',E'Keiwelbach');
INSERT INTO address.locality VALUES (284,56,E'Keiwelbach',E'Keiwelbach');
INSERT INTO address.locality VALUES (285,96,E'Kleinbettingen',E'klengbetten');
INSERT INTO address.locality VALUES (286,45,E'Kleinhoscheid',E'Klenghouschent');
INSERT INTO address.locality VALUES (287,45,E'Knaphoscheid',E'Knapphouschent');
INSERT INTO address.locality VALUES (288,105,E'Kobenbour',E'Kuebebur');
INSERT INTO address.locality VALUES (289,92,E'Kockelscheuer',E'Kockelscheier');
INSERT INTO address.locality VALUES (290,41,E'Koedange',E'Kéideng');
INSERT INTO address.locality VALUES (291,118,E'Koerich',E'Käerch');
INSERT INTO address.locality VALUES (292,9,E'Koetschette',E'Kietscht');
INSERT INTO address.locality VALUES (293,40,E'Kopstal',E'Koplescht');
INSERT INTO address.locality VALUES (294,34,E'Kuborn',E'Kéiber');
INSERT INTO address.locality VALUES (295,67,E'Lamadelaine',E'Rolleng');
INSERT INTO address.locality VALUES (296,85,E'Landscheid',E'Laaschent');
INSERT INTO address.locality VALUES (297,6,E'Lannen',E'Lannen');
INSERT INTO address.locality VALUES (298,53,E'Larochette',E'Fiels (An der)');
INSERT INTO address.locality VALUES (299,91,E'Lasauvage',E'Lasauvage');
INSERT INTO address.locality VALUES (300,17,E'Laufenwehr',E'Laufenwehr');
INSERT INTO address.locality VALUES (301,82,E'Lausdorn',E'Lausduer');
INSERT INTO address.locality VALUES (302,59,E'Lausdorn',E'Lausduer');
INSERT INTO address.locality VALUES (303,52,E'Lauterborn',E'Lauterbur');
INSERT INTO address.locality VALUES (304,38,E'Lehrhof',E'Léierhaff');
INSERT INTO address.locality VALUES (305,59,E'Leithum',E'Leetem');
INSERT INTO address.locality VALUES (306,22,E'Lellig',E'Lelleg');
INSERT INTO address.locality VALUES (307,80,E'Lellingen',E'Lellgen');
INSERT INTO address.locality VALUES (308,112,E'Lenningen',E'Lenneng');
INSERT INTO address.locality VALUES (309,88,E'Lentzweiler',E'Lenzweiler');
INSERT INTO address.locality VALUES (310,48,E'Leudelange',E'Leideleng');
INSERT INTO address.locality VALUES (311,97,E'Levelange',E'Liewel');
INSERT INTO address.locality VALUES (312,7,E'Liefrange',E'Léifreg');
INSERT INTO address.locality VALUES (313,82,E'Lieler',E'Léiler');
INSERT INTO address.locality VALUES (314,60,E'Lilien',E'Liljen');
INSERT INTO address.locality VALUES (315,24,E'Limpach',E'Lampech');
INSERT INTO address.locality VALUES (316,19,E'Linger',E'Lénger');
INSERT INTO address.locality VALUES (317,57,E'Lintgen',E'Lëntgen');
INSERT INTO address.locality VALUES (318,30,E'Lipperscheid',E'Lëppschent');
INSERT INTO address.locality VALUES (319,92,E'Livange',E'Léiweng');
INSERT INTO address.locality VALUES (320,85,E'Longsdorf',E'Longsdref');
INSERT INTO address.locality VALUES (321,116,E'Lorentzweiler',E'Luerenzweiler');
INSERT INTO address.locality VALUES (322,88,E'Lullange',E'Lëllgen');
INSERT INTO address.locality VALUES (323,20,E'Lultzhausen',E'Lëlz');
INSERT INTO address.locality VALUES (324,78,E'Luxembourg',E'Lëtzebuerg');
INSERT INTO address.locality VALUES (325,78,E'Luxembourg - Beggen',E'Lëtzebuerg - Beggen');
INSERT INTO address.locality VALUES (326,78,E'Luxembourg - Belair',E'Lëtzebuerg - Belair');
INSERT INTO address.locality VALUES (327,78,E'Luxembourg - Bonnevoie',E'Lëtzebuerg - Bouneweg');
INSERT INTO address.locality VALUES (328,78,E'Luxembourg - Centre',E'Lëtzebuerg - Zentrum');
INSERT INTO address.locality VALUES (329,78,E'Luxembourg - Cents',E'Lëtzebuerg - Zens');
INSERT INTO address.locality VALUES (330,78,E'Luxembourg - Cessange',E'Lëtzebuerg - Zeisseng');
INSERT INTO address.locality VALUES (331,78,E'Luxembourg - Clausen',E'Lëtzebuerg - Clausen');
INSERT INTO address.locality VALUES (332,78,E'Luxembourg - Dommeldange',E'Lëtzebuerg - Dummeldeng');
INSERT INTO address.locality VALUES (333,78,E'Luxembourg - Eich',E'Lëtzebuerg - Eech');
INSERT INTO address.locality VALUES (334,78,E'Luxembourg - Gare',E'Lëtzebuerg - Gare');
INSERT INTO address.locality VALUES (335,78,E'Luxembourg - Gasperich',E'Lëtzebuerg - Gaasperech');
INSERT INTO address.locality VALUES (336,78,E'Luxembourg - Grund',E'Lëtzebuerg - Gronn (Stadgronn)');
INSERT INTO address.locality VALUES (337,78,E'Luxembourg - Hamm',E'Lëtzebuerg - Hamm');
INSERT INTO address.locality VALUES (338,78,E'Luxembourg - Hollerich',E'Lëtzebuerg - Hollerech');
INSERT INTO address.locality VALUES (339,78,E'Luxembourg - Kirchberg',E'Lëtzebuerg - Kierchbierg');
INSERT INTO address.locality VALUES (340,78,E'Luxembourg - Limpertsberg',E'Lëtzebuerg - Lampertsbierg');
INSERT INTO address.locality VALUES (341,78,E'Luxembourg - Merl',E'Lëtzebuerg - Märel');
INSERT INTO address.locality VALUES (342,78,E'Luxembourg - Muehlenbach',E'Lëtzebuerg - Millebaach');
INSERT INTO address.locality VALUES (343,78,E'Luxembourg - Neudorf',E'Lëtzebuerg - Neiduerf');
INSERT INTO address.locality VALUES (344,78,E'Luxembourg - Reckenthal',E'Lëtzebuerg - Reckendall');
INSERT INTO address.locality VALUES (345,78,E'Luxembourg - Rollingergrund',E'Lëtzebuerg - Rollengergronn');
INSERT INTO address.locality VALUES (346,78,E'Luxembourg - Weimershof',E'Lëtzebuerg -Weimeschhaff');
INSERT INTO address.locality VALUES (347,78,E'Luxembourg - Weimerskirch',E'Lëtzebuerg - Weimeschkierch');
INSERT INTO address.locality VALUES (348,31,E'Machtum',E'Meechtem');
INSERT INTO address.locality VALUES (349,18,E'Mamer',E'Mamer');
INSERT INTO address.locality VALUES (350,22,E'Manternach',E'Manternach');
INSERT INTO address.locality VALUES (351,10,E'Marienthal',E'Mariendal');
INSERT INTO address.locality VALUES (352,63,E'Marnach',E'Maarnech');
INSERT INTO address.locality VALUES (353,58,E'Marscherwald',E'Marscherwald');
INSERT INTO address.locality VALUES (354,9,E'Martelange-Haut',E'Op de Leekollen (Uewermaarteleng)');
INSERT INTO address.locality VALUES (355,4,E'Masseler',E'Masseler');
INSERT INTO address.locality VALUES (356,88,E'Maulusmuehle',E'Maulusmuehle');
INSERT INTO address.locality VALUES (357,113,E'Mecher',E'Mecher');
INSERT INTO address.locality VALUES (358,7,E'Mecher',E'Mecher');
INSERT INTO address.locality VALUES (359,86,E'Medernach',E'Miedernach');
INSERT INTO address.locality VALUES (360,75,E'Medingen',E'Méideng');
INSERT INTO address.locality VALUES (361,72,E'Meispelt',E'Meespelt');
INSERT INTO address.locality VALUES (362,12,E'Mensdorf',E'Menster');
INSERT INTO address.locality VALUES (363,80,E'Merkholtz',E'Mäerkels');
INSERT INTO address.locality VALUES (364,110,E'Mersch',E'Miersch');
INSERT INTO address.locality VALUES (365,108,E'Merscheid',E'Mierschent');
INSERT INTO address.locality VALUES (366,100,E'Merscheid',E'Merscheet');
INSERT INTO address.locality VALUES (367,106,E'Mertert',E'Mäertert');
INSERT INTO address.locality VALUES (368,14,E'Mertzig',E'Mäerzeg');
INSERT INTO address.locality VALUES (369,53,E'Meysembourg',E'Meesebuerg');
INSERT INTO address.locality VALUES (370,30,E'Michelau',E'Méchela');
INSERT INTO address.locality VALUES (371,65,E'Michelbouch',E'Méchelbuch');
INSERT INTO address.locality VALUES (372,58,E'Michelshof',E'Michelshaff');
INSERT INTO address.locality VALUES (373,60,E'Moersdorf',E'Méischdref');
INSERT INTO address.locality VALUES (374,110,E'Moesdorf',E'Miesdref');
INSERT INTO address.locality VALUES (375,101,E'Moestroff',E'Mëischtref');
INSERT INTO address.locality VALUES (376,60,E'Mompach',E'Mompech');
INSERT INTO address.locality VALUES (377,64,E'Mondercange',E'Monnerech');
INSERT INTO address.locality VALUES (378,11,E'Mondorf-les-Bains',E'Munneref');
INSERT INTO address.locality VALUES (379,75,E'Moutfort',E'Mutfert');
INSERT INTO address.locality VALUES (380,22,E'Muenschecker',E'Mënjecker');
INSERT INTO address.locality VALUES (381,73,E'Mullendorf',E'Mëlleref');
INSERT INTO address.locality VALUES (382,13,E'Müllerthall',E'Mëllerdall');
INSERT INTO address.locality VALUES (383,63,E'Munshausen',E'Munzen');
INSERT INTO address.locality VALUES (384,74,E'Münsbach',E'Mënsbech');
INSERT INTO address.locality VALUES (385,108,E'Nachtmanderscheid',E'Nuechtmanescht');
INSERT INTO address.locality VALUES (386,6,E'Nagem',E'Nojem');
INSERT INTO address.locality VALUES (387,109,E'Neidhausen',E'Näidsen');
INSERT INTO address.locality VALUES (388,34,E'Neubrasilien',E'Neibrasilien');
INSERT INTO address.locality VALUES (389,74,E'Neuhaeusgen',E'Neihaischen');
INSERT INTO address.locality VALUES (390,20,E'Neunhausen',E'Néngsen');
INSERT INTO address.locality VALUES (391,77,E'Niederanven',E'Nidderaanwen');
INSERT INTO address.locality VALUES (392,2,E'Niederdonven',E'Nidderdonwen');
INSERT INTO address.locality VALUES (393,51,E'Niederfeulen',E'Nidderfeelen');
INSERT INTO address.locality VALUES (394,84,E'Niederglabach',E'Nidderglabech');
INSERT INTO address.locality VALUES (395,6,E'Niederpallen',E'Nidderpallen');
INSERT INTO address.locality VALUES (396,88,E'Niederwampach',E'Nidderwampech');
INSERT INTO address.locality VALUES (397,4,E'Nocher',E'Nacher');
INSERT INTO address.locality VALUES (398,97,E'Noerdange',E'Näerden');
INSERT INTO address.locality VALUES (399,69,E'Noertrange',E'Näertreg');
INSERT INTO address.locality VALUES (400,71,E'Noertzange',E'Näerzeng');
INSERT INTO address.locality VALUES (401,84,E'Nommern',E'Noumer');
INSERT INTO address.locality VALUES (402,72,E'Nospelt',E'Nouspelt');
INSERT INTO address.locality VALUES (403,7,E'Nothum',E'Noutem');
INSERT INTO address.locality VALUES (404,77,E'Oberanven',E'Ueweraanwen');
INSERT INTO address.locality VALUES (405,2,E'Oberdonven',E'Uewerdonwen');
INSERT INTO address.locality VALUES (406,109,E'Obereisenbach',E'Uewereesbech');
INSERT INTO address.locality VALUES (407,51,E'Oberfeulen',E'Uewerfeelen');
INSERT INTO address.locality VALUES (408,84,E'Oberglabach',E'Uewerglabech');
INSERT INTO address.locality VALUES (409,97,E'Oberpallen',E'Uewerpallen');
INSERT INTO address.locality VALUES (410,88,E'Oberwampach',E'Uewerwampech');
INSERT INTO address.locality VALUES (411,75,E'Oetrange',E'Éiter');
INSERT INTO address.locality VALUES (412,12,E'Olingen',E'Ouljen');
INSERT INTO address.locality VALUES (413,72,E'Olm',E'Ollem');
INSERT INTO address.locality VALUES (414,50,E'Openthalt',E'Openthalt');
INSERT INTO address.locality VALUES (415,6,E'Ospern',E'Osper');
INSERT INTO address.locality VALUES (416,26,E'Osweiler',E'Uesweller');
INSERT INTO address.locality VALUES (417,92,E'Peppange',E'Peppeng');
INSERT INTO address.locality VALUES (418,9,E'Perlé',E'Pärel');
INSERT INTO address.locality VALUES (419,67,E'Pétange',E'Péiteng');
INSERT INTO address.locality VALUES (420,62,E'Petit-Nobressart',E'Kleng-Elcher');
INSERT INTO address.locality VALUES (421,110,E'Pettingen',E'Pëtten');
INSERT INTO address.locality VALUES (422,80,E'Pintsch',E'Pënsch');
INSERT INTO address.locality VALUES (423,24,E'Pissange',E'Piisseng');
INSERT INTO address.locality VALUES (424,104,E'Platen',E'Platen');
INSERT INTO address.locality VALUES (425,69,E'Pommerloch',E'Pommerlach');
INSERT INTO address.locality VALUES (426,64,E'Pontpierre',E'Steebrécken');
INSERT INTO address.locality VALUES (427,104,E'Pratz',E'Proz');
INSERT INTO address.locality VALUES (428,57,E'Prettingen',E'Pretten');
INSERT INTO address.locality VALUES (429,108,E'Putscheid',E'Pëtschent');
INSERT INTO address.locality VALUES (430,9,E'Rambrouch',E'Rammerech');
INSERT INTO address.locality VALUES (431,77,E'Rameldange',E'Rammeldang');
INSERT INTO address.locality VALUES (432,110,E'Reckange',E'Recken');
INSERT INTO address.locality VALUES (433,24,E'Reckange-sur-Mess',E'Reckeng op der Mess');
INSERT INTO address.locality VALUES (434,6,E'Redange',E'Réiden');
INSERT INTO address.locality VALUES (435,6,E'Reichlange',E'Räichel');
INSERT INTO address.locality VALUES (436,104,E'Reimberg',E'Rëmmereg');
INSERT INTO address.locality VALUES (437,1,E'Reisdorf',E'Reisduerf');
INSERT INTO address.locality VALUES (438,70,E'Remerschen',E'Rëmerschen');
INSERT INTO address.locality VALUES (439,83,E'Remich',E'Réimech');
INSERT INTO address.locality VALUES (440,89,E'Reuland',E'Reiland');
INSERT INTO address.locality VALUES (441,113,E'Reuler',E'Reiler');
INSERT INTO address.locality VALUES (442,34,E'Rindschleiden',E'Randschelt');
INSERT INTO address.locality VALUES (443,100,E'Ringel',E'Réngel');
INSERT INTO address.locality VALUES (444,105,E'Rippig',E'Rippeg');
INSERT INTO address.locality VALUES (445,37,E'Rippweiler',E'Rippweiler');
INSERT INTO address.locality VALUES (446,67,E'Rodange',E'Rodange');
INSERT INTO address.locality VALUES (447,81,E'Rodenbourg',E'Roudemer');
INSERT INTO address.locality VALUES (448,63,E'Roder',E'Rueder');
INSERT INTO address.locality VALUES (449,109,E'Rodershausen',E'Roudersen');
INSERT INTO address.locality VALUES (450,24,E'Roedgen',E'Riedgen');
INSERT INTO address.locality VALUES (451,21,E'Roedt',E'Ried');
INSERT INTO address.locality VALUES (452,92,E'Roeser',E'Réiser');
INSERT INTO address.locality VALUES (453,28,E'Rolling',E'Rolleng');
INSERT INTO address.locality VALUES (454,110,E'Rollingen',E'Rollengen');
INSERT INTO address.locality VALUES (455,9,E'Rombach-Martelange',E'Rombech-Maarteleng');
INSERT INTO address.locality VALUES (456,62,E'Roodt',E'Rued');
INSERT INTO address.locality VALUES (457,95,E'Roodt',E'Rued');
INSERT INTO address.locality VALUES (458,12,E'Roodt-sur-Syre',E'Rued-Sir');
INSERT INTO address.locality VALUES (459,98,E'Roost',E'Rouscht');
INSERT INTO address.locality VALUES (460,26,E'Rosport',E'Rouspert');
INSERT INTO address.locality VALUES (461,103,E'Roullingen',E'Rulljen');
INSERT INTO address.locality VALUES (462,114,E'Rumelange',E'Rëmeleng');
INSERT INTO address.locality VALUES (463,88,E'Rumlange',E'Rëmeljen');
INSERT INTO address.locality VALUES (464,39,E'Saeul',E'Sëll');
INSERT INTO address.locality VALUES (465,36,E'Sandweiler',E'Sandweiler');
INSERT INTO address.locality VALUES (466,61,E'Sanem',E'Suessem');
INSERT INTO address.locality VALUES (467,88,E'Sassel',E'Saassel');
INSERT INTO address.locality VALUES (468,86,E'Savelborn',E'Suewelbur');
INSERT INTO address.locality VALUES (469,37,E'Schandel',E'Schandel');
INSERT INTO address.locality VALUES (470,30,E'Scheidel',E'scheedel');
INSERT INTO address.locality VALUES (471,58,E'Scheidgen',E'Scheedgen');
INSERT INTO address.locality VALUES (472,70,E'Schengen',E'Schengen');
INSERT INTO address.locality VALUES (473,107,E'Schieren',E'Schieren');
INSERT INTO address.locality VALUES (474,47,E'Schifflange',E'Schëffleng');
INSERT INTO address.locality VALUES (475,41,E'Schiltzberg',E'Schiltzbierg');
INSERT INTO address.locality VALUES (476,88,E'Schimpach',E'Schëmpech');
INSERT INTO address.locality VALUES (477,69,E'Schleif',E'Schleef');
INSERT INTO address.locality VALUES (478,30,E'Schlindermanderscheid',E'Schlënnermanescht');
INSERT INTO address.locality VALUES (479,90,E'Schmiede',E'Schmëdd');
INSERT INTO address.locality VALUES (480,110,E'Schoenfels',E'Schëndels');
INSERT INTO address.locality VALUES (481,41,E'Schoos',E'Schous');
INSERT INTO address.locality VALUES (482,33,E'Schouweiler',E'Schuller');
INSERT INTO address.locality VALUES (483,74,E'Schrassig',E'Schraasseg');
INSERT INTO address.locality VALUES (484,84,E'Schrondweiler',E'Schrondweiler');
INSERT INTO address.locality VALUES (485,74,E'Schuttrange',E'Schëtter');
INSERT INTO address.locality VALUES (486,39,E'Schwebach',E'Schweebech');
INSERT INTO address.locality VALUES (487,44,E'Schwebsingen',E'Schwéidsbeng');
INSERT INTO address.locality VALUES (488,97,E'Schweich',E'Schweech');
INSERT INTO address.locality VALUES (489,9,E'Schwiedelbrouch',E'Schwiddelbruch');
INSERT INTO address.locality VALUES (490,45,E'Selscheid',E'selschent');
INSERT INTO address.locality VALUES (491,85,E'Selz',E'Selz');
INSERT INTO address.locality VALUES (492,77,E'Senningen',E'Senneng');
INSERT INTO address.locality VALUES (493,77,E'Senningerberg',E'Sennengerbierg');
INSERT INTO address.locality VALUES (494,95,E'Septfontaines',E'Simmer');
INSERT INTO address.locality VALUES (495,63,E'Siebenaler',E'Siwwenaler');
INSERT INTO address.locality VALUES (496,61,E'Soleuvre',E'Zolwer');
INSERT INTO address.locality VALUES (497,69,E'Sonlez',E'Soller');
INSERT INTO address.locality VALUES (498,33,E'Sprinkange',E'Spréngkeng');
INSERT INTO address.locality VALUES (499,117,E'Stadtbredimus',E'Stadbriedemes');
INSERT INTO address.locality VALUES (500,77,E'Staffelstein',E'Stafelter');
INSERT INTO address.locality VALUES (501,56,E'Stegen',E'Steeën');
INSERT INTO address.locality VALUES (502,96,E'Steinfort',E'Stengefort');
INSERT INTO address.locality VALUES (503,26,E'Steinheim',E'Steenem');
INSERT INTO address.locality VALUES (504,73,E'Steinsel',E'Steesel');
INSERT INTO address.locality VALUES (505,88,E'Stockem',E'Stackem');
INSERT INTO address.locality VALUES (506,108,E'Stolzembourg',E'Stolzebuerg');
INSERT INTO address.locality VALUES (507,102,E'Strassen',E'Stroossen');
INSERT INTO address.locality VALUES (508,41,E'Stuppicht',E'Stuppecht');
INSERT INTO address.locality VALUES (509,115,E'Surré',E'Sir');
INSERT INTO address.locality VALUES (510,66,E'Syren',E'Siren');
INSERT INTO address.locality VALUES (511,100,E'Tadler',E'Toodler');
INSERT INTO address.locality VALUES (512,85,E'Tandel',E'Tandel');
INSERT INTO address.locality VALUES (513,7,E'Tarchamps',E'Lischpelt');
INSERT INTO address.locality VALUES (514,49,E'Tétange',E'Téiteng');
INSERT INTO address.locality VALUES (515,21,E'Trintange',E'Trënteng');
INSERT INTO address.locality VALUES (516,88,E'Troine',E'Tratten');
INSERT INTO address.locality VALUES (517,88,E'Troine-Route',E'Trätterstrooss');
INSERT INTO address.locality VALUES (518,90,E'Troisvierges',E'Élwen');
INSERT INTO address.locality VALUES (519,10,E'Tuntange',E'Tënten');
INSERT INTO address.locality VALUES (520,74,E'Uebersyren',E'Iwwersiren');
INSERT INTO address.locality VALUES (521,109,E'Untereisenbach',E'Eesbech');
INSERT INTO address.locality VALUES (522,27,E'Unterschlinder',E'Ënnerschlënner');
INSERT INTO address.locality VALUES (523,113,E'Urspelt',E'Ischpelt');
INSERT INTO address.locality VALUES (524,37,E'Useldange',E'Useldeng');
INSERT INTO address.locality VALUES (525,79,E'Vianden',E'Veianen');
INSERT INTO address.locality VALUES (526,65,E'Vichten',E'Viichten');
INSERT INTO address.locality VALUES (527,34,E'Wahl',E'Wal');
INSERT INTO address.locality VALUES (528,109,E'Wahlhausen',E'Wuelessen');
INSERT INTO address.locality VALUES (529,13,E'Waldbillig',E'Waldbëlleg');
INSERT INTO address.locality VALUES (530,21,E'Waldbredimus',E'Waldbriedemes');
INSERT INTO address.locality VALUES (531,77,E'Waldhof',E'Waldhaff');
INSERT INTO address.locality VALUES (532,55,E'Walferdange',E'Walfer');
INSERT INTO address.locality VALUES (533,1,E'Wallendorf-Pont',E'Wuelenduerf-Bréck');
INSERT INTO address.locality VALUES (534,85,E'Walsdorf',E'Waalsdref');
INSERT INTO address.locality VALUES (535,111,E'Warken',E'Waarken');
INSERT INTO address.locality VALUES (536,106,E'Wasserbillig',E'Waasserbëlleg');
INSERT INTO address.locality VALUES (537,7,E'Watrange',E'Walter');
INSERT INTO address.locality VALUES (538,29,E'Wecker',E'Wecker');
INSERT INTO address.locality VALUES (539,113,E'Weicherdange',E'Wäicherdang');
INSERT INTO address.locality VALUES (540,103,E'Weidingen',E'Wegdichen');
INSERT INTO address.locality VALUES (541,108,E'Weiler',E'Weller');
INSERT INTO address.locality VALUES (542,88,E'Weiler',E'Weiler');
INSERT INTO address.locality VALUES (543,66,E'Weiler-la-Tour',E'Weiler-la-Tour');
INSERT INTO address.locality VALUES (544,17,E'Weilerbach',E'Weilerbaach');
INSERT INTO address.locality VALUES (545,59,E'Weiswampach',E'Wäisswampech');
INSERT INTO address.locality VALUES (546,44,E'Wellenstein',E'Wellesteen');
INSERT INTO address.locality VALUES (547,25,E'Welfrange',E'Welfréng');
INSERT INTO address.locality VALUES (548,30,E'Welscheid',E'Welschent');
INSERT INTO address.locality VALUES (549,35,E'Welsdorf',E'Welsduerf');
INSERT INTO address.locality VALUES (550,59,E'Wemperhardt',E'Wämperhaart');
INSERT INTO address.locality VALUES (551,29,E'Weydig',E'Weidig');
INSERT INTO address.locality VALUES (552,41,E'Weyer',E'Weier');
INSERT INTO address.locality VALUES (553,24,E'Wickrange',E'Wickreng');
INSERT INTO address.locality VALUES (554,103,E'Wiltz',E'Wolz');
INSERT INTO address.locality VALUES (555,90,E'Wilwerdange',E'Wilwerdang');
INSERT INTO address.locality VALUES (556,80,E'Wilwerwiltz',E'Wëlwerwolz');
INSERT INTO address.locality VALUES (557,88,E'Wincrange',E'Wëntger');
INSERT INTO address.locality VALUES (558,118,E'Windhof',E'Wandhaff');
INSERT INTO address.locality VALUES (559,69,E'Winseler',E'Wanseler');
INSERT INTO address.locality VALUES (560,70,E'Wintrange',E'Wëntreng');
INSERT INTO address.locality VALUES (561,58,E'Wolper',E'Wolpert');
INSERT INTO address.locality VALUES (562,9,E'Wolwelange',E'Wolwen');
INSERT INTO address.locality VALUES (563,31,E'Wormeldange',E'Wuermeldeng (Wuermer)');
INSERT INTO address.locality VALUES (564,31,E'Wormeldange-Haut',E'Uewerwuermeldeng');
INSERT INTO address.locality VALUES (565,105,E'Zittig',E'Zëtteg');

SELECT setval(E'address.locality_id_seq', (select id from address.locality order by id desc limit 1));

INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Simmerfarm',E'Simmerfarm',    (SELECT id from address.municipality WHERE name = E'Septfontaines'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Simmerschmelz',E'Simmerschmelz', (SELECT id from address.municipality WHERE name =E'Septfontaines'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Flebour',E'Fléiber', (SELECT id from address.municipality WHERE name =E'Boulaide'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Flebour',E'Flebour', (SELECT id from address.municipality WHERE name =E'Bourscheid'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Tintesmühle',E'Tëntesmillen', (SELECT id from address.municipality WHERE name =E'Heinerscheid'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Unterschlinder',E'Ennerschlënner', (SELECT id from address.municipality WHERE name =E'Hoscheid'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Fossen',E'Foossen', (SELECT id from address.municipality WHERE name =E'Heinerscheid'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Leesbach',E'Léisbech', (SELECT id from address.municipality WHERE name =E'Septfontaines'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Friedbusch',E'Fridbësch', (SELECT id from address.municipality WHERE name =E'Bourscheid'));

INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Keiwelbach',E'Keiwelsbaach',    (SELECT id from address.municipality WHERE name =E'Bettendorf'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Lausdorn',E'Lausduer', (SELECT id from address.municipality WHERE name =E'Heinerscheid'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Colmar-Pont',E'Colmar-Pont', (SELECT id from address.municipality WHERE name =E'Schieren'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Rossmuehle',E'Rossmillen', (SELECT id from address.municipality WHERE name =E'Weiswampach'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Kleemuehle',E'Kléimillen', (SELECT id from address.municipality WHERE name =E'Weiswampach'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Hollermuehle',E'Hollermillen', (SELECT id from address.municipality WHERE name =E'Weiswampach'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Haut-Martelange',E'Uewermaarteleng', (SELECT id from address.municipality WHERE name =E'Rambrouch'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Klingelscheuer',E'Klingelscheuer', (SELECT id from address.municipality WHERE name =E'Lorentzweiler'));
INSERT INTO address.locality (name, name_lu, municipality_id) VALUES (E'Keppenhaff',E'Keppenhaff', (SELECT id from address.municipality WHERE name =E'Diekirch'));

INSERT INTO address.type (id,value) VALUES (1,E'private');
INSERT INTO address.type (id,value) VALUES (2,E'billing');
INSERT INTO address.type (id,value) VALUES (3,E'work');

INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'lu',E'luxembourg', 'L', 'LUX');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'de',E'germany', 'D', 'DEU');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'fr',E'france', 'F', 'FRA');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'en',E'england', 'GB', 'GBR');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'be',E'belgium', 'B', 'BEL');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'nl',E'netherlands', 'NL', 'NLD');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'pt',E'portugal', 'P', 'POR');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'it',E'italy', 'I', 'ITA');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'au',E'austria', 'A', 'AUT');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'bg',E'bulgaria', 'BG', 'BGR');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'cy',E'cyprus', 'CY', 'CYP');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'cz',E'czech', 'CZ', 'CZE');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'dk',E'denmark', 'DK', 'DNK');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'ee',E'estonia', 'EE', 'EST');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'fi',E'finland', 'FI', 'FIN');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'gr',E'greece', 'GR', 'GRC');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'hu',E'hungary', 'H', 'HUN');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'ie',E'ireland', 'IE', 'IRL');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'lv',E'latvia', 'LV', 'LVA');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'lt',E'lithuania', 'LT', 'LTU');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'mt',E'malta', 'M', 'MLT');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'pl',E'poland', 'PL', 'POL');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'ro',E'romania', 'RO', 'ROU');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'sk',E'slovakia', 'SK', 'SVK');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'si',E'slovenia', 'SI', 'SVN');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'es',E'spain', 'E', 'ESP');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'se',E'sweden', 'S', 'SWE');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'no',E'norway', 'N', 'NOR');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'ch',E'switzerland', 'CH', 'CHE');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'al',E'albania', 'AL', 'ALB');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'ad',E'andorra', 'AD', 'AND');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'am',E'armenia', 'AM', 'ARM');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'az',E'azerbaijan', 'AZ', 'AZE');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'by',E'belarus', 'BY', 'BLR');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'ba',E'bosnia_herzegovina', 'BA', 'BIH');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'hr',E'croatia', 'HR', 'HRV');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'ge',E'georgia', 'GE', 'GEO');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'is',E'iceland', 'IS', 'ISL');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'li',E'lichtenstein', 'FL', 'LIE');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'mk',E'macedonia', 'MK', 'MKD');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'md',E'moldova', 'MD', 'MDA');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'mc',E'monaco', 'MC', 'MCO');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'me',E'montenegro', 'ME', 'MNE');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'sm',E'san_marino', 'SM', 'SMR');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'rs',E'serbia', 'RS', 'SRB');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'tr',E'turkey', 'TR', 'TUR');
INSERT INTO  address.country (code, name, postal_code, iso3166_alpha3) VALUES (E'ua',E'ukraine', 'UA', 'UKR');

INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('afghanistan', 'af', 'AF', 'AFG');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('aland_islands', 'ax', 'AX', 'ALA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('algeria', 'dz', 'DZ', 'DZA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('american_samoa', 'as', 'AS', 'ASM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('angola', 'ao', 'AO', 'AGO');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('anguilla', 'ai', 'AI', 'AIA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('antarctica', 'aq', 'AQ', 'ATA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('antigua_and_barbuda', 'ag', 'AG', 'ATG');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('argentina', 'ar', 'AR', 'ARG');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('aruba', 'aw', 'AW', 'ABW');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('australia', 'au', 'AU', 'AUS');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('bahamas', 'bs', 'BS', 'BHS');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('bahrain', 'bh', 'BH', 'BHR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('bangladesh', 'bd', 'BD', 'BGD');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('barbados', 'bb', 'BB', 'BRB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('belize', 'bz', 'BZ', 'BLZ');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('benin', 'bj', 'BJ', 'BEN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('bermuda', 'bm', 'BM', 'BMU');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('bhutan', 'bt', 'BT', 'BTN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('bolivia', 'bo', 'BO', 'BOL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('botswana', 'bw', 'BW', 'BWA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('bouvet_island', 'bv', 'BV', 'BVT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('brazil', 'br', 'BR', 'BRA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('british_virgin_islands', 'vg', 'VG', 'VGB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('british_indian_ocean_territory', 'io', 'IO', 'IOT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('brunei_darussalam', 'bn', 'BN', 'BRN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('burkina_faso', 'bf', 'BF', 'BFA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('burundi', 'bi', 'BI', 'BDI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('cambodia', 'kh', 'KH', 'KHM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('cameroon', 'cm', 'CM', 'CMR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('canada', 'ca', 'CA', 'CAN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('cape_verde', 'cv', 'CV', 'CPV');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('cayman_islands', 'ky', 'KY', 'CYM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('central_african_republic', 'cf', 'CF', 'CAF');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('chad', 'td', 'TD', 'TCD');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('chile', 'cl', 'CL', 'CHL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('china', 'cn', 'CN', 'CHN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('hong_kong', 'hk', 'HK', 'HKG');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('macao', 'mo', 'MO', 'MAC');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('christmas_island', 'cx', 'CX', 'CXR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('cocos_islands', 'cc', 'CC', 'CCK');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('colombia', 'co', 'CO', 'COL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('comoros', 'km', 'KM', 'COM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('congo_brazzaville', 'cg', 'CG', 'COG');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('democratic_republic_of_the_congo', 'cd', 'CD', 'COD');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('cook_islands', 'ck', 'CK', 'COK');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('costa_rica', 'cr', 'CR', 'CRI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('cote_d_ivoire', 'ci', 'CI', 'CIV');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('cuba', 'cu', 'CU', 'CUB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('djibouti', 'dj', 'DJ', 'DJI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('dominica', 'dm', 'DM', 'DMA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('dominican_republic', 'do', 'DO', 'DOM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('ecuador', 'ec', 'EC', 'ECU');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('egypt', 'eg', 'EG', 'EGY');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('el_salvador', 'sv', 'SV', 'SLV');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('equatorial_guinea', 'gq', 'GQ', 'GNQ');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('eritrea', 'er', 'ER', 'ERI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('ethiopia', 'et', 'ET', 'ETH');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('falkland_islands', 'fk', 'FK', 'FLK');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('faroe_islands', 'fo', 'FO', 'FRO');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('fiji', 'fj', 'FJ', 'FJI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('french_guiana', 'gf', 'GF', 'GUF');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('french_polynesia', 'pf', 'PF', 'PYF');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('french_southern_territories', 'tf', 'TF', 'ATF');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('gabon', 'ga', 'GA', 'GAB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('gambia', 'gm', 'GM', 'GMB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('ghana', 'gh', 'GH', 'GHA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('gibraltar', 'gi', 'GI', 'GIB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('greenland', 'gl', 'GL', 'GRL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('grenada', 'gd', 'GD', 'GRD');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('guadeloupe', 'gp', 'GP', 'GLP');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('guam', 'gu', 'GU', 'GUM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('guatemala', 'gt', 'GT', 'GTM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('guernsey', 'gg', 'GG', 'GGY');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('guinea', 'gn', 'GN', 'GIN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('guinea_bissau', 'gw', 'GW', 'GNB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('guyana', 'gy', 'GY', 'GUY');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('haiti', 'ht', 'HT', 'HTI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('heard_island_and_mcdonald_islands', 'hm', 'HM', 'HMD');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('vatican_city_state', 'va', 'VA', 'VAT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('honduras', 'hn', 'HN', 'HND');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('india', 'in', 'IN', 'IND');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('indonesia', 'id', 'ID', 'IDN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('iran', 'ir', 'IR', 'IRN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('iraq', 'iq', 'IQ', 'IRQ');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('isle_of_man', 'im', 'IM', 'IMN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('israel', 'il', 'IL', 'ISR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('jamaica', 'jm', 'JM', 'JAM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('japan', 'jp', 'JP', 'JPN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('jersey', 'je', 'JE', 'JEY');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('jordan', 'jo', 'JO', 'JOR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('kazakhstan', 'kz', 'KZ', 'KAZ');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('kenya', 'ke', 'KE', 'KEN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('kiribati', 'ki', 'KI', 'KIR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('north_korea', 'kp', 'KP', 'PRK');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('south_korea', 'kr', 'KR', 'KOR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('kuwait', 'kw', 'KW', 'KWT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('kyrgyzstan', 'kg', 'KG', 'KGZ');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('lao_pdr', 'la', 'LA', 'LAO');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('lebanon', 'lb', 'LB', 'LBN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('lesotho', 'ls', 'LS', 'LSO');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('liberia', 'lr', 'LR', 'LBR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('libya', 'ly', 'LY', 'LBY');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('madagascar', 'mg', 'MG', 'MDG');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('malawi', 'mw', 'MW', 'MWI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('malaysia', 'my', 'MY', 'MYS');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('maldives', 'mv', 'MV', 'MDV');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('mali', 'ml', 'ML', 'MLI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('marshall_islands', 'mh', 'MH', 'MHL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('martinique', 'mq', 'MQ', 'MTQ');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('mauritania', 'mr', 'MR', 'MRT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('mauritius', 'mu', 'MU', 'MUS');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('mayotte', 'yt', 'YT', 'MYT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('mexico', 'mx', 'MX', 'MEX');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('micronesia', 'fm', 'FM', 'FSM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('mongolia', 'mn', 'MN', 'MNG');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('montserrat', 'ms', 'MS', 'MSR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('morocco', 'ma', 'MA', 'MAR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('mozambique', 'mz', 'MZ', 'MOZ');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('myanmar', 'mm', 'MM', 'MMR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('namibia', 'na', 'NA', 'NAM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('nauru', 'nr', 'NR', 'NRU');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('nepal', 'np', 'NP', 'NPL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('netherlands_antilles', 'an', 'AN', 'ANT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('new_caledonia', 'nc', 'NC', 'NCL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('new_zealand', 'nz', 'NZ', 'NZL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('nicaragua', 'ni', 'NI', 'NIC');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('niger', 'ne', 'NE', 'NER');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('nigeria', 'ng', 'NG', 'NGA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('niue', 'nu', 'NU', 'NIU');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('norfolk_island', 'nf', 'NF', 'NFK');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('northern_mariana_islands', 'mp', 'MP', 'MNP');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('oman', 'om', 'OM', 'OMN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('pakistan', 'pk', 'PK', 'PAK');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('palau', 'pw', 'PW', 'PLW');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('palestine', 'ps', 'PS', 'PSE');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('panama', 'pa', 'PA', 'PAN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('papua_new_guinea', 'pg', 'PG', 'PNG');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('paraguay', 'py', 'PY', 'PRY');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('peru', 'pe', 'PE', 'PER');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('philippines', 'ph', 'PH', 'PHL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('pitcairn', 'pn', 'PN', 'PCN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('puerto_rico', 'pr', 'PR', 'PRI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('qatar', 'qa', 'QA', 'QAT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('reunion', 're', 'RE', 'REU');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('russian_federation', 'ru', 'RU', 'RUS');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('rwanda', 'rw', 'RW', 'RWA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('saint_barthelemy', 'bl', 'BL', 'BLM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('saint_helena', 'sh', 'SH', 'SHN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('saint_kitts_and_nevis', 'kn', 'KN', 'KNA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('saint_lucia', 'lc', 'LC', 'LCA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('saint_martin', 'mf', 'MF', 'MAF');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('saint_pierre_and_miquelon', 'pm', 'PM', 'SPM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('saint_vincent_and_grenadines', 'vc', 'VC', 'VCT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('samoa', 'ws', 'WS', 'WSM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('sao_tome_and_principe', 'st', 'ST', 'STP');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('saudi_arabia', 'sa', 'SA', 'SAU');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('senegal', 'sn', 'SN', 'SEN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('seychelles', 'sc', 'SC', 'SYC');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('sierra_leone', 'sl', 'SL', 'SLE');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('singapore', 'sg', 'SG', 'SGP');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('solomon_islands', 'sb', 'SB', 'SLB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('somalia', 'so', 'SO', 'SOM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('south_africa', 'za', 'ZA', 'ZAF');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('south_georgia', 'gs', 'GS', 'SGS');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('south_sudan', 'ss', 'SS', 'SSD');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('sri_lanka', 'lk', 'LK', 'LKA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('sudan', 'sd', 'SD', 'SDN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('suriname', 'sr', 'SR', 'SUR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('svalbard_and_jan_mayen_islands', 'sj', 'SJ', 'SJM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('swaziland', 'sz', 'SZ', 'SWZ');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('syria', 'sy', 'SY', 'SYR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('taiwan', 'tw', 'TW', 'TWN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('tajikistan', 'tj', 'TJ', 'TJK');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('tanzania', 'tz', 'TZ', 'TZA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('thailand', 'th', 'TH', 'THA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('timor_leste', 'tl', 'TL', 'TLS');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('togo', 'tg', 'TG', 'TGO');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('tokelau', 'tk', 'TK', 'TKL');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('tonga', 'to', 'TO', 'TON');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('trinidad_and_tobago', 'tt', 'TT', 'TTO');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('tunisia', 'tn', 'TN', 'TUN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('turkmenistan', 'tm', 'TM', 'TKM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('turks_and_caicos_islands', 'tc', 'TC', 'TCA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('tuvalu', 'tv', 'TV', 'TUV');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('uganda', 'ug', 'UG', 'UGA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('united_arab_emirates', 'ae', 'AE', 'ARE');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('united_kingdom', 'gb', 'GB', 'GBR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('united_states_of_america', 'us', 'US', 'USA');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('united_states_minor_outlying_islands', 'um', 'UM', 'UMI');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('uruguay', 'uy', 'UY', 'URY');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('uzbekistan', 'uz', 'UZ', 'UZB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('vanuatu', 'vu', 'VU', 'VUT');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('venezuela', 've', 'VE', 'VEN');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('viet_nam', 'vn', 'VN', 'VNM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('virgin_islands', 'vi', 'VI', 'VIR');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('wallis_and_futuna_islands', 'wf', 'WF', 'WLF');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('western_sahara', 'eh', 'EH', 'ESH');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('yemen', 'ye', 'YE', 'YEM');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('zambia', 'zm', 'ZM', 'ZMB');
INSERT INTO  address.country (name, code, postal_code, iso3166_alpha3) VALUES ('zimbabwe', 'zw', 'ZW', 'ZWE');
