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

Clinical Lab Tests Part II

377 Shared Subjects

N/A
Clinical Assessments
Phys Exam
04/17/2018
clinlabtestsp201
03/23/2020
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; O; NR M = Male; F = Female; O=Other; NR = Not reported 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
Query visit String 60 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 100 Recommended Epithelial Cells
ua16 String 500 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 urobilinogen_ab
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
progesterone_time1 Float Recommended progesterone levels (pg/ml) at time point 1 0 :: 9999.99
progesterone_time2 Float Recommended progesterone levels (pg/ml) at time point 2 0 :: 9999.99
progesterone_time3 Float Recommended progesterone levels (pg/ml) at time point 3 0 :: 9999.99
progesterone_time4 Float Recommended progesterone levels (pg/ml) at time point 4 0 :: 9999.99
agratio_val String 50 Recommended A/G Ratio: Value
agratio_ab Integer Recommended A/G Ratio: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
ioncalc_val String 50 Recommended Ionized Calcium, Calculated: Value
ioncalc_ab Integer Recommended Ionized Calcium, Calculated: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
egfr_ab Integer Recommended eGFR: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
imgran_val String 50 Recommended Immature Gran #: Value
imgran_ab Integer Recommended Immature Gran #: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
igpercent_val String 50 Recommended Immature Gran %: Value
uepicells_val String 50 Recommended Epithelial Cells: Value
uepicells_ab Integer Recommended Epithelial Cells: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
ubacteria_val String 50 Recommended Bacteria: Value
ubacteria_ab Integer Recommended Bacteria: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
umucus_val String 50 Recommended Mucus: Value
umucus_ab Integer Recommended Mucus: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
uamur_val String 50 Recommended Amorphous Urates: Value
uamur_ab Integer Recommended Amorphous Urates: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
aniongap_val String 50 Recommended Anion Gap: Value
aniongap_ab Integer Recommended Anion Gap: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
buncreatrat_val String 50 Recommended Bun/Creatinine Ratio: Value
buncreatrat_ab Integer Recommended BUN/Creatinine Ratio: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
osmolality_val String 50 Recommended Osmolality Calc: Value
osmolality_ab Integer Recommended Osmolality Calc: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
globulin_ab Integer Recommended Globulin: Abnormal? 0::2; -9 1=Yes, not clinically significant; 2=Yes, clinically significant; 0=No; -9=Unknown
urine_blood String 20 Recommended Specify amount of blood found in urine
bilirubin_ab Integer Recommended Urine: Bilirubin Abnormal? 0::2;-9 0=No;1=Yes, not clinically significant; 2=Yes, clinically significant; -9=Unknown
resp_source Integer Recommended Respondent Source 1::6 1= subject; 2= parent; 3= clinician; 4= teacher; 5= trainer; 6= fidelity reviewer source
vitamind_orig_result Float Recommended Vitamin D at Original Screening
vitamind_date Date Recommended Date of Vitamin D Test
vitamind_result Float Recommended Vitamin D Test Result
vitamind_normal Integer Recommended Vitamin D Test Normal 0;1 0= No; 1= Yes
vitamind_dose Integer Recommended Dose of Vitamin D recommended to increase level
vitamind_meal Integer Recommended Was dose taken with a fatty meal? 0;1 0= No; 1= Yes
vitamind_cs Integer Recommended Vitamin D Treatment Required? 0;1 0= No; 1= Yes
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.