urfatBro/app/geo/country/db/001_countries_seeding.sql

-- https://pt.wikipedia.org/wiki/Lista_de_membros_da_Organiza%C3%A7%C3%A3o_Internacional_de_Normaliza%C3%A7%C3%A3o
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Afeganistão', 4, 'AF', 'AFG');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('África do Sul', 710, 'ZA', 'ZAF');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Albânia', 8, 'AL', 'ALB');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Alemanha', 276, 'DE', 'DEU');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Angola', 24, 'AO', 'AGO');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Antígua e Barbuda', 28, 'AG', 'ATG');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Arábia Saudita', 682, 'SA', 'SAU');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Argélia', 12, 'DZ', 'DZA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Argentina', 32, 'AR', 'ARG');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Armênia', 51, 'AM', 'ARM');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Austrália', 36, 'AU', 'AUS');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Áustria', 40, 'AT', 'AUT');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Azerbaijão', 31, 'AZ', 'AZE');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Bahamas', 44, 'BS', 'BHS');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Bangladesh', 50, 'BD', 'BGD');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Barbados', 52, 'BB', 'BRB');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Barém', 48, 'BH', 'BHR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Belarus', 112, 'BY', 'BLR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Bélgica', 56, 'BE', 'BEL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Belize', 84, 'BZ', 'BLZ');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Benin', 204, 'BJ', 'BEN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Bolívia', 68, 'BO', 'BOL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Bósnia e Herzegovina', 70, 'BA', 'BIH');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Botsuana', 72, 'BW', 'BWA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Brasil', 76, 'BR', 'BRA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Brunei Darussalam', 96, 'BN', 'BRN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Bulgária', 100, 'BG', 'BGR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Burkina Faso', 854, 'BF', 'BFA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Burundi', 108, 'BI', 'BDI');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Butão', 64, 'BT', 'BTN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Camarões', 120, 'CM', 'CMR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Camboja', 116, 'KH', 'KHM');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Canadá', 124, 'CA', 'CAN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Catar', 634, 'QA', 'QAT');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Cazaquistão', 398, 'KZ', 'KAZ');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Chile', 52, 'CL', 'CHL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('China', 156, 'CN', 'CHN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Chipre', 196, 'CY', 'CYP');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Cingapura', 702, 'SG', 'SGP');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Colômbia', 170, 'CO', 'COL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('República Democrática do Congo', 160, 'CD', 'cod');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Coreia do Norte', 408, 'KP', 'PRK');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Coréia do Sul', 410, 'KR', 'KOR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Costa do Marfim', 384, 'CI', 'CIV');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Costa Rica', 188, 'CR', 'CRI');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Croácia', 191, 'HR', 'HRV');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Cuba', 192, 'CU', 'CUB');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Dinamarca', 208, 'DK', 'DNK');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Dominica', 212, 'DM', 'DMA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Egito', 818, 'EG', 'EGY');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('El Salvador', 222, 'SV', 'SLV');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Emirados Árabes Unidos', 784, 'AE', 'ARE');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Equador', 218, 'EC', 'ECU');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Eritréia', 232, 'ER', 'ERI');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Eslováquia', 703, 'SK', 'SVK');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Eslovênia', 705, 'SI', 'SVN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Espanha', 724, 'ES', 'ESP');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Estados Unidos', 840, 'US', 'USA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Estônia', 233, 'EE', 'EST');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Eswatini', 748, 'SZ', 'SWZ');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Etiópia', 231, 'ET', 'ETH');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Federação Russa', 643, 'RU', 'RUS');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Fiji', 242, 'FJ', 'FJI');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Filipinas', 608, 'PH', 'PHL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Finlândia', 246, 'FI', 'FIN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('França', 250, 'FR', 'FRA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Gabão', 266, 'GA', 'GAB');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Gâmbia', 270, 'GM', 'GMB');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Gana', 288, 'GH', 'GHA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Georgia', 268, 'GE', 'GEO');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Grécia', 300, 'GR', 'GRC');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Guatemala', 320, 'GT', 'GTM');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Guiana', 328, 'GY', 'GUY');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Guiné', 324, 'GN', 'GIN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Haiti', 332, 'HT', 'HTI');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Honduras', 340, 'HN', 'HND');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Hong Kong', 344, 'HK', 'HKG');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Hungria', 348, 'HU', 'HUN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Índia', 356, 'IN', 'IND');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Indonésia', 360, 'ID', 'IDN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Togo', 768, 'TG', 'TGO');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Irão', 364, 'IR', 'IRN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Iraque', 368, 'IQ', 'IRQ');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Irlanda', 372, 'IE', 'IRL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Islândia', 352, 'IS', 'ISL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Israel', 376, 'IL', 'ISR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Itália', 380, 'IT', 'ITA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Jamaica', 388, 'JM', 'JAM');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Japão', 392, 'JP', 'JPN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Jordânia', 400, 'JO', 'JOR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Kuwait', 414, 'KW', 'KWT');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Letônia', 428, 'LV', 'LVA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Líbano', 422, 'LB', 'LBN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Lituânia', 440, 'LT', 'LTU');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Luxemburgo', 442, 'LU', 'LUX');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Macau', 446, 'MO', 'MAC');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Macedônia do Norte', 807, 'MK', 'MKD');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Madagáscar', 450, 'MG', 'MDG');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Malásia', 458, 'MY', 'MYS');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Malawi', 454, 'MW', 'MWI');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Mali', 466, 'ML', 'MLI');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Malta', 470, 'MT', 'MLT');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Marrocos', 504, 'MA', 'MAR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Maurício', 480, 'MU', 'MUS');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Mauritânia', 478, 'MR', 'MRT');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('México', 484, 'MX', 'MEX');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Moçambique', 508, 'MZ', 'MOZ');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Moldávia', 498, 'MD', 'MDA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Mongólia', 496, 'MN', 'MNG');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Montenegro', 442, 'ME', 'MNE');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Myanmar', 104, 'MM', 'MMR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Namíbia', 516, 'NA', 'NAM');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Nepal', 524, 'NP', 'NPL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Nicarágua', 558, 'NI', 'NIC');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Níger', 562, 'NE', 'NER');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Nigéria', 566, 'NG', 'NGA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Noruega', 578, 'NO', 'NOR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Nova Zelândia', 554, 'NZ', 'NZL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Omã', 512, 'OM', 'OMN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Países Baixos', 528, 'NL', 'NLD');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Palestina', 275, 'PS', 'PSE');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Panamá', 591, 'PA', 'PAN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Papua Nova Guiné', 598, 'PG', 'PNG');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Paquistão', 586, 'PK', 'PAK');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Paraguai', 600, 'PY', 'PRY');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Peru', 604, 'PE', 'PER');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Peru', 792, 'TR', 'TUR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Polônia', 616, 'PL', 'POL');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Portugal', 620, 'PT', 'PRT');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Quênia', 404, 'KE', 'KEN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Quirguistão', 417, 'KG', 'KGZ');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Reino Unido', 826, 'GB', 'GBR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('República Árabe da Síria', 760, 'SY', 'SYR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('República Checa', 203, 'CZ', 'CZE');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('República Democrática Popular do Laos', 418, 'LA', 'LAO');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('República Dominicana', 214, 'DO', 'DOM');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Roménia', 642, 'RO', 'ROU');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Ruanda', 646, 'RW', 'RWA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Santa Lúcia', 662, 'LC', 'LCA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('São Cristóvão e Névis', 659, 'KN', 'KNA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('São Tomé e Príncipe', 678, 'ST', 'STP');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('São Vicente e Granadinas', 670, 'VC', 'VCT');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Senegal', 686, 'SN', 'SEN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Serra Leoa', 694, 'SL', 'SLE');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Sérvia', 891, 'CS', 'SCG');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Seychelles', 690, 'SC', 'SYC');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Sri Lanka', 144, 'LK', 'LKA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Sudão', 736, 'SD', 'SDN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Suécia', 752, 'SE', 'SWE');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Suíça', 756, 'CH', 'CHE');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Suriname', 740, 'SR', 'SUR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Tailândia', 764, 'TH', 'THA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Tajiquistão', 762, 'TJ', 'TJK');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Tanzânia', 834, 'TZ', 'TZA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Trinidad e Tobago', 780, 'TT', 'TTO');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Tunísia', 788, 'TN', 'TUN');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Turcomenistão', 795, 'TM', 'TKM');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Ucrânia', 804, 'UA', 'UKR');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Uganda', 800, 'UG', 'UGA');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Uruguai', 858, 'UY', 'URY');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Uzbequistão', 860, 'UZ', 'UZB');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Vietnã', 704, 'VN', 'VNM');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Zâmbia', 894, 'ZM', 'ZMB');
INSERT INTO {geo_countries} (name, code, iso2, iso3) VALUES('Zimbábue', 816, 'ZW', 'ZWE');