from pharmadata import pharmaversesdtm
meta = pharmaversesdtm.meta('oe_ophtha')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 26,852 Columns: 25
oe_ophtha
from pharmadata import pharmaversesdtm
meta = pharmaversesdtm.meta('oe_ophtha')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 26,852 Columns: 25
| 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 |
| "OESEQ" | "Sequence Number" | "Int32" | null | null |
| "OECAT" | "Category for Ophthalmic Test or Exam" | "String" | null | null |
| "OESCAT" | "Subcategory for Ophthalmic Test or Exam" | "String" | null | null |
| "OEDTC" | "Date/Time of Collection" | "String" | null | null |
| "VISIT" | "Visit Name" | "String" | null | null |
| "VISITNUM" | "Visit Number" | "Float64" | null | null |
| "VISITDY" | "Planned Study Day of Visit" | "Float64" | null | null |
| "OESTRESN" | "Numeric Result/Finding in Standard Units" | "Float64" | null | null |
| "OESTRESC" | "Character Result/Finding in Std Format" | "String" | null | null |
| "OEORRES" | "Result or Finding in Original Units" | "String" | null | null |
| "OETEST" | "Name of Ophthalmic Test or Examination" | "String" | null | null |
| "OETESTCD" | "Short Name of Ophthalmic Test or Exam" | "String" | null | null |
| "OETSTDTL" | "Ophthalmic Test or Exam Detail" | "String" | null | null |
| "OELAT" | "Laterality" | "String" | null | null |
| "OELOC" | "Location Used for the Measurement" | "String" | null | null |
| "OEDY" | "Study Day of Visit/Collection/Exam" | "Float64" | null | null |
| "OEMETHOD" | "Method of Test or Examination" | "String" | null | null |
| "OEORRESU" | "Original Units" | "String" | null | null |
| "OESTRESU" | "Standard Units" | "String" | null | null |
| "OESTAT" | "Completion Status" | "String" | null | null |
| "OETPT" | "Planned Time Point Name" | "String" | null | null |
| "OETPTNUM" | "Planned Time Point Number" | "Float64" | null | null |
from great_docs import tbl_explorer
from pharmadata import pharmaversesdtm
tbl_explorer(pharmaversesdtm.oe_ophtha.head(10))PolarsRows10Columns25 | |||||||||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID 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 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | OE | 01-701-1015 | 1 | OPHTHALMIC ASSESSMENTS | None | 2013-12-26 | SCREENING 1 | 1 | -7 | 17.867315 | 17.867315 | 17.867315 | Total GA Area | AREA | TOTAL GA | LEFT | RETINA | -7 | FUNDUS AUTOFLUORESCENCE | mm2 | mm2 | None | PRE-DOSE | -0.5 |
| 1 | CDISCPILOT01 | OE | 01-701-1015 | 2 | OPHTHALMIC ASSESSMENTS | None | 2013-12-26 | SCREENING 1 | 1 | -7 | 3.343734 | 3.343734 | 3.343734 | Total GA Area | AREA | TOTAL GA | RIGHT | RETINA | -7 | FUNDUS AUTOFLUORESCENCE | mm2 | mm2 | None | PRE-DOSE | -0.5 |
| 2 | CDISCPILOT01 | OE | 01-701-1015 | 3 | OPHTHALMIC ASSESSMENTS | SD-OCT CST SINGLE FORM | 2013-12-26 | SCREENING 1 | 1 | -7 | 220 | 220 | 220 | Center Subfield Thickness | CSUBTH | CENTER SUBFIELD THICKNESS | LEFT | RETINA | -7 | SD-OCT | um | um | None | PRE-DOSE | -0.5 |
| 3 | CDISCPILOT01 | OE | 01-701-1015 | 4 | OPHTHALMIC ASSESSMENTS | SD-OCT CST SINGLE FORM | 2013-12-26 | SCREENING 1 | 1 | -7 | 211 | 211 | 211 | Center Subfield Thickness | CSUBTH | CENTER SUBFIELD THICKNESS | RIGHT | RETINA | -7 | SD-OCT | um | um | None | PRE-DOSE | -0.5 |
| 4 | CDISCPILOT01 | OE | 01-701-1015 | 5 | OPHTHALMIC ASSESSMENTS | FORM FOR CFP EVALUATION FOR 7M/4W | 2013-12-26 | SCREENING 1 | 1 | -7 | 4 | 4 | 4 | Diabetic Retinopathy Sev Recode Value | DRSSR | DIABETIC RETINOPATHY SEVERITY LEVEL RECODE VALUE (ETDRS SCALE) | LEFT | RETINA | -7 | COLOR FUNDUS PHOTOGRAPH | None | None | None | PRE-DOSE | -0.5 |
| 5 | CDISCPILOT01 | OE | 01-701-1015 | 6 | OPHTHALMIC ASSESSMENTS | FORM FOR CFP EVALUATION FOR 7M/4W | 2013-12-26 | SCREENING 1 | 1 | -7 | 8 | 8 | 8 | Diabetic Retinopathy Sev Recode Value | DRSSR | DIABETIC RETINOPATHY SEVERITY LEVEL RECODE VALUE (ETDRS SCALE) | RIGHT | RETINA | -7 | COLOR FUNDUS PHOTOGRAPH | None | None | None | PRE-DOSE | -0.5 |
| 6 | CDISCPILOT01 | OE | 01-701-1015 | 7 | OPHTHALMIC ASSESSMENTS | None | 2013-12-26 | SCREENING 1 | 1 | -7 | None | S | S | GA Foveal Location | GAFLOC | GA lesion location related to foveal center | LEFT | RETINA | -7 | FUNDUS AUTOFLUORESCENCE | None | None | None | PRE-DOSE | -0.5 |
| 7 | CDISCPILOT01 | OE | 01-701-1015 | 8 | OPHTHALMIC ASSESSMENTS | None | 2013-12-26 | SCREENING 1 | 1 | -7 | None | NS | NS | GA Foveal Location | GAFLOC | GA lesion location related to foveal center | RIGHT | RETINA | -7 | FUNDUS AUTOFLUORESCENCE | None | None | None | PRE-DOSE | -0.5 |
| 8 | CDISCPILOT01 | OE | 01-701-1015 | 9 | INTRAOCULAR PRESSURE | None | 2013-12-26 | SCREENING 1 | 1 | -7 | 20 | 20 | 20 | Intraocular Pressure | IOP | None | LEFT | EYE | -7 | APPLANATION TONOMETRY | mmHg | mmHg | None | PRE-DOSE | -0.5 |
| 9 | CDISCPILOT01 | OE | 01-701-1015 | 10 | INTRAOCULAR PRESSURE | None | 2013-12-26 | SCREENING 1 | 1 | -7 | 20 | 20 | 20 | Intraocular Pressure | IOP | None | RIGHT | EYE | -7 | APPLANATION TONOMETRY | mmHg | mmHg | None | PRE-DOSE | -0.5 |