S&P Capital IQ Enrichment Source

You can enrich your company data with referential attributes from S&P Capital IQ.

👋

Looking to use S&P Capital IQ Enrichment?

Contact Tamr at [email protected].

S&P Capital IQ Attributes

When you select S&P Capital IQ Attributes as the enrichment source in the Tamr Enrich step, the following attributes are returned for mastered entities that have been successfully matched to a Tamr Enrich ID.

Attribute Name Description
ciq_enrich_status The status of the Tamr Enrich enrichment:

SUCCESS: valid id syntax and recognized by Tamr Enrich, successful enrichment

SITE: the returned enrichment attributes correspond to a site level match in this enrichment source

LEGAL ENTITY: the returned enrichment attributes correspond to a legal entity level match in this enrichment source. Note that this value may not match the Tamr Enrich ID tamr_firmographic_match_status. This happens when site level data is available in one or more supported enrichment sources, but this source provides only legal entity level data.

NOT AVAILALBE IN SELECTED SOURCE: this enrichment source does not have information for this Tamr Enrich ID.

NO TAMR ENRICH ID: a Tamr Enrich ID has not been provided (null or empty string)

INVALID TAMR ENRICH ID: invalid ID syntax

UNRECOGNIZED TAMR ENRICH ID: valid ID syntax but Tamr Enrich does not recognize the ID

ciq_company_id Unique entity identifier created by S&P Capital IQ.
ciq_organization_name Name of the organization.
ciq_city City of the organization.
ciq_office_fax_value Fax number of the organization.
ciq_office_phone_value Main phone number of the organization.
ciq_other_phone_value Alternate phone number of the organization.
ciq_address_line_1 First line of the street address for the organization.
ciq_address_line_2 Second line of the street address for the

organization.

ciq_address_line_3 Third line of the street address for the

organization.

ciq_address_line_4 Fourth line of the street address for the

organization.

ciq_year_founded Year the organization was founded.
ciq_month_founded Month in which the organization was founded.
ciq_day_founded Day on which the organization was founded.
ciq_postal_code Zip code of the organization.
ciq_website Web address for the organization.
ciq_reporting_template_type_id The unique identifier for the template type. This defines the template in which a organization's financials were collected (e.g. Bank, Industrial, Insurance).
ciq_incorporation_country Country in which the organization was incorporated.
ciq_incorporation_region State in which the organization was incorporated.
ciq_region Textual description of the state for the organization.
ciq_region_abbreviation Abbreviation of the state (e.g., NY) for the organization.
ciq_country Textual description for the country for the organization.
ciq_iso_country_2 The organization's ISO alpha-2 country code.
ciq_iso_country_3 The organization's ISO alpha-3 country code.
ciq_country_geo_region Textual description for the region of the organization.
ciq_simple_industry_description Descriptive name for the industry of the organization.
ciq_company_type_name Textual description of the organization type.
ciq_company_status_type_name Textual description of the status type (e.g., Operating, Reorganizing, Acquired) for the organization.
ciq_us_number_of_employees_previous_year The organization's number of employees from the previous year.
ciq_ltm_sales_mm The organization's sales over the last 12 months
ciq_number_of_employees The organization's number of employees.
ciq_us_latest_year_employee_growth The organization's employee growth over the last year.
ciq_us_number_of_employees_current_year The organization's number of employees for the current year.
ciq_parent_company_id Unique entity identifier created by S&P Capital IQ of the parent organization.
ciq_parent_organization_name Name of the parent organization.
ciq_parent_city City of the parent organization.
ciq_parent_office_fax_value Fax number of the parent organization.
ciq_parent_office_phone_value Main phone number of the parent organization.
ciq_parent_other_phone_value Alternate phone number of the parent organization.
ciq_parent_address_line_1 First line of the street address for the parent organization.
ciq_parent_address_line_2 Second line of the street address for the

parent organization.

ciq_parent_address_line_3 Third line of the street address for the

parent organization.

ciq_parent_address_line_4 Fourth line of the street address for the

parent organization.

ciq_parent_year_founded Year the parent organization was founded.
ciq_parent_month_founded Month in which the parent organization was founded.
ciq_parent_day_founded Day on which the parent organization was founded.
ciq_parent_postal_code Zip code of the parent organization.
ciq_parent_website Web address for the parent organization.
ciq_parent_reporting_template_type_id The unique identifier for the template type of the parent organization. This defines the template in which a organization's financials were collected (e.g. Bank, Industrial, Insurance).
ciq_parent_incorporation_country Country in which the parent organization was incorporated.
ciq_parent_incorporation_region State in which the parent organization was incorporated.
ciq_parent_region Textual description of the state for the parent organization.
ciq_parent_region_abbreviation Abbreviation of the state (e.g., NY) for the parent organization.
ciq_parent_country Textual description for the country for the parent organization.
ciq_parent_iso_country_2 The parent organization's ISO alpha-2 country code.
ciq_parent_iso_country_3 The parent organization's ISO alpha-3 country code.
ciq_parent_country_geo_region Textual description for the region of the parent organization.
ciq_parent_simple_industry_description Descriptive name for the industry of the parent organization.
ciq_parent_company_type_name Textual description of the parent organization type.
ciq_parent_company_status_type_name Textual description of the status type (e.g., Operating, Reorganizing, Acquired) for the parent organization.
ciq_parent_us_number_of_employees_previous_year The parent organization's number of employees from the previous year.
ciq_parent_ltm_sales_mm The parent organization's sales over the last 12 months
ciq_parent_number_of_employees The parent organization's number of employees.
ciq_parent_us_latest_year_employee_growth The parent organization's employee growth over the last year.
ciq_parent_us_number_of_employees_current_year The parent organization's number of employees for the current year.

