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
|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|
Below are the data fields for the Country Grouping Terminology add-on.
|group_code||Code of countries group.|
|group_name||Name of countries group.|
|country_code||Two-character country code based on ISO 3166.|
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;
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.