from pharmadata import cdiscpilotsdtm
meta = cdiscpilotsdtm.meta('dm')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 306 Columns: 25dm
dm
Demographics
Structure: One record per subject
Variables
Show variable specs
shape: (25, 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" |
| "SUBJID" | "Subject Identifier for the Study" | "String" | "Yes" | "TOPIC" |
| "RFSTDTC" | "Subject Reference Start Date/Time" | "String" | "No" | "RECORD QUALIFIER" |
| "RFENDTC" | "Subject Reference End Date/Time" | "String" | "No" | "RECORD QUALIFIER" |
| "RFXSTDTC" | "Date/Time of First Study Treatment" | "String" | "No" | "RECORD QUALIFIER" |
| "RFXENDTC" | "Date/Time of Last Study Treatment" | "String" | "No" | "RECORD QUALIFIER" |
| "RFICDTC" | "Date/Time of Informed Consent" | "String" | "No" | "RECORD QUALIFIER" |
| "RFPENDTC" | "Date/Time of End of Participation" | "String" | "No" | "RECORD QUALIFIER" |
| "DTHDTC" | "Date/Time of Death" | "String" | "No" | "RECORD QUALIFIER" |
| "DTHFL" | "Subject Death Flag" | "String" | "No" | "RECORD QUALIFIER" |
| "SITEID" | "Study Site Identifier" | "String" | "Yes" | "RECORD QUALIFIER" |
| "AGE" | "Age" | "Float64" | "No" | "RECORD QUALIFIER" |
| "AGEU" | "Age Units" | "String" | "No" | "VARIABLE QUALIFIER" |
| "SEX" | "Sex" | "String" | "Yes" | "RECORD QUALIFIER" |
| "RACE" | "Race" | "String" | "No" | "RECORD QUALIFIER" |
| "ETHNIC" | "Ethnicity" | "String" | "No" | "RECORD QUALIFIER" |
| "ARMCD" | "Planned Arm Code" | "String" | "Yes" | "RECORD QUALIFIER" |
| "ARM" | "Description of Planned Arm" | "String" | "Yes" | "SYNONYM QUALIFIER" |
| "ACTARMCD" | "Actual Arm Code" | "String" | "Yes" | "RECORD QUALIFIER" |
| "ACTARM" | "Description of Actual Arm" | "String" | "Yes" | "SYNONYM QUALIFIER" |
| "COUNTRY" | "Country" | "String" | "Yes" | "RECORD QUALIFIER" |
| "DMDTC" | "Date/Time of Collection" | "String" | "No" | "TIMING" |
| "DMDY" | "Study Day of Collection" | "Float64" | "No" | "TIMING" |
Examples
from great_docs import tbl_explorer
from pharmadata import cdiscpilotsdtm
tbl_explorer(cdiscpilotsdtm.dm.head(10))PolarsRows10Columns25 | |||||||||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
SUBJID str |
RFSTDTC str |
RFENDTC str |
RFXSTDTC str |
RFXENDTC str |
RFICDTC str |
RFPENDTC str |
DTHDTC str |
DTHFL str |
SITEID str |
AGE f64 |
AGEU str |
SEX str |
RACE str |
ETHNIC str |
ARMCD str |
ARM str |
ACTARMCD str |
ACTARM str |
COUNTRY str |
DMDTC str |
DMDY f64 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | DM | 01-701-1015 | 1015 | 2014-01-02 | 2014-07-02 | 2014-01-02 | 2014-07-02 | None | 2014-07-02T11:45 | None | None | 701 | 63 | YEARS | F | WHITE | HISPANIC OR LATINO | Pbo | Placebo | Pbo | Placebo | USA | 2013-12-26 | -7 |
| 1 | CDISCPILOT01 | DM | 01-701-1023 | 1023 | 2012-08-05 | 2012-09-02 | 2012-08-05 | 2012-09-01 | None | 2013-02-18 | None | None | 701 | 64 | YEARS | M | WHITE | HISPANIC OR LATINO | Pbo | Placebo | Pbo | Placebo | USA | 2012-07-22 | -14 |
| 2 | CDISCPILOT01 | DM | 01-701-1028 | 1028 | 2013-07-19 | 2014-01-14 | 2013-07-19 | 2014-01-14 | None | 2014-01-14T11:10 | None | None | 701 | 71 | YEARS | M | WHITE | NOT HISPANIC OR LATINO | Xan_Hi | Xanomeline High Dose | Xan_Hi | Xanomeline High Dose | USA | 2013-07-11 | -8 |
| 3 | CDISCPILOT01 | DM | 01-701-1033 | 1033 | 2014-03-18 | 2014-04-14 | 2014-03-18 | 2014-03-31 | None | 2014-09-15 | None | None | 701 | 74 | YEARS | M | WHITE | NOT HISPANIC OR LATINO | Xan_Lo | Xanomeline Low Dose | Xan_Lo | Xanomeline Low Dose | USA | 2014-03-10 | -8 |
| 4 | CDISCPILOT01 | DM | 01-701-1034 | 1034 | 2014-07-01 | 2014-12-30 | 2014-07-01 | 2014-12-30 | None | 2014-12-30T09:50 | None | None | 701 | 77 | YEARS | F | WHITE | NOT HISPANIC OR LATINO | Xan_Hi | Xanomeline High Dose | Xan_Hi | Xanomeline High Dose | USA | 2014-06-24 | -7 |
| 5 | CDISCPILOT01 | DM | 01-701-1047 | 1047 | 2013-02-12 | 2013-03-29 | 2013-02-12 | 2013-03-09 | None | 2013-07-28 | None | None | 701 | 85 | YEARS | F | WHITE | NOT HISPANIC OR LATINO | Pbo | Placebo | Pbo | Placebo | USA | 2013-01-22 | -21 |
| 6 | CDISCPILOT01 | DM | 01-701-1057 | 1057 | None | None | None | None | None | 2013-12-27 | None | None | 701 | 59 | YEARS | F | WHITE | HISPANIC OR LATINO | Scrnfail | Screen Failure | Scrnfail | Screen Failure | USA | 2013-12-20 | None |
| 7 | CDISCPILOT01 | DM | 01-701-1097 | 1097 | 2014-01-01 | 2014-07-09 | 2014-01-01 | 2014-07-09 | None | 2014-07-09T09:39 | None | None | 701 | 68 | YEARS | M | WHITE | NOT HISPANIC OR LATINO | Xan_Lo | Xanomeline Low Dose | Xan_Lo | Xanomeline Low Dose | USA | 2013-12-23 | -9 |
| 8 | CDISCPILOT01 | DM | 01-701-1111 | 1111 | 2012-09-07 | 2012-09-17 | 2012-09-07 | 2012-09-16 | None | 2013-02-22 | None | None | 701 | 81 | YEARS | F | WHITE | NOT HISPANIC OR LATINO | Xan_Lo | Xanomeline Low Dose | Xan_Lo | Xanomeline Low Dose | USA | 2012-08-25 | -13 |
| 9 | CDISCPILOT01 | DM | 01-701-1115 | 1115 | 2012-11-30 | 2013-01-23 | 2012-11-30 | 2013-01-23 | None | 2013-05-20 | None | None | 701 | 84 | YEARS | M | WHITE | NOT HISPANIC OR LATINO | Xan_Lo | Xanomeline Low Dose | Xan_Lo | Xanomeline Low Dose | USA | 2012-11-23 | -7 |