medical
Codes and numbers from healthcare: CPT and HCPCS codes for procedures, services and supplies, ICD-10 diagnosis codes, LOINC codes for lab observations, NDC codes for drug products, and the DEA and NPI numbers of US prescribers and providers.
7 medical types: none a sibling also accepts, 2 in Meridian's open data.
The 7 medical types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
CPT Procedure Code cpt · VARCHAR | 99213 | — |
DEA Number dea_number · VARCHAR | AB1234563 | — |
HCPCS Level II Code hcpcs · VARCHAR | J1234 | — |
ICD-10 Diagnosis Code icd10 · VARCHAR | E11.9 | — |
LOINC Code loinc · VARCHAR | 2951-2 | — |
NDC (National Drug Code) ndc · VARCHAR | 0002-1433-80 | — |
NPI (National Provider Identifier) npi · VARCHAR | 1234567893 | — |
Which medical type is it?
1 of 7 medical types accepts it.
| Type | Reads it as |
|---|---|
CPT Procedure Code cpt | 99213 |
In Meridian's datasets
- HCPCS Level II Codehcpcs
.codehcpcs.code_display - NDC (National Drug Code)ndc
.codendc.code_display
Use it
Shell
printf '%s\n' '99213' '29580' > column.txt
finetype infer -f column.txt --mode columnDuckDB
SELECT ft_profile(v) FROM (VALUES ('99213'), ('29580')) t(v);After 29580, one type remains: cpt.