Loading...

National Institute of Mental Health Data Archive (NDA) Sign In
National Institute of Mental Health Data Archive (NDA) Sign In
NDA

Success! An email is on its way!

Please check your email to complete the linking process. The link you receive is only valid for 30 minutes.

Check your spam or junk folder if you do not receive the email in the next few minutes.

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.
Create or Link an Existing NDA Account
NIMH Data Archive (NDA) Sign In or Create An Account
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
Data Access Terms - Decline Terms

Are you sure you want to cancel? This will decline terms and you will not be authorized for access.

Filter Cart
No filters selected
Description
Value Range
Notes
Data Structures with shared data
No filters have been selected
helpcenter.filter-cart

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).

When combining other filters with the GUID filter, please note the GUID filter should be added last. Otherwise, preselected data may be lost. For example, a predefined filter from Featured Datasets may select a subset of data available for a subject. When combined with a GUID filter for the same subject, the filter cart will contain all data available from that subject, data structure, and dataset; this may be more data than was selected in the predefined filter for that subject. Again, you should add the GUID Filter as the last filter to your cart. This ensures 'AND' logic between filters and will limit results to the subjects, data structures, and datasets already included in your filter cart.

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 filter 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

  • What is a Filter Cart?
    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.
  • What do I do after filters are added to the Filter Cart?
    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.
  • Are there limitations on the amount of data a user can download?

    NDA limits the rate at which individual users can transfer data out of Amazon Web Services (AWS) S3 Object storage to non-AWS internet addresses. All users have a download limit of 20 Terabytes. This limit applies to the volume of data an individual user can transfer within a 30-day window. Only downloads to non-AWS internet addresses will be counted against the limit.

  • How does Filter Cart Boolean logic work?

    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.

    When combining other filters with the GUID filter, please note the GUID filter should be added last. Otherwise, preselected data may be lost. For example, a predefined filter from Featured Datasets may select a subset of data available for a subject. When combined with a GUID filter for the same subject, the filter cart will contain all data available from that subject, data structure, and dataset; this may be more data than was selected in the predefined filter for that subject. Again, you should add the GUID Filter as the last filter to your cart. This ensures 'AND' logic between filters and will limit results to the subjects, data structures, and datasets already included in your filter cart.

Glossary

  • Workspace
    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.
  • Filter Cart
    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 adds data using an AND condition. The opportunity to further refine data to determine what will be downloaded or sent to a miNDAR is available on the Data Packaging Page, the next step after the Filter Cart. Subsequent access to data is restricted by User Permission or Privilege; however Filter Cart use is not.
Switch User

COINS Medical History

952 Shared Subjects

