Getting drug utilisation related information of subjects in a cohort

Introduction

The DrugUtilisation package includes a range of functions that add drug-related information of subjects in OMOP CDM tables and cohort tables. Essentially, there are two functionalities: add and summarise. While the first return patient-level information on drug usage, the second returns aggregate estimates of it. In this vignette, we will explore these functions and provide some examples for its usage.

Set up

Mock data

For this vignette we will use mock data contained in the DrugUtilisation package. This mock dataset contains cohorts, we will take “cohort1” as the cohort table of interest from which we want to study drug usage of acetaminophen.

library(DrugUtilisation)

cdm <- mockDrugUtilisation(numberIndividual = 200)
cdm$cohort1 |>
  dplyr::glimpse()
#> Rows: ??
#> Columns: 4
#> Database: DuckDB v1.0.0 [root@Darwin 23.4.0:R 4.4.1/:memory:]
#> $ cohort_definition_id <int> 1, 1, 3, 3, 2, 2, 1, 3, 3, 2, 1, 2, 3, 1, 1, 3, 3…
#> $ subject_id           <int> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15…
#> $ cohort_start_date    <date> 2022-09-01, 2017-02-04, 2020-06-22, 2015-02-21, …
#> $ cohort_end_date      <date> 2022-09-10, 2018-01-21, 2020-07-04, 2015-03-06, …

Drug codes

Since we want to characterise acetaminophen and simvastatin usage for subjects in cohort1, we first have to get the codelist with CodelistGenerator:

drugConcepts <- CodelistGenerator::getDrugIngredientCodes(cdm = cdm, name = c("acetaminophen", "simvastatin"))

Add drug utilisation information

addNumberExposures()

With the function addNumberExposures() we can get how many exposures to acetaminophen each patient in our cohort had during a certain time. There are 2 thing to keep in mind when using this function:

In what follows we add a column in the cohort table, with the number of incident exposures during the time patients are in the cohort:

cohort <- addNumberExposures(
  cohort = cdm$cohort1, # cohort with the population of interest
  conceptSet = drugConcepts, # concepts of the drugs of interest
  indexDate = "cohort_start_date",
  censorDate = "cohort_end_date",
  restrictIncident = TRUE,
  nameStyle = "number_exposures_{concept_name}",
  name = NULL
)

cohort |>
  dplyr::glimpse()
#> Rows: ??
#> Columns: 6
#> Database: DuckDB v1.0.0 [root@Darwin 23.4.0:R 4.4.1/:memory:]
#> $ cohort_definition_id               <int> 1, 1, 3, 2, 3, 2, 1, 3, 1, 1, 3, 2,…
#> $ subject_id                         <int> 1, 2, 4, 6, 8, 10, 11, 13, 14, 15, …
#> $ cohort_start_date                  <date> 2022-09-01, 2017-02-04, 2015-02-21…
#> $ cohort_end_date                    <date> 2022-09-10, 2018-01-21, 2015-03-06…
#> $ number_exposures_36567_simvastatin <int> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,…
#> $ number_exposures_161_acetaminophen <int> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,…

addNumberEras()

This function works like the previous one, but calculates the number of eras instead of exposures. The difference between these two is given by the gapEra argument: consecutive drug exposures separated by less than the days specified in gapEra, are collapsed together into the same era.

Next we compute the number of eras, considering a gap of 3 days.

Additionally, we use the argument nameStyle so the new columns are only identified by the concept name, instead of using the prefix “number_eras_” set by default.

cohort <- addNumberEras(
  cohort = cdm$cohort1, # cohort with the population of interest
  conceptSet = drugConcepts, # concepts of the drugs of interest
  indexDate = "cohort_start_date",
  censorDate = "cohort_end_date",
  gapEra = 3,
  restrictIncident = TRUE,
  nameStyle = "{concept_name}",
  name = NULL
)

cohort |>
  dplyr::glimpse()
#> Rows: ??
#> Columns: 6
#> Database: DuckDB v1.0.0 [root@Darwin 23.4.0:R 4.4.1/:memory:]
#> $ cohort_definition_id <int> 1, 1, 3, 2, 3, 2, 1, 3, 1, 1, 3, 2, 1, 1, 3, 2, 3…
#> $ subject_id           <int> 1, 2, 4, 6, 8, 10, 11, 13, 14, 15, 16, 18, 19, 20…
#> $ cohort_start_date    <date> 2022-09-01, 2017-02-04, 2015-02-21, 2010-05-29, …
#> $ cohort_end_date      <date> 2022-09-10, 2018-01-21, 2015-03-06, 2010-10-14, …
#> $ `161_acetaminophen`  <int> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
#> $ `36567_simvastatin`  <int> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…

exposedTime

This argument set to TRUE will add a column specifying the time in days a person has been exposed to the drug of interest. Take note that gapEra and restrictIncident will be taken into account for this calculation:

  1. Drug eras: exposed time will be based on drug eras according to gapEra.

  2. Incident exposures: if restrictIncident = TRUE, exposed time will consider only those drug exposures starting after indexDate, while if restrictIncident = FALSE, exposures that started before indexDate and ended afterwards will also be taken into account.

The subfunction to get only this information is addExposedTime().

timeToExposure

If set to TRUE, a column will be added that shows the number of days until the first exposure occurring within the considered time window. Notice that the value of restrictIncident will be taken into account: if TRUE, the time to the first incident exposure during the time interval is measured; otherwise, exposures that start before the indexDate and end afterwards will be considered (in these cases, time to exposure is 0).

The subfunction to get only this information is addTimeToExposure()

initialQuantity and cumulativeQuantity

These, if TRUE, will add a column each specifying which was the initial quantity prescribed at the start of the first exposure considered (initialQuantity), and the cumulative quantity taken throughout the exposures in the considered time-window (cumulativeQuantity).

Quantities are measured at conceptSet level not ingredient. Notice that for both measures restrictIncident is considered, while gapEra is used for the cumulative quantity.

The subfunctions to get this information are addInitialQuantity() and addCumulativeQuantity() respectively.

initialDailyDose and cumulativeDose

If initialDailyDose is TRUE, a column will be add specifying for each of the ingredients in a conceptSet which was the initial daily dose given. The cumulativeDose will measure for each ingredient the total dose taken throughout the exposures considered in the time-window. Recall that restrictIncident is considered in these calculations, and that the cumulative dose also considers gapEra.

The subfunctions to get this information are addInitialDailyDose() and addCumulativeDose() respectively.

addDrugUtilisation()

