First Name
Type Registry
First Name
identity.person.first_name Given name (first name). Locale-specific due to cultural naming conventions.
Domain identity›person
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 "John"
→ identity.person.first_name DuckDB
Detect
SELECT finetype('John');
-- → 'identity.person.first_name' 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) = 'identity.person.first_name'; JSON Schema
finetype schema identity.person.first_name {
"$id": "https://noon.sh/schemas/identity.person.first_name",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Given name (first name). Locale-specific due to cultural naming conventions.",
"examples": [
"John",
"María",
"Jacques",
"太郎",
"محمد"
],
"maxLength": 100,
"minLength": 1,
"pattern": "^[\\p{L}\\s'\\-]+$",
"title": "First Name",
"type": "string"
} Examples
JohnMaríaJacques太郎محمد Also known as
given_name