N/A
Clinical Assessments
Med History
05/27/2015
coinsmedhistory01

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 randid
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.
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY
sex String 20 Required Sex of subject at birth M;F; O; NR M = Male; F = Female; O=Other; NR = Not reported gender
Query midihist_001 Integer Recommended Allergies- Drugs
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_1
midihist_001a String 250 Recommended Allergies- Drugs Specified mh_1a
Query midihist_002 Integer Recommended Allergies- Other
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_2
midihist_002a String 250 Recommended Allergies- Other Specified mh_2a
Query midihist_003 Integer Recommended HEENT Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_3
midihist_003a String 250 Recommended HEENT Disorder explain or describe mh_3a
Query midihist_004 Integer Recommended Cardiac arrhythmia
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_4
midihist_004a String 250 Recommended Cardiac arrhythmia describe mh_4a
Query midihist_005a String 250 Recommended History of MI describe mh_5a
Query midihist_006 Integer Recommended Agina
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_6
midihist_006a String 250 Recommended Agina describe mh_6a
Query midihist_007 Integer Recommended Congestive heart failure
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_7
midihist_007a String 250 Recommended Congestive heart failure describe mh_7a
Query midihist_008 Integer Recommended Other cardiac
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_8
Query midihist_008a String 250 Recommended Other cardiac describe mh_8a
Query midihist_009 Integer Recommended History of stroke
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_9
Query midihist_009a String 250 Recommended History of stroke describe mh_9a
Query midihist_010 Integer Recommended Hypertension
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_10
midihist_010a String 250 Recommended Hypertension describe mh_10a
Query midihist_011 Integer Recommended Stent/CABG
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_11
Query midihist_011a String 250 Recommended Stent/CABG describe mh_11a
Query midihist_012 Integer Recommended Renal Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_12
Query midihist_012a String 250 Recommended Renal Disorder describe mh_12a
Query midihist_013 Integer Recommended Hepatic Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_13
Query midihist_013a String 250 Recommended Hepatic Disorder describe mh_13a
Query midihist_014 Integer Recommended Pulmonary Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_14
midihist_014a String 250 Recommended Pulmonary Disorder describe mh_14a
Query midihist_015 Integer Recommended Gastrointestinal Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_15
midihist_015a String 250 Recommended Gastrointestinal Disorder describe mh_15a
Query midihist_016 Integer Recommended Musculoskeletal Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_16
midihist_016a String 250 Recommended Musculoskeletal Disorder describe mh_16a
Query midihist_017 Integer Recommended Neurologic Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_17
midihist_017a String 250 Recommended Neurologic Disorder describe mh_17a
Query midihist_018 Integer Recommended Dermatologic Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_18
midihist_018a String 250 Recommended Dermatologic Disorder describe mh_18a
Query midihist_019 Integer Recommended Hyperlipidemia/hypertriglyceridemia
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_19
midihist_019a String 250 Recommended Hyperlipidemia/hypertriglyceridemia describe mh_19a
Query midihist_020 Integer Recommended Hemotologic Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_20
midihist_020a String 250 Recommended Hemotologic Disorder describe mh_20a
Query midihist_021 Integer Recommended Diabetes mellitus Type 1
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_21
Query midihist_021a String 250 Recommended Diabetes mellitus Type 1 describe mh_21a
Query midihist_022 Integer Recommended Diabetes mellitus Type 2
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data
Query midihist_022a String 250 Recommended Diabetes mellitus Type 2 describe
Query midihist_023 Integer Recommended Diabetes mellitus Gestational
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data
midihist_023a String 250 Recommended Diabetes mellitus Gestational describe
Query mhendoce Integer Recommended Endocrine Disorder
1::3; -9; 9
1=No history 2=Yes, excludes;3=Yes, does not exclude; -9 =unknown; 9=not evaluated mh_22, midihist_024
Query endocmt String 250 Recommended Endocrine/Diabetes comments mh_22a, midihist_024a
Query midihist_025 Integer Recommended Genitourinary Disorder
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_23
midihist_025a String 250 Recommended Genitourinary Disorder describe mh_23a
Query midihist_026 Integer Recommended Infectious Disease
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_24
midihist_026a String 250 Recommended Infectious Disease describe mh_24a
Query midihist_027 Integer Recommended Dyslexia
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data
Query midihist_027a String 250 Recommended Dyslexia describe
Query midihist_028 Integer Recommended ADD or ADHD (Attention Deficit Disorder or Attention Deficit Hyperactivity Disorder)
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data
Query midihist_028a String 250 Recommended ADD or ADHD (Attention Deficit Disorder or Attention Deficit Hyperactivity Disorder) describe
Query hypothy Integer Recommended hypothyroidism underactive thy
0;1;-7; 9; -999
0=No; 1=Yes; -7=Refused;9=Not evaluated; -999= Don't know/Missing Data midihist_029
Query midihist_029a String 250 Recommended Underactive thyroid (for instance, Hashimoto's thyroiditis) describe
Query hyperthy Integer Recommended hyperthyroidism overactive thy
0;1;-7; 9; -999
0=No; 1=Yes; -7=Refused; 9=Not evaluated; -999= Don't know/Missing Data midihist_030
Query midihist_030a String 250 Recommended Overactive thyroid (for instance, Grave's disease) describe
Query ms Integer Recommended Has she/he ever been to a doctor for any of these things…Multiple Sclerosis /Esclerosis múltiple
1;0;-7; 9; -999
0=No; 1=Yes;-7=Refused; 9=Not evaluated; -999= Don't know/Missing Data //Now I'd like to ask you about your child's use of health services during the past year and throughout his/her whole life. midihist_031
midihist_031a String 250 Recommended Multiple Sclerosis describe
Query midihist_032 Integer Recommended Lupus
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data
midihist_032a String 250 Recommended Lupus describe
Query midihist_033 Integer Recommended Rheumatoid Arthritis
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data
Query midihist_033a String 250 Recommended Rheumatoid Arthritis describe
Query midihist_034 Integer Recommended Crohn's disease
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data
midihist_034a String 250 Recommended Crohn's disease describe
Query edihea Integer Recommended Head injury
0;1;2;9; -999
0 = No; 1 = Possible; 2 = Definite; 9 = Not answered/Not evaluated; -999= Don't know/Missing Data midihist_035
midihist_035a String 250 Recommended Head Injury describe
Query midihist_036 Integer Recommended Seizures, fainting spells, or migraines
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data
midihist_036a String 250 Recommended Seizures, fainting spells, or migraines describe
Query midihist_037 Integer Recommended Visual problems not correctable by lenses (i.e. blindness or astigmatism)
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data
Query midihist_037a String 250 Recommended Visual problems not correctable by lenses (i.e. blindness or astigmatism) describe
Query ccc2hearing Integer Recommended Does the subject have a permanent hearing loss? (0=No, 1=Yes)
0;1;-9; 9
0 = No; 1 = Yes; -9 = Missing value; 9=Not evaluated midihist_038
Query ccc2sphearin String 200 Recommended Details of hearing loss midihist_038a
Query dph00b3 Integer Recommended First degree relative history of psychosis
0;1; 9; -999
0=No; 1=Yes; 9=Not evaluated; -999= Don't know/Missing Data midihist_039
midihist_039a String 250 Recommended Psychosis in first degree relative describe
Query midihist_040 Integer Recommended Other medical history 1
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_25
midihist_040a String 250 Recommended Other medical history 1 describe mh_25a
Query midihist_041 Integer Recommended Other medical history 2
1;2;9;-999
1=No History; 2=Yes; 9=Not evaluated; -999= Don't know/Missing Data mh_26
Query midihist_041a String 250 Recommended Other medical history 2 describe mh_26a
Query blood_ps Integer Recommended systolic blood pressure midihist_042a
Query blood_pd Integer Recommended diastolic blood pressure midihist_042b
Query vital_pulse Integer Recommended Pulse (sitting for 3 minutes)beats/min 0 :: 300 midihist_043
Query weight_std Float Recommended Weight - Standard Unit -1 = Not known; 999 = Missing midihist_044
Query height_std Float Recommended Height - Standard Unit -1 = Not known; 999 = Missing midihist_045
Query exc_17b Integer Recommended Known history or current episode of recent myocardial infarction (within one year) or a history of myocardial infarction
1;2; -999
1=Yes; 2=No; -999=Don't know/Missing Data mh_5, midihist_005
Query intrt Integer Recommended Treatment Status Code 0::2 0=Baseline; 1=In Treatment; 2=In Follow-up
Query trtgrp_p Integer Recommended Treatment Group 1;2 1=Long-Acting Injectable Risperidone Microspheres; 2=Second Generation Oral Antipsychotic Medication
Query days_visit1 Integer Recommended Days from Visit 1 dav1pmc
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 visit String 60 Recommended Visit name vtyppmc
Query site String 101 Recommended Site Study Site
Query mhx002a Integer Recommended History of:Sensitivity to study medication(s) 1;2;9 1=No; 2=Yes;9=not evaluated
Query mhxa1e Integer Recommended Heart attack/ myocardial infarction 0;1;9;-9 0=No; 1=Yes; 9=not evaluated; -9=unknown
mhx004b String 250 Recommended If YES, Enter onset/resolved date indicate ongoing with treatment or not. If NOT EVALUATED, explain or describe below: Cardiovascular disorder
Query rev_endodiabetes String 50 Recommended Diabetes Yes;No;NK NK = Not known
Query mhx020b String 250 Recommended If YES, Enter onset/resolved date indicate ongoing with treatment or not. If NOT EVALUATED, explain or describe below: Other
Query psqb02 Integer Recommended Problem with sleepiness during the day 0::2; 9 0 = No; 1 = Yes; 2 = Do not know; -9 = Missing value
mhx024b String 200 Recommended Explain history - daytime sleepiness
Query mhx026a Integer Recommended History of STDs 1;2;9 1=No; 2=Yes; 9=Not evaluated
Query mhx026b String 200 Recommended Explain history - STDs
Query mhx028d Integer Recommended How many prescription medications at time of consent?
Query bima_28 Integer Recommended Number of anti-psychotic medications prescribed.
Query bima_29 Integer Recommended Number of other psychotropic medications prescribed.
Query bima_30 Integer Recommended Number of other non-psychotropic medications prescribed.
Query bima_31 Integer Recommended Number of times per day patient must take medications
Query monthsbl Float Recommended Actual number of months from Baseline
Query days_baseline Integer Recommended Days since baseline
nosecmt String 250 Recommended Nose/Throat comments
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.