from pharmadata import pharmaverseadam
meta = pharmaverseadam.meta('adbcva_ophtha')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 7,672 Columns: 71adbcva_ophtha
adbcva_ophtha
Best Corrected Visual Acuity Analysis
Structure: One or more records per subject per analysis parameter per analysis timepoint
Variables
Show variable specs
shape: (71, 5)
| 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" |
| "DOMAIN" | "Domain Abbreviation" | "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" |
| "TRTEDT" | "Date of Last Exposure to Treatment" | "Date" | "No" | "ADSL Treatment Timing 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" |
| "AVAL" | "Analysis Value" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "AVALC" | "Analysis Value (C)" | "String" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "AVALU" | "Analysis Value Unit" | "String" | "No" | null |
| "AVALCAT1" | "Analysis Value Category 1" | "String" | "No" | null |
| "AVALCA1N" | "Analysis Value Category 1 (N)" | "Float64" | "No" | null |
| "BASE" | "Baseline Value" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "BASEC" | "Baseline Value (C)" | "String" | "No" | "Analysis Parameter Variables for BDS Datasets" |
| "BASETYPE" | "Baseline Type" | "String" | "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" |
| "CRIT1" | "Analysis Criterion 1" | "String" | "No" | null |
| "CRIT1FL" | "Criterion 1 Evaluation Result Flag" | "String" | "No" | null |
| "CRIT2" | "Analysis Criterion 2" | "String" | "No" | null |
| "CRIT2FL" | "Criterion 2 Evaluation Result Flag" | "String" | "No" | null |
| "CRIT3" | "Analysis Criterion 3" | "String" | "No" | null |
| "CRIT3FL" | "Criterion 3 Evaluation Result Flag" | "String" | "No" | null |
| "CRIT4" | "Analysis Criterion 4" | "String" | "No" | null |
| "CRIT4FL" | "Criterion 4 Evaluation Result Flag" | "String" | "No" | null |
| "CRIT5" | "Analysis Criterion 5" | "String" | "No" | null |
| "CRIT5FL" | "Criterion 5 Evaluation Result Flag" | "String" | "No" | null |
| "CRIT6" | "Analysis Criterion 6" | "String" | "No" | null |
| "CRIT6FL" | "Criterion 6 Evaluation Result Flag" | "String" | "No" | null |
| "CRIT7" | "Analysis Criterion 7" | "String" | "No" | null |
| "CRIT7FL" | "Criterion 7 Evaluation Result Flag" | "String" | "No" | null |
| "CRIT8" | "Analysis Criterion 8" | "String" | "No" | null |
| "CRIT8FL" | "Criterion 8 Evaluation Result Flag" | "String" | "No" | null |
| "DTYPE" | "Derivation Type" | "String" | "No" | "Analysis Descriptor Variables for BDS Datasets" |
| "ABLFL" | "Baseline Record Flag" | "String" | "No" | "Flag Variables for BDS Datasets" |
| "ANL01FL" | "Analysis Flag 01" | "String" | "No" | null |
| "ANL02FL" | "Analysis Flag 02" | "String" | "No" | null |
| "ONTRTFL" | "On Treatment Record Flag" | "String" | "No" | "Flag Variables for BDS Datasets" |
| "OESEQ" | "Sequence Number" | "Int32" | "No" | null |
| "OECAT" | "Category for Ophthalmic Test or Exam" | "String" | "No" | null |
| "OESCAT" | "Subcategory for Ophthalmic Test or Exam" | "String" | "No" | null |
| "OEDTC" | "Date/Time of Collection" | "String" | "No" | null |
| "VISIT" | "Visit Name" | "String" | "No" | null |
| "VISITNUM" | "Visit Number" | "Float64" | "No" | null |
| "VISITDY" | "Planned Study Day of Visit" | "Float64" | "No" | null |
| "OESTRESN" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null |
| "OESTRESC" | "Character Result/Finding in Std Format" | "String" | "No" | null |
| "OEORRES" | "Result or Finding in Original Units" | "String" | "No" | null |
| "OETEST" | "Name of Ophthalmic Test or Exam" | "String" | "No" | null |
| "OETESTCD" | "Short Name of Ophthalmic Test or Exam" | "String" | "No" | null |
| "OETSTDTL" | "Ophthalmic Test or Exam Detail" | "String" | "No" | null |
| "OELAT" | "Laterality" | "String" | "No" | null |
| "OELOC" | "Location Used for the Measurement" | "String" | "No" | null |
| "OEDY" | "Study Day of Visit/Collection/Exam" | "Float64" | "No" | null |
| "OEMETHOD" | "Method of Test or Examination" | "String" | "No" | null |
| "OEORRESU" | "Original Units" | "String" | "No" | null |
| "OESTRESU" | "Standard Units" | "String" | "No" | null |
| "OESTAT" | "Completion Status" | "String" | "No" | null |
| "OETPT" | "Planned Time Point Name" | "String" | "No" | null |
| "OETPTNUM" | "Planned Time Point Number" | "Float64" | "No" | null |
| "STUDYEYE" | "Study Eye Location" | "String" | "No" | null |
| "AFEYE" | "Affected Eye" | "String" | "No" | null |
| "WORS01FL" | "Worst Post Baseline Obs" | "String" | "No" | null |
Examples
from great_docs import tbl_explorer
from pharmadata import pharmaverseadam
tbl_explorer(pharmaverseadam.adbcva_ophtha.head(10))PolarsRows10Columns71 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
STUDYID str |
USUBJID str |
DOMAIN str |
TRT01P str |
TRT01A str |
TRTSDT date |
TRTEDT date |
ADT date |
ADY f64 |
AVISIT str |
AVISITN f64 |
ATPT str |
ATPTN f64 |
PARAM str |
PARAMCD str |
AVAL f64 |
AVALC str |
AVALU str |
AVALCAT1 str |
AVALCA1N f64 |
BASE f64 |
BASEC str |
BASETYPE str |
CHG f64 |
PCHG f64 |
CRIT1 str |
CRIT1FL str |
CRIT2 str |
CRIT2FL str |
CRIT3 str |
CRIT3FL str |
CRIT4 str |
CRIT4FL str |
CRIT5 str |
CRIT5FL str |
CRIT6 str |
CRIT6FL str |
CRIT7 str |
CRIT7FL str |
CRIT8 str |
CRIT8FL str |
DTYPE str |
ABLFL str |
ANL01FL str |
ANL02FL str |
ONTRTFL str |
OESEQ i32 |
OECAT str |
OESCAT str |
OEDTC str |
VISIT str |
VISITNUM f64 |
VISITDY f64 |
OESTRESN f64 |
OESTRESC str |
OEORRES str |
OETEST str |
OETESTCD str |
OETSTDTL str |
OELAT str |
OELOC str |
OEDY f64 |
OEMETHOD str |
OEORRESU str |
OESTRESU str |
OESTAT str |
OETPT str |
OETPTNUM f64 |
STUDYEYE str |
AFEYE str |
WORS01FL str |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-05-21 | 140 | Week 20 | 11 | PRE-DOSE | -0.5 | Fellow Eye Visual Acuity Score (letters) | FBCVA | 2 | 2 | letters | < 20/800 | 1000 | 77 | 77 | LAST | -75 | -97.4025974026 | 0 <= CHG <= 5 | N | -5 <= CHG <= -1 | N | 10 <= CHG <= 15 | N | CHG <= -20 | Y | CHG <= 5 | Y | CHG <= 10 | Y | CHG >= -15 | N | CHG >= 15 | N | None | None | Y | None | Y | 63 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-05-21 | WEEK 20 | 11 | 140 | 2 | 2 | 2 | Visual Acuity Score | VACSCORE | None | LEFT | EYE | 140 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Fellow Eye | Y |
| 1 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-03-26 | 84 | Week 12 | 9 | PRE-DOSE | -0.5 | Fellow Eye Visual Acuity Score (letters) | FBCVA | 41 | 41 | letters | 20/160 | 160 | 77 | 77 | LAST | -36 | -46.7532467532 | 0 <= CHG <= 5 | N | -5 <= CHG <= -1 | N | 10 <= CHG <= 15 | N | CHG <= -20 | Y | CHG <= 5 | Y | CHG <= 10 | Y | CHG >= -15 | N | CHG >= 15 | N | None | None | Y | None | Y | 47 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-03-26 | WEEK 12 | 9 | 84 | 41 | 41 | 41 | Visual Acuity Score | VACSCORE | None | LEFT | EYE | 84 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Fellow Eye | None |
| 2 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-06-18 | 168 | Week 24 | 12 | PRE-DOSE | -0.5 | Fellow Eye Visual Acuity Score (letters) | FBCVA | 44 | 44 | letters | 20/125 | 125 | 77 | 77 | LAST | -33 | -42.8571428571 | 0 <= CHG <= 5 | N | -5 <= CHG <= -1 | N | 10 <= CHG <= 15 | N | CHG <= -20 | Y | CHG <= 5 | Y | CHG <= 10 | Y | CHG >= -15 | N | CHG >= 15 | N | None | None | Y | Y | Y | 71 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-06-18 | WEEK 24 | 12 | 168 | 44 | 44 | 44 | Visual Acuity Score | VACSCORE | None | LEFT | EYE | 168 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Fellow Eye | None |
| 3 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-05-07 | 126 | Week 16 | 10 | PRE-DOSE | -0.5 | Fellow Eye Visual Acuity Score (letters) | FBCVA | 52 | 52 | letters | 20/100 | 100 | 77 | 77 | LAST | -25 | -32.4675324675 | 0 <= CHG <= 5 | N | -5 <= CHG <= -1 | N | 10 <= CHG <= 15 | N | CHG <= -20 | Y | CHG <= 5 | Y | CHG <= 10 | Y | CHG >= -15 | N | CHG >= 15 | N | None | None | Y | None | Y | 55 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-05-07 | WEEK 16 | 10 | 112 | 52 | 52 | 52 | Visual Acuity Score | VACSCORE | None | LEFT | EYE | 126 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Fellow Eye | None |
| 4 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-02-12 | 42 | Week 6 | 7 | PRE-DOSE | -0.5 | Fellow Eye Visual Acuity Score (letters) | FBCVA | 64 | 64 | letters | 20/50 | 50 | 77 | 77 | LAST | -13 | -16.8831168831 | 0 <= CHG <= 5 | N | -5 <= CHG <= -1 | N | 10 <= CHG <= 15 | N | CHG <= -20 | N | CHG <= 5 | Y | CHG <= 10 | Y | CHG >= -15 | Y | CHG >= 15 | N | None | None | Y | None | Y | 31 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-02-12 | WEEK 6 | 7 | 42 | 64 | 64 | 64 | Visual Acuity Score | VACSCORE | None | LEFT | EYE | 42 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Fellow Eye | None |
| 5 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-01-02 | 1 | Baseline | 3 | PRE-DOSE | -0.5 | Fellow Eye Visual Acuity Score (letters) | FBCVA | 77 | 77 | letters | 20/32 | 32 | 77 | 77 | LAST | 0 | 0 | 0 <= CHG <= 5 | Y | -5 <= CHG <= -1 | N | 10 <= CHG <= 15 | N | CHG <= -20 | N | CHG <= 5 | Y | CHG <= 10 | Y | CHG >= -15 | Y | CHG >= 15 | N | None | Y | Y | Y | None | 15 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-01-02 | BASELINE | 3 | 1 | 77 | 77 | 77 | Visual Acuity Score | VACSCORE | None | LEFT | EYE | 1 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Fellow Eye | None |
| 6 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-01-30 | 29 | Week 4 | 5 | PRE-DOSE | -0.5 | Fellow Eye Visual Acuity Score (letters) | FBCVA | 77 | 77 | letters | 20/32 | 32 | 77 | 77 | LAST | 0 | 0 | 0 <= CHG <= 5 | Y | -5 <= CHG <= -1 | N | 10 <= CHG <= 15 | N | CHG <= -20 | N | CHG <= 5 | Y | CHG <= 10 | Y | CHG >= -15 | Y | CHG >= 15 | N | None | None | Y | None | Y | 23 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-01-30 | WEEK 4 | 5 | 28 | 77 | 77 | 77 | Visual Acuity Score | VACSCORE | None | LEFT | EYE | 29 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Fellow Eye | None |
| 7 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-03-05 | 63 | Week 8 | 8 | PRE-DOSE | -0.5 | Fellow Eye Visual Acuity Score (letters) | FBCVA | 92 | 92 | letters | 20/16 | 16 | 77 | 77 | LAST | 15 | 19.4805194805 | 0 <= CHG <= 5 | N | -5 <= CHG <= -1 | N | 10 <= CHG <= 15 | Y | CHG <= -20 | N | CHG <= 5 | N | CHG <= 10 | N | CHG >= -15 | Y | CHG >= 15 | Y | None | None | Y | None | Y | 39 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-03-05 | WEEK 8 | 8 | 56 | 92 | 92 | 92 | Visual Acuity Score | VACSCORE | None | LEFT | EYE | 63 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Fellow Eye | None |
| 8 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-01-30 | 29 | Week 4 | 5 | PRE-DOSE | -0.5 | Study Eye Visual Acuity Score (letters) | SBCVA | 24 | 24 | letters | 20/320 | 320 | 35 | 35 | LAST | -11 | -31.4285714286 | 0 <= CHG <= 5 | N | -5 <= CHG <= -1 | N | 10 <= CHG <= 15 | N | CHG <= -20 | N | CHG <= 5 | Y | CHG <= 10 | Y | CHG >= -15 | Y | CHG >= 15 | N | None | None | Y | None | Y | 24 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-01-30 | WEEK 4 | 5 | 28 | 24 | 24 | 24 | Visual Acuity Score | VACSCORE | None | RIGHT | EYE | 29 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Study Eye | Y |
| 9 | CDISCPILOT01 | 01-701-1015 | OE | Placebo | Placebo | 2014-01-02 | 2014-07-02 | 2014-03-05 | 63 | Week 8 | 8 | PRE-DOSE | -0.5 | Study Eye Visual Acuity Score (letters) | SBCVA | 31 | 31 | letters | 20/250 | 250 | 35 | 35 | LAST | -4 | -11.4285714286 | 0 <= CHG <= 5 | N | -5 <= CHG <= -1 | Y | 10 <= CHG <= 15 | N | CHG <= -20 | N | CHG <= 5 | Y | CHG <= 10 | Y | CHG >= -15 | Y | CHG >= 15 | N | None | None | Y | None | Y | 40 | BEST CORRECTED VISUAL ACUITY | OVERALL EVALUATION | 2014-03-05 | WEEK 8 | 8 | 56 | 31 | 31 | 31 | Visual Acuity Score | VACSCORE | None | RIGHT | EYE | 63 | ETDRS EYE CHART | None | None | None | PRE-DOSE | -0.5 | RIGHT | Study Eye | None |