Doc HomeSupport

S&P Capital IQ Enrichment Source

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

Suggest Edits

đź‘‹

Looking to use S&P Capital IQ Enrichment?

Contact Tamr at [email protected] to inquire about licensing options.

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
tamr_ciq_enrich_status The status of the S&P Capital IQ enrichment:
  • MATCH_NAME_ADDRESS: The enrichment attributes provided by S&P Capital IQ were matched to this company based on the company name and full address.
  • MATCH_NAME_CITY: The enrichment attributes provided by S&P Capital IQ were matched to this company based on the company name, city, country, and either region or postal code.
  • MATCH_NAME_COUNTRY: The enrichment attributes provided by S&P Capital IQ were matched to this company based on the company name and country.
  • MATCH_PHONE: The enrichment attributes provided by S&P Capital IQ were matched to this company based on the cleaned phone number.
  • MATCH_WEBSITE: The enrichment attributes provided by S&P Capital IQ were matched to this company based on the cleaned website.
  • NOT_AVAILABLE_IN_SELECTED_SOURCE: S&P Capital IQ does not have information associated with this company’s Tamr Enrich ID.
  • UNRECOGNIZED_TAMR_ENRICH ID: Tamr Enrich does not recognize the ID.
  • NO_MATCH_INVALID_NAME: A match was not found due to an invalid company name. Either the company name was empty, or the name contained only special characters or generic legal form information (for example CORP or LLC).
  • NO_MATCH_INVALID_COUNTRY: A match was not found due to an invalid (empty) country.
  • NO_MATCH: A match was not found.


Note: This value may not match the Tamr Enrich ID tamr_firmographic_match_status. This happens when a higher level match is available in one of the other supported data providers. For example, a match based on “MATCH_NAME_ADDRESS” was found in BoldData, and a match based on “MATCH_NAME_COUNTRY” was found in S&P Capital IQ (the selected provider). In this case, the value of the Tamr Enrich ID tamr_firmographic_match_status is "MATCH_NAME_ADDRESS" while the value of tamr_ciq_enrich_status is "MATCH_NAME_COUNTRY".
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

Updated about 2 months ago