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

Clinic Visit

5,568 Shared Subjects

N/A
Clinical Assessments
Phys Exam
12/10/2014
ccv01

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 bid, id, randid
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field
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 the subject M;F; O; NR M = Male; F = Female; O=Other; NR = Not reported gender
level String 10 Recommended Treatment level
Query week Float Recommended Week in level/study 99=week 10-week 14
crcid String 40 Recommended CRC ID/ROA ID
Query clinid Integer Recommended Clinician ID
Query clinicid Integer Recommended Clinic ID
Query update Integer Recommended Updated form 0;1 1= yes; 0= no
Query vis_type Integer Recommended Visit type 0::2 1=Phone; 0=doctor's office; 2=No, not phone interview locale, phone
Query menop Integer Recommended Menopausal/post-hysterectomy/male 0;1 0=No; 1=Yes
Query mpdatm Integer Recommended Date of last menstrual period mpdate
Query medication1_name String 500 Recommended Name first medication that the participant has taken 0 = No medication; 999= Legitimately skipped admd1, llaa3a, stnm1
Query medication2_name String 200 Recommended Name second medication that the participant has taken 0 = No medication; 999= Legitimately skipped admd2, llaa3b, stnm2
Query medication3_name String 150 Recommended Name third medication that the participant has taken 0 = No medication; 999= Legitimately skipped admd3, llaa3c, stnm3
Query medication4_name String 100 Recommended Name fourth medication that the participant has taken 0 = No medication; 999= Legitimately skipped admd4, llaa3d, llaada, stnm4
medication1_dosage String 150 Recommended First medication dosage 0 = No medication; 999 = Missing adds1, llaa4a1
medication2_dosage String 100 Recommended Second medication dosage 0 = No medication; 999 = Missing adds2, llaa4b1
Query medication3_dosage String 100 Recommended Third medication dosage 0 = No medication; 999 = Missing adds3, llaa4c1
Query medication4_dosage String 100 Recommended Fourth medication dosage 0 = No medication; 999 = Missing adds4, llaa4d1
Query lithm Integer Recommended Patient taking Li/NTP 0;1 0=No; 1=Yes
Query mtype Integer Recommended Med type 1::4 1=Li; 2=NTP; 3 = Other psychiatric medication, 4 = Non-psychiatric medication
Query serum Float Recommended Most recent serum level
Query drdat Integer Recommended Date blood drawn
Query liadj Integer Recommended Li or NTP dose adjustment needed 0;1;-2 0=No; 1=Yes; -2=N/A
Query litdy Integer Recommended Li or NTP serum level needed today 0;1;-2 0=No; 1=Yes; -2=N/A
Query suicd Integer Recommended Patient presently a suicide risk 0;1 0=No; 1=Yes risksui, risksuic
Query remsn Integer Recommended Patient in remission 0;1 0=No; 1=Yes
Query raise Integer Recommended Dose will be raised 0;1 0=No; 1=Yes
Query effct Integer Recommended Side effects prevent dose increase 0;1 0=Not checked; 1=Checked sideefct
Query cnmd Integer Recommended Concomitant meds prevent dose increase 0;1 0=Not checked; 1=Checked
Query cncn Integer Recommended Medical condition prevents dose increase 0;1 0=Not checked; 1=Checked
Query prtcl Integer Recommended Protocol prohibits dose increase 0;1 0=Not checked; 1=Checked
Query other Integer Required Other prevent dose increase 0;1;999 0 = No; 1 = Yes
Query stmed Integer Recommended Currently on STAR*D meds? 0;1 0=No; 1=Yes
Query stmd1 String 100 Recommended Prescribed med code 1
Query stmd2 String 50 Recommended Prescribed med code 2
Query stmd3 String 50 Recommended Prescribed med code 3
Query stmd4 String 50 Recommended Prescribed med code 4
Query stmd5 String 50 Recommended Prescribed med code 5
Query stmd6 String 50 Recommended Prescribed med code 6
Query stds1 Float Recommended Prescribed med daily dose 1
Query stds2 Float Recommended Prescribed med daily dose 2
Query stds3 Float Recommended Prescribed med daily dose 3
Query stds4 Float Recommended Prescribed med daily dose 4
Query stds5 String 50 Recommended Prescribed med daily dose 5
Query stds6 String 50 Recommended Prescribed med daily dose 6
Query adstart1 Integer Recommended Study med start date at this dose 1
Query adstart2 Integer Recommended Study med start date at this dose 2
Query adstart3 Integer Recommended Study med start date at this dose 3
Query adstart4 Integer Recommended Study med start date at this dose 4
Query stsd1 Float Recommended Prescribed med start date 1
Query stpdate1 Float Recommended Study med stop date1 sted1
Query stsd2 Float Recommended Prescribed med start date 2
Query stpdate2 Float Recommended Study med stop date2 sted2
Query stsd3 Float Recommended Prescribed med start date 3
Query stpdate3 Float Recommended Study med stop date3 sted3
Query stsd4 Float Recommended Prescribed med start date 4
Query stpdate4 Float Recommended Study med stop date4 sted4
Query stsd5 Integer Recommended Prescribed med start date 5
Query stpdate5 Integer Recommended Prescribed med end date 5 sted5
Query stsd6 Integer Recommended Prescribed med start date 6
Query stpdate6 Integer Recommended Prescribed med end date 6 sted6
Query trtmt Integer Recommended Treatment plan 1::4 1=Continue current level; 2=Go to next level; 3=Go to follow up; 4=Exit study
Query fnaid Integer Recommended Billed to third party 0;1 0=No; 1=Yes
Query days_baseline Integer Recommended Days since baseline date
Query visit String 60 Recommended Visit name int1, vtype
Query uvfa1a Integer Recommended Why did this visit occur:Assessment of possible change in psychiatric symptoms? 0;1 0=No; 1=Yes
Query uvfa1b Integer Recommended Why did this visit occur: Assessment of possible change in drug tolerability, adverse event? 0;1 0=No; 1=Yes
Query uvfa1c Integer Recommended Why did this visit occur: Assessment of possible change in medical status. 0;1 0=No; 1=Yes
Query uvfa1d Integer Recommended Why did this visit occur: Assessment of need for medication changes or adjustment or re-supply. 0;1 0=No; 1=Yes
Query fseqno Integer Recommended Sequence Number 0::999 The FSEQNO variable in the ADJ form has a special interpretation compared to other forms. For example, ADJ FSEQNO of '1' can be thought of as being '001', FSEQNO of '2' can be thought of as being '002', and FSEQNO of '3' can be thought of as being '003'. The first digit of FSEQNO relates to the corresponding ENF sequence number at that visit and the third digit relates to the specific adjudicator who completed the adjudication form.
Query version_form String 121 Recommended Form used/assessment name vers
Query daysrz Integer Recommended days since randomization llaa0b, uvfa0b, visitdt
Query llaa1 Integer Recommended Is the patient taking a lipid lowering agent? 0;1 0=No; 1= Yes
Query llaa2 Integer Recommended Since the last study visit, have there been any changes in the specific lipid-lowering agent the patient is taking or in the dose of that agent? 0;1 0=No; 1= Yes
Query medication5_name String 500 Recommended Name fifth medication that the participant has taken 0 = No medication; 999= Legitimately skipped llaa3e, stnm5
Query medication6_name String 500 Recommended Name sixth medication that the participant has taken 0 = No medication; 999= Legitimately skipped llaa3f, stnm6
medication5_dosage String 100 Recommended Fifth medication dosage 0 = No medication; 999 = Missing llaa4e1
Query medication6_dosage String 100 Recommended Sixth medication dosage 0 = No medication; 999 = Missing llaa4f1
Query medication1_unit String 100 Recommended Units of medication #1: llaa4a2
Query medication2_unit String 100 Recommended Units of medication #2: llaa4b2
Query medication3_unit String 100 Recommended Units of medication #3: llaa4c2
medication4_unit String 100 Recommended Units of medication #4: llaa4d2
medication5_unit String 100 Recommended Units of medication #5: llaa4e2
Query medication6_unit String 100 Recommended Units of medication #6: llaa4f2
Query llaa5a Integer Recommended Since your last appointment, on how many days did you NOT TAKE medication #1? 0::50; -999 999=Legitimately skipped
Query llaa5b Integer Recommended Since your last appointment, on how many days did you NOT TAKE medication #2? 0::50; -999 999=Legitimately skipped
Query llaa5c Integer Recommended Since your last appointment, on how many days did you NOT TAKE medication #3? 0::50; -999 999=Legitimately skipped
Query llaa5d Integer Recommended Since your last appointment, on how many days did you NOT TAKE medication #4? 0::50; -999 999=Legitimately skipped
Query llaa5e Integer Recommended Since your last appointment, on how many days did you NOT TAKE medication #5? 0::50; -999 999=Legitimately skipped
Query llaa5f Integer Recommended Since your last appointment, on how many days did you NOT TAKE medication #6? 0::50; -999 999=Legitimately skipped
Query llaa6a Integer Recommended Since your last appointment, on how many days did you take MORE THAN or LESS THAN the prescribed dose of medication #1? 0::50; -999 999=Legitimately skipped
Query llaa6b Integer Recommended Since your last appointment, on how many days did you take MORE THAN or LESS THAN the prescribed dose of medication #2? 0::50; -999 999=Legitimately skipped
Query llaa6c Integer Recommended Since your last appointment, on how many days did you take MORE THAN or LESS THAN the prescribed dose of medication #3? 0::50; -999 999=Legitimately skipped
Query llaa6d Integer Recommended Since your last appointment, on how many days did you take MORE THAN or LESS THAN the prescribed dose of medication # 4? 0::50; -999 999=Legitimately skipped
Query llaa6e Integer Recommended Since your last appointment, on how many days did you take MORE THAN or LESS THAN the prescribed dose of medication #5? 0::50; -999 999=Legitimately skipped
Query llaa6f Integer Recommended Since your last appointment, on how many days did you take MORE THAN or LESS THAN the prescribed dose of medication #6? 0::50; -999 999=Legitimately skipped
Query llaa7a Integer Recommended Based on the clinician's best judgment, please indicate the patient's adherence to medication #1: (Choose one LLAA7A from A, B, C, D, or E below) 1::5; 999 999=Legitimately skipped
Query llaa7b Integer Recommended Based on the clinician's best judgment, please indicate the patient's adherence to the medication: (Choose one from A, B, C, D, or E below) 1::5; 999 999=Legitimately skipped
Query llaa7c Integer Recommended Based on the clinician's best judgment, please indicate the patient's adherence to medication #3: (Choose one from A, B, C, D, or E below) 1::5; 999 999=Legitimately skipped
Query llaa7d Integer Recommended Based on the clinician's best judgment, please indicate the patient's adherence to medication #4: (Choose one from A, B, C, D, or E below) 1::5; 999 999=Legitimately skipped
Query llaa7e Integer Recommended Based on the clinician's best judgment, please indicate the patient's adherence to medication #5: (Choose one from A, B, C, D, or E below) 1::5; 999 999=Legitimately skipped
Query llaa7f Integer Recommended Based on the clinician's best judgment, please indicate the patient's adherence to the medication: (Choose one from A, B, C, D, or E below) 1::5; 999 999=Legitimately skipped
Query study String 100 Recommended Study studyid
Query site String 101 Recommended Site Study Site siteid
Query completed Integer Recommended Checks if completed 0::3 0=No; 1=Yes; 2=Yes, lost; 3=Unverified formcomp
Query subtrial_name Integer Recommended Name of subtrial 1::3 1=Crossover; 2=Guanfacine; 3= Open Label MPH
Query vis_q01 Integer Recommended Attended visit? 0::3 0=No; 1=Yes;2=Yes, visit form entered; 3=Yes, data collected - visit form added later
Query qccur_r Float Recommended QIDS-C current score (transcribed) qccur
Query hrsd_r Float Recommended HRS-D current score (transcribed) 999=missing hrsdcur
Query atmtsuic Integer Recommended Attempted suicide 0;1 0=No; 1=Yes
Query eeg012 Integer Recommended Women only: Still experiencing menstrual periods? 0;1;9 0=No; 1=Yes; 9=N/A menop_1
Query qcbeg_r Float Recommended QIDS-C beginning score (transcribed)
Query qcimp_r Float Recommended QIDS-C percent improvement (transcribed)
Query fibser_1 Integer Recommended 1. Choose the response that best describes the frequency (how often) of the side effects of the medication you have taken within the past week for your depression. 0::7 0=No side effects; 1=Present 10% of the time; 2=Present 25% of the time; 3=Present 5-% of the time; 4=Present 75% of the time; 5=Present 90% of the time; 6=Present all the time; 7=refused fiserf, fiserfrg, fiserfrq
Query fibser_2 Integer Recommended 2. Choose the response that best describes the intensity (how severe) of the side effects that you believe are due to the medication you have taken within the last week for your depression 0::6 0=No side effects; 1=Trivial; 2=Mild; 3=Moderate; 4=Marked; 5=Severe; 6=Intolerable fideri, fiserint
Query fibser_3 Integer Recommended 3. Choose the response that best describes the degree to which antidepressant medication side effects that you have had over the last week have interfered with your day to day functions. 0::6 0=No impairment; 1=Minimal impairment; 2=Mild impairment; 3=Moderate impairment; 4=Marked impairment; 5=Severe impairment; 6=Unable to function due to side effects grseb
Query cgi_sii_0_7 Integer Recommended CGI SII 0 - 7 Improvment/change 0::7; 9 0 = Not assessed; 1 = Very much improved; 2 = Much improved; 3 = Minimally improved; 4 = No change; 5 = Minimally worse; 6 = Much worse; 7 = Very much worse; 9=NA cgi_i
Query maq Integer Recommended 0 = N/A, no prescribed meds;1 = Never missed;2 = Rarely;3 = Sometimes;4 = Less than half the time;5 = About half the time;6 = Somewhat more than half the time;7 = Very often;8 = Nearly all the time;9 = All the time
Query stmed_1 Integer Recommended 0=No;1=Yes
Query stmd7 Integer Recommended
Query medication7_name String 100 Recommended Name seventh medication that the participant has taken 0 = No medication; 999= Legitimately skipped stnm7
Query stsd7 Integer Recommended Prescribed med start date 7
Query sted7 Integer Recommended
Query stds7 Float Recommended
Query phase Integer Recommended Phase 9 =follow up
Query response Integer Recommended 1 = NonResponse(<30% reduction in HRSD scores and HRSD >15 for 2 consecutive visits and met the DSM-IV criteria for MDD for 2 consecutive visits during weeks 6, 8, 10, and 12) 2 = Partial Response(not meeting criteria for NonResponse or Remission) 3 = Remission(>60% reduction in HRSD scores and HRSD <8 for 2 consecutive visits and does not meet DSM-IV criteria for MDD for 2 consecutive visits during weeks 6, 8, 10, and 12)If the patient meets the criteria for NonResponse the patient will advance to the Randomization Phase (Phase II). If the patient has had a partial response, continue at the maximum tolerated dose of the current medication up to week 12 then advance to the Randomization Phase. If the patient meets the criteria for Remission at week 12, continue on current medications in Phase II with patient visits scheduled only once every 4 weeks.
Query pharma_time Integer Recommended time time
baseline_a_002 String 100 Recommended Interview Start Time:
minietm String 10 Recommended Time interview ended
urt_q02 String 5 Recommended Time of last study med taken Q.2 Enter valid time using 24 hour clock in the following format: hh:mm; -888=NA
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.