Because of a lapse in government funding, the information on this website may not be up to date, transactions submitted via the website may not be processed, and the agency may not be able to respond to inquiries until appropriations are enacted. The NIH Clinical Center (the research hospital of NIH) is open. For more details about its operating status, please visit cc.nih.gov. Updates regarding government operating status and resumption of normal operations can be found at OPM.gov.

Sub-Term Mapping Tools

NormInflvar_EUI Table

  • I. Db Table

    NormInflvarEui
    NameTypePropertiesNotes
    normInflvarVARCHAR(120)Index, NOT NULLNormalized inflectional variants
    euiVARCHAR(8)NOT NULLEntry Unique Identifier

  • II. SQL Examples
    • Find EUI for term, "XXX"
      1. normXxx = LexItemNorm("XXX")
      2. SELECT eui FROM NormInflvarEui WHERE normInflvar= 'NormXxx';

  • III. Data

    File: ${STMT_DIR}/data/tables/normInflvarEui.data

    • Unicode Lexicon (used in lsf, mt)
      Meta Version (AA/AB)Rows
      Lexicon-2025910,433
      Lexicon-2024907,871
      Lexicon-2023904,386
      Lexicon-2022899,356
      Lexicon-2021892,616
      Lexicon-2020883,929
      Lexicon-2019874,906
      Lexicon-2018860,202
      Lexicon-2017846,444
      Lexicon-2016832,666
      Lexicon-2015818,931
      Lexicon-2014804,657
      Lexicon-2013791,470
      Lexicon-2012775,340
      Lexicon-2011749,738

    • ASCII Lexicon (used in MetaMap, the only table in ASCII DB)
      Meta VersionRows
      Lexicon-2025-ASCII902,536
      Lexicon-2024-ASCII899,974
      Lexicon-2023-ASCII896,489
      Lexicon-2022-ASCII891,472
      Lexicon-2021-ASCII884,744
      Lexicon-2020-ASCII876,132
      Lexicon-2019-ASCII867,149
      Lexicon-2018-ASCII852,650
      Lexicon-2017-ASCII839,427
      Lexicon-2016-ASCII825,801
      Lexicon-2015-ASCII812,272
      Lexicon-2014-ASCII798,698
      Lexicon-2013-ASCII785,755
      Lexicon-2012-ASCII769,883
      Lexicon-2011-ASCII745,033