Skip to content

Instantly share code, notes, and snippets.

@rasputino
Last active January 11, 2022 08:44
Show Gist options
  • Save rasputino/c735cd92c16697cd7477c64d216ecf4e to your computer and use it in GitHub Desktop.
Save rasputino/c735cd92c16697cd7477c64d216ecf4e to your computer and use it in GitHub Desktop.
Códigos nacionalidades INE
CREATE TABLE public.paises (
cpk_pais character(6) NOT NULL,
cdescpais character varying(30) NOT NULL
);
INSERT INTO public.paises VALUES ('661012','Albania');
INSERT INTO public.paises VALUES ('661027','Austria');
INSERT INTO public.paises VALUES ('661033','Bélgica');
INSERT INTO public.paises VALUES ('661048','Bulgaria');
INSERT INTO public.paises VALUES ('661051','CHECOSLOVAQUIA');
INSERT INTO public.paises VALUES ('661064','Chipre');
INSERT INTO public.paises VALUES ('661070','Dinamarca');
INSERT INTO public.paises VALUES ('661086','España');
INSERT INTO public.paises VALUES ('661099','Finlandia');
INSERT INTO public.paises VALUES ('661103','Francia');
INSERT INTO public.paises VALUES ('661110','Grecia');
INSERT INTO public.paises VALUES ('661125','Hungría');
INSERT INTO public.paises VALUES ('661131','Irlanda');
INSERT INTO public.paises VALUES ('661146','Islandia');
INSERT INTO public.paises VALUES ('661159','Italia');
INSERT INTO public.paises VALUES ('661162','Liechtenstein');
INSERT INTO public.paises VALUES ('661178','Luxemburgo');
INSERT INTO public.paises VALUES ('661184','Malta');
INSERT INTO public.paises VALUES ('661197','Mónaco');
INSERT INTO public.paises VALUES ('661201','Noruega');
INSERT INTO public.paises VALUES ('661218','Países Bajos');
INSERT INTO public.paises VALUES ('661223','Polonia');
INSERT INTO public.paises VALUES ('661239','Portugal');
INSERT INTO public.paises VALUES ('661244','Andorra');
INSERT INTO public.paises VALUES ('661257','Reino Unido');
INSERT INTO public.paises VALUES ('661260','Alemania');
INSERT INTO public.paises VALUES ('661282','Rumanía');
INSERT INTO public.paises VALUES ('661295','San Marino');
INSERT INTO public.paises VALUES ('661309','Santa Sede');
INSERT INTO public.paises VALUES ('661316','Suecia');
INSERT INTO public.paises VALUES ('661321','Suiza');
INSERT INTO public.paises VALUES ('661342','YUGOSLAVIA');
INSERT INTO public.paises VALUES ('661355','Ucrania');
INSERT INTO public.paises VALUES ('661368','Letonia');
INSERT INTO public.paises VALUES ('661374','Moldavia');
INSERT INTO public.paises VALUES ('661380','Belarús');
INSERT INTO public.paises VALUES ('661393','Georgia');
INSERT INTO public.paises VALUES ('661407','AZERBAIDZHAN');
INSERT INTO public.paises VALUES ('661414','Estonia');
INSERT INTO public.paises VALUES ('661429','Lituania');
INSERT INTO public.paises VALUES ('661435','República Checa');
INSERT INTO public.paises VALUES ('661440','República Eslovaca');
INSERT INTO public.paises VALUES ('661453','Bosnia y Herzegovina');
INSERT INTO public.paises VALUES ('661466','Croacia');
INSERT INTO public.paises VALUES ('661472','Eslovenia');
INSERT INTO public.paises VALUES ('661488','Armenia');
INSERT INTO public.paises VALUES ('661491','KAZAJSTAN');
INSERT INTO public.paises VALUES ('661504','KIRGUIZISTAN');
INSERT INTO public.paises VALUES ('661511','TAYIKISTAN');
INSERT INTO public.paises VALUES ('661526','TURKMENISTAN');
INSERT INTO public.paises VALUES ('661532','UZBEKISTAN');
INSERT INTO public.paises VALUES ('661547','RUSIA');
INSERT INTO public.paises VALUES ('661563','Macedonia');
INSERT INTO public.paises VALUES ('661579','Serbia');
INSERT INTO public.paises VALUES ('661585','Montenegro');
INSERT INTO public.paises VALUES ('661990','Otros países de Europa');
INSERT INTO public.paises VALUES ('662011','Burkina Faso');
INSERT INTO public.paises VALUES ('662026','Angola');
INSERT INTO public.paises VALUES ('662032','Argelia');
INSERT INTO public.paises VALUES ('662047','Benin');
INSERT INTO public.paises VALUES ('662050','Botswana');
INSERT INTO public.paises VALUES ('662063','Burundi');
INSERT INTO public.paises VALUES ('662079','Cabo Verde');
INSERT INTO public.paises VALUES ('662085','Camerún');
INSERT INTO public.paises VALUES ('662098','Comores');
INSERT INTO public.paises VALUES ('662102','Congo');
INSERT INTO public.paises VALUES ('662119','Costa de Marfil');
INSERT INTO public.paises VALUES ('662124','Djibouti');
INSERT INTO public.paises VALUES ('662130','Egipto');
INSERT INTO public.paises VALUES ('662145','Etiopía');
INSERT INTO public.paises VALUES ('662158','Gabón');
INSERT INTO public.paises VALUES ('662161','Gambia');
INSERT INTO public.paises VALUES ('662177','Ghana');
INSERT INTO public.paises VALUES ('662183','Guinea');
INSERT INTO public.paises VALUES ('662196','Guinea-Bissau');
INSERT INTO public.paises VALUES ('662200','Guinea Ecuatorial');
INSERT INTO public.paises VALUES ('662217','Kenia');
INSERT INTO public.paises VALUES ('662222','Lesotho');
INSERT INTO public.paises VALUES ('662238','Liberia');
INSERT INTO public.paises VALUES ('662243','Libia');
INSERT INTO public.paises VALUES ('662256','Madagascar');
INSERT INTO public.paises VALUES ('662269','Malawi');
INSERT INTO public.paises VALUES ('662275','Mali');
INSERT INTO public.paises VALUES ('662281','Marruecos');
INSERT INTO public.paises VALUES ('662294','Mauricio');
INSERT INTO public.paises VALUES ('662308','Mauritania');
INSERT INTO public.paises VALUES ('662315','Mozambique');
INSERT INTO public.paises VALUES ('662320','Namibia');
INSERT INTO public.paises VALUES ('662336','Níger');
INSERT INTO public.paises VALUES ('662341','Nigeria');
INSERT INTO public.paises VALUES ('662354','República Centroafricana');
INSERT INTO public.paises VALUES ('662367','Sudáfrica');
INSERT INTO public.paises VALUES ('662373','Ruanda');
INSERT INTO public.paises VALUES ('662389','Santo Tomé y Príncipe');
INSERT INTO public.paises VALUES ('662392','Senegal');
INSERT INTO public.paises VALUES ('662406','Seychelles');
INSERT INTO public.paises VALUES ('662413','Sierra Leona');
INSERT INTO public.paises VALUES ('662428','Somalia');
INSERT INTO public.paises VALUES ('662434','Sudán');
INSERT INTO public.paises VALUES ('662449','Swazilandia');
INSERT INTO public.paises VALUES ('662452','Tanzania');
INSERT INTO public.paises VALUES ('662465','Chad');
INSERT INTO public.paises VALUES ('662471','Togo');
INSERT INTO public.paises VALUES ('662487','Túnez');
INSERT INTO public.paises VALUES ('662490','Uganda');
INSERT INTO public.paises VALUES ('662503','República Democrática del Congo');
INSERT INTO public.paises VALUES ('662510','Zambia');
INSERT INTO public.paises VALUES ('662525','Zimbabwe');
INSERT INTO public.paises VALUES ('662531','Eritrea');
INSERT INTO public.paises VALUES ('662546','Sudán del Sur');
INSERT INTO public.paises VALUES ('662999','Otros países de África');
INSERT INTO public.paises VALUES ('663010','Canadá');
INSERT INTO public.paises VALUES ('663025','Estados Unidos de América');
INSERT INTO public.paises VALUES ('663031','México');
INSERT INTO public.paises VALUES ('663101','Antigua y Barbuda');
INSERT INTO public.paises VALUES ('663118','Bahamas');
INSERT INTO public.paises VALUES ('663123','Barbados');
INSERT INTO public.paises VALUES ('663139','Belice');
INSERT INTO public.paises VALUES ('663144','Costa Rica');
INSERT INTO public.paises VALUES ('663157','Cuba');
INSERT INTO public.paises VALUES ('663160','Dominica');
INSERT INTO public.paises VALUES ('663176','El Salvador');
INSERT INTO public.paises VALUES ('663182','Granada');
INSERT INTO public.paises VALUES ('663195','Guatemala');
INSERT INTO public.paises VALUES ('663209','Haití');
INSERT INTO public.paises VALUES ('663216','Honduras');
INSERT INTO public.paises VALUES ('663221','Jamaica');
INSERT INTO public.paises VALUES ('663237','Nicaragua');
INSERT INTO public.paises VALUES ('663242','Panamá');
INSERT INTO public.paises VALUES ('663255','San Vicente y las Granadinas');
INSERT INTO public.paises VALUES ('663268','República Dominicana');
INSERT INTO public.paises VALUES ('663274','Trinidad y Tobago');
INSERT INTO public.paises VALUES ('663280','Santa Lucía');
INSERT INTO public.paises VALUES ('663293','San Cristóbal y Nieves');
INSERT INTO public.paises VALUES ('663405','Argentina');
INSERT INTO public.paises VALUES ('663412','Bolivia');
INSERT INTO public.paises VALUES ('663427','Brasil');
INSERT INTO public.paises VALUES ('663433','Colombia');
INSERT INTO public.paises VALUES ('663448','Chile');
INSERT INTO public.paises VALUES ('663451','Ecuador');
INSERT INTO public.paises VALUES ('663464','Guyana');
INSERT INTO public.paises VALUES ('663470','Paraguay');
INSERT INTO public.paises VALUES ('663486','Perú');
INSERT INTO public.paises VALUES ('663499','Surinam');
INSERT INTO public.paises VALUES ('663502','Uruguay');
INSERT INTO public.paises VALUES ('663519','Venezuela');
INSERT INTO public.paises VALUES ('663998','Otros países de América');
INSERT INTO public.paises VALUES ('664019','Afganistán');
INSERT INTO public.paises VALUES ('664024','Arabia Saudí');
INSERT INTO public.paises VALUES ('664030','Bahréin');
INSERT INTO public.paises VALUES ('664045','Bangladesh');
INSERT INTO public.paises VALUES ('664058','Myanmar');
INSERT INTO public.paises VALUES ('664061','BUTHAN');
INSERT INTO public.paises VALUES ('664077','China');
INSERT INTO public.paises VALUES ('664083','Emiratos Árabes Unidos');
INSERT INTO public.paises VALUES ('664096','Filipinas');
INSERT INTO public.paises VALUES ('664100','India');
INSERT INTO public.paises VALUES ('664117','Indonesia');
INSERT INTO public.paises VALUES ('664122','Iraq');
INSERT INTO public.paises VALUES ('664138','Irán');
INSERT INTO public.paises VALUES ('664143','Israel');
INSERT INTO public.paises VALUES ('664156','Japón');
INSERT INTO public.paises VALUES ('664169','Jordania');
INSERT INTO public.paises VALUES ('664175','Camboya');
INSERT INTO public.paises VALUES ('664181','Kuwait');
INSERT INTO public.paises VALUES ('664194','Laos');
INSERT INTO public.paises VALUES ('664208','Líbano');
INSERT INTO public.paises VALUES ('664215','Malasia');
INSERT INTO public.paises VALUES ('664220','Maldivas');
INSERT INTO public.paises VALUES ('664236','Mongolia');
INSERT INTO public.paises VALUES ('664241','Nepal');
INSERT INTO public.paises VALUES ('664254','Omán');
INSERT INTO public.paises VALUES ('664267','Pakistán');
INSERT INTO public.paises VALUES ('664273','Qatar');
INSERT INTO public.paises VALUES ('664289','YEMEN (R.A.)');
INSERT INTO public.paises VALUES ('664292','YEMEN (R.D.P.)');
INSERT INTO public.paises VALUES ('664306','Corea');
INSERT INTO public.paises VALUES ('664313','Corea del Norte');
INSERT INTO public.paises VALUES ('664328','Singapur');
INSERT INTO public.paises VALUES ('664334','Siria');
INSERT INTO public.paises VALUES ('664349','Sri Lanka');
INSERT INTO public.paises VALUES ('664352','Tailandia');
INSERT INTO public.paises VALUES ('664365','Turquía');
INSERT INTO public.paises VALUES ('664371','Vietnam');
INSERT INTO public.paises VALUES ('664387','TAIWAN');
INSERT INTO public.paises VALUES ('664390','Brunei');
INSERT INTO public.paises VALUES ('664903','MACAO');
INSERT INTO public.paises VALUES ('665018','Australia');
INSERT INTO public.paises VALUES ('665023','Fiji');
INSERT INTO public.paises VALUES ('665039','NAURU');
INSERT INTO public.paises VALUES ('665044','Nueva Zelanda');
INSERT INTO public.paises VALUES ('665057','Papúa Nueva Guinea');
INSERT INTO public.paises VALUES ('665060','Islas Salomón');
INSERT INTO public.paises VALUES ('665076','Samoa');
INSERT INTO public.paises VALUES ('665082','Tonga');
INSERT INTO public.paises VALUES ('665095','Vanuatu');
INSERT INTO public.paises VALUES ('665109','KIRIBATI');
INSERT INTO public.paises VALUES ('665556','APATRIDAS');
INSERT INTO public.paises VALUES ('669663','OTROS TERR. ESP');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment