Index

To edit the date format in our BI reports you can go to this link:

https://www.w3schools.com/sql/func_mysql_date_format.asp

List of country codes, below the image you can find the codes in text:

Back to the top

AF = “@@Afghanistan”, AX = “@@Åland Islands”, AL = “@@Albania”, DZ = “@@Algeria”, AS = “@@American Samoa”, AD = “@@Andorra”, AO = “@@Angola”, AI = “@@Anguilla”, AQ = “@@Antarctica”, AG = “@@Antigua and Barbuda”, AR = “@@Argentina”, AM = “@@Armenia”, AW = “@@Aruba”, AU = “@@Australia”, AT = “@@Austria”, AZ = “@@Azerbaijan”, BS = “@@Bahamas”, BH = “@@Bahrain”, BD = “@@Bangladesh”, BB = “@@Barbados”, BY = “@@Belarus”, BE = “@@Belgium”, BZ = “@@Belize”, BJ = “@@Benin”, BM = “@@Bermuda”, BT = “@@Bhutan”, BO = “@@Bolivia, Plurinational State of”, BQ = “@@Bonaire, Sint Eustatius and Saba”, BA = “@@Bosnia and Herzegovina”, BW = “@@Botswana”, BV = “@@Bouvet Island”, BR = “@@Brazil”, IO = “@@British Indian Ocean Territory”, BN = “@@Brunei Darussalam”, BG = “@@Bulgaria”, BF = “@@Burkina Faso”, BI = “@@Burundi”, KH = “@@Cambodia”, CM = “@@Cameroon”, CA = “@@Canada”, CV = “@@Cape Verde”, KY = “@@Cayman Islands”, CF = “@@Central African Republic”, TD = “@@Chad”, CL = “@@Chile”, CN = “@@China”, CX = “@@Christmas Island”, CC = “@@Cocos (Keeling) Islands”, CO = “@@Colombia”, KM = “@@Comoros”, CG = “@@Congo”, CD = “@@Congo, the Democratic Republic of the”, CK = “@@Cook Islands”, CR = “@@Costa Rica”, CI = “@@Côte d’Ivoire”, HR = “@@Croatia”, CU = “@@Cuba”, CW = “@@Curaçao”, CY = “@@Cyprus”, CZ = “@@Czech Republic”, DK = “@@Denmark”, DJ = “@@Djibouti”, DM = “@@Dominica”, DO = “@@Dominican Republic”, EC = “@@Ecuador”, EG = “@@Egypt”, SV = “@@El Salvador”, GQ = “@@Equatorial Guinea”, ER = “@@Eritrea”, EE = “@@Estonia”, ET = “@@Ethiopia”, FK = “@@Falkland Islands (Malvinas)”, FO = “@@Faroe Islands”, FJ = “@@Fiji”, FI = “@@Finland”, FR = “@@France”, GF = “@@French Guiana”, PF = “@@French Polynesia”, TF = “@@French Southern Territories”, GA = “@@Gabon”, GM = “@@Gambia”, GE = “@@Georgia”, DE = “@@Germany”, GH = “@@Ghana”, GI = “@@Gibraltar”, GR = “@@Greece”, GL = “@@Greenland”, GD = “@@Grenada”, GP = “@@Guadeloupe”, GU = “@@Guam”, GT = “@@Guatemala”, GG = “@@Guernsey”, GN = “@@Guinea”, GW = “@@Guinea-Bissau”, GY = “@@Guyana”, HT = “@@Haiti”, HM = “@@Heard Island and McDonald Mcdonald Islands”, VA = “@@Holy See (Vatican City State)”, HN = “@@Honduras”, HK = “@@Hong Kong”, HU = “@@Hungary”, IS = “@@Iceland”, IN = “@@India”, ID = “@@Indonesia”, IR = “@@Iran, Islamic Republic of”, IQ = “@@Iraq”, IE = “@@Ireland”, IM = “@@Isle of Man”, IL = “@@Israel”, IT = “@@Italy”, JM = “@@Jamaica”, JP = “@@Japan”, JE = “@@Jersey”, JO = “@@Jordan”, KZ = “@@Kazakhstan”, KE = “@@Kenya”, KI = “@@Kiribati”, KP = “@@Korea, Democratic People’s Republic of”, KR = “@@Korea, Republic of”, KW = “@@Kuwait”, KG = “@@Kyrgyzstan”, LA = “@@Lao People’s Democratic Republic”, LV = “@@Latvia”, LB = “@@Lebanon”, LS = “@@Lesotho”, LR = “@@Liberia”, LY = “@@Libya”, LI = “@@Liechtenstein”, LT = “@@Lithuania”, LU = “@@Luxembourg”, MO = “@@Macao”, MK = “@@Macedonia, the Former Yugoslav Republic of”, MG = “@@Madagascar”, MW = “@@Malawi”, MY = “@@Malaysia”, MV = “@@Maldives”, ML = “@@Mali”, MT = “@@Malta”, MH = “@@Marshall Islands”, MQ = “@@Martinique”, MR = “@@Mauritania”, MU = “@@Mauritius”, YT = “@@Mayotte”, MX = “@@Mexico”, FM = “@@Micronesia, Federated States of”, MD = “@@Moldova, Republic of”, MC = “@@Monaco”, MN = “@@Mongolia”, ME = “@@Montenegro”, MS = “@@Montserrat”, MA = “@@Morocco”, MZ = “@@Mozambique”, MM = “@@Myanmar”, NA = “@@Namibia”, NR = “@@Nauru”, NP = “@@Nepal”, NL = “@@Netherlands”, NC = “@@New Caledonia”, NZ = “@@New Zealand”, NI = “@@Nicaragua”, NE = “@@Niger”, NG = “@@Nigeria”, NU = “@@Niue”, NF = “@@Norfolk Island”, MP = “@@Northern Mariana Islands”, NO = “@@Norway”, OM = “@@Oman”, PK = “@@Pakistan”, PW = “@@Palau”, PS = “@@Palestine, State of”, PA = “@@Panama”, PG = “@@Papua New Guinea”, PY = “@@Paraguay”, PE = “@@Peru”, PH = “@@Philippines”, PN = “@@Pitcairn”, PL = “@@Poland”, PT = “@@Portugal”, PR = “@@Puerto Rico”, QA = “@@Qatar”, RE = “@@Réunion”, RO = “@@Romania”, RU = “@@Russian Federation”, RW = “@@Rwanda”, BL = “@@Saint Barthélemy”, SH = “@@Saint Helena, Ascension and Tristan da Cunha”, KN = “@@Saint Kitts and Nevis”, LC = “@@Saint Lucia”, MF = “@@Saint Martin (French part)”, PM = “@@Saint Pierre and Miquelon”, VC = “@@Saint Vincent and the Grenadines”, WS = “@@Samoa”, SM = “@@San Marino”, ST = “@@Sao Tome and Principe”, SA = “@@Saudi Arabia”, SN = “@@Senegal”, RS = “@@Serbia”, SC = “@@Seychelles”, SL = “@@Sierra Leone”, SG = “@@Singapore”, SX = “@@Sint Maarten (Dutch part)”, SK = “@@Slovakia”, SI = “@@Slovenia”, SB = “@@Solomon Islands”, SO = “@@Somalia”, ZA = “@@South Africa”, GS = “@@South Georgia and the South Sandwich Islands”, SS = “@@South Sudan”, ES = “@@Spain”, LK = “@@Sri Lanka”, SD = “@@Sudan”, SR = “@@Suriname”, SJ = “@@Svalbard and Jan Mayen”, SZ = “@@Swaziland”, SE = “@@Sweden”, CH = “@@Switzerland”, SY = “@@Syrian Arab Republic”, TW = “@@Taiwan, Province of China”, TJ = “@@Tajikistan”, TZ = “@@Tanzania, United Republic of”, TH = “@@Thailand”, TL = “@@Timor-Leste”, TG = “@@Togo”, TK = “@@Tokelau”, TO = “@@Tonga”, TT = “@@Trinidad and Tobago”, TN = “@@Tunisia”, TR = “@@Turkey”, TM = “@@Turkmenistan”, TC = “@@Turks and Caicos Islands”, TV = “@@Tuvalu”, UG = “@@Uganda”, UA = “@@Ukraine”, AE = “@@United Arab Emirates”, GB = “@@United Kingdom”, US = “@@United States”, UM = “@@United States Minor Outlying Islands”, UY = “@@Uruguay”, UZ = “@@Uzbekistan”, VU = “@@Vanuatu”, VE = “@@Venezuela, Bolivarian Republic of”, VN = “@@Viet Nam”, VG = “@@Virgin Islands, British”, VI = “@@Virgin Islands, U.S.”, WF = “@@Wallis and Futuna”, EH = “@@Western Sahara”, YE = “@@Yemen”, ZM = “@@Zambia”, ZW = “@@Zimbabwe”, UU = “@@Unknown”

