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

Blood Sample Collection

939 Shared Subjects

N/A
Clinical Assessments
Summary
09/25/2015
bsc01
06/11/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, nimhid
src_subject_id String 20 Required Subject ID how it's defined in lab/project hcpa_id, ptid, subject, subject_id
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field bldcldt, intvdate, testdate
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. age, intvage
sex String 20 Required Sex of the subject M;F; O; NR M = Male; F = Female; O=Other; NR = Not reported gender
Query site String 101 Recommended Site Study Site siteid
Query study String 100 Recommended Study studyid
Query daysrz Integer Recommended days since randomization datecollect, studyday
Query completed Integer Recommended Checks if completed 0::3 0=No; 1=Yes; 2=Yes, lost; 3=Unverified bldclst, formcomp
Query sitedatasource_1 Integer Recommended Source of Data: Site 0;1; -888; -999 0=False; 1=True; -888=Not Applicable; -999=Missing; infosrcr
Query sitedatasource_phone Integer Recommended Source of Data: Telephone 0;1; -888; -999 0=False; 1=True; -888=Not Applicable; -999=Missing; infosrct
Query sitedatasource_physician Integer Recommended Source of Data: Physician 0;1; -888; -999 0=False; 1=True; -888=Not Applicable; -999=Missing; infosrcp
Query visit String 60 Recommended Visit name interval, visit_name, visitnum
version_form String 121 Recommended Form used/assessment name bscpg, form_name
Query bsctot Integer Recommended Total number of forms 1::99
Query ldosedy Integer Recommended Day of last dose Number of days from study baseline to date of last dose datelast
ldosetm String 10 Recommended Time of last dose lasttime
Query bsc_q01 Integer Recommended Any blood drawn
1;2
1= Yes, 2=No; blood, pom001, pom002
Query drawdays Integer Recommended blood draw days since consent bsc_q02, drawdate
drawtime String 20 Recommended time of blood draw bsc_q03, pom001a, pom002a, timecollect
Query bsc_q04 Integer Recommended Consume 70-gm carbohydrates 1;2 1= Yes, 2=No;
lmealtm String 10 Recommended Time of last meal bld_core_snacktime, bsc_q05, mealtime
Query lmealdy Integer Recommended Day of last meal Number of days from study baseline to date of last meal
Query bsc_q06a Float Recommended First food grams 0::99
Query bsc_q06b Float Recommended Second food grams 0::99
Query bsc_q06c Float Recommended Third food grams 0::99
Query mefa3 Integer Recommended Is the patient taking Risperidone? (Y/N) (If the patient is taking more than one anti-psychotic, the patient is ineligible.) 0;1;999 0=No; 1=Yes; 999=Legitimately skipped bsc_q07
Query adl_q03 Integer Recommended Date of last study med taken in days from the randomization date (ADL_Q03 = Date of last dose of study medication - randomization date) -888=NA bsc_q08
Query sma005 String 20 Recommended Time of last dose of study medication (hh:mm, 24-hour clock) bsc_q09
Query bsc_q10a Integer Recommended Blood collected for Risperidone 1;2 1= Yes, 2=No;
Query bsc_q10b Integer Recommended Blood collected for prolactin 1;2 1= Yes, 2=No;
Query bsc_q10c Integer Recommended Blood collected for glucose 1;2 1= Yes, 2=No;
Query bsc_q10d Integer Recommended Blood collected for hgbA1c 1;2 1= Yes, 2=No;
Query bsc_q10e Integer Recommended Blood collected for triglycerides 1;2 1= Yes, 2=No;
Query bsc_q10f Integer Recommended Blood collected for total cholesterol 1;2 1= Yes, 2=No;
Query bsc_q10g Integer Recommended Blood collected for LDL 1;2 1= Yes, 2=No;
Query bsc_q10h Integer Recommended Blood collected for HDL 1;2 1= Yes, 2=No;
Query leptin Float Recommended Leptin blood test result leptin_unit" specifies unit
leptin_unit String 10 Recommended Unit for the leptin blood test result
Query ci_enrolled Integer Recommended Participant enrolled 0;1 0=No; 1=Yes
Query ptcon Integer Recommended Patient consented 0;1 0=No; 1=Yes bldcnsnt
comments String 4,000 Recommended Comments about assessment blood_notes, ldl_notes, notes, salisaliva_notes
Query med2b Integer Recommended Visit Day Number of days from study baseline to date of visit
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 hypforin Float Recommended Plasma assay: hyperforin
Query sertra Float Recommended Plasma assay: sertraline
Query dmsertra Float Recommended Plasma assay: N-desmethyl-sertraline
Query tx_num Integer Recommended Medication Code Number 1::3 1 = Sertraline; 2 = Hypericum; 3 = Placebo
Query bsc_q10hh Integer Recommended Blood collected for Interleukin-6 1; 2 1= Yes, 2=No
Query bsc_q10i Integer Recommended Blood collected for LH 1; 2 1= Yes, 2=No
Query bsc_q10j Integer Recommended Blood collected for FSH 1; 2 1= Yes, 2=No
Query bsc_q10k Integer Recommended Blood collected for TSH 1; 2 1= Yes, 2=No
Query bsc_q10l Integer Recommended Blood collected for ACTH 1; 2 1= Yes, 2=No
Query bsc_q10m Integer Recommended Blood collected for Progesterone 1; 2 1= Yes, 2=No
Query bsc_q10n Integer Recommended Blood collected for Estradiol 1; 2 1= Yes, 2=No
Query bsc_q10o Integer Recommended Blood collected for Testosterone 1; 2 1= Yes, 2=No
Query bsc_q10p Integer Recommended Blood collected for SHBG 1; 2 1= Yes, 2=No
Query bsc_q10q Integer Recommended Blood collected for DHEA-S 1; 2 1= Yes, 2=No
Query interleukin6 Float Recommended Interleukin-6 blood test result interleukin-6
interleukin6_unit String 10 Recommended Unit for the Interleukin-6 blood test result interleukin-6_unit
Query lh Float Recommended LH blood test result
lh_unit String 10 Recommended Unit for the LH blood test result
Query fsh Float Recommended FSH blood test result
fsh_unit String 10 Recommended Unit for the FSH blood test result
Query tsh Float Recommended Thyroid-stimulating Hormone (TSH) 0::99.99;-7;-8;-9;999 In microIU/mL. -7 = Don't know; -8 = Refused to answer; -9 = Does not apply
tsh_unit String 10 Recommended Unit for the TSH blood test result
Query acth Float Recommended ACTH blood test result
acth_unit String 10 Recommended Unit for the ACTH blood test result
Query fprgrs Float Recommended Hormonal Measures Female Progesterone Results progesterone
progesterone_unit String 10 Recommended Unit for the Progesterone blood test result
Query festrs Float Recommended Hormonal Measures Female Estradiol Results estradiol
estradiol_unit String 10 Recommended Unit for the Estradiol blood test result
Query rsptest_no Float Recommended Blood value - Testosterone (ng/dL) testosterone
testosterone_unit String 10 Recommended Unit for the Testosterone blood test result
Query shbg Float Recommended SHBG blood test result
shbg_unit String 10 Recommended Unit for the SHBG blood test result
Query dheas_mean_pgml Float Recommended dheas Mean (pg/mL) dhea-s
dhea_s_unit String 10 Recommended Unit for the DHEA-S blood test result dhea-s_unit
ls_alt Integer Recommended 16. ALT(SGPT)(U/L) -9=Unknown; -1=Normal; -2= <15 alt_sgpt
biospc_8 Integer Recommended Number of Purple tubes collected bld_core_ppl
fasting Integer Recommended fasting blood draw y/n 0;1;-7 0=No; 1=Yes; -7=Refused bld_core_fast
rsptc_no Float Recommended Blood value - Total Cholesterol (mg/dL) -9=Unknown cholesterol
rsptrig_no Float Recommended Blood value - Triglycerides (mg/dL) -9=Unknown triglyceride
ls_ureanitrogen Float Recommended 10. Urea Nitrogen(mg/dL) 0 :: 70; -9 -9=unknown ureanitrogen
ls_totprotein Float Recommended 11. Total Protein(g/dL) 0 :: 20.0; -9 -9=Unknown totalprotein
ls_co2 Float Recommended 7. CO2 Content(mmol/L) 0 :: 50;-9 -9=Unknown co2content
ls_calcium Float Recommended 17. Calcium(mg/dL) 0 :: 100.0; -9 -9=Unknown calcium
ls_bilirubin Float Recommended 13. Bilirubin, Total(mg/dL) 0 :: 9.9; -9 -9=Unknown totalbilirubin
ls_albumin Float Recommended 12. Albumin(g/dL) 0 :: 20.0;-9 -9=Unknown albumin
laba8 Float Recommended Hscrp hscrp
laba5 Float Recommended Hdl Cholesterol (Mg/Dl) -9=Unknown hdl
bp1_alk Float Recommended Liver ALK Phos -9=Unknown alkphos_total
a1crs Float Recommended HbA1c Results hba1c
biospc2_purple_tubes Float Recommended num of purple tubes collected sample 2 bld_rucdr_ppl
bld_core Integer Recommended CORE Blood Collected? 0;1 1 = Yes ; 0 = No
bld_core_grn Integer Recommended CORE: Number of Tubes Collected: Green Tubes
bld_core_snack Integer Recommended Fasting: Time of last meal/snack 0;1 1 = Same day ; 0 = Prior day
bld_core_spin Integer Recommended Spin at 1000 - 1300G for 10 mins 0;1 1 = Yes ; 0 = No
insomm String 250 Recommended Insulin: Comments insulin
bld_core_d2ph Integer Recommended All Tubes Time from Draw to Processing: Hour(s):
bld_core_d2pm Integer Recommended All Tubes Time from Draw to Processing: Minute(s):
bld_core_p2fh Integer Recommended All Tubes Time from Processing to Freezing: Hour(s):
bld_core_p2fm Integer Recommended All Tubes Time from Processing to Freezing: Minute(s):
bld_rucdr Integer Recommended RUCDR Blood Collected?: 0;1 1 = Yes ; 0 = No
friedewald_ldl Float Recommended Friedewald LDL Cholesterol: 99999 for QNS(quantity not sufficient); Units=mg/dL
laba6 Integer Recommended Ldl Cholesterol (Mg/Dl) -9=Unknown; -1=Normal ldl
biospc_6 Integer Recommended Number of Yellow tubes collected bld_rucdr_grn, bld_rucdr_ylw
vitdlev Integer Recommended 25- vitamin D level (ng/mL) vitamind
ed1_saliva Integer Recommended SALIVA SAMPLE COLLECTED 0; 1; -5; -7; -8 0=No; 1=Yes -8=DON'T KNOW; -7=REFUSED; -5=Presented, not answered bld_rucdr_saliva
ed1_blood Integer Recommended BLOOD SAMPLES COLLECTED 0; 1; -5; -7; -8 0=No; 1=Yes -8=DON'T KNOW; -7=REFUSED; -5=Presented, not answered bld_draw
ls_ast Integer Recommended 15. AST(SGOT)(U/L) -9=Unknown; -1=Normal ast_sgot
hair3 Integer Recommended How many times do you wash your hair per week?
hair4 Integer Recommended Do you dye/bleach your hair? 0;1 1 = Yes ; 0 = No
hair4_1 String 100 Recommended If you dye/bleach your hair, When did you dye/bleach your hair?
hair4_2 String 100 Recommended Hair dye name:
hair4_3 String 100 Recommended Hair dye colour:
hair4_4 String 100 Recommended Degree of lightening:
hair5 Integer Recommended Do you perm your hair? 0;1 1 = Yes ; 0 = No
hair5y String 100 Recommended If you perm your hair, when did you perm your hair?
hair6 Integer Recommended Do you do any other hair treatments (straightening, hair growth stimulators, hair-gel, etc)? 0;1 1 = Yes ; 0 = No
hair6y String 200 Recommended If you have any other hair treatments, Specify:
hair7 Integer Recommended Are you aware that you are sweating relatively frequently/heavily on the head? 0::2 1 = Yes ; 0 = No ; 2 = Perhaps
rucdrsaliva Integer Recommended RUCDR Saliva: 0;1 1 = Yes ; 0 = No
salisaliva_1st String 10 Recommended Day of First Salimetric Scan:
salisaliva_collecttime1 Integer Recommended Did you eat before you collected your saliva sample? 0;1 1 = Yes ; 0 = No
salisaliva_collecttime1_1 String 50 Recommended If you ate before collecting your saliva sample, how long before collecting saliva did you eat?
salisaliva_collecttime2 Integer Recommended Did you brush your teeth before you collected your saliva sample? 0;1 1 = Yes ; 0 = No
salisaliva_collecttime2_1 String 50 Recommended If you brushed your teeth before collecting your saliva sample, how long before collecting saliva did you brush your teeth?
salisaliva_frozen Integer Recommended Saliva Sample Arrived Frozen: 0;1 1 = Yes ; 0 = No
salisaliva_mestrual Integer Recommended Saliva sample: Days after menstrual start 999999 = N/A
salisaliva_timetofrz Integer Recommended Saliva sample: Minutes from arrival to deep freezer:
p_col_nat_o String 65 Recommended Describe other natural hair color hair1
saliva_collection1_time String 10 Recommended Saliva Measures: Time of the first saliva collection (hour:minute) salisaliva_collecttime
urine_saliva_data_entry_status String 20 Recommended Urine and Saliva Measures: Urine and Saliva Measures: The Data entry completion status of this instrument (whether the instrument is completed or not) Incomplete;Complete salisaliva_yn
bld_core_des_ String 100 Recommended Specify Tubes Collected: CORE
bld_rucdr_des String 100 Recommended Specify Tubes Collected: RUCDR
hair_collect Integer Recommended Hair Sample Collected? 0;1 1 = Yes ; 0 = No
hair2 Integer Recommended Do you have curls? 0;1 1 = Yes ; 0 = No
chloride Integer Recommended Chloride 0 :: 999;-7;-8;-9 In mmol/L. -7 = Don't know; -8 = Refused to answer; -9 = Does not apply
creatinine Float Recommended Creatinine 0::9.9;-7;-8;-9;999 In mg/dL. -7 = Don't know; -8 = Refused to answer; -9 = Does not apply
glucose Integer Recommended Glucose 0 :: 999;-7;-8;-9 In mg/dL. -7 = Don't know; -8 = Refused to answer; -9 = Does not apply
potassium Float Recommended Potassium 0::9.9;-7;-8;-9;999 In mmol/L. -7 = Don't know; -8 = Refused to answer; -9 = Does not apply
sodium Integer Recommended Sodium 0 :: 999;-7;-8;-9 In mmol/L. -7 = Don't know; -8 = Refused to answer; -9 = Does not apply
hnk Float Recommended Hydroxynorketamine blood level 0 :: 999;-7;-8;-9 In ng/ml. -7 = Don't know; -8 = Refused to answer; -9 = Does not apply
bdnf Float Recommended Brain-derived neurotrophic factor 0 :: 999;-7;-8;-9 In ng/ml. -7 = Don't know; -8 = Refused to answer; -9 = Does not apply
hnk_notes String 200 Recommended Hydroxynorketamine notes (e.g., time since drug)
bdnf_notes String 200 Recommended Brain-derived neurotrophic factor notes (e.g., time since drug)
comqother String 255 Recommended Respondent - Other (text)
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.