from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('ae')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 961 Columns: 37ae
ae
Adverse Events
Structure: One record per adverse event per subject
Variables
Show variable specs
shape: (37, 5)
| variable | label | type | mandatory | role |
|---|---|---|---|---|
| str | str | str | str | str |
| "STUDYID" | "Study Identifier" | "String" | "Yes" | "IDENTIFIER" |
| "DOMAIN" | "Domain Abbreviation" | "String" | "Yes" | "IDENTIFIER" |
| "USUBJID" | "Unique Subject Identifier" | "String" | "Yes" | "IDENTIFIER" |
| "AESEQ" | "Sequence Number" | "Float64" | "Yes" | "IDENTIFIER" |
| "AESPID" | "Sponsor-Defined Identifier" | "String" | "No" | "IDENTIFIER" |
| "AETERM" | "Reported Term for the Adverse Event" | "String" | "Yes" | "TOPIC" |
| "AELLT" | "Lowest Level Term" | "String" | "No" | "VARIABLE QUALIFIER" |
| "AELLTCD" | "Lowest Level Term Code" | "Float64" | "No" | "VARIABLE QUALIFIER" |
| "AEDECOD" | "Dictionary-Derived Term" | "String" | "No" | "SYNONYM QUALIFIER" |
| "AEPTCD" | "Preferred Term Code" | "Float64" | "No" | "VARIABLE QUALIFIER" |
| "AEHLT" | "High Level Term" | "String" | "No" | "VARIABLE QUALIFIER" |
| "AEHLTCD" | "High Level Term Code" | "Float64" | "No" | "VARIABLE QUALIFIER" |
| "AEHLGT" | "High Level Group Term" | "String" | "No" | "VARIABLE QUALIFIER" |
| "AEHLGTCD" | "High Level Group Term Code" | "Float64" | "No" | "VARIABLE QUALIFIER" |
| "AEBODSYS" | "Body System or Organ Class" | "String" | "No" | "VARIABLE QUALIFIER" |
| "AEBDSYCD" | "Body System or Organ Class Code" | "Float64" | "No" | "VARIABLE QUALIFIER" |
| "AESOC" | "Primary System Organ Class" | "String" | "No" | "VARIABLE QUALIFIER" |
| "AESOCCD" | "Primary System Organ Class Code" | "Float64" | "No" | "VARIABLE QUALIFIER" |
| "AESEV" | "Severity/Intensity" | "String" | "No" | "VARIABLE QUALIFIER" |
| "AESER" | "Serious Event" | "String" | "No" | "RECORD QUALIFIER" |
| "AEACN" | "Action Taken with Study Treatment" | "String" | "No" | "RECORD QUALIFIER" |
| "AEREL" | "Causality" | "String" | "No" | "RECORD QUALIFIER" |
| "AEOUT" | "Outcome of Adverse Event" | "String" | "No" | "RECORD QUALIFIER" |
| "AESCAN" | "Involves Cancer" | "String" | "No" | "RECORD QUALIFIER" |
| "AESCONG" | "Congenital Anomaly or Birth Defect" | "String" | "No" | "RECORD QUALIFIER" |
| "AESDISAB" | "Persist or Signif Disability/Incapacity" | "String" | "No" | "RECORD QUALIFIER" |
| "AESDTH" | "Results in Death" | "String" | "No" | "RECORD QUALIFIER" |
| "AESHOSP" | "Requires or Prolongs Hospitalization" | "String" | "No" | "RECORD QUALIFIER" |
| "AESLIFE" | "Is Life Threatening" | "String" | "No" | "RECORD QUALIFIER" |
| "AESOD" | "Occurred with Overdose" | "String" | "No" | "RECORD QUALIFIER" |
| "EPOCH" | "Epoch" | "String" | "No" | "TIMING" |
| "AEDTC" | "Date/Time of Collection" | "String" | "No" | "TIMING" |
| "AESTDTC" | "Start Date/Time of Adverse Event" | "String" | "No" | "TIMING" |
| "AEENDTC" | "End Date/Time of Adverse Event" | "String" | "No" | "TIMING" |
| "AEDY" | "Study Day of Visit/Collection/Exam" | "Float64" | "No" | "TIMING" |
| "AESTDY" | "Study Day of Start of Adverse Event" | "Float64" | "No" | "TIMING" |
| "AEENDY" | "Study Day of End of Adverse Event" | "Float64" | "No" | "TIMING" |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.ae.head(10))PolarsRows10Columns37 | |||||||||||||||||||||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
AESEQ f64 |
AESPID str |
AETERM str |
AELLT str |
AELLTCD f64 |
AEDECOD str |
AEPTCD f64 |
AEHLT str |
AEHLTCD f64 |
AEHLGT str |
AEHLGTCD f64 |
AEBODSYS str |
AEBDSYCD f64 |
AESOC str |
AESOCCD f64 |
AESEV str |
AESER str |
AEACN str |
AEREL str |
AEOUT str |
AESCAN str |
AESCONG str |
AESDISAB str |
AESDTH str |
AESHOSP str |
AESLIFE str |
AESOD str |
EPOCH str |
AEDTC str |
AESTDTC str |
AEENDTC str |
AEDY f64 |
AESTDY f64 |
AEENDY f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | AE | 01-701-1015 | 1 | E07 | APPLICATION SITE ERYTHEMA | APPLICATION SITE REDNESS | None | APPLICATION SITE ERYTHEMA | None | HLT_0617 | None | HLGT_0152 | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | MILD | N | None | PROBABLE | NOT RECOVERED/NOT RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2014-01-16 | 2014-01-03 | None | 15 | 2 | None |
| 1 | CDISCPILOT01 | AE | 01-701-1015 | 2 | E08 | APPLICATION SITE PRURITUS | APPLICATION SITE ITCHING | None | APPLICATION SITE PRURITUS | None | HLT_0317 | None | HLGT_0338 | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | MILD | N | None | PROBABLE | NOT RECOVERED/NOT RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2014-01-16 | 2014-01-03 | None | 15 | 2 | None |
| 2 | CDISCPILOT01 | AE | 01-701-1015 | 3 | E06 | DIARRHOEA | DIARRHEA | None | DIARRHOEA | None | HLT_0148 | None | HLGT_0588 | None | GASTROINTESTINAL DISORDERS | None | GASTROINTESTINAL DISORDERS | None | MILD | N | None | REMOTE | RECOVERED/RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2014-01-16 | 2014-01-09 | 2014-01-11 | 15 | 8 | 10 |
| 3 | CDISCPILOT01 | AE | 01-701-1023 | 3 | E10 | ATRIOVENTRICULAR BLOCK SECOND DEGREE | AV BLOCK SECOND DEGREE | None | ATRIOVENTRICULAR BLOCK SECOND DEGREE | None | HLT_0415 | None | HLGT_0086 | None | CARDIAC DISORDERS | None | CARDIAC DISORDERS | None | MILD | N | None | POSSIBLE | NOT RECOVERED/NOT RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2012-08-27 | 2012-08-26 | None | 23 | 22 | None |
| 4 | CDISCPILOT01 | AE | 01-701-1023 | 2 | E09 | ERYTHEMA | LOCALIZED ERYTHEMA | None | ERYTHEMA | None | HLT_0284 | None | HLGT_0192 | None | SKIN AND SUBCUTANEOUS TISSUE DISORDERS | None | SKIN AND SUBCUTANEOUS TISSUE DISORDERS | None | MODERATE | N | None | PROBABLE | NOT RECOVERED/NOT RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2012-08-27 | 2012-08-07 | None | 23 | 3 | None |
| 5 | CDISCPILOT01 | AE | 01-701-1023 | 4 | E08 | ERYTHEMA | ERYTHEMA | None | ERYTHEMA | None | HLT_0284 | None | HLGT_0192 | None | SKIN AND SUBCUTANEOUS TISSUE DISORDERS | None | SKIN AND SUBCUTANEOUS TISSUE DISORDERS | None | MILD | N | None | POSSIBLE | RECOVERED/RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2012-09-02 | 2012-08-07 | 2012-08-30 | 29 | 3 | 26 |
| 6 | CDISCPILOT01 | AE | 01-701-1028 | 1 | E04 | APPLICATION SITE ERYTHEMA | APPLICATION SITE ERYTHEMA | None | APPLICATION SITE ERYTHEMA | None | HLT_0617 | None | HLGT_0152 | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | MILD | N | None | POSSIBLE | NOT RECOVERED/NOT RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2013-08-01 | 2013-07-21 | None | 14 | 3 | None |
| 7 | CDISCPILOT01 | AE | 01-701-1028 | 2 | E05 | APPLICATION SITE PRURITUS | APPLICATION SITE ITCHING | None | APPLICATION SITE PRURITUS | None | HLT_0317 | None | HLGT_0338 | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | MILD | N | None | PROBABLE | NOT RECOVERED/NOT RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2013-08-14 | 2013-08-08 | None | 27 | 21 | None |
| 8 | CDISCPILOT01 | AE | 01-701-1034 | 1 | E08 | APPLICATION SITE PRURITUS | APPLICATION SITE ITCHING | None | APPLICATION SITE PRURITUS | None | HLT_0317 | None | HLGT_0338 | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | MILD | N | None | PROBABLE | NOT RECOVERED/NOT RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2014-09-25 | 2014-08-27 | None | 87 | 58 | None |
| 9 | CDISCPILOT01 | AE | 01-701-1034 | 2 | E07 | FATIGUE | FATIGUE | None | FATIGUE | None | HLT_0043 | None | HLGT_0181 | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS | None | MILD | N | None | POSSIBLE | NOT RECOVERED/NOT RESOLVED | N | N | N | N | N | N | N | TREATMENT | 2014-11-18 | 2014-11-02 | None | 141 | 125 | None |