Syntax US LargeCap 500
Feed Details
Get yearly classification of the Syntax US LargeCap 500 constituents at both the company and product line levels. Get revenue information broken down by both product line and geographic segments.
Data export enables analyst to:
- Understand multiple company risk factors that leverages a patented, multi-attributed classification system
- Screen companies based on industry, lines of business, product line revenue, or geographic segments.
- Create accurate peer groups and identify competitors at the business and product line levels.
To get full access...
Contact Us* Some companies may have additional historical classification data.
Data Preview
LCSID | Fiscal Year | Product Line ID | Revenue segment | Product Line Name | Metric Type | Metric Percentage | Is Primary |
---|---|---|---|---|---|---|---|
LC0000002923 | 2013 | 18983 | Aerospace | Diversified Active Systems and Components for Commercial Airplanes; sold to OEMs | Revenue | 18.03 | true |
LC0000002923 | 2013 | 18986 | Aerospace | Commercial Airplane Maintenance | Revenue | 12.64 | true |
LC0000002923 | 2013 | 18987 | Automation and Control Solutions | Diversified Sensors; sold to OEMs | Revenue | 42.39 | true |
LC0000002923 | 2013 | 18989 | Performance Materials and Technologies | Diversified Chemicals and Polymer Applications | Revenue | 17.32 | true |
LC0000002923 | 2013 | 18997 | Transportation Systems | Diversified Active Components and Systems | Revenue | 9.61 | true |
LC0000002923 | 2017 | 18999 | Aerospace Sales | Diversified Active Systems and Components for Commercial Airplanes; sold to OEMs | Revenue | 6.11 | true |
RBR ID | Parent RBR ID | Taxonomy | Name | Description | Level |
---|---|---|---|---|---|
82734 | Activity | Activity | The Activity lens analyzes companies based on shared business activities, irrespective of the resource being acted upon. The lens is segmented into the following groups: Produce, Sell/Broker, Lease/Rent/Subscription, Process Transactions/Transfer Money, Infrastructure Operators, Software Developers and Operators of Website/Electronic Platforms, Transportation, Financing, Underwriting, and Trading, Professional Services, Research, Development, and Design, Leisure, Accommodation, and Recreation, Social and Consumer Services, and Maintenance, Repair, and Cleaning. | 1 | |
82735 | 82734 | Activity | Produce | The related business risk associated with the Produce group is the manufacture, extraction, and development of resources. | 2 |
82737 | 82735 | Activity | Manufacturing | The related business risk associated with the Manufacturing group is the is the production of products using labour, machines, tools, chemical and biological processing, or formulation. | 3 |
82739 | 82735 | Activity | Media and Information Production | The related business risk associated with the Media Production group is the publishing, broadcasting, and producing of media. | 3 |
82740 | 82735 | Activity | Outsourced Production | The related business risk associated with the Outsourced Production group are companies who source and design products but outsource the production to third party manufacturers. | 3 |
82741 | 82734 | Activity | Sell/Broker | The related business risk associated with the Sell/Broker group is the selling or brokerage of goods and services. | 2 |
LCSID | Fiscal Year | Region | Region Type | Revenue as Percentage |
---|---|---|---|---|
LC0000002923 | 2013 | Other | Superregion | 16.06 |
LC0000002923 | 2013 | EMEA | Superregion | 25.10 |
LC0000002923 | 2013 | Europe | Region | 25.10 |
LC0000002923 | 2013 | Americas | Superregion | 58.83 |
LC0000002923 | 2013 | North America | Region | 58.83 |
LC0000002923 | 2013 | North America | Subregion | 58.83 |
LCSID | Company Name |
---|---|
LC0000002923 | Honeywell International Inc |
LC0000028845 | Walt Disney Co (The) |
LC0000085480 | AT&T Inc |
LC0000287805 | Amazon.com Inc |
LC0001079599 | Microsoft Corp |
LCSID | Share Class FIGI |
---|---|
LC0000028845 | BBG001S5QHF3 |
LC0000085480 | BBG001S5VWH2 |
LC0001079599 | BBG001S5TD05 |
LC0000002923 | BBG001S5X1N1 |
LC0000287805 | BBG001S5PQL7 |
LCSID | Fiscal Year | RBR ID | Summary Classification Name |
---|---|---|---|
LC0000002923 | 2013 | 82734 | Diversified Equipment and Materials |
LC0000002923 | 2013 | 82735 | Diversified Equipment and Materials |
LC0000002923 | 2013 | 82737 | Diversified Equipment and Materials |
LC0000002923 | 2014 | 82734 | Diversified Equipment and Materials |
LC0000002923 | 2014 | 82735 | Diversified Equipment and Materials |
LC0000002923 | 2014 | 82737 | Diversified Equipment and Materials |
Product Line ID | RBR ID |
---|---|
2396 | 3527 |
18983 | 3527 |
18987 | 3527 |
18999 | 3527 |
19001 | 3527 |
19002 | 3527 |
Documentation
Company to Product Lines
Product lines represent the unique activities that an enterprise enacts on the economy. Some companies will have only one product line, whereas conglomerates will have many.
name | type | description |
---|---|---|
LCSID | String | Locus Classification System Identifier. Affinity Data's unique identifier for companies. |
Fiscal Year | Integer | Integer marking the fiscal year of classification, as product line data changes with time. |
Product Line ID | Integer | ID of record in Product Line table. |
Revenue Segment | String | Category Segment of Revenue. |
Product Line Name | String | Name of the product line. |
Metric Type | String | Metrics we use to distinguish product lines, including: Total proven reserves, Revenue, Operating profit, Net insurance premiums, Net income, Loan portfolio, Gross profit, EBITDA, Backlog, Assets under management |
Metric Percentage | Float | Percentage of this metric attributed to this product line, e.g. percentage of revenue a company earned from this product line in a given fiscal year. |
Is Primary | Boolean | The product line’s metric is listed as a Primary Metric for that given fiscal year. |
Related Business Risks (RBRs)
This table provides details about an RBR, including its taxonomic info.
name | type | description |
---|---|---|
Taxonomy | String | Taxonomy Name. |
RBR ID | Integer | RBR Identifier. Used to join company entities to RBR entities. |
Parent RBR ID | Integer | RBR Identifier. A reference to the RBR that serves as a taxonomical parent. |
Name | String | RBR Name. |
Description | String | Text description of an RBR. |
Level | Integer | Numerical value representing an RBR group’s depth in a taxonomy. Taxonomy depth indicates specificity, with higher numerical values indicating greater specificity. Note that different taxonomies may have different maximum depth levels. |
Company to Geographic Segments
This table provides regional breakdowns of revenue.
name | type | description |
---|---|---|
LCSID | String | Locus Classification System Identifier. Affinity Data's unique identifier for companies. |
Fiscal Year | Integer | Integer marking the fiscal year of classification, as geographic segment data changes with time. |
Region | String | Any kind of geographic region. |
Region Type | String | The type of region. This can be one of: Superregion, Region, Subregion, Country, and State. |
Revenue as Percentage | Float | Percentage of the company's total revenue. In cases where the region is marked as unattributed, the revenue percentage represents the portion of revenue that cannot be attributed to lower level regions. |
Companies
This table provides a company name and our own unique identifier that will unify RBR and product line queries.
name | type | description |
---|---|---|
LCSID | String | Locus Classification System Identifier. Affinity Data's unique identifier for companies. |
Company Name | String | A company’s registered name. |
Company to OpenFIGIs
Join table connecting Companies to OpenFIGI identifiers. For more information on using these identifiers visit the OpenFIGI website.
name | type | description |
---|---|---|
LCSID | String | Locus Classification System Identifier. Affinity Data's unique identifier for companies. |
Share Class FIGI | String | Financial Instrument Global Identifier. |
Companies Markers
This table serves as a join table between company and RBR entities.
name | type | description |
---|---|---|
LCSID | String | Locus Classification System Identifier. Affinity Data's unique identifier for companies. |
Fiscal Year | Integer | Integer marking the fiscal year of classification, as company RBR data changes with time |
RBR ID | Integer | RBR Identifier. Used to join company entities to RBR entities. |
Summary Classification Name | String | The primary classification name used to associate the company with its related business risks |
Product Lines to RBRs
This table Joins RBRs to Product Lines.
name | type | description |
---|---|---|
Product Line ID | Integer | ID of record in Product Line table. |
RBR ID | Integer | ID of record in RBR table. |
Show all the companies that got more than 10% of their revenue from Real Estate Construction Equipment in 2018.
SELECT
c.lcsid, c.company_name, SUM(pl.metric_percentage) metric_percentage
FROM
us_largecap_companies c
JOIN us_largecap_company_to_product_lines pl ON pl.lcsid = c.lcsid
WHERE
pl.product_line_name = 'Real Estate Construction Equipment'
AND pl.metric_type = 'Revenue'
AND pl.metric_percentage > 10.0
AND pl.fiscal_year = 2018
GROUP BY c.lcsid, c.company_name
Results
LCSID | Company Name | Metric Percentage |
---|---|---|
LC0000012345 | Caterpillar Inc | 41.94 |
LC0000012346 | Deere & Co | 21.37 |
Show all the companies that do business outside of the US have had exposure to Weapons and Defense.
SELECT DISTINCT
c.lcsid, c.company_name, gs.region
FROM us_largecap_companies c
JOIN us_largecap_company_to_product_lines pl ON pl.lcsid = c.lcsid
JOIN us_largecap_product_lines_to_rbrs ptr ON ptr.product_line_id = pl.product_line_id
JOIN us_largecap_related_business_risks rbr ON ptr.rbr_id = rbr.rbr_id
JOIN us_largecap_company_to_geographic_segments gs ON gs.lcsid = c.lcsid
WHERE
rbr.name = 'Defense Equipment'
AND rbr.taxonomy = 'Resource'
AND gs.region != 'United States'
AND gs.region_type != 'State'
Results
LCSID | Company Name | Region |
---|---|---|
LC0000012355 | Boeing Co | Asia |
LC0000012356 | Lockheed Martin Corp | Middle East |
LC0000012357 | Northrop Grumman Corp | Asia |
LC0000012358 | Rockwell Collins Inc | EMEA |
LC0000012359 | Textron Inc | APAC |
Show all the RBRs with the most companies in this data set by their primary function.
SELECT rbr.rbr_id, rbr.name, count(c.lcsid) number_of_companies
FROM us_largecap_related_business_risks rbr
JOIN us_largecap_companies_markers cm ON rbr.rbr_id = cm.rbr_id
JOIN us_largecap_companies c ON cm.lcsid = c.lcsid
WHERE cm.fiscal_year = '2018'
GROUP BY rbr.rbr_id, rbr.name
ORDER BY number_of_companies DESC
Results
RBR ID | RBR Name | Number of Companies |
---|---|---|
401 | Sector | 442 |
405 | Resource | 432 |
403 | Activity | 428 |
407 | Distribution Model | 224 |
409 | Produce | 217 |
Show all companies with over 6 product lines in 2018.
SELECT c.lcsid, c.company_name, count(pl.id)
FROM us_largecap_companies c
JOIN us_largecap_company_to_product_lines pl ON pl.lcsid = c.lcsid
WHERE pl.fiscal_year = 2018
GROUP BY c.lcsid, c.company_name
HAVING count(pl.id) > 6
Results
LCSID | Company Name | Count |
---|---|---|
LC0000065078 | Bank of America Corp | 16 |
LC0000039644 | General Dynamics Corp | 9 |
LC0000132860 | Cincinnati Financial Corp | 9 |
LC0000219337 | Chubb Ltd | 8 |
LC0000197459 | Perrigo Co Plc | 9 |
Show the sector assignment for a company in 2017.
SELECT c.lcsid, rbr.name, rbr.rbr_id, rbr.parent_rbr_id
FROM us_largecap_companies c
JOIN us_largecap_companies_markers cm ON c.lcsid = cm.lcsid
JOIN us_largecap_related_business_risks rbr ON cm.rbr_id = rbr.rbr_id
WHERE rbr.taxonomy = 'Sector'
AND cm.fiscal_year = 2017
AND c.lcsid = 'LC0000006718'
Results
LCSID | RBR Name | RBR ID | Parent RBR ID |
---|---|---|---|
LC0000006718 | Sector | 2967 | NULL |
LC0000006718 | Information Tools | 3105 | 2967 |
LC0000006718 | Hardware | 3117 | 3105 |
LC0000006718 | End User Hardware | 3126 | 3117 |
LC0000006718 | Wireless Phones | 3128 | 3126 |