How to get ClinicalTrials.gov Study Watch

Watch ClinicalTrials.gov studies for a keyword, condition, or sponsor - status and dates for biotech pipeline monitors. clinicaltrials.gov is one page of it. A run reads that public list and saves one row per result.

One row per result

A row has NCT id, Brief title, Overall status, Lead sponsor. The columns are listed in the schema on this page.

New rows from that site

Each run reads clinicaltrials.gov again. Put it on a schedule and the next file is the latest rows from that site.

ClinicalTrials.gov Study Watch in Excel, Sheets, or Power BI

The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.

Schema

Examples come from the actor sample, not a live result.

Name	Description	Example
`nctId`	NCT id	`NCT05564117`
`briefTitle`	Brief title	`Research Study Looking at How Well Semaglutide Tablets Taken Once Daily Work in People Who Have a Body Weight Above t...`
`overallStatus`	Overall status	`COMPLETED`
`leadSponsor`	Lead sponsor	`Novo Nordisk A/S`
`condition`	Condition	`Overweight`
`startDate`	Start date	`2022-10-11`
`sourceUrl`	Source URL	`https://clinicaltrials.gov/study/NCT05564117`
`recordKey`	Record key	`nct:NCT05564117`

nctIdNCT idNCT05564117
briefTitleBrief titleResearch Study Looking at How Well Semaglutide Tablets Taken Once Daily Work in People Who Have a Body Weight Above t...
overallStatusOverall statusCOMPLETED
leadSponsorLead sponsorNovo Nordisk A/S
conditionConditionOverweight
startDateStart date2022-10-11
sourceUrlSource URLhttps://clinicaltrials.gov/study/NCT05564117
recordKeyRecord keynct:NCT05564117