This query is used to count ethnicities (ethnicity_concept_id) across all person records. The input to the query is a value (or a comma-separated list of values) of an ethnicity_concept_id. If the input is omitted, all possible values for ethnicity_concept_id are summarized. This query is also available from OSCAR runs of CDM V4 and above.
Sample query run:
The following is a sample run of the query to run a search for number of persons grouped by ethnicity.
Output field list:
Sample output record: