# admh admh # Medical History Analysis ``` python 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) | variable | label | type | mandatory | role | |----|----|----|----|----| | str | str | str | str | str | | "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 ``` python 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