S&P Capital IQ Enrichment Examples

Example 1

Step Output
ciq_company_id

22399386

ciq_organization_name Sesa Industries Limited
ciq_address_line_1 Sesa Ghor
ciq_address_line_2 20 EDC Complex
ciq_address_line_3 Patto
ciq_address_line_4
ciq_city Panaji
ciq_region Goa
ciq_region_abbreviation
ciq_postal_code

403001

ciq_country India
ciq_iso_country_2 IN
ciq_iso_country_3 IND
ciq_country_geo_region Asia / Pacific
ciq_office_phone_value 91 83 2238 6085
ciq_other_phone_value
ciq_office_fax_value
ciq_year_founded
ciq_month_founded
ciq_day_founded
ciq_website www.sesagoa.com
ciq_reporting_template_type_id

1

ciq_incorporation_country
ciq_incorporation_region
ciq_simple_industry_description Metals and Mining
ciq_company_type_name Private Company
ciq_company_status_type_name Operating Subsidiary
ciq_us_number_of_employees_previous_year
ciq_ltm_sales_mm
ciq_number_of_employees
ciq_us_latest_year_employee_growth
ciq_us_number_of_employees_current_year
ciq_parent_company_id

878252

ciq_parent_organization_name Vedanta Limited
ciq_parent_address_line_1 Unit 103, Corporate Avenue
ciq_parent_address_line_2 1st Floor, C wing
ciq_parent_address_line_3 Atul Projects, Chakala
ciq_parent_address_line_4 Andheri (East)
ciq_parent_city Mumbai
ciq_parent_region Maharashtra
ciq_parent_region_abbreviation
ciq_parent_postal_code

400093

ciq_parent_country India
ciq_parent_iso_country_2 IN
ciq_parent_iso_country_3 IND
ciq_parent_country_geo_region Asia / Pacific
ciq_parent_office_phone_value 91 22 6643 4500
ciq_parent_other_phone_value
ciq_parent_office_fax_value 91 22 6643 4530
ciq_parent_year_founded

1954

ciq_parent_month_founded
ciq_parent_day_founded
ciq_parent_website www.vedantalimited.com
ciq_parent_reporting_template_type_id

1

ciq_parent_incorporation_country India
ciq_parent_incorporation_region Maharashtra
ciq_parent_simple_industry_description Metals and Mining
ciq_parent_company_type_name Public Company
ciq_parent_company_status_type_name Operating Subsidiary
ciq_parent_us_number_of_employees_previous_year
ciq_parent_ltm_sales_mm
ciq_parent_number_of_employees

8129

ciq_parent_us_latest_year_employee_growth
ciq_parent_us_number_of_employees_current_year

Example 2

Step Output
ciq_company_id

1051730

ciq_organization_name Gateway Insurance Services, Inc.
ciq_address_line_1 404 Rocksylvania Iowa Falls
ciq_address_line_2
ciq_address_line_3
ciq_address_line_4
ciq_city Ankeny
ciq_region Iowa
ciq_region_abbreviation IA
ciq_postal_code

50126

ciq_country United States
ciq_iso_country_2 US
ciq_iso_country_3 USA
ciq_country_geo_region United States and Canada
ciq_office_phone_value 641 648 4275
ciq_other_phone_value
ciq_office_fax_value 641 648 4027
ciq_year_founded

1984

ciq_month_founded
ciq_day_founded
ciq_website >www.gisiowa.com
ciq_reporting_template_type_id

1

ciq_incorporation_country United States
ciq_incorporation_region Iowa
ciq_simple_industry_description Insurance
ciq_company_type_name Private Company
ciq_company_status_type_name Operating Subsidiary
ciq_us_number_of_employees_previous_year

20

ciq_ltm_sales_mm
ciq_number_of_employees
ciq_us_latest_year_employee_growth

-95

ciq_us_number_of_employees_current_year

1

ciq_parent_company_id

30794684

ciq_parent_organization_name TrueNorth Companies LLC
ciq_parent_address_line_1 500 1st Street SE
ciq_parent_address_line_2
ciq_parent_address_line_3
ciq_parent_address_line_4
ciq_parent_city Cedar Rapids
ciq_parent_region Iowa
ciq_parent_region_abbreviation IA
ciq_parent_postal_code

52401

ciq_parent_country United States
ciq_parent_iso_country_2 US
ciq_parent_iso_country_3 USA
ciq_parent_country_geo_region United States and Canada
ciq_parent_office_phone_value 319 364 5193
ciq_parent_other_phone_value 800 798 4080
ciq_parent_office_fax_value
ciq_parent_year_founded

2000

ciq_parent_month_founded
ciq_parent_day_founded
ciq_parent_website www.truenorthcompanies.com
ciq_parent_reporting_template_type_id

1

ciq_parent_incorporation_country United States
ciq_parent_incorporation_region Arizona
ciq_parent_simple_industry_description Insurance
ciq_parent_company_type_name Private Company
ciq_parent_company_status_type_name Operating
ciq_parent_us_number_of_employees_previous_year

318

ciq_parent_ltm_sales_mm
ciq_parent_number_of_employees

250

ciq_parent_us_latest_year_employee_growth

-0.3145

ciq_parent_us_number_of_employees_current_year

317