NormTerm_CUI Table

  • I. Db Table

    NormTermCui
    NameTypePropertiesNotes
    normKeyTermVARCHAR(3100)Index, NOT NULLNormalized term
    cuiVARCHAR(8)NOT NULLConcept Unique Identifier

  • II. SQL Examples
    • Find CUI for term, "XXX"
      1. normXxx = LvgNorm("XXX")
      2. SELECT cui FROM NormTermCui WHERE normKeyTerm= 'NormXxx';

  • III. Data

    File: ${STMT_DIR}/data/tables/normTermCui.data
    Used in smt and mt

    Meta VersionRows
    Meta-2020AB12,846,408
    Meta-2020AA12,390,483
    Meta-2019AB12,227,428
    Meta-2019AA11,421,872
    Meta-2018AB11,334,948
    Meta-2018AA10,908,150
    Meta-2017AB10,804,573
    Meta-2017AA10,391,723
    Meta-2016AB10,285,050
    Meta-2016AA9,824,750
    Meta-2015AB9,601,523
    Meta-2015AA9,500,098
    Meta-2014AB9,419,535
    Meta-2014AA9,065,928
    Meta-2013AB8,603,754
    Meta-2013AA8,695,321
    Meta-2012AB8,607,838
    Meta-2012AA7,996,479
    Meta-2011AB7,930,988
    Meta-2011AA7,350,864