Gender Code

identity.person.gender_code

Single character or short code representing gender (M, F, X, O, etc.). Broad categorization.

Domain

identity

Try it

CLI

$ finetype infer -i "M"
→ identity.person.gender_code

DuckDB

Detect

SELECT finetype('M');
-- → 'identity.person.gender_code'

Cast expression

CAST(UPPER({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.gender_code';

JSON Schema

finetype schema identity.person.gender_code

{
  "$id": "https://meridian.online/schemas/identity.person.gender_code",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Single character or short code representing gender (M, F, X, O, etc.). Broad categorization.",
  "examples": [
    "M",
    "F",
    "X"
  ],
  "pattern": "^[MFX]$",
  "title": "Gender Code",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST(UPPER({col}) AS VARCHAR)"
}

Examples

MFX