NPI (National Provider Identifier)
10-digit numeric identifier for US healthcare providers, issued by CMS. Includes a Luhn check digit as the 10th digit. Required for HIPAA transactions. Format: exactly 10 digits starting with 1 or 2.
NPI (National Provider Identifier)
identity.medical.npi10-digit numeric identifier for US healthcare providers, issued by CMS. Includes a Luhn check digit as the 10th digit. Required for HIPAA transactions. Format: exactly 10 digits starting with 1 or 2.
Domain
identity
Category
medical
Casts to
VARCHAR
Scope
Universal
Try it
CLI
$ finetype infer -i "1234567893"
→ identity.medical.npiDuckDB
Detect
SELECT finetype('1234567893');
-- → 'identity.medical.npi'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.npi';JSON Schema
finetype schema identity.medical.npi
{
"$id": "https://meridian.online/schemas/identity.medical.npi",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "10-digit numeric identifier for US healthcare providers, issued by CMS. Includes a Luhn check digit as the 10th digit. Required for HIPAA transactions. Format: exactly 10 digits starting with 1 or 2.",
"examples": [
"1234567893",
"1003000126",
"1992789456"
],
"maxLength": 10,
"minLength": 10,
"pattern": "^[12]\\d{9}$",
"title": "NPI (National Provider Identifier)",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "CAST({col} AS VARCHAR)"
}Examples
123456789310030001261992789456Aliases
national_provider_identifierprovider_id