inst/QueryLibrary/Aggregate/condition_occurrence/CO01.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

CO01: How long does a condition last.

Description

Returns the distribution of a certain condition duration in days.

Query

SELECT
  cast((ca.condition_era_end_date - ca.condition_era_start_date) as integer) + 1 AS num_condition_duration_days,
  count(*)::integer                                                                 AS condition_duration_freq_count
FROM @cdm.condition_era ca
INNER JOIN @vocab.concept c
ON ca.condition_concept_id = c.concept_id
WHERE c.concept_id = $1
GROUP BY  c.concept_id,
          c.concept_name,
          cast((ca.condition_era_end_date - condition_era_start_date) as integer)
ORDER BY 1;

Input

| Parameter | Example | Mandatory | Notes | | --- | --- | --- | --- | | condition_concept_id | 4084167 | Yes | Acute allergic reaction |

Output

| Field | Description | | --- | --- | | num_condition_duration_days | Number of days condition diagnozed | | condition_duration_freq_count | The frequency of the condition |

Example output record

| Field | Description | | --- | --- | | num_condition_duration_days | 9 | | condition_duration_freq_count | 9077 |

Documentation

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

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