Numeric Code

representation.identifier.numeric_code

All-digit string where the digit pattern is meaningful and leading zeros must be preserved. Covers ISO country numeric codes (840, 036), NAICS/SIC industry codes, FIPS codes, product category codes, and similar classification systems. The critical property is that these values MUST remain as VARCHAR — casting to integer strips leading zeros and destroys the code's identity. Defers to geography.address.postal_code and identity.person.phone_number when those more specific types apply.

Domain

representation

Try it

CLI

$ finetype infer -i "840"
→ representation.identifier.numeric_code

DuckDB

Detect

SELECT finetype('840');
-- → 'representation.identifier.numeric_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) = 'representation.identifier.numeric_code';

JSON Schema

finetype schema representation.identifier.numeric_code

{
  "$id": "https://meridian.online/schemas/representation.identifier.numeric_code",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "All-digit string where the digit pattern is meaningful and leading zeros must be preserved. Covers ISO country numeric codes (840, 036), NAICS/SIC industry codes, FIPS codes, product category codes, and similar classification systems. The critical property is that these values MUST remain as VARCHAR — casting to integer strips leading zeros and destroys the code's identity. Defers to geography.address.postal_code and identity.person.phone_number when those more specific types apply.",
  "examples": [
    "840",
    "036",
    "5112",
    "06075",
    "0001",
    "99"
  ],
  "pattern": "^[0-9]+$",
  "title": "Numeric Code",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

840036511206075000199

Aliases

codeclassification_codecategory_code