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 – a cursor-like object with methods such as fetchone(), fetchmany() etc.
Return type: 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;