NDA Help Center

Login Dialog

Frequently Asked Questions


NDA Help Center

Filter Cart

Viewable at the top right of NDA pages, the Filter Cart is a temporary holder for filters and data they select. Filters are added to the Workspace first, before being submitted to The Filter Cart. Data selected by filters in the Filter Cart can be added to a Data Package or an NDA Study from the Data Packaging Page, by clicking the 'Create Data Package / Add Data to Study' button.

The filter cart supports combining multiple filters together, and depending on filter type will use "AND" or "OR"  when combining filters.

Multiple selections from the same filter type will result in those selections being applied with an ‘OR’ condition. For example, if you add an NDA Collection Filter with selections for both collections 2112 and 2563 to an empty Workspace, the subjects from NDA Collection 2112 ‘OR’ NDA Collection 2563 will be added to your Workspace even if a subject is in both NDA Collections. You can then add other NDA Collections to your Workspace which further extends the ‘OR’ condition.

If a different filter type is added to your Workspace, or a filter has already been submitted to the Filter Cart, the operation then performs a logical ‘AND’ operation. This means that given the subjects returned from the first filter, only those subjects that matched the first filter are returned by the second filter (i.e., subjects that satisfied both filters).

When combining other filters with the GUID filter, please note the GUID filter should be added last. Otherwise, preselected data may be lost. For example, a predefined filter from Featured Datasets may select a subset of data available for a subject. When combined with a GUID filter for the same subject, the filter cart will contain all data available from that subject, data structure, and dataset; this may be more data than was selected in the predefined filter for that subject. Again, you should add the GUID Filter as the last filter to your cart. This ensures 'AND' logic between filters and will limit results to the subjects, data structures, and datasets already included in your filter cart.

Note that only the subjects specific to your filter will be added to your Filter Cart and only on data shared with the research community. Other data for those same subjects may exist (i.e., within another NDA Collection, associated with a data structure that was not requested in the query, etc.). So, users should select ‘Find all Subjects Data’ to identify all data for those specific subjects. 

Additional Tips:

  • You may query the data without an account, but to gain access you will need to create an NDA user account and apply for access.  Most data access requires that you or your lab are sponsored by an NIH recognized institution with Federal Wide Assurance (FWA).  Without access, you will not be able to obtain individual-level data. 

    Once you have selected data of interest you can:
  • Create a data package - This allows you to specify format for access/download
  • Assign to Study Cohort - Associate the data to an NDA Study allowing for a DOI to be generated and the data to be linked directly to a finding, publication, or data release. 
  • Find All Subject Data - Depending on filter types being used, not all data associated with a subject will be selected.  Data may be restricted by data structure, NDA Collection, or outcome variables (e.g., NDA Study). ‘Find All Data’ expands the fliter criteria by replacing all filters in your Filter Cart with a single Query by GUID filter for all subjects selected by those filters.

    Please Note:
  • When running a query, it may take a moment to populate the Filter Cart. Queries happen in the background so you can define other queries during this time. 
  • When you add your first filter, all data associated with your query will be added to the Filter Cart (e.g., a Concept, an NDA Collection, a Data Structure/Element, etc.). As you add additional filters, they will also display in the Filter Cart. Only the name of filter will be shown in the Filter Cart, not the underlying structures. 
  • Information about the contents of the Filter Cart can be seen by clicking "Edit”.
  • Once your results appear in the Filter Cart, you can create a data package or assign subjects to a study by selecting the 'Package/Assign to Study' option. You can also 'Edit' or 'Clear' filters.

Frequently Asked Questions

  • The Filter Cart currently employs basic AND/OR Boolean logic. A single filter may contain multiple selections for that filter type, e.g., a single NDA Study filter might contain NDA Study 1 and NDA Study 2. A subject that is in EITHER 1 OR 2 will be returned.  Adding multiple filters to the cart, regardless of type, will AND the result of each filter.  If NDA Study 1 and NDA Study 2 are added as individual filters, data for a subject will only be selected if the subject is included in  BOTH 1 AND 2.

    When combining other filters with the GUID filter, please note the GUID filter should be added last. Otherwise, preselected data may be lost. For example, a predefined filter from Featured Datasets may select a subset of data available for a subject. When combined with a GUID filter for the same subject, the filter cart will contain all data available from that subject, data structure, and dataset; this may be more data than was selected in the predefined filter for that subject. Again, you should add the GUID Filter as the last filter to your cart. This ensures 'AND' logic between filters and will limit results to the subjects, data structures, and datasets already included in your filter cart.

  • Viewable at the top right of NDA pages, the Filter Cart is a temporary holder of data identified by the user, through querying or browsing, as being of some potential interest. The Filter Cart is where you send the data from your Workspace after it has been filtered.

  • After filters are added to the Filter Cart, users have options to ‘Create a Package’ for download, ‘Associate to Study Cohort’, or ‘Find All Subject Data’. Selecting ‘Find All Subject Data’ identifies and pulls all data for the subjects into the Filter Cart. Choosing ‘Create a Package’ allows users to package and name their query information for download. Choosing ‘Associate to Study Cohort’ gives users the opportunity to choose the Study Cohort they wish to associate this data.


  • Once your filter cart contains the subjects of interest, select Create Data Package/Assign to Data Study which will provide options for accessing item level data and/or assigning to a study.  

  • Once queries have been added to your workspace, the next step is to Submit the Filters in the workspace to the Filter Cart.  This process runs the queries selected, saving the results within a filter cart attached to your account.  

  • The Workspace within the General Query Tool is a holding area where you can review your pending filters prior to adding them to Filter Cart. Therefore, the first step in accessing data is to select one or more items and move it into the Workspace. 


