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

Global Appraisal of Individual Needs (GAIN) Substance Use



Download Definition as
Download Submission Template as
Element NameData TypeSizeRequiredDescriptionValue RangeNotesAliases
subjectkeyGUIDRequiredThe NDAR Global Unique Identifier (GUID) for research subjectNDAR*
src_subject_idString20RequiredSubject ID how it's defined in lab/projectsubject_id
interview_dateDateRequiredDate on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYYRequired field
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.
sexString20RequiredSex of the subjectM;FM = Male; F = Femalegender
timeptIntegerRecommendedTime Point888 = not applicable; 999 = missing
phi1IntegerRecommendedType of interview1::51 = In person; 2 = Phone; 3 = Mail; 4 = SIG-O only; 5 = Carp onlyin_person
cs07IntegerRecommendedAlcohol0;10=No; 1=Yesgain_01
gain_01aIntegerRecommendedHave you used any kind of alcohol (beer, gin, rum, scotch, tequila, whiskey, wine, or mixed drinks)? On how many days?
gain_01bIntegerRecommendedHave you gotten drunk or had 5 or more drinks?0; 11= Yes; 0= No
gain_01baIntegerRecommendedHave you gotten drunk or had 5 or more drinks? On how many days?
gain_02IntegerRecommendedHave you used marijuana, hashish, blunts or other forms of THC (herb, reefer, weed)?0; 11= Yes; 0= No
surq_3aIntegerRecommendedIn the past 30 days, what is your best estimate as to how many days you used marijuanagain_02a
gain_03IntegerRecommendedHave you used crack, smoked rock or free base cocaine?0; 11= Yes; 0= No
gain_03aIntegerRecommendedHave you used crack, smoked rock or free base cocaine? On how many days?
gain_04IntegerRecommendedHave you used other forms of cocaine?0; 11= Yes; 0= No
gain_04aIntegerRecommendedHave you used other forms of cocaine? On how many days?
addsev13IntegerRecommendedInhalants0;10 = No;1 = Yesgain_04b
gain_04baIntegerRecommendedHave you used inhalants or huffed (such as correction fluids, gasoline, glue, lighters, spray paints, or paint thinner)? On how many days?
addsev5IntegerRecommendedHeroin0;10 = No;1 = Yesgain_05
frquency_heroinIntegerRecommendedThink specifically about the past 30 days, including today. During the past 30 days, on how many days did you use any heroin? PX031301_Frequency_Heroin0::30gain_05a
sm_7g9IntegerRecommendedHave ever used Methadone without a prescription from a doctor?0;10=No;1=Yesgain_008
asid4IntegerRecommendedMethadone: Days of use in past 30 days0::30gain_008a
addsev7IntegerRecommendedOther opiates or analgesics0;10 = No;1 = Yesgain_009
gain_009aIntegerRecommendedHave you used painkillers, opiates or other analgesics (such as codeine, Darvocet, Darvon, Demerol, Dilaudid, Karachi, OxyContin, Oxys, Percocet, Propoxyphene, morphine, opium, Talwin, or Tylenol with codeine)? On how many days?
tlfb_hall_use_type___2IntegerRecommendedWhich of these have you used? (Please check all that apply) ( 2, PCP or angel dust)0 ; 10 = No; 1 = Yesgain_010
gain_010aIntegerRecommendedHave you used PCP or angel dust (phencyclidine)? On how many days?
addsev12IntegerRecommendedHallucinogens0;10 = No;1 = Yesgain_011
gain_011aIntegerRecommendedHave you used acid, LSD, ketamine, special K, mushrooms, or other hallucinogens (such as mescaline, peyote, psilocybin, or shrooms)? On how many days?
tranquilIntegerRecommendedtranquilizer0;1;-70=No; 1=Yes; -7=Refusedgain_012
gain_012aIntegerRecommendedHave you used anti-anxiety drugs or tranquilizers (such as Ativan, Deprol, Equanil, Diazepam, Klonopin, Meprobamate, Librium, Miltown, Serax, Valium, or Xanax)? On how many days?
gain_013IntegerRecommendedHave you used methamphetamines, crystal, ice, glass, or other forms of methedrine (such as Desoxyn)?0; 11= Yes; 0= No
gain_013aIntegerRecommendedHave you used methamphetamines, crystal, ice, glass, or other forms of methedrine (such as Desoxyn)? On how many days?
stimulIntegerRecommendedstimulants0;1;-70=No; 1=Yes; -7=Refusedgain_014
gain_014aIntegerRecommendedHave you used speed, uppers, amphetamines, ecstasy, MDMA or other stimulants (such as Biphetamine, Benzedrine, Dexedrine, or Ritalin)? On how many days?
sedativesIntegerRecommendedSedatives0;10=No; 1=Yesgain_015
gain_015aIntegerRecommendedHave you used downers, sleeping pills, barbiturates, or other sedatives (such as Dalmane, Donnatal, Doriden, Flurazepam, GHB, Halcion, liquid ecstasy, methaqualone, Placidyl, Quaalude, Secobarbital, Seconal, Rophypnol, or Tuinal)? On how many days?
otdrgIntegerRecommendedother drugs0;1;-70=No; 1=Yes; -7=Refusedgain_016
otdrugString40RecommendedOther druggain_016a
frquency_otherIntegerRecommendedThink specifically about the past 30 days, including today. During the past 30 days, on how many days did you use any other medicines or drugs or substances? PX031301_Frequency_Other0::30gain_016b
gain_06IntegerRecommendedHow many days did you go without using any alcohol, marijuana or other drugs?
gain_07IntegerRecommendedHow many days did you get drunk or were you high for most of the day?
gain_07aIntegerRecommendedHow many days did alcohol or drug use problems keep you from meeting your responsibilities at work, school, or home?
gain_07bIntegerRecommendedDuring the past 30 days what is the most days you have gone in a row without using alcohol, marijuana, or other drugs?
gain_08IntegerRecommendedHave you tried to hide that you were using alcohol or other drugs?0; 11= Yes; 0= No
gain_09IntegerRecommendedDid your parents, family, partner, co-workers, classmates or friends complain about your alcohol or other drug use?0; 11= Yes; 0= No
gain_10IntegerRecommendedHave you used alcohol or other drugs weekly or more often?0; 11= Yes; 0= No
gain_11IntegerRecommendedDid your alcohol or other drug use caused you to feel depressed, nervous, suspicious, uninterested in things, reduced your sexual desire or caused other psychological problems?0; 11= Yes; 0= No
gain_12IntegerRecommendedDid your alcohol or other drug use cause you to have numbness, tingling, shakes, blackouts, hepatitis, TB, sexually transmitted disease, or any other health problems?0; 11= Yes; 0= No
gain_13IntegerRecommendedHave you kept using alcohol or other drugs even though you knew it was keeping you from meeting your responsibilities at work, school, or home?0; 11= Yes; 0= No
gain_14IntegerRecommendedHave you repeatedly used alcohol or other drugs when it made the situation unsafe or dangerous for you, such as when you were driving a car, using a machine, or when you might have been forced into sex or hurt?0; 11= Yes; 0= No
gain_15IntegerRecommendedDid your alcohol or other drug use cause you to have repeated problems with the law?0; 11= Yes; 0= No
gain_16IntegerRecommendedHave you kept using alcohol or other drugs even though it was causing social problems, leading to fights, or getting you into trouble with other people?0; 11= Yes; 0= No
gain_17IntegerRecommendedHave you needed more alcohol or other drugs to get the same high or found that the same amount did not get you as high as it used to?0; 11= Yes; 0= No
gain_18IntegerRecommendedHave you had withdrawal problems from alcohol or other drugs like shaking hands, throwing up, having trouble sitting still or sleeping, or you used any alcohol or other drugs to stop being sick or avoid withdrawal problems?0; 11= Yes; 0= No
gain_19IntegerRecommendedHave you used alcohol or other drugs in larger amounts, more often or for a longer time than you meant to?0; 11= Yes; 0= No
gain_20IntegerRecommendedHave you been unable to cut down or stop using alcohol or other drugs?0; 11= Yes; 0= No
gain_21IntegerRecommendedHave you spent a lot of time either getting alcohol or other drugs, using alcohol or other drugs, or feeling the effects of alcohol or other drugs (high, sick)?0; 11= Yes; 0= No
gain_22IntegerRecommendedDid your use of alcohol or other drugs caused you to give up, reduce or have problems at important activities at work, school, home or social events?0; 11= Yes; 0= No
gain_23IntegerRecommendedHave you kept using alcohol or other drugs even after you knew it was causing or adding to medical, psychological or emotional problems you were having?0; 11= Yes; 0= No
gain_24IntegerRecommendedHave you had such strong urges to use alcohol or other drugs you could not think of anything else?0; 11= Yes; 0= No
gain_scoreString100RecommendedSubstance Abuse Status
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: gain01 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.