AACT is a publicly available relational database that contains all information (protocol and result data elements) about every study registered in ClinicalTrials.gov. Content is downloaded from ClinicalTrials.gov daily and loaded into AACT.
The documentation link below illustrates how ClinicalTrials.gov data are stored in the AACT database; it identifies all tables/columns and relationships.
Each table includes the unique identifier assigned by ClinicalTrials.gov: nct_id. This provides a way to find all data about a particular study and serves as the key that joins related information across multiple tables. Every table (except Studies) also includes an id column which uniquely identifies each row in the table. In most cases, you need to use the nct_id to join tables.
There are 246 unique data fields and 46 tables. The listing provides details by ID and nct_id.
The list of some key Tables Included:
Sample size at baseline for each study group; usually a count of participants but can represent other units of measure such as ‘hands’, ‘hips’, etc.
A single text column that provides a brief description of the study.
An AACT-provided table that contains info that’s been calculated from the information received from ClinicalTrials.gov. For example, number_of_facilities and actual_duration are provided in this table.
Results of scientifically appropriate statistical analyses performed on primary and secondary study outcomes. Includes results for treatment effect estimates, confidence intervals and other measures of dispersion, and p-values.
Basic info about study, including study title, date study registered with ClinicalTrials.gov, date results first posted to ClinicalTrials.gov, dates for study start and completion, phase of study, enrollment status, planned or actual enrollment, number of study arms/groups, etc.
– And many more.
The list of key data fields included are:
“ID” STRING, “NCT_ID” STRING, “RESULT_GROUP_ID” STRING,
“CTGOV_GROUP_CODE” STRING, “UNITS” STRING, “SCOPE” STRING, “COUNT” STRING
“ID” INTEGER, “NCT_ID” STRING, “DESCRIPTION” STRING
“ID” INTEGER, “NCT_ID” STRING, “MESH_TERM” STRING, “DOWNCASE_MESH_TERM” STRING
“ID” INTEGER, “NCT_ID” STRING,
“CONTACT_TYPE” STRING, “NAME” STRING, “PHONE” STRING, “EMAIL” STRING
– And many more.