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 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.