inst/shinyApps/QueryLibrary/queries/condition_occurence/CO11.md

In OHDSI/QueryLibrary: A Query Library for the OMOP-CDM

CO11: Counts of persons with conditions

Description

This query is used to count the persons with any number of occurrences of a certain condition (condition_concept_id). The input to the query is a value of a condition_concept_id.

Query

SELECT
  COUNT(DISTINCT person_id) AS persons_with_condition_count
FROM @cdm.condition_occurrence
WHERE condition_concept_id = 31967
      AND person_id IS NOT NULL;

Input

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

Output

| Field | Description | | --- | --- | | persons_with_condition_count | Number of persons who had at least one occurrence of a certain condition. |

Example output record

| Field | Description | | --- | --- | | persons_with_condition_count | 2142100 |

Documentation

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

OHDSI/QueryLibrary documentation built on Aug. 1, 2023, 5:42 a.m.