from pharmadata import pharmaverseadam
meta = pharmaverseadam.meta('adcm')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 7,510 Columns: 95adcm
adcm
Concomitant Medications Analysis
Variables
Show variable specs
shape: (95, 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 |
| "CMSEQ" | "Sequence Number" | "Float64" | "No" | null |
| "CMDECOD" | "Standardized Medication Name" | "String" | "No" | null |
| "CMTRT" | "Reported Name of Drug, Med, or Therapy" | "String" | "No" | null |
| "CMCLAS" | "Medication Class" | "String" | "No" | null |
| "CMSTDTC" | "Start Date/Time of Medication" | "String" | "No" | null |
| "ASTDT" | "Analysis Start Date" | "Date" | "No" | null |
| "ASTDTM" | "Analysis Start Date/Time" | "Datetime" | "No" | null |
| "ASTDTF" | "Analysis Start Date Imputation Flag" | "String" | "No" | null |
| "ASTTMF" | "Analysis Start Time Imputation Flag" | "String" | "No" | null |
| "CMENDTC" | "End Date/Time of Medication" | "String" | "No" | null |
| "AENDT" | "Analysis End Date" | "Date" | "No" | null |
| "AENDTM" | "Analysis End Date/Time" | "Datetime" | "No" | null |
| "AENDTF" | "Analysis End Date Imputation Flag" | "String" | "No" | null |
| "AENTMF" | "Analysis End Time Imputation Flag" | "String" | "No" | null |
| "ASTDY" | "Analysis Start Relative Day" | "Float64" | "No" | null |
| "CMSTDY" | "Study Day of Start of Medication" | "Float64" | "No" | null |
| "AENDY" | "Analysis End Relative Day" | "Float64" | "No" | null |
| "CMENDY" | "Study Day of End of Medication" | "Float64" | "No" | null |
| "ADURN" | "Analysis Duration (N)" | "Float64" | "No" | null |
| "ADURU" | "Analysis Duration Units" | "String" | "No" | null |
| "ANL01FL" | "Analysis Flag 01" | "String" | "No" | null |
| "ONTRTFL" | "On Treatment Record Flag" | "String" | "No" | null |
| "PREFL" | "Pre-treatment Flag" | "String" | "No" | null |
| "FUPFL" | "Follow-up Flag" | "String" | "No" | null |
| "AOCCPFL" | "1st Occurrence of Preferred Term Flag" | "String" | "No" | null |
| "CMINDC" | "Indication" | "String" | "No" | null |
| "CMDOSE" | "Dose per Administration" | "Float64" | "No" | null |
| "CMDOSU" | "Dose Units" | "String" | "No" | null |
| "CMDOSFRQ" | "Dosing Frequency per Interval" | "String" | "No" | null |
| "CMROUTE" | "Route of Administration" | "String" | "No" | null |
| "CMSPID" | "Sponsor-Defined Identifier" | "String" | "No" | null |
| "CMENRTPT" | "End Relative to Reference Time Point" | "String" | "No" | null |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | null |
| "VISIT" | "Visit Name" | "String" | "No" | null |
| "VISITDY" | "Planned Study Day of Visit" | "Float64" | "No" | null |
| "CMDTC" | "Date/Time of Collection" | "String" | "No" | null |
Examples
from great_docs import tbl_explorer
from pharmadata import pharmaverseadam
tbl_explorer(pharmaverseadam.adcm.head(10))PolarsRows10Columns95 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
CMSEQ f64 |
CMDECOD str |
CMTRT str |
CMCLAS str |
CMSTDTC str |
ASTDT date |
ASTDTM dtime |
ASTDTF str |
ASTTMF str |
CMENDTC str |
AENDT date |
AENDTM dtime |
AENDTF str |
AENTMF str |
ASTDY f64 |
CMSTDY f64 |
AENDY f64 |
CMENDY f64 |
ADURN f64 |
ADURU str |
ANL01FL str |
ONTRTFL str |
PREFL str |
FUPFL str |
AOCCPFL str |
CMINDC str |
CMDOSE f64 |
CMDOSU str |
CMDOSFRQ str |
CMROUTE str |
CMSPID str |
CMENRTPT str |
VISITNUM f64 |
VISIT str |
VISITDY f64 |
CMDTC str |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 48 | HYDROCORTISONE | HYDROCORTISONE | SYSTEMIC HORMONAL PREPARATIONS, EXCL. | 2014-03-27 | 2014-03-27 | 2014-03-27 00:00:00+00:00 | None | H | None | None | None | None | None | 85 | 85 | None | None | None | None | Y | Y | None | None | Y | None | 1 | VIAL | PRN | TOPICAL | 6 | ONGOING | 10 | WEEK 16 | 112 | 2014-05-07 |
| 1 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 54 | HYDROCORTISONE | HYDROCORTISONE | SYSTEMIC HORMONAL PREPARATIONS, EXCL. | 2014-03-27 | 2014-03-27 | 2014-03-27 00:00:00+00:00 | None | H | None | None | None | None | None | 85 | 85 | None | None | None | None | Y | Y | None | None | None | None | 1 | VIAL | PRN | TOPICAL | 6 | ONGOING | 11 | WEEK 20 | 140 | 2014-05-21 |
| 2 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 60 | HYDROCORTISONE | HYDROCORTISONE | SYSTEMIC HORMONAL PREPARATIONS, EXCL. | 2014-03-27 | 2014-03-27 | 2014-03-27 00:00:00+00:00 | None | H | None | None | None | None | None | 85 | 85 | None | None | None | None | Y | Y | None | None | None | None | 1 | VIAL | PRN | TOPICAL | 6 | ONGOING | 12 | WEEK 24 | 168 | 2014-06-18 |
| 3 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 66 | HYDROCORTISONE | HYDROCORTISONE | SYSTEMIC HORMONAL PREPARATIONS, EXCL. | 2014-03-27 | 2014-03-27 | 2014-03-27 00:00:00+00:00 | None | H | None | None | None | None | None | 85 | 85 | None | None | None | None | Y | Y | None | None | None | None | 1 | VIAL | PRN | TOPICAL | 6 | ONGOING | 13 | WEEK 26 | 182 | 2014-07-02 |
| 4 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 17 | UNCODED | NEOSPORIN /USA/ | UNCODED | 2014-01-03 | 2014-01-03 | 2014-01-03 00:00:00+00:00 | None | H | None | None | None | None | None | 2 | 2 | None | None | None | None | Y | Y | None | None | Y | None | 1 | VIAL | PRN | TOPICAL | 5 | ONGOING | 4 | WEEK 2 | 14 | 2014-01-16 |
| 5 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 22 | UNCODED | NEOSPORIN /USA/ | UNCODED | 2014-01-03 | 2014-01-03 | 2014-01-03 00:00:00+00:00 | None | H | None | None | None | None | None | 2 | 2 | None | None | None | None | Y | Y | None | None | None | None | 1 | VIAL | PRN | TOPICAL | 5 | ONGOING | 5 | WEEK 4 | 28 | 2014-01-30 |
| 6 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 27 | UNCODED | NEOSPORIN /USA/ | UNCODED | 2014-01-03 | 2014-01-03 | 2014-01-03 00:00:00+00:00 | None | H | None | None | None | None | None | 2 | 2 | None | None | None | None | Y | Y | None | None | None | None | 1 | VIAL | PRN | TOPICAL | 5 | ONGOING | 6 | AMBUL ECG REMOVAL | 30 | 2014-02-01 |
| 7 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 32 | UNCODED | NEOSPORIN /USA/ | UNCODED | 2014-01-03 | 2014-01-03 | 2014-01-03 00:00:00+00:00 | None | H | None | None | None | None | None | 2 | 2 | None | None | None | None | Y | Y | None | None | None | None | 1 | VIAL | PRN | TOPICAL | 5 | ONGOING | 7 | WEEK 6 | 42 | 2014-02-12 |
| 8 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 37 | UNCODED | NEOSPORIN /USA/ | UNCODED | 2014-01-03 | 2014-01-03 | 2014-01-03 00:00:00+00:00 | None | H | None | None | None | None | None | 2 | 2 | None | None | None | None | Y | Y | None | None | None | None | 1 | VIAL | PRN | TOPICAL | 5 | ONGOING | 8 | WEEK 8 | 56 | 2014-03-05 |
| 9 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | CM | 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 | On-Treatment | 2 | COMPLETED | 2014-07-02 | None | 2014-01-02 | 2014-07-02 | 182 | None | None | None | None | 42 | UNCODED | NEOSPORIN /USA/ | UNCODED | 2014-01-03 | 2014-01-03 | 2014-01-03 00:00:00+00:00 | None | H | None | None | None | None | None | 2 | 2 | None | None | None | None | Y | Y | None | None | None | None | 1 | VIAL | PRN | TOPICAL | 5 | ONGOING | 9 | WEEK 12 | 84 | 2014-03-26 |