Reset Password

NDA provides a single access to de-identified autism research data. For permission to download data, you will need an NDA account with approved access to NDA or a connected repository (AGRE, IAN, or the ATP). For NDA access, you need to be a research investigator sponsored by an NIH recognized institution with federal wide assurance. See Request Access for more information.

Warning Notice

This is a U.S. Government computer system, which may be accessed and used only for authorized Government business by authorized personnel. Unauthorized access or use of this computer system may subject violators to criminal, civil, and/or administrative action. All information on this computer system may be intercepted, recorded, read, copied, and disclosed by and to authorized personnel for official purposes, including criminal investigations. Such information includes sensitive data encrypted to comply with confidentiality and privacy requirements. Access or use of this computer system by any person, whether authorized or unauthorized, constitutes consent to these terms. There is no right of privacy in this system.

Update Password

You have logged in with a temporary password. Please update your password. Passwords must contain 8 or more characters and must contain at least 3 of the following types of characters:

  • Uppercase
  • Lowercase
  • Numbers
  • Special Characters limited to: %,_,!,@,#,$,-,%,&,+,=,),(,*,^,:,;

Subscribe to our mailing list

Mailing List(s)
Email Format

You are now leaving the NIMH Data Archive (NDA) web site to go to:

Click on the address above if the page does not change within 10 seconds.


NDA is not responsible for the content of this external site and does not monitor other web sites for accuracy.

Accept Terms
Filter Cart
No filters selected
Value Range
Data Structures with shared data
No filters have been selected
Switch User

Clinical Trials: Randomization

2,508 Shared Subjects

