CO18: Counts of condition occurrence records

This query is used to count the number of condition occurrence records (condition_occurrence_id) for all persons. The input to the query is a condition concept identifier

Input:
 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 number_of_condition_occurrences
FROM      condition_occurrence
WHERE     condition_concept_id = 31967
Output:
Output field list:
 Field  Description
number_of_condition_occurrences The number of the condition occurrences for all persons

Sample output record:
 Field  Description
number_of_condition_occurrences 142100
Comments