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 2021-04-05 for version 1.5.1.9001

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.5.2

License

MIT + file LICENSE

Maintainer

Ralf Herold

Last Published

April 14th, 2025

Functions in ctrdata (1.5.2)

ctrdata

ctrdata: Overview on functions
dfFindUniqueEuctrRecord

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

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

ctrGetQueryUrl

Extract query parameters and register name from input or from clipboard into which the URL of a register search was copied
dfListExtractKey

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

dbCTRLoadJSONFiles
dbGetFieldsIntoDf

Create data frame by extracting specified fields from database collection
dbQueryHistory

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

ctrLoadQueryIntoDbEuctr
dbCTRUpdateQueryHistory

dbCTRUpdateQueryHistory
dfTrials2Long

Extract trial information into long format
dbFindFields

Find names of fields in the database collection
dbFindIdsUniqueTrials

Deduplicate records to provide unique clinical trial identifiers
installFindBinary

Check availability of binaries installed locally
installCygwinWindowsTest

Convenience function to test for working cygwin installation
typeField

Change type of field based on name of field
setProxy

Function to set proxy
dbCTRAnnotateQueryRecords

dbQueryAnnotateRecords
installCygwinWindowsDoInstall

Convenience function to install a minimal cygwin environment under MS Windows, including perl, sed and php
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
addMetaData

Annotate ctrdata function return values
ctrFindActiveSubstanceSynonyms

Find synonyms of an active substance
ctrGetQueryUrlFromBrowser

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

ctrRerunQuery
ctrDb

Check and prepare nodbi connection object for ctrdata
ctrLoadQueryIntoDbCtgov

ctrLoadQueryIntoDbCtgov