from pharmadata import pharmaversesdtm
meta = pharmaversesdtm.meta('mh')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 1,818 Columns: 28mh
mh
Medical History
Variables
Show variable specs
shape: (28, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | null | null |
| "STUDYID" | "Study Identifier" | "String" | null | null |
| "DOMAIN" | "Domain Abbreviation" | "String" | null | null |
| "USUBJID" | "Unique Subject Identifier" | "String" | null | null |
| "MHSEQ" | "Sequence Number" | "Float64" | null | null |
| "MHSPID" | "Sponsor-Defined Identifier" | "String" | null | null |
| "MHTERM" | "Reported Term for the Medical History" | "String" | null | null |
| "MHLLT" | "Lowest Level Term" | "String" | null | null |
| "MHDECOD" | "Dictionary-Derived Term" | "String" | null | null |
| "MHHLT" | "High Level Term" | "String" | null | null |
| "MHHLGT" | "High Level Group Term" | "String" | null | null |
| "MHCAT" | "Category for Medical History" | "String" | null | null |
| "MHBODSYS" | "Body System or Organ Class" | "String" | null | null |
| "MHSEV" | "Severity/Intensity" | "String" | null | null |
| "VISITNUM" | "Visit Number" | "Float64" | null | null |
| "VISIT" | "Visit Name" | "String" | null | null |
| "VISITDY" | "Planned Study Day of Visit" | "Float64" | null | null |
| "MHDTC" | "Date/Time of History Collection" | "String" | null | null |
| "MHSTDTC" | "Start Date/Time of Medical History Event" | "String" | null | null |
| "MHDY" | "Study Day of History Collection" | "Float64" | null | null |
| "MHENDTC" | "End Date/Time of Medical History Event" | "String" | null | null |
| "MHPRESP" | "Medical History Event Pre-Specified" | "String" | null | null |
| "MHOCCUR" | "Medical History Occurrence" | "String" | null | null |
| "MHSTRTPT" | "Start Relative to Reference Time Point" | "String" | null | null |
| "MHENRTPT" | "End Relative to Reference Time Point" | "String" | null | null |
| "MHSTTPT" | "Start Reference Time Point" | "String" | null | null |
| "MHENTPT" | "End Reference Time Point" | "String" | null | null |
| "MHENRF" | "End Relative to Reference Period" | "String" | null | null |
| "MHSTAT" | "Completion Status" | "String" | null | null |
Examples
from great_docs import tbl_explorer
from pharmadata import pharmaversesdtm
tbl_explorer(pharmaversesdtm.mh.head(10))PolarsRows10Columns28 | ||||||||||||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
MHSEQ f64 |
MHSPID str |
MHTERM str |
MHLLT str |
MHDECOD str |
MHHLT str |
MHHLGT str |
MHCAT str |
MHBODSYS str |
MHSEV str |
VISITNUM f64 |
VISIT str |
VISITDY f64 |
MHDTC str |
MHSTDTC str |
MHDY f64 |
MHENDTC str |
MHPRESP str |
MHOCCUR str |
MHSTRTPT str |
MHENRTPT str |
MHSTTPT str |
MHENTPT str |
MHENRF str |
MHSTAT str |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | MH | 01-701-1015 | 9 | None | ALZHEIMER'S DISEASE | None | None | None | None | PRIMARY DIAGNOSIS | None | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 2010-04-30 | -7 | 2011-03-20 | Y | Y | None | BEFORE | None | SCREENING | BEFORE | None |
| 1 | CDISCPILOT01 | MH | 01-701-1015 | 1 | E01 | VERBATIM_0135 | PALPITATIONS | PALPITATIONS | HLT_0493 | HLGT_0593 | SIGNIFICANT PRE-EXISTING CONDITION | CARDIAC DISORDERS | MILD | 1 | SCREENING 1 | -7 | 2013-12-26 | None | -7 | None | None | None | BEFORE | None | SCREENING | FIRST DOSE OF STUDY DRUG | None | None |
| 2 | CDISCPILOT01 | MH | 01-701-1015 | 8 | None | VERBATIM_0140 | SUBTOTAL HYSTERECTOMY | HYSTERECTOMY | HLT_0675 | HLGT_0657 | HISTORICAL DIAGNOSIS | SURGICAL AND MEDICAL PROCEDURES | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 1986 | -7 | None | None | None | BEFORE | None | SCREENING | FIRST DOSE OF STUDY DRUG | None | None |
| 3 | CDISCPILOT01 | MH | 01-701-1015 | 2 | E03 | VERBATIM_0301 | HEADACHE | HEADACHE | HLT_0064 | HLGT_0344 | SIGNIFICANT PRE-EXISTING CONDITION | NERVOUS SYSTEM DISORDERS | MILD | 1 | SCREENING 1 | -7 | 2013-12-26 | None | -7 | None | None | None | BEFORE | None | SCREENING | FIRST DOSE OF STUDY DRUG | None | None |
| 4 | CDISCPILOT01 | MH | 01-701-1015 | 10 | None | VERBATIM_0539 | GALLBLADDER STONES | CHOLELITHIASIS | HLT_0084 | HLGT_0177 | HISTORICAL DIAGNOSIS | HEPATOBILIARY DISORDERS | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 2012 | -7 | None | None | None | BEFORE | None | SCREENING | FIRST DOSE OF STUDY DRUG | None | None |
| 5 | CDISCPILOT01 | MH | 01-701-1015 | 3 | E05 | VERBATIM_0825 | TINNITUS | TINNITUS | HLT_0570 | HLGT_0180 | SIGNIFICANT PRE-EXISTING CONDITION | EAR AND LABYRINTH DISORDERS | MILD | 1 | SCREENING 1 | -7 | 2013-12-26 | None | -7 | None | None | None | BEFORE | None | SCREENING | FIRST DOSE OF STUDY DRUG | None | None |
| 6 | CDISCPILOT01 | MH | 01-701-1015 | 4 | E02 | VERBATIM_0841 | HEARTBURN | DYSPEPSIA | HLT_0244 | HLGT_0716 | SIGNIFICANT PRE-EXISTING CONDITION | GASTROINTESTINAL DISORDERS | MILD | 1 | SCREENING 1 | -7 | 2013-12-26 | None | -7 | None | None | None | BEFORE | None | SCREENING | FIRST DOSE OF STUDY DRUG | None | None |
| 7 | CDISCPILOT01 | MH | 01-701-1015 | 6 | None | VERBATIM_1004 | THYROIDECTOMY PARTIAL | THYROIDECTOMY PARTIAL | HLT_0243 | HLGT_0016 | HISTORICAL DIAGNOSIS | SURGICAL AND MEDICAL PROCEDURES | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 1973 | -7 | None | None | None | BEFORE | None | SCREENING | FIRST DOSE OF STUDY DRUG | None | None |
| 8 | CDISCPILOT01 | MH | 01-701-1015 | 11 | None | VERBATIM_1230 | SORE THROAT | PHARYNGOLARYNGEAL PAIN | HLT_0130 | HLGT_0402 | HISTORICAL DIAGNOSIS | RESPIRATORY, THORACIC AND MEDIASTINAL DISORDERS | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 2013-12 | -7 | None | None | None | BEFORE | None | SCREENING | FIRST DOSE OF STUDY DRUG | None | None |
| 9 | CDISCPILOT01 | MH | 01-701-1015 | 7 | None | VERBATIM_1716 | TONSILLECTOMY | TONSILLECTOMY | HLT_0202 | HLGT_0199 | HISTORICAL DIAGNOSIS | SURGICAL AND MEDICAL PROCEDURES | None | 1 | SCREENING 1 | -7 | 2013-12-26 | 1973 | -7 | None | None | None | BEFORE | None | SCREENING | FIRST DOSE OF STUDY DRUG | None | None |