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

Medical Visits and Hospitalizations

1,051 Shared Subjects

N/A
Clinical Assessments
Med History
07/07/2015
mvhsp01
12/05/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*
src_subject_id String 20 Required Subject ID how it's defined in lab/project aid, demo_study_id
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field 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.
sex String 20 Required Sex of the subject M;F M = Male; F = Female gender, sex
site String 101 Recommended Site Study Site asite, siteid
Query clinicid Integer Recommended Clinic ID aclinic
Query interv Integer Recommended Intervention Status 0;1 1=ITV, intervention; 0=TAU, treatment as usual
visit String 50 Recommended Visit name visitnum, wave
Query days_baseline Integer Recommended Days since baseline lof
Query vis1 Integer Recommended How many times in the past 6 months have you been a patient overnight or longer in a hospital?
Query vis1a Integer Recommended During the past 6 months, how many total nights did you stay overnight or longer in a hospital.
Query vis1b Integer Recommended Number of nights stay in a hospital for emo (collected after baseline)
Query vis2 Integer Recommended In the past 6 months, how many different visits have you made to a hospital emergency room or an urgent care facility?
Query vis3a Integer Recommended In the past 6 months, how many clinic or office visits did you make to a primary care provider such as a family doctor, general internist, gynecologist, nurse or nurse practitioners?
Query vis3aa Integer Recommended During how many of these visits to a primary care provider in the last 6 months did you bring up or discuss personal or emotional problems such as your nerves, mood, alcohol, drugs or mental health?
Query vis3b Integer Recommended In the past 6 months, how many visits did you make to a medical specialist like a cardiologist, urologist, orthopaedist, neurologist, dermatologist?
Query vis3c Integer Recommended Now Id like to ask about visits to mental health providers. In the past 6 months, how many visits did you make to a Psychiatrist?
Query vis3d Integer Recommended In the past 6 months, how many visits did you make to a psychologist, social worker, psychotherapist, psychiatric nurse or other counselor or therapist that you havent already told me about?
Query vis4 Integer Recommended In the past 6 months, how many outpatient surgeries or outpatient medical procedures did you have?
vis4b1 String 55 Recommended Medical Procedure 1 med_surg_treatment_1, med_surg_treatment_1_12mo
vis4b2 String 55 Recommended Medical Procedure 2 med_surg_treatment_2, med_surg_treatment_2_12mo
vis4b3 String 55 Recommended Medical Procedure 3 med_surg_treatment_3, med_surg_treatment_3_12mo
vis4b4 String 55 Recommended Medical Procedure 4 med_surg_treatment_4, med_surg_treatment_4_12mo
vis4b5 String 55 Recommended Medical Procedure 5
vis4b6 String 55 Recommended Medical Procedure 6
vis4b7 String 55 Recommended Medical Procedure 7
vis4b8 String 55 Recommended Medical Procedure 8
vis4b9 String 55 Recommended Medical Procedure 9
vis4b10 String 55 Recommended Medical Procedure 10
Query casa8y Integer Recommended Number of visits for outpatient drug or alcohol treatment or services (past 6 months) vis5
Query vis6a Integer Recommended In the past 6 months, how often did any provider help you practice directly dealing with things that made you afraid such as places, people, memories or feelings in order to become less afraid of them? 1::4 1=Never; 2=Sometimes; 3=Usually; 4=Always;
Query vis6b Integer Recommended How often did any provider teach you methods of physical relaxation, such as slow breathing? 1::4 1=Never; 2=Sometimes; 3=Usually; 4=Always;
Query vis6c Integer Recommended How often did any provider help you look at your thoughts more realistically? 1::4 1=Never; 2=Sometimes; 3=Usually; 4=Always;
Query vis6d Integer Recommended How often did any provider help you to see mistakes in your thinking for example, all or nothing thinking or always fearing the worst will happen? 1::4 1=Never; 2=Sometimes; 3=Usually; 4=Always;
Query vis6e Integer Recommended How often did any provider help you to understand how your thoughts and feelings are related? 1::4 1=Never; 2=Sometimes; 3=Usually; 4=Always;
Query vis6g Integer Recommended How often did any provider ask you to do homework between visits? Homework can include activities like writing down your thoughts, feelings, and activities or practicing something you learned during your visit. 1::4 1=Never; 2=Sometimes; 3=Usually; 4=Always;
Query med1opmed Integer Recommended In the past 6 months did you take ANY prescription medications at least several times a week for at least a month? Please think about prescription medications other than vitamins and antibiotics. 0;1 0=No; 1=Yes med1
Query med1a Integer Recommended Have you been taking any prescription medications to help with depression, anxiety, or sleep? 0;1 0=No; 1=Yes
Query med_chg Integer Recommended High Quality RX 0;1 High Quality RX (IF (QUARXt2=3) THEN MED_CHANGEt2=1; ELSE IF (1=<QUARXt2<=2) THEN MED_CHANGEt2 =0;)
Query qucbt1 Integer Recommended During the past 6 months, had 1 or more CBT (direct practice, physical relaxation, help look at thoughts realistically, help to see thinking mistakes, help relating thoughts and feelings, CBT homework) at the level of 2=sometimes or 3=usually or 4=always 0;1 0=No - 0 times; 1=Yes - 1 to 6 times
Query qucbt2 Integer Recommended During the past 6 months, had 3 or more CBT (direct practice, physical relaxation, help look at thoughts realistically, help to see thinking mistakes, help relating thoughts and feelings, CBT homework) at the level of 2=sometimes or 3=usually or 4=always 0;1 0=No - 0 to 2 times; 1=Yes - 3 to 6 times
Query qucbt3 Integer Recommended During the past 6 months, had 3 or more CBT (direct practice, physical relaxation, help look at thoughts realistically, help to see thinking mistakes, help relating thoughts and feelings, CBT homework) at the level of 3=usually or 4=always 0;1 0=No - 0 to 2 times; 1=Yes - 3 to 6 times
Query thosp Integer Recommended Number of hospital visists
Query tnight Integer Recommended Number of nights in the hospital
Query tenght Integer Recommended Number of emotional nights in hospital
Query srfa6g Integer Recommended Emergency Room (Medical) number of visits 0::200
Query tpcrvs Integer Recommended Number of Primary care visits
Query tpcevs Integer Recommended Number of Emotional Primary care visists
Query tspcvs Integer Recommended Number of medical specialist visists
Query pmdvisit Integer Recommended psychiatrist number of visits tmhivs
Query tcnlvs Integer Recommended Number of visist to psychologist
Query tosurg Integer Recommended Number of outpatient surgery
Query p61i6 Integer Recommended Substance Abuse - Best estimate of number of episodes tsubst
Query ahosp Integer Recommended any hospital visits 0;1 0=No; 1=Yes
Query anight Integer Recommended any nights in hospital 0;1 0=No; 1=Yes
Query aenght Integer Recommended any emotional nights in hospital 0;1 0=No; 1=Yes
Query aervst Integer Recommended any emergency room visists 0;1 0=No; 1=Yes
Query apcrvs Integer Recommended any primary care visits 0;1 0=No; 1=Yes
Query apcevs Integer Recommended any emotional primary care visits 0;1 0=No; 1=Yes
Query aspcvs Integer Recommended any medical specialist visists 0;1 0=No; 1=Yes
Query amhivs Integer Recommended any visit to psychiatrist 0;1 0=No; 1=Yes
Query acnlvs Integer Recommended any-visit to psychologist 0;1 0=No; 1=Yes
Query aosurg Integer Recommended any-outpatient surgery 0;1 0=No; 1=Yes
Query ysua Integer Recommended Abuse. Other drug abuse/dependence. Diagnosis for other substance abuse 0 :: 1 0 = Absent; 1 = Present asubst
version_form String 100 Recommended Form used/assessment name
Query hrumed Integer Recommended Medical (MD/DO/Prescriber): Number of Visits in the past 2 months
Query hrupsyc Integer Recommended Psychiatric (MD/DO/Prescriber): Number of Visits in the past 2 months
Query hrunurse Integer Recommended Nursing: Number of Visits in the past 2 months
Query hrucase Integer Recommended Case Management: Number of Visits in the past 2 months
Query hruclinic Integer Recommended Clinician/Therapy/Counseling/Group Therapy/Substance Abuse Treatment: Number of Visits in the past 2 months
Query hruserv Integer Recommended Acute Services (medical or psychiatric): Number of Visits in the past 2 months
Query hruhosp Integer Recommended Day Hospital/Day Treatment Center: Number of Visits in the past 2 months
medication1_name String 500 Recommended Name first medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_medication_1, med_medication_1_12mo
medication1_dosage String 100 Recommended First medication dosage 0 = No medication; 999 = Missing med_dose_1, med_dose_1_12mo
medication1_frequency String 50 Recommended First medication frequency med_frequency_1, med_frequency_1_12mo
strreason1 String 500 Recommended Reason for prescription 1 med_condition_1, med_condition_1_12mo
med_change_notes String 250 Recommended What medication changes? med_recent_changes_1, med_recent_changes_1_12mo
medication2_name String 200 Recommended Name second medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_medication_2, med_medication_2_12mo
medication2_dosage String 100 Recommended Second medication dosage 0 = No medication; 999 = Missing med_dose_2, med_dose_2_12mo
medication2_frequency String 50 Recommended Second medication frequency med_frequency_2, med_frequency_2_12mo
strreason2 String 350 Recommended Reason for prescription 2 med_condition_2, med_condition_2_12mo
change_reason String 100 Recommended Reason for change original medication med_recent_changes_2, med_recent_changes_2_12mo
medication3_name String 150 Recommended Name third medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_medication_3, med_medication_3_12mo
medication3_dosage String 100 Recommended Third medication dosage 0 = No medication; 999 = Missing med_dose_3, med_dose_3_12mo
medication3_frequency String 50 Recommended Third medication frequency med_frequency_3, med_frequency_3_12mo
strreason3 String 350 Recommended Reason for prescription 3 med_condition_3, med_condition_3_12mo
medication4_name String 100 Recommended Name fourth medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_medication_4, med_medication_4_12mo
medication4_dosage String 100 Recommended Fourth medication dosage 0 = No medication; 999 = Missing med_dose_4, med_dose_4_12mo
medication4_frequency String 50 Recommended Fourth medication frequency med_frequency_4, med_frequency_4_12mo
strreason4 String 255 Recommended Reason for prescription 4 med_condition_4, med_condition_4_12mo
medication5_name String 500 Recommended Name fifth medication that the participant has taken 0 = No medication; 999= Legitimately skipped med_medication_5, med_medication_5_12mo
medication5_dosage String 100 Recommended Fifth medication dosage 0 = No medication; 999 = Missing med_dose_5, med_dose_5_12mo
medication5_frequency String 50 Recommended Fifth medication frequency med_frequency_5, med_frequency_5_12mo
strreason5 String 255 Recommended Reason for prescription 5 med_condition_5, med_condition_5_12mo
mdga20a String 150 Recommended Medical Illness 1 med_past_what_diagnosis_1, med_past_what_diagnosis_1_12mo
strillness1 String 100 Recommended Date of 1st illness med_past_date_1, med_past_date_1_12mo
otherpasttreatmentintervent1_1 String 100 Recommended Other Past Treatment 1 Intervention med_past_treatment_1, med_past_treatment_1_12mo
mdga20b String 150 Recommended Medical Illness 2 med_past_what_diagnosis_2, med_past_what_diagnosis_2_12mo
strillness2 String 100 Recommended Date of 2nd illness med_past_date_2, med_past_date_2_12mo
otherpasttreatmentintervent2_1 String 100 Recommended Other Past Treatment 2 Intervention med_past_treatment_2, med_past_treatment_2_12mo
mdga20c String 150 Recommended Medical Illness 3 med_past_what_diagnosis_3, med_past_what_diagnosis_3_12mo
strillness3 String 100 Recommended Date of 3rd illness med_past_date_3, med_past_date_3_12mo
otherpasttreatmentintervent3_1 String 100 Recommended Other Past Treatment 3 Intervention med_past_treatment_3, med_past_treatment_3_12mo
mdga20d String 150 Recommended Medical Illness 4 med_past_what_diagnosis_4, med_past_what_diagnosis_4_12mo
strillness4 String 100 Recommended Date of 4th illness med_past_date_4, med_past_date_4_12mo
otherpasttreatmentintervent4_1 String 100 Recommended Other Past Treatment 4 Intervention med_past_treatment_4, med_past_treatment_4_12mo
mdga20e String 150 Recommended Medical Illness 5 med_past_what_diagnosis_5, med_past_what_diagnosis_5_12mo
otherpasttreatmentintervent5_1 String 100 Recommended Other Past Treatment 5 Intervention med_past_treatment_5, med_past_treatment_5_12mo
strreasonhosp1 String 50 Recommended Reason for 1st hospitalization. med_surg_what_1, med_surg_what_1_12mo
dtmstarthosp1 String 100 Recommended Date 1st hospitalization began med_surg_date_1, med_surg_date_1_12mo
strreasonhosp2 String 50 Recommended Reason for 2nd hospitalization. med_surg_what_2, med_surg_what_2_12mo
dtmstarthosp2 String 100 Recommended Date 2nd hospitalization began med_surg_date_2, med_surg_date_2_12mo
strreasonhosp3 String 50 Recommended Reason for 3rd hospitalization. med_surg_what_3, med_surg_what_3_12mo
dtmstarthosp3 String 100 Recommended Date 3rd hospitalization began med_surg_date_3, med_surg_date_3_12mo
strreasonhosp4 String 50 Recommended Reason for 4th hospitalization. med_surg_what_4, med_surg_what_4_12mo
dtmstarthosp4 String 100 Recommended Date 4th hospitalization began med_surg_date_4, med_surg_date_4_12mo
comments_misc String 4,000 Recommended Miscellaneous comments on study, interview, methodology relevant to this form data med_comments, med_comments_12mo
respondent_other_specify String 50 Recommended Respondent: Other (specify) med_completed_by_other_12mo
med_health_past_weeks String 300 Recommended How has your health been over the past few weeks? med_health_past_weeks_12mo
Query med_asked_not_to_take_1 Integer Recommended med1 - Asked not to take on Scan Day 1 1 = Asked not to take med_asked_not_to_take_1_12mo
Query med_asked_not_to_take_2 Integer Recommended med2 - Asked not to take on Scan Day 1 1 = Asked not to take med_asked_not_to_take_2_12mo
med_recent_changes_3 String 100 Recommended med3 - Recent Changes med_recent_changes_3_12mo
Query med_asked_not_to_take_3 Integer Recommended med3 - Asked not to take on Scan Day 1 1 = Asked not to take med_asked_not_to_take_3_12mo
med_recent_changes_4 String 100 Recommended med4 - Recent Changes med_recent_changes_4_12mo
Query med_asked_not_to_take_4 Integer Recommended med4 - Asked not to take on Scan Day 1 1 = Asked not to take med_asked_not_to_take_4_12mo
med_recent_changes_5 String 100 Recommended med5 - Recent Changes med_recent_changes_5_12mo
Query med_asked_not_to_take_5 Integer Recommended med5 - Asked not to take on Scan Day 1 1 = Asked not to take med_asked_not_to_take_5_12mo
Query med_past_resolved_1 Integer Recommended illness1 - Resolved 1 1 = Yes med_past_resolved_1_12mo
Query med_past_resolved_2 Integer Recommended illness2 - Resolved 1 1 = Yes med_past_resolved_2_12mo
Query med_past_resolved_3 Integer Recommended illness3 - Resolved 1 1 = Yes med_past_resolved_3_12mo
Query med_past_resolved_4 Integer Recommended illness4 - Resolved 1 1 = Yes med_past_resolved_4_12mo
med_past_date_5 String 100 Recommended illness5 - Date med_past_date_5_12mo
Query med_past_resolved_5 Integer Recommended illness5 - Resolved 1 1 = Yes med_past_resolved_5_12mo
Query aescode Integer Recommended Staff code number of person completing this form med_completed_by, med_completed_by_12mo
rev_immunomedallergymed String 255 Recommended Medication Allergies: Medications med_allergies, med_allergies_12mo
chf_05 String 250 Recommended Type of other treatment med_other_tx, med_other_tx_12mo
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.