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

36 Shared Subjects

N/A
Clinical Assessments
Phys Exam
04/17/2018
clinlabtestsp201
11/04/2019
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* guid
src_subject_id String 20 Required Subject ID how it's defined in lab/project subject_id
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field date_rna_collected, intvdate, v1_lab_date, visit_date_lith_levels
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. intvage
sex String 20 Required Sex of the subject M;F M = Male; F = Female gender
Query v1_lab_hepbscreen Integer Recommended Lab results Hepatitis B screen 0 :: 1 0 = negative; 1 = positive
Query v1_lab_hepcscreen Integer Recommended Lab results Hepatitis C screen 0 :: 1 0 = negative; 1 = positive
maf_end_date Date Recommended date of last dose taken avl002
ldosetm String 10 Recommended Time of last dose avl003
visit String 50 Recommended Visit name
Query positive_drugs1 Integer Recommended Positive for Cotinine 0 :: 1 0 = No; 1 = Yes cot002
Query cot02a Float Recommended Cotinine level (ng/mL) -9 = Unknown
hbsag String 25 Recommended hepatitis B surface antigen test results HBsAg hep003
Query strf_03 Integer Recommended Checks lab test Hepatitis LFT 0;1 0=No; 1=Yes hep001
Query hep004 Integer Recommended HCV test result
1;2;-9
1 = Positive; 2 = Negative; -9 = Equivocal
Query cmp_screening Integer Recommended CMP collected? 1;2 1= Yes; 2= No
Query egfraa_screening Integer Recommended eGFR-African American (Baseline) 1;2 1= Normal; 2= Abnormal
Query egfr_all_races_screening Integer Recommended eGFR-All Other Races (Baseline) 1;2 1= Normal; 2= Abnormal
Query hcg_screening Integer Recommended HCG Quantitative Collected? 1::3 1= Yes; 2= No; 3= N/A, subject is male
ekg_comments_screening String 200 Recommended EKG comments
ethanol_screening String 200 Recommended Ethanol Value
Query oxycodon Integer Recommended Oxycodone 0;1;2;3;4 0=No; 1=Yes;2=Unclear or Equivocal; 3=Results not valid; 4=Not assessed oxycodone_screening
Query ua_chem_strip_screening Integer Recommended UA Chem Strip 1;2 1= Yes; 2= No
ua2 String 25 Recommended Urine clarity
ua15 String 25 Recommended Epithelial Cells
ua16 String 25 Recommended Urine Mic Comment
Query cbc_scan_day_labs Integer Recommended CBC Collected? 1;2 1= Yes; 2= No cbc_screening
Query cmpscan_day_labs Integer Recommended CMP collected? 1;2 1= Yes; 2= No
Query egfraa_scan_day_labs Integer Recommended eGFR-African American 1;2 1= Normal; 2= Abnormal
Query egfr_all_races_scan_day_labs Integer Recommended eGFR-All Other Races 1;2 1= Normal; 2= Abnormal
Query rnasample Integer Recommended Was RNA sample collected? 1;2 1= Yes; 2= No
reason_rna_not_collected String 50 Recommended Reason for not collecting RNA
rnasampletime String 10 Recommended If yes, what time was RNA sample collected?
rnasamplecomments String 200 Recommended RNA Comments:
Query lithium_level_collected Integer Recommended Was lithium sample collected?
1;2
1= Yes; 2= No
Query mr_licurdose Integer Recommended lithium current total dose lithiumdose
lithium_not_collected_reason String 200 Recommended If Lithium not collected, explain why:
Query last_lithium_dose Float Recommended How long ago was last lithium dose? (hours)
lithiumlvls_comments String 255 Recommended Lithium Comments
Query tnfa Float Recommended Tumor necrosis factor alpha level pg/mL
Query telomere Float Recommended Telomere length (ng)
Query isoprostanes Float Recommended Isoprostanes: Test Result picomole/mL
uuro_00_re String 20 Recommended Urobilinogen Result
Query uuro_00_ab Integer Recommended Urobilinogen Abnormal 0::2 0=No;1=Yes, not clinically significant; 2=Yes, clinically significant
Query uuro_00_ex Integer Recommended Urobilinogen Excludes 0;1 0 = No; 1 = Yes
uuro_00_co String 200 Recommended Urobilinogen Comments
Query ggt_01_re Float Recommended Gamma-Glutamyl Transferase (GGT) (U/L, IUL) 0::100; -9 -9 = Missing
Query ggt_01_ab Integer Recommended Gamma-Glutamyl Transferase (GGT) (U/L, IUL): Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
Query ggt_01_ex Integer Recommended Gamma-Glutamyl Transferase (GGT) (U/L, IUL): Excludes? 0;1 0 = No; 1 = Yes
ggt_01_co String 200 Recommended Gamma-Glutamyl Transferase (GGT) (U/L, IUL): Comments
Query alb_05_ex Integer Recommended Albumin (g/dl): Excludes? 0;1 0 = No; 1 = Yes
alb_05_co String 200 Recommended Albumin (g/dl): Comments
Query tro_16_re Float Recommended Troponin (ng/ml) 0::2; -9 -9 = Missing
Query tro_16_ab Integer Recommended Troponin (ng/ml): Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
Query tro_16_ex Integer Recommended Troponin (ng/ml): Excludes? 0;1 0 = No; 1 = Yes
tro_16_co String 200 Recommended Troponin (ng/ml): Comments
Query plt_15_ab Integer Recommended Platelet Count (k/mm3): Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
plt_15_co String 200 Recommended Platelet Count (k/mm3): Comments
Query aptt_17_re Float Recommended APTT (sec) 0::120; -9 -9 = Missing
Query aptt_17_ab Integer Recommended APTT (sec): Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
Query aptt_17_ex Integer Recommended APTT (sec): Excludes? 0;1 0 = No; 1 = Yes
aptt_17_co String 200 Recommended APTT (sec): Comments
Query pt_18_re Float Recommended Prothrombin time/International normalized ratio (PT/INR) (units) 0::30; -9 -9 = Missing
Query pt_18_ab Integer Recommended Prothrombin time/International normalized ratio (PT/INR) (units): Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
Query pt_18_ex Integer Recommended Prothrombin time/International normalized ratio (PT/INR) (units): Excludes? 0;1 0 = No; 1 = Yes
pt_18_co String 200 Recommended Prothrombin time/International normalized ratio (PT/INR) (units): Comments
Query cd4_19_re Integer Recommended CD4 Count (cells/mm3) 0::2100; -9 -9 = Missing
Query cd4_19_ab Integer Recommended CD4 Count (cells/mm3): Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
Query cd4_19_ex Integer Recommended CD4 Count (cells/mm3): Excludes? 0;1 0 = No; 1 = Yes
cd4_19_co String 200 Recommended CD4 Count (cells/mm3): Comments
ua10 String 50 Recommended Urobilinogen status
absolute_nrbc_screening String 15 Recommended Absolute nRBC (range) nrbc_scan_day
th1_cytokines String 175 Recommended Type 1 helper T cells cytokines, concentrations, and units
th2_cytokines String 175 Recommended Type 2 helper T cells cytokines, concentrations, and units
th17_cytokines String 175 Recommended Type 17 helper T cells cytokines, concentrations, and units
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.