NDA Help Center

Login Dialog

Frequently Asked Questions


NDA Help Center

Filter Cart

The Filter Cart provides a powerful way to query and access data for which you may be interested.  

A few points related to the filter cart are important to understand with the NDA Query/Filter implementation: 

First, the filter cart is populated asyncronously.  So, when you run a query, it may take a moment to populate but this will happen in the background so you can define other queries during this time.  

When you are adding your first filter, all data associated with your query will be added to the filter cart (whether it be a collection, a concept, a study, a data structure/elment or subjects). Not all data structures or collections will necessarily be displayed.  For example, if you select the NDA imaging structure image03, and further restrict that query to scan_type fMRI, only fMRI images will appear and only the image03 structure will be shown.  To see other data structures, select "Find All Subject Data" which will query all data for those subjects. When a secord or third filter is applied, an AND condition is used.  A subject must exist in all filters.  If the subject does not appear in any one filter, that subjects data will not be included in your filter cart. If that happens, clear your filter cart, and start over.  

It is best to package more data than you need and access those data using other tools, independent of the NDA (e.g. miNDAR snapshot), to limit the data selected.  If you have any questions on data access, are interested in using avaialble web services, or need help accessing data, please contact us for assistance.  

Frequently Asked Questions



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

Expectancy Rating Questionnaire (ERQ)



Expectancy Rating Questionnaire

