Set Up

This page provides a sample Eligibility Report generated using gsm.kri package. Expand the “Setup” section below to see the code used to generate the report. Or scroll down for the standard report output.

Setup
# Load libraries
library(dplyr)
library(purrr)
library(gsm.core)
library(gsm.kri)
library(gsm.mapping)
library(gsm.qtl)

# Prepare example data

dfResults <- gsm.core::reportingResults_study %>%
  filter(MetricID %in% "Analysis_qtl0001") %>%
  mutate(MetricID = "study_eligibility")

dfMetrics <- gsm.core::reportingMetrics_study %>%
  filter(MetricID %in% "Analysis_qtl0001") %>%
  mutate(MetricID = "study_eligibility")

dfGroups <- gsm.core::reportingGroups_study

mappings_wf <- gsm.core::MakeWorkflowList(
  strNames = c("IE", "EXCLUSION", "ENROLL", "PD"),
  strPath = "workflow/1_mappings",
  strPackage = "gsm.mapping"
)

mappings_spec <- gsm.mapping::CombineSpecs(mappings_wf)

lRaw <- map_depth(
  list(gsm.core::lSource),
  1,
  gsm.mapping::Ingest,
  mappings_spec
)
## ℹ Ingesting data for ENROLL.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 1000 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for IE.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 255 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for PD.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 3000 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for IE.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 255 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for ENROLL.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 1000 rows returned.
## Disconnected from temporary DuckDB connection.
## ℹ Ingesting data for PD.
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 3000 rows returned.
## Disconnected from temporary DuckDB connection.
mapped <- map_depth(lRaw, 1, ~ gsm.core::RunWorkflows(mappings_wf, .x))
## 
## ── Running 4 Workflows ─────────────────────────────────────────────────────────
## 
## ── Initializing `Mapped_ENROLL` Workflow ───────────────────────────────────────
## 
## ── Checking data against spec
## → All 1 data.frame(s) in the spec are present in the data: Raw_ENROLL
## → All specified columns in Raw_ENROLL are in the expected format
## → All 7 specified column(s) in the spec are present in the data: Raw_ENROLL$studyid, Raw_ENROLL$invid, Raw_ENROLL$country, Raw_ENROLL$subjid, Raw_ENROLL$subjectid, Raw_ENROLL$enrollyn, Raw_ENROLL$enroll_dt
## 
## ── Workflow Step 1 of 1: `=` ──
## 
## ── Evaluating 2 parameter(s) for `=`
## ℹ lhs = Mapped_ENROLL: No matching data found. Passing 'Mapped_ENROLL' as a string.
## ✔ rhs = Raw_ENROLL: Passing lData$Raw_ENROLL.
## 
## ── Calling `=`
## 
## ── 1000x7 data.frame saved as `lData$Mapped_ENROLL`.
## 
## ── Returning results from final step: 1000x7 data.frame`. ──
## 
## ── Completed `Mapped_ENROLL` Workflow ──────────────────────────────────────────
## 
## ── Initializing `Mapped_IE` Workflow ───────────────────────────────────────────
## 
## ── Checking data against spec
## → All 1 data.frame(s) in the spec are present in the data: Raw_IE
## → All specified columns in Raw_IE are in the expected format
## → All 7 specified column(s) in the spec are present in the data: Raw_IE$studyid, Raw_IE$subjid, Raw_IE$tiver, Raw_IE$ietest, Raw_IE$ietestcd, Raw_IE$ieorres, Raw_IE$iecat
## 
## ── Workflow Step 1 of 3: `gsm.core::RunQuery` ──
## 
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = Raw_IE: Passing lData$Raw_IE.
## ℹ strQuery = SELECT *, CASE WHEN ietestcd ILIKE '%EXC%' THEN 'EX' WHEN ietestcd ILIKE '%INC%' THEN 'IN' END as iecat_custom FROM df: No matching data found. Passing 'SELECT *, CASE WHEN ietestcd ILIKE '%EXC%' THEN 'EX' WHEN ietestcd ILIKE '%INC%' THEN 'IN' END as iecat_custom FROM df' as a string.
## 
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 255 rows returned.
## Disconnected from temporary DuckDB connection.
## 
## ── 255x8 data.frame saved as `lData$iecat_custom`.
## 
## ── Workflow Step 2 of 3: `gsm.core::RunQuery` ──
## 
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = iecat_custom: Passing lData$iecat_custom.
## ℹ strQuery = SELECT * , CASE WHEN iecat_custom = 'EX' AND ieorres = 'Yes' then 'Y' WHEN iecat_custom = 'IN' AND ieorres = 'No' then 'Y' END as ie_violation FROM df: No matching data found. Passing 'SELECT * , CASE WHEN iecat_custom = 'EX' AND ieorres = 'Yes' then 'Y' WHEN iecat_custom = 'IN' AND ieorres = 'No' then 'Y' END as ie_violation FROM df' as a string.
## 
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 255 rows returned.
## Disconnected from temporary DuckDB connection.
## 
## ── 255x9 data.frame saved as `lData$ie_violation`.
## 
## ── Workflow Step 3 of 3: `gsm.core::RunQuery` ──
## 
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = ie_violation: Passing lData$ie_violation.
## ℹ strQuery = SELECT * FROM df WHERE subjid IS NOT NULL AND ie_violation = 'Y': No matching data found. Passing 'SELECT * FROM df WHERE subjid IS NOT NULL AND ie_violation = 'Y'' as a string.
## 
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 122 rows returned.
## Disconnected from temporary DuckDB connection.
## 
## ── 122x9 data.frame saved as `lData$Mapped_IE`.
## 
## ── Returning results from final step: 122x9 data.frame`. ──
## 
## ── Completed `Mapped_IE` Workflow ──────────────────────────────────────────────
## 
## ── Initializing `Mapped_PD` Workflow ───────────────────────────────────────────
## 
## ── Checking data against spec
## → All 1 data.frame(s) in the spec are present in the data: Raw_PD
## → All specified columns in Raw_PD are in the expected format
## → All 6 specified column(s) in the spec are present in the data: Raw_PD$studyid, Raw_PD$subjid, Raw_PD$deemedimportant, Raw_PD$dvdecod, Raw_PD$dvterm, Raw_PD$dvdtm
## 
## ── Workflow Step 1 of 1: `=` ──
## 
## ── Evaluating 2 parameter(s) for `=`
## ℹ lhs = Mapped_PD: No matching data found. Passing 'Mapped_PD' as a string.
## ✔ rhs = Raw_PD: Passing lData$Raw_PD.
## 
## ── Calling `=`
## 
## ── 3000x6 data.frame saved as `lData$Mapped_PD`.
## 
## ── Returning results from final step: 3000x6 data.frame`. ──
## 
## ── Completed `Mapped_PD` Workflow ──────────────────────────────────────────────
## 
## ── Initializing `Mapped_EXCLUSION` Workflow ────────────────────────────────────
## 
## ── Checking data against spec
## → All 3 data.frame(s) in the spec are present in the data: Mapped_IE, Mapped_ENROLL, Mapped_PD
## → All specified columns in Mapped_IE are in the expected format
## → All specified columns in Mapped_ENROLL are in the expected format
## → All specified columns in Mapped_PD are in the expected format
## → All 20 specified column(s) in the spec are present in the data: Mapped_IE$studyid, Mapped_IE$subjid, Mapped_IE$tiver, Mapped_IE$ietest, Mapped_IE$ietestcd, Mapped_IE$ieorres, Mapped_IE$iecat_custom, Mapped_IE$ie_violation, Mapped_ENROLL$studyid, Mapped_ENROLL$subjectid, Mapped_ENROLL$subjid, Mapped_ENROLL$invid, Mapped_ENROLL$enrollyn, Mapped_ENROLL$country, Mapped_PD$studyid, Mapped_PD$subjid, Mapped_PD$dvterm, Mapped_PD$dvdecod, Mapped_PD$deemedimportant, Mapped_PD$dvdtm
## 
## ── Workflow Step 1 of 5: `gsm.core::RunQuery` ──
## 
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = Mapped_IE: Passing lData$Mapped_IE.
## ℹ strQuery = SELECT subjid, studyid, array_to_string(array_agg(ietestcd), ',') AS ietestcd_concat, ie_violation FROM df GROUP BY studyid, subjid, ie_violation: No matching data found. Passing 'SELECT subjid, studyid, array_to_string(array_agg(ietestcd), ',') AS ietestcd_concat, ie_violation FROM df GROUP BY studyid, subjid, ie_violation' as a string.
## 
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 122 rows returned.
## Disconnected from temporary DuckDB connection.
## 
## ── 122x4 data.frame saved as `lData$pivot_ie`.
## 
## ── Workflow Step 2 of 5: `dplyr::left_join` ──
## 
## ── Evaluating 3 parameter(s) for `dplyr::left_join`
## ✔ x = Mapped_ENROLL: Passing lData$Mapped_ENROLL.
## ✔ y = pivot_ie: Passing lData$pivot_ie.
## ℹ by is of length 2: Parameter is a vector. Passing as is.
## 
## ── Calling `dplyr::left_join`
## 
## ── 1000x9 data.frame saved as `lData$add_ie`.
## 
## ── Workflow Step 3 of 5: `gsm.core::RunQuery` ──
## 
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = Mapped_PD: Passing lData$Mapped_PD.
## ℹ strQuery = SELECT studyid, subjid, array_to_string(array_agg(dvdtm), ';;;') AS dvdtm, array_to_string(array_agg(dvterm), ';;;') AS eligibility_criteria FROM df WHERE dvdecod IN ('Exclusion Criteria', 'Inclusion Criteria') GROUP BY studyid, subjid: No matching data found. Passing 'SELECT studyid, subjid, array_to_string(array_agg(dvdtm), ';;;') AS dvdtm, array_to_string(array_agg(dvterm), ';;;') AS eligibility_criteria FROM df WHERE dvdecod IN ('Exclusion Criteria', 'Inclusion Criteria') GROUP BY studyid, subjid' as a string.
## 
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 270 rows returned.
## Disconnected from temporary DuckDB connection.
## 
## ── 270x4 data.frame saved as `lData$pivot_pd`.
## 
## ── Workflow Step 4 of 5: `dplyr::left_join` ──
## 
## ── Evaluating 3 parameter(s) for `dplyr::left_join`
## ✔ x = add_ie: Passing lData$add_ie.
## ✔ y = pivot_pd: Passing lData$pivot_pd.
## ℹ by is of length 2: Parameter is a vector. Passing as is.
## 
## ── Calling `dplyr::left_join`
## 
## ── 1000x11 data.frame saved as `lData$premapped`.
## 
## ── Workflow Step 5 of 5: `gsm.core::RunQuery` ──
## 
## ── Evaluating 2 parameter(s) for `gsm.core::RunQuery`
## ✔ df = premapped: Passing lData$premapped.
## ℹ strQuery = SELECT *, CASE WHEN ie_violation = 'Y' AND eligibility_criteria IS NULL THEN 'EDC I/E only' WHEN ie_violation IS NULL AND eligibility_criteria IS NOT NULL THEN 'Eligibility IPD only' WHEN ie_violation = 'Y' AND eligibility_criteria IS NOT NULL THEN 'Ineligible, Both Criteria' ELSE 'Neither' END AS Source  FROM df WHERE enrollyn = 'Y': No matching data found. Passing 'SELECT *, CASE WHEN ie_violation = 'Y' AND eligibility_criteria IS NULL THEN 'EDC I/E only' WHEN ie_violation IS NULL AND eligibility_criteria IS NOT NULL THEN 'Eligibility IPD only' WHEN ie_violation = 'Y' AND eligibility_criteria IS NOT NULL THEN 'Ineligible, Both Criteria' ELSE 'Neither' END AS Source  FROM df WHERE enrollyn = 'Y'' as a string.
## 
## ── Calling `gsm.core::RunQuery`
## Creating a new temporary DuckDB connection.
## ✔ SQL Query complete: 769 rows returned.
## Disconnected from temporary DuckDB connection.
## 
## ── 769x12 data.frame saved as `lData$Mapped_EXCLUSION`.
## 
## ── Returning results from final step: 769x12 data.frame`. ──
## 
## ── Completed `Mapped_EXCLUSION` Workflow ───────────────────────────────────────
lListings <- list(
  IE = mapped[[1]]$Mapped_EXCLUSION
)

