Explore

Using the ClinicalTrials.gov Pack

This Pack is under development.

Expect breaking changes so long as this banner is up.

The ClinicalTrials.gov Pack lets you access clinical trials data in Coda using the

ClinicalTrials.gov API⁠

Disclaimer

This is not an “official” Pack from the

ClinicalTrials.gov⁠

API, but a best-effort attempt at making the rich data on clinical trials more accessible for structured access with Coda. The Pack is not affiliated in any way with the NIH or the US Government.

Installation

Find the ClinicalTrials.gov Pack in the “Insert” menu in Coda, or alternatively add to doc here:

⁠

ClinicalTrials.gov Pack, extend Coda with... - Coda Access clinical trials from the US National Library of Medicine. This Pack is not affiliated with US Government and accesses clinical trial info using the Clin coda.io⁠

⁠

Usage

The Pack exposes two ways of accessing studies:

The Study() formula, which looks up a study by its NCT ID (e.g., NCT05425940)

The Studies Pack table, which syncs in a list of studies matching a set of parameters

With Coda, you can configure the Pack table to sync on a recurring basis and, for instance, pull in updated or new studies matching your criteria.

After you’ve synced studies, you’ll want to make heavy use of formulaic columns in order to access the properties you want. See the demo below for details.

To help discover available properties, you can use the

data explorer⁠

- plug in the study ID into the GET /studies/{nctId} and see what it spits out. You should then be able to find the similar property using Coda formula autocomplete.

Documentation

This Pack provides a Coda-accessible abstraction on top of the official ClinicalTrials.gov API. The API is very rich and returns a lot of information on studies; the Pack does not attempt to transform this data.

You may find the following documentation useful:

⁠

Study Data Structure⁠

⁠

The study object returned by the Pack is accessible with the same properties documented here. For example, to get the title of study, you can use the following Coda formula: Study.ProtocolSection.IdentificationModule.BriefTitle

⁠

Study sync table parameters⁠

⁠

Studies can be filtered and sorted using the parameters documented here - see the GET /studies section for links additional documentation. These can be set in the settings of your Studies Pack sync table

Demo

Demo

Not synced yet

Status

Locations

Study

View

Status

Brief Title

Brief Summary

Start Date

Completion Date

Inclusion Criteria

Locations

Contacts

Study Plan

NCT05322590

View

RECRUITING

BXQ-350 in Newly Diagnosed Metastatic Colorectal Carcinoma

The study will assess the safety and efficacy of BXQ-350 plus modified FOLFOX7 (mFOLFOX7) and bevacizumab in participants who have newly diagnosed metastatic adenocarcinoma of the colon/rectum. The study will also evaluate if the administration of BXQ-350 with mFOLFOX7 and bevacizumab may diminish oxaliplatin induced sensory neurotoxicity, enabling participants to receive the total and planned doses of mFOLFOX7.

All participants will receive BXQ-350 by intravenous (IV) infusion along with standard of care doses of mFOLFOX and bevacizumab. The study is divided into two stages: Stage 1 will be open label and will enroll participants at increasing dose levels of BXQ-350 in order to determine the Stage 2 dose. Stage 2 will be blinded; participants will receive BXQ-350 at the established Stage 1 dose or placebo.

1/9/2023

4/1/2029

Inclusion Criteria:

Birmingham

Orange

San Francisco

Miami

Iowa City

Edgewood

Lexington

Louisville

New Orleans

New York

Stony Brook

Canton

Cincinnati

Portland

Greenville

Bexion Pharmaceuticals, Inc.

PHASE1PHASE2

NCT02886104

View

RECRUITING

Comparison of Hepatectomy and Local Ablation for Resectable Synchronous and Metachronous Colorectal Liver Metastasis

The surgical and local ablation strategy for the treatment of resectable synchronous and metachronous colorectal liver metastases(CRLM) has not still been defined. The purpose of this study is to compare two treatment strategies in which simultaneous resection of both primary and secondary tumor of synchronous CRLM(SCRLM) and resection of metachronous CRLM(MCRLM) is compared with resection of primary tumor and ablation of secondary tumor in SCRLM and ablation of MCRLM. Endpoints include the rate of severe complications and survival.

8/1/2016

7/1/2026

Inclusion Criteria:

Guangzhou

Meijin Huang, MD,PHD

Jun Huang, MD,PHD

NCT05425940

View

RECRUITING

Study of XL092 + Atezolizumab vs Regorafenib in Subjects With Metastatic Colorectal Cancer

This is a multicenter, randomized, open-label, controlled Phase 3 trial of XL092 + atezolizumab vs regorafenib in subjects with microsatellite stable/microsatellite instability low (MSS/MSI-low) metastatic colorectal cancer (mCRC) who have progressed during, after or are intolerant to standard-of-care (SOC) therapy.

9/7/2022

2/1/2026

Inclusion Criteria:

Jonesboro

Phoenix

Tucson

Duarte

La Jolla

Los Angeles

Orange

Santa Monica

Santa Rosa

Sylmar

Torrance

Whittier

New Haven

Miami Beach

Orlando

Marietta

Joliet

Indianapolis

Westwood

Lexington

New Orleans

Saint Louis

Billings

Omaha

Albuquerque

Bronx

New York

Charlotte

Show 98 more

Exelixis Clinical Trials

Backup or International

PHASE3

There are no rows in this table

⁠

Known issues

Some studies may have too much data for Coda to sync. If you’re running into this issue, use the Fields attribute in Pack settings to limit the data returned by the API

It may be hard to discover the information actually needed. Coda optimizes for simple APIs where all attributes are top level - due to the amount of information this API exposes, the complex data structure is retained and you’ll actually need to perform nested property lookups

The Pack hasn’t been thoroughly tested on all the data available via the API, and in fact part of the Pack’s code is auto-generated using the schemas provided in the documentation. If you run into issues seeing data in Coda that you can replicate is available via the ClinicalTrials.gov API, don’t hesitate to reach out!

Support

Contact information is in the Pack listing.

Source code is available in this

GitHub repo.⁠

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.