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

Clinical Trials. Demographics

3,200 Shared Subjects

N/A
Clinical Assessments
Demographics
01/06/2015
demogr01
07/12/2018
View Change History
01
Query Element Name Data Type Size Required Description Value Range Notes Aliases
subjectkey GUID Required The NDAR Global Unique Identifier (GUID) for research subject NDAR* guid
src_subject_id String 20 Required Subject ID how it's defined in lab/project id, patid, pid, randid, subjectid
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field demdat, visit_date
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_v, agem
sex String 20 Required Sex of the subject M;F M = Male; F = Female gender, sex
Query visit String 50 Recommended Visit name int1, timept, visit_name, vtypdhs
Query asstyp Integer Recommended Assessment type 1::20 1=TADS GATE A; 2=TADS GATE B; 3 = TADS Gate C; 4 = TADS Week 6; 5 = TADS Week 12; 6 = TADS Week 18; 7 = TADS Week 24; 8 = TADS Week 30; 9 = TADS Week 36; 10 = TADS F/U Mo 3; 11 = TADS F/U Mo 6; 12 = TADS F/U Mo 9; 13 = TADS F/U Mo 12; 14 = SOFTAD month 6; 15 = SOFTAD month 12; 16 = SOFTAD month 18; 17 = SOFTAD month 24; 18 = SOFTAD month 30; 19 = SOFTAD month 36; 20 = SOFTAD month 42
Query stage Integer Recommended Study stage
0::5; 51::53; 67; -888; -999
0 = Pre-Randomization (TADS) 1 = Stage 1 (TADS) 2 = Stage 2 (TADS) 3 = Stage 3 (TADS) 4 = Stage 4 (TADS) 5 = Stage 5 (SOFTAD); 51=Treatmentas Usual; 52=Screening Alone; 53=Intervention; 67=Unknown; -888=Not Applicable; -999=Missing;
Query enroll Integer Recommended SOFTAD enrollment record 0;1 0 = No; 1 = Yes
Query bsit0 Float Recommended Weeks from Time 0/baseline to assessment demt0, stet0
Query bsimo Float Recommended Months from Time 0 to assessment demmo, ste_m
Query bsistm Float Recommended Months from SOFTAD enrollment date to assessment demstm
Query height_met Float Recommended Height - Metric Unit ht_cm, steht
Query weight_met Float Recommended Weight - Metric Unit stewt, wt_kg
Query marist Integer Recommended Marital status 0;1 0 = No; 1 = Yes
Query signifot Integer Recommended Living with significant other 0;1 0 = No; 1 = Yes
Query livehome Integer Recommended Living at home 0;1 0 = No; 1 = Yes
Query primarm Integer Recommended Primary female caretaker/mother figure (maternal demographics) 0::10 0 = No female caretaker 1 = Biological mother 2 = Adoptive mother 3 = Foster mother 4 = Stepmother 5 = Grandmother 6 = Sister 7 = Aunt 8 = Other 9 = Other female relative 10 = Other female non-relative dem_05af, fpcare
Query fpcareo String 40 Recommended Other female primary caregiver
Query primarf Integer Recommended Primary male caretaker/father figure (paternal demographics) 0::10 0 = No male caretaker 1 = Biological father 2 = Adoptive father 3 = Foster father 4 = Stepfather 5 = Grandfather 6 = Brother 7 = Uncle 8 = Other 9 = Other male relative 10 = Other male non-relative dem_05bf, mpcare
Query mpcareo String 40 Recommended Other male primary caregiver
Query independ Integer Recommended Living independently in past 6 months 0;1 0 = No; 1 = Yes
Query foster Integer Recommended Foster home in past 6 months 0;1 0 = No; 1 = Yes
Query college_6m Integer Recommended College/university in past 6 months 0;1 0 = No; 1 = Yes college
Query treatctr Integer Recommended Treatment center in past 6 months 0;1 0 = No; 1 = Yes
Query homeless Integer Recommended Homeless in past 6 months 0;1 0 = No; 1 = Yes
Query boardsc Integer Recommended Boarding school in past 6 months 0;1 0 = No; 1 = Yes
Query grouphm Integer Recommended Group home in past 6 months 0;1 0 = No; 1 = Yes
Query detent Integer Recommended Detention center in past 6 months 0;1 0 = No; 1 = Yes
Query ceducat Integer Recommended Current educational status 0::6 0 = Not in an educational pgm.; 1 = Graduate or professional pgm.; 2 = College / junior college; 3 = Trade school; 4 = High school; 5 = GED / high school diploma pgm.; 6 = Middle school
Query grades Integer Recommended How are teen's grades in school at the present time? 0::5 0 = Teen dropped out of school 1 = Enrolled, but school not in session 2 = Better than average 3 = Average 4 = Below average 5 = Failing
Query suspend Integer Recommended Expelled/suspended in past 6 months 0;1 0 = No; 1 = Yes
Query suspcnt Integer Recommended No. expulsions/suspensions, past 6 mos.Number of expulsions or suspensions in the past 6 months
Query employst Integer Recommended Current employment status 1::8 1 = Working full-time job; 2 = Working part-time job; 3=not employed; 4=NA; 5 =retired;6=Disability recipient; 7=Student; 8=Other
Query empcur Integer Recommended Currently employed 0;1; -99; 77; 88 0 = No; 1 = Yes; -99= N/A ; 88= Missing ; 77= Refused employ
Query daysrz Integer Recommended days since randomization visitdt
Query study String 100 Recommended Study studyid
Query site String 101 Recommended Site Study Site psite, site_uid, siteid
Query completed Integer Recommended Checks if completed 0::3 0=No; 1=Yes; 2=Yes, lost; 3=Unverified formcomp
Query subtrial_name Integer Recommended Name of subtrial 1::3 1=Crossover; 2=Guanfacine; 3= Open Label MPH
Query ethnicity String 30 Recommended Ethnicity of participant
Hispanic or Latino; Not Hispanic or Latino; Unknown
ethnic, hispanic
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
race
Query dem_04 Integer Recommended Childs usual living arrangement 1::7 1=Parental Home(At least one parent) 2=Relative(Other than parent) 3=With Unrelated Adults 4=Shared apartment/ residence with parents friends 5=Shelter/street/homeless/ transient 6=Unknown 7=Other
Query dem_05aa Integer Recommended Current mother figure age
Query dem_05ba Integer Recommended Current father figure age
Query dem_06a Integer Recommended Give the number of each of the following in the childs usual living arrangement - Brothers
Query dem_06b Integer Recommended Give the number of each of the following in the childs usual living arrangement - Sisters
Query dem_06c Integer Recommended Give the number of each of the following in the childs usual living arrangement - Other relatives
Query dem_06d Integer Recommended Give the number of each of the following in the childs usual living arrangement - Other non-relatives
Query dem_07 Integer Recommended Type of educational activity 1::17 1=Regular public school grade; 2=Regular private/parochial school grade 3=Regular public nursery; 4=Regular public kindergarten; 5=Regular private/parochial nursery; 6=Regular private/parochial kindergarten; 7=Special school for preschoolers with emotional/behavioral or learning problems; 8=Day Care; 9=Play group; 10=Pre-nursery; 11=Pre-kindergarten; 12=Not in school, not in play group, not in day care; 13=Special Class within regular school; 14=Special school for school-age children with emotional/behavioral or learning problems; 15=Other (Specify);16=Special school; 17=Home school
Query currgradelevel String 50 Recommended Current grade level dem_07a
Query dem_08a Integer Recommended Mother current employment 1::11;99 1=Working full time(35hrs or more a week at one or more jobs) ; 2=Working part time; 3=Keeping house ; 4=Unemployed, looking for work; 5=Unemployed, not looking for work; 6=Disabled; 7=Retired; 8=Student, full time; 9=Student, part time; 10=Other; 11 =Unemployed; 99=Not in household
Query dem_08b Integer Recommended Father current employment 1::12;99 1=Working full time(35hrs or more a week at one or more jobs); 2=Working part time; 3=Keeping house; 4=Unemployed, looking for work; 5=Unemployed, not looking for work; 6=Disabled; 7=Retired; 8=Student, full time; 9=Student, part time; 10=Other; 11 =Unemployed; 99=Not in household; 12 = Self-employed
Query dem_09a Integer Recommended Mother highest occupation 1::8;99 1=Higher executive, proprietor of large concern, major professional; 2=Business manager or large concern, proprietor of medium-sized business, lesser professiona;l 3=Administrative personnel, owner of small independent business, minor professional; 4=Clerical or sales worker, technician, owner of little business;5=Skilled manual employee; 6=Machine operator, semi-skilled employee; 7=Unskilled employee; 8=farm laborers, menial service workers, students, housewives, (dependent on welfare, no regular occupation); 99=Not ascertained; 9 = Not in household job_moh
Query dem_09b Integer Recommended Father highest occupation 1::9;99 1=Higher executive, proprietor of large concern, major professional; 2=Business manager or large concern, proprietor of medium-sized business, lesser professiona;l 3=Administrative personnel, owner of small independent business, minor professional; 4=Clerical or sales worker, technician, owner of little business;5=Skilled manual employee; 6=Machine operator, semi-skilled employee; 7=Unskilled employee; 8=farm laborers, menial service workers, students, housewives, (dependent on welfare, no regular occupation); 99=Not ascertained; 9 = Not in household job_fahi
Query dem_10 Integer Recommended Income from public assistance
0;1
1=Yes 0=No
Query dem_11a Integer Recommended Mother level of education 1::9; 99 1=Eighth grade or less; 2=Some high school ; 3=High school graduate or GED; 4=Some college or post-high school; 5=College graduate; 6=Advanced graduate or professional degree; 7=Attended grade school, not through 8th grade; 8=Some post-graduate training, no degree; 9=No schooling; 99=Information not available ed_mo
Query dem_11b Integer Recommended Father level of education 1::9; 99 1=Eighth grade or less; 2=Some high school; 3=High school graduate or GED; 4=Some college or post-high school; 5=College graduate; 6=Advanced graduate or professional degree; 7=Attended grade school, not through 8th grade; 8=Some post-graduate training, no degree; 9=No schooling; 99=Information not available ed_fa
Query dem_12 Integer Recommended Parents marital status 1::7 1=Married/common law 2=Not married, living together 3=Separated 4=Divorced/annulled 5=Widowed ; 6=Never married, not living with someone; 7=other
Query dem_13 Integer Recommended Number of years married / living together
Query dem_14 Integer Recommended Parental separations or divorces
Query dem_15 Integer Recommended Number different foster homes
Query dem_16a Integer Recommended Current mother problems 1::5;99 1=Never had any mental or nervous problems 2=Had mental or nervous problems, but was never seen by a doctor or counselor for this 3=Had mental or nervous problems and received outpatient treatment and/or medication for this 4=Had nervous or mental problems and received hospitalization and inpatient treatment only once 5=Had nervous or mental problems and received more than one hospitalization and/or commitment to a psychiatric hospital 99=Unknown
Query dem_16b Integer Recommended Current father problems 1::5;99 1=Never had any mental or nervous problems 2=Had mental or nervous problems, but was never seen by a doctor or counselor for this 3=Had mental or nervous problems and received outpatient treatment and/or medication for this 4=Had nervous or mental problems and received hospitalization and inpatient treatment only once 5=Had nervous or mental problems and received more than one hospitalization and/or commitment to a psychiatric hospital 99=Unknown
Query dem_17a Integer Recommended Biologic mother problems 1::5;99 1=Never had any mental or nervous problems 2=Had mental or nervous problems, but was never seen by a doctor or counselor for this 3=Had mental or nervous problems and received outpatient treatment and/or medication for this 4=Had nervous or mental problems and received hospitalization and inpatient treatment only once 5=Had nervous or mental problems and received more than one hospitalization and/or commitment to a psychiatric hospital 99=Unknown
Query dem_17b Integer Recommended Biologic father problems 1::5;99 1=Never had any mental or nervous problems 2=Had mental or nervous problems, but was never seen by a doctor or counselor for this 3=Had mental or nervous problems and received outpatient treatment and/or medication for this 4=Had nervous or mental problems and received hospitalization and inpatient treatment only once 5=Had nervous or mental problems and received more than one hospitalization and/or commitment to a psychiatric hospital 99=Unknown
Query dem_18a Integer Recommended ADD or hyperactivity 0;1 1=Yes 0=No
Query dem_18b Integer Recommended LD dyslexia or learning problems 0;1 1=Yes 0=No
Query dem_18c Integer Recommended Behavior / discipline problems school 0;1 1=Yes 0=No
Query dem_18d Integer Recommended Behavior / discipline problems home 0;1 1=Yes 0=No
Query dem_18e Integer Recommended Problems with alcohol use or abuse 0;1 1=Yes 0=No
Query dem_18f Integer Recommended Problems with drug use or abuse 0;1 1=Yes 0=No
Query dem_18g Integer Recommended Aggression or conduct disorder 0;1 1=Yes 0=No
Query dem_18h Integer Recommended Problems with the law 0;1 1=Yes 0=No
Query dem_18i Integer Recommended Jail due to problems with the law 0;1 1=Yes 0=No
Query dem_18j Integer Recommended Muscle twitches or motor tics 0;1 1=Yes 0=No
Query dem_18k Integer Recommended Tourettes Syndrome 0::4 1=Yes; 0=No; 2=Current;3=In partial remission; 4=Past
Query dem_18l Integer Recommended Anxiety 0;1; 999 1=Yes; 0=No; 999=missing
Query dem_18m Integer Recommended Depression 0;1 1=Yes 0=No
Query dem_18n Integer Recommended Alternating mania and depression 0;1 1=Yes 0=No
Query dem_18o Integer Recommended Suicide 0;1 1=Yes 0=No
Query dem_18p Integer Recommended Obsessive thoughts or compulsions 0;1 1=Yes 0=No
Query dem_18q Integer Recommended Nervous breakdown 0;1 1=Yes 0=No
Query dem_18r Integer Recommended Hospitalized for emotional problems 0;1;9 1=Yes; 0=No; 9=Don't Know
Query dem_18s Integer Recommended Other psych / behavior problems 0;1 1=Yes 0=No
Query dem_18t Integer Recommended Mental retardation 0;1 1=Yes 0=No
Query emp_01 Integer Recommended Employment update visit: Change in Employment 0;1 1=Yes 0=No
Query emp_02 Integer Recommended Employment update visit: Mother current employment 1::10;99 1 = Working full time (35 hrs or more a week at one or more jobs) 2 = Working part time 3 = Keeping house 4 = Unemployed, looking for work 5 = Unemployed, not looking for work 6 = Disabled 7 = Retired 8 = Student, full time 9 = Student, part time 10 = Other: 99 = Not in household
Query emp_03 Integer Recommended Employment update visit: Mother highest occupation 1::8;99 1 = Higher executive; proprietor of large concern, major professional 2 = Business manager of large concern, proprietor of medium-sized business, lesser professional 3 = Administrative personnel, owner of small independent business, minor professional 4 = Clerical or sales worker, technician, owner of little business 5 = Skilled manual employee 6 = Machine operator, semi-skilled employee 7 = Unskilled employee 8 = Never worked in paid employment 99 = Not ascertained
Query emp_04 Integer Recommended Date of employment status change in days from the randomization date (EMP_04 = date of employment status change - randomization date)
session_id String 20 Recommended session ID/screening ID screeningid
version_form String 100 Recommended Form used/assessment name form_name
Query vis_type Integer Recommended Visit type 0::2 1=Phone; 0=doctor's office; 2=No, not phone interview phone
Query days_baseline Integer Recommended Days since baseline date
Query educat Float Recommended Number of years in formal education 999=Unknown/Missing school, years_of_school
Query education_level Integer Recommended Highest level of education completed for adult subject 1::6; 9 1 = Grades 1 to 11; 2 = High school graduate or GED; 3 = Associate or technical degree; 4 = Bachelor's degree; 5 = Master's degree; 6 = Doctorate or equivalent professional degree; 9 = Unknown degree
totincom String 40 Recommended Monthly household income income
Query week Float Recommended Week in level/study 99=week 10-week 14
Query visday Integer Recommended Number of days from study baseline to date of visit daygeninfo
otherrace String 100 Recommended specify other race The following questions are about you or the child's family. raceoth, racespec
Query liveswith_scid String 30 Recommended Lives with: livwith
jobh String 150 Recommended job title
Query grade_highed String 50 Recommended Grade/Highest education 1 = Less than 6th grade; 2 = Some high school; 3 = High school diploma or GED; 4 = Some college, no degree; 5 = Associate's degree; 6 = Bachelor's degree; 7 = Some graduate school; 8 = Master's degree and above; 9=Some post-graduate training, no degree; 10=Completed 8th grade, no high school; 99=Information not available; 11= High schoo;l 12= College or University; 13= Graduate school; 14= Other; 15 = Less than high school ed_pt, educ
Query p_p2job String 100 Recommended What is his/her primary occupation? If unemployed or disabled, list his/her past occupation occode
Query resp_employmentstatus Integer Recommended Respondent's employment status 1::6 1 = Working at a full-time paid job (35 or more hours a week); 2 = Working at a part-time paid job (less than 35 hours a week); 3 = A full-time student (3 or more class/semester); 4 = A part-time student (1 or 2 classes/semester); 5 = Not currently working; 6 = Other
Query ses Integer Recommended Hollingshead SES Score SES at age of entry to study
Query sestot Integer Recommended Socio-Economic Status (SES) 1::5 1 = SES score of 08 to 19;2 = SES score of 20 to 29;3 = SES score of 30 to 39;4 = SES score of 40 to 54;5 = SES score of 55 to 66
Query refothers String 50 Recommended Referral source: specify
Query respondent String 20 Recommended Respondent
Mother;Father;Both; Child; Other; Parent
Query respondent_other_specify String 50 Recommended Respondent: Other (specify) nfogeninfo
Query race_c Integer Recommended Race in two category (white only vs. other) 1;2 1=White alone; 2=other racebi, racebi_m
Query sestotbi Integer Recommended Dichotomous SES variable 0;1 0 = SES 1-3;1 = SES 4-5
Query referral_d Integer Recommended Referral Derived 1::12 Changed documentation to 1-12 to match the data file (was 0-11).1 = Newspaper Ad;2 = Poster/Brochure;3 = Radio Ad;4 = Inpatient Unit;5 = Outpatient Clinic;6 = Private clinician;7 = Other;8 = Internet/Website;9 = Television Ad;10 = School Staff;11 = Friend;12 = Seminar
Query referraltri Integer Recommended Trichotomous Referral Variable 0::2 0 = Other;1 = Through Ads/Outreach;2 = Through Referral
Query agebi Integer Recommended Dichotomous Age Variable 0;1 0 = Child (7-12 years);1 = Adolescent (13-17 years)
Query relationship Integer Recommended Relationship of respondent to individual
1::93;-999
1 = Biological mom; 2 = Biological dad; 3 = Grandparent; 4 = Special education (sped) teacher; 5 = General education teacher; 6 = Occupational therapist; 7 = Speech and language therapist; 8 = Behavioral therapist; 9 = Paraprofessional; 10 = Aide; 11 = Principal; 12 = Administrator; 13 = Other; 14 = Content teacher; 15 = Parent center director; 16 = Self; 17=Adoptive mother; 18=Adoptive father; 19=Foster mother; 20 = Foster father; 21=Grandmother; 22=Grandfather; 23=Step-mother; 24 = Step-father; 25=Aunt; 26=Uncle; 27=Missing Data; 28=Both parents;31= Grandmother from mother side; 32= Grandfather from mother side; 33= Grandmother from father side; 34= Grandfather from father side; 36= Brother; 37= Sister; 38= Cousin; 39= female caregiver; 40=male caregiver; 41=Female child; 42=Male child; 43=Spouse/Mate; 44=Friend; 45=Parent; 46=Significant other; 47=Sibling; 48=Son/Daughter; 49=Son-in-law/Daughter-in law; 50=Other Relative; 51=Paid caregiver; 52=Friends; 53=Roommate; 54=Supervisor; 55=mother's boyfriend; 56=other parental figure; 57=Summary; 58=counselor ; 59 = other female relative; 60 = other male relative; 61 = non-relative ; 62=Maternal Aunt; 63=Maternal Uncle; 64=Maternal Cousin; 65 = Paternal Aunt; 66=Paternal Uncle; 67=Paternal Cousin ; 68=Biological/Adoptive Mother and Grandmother; 69=Biological/Adoptive Mother and Stepmother and Grandmother; 70=Biological/Adoptive Mother and Grandmother and Foster Father; 71=Biological/Adoptive Mother and Stepmother and Foster Mother; 72=Biological/Adoptive Mother and Foster Mother; 73=Biological/Adoptive Mother and Biological/Adoptive Father; 74=Biological/Adoptive Mother and Stepmother and Biological/Adoptive Father; 75=Biological/Adoptive Mother and Other; 76=Biological/Adoptive Mother and Stepmother and Stepfather; 77=Biological/Adoptive Mother and Stepfather; 78=Biological/Adoptive Mother and Grandfather; 79=Biological/Adoptive Mother and Stepmother and Foster Father; 80=Biological/Adoptive Mother and Stepmother; 81=Guardian, female; 82=Other female; 83=Guardian, male; 84=Other male; 85=Other/Grandparent/Nanny; 86 = Mother, Father, Guardian; 87 = Daughter, son, grandchild; 88 = Professional (e.g., social worker, nurse, therapist, psychiatrist, or group home staff); 90=Other; -999=Missing; 89 = Biological parent; 91 = Stepparent; 92 = Adoptive parent; 93 = Foster parent
Query rcsestot Integer Recommended Hollingshead Socio-Economic Status (SES) Total Score (Recoded) 1::5 1 = SES score of 08 to 19; 2 = SES score of 20 to 29; 3 = SES score of 30 to 39; 4 = SES score of 40 to 54; 5 = SES score of 55 to 66
comments_misc String 4,000 Recommended Miscellaneous comments on study, interview, methodology relevant to this form data
Query imputation Integer Recommended Indicator noting imputed data set number 1::20
date_updated Date Recommended Date record updated edit_date
Query das1ms String 200 Recommended Marital status
Query living_notes String 255 Recommended Living arrangements (specify) res_oth
Query residenc1 Integer Recommended Patients Current Residence 1;2;3;4;5;6;7 1=Living alone; 2=Supported living arrangement; 3=Structured environment; 4=Family of origin; 5=Family of orientation; 6=Other relatives; 7=Other living situation residenc
Query job_pthi Integer Recommended Level of Occupation. Patient highest 1;2;3;4;5;6;7;9; 99 1=Higher executive, proprietor of large concern, major professional; 2=Business manager or large concern, proprietor of medium-sized business, lesser professiona;l 3=Administrative personnel, owner of small independent business, minor professional; 4=Clerical or sales worker, technician, owner of little business;5=Skilled manual employee; 6=Machine operator, semi-skilled employee; 7=Unskilled employee; 8=farm laborers, menial service workers, students, housewives, (dependent on welfare, no regular occupation); 99=Not ascertained; 9 = Not in household
Query job_ptcu Integer Recommended Level of Occupation. Patient current 1::9; 99 1=Higher executive, proprietor of large concern, major professional; 2=Business manager or large concern, proprietor of medium-sized business, lesser professiona;l 3=Administrative personnel, owner of small independent business, minor professional; 4=Clerical or sales worker, technician, owner of little business;5=Skilled manual employee; 6=Machine operator, semi-skilled employee; 7=Unskilled employee; 8=farm laborers, menial service workers, students, housewives, (dependent on welfare, no regular occupation); 99=Not ascertained; 9 = Not in household
Query surfqha Integer Recommended Dollar amount for other social welfare fin_wel
Query surfqea Float Recommended Dollar amount for SSI fin_ssi
Query other_amount Float Recommended Dollar amount per month fin_oth
Query fin_pt Float Recommended Patients current sources of finacial support-Patient (including earnings, unemployment benefits)
Query fin_fam Float Recommended Patients current sources of finacial support-Family Members
Query fin_tot Float Recommended Patients current sources of finacial support-TOTAL
Query longest Integer Recommended longest lasting job in months job_len
Query begin_pd Integer Recommended When did patient begin regular paid employment? 1;2;3 1=During or before adolescence; 2=After 20 years of age; 3=Never had regular paid employment
cg_work_hours String 255 Recommended Number of hours worked per week for Pay job_hr
spc_ptcu String 255 Recommended Specify Occupation and Size of Business- Patient current
spc_mohi String 255 Recommended Specify Occupation and Size of Business- Mother highest
spc_fahi String 255 Recommended Specify Occupation and Size of Business- Father highest
Query con_dx Float Recommended Consensus DSM-IV Diagnosis code 295.0 = Schizophrenia, NOS; 295.1=Schizophrenia, Disorganized Type; 295.2=Schizophrenia, Catatonic Type; 295.3=Schizophrenia, Paranoid Type; 295.4=Schizophreniform Disorder; 295.6=Schizophrenia, Residual Type; 295.7=Schizoaffective Disorder; 295.9=Schizophrenia, Undifferentiated Type
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 dav1dhs
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
spc_pthi String 255 Recommended Specify Occupation and Size of Business-Patient Highest
Query rlhqlql Integer Recommended Patient's status is childbearing potential
1;2;9
1=No; 2=Yes; 9=unknown chdpot
Query numchild Integer Recommended number of children
Query dem14 Integer Recommended Household income 1::4 1=24,999 or less; 2=25,000 - 49,999; 3=50,000 - 74,999; 4=75,000 or greater
Query country_origin String 100 Recommended Country of Origin
Query born_us Integer Recommended Were you born in the United States 0;1 0=No;1=Yes
Query ustime Integer Recommended How long you lived in US, years
Query read_eng Integer Recommended How well do you read English 0::3; 8; 9 0 = Poor; 1 = Fair; 2 = Good; 3 = Excellent; 8 = Don¿t know; 9 = Refused
Query write_eng Integer Recommended How well do you write in English 0::3; 8; 9 0 = Poor; 1 = Fair; 2 = Good; 3 = Excellent; 8 = Don¿t know; 9 = Refused
Query speak_eng Integer Recommended How well do you speak English? ¿Qué tan bien habla usted el inglés? 0::3; 8; 9 0 = Poor/Mal; 1 = Fair/Regular; 2 = Good/Bien; 3 = Excellent/Excelente; 8 = Don't Know/No se; 9 = Refused/Niego contestar
Query dem_ptd Integer Recommended Days from date of negative pregnancy test to baseline visit date
Query totaladults Integer Recommended How many total adults are in the home, including PCG?
Query zipdist Float Recommended Distance between home to clinic in miles
Query proccode Integer Recommended Procedure/rationale code for educational placement 1::4 1=IEIS data collected before Week 4; 2=No IEIS data collected - Demographic data used with confirmation; 3=IEIS was collected later than 4 Weeks into the study and matched demographic information; 4=IEIS was collected later than 4 weeks into the study, and conflicted with demographic data regarding placement. Resolved by using all information available.
Query eduplace Integer Recommended Educational placement code 1::9 1=Full time Regular Ed without aide; 2=Full time Regular Ed with aide; 3=Regular Ed with "pull out" for certain subjects; 4=Special Ed classroom(minimal or no inclusion); 5=Special School (grade school);6=Home School; 7=Special Preschool; 8=Regular Preschool; 9=No School
Query fdi_q19 Integer Recommended Household income 1 :: 13 1=$20,000 or less; 2=$20,001-$40,000; 3=$40,001-$60,000; 4=$60,001-$80,000; 5=$80,001-$100,000; 6=$100,001 - $125,000; 7=$125,001-$150,000; 8=$150,000-$200,000; 9=$200,000 or higher; 10=I don't know; 11=I prefer not to answer; 12 = $60,001 - $90,000;13 = More than $90,000
Query dadempl Integer Recommended In the current household, which of the following best describes the father's (father figure) current employment status? 1::91 1 = Working full time 2 = Working part time 3 = Unemployed, looking for work 4 = Unemployed, not looking for work 5 = Keeping house 6 = Disabled 7 = Retired 8 = Student, full time 9 = Student, part time 10 = Other 62 = Disabled and working part time 81 = Student full time and working full time 82 = Student full time and working part time 91 = Student part time and working full time
Query psysoc_214 String 160 Recommended Employment: Other1:
Query psysoc_217 String 160 Recommended Employment: Other2:
Query pre001 Integer Recommended Was a pregnancy test done? 0;1; 3; -9 0=No; 1=Yes; -9 =unknown; 3=N/A
Query ifna Integer Recommended If N/A checked (pregnancy test), please select one reason 1::3 1 = Male; 2 = Premanarche; 3 = Other (specify)
Query specify String 200 Recommended If "Other", (pregnancy test N/A) specify - TEXT
Query pre004 Integer Recommended Pregnancy Test Result 1;2;9;-9 1=Positive; 2=Negative; 9=Equivocal; -9=Unknown
Query chi_living_other String 255 Recommended child living arrangement_other Other living arrangement
Query eop10 Integer Recommended Investigators Signature Day signed: Number of days from study baseline to date investigator's signature was obtained
Query recscore String 150 Recommended Recruitment score
race_someother String 100 Recommended What race {do you/[if asked of proxy: does Subject Person]} consider {yourself/[if asked of proxy: himself/herself]} to be? SOME OTHER RACE PX010601_Race_Some_Other_Race raceothr
Query race_refuse Integer Recommended What race {do you/[if asked of proxy: does Subject Person]} consider {yourself/[if asked of proxy: himself/herself]} to be? REFUSED PX010601_Race_Refused
1;2
1=Yes; 2=No raceref
resp_ethnicity String 30 Recommended Respondent's ethnicity
Hispanic or Latino;Not Hispanic or Latino;Unknown or not reported
Query gender_identify Integer Recommended What is your current gender? 1::7 1= Male; 2= Female; 3= TransMale/Transman; 4= TransFemale/Transwoman; 5= Genderqueer; 6= Additional category; 7= Decline to state
gender_identity_descrip String 50 Recommended What is your gender? specify gender_spec
Query current_residence Integer Recommended What best describes your current residence? 1::7 1= House; 2= Rowhouse or townhouse; 3= Mobile home; 4= Apartment or condominium; 5= Communal housing (e.g., dormitory, co-op, boarding house, etc.); 6= Healthcare facility or nursing home; 7= Homeless
Query length_residence Integer Recommended How long have you lived at your current residence? 0;1 0= Less than 2 years; 1= 2 or more years
Query months_residence Integer Recommended How many months have you lived at your current residence?
Query financial_support Integer Recommended What is your annual household income? 1::5 1= $0 - $24,999; 2= $25,000 - $49,999; 3= $50,000 - $74,999; 4= $75,000 - $99,999; 5= $100,000 or more
Query degree Integer Recommended What type of college degree do you have? 1::5 1 = Associate ; 2 = Bachelors; 3 = Masters; 4 = Doctorate; 5 = Other (specify)
Query residence_length Integer Recommended How long has your family lived in your current home? years_residence
Query marriage_status Integer Recommended What is your current marital status? 1::6 1= Never married; 2= Cohabiting with partner; 3= Married; 4= Separated; 5= Divorced; 6= Widowed
Query household_number_in_house Integer Recommended Number of people living in primary residence for subject (proband) total_household
Query empl Integer Recommended Current employment status 1::21; -7 1=Unemployed not looking for employment; 2=Unemployed looking for employment; 3=Full time employed for pay; 4=Part time employed for pay; 5=Self employed for pay; 6=Retired not working; 7=Unemployed, volunteer work; 8=Unemployed, disabled; 9=Other, specify -7=Refused; 10= Paid employment or self-employed; 11= Voluntary employment; 12= Sheltered/Welfare employment; 13= Unemployed; 14= Student; 15= Other; 16= Stay-at-home Parent; 17= Part-Time Student; 18= Receiving Disability/ Unemployed; 19= Receiving Disability with Part-Time Employment; 20= Retired, Part-Time Employment; 21= Retired, Unemployed employment
Query student Integer Recommended Currently a student 0::2 0=No; 1=Yes; 2=Part time
Query medcaidb Integer Recommended Medicaid: Medicaid managed care 0;1 0 = No; 1 = Yes medicare
Query insmedc Integer Recommended Medicaire 0;1 0 = Not Checked; 1 = Checked; medicaid
Query inspp Integer Recommended Private plan (e.g., BC/BS, Aetna) 0;1 0 = Not Checked; 1 = Checked; private_insurance
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.