Improving Public Access to Aggregate Content of

What is AACT?

AACT is a publicly available relational database that contains all information (protocol and result data elements) about every study registered in Content is downloaded from daily and loaded into AACT. The Clinical Trials Transformation Initiative (CTTI) enhanced AACT in October, 2016 to include the following features:

  • Database content refreshed daily
  • Database directly accessible in the cloud
  • Static copies of the database available for download
  • Open source tools freely available (postgreSQL, Ruby on Rails, Tableau Public)
  • Source code available via Github

If you're interested in data extracted via the original AACT system (March, 2016 and earlier), please visit the original AACT webpage. is moving to a new version of their API January 1st 2022. This change should not affect the structure of AACT significantly, but there will be changes. Please see our migration page to see the currently document differences and to alert us about any mistakes.

In preparation for this migration that we have added the ability for you see the most recent version of the data.

Please go to our beta migration page to see how to run queries on the data.