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

  • 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

Household Demographics and Medication History

0 Shared Subjects

Household Demographics and Medication history of subject
Clinical Assessments
Demographics
12/14/2017
hdmh01
01/10/2018
View Change History
01
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*
src_subject_id String 20 Required Subject ID how it's defined in lab/project clinical_barcode
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field bl_visit_date, date_demographics
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. ch_age
sex String 20 Required Sex of the subject
M;F; O; NR
M = Male; F = Female; O=Other; NR = Not reported ch_sex, gender
race String 30 Required Race of study subject
American Indian/Alaska Native; Asian; Hawaiian or Pacific Islander; Black or African American; White; More than one race; Unknown or not reported
race_dem
ethnic_group String 255 Recommended Ethnic group ethnicity_dem
Query ca243 Integer Recommended What handedness do you consider yourself? 1::3 1=Right; 2=Left; 3=Mixed overall_handedness
Query dmg_q54 Integer Recommended total number of full siblings 0::99 0 - 99 full_sib_total
Query dmg_q55 Integer Recommended total number of half siblings 0::99 0 - 99 half_sib_total
otherrace String 100 Recommended specify other race The following questions are about you or the child's family. race_other_dem
Query fh07 Integer Recommended 7. Subject adopted 0;1;9 dem_adopted
das1ms String 200 Recommended Marital status dem_marital_status
Query dmg_curlvcir Integer Recommended child current living circumstances 1::8 1=Parental home (at least one parent) 2=Relatives (other than parents) 3=With (child's) boyfriend/girlfriend or spouse (includes common law arrangement) 4=With unrelated adults 5=Foster home 6=Group home 7=Institution 8=Other subject_living_dem
ses1job String 100 Recommended Head of Household: Job Title dem_head_job_title
Query occupation Integer Recommended (or OCCUP); Hollingshead Status - HEAD OF HOUSEHOLD 1::9 1 = Farm Laborers/Menial Service Workers, Welfare Recipients; 2 = Unskilled Workers; 3 = Machine Operators, Semi-Skilled Workers; 4 = Smaller Business Owners, Skilled Manual Workers, Craftsmen, Tenant Farmers; 5 = Clerical and Sales Workers, Small Farm and Business Owners; 6 = Technicians, Semi-Professionals and Small Business Owners; 7 = Smaller Business Owners, Farm Owners, Managers, Minor Professionals; 8 = Administrators, Lesser Professionals, Proprietors of Medium-Sized Businesses; 9 = Higher Executives, Proprietors of Large Businesses, Major Professionals dem_head_hollingshead
Query emply Integer Recommended HEAD OF HOUSEHOLD Presently Employed 0;1;2;7 0 = NO; 1 = YES - PART TIME; 2 = YES - FULL TIME; 7 = RETIRED dem_head_employed
ses2job String 50 Recommended Spouse/Significant Other: Job Title dem_spouse_job_title
Query ses2educ Integer Recommended Spouse/Significant Other: Education 1::7 1 = Less than 7th Grade; 2 = Jr. High School (7th/8th/9th grade); 3 = Some High School (10th/11th/12th grade); 4 = High School Graduate; 5 = Some College (at least 1 year); 6 = Standard College Degree; 7 = Graduate Professional Training dem_spouse_education
Query occupationsp Integer Recommended (or OCCUPSP); Hollingshead Status - SPOUSE 1::9 1 = Farm Laborers/Menial Service Workers, Welfare Recipients; 2 = Unskilled Workers; 3 = Machine Operators, Semi-Skilled Workers; 4 = Smaller Business Owners, Skilled Manual Workers, Craftsmen, Tenant Farmers; 5 = Clerical and Sales Workers, Small Farm and Business Owners; 6 = Technicians, Semi-Professionals and Small Business Owners; 7 = Smaller Business Owners, Farm Owners, Managers, Minor Professionals; 8 = Administrators, Lesser Professionals, Proprietors of Medium-Sized Businesses; 9 = Higher Executives, Proprietors of Large Businesses, Major Professionals; 88 = not applicable; 99 = missing dem_spouse_hollingshead
Query spouse_empl Integer Recommended Is your spouse currently employed 0::2; 7 0=No; 1=Yes part-time; 2=Yes full-time; 7=Retired dem_spouse_employed
Query educ Integer Recommended HEAD OF HOUSEHOLD Education 1::7 1 = Less than 7th Grade; 2 = Jr. High School (9th Grade); 3 = Some High School (10th or 11th Grade); 4 = High School Graduate; 5 = Some College (at least 1 year); 6 = Standard College Degree; 7 = Graduate Professional Training dem_head_education
respondent String 20 Recommended Respondent Mother;Father;Both;Other;Parent;Teacher;Child informant_dem
Query supt Integer Recommended Receives support if parent's divorced or separated? 0; 1 0 = No; 1 = Yes dem_divorced_support
Query demo6 Integer Recommended Sisters 0::9 0=none in home; 1= one in home; 2= two in home; 9=9 in home sisters_dem
Query d6c1 Integer Recommended Number of full sisters full_sist_total
Query d6e1 Integer Recommended Number of half sisters half_sis_total
Query demo5 Integer Recommended Brothers 0::9 0=none in home; 1= one in home; 2= two in home; 9=9 in home brothers_dem
Query d6b1 Integer Recommended Number of full brothers full_bro_total
Query d6f1 Integer Recommended Number of adopted brothers half_bro_total
medication1_name String 500 Recommended Name first medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_1
medication2_name String 200 Recommended Name second medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_2
medication3_name String 150 Recommended Name third medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_3
medication4_name String 100 Recommended Name fourth medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_4
medication5_name String 500 Recommended Name fifth medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_5
medication6_name String 500 Recommended Name sixth medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_6
medication7_name String 100 Recommended Name seventh medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_7
medication8_name String 100 Recommended Name eighth medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_8
medication9_name String 100 Recommended Name ninth medication that the participant has taken med_9
medication10_name String 100 Recommended Name tenth medication that the participant has taken med_10
medication11_name String 100 Recommended Medication 11 name med_11
medication12_name String 100 Recommended Med name12 med_12
medication13_name String 500 Recommended Medication 13 name med_13
medication14_name String 500 Recommended Medication 14 name med_14
medication15_name String 500 Recommended Medication 15 name med_15
medication16_name String 500 Recommended Med name16 med_16
medication17_name String 500 Recommended Med name17 med_17
medication18_name String 500 Recommended Med name18 med_18
medication19_name String 500 Recommended medication name 19 med_19
medication20_name String 500 Recommended medication name 20 med_20
medication21_name String 500 Recommended medication name 21 med_21
medication22_name String 500 Recommended medication name 22 med_22
medication23_name String 500 Recommended medication name 23 med_23
medication24_name String 500 Recommended medication name 24 med_24
medication25_name String 500 Recommended medication name 25 med_25
medication26_name String 500 Recommended medication name 26 med_26
medication27_name String 500 Recommended medication name 27 med_27
medication28_name String 500 Recommended medication name 28 med_28
medication29_name String 500 Recommended medication name 29 med_29
medication30_name String 500 Recommended medication name 30 med_30
Query basline_meds Integer Recommended Has participant taken medications (including OTC) at screening/baseline visit? 0::1 0= No; 1= Yes
Query six_mo_meds Integer Recommended Has participant taken medications (including OTC) between baseline and 6 months follow up? 0::1 0= No; 1= Yes
Query twentyfour_mo_meds Integer Recommended Has participant taken medications (including OTC) between 6 month and 24 month follow up? 0::1 0= No; 1= Yes
Query ses Integer Recommended Hollingshead SES Score SES at age of entry to study dem_social_status_num
Query sestot Integer Recommended Socio-Economic Status (SES) 1::5 1 = SES score of 08 to 19;2 = SES score of 20 to 29;3 = SES score of 30 to 39;4 = SES score of 40 to 54;5 = SES score of 55 to 66 dem_social_status_range
Query education_level_dem Integer Recommended Level of Education - Subject 0::14; 99; 999 0= Kindergarten; 1= First grade; 2= Second grade; 3= Third grade; 4= Fourth grade; 5= Fifth grade; 6= Sixth grade; 7= Seventh grade; 8= Eighth grade; 9= Ninth grade; 10= Tenth grade; 11= Eleventh grade; 12= Twelfth grade; 13= Special school; 14= Out of school; 99= Other; 999= Unknown
srs_respond_detail_oth_spec String 250 Recommended Respondent detail, specify other informant_other_dem
living_other_dem String 25 Recommended If subject is living with other person, please specify
Query demo_siblingscount Integer Recommended Number of siblings 888 = not applicable; 999 = missing total_sib_dem
Query fh13 Integer Recommended Birth order 0::13; 99 99 = Missing value birth_order_dem
Query dem_adopted_related Integer Recommended If subject is adopted, are adoptive parent(s) also biologically related to subject? 0::1 0= No; 1= Yes
Query dem_adoptive_relationship Integer Recommended If subject's adoptive parents are biologically related, please specify relationship: 1::13 1= Maternal Grandmother only; 2= Maternal Grandfather only; 3= Both Maternal Grandparents; 4= Paternal Grandmother only; 5= Paternal Grandfather only; 6= Both Paternal Grandparents; 7= Maternal Aunt only; 8= Maternal Uncle only; 9= Both Maternal Aunt and Uncle; 10= Paternal Aunt only; 11= Paternal Uncle only; 12= Both Paternal Aunt and Uncle; 13= Other relative
dem_adoptive_related_other String 50 Recommended If subject's adoptive parents are other relatives, please specify
p002_specify String 500 Recommended Describe Allergy ch_allergies
Query upreg Integer Recommended Pregnant - Urine test 1::3; 9 1=Positive; 2=Negative; 3=Not done; 9=Equivocal (Must retest) ch_pregnancy_baseline
mnstrdt Date Recommended Date of Last Menstrual Period last_period_date_baseline
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.