inst/QueryLibrary/Aggregate/person/PE11.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

PE11: Number of patients by month of birth

Description

This query is used to count number of patients grouped by month of birth within all person records. All possible values for month of birth are summarized. Not all databases maintain month of birth. This query is only available from CDM V4 and above.

Query

SELECT
  month_of_birth AS month_of_year,
  count(*)::integer       AS num_persons
FROM @cdm.person
GROUP BY month_of_birth
ORDER BY month_of_birth
;

Input

None

Output

| Field | Description | | --- | --- | | month | Month year 1 through 12 | | num_persons | Number of records |

Example output record

| Field | Value | | --- | --- | | month | 1 | | num_persons | 34462921 |

Documentation

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

Sensitive fields

num_persons

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