• Home
• de.alpharogroup
• address-book-init
• 3.6.0
• source code
• insertCountries.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

dll.inserts.insertCountries.sql Maven / Gradle / Ivy

INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (1,'AF','AFG','004','af.afg');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (2,'AX','ALA','248','ax.ala');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (3,'AL','ALB','008','al.alb');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (4,'DZ','DZA','012','dz.dza');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (5,'AS','ASM','016','as.asm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (6,'AD','AND','020','ad.and');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (7,'AO','AGO','024','ao.ago');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (8,'AI','AIA','660','ai.aia');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (9,'AQ','ATA','010','aq.ata');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (10,'AG','ATG','028','ag.atg');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (11,'AR','ARG','032','ar.arg');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (12,'AM','ARM','051','am.arm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (13,'AW','ABW','533','aw.abw');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (14,'AU','AUS','036','au.aus');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (15,'AT','AUT','040','at.aut');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (16,'AZ','AZE','031','az.aze');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (17,'BS','BHS','044','bs.bhs');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (18,'BH','BHR','048','bh.bhr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (19,'BD','BGD','050','bd.bgd');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (20,'BB','BRB','052','bb.brb');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (21,'BY','BLR','112','by.blr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (22,'BE','BEL','056','be.bel');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (23,'BZ','BLZ','084','bz.blz');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (24,'BJ','BEN','204','bj.ben');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (25,'BM','BMU','060','bm.bmu');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (26,'BT','BTN','064','bt.btn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (27,'BO','BOL','068','bo.bol');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (28,'BA','BIH','070','ba.bih');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (29,'BW','BWA','072','bw.bwa');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (30,'BV','BVT','074','bv.bvt');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (31,'BR','BRA','076','br.bra');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (32,'IO','IOT','086','io.iot');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (33,'BN','BRN','096','bn.brn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (34,'BG','BGR','100','bg.bgr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (35,'BF','BFA','854','bf.bfa');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (36,'BI','BDI','108','bi.bdi');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (37,'KH','KHM','116','kh.khm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (38,'CM','CMR','120','cm.cmr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (39,'CA','CAN','124','ca.can');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (40,'CV','CPV','132','cv.cpv');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (41,'KY','CYM','136','ky.cym');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (42,'CF','CAF','140','cf.caf');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (43,'TD','TCD','148','td.tcd');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (44,'CL','CHL','152','cl.chl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (45,'CN','CHN','156','cn.chn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (46,'CX','CXR','162','cx.cxr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (47,'CC','CCK','166','cc.cck');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (48,'CO','COL','170','co.col');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (49,'KM','COM','174','km.com');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (50,'CG','COG','178','cg.cog');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (51,'CD','COD','180','cd.cod');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (52,'CK','COK','184','ck.cok');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (53,'CR','CRI','188','cr.cri');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (54,'CI','CIV','384','ci.civ');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (55,'HR','HRV','191','hr.hrv');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (56,'CU','CUB','192','cu.cub');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (57,'CY','CYP','196','cy.cyp');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (58,'CZ','CZE','203','cz.cze');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (59,'DK','DNK','208','dk.dnk');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (60,'DJ','DJI','262','dj.dji');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (61,'DM','DMA','212','dm.dma');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (62,'DO','DOM','214','do.dom');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (63,'EC','ECU','218','ec.ecu');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (64,'EG','EGY','818','eg.egy');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (65,'SV','SLV','222','sv.slv');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (66,'GQ','GNQ','226','gq.gnq');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (67,'ER','ERI','232','er.eri');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (68,'EE','EST','233','ee.est');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (69,'ET','ETH','231','et.eth');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (70,'FK','FLK','238','fk.flk');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (71,'FO','FRO','234','fo.fro');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (72,'FJ','FJI','242','fj.fji');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (73,'FI','FIN','246','fi.fin');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (74,'FR','FRA','250','fr.fra');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (75,'GF','GUF','254','gf.guf');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (76,'PF','PYF','258','pf.pyf');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (77,'TF','ATF','260','tf.atf');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (78,'GA','GAB','266','ga.gab');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (79,'GM','GMB','270','gm.gmb');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (80,'GE','GEO','268','ge.geo');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (81,'DE','DEU','276','de.deu');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (82,'GH','GHA','288','gh.gha');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (83,'GI','GIB','292','gi.gib');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (84,'GR','GRC','300','gr.grc');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (85,'GL','GRL','304','gl.grl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (86,'GD','GRD','308','gd.grd');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (87,'GP','GLP','312','gp.glp');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (88,'GU','GUM','316','gu.gum');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (89,'GT','GTM','320','gt.gtm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (90,'GG','GGY','831','gg.ggy');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (91,'GN','GIN','324','gn.gin');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (92,'GW','GNB','624','gw.gnb');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (93,'GY','GUY','328','gy.guy');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (94,'HT','HTI','332','ht.hti');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (95,'HM','HMD','334','hm.hmd');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (96,'VA','VAT','336','va.vat');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (97,'HN','HND','340','hn.hnd');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (98,'HK','HKG','344','hk.hkg');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (99,'HU','HUN','348','hu.hun');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (100,'IS','ISL','352','is.isl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (101,'IN','IND','356','in.ind');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (102,'ID','IDN','360','id.idn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (103,'IR','IRN','364','ir.irn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (104,'IQ','IRQ','368','iq.irq');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (105,'IE','IRL','372','ie.irl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (106,'IM','IMM','833','im.imm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (107,'IL','ISR','376','il.isr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (108,'IT','ITA','380','it.ita');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (109,'JM','JAM','388','jm.jam');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (110,'JP','JPN','392','jp.jpn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (111,'JE','JEY','832','je.jey');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (112,'JO','JOR','400','jo.jor');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (113,'KZ','KAZ','398','kz.kaz');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (114,'KE','KEN','404','ke.ken');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (115,'KI','KIR','296','ki.kir');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (116,'KP','PRK','408','kp.prk');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (117,'KR','KOR','410','kr.kor');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (118,'KW','KWT','414','kw.kwt');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (119,'KG','KGZ','417','kg.kgz');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (120,'LA','LAO','418','la.lao');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (121,'LV','LVA','428','lv.lva');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (122,'LB','LBN','422','lb.lbn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (123,'LS','LSO','426','ls.lso');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (124,'LR','LBR','430','lr.lbr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (125,'LY','LBY','434','ly.lby');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (126,'LI','LIE','438','li.lie');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (127,'LT','LTU','440','lt.ltu');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (128,'LU','LUX','442','lu.lux');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (129,'MO','MAC','446','mo.mac');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (130,'MK','MKD','807','mk.mkd');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (131,'MG','MDG','450','mg.mdg');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (132,'MW','MWI','454','mw.mwi');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (133,'MY','MYS','458','my.mys');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (134,'MV','MDV','462','mv.mdv');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (135,'ML','MLI','466','ml.mli');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (136,'MT','MLT','470','mt.mlt');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (137,'MH','MHL','584','mh.mhl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (138,'MQ','MTQ','474','mq.mtq');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (139,'MR','MRT','478','mr.mrt');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (140,'MU','MUS','480','mu.mus');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (141,'YT','MYT','175','yt.myt');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (142,'MX','MEX','484','mx.mex');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (143,'FM','FSM','583','fm.fsm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (144,'MD','MDA','498','md.mda');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (145,'MC','MCO','492','mc.mco');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (146,'MN','MNG','496','mn.mng');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (147,'ME','MNE','499','me.mne');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (148,'MS','MSR','500','ms.msr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (149,'MA','MAR','504','ma.mar');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (150,'MZ','MOZ','508','mz.moz');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (151,'MM','MMR','104','mm.mmr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (152,'NA','NAM','516','na.nam');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (153,'NR','NRU','520','nr.nru');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (154,'NP','NPL','524','np.npl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (155,'NL','NLD','528','nl.nld');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (156,'AN','ANT','530','an.ant');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (157,'NC','NCL','540','nc.ncl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (158,'NZ','NZL','554','nz.nzl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (159,'NI','NIC','558','ni.nic');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (160,'NE','NER','562','ne.ner');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (161,'NG','NGA','566','ng.nga');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (162,'NU','NIU','570','nu.niu');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (163,'NF','NFK','574','nf.nfk');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (164,'MP','MNP','580','mp.mnp');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (165,'NO','NOR','578','no.nor');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (166,'OM','OMN','512','om.omn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (167,'PK','PAK','586','pk.pak');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (168,'PW','PLW','585','pw.plw');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (169,'PS','PSE','275','ps.pse');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (170,'PA','PAN','591','pa.pan');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (171,'PG','PNG','598','pg.png');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (172,'PY','PRY','600','py.pry');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (173,'PE','PER','604','pe.per');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (174,'PH','PHL','608','ph.phl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (175,'PN','PCN','612','pn.pcn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (176,'PL','POL','616','pl.pol');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (177,'PT','PRT','620','pt.prt');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (178,'PR','PRI','630','pr.pri');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (179,'QA','QAT','634','qa.qat');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (180,'RE','REU','638','re.reu');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (181,'RO','ROU','642','ro.rou');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (182,'RU','RUS','643','ru.rus');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (183,'RW','RWA','646','rw.rwa');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (184,'BL','BLM','652','bl.blm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (185,'SH','SHN','654','sh.shn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (186,'KN','KNA','659','kn.kna');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (187,'LC','LCA','662','lc.lca');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (188,'MT','MAF','663','mt.maf');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (189,'PM','SPM','666','pm.spm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (190,'VC','VCT','670','vc.vct');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (191,'WS','WSM','882','ws.wsm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (192,'SM','SMR','674','sm.smr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (193,'ST','STP','678','st.stp');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (194,'SA','SAU','682','sa.sau');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (195,'SN','SEN','686','sn.sen');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (196,'RS','SRB','688','rs.srb');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (197,'SC','SYC','690','sc.syc');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (198,'SL','SLE','694','sl.sle');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (199,'SG','SGP','702','sg.sgp');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (200,'SK','SVK','703','sk.svk');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (201,'SI','SVN','705','si.svn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (202,'SB','SLB','090','sb.slb');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (203,'SO','SOM','706','so.som');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (204,'ZA','ZAF','710','za.zaf');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (205,'GS','SGS','239','gs.sgs');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (206,'ES','ESP','724','es.esp');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (207,'LK','LKA','144','lk.lka');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (208,'SD','SDN','736','sd.sdn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (209,'SR','SUR','740','sr.sur');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (210,'SJ','SJM','744','sj.sjm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (211,'SZ','SWZ','748','sz.swz');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (212,'SE','SWE','752','se.swe');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (213,'CH','CHE','756','ch.che');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (214,'SY','SYR','760','sy.syr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (215,'TW','TWN','158','tw.twn');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (216,'TJ','TJK','762','tj.tjk');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (217,'TZ','TZA','834','tz.tza');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (218,'TH','THA','764','th.tha');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (219,'TL','TLS','626','tl.tls');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (220,'TG','TGO','768','tg.tgo');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (221,'TK','TKL','772','tk.tkl');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (222,'TO','TON','776','to.ton');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (223,'TT','TTO','780','tt.tto');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (224,'TN','TUN','788','tn.tun');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (225,'TR','TUR','792','tr.tur');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (226,'TM','TKM','795','tm.tkm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (227,'TC','TCA','796','tc.tca');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (228,'TV','TUV','798','tv.tuv');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (229,'UG','UGA','800','ug.uga');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (230,'UA','UKR','804','ua.ukr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (231,'AE','ARE','784','ae.are');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (232,'GB','GBR','826','gb.gbr');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (233,'US','USA','840','us.usa');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (234,'UM','UMI','581','um.umi');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (235,'UY','URY','858','uy.ury');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (236,'UZ','UZB','860','uz.uzb');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (237,'VU','VUT','548','vu.vut');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (238,'VA','VAT','336','va.vat');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (239,'VE','VEN','862','ve.ven');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (240,'VN','VNM','704','vn.vnm');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (241,'VG','VGB','092','vg.vgb');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (242,'VI','VIR','850','vi.vir');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (243,'WF','WLF','876','wf.wlf');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (244,'EH','ESH','732','eh.esh');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (245,'YE','YEM','887','ye.yem');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (246,'YU','YUG','891','yu.yug');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (247,'ZM','ZMB','894','zm.zmb');
INSERT INTO countries (id,iso3166_a2name,iso3166_a3name,iso3166_number,name) VALUES (248,'ZW','ZWE','716','zw.zwe');