ClinicalTrials.gov Scraper
Pricing
from $0.70 / 1,000 studies
Trial records with the whyStopped free text classified into safety, futility, slow accrual, funding and the rest — unreadable at scale across 34,000+ terminated studies until now. Plus enrolment failure, overdue records and how many stopped trials never posted results.
type
Optional
study or analysis.
nctId
Optional
Registry identifier.
title
Optional
Brief title.
url
Optional
Link to the study on ClinicalTrials.gov.
status
Optional
Overall recruitment status as filed.
isStopped
Optional
True for TERMINATED, WITHDRAWN or SUSPENDED.
whyStopped
Optional
The sponsor's own words. Free text, and the most informative field in the record.
stopReason
Optional
The classification: safety, futility, slow_accrual, funding, business_decision, sponsor_decision_undisclosed, investigator_or_site, drug_supply, covid, regulatory, administrative, unspecified or other. Null for trials still running.
stopReasonGiven
Optional
False when the sponsor left it blank or entered a placeholder like N/A.
phase
Optional
Trial phase.
isLatePhase
Optional
Phase 2, 3 or 4. A halted late-phase trial is a material event in a way a halted NA study is not.
leadSponsor
Optional
Lead sponsor organisation.
sponsorClass
Optional
INDUSTRY, NIH, OTHER_GOV, ACADEMIC and so on.
isIndustrySponsored
Optional
Lead sponsor is a company.
conditions
Optional
Conditions studied.
enrollment
Optional
Enrolment count as filed.
enrollmentType
Optional
ACTUAL once the trial has run, ESTIMATED while it is a target.
enrolledNobody
Optional
A stopped trial whose ACTUAL enrolment is one or zero. It never got going, whatever reason was given.
startDate
Optional
Start date. Registry dates come as YYYY, YYYY-MM or YYYY-MM-DD and are normalised without inventing precision.
primaryCompletionDate
Optional
Primary completion date.
primaryCompletionType
Optional
ACTUAL or ESTIMATED. The distinction is what makes an overdue record detectable.
completionDate
Optional
Overall completion date.
durationMonths
Optional
Months from start to completion. For a stopped trial, how long it survived.
isOverdue
Optional
The primary completion date is still an ESTIMATE and has already passed - the record has not been updated to say what happened.
monthsOverdue
Optional
How long it has been overdue.
hasResults
Optional
Results have been posted to the registry.
resultsWithheld
Optional
The trial stopped and no results were ever posted. This is how a negative finding disappears.
countries
Optional
Distinct countries with sites.
siteCount
Optional
Number of listed sites, not deduplicated.
firstPostedDate
Optional
When the study first appeared on the registry.
lastUpdateDate
Optional
When the record was last updated.
studiesAnalysed
Optional
Analysis rows: studies read.
stoppedStudies
Optional
Analysis rows: how many had stopped.
stoppedPercent
Optional
Analysis rows: share of the cohort that stopped.
stopReasons
Optional
Analysis rows: full count per reason category.
slowAccrualPercent
Optional
Analysis rows: share of stopped trials that died of accrual failure - the most common cause of death in clinical research, and a direct read on how hard an indication is to run.
safetyCount
Optional
Analysis rows: stopped for safety.
futilityCount
Optional
Analysis rows: stopped for futility or lack of efficacy.
sponsorDecisionCount
Optional
Analysis rows: stopped on a bare sponsor decision with no rationale disclosed.
noReasonGivenPercent
Optional
Analysis rows: share that gave no usable reason at all.
resultsWithheldPercent
Optional
Analysis rows: share of stopped trials that never posted results.
medianMonthsBeforeStopping
Optional
Analysis rows: median survival of a stopped trial. Median, so one very long outlier cannot distort it.
topStoppingSponsor
Optional
Analysis rows: sponsor with the most stopped trials in the cohort.
matchedInRegistry
Optional
Analysis rows: how many studies the query matched in total, which may exceed how many were read.
