State of Clinical Trials

>> AACT Database

CTTI has aggregated and restructured publicly available data and made it available here as a relational database to facilitate analysis of the complete set of trials. This database is the Aggregate Analysis of (AACT). 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 September 27, 2015.


AACT Supporting Documents

  • Comprehensive Data Dictionary: 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 in five sections: current variables, enumerations, schema, constraints, and record counts.
  • Readme Files: Provide instructions on how to implement AACT as well as critical info for database administrators and statistical programmers. (The Readme files are located in each ZIP file above.)
  • NLM documentation: Thorough documentation including information about branching of registration and results questions. NLM documentation is found on the Protocol Registration System: protocol data element definitions and results data element definitions.


Points to Consider When Using AACT

The Points to Consider Document 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 March 27, 2015.

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 recommendations, 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.