Feb
05
2009

SQL Tips – List of Top Level Domains

Here is SQL and a text list of the Top Level Domains currently in use on the internet

The list is free for all to use for any purpose.

The original data was sourced from IANA on Thursday 5 February 2008.

If you need to modify it further, remember that you can always use The Worlds Simplest Code Generator.

In the SQL version, the following have been escaped with an extra single quote:

  • Cote d’Ivoire
  • Korea, Democratic People’s Republic of
  • Lao People’s Democratic Republic

Please post a comment if you find this useful.

SQL version:

--Note: All test domains have been commented out at the bottom
INSERT INTO tblDomains(extension,type,description)
VALUES
('.AC','country-code','Ascension Island'),
('.AD','country-code','Andorra'),
('.AE','country-code','United Arab Emirates'),
('.AF','country-code','Afghanistan'),
('.AG','country-code','Antigua and Barbuda'),
('.AI','country-code','Anguilla'),
('.AL','country-code','Albania'),
('.AM','country-code','Armenia'),
('.AN','country-code','Netherlands Antilles'),
('.AO','country-code','Angola'),
('.AQ','country-code','Antarctica'),
('.AR','country-code','Argentina'),
('.AS','country-code','American Samoa'),
('.AT','country-code','Austria'),
('.AU','country-code','Australia'),
('.AW','country-code','Aruba'),
('.AX','country-code','Aland Islands'),
('.AZ','country-code','Azerbaijan'),
('.BA','country-code','Bosnia and Herzegovina'),
('.BB','country-code','Barbados'),
('.BD','country-code','Bangladesh'),
('.BE','country-code','Belgium'),
('.BF','country-code','Burkina Faso'),
('.BG','country-code','Bulgaria'),
('.BH','country-code','Bahrain'),
('.BI','country-code','Burundi'),
('.BJ','country-code','Benin'),
('.BL','country-code','Saint Barthelemy'),
('.BM','country-code','Bermuda'),
('.BN','country-code','Brunei Darussalam'),
('.BO','country-code','Bolivia'),
('.BR','country-code','Brazil'),
('.BS','country-code','Bahamas'),
('.BT','country-code','Bhutan'),
('.BV','country-code','Bouvet Island'),
('.BW','country-code','Botswana'),
('.BY','country-code','Belarus'),
('.BZ','country-code','Belize'),
('.CA','country-code','Canada'),
('.CC','country-code','Cocos (Keeling) Islands'),
('.CD','country-code','Congo, The Democratic Republic of the'),
('.CF','country-code','Central African Republic'),
('.CG','country-code','Congo'),
('.CH','country-code','Switzerland'),
('.CI','country-code','Cote d''Ivoire'),
('.CK','country-code','Cook Islands'),
('.CL','country-code','Chile'),
('.CM','country-code','Cameroon'),
('.CN','country-code','China'),
('.CO','country-code','Colombia'),
('.CR','country-code','Costa Rica'),
('.CU','country-code','Cuba'),
('.CV','country-code','Cape Verde'),
('.CX','country-code','Christmas Island'),
('.CY','country-code','Cyprus'),
('.CZ','country-code','Czech Republic'),
('.DE','country-code','Germany'),
('.DJ','country-code','Djibouti'),
('.DK','country-code','Denmark'),
('.DM','country-code','Dominica'),
('.DO','country-code','Dominican Republic'),
('.DZ','country-code','Algeria'),
('.EC','country-code','Ecuador'),
('.EE','country-code','Estonia'),
('.EG','country-code','Egypt'),
('.EH','country-code','Western Sahara'),
('.ER','country-code','Eritrea'),
('.ES','country-code','Spain'),
('.ET','country-code','Ethiopia'),
('.EU','country-code','European Union'),
('.FI','country-code','Finland'),
('.FJ','country-code','Fiji'),
('.FK','country-code','Falkland Islands (Malvinas)'),
('.FM','country-code','Micronesia, Federated States of'),
('.FO','country-code','Faroe Islands'),
('.FR','country-code','France'),
('.GA','country-code','Gabon'),
('.GB','country-code','United Kingdom'),
('.GD','country-code','Grenada'),
('.GE','country-code','Georgia'),
('.GF','country-code','French Guiana'),
('.GG','country-code','Guernsey'),
('.GH','country-code','Ghana'),
('.GI','country-code','Gibraltar'),
('.GL','country-code','Greenland'),
('.GM','country-code','Gambia'),
('.GN','country-code','Guinea'),
('.GP','country-code','Guadeloupe'),
('.GQ','country-code','Equatorial Guinea'),
('.GR','country-code','Greece'),
('.GS','country-code','South Georgia and the South Sandwich Islands'),
('.GT','country-code','Guatemala'),
('.GU','country-code','Guam'),
('.GW','country-code','Guinea-Bissau'),
('.GY','country-code','Guyana'),
('.HK','country-code','Hong Kong'),
('.HM','country-code','Heard Island and McDonald Islands'),
('.HN','country-code','Honduras'),
('.HR','country-code','Croatia'),
('.HT','country-code','Haiti'),
('.HU','country-code','Hungary'),
('.ID','country-code','Indonesia'),
('.IE','country-code','Ireland'),
('.IL','country-code','Israel'),
('.IM','country-code','Isle of Man'),
('.IN','country-code','India'),
('.IO','country-code','British Indian Ocean Territory'),
('.IQ','country-code','Iraq'),
('.IR','country-code','Iran, Islamic Republic of'),
('.IS','country-code','Iceland'),
('.IT','country-code','Italy'),
('.JE','country-code','Jersey'),
('.JM','country-code','Jamaica'),
('.JO','country-code','Jordan'),
('.JP','country-code','Japan'),
('.KE','country-code','Kenya'),
('.KG','country-code','Kyrgyzstan'),
('.KH','country-code','Cambodia'),
('.KI','country-code','Kiribati'),
('.KM','country-code','Comoros'),
('.KN','country-code','Saint Kitts and Nevis'),
('.KP','country-code','Korea, Democratic People''s Republic of'),
('.KR','country-code','Korea, Republic of'),
('.KW','country-code','Kuwait'),
('.KY','country-code','Cayman Islands'),
('.KZ','country-code','Kazakhstan'),
('.LA','country-code','Lao People''s Democratic Republic'),
('.LB','country-code','Lebanon'),
('.LC','country-code','Saint Lucia'),
('.LI','country-code','Liechtenstein'),
('.LK','country-code','Sri Lanka'),
('.LR','country-code','Liberia'),
('.LS','country-code','Lesotho'),
('.LT','country-code','Lithuania'),
('.LU','country-code','Luxembourg'),
('.LV','country-code','Latvia'),
('.LY','country-code','Libyan Arab Jamahiriya'),
('.MA','country-code','Morocco'),
('.MC','country-code','Monaco'),
('.MD','country-code','Moldova'),
('.ME','country-code','Montenegro'),
('.MF','country-code','Saint Martin'),
('.MG','country-code','Madagascar'),
('.MH','country-code','Marshall Islands'),
('.MK','country-code','Macedonia, The Former Yugoslav Republic of'),
('.ML','country-code','Mali'),
('.MM','country-code','Myanmar'),
('.MN','country-code','Mongolia'),
('.MO','country-code','Macao'),
('.MP','country-code','Northern Mariana Islands'),
('.MQ','country-code','Martinique'),
('.MR','country-code','Mauritania'),
('.MS','country-code','Montserrat'),
('.MT','country-code','Malta'),
('.MU','country-code','Mauritius'),
('.MV','country-code','Maldives'),
('.MW','country-code','Malawi'),
('.MX','country-code','Mexico'),
('.MY','country-code','Malaysia'),
('.MZ','country-code','Mozambique'),
('.NA','country-code','Namibia'),
('.NC','country-code','New Caledonia'),
('.NE','country-code','Niger'),
('.NF','country-code','Norfolk Island'),
('.NG','country-code','Nigeria'),
('.NI','country-code','Nicaragua'),
('.NL','country-code','Netherlands'),
('.NO','country-code','Norway'),
('.NP','country-code','Nepal'),
('.NR','country-code','Nauru'),
('.NU','country-code','Niue'),
('.NZ','country-code','New Zealand'),
('.OM','country-code','Oman'),
('.PA','country-code','Panama'),
('.PE','country-code','Peru'),
('.PF','country-code','French Polynesia'),
('.PG','country-code','Papua New Guinea'),
('.PH','country-code','Philippines'),
('.PK','country-code','Pakistan'),
('.PL','country-code','Poland'),
('.PM','country-code','Saint Pierre and Miquelon'),
('.PN','country-code','Pitcairn'),
('.PR','country-code','Puerto Rico'),
('.PS','country-code','Palestinian Territory, Occupied'),
('.PT','country-code','Portugal'),
('.PW','country-code','Palau'),
('.PY','country-code','Paraguay'),
('.QA','country-code','Qatar'),
('.RE','country-code','Reunion'),
('.RO','country-code','Romania'),
('.RS','country-code','Serbia'),
('.RU','country-code','Russian Federation'),
('.RW','country-code','Rwanda'),
('.SA','country-code','Saudi Arabia'),
('.SB','country-code','Solomon Islands'),
('.SC','country-code','Seychelles'),
('.SD','country-code','Sudan'),
('.SE','country-code','Sweden'),
('.SG','country-code','Singapore'),
('.SH','country-code','Saint Helena'),
('.SI','country-code','Slovenia'),
('.SJ','country-code','Svalbard and Jan Mayen'),
('.SK','country-code','Slovakia'),
('.SL','country-code','Sierra Leone'),
('.SM','country-code','San Marino'),
('.SN','country-code','Senegal'),
('.SO','country-code','Somalia'),
('.SR','country-code','Suriname'),
('.ST','country-code','Sao Tome and Principe'),
('.SU','country-code','Soviet Union (being phased out)'),
('.SV','country-code','El Salvador'),
('.SY','country-code','Syrian Arab Republic'),
('.SZ','country-code','Swaziland'),
('.TC','country-code','Turks and Caicos Islands'),
('.TD','country-code','Chad'),
('.TF','country-code','French Southern Territories'),
('.TG','country-code','Togo'),
('.TH','country-code','Thailand'),
('.TJ','country-code','Tajikistan'),
('.TK','country-code','Tokelau'),
('.TL','country-code','Timor-Leste'),
('.TM','country-code','Turkmenistan'),
('.TN','country-code','Tunisia'),
('.TO','country-code','Tonga'),
('.TP','country-code','Portuguese Timor (being phased out)'),
('.TR','country-code','Turkey'),
('.TT','country-code','Trinidad and Tobago'),
('.TV','country-code','Tuvalu'),
('.TW','country-code','Taiwan'),
('.TZ','country-code','Tanzania, United Republic of'),
('.UA','country-code','Ukraine'),
('.UG','country-code','Uganda'),
('.UK','country-code','United Kingdom'),
('.UM','country-code','United States Minor Outlying Islands'),
('.US','country-code','United States'),
('.UY','country-code','Uruguay'),
('.UZ','country-code','Uzbekistan'),
('.VA','country-code','Holy See (Vatican City State)'),
('.VC','country-code','Saint Vincent and the Grenadines'),
('.VE','country-code','Venezuela'),
('.VG','country-code','Virgin Islands, British'),
('.VI','country-code','Virgin Islands, U.S.'),
('.VN','country-code','Viet Nam'),
('.VU','country-code','Vanuatu'),
('.WF','country-code','Wallis and Futuna'),
('.WS','country-code','Samoa'),
('.YE','country-code','Yemen'),
('.YT','country-code','Mayotte'),
('.YU','country-code','Yugoslavia (being phased out)'),
('.ZA','country-code','South Africa'),
('.ZM','country-code','Zambia'),
('.ZW','country-code','Zimbabwe'),
('.COM','generic','Generic'),
('.INFO','generic','Generic'),
('.NET','generic','Generic'),
('.ORG','generic','Generic'),
('.BIZ','reserved','Business'),
('.NAME','reserved','Individuals'),
('.PRO','reserved','Individuals'),
('.ARPA','infrastructure','Internet'),
('.AERO','sponsored','Aviation'),
('.ASIA','sponsored','Asia Pacific'),
('.CAT','sponsored','Catalan'),
('.COOP','sponsored','Cooperative Associations'),
('.EDU','sponsored','Educational'),
('.GOV','sponsored','United States Government'),
('.INT','sponsored','International Organisations'),
('.JOBS','sponsored','Human Resources'),
('.MIL','sponsored','United States military'),
('.MOBI','sponsored','Mobile'),
('.MUSEUM','sponsored','Museums'),
('.TEL','sponsored','Cotact Information'),
('.TRAVEL','sponsored','Travel');
/*
--Test Domains
,
('.δοκιμή','test','test:el-Grek'),
('.испытание','test','test:ru-Cyrl'),
('.טעסט','test','test:yi-Hebr'),
('.آزمایشی','test','test:fa-Arab'),
('.إختبار','test','test:ar-Arab'),
('.परीक्षा','test','test:hi-Deva'),
('.பரிட்சை','test','test:ta-Taml'),
('.테스트','test','test:ko-Hang'),
('.テスト','test','test:ja-Kana'),
('.测试','test','test:zh-Hans'),
('.測試','test','test:zh-Hant');
*/

