Whilst developing a publishing site, I thought I would need a list of continents and their respective countries to put in a MySQL database to help locate people who published on the site.

I researched the Internet for a while but could not find a list of continents and respective countries. However a few days ago I was looking at a site for a totally different reason and came across a list of continents and sub-countries by coincidence.

I eventually only used the list of worldwide countries and did not need them separated into continents.

As I had forgotten where I found the list, and instead of discarding it I thought I'd share it here as I'm sure someone may find a use for it.

Please note that the list below seemed to be correct as of early 2010, and if you have a more up to date list then please let me know. Thank you.

The list is follows with the continents appearing in upper case and their respective countries listed below.

NORTH AMERICA

Aruba
Bahamas
Barbados
Belize
Bermuda
Canada
Cayman Islands
Costa Rica
Dominica
Dominican Republic
El Salvador
Grenada
Guadeloupe
Guatemala
Haiti
Honduras
Jamaica
Martinique
Mexico
Nicaragua
Panama
Puerto Rico
Saint Kitts and Nevis
Saint Vincent and the Grenadines
Saint Lucia
Trinidad and Tobago
Turks and Caicos Islands
United States
United States Minor Outlying Islands
Virgin Islands (British)
Virgin Islands (U.S.)

SOUTH AMERICA

Argentina
Bolivia
Brazil
Chile
Colombia
Ecuador
French Guiana
Guyana
Mexico
Paraguay
Peru
Suriname
Uruguay
Venezuela

EUROPE

Albania
Andorra
Anguilla
Antarctica
Antigua and Barbuda
Armenia
Austria
Azerbaijan
Belarus
Belgium
Bosnia and Herzegovina
Bouvet Island
British Indian Ocean Territory
Bulgaria
Christmas Island
Cocos (Keeling) Islands
Croatia
Cyprus
Czech Republic
Denmark
Estonia
Faroe Islands
Falkland Islands (Malvinas)
Finland
France
French Polynesia
French Southern Territories
Georgia
Germany
Gibraltar
Greece
Greenland
Guam
Heard Island and McDonald Islands
Holy See (Vatican City State)
Hungary
Iceland
Ireland
Italy
Kazakhstan
Kyrgyzstan
Latvia
Liechtenstein
Lithuania
Luxembourg
Macedonia, the former Yugoslav Republic of
Malta
Marshall Islands
Mayotte
Moldova, Republic of
Monaco
Mongolia
Montserrat
Netherlands
Netherlands Antilles
New Caledonia
Norfolk Island
Norway
Pitcairn
Poland
Portugal
Réunion
Romania
Russian Federation
Saint Pierre and Miquelon
Saint Helena
San Marino
Slovakia
Slovenia
Spain
Svalbard and Jan Mayen
Sweden
Switzerland
Tokelau
Turkey
Ukraine
United Kingdom
Wallis and Futuna

MIDDLE EAST

Bahrain
Egypt
Israel
Jordan
Kuwait
Lebanon
Oman
Pakistan
Qatar
Saudi Arabia
Tajikistan
Turkmenistan
United Arab Emirates
Uzbekistan
Western Sahara
Yemen

AFRICA

Algeria
Angola
Benin
Botswana
Burkina Faso
Burundi
Cameroon
Cape Verde
Central African Republic
Chad
Comoros
Congo
Côte d'Ivoire
Djibouti
Equatorial Guinea
Eritrea
Ethiopia
Gabon
Gambia
Ghana
Guinea
Guinea-Bissau
Kenya
Lesotho
Liberia
Madagascar
Malawi
Mali
Mauritania
Mauritius
Morocco
Mozambique
Namibia
Niger
Nigeria
Rwanda
Sao Tome and Principe
Senegal
Seychelles
Sierra Leone
Somalia
South Africa
Swaziland
Tanzania, United Republic of
Togo
Tunisia
Uganda
Zambia
Zimbabwe

ASIA

Bangladesh
Bhutan
Brunei Darussalam
Cambodia
China
Hong Kong
India
Indonesia
Japan
Lao People's Democratic Republic
Macao
Malaysia
Maldives
Myanmar
Nepal
Philippines
Singapore
Korea, Republic of
Sri Lanka
Taiwan
Thailand
Timor-Leste
Viet Nam

OCEANA

American Samoa
Australia
Cook Islands
Fiji
Kiribati
Micronesia, Federated States of
Nauru
New Zealand
Niue
Northern Mariana Islands
Palau
Papua New Guinea
Samoa
Solomon Islands
Tonga
Tuvalu
Vanuatu