Data Analysis Tools

Complementing the release of the Shifts in U.S. Merchandise Trade 2014 (“2014 Trade Shifts”) and The Year in Trade 2014 reports, the U.S. International Trade Commission (Commission) has developed the Data Analysis Tools (DATs) series which consists of two (2) Excel files. (Links to the reports appear to the left.) The links to each of the Excel files appear below.

The DATs are a series of custom-built, Excel-based interactive dashboards that show selected U.S. merchandise trade data used in the reports. The tables and charts given in these dashboards do not repeat specific tables or charts presented in the reports. Instead, they complement the reports’ tables by displaying the same data in a series of interactive tables and associated charts that are intended to quickly provide additional analytical insights.

Moreover, the Trade Shifts and Year in Trade reports have historically presented only a few years of time series data for most trade tables—typically five years for Trade Shifts and three for The Year in Trade. By contrast, many of these dashboards include data spanning 15 years or more.

These data are official U.S. import and export statistics published by the U.S. Census Bureau (Census) of the U.S. Department of Commerce, accessed March–April 2015. Data from years before 2010 do not contain any Census revisions. Data for 2010 through 2013 reflect all Census revisions issued as of June 30, 2014.

Note that the data in these dashboards may not perfectly match the data reported in the Trade Shifts and Year in Trade reports, for two reasons:

  1. 2014 Trade Shifts, in a departure from previous years and as described more fully in the Web-based report itself, uses an expanded set of trade measures to allow a more inclusive look at the composition of U.S. trade flows.
  2. Data in a Year in Trade report are occasionally adjusted by the Commission before the report is published (e.g., to reflect implementation dates of individual trade agreements). Such adjustments are generally footnoted in the applicable table(s) of the report.

Dashboards contents:
Excel File 1 (size: 87 mb) Please note: large file may take time to load.

Tab Dashboards
DB1 Dashboard 1: Major trading partner dashboard
  Details:
  • HTS 6-digit subheading product level detail
  • Major trading partner detail (smaller trading partners aggregated into “Rest of World” or “ROW”)
  • Five years of data:  2010 through 2014
  • Imports = U.S. general imports
  • Exports = U.S. total exports

DB2 Dashboard 2: Trading partner-sector dashboard
  Details:
  • High-level product sector details
  • All trading partner details
  • Eighteen years of data: 1997 through 2014
  • Imports = U.S. general imports
  • Exports = U.S. total exports

DB3 Dashboard 3: Shifts in trade digest dashboard
  Details:
  • Medium-level product digest details
  • U.S. trade with the world
  • Eighteen years of data: 1997 through 2014
  • Imports = U.S. general imports
  • Exports = U.S. total exports
  • Analysis of 2014 Trade Shifts data

DB4 Dashboard 4: Domestic and re-exports (also called foreign exports) dashboard (see definitions link in the
“Resources” box in the navigation pane at the top left of the individual 2014 Trade Shifts webpages)
  Details:
  • Medium-level product digest details
  • U.S. trade with major trading partners
  • Eighteen years of data: 1997 through 2014
  • Exports = domestic, re-exports, and total exports
  • Comparison of subsets to overall U.S. benchmark

DB5 Dashboard 5: Major trade preference programs dashboard
  Details:
  • HTS 6-digit subheading product-level detail
  • U.S. trade with preference program trading partners
  • Eighteen years of data: 1997 through 2014
  • Imports = U.S. imports for consumption
  • Preferential treatment data only:
    - African Growth and Opportunity Act (AGOA);
    - Andean Trade Preference Act/Andean Trade Promotion and Drug Eradication Act (ATPA/ATPDEA);
    - Caribbean Basin Economic Recovery Act/U.S.-Caribbean Basin Trade Partnership Act (CBERA/CBTPA);
    - Generalized System of Preferences (GSP); and
    - The Haitian Hemispheric Opportunity through Partnership Encouragement Act of 2006 (HOPE), the Food
Conservation and Energy Act of 2008 (HOPE II), and the Haiti Economic Lift Program of 2010 (HOPE/HELP)

Excel File 2 (size: 104 mb) Please note: large file may take time to load.

Tab Dashboards
DB6 Dashboard 6:  U.S. Free Trade Agreement (FTA) trading partner imports
  Details:
  • HTS 6-digit subheading, 2-digit chapter product-level detail
  • 2014 U.S. FTA trading partners
  • 18 years of data: 1997 through 2014
  • Imports = U.S. general imports and U.S. imports for consumption
  • Duty information, claimed under FTA provision info and foreign trade zone (FTZ) and bonded warehouse
information

DB7 Dashboard 7:  EU partner imports
  Details:
  • HTS 6-digit subheading, 2-digit chapter product level detail
  • Trading partners within the EU
  • 15 years of data:  2000 through 2014
  • Imports = U.S. general imports and U.S. imports for consumption
  • Duty information and FTZ and bonded warehouse information