Table of Countries and currencies Info for programmers

currencies 3I 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:

 

Countries & currenciesThis will help in giving nationality / country / currency for applications.

 also you can see a small application for it, in:

https://readerman1.wordpress.com/2015/09/07/countries-currencies-languages-culture-info-for-developers/

Countries & currencies 2

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

 

currencies 2

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

 

currencies 1

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

Countries 1

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)

 

currencies 4

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

https://goo.gl/i9rzwV

 

 

 

About Reader Man حسين ناجي الصفافير

حسين ناجي الصفافير Hussain Naji Al-Safafeer Info: https://readerman1.wordpress.com/aboutme
This entry was posted in Development and tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s