All the explained add functions are subfunctions of the more comprehensive addDrugUtilisation(). This broader function computes multiple drug utilization metrics.

addDrugUtilisation(
  cohort,
  indexDate = "cohort_start_date",
  censorDate = "cohort_end_date",
  ingredientConceptId = NULL,
  conceptSet = NULL,
  restrictIncident = TRUE,
  gapEra = 1,
  numberExposures = TRUE,
  numberEras = TRUE,
  exposedTime = TRUE,
  timeToExposure = TRUE,
  initialQuantity = TRUE,
  cumulativeQuantity = TRUE,
  initialDailyDose = TRUE,
  cumulativeDose = TRUE,
  nameStyle = "{value}_{concept_name}_{ingredient}",
  name = NULL
)

Use case

In what follows we create a permanent table “drug_utilisation_example” in the database with the information on dosage and quantity of the ingredients 1125315 (acetaminophen) and 1503297 (metformin). We are interested in exposures happening from cohort end date, until the end of the patient’s observation data. Additionally, we define an exposure era using a gap of 7 days, and we only consider incident exposures during that time.

cdm$drug_utilisation_example <- cdm$cohort1 |>
  # add end of current observation date with the package PatientProfiels
  PatientProfiles::addFutureObservation(futureObservationType = "date") |>
  # add the targeted drug utilisation measures
  addDrugUtilisation(
    indexDate = "cohort_end_date",
    censorDate = "future_observation",
    ingredientConceptId = c(1125315, 1503297),
    conceptSet = NULL,
    restrictIncident = TRUE,
    gapEra = 7,
    numberExposures = FALSE,
    numberEras = FALSE,
    exposedTime = FALSE,
    timeToExposure = FALSE,
    initialQuantity = TRUE,
    cumulativeQuantity = TRUE,
    initialDailyDose = TRUE,
    cumulativeDose = TRUE,
    nameStyle = "{value}_{concept_name}_{ingredient}",
    name = "drug_utilisation_example"
  )

cdm$drug_utilisation_example |>
  dplyr::glimpse()
#> Rows: ??
#> Columns: 13
#> Database: DuckDB v1.0.0 [root@Darwin 23.4.0:R 4.4.1/:memory:]
#> $ cohort_definition_id                                                <int> 1,…
#> $ subject_id                                                          <int> 2,…
#> $ cohort_start_date                                                   <date> 2…
#> $ cohort_end_date                                                     <date> 2…
#> $ future_observation                                                  <date> 2…
#> $ cumulative_quantity_ingredient_1503297_descendants                  <dbl> 0,…
#> $ cumulative_quantity_ingredient_1125315_descendants                  <dbl> 0,…
#> $ initial_quantity_ingredient_1125315_descendants                     <dbl> 0,…
#> $ initial_quantity_ingredient_1503297_descendants                     <dbl> 0,…
#> $ cumulative_dose_milligram_ingredient_1125315_descendants_1125315    <dbl> 0,…
#> $ initial_daily_dose_milligram_ingredient_1125315_descendants_1125315 <dbl> 0,…
#> $ cumulative_dose_milligram_ingredient_1503297_descendants_1503297    <dbl> 0,…
#> $ initial_daily_dose_milligram_ingredient_1503297_descendants_1503297 <dbl> 0,…

Summarise drug utilisation information

The information given by addDrugUtilisation() or its sub-functions is at patient level. If we are interested in aggregated estimates for these measure we can use summariseDrugUtilisation().

summariseDrugUtilisation()

This function will provide the desired estimates (set in the argument estimates) of the targeted drug utilisation measures. Similar to addDrugUtilisation(), by setting TRUE or FALSE each of the drug utilisation measures, the user can choose which measures to obtain.

duResults <- summariseDrugUtilisation(
  cohort = cdm$cohort1,
  strata = list(),
  estimates = c(
    "q25", "median", "q75", "mean", "sd", "count_missing",
    "percentage_missing"
  ),
  indexDate = "cohort_start_date",
  censorDate = "cohort_end_date",
  ingredientConceptId = c(1125315, 1503297),
  conceptSet = NULL,
  restrictIncident = TRUE,
  gapEra = 7,
  numberExposures = TRUE,
  numberEras = TRUE,
  exposedTime = TRUE,
  timeToExposure = TRUE,
  initialQuantity = TRUE,
  cumulativeQuantity = TRUE,
  initialDailyDose = TRUE,
  cumulativeDose = TRUE
)

duResults |>
  dplyr::glimpse()
#> Rows: 342
#> Columns: 13
#> $ result_id        <int> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,…
#> $ cdm_name         <chr> "DUS MOCK", "DUS MOCK", "DUS MOCK", "DUS MOCK", "DUS …
#> $ group_name       <chr> "cohort_name", "cohort_name", "cohort_name", "cohort_…
#> $ group_level      <chr> "cohort_1", "cohort_1", "cohort_1", "cohort_1", "coho…
#> $ strata_name      <chr> "overall", "overall", "overall", "overall", "overall"…
#> $ strata_level     <chr> "overall", "overall", "overall", "overall", "overall"…
#> $ variable_name    <chr> "number records", "number subjects", "number exposure…
#> $ variable_level   <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
#> $ estimate_name    <chr> "count", "count", "q25", "median", "q75", "mean", "sd…
#> $ estimate_type    <chr> "integer", "integer", "integer", "integer", "integer"…
#> $ estimate_value   <chr> "67", "67", "0", "0", "0", "0.164179104477612", "0.41…
#> $ additional_name  <chr> "overall", "overall", "concept_set", "concept_set", "…
#> $ additional_level <chr> "overall", "overall", "ingredient_1503297_descendants…

As seen below, the result of this function is a summarised_result object. For more information on these class of objects see omopgenerics package.

Additionally, the strata argument will provide the estimates for different stratifications defined by columns in the cohort. For instance, we can add a column indicating the sex, and another indicating if the subject is older than 50, and use those to stratify by sex and age, together and separately as follows:

duResults <- cdm$cohort1 |>
  # add age and sex
  PatientProfiles::addDemographics(
    age = TRUE,
    ageGroup = list("<=50" = c(0, 50), ">50" = c(51, 150)),
    sex = TRUE,
    priorObservation = FALSE,
    futureObservation = FALSE
  ) |>
  # drug utilisation
  summariseDrugUtilisation(
    strata = list("age_group", "sex", c("age_group", "sex")),
    estimates = c("mean", "sd", "count_missing", "percentage_missing"),
    indexDate = "cohort_start_date",
    censorDate = "cohort_end_date",
    ingredientConceptId = c(1125315, 1503297),
    conceptSet = NULL,
    restrictIncident = TRUE,
    gapEra = 7,
    numberExposures = TRUE,
    numberEras = TRUE,
    exposedTime = TRUE,
    timeToExposure = TRUE,
    initialQuantity = TRUE,
    cumulativeQuantity = TRUE,
    initialDailyDose = TRUE,
    cumulativeDose = TRUE
  )

