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

Clinical Lab Tests Part II

clinlabtestsp2

01

Download Definition as
Download Submission Template as
Element NameData TypeSizeRequiredDescriptionValue RangeNotesAliases
subjectkeyGUIDRequiredThe NDAR Global Unique Identifier (GUID) for research subjectNDAR*guid
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 fielddate_rna_collected, intvdate, v1_lab_date, visit_date_lith_levels
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.intvage
sexString20RequiredSex of the subjectM;FM = Male; F = Femalegender
v1_lab_hepbscreenIntegerRecommendedLab results Hepatitis B screen0 :: 10 = negative; 1 = positive
v1_lab_hepcscreenIntegerRecommendedLab results Hepatitis C screen0 :: 10 = negative; 1 = positive
maf_end_dateDateRecommendeddate of last dose takenavl002
ldosetmString10RecommendedTime of last doseavl003
visitString50RecommendedVisit name
positive_drugs1IntegerRecommendedPositive for Cotinine0 :: 10 = No; 1 = Yescot002
cot02aFloatRecommendedCotinine level (ng/mL)-9 = Unknown
hbsagString25Recommendedhepatitis B surface antigen test results HBsAghep003
strf_03IntegerRecommendedChecks lab test Hepatitis LFT0;10=No; 1=Yeshep001
hep004IntegerRecommendedHCV test result
1;2;-9
1 = Positive; 2 = Negative; -9 = Equivocal
cmp_screeningIntegerRecommendedCMP collected?1;21= Yes; 2= No
egfraa_screeningIntegerRecommendedeGFR-African American (Baseline)1;21= Normal; 2= Abnormal
egfr_all_races_screeningIntegerRecommendedeGFR-All Other Races (Baseline)1;21= Normal; 2= Abnormal
hcg_screeningIntegerRecommendedHCG Quantitative Collected?1::31= Yes; 2= No; 3= N/A, subject is male
ekg_comments_screeningString200RecommendedEKG comments
ethanol_screeningString200RecommendedEthanol Value
oxycodonIntegerRecommendedOxycodone0;1;2;3;40=No; 1=Yes;2=Unclear or Equivocal; 3=Results not valid; 4=Not assessedoxycodone_screening
ua_chem_strip_screeningIntegerRecommendedUA Chem Strip1;21= Yes; 2= No
ua2String25RecommendedUrine clarity
ua15String25RecommendedEpithelial Cells
ua16String25RecommendedUrine Mic Comment
cbc_scan_day_labsIntegerRecommendedCBC Collected?1;21= Yes; 2= Nocbc_screening
cmpscan_day_labsIntegerRecommendedCMP collected?1;21= Yes; 2= No
egfraa_scan_day_labsIntegerRecommendedeGFR-African American1;21= Normal; 2= Abnormal
egfr_all_races_scan_day_labsIntegerRecommendedeGFR-All Other Races1;21= Normal; 2= Abnormal
rnasampleIntegerRecommendedWas RNA sample collected?1;21= Yes; 2= No
reason_rna_not_collectedString50RecommendedReason for not collecting RNA
rnasampletimeString10RecommendedIf yes, what time was RNA sample collected?
rnasamplecommentsString200RecommendedRNA Comments:
lithium_level_collectedIntegerRecommendedWas lithium sample collected?
1;2
1= Yes; 2= No
mr_licurdoseIntegerRecommendedlithium current total doselithiumdose
lithium_not_collected_reasonString200RecommendedIf Lithium not collected, explain why:
last_lithium_doseFloatRecommendedHow long ago was last lithium dose? (hours)
lithiumlvls_commentsString255RecommendedLithium Comments
tnfaFloatRecommendedTumor necrosis factor alpha level pg/mL
telomereFloatRecommendedTelomere length (ng)
isoprostanesFloatRecommendedIsoprostanes: Test Resultpicomole/mL
uuro_00_reString20RecommendedUrobilinogen Result
uuro_00_abIntegerRecommendedUrobilinogen Abnormal0::20=No;1=Yes, not clinically significant; 2=Yes, clinically significant
uuro_00_exIntegerRecommendedUrobilinogen Excludes0;10 = No; 1 = Yes
uuro_00_coString200RecommendedUrobilinogen Comments
ggt_01_reFloatRecommendedGamma-Glutamyl Transferase (GGT) (U/L, IUL)0::100; -9-9 = Missing
ggt_01_abIntegerRecommendedGamma-Glutamyl Transferase (GGT) (U/L, IUL): Abnormal?0::2; -91=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
ggt_01_exIntegerRecommendedGamma-Glutamyl Transferase (GGT) (U/L, IUL): Excludes?0;10 = No; 1 = Yes
ggt_01_coString200RecommendedGamma-Glutamyl Transferase (GGT) (U/L, IUL): Comments
alb_05_exIntegerRecommendedAlbumin (g/dl): Excludes?0;10 = No; 1 = Yes
alb_05_coString200RecommendedAlbumin (g/dl): Comments
tro_16_reFloatRecommendedTroponin (ng/ml)0::2; -9-9 = Missing
tro_16_abIntegerRecommendedTroponin (ng/ml): Abnormal?0::2; -91=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
tro_16_exIntegerRecommendedTroponin (ng/ml): Excludes?0;10 = No; 1 = Yes
tro_16_coString200RecommendedTroponin (ng/ml): Comments
plt_15_abIntegerRecommendedPlatelet Count (k/mm3): Abnormal?0::2; -91=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
plt_15_coString200RecommendedPlatelet Count (k/mm3): Comments
aptt_17_reFloatRecommendedAPTT (sec)0::120; -9-9 = Missing
aptt_17_abIntegerRecommendedAPTT (sec): Abnormal?0::2; -91=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
aptt_17_exIntegerRecommendedAPTT (sec): Excludes?0;10 = No; 1 = Yes
aptt_17_coString200RecommendedAPTT (sec): Comments
pt_18_reFloatRecommendedProthrombin time/International normalized ratio (PT/INR) (units)0::30; -9-9 = Missing
pt_18_abIntegerRecommendedProthrombin time/International normalized ratio (PT/INR) (units): Abnormal?0::2; -91=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
pt_18_exIntegerRecommendedProthrombin time/International normalized ratio (PT/INR) (units): Excludes?0;10 = No; 1 = Yes
pt_18_coString200RecommendedProthrombin time/International normalized ratio (PT/INR) (units): Comments
cd4_19_reIntegerRecommendedCD4 Count (cells/mm3)0::2100; -9-9 = Missing
cd4_19_abIntegerRecommendedCD4 Count (cells/mm3): Abnormal?0::2; -91=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
cd4_19_exIntegerRecommendedCD4 Count (cells/mm3): Excludes?0;10 = No; 1 = Yes
cd4_19_coString200RecommendedCD4 Count (cells/mm3): Comments
ua10String50RecommendedUrobilinogen status
absolute_nrbc_screeningString15RecommendedAbsolute nRBC (range)nrbc_scan_day
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: clinlabtestsp201 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.