Retrieve and Analyze Clinical Trials Data from Public Registers
ctrdata: Retrieve and Analyze Clinical Trials Data from Public Registe...
Information on clinical trial registers
Trial concepts implemented across registers
Getting started, database connection, function overview
Check and prepare nodbi connection object for ctrdata
Find synonyms of an active substance
Generates queries that work across registers
Get register name and query parameters from search URL
Load and store register trial information
Open register to show query results or search page
Show full structure and all data of a trial
Find names of fields in the database collection
Get identifiers of deduplicated trial records
Create data frame of specified fields or trial concepts from database ...
Show history of queries loaded into collection
Merge variables, keeping type where possible, optionally relevel facto...
Get value for variable of interest
Convert data frame with trial records into long format
Calculate type of assignment to intervention in a study
Calculate type of control data collected in a study
Calculate the external references from a study's register record
Calculate if a study's results are available
Calculate if study is a medicine-interventional study
Calculate if record is unique for a study
Calculate if study is likely a platform trial or not
Calculate number of sites of a study
Calculate number of arms or groups with investigational medicines in a...
Calculate details of a primary endpoint of a study
Calculate details of a study's primary endpoint analysis and testing
Calculate date of results of a study
Calculate sample size of a study
Calculate type of sponsor of a study
Calculate start date of a study
Calculate status of recruitment of a study
Calculate objectives of a study
Calculate phase of a clinical trial
Calculate in- and exclusion criteria and age groups
Calculate the title of a study
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' (<http://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.
Useful links