duResults |>
  dplyr::glimpse()
#> Rows: 1,782
#> Columns: 13
#> $ result_id        <int> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,…
#> $ cdm_name         <chr> "DUS MOCK", "DUS MOCK", "DUS MOCK", "DUS MOCK", "DUS …
#> $ group_name       <chr> "cohort_name", "cohort_name", "cohort_name", "cohort_…
#> $ group_level      <chr> "cohort_1", "cohort_1", "cohort_1", "cohort_1", "coho…
#> $ strata_name      <chr> "age_group", "age_group", "age_group", "age_group", "…
#> $ strata_level     <chr> "<=50", "<=50", "<=50", "<=50", "<=50", "<=50", "<=50…
#> $ variable_name    <chr> "number records", "number subjects", "number exposure…
#> $ variable_level   <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
#> $ estimate_name    <chr> "count", "count", "mean", "sd", "count_missing", "per…
#> $ estimate_type    <chr> "integer", "integer", "numeric", "numeric", "integer"…
#> $ estimate_value   <chr> "59", "59", "0.169491525423729", "0.421513789723353",…
#> $ additional_name  <chr> "overall", "overall", "concept_set", "concept_set", "…
#> $ additional_level <chr> "overall", "overall", "ingredient_1503297_descendants…

The estimates obtained in this last part correspond to the mean (mean) and standard deviation (sd) of those that had information on dose and quantity, and the number (count_missing) (and percentage (percentage_missing)) of subjects with missing information.

tableDrugUtilisation()

Results from summariseDrugUtilisation() can be nicely visualised in a tabular format using the function tableDrugUtilisation().

