NDC (National Drug Code)

identity.medical.ndc

10-11 digit identifier for drug products in the US, assigned by the FDA. Three segments: labeler code, product code, package code. Common formats with dashes: 4-4-2, 5-3-2, or 5-4-1 (totaling 10 digits). May also appear as 11 digits with zero-padded segments.

Domain

identity

Try it

CLI

$ finetype infer -i "0002-1433-80"
→ identity.medical.ndc

DuckDB

Detect

SELECT finetype('0002-1433-80');
-- → 'identity.medical.ndc'

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.ndc';

JSON Schema

finetype schema identity.medical.ndc

{
  "$id": "https://meridian.online/schemas/identity.medical.ndc",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "10-11 digit identifier for drug products in the US, assigned by the FDA. Three segments: labeler code, product code, package code. Common formats with dashes: 4-4-2, 5-3-2, or 5-4-1 (totaling 10 digits). May also appear as 11 digits with zero-padded segments.",
  "examples": [
    "0002-1433-80",
    "12345-678-90",
    "12345-6789-0",
    "00021433801"
  ],
  "pattern": "^\\d{4}-\\d{4}-\\d{2}$|^\\d{5}-\\d{3}-\\d{2}$|^\\d{5}-\\d{4}-\\d{1}$|^\\d{11}$",
  "title": "NDC (National Drug Code)",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

0002-1433-8012345-678-9012345-6789-000021433801

Aliases

national_drug_codedrug_code