inst/QueryLibrary/Aggregate/condition_occurrence/CO09.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

CO09: Is a condition seasonal, alergies for example

Description

Returns the distribution of condition occurrence per season in the northern hemisphere, defined in the following way:

| Season | Temporal period | | --- | --- | | Spring | March 21 - June 21 | | Summer | June 22 - September 22 | | Fall | September 23 - December 21 | | Winter | December 22 - March 20 |

Query

SELECT season,
       COUNT(*)::integer AS season_freq
FROM
  (SELECT
    CASE
      WHEN daymonth>0320 AND daymonth<=0621 THEN 'Spring'
      WHEN daymonth>0621 AND daymonth<=0922 THEN 'Summer'
      WHEN daymonth>0922 AND daymonth<=1221 THEN 'Fall'
      WHEN daymonth>1221 OR (daymonth>0000 AND daymonth<=0520) THEN 'Winter'
      ELSE 'Unknown'
    END                   AS season
    FROM
       (SELECT

          CAST(CONCAT(CAST(date_part('day',condition_start_date) AS VARCHAR), CAST(date_part('month',condition_start_date) AS VARCHAR)) AS int) AS daymonth,
          condition_start_date
        FROM synthea_omop.condition_occurrence
        WHERE condition_concept_id = $1
       ) AS condition_dates
  ) AS condition_season
GROUP BY season
ORDER BY season_freq;

Input

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

Output

| Field | Description | | --- | --- | | season | Season as defined in the northern hemisphere. | | season_freq | Frequency of condition occurrence in the season. |

Example output record

| Field | Description | | --- | --- | | season | Summer | | season_freq | 62924 |

Documentation

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

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