Accepted country names

Looker’s default world (choropleth) map reads in “full” country names or ISO 3166-1 alpha-3 country codes. It’s a great way to visualize a world of data, but it requires fairly specific data. If you don’t know what format your data need to be in, we’ve got you covered! Here, we’ll cover converting two-character country codes to three-character ones and the list of accepted country names.

###Country codes
There’s a list of ISO 3166-1 alpha-3 country codes on wikipedia, but if you’re currently working with two-digit codes, it’s not super helpful. To convert two-digit codes to three-digit ones, I recommend a dimension along these lines:

- dimension: country                                       
    sql: |
      CASE
        WHEN ${TABLE}.geo_country = 'AF' THEN 'AFG'
        WHEN ${TABLE}.geo_country = 'AX' THEN 'ALA'
        WHEN ${TABLE}.geo_country = 'AL' THEN 'ALB'
        WHEN ${TABLE}.geo_country = 'DZ' THEN 'DZA'
        WHEN ${TABLE}.geo_country = 'AS' THEN 'ASM'
        WHEN ${TABLE}.geo_country = 'AD' THEN 'AND'
        WHEN ${TABLE}.geo_country = 'AO' THEN 'AGO'
        WHEN ${TABLE}.geo_country = 'AI' THEN 'AIA'
        WHEN ${TABLE}.geo_country = 'AQ' THEN 'ATA'
        WHEN ${TABLE}.geo_country = 'AG' THEN 'ATG'
        WHEN ${TABLE}.geo_country = 'AR' THEN 'ARG'
        WHEN ${TABLE}.geo_country = 'AM' THEN 'ARM'
        WHEN ${TABLE}.geo_country = 'AW' THEN 'ABW'
        WHEN ${TABLE}.geo_country = 'AU' THEN 'AUS'
        WHEN ${TABLE}.geo_country = 'AT' THEN 'AUT'
        WHEN ${TABLE}.geo_country = 'AZ' THEN 'AZE'
        WHEN ${TABLE}.geo_country = 'BS' THEN 'BHS'
        WHEN ${TABLE}.geo_country = 'BH' THEN 'BHR'
        WHEN ${TABLE}.geo_country = 'BD' THEN 'BGD'
        WHEN ${TABLE}.geo_country = 'BB' THEN 'BRB'
        WHEN ${TABLE}.geo_country = 'BY' THEN 'BLR'
        WHEN ${TABLE}.geo_country = 'BE' THEN 'BEL'
        WHEN ${TABLE}.geo_country = 'BZ' THEN 'BLZ'
        WHEN ${TABLE}.geo_country = 'BJ' THEN 'BEN'
        WHEN ${TABLE}.geo_country = 'BM' THEN 'BMU'
        WHEN ${TABLE}.geo_country = 'BT' THEN 'BTN'
        WHEN ${TABLE}.geo_country = 'BO' THEN 'BOL'
        WHEN ${TABLE}.geo_country = 'BQ' THEN 'BES'
        WHEN ${TABLE}.geo_country = 'BA' THEN 'BIH'
        WHEN ${TABLE}.geo_country = 'BW' THEN 'BWA'
        WHEN ${TABLE}.geo_country = 'BV' THEN 'BVT'
        WHEN ${TABLE}.geo_country = 'BR' THEN 'BRA'
        WHEN ${TABLE}.geo_country = 'IO' THEN 'IOT'
        WHEN ${TABLE}.geo_country = 'BN' THEN 'BRN'
        WHEN ${TABLE}.geo_country = 'BG' THEN 'BGR'
        WHEN ${TABLE}.geo_country = 'BF' THEN 'BFA'
        WHEN ${TABLE}.geo_country = 'BI' THEN 'BDI'
        WHEN ${TABLE}.geo_country = 'KH' THEN 'KHM'
        WHEN ${TABLE}.geo_country = 'CM' THEN 'CMR'
        WHEN ${TABLE}.geo_country = 'CA' THEN 'CAN'
        WHEN ${TABLE}.geo_country = 'CV' THEN 'CPV'
        WHEN ${TABLE}.geo_country = 'KY' THEN 'CYM'
        WHEN ${TABLE}.geo_country = 'CF' THEN 'CAF'
        WHEN ${TABLE}.geo_country = 'TD' THEN 'TCD'
        WHEN ${TABLE}.geo_country = 'CL' THEN 'CHL'
        WHEN ${TABLE}.geo_country = 'CN' THEN 'CHN'
        WHEN ${TABLE}.geo_country = 'CX' THEN 'CXR'
        WHEN ${TABLE}.geo_country = 'CC' THEN 'CCK'
        WHEN ${TABLE}.geo_country = 'CO' THEN 'COL'
        WHEN ${TABLE}.geo_country = 'KM' THEN 'COM'
        WHEN ${TABLE}.geo_country = 'CG' THEN 'COG'
        WHEN ${TABLE}.geo_country = 'CD' THEN 'COD'
        WHEN ${TABLE}.geo_country = 'CK' THEN 'COK'
        WHEN ${TABLE}.geo_country = 'CR' THEN 'CRI'
        WHEN ${TABLE}.geo_country = 'CI' THEN 'CIV'
        WHEN ${TABLE}.geo_country = 'HR' THEN 'HRV'
        WHEN ${TABLE}.geo_country = 'CU' THEN 'CUB'
        WHEN ${TABLE}.geo_country = 'CW' THEN 'CUW'
        WHEN ${TABLE}.geo_country = 'CY' THEN 'CYP'
        WHEN ${TABLE}.geo_country = 'CZ' THEN 'CZE'
        WHEN ${TABLE}.geo_country = 'DK' THEN 'DNK'
        WHEN ${TABLE}.geo_country = 'DJ' THEN 'DJI'
        WHEN ${TABLE}.geo_country = 'DM' THEN 'DMA'
        WHEN ${TABLE}.geo_country = 'DO' THEN 'DOM'
        WHEN ${TABLE}.geo_country = 'EC' THEN 'ECU'
        WHEN ${TABLE}.geo_country = 'EG' THEN 'EGY'
        WHEN ${TABLE}.geo_country = 'SV' THEN 'SLV'
        WHEN ${TABLE}.geo_country = 'GQ' THEN 'GNQ'
        WHEN ${TABLE}.geo_country = 'ER' THEN 'ERI'
        WHEN ${TABLE}.geo_country = 'EE' THEN 'EST'
        WHEN ${TABLE}.geo_country = 'ET' THEN 'ETH'
        WHEN ${TABLE}.geo_country = 'FK' THEN 'FLK'
        WHEN ${TABLE}.geo_country = 'FO' THEN 'FRO'
        WHEN ${TABLE}.geo_country = 'FJ' THEN 'FJI'
        WHEN ${TABLE}.geo_country = 'FI' THEN 'FIN'
        WHEN ${TABLE}.geo_country = 'FR' THEN 'FRA'
        WHEN ${TABLE}.geo_country = 'GF' THEN 'GUF'
        WHEN ${TABLE}.geo_country = 'PF' THEN 'PYF'
        WHEN ${TABLE}.geo_country = 'TF' THEN 'ATF'
        WHEN ${TABLE}.geo_country = 'GA' THEN 'GAB'
        WHEN ${TABLE}.geo_country = 'GM' THEN 'GMB'
        WHEN ${TABLE}.geo_country = 'GE' THEN 'GEO'
        WHEN ${TABLE}.geo_country = 'DE' THEN 'DEU'
        WHEN ${TABLE}.geo_country = 'GH' THEN 'GHA'
        WHEN ${TABLE}.geo_country = 'GI' THEN 'GIB'
        WHEN ${TABLE}.geo_country = 'GR' THEN 'GRC'
        WHEN ${TABLE}.geo_country = 'GL' THEN 'GRL'
        WHEN ${TABLE}.geo_country = 'GD' THEN 'GRD'
        WHEN ${TABLE}.geo_country = 'GP' THEN 'GLP'
        WHEN ${TABLE}.geo_country = 'GU' THEN 'GUM'
        WHEN ${TABLE}.geo_country = 'GT' THEN 'GTM'
        WHEN ${TABLE}.geo_country = 'GG' THEN 'GGY'
        WHEN ${TABLE}.geo_country = 'GN' THEN 'GIN'
        WHEN ${TABLE}.geo_country = 'GW' THEN 'GNB'
        WHEN ${TABLE}.geo_country = 'GY' THEN 'GUY'
        WHEN ${TABLE}.geo_country = 'HT' THEN 'HTI'
        WHEN ${TABLE}.geo_country = 'HM' THEN 'HMD'
        WHEN ${TABLE}.geo_country = 'VA' THEN 'VAT'
        WHEN ${TABLE}.geo_country = 'HN' THEN 'HND'
        WHEN ${TABLE}.geo_country = 'HK' THEN 'HKG'
        WHEN ${TABLE}.geo_country = 'HU' THEN 'HUN'
        WHEN ${TABLE}.geo_country = 'IS' THEN 'ISL'
        WHEN ${TABLE}.geo_country = 'IN' THEN 'IND'
        WHEN ${TABLE}.geo_country = 'ID' THEN 'IDN'
        WHEN ${TABLE}.geo_country = 'IR' THEN 'IRN'
        WHEN ${TABLE}.geo_country = 'IQ' THEN 'IRQ'
        WHEN ${TABLE}.geo_country = 'IE' THEN 'IRL'
        WHEN ${TABLE}.geo_country = 'IM' THEN 'IMN'
        WHEN ${TABLE}.geo_country = 'IL' THEN 'ISR'
        WHEN ${TABLE}.geo_country = 'IT' THEN 'ITA'
        WHEN ${TABLE}.geo_country = 'JM' THEN 'JAM'
        WHEN ${TABLE}.geo_country = 'JP' THEN 'JPN'
        WHEN ${TABLE}.geo_country = 'JE' THEN 'JEY'
        WHEN ${TABLE}.geo_country = 'JO' THEN 'JOR'
        WHEN ${TABLE}.geo_country = 'KZ' THEN 'KAZ'
        WHEN ${TABLE}.geo_country = 'KE' THEN 'KEN'
        WHEN ${TABLE}.geo_country = 'KI' THEN 'KIR'
        WHEN ${TABLE}.geo_country = 'KP' THEN 'PRK'
        WHEN ${TABLE}.geo_country = 'KR' THEN 'KOR'
        WHEN ${TABLE}.geo_country = 'KW' THEN 'KWT'
        WHEN ${TABLE}.geo_country = 'KG' THEN 'KGZ'
        WHEN ${TABLE}.geo_country = 'LA' THEN 'LAO'
        WHEN ${TABLE}.geo_country = 'LV' THEN 'LVA'
        WHEN ${TABLE}.geo_country = 'LB' THEN 'LBN'
        WHEN ${TABLE}.geo_country = 'LS' THEN 'LSO'
        WHEN ${TABLE}.geo_country = 'LR' THEN 'LBR'
        WHEN ${TABLE}.geo_country = 'LY' THEN 'LBY'
        WHEN ${TABLE}.geo_country = 'LI' THEN 'LIE'
        WHEN ${TABLE}.geo_country = 'LT' THEN 'LTU'
        WHEN ${TABLE}.geo_country = 'LU' THEN 'LUX'
        WHEN ${TABLE}.geo_country = 'MO' THEN 'MAC'
        WHEN ${TABLE}.geo_country = 'MK' THEN 'MKD'
        WHEN ${TABLE}.geo_country = 'MG' THEN 'MDG'
        WHEN ${TABLE}.geo_country = 'MW' THEN 'MWI'
        WHEN ${TABLE}.geo_country = 'MY' THEN 'MYS'
        WHEN ${TABLE}.geo_country = 'MV' THEN 'MDV'
        WHEN ${TABLE}.geo_country = 'ML' THEN 'MLI'
        WHEN ${TABLE}.geo_country = 'MT' THEN 'MLT'
        WHEN ${TABLE}.geo_country = 'MH' THEN 'MHL'
        WHEN ${TABLE}.geo_country = 'MQ' THEN 'MTQ'
        WHEN ${TABLE}.geo_country = 'MR' THEN 'MRT'
        WHEN ${TABLE}.geo_country = 'MU' THEN 'MUS'
        WHEN ${TABLE}.geo_country = 'YT' THEN 'MYT'
        WHEN ${TABLE}.geo_country = 'MX' THEN 'MEX'
        WHEN ${TABLE}.geo_country = 'FM' THEN 'FSM'
        WHEN ${TABLE}.geo_country = 'MD' THEN 'MDA'
        WHEN ${TABLE}.geo_country = 'MC' THEN 'MCO'
        WHEN ${TABLE}.geo_country = 'MN' THEN 'MNG'
        WHEN ${TABLE}.geo_country = 'ME' THEN 'MNE'
        WHEN ${TABLE}.geo_country = 'MS' THEN 'MSR'
        WHEN ${TABLE}.geo_country = 'MA' THEN 'MAR'
        WHEN ${TABLE}.geo_country = 'MZ' THEN 'MOZ'
        WHEN ${TABLE}.geo_country = 'MM' THEN 'MMR'
        WHEN ${TABLE}.geo_country = 'NA' THEN 'NAM'
        WHEN ${TABLE}.geo_country = 'NR' THEN 'NRU'
        WHEN ${TABLE}.geo_country = 'NP' THEN 'NPL'
        WHEN ${TABLE}.geo_country = 'NL' THEN 'NLD'
        WHEN ${TABLE}.geo_country = 'NC' THEN 'NCL'
        WHEN ${TABLE}.geo_country = 'NZ' THEN 'NZL'
        WHEN ${TABLE}.geo_country = 'NI' THEN 'NIC'
        WHEN ${TABLE}.geo_country = 'NE' THEN 'NER'
        WHEN ${TABLE}.geo_country = 'NG' THEN 'NGA'
        WHEN ${TABLE}.geo_country = 'NU' THEN 'NIU'
        WHEN ${TABLE}.geo_country = 'NF' THEN 'NFK'
        WHEN ${TABLE}.geo_country = 'MP' THEN 'MNP'
        WHEN ${TABLE}.geo_country = 'NO' THEN 'NOR'
        WHEN ${TABLE}.geo_country = 'OM' THEN 'OMN'
        WHEN ${TABLE}.geo_country = 'PK' THEN 'PAK'
        WHEN ${TABLE}.geo_country = 'PW' THEN 'PLW'
        WHEN ${TABLE}.geo_country = 'PS' THEN 'PSE'
        WHEN ${TABLE}.geo_country = 'PA' THEN 'PAN'
        WHEN ${TABLE}.geo_country = 'PG' THEN 'PNG'
        WHEN ${TABLE}.geo_country = 'PY' THEN 'PRY'
        WHEN ${TABLE}.geo_country = 'PE' THEN 'PER'
        WHEN ${TABLE}.geo_country = 'PH' THEN 'PHL'
        WHEN ${TABLE}.geo_country = 'PN' THEN 'PCN'
        WHEN ${TABLE}.geo_country = 'PL' THEN 'POL'
        WHEN ${TABLE}.geo_country = 'PT' THEN 'PRT'
        WHEN ${TABLE}.geo_country = 'PR' THEN 'PRI'
        WHEN ${TABLE}.geo_country = 'QA' THEN 'QAT'
        WHEN ${TABLE}.geo_country = 'RE' THEN 'REU'
        WHEN ${TABLE}.geo_country = 'RO' THEN 'ROU'
        WHEN ${TABLE}.geo_country = 'RU' THEN 'RUS'
        WHEN ${TABLE}.geo_country = 'RW' THEN 'RWA'
        WHEN ${TABLE}.geo_country = 'BL' THEN 'BLM'
        WHEN ${TABLE}.geo_country = 'SH' THEN 'SHN'
        WHEN ${TABLE}.geo_country = 'KN' THEN 'KNA'
        WHEN ${TABLE}.geo_country = 'LC' THEN 'LCA'
        WHEN ${TABLE}.geo_country = 'MF' THEN 'MAF'
        WHEN ${TABLE}.geo_country = 'PM' THEN 'SPM'
        WHEN ${TABLE}.geo_country = 'VC' THEN 'VCT'
        WHEN ${TABLE}.geo_country = 'WS' THEN 'WSM'
        WHEN ${TABLE}.geo_country = 'SM' THEN 'SMR'
        WHEN ${TABLE}.geo_country = 'ST' THEN 'STP'
        WHEN ${TABLE}.geo_country = 'SA' THEN 'SAU'
        WHEN ${TABLE}.geo_country = 'SN' THEN 'SEN'
        WHEN ${TABLE}.geo_country = 'RS' THEN 'SRB'
        WHEN ${TABLE}.geo_country = 'SC' THEN 'SYC'
        WHEN ${TABLE}.geo_country = 'SL' THEN 'SLE'
        WHEN ${TABLE}.geo_country = 'SG' THEN 'SGP'
        WHEN ${TABLE}.geo_country = 'SX' THEN 'SXM'
        WHEN ${TABLE}.geo_country = 'SK' THEN 'SVK'
        WHEN ${TABLE}.geo_country = 'SI' THEN 'SVN'
        WHEN ${TABLE}.geo_country = 'SB' THEN 'SLB'
        WHEN ${TABLE}.geo_country = 'SO' THEN 'SOM'
        WHEN ${TABLE}.geo_country = 'ZA' THEN 'ZAF'
        WHEN ${TABLE}.geo_country = 'GS' THEN 'SGS'
        WHEN ${TABLE}.geo_country = 'SS' THEN 'SSD'
        WHEN ${TABLE}.geo_country = 'ES' THEN 'ESP'
        WHEN ${TABLE}.geo_country = 'LK' THEN 'LKA'
        WHEN ${TABLE}.geo_country = 'SD' THEN 'SDN'
        WHEN ${TABLE}.geo_country = 'SR' THEN 'SUR'
        WHEN ${TABLE}.geo_country = 'SJ' THEN 'SJM'
        WHEN ${TABLE}.geo_country = 'SZ' THEN 'SWZ'
        WHEN ${TABLE}.geo_country = 'SE' THEN 'SWE'
        WHEN ${TABLE}.geo_country = 'CH' THEN 'CHE'
        WHEN ${TABLE}.geo_country = 'SY' THEN 'SYR'
        WHEN ${TABLE}.geo_country = 'TW' THEN 'TWN'
        WHEN ${TABLE}.geo_country = 'TJ' THEN 'TJK'
        WHEN ${TABLE}.geo_country = 'TZ' THEN 'TZA'
        WHEN ${TABLE}.geo_country = 'TH' THEN 'THA'
        WHEN ${TABLE}.geo_country = 'TL' THEN 'TLS'
        WHEN ${TABLE}.geo_country = 'TG' THEN 'TGO'
        WHEN ${TABLE}.geo_country = 'TK' THEN 'TKL'
        WHEN ${TABLE}.geo_country = 'TO' THEN 'TON'
        WHEN ${TABLE}.geo_country = 'TT' THEN 'TTO'
        WHEN ${TABLE}.geo_country = 'TN' THEN 'TUN'
        WHEN ${TABLE}.geo_country = 'TR' THEN 'TUR'
        WHEN ${TABLE}.geo_country = 'TM' THEN 'TKM'
        WHEN ${TABLE}.geo_country = 'TC' THEN 'TCA'
        WHEN ${TABLE}.geo_country = 'TV' THEN 'TUV'
        WHEN ${TABLE}.geo_country = 'UG' THEN 'UGA'
        WHEN ${TABLE}.geo_country = 'UA' THEN 'UKR'
        WHEN ${TABLE}.geo_country = 'AE' THEN 'ARE'
        WHEN ${TABLE}.geo_country = 'GB' THEN 'GBR'
        WHEN ${TABLE}.geo_country = 'US' THEN 'USA'
        WHEN ${TABLE}.geo_country = 'UM' THEN 'UMI'
        WHEN ${TABLE}.geo_country = 'UY' THEN 'URY'
        WHEN ${TABLE}.geo_country = 'UZ' THEN 'UZB'
        WHEN ${TABLE}.geo_country = 'VU' THEN 'VUT'
        WHEN ${TABLE}.geo_country = 'VE' THEN 'VEN'
        WHEN ${TABLE}.geo_country = 'VN' THEN 'VNM'
        WHEN ${TABLE}.geo_country = 'VG' THEN 'VGB'
        WHEN ${TABLE}.geo_country = 'VI' THEN 'VIR'
        WHEN ${TABLE}.geo_country = 'WF' THEN 'WLF'
        WHEN ${TABLE}.geo_country = 'EH' THEN 'ESH'
        WHEN ${TABLE}.geo_country = 'YE' THEN 'YEM'
        WHEN ${TABLE}.geo_country = 'ZM' THEN 'ZMB'
        WHEN ${TABLE}.geo_country = 'ZW' THEN 'ZWE'
      ELSE NULL
      END

