Veel mensen hebben er moeite mee.
Voor een of andere web applicatie heb je om een of andere reden een overzicht nodig van de Nederlandse landnamen, maar verder wel volgens het ISO formaat.
Nog erger is het, omdat er op de Nederlandse Wikipedia, op de pagina van de juiste ISO code een Nederlandstalige tabel staat, al is hij verder niet als .SQL beschikbaar.
Nadat ik deze tabel nodig had, heb ik er, met regexp replacements, een versie gemaakt met alle landennamen, in .SQL formaat.
Je mag hem zelf gebruiken, maar link a.u.b. terug naar mij, ik ben er toch een tijd aan bezig geweest…
Dit is vanaf nu hier te bekijken, op de volgende pagina:
CREATE TABLE IF NOT EXISTS nlcountry (
iso CHAR(2) NOT NULL PRIMARY KEY,
printable_name VARCHAR(80) NOT NULL,
iso3 CHAR(3),
numcode SMALLINT
);
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AF','Afghanistan','AFG','004');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AL','Albanië','ALB','008');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('DZ','Algerije','DZA','012');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AS','Amerikaans-Samoa','ASM','016');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AD','Andorra','AND','020');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AO','Angola','AGO','024');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AG','Antigua en Barbuda','ATG','028');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AR','Argentinië','ARG','032');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AM','Armenië','ARM','051');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AW','Aruba','ABW','533');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BH','Bahrein','BHR','048');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BD','Bangladesh','BGD','050');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BE','België','BEL','056');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BZ','Belize (land)','BLZ','084');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BJ','Benin','BEN','204');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BT','Bhutan','BTN','064');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BO','Bolivia','BOL','068');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BA','Bosnië-Herzegovina','BIH','070');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BV','Bouvet','BVT','074');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BN','Brunei','BRN','096');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CA','Canada','CAN','124');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CL','Chili','CHL','152');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CN','Volksrepubliek China','CHN','156');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CU','Cuba','CUB','192');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CY','Cyprus','CYP','196');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('EG','Egypte','EGY','818');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('EE','Estland','EST','233');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('FO','Faeröer','FRO','234');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('FJ','Fiji','FJI','242');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PH','Filipijnen','PHL','608');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('FR','Frankrijk','FRA','250');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GF','Frans-Guyana','GUF','254');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GA','Gabon','GAB','266');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GM','Gambia (land)','GMB','270');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GE','Georgië','GEO','268');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GH','Ghana','GHA','288');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GR','Griekenland','GRC','300');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GD','Grenada','GRD','308');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GU','Guam','GUM','316');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GN','Guinee','GIN','324');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GY','Guyana','GUY','328');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('HT','Haïti','HTI','332');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('HU','Hongarije','HUN','348');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('IS','IJsland','ISL','352');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('IR','Iran','IRN','364');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('IQ','Irak','IRQ','368');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('IE','Ierse Republiek','IRL','372');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('IT','Italië','ITA','380');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CI','Ivoorkust','CIV','384');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('JM','Jamaica','JAM','388');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('JP','Japan','JPN','392');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('YE','Jemen','YEM','887');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CM','Kameroen','CMR','120');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CV','Kaapverdië','CPV','132');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KZ','Kazachstan','KAZ','398');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KI','Kiribati','KIR','296');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('HR','Kroatië','HRV','191');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KW','Koeweit','KWT','414');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KG','Kirgizië','KGZ','417');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LA','Laos','LAO','418');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LV','Letland','LVA','428');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LS','Lesotho','LSO','426');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LY','Libië','LBY','434');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MG','Madagaskar','MDG','450');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MW','Malawi','MWI','454');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('ML','Mali','MLI','466');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('YT','Mayotte','MYT','175');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MX','Mexico (land)','MEX','484');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MC','Monaco','MCO','492');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MS','Montserrat','MSR','500');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MA','Marokko','MAR','504');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MZ','Mozambique','MOZ','508');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MM','Myanmar','MMR','104');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NA','Namibië','NAM','516');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NR','Nauru','NRU','520');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NP','Nepal','NPL','524');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NZ','Nieuw-Zeeland','NZL','554');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NI','Nicaragua','NIC','558');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NE','Niger (land)','NER','562');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NG','Nigeria','NGA','566');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('UZ','Oezbekistan','UZB','860');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NO','Noorwegen','NOR','578');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('OM','Oman','OMN','512');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('UG','Oeganda','UGA','800');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AT','Oostenrijk','AUT','040');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TL','Oost-Timor','TLS','626');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PK','Pakistan','PAK','586');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PW','Palau (land)','PLW','585');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PS','Palestina','PSE','275');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PA','Panama (land)','PAN','591');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PY','Paraguay','PRY','600');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PE','Peru','PER','604');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PL','Polen','POL','616');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PR','Puerto Rico','PRI','630');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('QA','Qatar','QAT','634');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('RO','Roemenië','ROU','642');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('RU','Rusland','RUS','643');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('RW','Rwanda','RWA','646');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('EH','Westelijke Sahara','ESH','732');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LC','Saint Lucia','LCA','662');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('WS','Samoa','WSM','882');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SM','San Marino','SMR','674');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SN','Senegal','SEN','686');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SC','Seychellen','SYC','690');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SL','Sierra Leone','SLE','694');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SG','Singapore','SGP','702');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SH','Sint Helena','SHN','654');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SK','Slowakije','SVK','703');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SI','Slovenië','SVN','705');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SB','Solomon Eilanden','SLB','090');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SO','Somalië','SOM','706');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('ES','Spanje','ESP','724');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LK','Sri Lanka','LKA','144');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SD','Soedan','SDN','736');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SR','Suriname','SUR','740');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SY','Syrië','SYR','760');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TJ','Tadzjikistan','TJK','762');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TW','Taiwan','TWN','158');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TH','Thailand','THA','764');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TG','Togo','TGO','768');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TO','Tonga (land)','TON','776');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TD','Tsjaad','TCD','148');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TN','Tunesië','TUN','788');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TR','Turkije','TUR','792');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TM','Turkmenistan','TKM','795');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TV','Tuvalu','TUV','798');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('UY','Uruguay','URY','858');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('VU','Vanuatu','VUT','548');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('VE','Venezuela','VEN','862');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('VN','Vietnam','VNM','704');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('ZM','Zambia','ZMB','894');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('ZW','Zimbabwe','ZWE','716');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SE','Zweden','SWE','752');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CH','Zwitserland','CHE','756');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('VI','Amerikaanse Maagdeneilanden','VIR','850');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AI','Anguilla','AIA','660');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AQ','Antarctica','ATA','010');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AU','Australië','AUS','036');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AZ','Azerbeidzjan','AZE','031');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BS','Bahama\'s','BHS','044');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BB','Barbados','BRB','052');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BM','Bermuda','BMU','060');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BW','Botswana','BWA','072');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BR','Brazilië','BRA','076');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('VG','Britse Maagdeneilanden','VGB','092');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('IO','Brits IO Territorium','VGB','092');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BG','Bulgarije','BGR','100');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BF','Burkina Faso','BFA','854');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BI','Burundi','BDI','108');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KH','Cambodja','KHM','116');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CF','Centraal-Afrikaanse Republiek','CAF','140');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CX','Christmaseiland','CXR','162');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CC','Cocoseilanden','CCK','166');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CO','Colombia','COL','170');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KM','Comoren','COM','174');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CG','Congo-Brazzaville','COG','178');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CD','Congo-Kinshasa','COD','180');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CK','Cookeilanden','COK','184');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CR','Costa Rica','CRI','188');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('DK','Denemarken','DNK','208');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('DJ','Djibouti','DJI','262');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('DM','Dominica','DMA','212');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('DO','Dominicaanse Republiek','DOM','214');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('DE','Duitsland','DEU','276');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('EC','Ecuador','ECU','218');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SV','El Salvador','SLV','222');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GQ','Equatoriaal-Guinea','GNQ','226');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('ER','Eritrea','ERI','232');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('ET','Ethiopië','ETH','231');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('FK','Falklandeilanden','FLK','238');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('FI','Finland','FIN','246');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PF','Frans-Polynesië','PYF','258');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TF','Franse Zuidelijke Gebieden','ATF','260');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GI','Gibraltar','GIB','292');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GL','Groenland','GRL','304');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GP','Guadeloupe','GLP','312');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GT','Guatemala','GTM','320');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GW','Guinee-Bissau','GNB','624');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('HM','Heard- en McDonaldeilanden','HMD','334');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('HN','Honduras','HND','340');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('HK','Hongkong','HKG','344');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('IN','India','IND','356');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('ID','Indonesië','IDN','360');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('IM','Isle of Man','','833');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('IL','Israël','ISR','376');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('JO','Jordanië','JOR','400');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KY','Caymaneilanden','CYM','136');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KE','Kenia','KEN','404');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KP','Noord-Korea','PRK','408');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LB','Libanon','LBN','422');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LR','Liberia','LBR','430');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LI','Liechtenstein','LIE','438');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LT','Litouwen','LTU','440');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('LU','Luxemburg','LUX','442');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MO','Macao','MAC','446');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MK','Macedonië','MKD','807');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MY','Maleisië','MYS','458');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MV','Maldiven','MDV','462');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MT','Malta','MLT','470');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MQ','Martinique','MTQ','474');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MR','Mauritanië','MRT','478');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MU','Mauritius','MUS','480');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('FM','Micronesia','FSM','583');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MD','Moldavië','MDA','498');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MN','Mongolië','MNG','496');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NL','Nederland','NLD','528');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AN','Nederlandse Antillen','ANT','530');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NC','Nieuw-Caledonië','NCL','540');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NU','Niue','NIU','570');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('NF','Norfolkeiland','NFK','574');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MP','Noordelijke Marianen','MNP','580');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('UA','Oekraïne','UKR','804');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PG','Papoea-Nieuw-Guinea','PNG','598');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PN','Pitcairn','PCN','612');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PT','Portugal','PRT','620');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('RE','Réunion','REU','638');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KN','Saint Kitts en Nevis','KNA','659');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('PM','Saint-Pierre en Miquelon','SPM','666');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('VC','Saint Vincent en de Grenadines','VCT','670');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GS','Sandwich Eilanden','SGS','239');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('ST','São Tomé en Principe','STP','678');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SA','Saoedi-Arabië','SAU','682');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CS','Servië en Montenegro','SCG','891');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SJ','Jan Mayen','SJM','744');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('SZ','Swaziland','SWZ','748');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TZ','Tanzania','TZA','834');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TK','Tokelau','TKL','772');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TT','Trinidad en Tobago','TTO','780');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('CZ','Tsjechië','CZE','203');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('TC','Turks en Caicos eilanden','TCA','796');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('AE','Verenigde Arabische Emiraten','ARE','784');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('GB','Verenigd Koninkrijk','GBR','826');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('US','Verenigde Staten van Amerika','USA','840');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('VA','Vaticaanstad','VAT','336');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('WF','Wallis en Futuna','WLF','876');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('BY','Wit-Rusland','BLR','112');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('ZA','Zuid-Afrika','ZAF','710');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('KR','Zuid-Korea','KOR','410');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('MH','Marshalleilanden','MHL','584');
INSERT INTO nlcountry (iso,printable_name,iso3,numcode) VALUES ('UM','Kleine Pacifische eilanden VS','UMI','581');
1 comment
Wim says:
June 22, 2011 at 11:09 pm (UTC 1)
Bedankt voor deze lijst, ik heb ‘m uitgbreidt met de telnrs. (kan “null” zijn)
Misschien ook iets voor anderen…
ID is een technische sleutel.
Heb een shortlist kolom toegevoegd om zo eventueel een voor de gebruiker wat meer handzame lijst te kunnen presenteren.
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(1,’Afghanistan’,’4′,93,’AF’,'AFG’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(2,’Albanië’,’8′,355,’AL’,'ALB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(3,’Algerije’,’12′,213,’DZ’,'DZA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(4,’Amerikaanse Maagdeneilanden’,’16′,1340,’VI’,'VIR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(5,’Amerikaans-Samoa’,’20′,684,’AS’,'ASM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(6,’Andorra’,’24′,376,’AD’,'AND’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(7,’Angola’,’28′,244,’AO’,'AGO’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(8,’Anguilla’,’32′,1264,’AI’,'AIA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(9,’Antarctica’,’51′,672,’AQ’,'ATA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(10,’Antigua en Barbuda’,’533′,1268,’AG’,'ATG’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(11,’Argentinië’,’48′,54,’AR’,'ARG’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(12,’Armenië’,’50′,374,’AM’,'ARM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(13,’Aruba’,’56′,297,’AW’,'ABW’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(14,’Australië’,’84′,61,’AU’,'AUS’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(15,’Azerbeidzjan’,’204′,994,’AZ’,'AZE’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(16,’Bahama`s’,’64′,1242,’BS’,'BHS’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(17,’Bahrein’,’68′,973,’BH’,'BHR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(18,’Bangladesh’,’70′,880,’BD’,'BGD’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(19,’Barbados’,’74′,1246,’BB’,'BRB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(20,’België’,’96′,32,’BE’,'BEL’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(21,’Belize’,’124′,501,’BZ’,'BLZ’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(22,’Benin’,’152′,229,’BJ’,'BEN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(23,’Bermuda’,’156′,1441,’BM’,'BMU’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(24,’Bhutan’,’192′,975,’BT’,'BTN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(25,’Bolivia’,’196′,591,’BO’,'BOL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(26,’Bosnië-Herzegovina’,’818′,387,’BA’,'BIH’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(27,’Botswana’,’233′,267,’BW’,'BWA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(28,’Bouvet’,’234′,null,’BV’,'BVT’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(29,’Brazilië’,’242′,55,’BR’,'BRA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(30,’Britse Maagdeneilanden’,’250′,1284,’VG’,'VGB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(31,’Brunei’,’254′,673,’BN’,'BRN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(32,’Bulgarije’,’266′,359,’BG’,'BGR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(33,’Burkina Faso’,’270′,226,’BF’,'BFA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(34,’Burundi’,’268′,257,’BI’,'BDI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(35,’Cambodja’,’288′,855,’KH’,'KHM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(36,’Canada’,’300′,1,’CA’,'CAN’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(37,’Caymaneilanden’,’308′,1345,’KY’,'CYM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(38,’Centraal-Afrikaanse Republiek’,’316′,236,’CF’,'CAF’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(39,’Chili’,’324′,56,’CL’,'CHL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(40,’China’,’784′,86,’CN’,'CHN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(41,’Christmaseiland’,’328′,null,’CX’,'CXR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(42,’Cocoseilanden’,’332′,null,’CC’,'CCK’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(43,’Colombia’,’348′,57,’CO’,'COL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(44,’Comoren’,’352′,269,’KM’,'COM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(45,’Congo-Brazzaville’,’364′,242,’CG’,'COG’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(46,’Congo-Kinshasa’,’368′,243,’CD’,'COD’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(47,’Cookeilanden’,’372′,682,’CK’,'COK’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(48,’Costa Rica’,’380′,506,’CR’,'CRI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(49,’Cuba’,’384′,53,’CU’,'CUB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(50,’Cyprus’,’388′,357,’CY’,'CYP’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(51,’Denemarken’,’392′,45,’DK’,'DNK’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(52,’Djibouti’,’887′,253,’DJ’,'DJI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(53,’Dominica’,’120′,1767,’DM’,'DMA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(54,’Dominicaanse Republiek’,’132′,1809,’DO’,'DOM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(55,’Duitsland’,’398′,49,’DE’,'DEU’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(56,’Ecuador’,’296′,593,’EC’,'ECU’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(57,’Egypte’,’191′,20,’EG’,'EGY’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(58,’El Salvador’,’414′,503,’SV’,'SLV’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(59,’Equatoriaal-Guinea’,’417′,240,’GQ’,'GNQ’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(60,’Eritrea’,’418′,291,’ER’,'ERI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(61,’Estland’,’428′,372,’EE’,'EST’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(62,’Ethiopië’,’426′,251,’ET’,'ETH’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(63,’Faeröer’,’434′,298,’FO’,'FRO’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(64,’Falklandeilanden’,’450′,500,’FK’,'FLK’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(65,’Fiji’,’454′,679,’FJ’,'FJI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(66,’Filipijnen’,’466′,63,’PH’,'PHL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(67,’Finland’,’175′,358,’FI’,'FIN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(68,’Frankrijk’,’484′,33,’FR’,'FRA’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(69,’Franse Zuidelijke Gebieden’,’492′,null,’TF’,'ATF’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(70,’Frans-Guyana’,’500′,594,’GF’,'GUF’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(71,’Frans-Polynesië’,’504′,689,’PF’,'PYF’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(72,’Gabon’,’508′,241,’GA’,'GAB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(73,’Gambia’,’104′,220,’GM’,'GMB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(74,’Georgië’,’516′,995,’GE’,'GEO’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(75,’Ghana’,’520′,233,’GH’,'GHA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(76,’Gibraltar’,’524′,350,’GI’,'GIB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(77,’Grenada’,’554′,1473,’GD’,'GRD’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(78,’Griekenland’,’558′,30,’GR’,'GRC’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(79,’Groenland’,’562′,299,’GL’,'GRL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(80,’Guadeloupe’,’566′,590,’GP’,'GLP’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(81,’Guam’,’860′,1671,’GU’,'GUM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(82,’Guatemala’,’578′,502,’GT’,'GTM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(83,’Guinee’,’512′,224,’GN’,'GIN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(84,’Guinee-Bissau’,’800′,245,’GW’,'GNB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(85,’Guyana’,’40′,592,’GY’,'GUY’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(86,’Haïti’,’626′,509,’HT’,'HTI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(87,’Heard- en McDonaldeilanden’,’586′,null,’HM’,'HMD’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(88,’Honduras’,’585′,504,’HN’,'HND’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(89,’Hongarije’,’275′,36,’HU’,'HUN’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(90,’Hongkong’,’591′,852,’HK’,'HKG’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(91,’Ierland’,’600′,353,’IE’,'IRL’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(92,’IJsland’,’604′,354,’IS’,'ISL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(93,’India’,’616′,91,’IN’,'IND’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(94,’Indonesië’,’630′,62,’ID’,'IDN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(95,’Irak’,’634′,964,’IQ’,'IRQ’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(96,’Iran’,’642′,98,’IR’,'IRN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(97,’Isle of Man’,’643′,null,’IM’,”,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(98,’Israël’,’646′,972,’IL’,'ISR’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(99,’Italië’,’732′,39,’IT’,'ITA’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(100,’Ivoorkust’,’662′,225,’CI’,'CIV’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(101,’Jamaica’,’882′,1876,’JM’,'JAM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(102,’Jan Mayen’,’674′,null,’SJ’,'SJM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(103,’Japan’,’686′,81,’JP’,'JPN’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(104,’Jemen’,’690′,967,’YE’,'YEM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(105,’Jordanië’,’694′,962,’JO’,'JOR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(106,’Kaapverdië’,’702′,238,’CV’,'CPV’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(107,’Kameroen’,’654′,237,’CM’,'CMR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(108,’Kazachstan’,’703′,7,’KZ’,'KAZ’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(109,’Kenia’,’705′,254,’KE’,'KEN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(110,’Kirgizië’,’90′,996,’KG’,'KGZ’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(111,’Kiribati’,’706′,686,’KI’,'KIR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(112,’Kleine Pacifische eilanden VS’,’724′,null,’UM’,'UMI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(113,’Koeweit’,’144′,965,’KW’,'KWT’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(114,’Kroatië’,’736′,385,’HR’,'HRV’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(115,’Laos’,’740′,856,’LA’,'LAO’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(116,’Lesotho’,’760′,266,’LS’,'LSO’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(117,’Letland’,’762′,371,’LV’,'LVA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(118,’Libanon’,’158′,961,’LB’,'LBN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(119,’Liberia’,’764′,231,’LR’,'LBR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(120,’Libië’,’768′,218,’LY’,'LBY’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(121,’Liechtenstein’,’776′,423,’LI’,'LIE’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(122,’Litouwen’,’148′,370,’LT’,'LTU’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(123,’Luxemburg’,’788′,352,’LU’,'LUX’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(124,’Macao’,’792′,853,’MO’,'MAC’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(125,’Macedonië’,’795′,389,’MK’,'MKD’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(126,’Madagaskar’,’798′,261,’MG’,'MDG’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(127,’Malawi’,’858′,265,’MW’,'MWI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(128,’Maldiven’,’548′,960,’MV’,'MDV’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(129,’Maleisië’,’862′,60,’MY’,'MYS’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(130,’Mali’,’704′,223,’ML’,'MLI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(131,’Malta’,’894′,356,’MT’,'MLT’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(132,’Marokko’,’716′,212,’MA’,'MAR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(133,’Marshalleilanden’,’752′,692,’MH’,'MHL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(134,’Martinique’,’756′,596,’MQ’,'MTQ’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(135,’Mauritanië’,’850′,222,’MR’,'MRT’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(136,’Mauritius’,’660′,230,’MU’,'MUS’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(137,’Mayotte’,’10′,2696,’YT’,'MYT’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(138,’Mexico’,’36′,52,’MX’,'MEX’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(139,’Micronesia’,’31′,691,’FM’,'FSM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(140,’Moldavië’,’44′,373,’MD’,'MDA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(141,’Monaco’,’52′,377,’MC’,'MCO’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(142,’Mongolië’,’60′,976,’MN’,'MNG’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(143,’Montserrat’,’72′,1664,’MS’,'MSR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(144,’Mozambique’,’76′,258,’MZ’,'MOZ’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(145,’Myanmar’,’92′,95,’MM’,'MMR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(146,’Namibië’,’92′,264,’NA’,'NAM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(147,’Nauru’,’100′,674,’NR’,'NRU’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(148,’Nederland’,’854′,31,’NL’,'NLD’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(149,’Nederlandse Antillen’,’108′,599,’AN’,'ANT’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(150,’Nepal’,’116′,977,’NP’,'NPL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(151,’Nicaragua’,’140′,505,’NI’,'NIC’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(152,’Nieuw-Caledonië’,’162′,687,’NC’,'NCL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(153,’Nieuw-Zeeland’,’166′,64,’NZ’,'NZL’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(154,’Niger’,’170′,227,’NE’,'NER’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(155,’Nigeria’,’174′,234,’NG’,'NGA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(156,’Niue’,’178′,683,’NU’,'NIU’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(157,’Noordelijke Marianen’,’180′,1670,’MP’,'MNP’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(158,’Noord-Korea’,’184′,850,’KP’,'PRK’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(159,’Noorwegen’,’188′,47,’NO’,'NOR’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(160,’Norfolkeiland’,’208′,6723,’NF’,'NFK’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(161,’Oeganda’,’262′,256,’UG’,'UGA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(162,’Oekraïne’,’212′,380,’UA’,'UKR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(163,’Oezbekistan’,’214′,998,’UZ’,'UZB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(164,’Oman’,’276′,968,’OM’,'OMN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(165,’Oostenrijk’,’218′,43,’AT’,'AUT’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(166,’Oost-Timor’,’222′,670,’TL’,'TLS’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(167,’Pakistan’,’226′,92,’PK’,'PAK’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(168,’Palau’,’232′,680,’PW’,'PLW’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(169,’Palestina’,’231′,970,’PS’,'PSE’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(170,’Panama’,’238′,507,’PA’,'PAN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(171,’Papoea-Nieuw-Guinea’,’246′,675,’PG’,'PNG’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(172,’Paraguay’,’258′,595,’PY’,'PRY’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(173,’Peru’,’260′,51,’PE’,'PER’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(174,’Pitcairn’,’292′,null,’PN’,'PCN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(175,’Polen’,’304′,48,’PL’,'POL’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(176,’Portugal’,’312′,351,’PT’,'PRT’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(177,’Puerto Rico’,’320′,1787,’PR’,'PRI’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(178,’Qatar’,’624′,974,’QA’,'QAT’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(179,’Réunion’,’334′,262,’RE’,'REU’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(180,’Roemenië’,’340′,40,’RO’,'ROU’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(181,’Rusland’,’344′,7,’RU’,'RUS’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(182,’Rwanda’,’356′,250,’RW’,'RWA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(183,’Saint Kitts en Nevis’,’360′,1869,’KN’,'KNA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(184,’Saint Lucia’,’833′,1758,’LC’,'LCA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(185,’Saint Vincent en de Grenadines’,’376′,1784,’VC’,'VCT’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(186,’Saint-Pierre en Miquelon’,’400′,508,’PM’,'SPM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(187,’Samoa’,’136′,685,’WS’,'WSM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(188,’San Marino’,’404′,378,’SM’,'SMR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(189,’Sandwich Eilanden’,’408′,null,’GS’,'SGS’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(190,’Sao Tomé en Principe’,’422′,239,’ST’,'STP’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(191,’Saoedi-Arabië’,’430′,966,’SA’,'SAU’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(192,’Senegal’,’438′,221,’SN’,'SEN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(193,’Servië en Montenegro’,’440′,381,’CS’,'SCG’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(194,’Seychellen’,’442′,248,’SC’,'SYC’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(195,’Sierra Leone’,’446′,232,’SL’,'SLE’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(196,’Singapore’,’807′,65,’SG’,'SGP’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(197,’Sint Helena’,’458′,290,’SH’,'SHN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(198,’Slovenië’,’462′,386,’SI’,'SVN’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(199,’Slowakije’,’470′,421,’SK’,'SVK’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(200,’Soedan’,’474′,249,’SD’,'SDN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(201,’Solomon Eilanden’,’478′,677,’SB’,'SLB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(202,’Somalië’,’480′,252,’SO’,'SOM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(203,’Spanje’,’583′,34,’ES’,'ESP’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(204,’Sri Lanka’,’498′,94,’LK’,'LKA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(205,’Suriname’,’496′,597,’SR’,'SUR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(206,’Swaziland’,’528′,268,’SZ’,'SWZ’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(207,’Syrië’,’530′,963,’SY’,'SYR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(208,’Tadzjikistan’,’540′,992,’TJ’,'TJK’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(209,’Taiwan’,’570′,886,’TW’,'TWN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(210,’Tanzania’,’574′,255,’TZ’,'TZA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(211,’Thailand’,’580′,66,’TH’,'THA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(212,’Togo’,’804′,228,’TG’,'TGO’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(213,’Tokelau-eilanden’,’598′,690,’TK’,'TKL’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(214,’Tonga’,’612′,676,’TO’,'TON’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(215,’Trinidad en Tobago’,’620′,1868,’TT’,'TTO’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(216,’Tsjaad’,’638′,235,’TD’,'TCD’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(217,’Tsjechië’,’659′,420,’CZ’,'CZE’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(218,’Tunesië’,’666′,216,’TN’,'TUN’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(219,’Turkije’,’670′,90,’TR’,'TUR’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(220,’Turkmenistan’,’239′,993,’TM’,'TKM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(221,’Turks- en Caicoseilanden’,’678′,1649,’TC’,'TCA’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(222,’Tuvalu’,’682′,688,’TV’,'TUV’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(223,’Uruguay’,’891′,598,’UY’,'URY’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(224,’Vanuatu’,’744′,678,’VU’,'VUT’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(225,’Vaticaanstad’,’748′,379,’VA’,'VAT’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(226,’Venezuela’,’834′,58,’VE’,'VEN’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(227,’Verenigd Koninkrijk’,’772′,44,’GB’,'GBR’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(228,’Verenigde Arabische Emiraten’,’780′,971,’AE’,'ARE’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(229,’Verenigde Staten ‘,’203′,1,’US’,'USA’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(230,’Vietnam’,’796′,84,’VN’,'VNM’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(231,’Wallis en Futuna’,’826′,681,’WF’,'WLF’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(232,’Westelijke Sahara’,’840′,null,’EH’,'ESH’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(233,’Wit-Rusland’,’336′,375,’BY’,'BLR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(234,’Zambia’,’876′,260,’ZM’,'ZMB’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(235,’Zimbabwe’,’112′,263,’ZW’,'ZWE’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(236,’Zuid-Afrika’,’710′,27,’ZA’,'ZAF’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(237,’Zuid-Korea’,’410′,82,’KR’,'KOR’,’0′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(238,’Zweden’,’584′,46,’SE’,'SWE’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(239,’Zwitserland’,’581′,41,’CH’,'CHE’,’1′);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(,’Alaska’,”,1907,”,”,’no’);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(,’Ascension’,”,247,”,”,’no’);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(,’Brits IO Territorium’,’608′,null,’IO’,'VGB’,'no’);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(,’Diego Garcia’,”,246,”,”,’no’);
INSERT INTO tablanden (‘ID’,'Landnaam’,'ISOCode’,'LandTelNr’,'ISOAfk2′,’ISOAfk3′,’Shortlist’) VALUES(,’Puerto Rico’,”,1939,”,”,’0′);