The complete version history of every clinical trial.

What's included

Every version of every trial, with:

• Recruitment status, and the stated reason when a trial stops
• Study design: allocation, masking, model, and purpose
• Enrollment, anticipated or actual
• Lead sponsor and submitting organization
• Start, primary completion, and completion dates
• Titles, descriptions, and eligibility criteria
• Registered interventions: drugs, biologics, devices, procedures, and more

• Timing you can trust: each version carries both its submission date and its public posting date, plus whether that date is actual or estimated.
• Stable schema: changes are additive only, so queries you write today keep working.

Every primary-completion slip across the whole registry, in one query. The same SQL runs on the hosted database or on the downloaded files.

WITH v AS (
    SELECT nct_id, nct_version,
           last_update_post_date,
           primary_completion_date AS pcd,
           LAG(primary_completion_date) OVER (
               PARTITION BY nct_id
               ORDER BY nct_version
           ) AS prev_pcd
    FROM trial_versions
)
SELECT *,
       pcd - prev_pcd AS slip_days
FROM v
WHERE pcd > prev_pcd;