Meridianmeridian

International Calling Code

geography.contact.calling_code

International dialing code for a country (e.g., +1 for USA/Canada, +44 for UK, +33 for France). May include +, may not.

Domain
geography
Category
contact
Casts to
VARCHAR
Scope
Locale-specific
Locales
EN, EN_AU, EN_GB, EN_CA, EN_US, DE, FR, ES, IT, NL, PL, RU, JA, ZH, KO, AR, ZA, PT_BR, ES_MX, HI, ES_AR, ES_CL, ES_CO, ES_PE, SE, NO, DK, FI, CZ, HU, RO, GR, TR, IL, TH, MY, SG, PH, ID, TW, NZ, NG, PT, AT, CH, BE, IE

Try it

CLI
$ finetype infer -i "+1"
→ geography.contact.calling_code

DuckDB

Detect
SELECT finetype('+1');
-- → 'geography.contact.calling_code'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'geography.contact.calling_code';

Struct Expansion

Expression
code: REGEXP_EXTRACT({col}, '\+?([0-9]+)')

JSON Schema

finetype schema geography.contact.calling_code
{
  "$id": "https://meridian.online/schemas/geography.contact.calling_code",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "International dialing code for a country (e.g., +1 for USA/Canada, +44 for UK, +33 for France). May include +, may not.",
  "examples": [
    "+1",
    "+44",
    "+33",
    "+81",
    "1"
  ],
  "pattern": "^\\+?[0-9]{1,4}$",
  "title": "International Calling Code",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

+1+44+33+811

Aliases

isd_codecountry_code