Domains

clinical, public health, translational

License

Warning: No license entered

Homepage

aact

Repository

GitHub

Infores ID

infores:aact

FAIRsharing ID

Unknown

Product Summary

Contacts

Clinical Trials Transformation Initiative (CTTI)

URL: https://aact.ctti-clinicaltrials.org/contactus

Products

From this Resource

ID	Name	URL	Category	Format	Description
aact.playground	AACT Playground	playground	GraphicalInterface	http	Web-based SQL query playground for ru...
aact.database	AACT Cloud Database	connect	Product	postgres	Cloud-based PostgreSQL database with ...
aact.downloads	AACT Database Downloads	downloads	Product	postgres	Static downloadable copies of the com...
aact.schema	AACT Database Schema	schema	DocumentationProduct	❔	Complete database schema documentatio...
aact.dictionary	AACT Data Dictionary	data_dictionary	DocumentationProduct	❔	Data dictionary with detailed informa...

Relevant Taxa

Human (NCBITaxon:9606)

Details

Aggregate Analysis of ClinicalTrials.gov (AACT) Database

Overview

AACT is a publicly available relational database that contains all information (protocol and result data elements) about every study registered in ClinicalTrials.gov. The database is maintained by the Clinical Trials Transformation Initiative (CTTI) and provides researchers and analysts with structured access to clinical trial data for analysis and research.

Key Features

Daily Updates: Database content is refreshed daily from ClinicalTrials.gov
Cloud Access: PostgreSQL database directly accessible in the cloud with free account registration
Static Downloads: Complete database snapshots available for download
Open Source: Built with open source tools (PostgreSQL, Ruby on Rails) and source code available on GitHub
Multiple Access Methods: Support for various PostgreSQL clients including pgAdmin, R/RStudio, SAS, and psql

Data Content

AACT contains comprehensive information from ClinicalTrials.gov including:

Study protocols and design information
Enrollment and demographic data
Intervention and outcome measures
Results data including baseline characteristics, outcome measures, and adverse events
Administrative and regulatory information
Literature references and related publications

The database is organized into a relational structure with multiple tables representing different aspects of clinical trials data.

Access Methods

Web Playground: Browser-based SQL query interface for immediate data exploration
PostgreSQL Database: Direct database connection via standard PostgreSQL clients
Downloaded Archives: Full database dumps for local installation and analysis
Documentation: Comprehensive schema documentation, data dictionary, and field mappings

Use Cases

Evaluating trends in clinical trial design and conduct
Meta-analysis and systematic reviews of clinical research
Analyzing reporting quality and completeness
Studying geographic and temporal patterns in clinical trials
Training and education in clinical research methods

Management

AACT is maintained by the Clinical Trials Transformation Initiative (CTTI), a public-private partnership co-founded by Duke University and the U.S. Food and Drug Administration (FDA) to improve the quality and efficiency of clinical trials.

Citation

Aggregate Analysis of ClinicalTrials.gov (AACT) Database. Clinical Trials Transformation Initiative (CTTI). Available at: https://aact.ctti-clinicaltrials.org/