from pharmadata import pharmaverseadam
meta = pharmaverseadam.meta('adpp')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 2,688 Columns: 79
adpp
Structure: One or more records per subject per analysis parameter per analysis timepoint
from pharmadata import pharmaverseadam
meta = pharmaverseadam.meta('adpp')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 2,688 Columns: 79
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | str |
| "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 |
| "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" | "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" |
| "PARAMCD" | "Parameter Code" | "String" | "Yes" | "Analysis Parameter Variables for BDS Datasets" |
| "AVAL" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "AVALCAT1" | "Analysis Value Category 1" | "String" | "No" | null |
| "AVALCA1N" | "Analysis Value Category 1 (N)" | "Float64" | "No" | null |
| "SRCDOM" | "Domain Abbreviation" | "String" | "No" | "Datapoint Traceability Variables" |
| "SRCVAR" | "Source Variable" | "String" | "No" | "Datapoint Traceability Variables" |
| "SRCSEQ" | "Sequence Number" | "Int32" | "No" | "Datapoint Traceability Variables" |
| "PPTESTCD" | "Parameter Short Name" | "String" | "No" | null |
| "PPTEST" | "Parameter Name" | "String" | "No" | null |
| "PPCAT" | "Parameter Category" | "String" | "No" | null |
| "PPORRES" | "Result or Finding in Original Units" | "Float64" | "No" | null |
| "PPORRESU" | "Original Units" | "String" | "No" | null |
| "PPSTRESU" | "Standard Units" | "String" | "No" | null |
| "PPSPEC" | "Specimen Material Type" | "String" | "No" | null |
| "PPRFDTC" | "Date/Time of Reference Point" | "String" | "No" | null |
| "VISIT" | "Visit Name" | "String" | "No" | null |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | null |
| "PARCAT1" | "Parameter Category" | "String" | null | null |
| "AVALU" | "Standard Units" | "String" | null | null |
from great_docs import tbl_explorer
from pharmadata import pharmaverseadam
tbl_explorer(pharmaverseadam.adpp.head(10))PolarsRows10Columns79 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
STUDYID str |
USUBJID str |
SUBJID str |
SITEID str |
COUNTRY 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 |
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 |
PARAMCD str |
AVAL f64 |
AVALCAT1 str |
AVALCA1N f64 |
SRCDOM str |
SRCVAR str |
SRCSEQ i32 |
PPTESTCD str |
PPTEST str |
PPCAT str |
PPORRES f64 |
PPORRESU str |
PPSTRESU str |
PPSPEC str |
PPRFDTC str |
VISIT str |
VISITNUM f64 |
PARCAT1 str |
AVALU str |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | AUCALL | 18.1210409513 | <19 | 1 | PP | SEQ | 1 | AUCALL | AUC All | XANOMELINE | 18.1210409513 | h*ug/ml | h*ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | h*ug/ml |
| 1 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | AUCALL | 18.1210409513 | <19 | 1 | PP | SEQ | 2 | AUCALL | AUC All | XANOMELINE | 18.1210409513 | h*ug/ml | h*ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | h*ug/ml |
| 2 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | AUCALL | 18.1210409513 | <19 | 1 | PP | SEQ | 3 | AUCALL | AUC All | XANOMELINE | 18.1210409513 | h*ug/ml | h*ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | h*ug/ml |
| 3 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | AUCALL | 18.1210409513 | <19 | 1 | PP | SEQ | 4 | AUCALL | AUC All | XANOMELINE | 18.1210409513 | h*ug/ml | h*ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | h*ug/ml |
| 4 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | AUCLST | 18.0875151488 | None | None | PP | SEQ | 5 | AUCLST | AUC to Last Nonzero Conc | XANOMELINE | 18.0875151488 | h*ug/ml | h*ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | h*ug/ml |
| 5 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | CLST | 0.0107062734364 | None | None | PP | SEQ | 6 | CLST | Last Nonzero Conc | XANOMELINE | 0.0107062734364 | ug/ml | ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | ug/ml |
| 6 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | CLST | 0.0107062734364 | None | None | PP | SEQ | 7 | CLST | Last Nonzero Conc | XANOMELINE | 0.0107062734364 | ug/ml | ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | ug/ml |
| 7 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | CLST | 0.0107062734364 | None | None | PP | SEQ | 8 | CLST | Last Nonzero Conc | XANOMELINE | 0.0107062734364 | ug/ml | ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | ug/ml |
| 8 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | CLST | 0.0107062734364 | None | None | PP | SEQ | 9 | CLST | Last Nonzero Conc | XANOMELINE | 0.0107062734364 | ug/ml | ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | ug/ml |
| 9 | CDISCPILOT01 | 01-701-1028 | 1028 | 701 | USA | 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 | COMPLETED | 2014-01-14 | None | 2013-07-19 | 2014-01-14 | 180 | None | None | None | None | 2013-07-19 | 1 | Day 1 | 1 | CMAX | 1.77185469788 | None | None | PP | SEQ | 10 | CMAX | Max Conc | XANOMELINE | 1.77185469788 | ug/ml | ug/ml | PLASMA | 2013-07-19 | Day 1 | 1 | XANOMELINE | ug/ml |