from pharmadata import pharmaverseadam
meta = pharmaverseadam.meta('advs_peds')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 546 Columns: 80
advs_peds
Structure: One or more records per subject per analysis parameter per analysis timepoint
from pharmadata import pharmaverseadam
meta = pharmaverseadam.meta('advs_peds')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 546 Columns: 80
| 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 |
| "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 |
| "DTHDTC" | "Date/Time of Death" | "String" | "No" | null |
| "DTHFL" | "Subject Death Flag" | "String" | "No" | null |
| "ASEQ" | "Analysis Sequence Number" | "Int32" | "No" | "Identifier Variables for BDS Datasets" |
| "BRTHDTC" | "Date/Time of Birth (Character)" | "String" | "No" | null |
| "BRTHDT" | "Date/Time of Birth" | "Date" | "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" |
| "SEX" | "Sex" | "String" | "No" | "ADSL Subject Demographics Variables" |
| "RACE" | "Race" | "String" | "No" | "ADSL Subject Demographics Variables" |
| "ETHNIC" | "Ethnicity" | "String" | "No" | null |
| "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 |
| "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" |
| "RFICDTC" | "Date/Time of Informed Consent" | "String" | "No" | null |
| "TRTDURD" | "Total Treatment Duration (Days)" | "Float64" | "No" | "ADSL Subject-Level Trial Experience Variables" |
| "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" |
| "ATPT" | "Analysis Timepoint" | "String" | "No" | "Timing Variables for BDS Datasets" |
| "ATPTN" | "Analysis Timepoint (N)" | "Float64" | "No" | "Timing Variables for BDS Datasets" |
| "PARAM" | "Parameter" | "String" | "Yes" | "Analysis Parameter Variables for BDS Datasets" |
| "PARAMCD" | "Parameter Code" | "String" | "Yes" | "Analysis Parameter Variables for BDS Datasets" |
| "PARAMN" | "Parameter (N)" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "AVAL" | "Analysis Value" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "BASE" | "Baseline Value" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "CHG" | "Change from Baseline" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "PCHG" | "Percent Change from Baseline" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "ABLFL" | "Baseline Record Flag" | "String" | "No" | "Flag Variables for BDS Datasets" |
| "ANL01FL" | "Analysis Flag 01" | "String" | "No" | null |
| "ONTRTFL" | "On Treatment Record Flag" | "String" | "No" | "Flag Variables for BDS Datasets" |
| "EPOCH" | "Epoch" | "String" | "No" | null |
| "VSEVAL" | "Evaluator" | "String" | "No" | null |
| "VSSEQ" | "Sequence Number" | "Int32" | "No" | null |
| "VSTESTCD" | "Vital Signs Test Short Name" | "String" | "No" | null |
| "VSTEST" | "Vital Signs Test Name" | "String" | "No" | null |
| "VSPOS" | "Vital Signs Position of Subject" | "String" | "No" | null |
| "VSORRES" | "Result or Finding in Original Units" | "String" | "No" | null |
| "VSORRESU" | "Original Units" | "String" | "No" | null |
| "VSSTRESC" | "Character Result/Finding in Std Format" | "String" | "No" | null |
| "VSSTRESN" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "VSSTRESU" | "Standard Units" | "String" | "No" | null |
| "VSSTAT" | "Completion Status" | "String" | "No" | null |
| "VSLOC" | "Location of Vital Signs Measurement" | "String" | "No" | null |
| "VSBLFL" | "Baseline Flag" | "String" | "No" | null |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | null |
| "VISIT" | "Visit Name" | "String" | "No" | null |
| "VISITDY" | "Planned Study Day of Visit" | "Int32" | "No" | null |
| "VSDTC" | "Date/Time of Measurements" | "String" | "No" | null |
| "VSDY" | "Study Day of Vital Signs" | "Int32" | "No" | null |
| "VSTPT" | "Planned Time Point Name" | "String" | "No" | null |
| "VSTPTNUM" | "Planned Time Point Number" | "Float64" | "No" | null |
| "VSELTM" | "Planned Elapsed Time from Time Point Ref" | "String" | "No" | null |
| "VSTPTREF" | "Time Point Reference" | "String" | "No" | null |
| "AAGECUR" | "Current Analysis Age (Days)" | "Float64" | "No" | null |
| "AAGECURU" | "Current Analysis Age Units" | "String" | "No" | null |
| "HGTTMP" | "Temporary Height at Timepoint" | "Float64" | "No" | null |
| "HGTTMPU" | "Temporary Height at Timepoint Units" | "String" | "No" | null |
from great_docs import tbl_explorer
from pharmadata import pharmaverseadam
tbl_explorer(pharmaverseadam.advs_peds.head(10))PolarsRows10Columns80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
STUDYID str |
USUBJID str |
SUBJID str |
SITEID str |
COUNTRY str |
DOMAIN str |
RFSTDTC str |
RFENDTC str |
RFXSTDTC str |
RFXENDTC str |
RFPENDTC str |
DTHDTC str |
DTHFL str |
ASEQ i32 |
BRTHDTC str |
BRTHDT date |
DMDTC str |
DMDY f64 |
AGE f64 |
AGEU str |
SEX str |
RACE str |
ETHNIC str |
ARM str |
ARMCD str |
ACTARM str |
ACTARMCD str |
TRT01P str |
TRT01A str |
TRTSDT date |
TRTSDTM dtime |
TRTSTMF str |
TRTEDT date |
TRTEDTM dtime |
TRTETMF str |
RFICDTC str |
TRTDURD f64 |
ADT date |
ADY f64 |
AVISIT str |
AVISITN f64 |
ATPT str |
ATPTN f64 |
PARAM str |
PARAMCD str |
PARAMN f64 |
AVAL f64 |
BASE f64 |
CHG f64 |
PCHG f64 |
ABLFL str |
ANL01FL str |
ONTRTFL str |
EPOCH str |
VSEVAL str |
VSSEQ i32 |
VSTESTCD str |
VSTEST str |
VSPOS str |
VSORRES str |
VSORRESU str |
VSSTRESC str |
VSSTRESN f64 |
VSSTRESU str |
VSSTAT str |
VSLOC str |
VSBLFL str |
VISITNUM f64 |
VISIT str |
VISITDY i32 |
VSDTC str |
VSDY i32 |
VSTPT str |
VSTPTNUM f64 |
VSELTM str |
VSTPTREF str |
AAGECUR f64 |
AAGECURU str |
HGTTMP f64 |
HGTTMPU str |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 1 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2013-12-26 | -7 | Screening 1 | -1 | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 16.5779328715 | 16.6159515917 | None | None | None | None | None | Epoch | None | 1 | BMI | BMI | None | 16.5779328715278 | kg/m2 | 16.5779328715278 | 16.5779328715 | kg/m2 | None | None | None | 1 | SCREENING 1 | None | 2013-12-26 | None | None | None | None | None | 359 | DAYS | 74.13 | cm |
| 1 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 2 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2014-01-02 | 1 | Baseline | 0 | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 16.6159515917 | 16.6159515917 | None | None | Y | Y | None | Epoch | None | 5 | BMI | BMI | None | 16.6159515916646 | kg/m2 | 16.6159515916646 | 16.6159515917 | kg/m2 | None | None | None | 3 | BASELINE | None | 2014-01-02 | None | None | None | None | None | 366 | DAYS | 74.41 | cm |
| 2 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 3 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2014-01-16 | 15 | Week 2 | None | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 16.6977686496 | 16.6159515917 | None | None | None | None | Y | Epoch | None | 9 | BMI | BMI | None | 16.6977686495846 | kg/m2 | 16.6977686495846 | 16.6977686496 | kg/m2 | None | None | None | 4 | WEEK 2 | None | 2014-01-16 | None | None | None | None | None | 380 | DAYS | 74.71 | cm |
| 3 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 4 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2014-01-30 | 29 | Week 4 | None | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 16.8161956675 | 16.6159515917 | None | None | None | None | Y | Epoch | None | 13 | BMI | BMI | None | 16.8161956674711 | kg/m2 | 16.8161956674711 | 16.8161956675 | kg/m2 | None | None | None | 5 | WEEK 4 | None | 2014-01-30 | None | None | None | None | None | 394 | DAYS | 75.32 | cm |
| 4 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 5 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2014-02-12 | 42 | Week 6 | None | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 16.8246072334 | 16.6159515917 | None | None | None | None | Y | Epoch | None | 17 | BMI | BMI | None | 16.8246072334467 | kg/m2 | 16.8246072334467 | 16.8246072334 | kg/m2 | None | None | None | 7 | WEEK 6 | None | 2014-02-12 | None | None | None | None | None | 407 | DAYS | 75.93 | cm |
| 5 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 6 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2014-03-05 | 63 | Week 8 | None | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 16.9159634735 | 16.6159515917 | None | None | None | None | Y | Epoch | None | 21 | BMI | BMI | None | 16.9159634735359 | kg/m2 | 16.9159634735359 | 16.9159634735 | kg/m2 | None | None | None | 8 | WEEK 8 | None | 2014-03-05 | None | None | None | None | None | 428 | DAYS | 76.54 | cm |
| 6 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 7 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2014-03-26 | 84 | Week 12 | None | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 17.0518553876 | 16.6159515917 | None | None | None | None | Y | Epoch | None | 25 | BMI | BMI | None | 17.0518553875519 | kg/m2 | 17.0518553875519 | 17.0518553876 | kg/m2 | None | None | None | 9 | WEEK 12 | None | 2014-03-26 | None | None | None | None | None | 449 | DAYS | 77.72 | cm |
| 7 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 8 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2014-05-07 | 126 | Week 16 | None | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 17.162063256 | 16.6159515917 | None | None | None | None | Y | Epoch | None | 29 | BMI | BMI | None | 17.1620632559648 | kg/m2 | 17.1620632559648 | 17.162063256 | kg/m2 | None | None | None | 10 | WEEK 16 | None | 2014-05-07 | None | None | None | None | None | 491 | DAYS | 78.96 | cm |
| 8 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 9 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2014-05-21 | 140 | Week 20 | None | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 17.2487514235 | 16.6159515917 | None | None | None | None | Y | Epoch | None | 33 | BMI | BMI | None | 17.2487514234882 | kg/m2 | 17.2487514234882 | 17.2487514235 | kg/m2 | None | None | None | 11 | WEEK 20 | None | 2014-05-21 | None | None | None | None | None | 505 | DAYS | 80.22 | cm |
| 9 | CDISCPILOT01 | 01-701-1015 | 1015 | 701 | USA | VS | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | 2014-07-02T11:45 | None | None | 10 | 2013-01-02 | 2013-01-02 | 2013-12-26 | -7 | 1 | YEARS | F | WHITE | HISPANIC OR LATINO | Placebo | Pbo | Placebo | Pbo | 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 | None | 182 | 2014-06-18 | 168 | Week 24 | None | None | None | Body Mass Index(kg/m^2) | BMI | 3 | 17.4336757598 | 16.6159515917 | None | None | None | None | Y | Epoch | None | 37 | BMI | BMI | None | 17.4336757597814 | kg/m2 | 17.4336757597814 | 17.4336757598 | kg/m2 | None | None | None | 12 | WEEK 24 | None | 2014-06-18 | None | None | None | None | None | 533 | DAYS | 81.43 | cm |