State of Clinical Trials

>> AACT Database

Using publicly available and downloadable data from, a restructured and reformatted relational database was developed. This is referred to as the database for Aggregate Analysis of (AACT). The purpose of AACT is to make the acquisition and analysis of the aggregate data from more user-friendly. CLICK HERE for an overview of the background on and the AACT database.

The AACT database extracts are available for download in three formats. Please refer to the supporting documents below for more information about how to use AACT.

ZIP files containing these database extracts may be downloaded from the links provided below:

*This dataset reflects data downloaded from March 27, 2015.

**The Readme file (located in each ZIP file) provides critical considerations for database administrators and statistical programmers regarding importing the database extracts.

***Note: This version of AACT does not include 2 tables that are normally part of the release: CONDITION_BROWSE and INTERVENTION_BROWSE. MeSH terms in these table are generated by an NLM algorithm which periodically changes. This information was incomplete at the time of the March, 2015 extract from, so has been omitted from this release.


March 2015 AACT Refresher Update Supporting Documents

  • The Comprehensive Data Dictionary 2015_March provides a complete list of data elements from the AACT database, corresponding definitions from NLM’s data element definitions document, and data model and parameters used in the AACT database. It is designed for data analysts and programmers and contains following six sections: current variables, enumerations, schema, constraints, requirements, and record counts.
  • The High Level Data Dictionary 2015_March delivers a summary view of the variables contained in the AACT database and is designed for investigators and researchers. Users may also wish to access the protocol data element definitions and results data element definitions as posted on the Protocol Registration System site; these documents provide some information related to the branching nature of the registration and results questions.


Points to Consider When Using 2015 AACT Refresher Update

The Points to Consider Document 2015_March provides guidelines for investigators to consider when planning a statistical analysis of the database. It is not intended to be a comprehensive guide. See document for information on:

  • Population: which studies are likely to be represented in the registry
  • Duplicate records
  • Data completeness and accuracy
  • Types of questions that can be investigated with the data from AACT
  • data element definitions and interpretation of these variables
  • Explanation of variables original to ("National Library of Medicine (NLM)" variables) and those added as a part of the AACT database ("CTTI" variables)
  • Integration of the MeSH thesaurus (NLM's controlled vocabulary thesaurus) into the AACT database


Examples of analyses conducted using the AACT database are available on the State of Clinical Trials > Products page.


Example Data Trend Using AACT Database:



Previous Versions of AACT are available here:

Dataset reflects data downloaded from September 27, 2014.

Dataset reflects data downloaded from March 27, 2014.

Dataset reflects data downloaded from September 27, 2013.

Dataset reflects data downloaded from September 27, 2012.

Dataset reflects data downloaded from September 27, 2011.

Dataset reflects data downloaded from September 27, 2010.


Primary Navigation

Who We Are

Who You Are

What We Do

Briefing Room

Take Action

Contact Us


Most Visited Pages

AACT Database

CTTI Webinars

CTTI Tools

CTTI Membership

CTTI Projects


Follow Us

LinkedIn     Twitter     Facebook     Vimeo


CTTI encourages the use of all materials listed on this site in the pursuit of improving the clinical trials enterprise. Our recomendations, tools, meeting summaries, and more are available to the public for free. We do ask that you acknowledge the source whenever using or referencing CTTI materials. Read our Citation Policy here.