smq_db

smq_db

Standardized MedDRA Queries

from pharmadata import pharmaversesdtm

meta = pharmaversesdtm.meta('smq_db')
print(f"Rows: {meta.number_rows:,}  Columns: {meta.number_columns}")
Rows: 44  Columns: 6

Variables

Show variable specs
shape: (6, 5)
variablelabeltypemandatoryrole
strstrstrnullnull
"termchar""Reported Term""String"nullnull
"scope""Scope""String"nullnull
"smq_name""Name""String"nullnull
"smq_id""Name ID""Int32"nullnull
"version""Version""String"nullnull
"termvar""Variable""String"nullnull

Examples

from great_docs import tbl_explorer
from pharmadata import pharmaversesdtm

tbl_explorer(pharmaversesdtm.smq_db.head(10))
PolarsRows10Columns6
termchar
str
scope
str
smq_name
str
smq_id
i32
version
str
termvar
str
0 Achromotrichia congenital narrow Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD
1 Craniosynostosis narrow Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD
2 Hypophosphatasia narrow Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD
3 Congenital pyelocaliectasis narrow Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD
4 Uterine contractions during pregnancy narrow Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD
5 Uterine contractions during pregnancy broad Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD
6 Ductus arteriosus premature closure narrow Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD
7 Pseudotruncus arteriosus narrow Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD
8 Lipomeningocele narrow Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD
9 Macrocephaly narrow Pregnancy and neonatal topics (SMQ) 20000185 20.1 AEDECOD