tableDrugUtilisation(duResults)
#> ! Results have not been suppressed.
#> ℹ <median> (<q25> - <q75>) has not been formatted.
Cohort name
Cohort 1 Cohort 2 Cohort 3
Age group
<=50 >50 <=50 >50 Overall <=50 >50 <=50 >50 Overall <=50 >50 <=50 >50 Overall
Database name Variable Unit Estimate name Concept set Ingredient Sex
Overall Overall Female Male Female Male Overall Female Male Overall Overall Female Male Female Male Overall Female Male Overall Overall Female Male Female Male Overall Female Male
DUS MOCK Number records - N Overall Overall 59 8 27 32 4 4 67 31 36 56 6 27 29 2 4 62 29 33 64 7 28 36 2 5 71 30 41
Number subjects - N Overall Overall 59 8 27 32 4 4 67 31 36 56 6 27 29 2 4 62 29 33 64 7 28 36 2 5 71 30 41
Number exposures - N (%) Ingredient 1503297 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1503297 descendants Overall 0.17 (0.42) 0.12 (0.35) 0.11 (0.42) 0.22 (0.42) 0.00 (0.00) 0.25 (0.50) 0.16 (0.41) 0.10 (0.40) 0.22 (0.42) 0.20 (0.40) 0.00 (0.00) 0.22 (0.42) 0.17 (0.38) 0.00 (0.00) 0.00 (0.00) 0.18 (0.39) 0.21 (0.41) 0.15 (0.36) 0.25 (0.50) 0.00 (0.00) 0.18 (0.48) 0.31 (0.52) 0.00 (0.00) 0.00 (0.00) 0.23 (0.48) 0.17 (0.46) 0.27 (0.50)
N (%) Ingredient 1125315 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1125315 descendants Overall 0.17 (0.38) 0.12 (0.35) 0.22 (0.42) 0.12 (0.34) 0.25 (0.50) 0.00 (0.00) 0.16 (0.37) 0.23 (0.43) 0.11 (0.32) 0.27 (0.52) 0.17 (0.41) 0.44 (0.64) 0.10 (0.31) 0.00 (0.00) 0.25 (0.50) 0.26 (0.51) 0.41 (0.63) 0.12 (0.33) 0.25 (0.56) 0.14 (0.38) 0.25 (0.44) 0.25 (0.65) 0.00 (0.00) 0.20 (0.45) 0.24 (0.55) 0.23 (0.43) 0.24 (0.62)
Time to exposure - N (%) Ingredient 1503297 descendants Overall 50 (84.75 %) 7 (87.50 %) 25 (92.59 %) 25 (78.12 %) 4 (100.00 %) 3 (75.00 %) 57 (85.07 %) 29 (93.55 %) 28 (77.78 %) 45 (80.36 %) 6 (100.00 %) 21 (77.78 %) 24 (82.76 %) 2 (100.00 %) 4 (100.00 %) 51 (82.26 %) 23 (79.31 %) 28 (84.85 %) 50 (78.12 %) 7 (100.00 %) 24 (85.71 %) 26 (72.22 %) 2 (100.00 %) 5 (100.00 %) 57 (80.28 %) 26 (86.67 %) 31 (75.61 %)
Mean (SD) Ingredient 1503297 descendants Overall 161.33 (188.09) - 11.00 (5.66) 204.29 (193.59) - - 168.40 (178.73) 11.00 (5.66) 207.75 (179.50) 529.55 (440.70) - 690.00 (415.29) 337.00 (430.11) - - 529.55 (440.70) 690.00 (415.29) 337.00 (430.11) 890.50 (2,478.89) - 654.50 (402.45) 984.90 (2,964.34) - - 890.50 (2,478.89) 654.50 (402.45) 984.90 (2,964.34)
N (%) Ingredient 1125315 descendants Overall 49 (83.05 %) 7 (87.50 %) 21 (77.78 %) 28 (87.50 %) 3 (75.00 %) 4 (100.00 %) 56 (83.58 %) 24 (77.42 %) 32 (88.89 %) 43 (76.79 %) 5 (83.33 %) 17 (62.96 %) 26 (89.66 %) 2 (100.00 %) 3 (75.00 %) 48 (77.42 %) 19 (65.52 %) 29 (87.88 %) 51 (79.69 %) 6 (85.71 %) 21 (75.00 %) 30 (83.33 %) 2 (100.00 %) 4 (80.00 %) 57 (80.28 %) 23 (76.67 %) 34 (82.93 %)
Mean (SD) Ingredient 1125315 descendants Overall 475.70 (896.00) - 268.33 (251.60) 786.75 (1,444.97) - - 435.00 (860.67) 234.00 (246.99) 786.75 (1,444.97) 899.00 (1,450.91) - 1,116.10 (1,601.55) 175.33 (259.15) - - 839.71 (1,411.52) 1,116.10 (1,601.55) 148.75 (218.17) 221.23 (220.75) - 244.86 (269.59) 193.67 (167.46) - - 264.00 (265.69) 244.86 (269.59) 283.14 (281.80)
Cumulative quantity - N (%) Ingredient 1503297 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1503297 descendants Overall 9.58 (29.87) 5.00 (14.14) 8.89 (34.90) 10.16 (25.45) 0.00 (0.00) 10.00 (20.00) 9.03 (28.42) 7.74 (32.63) 10.14 (24.65) 9.21 (22.67) 0.00 (0.00) 11.15 (27.73) 7.41 (16.99) 0.00 (0.00) 0.00 (0.00) 8.32 (21.70) 10.38 (26.88) 6.52 (16.08) 10.02 (29.58) 0.00 (0.00) 11.43 (39.13) 8.92 (19.78) 0.00 (0.00) 0.00 (0.00) 9.03 (28.23) 10.67 (37.87) 7.83 (18.74)
N (%) Ingredient 1125315 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1125315 descendants Overall 7.29 (20.05) 8.75 (24.75) 9.81 (22.97) 5.16 (17.30) 17.50 (35.00) 0.00 (0.00) 7.46 (20.46) 10.81 (24.22) 4.58 (16.36) 11.79 (24.00) 0.83 (2.04) 19.26 (29.64) 4.83 (14.55) 0.00 (0.00) 1.25 (2.50) 10.73 (23.03) 17.93 (28.99) 4.39 (13.68) 9.64 (26.24) 5.00 (13.23) 8.64 (23.22) 10.42 (28.67) 0.00 (0.00) 7.00 (15.65) 9.18 (25.23) 8.07 (22.51) 10.00 (27.29)
Initial quantity - N (%) Ingredient 1503297 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1503297 descendants Overall 9.58 (29.87) 5.00 (14.14) 8.89 (34.90) 10.16 (25.45) 0.00 (0.00) 10.00 (20.00) 9.03 (28.42) 7.74 (32.63) 10.14 (24.65) 9.21 (22.67) 0.00 (0.00) 11.15 (27.73) 7.41 (16.99) 0.00 (0.00) 0.00 (0.00) 8.32 (21.70) 10.38 (26.88) 6.52 (16.08) 8.45 (20.70) 0.00 (0.00) 7.86 (22.17) 8.92 (19.78) 0.00 (0.00) 0.00 (0.00) 7.62 (19.80) 7.33 (21.49) 7.83 (18.74)
N (%) Ingredient 1125315 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1125315 descendants Overall 7.29 (20.05) 8.75 (24.75) 9.81 (22.97) 5.16 (17.30) 17.50 (35.00) 0.00 (0.00) 7.46 (20.46) 10.81 (24.22) 4.58 (16.36) 10.36 (20.99) 0.83 (2.04) 16.30 (25.18) 4.83 (14.55) 0.00 (0.00) 1.25 (2.50) 9.44 (20.15) 15.17 (24.62) 4.39 (13.68) 8.08 (21.23) 5.00 (13.23) 8.64 (23.22) 7.64 (19.87) 0.00 (0.00) 7.00 (15.65) 7.77 (20.53) 8.07 (22.51) 7.56 (19.24)
Number eras - N (%) Ingredient 1503297 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1503297 descendants Overall 0.15 (0.36) 0.12 (0.35) 0.07 (0.27) 0.22 (0.42) 0.00 (0.00) 0.25 (0.50) 0.15 (0.36) 0.06 (0.25) 0.22 (0.42) 0.20 (0.40) 0.00 (0.00) 0.22 (0.42) 0.17 (0.38) 0.00 (0.00) 0.00 (0.00) 0.18 (0.39) 0.21 (0.41) 0.15 (0.36) 0.22 (0.42) 0.00 (0.00) 0.14 (0.36) 0.28 (0.45) 0.00 (0.00) 0.00 (0.00) 0.20 (0.40) 0.13 (0.35) 0.24 (0.43)
N (%) Ingredient 1125315 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1125315 descendants Overall 0.17 (0.38) 0.12 (0.35) 0.22 (0.42) 0.12 (0.34) 0.25 (0.50) 0.00 (0.00) 0.16 (0.37) 0.23 (0.43) 0.11 (0.32) 0.23 (0.43) 0.17 (0.41) 0.37 (0.49) 0.10 (0.31) 0.00 (0.00) 0.25 (0.50) 0.23 (0.42) 0.34 (0.48) 0.12 (0.33) 0.22 (0.45) 0.14 (0.38) 0.25 (0.44) 0.19 (0.47) 0.00 (0.00) 0.20 (0.45) 0.21 (0.44) 0.23 (0.43) 0.20 (0.46)
Exposed time - N (%) Ingredient 1503297 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1503297 descendants Overall 83.81 (535.92) 55.88 (158.04) 1.15 (5.22) 153.56 (725.51) 0.00 (0.00) 111.75 (223.50) 80.48 (505.10) 1.00 (4.88) 148.92 (686.05) 160.84 (689.60) 0.00 (0.00) 315.07 (977.41) 17.24 (52.18) 0.00 (0.00) 0.00 (0.00) 145.27 (656.56) 293.34 (945.35) 15.15 (49.15) 63.25 (324.69) 0.00 (0.00) 132.64 (486.18) 9.28 (23.93) 0.00 (0.00) 0.00 (0.00) 57.01 (308.61) 123.80 (470.32) 8.15 (22.60)
N (%) Ingredient 1125315 descendants Overall 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1125315 descendants Overall 53.47 (250.77) 8.00 (22.63) 41.07 (175.75) 63.94 (302.49) 16.00 (32.00) 0.00 (0.00) 48.04 (235.66) 37.84 (164.15) 56.83 (285.41) 95.12 (366.82) 1.00 (2.45) 184.93 (516.77) 11.52 (36.32) 0.00 (0.00) 1.50 (3.00) 86.02 (349.44) 172.17 (500.25) 10.30 (34.14) 42.17 (130.07) 311.14 (823.21) 66.18 (172.67) 23.50 (81.44) 0.00 (0.00) 435.60 (974.03) 68.69 (282.55) 61.77 (167.45) 73.76 (345.42)
Cumulative dose Milligram N (%) Ingredient 1125315 descendants Acetaminophen 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1125315 descendants Acetaminophen 47,760.94 (176,351.83) 3,333.33 (9,428.09) 48,451.35 (193,267.21) 47,178.40 (163,885.97) 6,666.67 (13,333.33) 0.00 (0.00) 42,456.15 (165,983.09) 43,059.78 (180,533.80) 41,936.35 (154,968.28) 20,754.20 (75,976.96) 47.17 (115.54) 37,360.46 (105,503.27) 5,293.20 (22,123.83) 0.00 (0.00) 70.75 (141.51) 18,750.29 (72,407.23) 34,783.87 (102,121.00) 4,660.18 (20,767.25) 42,205.07 (141,697.91) 2,500.00 (6,614.38) 23,714.54 (57,944.39) 56,586.60 (181,836.65) 0.00 (0.00) 3,500.00 (7,826.24) 38,290.49 (134,967.86) 22,133.57 (56,233.41) 50,112.62 (171,017.35)
Initial daily dose Milligram N (%) Ingredient 1125315 descendants Acetaminophen 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1125315 descendants Acetaminophen 3,529.39 (24,997.54) 52.08 (147.31) 203.06 (663.40) 6,335.97 (33,926.21) 104.17 (208.33) 0.00 (0.00) 3,114.19 (23,461.18) 190.30 (622.01) 5,631.97 (31,992.56) 303.22 (1,343.73) 7.86 (19.26) 581.91 (1,906.58) 43.75 (163.45) 0.00 (0.00) 11.79 (23.58) 274.64 (1,278.98) 541.78 (1,843.34) 39.88 (153.43) 6,179.16 (36,951.51) 1.15 (3.04) 3,134.25 (13,756.50) 8,547.43 (47,943.44) 0.00 (0.00) 1.61 (3.59) 5,570.06 (35,104.32) 2,925.30 (13,297.46) 7,505.25 (44,936.26)
Cumulative dose Milligram N (%) Ingredient 1503297 descendants Metformin 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1503297 descendants Metformin 4,854.79 (17,334.58) 5,000.00 (14,142.14) 4,148.15 (16,972.16) 5,451.03 (17,883.16) 0.00 (0.00) 10,000.00 (20,000.00) 4,872.13 (16,890.22) 3,612.90 (15,863.33) 5,956.47 (17,878.64) 5,442.23 (18,371.73) 0.00 (0.00) 9,851.85 (25,612.05) 1,336.73 (4,202.06) 0.00 (0.00) 0.00 (0.00) 4,915.57 (17,520.07) 9,172.41 (24,810.81) 1,174.70 (3,955.56) 4,796.30 (14,853.46) 0.00 (0.00) 7,094.56 (21,289.44) 3,008.76 (6,322.25) 0.00 (0.00) 0.00 (0.00) 4,323.42 (14,164.62) 6,621.59 (20,620.92) 2,641.84 (5,997.33)
Initial daily dose Milligram N (%) Ingredient 1503297 descendants Metformin 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %) 0 (0.00 %)
Mean (SD) Ingredient 1503297 descendants Metformin 2,123.99 (12,438.83) 11.19 (31.64) 1,287.04 (6,490.64) 2,830.17 (15,906.80) 0.00 (0.00) 22.37 (44.74) 1,871.72 (11,681.04) 1,120.97 (6,058.35) 2,518.20 (14,997.00) 212.59 (1,338.53) 0.00 (0.00) 29.85 (90.37) 382.73 (1,857.30) 0.00 (0.00) 0.00 (0.00) 192.02 (1,272.57) 27.79 (87.42) 336.34 (1,741.97) 138.68 (450.02) 0.00 (0.00) 16.09 (58.00) 234.03 (583.58) 0.00 (0.00) 0.00 (0.00) 125.01 (428.95) 15.02 (56.11) 205.49 (551.37)

