CO10: Counts of condition records

This query is used to count conditions (condition_concept_id) across all condition occurrence records. The input to the query is a value of a condition_concept_id. 

 Parameter  Example  Mandatory  Notes
condition_concept_id 31967 Yes Condition concept identifier for 'Nausea'

Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue
SELECT    COUNT(*) as condition_occurrence_count
FROM      condition_occurrence
WHERE     condition_concept_id = 31967
Output field list:
 Field  Description
condition_occurrence_count Number of occurrence of a condition

Sample output record:
 Field  Description
condition_occurrence_count 245123