from pharmadata import pharmaversesdtm
meta = pharmaversesdtm.meta('mb')
print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}")Rows: 18 Columns: 21mb
mb
Microbiology Specimen
Variables
Show variable specs
shape: (21, 5)
| 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 |
| "MBSEQ" | "Sequence Number" | "Int32" | null | null |
| "MBGRPID" | "Group ID" | "Float64" | null | null |
| "MBREFID" | "Reference ID" | "String" | null | null |
| "MBLNKGRP" | "Link Group ID" | "String" | null | null |
| "MBTESTCD" | "Microbiology Test or Finding Short Name" | "String" | null | null |
| "MBTEST" | "Microbiology Test or Finding Name" | "String" | null | null |
| "MBTSTDTL" | "Measurement, Test or Examination Detail" | "String" | null | null |
| "MBORRES" | "Result or Finding in Original Units" | "String" | null | null |
| "MBORRESU" | "Original Units" | "String" | null | null |
| "MBRSLSCL" | "Result Scale" | "String" | null | null |
| "MBSTRESC" | "Result or Finding in Standard Format" | "String" | null | null |
| "MBSTRESN" | "Numeric Result/Finding in Standard Units" | "String" | null | null |
| "MBSTRESU" | "Standard Units" | "String" | null | null |
| "MBSPEC" | "Specimen Material Type" | "String" | null | null |
| "MBLOC" | "Specimen Collection Location" | "String" | null | null |
| "MBMETHOD" | "Method of Test or Examination" | "String" | null | null |
| "VISITNUM" | "Visit Number" | "Float64" | null | null |
| "MBDTC" | "Date/Time of Collection" | "String" | null | null |
Examples
from great_docs import tbl_explorer
from pharmadata import pharmaversesdtm
tbl_explorer(pharmaversesdtm.mb.head(10))PolarsRows10Columns21 | |||||||||||||||||||||
STUDYID str |
DOMAIN str |
USUBJID str |
MBSEQ i32 |
MBGRPID f64 |
MBREFID str |
MBLNKGRP str |
MBTESTCD str |
MBTEST str |
MBTSTDTL str |
MBORRES str |
MBORRESU str |
MBRSLSCL str |
MBSTRESC str |
MBSTRESN str |
MBSTRESU str |
MBSPEC str |
MBLOC str |
MBMETHOD str |
VISITNUM f64 |
MBDTC str |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CDISCPILOT01 | MB | 01-701-1015 | 1 | 1 | ALIQ1.1.2 | ALIQ1.1.2-C | GMNCOC | Gram Negative Cocci | DETECTION | PRESENT | None | Ord | PRESENT | None | None | SKIN TISSUE | SKIN OF THE AXILLA | GRAM STAIN | 1 | 2025-06-14T08:00 |
| 1 | CDISCPILOT01 | MB | 01-701-1015 | 2 | 1 | ALIQ1.1.2 | ALIQ1.1.2-C | GMNCOC | Gram Negative Cocci | QUANTIFICATION | 2+ | None | Ord | 2+ | 2 | None | SKIN TISSUE | SKIN OF THE AXILLA | GRAM STAIN | 1 | 2025-06-14T08:00 |
| 2 | CDISCPILOT01 | MB | 01-701-1015 | 3 | 2 | ALIQ1.1.2 | ALIQ1.1.2-C | MCCOLCNT | Colony Count | QUANTIFICATION | 100 | CFU/mL | Quant | 100 | CFU/mL | CFU/mL | SKIN TISSUE | SKIN OF THE AXILLA | COLONY COUNT | 1 | 2025-06-14T08:00 |
| 3 | CDISCPILOT01 | MB | 01-701-1015 | 4 | 3 | ALIQ1.1.3 | ALIQ1.1.3-C | GNROD | Gram Negative Rods | DETECTION | PRESENT | None | Ord | PRESENT | None | None | SKIN TISSUE | SKIN OF THE AXILLA | GRAM STAIN | 1 | 2025-06-14T08:00 |
| 4 | CDISCPILOT01 | MB | 01-701-1015 | 5 | 3 | ALIQ1.1.3 | ALIQ1.1.3-C | GNROD | Gram Negative Rods | QUANTIFICATION | 1+ | None | Ord | 1+ | 1 | None | SKIN TISSUE | SKIN OF THE AXILLA | GRAM STAIN | 1 | 2025-06-14T08:00 |
| 5 | CDISCPILOT01 | MB | 01-701-1015 | 6 | 4 | ALIQ1.1.3 | ALIQ1.1.3-C | MCCOLCNT | Colony Count | QUANTIFICATION | 50 | CFU/mL | Quant | 50 | CFU/mL | CFU/mL | SKIN TISSUE | SKIN OF THE AXILLA | COLONY COUNT | 1 | 2025-06-14T08:00 |
| 6 | CDISCPILOT01 | MB | 01-701-1015 | 7 | 5 | ALIQ1.2.1 | ALIQ1.2.1-C | GNROD | Gram Negative Rods | DETECTION | PRESENT | None | Ord | PRESENT | None | None | SKIN TISSUE | SKIN OF THE AXILLA | GRAM STAIN | 2 | 2025-06-21T08:00 |
| 7 | CDISCPILOT01 | MB | 01-701-1015 | 8 | 5 | ALIQ1.2.1 | ALIQ1.2.1-C | GNROD | Gram Negative Rods | QUANTIFICATION | 3+ | None | Ord | 3+ | 3 | None | SKIN TISSUE | SKIN OF THE AXILLA | GRAM STAIN | 2 | 2025-06-21T08:00 |
| 8 | CDISCPILOT01 | MB | 01-701-1015 | 9 | 6 | ALIQ1.2.1 | ALIQ1.2.1-C | MCCOLCNT | Colony Count | QUANTIFICATION | 500 | CFU/mL | Quant | 500 | CFU/mL | CFU/mL | SKIN TISSUE | SKIN OF THE AXILLA | COLONY COUNT | 2 | 2025-06-21T08:00 |
| 9 | CDISCPILOT01 | MB | 01-701-1023 | 1 | 1 | ALIQ2.1.2 | ALIQ2.1.2-C | GPRCOC | Gram Positive Cocci | DETECTION | PRESENT | None | Ord | PRESENT | None | None | URINE | URINARY SYSTEM | GRAM STAIN | 1 | 2025-07-15T08:00 |