inspectomop.queries.condition.condition_concept_for_concept_id

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

Retrieves the condition concept for a condition_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 : [‘concept_id’, ‘concept_name’, ‘concept_code’, ‘concept_class_id’, ‘vocabulary_id’, ‘vocabulary_name’]

Returns:

results

Return type:

sqlalchemy.sql.expression.Executable

See also

inspectomop.queries.general.concepts_for_concept_ids

Notes

Original SQL

C01: Find condition by concept ID:

SELECT
    C.concept_id Condition_concept_id,
    C.concept_name Condition_concept_name,
    C.concept_code Condition_concept_code,
    C.concept_class_id Condition_concept_class,
    C.vocabulary_id Condition_concept_vocab_ID,
    V.vocabulary_name Condition_concept_vocab_name,
    CASE C.vocabulary_id
        WHEN 'SNOMED' THEN CASE lower(C.concept_class_id)
        WHEN 'clinical finding' THEN 'Yes' ELSE 'No' END
        WHEN 'MedDRA' THEN 'Yes'
        ELSE 'No'
    END Is_Disease_Concept_flag
FROM
    concept C,
    vocabulary V
WHERE
    C.concept_id = 192671 AND
    C.vocabulary_id = V.vocabulary_id AND
    sysdate BETWEEN valid_start_date AND valid_end_date;