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

Columbia Suicide History Form

122 Shared Subjects

N/A
Clinical Assessments
Suicide
12/20/2016
cshf01
12/20/2016
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
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field
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.
sex String 20 Required Sex of the subject M;F M = Male; F = Female gender
Query site String 101 Recommended Site Study Site
Query visit String 50 Recommended Visit name
Query days_baseline Integer Recommended Days since baseline
Query suicidalityatt_lifetime_tot Integer Recommended Number of Lifetime Suicide Attempts
Query shsq2 Integer Recommended Total number of ambiguous attempts
Query sbiatnal Integer Recommended Suicidal Behavior. Total number Interrupted Attempts. Lifetime. 0::1000;-9 -9=incomplete
Query cssrs_base_14a Integer Recommended Baseline. Que 14a - Suicidal Behavior: Number of aborted attempts
Query actlthl2 Integer Recommended Most Lethal Actual Lethality/Medical Damage 0::6; 9;-9 0=No physical damage or very minor physical damage (e.g., surface scratches).; 1=Minor physical damage (e.g., lethargic speech first-degree burns mild bleeding sprains).; 2=Moderate physical damage medical attention needed (e.g., conscious but sleepy, somewhat responsive second-degree burns bleeding of major vessel).; 3=Moderately severe physical damage medical hospitalization and likely intensive care required (e.g., comatose with reflexes intact third-degree burns less than 20% of body extensive blood loss but can recover major fractures).; 4=Severe physical damage medical hospitalization with intensive care required (e.g., comatose without reflexes third-degree burns over 20% of body extensive blood loss with unstable vital signs major damage to a vital area); 5=Death; -9=incomplete; 6 = Depending upon method used: Bullet to head area, Comatose -- all reflexes absent; respiratory depression with cyanosis or circulatory failure and shock or both, Extensive blood loss with shock; insult to vital areas with change in vital signs; recovery with inpatient care doubtful, Major damage to vital area (skull, neck, spinal column) -- paralysis expected, Paralysis or other spinal cord injury, Third degree burns over 60% body area, Unconscious -- massive efforts at resuscitation necessary for revival; 9=NA
Query actlthl1 Integer Recommended Most Recent Actual Lethality/Medical Damage 0::6; 9; -9 0=No physical damage or very minor physical damage (e.g., surface scratches).; 1=Minor physical damage (e.g., lethargic speech first-degree burns mild bleeding sprains).; 2=Moderate physical damage medical attention needed (e.g., conscious but sleepy, somewhat responsive second-degree burns bleeding of major vessel).; 3=Moderately severe physical damage medical hospitalization and likely intensive care required (e.g., comatose with reflexes intact third-degree burns less than 20% of body extensive blood loss but can recover major fractures).; 4=Severe physical damage medical hospitalization with intensive care required (e.g., comatose without reflexes third-degree burns over 20% of body extensive blood loss with unstable vital signs major damage to a vital area); 5=Death; -9=incomplete; 6 = Depending upon method used: Bullet to head area, Comatose -- all reflexes absent; respiratory depression with cyanosis or circulatory failure and shock or both, Extensive blood loss with shock; insult to vital areas with change in vital signs; recovery with inpatient care doubtful, Major damage to vital area (skull, neck, spinal column) -- paralysis expected, Paralysis or other spinal cord injury, Third degree burns over 60% body area, Unconscious -- massive efforts at resuscitation necessary for revival; 9=NA
Query shsq7ady Integer Recommended Date of: First actual suicide attempt (days from baseline)
Query shsq7bdy Integer Recommended Date of: Most recent actual attempt (days from baseline)
Query shsq7cdy Integer Recommended Date of: Most lethal actual attempt (days from baseline)
Query shsq8 Integer Recommended Lethality of most recent ambiguous attempt 0::9 0 = Depending upon method used: Fully conscious and alert, Minor bruises only -- no treatment necessary, No damage, No or minimal medical consequences or treatment, Surface scratches; none or minor bleeding; little or no wound care required; 1 = Depending upon method used: 01 Conscious but sleepy; 2 = Depending upon method used: Conscious -- some respiratory distress but no resuscitation needed, First degree burns, Flesh wounds with powder burns, Lethargic with diminution in intellectual ability, Moderate bleeding with clotting before significant blood loss occurs; simple wound care required, Simple rope burns, Some injury (e.g., mouth burns) and treatment in emergency room or on outpatient basis (e.g., gastric lavage), Sprains or minor injuries -- no bone, ligament, or tendon damage; no internal bleeding, tissue or brain damage; 3 = Depending upon method used: Asleep but easily aroused, Bleeding of major veins, danger of considerable blood loss without surgical intervention -- suturing necessary but no transfusion; vital areas intact and no change in vital sings; care on outpatient basis, Bullet lodged in extremity -- minor bleeding, Conscious -- minimal to moderate efforts at resuscitation needed, Extremities fractured -- casting necessary but no major tendon repair and complete recovery expected, More extensive injuries with treatment on outpatient basis, Second degree burns; 4 = Depending upon method used: Comatose -- withdrawal from painful stimuli; reflexes intact; injury sufficient for hospitalization, Injury sufficient for hospitalization -- vital signs and level of consciousness may be affected; 5 = Depending upon method used: Bullet in abdomen or chest -- major bleeding; vital signs unstable, Comatose -- no withdrawal from painful stimuli, most reflexes intact; no respiratory or circulatory depression; injury sufficient for ICU monitoring, Conscious -- extensive efforts at resuscitation needed, Extensive blood loss; suturing, blood replacement and tendon repair required; wound may be to head, thorax, or abdomen but vital organs intact and vital signs stable; recovery with inpatient care expected, Hospitalization and resuscitation required, Major bone and/or tendon damage in multiple areas -- internal bleeding; some residual impairment expected but not in vital areas, Third degree burns under 20% body area; 6 = Depending upon method used: Comatose -- most reflexes absent; no respiratory or circulatory depression; ICU and significant medical procedure (e.g., dialysis), Major systemic effects -- such as G.I. perforation, renal failure, blood hemolysis, or shock; vital signs unstable; 7 = Depending upon method used: Bullet to head area, Comatose -- all reflexes absent; respiratory depression with cyanosis or circulatory failure and shock or both, Extensive blood loss with shock; insult to vital areas with change in vital signs; recovery with inpatient care doubtful, Major damage to vital area (skull, neck, spinal column) -- paralysis expected, Paralysis or other spinal cord injury, Third degree burns over 60% body area, Unconscious -- massive efforts at resuscitation necessary for revival; 8 = Death; 9 = Not Applicable
Query shsq9 Integer Recommended Lethality of most lethal ambiguous attempt 0::9 0 = Depending upon method used: Fully conscious and alert, Minor bruises only -- no treatment necessary, No damage, No or minimal medical consequences or treatment, Surface scratches; none or minor bleeding; little or no wound care required; 1 = Depending upon method used: 01 Conscious but sleepy; 2 = Depending upon method used: Conscious -- some respiratory distress but no resuscitation needed, First degree burns, Flesh wounds with powder burns, Lethargic with diminution in intellectual ability, Moderate bleeding with clotting before significant blood loss occurs; simple wound care required, Simple rope burns, Some injury (e.g., mouth burns) and treatment in emergency room or on outpatient basis (e.g., gastric lavage), Sprains or minor injuries -- no bone, ligament, or tendon damage; no internal bleeding, tissue or brain damage; 3 = Depending upon method used: Asleep but easily aroused, Bleeding of major veins, danger of considerable blood loss without surgical intervention -- suturing necessary but no transfusion; vital areas intact and no change in vital sings; care on outpatient basis, Bullet lodged in extremity -- minor bleeding, Conscious -- minimal to moderate efforts at resuscitation needed, Extremities fractured -- casting necessary but no major tendon repair and complete recovery expected, More extensive injuries with treatment on outpatient basis, Second degree burns; 4 = Depending upon method used: Comatose -- withdrawal from painful stimuli; reflexes intact; injury sufficient for hospitalization, Injury sufficient for hospitalization -- vital signs and level of consciousness may be affected; 5 = Depending upon method used: Bullet in abdomen or chest -- major bleeding; vital signs unstable, Comatose -- no withdrawal from painful stimuli, most reflexes intact; no respiratory or circulatory depression; injury sufficient for ICU monitoring, Conscious -- extensive efforts at resuscitation needed, Extensive blood loss; suturing, blood replacement and tendon repair required; wound may be to head, thorax, or abdomen but vital organs intact and vital signs stable; recovery with inpatient care expected, Hospitalization and resuscitation required, Major bone and/or tendon damage in multiple areas -- internal bleeding; some residual impairment expected but not in vital areas, Third degree burns under 20% body area; 6 = Depending upon method used: Comatose -- most reflexes absent; no respiratory or circulatory depression; ICU and significant medical procedure (e.g., dialysis), Major systemic effects -- such as G.I. perforation, renal failure, blood hemolysis, or shock; vital signs unstable; 7 = Depending upon method used: Bullet to head area, Comatose -- all reflexes absent; respiratory depression with cyanosis or circulatory failure and shock or both, Extensive blood loss with shock; insult to vital areas with change in vital signs; recovery with inpatient care doubtful, Major damage to vital area (skull, neck, spinal column) -- paralysis expected, Paralysis or other spinal cord injury, Third degree burns over 60% body area, Unconscious -- massive efforts at resuscitation necessary for revival; 8 = Death; 9= Not Applicable
Query hsiyesno Integer Recommended have you ever thought of committing suicide? 0;1 0=No; 1=yes
Query hsioften Integer Recommended have you ever thought of committing suicide? How often? 1::4 1=Rarely; 2=Sometimes; 3=Often; 4=Almost Always
Query hsiddy Integer Recommended Thought about suicide. When was the last time? (days from baseline)
Query suicidalityattempt Integer Recommended Attempt suicide 0;1 0=No; 1=Yes
Query hcsaq2 Integer Recommended Total Number of lifetime suicide attempts (only self-injurious behaviour with intent to die).
Query ca213 Integer Recommended Current condition - Suicide attempts number
Query pas03a_wk1 Integer Recommended Date of suicide attempt
Query dtacracy Integer Recommended Date accuracy 0;7;30;90;365 0 = Exact Date; 7 = Narrow down to a week; 30 = Narrow down to a month; 90 = Narrow down to a season; 365 = Narrow down to a year
Query lrating Integer Recommended Lethality Rating Scale 0::9 0 = Depending upon method used: Fully conscious and alert, Minor bruises only -- no treatment necessary, No damage, No or minimal medical consequences or treatment, Surface scratches; none or minor bleeding; little or no wound care required; 1 = Depending upon method used: 01 Conscious but sleepy; 2 = Depending upon method used: Conscious -- some respiratory distress but no resuscitation needed, First degree burns, Flesh wounds with powder burns, Lethargic with diminution in intellectual ability, Moderate bleeding with clotting before significant blood loss occurs; simple wound care required, Simple rope burns, Some injury (e.g., mouth burns) and treatment in emergency room or on outpatient basis (e.g., gastric lavage), Sprains or minor injuries -- no bone, ligament, or tendon damage; no internal bleeding, tissue or brain damage; 3 = Depending upon method used: Asleep but easily aroused, Bleeding of major veins, danger of considerable blood loss without surgical intervention -- suturing necessary but no transfusion; vital areas intact and no change in vital sings; care on outpatient basis, Bullet lodged in extremity -- minor bleeding, Conscious -- minimal to moderate efforts at resuscitation needed, Extremities fractured -- casting necessary but no major tendon repair and complete recovery expected, More extensive injuries with treatment on outpatient basis, Second degree burns; 4 = Depending upon method used: Comatose -- withdrawal from painful stimuli; reflexes intact; injury sufficient for hospitalization, Injury sufficient for hospitalization -- vital signs and level of consciousness may be affected; 5 = Depending upon method used: Bullet in abdomen or chest -- major bleeding; vital signs unstable, Comatose -- no withdrawal from painful stimuli, most reflexes intact; no respiratory or circulatory depression; injury sufficient for ICU monitoring, Conscious -- extensive efforts at resuscitation needed, Extensive blood loss; suturing, blood replacement and tendon repair required; wound may be to head, thorax, or abdomen but vital organs intact and vital signs stable; recovery with inpatient care expected, Hospitalization and resuscitation required, Major bone and/or tendon damage in multiple areas -- internal bleeding; some residual impairment expected but not in vital areas, Third degree burns under 20% body area; 6 = Depending upon method used: Comatose -- most reflexes absent; no respiratory or circulatory depression; ICU and significant medical procedure (e.g., dialysis), Major systemic effects -- such as G.I. perforation, renal failure, blood hemolysis, or shock; vital signs unstable; 7 = Depending upon method used: Bullet to head area, Comatose -- all reflexes absent; respiratory depression with cyanosis or circulatory failure and shock or both, Extensive blood loss with shock; insult to vital areas with change in vital signs; recovery with inpatient care doubtful, Major damage to vital area (skull, neck, spinal column) -- paralysis expected, Paralysis or other spinal cord injury, Third degree burns over 60% body area, Unconscious -- massive efforts at resuscitation necessary for revival; 8 = Death; 9 = Not Applicable
Query chf_method1 String 250 Recommended 1st suicide attempt method
Query chf_method2 String 250 Recommended 2nd suicide attempt method
Query chf_method3 String 250 Recommended 3rd suicide attempt method
Query atmptype Integer Recommended Attempt Type 1::4 1=Actual; 2=Ambiguous; 3=Interrupted; 4=Aborted
Query srd10j Integer Recommended Were you alone or with others? 1;2 1=Alone; 2=With others
Query exttrig Integer Recommended External Trigger Category 1::9 1 = conjugal; 2 = other interpersonal; 3 = occupational; 4 = living situation; 5 = health; 6 = other; 7 = cannot be assessed; 8 = sexual abuse; 9 = physical abuse
Query sectrig Integer Recommended Secondary Trigger Category 1::9 1 = conjugal; 2 = other interpersonal; 3 = occupational; 4 = living situation; 5 = health; 6 = other; 7 = cannot be assessed; 8 = sexual abuse; 9 = physical abuse
Query atmpyn Integer Recommended Has the adolescent had any Actual, Ambiguous, Interrupted, or Aborted Attempts since the last assessment? 0;1 0=No; 1=yes
Query sa_total Integer Recommended Total suicide attempt by assessment period sano
Query suicide_interrupted_total Integer Recommended Total interrupted suicide attempts per subject over follow-up asano
Query suicide_aborted_total Integer Recommended Total aborted suicide attempts per subject over follow-up isano
Query sebevnt Integer Recommended Masked Suicide eavluation Board (SEB) Event 0::6 0 = No Event;1 = Actual suicide attempt; 2 = Interrupted suicide attempt; 3 = Hospitalization because of thoughts of c; 4 = Emergency evaluation because of thoughts; 5 = Self Injurious Behavior without Suicidal; 6 = Completed Suicide
Query sebevday Integer Recommended Masked Suicide Evaluation Board (SEB) Date (days from baseline)
Query version_form String 100 Recommended Form used/assessment name
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.