Countries
Look up the 249 countries and territories of ISO 3166-1 by code or by name in English or French, with their codes, names and currency. Typical uses: check a country code in an import, turn a country name typed by a user into its ISO code.
country info <code>
Description
A country by its code alpha-2, alpha-3 or numeric (case does not matter, UK is taken as GB). Result: {alpha2, alpha3, numeric, name, name_fr, currency, currency_name, calling_code, eu, eu_since, euro_area, euro_since, membership_checked}
A country by its code alpha-2, alpha-3 or numeric (case does not matter, UK is taken as GB). Result: {alpha2, alpha3, numeric, name, name_fr, currency, currency_name, calling_code, eu, eu_since, euro_area, euro_since, membership_checked}
Parameters
code: FR, FRA or 250 - String - required
code: FR, FRA or 250 - String - required
admin
country info "FR"
mentdb
{"alpha2": "FR", "alpha3": "FRA", "numeric": "250", "name": "France", "name_fr": "France", "currency": "EUR", "currency_name": "Euro", "calling_code": "+33", "eu": true, "eu_since": 1958, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}
By the numeric code
admin
country info "638"
mentdb
{"alpha2": "RE", "alpha3": "REU", "numeric": "638", "name": "Réunion", "name_fr": "La Réunion", "currency": "EUR", "currency_name": "Euro", "calling_code": "+262", "eu": false, "eu_since": null, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}
No currency and no calling code
admin
country info "AQ"
mentdb
{"alpha2": "AQ", "alpha3": "ATA", "numeric": "010", "name": "Antarctica", "name_fr": "Antarctique", "currency": null, "currency_name": null, "calling_code": null, "eu": false, "eu_since": null, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}
Used in use cases (1 recipe)
Integrator & ETL developer › Turn a country typed by a user into its ISO codes, calling code, currency and EU status
Integrator & ETL developer › Turn a country typed by a user into its ISO codes, calling code, currency and EU status
country list
Description
All the countries, by alpha-2 code
All the countries, by alpha-2 code
admin
country list
mentdb
[{"alpha2": "AD", "alpha3": "AND", "numeric": "020", "name": "Andorra", "name_fr": "Andorre", "currency": "EUR", "currency_name": "Euro", "calling_code": "+376", "eu": false, "eu_since": null, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}, ...]
country list <json_params>
Description
The countries with options: eu (true: the members of the EU only; false: the others), euro_area (true or false, same), sort (alpha2, name or name_fr)
The countries with options: eu (true: the members of the EU only; false: the others), euro_area (true or false, same), sort (alpha2, name or name_fr)
Parameters
json_params: The options, as a JSON object - String - required
json_params: The options, as a JSON object - String - required
admin
country list "{\"euro_area\": true, \"sort\": \"name_fr\"}"
mentdb
[{"alpha2": "DE", "alpha3": "DEU", "numeric": "276", "name": "Germany", "name_fr": "Allemagne", "currency": "EUR", "currency_name": "Euro", "calling_code": "+49", "eu": true, "eu_since": 1958, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "AT", "alpha3": "AUT", "numeric": "040", "name": "Austria", "name_fr": "Autriche", "currency": "EUR", "currency_name": "Euro", "calling_code": "+43", "eu": true, "eu_since": 1995, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "BE", "alpha3": "BEL", "numeric": "056", "name": "Belgium", "name_fr": "Belgique", "currency": "EUR", "currency_name": "Euro", "calling_code": "+32", "eu": true, "eu_since": 1958, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "BG", "alpha3": "BGR", "numeric": "100", "name": "Bulgaria", "name_fr": "Bulgarie", "currency": "EUR", "currency_name": "Euro", "calling_code": "+359", "eu": true, "eu_since": 2007, "euro_area": true, "euro_since": 2026, "membership_checked": "2026-11-10"}, {"alpha2": "CY", "alpha3": "CYP", "numeric": "196", "name": "Cyprus", "name_fr": "Chypre", "currency": "EUR", "currency_name": "Euro", "calling_code": "+357", "eu": true, "eu_since": 2004, "euro_area": true, "euro_since": 2008, "membership_checked": "2026-11-10"}, {"alpha2": "HR", "alpha3": "HRV", "numeric": "191", "name": "Croatia", "name_fr": "Croatie", "currency": "EUR", "currency_name": "Euro", "calling_code": "+385", "eu": true, "eu_since": 2013, "euro_area": true, "euro_since": 2023, "membership_checked": "2026-11-10"}, {"alpha2": "ES", "alpha3": "ESP", "numeric": "724", "name": "Spain", "name_fr": "Espagne", "currency": "EUR", "currency_name": "Euro", "calling_code": "+34", "eu": true, "eu_since": 1986, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "EE", "alpha3": "EST", "numeric": "233", "name": "Estonia", "name_fr": "Estonie", "currency": "EUR", "currency_name": "Euro", "calling_code": "+372", "eu": true, "eu_since": 2004, "euro_area": true, "euro_since": 2011, "membership_checked": "2026-11-10"}, {"alpha2": "FI", "alpha3": "FIN", "numeric": "246", "name": "Finland", "name_fr": "Finlande", "currency": "EUR", "currency_name": "Euro", "calling_code": "+358", "eu": true, "eu_since": 1995, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "FR", "alpha3": "FRA", "numeric": "250", "name": "France", "name_fr": "France", "currency": "EUR", "currency_name": "Euro", "calling_code": "+33", "eu": true, "eu_since": 1958, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "GR", "alpha3": "GRC", "numeric": "300", "name": "Greece", "name_fr": "Grèce", "currency": "EUR", "currency_name": "Euro", "calling_code": "+30", "eu": true, "eu_since": 1981, "euro_area": true, "euro_since": 2001, "membership_checked": "2026-11-10"}, {"alpha2": "IE", "alpha3": "IRL", "numeric": "372", "name": "Ireland", "name_fr": "Irlande", "currency": "EUR", "currency_name": "Euro", "calling_code": "+353", "eu": true, "eu_since": 1973, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "IT", "alpha3": "ITA", "numeric": "380", "name": "Italy", "name_fr": "Italie", "currency": "EUR", "currency_name": "Euro", "calling_code": "+39", "eu": true, "eu_since": 1958, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "LV", "alpha3": "LVA", "numeric": "428", "name": "Latvia", "name_fr": "Lettonie", "currency": "EUR", "currency_name": "Euro", "calling_code": "+371", "eu": true, "eu_since": 2004, "euro_area": true, "euro_since": 2014, "membership_checked": "2026-11-10"}, {"alpha2": "LT", "alpha3": "LTU", "numeric": "440", "name": "Lithuania", "name_fr": "Lituanie", "currency": "EUR", "currency_name": "Euro", "calling_code": "+370", "eu": true, "eu_since": 2004, "euro_area": true, "euro_since": 2015, "membership_checked": "2026-11-10"}, {"alpha2": "LU", "alpha3": "LUX", "numeric": "442", "name": "Luxembourg", "name_fr": "Luxembourg", "currency": "EUR", "currency_name": "Euro", "calling_code": "+352", "eu": true, "eu_since": 1958, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "MT", "alpha3": "MLT", "numeric": "470", "name": "Malta", "name_fr": "Malte", "currency": "EUR", "currency_name": "Euro", "calling_code": "+356", "eu": true, "eu_since": 2004, "euro_area": true, "euro_since": 2008, "membership_checked": "2026-11-10"}, {"alpha2": "NL", "alpha3": "NLD", "numeric": "528", "name": "Netherlands", "name_fr": "Pays-Bas", "currency": "EUR", "currency_name": "Euro", "calling_code": "+31", "eu": true, "eu_since": 1958, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "PT", "alpha3": "PRT", "numeric": "620", "name": "Portugal", "name_fr": "Portugal", "currency": "EUR", "currency_name": "Euro", "calling_code": "+351", "eu": true, "eu_since": 1986, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}, {"alpha2": "SK", "alpha3": "SVK", "numeric": "703", "name": "Slovakia", "name_fr": "Slovaquie", "currency": "EUR", "currency_name": "Euro", "calling_code": "+421", "eu": true, "eu_since": 2004, "euro_area": true, "euro_since": 2009, "membership_checked": "2026-11-10"}, {"alpha2": "SI", "alpha3": "SVN", "numeric": "705", "name": "Slovenia", "name_fr": "Slovénie", "currency": "EUR", "currency_name": "Euro", "calling_code": "+386", "eu": true, "eu_since": 2004, "euro_area": true, "euro_since": 2007, "membership_checked": "2026-11-10"}]
The EU members without the euro
admin
country list "{\"eu\": true, \"euro_area\": false}"
mentdb
[{"alpha2": "CZ", "alpha3": "CZE", "numeric": "203", "name": "Czechia", "name_fr": "Tchéquie", "currency": "CZK", "currency_name": "Czech Koruna", "calling_code": "+420", "eu": true, "eu_since": 2004, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}, {"alpha2": "DK", "alpha3": "DNK", "numeric": "208", "name": "Denmark", "name_fr": "Danemark", "currency": "DKK", "currency_name": "Danish Krone", "calling_code": "+45", "eu": true, "eu_since": 1973, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}, {"alpha2": "HU", "alpha3": "HUN", "numeric": "348", "name": "Hungary", "name_fr": "Hongrie", "currency": "HUF", "currency_name": "Hungarian Forint", "calling_code": "+36", "eu": true, "eu_since": 2004, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}, {"alpha2": "PL", "alpha3": "POL", "numeric": "616", "name": "Poland", "name_fr": "Pologne", "currency": "PLN", "currency_name": "Polish Zloty", "calling_code": "+48", "eu": true, "eu_since": 2004, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}, {"alpha2": "RO", "alpha3": "ROU", "numeric": "642", "name": "Romania", "name_fr": "Roumanie", "currency": "RON", "currency_name": "Romanian Leu", "calling_code": "+40", "eu": true, "eu_since": 2007, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}, {"alpha2": "SE", "alpha3": "SWE", "numeric": "752", "name": "Sweden", "name_fr": "Suède", "currency": "SEK", "currency_name": "Swedish Krona", "calling_code": "+46", "eu": true, "eu_since": 1995, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}]
Used in use cases (1 recipe)
Integrator & ETL developer › Turn a country typed by a user into its ISO codes, calling code, currency and EU status
Integrator & ETL developer › Turn a country typed by a user into its ISO codes, calling code, currency and EU status
country find <name>
Description
Find countries by name in English or French, with accents, case and punctuation ignored, or by code, or by a usual alias (UK, USA, Holland, Ivory Coast, Burma...). Result: the best first, each with match (name, alias, code, prefix, word or contains), score (100 to 50) and the fields of country info; 10 results at most
Find countries by name in English or French, with accents, case and punctuation ignored, or by code, or by a usual alias (UK, USA, Holland, Ivory Coast, Burma...). Result: the best first, each with match (name, alias, code, prefix, word or contains), score (100 to 50) and the fields of country info; 10 results at most
Parameters
name: A name, a part of a name or a code - String - required
name: A name, a part of a name or a code - String - required
admin
country find "cote d'ivoire"
mentdb
[{"match": "name", "score": 100, "alpha2": "CI", "alpha3": "CIV", "numeric": "384", "name": "Côte d\u2019Ivoire", "name_fr": "Côte d\u2019Ivoire", "currency": "XOF", "currency_name": "West African CFA Franc", "calling_code": "+225", "eu": false, "eu_since": null, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}]
A part of a name
admin
country find "guin"
mentdb
[{"match": "prefix", "score": 70, "alpha2": "GN", "alpha3": "GIN", "numeric": "324", "name": "Guinea", "name_fr": "Guinée", "currency": "GNF", "currency_name": "Guinean Franc", "calling_code": "+224", "eu": false, "eu_since": null, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}, {"match": "prefix", "score": 70, "alpha2": "GQ", "alpha3": "GNQ", "numeric": "226", "name": "Equatorial Guinea", "name_fr": "Guinée équatoriale", "currency": "XAF", "currency_name": "Central African CFA Franc", "calling_code": "+240", "eu": false, "eu_since": null, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}, {"match": "prefix", "score": 70, "alpha2": "GW", "alpha3": "GNB", "numeric": "624", "name": "Guinea-Bissau", "name_fr": "Guinée-Bissau", "currency": "XOF", "currency_name": "West African CFA Franc", "calling_code": "+245", "eu": false, "eu_since": null, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}, {"match": "word", "score": 60, "alpha2": "PG", "alpha3": "PNG", "numeric": "598", "name": "Papua New Guinea", "name_fr": "Papouasie-Nouvelle-Guinée", "currency": "PGK", "currency_name": "Papua New Guinean Kina", "calling_code": "+675", "eu": false, "eu_since": null, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}]
country find <name> <json_params>
Description
Find countries with options: max (10, 1 to 249), exact (false: true keeps only the whole names, codes and aliases)
Find countries with options: max (10, 1 to 249), exact (false: true keeps only the whole names, codes and aliases)
Parameters
name: A name, a part of a name or a code - String - required
json_params: The options, as a JSON object - String - required
name: A name, a part of a name or a code - String - required
json_params: The options, as a JSON object - String - required
admin
country find "Allemagne" "{\"exact\": true}"
mentdb
[{"match": "name", "score": 100, "alpha2": "DE", "alpha3": "DEU", "numeric": "276", "name": "Germany", "name_fr": "Allemagne", "currency": "EUR", "currency_name": "Euro", "calling_code": "+49", "eu": true, "eu_since": 1958, "euro_area": true, "euro_since": 1999, "membership_checked": "2026-11-10"}]
The first result only
admin
country find "usa" "{\"max\": 1}"
mentdb
[{"match": "code", "score": 90, "alpha2": "US", "alpha3": "USA", "numeric": "840", "name": "United States", "name_fr": "États-Unis", "currency": "USD", "currency_name": "US Dollar", "calling_code": "+1", "eu": false, "eu_since": null, "euro_area": false, "euro_since": null, "membership_checked": "2026-11-10"}]
Used in use cases (1 recipe)
Integrator & ETL developer › Turn a country typed by a user into its ISO codes, calling code, currency and EU status
Integrator & ETL developer › Turn a country typed by a user into its ISO codes, calling code, currency and EU status
