AACT Database

CTTI has aggregated and restructured publicly available ClinicalTrials.gov 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 ClincalTrials.gov (AACT). CLICK HERE for an overview of the background on ClinicalTrials.gov 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 ClinicalTrials.gov March 27, 2016.

 

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 ClinicalTrials.gov 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 ClinicalTrials.gov 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 ClinicalTrials.gov registry
  • Duplicate records
  • Data completeness and accuracy
  • Types of questions that can be investigated with the ClinicalTrials.gov data from AACT
  • ClinicalTrials.gov data element definitions and interpretation of these variables
  • Explanation of variables original to ClinicalTrials.gov ("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

 

Example Data Trend Using AACT Database:

 

 

Previous Versions of AACT are available here:

Dataset reflects data downloaded from ClinicalTrial.gov September 27, 2015.

Dataset reflects data downloaded from ClinicalTrial.gov March 27, 2015.

Dataset reflects data downloaded from ClinicalTrial.gov September 27, 2014.

Dataset reflects data downloaded from ClinicalTrial.gov March 27, 2014.

Dataset reflects data downloaded from ClinicalTrials.gov September 27, 2013.

Dataset reflects data downloaded from ClinicalTrials.gov September 27, 2012.

Dataset reflects data downloaded from ClinicalTrials.gov September 27, 2011.

Dataset reflects data downloaded from ClinicalTrials.gov September 27, 2010.