I’m trying to compile a list of sexually transmitted diseases using SNOMED-CT (I happen to be using OHDSI/OMOP concept tables in Databricks as my source for SNOMED-CT).
Querying the SNOMED-CT data from OHDSI Athena in OHDSI/OMOP using the query below, I get the results shown below. Notably missing from the ancestors is any indication that HIV is a sexually transmitted disease/infection.
Is there a way to use SNOMED-CT to create a somewhat comprehensive list of sexually transmitted diseases? Is there a better way to get to a list of codes (SNOMED or other, e.g. ICD) for sexually transmitted diseases/infections?
select distinct
parent.concept_id,
parent.concept_code,
parent.vocabulary_id,
parent.concept_name,
an.max_levels_of_separation,
an.min_levels_of_separation
from
concept con
join concept_ancestor an on 1=1
and an.descendant_concept_id = con.concept_id
join concept parent on 1=1
and parent.concept_id = an.ancestor_concept_id
where 1=1
and con.vocabulary_id = 'SNOMED'
and lower(con.concept_name) = 'acute hiv infection'
and con.domain_id = 'Condition'
order by parent.concept_name
;
This finding seems to be confirmed using other SNOMED-CT browsers, for example:
