Person‎ > ‎

PE02: Number of patients of specific gender in the dataset

Use this query to determine the number of women and men in an a databse. The gender concept code for women is 8532 and for men is 8507. There are also unknown gender (8551), other (8521) and ambiguous (8570).

Input:
 Parameter  Example  Mandatory  Notes
Gender Concept ID 8532 Yes Concept Identifier for ‘female'

Sample query run:
The following is a sample run of the query to run a search for specific gender concept ID. The input parameters are highlighted in blue.
SELECT  COUNT(person_ID) AS num_persons_count 
FROM Person
WHERE GENDER_CONCEPT_ID = 8532
Output:
Output field list:
 Field  Description
num_persons_count Number of patients in the dataset of specific gender

Sample output record:
 Field  Value
num_persons_count 2859298
Comments