Disclaimer: This is an early beta prototype. If you find any error, with data or functionality, please let us know via this page.

Overview

The entire OpenTrials database is saved monthly automatically. This is what we use to power our API, and contains everything that you can see on this website. Having the entire database in your local machine allows you to analyze the data using your favorite tool, or even create your own copy of the OpenTrials API.

As with any usage of OpenTrials's data, make sure you read and understand our Terms of use.

Download

Below are the latest available dumps of our database. Their file names contain the date at which the dump was produced:

How to use

The dump files you can download above were generated using the pg_dump command of PostgreSQL 9.4. To load it, you need a local database running PostgreSQL 9.4 or newer.

Assuming you have a database called DATABASE created in a PostgreSQL 9.4+ server running on HOST, with user USER, you can restore a dump named OPENTRIALS_DUMP.dump by opening a command line and running:

    pg_restore --no-owner --no-acl --create --host=HOST --username=USER --dbname=DATABASE OPENTRIALS_DUMP.dump
        

Please refer to the PostgreSQL documentation for more information about the restoring process.