Clinical Trials: Randomization
Clinical Assessments
View Change History
Query Element Name Data Type Size Required Description Value Range Notes Aliases
subjectkey GUID Required The NDAR Global Unique Identifier (GUID) for research subject NDAR* guid
src_subject_id String 20 Required Subject ID how it's defined in lab/project SUBJECT, bid, id, randid, record_id, rsubjid, subject_id
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY RVDATE, date_of_interview_contact, intvdate
interview_age Integer Required Age in months at the time of the interview/test/sampling/imaging. 0 :: 1260 Age is rounded to chronological month. If the research participant is 15-days-old at time of interview, the appropriate value would be 0 months. If the participant is 16-days-old, the value would be 1 month. age, dema1, intvage
sex String 20 Required Sex of subject at birth
M;F; O; NR
M = Male; F = Female; O=Other; NR = Not reported dema2, gender, sex
Query aescode Integer Recommended Staff code number of person completing this form RDMCODE, interviewer_code
Query visit String 60 Recommended Visit name int1, redcap_event_name
Query bafinfo Integer Recommended Check if the Assessment was not done. 0::2 0=No; 1=Yes; 2=Unverified RDMINFO
Query mtinc Integer Recommended Does the subject continue to meet the inclusion exclusion criteria? 0;1; -9 0=No; 1=Yes; -9=unknown ran001
Query elrdm Integer Recommended Is the subject eligible for randomization? rdma3
rdmdate Date Recommended Date of Randomization ran003, rand_local_date
prjdate6 Date Recommended 6 week projection date
prjdate12 Date Recommended 12 week projection date
Query hlocondition Integer Recommended What condition is the patient randomized to? 0;1 0=Control; 1=Posit Science CONDITION
Query nrdmrsn Integer Recommended Primary reason not randomized 0::5 1=Failed to meet inclusion criteria; 2=Withdrew consent; 3=Medical reason (AE, illness, etc); 4=Non-compliance with protocol treatment; 5=Subject requires prohibited medication; 0=Other ran005
nrdmspc String 500 Recommended Specify other reason not randomized ran006
site String 101 Recommended Site Study Site siteid
Query ran001a Integer Recommended Was this subject a re-screen? 0;1 0=No; 1=Yes
Query ran001b Integer Recommended Were all re-screen assessments performed? 0;1 0=No; 1=Yes
Query ran002 Integer Recommended Was the subject randomized? 0::3; -9 0=No; 1=Yes; -9=unknown; 2=No meds; 3=No community care ran_q1b
ran004 String 10 Recommended Randomization number/coding cohort
Query visitid Integer Recommended MetaTrial Visit ID System variable: unique code for each type of visit -use to merge files
Query fseqno Integer Recommended Sequence Number 0::999 The FSEQNO variable in the ADJ form has a special interpretation compared to other forms. For example, ADJ FSEQNO of '1' can be thought of as being '001', FSEQNO of '2' can be thought of as being '002', and FSEQNO of '3' can be thought of as being '003'. The first digit of FSEQNO relates to the corresponding ENF sequence number at that visit and the third digit relates to the specific adjudicator who completed the adjudication form.
Query rdma1 Integer Recommended Does the patient still give consent to participate in the study? 0;1 0=No; 1=Yes
Query rdma2 Integer Recommended Is the patient still considered eligible for study participation? 0;1 0=No; 1=Yes
Query rdma4 Integer Recommended Do you want to randomize this patient? 0;1 0=No; 1=Yes
Query rdma6 Integer Recommended Do you need a bottle code for the oral trial? 0;1 0=No; 1=Yes
Query version String 20 Recommended Version/code of assessment
Query visday Integer Recommended Number of days from study baseline to date of visit
version_form String 121 Recommended Form used/assessment name
Query daysrz Integer Recommended days since randomization date, visitdt
study String 100 Recommended Study; The code for each individual study studyid
Query completed Integer Recommended Checks if completed 0::3 0=No; 1=Yes; 2=Yes, lost; 3=Unverified formcomp
Query subtrial_name Integer Recommended Name of subtrial 1::3 1=Crossover; 2=Guanfacine; 3= Open Label MPH
Query ran_q1 Integer Recommended Tolerate 4 lowest Doses 0;1 0=No; 1=Yes
Query ran_q1a Integer Recommended Tolerate highest dose 0;1 0=No; 1=Yes
Query ran_q4 Integer Recommended Primary reason not randomized 1::10 1 = Toxicity or side effects related to study medication; 2 = Medical reason unrelated to study medication; 3 = Termination by principal investigator because of non medical reasons; 4 = Failed to return to clinic; 5 = Declined study participation; 6 = Moved from area (current or pending); 7 = Death; 8 = Subject no longer eligible to participate; 9 = School unable/no longer willing to participate; 10 = Other
Query enrl_ord Integer Recommended Order of Enrollment - The first subject enrolled in the Guanfacine Trial (i.e., the earliest enrollment date) has ENRL_ORD = 1, the second subject enrolled has ENRL_ORD = 2, the third has ENRL_ORD = 3, etc. Subjects enrolled on the same day are given the same number. Derived variable, not on CRF
Query ranq5 Integer Recommended Reason not randomized 1::7;-9 1=Failed to meet inclusion or exclusion criteria; 2=Declined study participation/Withdrew consent; 3=Failed to return to clinic; 4=Moved from area; 5=Incarceration; 6=Death; 7=Other; -9=Unknown
Query arm Integer Recommended Assigned Randomization Arm 1::3 1=Escitalopram plus Orange capsule-Lexapro; 2=Bupropion-SR plus Blue capsule-Wellbutrin; 3=Venlafaxine XR plus Green capsule-Effexor
Query vis_type Integer Recommended Visit type 0::2 1=Phone/remote; 0=doctor's office/In person; 2=No, not phone interview phone
Query ran004a Integer Recommended Treatment Group 1;2;-9 1=start treatment with ketamine; 2= start treatment with saline; -9 =unknown q4a
inelgs String 250 Recommended Ineligible reason rdma2a
Query iec16 Integer Recommended Eligibility status 1::3 1=Eligible; 2= Ineligible; 3=Pending rdma3a
Query iec003a Integer Recommended Is the subject eligible to participate in the study?
0=No; 1=Yes; -9=Unknown rndqual
trtarm String 200 Recommended Treatment arm treatment
datetime String 25 Recommended Date on which the interview/genetic test/sampling/imaging was completed. MM/DD/YYYY and __:__ sitedtm
Query resubmit Integer Recommended Randomization error- resubmit
0;1; -9
0=No; 1=Yes; -9=Unknown
Query ad_exc11 Integer Recommended Current use of antidepressants or anticonvulsants 0;1 0=No; 1=Yes
treatment_name String 200 Recommended treatment name
Query randomization Integer Recommended Randomization Field 2;3 2=Blue; 3=White
Query ca6_1 Integer Recommended Chronic depression 0;1 0=No; 1=Yes
Query bdi_stw Integer Recommended Suicidal thoughts or wishes 0;1;2;3;-7; -9 0=I don't have any thoughts of killing myself; 1= I have thoughts of killing myself, but I would not carry them out; 2=I would like to kill myself; 3=I would kill myself if I had the chance"; -7=Refused; -9=incomplete
psmd1 String 250 Recommended Psych med code 1
refothers String 50 Recommended Referral source: specify
Query med_group Integer Recommended Randomly Assigned Medication Group 0;1 (0=Changed to Second SSRI, 1=Changed to VENLAFAXINE)
Query cbt_group Integer Recommended Randomly Assigned to Clinical Behavior Therapy? 0;1 (0=No, 1=Yes)
ssricat String 50 Recommended Randomly Assigned SSRI
cameon String 50 Recommended Current SSRI
Query noparox Integer Recommended Constrain paroxetine? 1 1 = YES for all patients; YES for all patients became active when study stopped using paroxetine.
Query refflu Integer Recommended Did patient refuse fluoxetine?(Prozac) 0;1 0 = No; 1 = Yes
Query refcit Integer Recommended Did patient refuse citalopram?(Celexa) 0;1 0 = No; 1 = Yes
Query refpar Integer Recommended Did patient refuse paroxetine? 0;1 0 = No; 1 = Yes
Query comanx Integer Recommended COMORBID ANXIETY 0;1 0=No; 1=Yes
Query rnd_5 Integer Recommended Randomized provider number
Query lithever Integer Recommended ever taken lithium 0;1;-7 0=No; 1=Yes; -7=Refused
Query week Float Recommended Week in level/study 99=week 10-week 14
Query visnum Float Recommended Numeric Visit Number -1.5 = Pre-Screening; -1 = Screening; 0 = Baseline; ## = Visit ## (from 1 to 10); Whole numbers = standard monthly visits; #.001 - #.009 = Unscheduled; #.1 = End of Phase 1; #.2 = End of Phase 2; #.3 = End of Phase 3; #.4 = End of Open Choice Phase; #.5 = End of Study; #.6 = Genetic Analysis; 1000=all visits
Query iecsig Integer Recommended Investigator signature on form. 0;1 0=No; 1= Yes
lab020 Date Recommended Date of PI/clinician signature
Query sigd1 Integer Recommended Physician/PI signature date (days since randomization)
general_2 String 4,000 Recommended How have you been since I last saw you?
general_3 String 4,000 Recommended Do you have any specific worries or complaints about your health in general?
general_4a Integer Recommended Have you missed taking any of your trial medicines? 0=No; 1=Yes
general_4b Float Recommended Have you missed taking any of your trial medicines? If yes, how many days? 2 decimal place
general_4c String 4,000 Recommended Have you missed taking any of your trial medicines? Any why?
general_5 String 4,000 Recommended Have you had any problems relating to the trial capsules?
general_6 String 4,000 Recommended Do you have any other problems or worries in relation to the trial?
comments_misc String 4,000 Recommended Miscellaneous comments on study, interview, methodology relevant to this form data clinician_notes
rand_treat String 20 Recommended Randomized treatment MST;ECT
rand_call_date Date Recommended Date of telephone call
Data Structure

This page displays the data structure defined for the measure identified in the title and structure short name. The table below displays a list of data elements in this structure (also called variables) and the following information:

  • Element Name: This is the standard element name
  • Data Type: Which type of data this element is, e.g. String, Float, File location.
  • Size: If applicable, the character limit of this element
  • Required: This column displays whether the element is Required for valid submissions, Recommended for valid submissions, Conditional on other elements, or Optional
  • Description: A basic description
  • Value Range: Which values can appear validly in this element (case sensitive for strings)
  • Notes: Expanded description or notes on coding of values
  • Aliases: A list of currently supported Aliases (alternate element names)
  • For valid elements with shared data, on the far left is a Filter button you can use to view a summary of shared data for that element and apply a query filter to your Cart based on selected value ranges

At the top of this page you can also:

  • Use the search bar to filter the elements displayed. This will not filter on the Size of Required columns
  • Download a copy of this definition in CSV format
  • Download a blank CSV submission template prepopulated with the correct structure header rows ready to fill with subject records and upload

Please email the The NDA Help Desk with any questions.