admh

admh

Medical History Analysis

from pharmadata import pharmaverseadam

meta = pharmaverseadam.meta('admh')
print(f"Rows: {meta.number_rows:,}  Columns: {meta.number_columns}")
Rows: 1,818  Columns: 114

Variables

Show variable specs
shape: (114, 5)
variablelabeltypemandatoryrole
strstrstrstrstr
"STUDYID""Study Identifier""String""No"null
"USUBJID""Unique Subject Identifier""String""No"null
"SUBJID""Subject Identifier for the Study""String""No"null
"SITEID""Study Site Identifier""String""No"null
"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
"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"null
"AGEU""Age Units""String""No"null
"AGEGR1""Pooled Age Group 1""String""No"null
"SEX""Sex""String""No"null
"RACE""Race""String""No"null
"RACEGR1""Pooled Race Group 1""String""No"null
"ETHNIC""Ethnicity""String""No"null
"SAFFL""Safety Population Flag""String""No"null
"ARM""Description of Planned Arm""String""No"null
"ARMCD""Planned Arm Code""String""No"null
"ACTARM""Description of Actual Arm""String""No"null
"ACTARMCD""Actual Arm Code""String""No"null
"TRTP""Planned Treatment""String""No"null
"TRTA""Actual Treatment""String""No"null
"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"null
"TRTSDTM""Datetime of First Exposure to Treatment""Datetime""No"null
"TRTSTMF""Time of First Exposure Imput. Flag""String""No"null
"TRTEDT""Date of Last Exposure to Treatment""Date""No"null
"TRTEDTM""Datetime of Last Exposure to Treatment""Datetime""No"null
"TRTETMF""Treatment End Datetime Imput Flag""String""No"null
"APHASE""Phase""String""No"null
"APHASEN""Description of Phase N""Float64""No"null
"EOSSTT""End of Study Status""String""No"null
"EOSDT""End of Study Date""Date""No"null
"RFICDTC""Date/Time of Informed Consent""String""No"null
"RANDDT""Date of Randomization""Date""No"null
"LSTALVDT""Date Last Known Alive""Date""No"null
"TRTDURD""Total Treatment Duration (Days)""Float64""No"null
"DTHDT""Date of Death""Date""No"null
"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
"MHSEQ""Sequence Number""Float64""No"null
"MHTERM""Reported Term for the Medical History""String""No"null
"MHTERMN""Medical History Term (N)""Float64""No"null
"MHDECOD""Dictionary-Derived Term""String""No"null
"MHBODSYS""Body System or Organ Class""String""No"null
"MHLLT""Lowest Level Term""String""No"null
"MHHLT""High Level Term""String""No"null
"MHHLGT""High Level Group Term""String""No"null
"MHCAT""Category for Medical History""String""No"null
"MHSTDTC""Start Date/Time of Medical History Event""String""No"null
"ASTDT""Analysis Start Date""Date""No"null
"MHENDTC""End Date/Time of Medical History Event""String""No"null
"AENDT""Analysis End Date""Date""No"null
"ASTDY""Analysis Start Relative Day""Float64""No"null
"AENDY""Analysis End Relative Day""Float64""No"null
"MHOCCUR""Medical History Occurrence""String""No"null
"MHPRESP""Medical History Event Pre-Specified""String""No"null
"ANL01FL""Analysis Flag 01""String""No"null
"AOCCFL""1st Occurrence within Subject Flag""String""No"null
"AOCCPFL""1st Occurrence of Preferred Term Flag""String""No"null
"AOCCSFL""1st Occurrence of SOC Flag""String""No"null
"MHSPID""Sponsor-Defined Identifier""String""No"null
"MHSEV""Severity/Intensity""String""No"null
"VISITNUM""Visit Number""Float64""No"null
"VISIT""Visit Name""String""No"null
"VISITDY""Planned Study Day of Visit""Float64""No"null
"MHDTC""Date/Time of History Collection""String""No"null
"MHDY""Study Day of History Collection""Float64""No"null
"MHSTRTPT""Start Relative to Reference Time Point""String""No"null
"MHENRTPT""End Relative to Reference Time Point""String""No"null
"MHSTTPT""Start Reference Time Point""String""No"null
"MHENTPT""End Reference Time Point""String""No"null
"MHENRF""End Relative to Reference Period""String""No"null
"MHSTAT""Completion Status""String""No"null
"ADT""Analysis Date""Date""No"null
"ADY""Analysis Relative Day""Float64""No"null
"SMQ02NAM""SMQ 02 Name""String""No"null
"SMQ02CD""SMQ 02 Code""Int32""No"null
"SMQ02SC""SMQ 02 Scope""String""No"null
"SMQ02SCN""SMQ 02 Scope (N)""Int32""No"null
"SMQ03NAM""SMQ 03 Name""String""No"null
"SMQ03CD""SMQ 03 Code""Int32""No"null
"SMQ03SC""SMQ 03 Scope""String""No"null
"SMQ03SCN""SMQ 03 Scope (N)""Int32""No"null
"SMQ05NAM""SMQ 05 Name""String""No"null
"SMQ05CD""SMQ 05 Code""Int32""No"null
"SMQ05SC""SMQ 05 Scope""String""No"null
"SMQ05SCN""SMQ 05 Scope (N)""Int32""No"null
"CQ01NAM""Customized Query 01 Name""String""No"null
"CQ04NAM""Customized Query 04 Name""String""No"null
"CQ04CD""Customized Query 04 Code""Int32""No"null
"AHIST""Response of Med Hx (past or current)""String""No"null
"AOCPFL""1st Occur w/in Trt Prd FL""String""No"null
"AOCPSFL""1st Occur of SOC w/in Trt Prd FL""String""No"null
"AOCPPFL""1st Occur of PT w/in Trt Prd FL""String""No"null

