Skip to main content

Security Master

Overview​

Snowflake's COMPANY_INDEX table serves as the spine for Snowflake data that involves company-level identifiers. This table is a list of ~100K public and private companies aggregated from the Securities and Exchange Commission (SEC), Refinitiv, the Global Legal Entity Identifier Foundation (GLEIF), and the IRS. Each of these sources have their own unique identifier for companies, listed below. Snowflake maps these IDs together to allow users to join datasets together using common unique identifiers. All Snowflake datasets that include Company entities use the COMPANY_ID field as the unique ID for the Company.

  • The LEI (Legal Entity Identifier) is a 20-character, alpha-numeric code based on the ISO 17442 standard, assigned to distinct legal entities that engage in financial transactions and administered by the Global Legal Entity Identifier Foundation (GLEIF).
  • The EIN (Employer Identification Number) is issued by the US Internal Revenue Service (IRS) and is a unique 9-digit number used to identify business entities for tax purposes.
  • The CIK (Central Index Key) is issued by the US Securities and Exchange Commission (SEC) and is a unique number assigned to corporations, individuals, and foreign governments who are required to file disclosures with the SEC.
  • The PERMID_COMPANY_ID is issued by PermID from Refinitiv and is a permanent identifier that they publish for organization entities.

The COMPANY_CHARACTERISTICS table serves as a compliment to the COMPANY_INDEX table. This table includes a unique ID for each company (COMPANY_ID) and associated categorical characteristics: address, legal structure, previous names, SEC industry group, EIN, CIK, LEI, PermID, Refinitiv business sector and industry code/description, and SIC code/description. A characteristic may be temporal with start and end dates indicating the range for which the data is valid.

Notes​

Snowflake combines data from the SEC, LSEG's PermID, GLEIF, and OpenFigi to create our company/security masters.

Disclaimers​

See the individual source pages for legal disclaimers. Snowflake is not endorsed by or affiliated with any of these providers. Contact snowflake-public-data@snowflake.com for questions.