Gender Code
Single-character sex/gender code. ICAO Doc 9303 passport sex field uses M (male), F (female), X (unspecified). ISO/IEC 5218 numeric coding uses 0 (not known), 1 (male), 2 (female), 9 (not applicable). Matched case-insensitively (ac-02).
Gender Code
identity.person.gender_codeSingle-character sex/gender code. ICAO Doc 9303 passport sex field uses M (male), F (female), X (unspecified). ISO/IEC 5218 numeric coding uses 0 (not known), 1 (male), 2 (female), 9 (not applicable). Matched case-insensitively (ac-02).
Domain
identity
Category
person
Casts to
VARCHAR
Scope
broad_words
Try it
CLI
$ finetype infer -i "M" --mode column
→ identity.person.gender_codeDuckDB
Detect
SELECT ft_infer('M');
-- → 'identity.person.gender_code'Cast expression
CAST(UPPER({col}) AS VARCHAR)Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'identity.person.gender_code';JSON Schema
finetype taxonomy identity.person.gender_code -o json-schema
{
"$id": "https://meridian.online/schemas/identity.person.gender_code",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Single-character sex/gender code. ICAO Doc 9303 passport sex field uses M (male), F (female), X (unspecified). ISO/IEC 5218 numeric coding uses 0 (not known), 1 (male), 2 (female), 9 (not applicable). Matched case-insensitively (ac-02).",
"enum": [
"M",
"F",
"X",
"0",
"1",
"2",
"9"
],
"examples": [
"M",
"F",
"X",
"1"
],
"title": "Gender Code",
"type": "string",
"x-finetype-label": "identity.person.gender_code",
"x-finetype-pii": false
}Examples
MFX1