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.

Text Categorization

SH_JD_SCORES Table

  • I. Db Table

    SH_JD_SCORES
    NameTypePropertiesNotes
    shVARCHAR(3)Index, NOT NULLSub heading abbreviation (lower case)
    jidVARCHAR(6)Index, NOT NULLJournal descriptor ID
    scoreFLOAT scores based on document count for sub-heading

  • II. SQL Examples
    • Find scores for SH, "XXX"
      1. "xxx" = "XXX".toLowerCase( );
      2. SELECT jid, score FROM SH_JD_SCORES WHERE sh= 'xxx';