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.

Company Characteristics Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_CHARACTERISTICS_PIT: Tracks history of the company_characteristics table with start and end timestamps to indicate row validity periods.

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 Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_INDEX_PIT: Tracks history of the company_index table with start and end timestamps to indicate row validity periods.

Company RelationshipsView Source Documentation

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

Company Relationships Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_RELATIONSHIPS_PIT: Tracks history of the company_relationships table with start and end timestamps to indicate row validity periods.

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.

Company Security Relationships Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_SECURITY_RELATIONSHIPS_PIT: Tracks history of the company_security_relationships table with start and end timestamps to indicate row validity periods.

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.

PermID Security Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.PERMID_SECURITY_INDEX_PIT: Tracks history of the permid_security_index table with start and end timestamps to indicate row validity periods.