Examples

from great_docs import tbl_explorer
from pharmadata import pharmaverseadam

tbl_explorer(pharmaverseadam.admh.head(10))
PolarsRows10Columns114
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
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
APHASE
str
APHASEN
f64
EOSSTT
str
EOSDT
date
RFICDTC
str
RANDDT
date
LSTALVDT
date
TRTDURD
f64
DTHDT
date
DTHDTF
str
DTHCAUS
str
DTHCGR1
str
MHSEQ
f64
MHTERM
str
MHTERMN
f64
MHDECOD
str
MHBODSYS
str
MHLLT
str
MHHLT
str
MHHLGT
str
MHCAT
str
MHSTDTC
str
ASTDT
date
MHENDTC
str
AENDT
date
ASTDY
f64
AENDY
f64
MHOCCUR
str
MHPRESP
str
ANL01FL
str
AOCCFL
str
AOCCPFL
str
AOCCSFL
str
MHSPID
str
MHSEV
str
VISITNUM
f64
VISIT
str
VISITDY
f64
MHDTC
str
MHDY
f64
MHSTRTPT
str
MHENRTPT
str
MHSTTPT
str
MHENTPT
str
MHENRF
str
MHSTAT
str
ADT
date
ADY
f64
SMQ02NAM
str
SMQ02CD
i32
SMQ02SC
str
SMQ02SCN
i32
SMQ03NAM
str
SMQ03CD
i32
SMQ03SC
str
SMQ03SCN
i32
SMQ05NAM
str
SMQ05CD
i32
SMQ05SC
str
SMQ05SCN
i32
CQ01NAM
str
CQ04NAM
str
CQ04CD
i32
AHIST
str
AOCPFL
str
AOCPSFL
str
AOCPPFL
str
0 CDISCPILOT01 01-701-1015 1015 701 USA MH 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 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 Screening 1 COMPLETED 2014-07-02 None 2014-01-02 2014-07-02 182 None None None None 9 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2010-04-30 2010-04-30 2011-03-20 2011-03-20 -1343 -1019 Y Y Y Y Y Y None None 1 SCREENING 1 -7 2013-12-26 -7 None BEFORE None SCREENING BEFORE None 2013-12-26 -7 None None None None None None None None None None None None None None None Past Y Y Y
1 CDISCPILOT01 01-701-1023 1023 701 USA MH 2012-08-05 2012-09-02 2012-08-05 2012-09-01 2013-02-18 None 2013-02-18 None None None None None None None None None NA 2012-07-22 -14 64 YEARS 18-64 M WHITE White HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2012-08-05 2012-08-05 00:00:00+00:00 H 2012-09-01 2012-09-01 23:59:59+00:00 H Screening 1 DISCONTINUED 2012-09-02 None 2012-08-05 2012-09-02 28 None None None None 16 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2006-03-11 2006-03-11 2006-11-29 2006-11-29 -2339 -2076 Y Y Y Y Y Y None None 1 SCREENING 1 -7 2012-07-22 -14 None BEFORE None SCREENING BEFORE None 2012-07-22 -14 None None None None None None None None None None None None None None None Past Y Y Y
2 CDISCPILOT01 01-701-1028 1028 701 USA MH 2013-07-19 2014-01-14 2013-07-19 2014-01-14 2014-01-14T11:10 None None None None None None None None None None None NA 2013-07-11 -8 71 YEARS >64 M WHITE White NOT HISPANIC OR LATINO Y Xanomeline High Dose Xan_Hi Xanomeline High Dose Xan_Hi Xanomeline High Dose Xanomeline High Dose Xanomeline High Dose Xanomeline High Dose 2013-07-19 2013-07-19 00:00:00+00:00 H 2014-01-14 2014-01-14 23:59:59+00:00 H Screening 1 COMPLETED 2014-01-14 None 2013-07-19 2014-01-14 180 None None None None 6 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2009-12-16 2009-12-16 2010-11-24 2010-11-24 -1311 -968 Y Y Y Y Y Y None None 1 SCREENING 1 -7 2013-07-11 -8 None BEFORE None SCREENING BEFORE None 2013-07-11 -8 None None None None None None None None None None None None None None None Past Y Y Y
3 CDISCPILOT01 01-701-1033 1033 701 USA MH 2014-03-18 2014-04-14 2014-03-18 2014-03-31 2014-09-15 None 2014-09-15 None None None None None None None None None NA 2014-03-10 -8 74 YEARS >64 M WHITE White NOT HISPANIC OR LATINO Y Xanomeline Low Dose Xan_Lo Xanomeline Low Dose Xan_Lo Xanomeline Low Dose Xanomeline Low Dose Xanomeline Low Dose Xanomeline Low Dose 2014-03-18 2014-03-18 00:00:00+00:00 H 2014-03-31 2014-03-31 23:59:59+00:00 H Screening 1 DISCONTINUED 2014-04-14 None 2014-03-18 2014-04-14 14 None None None None 26 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2009-08-02 2009-08-02 2010-08-12 2010-08-12 -1689 -1314 Y Y Y Y Y Y None None 1 SCREENING 1 -7 2014-03-10 -8 None BEFORE None SCREENING BEFORE None 2014-03-10 -8 None None None None None None None None None None None None None None None Past Y Y Y
4 CDISCPILOT01 01-701-1034 1034 701 USA MH 2014-07-01 2014-12-30 2014-07-01 2014-12-30 2014-12-30T09:50 None None None None None None None None None None None NA 2014-06-24 -7 77 YEARS >64 F WHITE White NOT HISPANIC OR LATINO Y Xanomeline High Dose Xan_Hi Xanomeline High Dose Xan_Hi Xanomeline High Dose Xanomeline High Dose Xanomeline High Dose Xanomeline High Dose 2014-07-01 2014-07-01 00:00:00+00:00 H 2014-12-30 2014-12-30 23:59:59+00:00 H Screening 1 COMPLETED 2014-12-30 None 2014-07-01 2014-12-30 183 None None None None 13 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2011-09-29 2011-09-29 2012-05-03 2012-05-03 -1006 -789 Y Y Y None Y Y None None 1 SCREENING 1 -7 2014-06-24 -7 None BEFORE None SCREENING BEFORE None 2014-06-24 -7 None None None None None None None None None None None None None None None Past None Y Y
5 CDISCPILOT01 01-701-1047 1047 701 USA MH 2013-02-12 2013-03-29 2013-02-12 2013-03-09 2013-07-28 None 2013-07-28 None None None None None None None None None NA 2013-01-22 -21 85 YEARS >64 F WHITE White NOT HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2013-02-12 2013-02-12 00:00:00+00:00 H 2013-03-09 2013-03-09 23:59:59+00:00 H Screening 1 DISCONTINUED 2013-03-29 None 2013-02-12 2013-04-07 26 None None None None 14 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2009-07-26 2009-07-26 2010-05-09 2010-05-09 -1297 -1010 Y Y Y Y Y Y None None 1 SCREENING 1 -7 2013-01-22 -21 None BEFORE None SCREENING BEFORE None 2013-01-22 -21 None None None None None None None None None None None None None None None Past Y Y Y
6 CDISCPILOT01 01-701-1097 1097 701 USA MH 2014-01-01 2014-07-09 2014-01-01 2014-07-09 2014-07-09T09:39 None None None None None None None None None None None NA 2013-12-23 -9 68 YEARS >64 M WHITE White NOT HISPANIC OR LATINO Y Xanomeline Low Dose Xan_Lo Xanomeline Low Dose Xan_Lo Xanomeline Low Dose Xanomeline Low Dose Xanomeline Low Dose Xanomeline Low Dose 2014-01-01 2014-01-01 00:00:00+00:00 H 2014-07-09 2014-07-09 23:59:59+00:00 H Screening 1 COMPLETED 2014-07-09 None 2014-01-01 2014-07-09 190 None None None None 4 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2005-09-22 2005-09-22 2006-07-09 2006-07-09 -3023 -2733 Y Y Y Y Y Y None None 1 SCREENING 1 -7 2013-12-23 -9 None BEFORE None SCREENING BEFORE None 2013-12-23 -9 None None None None None None None None None None None None None None None Past Y Y Y
7 CDISCPILOT01 01-701-1111 1111 701 USA MH 2012-09-07 2012-09-17 2012-09-07 2012-09-16 2013-02-22 None 2013-02-22 None None None None None None None None None NA 2012-08-25 -13 81 YEARS >64 F WHITE White NOT HISPANIC OR LATINO Y Xanomeline Low Dose Xan_Lo Xanomeline Low Dose Xan_Lo Xanomeline Low Dose Xanomeline Low Dose Xanomeline Low Dose Xanomeline Low Dose 2012-09-07 2012-09-07 00:00:00+00:00 H 2012-09-16 2012-09-16 23:59:59+00:00 H Screening 1 DISCONTINUED 2012-09-17 None 2012-09-07 2012-09-17 10 None None None None 29 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2009-04-04 2009-04-04 2010-01-14 2010-01-14 -1252 -967 Y Y Y Y Y Y None None 1 SCREENING 1 -7 2012-08-25 -13 None BEFORE None SCREENING BEFORE None 2012-08-25 -13 None None None None None None None None None None None None None None None Past Y Y Y
8 CDISCPILOT01 01-701-1115 1115 701 USA MH 2012-11-30 2013-01-23 2012-11-30 2013-01-23 2013-05-20 None 2013-05-20 None None None None None None None None None NA 2012-11-23 -7 84 YEARS >64 M WHITE White NOT HISPANIC OR LATINO Y Xanomeline Low Dose Xan_Lo Xanomeline Low Dose Xan_Lo Xanomeline Low Dose Xanomeline Low Dose Xanomeline Low Dose Xanomeline Low Dose 2012-11-30 2012-11-30 00:00:00+00:00 H 2013-01-23 2013-01-23 23:59:59+00:00 H Screening 1 DISCONTINUED 2013-01-23 None 2012-11-30 2013-01-23 55 None None None None 13 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2004-05-28 2004-05-28 2004-07-16 2004-07-16 -3108 -3059 Y Y Y Y Y Y None None 1 SCREENING 1 -7 2012-11-23 -7 None BEFORE None SCREENING BEFORE None 2012-11-23 -7 None None None None None None None None None None None None None None None Past Y Y Y
9 CDISCPILOT01 01-701-1118 1118 701 USA MH 2014-03-12 2014-09-09 2014-03-12 2014-09-09 2014-09-09T13:28 None None None None None None None None None None None NA 2014-02-27 -13 52 YEARS 18-64 M WHITE White NOT HISPANIC OR LATINO Y Placebo Pbo Placebo Pbo Placebo Placebo Placebo Placebo 2014-03-12 2014-03-12 00:00:00+00:00 H 2014-09-09 2014-09-09 23:59:59+00:00 H Screening 1 COMPLETED 2014-09-09 None 2014-03-12 2014-09-09 182 None None None None 8 ALZHEIMER'S DISEASE 1 None None None None None PRIMARY DIAGNOSIS 2010-06-24 2010-06-24 2010-08-16 2010-08-16 -1357 -1304 Y Y Y Y Y Y None None 1 SCREENING 1 -7 2014-02-27 -13 None BEFORE None SCREENING BEFORE None 2014-02-27 -13 None None None None None None None None None None None None None None None Past Y Y Y