NDA Help Center

Login Dialog

Frequently Asked Questions

Glossary

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.

Glossary

  • 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. 

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

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
Filter Cart
No filters selected
Description
Value Range
Notes
Data Structures with shared data
No filters have been selected
Switch User

ABCD Youth Diagnostic Interview for DSM-5 Background Items 5 (KSADS-5)

11,878 Shared Subjects

School, sexual orientation
Clinical Assessments
Social Adjustment
11/30/2017
abcd_yksad01
05/20/2021
View Change History
01
Query Element Name Data Type Size Required Condition Description Value Range Notes Aliases
subjectkey GUID Required The NDAR Global Unique Identifier (GUID) for research subject NDAR*
src_subject_id String 20 Required Subject ID how it's defined in lab/project
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY
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.
sex String 20 Required Sex of subject at birth M;F; O; NR M = Male; F = Female; O=Other; NR = Not reported gender
eventname String 60 Required The event name for which the data was collected
Query kbi_y_grade_repeat Integer Recommended Have you ever repeated a grade? 0 ; 1 ; 777 1 = Yes; 0 = No ; 777 = Decline to answer ksads_back_grade_repeat
Query kbi_y_drop_in_grades Integer Recommended Has there been a drop in your grades in the past year? 0 ; 1 ; 777 1 = Yes; 0 = No ; 777 = Decline to answer ksads_back_drop_in_grades
Query kbi_y_det_susp Integer Recommended In the past year, have you had any detentions or suspensions? 0 ; 1 ; 777 1 = Yes; 0 = No ; 777 = Decline to answer ksads_back_det_susp
Query kbi_y_det_reason___1 Integer Recommended kbi_y_det_susp == 1 For what? Click all that apply: (1, Fighting) 0 ; 1 0 = No; 1 = Yes ksads_back_det_reason___1
Query kbi_y_det_reason___2 Integer Recommended kbi_y_det_susp == 1 For what? Click all that apply: ( 2, Talking Back to a Teacher) 0 ; 1 0 = No; 1 = Yes ksads_back_det_reason___2
Query kbi_y_det_reason___3 Integer Recommended kbi_y_det_susp == 1 For what? Click all that apply: ( 3, Threatening a Teacher) 0 ; 1 0 = No; 1 = Yes ksads_back_det_reason___3
Query kbi_y_det_reason___4 Integer Recommended kbi_y_det_susp == 1 For what? Click all that apply: ( 4, Cutting Classes) 0 ; 1 0 = No; 1 = Yes ksads_back_det_reason___4
Query kbi_y_det_reason___5 Integer Recommended kbi_y_det_susp == 1 For what? Click all that apply: ( 5, Using Drugs at School) 0 ; 1 0 = No; 1 = Yes ksads_back_det_reason___5
Query kbi_y_det_reason___6 Integer Recommended kbi_y_det_susp == 1 For what? Click all that apply: ( 6, Drinking at School) 0 ; 1 0 = No; 1 = Yes ksads_back_det_reason___6
Query kbi_y_det_reason___7 Integer Recommended kbi_y_det_susp == 1 For what? Click all that apply: ( 7, Bringing a Weapon to School) 0 ; 1 0 = No; 1 = Yes ksads_back_det_reason___7
Query kbi_y_det_reason___8 Integer Recommended kbi_y_det_susp == 1 For what? Click all that apply: ( 8, Other (fill in blank)) 0 ; 1 0 = No; 1 = Yes ksads_back_det_reason___8
Query kbi_y_sex_orient Integer Recommended Are you gay or bisexual? 1 ; 2 ; 3 ; 4; 777 1 = Yes; 2 = Maybe; 3 = No; 4 = I do not understand this question ; 777 = Decline to answer ksads_back_sex_orient
Query kbi_y_sex_orient_probs Integer Recommended kbi_y_sex_orient == 1 || kbi_y_sex_orient == 2 Has this caused any problems for you with your family or with kids at school? 1 ; 2 ; 3; 777 1 = Not at all; 2 = Some; 3 = A lot ; 777 = Decline to answer ksads_back_sex_orient_probs
Query kbi_y_trans_id Integer Recommended Are you transgender? 1 ; 2 ; 3 ; 4; 777 1 = Yes; 2 = Maybe; 3 = No; 4 = I do not understand this question ; 777 = Decline to answer ksads_back_trans_id
Query kbi_y_trans_prob Integer Recommended kbi_y_trans_id == 2 || kbi_y_trans_id == 1 Has this caused any problems for you with your family or with kids at school? 1 ; 2 ; 3; 777 1 = Not at all; 2 = Some; 3 = A lot ; 777 = Decline to answer ksads_back_trans_prob
Query ksads_bully_raw_26 Integer Recommended Do you have any problems with bullying at school or in your neighborhood? 0 ; 1 1 = Yes; 0 = No
kbi_y_det_reason___777 Integer Recommended kbi_y_det_susp == 1 For what? Click all that apply: ( 777 Decline to answer) 0 ; 1 0 = No; 1 = Yes ksads_back_det_reason___777
kbi_y_det_reason_new___2 Integer Recommended For what? Click all that apply: 2, 2, Talking Back to a Teacher 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___3 Integer Recommended For what? Click all that apply: 3, 3, Threatening a Teacher 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___4 Integer Recommended For what? Click all that apply: 4, 4, Cutting Classes 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___5 Integer Recommended For what? Click all that apply: 5, 5, Using Drugs at School 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___6 Integer Recommended For what? Click all that apply: 6, 6, Drinking at School 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___7 Integer Recommended For what? Click all that apply: 7, 7, Bringing a Weapon to School 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___8 Integer Recommended For what? Click all that apply: 8, 8, Dress code violation 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___9 Integer Recommended For what? Click all that apply: 9, 9, Stealing 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___10 Integer Recommended For what? Click all that apply: 10, 10, Throwing things, breaking things, or vandalism 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___11 Integer Recommended For what? Click all that apply: 11, 11, Whole class got a suspension 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___12 Integer Recommended For what? Click all that apply: 12, 12, Smoking, vaping or cell use 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___13 Integer Recommended For what? Click all that apply: 13, 13, ''Bullying'' or threatening a student 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___14 Integer Recommended For what? Click all that apply: 14, 14, Physically hurting someone, intentionally or accidentally (but not as part of a fight, choose item #1 for a fight) 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___15 Integer Recommended For what? Click all that apply: 15, 15, Using bad language or saying mean or hurtful things 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___16 Integer Recommended For what? Click all that apply: 16, 16, Bringing something to school that is not allowed (other than a weapon, alcohol, or drugs, choose options # 5 for these) 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___17 Integer Recommended For what? Click all that apply: 17, 17, Being disruptive (e.g., talking or arguing in class, making noises, not following instructions, passing notes, standing on school bus, running in hallway, playing in class or in the bathroom) 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___18 Integer Recommended For what? Click all that apply: 18, 18, Not doing or not handing in homework 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___19 Integer Recommended For what? Click all that apply: 19, 19, Being late for class or school 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___20 Integer Recommended For what? Click all that apply: 20, 20, Other 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_y_det_reason_new___21 Integer Recommended For what? Click all that apply: 777, 21, Refuse to answer 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_remote___1 Integer Recommended Remote method of KSADS Background Items & KSADS-5 administration [Check all that apply]: 1, Audio (i.e. phone call) 0;1 1 = Yes; 0 = No [sched_delay] = '9' or [sched_hybrid] = '1'
kbi_desc_self Integer Recommended Would you describe yourself as: 1::3;777 1=Heterosexual (straight) ; 2=Other ; 3=Unsure ; 777=Decline to answer ([kbi_y_sex_orient] = '3' AND [event-name] = '4_year_follow_up_y_arm_1')
kbi_desc_self_2 Integer Recommended Would you describe yourself as: 1::4;777 1=Gay or lesbian ; 2=Bisexual ; 3=Other ; 4=Unsure ; 777=Decline to answer ([kbi_y_sex_orient] = '1' AND [event-name] = '4_year_follow_up_y_arm_1')
kbi_desc_self_3 Integer Recommended Would you describe yourself as: 1::5;777 1=Gay or lesbian ; 2=Bisexual ; 3=Heterosexual (straight) ; 4=Other ; 5=Unsure ; 777=Decline to answer ([kbi_y_sex_orient] = '2' AND [event-name] = '4_year_follow_up_y_arm_1')
kbi_grades_repeated___1 Integer Recommended Please indicate what grades you repeated in the past: 1, 1st 0;1 0=No ; 1=Yes [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_grades_repeated___2 Integer Recommended Please indicate what grades you repeated in the past: 2, 2nd 0;1 0=No ; 1=Yes [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_grades_repeated___3 Integer Recommended Please indicate what grades you repeated in the past: 3, 3rd 0;1 0=No ; 1=Yes [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_grades_repeated___4 Integer Recommended Please indicate what grades you repeated in the past: 4, 4th 0;1 0=No ; 1=Yes [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_grades_repeated___5 Integer Recommended Please indicate what grades you repeated in the past: 5, 5th 0;1 0=No ; 1=Yes [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_grades_repeated___6 Integer Recommended Please indicate what grades you repeated in the past: 6, 6th 0;1 0=No ; 1=Yes [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_grades_repeated___7 Integer Recommended Please indicate what grades you repeated in the past: 7, 7th 0;1 0=No ; 1=Yes [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_remote___2 Integer Recommended Remote method of KSADS Background Items & KSADS-5 administration [Check all that apply]: 2, Video/Webcam 0;1 1 = Yes; 0 = No [sched_delay] = '9' or [sched_hybrid] = '1'
kbi_grades_repeated___8 Integer Recommended Please indicate what grades you repeated in the past: 8, 8th 0;1 0=No ; 1=Yes [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_grades_repeated___777 Integer Recommended Please indicate what grades you repeated in the past: 777, Refuse to answer 0;1 0=No ; 1=Yes [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_repeat_grade_before_pst_yr Integer Recommended Have you repeated a grade before the past year? 1;0;777 1=Yes ; 0=No ; 777=Refuse to answer [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_repeat_grade_pst_yr Integer Recommended Have you repeated a grade in the past year? 1;0;777 1=Yes ; 0=No ; 777=Refuse to answer [kbi_y_grade_repeat] = '1' and [event-name] = ''3_year_follow_up_y_arm_1''
kbi_sex_assigned_at_birth Integer Recommended What was your sex assigned at birth 1;2;999;777 1=Male ; 2=Female ; 999=Don't know ; 777=Refuse to answer [event_name_number] > '21'
kbi_remote___3 Integer Recommended Remote method of KSADS Background Items & KSADS-5 administration [Check all that apply]: 3, Screen Sharing 0;1 1 = Yes; 0 = No [sched_delay] = '9' or [sched_hybrid] = '1'
kbi_remote___4 Integer Recommended Remote method of KSADS Background Items & KSADS-5 administration [Check all that apply]: 4, In person (ONLY if issues arise and hybrid) 0;1 1 = Yes; 0 = No [sched_delay] = '9' or [sched_hybrid] = '1'
kbi_device Integer Recommended Youth's Device: 1::3 1=Phone Screen ; 2=Tablet/iPad Screen ; 3=Computer Screen [kbi_remote(2)] = ''1'' or [kbi_remote(3)] = ''1''
kbi_gender Integer Recommended What is your current gender identity? 1::3;777;999 1=Boy ; 2=Girl ; 3=Another gender (e.g. nonbinary) ; 999=I don't understand the question ; 777=Refuse to answer
kbi_y_det_reason_new___1 Integer Recommended For what? Click all that apply:1, 1, Fighting 0;1 0=No ; 1=Yes [kbi_y_det_susp] = '1' and [event_name_number] > '30'
kbi_admin Integer Recommended Please indicate how instrument was administered: 1::3 1=RA-Administered ; 2=Youth Self-Administered ; 3=Combination [sched_delay] = '7' and ([event-name] = 2_year_follow_up_y_arm_1'' or [event-name] = ''3_year_follow_up_y_arm_1'')''
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.