By default, it returns a gt table object, in which strata is split and both cohort name (group columns in the summarised result) and strata are in the table’s header. However, this dispositions can be customised, for instance:

tableDrugUtilisation(
  duResults,
  header = c("group", "estimate"),
  splitStrata = FALSE,
  cohortName = TRUE,
  cdmName = FALSE,
  conceptSet = TRUE,
  ingredient = TRUE,
  groupColumn = list("Strata" = c("strata_name", "strata_level")),
  type = "flextable",
  formatEstimateName = c(
    `Missing, N (%)` = "<count_missing> (<percentage_missing> %)",
    N = "<count>",
    `Non-missing, Mean (SD)` = "<mean> (<sd>)"
  )
)
#> ! Results have not been suppressed.

Strata

Variable

Unit

Concept set

Ingredient

Cohort name

Cohort 1

Cohort 2

Cohort 3

N

Missing, N (%)

Non-missing, Mean (SD)

N

Missing, N (%)

Non-missing, Mean (SD)

N

Missing, N (%)

Non-missing, Mean (SD)

Age group and sex; <=50 and female

Number records

-

Overall

Overall

27

-

-

27

-

-

28

-

-

Number subjects

-

Overall

Overall

27

-

-

27

-

-

28

-

-

Number exposures

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.11 (0.42)

-

0 (0.00 %)

0.22 (0.42)

-

0 (0.00 %)

0.18 (0.48)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.22 (0.42)

-

0 (0.00 %)

0.44 (0.64)

-

0 (0.00 %)

0.25 (0.44)

Time to exposure

-

Ingredient 1503297 descendants

Overall

-

25 (92.59 %)

11.00 (5.66)

-

21 (77.78 %)

690.00 (415.29)

-

24 (85.71 %)

654.50 (402.45)

Ingredient 1125315 descendants

Overall

-

21 (77.78 %)

268.33 (251.60)

-

17 (62.96 %)

1,116.10 (1,601.55)

-

21 (75.00 %)

244.86 (269.59)

Cumulative quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

8.89 (34.90)

-

0 (0.00 %)

11.15 (27.73)

-

0 (0.00 %)

11.43 (39.13)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

9.81 (22.97)

-

0 (0.00 %)

19.26 (29.64)

-

0 (0.00 %)

8.64 (23.22)

Initial quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

8.89 (34.90)

-

0 (0.00 %)

11.15 (27.73)

-

0 (0.00 %)

7.86 (22.17)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

9.81 (22.97)

-

0 (0.00 %)

16.30 (25.18)

-

0 (0.00 %)

8.64 (23.22)

Number eras

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.07 (0.27)

-

0 (0.00 %)

0.22 (0.42)

-

0 (0.00 %)

0.14 (0.36)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.22 (0.42)

