What is Country Grouping Terminology

What is Country Grouping Terminology

Country Grouping is a group of countries that are treated as a single entity for the certification and specialization purposes. The member countries pool their resources in order to meet the requirements for certification and specialization. The country grouping is often referred to by a single term, word or abbreviation. The derivation of such terms includes political alliances, inter-governmental organization, business market areas and more.

GeoDataSource Country Grouping Terminology is a free data that provides a list of countries together with the grouping name. For example, APAC, ASEAN, EALA, OPEC, EU, etc. The country code follows the ISO 3166 standard which allows the data to be retrieved easily. The table below shows the example of the Country Grouping Terminology.

Example of Country Grouping

Group CodeCountries
APACAS, 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
ASEANBN, CN, ID, JP, KH, KR, LA, MM, MY, PH, SG, TH, VN
EUAT, 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 moreMany more

Data Fields

Below are the data fields for the Country Grouping Terminology add-on.

Field NameDescription
group_codeCode of countries group.
group_nameName of countries group.
country_codeTwo-character country code based on ISO 3166.

Data Table

In order to get the Country Grouping Terminology information, the country_grouping_terminology table can be created and loaded by the following code in MySQL.

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

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.

For more details about the Country Grouping Terminology add-on, you can visit https://www.geodatasource.com/addon/country-grouping-terminology to learn more about the information provided.

Was this article helpful?

Related Articles