adlb

adlb

Laboratory Analysis

Structure: One or more records per subject per analysis parameter per analysis timepoint

from pharmadata import pharmaverseadam

meta = pharmaverseadam.meta('adlb')
print(f"Rows: {meta.number_rows:,}  Columns: {meta.number_columns}")
Rows: 83,652  Columns: 115

Variables

Show variable specs
shape: (115, 5)
variablelabeltypemandatoryrole
strstrstrstrstr
"STUDYID""Study Identifier""String""Yes""Identifier Variables for BDS Datasets"
"USUBJID""Unique Subject Identifier""String""Yes""Identifier Variables for BDS Datasets"
"SUBJID""Subject Identifier for the Study""String""No""Identifier Variables for BDS Datasets"
"SITEID""Study Site Identifier""String""No""Identifier Variables for BDS Datasets"
"COUNTRY""Country""String""No"null
"DOMAIN""Domain Abbreviation""String""No"null
"RFSTDTC""Subject Reference Start Date/Time""String""No"null
"RFENDTC""Subject Reference End Date/Time""String""No"null
"RFXSTDTC""Date/Time of First Study Treatment""String""No"null
"RFXENDTC""Date/Time of Last Study Treatment""String""No"null
"RFPENDTC""Date/Time of End of Participation""String""No"null
"SCRFDT""Screen Failure Date""Date""No"null
"FRVDT""Final Retrieval Visit Date""Date""No"null
"DTHDTC""Date/Time of Death""String""No"null
"DTHADY""Relative Day of Death""Float64""No"null
"DTHFL""Subject Death Flag""String""No"null
"LDDTHELD""Elapsed Days from Last Dose to Death""Float64""No"null
"LDDTHGR1""Last Dose to Death - Days Elapsed Grp 1""String""No"null
"DTH30FL""Death Within 30 Days of Last Trt Flag""String""No"null
"DTHA30FL""Death After 30 Days from Last Trt Flag""String""No"null
"DTHDOM""Domain for Date of Death Collection""String""No"null
"DTHB30FL""Death Within 30 Days of First Trt Flag""String""No"null
"ASEQ""Analysis Sequence Number""Int32""No""Identifier Variables for BDS Datasets"
"REGION1""Geographic Region 1""String""No"null
"DMDTC""Date/Time of Collection""String""No"null
"DMDY""Study Day of Collection""Float64""No"null
"AGE""Age""Float64""No""ADSL Subject Demographics Variables"
"AGEU""Age Units""String""No""ADSL Subject Demographics Variables"
"AGEGR1""Pooled Age Group 1""String""No"null
"SEX""Sex""String""No""ADSL Subject Demographics Variables"
"RACE""Race""String""No""ADSL Subject Demographics Variables"
"RACEGR1""Pooled Race Group 1""String""No"null
"ETHNIC""Ethnicity""String""No"null
"SAFFL""Safety Population Flag""String""No""ADSL Population Indicator Variables"
"ARM""Description of Planned Arm""String""No""ADSL Treatment Variables"
"ARMCD""Planned Arm Code""String""No"null
"ACTARM""Description of Actual Arm""String""No""ADSL Treatment Variables"
"ACTARMCD""Actual Arm Code""String""No"null
"TRTP""Planned Treatment""String""No""Record-Level Treatment Variables for BDS Datasets"
"TRTA""Actual Treatment""String""No""Record-Level Treatment Variables for BDS Datasets"
"TRT01P""Planned Treatment for Period 01""String""No"null
"TRT01A""Actual Treatment for Period 01""String""No"null
"TRTSDT""Date of First Exposure to Treatment""Date""No""ADSL Treatment Timing Variables"
"TRTSDTM""Datetime of First Exposure to Treatment""Datetime""No""ADSL Treatment Timing Variables"
"TRTSTMF""Time of First Exposure Imput. Flag""String""No""ADSL Treatment Timing Variables"
"TRTEDT""Date of Last Exposure to Treatment""Date""No""ADSL Treatment Timing Variables"
"TRTEDTM""Datetime of Last Exposure to Treatment""Datetime""No""ADSL Treatment Timing Variables"
"TRTETMF""Time of Last Exposure Imput. Flag""String""No""ADSL Treatment Timing Variables"
"EOSSTT""End of Study Status""String""No""ADSL Subject-Level Trial Experience Variables"
"EOSDT""End of Study Date""Date""No""ADSL Subject-Level Trial Experience Variables"
"RFICDTC""Date/Time of Informed Consent""String""No"null
"RANDDT""Date of Randomization""Date""No""ADSL Subject-Level Trial Experience Variables"
"LSTALVDT""Date Last Known Alive""Date""No""ADSL Subject-Level Trial Experience Variables"
"TRTDURD""Total Treatment Duration (Days)""Float64""No""ADSL Subject-Level Trial Experience Variables"
"DTHDT""Date of Death""Date""No""ADSL Subject-Level Trial Experience Variables"
"DTHDTF""Date of Death Imputation Flag""String""No""ADSL Subject-Level Trial Experience Variables"
"DTHCAUS""Cause of Death""String""No"null
"DTHCGR1""Cause of Death Reason 1""String""No"null
"ADT""Analysis Date""Date""No""Timing Variables for BDS Datasets"
"ADY""Analysis Relative Day""Float64""No""Timing Variables for BDS Datasets"
"AVISIT""Analysis Visit""String""No""Timing Variables for BDS Datasets"
"AVISITN""Analysis Visit (N)""Float64""No""Timing Variables for BDS Datasets"
"PARAM""Parameter""String""Yes""Analysis Parameter Variables for BDS Datasets"
"PARAMCD""Parameter Code""String""Yes""Analysis Parameter Variables for BDS Datasets"
"PARAMN""Parameter (N)""Float64""No""Analysis Parameter Variables for BDS Datasets"
"PARCAT1""Parameter Category 1""String""No"null
"AVAL""Analysis Value""Float64""No""Analysis Parameter Variables for BDS Datasets"
"AVALC""Analysis Value (C)""String""No""Analysis Parameter Variables for BDS Datasets"
"BASE""Baseline Value""Float64""No""Analysis Parameter Variables for BDS Datasets"
"BASEC""Baseline Value (C)""String""No""Analysis Parameter Variables for BDS Datasets"
"BASETYPE""Baseline Type""String""No""Analysis Parameter Variables for BDS Datasets"
"CHG""Change from Baseline""Float64""No""Analysis Parameter Variables for BDS Datasets"
"PCHG""Percent Change from Baseline""Float64""No""Analysis Parameter Variables for BDS Datasets"
"R2BASE""Ratio to Baseline""Float64""No""Analysis Parameter Variables for BDS Datasets"
"R2ANRLO""Ratio of Analysis Val compared to ANRLO""Float64""No"null
"R2ANRHI""Ratio of Analysis Val compared to ANRHI""Float64""No"null
"SHIFT1""Shift from Baseline to Analysis Value""String""No"null
"SHIFT2""Shift from Baseline to Overall Grade""String""No"null
"DTYPE""Derivation Type""String""No""Analysis Descriptor Variables for BDS Datasets"
"ATOXGR""Analysis Toxicity Grade""String""No""Toxicity and Range Variables for BDS Datasets"
"BTOXGR""Baseline Toxicity Grade""String""No""Toxicity and Range Variables for BDS Datasets"
"ANRIND""Analysis Reference Range Indicator""String""No""Toxicity and Range Variables for BDS Datasets"
"BNRIND""Baseline Reference Range Indicator""String""No""Toxicity and Range Variables for BDS Datasets"
"ANRLO""Analysis Normal Range Lower Limit""Float64""No""Toxicity and Range Variables for BDS Datasets"
"ANRHI""Analysis Normal Range Upper Limit""Float64""No""Toxicity and Range Variables for BDS Datasets"
"ATOXGRL""Analysis Toxicity Grade Low""String""No"null
"ATOXGRH""Analysis Toxicity Grade High""String""No"null
"BTOXGRL""Baseline Toxicity Grade Low""String""No"null
"BTOXGRH""Baseline Toxicity Grade High""String""No"null
"ATOXDSCL""Analysis Toxicity Description Low""String""No"null
"ATOXDSCH""Analysis Toxicity Description High""String""No"null
"ABLFL""Baseline Record Flag""String""No""Flag Variables for BDS Datasets"
"ANL01FL""Analysis Flag 01""String""No"null
"ONTRTFL""On Treatment Record Flag""String""No""Flag Variables for BDS Datasets"
"LVOTFL""Last Value On Treatment Record Flag""String""No""Flag Variables for BDS Datasets"
"LBSEQ""Sequence Number""Float64""No"null
"LBTESTCD""Lab Test or Examination Short Name""String""No"null
"LBTEST""Lab Test or Examination Name""String""No"null
"LBCAT""Category for Lab Test""String""No"null
"LBORRES""Result or Finding in Original Units""String""No"null
"LBORRESU""Original Units""String""No"null
"LBORNRLO""Reference Range Lower Limit in Orig Unit""String""No"null
"LBORNRHI""Reference Range Upper Limit in Orig Unit""String""No"null
"LBSTRESC""Character Result/Finding in Std Format""String""No"null
"LBSTRESN""Numeric Result/Finding in Standard Units""Float64""No"null
"LBSTRESU""Standard Units""String""No"null
"LBSTNRLO""Reference Range Lower Limit-Std Units""Float64""No"null
"LBSTNRHI""Reference Range Upper Limit-Std Units""Float64""No"null
"LBNRIND""Reference Range Indicator""String""No"null
"LBBLFL""Baseline Flag""String""No"null
"VISITNUM""Visit Number""Float64""No"null
"VISIT""Visit Name""String""No"null
"VISITDY""Planned Study Day of Visit""Float64""No"null
"LBDTC""Date/Time of Specimen Collection""String""No"null
"LBDY""Study Day of Specimen Collection""Float64""No"null

