S&P Capital IQ Attributes

👋
Looking to use S&P Capital IQ Enrichment?
Contact Tamr at [email protected] to inquire about licensing options.

S&P Capital IQ is a premium enrichment service. An S&P data license in required to use this service in the RealTime B2B Customers data product.

The following attributes are provided by S&P Capital IQ enrichment.

By default, each attribute is prefaced with capiq_result_ when included in publish and curation views.

S&P Capital IQ Attribute	Description
match_result_tamr_enrich_id	The organization id (`org_id` ) of the matching S&P Capital IQ reference record.
match_result_match_confidence	The level of confidence with which Tamr matched this S&P Capital IQ reference record: Very high, high, medium, or low.
match_result_match_drivers	The attributes on which the record matched or partially matched to the S&P Capital IQ reference record (company name, address attributes, phone, registration number, website, and so on).
company_id	Unique entity identifier created by S&P Capital IQ.
organization_name	Name of the organization.
address_line_1	First line of the street address for the organization.
address_line_2	Second line of the street address for the organization.
address_line_3	Third line of the street address for the organization.
address_line_4	Fourth line of the street address for the organization.
city	City for the organization.
region	Textual description of the state for the organization.
region_abbreviation	Abbreviation of the state (e.g., NY) for the organization.
postal_code	Zip code of the organization.
country	Textual description for the country for the organization.
iso_country_2	The organization's ISO alpha-2 country code.
iso_country_3	The organization's ISO alpha-3 country code.
country_geo_region	Textual description for the region of the organization.
office_phone_value	Main phone number of the organization.
other_phone_value	Alternate phone number of the organization.
office_fax_value	Fax number of the organization.
year_founded	Year the organization was founded.
month_founded	Month in which the organization was founded.
day_founded	Day on which the organization was founded.
website	Web address for the organization.
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).
incorporation_country	Country in which the organization was incorporated.
incorporation_region	State in which the organization was incorporated.
simple_industry_description	Descriptive name for the industry of the organization.
company_type_name	Textual description of the organization type.
company_status_type_name	Textual description of the status type (e.g., Operating, Reorganizing, Acquired) for the organization.
us_number_of_employees_previous_year	The organization's number of employees from the previous year.
ltm_sales_mm	The organization's sales over the last 12 months
number_of_employees	The organization's number of employees.
us_latest_year_employee_growth	The organization's employee growth over the last year.
us_number_of_employees_current_year	The organization's number of employees for the current year.
parent_company_id	Unique entity identifier created by S&P Capital IQ of the parent organization.
parent_organization_name	Name of the parent organization.
parent_address_line_1	First line of the street address for the parent organization.
parent_address_line_2	Second line of the street address for the parent organization.
parent_address_line_3	Third line of the street address for the parent organization.
parent_address_line_4	Fourth line of the street address for the parent organization.
parent_city	City of the parent organization.
parent_region	Textual description of the state for the parent organization.
parent_region_abbreviation	Abbreviation of the state (e.g., NY) for the parent organization.
parent_postal_code	Zip code of the parent organization.
parent_country	Textual description for the country for the parent organization.
parent_iso_country_2	The parent organization's ISO alpha-2 country code.
parent_iso_country_3	The parent organization's ISO alpha-3 country code.
parent_country_geo_region	Textual description for the region of the parent organization.
parent_office_phone_value	Main phone number of the parent organization.
parent_other_phone_value	Alternate phone number of the parent organization.
parent_office_fax_value	Fax number of the parent organization.
parent_year_founded	Year the parent organization was founded.
parent_month_founded	Month in which the parent organization was founded.
parent_day_founded	Day on which the parent organization was founded.
parent_website	Web address for the parent organization.
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).
parent_incorporation_country	Country in which the parent organization was incorporated.
parent_incorporation_region	State in which the parent organization was incorporated.
parent_simple_industry_description	Descriptive name for the industry of the parent organization.
parent_company_type_name	Textual description of the parent organization type.
parent_company_status_type_name	Textual description of the status type (e.g., Operating, Reorganizing, Acquired) for the parent organization.
parent_us_number_of_employees_previous_year	The parent organization's number of employees from the previous year.
parent_ltm_sales_mm	The parent organization's sales over the last 12 months
parent_number_of_employees	The parent organization's number of employees.
parent_us_latest_year_employee_growth	The parent organization's employee growth over the last year.
parent_us_number_of_employees_current_year	The parent organization's number of employees for the current year.
ultimate_parent_company_id	Unique entity identifier created by S&P Capital IQ of the ultimate parent organization.
ultimate__parent_organization_name	Name of the ultimate parent organization.
ultimate__parent_address_line_1	First line of the street address for the ultimate parent organization.
ultimate__parent_address_line_2	Second line of the street address for the ultimate parent organization.
ultimate_parent_address_line_3	Third line of the street address for the utlimate parent organization.
ultimate__parent_address_line_4	Fourth line of the street address for the ultimate parent organization.
ultimate__parent_city	City of the ultimate parent organization.
ultimate_parent_region	Textual description of the state for the ultimate parent organization.
ultimate__parent_region_abbreviation	Abbreviation of the state (e.g., NY) for the ultimate parent organization.
ultimate__parent_postal_code	Zip code of the ultimate parent organization.
ultimate_parent_country	Textual description for the country for the ultimate parent organization.
ultimate__parent_iso_country_2	The ultimate parent organization's ISO alpha-2 country code.
ultimate__parent_iso_country_3	The ultimate parent organization's ISO alpha-3 country code.
ultimate_parent_country_geo_region	Textual description for the region of the ultimate parent organization.
ultimate_parent_office_phone_value	Main phone number of the ultimate parent organization.
ultimate_parent_other_phone_value	Alternate phone number of the ultimate parent organization.
ultimate_parent_office_fax_value	Fax number of the ultimate parent organization.
ultimate__parent_year_founded	Year the ultimate parent organization was founded.
ultimate_parent_month_founded	Month in which the ultimate parent organization was founded.
ultimate_parent_day_founded	Day on which the ultimate parent organization was founded.
ultimate__parent_website	Web address for the ultimate parent organization.
ultimate__parent_reporting_template_type_id	The unique identifier for the template type of the ultimate parent organization. This defines the template in which a organization's financials were collected (e.g. Bank, Industrial, Insurance).
ultimate_parent_incorporation_country	Country in which the ultimate parent organization was incorporated.
ultimate__parent_incorporation_region	State in which the ultimate parent organization was incorporated.
ultimate__parent_simple_industry_description	Descriptive name for the industry of the ultimate parent organization.
ultimate__parent_company_type_name	Textual description of the ultimate parent organization type.
ultimate_parent_company_status_type_name	Textual description of the status type (e.g., Operating, Reorganizing, Acquired) for the ultimate parent organization.
ultimate_parent_us_number_of_employees_previous_year	The ultimate parent organization's number of employees from the previous year.
ultimate_parent_ltm_sales_mm	The ultimate parent organization's sales over the last 12 months
ultimate_parent_number_of_employees	The ultimate parent organization's number of employees.
ultimate_parent_us_latest_year_employee_growth	The ultimate parent organization's employee growth over the last year.
ultimate_parent_us_number_of_employees_current_year	The ultimate parent organization's number of employees for the current year.