inst/QueryLibrary/Aggregate/condition_occurrence/CO19.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

CO19: Counts of condition occurrence records stratified by observation month

Description

This query is used to count the condition occurrence records stratified by observation month.

Query

SELECT 
  date_part('month',condition_start_date) month_number, 
  COUNT(*)::integer AS number_of_conditions_in_month
FROM @cdm.condition_occurrence
GROUP BY date_part('month',condition_start_date)
ORDER BY 1;

Input

None

Output

| Field | Description | | --- | --- | | Month_number | Month number | | Number_of_conditions_in_month | The number of the condition occurrences is a specified month. |

Example output record

| Field | Description | | --- | --- | | Month_number | 3 | | Number_of_conditions_in_month | 20643257 |

Documentation

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

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