inst/QueryLibrary/Aggregate/condition_occurrence/CO18.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

CO18: Counts of condition occurrence records

Description

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.

Query

SELECT
  COUNT(*)::integer AS number_condition_occurrences
FROM @cdm.condition_occurrence
WHERE condition_concept_id = $1;

Input

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

Output

| Field | Description | | --- | --- | | number_of_condition_occurrences | The number of the condition occurrences for all persons |

Example output record

| Field | Description | | --- | --- | | number_of_condition_occurrences | 142100 |

Documentation

https://github.com/OHDSI/CommonDataModel/wiki/

sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.