NDA Help Center

Login Dialog

Frequently Asked Questions

Glossary

Contact NDA Help Desk

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

Glossary

Contact NDA Help Desk

Loading...

Login
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: %,_,!,@,#,$,-,%,&,+,=,),(,*,^,:,;
Update Password

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.

Disclaimer

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

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

Alcohol, Smoking and Substance Involvement Screening Test

0 Shared Subjects

N/A
Clinical Assessments
Substance Use
05/26/2017
assist01
09/14/2017
View Change History
01
Definition
Submission Template
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* z1
src_subject_id String 20 Required Subject ID how it's defined in lab/project z2
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field z3
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. z4
sex String 20 Required Sex of the subject M;F M = Male; F = Female gender, z5
Query whoassist_use1 Integer Recommended Substance used 1 0;1; -9 0= No; 1= Yes; -9=missing assistq1s1
Query whoassist_use2 Integer Recommended Substance used 2 0;1; -9 0= No; 1= Yes; -9=missing assistq1s2
Query whoassist_use3 Integer Recommended Substance used 3 0;1; -9 0= No; 1= Yes; -9=missing assistq1s3
Query whoassist_use4 Integer Recommended Substance used 4 0;1; -9 0= No; 1= Yes; -9=missing assistq1s4
Query whoassist_use5 Integer Recommended Substance used 5 0;1; -9 0= No; 1= Yes; -9=missing assistq1s5
Query whoassist_often1 Integer Recommended How often have you used substance 1 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq2s1
Query whoassist_often2 Integer Recommended How often have you used substance 2 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq2s2
Query whoassist_often3 Integer Recommended How often have you used substance 3 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq2s3
Query whoassist_often4 Integer Recommended How often have you used substance 4 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq2s4
Query whoassist_often5 Integer Recommended How often have you used substance 5 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq2s5
Query whoassist_urge1 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 1 0::6; -3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq3s1
Query whoassist_urge2 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 2 0::6; -3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq3s2
Query whoassist_urge3 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 3 0::6; -3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq3s3
Query whoassist_urge4 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 4 0::6; -3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq3s4
Query whoassist_urge5 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 5 0::6; -3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3=NA; -9=missing assistq3s5
Query whoassist_prob1 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 1 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3=NA; -9=missing assistq4s1
Query whoassist_prob2 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 2 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3=NA; -9=missing assistq4s2
Query whoassist_prob3 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 3 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3=NA; -9=missing assistq4s3
Query whoassist_prob4 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 4 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3=NA; -9=missing assistq4s4
Query whoassist_prob5 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 5 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3=NA; -9=missing assistq4s5
Query whoassist_fail1 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 1 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3=NA; -9 =missing assistq5s1
Query whoassist_fail2 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 2 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3=NA; -9 =missing assistq5s2
Query whoassist_fail3 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 3 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3=NA; -9 =missing assistq5s3
Query whoassist_fail4 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 4 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3=NA; -9 =missing assistq5s4
Query whoassist_fail5 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 5 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3=NA; -9 =missing assistq5s5
Query whoassist_concern1 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 1 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s1
Query whoassist_concern2 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 2 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s2
Query whoassist_concern3 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 3 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s3
Query whoassist_concern4 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 4 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s4
Query whoassist_concern5 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 5 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s5
Query whoassist__control1 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 1 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s1
Query whoassist__control2 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 2 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s2
Query whoassist__control3 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 3 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s3
Query whoassist__control4 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 4 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s4
Query whoassist__control5 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 5 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s5
Query whoassist_use6 Integer Recommended Substance used 6 0;1;-9 0= No; 1= Yes; -9 = missing assistq1s6
Query whoassist_use7 Integer Recommended Substance used 7 0;1;-9 0= No; 1= Yes; -9 = missing assistq1s7
Query whoassist_use8 Integer Recommended Substance used 8 0;1;-9 0= No; 1= Yes; -9 = missing assistq1s8
Query whoassist_use9 Integer Recommended Substance used 9 0;1;-9 0= No; 1= Yes; -9 = missing assistq1s9
Query whoassist_use10 Integer Recommended Substance used 10 0;1;-9 0= No; 1= Yes; -9 = missing assistq1s10
Query whoassist_often6 Integer Recommended How often have you used substance 6 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq2s6
Query whoassist_often7 Integer Recommended How often have you used substance 7 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq2s7
Query whoassist_often8 Integer Recommended How often have you used substance 8 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq2s8
Query whoassist_often9 Integer Recommended How often have you used substance 9 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq2s9
Query whoassist_often10 Integer Recommended How often have you used substance 10 0::6;-3;-9 0= Never; 2= Once or Twice; 3= Monthly; 4= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq2s10
Query whoassist_urge6 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 6 0::6;-3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq3s6
Query whoassist_urge7 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 7 0::6;-3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq3s7
Query whoassist_urge8 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 8 0::6;-3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq3s8
Query whoassist_urge9 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 9 0::6;-3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq3s9
Query whoassist_urge10 Integer Recommended In [time frame], how often had you had a desire or urge to use substance 10 0::6;-3;-9 0= Never; 3= Once or Twice; 4= Monthly; 5= Weekly; 6= Daily or Almost Daily; -3 = NA; -9 = missing assistq3s10
Query whoassist_prob6 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 6 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3 = NA; -9 = missing assistq4s6
Query whoassist_prob7 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 7 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3 = NA; -9 = missing assistq4s7
Query whoassist_prob8 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 8 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3 = NA; -9 = missing assistq4s8
Query whoassist_prob9 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 9 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3 = NA; -9 = missing assistq4s9
Query whoassist_prob10 Integer Recommended In [time frame], how often have health, social, legal or financial problems resulted from using substance 10 0::7; -3; -9 0= Never; 4= Once or Twice; 5= Monthly; 6= Weekly; 7= Daily or Almost Daily; -3 = NA; -9 = missing assistq4s10
Query whoassist_fail6 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 6 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3 = NA; -9 = missing assistq5s6
Query whoassist_fail7 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 7 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3 = NA; -9 = missing assistq5s7
Query whoassist_fail8 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 8 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3 = NA; -9 = missing assistq5s8
Query whoassist_fail9 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 9 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3 = NA; -9 = missing assistq5s9
Query whoassist_fail10 Integer Recommended In [time frame], how often have you failed to do what was normally expected of you because of your use of substance 10 0::8; -3; -9 0= Never; 5= Once or Twice; 6= Monthly; 7= Weekly; 8= Daily or Almost Daily; -3 = NA; -9 = missing assistq5s10
Query whoassist_concern6 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 6 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s6
Query whoassist_concern7 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 7 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s7
Query whoassist_concern8 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 8 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s8
Query whoassist_concern9 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 9 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s9
Query whoassist_concern10 Integer Recommended Has a friend or relative or anyone else ever expressed concern about your use of substance 10 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq6s10
Query whoassist__control6 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 6 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s6
Query whoassist__control7 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 7 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s7
Query whoassist__control8 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 8 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s8
Query whoassist__control9 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 9 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s9
Query whoassist__control10 Integer Recommended Have you ever tried and failed to control, cut down or stop using substance 10 0;3;6; -9; -3 0=No, Never; 3= Yes, but not in the past 3 months; 6= Yes, in the past 3 months; -9 =missing; -3=NA assistq7s10
Query aescode Integer Recommended Staff code number of person completing this form
comments_misc String 4,000 Recommended Miscellaneous comments on study, interview, methodology relevant to this form data
version_form String 100 Recommended Form used/assessment name
Query medhx9a String 100 Recommended Do you use other recreational "street" drugs? If yes, please specify - 1 assistother
Query visit String 50 Recommended Visit name
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.