I searched the internet for possible information/properties for countries and their currencies for developers/programmers, and got multiple sources and tables, then I began linking them to make a much more informative table, so it came out with these fields:
This will help in giving nationality / country / currency for applications.
also you can see a small application for it, in:
Countries & currencies & Languages & Culture Info for Developers
order | Field | Desc |
0 | ISO3166_1_numeric | Numeric codes from ISO 3166-1 (synonymous with UN Statistics M49 Codes) |
1 | eName | Country’s official English short name |
2 | aName | Country’s official Arabic short name |
3 | frName | Country’s offical French short name |
4 | ISO3166-1-Alpha-2 | Alpha-2 codes from ISO 3166-1 |
5 | ISO3166-1-Alpha-3 | Alpha-3 codes from ISO 3166-1 (synonymous with World Bank Codes) |
6 | ITU | Codes assigned by the International Telecommunications Union |
7 | MARC | MAchine-Readable Cataloging codes from the Library of Congress |
8 | WMO | Country abbreviations by the World Meteorological Organization |
9 | DS | Distinguishing signs of vehicles in international traffic |
10 | dialingCode | Country code from ITU-T recommendation E.164, sometimes followed by area code |
11 | FIFA | Codes assigned by the Fédération Internationale de Football Association |
12 | FIPS | Codes from the U.S. standard FIPS PUB 10-4 |
13 | GAUL | Global Administrative Unit Layers from the Food and Agriculture Organization |
14 | IOC | Codes assigned by the International Olympics Committee |
15 | currency_numeric_code | ISO 4217 currency numeric code |
16 | currency_alphabetic_code | ISO 4217 currency alphabetic code |
17 | currency_minor_unit | ISO 4217 currency number of minor units |
18 | currency_EName | ISO 4217 currency english name |
19 | currency_AName | currency Arabic name |
20 | currency_ESign | currency english sign |
21 | currency_ASign | currency arabic sign |
22 | capital_CityNo | Capital City number |
23 | GPSPoint_Latitude | GPS Latitude |
24 | GPSPoint_Longitude | GPS Longitude |
25 | exchangeRateToBaseCurrency | exchange Rate To Base Currency |
The data is in this Excel sheet:
Nationality Country & Dialing Codes – 2015-09-16
Field Sizes:
# | Field | Size |
0 | ISO3166_1_numeric | Integer |
1 | eName | varchar(150) |
2 | aName | nvarchar(150) |
3 | frName | nvarchar(150) |
4 | ISO3166-1-Alpha-2 | varchar(2) |
5 | ISO3166-1-Alpha-3 | varchar(3) |
6 | ITU | varchar(3) |
7 | MARC | varchar(15) |
8 | WMO | varchar(2) |
9 | DS | varchar(3) |
10 | dialingCode | varchar(30) |
11 | FIFA | varchar(30) |
12 | FIPS | varchar(50) |
13 | GAUL | Integer |
14 | IOC | varchar(3) |
15 | currency_numeric_code | Integer |
16 | currency_alphabetic_code | varchar(3) |
17 | currency_minor_unit | Integer |
18 | currency_EName | varchar(150) |
19 | currency_AName | nvarchar(150) |
20 | currency_ESign | varchar(6) |
21 | currency_ASign | nvarchar(6) |
22 | capital_CityNo | Integer |
23 | GPSPoint_Latitude | varchar(16) |
24 | GPSPoint_Longitude | varchar(16) |
25 | exchangeRateToBaseCurrency | Decimal(18,6) |
26 | decimalPlaces | smallint |
27 | decimalSeparator | nvarchar(5) |
28 | thousandsSeparator | nvarchar(5) |
29 | CR_CurrencyPositionType | smallint |
30 | CR_NegativeType | smallint |
The fields description in English:
# | Field | Description |
0 | ISO3166_1_numeric | Numeric codes from ISO 3166-1 (synonymous with UN Statistics M49 Codes) |
1 | eName | Country’s official English short name |
2 | aName | Country’s official Arabic short name |
3 | frName | Country’s offical French short name |
4 | ISO3166-1-Alpha-2 | Alpha-2 codes from ISO 3166-1 |
5 | ISO3166-1-Alpha-3 | Alpha-3 codes from ISO 3166-1 (synonymous with World Bank Codes) |
6 | ITU | Codes assigned by the International Telecommunications Union |
7 | MARC | MAchine-Readable Cataloging codes from the Library of Congress |
8 | WMO | Country abbreviations by the World Meteorological Organization |
9 | DS | Distinguishing signs of vehicles in international traffic |
10 | dialingCode | Country code from ITU-T recommendation E.164, sometimes followed by area code |
11 | FIFA | Codes assigned by the Fédération Internationale de Football Association |
12 | FIPS | Codes from the U.S. standard FIPS PUB 10-4 |
13 | GAUL | Global Administrative Unit Layers from the Food and Agriculture Organization |
14 | IOC | Codes assigned by the International Olympics Committee |
15 | currency_numeric_code | ISO 4217 currency numeric code |
16 | currency_alphabetic_code | ISO 4217 currency alphabetic code |
17 | currency_minor_unit | ISO 4217 currency number of minor units |
18 | currency_EName | ISO 4217 currency english name |
19 | currency_AName | currency Arabic name |
20 | currency_ESign | currency english sign |
21 | currency_ASign | currency arabic sign |
22 | capital_CityNo | Capital City number |
23 | GPSPoint_Latitude | GPS Latitude |
24 | GPSPoint_Longitude | GPS Longitude |
25 | exchangeRateToBaseCurrency | exchange Rate To Base Currency |
26 | decimalPlaces | number of decimals after the point |
27 | decimalSeparator | the character used for specifing the decimal |
28 | thousandsSeparator | the character used for specifing the thousand seperator |
29 | CR_CurrencyPositionType | Later |
30 | CR_NegativeType | Later |
The fields description in Arabic:
# | Field | عربي |
0 | ISO3166_1_numeric | رقم أيزو |
1 | eName | الاسم انجليزي |
2 | aName | الاسم عربي |
3 | frName | الاسم فرنسي |
4 | ISO3166-1-Alpha-2 | ايزو حرفين |
5 | ISO3166-1-Alpha-3 | ايزو ثلاث حروف |
6 | ITU | رمز الاتحاد الدولي للاتصالات |
7 | MARC | رمز مكتبة الكونغرس |
8 | WMO | رمز البلاد من قبل المنظمة العالمية للأرصاد الجوية |
9 | DS | العلامات المميزة للمركبات في حركة المرور الدولي |
10 | dialingCode | رمز البلد من ITU-T توصية E.164، وجاء في بعض الأحيان رمز المنطقة |
11 | FIFA | رموز فيفا |
12 | FIPS | رموز من PUB FIPS القياسية الولايات المتحدة |
13 | GAUL | طبقات الوحدة الإدارية العالمية من منظمة الأغذية والزراعة |
14 | IOC | رمز اللجنة الأولمبية الدولية |
15 | currency_numeric_code | ISO 4217 العملة رمز رقمي |
16 | currency_alphabetic_code | ISO 4217 العملة رمز أبجدي |
17 | currency_minor_unit | ISO 4217 عدد العملات وحدات صغيرة |
18 | currency_EName | ISO 4217 اسم العملة |
19 | currency_AName | اسم العملة بالعربي |
20 | currency_ESign | رمز العملة بالانجليزي |
21 | currency_ASign | رمز العملة بالعربي |
22 | capital_CityNo | رقم العاصمة |
23 | GPSPoint_Latitude | خط العرض |
24 | GPSPoint_Longitude | خط الطول |
25 | exchangeRateToBaseCurrency | قيمة التحويل من العملة الحالية إلى عملة البرنامج |
26 | decimalPlaces | عدد الخانات العشرية |
27 | decimalSeparator | الرمز المستخدم للتفرقة بين الرقم العشري والرقم الصحيح |
28 | thousandsSeparator | الرمز المستخدم للتفرقة بين الألاف |
29 | CR_CurrencyPositionType | |
30 | CR_NegativeType |
Fields for the Country Capital Table:
Field | Desc | عربي | Size |
CountryNo | ISO3166-1-numeric | رقم الدولة | Integer |
CountryCityNo | Capital City number | رقم العاصمة | Integer |
Capital EName | Capital English name | الاسم عربي | nvarchar(150) |
Capital AName | Capital Arabic name | الاسم انجليزي | varchar(150) |
Country Code | ISO3166-1-Alpha-3 | رقم الدولة الحرفي | varchar(3) |
GPSPoint_Latitude | GPS Latitude | خط العرض | varchar(16) |
GPSPoint_Longitude | GPS Longitude | خط الطول | varchar(16) |
References:
https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes
https://msdn.microsoft.com/en-us/library/ee825488(v=cs.20).aspx
http://timtrott.co.uk/culture-codes/
http://data.okfn.org/data/core/country-codes
https://www.unc.edu/~rowlett/units/codes/country.htm
http://www.nationsonline.org/oneworld/country_code_list.htm
https://en.wikipedia.org/wiki/ISO_3166-1_numeric
http://www.worldatlas.com/aatlas/ctycodes.htm
https://www.countries-ofthe-world.com/world-currencies.html
http://www.nationsonline.org/oneworld/currencies.htm
http://www.tripmondo.com/magazine/facts-and-statistics/list-of-capitals-and-countries/
http://www.yallaforex.net/school-yallaforex-pages/5.htm