Related Experiment Video
Updated: May 12, 2026

Generation of Comprehensive Thoracic Oncology Database - Tool for Translational Research
Published on: January 22, 2011
From ClinicalTrials.gov trial registry to an analysis-ready database of clinical trial results
M Soledad Cepeda1, Victor Lobanov, Jesse A Berlin
1Janssen Research & Development, LLC, Titusville, NJ 08560, USA. scepeda@its.jnj.com
Background:
The ClinicalTrials.gov web site provides a convenient interface to look up study results, but it does not allow downloading data in a format that can be readily used for quantitative analyses.
Purpose:
To develop a system that automatically downloads study results from ClinicalTrials.gov and provides an interface to retrieve study results in a spreadsheet format ready for analysis.
Methods:
Sherlock(®) identifies studies by intervention, population, or outcome of interest and in seconds creates an analytic database of study results ready for analyses. The outcome classification algorithms used in Sherlock were validated against a classification by an expert.
Conclusions:
Having a database ready for analysis that can be updated automatically, dramatically extends the utility of the ClinicalTrials.gov trial registry. It increases the speed of comparative research, reduces the need for manual extraction of data, and permits answering a vast array of questions.
Related Concept Videos
Clinical Trials
There are four phases in a clinical trial. A phase one...
Clinical Trials: Overview
Hazard Ratio
For example, in a clinical trial evaluating a...
Types of Biopharmaceutical Studies: Controlled and Non-Controlled Approaches
Non-controlled studies, commonly employed for initial exploration, lack a control group, rendering them susceptible to biases and external influences. In contrast, controlled...
Statistical Software for Data Analysis and Clinical Trials
Preclinical Development: Overview