Overview of U.S. Top Products Page:
The U.S. Top Products Page provides a ranked list of U.S. Products in any of the concordances provided by the Census Bureau at all but the most detailed HS levels. You can view graphs and line graphs for up to the top 20 products. Detail is available by country, for the period 2000-present, with the current year and prior year-to-date and current statistical month available for the most recent two years. NAICs data and HS data are also available by State for imports and exports. The number of items to view can be changed including to all items (up to a maximum of 1500 products), as well as what year is ranked, what product trade shares are shown and what year-to-year change and percentage change calculations are shown. The Top Products page is meant to provide a single page of output for a single region (country region for US total or for an individual state). While virtually any product can be displayed except 10-digit HS, this report is not intended to produce reports for multiple countries or multiple states.
What Countries are Available:
All individual countries the U.S. reports statistics for, plus about 30-40 standard TPIS country groups are available, such as World regions (continents, Europe, South America, Asia, …) as well as sub-continent areas, and economic and political groupings such as OECD, OPEC, Special Tariff Areas (FTA, CBERA).
What Products or Industries are Available:
Except for HS 8-digit and 10-digit detail, all products are available at any relevant digit level. The products are classified by both source (concordance) and by digit level. For NAICs, SITC and NEI, there are also a few product groupings that you can select and the top products in the grouping can be displayed at a relevant digit level. Because the top products web page tries to provide a ranked listing, the digit level to be displayed is relevant. If you select an individual product, say and HS 2-digit code like HS 64-textiles and apparel, the ranked listing will be for all products at the 4-digit or 6-digit HS level that start with the 1st two digits 64. SITC non-manufactures would rank products in the range 0-4 at the 1-digit level or higher depending on your choice.
What Concordances and digit levels are Available:
· HS – Harmonized System (to codes used to collect the statistics): digits 2, 4 and 6-digit
· NAICS – North American Industry Classification System: digit 2*, 3, 4, 5, 6
· SITC – Standard International Trade Classification System: Digits 1, 2, 3, 4, 5
· ENDUSUE – BEA End Use Categories: Digits 2, 3, 5 (4-don’t have descriptions)
· HITECH – High Technology Products: A 2-digit code assigned at 10-dgits HS by Census FTD.
· NEI – Groups of 6-digit HS defined by US DOC/ITA as relevant for the National Export Initiative
How Do I Change to a Different Concordance, say NAICs to HS:
Near the top of the page there is a label “Source:” with a dropdown box to the right that defaults to “NAICS”. Click the down arrow on the right of the dropdown box and select another source (concordance). Note the source is originally HS 10-digit data for all concordances, but the 10-digit HS export and import codes have correspondences to the other concordances: NAICS, SITC, ENDUSE, HITTECH assigned by the Census Bureau’s Foreign Trade Division and/or the U.S. International Trade Commission. The Source Dropdown box is shown below:
How do the Product Selection Dropdown Boxes Work:
There are three related (actually nested) Product Dropdown boxes, labeled “PRODUCT:’, “..Product Detail”, “..More Product Detail”. The “selected” product will be the one in the most detailed product box that does NOT have “Not Selected” showing. The “PRODUCT:” dropdown box is the most aggregate of the boxes. It generally holds the Total for all products (industries) as well as any special groupings for NAICS and SITC. The “..Product Detail” box shows the products matching the selection at a somewhat more disaggregate level, 4-digit and 6-digit for HS, 3,4 digit for NAICS, 2, 3 digit for SITC, … The “..More Product Detail” product dropdown box shows the most detail products available. Products are arranged this way to make navigating thousands of products a bit easier—by changing a selection in a more detailed box or the Source Concordance, it immediately changes (closes) the more detailed boxes and populates the detailed boxes with relevant products. (Note that if you choose a product that doesn’t have a more detailed breakdown, only the total will show (twice) because there is nothing to rank. So choose a product at less than the maximum digit level and optionally select a digit level to display. Below shows 2 different product selections:
1. NAICS non-durables and a 3-digit non-durable selection for 313-Textiles and Fabrics:
With output like:
2. HS at a 4-digit level for category 60-Kitted or Crocheted Fabrics, and the 4-digit 6001 under it-Pile Fabrics..
With output like:
How do I Select a Digit Level for the Ranked Items:
Just below the Product Selection Dropboxes, there is a line where you can change the number of leading items to show, the digit level to display, and the time period to use in the ranking. The digit level is selected in the dropdown boxes next to the “@” label:
I want to see a ranking of the Top 10 products for the most recent period:
Change “Show Top” dropdown box to display 10. In the same line to the right of the digits to display, select the most recent year-to-date period (the sum of all months available for the latest year), or rank according to the latest month available for the current year.
The tabular output would look like:
And for Ranking for the Most Current Month, the selections (for Europe top 5) in 2014 current month:
How do I Display Charts:
To display charts, you check the box labeled “Show
Charts”. Note that the maximum number of
ranked items that can be displayed in a chart is 19, so you must choose Top 20
or fewer to display charts.
The below selects the top 5 naics 4-digit industries and displays both import and export charts.
What Kinds of Charts and Graphs Can I display:
Pie charts showing the top x items and all other are the default chart type, and the chart shows the share for the “ranked” time period. You can also show line graphs to display trends for the selected range of (full) years for the total of the ranked items. Other charting and graphing options are available if you select “Advanced” options, the hit the “Refresh Button”. You can change the chart types to 2 or 3 dimensional, to donuts, horizontal bar graphs, vertical bar graphs, cones or funnels. You can change line graphs to 3-d or 2-d, and some other options. Plus, for line graphs, you can display the trends for the ranked products for either imports, exports or both, instead of the product total trend lines. The following how to select 2-d horizontal bar graphs, and export ranked product trend lines. (Must hit refresh button to see any changes in the charts/graphs displayed after changing options):
The chart and graph output for the above settings would be:
How Can I Display Trade for Asia, Then Look at Individual Countries in Asia:
To select ASIA as a group, you’d go to the line on the web page just below the “Show Top” line, and select the TPIS country grouping you want from the dropdown box to the right of the “In:” Label. You can see what selecting Asia would look like in the below clip: the “Asia” group is selected and the country (group) displayed is shown in the dropdown box to the left, next to the “For:” label. In this case, the total for Asia (.ASIA Total).
And output would be:
Then to dsplay an individual Country, China, in Asia, simply change the “For:” dropdown box to “China”, as show in the clip below:
Output for China would look like:
How Do I Display Data for a State:
Trade by U.S. State is available only for NAICS at the 2-digit, 3-digit and 4-digit levels, and for HS data at the 2,4, and 6-digit levels. At the moment, ranking by Current month is not available for state data (current month is zero), but you can rank by current year-to-date. To display data for a state, you must first select a source that can display data by state: These sources are: 1--U.S. State Trade By Industry, NAICS; 2--US State Trade By HS (2-,4-,6-digits); 3--U.S. Trade by NEI Priority Sectors. Note that NEI product groupings are defined by 6-digit HS commodities, so ranking any of the NEI priority sectors returns the top 6-digit HS codes in the sector.
The below selections show charts California Exports and Imports from South America for NAICS category 11-Agricultural and Livestock Products at the 4-digit HS:
For New York Trade in Aerospace (NEI group) products, the selections are:
And the output would look like:
Changing Scale, Default Flows, and Selecting Other Calculations in Data Tables:
In the Advanced Options section, you can change a number of elements of how the data in tables are displayed. You can suggest what scale to use ($Billions, $Millions, $000-thousnad, or $). You can Change Exports, which defaults to Total Exports (domestic + foreign) to either Domestic or Foreign (not available for State-Level Data). You can Change Imports from General Imports, Customs Value to, CIF Value, or Imports for Consumption, CIF Value, Customs Value, Duties, Dutiable Value, and Landed Duty Paid (CIF+Charges)—(Imports by state is only General Imports, Customs Value). You can also select various Time calculations, percentage changes, $ changes, shares for beginning-end periods as well as for all periods displayed. Check the “Advanced Options” then hit the “REFRESH” button to display the advanced table options. Then select the options you want and hit the “REFRESH” button again.
The following shows selecting shares calculations, percentage change calculations and $change calculations for all years, with data requested in $millions.
How Can I Hide the Selections and Get a Clean Printout of the Data or Graphs:
Press the “PRINT FORMAT” button to display just the output on the page. If you just want the data tables, make sure “Show Charts” and “Show Line Graph” options are NOT checked. If you just want Exports, uncheck Imports. To see only the charts, check the “Show Charts” option and uncheck “Show Line Graph” and uncheck “Display Tabular Data”. By default, the ITA logo appear in the title position of the “print format”: to suppress the ITA logo uncheck “Show ITA Logo in Print Format”. When all options are what you want, click the “Display in PRINT FORMAT” button and use the standard browser print options to print or save as a PDF.
Below demonstrates printing Charts and a Data table :