Voor de mensen die net zoals ik niet kunnen vinden op het internet een tabel met alle netnummers(landnummers) van de wereld , let op de tabel is wel in het Nederlands.
Mocht je toevoeging of verbeteringen hebben geeft het aan. Als je het ergens gaat implanteren graag even een melding.
Mocht je toevoeging of verbeteringen hebben geeft het aan. Als je het ergens gaat implanteren graag even een melding.
PHP:
create or replace table Landcodes
(
LandnaamNL varchar(50) not null,
Belcode number(6) not null,
AFk2 varchar(3) not null,
Afk3 varchar(3) not null,
Continent varchar(20) not null,
Subcontinent varchar(10)
primary key (LandnaamNL)
)
insert into Landcodes values ("Afghanistan",93,"AF","AFG*","Azië")
insert into Landcodes values ("Alaska",1907,"AK","AK","Noord-Amerika")
insert into Landcodes values ("Albanië",355,"AL ","ALB*","Europa")
insert into Landcodes values ("Algerije ",213,"DZ","DZA","Afrika")
insert into Landcodes values ("Amerikaanse Maagdeneilanden",1340,"VI","VIR","Noord-Amerika")
insert into Landcodes values ("Amerikaans Samoa",684,"AS","ASM","Oceanië","Polynesië")
insert into Landcodes values ("Andorra",376,"AD","AND","Europa")
insert into Landcodes values ("Angola",244,"AO","AGO","Afrika")
insert into Landcodes values ("Anguilla",1264,"AI","AIA","Noord-Amerika")
insert into Landcodes values ("Antigua en Barbuda",1268,"AG","ATG","Noord-Amerika")
insert into Landcodes values ("Argentinië",54,"AR","ARG","Zuid-Amerika")
insert into Landcodes values ("Armenië",374,"AM","ARM","Azië")
insert into Landcodes values ("Aruba",297,"AW","ABW","Noord-Amerika")
insert into Landcodes values ("Ascension",247,"AC","AC","Afrika")
insert into Landcodes values ("Australië",61,"AU","AUS","Oceanië")
insert into Landcodes values ("Australisch Antarctica",672,"AU","Aus","Oceanië")
insert into Landcodes values ("Azerbeidzjan",994,"AZ","AZE","Azië")
insert into Landcodes values ("Bahama's",1242,"BS","BHS","Noord-Amerika")
insert into Landcodes values ("Bahrein",973,"BH","BHR","Azië")
insert into Landcodes values ("Bangladesh",880,"BD","BGD","Azië")
insert into Landcodes values ("Barbados",1246,"BB","BRB","Noord-Amerika")
insert into Landcodes values ("België",32,"BE","BEL","Europa")
insert into Landcodes values ("Belize",501,"BZ","BLZ","Noord-Amerika")
insert into Landcodes values ("Benin",229,"BJ","BEN","Afrika")
insert into Landcodes values ("Bermuda",1441,"BM","BMU","Noord-Amerika")
insert into Landcodes values ("Bhutan",975,"BT","BTN","Azië")
insert into Landcodes values ("Bolivia",591,"BO","BOL","Zuid-Amerika")
insert into Landcodes values ("Bosnië en Herzegovina",387,"BA","BIH","Europa")
insert into Landcodes values ("Botswana",267,"BW","BWA","Afrika")
insert into Landcodes values ("Brazilië",55,"BR","BRA","Zuid-Amerika")
insert into Landcodes values ("Britse Maagdeneilanden",1284,"IO","IOT","Noord-Amerika")
insert into Landcodes values ("Brunei",673,"BN","BRN","Azië")
insert into Landcodes values ("Bulgarije",359,"BG","BGR","Europa")
insert into Landcodes values ("Burkina Faso",226,"BF","BFA","Afrika")
insert into Landcodes values ("Burundi",257,"BI","BDI","Afrika")
insert into Landcodes values ("Cambodja",855,"KH","KHM","Azië")
insert into Landcodes values ("Canada",1,"CA","CAN","Noord-Amerika")
insert into Landcodes values ("Caymaneilanden",1345,"KY","CYM","Noord-Amerika")
insert into Landcodes values ("Centraal Afrikaanse Republiek",236,"CF","CAF","Afrika")
insert into Landcodes values ("Chili",56,"CL","CHL","Zuid-Amerika")
insert into Landcodes values ("China",86,"CN","CHN","Azië")
insert into Landcodes values ("Colombia",57,"CO","COL","Zuid-Amerika")
insert into Landcodes values ("Comoren",269,"KM","COM","Afrika")
insert into Landcodes values ("Congo Brazzaville",242,"CG","COD","Afrika")
insert into Landcodes values ("Congo Kinshasa",243,"CG","COD","Afrika")
insert into Landcodes values ("Cookeilanden",682,"CC","CCK","Oceanië","Polynesië")
insert into Landcodes values ("Costa Rica",506,"CR","CRV","Noord-Amerika")
insert into Landcodes values ("Cuba",53,"CU","CUB","Noord-Amerika")
insert into Landcodes values ("Cyprus",357,"CY","CYP","Azië")
insert into Landcodes values ("Denemarken",45,"DK","DNK","Europa")
insert into Landcodes values ("Diego Garcia",246,"nvt","nvt","Afrika")
insert into Landcodes values ("Djibouti",253,"DJ","DJI","Afrika")
insert into Landcodes values ("Dominica",1767,"DO","DOM","Noord-Amerika")
insert into Landcodes values ("Dominicaanse Republiek","1809","EC","ECU","Noord-Amerika")
insert into Landcodes values ("Duitsland",49,"DE","DEU","Europa")
insert into Landcodes values ("DDR"," 37 (opgeheven)","ddr","ddr","Europa")
insert into Landcodes values ("Ecuador",593,"EC","ECU","Zuid-Amerika")
insert into Landcodes values ("Egypte",20,"EG","EGY","Afrika")
insert into Landcodes values ("El Salvador",503,"SV","SLV","Noord-Amerika")
insert into Landcodes values ("Equatoriaal Guinea",240,"GQ","GNQ","Afrika")
insert into Landcodes values ("Eritrea",291,"ER","ERI","Afrika")
insert into Landcodes values ("Estland",372,"EE","EST","Europa")
insert into Landcodes values ("Ethiopië",251,"ET","ETH","Afrika")
insert into Landcodes values ("Faeröer",298,"FO","FRO","Europa")
insert into Landcodes values ("Falklandeilanden",500,"FK","FLK","Zuid-Amerika")
insert into Landcodes values ("Fiji",679,"FJ","FJI","Oceanië","Melanesië")
insert into Landcodes values ("Filipijnen",63,"PH","PHL","Azië")
insert into Landcodes values ("Finland",358,"FI","FIN","Europa")
insert into Landcodes values ("Frankrijk",33,"FR","FRA","Europa")
insert into Landcodes values ("Frans Guyana",594,"GF","GFU","Zuid-Amerika")
insert into Landcodes values ("Frans Polynesië",689,"PF","PYF","Oceanië","Polynesië")
insert into Landcodes values ("Gabon",241,"GA","GAB","Afrika")
insert into Landcodes values ("Gambia",220,"GM","GMB","Afrika")
insert into Landcodes values ("Georgië",995,"GE","GEO","Europa")
insert into Landcodes values ("Ghana",233,"GH","GHA","Afrika")
insert into Landcodes values ("Gibraltar",350,"GI","GIB","Europa")
insert into Landcodes values ("Grenada",1473,"GD","GRD","Noord-Amerika")
insert into Landcodes values ("Griekenland",30,"GR","GRC","Europa")
insert into Landcodes values ("Groenland",299,"GL","GLR","Noord-Amerika")
insert into Landcodes values ("Groot Brittannië",44,"GB","GBR","Europa")
insert into Landcodes values ("Guadeloupe",590,"BL","BLM","Noord-Amerika")
insert into Landcodes values ("Guam",1671,"nvt","nvt","Oceanië","Micronesië")
insert into Landcodes values ("Guatemala",502,"GP","GLP","Noord-Amerika")
insert into Landcodes values ("Guinee",224,"GN","GIN","Afrika")
insert into Landcodes values ("Guinee Bissau",24,"GW","GNB","Afrika")
insert into Landcodes values ("Guyana",592,"GY","GUY","Zuid-Amerika")
insert into Landcodes values ("Haïti",509,"HT","HTI","Noord-Amerika")
insert into Landcodes values ("Honduras",504,"HN","HND","Noord-Amerika")
insert into Landcodes values ("Hongarije",36,"HU","HUN","Europa")
insert into Landcodes values ("Hongkong",852,"HK","HKG","Azië")
insert into Landcodes values ("Ierland",353,"IE","IRL","Europa")
insert into Landcodes values ("IJsland",354,"IS","IS","Europa")
insert into Landcodes values ("India",91,"IN","IND","Azië")
insert into Landcodes values ("Indonesië",62,"ID","IDN","Azië")
insert into Landcodes values ("Irak",964,"IQ","IRQ","Azië")
insert into Landcodes values ("Iran",98,"IR","IRN","Azië")
insert into Landcodes values ("Israël",972,"IL","ISR","Azië")
insert into Landcodes values ("Italië",39,"IT","ITA","Europa")
insert into Landcodes values ("Ivoorkust",225,"CI","CI","Afrika")
insert into Landcodes values ("Jamaica",1876,"JM","JAM","Noord-Amerika")
insert into Landcodes values ("Japan",81,"JP","JPN","Azië")
insert into Landcodes values ("Jemen",967,"YE","YEM","Azië")
insert into Landcodes values ("Jordanië",962,"JO","JOR","Azië")
insert into Landcodes values ("Kaapverdië",238,"CV","CPV","Afrika")
insert into Landcodes values ("Kameroen",237,"CM","CMR","Afrika")
insert into Landcodes values ("Kanaaleilanden",44,"GB","GBR","Europa")
insert into Landcodes values ("Kazachstan",7,"UZ","UZB","Azië")
insert into Landcodes values ("Kenia",254,"KE","KEN","Afrika")
insert into Landcodes values ("Kirgizië",996,"KG","KGZ","Azië")
insert into Landcodes values ("Kiribati",686,"KI","KIR","Oceanië","Micronesië")
insert into Landcodes values ("Koeweit",965,"KW","KWT","Azië")
insert into Landcodes values ("Kosovo",377,"MC","MCO","Europa")
insert into Landcodes values ("Kroatië",385,"HR","HRV","Europa")
insert into Landcodes values ("Laos",856,"LA","LAO","Azië")
insert into Landcodes values ("Lesotho",266,"LS","LSO","Afrika")
insert into Landcodes values ("Letland",371,"LV","LVA","Europa")
insert into Landcodes values ("Libanon",961,"LB","LBN","Azië")
insert into Landcodes values ("Liberia",231,"LR","LBR","Afrika")
insert into Landcodes values ("Libië",218,"LY","LBY","Afrika")
insert into Landcodes values ("Liechtenstein",423,"LI","LIE","Europa")
insert into Landcodes values ("Litouwen",370,"LT","LTU","Europa")
insert into Landcodes values ("Luxemburg",352,"LU","LUX","Europa")
insert into Landcodes values ("Macau",853,"MO","MAC","Azië")
insert into Landcodes values ("Macedonië",389,"MK","MKD","Europa")
insert into Landcodes values ("Madagaskar",261,"MG","MDG","Afrika")
insert into Landcodes values ("Malawi",265,"MW","MWI","Afrika")
insert into Landcodes values ("Maldiven",960,"MV","MDV","Azië")
insert into Landcodes values ("Maleisië",60,"MY","MYS","Azië")
insert into Landcodes values ("Mali",223,"ML","MLI","Afrika")
insert into Landcodes values ("Malta",356,"MT","MLT","Europa")
insert into Landcodes values ("Man",44,"GB","GBR","Europa")
insert into Landcodes values ("Marokko",212,"MA","MAR","Afrika")
insert into Landcodes values ("Marshalleilanden",692,"MH","MHL","Oceanië","Micronesië")
insert into Landcodes values ("Martinique",596,"MQ","MQ","Zuid-Amerika")
insert into Landcodes values ("Mauritanië",222,"MR","MRT","Afrika")
insert into Landcodes values ("Mauritius",230,"MU","MUS","Afrika")
insert into Landcodes values ("Mayotte",2696,"nvt","nvt","Afrika")
insert into Landcodes values ("Mexico",52,"MX","MEX","Noord-Amerika")
insert into Landcodes values ("Micronesia",691,"FM","FSM","Oceanië","Micronesië")
insert into Landcodes values ("Moldavië",373,"MD","MDA","Europa")
insert into Landcodes values ("Monaco",377,"MC","MCO","Europa")
insert into Landcodes values ("Mongolië",976,"MN","MNG","Azië")
insert into Landcodes values ("Montenegro",381,"RS","SRB","Europa")
insert into Landcodes values ("Montserrat",1664,"nvt","nvt","Noord-Amerika")
insert into Landcodes values ("Mozambique",258,"MZ","MOZ","Afrika")
insert into Landcodes values ("Myanmar",95,"nvt","nvt","azie")
insert into Landcodes values ("Namibië",264,"NA","NAM","Afrika")
insert into Landcodes values ("Nauru",674,"NR","NRU","Oceanië","Micronesië")
insert into Landcodes values ("Nederland",31,"NL","NLD","Europa")
insert into Landcodes values ("Nederlandse Antillen",599,"AN","ANT","Zuid-Amerika")
insert into Landcodes values ("Curaçao",5999,"AN","ANT","Zuid-Amerika")
insert into Landcodes values ("Sint Maarten",5995,"AN","ANT","Zuid-Amerika")
insert into Landcodes values ("Bonaire",5997,"AN","ANT","Zuid-Amerika")
insert into Landcodes values ("Nepal",977,"NP","NPL","Azië")
insert into Landcodes values ("Nicaragua",505,"NI","NIC","Noord-Amerika")
insert into Landcodes values ("Nieuw Caledonië",687,"NC","NCL","Oceanië","Melanesië")
insert into Landcodes values ("Nieuw Guinea",675,"PG","PNG","Oceanië","Melanesië")
insert into Landcodes values ("Nieuw Zeeland",64,"PN","PCN","Oceanië")
insert into Landcodes values ("Niger",227,"nvt","nvt","Afrika")
insert into Landcodes values ("Nigeria",234,"NG","NGA","Afrika")
insert into Landcodes values ("Niue",683,"NU","NIU","Oceanië","Polynesië")
insert into Landcodes values ("Noord Korea",850,"KP","PRK","Azië")
insert into Landcodes values ("Noordelijke Marianen",1670,"MP","MNP","Oceanië","Micronesië")
insert into Landcodes values ("Noorwegen",47,"NO","NOR","Europa")
insert into Landcodes values ("Norfolk",6723,"NF","NF","Oceanië")
insert into Landcodes values ("Uganda",256,"UG","UGA","Afrika")
insert into Landcodes values ("Oekraïne",380,"UA","UA","Europa")
insert into Landcodes values ("Oezbekistan",998,"UZ","UZB","Azië")
insert into Landcodes values ("Oman",968,"OM","OMN","Azië")
insert into Landcodes values ("Oost Timor",670,"TL","TLS","Azië")
insert into Landcodes values ("Oostenrijk",43,"AT","AUS","Europa")
insert into Landcodes values ("Pakistan",92,"PK","PAK","Azië")
insert into Landcodes values ("Palau",680,"PW","PLW","Oceanië","Micronesië")
insert into Landcodes values ("Palestina",970,"PLO","PLO","Azië")
insert into Landcodes values ("Panama",507,"PA","PAN","Noord-Amerika")
insert into Landcodes values ("Papoea(Nieuw-Guinea)",675,"PG","PNG","Oceanië","Melanesië")
insert into Landcodes values ("Paraguay",595,"PY","PRY","Zuid-Amerika")
insert into Landcodes values ("Peru",51,"PE","PER","Zuid-Amerika")
insert into Landcodes values ("Polen",48,"PL","POL","Europa")
insert into Landcodes values ("Portugal",351,"PT","PRT","Europa")
insert into Landcodes values ("Puerto Rico1",1787,"PR","PRI","Noord-Amerika")
insert into Landcodes values ("Puerto Rico2",1939,"PR","PRI","Noord-Amerika")
insert into Landcodes values ("Qatar",974,"QA","QAT","Azië")
insert into Landcodes values ("Réunion",262,"RE","RE","Afrika")
insert into Landcodes values ("Roemenië",40,"RO","ROU","Europa")
insert into Landcodes values ("Rusland",7,"RU","RUS","Azië")
insert into Landcodes values ("Rwanda",250,"RW","RWA","Afrika")
insert into Landcodes values ("Saint Kitts en Nevis",1869,"KN","KNA","Noord-Amerika")
insert into Landcodes values ("Saint Lucia",1758,"LC","LCA","Noord-Amerika")
insert into Landcodes values ("Saint Vincent en de Grenadines",1784,"VC","VCT","Noord-Amerika")
insert into Landcodes values ("Saint Pierre en Miquelon","508","PM","SPM","Noord-Amerika")
insert into Landcodes values ("Salomonseilanden",677,"SB","SLB","Oceanië","Melanesië")
insert into Landcodes values ("Samoa",685,"WS","WSM","Oceanië","Polynesië")
insert into Landcodes values ("San Marino",378,"SM","SMR","Europa")
insert into Landcodes values ("Sao Tomé en Principe",239,"ST","STP","Afrika")
insert into Landcodes values ("Saoedi Arabië",966,"SA","SAU","Azië")
insert into Landcodes values ("Senegal",221,"SN","SEN","Afrika")
insert into Landcodes values ("Servië",381,"RS","SRB","Europa")
insert into Landcodes values ("Seychellen",248,"SC","SYC","Afrika")
insert into Landcodes values ("Sierra Leone",232,"SL","SLE","Afrika")
insert into Landcodes values ("Singapore",65,"SG","SGP","Azië")
insert into Landcodes values ("Sint Helena",290,"SH","SHN","Afrika")
insert into Landcodes values ("Slovenië",386,"SI","SVN","Europa")
insert into Landcodes values ("Slowakije",421,"SK","SVK","Europa")
insert into Landcodes values ("Somalië",252,"SO","SOM","Afrika")
insert into Landcodes values ("Spanje",34,"ES","ESP","Europa")
insert into Landcodes values ("Sri Lanka",94,"LK","LKA","Azië")
insert into Landcodes values ("Soedan",249,"SD","SDN","Afrika")
insert into Landcodes values ("Suriname",597,"SR","SUR","Zuid-Amerika")
insert into Landcodes values ("Swaziland",268,"SZ","SWZ","Afrika")
insert into Landcodes values ("Syrië",963,"SY","SYR","Azië")
insert into Landcodes values ("Tadzjikistan",992,"TJ","TJK","Azië")
insert into Landcodes values ("Taiwan",886,"TW","TWN","Azië")
insert into Landcodes values ("Tanzania",255,"TZ","TZA","Afrika")
insert into Landcodes values ("Thailand",66,"TH","THA","Azië")
insert into Landcodes values ("Togo",228,"TG","TGO","Afrika")
insert into Landcodes values ("Tokelau eilanden",690,"TK","TKL","Oceanië","Polynesië")
insert into Landcodes values ("Tonga",676,"TO","TON","Oceanië","Polynesië")
insert into Landcodes values ("Trinidad en Tobago",1868,"TT","TTO","Noord-Amerika")
insert into Landcodes values ("Tsjaad",235,"TD","TD","Afrika")
insert into Landcodes values ("Tsjechië",420,"CZ","CZE","Europa")
insert into Landcodes values ("Tunesië",216,"TN","TUN","Afrika")
insert into Landcodes values ("Turkije",90,"TR","TUR","Azië")
insert into Landcodes values ("Turkmenistan",993,"TM","TKM","Azië")
insert into Landcodes values ("Turks en Caicoseilanden",1649,"TC","TCA","Noord-Amerika")
insert into Landcodes values ("Tuvalu",688,"TV","TUV","Oceanië","Polynesië")
insert into Landcodes values ("Uganda",256,"un","un","Afrika")
insert into Landcodes values ("Uruguay",598,"UY","URY","Zuid-Amerika")
insert into Landcodes values ("Vanuatu",678,"VU","VUT","Oceanië","Melanesië")
insert into Landcodes values ("Vaticaanstad",379,"VI","VI","Europa")
insert into Landcodes values ("Venezuela",58,"VE","VEN","Zuid-Amerika")
insert into Landcodes values ("Verenigd Koninkrijk",44,"GB","GBR","Europa")
insert into Landcodes values ("Verenigde Arabische Emiraten",971,"AE","ARE","Azië")
insert into Landcodes values ("Verenigde Staten",1,"US","USA","Noord-Amerika")
insert into Landcodes values ("Vietnam",84,"VN","VNM","Azië")
insert into Landcodes values ("Wallis en Futuna",681,"WF","WLF","Oceanië","Polynesië")
insert into Landcodes values ("Wit Rusland",375,"BY","BLR","Europa")
insert into Landcodes values ("Zambia",260,"ZM","ZMB","Afrika")
insert into Landcodes values ("Zimbabwe",263,"ZW","ZWE","Afrika")
insert into Landcodes values ("Zuid Afrika",27,"ZA","ZAF","Afrika")
insert into Landcodes values ("Zuid Korea",82,"KR","KOR","Azië")
insert into Landcodes values ("Zweden",46,"SE","SWE","Europa")
insert into Landcodes values ("Zwitserland",41,"CH","CHE","Europa")
Laatst bewerkt:
