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 |
Updated 18 days ago