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

Demographics and Baseline Characteristics

2,567 Shared Subjects

Demographics and baseline characteristics
Clinical Assessments
Demographics
05/07/2014
demo01
12/27/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*
src_subject_id String 20 Required Subject ID how it's defined in lab/project CATIEID, bid, record_id
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, age, dema1
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field date, followup_date
sex String 20 Required Sex of the subject
M;F
M = Male; F = Female GENDER, dema2, gender, sex
Query white Integer Recommended 5. Race 0;1 1=yes, 0=no
Query black Integer Recommended Black or African-American 0;1; 999 1=yes; 0=no;999= missing
Query native Integer Recommended American Indian or Alaska Native 0;1; 999 1=yes; 0=no; 999= missing
Query asian String 5 Recommended Ethnicity: Asian
Yes;No; 999
999= missing
Query pacific String 5 Recommended Ethnicity: Pacific
Yes;No; 999
999= missing
Query race String 30 Recommended Race of study subject
American Indian/Alaska Native; Asian; Hawaiian or Pacific Islander; Black or African American; White; More than one race; Unknown or not reported
dema3, race1
Query race_c Integer Recommended Race in two category (white only vs. other) 1;2 1=White alone; 2=other
Query exacer Integer Recommended Has patient been hospitalized or required crisis stabilization services in the past three months for any mental health problem? 0;1 0=No; 1=Yes; Baseline covariate adjusted for in many statsitical models based on analysis plan
Query td Integer Recommended Does the patient now meet Schooler-Kane criteria for probable tardive dyskinesia? 0;1 0=No; 1= Yes; This item is question 10 from the screening eCRF. It is NOT the variable used to stratify patients into Phase 1A nor adjust for TD in statistical models. That variable, which was collected at the time of randomization via IVR (interactive voice response) is in the KEYVARS file, and is called PHASE1A
Query das1ms String 200 Recommended Marital status dema5, marital, marital_status
Query marital2 Integer Recommended Marital Stat categorized (married vs not) 0;1 1=Married; 0=Not married
Query sigother Integer Recommended Are you currently living with a significant other? 0;1 1=yes, 0=no
Query psysoc_89 String 5 Recommended Veteran?
Y;N;-7
Y=Yes; N=No; -7=Refused DEMO3, veteran
Query curreduccompleted String 50 Recommended Current grade education level completed PAT_EDUC
Query demo4a Integer Recommended If patient did not finish high school, years of education
Query educ_yrs Float Recommended Number of Years of Patient's Education 1::11;11.5;12::21 1-11 =(for patients who did not complete high school, these categories represent the number of years of education); 11.5 = Did not complete high school and number of years of education is 12; 12 = GED/high school diploma; 13 = Some college, did not graduate; 14 = Community college / tech school degree; 16 = College graduate; 17 = College graduate and some Master's level courses; 18 = Master's degree completed; 19 = Advanced degree courses, not graduated 21 = Advanced degree completed dema8
Query par_educ Integer Recommended How far did your parents go in school 0::9 0=Did not complete high school; 1=GED/High school diploma; 2=Some college, did not graduate; 3=Community college or technical school degree; 4=College graduate; 5=College graduate and some Master's level; 6=Master's degree completed; 7=Advanced degree courses, not graduated; 8=Advanced degree completed (e.g. Ph.D., M); 9=Unknown
Query demo5a Integer Recommended If parent did not finish highschool, years of education
Query cgi_sev Integer Recommended Clinician Global Impressions: Severity score 1::7 1 = Normal, Not ill; 2 = Minimally ill; 3 = Mildly ill; 4 = Moderately ill; 5 = Markedly ill; 6 = Severely ill; 7 = Very Severely ill
Query cgi_cat Integer Recommended Baseline CGI Severity (Normal vs not) 0;1 1=Normal, not ill; 0=Ill
Query b1_panss Integer Recommended Phase 1 Baseline PANSS Total Baseline score for the phase Also in PANSS file
Query employ Integer Recommended Patient Employment Status at Baseline 0::3 0=Unknown; 1=Full Time; 2=Part Time; 3=Did Not Work; Full time = worked at least 18 days in past month; Part time = worked less than 18 days in past month and earned income (SURFQA=1); Did not work = worked less than 18 days in past month and did not earn income (SURFQA = 2 or 3)
Query employ2 Integer Recommended Employment Status (Full time vs not) 0;1 1=Full time; 0=Not full time
Query qol01a Integer Recommended Currently live with parent 0;1 1=yes; 0=no
Query qol01b Integer Recommended Currently live with a spouse/girlfriend/boyfriend 0;1 1=yes; 0=no
Query qol01c Integer Recommended Currently live with a sibling 0;1 1=yes; 0=no
Query qol01d Integer Recommended Currently live with a son or daughter 0;1 1=yes; 0=no
Query qol01e Integer Recommended Currently live with other relatives 0;1 1=yes; 0=no
Query qol01f Integer Recommended Currently live with other people not related and not friends 0;1 1=yes; 0=no
Query qol01g Integer Recommended Lives alone 0;1 1=yes; 0=no
Query scid17a Integer Recommended Age 1st treated for emo/behavioral
Query yrs_trt Integer Recommended Years Since First Treatment for Behavioral or Emotional Problem
Query scid18a Integer Recommended Age at 1st antipsychotic prescription yrs_ause
Query yrs_pres Integer Recommended Years Since First Prescribed an Antipsychotic Medication
Query scid19 Integer Recommended Number previous hospitalizations lifetime
Query scid20 Integer Recommended Number previous hospitalizations past year
Query anti_beh Integer Recommended Childhood Antisocial Behaviors Sum of (SCID23 - SCID28)
Query beh_cat Integer Recommended Categorized Childhood Antisocial Behaviors 1::4 1=0 Antisocial Behaviors; 2=1-2 Antisocial Behaviors; 3=3-4 Antisocial Behaviors; 4=5-6 Antisocial Behaviors
Query sitetype String 20 Recommended Site Care Setting Site care setting indicated by the site (all applicable types are listed per site); MC = Managed Care; PN = Private, Non-Profit Agency; PP = Private Practice; RO =Research Only;SH = State Mental Health;UC = University Clinic;VA = VA; MHIS = Mental health, isolation, or suicide watch; GP = General Population interview_sublocation
Query rescreen Integer Recommended Rescreened 0;1 1=Yes for patients screened multiple times for inclusion in the study; missing otherwise
Query scrn_dy Integer Recommended Day Screened Number of days from study baseline to date of screening
Query olz_0 Integer Recommended Baseline OLZ 0;1 Patient was receiving this antipsychotic medication (olanzapine) at baseline 1=Yes, 0=No Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query quet_0 Integer Recommended Baseline QUET 0;1 Patient was receiving this antipsychotic medication (quetiapine) at baseline 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query risp_0 Integer Recommended Baseline RISP 0;1 Patient was receiving this antipsychotic medication (risperidone) at baseline 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query zip_0 Integer Recommended Baseline ZIP 0;1 Patient was receiving this antipsychotic medication (ziprasidone) at baseline 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query hal_0 Integer Recommended Baseline HAL 0;1 Patient was receiving this antipsychotic medication (Haldol) at baseline; 1=Yes, 0=No
Query deca_0 Integer Recommended Baseline DECA 0;1 Patient was receiving this antipsychotic medication (a decanoate) at baseline 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query per_0 Integer Recommended Baseline PER 0;1 Patient was receiving this antipsychotic medication (perphenazine) at baseline 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query othr_0 Integer Recommended Baseline Other Antipsychotics 0;1 Patient was receiving any other antipsychotic medication besides OLZ, QUET, RISP, ZIP, HAL, DECA, or PER at baseline; 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query allothr0 Integer Recommended Baseline All Other Antipsychotics 0;1 Patient received any other antipsychotic medications (ZIP, HAL, DECA, PER, or anything falling within the OTHR_0 category) at baseline (meds not included here are OLZ, QUET, and RISP); 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query none_0 Integer Recommended No Baseline Antipsychotic Med 0;1 Patient was receiving no antipsychotic medication at baseline; 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query olzi_0 Integer Recommended Baseline OLZ Monotherapy 0;1 Patient received ONLY this antipsychotic medication at baseline; 1=Yes, 0=No
Query queti_0 Integer Recommended Baseline QUET Monotherapy 0;1 Patient received ONLY this antipsychotic medication at baseline; 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query rispi_0 Integer Recommended Baseline RISP Monotherapy 0;1 Patient received ONLY this antipsychotic medication at baseline; 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query dualmed0 Integer Recommended Baseline Combination Meds 0;1 Patient received multiple antipsychotic medications at baseline, one of which was olanzapine, quetiapine, or risperidone 1=Yes, 0=No; Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query allothi0 Integer Recommended Baseline All Other Monotherapy 0;1 Patient received one or more antipsychotic medications at baseline which did not include olanzapine, quetiapine, or risperidone 1=Yes, 0=No; (Note: this can be monotherapy or more than one drug); Note: includes medications reported taken on the day of baseline or in the 2 weeks prior to baseline
Query switch Integer Recommended Baseline Med Switch Status 0::2 Compares Phase 1/1A randomized treatment with antipsychotic medications received at baseline 0=Newly treated (not taking an antipsychotic at baseline); 1=Same medication 2=Switched medication
Query me0a Integer Recommended Significant historical medical diag? 0;1 0=No; 1=Yes
Query soc String 100 Recommended SOC System Organ Class Coded variable: MedDRA dictionary, version 4.0: System Organ Class This file contains the MedDRA coded terms for any AEs/side effects that were reported spontaneously by the patient at a visit
prf_term String 100 Recommended Preferred Term Coded variable: MedDRA dictionary, version 4.0: Preferred Term This file contains the MedDRA coded terms for any AEs/side effects that were reported spontaneously by the patient at a visit
Query me2 Integer Recommended Status 0;1 0 = Past [Inactive]; 1 = Active
Query me3 Integer Recommended Did the patient have a hysterectomy? 0;1 0=No; 1=Yes
Query me3a Integer Recommended 3a. Did the hysterectomy include an ooph 0;1;99 0 = No; 1 = Yes; 99 = Unknown
Query any_mhx Integer Recommended Any Active Significant Medical History 1=Yes, missing otherwise
Query ran002 Integer Recommended Was the subject randomized? 0::3; -9 0=No; 1=Yes; -9=unknown; 2=No meds; 3=No community care rand
Query dema6 Integer Recommended Which Best describes your current living situation? 1::9 1=Independent Living. Live alone, with spouse, family or friend, in an apartment or house.; 2=Minimally Structured Residence. Live in a supervised apartment program, boarding home, adult foster care.; 3=Moderately Restrictive Residence. Live in a halfway house, treatment program, acute psychiatric diversion facility, treatment lodge; 4=Extremely Restrictive Residence. Psychiatric hospital, skilled nursing facility, jail or prison.; 5=Homeless. Has been homeless or in emergency shelter for the homeless; 6=Lives in someone elses apartment, room or house; 7=Dormitory/College residence; 8=Residential treatment; 9=Other, specify
Query dema7 Integer Recommended In the past week, how many days did you get to choose what you had to eat for your meals. (Applies to MOST meals in a day) 0::3 0=0 to 1 days; 1=2 to 3 days; 2= 4 to 5 days; 3= 6to 7 days
Query dema9 Integer Recommended Did you earn a high school diploma or GED? 0;1 0=No; 1=Yes
Query living1 Integer Recommended Living situation 0;1 0=Other type of living situation; 1=Independent Living
Query strata String 1 Recommended O/Q/R ? Incoming Study Medication O;Q;R O=Olanzapine; Q=Quetiapine; R=Risperidone
Query trt Integer Recommended Treatment code 1;2 1: Switch; 2: Stay
Query visit String 50 Recommended Visit name week, wk
Query fseqno Integer Recommended Sequence Number 0::999 The FSEQNO variable in the ADJ form has a special interpretation compared to other forms. For example, ADJ FSEQNO of '1' can be thought of as being '001', FSEQNO of '2' can be thought of as being '002', and FSEQNO of '3' can be thought of as being '003'. The first digit of FSEQNO relates to the corresponding ENF sequence number at that visit and the third digit relates to the specific adjudicator who completed the adjudication form.
Query daysrz Integer Recommended days since randomization days, dema0b
version_form String 100 Recommended Form used/assessment name vers
Query site String 101 Recommended Site Study Site psite
Query treatment_name String 200 Recommended treatment name trt1
Query wtliab2 Integer Recommended Weight liability at baseline 1::3 1=High only; 2=Low only; 3=Both
fspgod String 35 Recommended Subject's gender OTHER describe gender_other
incardat Date Recommended date of last incarceration jail_date
Query psysoc_78 Integer Recommended Lifetime: # Arrests 0::200 arrests
Query psysoc_81 Integer Recommended Lifetime: Jail Time: # Years 0::200 years_incarcerated
Query psysoc_82 Integer Recommended Lifetime: Jail Time: # Months 0::11 months_incarcerated
Query psysoc_83 Integer Recommended Lifetime: Jail Time: # Days days_incarcerated
Query vr_arrest Integer Recommended arrested since last visit 0;1 0=No; 1=Yes arrested
Query am16 Integer Recommended Total number of times arrested during this interval times_arrested
dthdate String 30 Recommended Date of death death_date
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
ca15 Date Recommended Admission date admission_1
ca16 Date Recommended Discharge date discharge_1
Query demosam_002 Integer Recommended How many years of education have you had 0 = No Education ;1 = 1st grade ;2 = 2nd grade ;3 = 3rd grade ;4 = 4th grade ; 5=5 years Completed 5th grade (Grade School) ;6=6 years Completed 6th grade;7=7 years Completed 7th grade ;8=8 years Completed 8th grade (Middle School) ;9 = 9th grade ; 10 = 10th grade ; 11 = 11th grade ; 12 = 12th grade OR GED ; 13 = 1 year of college ; 14 = 2 years of college or associates degree ; 15 = 3 years of college ; 16 = bachelor's degree ; 17 = 1 year of graduate school ; 18 = 2 years of graduate school ; 19 = 3 years of graduate school ; 20 = 4+ years of graduate school education
Query status_before String 500 Recommended In the 12 months before your current incarceration, were you (select all that apply): Legally employed for wages; Legally self-employed; Making money illegally; Out of work and looking for work; Out of work but not currently looking for work; A full-time parent; A student; Military; Retired; Unable to work; Receiving disability benefits (such as SSDI, VA disability benefits, etc)
Query children_under18 Integer Recommended Number of children you have under age 18 children
Query children_support Integer Recommended Number of children (of any age) who you were living with you or who you were supporting financially in the year before your current incarceration:
Query income_beforejail Integer Recommended Annual household income (legal or illegal) in the year prior to the current incarceration: income
Query household Integer Recommended Number of people in your household in the year prior to the current incarceration:
Query incarcerated Integer Recommended Number of times you have been incarcerated including house of correction, prison or jail, in your lifetime (include current jail time served; if transferred between facilities [like jail to prison] count as one time; best estimate):
Query suicide_watch Integer Recommended Since you were arrested most recently and brought to this jail, have you spent any time on suicide or mental health watch? 0;1 0 = No; 1 = Yes
Query interview_status Integer Recommended Interview status 1::4 1 = Occurring; 2 = Missed; 3 = Deceased; 4 = Other
other_interview_status String 300 Recommended If interview status is "Other," then please explain
Query currently_incarcerated Integer Recommended Currently incarcerated? 0;1 0 = No; 1 = Yes
Query type_incarceration Integer Recommended If incarcerated, please specify type 1::3 1 = Jail detention (unsentenced); 2 = Serving a jail sentence; 3 = Serving a prison sentence
release_date Date Recommended What date were you released after the time we saw you in jail (initial assessment)? release_date_fu
Query incarcerated_again Integer Recommended Have you been incarcerated again since last assessment?
0;1
0 = No; 1 = Yes
Query incarcerated_num Integer Recommended How many times incarcerated since last assessment?
admission_2 Date Recommended Admission date #2
discharge_2 Date Recommended Discharge date #2
admission_3 Date Recommended Admission date #3
discharge_3 Date Recommended Discharge date #3
admission_4 Date Recommended Admission date #4
discharge_4 Date Recommended Discharge date #4
admission_5 Date Recommended Admission date #5
discharge_5 Date Recommended Discharge date #5
admission_6 Date Recommended Admission date #6
discharge_6 Date Recommended Discharge date #6
admission_7 Date Recommended Admission date #7
discharge_7 Date Recommended Discharge date #7
actual_release_date Date Recommended Actual Release Date
Query outreach_type1 Integer Recommended Communication type 1::5 1 = Phone call ; 2 = Email ; 3 = Postal letter ; 4 = Phone text ; 5 = In person
Query locator_type1 Integer Recommended Communication type 1::5 1 = Phone call ; 2 = Email ; 3 = Postal letter ; 4 = Phone text ; 5 = In person
otherrace String 100 Recommended specify other race The following questions are about you or the child's family. race_otr
Query ethnicity String 30 Recommended Ethnicity of participant
Hispanic or Latino; Not Hispanic or Latino; Unknown
btaa3 Float Recommended Length of session (minutes) 999=Legitmately skipped session_length
attempted_calls Integer Recommended Attempted Calls (including completed call) cvlt_notes
contact_type Integer Recommended Contact type 1::5 1 = Suicide Prevention Intervention Session - Completed ; 2 = Suicide Prevention Intervention Session - Partial ; 3 = Follow-up Session - Completed ; 4 = Follow-up Session - Partial ; 5 = Adverse Event/Severe Adverse Event only
locator_call_num Integer Recommended total number of locator calls call_count
time_service String 50 Recommended Approximate time spent on service linkage outside session
sexual_or_descrip String 50 Recommended What is your sexual orientation? orientation_other
demoses04 Integer Recommended Which best describes how you identify your sexual orientation?
1::8
1= Asexual; 2= Bisexual; 3= Heterosexual/Straight; 4= Gay; 5= Lesbian; 6= Pansexual; 7= Questioning; 8= Other (please indicate) orientation
years_incarcerated Integer Recommended Total time spent incarcerated in lifetime: # years 0::99 Incerceration includes both jail and prison
months_incarcerated Integer Recommended Total time spent incarcerated in lifetime: # months 0::12 Incerceration includes both jail and prison
days_incarcerated Integer Recommended Total time spent incarcerated in lifetime: # days 0::31 Incerceration includes both jail and prison
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.