-

0 (0.00 %)

0.37 (0.49)

-

0 (0.00 %)

0.25 (0.44)

Exposed time

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

1.15 (5.22)

-

0 (0.00 %)

315.07 (977.41)

-

0 (0.00 %)

132.64 (486.18)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

41.07 (175.75)

-

0 (0.00 %)

184.93 (516.77)

-

0 (0.00 %)

66.18 (172.67)

Cumulative dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

48,451.35 (193,267.21)

-

0 (0.00 %)

37,360.46 (105,503.27)

-

0 (0.00 %)

23,714.54 (57,944.39)

Initial daily dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

203.06 (663.40)

-

0 (0.00 %)

581.91 (1,906.58)

-

0 (0.00 %)

3,134.25 (13,756.50)

Cumulative dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

4,148.15 (16,972.16)

-

0 (0.00 %)

9,851.85 (25,612.05)

-

0 (0.00 %)

7,094.56 (21,289.44)

Initial daily dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

1,287.04 (6,490.64)

-

0 (0.00 %)

29.85 (90.37)

-

0 (0.00 %)

16.09 (58.00)

Age group and sex; <=50 and male

Number records

-

Overall

Overall

32

-

-

29

-

-

36

-

-

Number subjects

-

Overall

Overall

32

-

-

29

-

-

36

-

-

Number exposures

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.22 (0.42)

-

0 (0.00 %)

0.17 (0.38)

-

0 (0.00 %)

0.31 (0.52)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.12 (0.34)

-

0 (0.00 %)

0.10 (0.31)

-

0 (0.00 %)

0.25 (0.65)

Time to exposure

-

Ingredient 1503297 descendants

Overall

-

25 (78.12 %)

204.29 (193.59)

-

24 (82.76 %)

337.00 (430.11)

-

26 (72.22 %)

984.90 (2,964.34)

Ingredient 1125315 descendants

Overall

-

28 (87.50 %)

786.75 (1,444.97)

-

26 (89.66 %)

175.33 (259.15)

-

30 (83.33 %)

193.67 (167.46)

Cumulative quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

10.16 (25.45)

-

0 (0.00 %)

7.41 (16.99)

-

0 (0.00 %)

8.92 (19.78)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

5.16 (17.30)

-

0 (0.00 %)

4.83 (14.55)

-

0 (0.00 %)

10.42 (28.67)

Initial quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

10.16 (25.45)

-

0 (0.00 %)

7.41 (16.99)

-

0 (0.00 %)

8.92 (19.78)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

5.16 (17.30)

-

0 (0.00 %)

4.83 (14.55)

-

0 (0.00 %)

7.64 (19.87)

Number eras

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.22 (0.42)

-

0 (0.00 %)

0.17 (0.38)

-

0 (0.00 %)

0.28 (0.45)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.12 (0.34)

-

0 (0.00 %)

0.10 (0.31)

-

0 (0.00 %)

0.19 (0.47)

Exposed time

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

153.56 (725.51)

-

0 (0.00 %)

17.24 (52.18)

-

0 (0.00 %)

9.28 (23.93)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

63.94 (302.49)

-

0 (0.00 %)

11.52 (36.32)

-

0 (0.00 %)

23.50 (81.44)

Cumulative dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

47,178.40 (163,885.97)

-

0 (0.00 %)

5,293.20 (22,123.83)

-

0 (0.00 %)

56,586.60 (181,836.65)

Initial daily dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

6,335.97 (33,926.21)

-

0 (0.00 %)

43.75 (163.45)

-

0 (0.00 %)

8,547.43 (47,943.44)

Cumulative dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

5,451.03 (17,883.16)

-

0 (0.00 %)

1,336.73 (4,202.06)

-

0 (0.00 %)

3,008.76 (6,322.25)

Initial daily dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

2,830.17 (15,906.80)

-

0 (0.00 %)

382.73 (1,857.30)

-

0 (0.00 %)

234.03 (583.58)

Age group and sex; >50 and female

Number records

-

Overall

Overall

4

-

-

2

-

-

2

-

-

Number subjects

-

Overall

Overall

4

-

-

2

-

-

2

-

-

Number exposures

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.25 (0.50)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Time to exposure

-

Ingredient 1503297 descendants

Overall

-

4 (100.00 %)

-

-

2 (100.00 %)

-

-

2 (100.00 %)

-

Ingredient 1125315 descendants

Overall

-

3 (75.00 %)

-

-

2 (100.00 %)

-

-

2 (100.00 %)

-

Cumulative quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