Download Definition as
Download Submission Template as
Element NameData TypeSizeRequiredDescriptionValue RangeNotesAliases
subjectkeyGUIDRequiredThe NDAR Global Unique Identifier (GUID) for research subjectNDAR*guid_r03
src_subject_idString20RequiredSubject ID how it's defined in lab/projectcbcl_sss_id, id, patid, pid, record_id, sid_r03
interview_dateDateRequiredDate on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYYRequired fieldcbcl_sss_date, lvdate_r03, txevaluation_date
interview_ageIntegerRequiredAge in months at the time of the interview/test/sampling/imaging.0 :: 1260Age 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.cbcl_sss_age, childage_r03
sexString20RequiredSex of the subjectM;FM = Male; F = Femalecbcl_sss_gender, childgender_r03, gender
comments_miscString4,000RecommendedMiscellaneous comments on study, interview, methodology relevant to this form data
erq_p_1IntegerRecommendedHow logical does this treatment seem to you?1::9; -99; 88; 771 = Not at all logical; 2 = 2; 3 = 3; 4 = 4; 5= Somewhat logical; 6= 6; 7= 7; 8= 8; 9= Very logical; -99= NA; 88 = Missing; 77= Refused;ERQ_PARENT1, ceq_1, ceq_logical, txevaluation_1
erq_p_2IntegerRecommendedAt this point, how successfully do you think this course will be in raising the quality of your /your child functioning1::9; -99; 88; 771= Not at all useful; 2= 2; 3= 3; 4= 4; 5= Somewhat useful; 6= 6; 7= 7; 8= 8; 9= Very useful; -99= NA; 88 = Missing; 77 =Refused;ERQ_PARENT2, ceq_useful, txevaluation_2
erq_p_3IntegerRecommendedHow confident would you be in recommending this treatment to a friend who has a similar problem?1::9; -99; 88; 771 = Not at all confident; 2 = 2; 3 = 3; 4 = 4; 5= Somewhat confident; 6= 6; 7= 7; 8= 8; 9= Very confident; -99= NA; 88 = Missing; 77= Refused;ERQ_PARENT3, ceq_3, ceq_4, ceq_confident, txevaluation_3
erq_p_4IntegerRecommendedHow successful do you think this treatment will be in decreasing other (non-anxiety related) problems your child has?1::9; -99; 88; 771 = not at all ; 2,3,4 ; 5 = somewhat ; 6,7,8; 9 = very muchERQ_PARENT4, cred1
erq_p_5IntegerRecommendedBy the end of the course, how much improvement in your/your child functioning do you think will occur0::10; -99; 88; 770= 0%; 1= 10%;2= 20%; 3= 30%; 4= 40%; 5= 50%; 6= 60%; 7= 70%; 8= 80%; 9= 90%; 10= 100%; -99 =NA; 88 =Missing; 77 = Refused;ERQ_PARENT5, ceq_improvementthink, cred2
erq_selfeIntegerRecommendedHow likely is it you will be able to do what is necessary to make anxiety treatment successful?0::80 = Not at all; 2 = Possibly; 4 = 50/50; 6 = Very likely; 8 = Certainly;selfefficacy_expectancy
erq_outcIntegerRecommendedHow likely is it that your anxiety can be successfully treated0::80 = Not at all; 2 = Possibly; 4 = 50/50; 6 = Very likely; 8 = Certainly;outcome_expectancy
siteString101RecommendedSiteStudy Siteasite
clinicidIntegerRecommendedClinic IDaclinic
ran002IntegerRecommendedWas the subject randomized?0::3; -90=No; 1=Yes; -9=unknown; 2=No meds; 3=No community carerand
days_baselineIntegerRecommendedDays since baselinelos_mini
cred3IntegerRecommendedAt this point, how much do you really feel that treatment will help you to reduce your symptoms?1::91=not at all useful::9=very confidentceq_1a, ceq_3, ceq_reduce
cred4IntegerRecommendedBy the end of the treatment period, how much improvement in your symptoms do you really feel will occur?0::100=0%; 1=10%; 2=20%; 3=30%; 4=40%; 5=50%; 6=60%; 7=70%; 8=80%; 9=90%; 10=100%ceq_10, ceq_5, ceq_improvement_feel
txevaluation_4IntegerRecommended4. How important do you think it is that we make this treatment available to others who experience bipolar disorder?1::91=Not at all important; 9=Very important
txevaluation_5IntegerRecommended5. How successful do you believe this treatment would be in decreasing other problems involving tension, anxiety, insomnia, etc.?1::91=Not at all successful; 9=Very successful
oat1IntegerRecommendedHow sensible does this type of treatment seem to you?1 :: 71=Not at all; 2; 3; 4=Somewhat; 5; 6; 7=Extremely
oat2IntegerRecommendedHow confident are you that this treatment will help decrease your depression?1 :: 71=Not at all; 2; 3; 4=Somewhat; 5; 6; 7=Extremely
oat3IntegerRecommendedHow confident would you be to recommend this treatment to a friend who had problems with depression?1 :: 71=Not at all; 2; 3; 4=Somewhat; 5; 6; 7=Extremely
ceq_2IntegerRecommendedHow acceptable does the therapy offered to you seem to treat sleep symptoms?
1::9; -99
On a likert: 1 = not at all acceptable; 2,3,4 ; 5 = somewhat acceptable; 6,7,8; 9 = very acceptable; -99 = missing, omitted or unreadable
ceq_5bIntegerRecommendedHow much did you follow the therapy procedures and recommendations?
0::10; -99; 88; 77
0= 0%; 1= 10%;2= 20%; 3= 30%; 4= 40%; 5= 50%; 6= 60%; 7= 70%; 8= 80%; 9= 90%; 10= 100%; -99 =NA; 88 =Missing; 77 = Refused;
ceq_6IntegerRecommendedDo you consider that you still suffer from depression?
1::9; -99
On a likert: 1 = not at all ; 2,3,4 ; 5 = somewhat ; 6,7,8; 9 = very much; -99 = missing, omitted or unreadable
ceq_7IntegerRecommendedDo you think that you would need an additional treatment for depression?
1::9; -99
On a likert: 1 = not at all ; 2,3,4 ; 5 = somewhat ; 6,7,8; 9 = very much; -99 = missing, omitted or unreadable
ceq_8IntegerRecommendedHow satisfied are you with the treatment you received?
1::9; -99
On a likert: 1 = not at all satisfied; 2,3,4 ; 5 = somewhat satisfied; 6,7,8; 9 = very satisfied; -99 = missing, omitted or unreadable
ceq_9IntegerRecommendedHow would you rate the relationship between you and your therapist?
1::9; -99
On a likert: 1 = not very good; 2,3,4 ; 5 = somewhat good; 6,7,8; 9 = very good; -99 = missing, omitted or unreadable
ceq_4IntegerRecommendedBy the end of the treatment period, how much improvement in your depressive symptoms do you think will occurr? (percentage)0::100
ceq_2aIntegerRecommendedBy the end of the treatment period, how much improvement in your depressive symptoms do you really feel will occur? (Percentage)0::100
ceq2IntegerRecommendedAt this point, how successful do you think this treatment will be in reducing your depressive symptoms?1::91= Not at all successful; 5= Somewhat successful; 9= Very successful
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.

Distribution for DataStructure: erq01 and Element:
Chart Help

Filters enable researchers to view the data shared in NDA before applying for access or for selecting specific data for download or NDA Study assignment. For those with access to NDA shared data, you may select specific values to be included by selecting an individual bar chart item or by selecting a range of values (e.g. interview_age) using the "Add Range" button. Note that not all elements have appropriately distinct values like comments and subjectkey and are not available for filtering. Additionally, item level detail is not always provided by the research community as indicated by the number of null values given.

Filters for multiple data elements within a structure are supported. Selections across multiple data structures will be supported in a future version of NDA.