Sex, ethnicity, race

Sex, Ethnicity, and Race - Variable Definition Table:

Field Name

Type

Mode

Description

Field Values
sex STRING NULLABLE participant sex category

Male
Female
Unknown
ethnicity STRING NULLABLE participant ethnicity category

Not Hispanic or Latino
Hispanic or Latino
Unknown
race STRING NULLABLE participant race category

White
Black or African American
Unknown
Asian
Multiracial
American Indian or Alaska
Native Hawaiian or Other

 

Tables that Reference these Variables:

  • Demographics
     

Data Type Information:

Field Name

Type

Mode
sex STRING NULLABLE
ethnicity STRING NULLABLE
race STRING NULLABLE

 

Curation Notations:

Query Definition
Demographics.sex is not null OR Demographics.ethnicity is not null OR Demographics.race is not null

Clinical Data Forms Queried (available as a BigQuery Table and csv File)
Demographics

Criteria
sex is not null
ethnicity is not null
race is not null
OR

Query
SELECT left(participant_id, 2) Cohort, count(distinct participant_id) Count from `amp-pd-research.2021_v2_5release_0510.Demographics` WHERE sex is not null OR ethnicity is not null OR race is not null GROUP BY Cohort ORDER BY Cohort