Accepted country names

If you’re working with full country names, make sure your names are consistent with those below. If not, try a conversion similar to the one outlined above.

Afghanistan
Angola
Albania
United Arab Emirates
Argentina
Armenia
Antarctica
French Southern and Antarctic Lands
Australia
Austria
Azerbaijan
Burundi
Belgium
Benin
Burkina Faso
Bangladesh
Bulgaria
The Bahamas
Bosnia and Herzegovina
Belarus
Belize
Bolivia
Brazil
Brunei
Bhutan
Botswana
Central African Republic
Canada
Switzerland
Chile
China
Ivory Coast
Cameroon
Democratic Republic of the Congo
Republic of the Congo
Colombia
Costa Rica
Cuba
Northern Cyprus
Cyprus
Czech Republic
Germany
Djibouti
Denmark
Dominican Republic
Algeria
Ecuador
Egypt
Eritrea
Spain
Estonia
Ethiopia
Finland
Fiji
Falkland Islands
France
Gabon
United Kingdom
Georgia
Ghana
Guinea
Gambia
Guinea Bissau
Equatorial Guinea
Greece
Greenland
Guatemala
Guyana
Honduras
Croatia
Haiti
Hungary
Indonesia
India
Ireland
Iran
Iraq
Iceland
Israel
Italy
Jamaica
Jordan
Japan
Kazakhstan
Kenya
Kyrgyzstan
Cambodia
South Korea
Kosovo
Kuwait
Laos
Lebanon
Liberia
Libya
Sri Lanka
Lesotho
Lithuania
Luxembourg
Latvia
Morocco
Moldova
Madagascar
Mexico
Macedonia
Mali
Myanmar
Montenegro
Mongolia
Mozambique
Mauritania
Malawi
Malaysia
Namibia
New Caledonia
Niger
Nigeria
Nicaragua
Netherlands
Norway
Nepal
New Zealand
Oman
Pakistan
Panama
Peru
Philippines
Papua New Guinea
Poland
Puerto Rico
North Korea
Portugal
Paraguay
Qatar
Romania
Russia
Rwanda
Western Sahara
Saudi Arabia
Sudan
South Sudan
Senegal
Solomon Islands
Sierra Leone
El Salvador
Somaliland
Somalia
Republic of Serbia
Suriname
Slovakia
Slovenia
Sweden
Swaziland
Syria
Chad
Togo
Thailand
Tajikistan
Turkmenistan
East Timor
Trinidad and Tobago
Tunisia
Turkey
Taiwan
United Republic of Tanzania
Uganda
Ukraine
Uruguay
United States of America
Uzbekistan
Venezuela
Vietnam
Vanuatu
West Bank
Yemen
South Africa
Zambia
Zimbabwe

