• Your shopping cart is empty!

Country Grouping Terminology

FREE

A free data that provides list of countries together with the grouping name. For example, APAC, EALA, OPEC, etc. The country code follows the ISO 3166 standard which allow the data to be retrieved easily.

Specifications

Field Name Description Type Length
group_name Name of countries group. character 50
country_code Two-character country code based on ISO 3166. character 2

Example of Country Grouping

Group Name Countries
APAC AS, AU, BD, BN, BT, CC, CK, CN, CX, FJ, FM, GN, GU, HK, ID, IN, JP, KH, KI, KP, KR, LA, LK, MH, MM, MN, MO, MP, MV, MY, NC, NF, NP, NR, NU, NZ, PF, PH, PK, PN, PW, RU, SB, SG, TH, TK, TL, TO, TV, TW, VN, VU, WF, WS
ASEAN BN, CN, ID, JP, KH, KR, LA, MM, MY, PH, SG, TH, VN
BRIC BR, CN, IN, RU
BRICS BR, CN, IN, RU, ZA
EAC BI, KE, RW, SD, TZ, UG
EFTA CH, IS, LI, NO
EMEA AD, AE, AL, AM, AO, AT, AX, AZ, BA, BE, BG, BH, BI, BJ, BW, BY, CF, CG, CH, CI, CM, CV, CY, CZ, DE, DJ, DK, DZ, EE, EG, EH, ER, ES, ET, FI, FO, FR, GA, GB, GE, GG, GH, GI, GM, GN, GR, HR, HU, IE, IL, IM, IQ, IR, IS, IT, JE, JO, KE, KM, KW, KZ, LB, LI, LR, LS, LT, LU, LV, LY, MA, MC, MD, ME, MG, MK, ML, MR, MT, MU, MW, MZ, NA, NE, NL, NO, OM, PL, PT, QA, RE, RS, RU, RW, SA, SC, SD, SE, SH, SI, SK, SL, SM, SN, ST, SY, SZ, TD, TG, TN, TR, TZ, UA, UG, VA, YE, YT, ZA, ZM, ZW
EU AT, BE, BG, CY, CZ, DE, DK, EE, ES, FI, FR, GB, GR, HR, HU, IE, IT, LT, LU, LV, MT, NL, OM, PL, PT, SE, SI, SK
Many more Please visit https://github.com/geodatasource/country-grouping-terminology for complete data download

SQL Statement
-- Create table "country_grouping_terminology"
CREATE TABLE `country_grouping_terminology`(
	`group_name` VARCHAR(50),
	`country_code` VARCHAR(2),
	INDEX `idx_country_code` (`group_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Load data into table
LOAD DATA LOCAL
INFILE 'GEODATASOURCE-COUNTRY-GROUPING-TERMINOLOGY.CSV'
INTO TABLE `country_grouping_terminology`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;
-- Create table "country_grouping_terminology"
CREATE TABLE [geodatasource].[dbo].[country_grouping_terminology](
	[group_name] nvarchar(50) NOT NULL,
	[country_code] nvarchar(2) NOT NULL
) ON [PRIMARY]
GO

CREATE INDEX [idx_group_name] ON [geodatasource].[dbo].[country_grouping_terminology]([group_name]) ON [PRIMARY]
GO																	
Licensing

Single Server License

All prices mentioned in this page are for "Single Server License" unless specified otherwise. "Single Server License" can be used for 1 database server in a commercial environment with single or multiple connected clients.