Convert icd-10 to snomed

Hello @freedafeng,

OMOP Vocabularies include mapping between ICD10 and SNOMED, you can have a look in Athena (vocabulary browser). When you open a result (example), there’s a field ‘Non-standard to Standard map (OMOP)’ — you’ll mostly see SNOMED concepts there.
For automated scenarios, you can download OMOP Vocabularies in CSV from Athena (account required), load them into a database using scripts from OHDSI/CommonDataModel repository and query for the mapping:

SELECT
    source.concept_code, source.concept_name,  -- ICD code + full name
    target.concept_code, target.concept_name   -- corresponding SNOMED concept
FROM concept source
INNER JOIN concept_relationship rel
    ON rel.concept_id_1 = source.concept_id    -- numeric ID for ICD code, OMOP-assigned
    AND rel.invalid_reason IS NULL             -- mapping is not deprecated
    AND rel.relationship_id = 'Maps to'        -- relationship for mapping between codes
INNER JOIN concept target
    ON target.concept_id = rel.concept_id_2
    AND target.invalid_reason IS NULL          -- SNOMED code should be valid
WHERE
    source.vocabulary_id = 'ICD10'   -- also ICD10CM, etc
    AND target.vocabulary_id = 'SNOMED'
2 Likes