inst/QueryLibrary/Aggregate/condition_occurrence/CO10.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

CO10: Counts of condition records

Description

Returns the total count of condition occurences.

Query

SELECT
  COUNT(*)::integer AS condition_occurrence_count
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 | | --- | --- | | condition_occurrence_count | Number of occurrence of a condition |

Example output record

| Field | Description | | --- | --- | | condition_occurrence_count | 245123 |

Documentation

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

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