Package: ctrdata 1.26.1.9000

ctrdata: Retrieve and Analyze Clinical Trials Data from Public Registers

A system for querying, retrieving and analyzing protocol- and results-related information on clinical trials from four public registers, the 'European Union Clinical Trials Register' ('EUCTR', <https://www.clinicaltrialsregister.eu/>), 'ClinicalTrials.gov' (<https://clinicaltrials.gov/> and also translating queries the retired classic interface), the 'ISRCTN' (<https://www.isrctn.com/>) and the 'European Union Clinical Trials Information System' ('CTIS', <https://euclinicaltrials.eu/>). Trial information is downloaded, converted and stored in a database ('PostgreSQL', 'SQLite', 'DuckDB' or 'MongoDB'; via package 'nodbi'). Protocols, statistical analysis plans, informed consent sheets and other documents in registers associated with trials can also be downloaded. Other functions implement trial concepts canonically across registers, identify deduplicated records, easily find and extract variables (fields) of interest even from complex nested data as used by the registers, merge variables and update queries. The package can be used for monitoring, meta- and trend-analysis of the design and conduct as well as of the results of clinical trials across registers. See overview in Herold, R. (2025) <doi:10.1017/rsm.2025.10061>.

Authors:Ralf Herold [aut, cre], Marek Kubica [cph], Ivan Bozhanov [cph]

ctrdata_1.26.1.9000.tar.gz

ctrdata_1.26.1.9000.tgz(r-4.6-any)ctrdata_1.26.1.9000.tgz(r-4.5-any)
ctrdata_1.26.1.9000.tar.gz(r-4.7-any)ctrdata_1.26.1.9000.tar.gz(r-4.6-any)
ctrdata_1.26.1.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html
DESCRIPTION |NEWS
card.svg |card.png
ctrdata/json (API)

# Install 'ctrdata' in R:
install.packages('ctrdata', repos = c('https://rfhb.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/rfhb/ctrdata/issues

Pkgdown/docs site:https://rfhb.github.io

On CRAN:

Conda:

clinical-dataclinical-researchclinical-studiesclinical-trialsctgovdatabaseduckdbmongodbnodbipostgresqlregistersqlitestudiestrial

8.23 score 57 stars 57 scripts 1.2k downloads 33 exports 75 dependencies

Last updated from:54fa01cf1a. Checks:6 OK, 3 FAILURE. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK806
source / vignettesOK212
linux-release-x86_64OK788
macos-release-arm64OK795
macos-oldrel-arm64OK758
windows-develFAILURE3718
windows-releaseFAILURE3691
windows-oldrelFAILURE3680
wasm-releaseOK146

Exports:ctrFindActiveSubstanceSynonymsctrGenerateQueriesctrGetQueryUrlctrLoadQueryIntoDbctrOpenSearchPagesInBrowserctrShowOneTrialdbFindFieldsdbFindIdsUniqueTrialsdbGetFieldsIntoDfdbQueryHistorydfMergeVariablesReleveldfName2ValuedfTrials2Longf.assignmentTypef.controlTypef.externalLinksf.hasResultsf.isMedIntervTrialf.isUniqueTrialf.likelyPlatformTrialf.numSitesf.numTestArmsSubstancesf.primaryEndpointDescriptionf.primaryEndpointResultsf.resultsDatef.sampleSizef.sponsorTypef.startDatef.statusRecruitmentf.trialObjectivesf.trialPhasef.trialPopulationf.trialTitle

Dependencies:askpassbase64encbitbit64bslibcachemclicliprcpp11crayoncurlDBIdigestdplyrevaluatefastmapfontawesomefsgenericsgluehighrhmshtmltoolshtmlwidgetshttrhttr2jqrjquerylibjsonliteknitrlazyevallifecyclelubridatemagrittrmemoisemimenodbiopensslpillarpkgconfigprettyunitsprogresspurrrR.methodsS3R.ooR.utilsR6rappdirsRcppreadrrlangrmarkdownrvestsassselectrstringdiststringistringrsystibbletidyrtidyselecttimechangetinytextzdbutf8uuidV8vctrsvroomwithrxfunxml2yamlzip

Install R package ctrdata
Install package ctrdata on an R system | Databases to use | Attach package ctrdata | Credit to clinical trial registers | Quote or reference ctrdata

Last update: 2026-06-14
Started: 2020-10-16

Summarise and analyse clinical trial information
Preparations | Find fields / variables of interest | Data frame from database | Metadata from data frame | De-duplicate records | Use trial concepts to simplify analyses | Reviewing a specific trial | Simple analysis of dates | Cross-register clinical trial concepts | Merging fields for analysis | Historic versions of trial records and changes in sample sizes | Analysing nested fields such as trial results | Analysing primary endpoints | Analysis methods and p values | Investigational or authorised medicinal product? | Analyses using MongoDB pipeline | Aggregation | Mapreduce

Last update: 2026-06-14
Started: 2021-12-04

Retrieve clinical trial information
Get started | Attach package ctrdata | Open register's advanced search page in browser | Adjust search parameters and execute search in browser | Copy address from browser address bar to clipboard | Get address from clipboard | Connect database, retrieve, transform, save and check | Loading only a single version of EUCTR protocol-related data | Repeat and update a previous query | Results-related trial information | Add trial information from several registers | Add personal annotations | Find synonyms of active substance names | Find platform trials | Load information using trial identifiers

Last update: 2026-03-07
Started: 2020-10-16

Readme and manuals

Help Manual

Help pageTopics
Getting started, database connection, function overviewctrdata
Information on clinical trial registersctrdata-registers
Trial concepts implemented across registersctrdata-trial-concepts
Find synonyms of an active substancectrFindActiveSubstanceSynonyms
Generates queries that work across registersctrGenerateQueries
Get register name and query parameters from search URLctrGetQueryUrl
Load and store register trial informationctrLoadQueryIntoDb
Open register to show query results or search pagectrOpenSearchPagesInBrowser
Show full structure and all data of a trialctrShowOneTrial
Find names of fields in the database collectiondbFindFields
Get identifiers of deduplicated trial recordsdbFindIdsUniqueTrials
Create data frame of specified fields or trial concepts from database collectiondbGetFieldsIntoDf
Show history of queries loaded into collectiondbQueryHistory
Merge variables, keeping type where possible, optionally relevel factorsdfMergeVariablesRelevel
Get value for variable of interestdfName2Value
Convert data frame with trial records into long formatdfTrials2Long
Calculate type of assignment to intervention in a studyf.assignmentType
Calculate type of control data collected in a studyf.controlType
Calculate the external references from a study's register recordf.externalLinks
Calculate if a study's results are availablef.hasResults
Calculate if study is a medicine-interventional studyf.isMedIntervTrial
Calculate if record is unique for a studyf.isUniqueTrial
Calculate if study is likely a platform trial or notf.likelyPlatformTrial
Calculate number of sites of a studyf.numSites
Calculate number of arms or groups with investigational medicines in a studyf.numTestArmsSubstances
Calculate details of a primary endpoint of a studyf.primaryEndpointDescription
Calculate details of a study's primary endpoint statistical testingf.primaryEndpointResults
Calculate date of results of a studyf.resultsDate
Calculate sample size of a studyf.sampleSize
Calculate type of sponsor of a studyf.sponsorType
Calculate start date of a studyf.startDate
Calculate status of recruitment of a studyf.statusRecruitment
Calculate objectives of a studyf.trialObjectives
Calculate phase of a clinical trialf.trialPhase
Calculate in- and exclusion criteria and age groupsf.trialPopulation
Calculate the title of a studyf.trialTitle