Icheb’s blog

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');