Diagnosis and Change in Diagnosis

Diagnosis and Change in Diagnosis - Variable Definition Table:

Field Name



diagnosis The diagnosis is an opportunity for the site investigator to give their opinion on a participant's most likely clinical diagnosis, regardless of cohort. The diagnosis may change over time because the site investigator may update the diagnosis at every longitudinal visit based on their opinion.

No PD Nor Other

Idiopathic PD

Parkinson's Disease

Prodromal non-motor


Prodromal motor PD

No PD no Other

Multiple System Atrophy

Essential Tremor Progressive

Other Neurological


Demential with Lewy


initial_diagnosis Initial diagnosis  
most_recent_diagnosis Most recent diagnosis  
change_in_diagnosis Change in diagnosis indicator Yes
change_in_diagnosis_date Change in diagnosis date YYYY-MM format
date_of_pd_diagnosis Date of Parkinson's disease diagnosis YYYY-MM format
age_at_diagnosis Age at Parkinson's disease diagnosis ###


Tables that Reference this Variable:

  • PD Medical History

Data Type Information:

Field Name



initial_diagnosis STRING NULLABLE
most_recent_diagnosis STRING NULLABLE
change_in_diagnosis STRING NULLABLE
change_in_diagnosis_date STRING NULLABLE
date_of_pd_diagnosis STRING NULLABLE
age_at_diagnosis INTEGER NULLABLE

Curation Notations:

  1. Appropriate Diagnosis (APPRDX) in PPMI and BioFIND were used as Study Arm and Most Likely Primary Diagnosis (PRIMDIAG) was used as Diagnosis. In PDBP Case/Control were used to identify three Study Arm values.
  2. Diagnosis in PDBP were cleaned and standardized as suggested by CDH group.
  3. Blank diagnosis values were filled with the value from the previous visit based on the participant_id. When a change in diagnosis occurs between visits (PDBP), the new diagnosis was associated with whichever visit is closest to the change date. The closest visit may be before the date of change logged in the system. These updates were completed manually.
Query Definition
PD_Medical_History.diagnosis is not null OR PD_Medical_History.change_in_diagnosis = "Yes"

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

diagnosis is not null
change_in_diagnosis = "Yes"

SELECT left(participant_id, 2) Cohort, count(distinct participant_id) Count from `amp-pd-research.2021_v2_5release_0510.PD_Medical_History` WHERE diagnosis is not null OR change_in_diagnosis = "Yes" GROUP BY Cohort ORDER BY Cohort