Examples

from great_docs import tbl_explorer
from pharmadata import pharmaverseadam

tbl_explorer(pharmaverseadam.adlb.head(10))
PolarsRows10Columns115
STUDYID
str
USUBJID
str
SUBJID
str
SITEID
str
COUNTRY
str
DOMAIN
str
RFSTDTC
str
RFENDTC
str
RFXSTDTC
str
RFXENDTC
str
RFPENDTC
str
SCRFDT
date
FRVDT
date
DTHDTC
str
DTHADY
f64
DTHFL
str
LDDTHELD
f64
LDDTHGR1
str
DTH30FL
str
DTHA30FL
str
DTHDOM
str
DTHB30FL
str
ASEQ
i32
REGION1
str
DMDTC
str
DMDY
f64
AGE
f64
AGEU
str
AGEGR1
str
SEX
str
RACE
str
RACEGR1
str
ETHNIC
str
SAFFL
str
ARM
str
ARMCD
str
ACTARM
str
ACTARMCD
str
TRTP
str
TRTA
str
TRT01P
str
TRT01A
str
TRTSDT
date
TRTSDTM
dtime
TRTSTMF
str
TRTEDT
date
TRTEDTM
dtime
TRTETMF
str
EOSSTT
str
EOSDT
date
RFICDTC
str
RANDDT
date
LSTALVDT
date
TRTDURD
f64
DTHDT
date
DTHDTF
str
DTHCAUS
str
DTHCGR1
str
ADT
date
ADY
f64
AVISIT
str
AVISITN
f64
PARAM
str
PARAMCD
str
PARAMN
f64
PARCAT1
str
AVAL
f64
AVALC
str
BASE
f64
BASEC
str
BASETYPE
str
CHG
f64
PCHG
f64
R2BASE
f64
R2ANRLO
f64
R2ANRHI
f64
SHIFT1
str
SHIFT2
str
DTYPE
str
ATOXGR
str
BTOXGR
str
ANRIND
str
BNRIND
str
ANRLO
f64
ANRHI
f64
ATOXGRL
str
ATOXGRH
str
BTOXGRL
str
BTOXGRH
str
ATOXDSCL
str
ATOXDSCH
str
ABLFL
str
ANL01FL
str
ONTRTFL
str
LVOTFL
str
LBSEQ
f64
LBTESTCD
str
LBTEST
str
LBCAT
str
LBORRES
str
LBORRESU
str
LBORNRLO
str
LBORNRHI
str
LBSTRESC
str
LBSTRESN
f64
LBSTRESU
str
LBSTNRLO
f64
LBSTNRHI
f64
LBNRIND
str
LBBLFL
str
VISITNUM
f64
VISIT
str
VISITDY
f64
LBDTC
str
LBDY
f64
0 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 1 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2013-12-26 -7 Baseline 0 Albumin (g/L) ALB 1 CHEMISTRY 38 None 38 None LAST None None 1 1.15151515152 0.775510204082 NORMAL to NORMAL 0 to 0 None 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None Y None None None 1 ALB Albumin CHEMISTRY 3.8 g/dL 3.3 4.9 38 38 g/L 33 49 NORMAL Y 1 SCREENING 1 -7 2013-12-26T14:45 -7
1 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 2 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2014-01-16 15 Week 2 4 Albumin (g/L) ALB 1 CHEMISTRY 39 None 38 None LAST 1 2.63157894737 1.02631578947 1.18181818182 0.795918367347 NORMAL to NORMAL 0 to 0 None 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None None Y Y None 39 ALB Albumin CHEMISTRY 3.9 g/dL 3.3 4.9 39 39 g/L 33 49 NORMAL None 4 WEEK 2 14 2014-01-16T13:17 15
2 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 3 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2014-01-16 15 POST-BASELINE MAXIMUM 9998 Albumin (g/L) ALB 1 CHEMISTRY 39 None 38 None LAST 1 2.63157894737 1.02631578947 1.18181818182 0.795918367347 NORMAL to NORMAL 0 to 0 MAXIMUM 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None None Y Y None 39 ALB Albumin CHEMISTRY 3.9 g/dL 3.3 4.9 39 39 g/L 33 49 NORMAL None 4 WEEK 2 14 2014-01-16T13:17 15
3 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 4 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2014-01-30 29 Week 4 5 Albumin (g/L) ALB 1 CHEMISTRY 38 None 38 None LAST 0 0 1 1.15151515152 0.775510204082 NORMAL to NORMAL 0 to 0 None 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None None Y Y None 74 ALB Albumin CHEMISTRY 3.8 g/dL 3.3 4.9 38 38 g/L 33 49 NORMAL None 5 WEEK 4 28 2014-01-30T08:50 29
4 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 5 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2014-02-12 42 Week 6 7 Albumin (g/L) ALB 1 CHEMISTRY 37 None 38 None LAST -1 -2.63157894737 0.973684210526 1.12121212121 0.755102040816 NORMAL to NORMAL 0 to 0 None 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None None Y Y None 104 ALB Albumin CHEMISTRY 3.7 g/dL 3.3 4.9 37 37 g/L 33 49 NORMAL None 7 WEEK 6 42 2014-02-12T12:56 42
5 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 6 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2014-02-12 42 POST-BASELINE MINIMUM 9997 Albumin (g/L) ALB 1 CHEMISTRY 37 None 38 None LAST -1 -2.63157894737 0.973684210526 1.12121212121 0.755102040816 NORMAL to NORMAL 0 to 0 MINIMUM 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None None Y Y None 104 ALB Albumin CHEMISTRY 3.7 g/dL 3.3 4.9 37 37 g/L 33 49 NORMAL None 7 WEEK 6 42 2014-02-12T12:56 42
6 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 7 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2014-03-05 63 Week 8 8 Albumin (g/L) ALB 1 CHEMISTRY 38 None 38 None LAST 0 0 1 1.15151515152 0.775510204082 NORMAL to NORMAL 0 to 0 None 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None None Y Y None 134 ALB Albumin CHEMISTRY 3.8 g/dL 3.3 4.9 38 38 g/L 33 49 NORMAL None 8 WEEK 8 56 2014-03-05T12:25 63
7 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 8 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2014-03-26 84 Week 12 9 Albumin (g/L) ALB 1 CHEMISTRY 38 None 38 None LAST 0 0 1 1.15151515152 0.775510204082 NORMAL to NORMAL 0 to 0 None 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None None Y Y None 164 ALB Albumin CHEMISTRY 3.8 g/dL 3.3 4.9 38 38 g/L 33 49 NORMAL None 9 WEEK 12 84 2014-03-26T15:15 84
8 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 9 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2014-05-07 126 Week 16 10 Albumin (g/L) ALB 1 CHEMISTRY 37 None 38 None LAST -1 -2.63157894737 0.973684210526 1.12121212121 0.755102040816 NORMAL to NORMAL 0 to 0 None 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None None Y Y None 199 ALB Albumin CHEMISTRY 3.7 g/dL 3.3 4.9 37 37 g/L 33 49 NORMAL None 10 WEEK 16 112 2014-05-07T11:21 126
9 CDISCPILOT01 01-701-1015 1015 701 USA LB 2014-01-02 2014-07-02 2014-01-02 2014-07-02 2014-07-02T11:45 None None None None None None None None None None None 10 NA 2013-12-26 -7 63 YEARS 18-64 F WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-01-02 2014-01-02 00:00:00+00:00 H 2014-07-02 2014-07-02 23:59:59+00:00 H COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 2014-05-21 140 Week 20 11 Albumin (g/L) ALB 1 CHEMISTRY 37 None 38 None LAST -1 -2.63157894737 0.973684210526 1.12121212121 0.755102040816 NORMAL to NORMAL 0 to 0 None 0 0 NORMAL NORMAL 33 49 0 None 0 None Hypoalbuminemia None None Y Y None 229 ALB Albumin CHEMISTRY 3.7 g/dL 3.3 4.9 37 37 g/L 33 49 NORMAL None 11 WEEK 20 140 2014-05-21T10:58 140