NDA Help Center

Login Dialog

Frequently Asked Questions

Glossary

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

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

Lab Results

2,042 Shared Subjects

Lab Results
Clinical Assessments
Phys Exam
05/07/2014
lab01
01/05/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 CATIEID
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field visit_date
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 M = Male; F = Female gender
Query visitid Integer Recommended MetaTrial Visit ID System variable: unique code for each type of visit -use to merge files
Query visit String 50 Recommended Visit name visitnum
Query truncvis Integer Recommended Truncated Visit Number Created variable: provides a numeric visit number for all visits, including unscheduled and end of phase
Query phase_ct String 20 Recommended Current Phase. Phase patient was in at the time of the assessment Phase 4 refers to the follow-up phase. Pre-Rand; Phase 1/1A; Phase 2; Phase 3; Phase 4; Phase 1B; Open-Choice Phase; Screening; Phase 1 phase
Query colldy Integer Recommended Collection Day Number of days from study baseline to date of sample collection COLLECDY
testname String 50 Recommended Laboratory Test Name form
Query repeat Integer Recommended Flag for Repeat of Lab Test 0;1 0=No;1=Yes, missing otherwise
Query testgrp String 50 Recommended Laboratory Test Group
testcode String 10 Recommended Laboratory Test Code
collectm String 20 Recommended Collection Time
Query rstatus String 1 Recommended Record Status X=result for this lab test not available; 0 or missing = result for this lab test is availalbe form_status
Query resultyp String 1 Recommended Type Of Result N;T N=numeric, T=text
result String 100 Recommended Reported Result value
Query units String 50 Recommended Reported Unit unit
hinorm String 50 Recommended Normal Range Reported High Value referang, sitref
lonorm String 50 Recommended Normal Range Reported Low Value
cvresult String 50 Recommended Result in Conventional Units
Query resn Float Recommended Numeric Result Takes the value of CVRESULT. If CVRESULT has a > or < sign, then the sign is removed before creating RESN.
Query cvunits String 10 Recommended Conventional Units
Query cvhinorm Float Recommended Normal Range Conventional High Value
Query cvlonorm Float Recommended Normal Range Conventional Low Value -999=negative; 999=normal
Query alertflg String 2 Recommended Alert Flag H; TH; PH; L;PL; TL H=High;TH=High, telephone the site;PH=panic high; L=Low; TL=Low, telephone the site; PL=panic low
Query base1f Integer Recommended Phase 1/1A Baseline Flag 1=Yes for all records meeting this criteria
Query last1f Integer Recommended Phase 1/1A Last Value Flag 1=Yes for all records meeting this criteria
Query baseval1 Float Recommended Phase 1/1A Baseline Value value for each particular lab test at phase-specific baseline; retained across all records for that lab test.
Query chgval1 Float Recommended Phase 1/1A Change from Baseline Phase-specific change (within each phase, change is calculated from that phase's baseline measurement)
Query base1bf Integer Recommended Phase 1B Baseline Flag 1=Yes for all records meeting this criteria
Query last1bf Integer Recommended Phase 1B Last Value Flag 1=Yes for all records meeting this criteria
Query basval1b Float Recommended Phase 1B Baseline Value value for each particular lab test at phase-specific baseline; retained across all records for that lab test.
Query chgval1b Float Recommended Phase 1B Change from Baseline Phase-specific change (within each phase, change is calculated from that phase's baseline measurement)
Query base2f Integer Recommended Phase 2 Baseline Flag 1=Yes for all records meeting this criteria
Query last2f Integer Recommended Phase 2 Last Value Flag 1=Yes for all records meeting this criteria
Query baseval2 Float Recommended Phase 2 Baseline Value value for each particular lab test at phase-specific baseline; retained across all records for that lab test.
Query chgval2 Float Recommended Phase 2 Change from Baseline Phase-specific change (within each phase, change is calculated from that phase's baseline measurement)
Query base3f Integer Recommended Phase 3 Baseline Flag 1=Yes for all records meeting this criteria
Query last3f Integer Recommended Phase 3 Last Value Flag 1=Yes for all records meeting this criteria
Query baseval3 Float Recommended Phase 3 Baseline Value value for each particular lab test at phase-specific baseline; retained across all records for that lab test.
Query chgval3 Float Recommended Phase 3 Change from Baseline Phase-specific change (within each phase, change is calculated from that phase's baseline measurement)
lmealtm String 10 Recommended Time of last meal
ldosetm String 10 Recommended Time of last dose
Query ldosedy Integer Recommended Day of last dose Number of days from study baseline to date of last dose
Query lmealdy Integer Recommended Day of last meal Number of days from study baseline to date of last meal
Query visday Integer Recommended Number of days from study baseline to date of visit
accessno String 25 Recommended Accession Number Uniquely identifies each blood draw
Query visnum Float Recommended Numeric Visit Number -1.5 = Pre-Screening; -1 = Screening; 0 = Baseline; ## = Visit ## (from 1 to 10); Whole numbers = standard monthly visits; #.001 - #.009 = Unscheduled; #.1 = End of Phase 1; #.2 = End of Phase 2; #.3 = End of Phase 3; #.4 = End of Open Choice Phase; #.5 = End of Study; #.6 = Genetic Analysis; 1000=all visits
Query chgval2s Float Recommended Phase 2 Change from Study Baseline Change from Phase 1 baseline to Phase 2
Query chgval3s Float Recommended Phase 3 Change from Study Baseline Change from Phase 1 baseline to Phase 3
Query baseocf Integer Recommended Phase OC Baseline Flag 1 1=Yes for all records meeting this criteria
Query basevloc Float Recommended Phase OC Baseline Value value for each particular lab test at phase-specific baseline; retained across all records for that lab test.
Query chgvaloc Float Recommended Phase OC Change from Baseline Phase-specific change (within each phase, change is calculated from that phase's baseline measurement)
Query chgvalos Float Recommended Phase OC Change from Study Baseline Change from Phase 1 baseline to Open Choice Phase
Query lastocf Integer Recommended Phase OC Last Value Flag 1 1=Yes for all records meeting this criteria
Query avnumcig Integer Recommended Average Number of Cigarettes
Query ls_result Integer Recommended Result 1;2;3 1=Normal;2=Abnormal-Not clinically significant;3=Abnormal-Clinically significant clinsignif
Query lineno Integer Recommended Line number (lines per participant) 0::150
Query iecsig Integer Recommended Investigator signature on form. 0;1 0=No; 1= Yes
site String 101 Recommended Site Study Site siteid
Query days_baseline Integer Recommended Days since baseline
comments_misc String 4,000 Recommended Miscellaneous comments on study, interview, methodology relevant to this form data
flwup1 String 250 Recommended Followup 1 fupplan
Query rangelevel Integer Recommended Range Level 1::3 1 = Within Range; 2 = High; 3 = Low
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.