International Calling Code
geography.contact.calling_codeInternational dialing code for a country (e.g., +1 for USA/Canada, +44 for UK, +33 for France). May include +, may not.
Worked samples
DuckDB 1.5.5 · finetype 0.6.64
| Value | As VARCHAR | code |
|---|---|---|
| +1 | +1 | 1 |
| +44 | +44 | 44 |
| +33 | +33 | 33 |
| +81 | +81 | 81 |
| 1 | 1 | 1 |
| AR | ^\+?966$ |
| AT | ^\+?43$ |
| BE | ^\+?32$ |
| CH | ^\+?41$ |
| CZ | ^\+?420$ |
| DE | ^\+?49$ |
| DK | ^\+?45$ |
| EN | ^\+?1$ |
| EN_AU | ^\+?61$ |
| EN_CA | ^\+?1$ |
| EN_GB | ^\+?44$ |
| EN_US | ^\+?1$ |
| ES | ^\+?34$ |
| ES_AR | ^\+?54$ |
| ES_CL | ^\+?56$ |
| ES_CO | ^\+?57$ |
| ES_MX | ^\+?52$ |
| ES_PE | ^\+?51$ |
| FI | ^\+?358$ |
| FR | ^\+?33$ |
| GR | ^\+?30$ |
| HI | ^\+?91$ |
| HU | ^\+?36$ |
| ID | ^\+?62$ |
| IE | ^\+?353$ |
| IL | ^\+?972$ |
| IT | ^\+?39$ |
| JA | ^\+?81$ |
| KO | ^\+?82$ |
| MY | ^\+?60$ |
| NG | ^\+?234$ |
| NL | ^\+?31$ |
| NO | ^\+?47$ |
| NZ | ^\+?64$ |
| PH | ^\+?63$ |
| PL | ^\+?48$ |
| PT | ^\+?351$ |
| PT_BR | ^\+?55$ |
| RO | ^\+?40$ |
| RU | ^\+?7$ |
| SE | ^\+?46$ |
| SG | ^\+?65$ |
| TH | ^\+?66$ |
| TR | ^\+?90$ |
| TW | ^\+?886$ |
| ZA | ^\+?27$ |
| ZH | ^\+?86$ |
Shape
^\+?[0-9]{1,4}$| Value | Length | Shape |
|---|---|---|
| +1 | 2 | matches |
| +44 | 3 | matches |
| +33 | 3 | matches |
| +81 | 3 | matches |
| 1 | 1 | matches |
| + | 1 | rejected: one character short |
Background
Origin
Recommendation E.164 is published by the Telecommunication Standardization Sector of the International Telecommunication Union (ITU-T).[1] The version of E.164 in force is E.164 (02/26).[2]
E.164 recommends that the national (significant) number be at most 15 – n digits, where n is the number of digits in the country code.[1] E.164 defines the country code for Global Services as a 3-digit country code.[1]
ITU-T Recommendation E.123 says the international prefix symbol should be + (plus) and should precede the country code in the international number.[3] E.123 explains that the plus sign reminds the subscriber to dial the international prefix, which differs from country to country.[3] E.123 also says the plus sign identifies the number following it as the international telephone number.[3]
Use
The ITU publishes a List of ITU-T Recommendation E.164 assigned country codes, in numerical and alphabetical order.[4] The 2005 edition of the ITU list gives code 7 to both Kazakhstan and the Russian Federation.[4] The 2005 edition of the ITU list marks country code 0 as reserved.[4]
Wikipedia writes the members of the North American Numbering Plan as 1 followed by a three-digit area code, such as 1 (684) for American Samoa.[5] GeoNames' countryInfo.txt gives American Samoa's phone code as +1-684.[6] GeoNames' countryInfo.txt gives the Dominican Republic's phone code as +1-809 and 1-829.[6] Before validating a calling-code column, look for these area-code variants and multi-value cells, and decide whether to keep the area code or reduce each value to the bare country code. (Meridian's view)
The 2005 edition of the ITU list shows Vatican City State under both 39 and 379.[4] GeoNames' countryInfo.txt gives Vatican's phone code as 379.[6]
In the libphonenumber README, a Swiss number parsed with region CH yields a country_code of 41.[7] The libphonenumber README shows the same Swiss number formatted in E.164 as +41446681800.[7] Store calling codes as text, strip any leading plus before comparing, and keep the plus only for display. (Meridian's view)
Sources
- [1]Recommendation ITU-T E.164 (02/2026) The international public telecommunication numbering planstandard
- [2]E.164 : The international public telecommunication numbering plancatalogue entry
- [3]ITU-T Rec. E.123 (02/2001) Notation for national and international telephone numbers, e-mail addresses and web addressesstandard
- [4]List of ITU-T Recommendation E.164 assigned country codes (Position on 1 May 2005)standard
- [5]List of telephone country codessecondary source
- [6]countryInfo.txtdataset
- [7]GitHub - google/libphonenumber: Google's common Java, C++ and JavaScript library for parsing, formatting, and validating international phone numbers.documentation
Detection notes
v1 migration: Was address.calling_code (also aliased to address.isd_code). May include +, may not. Locale-specific for country association. Range: 1-4 digits.
Use it
$ finetype infer -i "+1" --mode column
→ geography.contact.calling_code
SELECT ft_infer('+1');
-- → 'geography.contact.calling_code'CAST({col} AS VARCHAR)Schema
https://meridian.online/schemas/geography.contact.calling_code · Frictionless type string
finetype taxonomy geography.contact.calling_code -o json-schema