17.50 (35.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Initial quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

17.50 (35.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Number eras

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.25 (0.50)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Exposed time

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

16.00 (32.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Cumulative dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

6,666.67 (13,333.33)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Initial daily dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

104.17 (208.33)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Cumulative dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Initial daily dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Age group and sex; >50 and male

Number records

-

Overall

Overall

4

-

-

4

-

-

5

-

-

Number subjects

-

Overall

Overall

4

-

-

4

-

-

5

-

-

Number exposures

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.25 (0.50)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.25 (0.50)

-

0 (0.00 %)

0.20 (0.45)

Time to exposure

-

Ingredient 1503297 descendants

Overall

-

3 (75.00 %)

-

-

4 (100.00 %)

-

-

5 (100.00 %)

-

Ingredient 1125315 descendants

Overall

-

4 (100.00 %)

-

-

3 (75.00 %)

-

-

4 (80.00 %)

-

Cumulative quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

10.00 (20.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

1.25 (2.50)

-

0 (0.00 %)

7.00 (15.65)

Initial quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

10.00 (20.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

1.25 (2.50)

-

0 (0.00 %)

7.00 (15.65)

Number eras

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.25 (0.50)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.25 (0.50)

-

0 (0.00 %)

0.20 (0.45)

Exposed time

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

111.75 (223.50)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

1.50 (3.00)

-

0 (0.00 %)

435.60 (974.03)

Cumulative dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

70.75 (141.51)

-

0 (0.00 %)

3,500.00 (7,826.24)

Initial daily dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

11.79 (23.58)

-

0 (0.00 %)

1.61 (3.59)

Cumulative dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

10,000.00 (20,000.00)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Initial daily dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

22.37 (44.74)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Age group; <=50

Number records

-

Overall

Overall

59

-

-

56

-

-

64

-

-

Number subjects

-

Overall

Overall

59

-

-

56

-

-

64

-

-

Number exposures

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.17 (0.42)

-

0 (0.00 %)

0.20 (0.40)

-

0 (0.00 %)

0.25 (0.50)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.17 (0.38)

-

0 (0.00 %)

0.27 (0.52)

-

0 (0.00 %)

0.25 (0.56)

Time to exposure

-

Ingredient 1503297 descendants

Overall

-

50 (84.75 %)

161.33 (188.09)

-

45 (80.36 %)

529.55 (440.70)

-

50 (78.12 %)

890.50 (2,478.89)

Ingredient 1125315 descendants

Overall

-

49 (83.05 %)

475.70 (896.00)

-

43 (76.79 %)

899.00 (1,450.91)

-

51 (79.69 %)

221.23 (220.75)

Cumulative quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

9.58 (29.87)

-

0 (0.00 %)

9.21 (22.67)

-

0 (0.00 %)

10.02 (29.58)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

7.29 (20.05)

-

0 (0.00 %)

11.79 (24.00)

-

0 (0.00 %)

9.64 (26.24)

Initial quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

9.58 (29.87)

-

0 (0.00 %)

9.21 (22.67)

-

0 (0.00 %)

8.45 (20.70)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

7.29 (20.05)

-

0 (0.00 %)

10.36 (20.99)

-

0 (0.00 %)

8.08 (21.23)

Number eras

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.15 (0.36)

-

0 (0.00 %)

0.20 (0.40)

-

0 (0.00 %)

0.22 (0.42)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.17 (0.38)

-

0 (0.00 %)

0.23 (0.43)

-

0 (0.00 %)

0.22 (0.45)

Exposed time

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

83.81 (535.92)

-

0 (0.00 %)

160.84 (689.60)

-

0 (0.00 %)

63.25 (324.69)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

53.47 (250.77)

-

0 (0.00 %)

95.12 (366.82)

-

0 (0.00 %)

42.17 (130.07)

Cumulative dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

47,760.94 (176,351.83)

-

0 (0.00 %)

20,754.20 (75,976.96)

-

0 (0.00 %)

42,205.07 (141,697.91)

Initial daily dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

3,529.39 (24,997.54)

-

0 (0.00 %)

303.22 (1,343.73)

-

0 (0.00 %)

6,179.16 (36,951.51)

Cumulative dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

4,854.79 (17,334.58)

-

0 (0.00 %)

5,442.23 (18,371.73)

-

0 (0.00 %)

4,796.30 (14,853.46)

Initial daily dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

2,123.99 (12,438.83)

-

0 (0.00 %)

212.59 (1,338.53)

-

0 (0.00 %)

138.68 (450.02)

Age group; >50

Number records

-

Overall

Overall

8

-

-

6

-

-

7

-

-

Number subjects

-

Overall

Overall

8

-

-

6

-

-

7

-

-

Number exposures

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.12 (0.35)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.12 (0.35)

-

0 (0.00 %)

0.17 (0.41)

-

0 (0.00 %)

0.14 (0.38)

Time to exposure

-

Ingredient 1503297 descendants

Overall

-

7 (87.50 %)

-

-

6 (100.00 %)

-

-

7 (100.00 %)

-

Ingredient 1125315 descendants

Overall

-

7 (87.50 %)

-

-

5 (83.33 %)

-

-

6 (85.71 %)

-

Cumulative quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

5.00 (14.14)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

8.75 (24.75)

-

0 (0.00 %)

0.83 (2.04)

-

0 (0.00 %)

5.00 (13.23)

Initial quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

5.00 (14.14)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

8.75 (24.75)

-

0 (0.00 %)

0.83 (2.04)

-

0 (0.00 %)

5.00 (13.23)

Number eras

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.12 (0.35)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.12 (0.35)

-

0 (0.00 %)

0.17 (0.41)

-

0 (0.00 %)

0.14 (0.38)

Exposed time

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

55.88 (158.04)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

8.00 (22.63)

-

0 (0.00 %)

1.00 (2.45)

-

0 (0.00 %)

311.14 (823.21)

Cumulative dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

3,333.33 (9,428.09)

-

0 (0.00 %)

47.17 (115.54)

-

0 (0.00 %)

2,500.00 (6,614.38)

Initial daily dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

52.08 (147.31)

-

0 (0.00 %)

7.86 (19.26)

-

0 (0.00 %)

1.15 (3.04)

Cumulative dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

5,000.00 (14,142.14)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Initial daily dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

11.19 (31.64)

-

0 (0.00 %)

0.00 (0.00)

-

0 (0.00 %)

0.00 (0.00)

Overall; Overall

Number records

-

Overall

Overall

67

-

-

62

-

-

71

-

-

Number subjects

-

Overall

Overall

67

-

-

62

-

-

71

-

-

Number exposures

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.16 (0.41)

-

0 (0.00 %)

0.18 (0.39)

-

0 (0.00 %)

0.23 (0.48)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.16 (0.37)

-

0 (0.00 %)

0.26 (0.51)

-

0 (0.00 %)

0.24 (0.55)

Time to exposure

-

Ingredient 1503297 descendants

Overall

-

57 (85.07 %)

168.40 (178.73)

-

51 (82.26 %)

529.55 (440.70)

-

57 (80.28 %)

890.50 (2,478.89)

Ingredient 1125315 descendants

Overall

-

56 (83.58 %)

435.00 (860.67)

-

48 (77.42 %)

839.71 (1,411.52)

-

57 (80.28 %)

264.00 (265.69)

Cumulative quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

9.03 (28.42)

-

0 (0.00 %)

8.32 (21.70)

-

0 (0.00 %)

9.03 (28.23)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

7.46 (20.46)

-

0 (0.00 %)

10.73 (23.03)

-

0 (0.00 %)

9.18 (25.23)

Initial quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

9.03 (28.42)

-

0 (0.00 %)

8.32 (21.70)

-

0 (0.00 %)

7.62 (19.80)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

7.46 (20.46)

-

0 (0.00 %)

9.44 (20.15)

-

0 (0.00 %)

7.77 (20.53)

Number eras

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.15 (0.36)

-

0 (0.00 %)

0.18 (0.39)

-

0 (0.00 %)

0.20 (0.40)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.16 (0.37)

-

0 (0.00 %)

0.23 (0.42)

-

0 (0.00 %)

0.21 (0.44)

Exposed time

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

80.48 (505.10)

-

0 (0.00 %)

145.27 (656.56)

-

0 (0.00 %)

57.01 (308.61)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

48.04 (235.66)

-

0 (0.00 %)

86.02 (349.44)

-

0 (0.00 %)

68.69 (282.55)

Cumulative dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

42,456.15 (165,983.09)

-

0 (0.00 %)

18,750.29 (72,407.23)

-

0 (0.00 %)

38,290.49 (134,967.86)

Initial daily dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

3,114.19 (23,461.18)

-

0 (0.00 %)

274.64 (1,278.98)

-

0 (0.00 %)

5,570.06 (35,104.32)

Cumulative dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

4,872.13 (16,890.22)

-

0 (0.00 %)

4,915.57 (17,520.07)

-

0 (0.00 %)

4,323.42 (14,164.62)

Initial daily dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

1,871.72 (11,681.04)

-

0 (0.00 %)

192.02 (1,272.57)

-

0 (0.00 %)

125.01 (428.95)

Sex; Female

Number records

-

Overall

Overall

31

-

-

29

-

-

30

-

-

Number subjects

-

Overall

Overall

31

-

-

29

-

-

30

-

-

Number exposures

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.10 (0.40)

-

0 (0.00 %)

0.21 (0.41)

-

0 (0.00 %)

0.17 (0.46)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.23 (0.43)

-

0 (0.00 %)

0.41 (0.63)

-

0 (0.00 %)

0.23 (0.43)

Time to exposure

-

Ingredient 1503297 descendants

Overall

-

29 (93.55 %)

11.00 (5.66)

-

23 (79.31 %)

690.00 (415.29)

-

26 (86.67 %)

654.50 (402.45)

Ingredient 1125315 descendants

Overall

-

24 (77.42 %)

234.00 (246.99)

-

19 (65.52 %)

1,116.10 (1,601.55)

-

23 (76.67 %)

244.86 (269.59)

Cumulative quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

7.74 (32.63)

-

0 (0.00 %)

10.38 (26.88)

-

0 (0.00 %)

10.67 (37.87)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

10.81 (24.22)

-

0 (0.00 %)

17.93 (28.99)

-

0 (0.00 %)

8.07 (22.51)

Initial quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

7.74 (32.63)

-

0 (0.00 %)

10.38 (26.88)

-

0 (0.00 %)

7.33 (21.49)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

10.81 (24.22)

-

0 (0.00 %)

15.17 (24.62)

-

0 (0.00 %)

8.07 (22.51)

Number eras

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.06 (0.25)

-

0 (0.00 %)

0.21 (0.41)

-

0 (0.00 %)

0.13 (0.35)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.23 (0.43)

-

0 (0.00 %)

0.34 (0.48)

-

0 (0.00 %)

0.23 (0.43)

Exposed time

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

1.00 (4.88)

-

0 (0.00 %)

293.34 (945.35)

-

0 (0.00 %)

123.80 (470.32)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

37.84 (164.15)

-

0 (0.00 %)

172.17 (500.25)

-

0 (0.00 %)

61.77 (167.45)

Cumulative dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

43,059.78 (180,533.80)

-

0 (0.00 %)

34,783.87 (102,121.00)

-

0 (0.00 %)

22,133.57 (56,233.41)

Initial daily dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

190.30 (622.01)

-

0 (0.00 %)

541.78 (1,843.34)

-

0 (0.00 %)

2,925.30 (13,297.46)

Cumulative dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

3,612.90 (15,863.33)

-

0 (0.00 %)

9,172.41 (24,810.81)

-

0 (0.00 %)

6,621.59 (20,620.92)

Initial daily dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

1,120.97 (6,058.35)

-

0 (0.00 %)

27.79 (87.42)

-

0 (0.00 %)

15.02 (56.11)

Sex; Male

Number records

-

Overall

Overall

36

-

-

33

-

-

41

-

-

Number subjects

-

Overall

Overall

36

-

-

33

-

-

41

-

-

Number exposures

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.22 (0.42)

-

0 (0.00 %)

0.15 (0.36)

-

0 (0.00 %)

0.27 (0.50)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.11 (0.32)

-

0 (0.00 %)

0.12 (0.33)

-

0 (0.00 %)

0.24 (0.62)

Time to exposure

-

Ingredient 1503297 descendants

Overall

-

28 (77.78 %)

207.75 (179.50)

-

28 (84.85 %)

337.00 (430.11)

-

31 (75.61 %)

984.90 (2,964.34)

Ingredient 1125315 descendants

Overall

-

32 (88.89 %)

786.75 (1,444.97)

-

29 (87.88 %)

148.75 (218.17)

-

34 (82.93 %)

283.14 (281.80)

Cumulative quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

10.14 (24.65)

-

0 (0.00 %)

6.52 (16.08)

-

0 (0.00 %)

7.83 (18.74)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

4.58 (16.36)

-

0 (0.00 %)

4.39 (13.68)

-

0 (0.00 %)

10.00 (27.29)

Initial quantity

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

10.14 (24.65)

-

0 (0.00 %)

6.52 (16.08)

-

0 (0.00 %)

7.83 (18.74)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

4.58 (16.36)

-

0 (0.00 %)

4.39 (13.68)

-

0 (0.00 %)

7.56 (19.24)

Number eras

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

0.22 (0.42)

-

0 (0.00 %)

0.15 (0.36)

-

0 (0.00 %)

0.24 (0.43)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

0.11 (0.32)

-

0 (0.00 %)

0.12 (0.33)

-

0 (0.00 %)

0.20 (0.46)

Exposed time

-

Ingredient 1503297 descendants

Overall

-

0 (0.00 %)

148.92 (686.05)

-

0 (0.00 %)

15.15 (49.15)

-

0 (0.00 %)

8.15 (22.60)

Ingredient 1125315 descendants

Overall

-

0 (0.00 %)

56.83 (285.41)

-

0 (0.00 %)

10.30 (34.14)

-

0 (0.00 %)

73.76 (345.42)

Cumulative dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

41,936.35 (154,968.28)

-

0 (0.00 %)

4,660.18 (20,767.25)

-

0 (0.00 %)

50,112.62 (171,017.35)

Initial daily dose

Milligram

Ingredient 1125315 descendants

Acetaminophen

-

0 (0.00 %)

5,631.97 (31,992.56)

-

0 (0.00 %)

39.88 (153.43)

-

0 (0.00 %)

7,505.25 (44,936.26)

Cumulative dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

5,956.47 (17,878.64)

-

0 (0.00 %)

1,174.70 (3,955.56)

-

0 (0.00 %)

2,641.84 (5,997.33)

Initial daily dose

Milligram

Ingredient 1503297 descendants

Metformin

-

0 (0.00 %)

2,518.20 (14,997.00)

-

0 (0.00 %)

336.34 (1,741.97)

-

0 (0.00 %)

205.49 (551.37)