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
EU	AT, BE, BG, CY, CZ, DE, DK, EE, ES, FI, FR, GR, HR, HU, IE, IT, LT, LU, LV, MT, NL, OM, PL, PT, SE, SI, SK
Many more	Many more

Country Grouping Terminology:

SQL Statement

MySQL
MS SQL

-- 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.