Returns The Legacy Capital IQ Platform Corporate Tree Using The Company Relationship Dataset (v3)

This query returns the legacy Capital IQ corporate tree for a selected Company ID using the company relationship dataset. It includes selected filters: current investments, subsidiaries/operating units, investment arms, and merged entities, across all ownership types. Up to level 2, the hierarchy expands across all stake types; from level 3 onward, only entities with Majority ownership are returned, with recursion limited to seven levels. Link - https://www.capitaliq.com/CIQDotNet/CorporateTree/CorporateTree.aspx?CompanyId=25915843

Enhancement Date: 1/29/2026

  • SourceMarket Intelligence
  • Data Packages Required
    Base CompanyCompany Relationship ReferenceCompany Relationships
  • Associated Datasets
    公司关系

Query Types

  • Snowflake