ICD-10 Diagnosis Code
International Classification of Diseases, 10th Revision code used to classify diagnoses and procedures. Format: letter + 2 digits + optional dot + up to 4 alphanumeric characters.
ICD-10 Diagnosis Code
identity.medical.icd10International Classification of Diseases, 10th Revision code used to classify diagnoses and procedures. Format: letter + 2 digits + optional dot + up to 4 alphanumeric characters.
Domain
identity
Category
medical
Casts to
VARCHAR
Scope
Universal
Try it
CLI
$ finetype infer -i "E11.9"
→ identity.medical.icd10DuckDB
Detect
SELECT finetype('E11.9');
-- → 'identity.medical.icd10'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.medical.icd10';JSON Schema
finetype schema identity.medical.icd10
{
"$id": "https://meridian.online/schemas/identity.medical.icd10",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "International Classification of Diseases, 10th Revision code used to classify diagnoses and procedures. Format: letter + 2 digits + optional dot + up to 4 alphanumeric characters.",
"examples": [
"E11.9",
"J18.9",
"M54.5",
"I10",
"Z00.00"
],
"pattern": "^[A-TV-Z][0-9][0-9AB](\\.[0-9A-TV-Z]{1,4})?$",
"title": "ICD-10 Diagnosis Code",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "CAST({col} AS VARCHAR)"
}Examples
E11.9J18.9M54.5I10Z00.00Aliases
icddiagnosis_code