Text version:

.AC	country-code	Ascension Island
.AD	country-code	Andorra
.AE	country-code	United Arab Emirates
.AF	country-code	Afghanistan
.AG	country-code	Antigua and Barbuda
.AI	country-code	Anguilla
.AL	country-code	Albania
.AM	country-code	Armenia
.AN	country-code	Netherlands Antilles
.AO	country-code	Angola
.AQ	country-code	Antarctica
.AR	country-code	Argentina
.AS	country-code	American Samoa
.AT	country-code	Austria
.AU	country-code	Australia
.AW	country-code	Aruba
.AX	country-code	Aland Islands
.AZ	country-code	Azerbaijan
.BA	country-code	Bosnia and Herzegovina
.BB	country-code	Barbados
.BD	country-code	Bangladesh
.BE	country-code	Belgium
.BF	country-code	Burkina Faso
.BG	country-code	Bulgaria
.BH	country-code	Bahrain
.BI	country-code	Burundi
.BJ	country-code	Benin
.BL	country-code	Saint Barthelemy
.BM	country-code	Bermuda
.BN	country-code	Brunei Darussalam
.BO	country-code	Bolivia
.BR	country-code	Brazil
.BS	country-code	Bahamas
.BT	country-code	Bhutan
.BV	country-code	Bouvet Island
.BW	country-code	Botswana
.BY	country-code	Belarus
.BZ	country-code	Belize
.CA	country-code	Canada
.CC	country-code	Cocos (Keeling) Islands
.CD	country-code	Congo, The Democratic Republic of the
.CF	country-code	Central African Republic
.CG	country-code	Congo
.CH	country-code	Switzerland
.CI	country-code	Cote d'Ivoire
.CK	country-code	Cook Islands
.CL	country-code	Chile
.CM	country-code	Cameroon
.CN	country-code	China
.CO	country-code	Colombia
.CR	country-code	Costa Rica
.CU	country-code	Cuba
.CV	country-code	Cape Verde
.CX	country-code	Christmas Island
.CY	country-code	Cyprus
.CZ	country-code	Czech Republic
.DE	country-code	Germany
.DJ	country-code	Djibouti
.DK	country-code	Denmark
.DM	country-code	Dominica
.DO	country-code	Dominican Republic
.DZ	country-code	Algeria
.EC	country-code	Ecuador
.EE	country-code	Estonia
.EG	country-code	Egypt
.EH	country-code	Western Sahara
.ER	country-code	Eritrea
.ES	country-code	Spain
.ET	country-code	Ethiopia
.EU	country-code	European Union
.FI	country-code	Finland
.FJ	country-code	Fiji
.FK	country-code	Falkland Islands (Malvinas)
.FM	country-code	Micronesia, Federated States of
.FO	country-code	Faroe Islands
.FR	country-code	France
.GA	country-code	Gabon
.GB	country-code	United Kingdom
.GD	country-code	Grenada
.GE	country-code	Georgia
.GF	country-code	French Guiana
.GG	country-code	Guernsey
.GH	country-code	Ghana
.GI	country-code	Gibraltar
.GL	country-code	Greenland
.GM	country-code	Gambia
.GN	country-code	Guinea
.GP	country-code	Guadeloupe
.GQ	country-code	Equatorial Guinea
.GR	country-code	Greece
.GS	country-code	South Georgia and the South Sandwich Islands
.GT	country-code	Guatemala
.GU	country-code	Guam
.GW	country-code	Guinea-Bissau
.GY	country-code	Guyana
.HK	country-code	Hong Kong
.HM	country-code	Heard Island and McDonald Islands
.HN	country-code	Honduras
.HR	country-code	Croatia
.HT	country-code	Haiti
.HU	country-code	Hungary
.ID	country-code	Indonesia
.IE	country-code	Ireland
.IL	country-code	Israel
.IM	country-code	Isle of Man
.IN	country-code	India
.IO	country-code	British Indian Ocean Territory
.IQ	country-code	Iraq
.IR	country-code	Iran, Islamic Republic of
.IS	country-code	Iceland
.IT	country-code	Italy
.JE	country-code	Jersey
.JM	country-code	Jamaica
.JO	country-code	Jordan
.JP	country-code	Japan
.KE	country-code	Kenya
.KG	country-code	Kyrgyzstan
.KH	country-code	Cambodia
.KI	country-code	Kiribati
.KM	country-code	Comoros
.KN	country-code	Saint Kitts and Nevis
.KP	country-code	Korea, Democratic People's Republic of
.KR	country-code	Korea, Republic of
.KW	country-code	Kuwait
.KY	country-code	Cayman Islands
.KZ	country-code	Kazakhstan
.LA	country-code	Lao People's Democratic Republic
.LB	country-code	Lebanon
.LC	country-code	Saint Lucia
.LI	country-code	Liechtenstein
.LK	country-code	Sri Lanka
.LR	country-code	Liberia
.LS	country-code	Lesotho
.LT	country-code	Lithuania
.LU	country-code	Luxembourg
.LV	country-code	Latvia
.LY	country-code	Libyan Arab Jamahiriya
.MA	country-code	Morocco
.MC	country-code	Monaco
.MD	country-code	Moldova
.ME	country-code	Montenegro
.MF	country-code	Saint Martin
.MG	country-code	Madagascar
.MH	country-code	Marshall Islands
.MK	country-code	Macedonia, The Former Yugoslav Republic of
.ML	country-code	Mali
.MM	country-code	Myanmar
.MN	country-code	Mongolia
.MO	country-code	Macao
.MP	country-code	Northern Mariana Islands
.MQ	country-code	Martinique
.MR	country-code	Mauritania
.MS	country-code	Montserrat
.MT	country-code	Malta
.MU	country-code	Mauritius
.MV	country-code	Maldives
.MW	country-code	Malawi
.MX	country-code	Mexico
.MY	country-code	Malaysia
.MZ	country-code	Mozambique
.NA	country-code	Namibia
.NC	country-code	New Caledonia
.NE	country-code	Niger
.NF	country-code	Norfolk Island
.NG	country-code	Nigeria
.NI	country-code	Nicaragua
.NL	country-code	Netherlands
.NO	country-code	Norway
.NP	country-code	Nepal
.NR	country-code	Nauru
.NU	country-code	Niue
.NZ	country-code	New Zealand
.OM	country-code	Oman
.PA	country-code	Panama
.PE	country-code	Peru
.PF	country-code	French Polynesia
.PG	country-code	Papua New Guinea
.PH	country-code	Philippines
.PK	country-code	Pakistan
.PL	country-code	Poland
.PM	country-code	Saint Pierre and Miquelon
.PN	country-code	Pitcairn
.PR	country-code	Puerto Rico
.PS	country-code	Palestinian Territory, Occupied
.PT	country-code	Portugal
.PW	country-code	Palau
.PY	country-code	Paraguay
.QA	country-code	Qatar
.RE	country-code	Reunion
.RO	country-code	Romania
.RS	country-code	Serbia
.RU	country-code	Russian Federation
.RW	country-code	Rwanda
.SA	country-code	Saudi Arabia
.SB	country-code	Solomon Islands
.SC	country-code	Seychelles
.SD	country-code	Sudan
.SE	country-code	Sweden
.SG	country-code	Singapore
.SH	country-code	Saint Helena
.SI	country-code	Slovenia
.SJ	country-code	Svalbard and Jan Mayen
.SK	country-code	Slovakia
.SL	country-code	Sierra Leone
.SM	country-code	San Marino
.SN	country-code	Senegal
.SO	country-code	Somalia
.SR	country-code	Suriname
.ST	country-code	Sao Tome and Principe
.SU	country-code	Soviet Union (being phased out)
.SV	country-code	El Salvador
.SY	country-code	Syrian Arab Republic
.SZ	country-code	Swaziland
.TC	country-code	Turks and Caicos Islands
.TD	country-code	Chad
.TF	country-code	French Southern Territories
.TG	country-code	Togo
.TH	country-code	Thailand
.TJ	country-code	Tajikistan
.TK	country-code	Tokelau
.TL	country-code	Timor-Leste
.TM	country-code	Turkmenistan
.TN	country-code	Tunisia
.TO	country-code	Tonga
.TP	country-code	Portuguese Timor (being phased out)
.TR	country-code	Turkey
.TT	country-code	Trinidad and Tobago
.TV	country-code	Tuvalu
.TW	country-code	Taiwan
.TZ	country-code	Tanzania, United Republic of
.UA	country-code	Ukraine
.UG	country-code	Uganda
.UK	country-code	United Kingdom
.UM	country-code	United States Minor Outlying Islands
.US	country-code	United States
.UY	country-code	Uruguay
.UZ	country-code	Uzbekistan
.VA	country-code	Holy See (Vatican City State)
.VC	country-code	Saint Vincent and the Grenadines
.VE	country-code	Venezuela
.VG	country-code	Virgin Islands, British
.VI	country-code	Virgin Islands, U.S.
.VN	country-code	Viet Nam
.VU	country-code	Vanuatu
.WF	country-code	Wallis and Futuna
.WS	country-code	Samoa
.YE	country-code	Yemen
.YT	country-code	Mayotte
.YU	country-code	Yugoslavia (being phased out)
.ZA	country-code	South Africa
.ZM	country-code	Zambia
.ZW	country-code	Zimbabwe
.COM	generic	Generic
.INFO	generic	Generic
.NET	generic	Generic
.ORG	generic	Generic
.BIZ	reserved	Business
.NAME	reserved	Individuals
.PRO	reserved	Individuals
.ARPA	infrastructure	Internet
.AERO	sponsored	Aviation
.ASIA	sponsored	Asia Pacific
.CAT	sponsored	Catalan
.COOP	sponsored	Cooperative Associations
.EDU	sponsored	Educational
.GOV	sponsored	United States Government
.INT	sponsored	International Organisations
.JOBS	sponsored	Human Resources
.MIL	sponsored	United States military
.MOBI	sponsored	Mobile
.MUSEUM	sponsored	Museums
.TEL	sponsored	Cotact Information
.TRAVEL	sponsored	Travel
.δοκιμή	test	test:el-Grek
.испытание	test	test:ru-Cyrl
.טעסט	test	test:yi-Hebr
.آزمایشی	test	test:fa-Arab
.إختبار	test	test:ar-Arab
.परीक्षा	test	test:hi-Deva
.பரிட்சை	test	test:ta-Taml
.테스트	test	test:ko-Hang
.テスト	test	test:ja-Kana
.测试	test	test:zh-Hans
.測試	test	test:zh-Hant
Written by John in: SQL Tips,Tips |

2 Comments »

  • BigDog

    BigDog…

    I am So Lucky That I found your blog and great articles. I will come to your blog often for finding new great articles from your blog.I am adding your rss feed in my reader Thank you…

    Trackback | 12 May 2009
  • Tom

    Ausom, cheers man, i was going to create this exact list, <3 google.

    Cheers 🙂

    Is this the most upto date list? and can i ask where all top level domains are listed? the closest i can find is:

    http://en.wikipedia.org/wiki/List_of_Internet_top-level_domains

    Comment | 10 June 2009

RSS feed for comments on this post. TrackBack URL

Leave a comment