This query is similar to PE02, but it lists all available genders (male, female, unknown, ambiguous, other) across all person records. The input to the query is a value (or a comma-separated list of values) of a gender_concept_id. If the input is omitted, all possible values for gender_concept_id are summarized.
Input:
<None>
Sample query run:
The following is a sample run of the query to run a search for number of persons grouped by gender.
SELECT person.GENDER_CONCEPT_ID,
concept.CONCEPT_NAME AS gender_name,
COUNT(person.person_ID) AS num_persons_count
FROM person
INNER JOIN vocabulary.concept ON person.GENDER_CONCEPT_ID = concept.CONCEPT_ID
GROUP BY person.GENDER_CONCEPT_ID, concept.CONCEPT_NAME
Output:
Output field list:
| Field |
Description |
| Gender_concept_ID |
Gender concept ID as defined in CDM vocabulary |
| Gender_Name |
Gender name as defined in CDM vocabulary |
| Num_Persons_count |
Count of patients with specific gender ID |
Sample output record:
| Field |
Value |
| Gender_concept_ID |
8507 |
| Gender_Name |
Male |
| Num_Persons_count |
1607473 |
| 