Learn R Programming

⚠️There's a newer version (1.22.0) of this package.Take me there.

ctrdata for aggregating and analysing clinical trials

The package ctrdata provides functions for retrieving (downloading) information on clinical trials from public registers, and for aggregating and analysing this information. Use with R for the European Union Clinical Trials Register (“EUCTR”, https://www.clinicaltrialsregister.eu/) and ClinicalTrials.gov (“CTGOV”, https://clinicaltrials.gov/). The motivation is to understand trends in design and conduct of trials, their availability for patients and their detailled results. The package is to be used within the R system.

Last reviewed on 2020-10-17 for version 1.4

Main features:

  • Protocol-related trial information is easily retrieved (downloaded): Users define a query in a register’s web interface and then use ctrdata to retrieve in one step all trials resulting from the query. Results-related trial information and personal annotations can be including during retrieval. Synonyms of an active substance can also be found.

  • Retrieved (downloaded) trial information is transformed and stored in a document-centric database, for fast and offline access. Uses RSQLite, local or remote MongoDB servers, via R package nodbi. Easily re-run a previous query to update a database.

  • Analysis can be done with R (using ctrdata convenience functions) or others systems. Unique (de-duplicated) trial records are identified across registers. ctrdata can merge and recode information (fields) and also provides easy access even to deeply-nested fields (

Copy Link

Version

Install

install.packages('ctrdata')

Monthly Downloads

813

Version

1.4.1

License

MIT + file LICENSE

Maintainer

Ralf Herold

Last Published

April 14th, 2025

Functions in ctrdata (1.4.1)

ctrLoadQueryIntoDbEuctr

ctrLoadQueryIntoDbEuctr
ctrGetQueryUrlFromBrowser

Import from clipboard the URL of a search in one of the registers
ctrOpenSearchPagesInBrowser

Open advanced search pages of register(s) or execute search in browser
ctrLoadQueryIntoDb

Retrieve or update information on clinical trials from register and store in database
ctrRerunQuery

ctrRerunQuery
ctrLoadQueryIntoDbCtgov

ctrLoadQueryIntoDbCtgov
checkDoc

Check if a document exists based on its unique identifier
addMetaData

Annotate ctrdata function return values
dbFindFields

Find names of fields in the database collection
ctrDb

Check and prepare nodbi connection object for ctrdata
dbGetFieldsIntoDf

Create data frame by extracting specified fields from database collection
dbFindIdsUniqueTrials

Deduplicate records to provide unique clinical trial identifiers
installCygwinWindowsTest

Convenience function to test for working cygwin installation
dbQueryHistory

Show the history of queries that were loaded into a database
installFindBinary

Check availability of binaries installed locally
ctrdata

ctrdata: Overview on functions
dbCTRAnnotateQueryRecords

dbQueryAnnotateRecords
dfListExtractKey

Extract named element(s) from list(s) into long-format data frame
setProxy

Function to set proxy
dfFindUniqueEuctrRecord

Select single trial record from records of different EU Member States
typeField

Change type of field based on name of field
ctrFindActiveSubstanceSynonyms

Find synonyms of an active substance
dfTrials2Long

Extract trial information into long format
installCygwinWindowsDoInstall

Convenience function to install a minimal cygwin environment under MS Windows, including perl, sed and php
dbCTRUpdateQueryHistory

dbCTRUpdateQueryHistory
dbCTRLoadJSONFiles

dbCTRLoadJSONFiles
dfMergeTwoVariablesRelevel

Merge two variables into one, optionally map values to new levels
dfName2Value