inspectomop.queries.condition.condition_concepts_occurring_at_anatomical_site_concept_id

inspectomop.queries.condition.condition_concepts_occurring_at_anatomical_site_concept_id(concept_id, inspector, return_columns=None)

Retrieves condition concepts that occur at a given anatomical site. Input concept_id should be a concept of class ‘Body Structure’

Parameters:
  • concept_id (int) –
  • inspector (inspectomop.inspector.Inspector) –
  • return_columns (list of str, optional) –
    • optional subset of columns to return from the query
    • columns : [‘cond_concept_id’, ‘cond_concept_name’, ‘cond_concept_code’, ‘cond_concept_class_id’, ‘cond_vocab_id’, ‘cond_vocab_name’, ‘anat_site_concept_id’,’anat_site_concept_name’, ‘anat_site_concept_code’, ‘anat_site_concept_class_id’, ‘anat_site_vocab_id’, ‘anat_site_vocab_name’]
Returns:

results – a cursor-like object with methods such as fetchone(), fetchmany() etc.
Return type:

inspectomop.results.Results

See also

anatomical_site_by_keyword()

Notes

Original SQL

C11: Find all SNOMED-CT condition concepts that are occurring at an anatomical site:

SELECT
    A.concept_Id Condition_ID,
    A.concept_Name Condition_name,
    A.concept_Code Condition_code,
    A.concept_Class_id Condition_class,
    A.vocabulary_id Condition_vocab_ID,
    VA.vocabulary_name Condition_vocab_name,
    D.concept_Id Anatomical_site_ID,
    D.concept_Name Anatomical_site_Name,
    D.concept_Code Anatomical_site_Code,
    D.concept_Class_id Anatomical_site_Class,
    D.vocabulary_id Anatomical_site_vocab_ID,
    VS.vocabulary_name Anatomical_site_vocab_name
FROM
    concept_relationship CR,
    concept A,
    concept D,
    vocabulary VA,
    vocabulary VS
WHERE
    CR.relationship_ID = 'Has finding site' AND
    CR.concept_id_1 = A.concept_id AND
    A.vocabulary_id = VA.vocabulary_id AND
    CR.concept_id_2 = D.concept_id AND
    D.concept_id = 4103720 --input AND
    D.vocabulary_id = VS.vocabulary_id AND
    sysdate BETWEEN CR.valid_start_date AND CR.valid_end_date;