Demo, drug, adr, link, ind, out, srce, and followup are the main table in
Vigibase Extract Case Level data.
In a regular workflow, you will work with those tables as R
objects (e.g. demo, drug, adr, link, ind, out, srce, followup).
These built-in example datasets use an underscore "_" to avoid ambiguity
with your own tables (e.g.
demo_, drug_, adr_, link_, ind_, out_, srce_, followup_).
This is a relational database, which means every table has a primary key
variable (e.g., UMCReportId for demo_. Keys will allow joints with other tables
The full details on the original structure can be found in
"VigiBase Extract Case Level - file description.pdf"
in your VigiBase ECL folders.
demo_ will typically be your cornerstone table, since it contains
one row per report. It is the preferred table to update for drugs and adrs
identification before performing disproportionality analyses.
These tables are subsets of the original ones, with some of the
immune checkpoint inhibitor cases or immune-related adverse events.
All data shown in these example data are FAKE, which means
you shouldn't consider the counts and computations as accurate.
Immune checkpoint inhibitors drugs include
"Ipilimumab", "Atezolizumab", "Durvalumab", "Nivolumab", "Pembrolizumab",
"Avelumab", "Cemiplimab","REGN 2810", "Tremelimumab".
More details on how to use vigibase tables can be found in the vignettes.
vignette("basic_workflow"), vignette("descriptive").
To build your own tables, use tb_vigibase(). See vignette("getting_started").
Usage
data(demo_)
drug_
adr_
link_
followup_
ind_
out_
srce_Format
demo_ is a data.table with 7 variables and 750 rows.
UMCReportIdInteger. The unique identifier of the case report.AgeGroupCharacter. The age group of the patient. Correspondence table ispath_sub/AgeGroup.parquet.GenderCharacter. Case gender.path_sub/Gender.parquetDateDatabaseCharacter (not date or numeric!). The date of the latest update of the report in the database.TypeCharacter. The type of report.path_sub/ReportType.parquetRegionCharacter. The world region where the report comes frompath_sub/Region.parquet.FirstDateDatabaseCharacter. The date the report was first submitted to the database.
drug_ is a data.table with 10 variables and 3514 rows.
UMCReportIdInteger. Seedemo_.Drug_IdInteger. The unique identifier of each drug report.MedicinalProd_IdInteger. The medicinalproduct identifier. Seeget_atc_code().DrecNoInteger. Drug Record Number, pivotal to identify drugs withget_drecno().Seq1,Seq2Character. Seq 1 and 2 complement DrecNo, in WHODrug dictionary.RouteCharacter. The route of administration of the drug.BasisCharacter. The reputation basis of the drug (suspect, concomitant, or interacting).path_sub/RepBasis.parquetAmountCharacter. The amount of drug administered.AmountUCharacter. The unit of the amount of drug administered.path_sub/SizeUnit.parquetFrequencyCharacter. The frequency of drug administration.FrequencyUCharacter. The unit of the frequency of drug administration.path_sub/Frequency.parquet
adr_ is a data.table with 4 variables and 2133 rows.
UMCReportIdInteger. Seedemo_.Adr_IdInteger. The unique identifier of each adverse event report.MedDRA_IdInteger. The MedDRA identifier of the adverse event. It is used inget_llt_soc()andget_llt_smq().OutcomeCharacter. The outcome of the adverse event.path_sub/Outcome.parquet
link_ is a data.table with 3 variables and 3514 rows. The version
built with tb_vigibase() is slightly different than the original one.
Drug_IdandAdr_Id. Integers. Together, they are the key variable oflink. Seedrug_andadr_.Dechallenge1and2Characters. Dechallenge action and outcome.path_sub/Dechallenge.parquet,path_sub/Dechallenge2.parquetRechallenge1and2Characters. Rechallenge action and outcome.path_sub/Rechallenge.parquet,path_sub/Rechallenge2.parquetTimeToOnsetMinandMaxNumerics. The minimum and maximum time to onset of the adverse event.tto_meanNumeric. The mean time to onset of the adverse event. It is the average ofTimeToOnsetMinandMax.rangeNumeric. The incertitude aroundtto_mean. Seevignette("descriptive").UMCReportIdInteger. Seedemo_.
ind_ is a data.table with 2 variables and 2426 rows.
Drug_IdInteger. Seedrug_.IndicationCharacter. The indication of the drug.
out_ is a data.table with 3 variables and 747 rows.
UMCReportIdInteger. Seedemo_.SeriousnessCharacter. The seriousness criteria of the report.path_sub/Seriousness.parquetSeriousCharacter. Whether the case is serious or not ("N" No, "Y" Yes)
srce_ is a data.table with 2 variables and 729 rows.
UMCReportIdInteger. Seedemo_.TypeCharacter. The Type of Reporter.path_sub/Notifier.parquet
followup_ is a data.table with 2 variables and 902 rows.
UMCReportIdInteger. Seedemo_.ReplacedUMCReportIdInteger. Previous version of the case, which is no longer available indemo_.
An object of class data.table (inherits from data.frame) with 3514 rows and 12 columns.
An object of class data.table (inherits from data.frame) with 2133 rows and 4 columns.
An object of class data.table (inherits from data.frame) with 5136 rows and 11 columns.
An object of class data.table (inherits from data.frame) with 902 rows and 2 columns.
An object of class data.table (inherits from data.frame) with 2426 rows and 2 columns.
An object of class data.table (inherits from data.frame) with 747 rows and 3 columns.
An object of class data.table (inherits from data.frame) with 729 rows and 2 columns.
