MeridianMERIDIAN

Gender Code

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

Gender Code

identity.person.gender_code

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

Domain
identity
Category
person
Casts to
VARCHAR
Scope
broad_words

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

Type Registry