inspectomop.queries.condition.conditions_caused_by_pathogen_or_causative_agent_concept_id

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

Retreives all conditions caused by a pathogen or other causative agent concept_id.

Parameters:
  • concept_id (int) –
  • inspector (inspectomop.inspector.Inspector) –
  • return_columns (list of str, optional) –
    • optional subset of columns to return from the query
    • columns : [‘condition_concept_id’, ‘condition_name’, ‘condition_concept_code’, ‘condition_concept_class_id’, ‘condition_vocab_id’, ‘condition_vocab_name’, ‘causative_agent_concept_id’, ‘causative_agent_concept_name’, ‘causative_agent_concept_code’, ‘causative_agent_concept_class_id’, ‘causative_agent_vocab_id’, ‘causative_agent_vocab_name’]
Returns:

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

inspectomop.results.Results

See also

disease_causing_agents_for_keyword(), pathogen_concept_for_keyword()

Notes

Original SQL

C09: Find all SNOMED-CT condition concepts that can be caused by a given pathogen or causative agent:

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 Causative_agent_ID,
    D.concept_Name Causative_agent_Name,
    D.concept_Code Causative_agent_Code,
    D.concept_Class_id Causative_agent_Class,
    D.vocabulary_id Causative_agent_vocab_ID,
    VS.vocabulary_name Causative_agent_vocab_name
FROM
    concept_relationship CR,
    concept A,
    concept D,
    vocabulary VA,
    vocabulary VS
WHERE
    CR.relationship_ID = 'Has causative agent' 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 = 4248851 AND
    D.vocabulary_id = VS.vocabulary_id AND
    sysdate BETWEEN CR.valid_start_date AND CR.valid_end_date;