|
id
|
Primary Key for country entries
|
int(4)
|
|
PRI
|
1
|
NO
|
|
CLDR display name
|
Common Locale Data Repository provides key building blocks for software to support the world's languages, with the largest and most extensive standard repository of locale data available
|
varchar(255)
|
255
|
|
2
|
YES
|
|
ISO3166-1-numeric
|
Three-digit country codes defined in ISO 3166-1 published by the International Organization for Standardization (ISO)
|
int(11)
|
|
|
3
|
YES
|
|
ISO3166-1-Alpha-2
|
Two-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO)
|
char(2)
|
2
|
|
4
|
YES
|
|
ISO3166-1-Alpha-3
|
Three-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO)
|
char(3)
|
3
|
|
5
|
YES
|
|
official_name_ar
|
Official recognized country name in the Arabic language
|
varchar(255)
|
255
|
|
6
|
YES
|
|
official_name_cn
|
Official recognized country name in the Chinese/Mandarin language
|
varchar(255)
|
255
|
|
7
|
YES
|
|
official_name_en
|
Official recognized country name in the English language
|
varchar(255)
|
255
|
|
8
|
YES
|
|
official_name_es
|
Official recognized country name in the Spanish language
|
varchar(255)
|
255
|
|
9
|
YES
|
|
official_name_ru
|
Official recognized country name in the Russian language
|
varchar(255)
|
255
|
|
10
|
YES
|
|
official_name_fr
|
Official recognized country name in the French language
|
varchar(255)
|
255
|
|
11
|
YES
|
|
ISO4217-currency_alphabetic_code
|
Standard published by International Organization for Standardization (ISO) that represents currency
|
char(255)
|
255
|
|
12
|
YES
|
|
ISO4217-currency_country_name
|
standard published by International Organization for Standardization (ISO) that represents Country of currency
|
varchar(255)
|
255
|
|
13
|
YES
|
|
ISO4217-currency_minor_unit
|
Minor Unit of currency for standard published by International Organization for Standardization (ISO) that
|
char(5)
|
5
|
|
14
|
YES
|
|
ISO4217-currency_name
|
Name of currency for standard published by International Organization for Standardization (ISO) that
|
varchar(255)
|
255
|
|
15
|
YES
|
|
ISO4217-currency_numeric_code
|
Numeric Code for standard published by International Organization for Standardization (ISO) that
|
char(6)
|
6
|
|
16
|
YES
|
|
M49
|
UN M49 or the Standard Country or Area Codes for Statistical Use is a standard for area codes used by the United Nations for statistical purposes, developed and maintained by the United Nations Statistics Division
|
char(3)
|
3
|
|
17
|
YES
|
|
UNTERM Arabic Formal
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Arabic Country Name
|
varchar(255)
|
255
|
|
18
|
YES
|
|
UNTERM Arabic Short
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Arabic Country Name
|
varchar(255)
|
255
|
|
19
|
YES
|
|
UNTERM Chinese Formal
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Chinese Country Name
|
varchar(255)
|
255
|
|
20
|
YES
|
|
UNTERM Chinese Short
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Chinese Short Country Name
|
varchar(255)
|
255
|
|
21
|
YES
|
|
UNTERM English Formal
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for English Country Name
|
varchar(255)
|
255
|
|
22
|
YES
|
|
UNTERM English Short
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for English Short Country Name
|
varchar(255)
|
255
|
|
23
|
YES
|
|
UNTERM French Formal
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for French Country Name
|
varchar(255)
|
255
|
|
24
|
YES
|
|
UNTERM French Short
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for French Short Country Name
|
varchar(255)
|
255
|
|
25
|
YES
|
|
UNTERM Russian Formal
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Russian Country Name
|
varchar(255)
|
255
|
|
26
|
YES
|
|
UNTERM Russian Short
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Russian Short Country Name
|
varchar(255)
|
255
|
|
27
|
YES
|
|
UNTERM Spanish Formal
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Spanish Country Name
|
varchar(255)
|
255
|
|
28
|
YES
|
|
UNTERM Spanish Short
|
UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Spanish Short Country Name
|
varchar(255)
|
255
|
|
29
|
YES
|
|
Capital
|
Name of Official Capital for Country
|
varchar(255)
|
255
|
|
30
|
YES
|
|
Continent
|
The Continent Code the Country presides in
|
char(2)
|
2
|
|
31
|
YES
|
|
DS
|
code used for "distinquishing Signs" for Convention on Road Traffic (Geneva, 1949)
|
varchar(3)
|
3
|
|
32
|
YES
|
|
Developed / Developing Countries
|
Country falls under Developed or Developing Category
|
varchar(30)
|
30
|
|
33
|
YES
|
|
Dial
|
Unique Dial Code for respective Country
|
varchar(10)
|
10
|
|
34
|
YES
|
|
EDGAR
|
SEC EDGAR filing codes are used to submit documents to the EDGAR system in addition to accessing online tools and web sites. These codes are created and provided when a company or insider registers with the SEC as an EDGAR filer
|
varchar(255)
|
255
|
|
35
|
YES
|
|
FIFA
|
3 letter country code assigned by FIFA International Federation of Association Football
|
char(3)
|
3
|
|
36
|
YES
|
|
FIPS
|
2 letter country code assigned by the Federal Information Processing Standards (FIPS)
|
char(3)
|
3
|
|
37
|
YES
|
|
GAUL
|
GAUL is a relatively new initiative from the FAO (Food and Agriculture Organization), a specialized agency of the U.N. It aims to codify all the world's statoids and their changes,
|
char(10)
|
10
|
|
38
|
YES
|
|
Geoname ID
|
ID to identify country in GeoNames databases
|
varchar(20)
|
20
|
|
39
|
YES
|
|
Global Code
|
(Global Code) is a set of global principles of good practice in the foreign exchange market, developed to provide a common set of guidelines to promote the integrity and effective functioning of the wholesale foreign exchange market.
|
varchar(10)
|
10
|
|
40
|
YES
|
|
Global Name
|
Global name for country
|
varchar(10)
|
10
|
|
41
|
YES
|
|
IOC
|
3-letter codes assigned to country by the International Olympic Comittee (IOC)
|
char(3)
|
3
|
|
42
|
YES
|
|
ITU
|
letetr codes assigned to country by the International Telecommunication Union (ITU)
|
char(3)
|
3
|
|
43
|
YES
|
|
Intermediate Region Code
|
Code for the Smaller geographical subregions that the country is part of created by the United Nations
|
int(11)
|
|
|
44
|
YES
|
|
Intermediate Region Name
|
Smaller geographical subregions that the country is part of created by the United Nations
|
varchar(255)
|
255
|
|
45
|
YES
|
|
Land Locked Developing Countries (LLDC)
|
Landlocked developing countries (LLDC) are developing countries that are landlocked
|
char(1)
|
1
|
|
46
|
YES
|
|
Languages
|
Language codes of the country
|
varchar(30)
|
30
|
|
47
|
YES
|
|
Least Developed Countries (LDC)
|
Least developed countries (LDCs) are low-income countries confronting severe structural impediments to sustainable development. They are highly vulnerable to economic and environmental shocks and have low levels of human assets.
|
char(1)
|
1
|
|
48
|
YES
|
|
MARC
|
MARC is a standard for encoding bibliographic materials in electronic form. The Library of Congress maintains the MARC code list for countries
|
char(2)
|
2
|
|
49
|
YES
|
|
Region Code
|
UN M49 or the Standard Country or Area Codes for Statistical Use (Series M, No. 49) is a standard for area codes used by the United Nations for statistical purposes, developed and maintained by the United Nations Statistics Division
|
int(11)
|
|
|
50
|
YES
|
|
Region Name
|
Name of the Region Based on the UN M49 list
|
varchar(60)
|
60
|
|
51
|
YES
|
|
Small Island Developing States (SIDS)
|
Small Island Developing States (SIDS) are a distinct group of 38 UN Member States and 20 Non-UN Members/Associate Members of United Nations regional commissions that face unique social, economic and environmental vulnerabilities.
|
char(1)
|
1
|
|
52
|
YES
|
|
Sub-region Code
|
code that corresponds to the UN Region Code List
|
int(11)
|
|
|
53
|
YES
|
|
Sub-region Name
|
Name that corresponds to the UN Region Codelist
|
varchar(60)
|
60
|
|
54
|
YES
|
|
TLD
|
top-level domain (TLD) for a country
|
char(3)
|
3
|
|
55
|
YES
|
|
WMO
|
Meteorological codes are defined by the World Meteorological Organization in WMO
|
char(2)
|
2
|
|
56
|
YES
|
|
is_independent
|
Field is reserved to indicate the country's political sovereignty
|
varchar(30)
|
30
|
|
57
|
YES
|