Latest AACT Database Snapshots

PostgreSQL Database Dump
Last Exported: 05-21-2025

Use this file to create a complete copy of the AACT database on your own PostgreSQL server.

pg_restore -c -d your_database_name path_to_downloaded_file
File: 20250521_clinical_trials_ctgov.zip
Size: 2.04 GB
Flat Text Files
Last Exported: 05-21-2025

Use these pipe-delimited text files to import AACT data into any database or analysis tool. Each file corresponds to a table in the AACT database schema.

File: 20250521_export_ctgov.zip
Size: 2.03 GB
COVID-19 Spreadsheets
Last Exported: 03-08-2023

These files contain current clinical studies related to COVID-19 from ClinicalTrials.gov as of the date of file creation. Each file allows users without advanced database skills to explore the trials in a spreadsheet format.

Please Note: COVID-19 spreadsheets are no longer actively generated. Please check the "Last Exported" date above for the most recent available data.

File: 20230308003509_covid-19.tsv
Size: B