NOTE: For the report:

"column":"IF(x.nationality = 'AF','Afghanistan',IF(x.nationality = 'AX','Åland Islands',IF(x.nationality = 'AL','Albania',IF(x.nationality = 'DZ','Algeria',IF(x.nationality = 'AS','American Samoa',IF(x.nationality = 'AD','Andorra',IF(x.nationality = 'AO','Angola',IF(x.nationality = 'AI','Anguilla',IF(x.nationality = 'AQ','Antarctica',IF(x.nationality = 'AG','Antigua and Barbuda',IF(x.nationality = 'AR','Argentina',IF(x.nationality = 'AM','Armenia',IF(x.nationality = 'AW','Aruba',IF(x.nationality = 'AU','Australia',IF(x.nationality = 'AT','Austria',IF(x.nationality = 'AZ','Azerbaijan',IF(x.nationality = 'BS','Bahamas',IF(x.nationality = 'BH','Bahrain',IF(x.nationality = 'BD','Bangladesh',IF(x.nationality = 'BB','Barbados',IF(x.nationality = 'BY','Belarus',IF(x.nationality = 'BE','Belgium',IF(x.nationality = 'BZ','Belize',IF(x.nationality = 'BJ','Benin',IF(x.nationality = 'BM','Bermuda',IF(x.nationality = 'BT','Bhutan',IF(x.nationality = 'BO','Bolivia',IF(x.nationality = 'BQ','Bonaire',IF(x.nationality = 'BA','Bosnia and Herzegovina',IF(x.nationality = 'BW','Botswana',IF(x.nationality = 'BV','Bouvet Island',IF(x.nationality = 'BR','Brazil',IF(x.nationality = 'IO','British Indian Ocean Territory',IF(x.nationality = 'BN','Brunei Darussalam',IF(x.nationality = 'BG','Bulgaria',IF(x.nationality = 'BF','Burkina Faso',IF(x.nationality = 'BI','Burundi',IF(x.nationality = 'KH','Cambodia',IF(x.nationality = 'CM','Cameroon',IF(x.nationality = 'CA','Canada',IF(x.nationality = 'CV','Cape Verde',IF(x.nationality = 'KY','Cayman Islands',IF(x.nationality = 'CF','Central African Republic',IF(x.nationality = 'TD','Chad',IF(x.nationality = 'CL','Chile',IF(x.nationality = 'CN','China',IF(x.nationality = 'CX','Christmas Island',IF(x.nationality = 'CC','Cocos Islands',IF(x.nationality = 'CO','Colombia',IF(x.nationality = 'KM','Comoros',IF(x.nationality = 'CG','Congo',IF(x.nationality = 'CD','Congo',IF(x.nationality = 'CK','Cook Islands',IF(x.nationality = 'CR','Costa Rica',IF(x.nationality = 'CI','Cote d Ivoire',IF(x.nationality = 'HR','Croatia',IF(x.nationality = 'CU','Cuba',IF(x.nationality = 'CW','Curaçao',IF(x.nationality = 'CY','Cyprus',IF(x.nationality = 'CZ','Czech Republic',IF(x.nationality = 'DK','Denmark',IF(x.nationality = 'DJ','Djibouti',IF(x.nationality = 'DM','Dominica',IF(x.nationality = 'DO','Dominican Republic',IF(x.nationality = 'EC','Ecuador',IF(x.nationality = 'EG','Egypt',IF(x.nationality = 'SV','El Salvador',IF(x.nationality = 'GQ','Equatorial Guinea',IF(x.nationality = 'ER','Eritrea',IF(x.nationality = 'EE','Estonia',IF(x.nationality = 'ET','Ethiopia',IF(x.nationality = 'FK','Falkland Islands',IF(x.nationality = 'FO','Faroe Islands',IF(x.nationality = 'FJ','Fiji',IF(x.nationality = 'FI','Finland',IF(x.nationality = 'FR','France',IF(x.nationality = 'GF','French Guiana',IF(x.nationality = 'PF','French Polynesia',IF(x.nationality = 'TF','French Southern Territories',IF(x.nationality = 'GA','Gabon',IF(x.nationality = 'GM','Gambia',IF(x.nationality = 'GE','Georgia',IF(x.nationality = 'DE','Germany',IF(x.nationality = 'GH','Ghana',IF(x.nationality = 'GI','Gibraltar',IF(x.nationality = 'GR','Greece',IF(x.nationality = 'GL','Greenland',IF(x.nationality = 'GD','Grenada',IF(x.nationality = 'GP','Guadeloupe',IF(x.nationality = 'GU','Guam',IF(x.nationality = 'GT','Guatemala',IF(x.nationality = 'GG','Guernsey',IF(x.nationality = 'GN','Guinea',IF(x.nationality = 'GW','Guinea-Bissau',IF(x.nationality = 'GY','Guyana',IF(x.nationality = 'HT','Haiti',IF(x.nationality = 'HM','Heard Island and McDonald Mcdonald Islands',IF(x.nationality = 'VA','Holy See',IF(x.nationality = 'HN','Honduras',IF(x.nationality = 'HK','Hong Kong',IF(x.nationality = 'HU','Hungary',IF(x.nationality = 'IS','Iceland',IF(x.nationality = 'IN','India',IF(x.nationality = 'ID','Indonesia',IF(x.nationality = 'IR','Iran',IF(x.nationality = 'IQ','Iraq',IF(x.nationality = 'IE','Ireland',IF(x.nationality = 'IM','Isle of Man',IF(x.nationality = 'IL','Israel',IF(x.nationality = 'IT','Italy',IF(x.nationality = 'JM','Jamaica',IF(x.nationality = 'JP','Japan',IF(x.nationality = 'JE','Jersey',IF(x.nationality = 'JO','Jordan',IF(x.nationality = 'KZ','Kazakhstan',IF(x.nationality = 'KE','Kenya',IF(x.nationality = 'KI','Kiribati',IF(x.nationality = 'KP','Korea',IF(x.nationality = 'KR','Korea',IF(x.nationality = 'KW','Kuwait',IF(x.nationality = 'KG','Kyrgyzstan',IF(x.nationality = 'LA','Lao',IF(x.nationality = 'LV','Latvia',IF(x.nationality = 'LB','Lebanon',IF(x.nationality = 'LS','Lesotho',IF(x.nationality = 'LR','Liberia',IF(x.nationality = 'LY','Libya',IF(x.nationality = 'LI','Liechtenstein',IF(x.nationality = 'LT','Lithuania',IF(x.nationality = 'LU','Luxembourg',IF(x.nationality = 'MO','Macao',IF(x.nationality = 'MK','Macedonia',IF(x.nationality = 'MG','Madagascar',IF(x.nationality = 'MW','Malawi',IF(x.nationality = 'MY','Malaysia',IF(x.nationality = 'MV','Maldives',IF(x.nationality = 'ML','Mali',IF(x.nationality = 'MT','Malta',IF(x.nationality = 'MH','Marshall Islands',IF(x.nationality = 'MQ','Martinique',IF(x.nationality = 'MR','Mauritania',IF(x.nationality = 'MU','Mauritius',IF(x.nationality = 'YT','Mayotte',IF(x.nationality = 'MX','Mexico',IF(x.nationality = 'FM','Micronesia',IF(x.nationality = 'MD','Moldova',IF(x.nationality = 'MC','Monaco',IF(x.nationality = 'MN','Mongolia',IF(x.nationality = 'ME','Montenegro',IF(x.nationality = 'MS','Montserrat',IF(x.nationality = 'MA','Morocco',IF(x.nationality = 'MZ','Mozambique',IF(x.nationality = 'MM','Myanmar',IF(x.nationality = 'NA','Namibia',IF(x.nationality = 'NR','Nauru',IF(x.nationality = 'NP','Nepal',IF(x.nationality = 'NL','Netherlands',IF(x.nationality = 'NC','New Caledonia',IF(x.nationality = 'NZ','New Zealand',IF(x.nationality = 'NI','Nicaragua',IF(x.nationality = 'NE','Niger',IF(x.nationality = 'NG','Nigeria',IF(x.nationality = 'NU','Niue',IF(x.nationality = 'NF','Norfolk Island',IF(x.nationality = 'MP','Northern Mariana Islands',IF(x.nationality = 'NO','Norway',IF(x.nationality = 'OM','Oman',IF(x.nationality = 'PK','Pakistan',IF(x.nationality = 'PW','Palau',IF(x.nationality = 'PS','Palestine',IF(x.nationality = 'PA','Panama',IF(x.nationality = 'PG','Papua New Guinea',IF(x.nationality = 'PY','Paraguay',IF(x.nationality = 'PE','Peru',IF(x.nationality = 'PH','Philippines',IF(x.nationality = 'PN','Pitcairn',IF(x.nationality = 'PL','Poland',IF(x.nationality = 'PT','Portugal',IF(x.nationality = 'PR','Puerto Rico',IF(x.nationality = 'QA','Qatar',IF(x.nationality = 'RE','Réunion',IF(x.nationality = 'RO','Romania',IF(x.nationality = 'RU','Russian Federation',IF(x.nationality = 'RW','Rwanda',IF(x.nationality = 'BL','Saint Barthélemy',IF(x.nationality = 'SH','Saint Helena',IF(x.nationality = 'KN','Saint Kitts and Nevis',IF(x.nationality = 'LC','Saint Lucia',IF(x.nationality = 'MF','Saint Martin',IF(x.nationality = 'PM','Saint Pierre and Miquelon',IF(x.nationality = 'VC','Saint Vincent and the Grenadines',IF(x.nationality = 'WS','Samoa',IF(x.nationality = 'SM','San Marino',IF(x.nationality = 'ST','Sao Tome and Principe',IF(x.nationality = 'SA','Saudi Arabia',IF(x.nationality = 'SN','Senegal',IF(x.nationality = 'RS','Serbia',IF(x.nationality = 'SC','Seychelles',IF(x.nationality = 'SL','Sierra Leone',IF(x.nationality = 'SG','Singapore',IF(x.nationality = 'SX','Sint Maarten',IF(x.nationality = 'SK','Slovakia',IF(x.nationality = 'SI','Slovenia',IF(x.nationality = 'SB','Solomon Islands',IF(x.nationality = 'SO','Somalia',IF(x.nationality = 'ZA','South Africa',IF(x.nationality = 'GS','South Georgia and the South Sandwich Islands',IF(x.nationality = 'SS','South Sudan',IF(x.nationality = 'ES','Spain',IF(x.nationality = 'LK','Sri Lanka',IF(x.nationality = 'SD','Sudan',IF(x.nationality = 'SR','Suriname',IF(x.nationality = 'SJ','Svalbard and Jan Mayen',IF(x.nationality = 'SZ','Swaziland',IF(x.nationality = 'SE','Sweden',IF(x.nationality = 'CH','Switzerland',IF(x.nationality = 'SY','Syrian Arab Republic',IF(x.nationality = 'TW','Taiwan',IF(x.nationality = 'TJ','Tajikistan',IF(x.nationality = 'TZ','Tanzania',IF(x.nationality = 'TH','Thailand',IF(x.nationality = 'TL','Timor-Leste',IF(x.nationality = 'TG','Togo',IF(x.nationality = 'TK','Tokelau',IF(x.nationality = 'TO','Tonga',IF(x.nationality = 'TT','Trinidad and Tobago',IF(x.nationality = 'TN','Tunisia',IF(x.nationality = 'TR','Turkey',IF(x.nationality = 'TM','Turkmenistan',IF(x.nationality = 'TC','Turks and Caicos Islands',IF(x.nationality = 'TV','Tuvalu',IF(x.nationality = 'UG','Uganda',IF(x.nationality = 'UA','Ukraine',IF(x.nationality = 'AE','United Arab Emirates',IF(x.nationality = 'GB','United Kingdom',IF(x.nationality = 'US','United States',IF(x.nationality = 'UM','United States Minor Outlying Islands',IF(x.nationality = 'UY','Uruguay',IF(x.nationality = 'UZ','Uzbekistan',IF(x.nationality = 'VU','Vanuatu',IF(x.nationality = 'VE','Venezuela',IF(x.nationality = 'VN','Viet Nam',IF(x.nationality = 'VG','Virgin Islands',IF(x.nationality = 'VI','Virgin Islands',IF(x.nationality = 'WF','Wallis and Futuna',IF(x.nationality = 'EH','Western Sahara',IF(x.nationality = 'YE','Yemen',IF(x.nationality = 'ZM','Zambia',IF(x.nationality = 'ZW','Zimbabwe','UU')))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))",

Back to the top