Table Info: h sys ccodes
Home > Administration > Reporting > Table Info: h_sys_ccodes
Introduction
ISO 3166-1 alpha-2 codes are two-letter country codes defined as part of the ISO 3166 standard published by the International Organization for Standardization (ISO). The codes are used to represent countries, dependent territories, and special areas of geographical interest. Hornbill utilises these country codes when storing country information against contact, organisation, and site records. Hornbill stores this information in a specific database table called h_sys_ccodes, however it has been published here to act as a reference for populating any CSV files that will be used to import contact, external organisation, or site records.
Where is the Country Code Stored in Other Tables?
If you want to extract country name information to accompany particular sets of records you may want to include the h_sys_ccodes table in your report. This can be joined on the h_country column of the appropriate table i.e.:
- Contact Records: h_sys_contact.h_country = h_sys_ccodes.h_code
- Organisation Records: h_sys_organisations.h_country = h_sys_ccodes.h_code
- Site records: h_sys_sites.h_country = h_sys_ccodes.h_code
Table Details
ISO 3166 Alpha 2 Country Code (h_code) | Country Name (h_name) |
---|---|
AD | Andorra |
AE | United Arab Emirates |
AF | Afghanistan |
AG | Antigua and Barbuda |
AI | Anguilla |
AL | Albania |
AM | Armenia |
AN | Netherlands Antilles |
AO | Angola |
AQ | Antarctica |
AR | Argentina |
AS | American Samoa |
AT | Austria |
AU | Australia |
AW | Aruba |
AX | Aland Islands |
AZ | Azerbaijan |
BA | Bosnia and Herzegovina |
BB | Barbados |
BD | Bangladesh |
BE | Belgium |
BF | Burkina Faso |
BG | Bulgaria |
BH | Bahrain |
BI | Burundi |
BJ | Benin |
BL | Saint Barthelemy |
BM | Bermuda |
BN | Brunei |
BO | Bolivia |
BR | Brazil |
BS | The Bahamas |
BT | Bhutan |
BV | Bouvet Island |
BW | Botswana |
BY | Belarus |
BZ | Belize |
CA | Canada |
CC | Cocos (Keeling) Islands |
CD | Republic of the Congo |
CF | Central African Republic |
CG | Republic of the Congo |
CH | Switzerland |
CI | Cote d'Ivoire |
CK | Cook Islands |
CL | Chile |
CM | Cameroon |
CN | People's Republic of China |
CO | Colombia |
CR | Costa Rica |
CU | Cuba |
CV | Cape Verde |
CX | Christmas Island |
CY | Cyprus |
CZ | Czech Republic |
DE | Germany |
DJ | Djibouti |
DK | Denmark |
DM | Dominica |
DO | Dominican Republic |
DZ | Algeria |
EC | Ecuador |
EE | Estonia |
EG | Egypt |
EH | Western Sahara |
ER | Eritrea |
ES | Spain |
ET | Ethiopia |
FI | Finland |
FJ | Fiji |
FK | Falkland Islands |
FM | Federated States of Micronesia |
FO | Faroe Islands |
FR | France |
GA | Gabon |
GB | United Kingdom |
GD | Grenada |
GE | Georgia (country) |
GF | French Guiana |
GG | Guernsey |
GH | Ghana |
GI | Gibraltar |
GL | Greenland |
GM | The Gambia |
GN | Guinea |
GP | Guadeloupe |
GQ | Equatorial Guinea |
GR | Greece |
GS | South Georgia and the South Sandwich Islands |
GT | Guatemala |
GU | Guam |
GW | Guinea-Bissau |
GY | Guyana |
HK | Hong Kong |
HM | Heard Island and McDonald Islands |
HN | Honduras |
HR | Croatia |
HT | Haiti |
HU | Hungary |
ID | Indonesia |
IE | Republic of Ireland |
IL | Israel |
IM | Isle of Man |
IN | India |
IO | British Indian Ocean Territory |
IQ | Iraq |
IR | Iran |
IS | Iceland |
IT | Italy |
JE | Jersey |
JM | Jamaica |
JO | Jordan |
JP | Japan |
KE | Kenya |
KG | Kyrgyzstan |
KH | Cambodia |
KI | Kiribati |
KM | Comoros |
KN | Saint Kitts and Nevis |
KP | North Korea |
KR | South Korea |
KW | Kuwait |
KY | Cayman Islands |
KZ | Kazakhstan |
LA | Laos |
LB | Lebanon |
LC | Saint Lucia |
LI | Liechtenstein |
LK | Sri Lanka |
LR | Liberia |
LS | Lesotho |
LT | Lithuania |
LU | Luxembourg |
LV | Latvia |
LY | Libya |
MA | Morocco |
MC | Monaco |
MD | Moldova |
ME | Montenegro |
MF | Martin (France) |
MG | Madagascar |
MH | Marshall Islands |
MK | Republic of Macedonia |
ML | Mali |
MM | Burma |
MN | Mongolia |
MO | Macau |
MP | Northern Mariana Islands |
MQ | Martinique |
MR | Mauritania |
MS | Montserrat |
MT | Malta |
MU | Mauritius |
MV | Maldives |
MW | Malawi |
MX | Mexico |
MY | Malaysia |
MZ | Mozambique |
NA | Namibia |
NC | New Caledonia |
NE | Niger |
NF | Norfolk Island |
NG | Nigeria |
NI | Nicaragua |
NL | Netherlands |
NO | Norway |
NP | Nepal |
NR | Nauru |
NU | Niue |
NZ | New Zealand |
OM | Oman |
PA | Panama |
PE | Peru |
PF | French Polynesia |
PG | Papua New Guinea |
PH | Philippines |
PK | Pakistan |
PL | Poland |
PM | Saint Pierre and Miquelon |
PN | Pitcairn Islands |
PR | Puerto Rico |
PS | Palestinian territories |
PT | Portugal |
PW | Palau |
PY | Paraguay |
QA | Qatar |
RE | Reunion |
RO | Romania |
RS | Serbia |
RU | Russia |
RW | Rwanda |
SA | Saudi Arabia |
SB | Solomon Islands |
SC | Seychelles |
SD | Sudan |
SE | Sweden |
SG | Singapore |
SH | Saint Helena |
SI | Slovenia |
SJ | Svalbard and Jan Mayen |
SK | Slovakia |
SL | Sierra Leone |
SM | San Marino |
SN | Senegal |
SO | Somalia |
SR | Suriname |
ST | São Tomé and Príncipe |
SV | El Salvador |
SY | Syria |
SZ | Swaziland |
TC | Turks and Caicos Islands |
TD | Chad |
TF | French Southern and Antarctic Lands |
TG | Togo |
TH | Thailand |
TJ | Tajikistan |
TK | Tokelau |
TL | East Timor |
TM | Turkmenistan |
TN | Tunisia |
TO | Tonga |
TR | Turkey |
TT | Trinidad and Tobago |
TV | Tuvalu |
TW | Taiwan |
TZ | Tanzania |
UA | Ukraine |
UG | Uganda |
UM | United States Minor Outlying Islands |
US | United States |
UY | Uruguay |
UZ | Uzbekistan |
VA | Vatican City |
VC | Saint Vincent and the Grenadines |
VE | Venezuela |
VG | British Virgin Islands |
VI | United States Virgin Islands |
VN | Vietnam |
VU | Vanuatu |
WF | Wallis and Futuna |
WS | Samoa |
YE | Yemen |
YT | Mayotte |
ZA | South Africa |
ZM | Zambia |
ZW | Zimbabwe |
Extended Details Tables
h_sys_ccodes does not have any extended/child tables associated with it.