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

Medication Accountability Form

399 Shared Subjects

N/A
Clinical Assessments
Treatment
04/13/2015
mac01

View Change History
01
Query Element Name Data Type Size Required Description Value Range Notes Aliases
subjectkey GUID Required The NDAR Global Unique Identifier (GUID) for research subject NDAR*
src_subject_id String 20 Required Subject ID how it's defined in lab/project randid
interview_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
study String 100 Recommended Study studyid
site String 101 Recommended Site Study Site siteid
visit String 50 Recommended Visit name int1
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 prescript_letter String 1 Recommended Prescription letter A;B;C;D;E
Query pmstdt Integer Recommended Date medication/treatment began in days from the randomization date prescript_stdt
Query pmstop Integer Recommended Date medication/treatment stopped in days from the randomization date prescript_enddt
Query med_q1aa Integer Recommended Prescription A from bottle A 0::200
Query med_q1ab Integer Recommended Prescription A from bottle B 0::200
Query med_q1ac Integer Recommended Prescription A from bottle C 0::200
Query med_q1ad Integer Recommended Prescription A from bottle D 0::200
Query med_q1ba Integer Recommended Prescription B from bottle A 0::200
Query med_q1bb Integer Recommended Prescription B from bottle B 0::200
Query med_q1bc Integer Recommended Prescription B from bottle C 0::200
Query med_q1bd Integer Recommended Prescription B from bottle D 0::200
Query med_q1ca Integer Recommended Prescription C from bottle A 0::200
Query med_q1cb Integer Recommended Prescription C from bottle B 0::200
Query med_q1cc Integer Recommended Prescription C from bottle C 0::200
Query med_q1cd Integer Recommended Prescription C from bottle D 0::200
Query med_q1da Integer Recommended Prescription D from bottle A 0::200
Query med_q1db Integer Recommended Prescription D from bottle B 0::200
Query med_q1dc Integer Recommended Prescription D from bottle C 0::200
Query med_q1dd Integer Recommended Prescription D from bottle D 0::200
Query med_q1ea Integer Recommended Prescription E from bottle A 0::200
Query med_q1eb Integer Recommended Prescription E from bottle B 0::200
Query med_q1ec Integer Recommended Prescription E from bottle C 0::200
Query med_q1ed Integer Recommended Prescription E from bottle D 0::200
Query prescript_am Float Recommended Prescription AM
Query prescript_noon Float Recommended Prescription Noon
Query prescript_pm Float Recommended Prescription PM
Query prescript_seesub Integer Recommended Did you see the subject? 1;2 1=Yes 2=No
Query prescript_botlet String 1 Recommended Bottle letter A;B;C;D
Query prescript_botdisp Float Recommended Pills dispensed from bottle
Query prescript_botexp Float Recommended Expected returned from bottle
Query prescript_botret Float Recommended Actual returned from bottle
Query prescript_botmiss Float Recommended Missed from bottle
Query prescript_botextr Float Recommended Extra from bottle
Query prescript_botlost Float Recommended Lost from bottle
Query prescript_reteqexp Integer Recommended Did returned equal expected? 1;2 1=Yes 2=No
Query prescript_tookmed Integer Recommended Took all meds as prescribed? 1;2 1=Yes 2=No
Query med_q4a Integer Recommended Week D1 Bottle am pills 0::200
Query med_q4b Integer Recommended Week D1 Bottle noon pills 0::200
Query med_q4c Integer Recommended Week D1 Bottle pm pills 0::200
Query med_q4d Integer Recommended Week D1 Bottle pills 0::200
Query daysrz Integer Recommended days since randomization visitdt
Query week Float Recommended Week in level/study 99=week 10-week 14
Query rand_num Integer Recommended Randomization Number 0::2
Query ma_bluprop Float Recommended blue pills proportion taken 0::100
Query ma_greprop Float Recommended green pills proportion taken 0::100
Query ma_oraprop Float Recommended orange pills proportion taken 0::100
Query bludose Float Recommended Dosage per blue pill (MG)
Query gredose Float Recommended Dosage per green pill (MG)
Query apcurdose Float Recommended antipsychotic current capsules/day Current antipsychotic dose in MG
stpnm1 String 250 Recommended Study med name1 drug_name
Query mr_apsched Integer Recommended antipsychotic dosing schedule 1::6 1=qD=once a day; 2=BID=twice a day; 3=TID=three times a day; 4=QID=four times a day; 5=PRN=as needed; 6=Oth=Other
mr_apscheds String 20 Recommended antipsychotic dosing schedule, describe
Query mr_apdoseeq Integer Recommended antipsychotic are doses equal 1::3 1=yes; 2=more in morning; 3=more after noon
Query mr_apchange Integer Recommended antipsychotic change in prescribed dose 0::2 1=yes; 0=no; 2=Re-randomized
Query mr_apnewdose Integer Recommended med record 4, antipsychotic new number of capsules/day 0::8
Query mr_hospinfo Integer Recommended subject hospitalized from info gathered this visit 0;1 0=No; 1=Yes
Query mr_becurdose Float Recommended benztrpine current total dose
Query mr_besched Integer Recommended benztrpine dosing schedule 1::6 1=qD=once a day; 2=BID=twice a day; 3=TID=three times a day; 4=QID=four times a day; 5=PRN=as needed; 6=Oth=Other
Query mr_beschedprn Integer Recommended benztrpine dosing schedule PRN dosage
Query mr_bechange Integer Recommended benztrpine change in prescribed dose 0;1 0=No; 1=Yes
Query mr_benewdose Float Recommended benztrpine new dose
Query mr_trcurdose Integer Recommended trihexphenydyl current total dose
Query mr_trsched Integer Recommended trihexphenydyl dosing schedule 1::6 1=qD=once a day; 2=BID=twice a day; 3=TID=three times a day; 4=QID=four times a day; 5=PRN=as needed; 6=Oth=Other
Query mr_trschedprn Integer Recommended trihexphenydyl dosing schedule PRN dosage
Query mr_trchange Integer Recommended trihexphenydyl change in prescribed dose 0;1 0=No; 1=Yes
Query mr_trnewdose Integer Recommended trihexphenydyl new dose
Query mr_prcurdose Integer Recommended propranolol current total dose
Query mr_prsched Integer Recommended propranolol dosing schedule 1::6 1=qD=once a day; 2=BID=twice a day; 3=TID=three times a day; 4=QID=four times a day; 5=PRN=as needed; 6=Oth=Other
Query mr_prschedprn Integer Recommended propranolol dosing schedule PRN dosage
Query mr_prchange Integer Recommended propranolol change in prescribed dose 0;1 0=No; 1=Yes
Query mr_prnewdose Integer Recommended propranolol new dose
Query mr_locurdose Float Recommended lorazepam current total dose
Query mr_losched Integer Recommended lorazepam dosing schedule 1::6 1=qD=once a day; 2=BID=twice a day; 3=TID=three times a day; 4=QID=four times a day; 5=PRN=as needed; 6=Oth=Other
mr_loscheds String 20 Recommended lorazepam dosing schedule, describe
Query mr_loschedprn Integer Recommended lorazepam dosing schedule PRN dosage
Query mr_lochange Integer Recommended lorazepam change in prescribed dose 0;1 0=No; 1=Yes
Query mr_lonewdose Integer Recommended lorazepam new dose
Query mr_clcurdose Float Recommended clonazepam current total dose
Query mr_clsched Integer Recommended clonazepam dosing schedule 1::6 1=qD=once a day; 2=BID=twice a day; 3=TID=three times a day; 4=QID=four times a day; 5=PRN=as needed; 6=Oth=Other
mr_clscheds String 20 Recommended clonazepam dosing schedule, describe
Query mr_clschedprn Float Recommended clonazepam dosing schedule PRN dosage
Query mr_clchange Integer Recommended clonazepam change in prescribed dose 0;1 0=No; 1=Yes
Query mr_clnewdose Float Recommended clonazepam new dose 0::3
Query mr_antidepr Integer Recommended any concomitant meds antidepressants 0;1 0=No; 1=Yes
Query mr_moodstab Integer Recommended any concomitant meds mood stabilizers 0;1 0=No; 1=Yes
Query mr_securdose Float Recommended sertraline current total dose
Query mr_flcurdose Integer Recommended fluoxetine current total dose
Query mr_vacurdose Integer Recommended valproic acid current total dose
Query mr_varecdose Float Recommended valproic acid most recent level on dose
Query mr_licurdose Integer Recommended lithium current total dose
Query mr_lirecdose Float Recommended lithium most recent level on this dose
Query antidep1 Integer Recommended Code for antidepressant #1 30=AMITRIPTYLINE; 31=BUPROPION; 32=CITALOPRAM; 33=DESVENLAFAXINE; 34=DOXEPIN; 35 = DULOXETINE; 36=ESCITALOPRAM OXALATE; 37=FLUOXETINE; 38=FLUVOXAMINE; 39=MIRTAZAPINE; 40=NORTRIPTYLINE; 41=PAROXETINE; 42=SERTRALINE; 43=TRAZODONE; 44=VENLAFAXINE mr_antidep1
Query antidep2 Integer Recommended Code for antidepressant #2 30=AMITRIPTYLINE; 31=BUPROPION; 32=CITALOPRAM; 33=DESVENLAFAXINE; 34=DOXEPIN; 35 = DULOXETINE; 36=ESCITALOPRAM OXALATE; 37=FLUOXETINE; 38=FLUVOXAMINE; 39=MIRTAZAPINE; 40=NORTRIPTYLINE; 41=PAROXETINE; 42=SERTRALINE; 43=TRAZODONE; 44=VENLAFAXINE mr_antidep2
mr_mdstab1 String 20 Recommended mood stabilizer use 1
mr_mdstab2 String 20 Recommended mood stabilizer use 2
ssq2ed String 75 Recommended Name of antibiotics (or condition treated) mr_antibiotic
mr_anticholin String 20 Recommended anticholin use
mr_propranolol String 20 Recommended prpranolol use
benzo_name String 50 Recommended Benzodiazepines name? mr_benzo
mr_diphen String 20 Recommended Diphenhydramine use
mr_antipsych1 String 50 Recommended antipsychotic use 1
mr_antipsych2 String 50 Recommended antipsychotic use 2
mr_oth1 String 20 Recommended other drug use 1 otdrug
mr_oth2 String 20 Recommended other drug use 2
mr_oth3 String 20 Recommended other drug use 3
mr_oth4 String 20 Recommended other drug use 4
Query treat String 1 Recommended Treatment for Randomization X;Y;Z treatment
stdate1 String 20 Recommended Medication start date 1 mm/dd/yyyy or write out month year
spdate1 String 20 Recommended Medication stop date 1 mm/dd/yyyy or write out month year
Query stds1 Float Recommended Prescribed med daily dose 1
Query ma1a_ab Integer Recommended Dose 1: Active or Blinded 1;2 1=Active; 2=Blinded
stdate2 String 20 Recommended Medication start date 2 mm/dd/yyyy or write out month year
spdate2 String 20 Recommended Medication stop date 2 mm/dd/yyyy or write out month year
Query stds2 Float Recommended Prescribed med daily dose 2
Query ma1b_ab Integer Recommended Dose 2: Active or Blinded 1;2 1=Active; 2=Blinded
stdate3 String 20 Recommended Medication start date 3 mm/dd/yyyy or write out month year
spdate3 String 20 Recommended Medication stop date 3 mm/dd/yyyy or write out month year
Query stds3 Float Recommended Prescribed med daily dose 3
Query ma1c_ab Integer Recommended Dose 3: Active or Blinded 1;2 1=Active; 2=Blinded
stdate4 String 20 Recommended Medication start date 4 mm/dd/yyyy or write out month year
spdate4 String 20 Recommended Medication stop date 4 mm/dd/yyyy or write out month year
Query stds4 Float Recommended Prescribed med daily dose 4
Query ma1d_ab Integer Recommended Dose 4: Active or Blinded 1;2 1=Active; 2=Blinded
stdate5 String 20 Recommended Medication start date 5 mm/dd/yyyy or write out month year
spdate5 String 20 Recommended Medication stop date 5 mm/dd/yyyy or write out month year
stds5 String 50 Recommended Prescribed med daily dose 5
Query ma1e_ab Integer Recommended Dose 5: Active or Blinded 1;2 1=Active; 2=Blinded
stdate6 String 20 Recommended Medication start date 6 mm/dd/yyyy or write out month year
spdate6 String 20 Recommended Medication stop date 6 mm/dd/yyyy or write out month year
stds6 String 50 Recommended Prescribed med daily dose 6
Query ma1f_ab Integer Recommended Dose 6: Active or Blinded 1;2 1=Active; 2=Blinded
stdate7 String 20 Recommended Medication start date 7 mm/dd/yyyy or write out month year
spdate7 String 20 Recommended Medication stop date 7 mm/dd/yyyy or write out month year
Query stds7 Float Recommended
Query ma1g_ab Integer Recommended Dose 7: Active or Blinded 1;2 1=Active; 2=Blinded
ma3_reason String 500 Recommended Reason Medication Was Not Taken As Prescribed or How Dose Was Lost
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.