Skip to main content

Data Dictionary

Company CharacteristicsView Source Documentation

PUBLIC_DATA.COMPANY_CHARACTERISTICS: Characteristics for nearly 100k companies, including EIN, CIK, LEI, address information, industry descriptions, and more, with start and end date ranges.

PUBLIC_DATA.COMPANY_INDEX: Compiled list of public and private companies with a unique Snowflake company identifier (company_id) mapped to public identifiers like CIK, EIN, PermID, and LEI. This table serves as the spine for Cybersyn data that involves company-level identifiers.

Company RelationshipsView Source Documentation

PUBLIC_DATA.COMPANY_RELATIONSHIPS: Company subsidiary and parent relationships, joinable to Snowflake Public Data company_index table.

Company Security RelationshipsView Source Documentation

PUBLIC_DATA.COMPANY_SECURITY_RELATIONSHIPS: Map between companies and the securities (stocks, bonds, etc.) they issue, including security identifiers from common open sources, including OpenFIGI and PermID. Maps to Snowflake Public Data company index.

OpenFIGI Security IndexView Source Documentation

PUBLIC_DATA.OPENFIGI_SECURITY_INDEX: Security details for OpenFIGI Composite, Share Class, and FIGI IDs, including tickers, names, asset classes, types, subtypes, exchange codes, and related IDs.

PermID Security IndexView Source Documentation

PUBLIC_DATA.PERMID_SECURITY_INDEX: PermIDs for financial securities, including name, primary ticker, asset class, primary exchange, security status, and related global tickers.