• 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_code Code of countries group. character 50
group_name Name of countries group. character 200
country_code Two-character country code based on ISO 3166. character 2

Example of Country Grouping

Group Code 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_code` VARCHAR(50),
	`group_name` VARCHAR(200),
	`country_code` VARCHAR(2),
	INDEX `idx_group_code` (`group_code`)
) 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_code] nvarchar(50) NOT NULL,
	[group_name] nvarchar(200) NOT NULL,
	[country_code] nvarchar(2) NOT NULL
) ON [PRIMARY]
GO

CREATE INDEX [idx_group_code] ON [geodatasource].[dbo].[country_grouping_terminology]([group_code]) ON [PRIMARY]
GO																	
Licensing

The Country Grouping Terminology list data is licensed under Creative Commons Attribution-ShareAlike 4.0 International License. It is free for personal or commercial use with attribution required by mentioning the use of this data as follows,
This site or product includes Country Grouping Terminology List data available from https://www.geodatasource.com.