Here is a sample case statement to map country names to country codes:

  - dimension: country_code
    sql: |
      CASE 
        when ${TABLE}.country_name = 'Afghanistan' then 'AFG'
        when ${TABLE}.country_name = 'Åland Islands' then 'ALA'
        when ${TABLE}.country_name = 'Albania' then 'ALB'
        when ${TABLE}.country_name = 'Algeria' then 'DZA'
        when ${TABLE}.country_name = 'Argentina' then 'ARG'
        when ${TABLE}.country_name = 'Armenia' then 'ARM'
        when ${TABLE}.country_name = 'Australia' then 'AUS'
        when ${TABLE}.country_name = 'Austria' then 'AUT'
        when ${TABLE}.country_name = 'Azerbaijan' then 'AZE'
        when ${TABLE}.country_name = 'Belarus' then 'BLR'
        when ${TABLE}.country_name = 'Belgium' then 'BEL'
        when ${TABLE}.country_name = 'Bolivia, Plurinational State of' then 'BOL'
        when ${TABLE}.country_name = 'Botswana' then 'BWA'
        when ${TABLE}.country_name = 'Brazil' then 'BRA'
        when ${TABLE}.country_name = 'Brunei Darussalam' then 'BRN'
        when ${TABLE}.country_name = 'Bulgaria' then 'BGR'
        when ${TABLE}.country_name = 'Cambodia' then 'KHM'
        when ${TABLE}.country_name = 'Canada' then 'CAN'
        when ${TABLE}.country_name = 'Chile' then 'CHL'
        when ${TABLE}.country_name = 'China' then 'CHN'
        when ${TABLE}.country_name = 'Colombia' then 'COL'
        when ${TABLE}.country_name = 'Costa Rica' then 'CRI'
        when ${TABLE}.country_name = 'Croatia' then 'HRV'
        when ${TABLE}.country_name = 'Cyprus' then 'CYP'
        when ${TABLE}.country_name = 'Czech Republic' then 'CZE'
        when ${TABLE}.country_name = 'Denmark' then 'DNK'
        when ${TABLE}.country_name = 'Dominican Republic' then 'DOM'
        when ${TABLE}.country_name = 'Ecuador' then 'ECU'
        when ${TABLE}.country_name = 'Egypt' then 'EGY'
        when ${TABLE}.country_name = 'El Salvador' then 'SLV'
        when ${TABLE}.country_name = 'Estonia' then 'EST'
        when ${TABLE}.country_name = 'Fiji' then 'FJI'
        when ${TABLE}.country_name = 'Finland' then 'FIN'
        when ${TABLE}.country_name = 'France' then 'FRA'
        when ${TABLE}.country_name = 'Gabon' then 'GAB'
        when ${TABLE}.country_name = 'Germany' then 'DEU'
        when ${TABLE}.country_name = 'Ghana' then 'GHA'
        when ${TABLE}.country_name = 'Greece' then 'GRC'
        when ${TABLE}.country_name = 'Guatemala' then 'GTM'
        when ${TABLE}.country_name = 'Honduras' then 'HND'
        when ${TABLE}.country_name = 'Hong Kong' then 'HKG'
        when ${TABLE}.country_name = 'Hungary' then 'HUN'
        when ${TABLE}.country_name = 'Iceland' then 'ISL'
        when ${TABLE}.country_name = 'India' then 'IND'
        when ${TABLE}.country_name = 'Indonesia' then 'IDN'
        when ${TABLE}.country_name = 'Ireland' then 'IRL'
        when ${TABLE}.country_name = 'Isle of Man' then 'IMN'
        when ${TABLE}.country_name = 'Israel' then 'ISR'
        when ${TABLE}.country_name = 'Italy' then 'ITA'
        when ${TABLE}.country_name = 'Jamaica' then 'JAM'
        when ${TABLE}.country_name = 'Japan' then 'JPN'
        when ${TABLE}.country_name = 'Jordan' then 'JOR'
        when ${TABLE}.country_name = 'Kazakhstan' then 'KAZ'
        when ${TABLE}.country_name = 'Kenya' then 'KEN'
        when ${TABLE}.country_name like 'Korea, Democratic People%' then 'PRK'
        when ${TABLE}.country_name = 'Korea, Republic of' then 'KOR'
        when ${TABLE}.country_name = 'Kuwait' then 'KWT'
        when ${TABLE}.country_name = 'Latvia' then 'LVA'
        when ${TABLE}.country_name = 'Lebanon' then 'LBN'
        when ${TABLE}.country_name = 'Liechtenstein' then 'LIE'
        when ${TABLE}.country_name = 'Lithuania' then 'LTU'
        when ${TABLE}.country_name = 'Luxembourg' then 'LUX'
        when ${TABLE}.country_name = 'Malaysia' then 'MYS'
        when ${TABLE}.country_name = 'Maldives' then 'MDV'
        when ${TABLE}.country_name = 'Malta' then 'MLT'
        when ${TABLE}.country_name = 'Mexico' then 'MEX'
        when ${TABLE}.country_name = 'Morocco' then 'MAR'
        when ${TABLE}.country_name = 'Mozambique' then 'MOZ'
        when ${TABLE}.country_name = 'Myanmar' then 'MMR'
        when ${TABLE}.country_name = 'Netherlands' then 'NLD'
        when ${TABLE}.country_name = 'New Zealand' then 'NZL'
        when ${TABLE}.country_name = 'Nicaragua' then 'NIC'
        when ${TABLE}.country_name = 'Norway' then 'NOR'
        when ${TABLE}.country_name = 'Oman' then 'OMN'
        when ${TABLE}.country_name = 'Pakistan' then 'PAK'
        when ${TABLE}.country_name = 'Panama' then 'PAN'
        when ${TABLE}.country_name = 'Paraguay' then 'PRY'
        when ${TABLE}.country_name = 'Peru' then 'PER'
        when ${TABLE}.country_name = 'Philippines' then 'PHL'
        when ${TABLE}.country_name = 'Poland' then 'POL'
        when ${TABLE}.country_name = 'Portugal' then 'PRT'
        when ${TABLE}.country_name = 'Puerto Rico' then 'PRI'
        when ${TABLE}.country_name = 'Qatar' then 'QAT'
        when ${TABLE}.country_name = 'Romania' then 'ROU'
        when ${TABLE}.country_name = 'Russian Federation' then 'RUS'
        when ${TABLE}.country_name = 'Saudi Arabia' then 'SAU'
        when ${TABLE}.country_name = 'Singapore' then 'SGP'
        when ${TABLE}.country_name = 'Slovakia' then 'SVK'
        when ${TABLE}.country_name = 'Slovenia' then 'SVN'
        when ${TABLE}.country_name = 'South Africa' then 'ZAF'
        when ${TABLE}.country_name = 'Spain' then 'ESP'
        when ${TABLE}.country_name = 'Sri Lanka' then 'LKA'
        when ${TABLE}.country_name = 'Swaziland' then 'SWZ'
        when ${TABLE}.country_name = 'Sweden' then 'SWE'
        when ${TABLE}.country_name = 'Switzerland' then 'CHE'
        when ${TABLE}.country_name = 'Syrian Arab Republic' then 'SYR'
        when ${TABLE}.country_name = 'Taiwan, Province of China' then 'TWN'
        when ${TABLE}.country_name = 'Tanzania, United Republic of' then 'TZA'
        when ${TABLE}.country_name = 'Thailand' then 'THA'
        when ${TABLE}.country_name = 'Trinidad and Tobago' then 'TTO'
        when ${TABLE}.country_name = 'Tunisia' then 'TUN'
        when ${TABLE}.country_name = 'Turkey' then 'TUR'
        when ${TABLE}.country_name = 'Turks and Caicos Islands' then 'TCA'
        when ${TABLE}.country_name = 'Ukraine' then 'UKR'
        when ${TABLE}.country_name = 'United Arab Emirates' then 'ARE'
        when ${TABLE}.country_name = 'United Kingdom' then 'GBR'
        when ${TABLE}.country_name = 'United States' then 'USA'
        when ${TABLE}.country_name = 'United States Minor Outlying Islands' then 'UMI'
        when ${TABLE}.country_name = 'Uruguay' then 'URY'
        when ${TABLE}.country_name = 'Uzbekistan' then 'UZB'
        when ${TABLE}.country_name = 'Vanuatu' then 'VUT'
        when ${TABLE}.country_name = 'Viet Nam' then 'VNM'
        when ${TABLE}.country_name = 'Virgin Islands, U.S.' then 'VIR'
        when ${TABLE}.country_name = 'Zimbabwe' then 'ZWE'
      END
2 4 2,491
4 REPLIES 4

Neither the full country name, nor the alpha-3 code for Bahrain appears to work. I noticed Bahrain is in your first example, but not in the following two. Any thoughts why the map isn’t reading Bahrain, BHR?

Naomi_Johnson
Participant III

Hi, is there any update on Bahrain not showing up in maps? Thanks

MY choice is KSA

Dawid
Participant V

Are there any plans to use one of the official nomenclatures for the country names:

  • UNTERM (United Nations
  • ISO4217 Currency Country Name
  • “Official name” - UN Protocol and Liaison Service 
  • CLDR (Common Locale Data Repository)

Many datasets are available that have one of the above (or all!) but there’s always a mismatch for some countries. Let’s take UK as an example:

UNTERM Formal: the United Kingdom of Great Britain and Northern Ireland
UNTERM Short: United Kingdom of Great Britain and Northern Ireland (the)
ISO4217: UNITED KINGDOM OF GREAT BRITAIN AND NORTHERN IRELAND
Official: United Kingdom of Great Britain and Northern Ireland
CLDR: UK

Looker: United Kingdom

I know we may want to conserve space on the map or the label but I think using the correct names and increasing interoperability of the data is more important.

Top Labels in this Space
Top Solution Authors