Ineligible Participant Overview

Study Overview

Param Value
StudyID AA-AA-000-0000
Ineligible Participants 303
Total Enrolled 769
Current Ineligible Enrolled Rate 39.4%

Time Series Chart

Bar Charts

Site

Site (by %)

Country

Source

Criteria/Site

Criteria/Country

Inclusion/Exclusion Listing

Site Country Subject ID Source Which I/E PD Date1 PD Date2 PD Date3 PD Term1 PD Term2 PD Term3
0X1750 US S29898 EDC I/E only
incl10
NA NA NA
0X4323 US S35058 EDC I/E only
incl4
NA NA NA
0X213 UK S22366 Eligibility IPD only 2012-01-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X5384 UK S61242 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X9360 Japan S6700 EDC I/E only
excl4
NA NA NA
0X2170 Japan S95738 Eligibility IPD only 2012-01-01 2012-01-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X6603 UK S99475 Eligibility IPD only 2012-01-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X958 UK S43843 Ineligible, Both Criteria
excl8
2012-02-01 NA NA
Inclusion/Exclusion description
0X759 US S89142 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X8633 Japan S6557 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X5895 Japan S42745 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X9142 Japan S13713 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X958 UK S56659 Eligibility IPD only 2012-01-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X9142 Japan S9242 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X4485 US S84022 EDC I/E only
excl5
NA NA NA
0X9346 UK S41703 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4323 US S92817 Ineligible, Both Criteria
excl10
2012-01-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X4485 US S80827 Ineligible, Both Criteria
incl9
2012-01-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X4590 US S42441 Eligibility IPD only 2012-01-01 2012-01-01 2012-03-01
Inclusion/Exclusion description
Inclusion/Exclusion description
Inclusion/Exclusion description
0X9580 UK S19156 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X6405 US S52428 Ineligible, Both Criteria
incl2
2012-02-01 NA NA
Inclusion/Exclusion description
0X3909 Japan S62190 Ineligible, Both Criteria
incl4
2012-03-01 NA NA
Inclusion/Exclusion description
0X4590 US S13289 Eligibility IPD only 2012-01-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X7011 US S90711 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X8351 UK S61706 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9737 Japan S28543 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8764 Japan S81402 EDC I/E only
excl8
NA NA NA
0X8351 UK S52552 EDC I/E only
incl7
NA NA NA
0X8517 UK S46976 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X9346 UK S10169 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X7809 Japan S34327 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X4590 US S64268 EDC I/E only
incl7
NA NA NA
0X2532 US S47175 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X9346 UK S61441 EDC I/E only
excl1
NA NA NA
0X2170 Japan S34157 Eligibility IPD only 2012-01-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X8517 UK S66721 Ineligible, Both Criteria
excl5
2012-01-01 NA NA
Inclusion/Exclusion description
0X5895 Japan S2143 Eligibility IPD only 2012-01-01 2012-01-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X9142 Japan S3285 EDC I/E only
excl3
NA NA NA
0X213 UK S40145 Ineligible, Both Criteria
incl7
2012-01-01 NA NA
Inclusion/Exclusion description
0X958 UK S52979 Eligibility IPD only 2012-01-01 2012-01-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X759 US S76424 Ineligible, Both Criteria
incl6
2012-01-01 NA NA
Inclusion/Exclusion description
0X213 UK S73715 Ineligible, Both Criteria
excl8
2012-02-01 NA NA
Inclusion/Exclusion description
0X3289 US S35204 Eligibility IPD only 2012-01-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X4323 US S44278 Eligibility IPD only 2012-01-01 2012-01-01 2012-01-01
Inclusion/Exclusion description
Inclusion/Exclusion description
Inclusion/Exclusion description
0X6405 US S6022 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X8799 UK S71069 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X9737 Japan S20971 Ineligible, Both Criteria
excl9
2012-02-01 NA NA
Inclusion/Exclusion description
0X2192 UK S36177 Eligibility IPD only 2012-01-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X4323 US S15734 Eligibility IPD only 2012-03-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X9142 Japan S61670 EDC I/E only
incl9
NA NA NA
0X9142 Japan S2969 Eligibility IPD only 2012-01-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X4629 Japan S50664 EDC I/E only
excl7
NA NA NA
0X3909 Japan S21491 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X6603 UK S32854 EDC I/E only
incl2
NA NA NA
0X213 UK S67498 EDC I/E only
incl6
NA NA NA
0X101 UK S96757 Ineligible, Both Criteria
excl9
2012-01-01 2012-01-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X4264 US S47665 Eligibility IPD only 2012-01-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X1750 US S56565 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X8625 US S83058 Eligibility IPD only 2012-01-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X5384 UK S95900 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8625 US S72389 Eligibility IPD only 2012-01-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X8354 Japan S3492 Eligibility IPD only 2012-01-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X7011 US S58315 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X2532 US S17064 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X5033 US S69485 EDC I/E only
excl4
NA NA NA
0X3289 US S42358 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X7983 US S75468 Eligibility IPD only 2012-01-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X2323 Japan S23519 EDC I/E only
incl8
NA NA NA
0X5895 Japan S50779 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X4959 US S40424 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X8091 UK S89271 Eligibility IPD only 2012-01-01 2012-01-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X2901 US S10582 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X8091 UK S61099 Eligibility IPD only 2012-01-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X4485 US S40868 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X4485 US S52444 Eligibility IPD only 2012-01-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X8788 Japan S85481 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X2192 UK S99639 Ineligible, Both Criteria
excl7
2012-01-01 NA NA
Inclusion/Exclusion description
0X8633 Japan S98371 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X1910 US S60126 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X213 UK S58498 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X2170 Japan S7173 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X2192 UK S30541 EDC I/E only
incl3
NA NA NA
0X4874 Japan S47824 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X7011 US S32805 Eligibility IPD only 2012-01-01 2012-01-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X9360 Japan S36762 Eligibility IPD only 2012-01-01 NA NA
Inclusion/Exclusion description
0X4323 US S52192 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X3508 UK S8366 Eligibility IPD only 2012-02-01 2012-02-01 2012-03-01
Inclusion/Exclusion description
Inclusion/Exclusion description
Inclusion/Exclusion description
0X5733 Japan S24175 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X7983 US S24430 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X1982 US S34322 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X4415 Japan S54155 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X8713 US S47209 EDC I/E only
incl9
NA NA NA
0X6767 Japan S81619 Eligibility IPD only 2012-02-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X4019 US S4221 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X3289 US S27209 EDC I/E only
incl9
NA NA NA
0X9043 US S78985 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4384 US S60876 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1417 US S19541 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9043 US S71362 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X6405 US S60674 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X6603 UK S58273 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X3411 UK S44132 EDC I/E only
incl3
NA NA NA
0X2192 UK S98673 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8559 Japan S10093 EDC I/E only
incl10
NA NA NA
0X5458 UK S70775 EDC I/E only
incl4
NA NA NA
0X1910 US S71223 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4629 Japan S37633 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8354 Japan S95215 EDC I/E only
incl5
NA NA NA
0X7244 US S74143 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1910 US S76127 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X5895 Japan S78898 EDC I/E only
incl4
NA NA NA
0X9119 US S97150 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X958 UK S37784 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X3289 US S3483 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X3694 Japan S12625 EDC I/E only
excl1
NA NA NA
0X2323 Japan S17819 EDC I/E only
excl10
NA NA NA
0X4415 Japan S14271 EDC I/E only
incl7
NA NA NA
0X9691 Japan S51362 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X213 UK S12703 Ineligible, Both Criteria
incl3
2012-03-01 NA NA
Inclusion/Exclusion description
0X3411 UK S24201 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X301 US S072 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X5348 Japan S57432 EDC I/E only
incl2
NA NA NA
0X759 US S23540 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X3909 Japan S2797 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X4323 US S50998 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X4323 US S85079 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6603 UK S68891 Ineligible, Both Criteria
excl5
2012-03-01 NA NA
Inclusion/Exclusion description
0X6900 Japan S51418 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X1417 US S18274 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X5733 Japan S51378 EDC I/E only
incl3
NA NA NA
0X5384 UK S3741 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1635 US S16413 EDC I/E only
excl2
NA NA NA
0X1750 US S49717 Ineligible, Both Criteria
incl3
2012-03-01 NA NA
Inclusion/Exclusion description
0X7753 US S54277 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8713 US S28406 EDC I/E only
incl4
NA NA NA
0X1257 Japan S37510 EDC I/E only
excl2
NA NA NA
0X8559 Japan S35142 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X3090 US S63308 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8786 US S84785 Ineligible, Both Criteria
excl6
2012-03-01 NA NA
Inclusion/Exclusion description
0X9691 Japan S19535 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X3508 UK S6303 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X3989 US S9194 EDC I/E only
excl10
NA NA NA
0X7011 US S78456 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X2170 Japan S16728 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X9346 UK S63832 Ineligible, Both Criteria
incl1
2012-03-01 NA NA
Inclusion/Exclusion description
0X213 UK S63030 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X4571 UK S63176 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X2170 Japan S39113 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X7289 US S2661 Eligibility IPD only 2012-02-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X5967 UK S92964 EDC I/E only
incl3
NA NA NA
0X7244 US S24630 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4485 US S40667 Eligibility IPD only 2012-03-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X8786 US S4133 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6900 Japan S38118 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X9580 UK S51805 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8633 Japan S7154 EDC I/E only
incl2
NA NA NA
0X8625 US S62473 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X9858 UK S78928 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6603 UK S52258 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X3289 US S68230 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X6767 Japan S86567 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1982 US S84760 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X7244 US S37167 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9360 Japan S74393 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X6403 Japan S24077 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X1337 Japan S40833 EDC I/E only
excl7
NA NA NA
0X6405 US S19075 Eligibility IPD only 2012-02-01 2012-02-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X3560 US S6539 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X3090 US S53155 Eligibility IPD only 2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X9346 UK S85234 EDC I/E only
excl7
NA NA NA
0X6403 Japan S56238 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9691 Japan S25650 Eligibility IPD only 2012-03-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X3989 US S7687 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4959 US S75201 EDC I/E only
incl3
NA NA NA
0X7753 US S93033 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X301 US S5056 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X2170 Japan S9976 EDC I/E only
incl1
NA NA NA
0X7011 US S47832 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X8790 Japan S4885 Ineligible, Both Criteria
excl9
2012-02-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X7809 Japan S15139 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X6405 US S66335 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X8827 Japan S94088 Ineligible, Both Criteria
incl4
2012-02-01 NA NA
Inclusion/Exclusion description
0X4044 UK S54585 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X4465 Japan S81198 EDC I/E only
incl3
NA NA NA
0X4044 UK S90822 EDC I/E only
incl3
NA NA NA
0X101 UK S50189 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X3144 US S23536 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6603 UK S3453 EDC I/E only
incl5
NA NA NA
0X826 Japan S87484 Eligibility IPD only 2012-02-01 NA NA
Inclusion/Exclusion description
0X9277 Japan S48926 EDC I/E only
incl1
NA NA NA
0X8713 US S34454 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4485 US S38678 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9556 Japan S75553 EDC I/E only
excl8
NA NA NA
0X2018 US S15062 EDC I/E only
incl4
NA NA NA
0X9401 Japan S2794 EDC I/E only
incl10
NA NA NA
0X7809 Japan S18586 EDC I/E only
incl7
NA NA NA
0X4699 Japan S9465 EDC I/E only
excl7
NA NA NA
0X2262 Japan S10703 EDC I/E only
excl8
NA NA NA
0X1333 US S42047 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4798 US S31693 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X2192 UK S81429 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9556 Japan S19923 Ineligible, Both Criteria
excl6
2012-03-01 NA NA
Inclusion/Exclusion description
0X8788 Japan S8141 EDC I/E only
excl4
NA NA NA
0X1417 US S65760 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9556 Japan S57990 EDC I/E only
excl8
NA NA NA
0X9126 UK S65660 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8517 UK S59632 EDC I/E only
excl1
NA NA NA
0X4465 Japan S84613 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9832 US S15606 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X301 US S54523 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X326 Japan S89999 EDC I/E only
excl3
NA NA NA
0X8625 US S79298 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9691 Japan S71716 Ineligible, Both Criteria
incl9
2012-03-01 NA NA
Inclusion/Exclusion description
0X2285 Japan S72804 EDC I/E only
excl5
NA NA NA
0X3989 US S58307 Eligibility IPD only 2012-03-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X5967 UK S2104 EDC I/E only
incl5
NA NA NA
0X9529 US S47053 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1982 US S86258 Ineligible, Both Criteria
excl1
2012-03-01 NA NA
Inclusion/Exclusion description
0X4231 UK S73285 EDC I/E only
excl1
NA NA NA
0X4328 Japan S47497 EDC I/E only
excl7
NA NA NA
0X288 UK S43623 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1910 US S60381 EDC I/E only
incl4
NA NA NA
0X7983 US S33260 EDC I/E only
excl2
NA NA NA
0X9360 Japan S37311 EDC I/E only
excl8
NA NA NA
0X1767 Japan S7442 EDC I/E only
incl10
NA NA NA
0X5967 UK S71658 EDC I/E only
excl3
NA NA NA
0X1996 US S35412 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4629 Japan S88390 Ineligible, Both Criteria
incl6
2012-03-01 NA NA
Inclusion/Exclusion description
0X2323 Japan S29019 EDC I/E only
incl7
NA NA NA
0X6603 UK S85665 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6712 Japan S45003 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1865 Japan S88499 EDC I/E only
incl9
NA NA NA
0X1419 UK S94236 EDC I/E only
excl9
NA NA NA
0X4384 US S39303 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6954 Japan S4504 EDC I/E only
excl6
NA NA NA
0X9126 UK S841 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X5967 UK S57756 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X9574 US S58861 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X5702 US S36274 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6405 US S9226 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X7590 US S8303 EDC I/E only
incl5
NA NA NA
0X9529 US S78357 EDC I/E only
incl6
NA NA NA
0X3090 US S3034 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8633 Japan S63190 EDC I/E only
excl2
NA NA NA
0X088 UK S63643 EDC I/E only
incl1
NA NA NA
0X6601 UK S84246 EDC I/E only
excl6
NA NA NA
0X9165 UK S70330 EDC I/E only
excl4
NA NA NA
0X9580 UK S97826 EDC I/E only
incl10
NA NA NA
0X9529 US S60167 EDC I/E only
excl10
NA NA NA
0X5733 Japan S68494 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6252 US S60689 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8788 Japan S82305 Eligibility IPD only 2012-03-01 2012-03-01 NA
Inclusion/Exclusion description
Inclusion/Exclusion description
0X8513 Japan S44765 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8091 UK S84404 EDC I/E only
excl5
NA NA NA
0X5047 Japan S36490 EDC I/E only
excl2
NA NA NA
0X3508 UK S69904 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X7106 Japan S66288 EDC I/E only
excl7
NA NA NA
0X180 UK S14672 EDC I/E only
incl7
NA NA NA
0X1996 US S59860 EDC I/E only
excl2
NA NA NA
0X9165 UK S23627 EDC I/E only
incl10
NA NA NA
0X7106 Japan S75421 EDC I/E only
excl5
NA NA NA
0X3606 Japan S4725 EDC I/E only
incl1
NA NA NA
0X9165 UK S9273 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X2901 US S77451 EDC I/E only
incl9
NA NA NA
0X3090 US S59091 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1996 US S95540 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6884 Japan S90997 EDC I/E only
incl7
NA NA NA
0X2285 Japan S98483 EDC I/E only
excl5
NA NA NA
0X5089 Japan S38735 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X7587 Japan S4299 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4571 UK S99968 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4798 US S62953 EDC I/E only
excl9
NA NA NA
0X2018 US S18250 EDC I/E only
incl2
NA NA NA
0X2788 UK S54411 Ineligible, Both Criteria
excl6
2012-03-01 NA NA
Inclusion/Exclusion description
0X2901 US S25454 EDC I/E only
incl3
NA NA NA
0X4034 US S85100 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4019 US S35357 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1337 Japan S42067 EDC I/E only
excl4
NA NA NA
0X4231 UK S19364 EDC I/E only
excl2
NA NA NA
0X3289 US S95477 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X7289 US S85026 EDC I/E only
excl5
NA NA NA
0X8625 US S4848 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X354 UK S70307 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6601 UK S19468 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X354 UK S47969 EDC I/E only
incl1
NA NA NA
0X1616 US S59092 EDC I/E only
excl7
NA NA NA
0X9556 Japan S51038 EDC I/E only
excl2
NA NA NA
0X7250 Japan S19514 EDC I/E only
incl4
NA NA NA
0X8764 Japan S20805 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X3694 Japan S74010 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4019 US S12851 EDC I/E only
excl6
NA NA NA
0X8713 US S55641 EDC I/E only
excl8
NA NA NA
0X3989 US S11217 EDC I/E only
incl5
NA NA NA
0X8799 UK S82918 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1169 UK S63151 EDC I/E only
excl2
NA NA NA
0X958 UK S93719 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X1910 US S27200 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X7590 US S9936 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X4044 UK S61093 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X2757 Japan S87835 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X2006 US S29904 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X8774 UK S15288 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description
0X6403 Japan S65333 Eligibility IPD only 2012-03-01 NA NA
Inclusion/Exclusion description

⬇️ Download CSV