Dictionary Query Tool

Take me to the DicTionary Query Tool

Instructional Video

This guide walks you through how to use the Dictionary Query Tool in Lasso to efficiently build and download tabular datasets and the data dictionary.

Basic Workflow

  1. Go to the All Study Data Search & Filter Module in the left-hand menu bar
  1. Click Dictionary Query Tool in the top right-hand corner
  1. Search for the variable of interest using the search bar
  1. Drag selected variable over to the Selected Tabulated Data box on the right-hand side of the screen
  1. Click Download Data  
  1. Click Download Data Dictionary

Optional Features

Explore & Filter Variables

  • Use column-level filters to locate specific variables of interest.  
  • You can filter by domain, table name, source and more.

For help understanding column labels, see the table at the bottom of this document.

Export the Data Dictionary

You can download the data dictionary or codebook for all variables in the study by:

  1. Clicking the “Download” button at the top of your screen

You can also download the data dictionary for the specific variables you queried by:

  1. Clicking “Download Data Dictionary” button next to the Download Data button to generate a dictionary only for the instruments currently selected  

What do the column names mean in the Lasso Dictionary Query Tool?

  • domain: This indicates the broad category to which a measure belongs.
  • Table_label: The title or label assigned to the measure.
  • Source: The origin of the data for the measure, such as responses from a parent or youth.
  • Table_name: The name given to the measure.
  • Name: The variable name associated with the measure.
  • Description: The specific question or column description related to the variable.
  • Levels: This reflects the number of response categories or levels of measurement for categorical variables.
  • Type_level: Describes the scale type of the variable (e.g., ordinal, nominal).
  • Type_data: Indicates the data type of the variable (e.g., timestamp, character, integer).
  • Type_var: Defines the general category of the variable (e.g., administrative data, summary score).
  • Type_field: Explains how the field was presented to participants (e.g., dropdown, check-all-that-apply).
  • Order_display: The sequence in which the variable/question appeared to participants within the measure.
  • Branching_logic: Logic that determines whether the variable/question is shown based on participant responses.
  • Instruction: The instructions that appeared before all the items in the measure.
  • Identifier_column: Identifies column names used as unique identifiers for the variable.
  • Order_sort: Standardized sort order for columns within a measure; controls column sequencing in the data.
  • Note: Notes provided to participants regarding the column/variable/question.
  • url_table_warn_data: A hyperlink pointing to a warning about data issues for the associated table in the wiki.
  • url_warn_data: Hyperlink to general data issue warnings in the wiki.
  • url_table_warn_use: Hyperlink to guidance on responsible use of data specific to the table.
  • Url_warn_use: Hyperlink to general responsible data use warnings in the wiki.
  • Study: Indicates whether the measure belongs to the core study, a sub-study, or an ancillary study.
  • Version: Specifies the data version (e.g., HBCD 1.0, ABCD 6.0).
  • subdomain: A more granular category within the broader domain.
  • header: Intermediate instructions relevant to a specific group of questions.
  • Unit: The scientific unit of measurement used for the variable (e.g., lbs., cm).
  • Metric: Specifies the particular metric being measured, often in imaging data.
  • Atlas: The cortical or fiber tract atlas referenced in the imaging data.
  • Label_es: The Spanish-language label for the measure.
  • Level_es: Spanish description of the number of response categories for categorical variables.
  • Instruction_es: Spanish version of the instructions before the measure items.
  • Header_es: Spanish translation of the intermediate instructions.
  • Note_es: Spanish note displayed to participants about the variable.
  • url_table: A hyperlink to the table’s detailed description on the wiki.
  • Table_redcap: The name of the REDCap table that includes the variable.
  • Name_redcap: The REDCap-assigned name for the column/variable.
  • Name_redcap_exp: The export-friendly name used in REDCap for the column/variable.
  • Name_DEAP: The name used for this variable in the DEAP system.
  • Table_NDA: The table to which the variable belonged in the NDA before version 5.0 (ABCD Study).
  • Table_NDA 5_0: The NDA table assignment for the variable in version 5.0 (ABCD Study).
  • Name_NDA: The variable name as used in the NDA system.