Global Legal Entity Identifier Foundation

GLEIF

Overview

The Global Legal Entity Identity Foundation (GLEIF) is an interntatinol non-profit that publishes the Global LEI Index. This index includes historical and current LEI (legal entity identifier) records including related reference data in a single repository. The Global LEI Index is, "the only global online source that provides open, standardized and high quality legal entity reference data."

Key Attributes

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes

The COMPANY_INDEX table serves as the spine for Cybersyn 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. Cybersyn maps these IDs together to allow users to join datasets together using common unique identifiers. All Cybersyn 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. EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. Index tables contain all entities of a certain type. Timeseries tables contain all timeseries' dates and values that refer to an entity type. Additional tables, such as the relationships table and attributes table, are used to describe the entities and timeseries. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details

Tables & Sources

Cybersyn Products

Tables above are available in the following Cybersyn data products:

Examples & Sample Queries

Aggregate company identifiers and metadata about companies

Search for commonly-used corporate identifiers such as CIK and EIN as well as stock-specific identifiers like ticker symbol and OpenFIGI ID.

SELECT
    idx.company_id,
    idx.company_name,
    idx.cik,
    idx.ein,
    idx.lei,
    openfigi.openfigi_share_class_id,
    openfigi.primary_ticker,
    idx.permid_company_id
FROM cybersyn.company_index AS idx
JOIN cybersyn.company_characteristics AS char
    ON (idx.company_id = char.company_id)
JOIN cybersyn.company_security_relationships AS rship
    ON (idx.company_id = rship.company_id)
JOIN cybersyn.openfigi_security_index AS openfigi
    ON ARRAY_CONTAINS(rship.security_id::VARIANT, openfigi.openfigi_share_class_id)
WHERE char.relationship_type = 'sic_description'
  AND char.value = 'Air transportation, scheduled';

Disclaimers

The data in this product is sourced from Global Legal Entity Identifier Foundation (GLEIF).

Cybersyn is not endorsed by or affiliated with any of these providers. Contact support@cybersyn.com for questions.

Last updated

Copyright © 2024 Cybersyn