Skip to content

International Calling Code

Type Registry

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›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

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

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

JSON Schema

finetype schema geography.contact.calling_code 
{
  "$id": "https://noon.sh/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"
}

Examples

+1+44+33+811

Also known as

isd_codecountry_code

Types in geography