U.S. Census Bureau

Related Party Trade Database

Help

Table of contents:



Description

RELATED PARTY trade data is published as imports and exports.

  • IMPORTS
    • Related-party trade includes import transactions between parties with various types of relationships including "any person directly or indirectly, owning, controlling or holding power to vote, 6 percent of the outstanding voting stock or shares of any organization."

  • EXPORTS
    • A related-party export transaction is one between a U.S. exporter and a foreign consignee, where either party owns, directly or indirectly, 10 percent or more of the other party.
    • These numbers reflect domestic exports.

"Please select data you would like in your request"

NAICS Codes

Select multiple NAICS codes from this menu. They are listed in numeric order. The greater the number of digits in the code, the more detail that's available.

The top menu items start with the word "ALL" (e.g. "ALL NAICS2", "ALL NAICS3", etc.). These will pull every single code in that digit group. For example, if you select "ALL NAICS2", the report will include every single 2-digit NAICS code.

Limitations:

  • The system will not pull data for specific NAICS codes and a NAICS group simultaneously. So, you can pull data for "111 Agricultural Products" or "All NAICS 3", but you can't pull them both at the same time.

  • The system will not pull data for multiple NAICS groups simultaneously. So, you can select "All NAICS 3" for one request. You can select "All NAICS 2" for a different request. You can not select "All NAICS 3" and "All NAICS 2" at the same time.

  • The system will only pull data for "ALL COUNTRIES" and a NAICS group at the same time if you only display NAICS or COUNTRY. It will not work if you want to display NAICS and COUNTRY simultaneously.

Years

Select multiple years from this menu. This application provides annual data only.

Data for 2010 to present are revised. Data prior to 2010 are unrevised.


Countries

Select multiple countries from this menu. They are listed in alphabetic order.

The "ALL Countries" group at the top of the menu will provide all available countries for your request. There is no need to select additional countries.

Limitations:

  • The system will not pull data for "ALL COUNTRIES" and a specific country simultaneously.

  • The system will only pull data for "ALL COUNTRIES" and a NAICS group at the same time if you only display NAICS or COUNTRY. It will not work if you want to display NAICS and COUNTRY simultaneously.

Variables

The following variables are available to display in your report:

  • Imports
    • Total Trade: Total value of all imports for consumption
    • Related Trade: Trade with an entity located outside the United States in which the importer holds at least a 6% equity interest.
    • Nonrelated Trade: Trade between parties, whether importers or exporters that have no affiliation with each other or who do not meet the relevant equity requirements.
    • Nonreported Trade: Trade that has not been explicitly identified either related or non-related trade.

  • Exports
    • Domestic Total Trade: Total value of all domestic exports
    • Domestic Related Trade: Trade with an entity located outside the United States in which the exporter holds at least a 10% equity interest.
    • Domestic Nonrelated Trade: Trade between parties, whether importers or exporters that have no affiliation with each other or who do not meet the relevant equity requirements.
    • Domestic Nonreported Trade: Trade that has not been explicitly identified either related or non-related trade.

How would you like to layout your report?

Data can be displayed in many different ways. This application provides two (2) options:

  • NAICS by Country

    • All country data is grouped by NAICS codes. This option is best when you want to see which countries traded in specific products.

      SAMPLE of a NAICS by Country report with YEAR across
      NAICS
      Country
      2003
      2004
      2005
      Imports Total Trade
      Imports Total Trade
      Imports Total Trade
      111
      Canada
      698,339
      541,248
      879,214
      France
      987,148
      742,314
      147,477
      Mexico
      841,412
      321,147
      847,456
      112
      Canada
      145,783
      514,367
      846,552
      Mexico
      142,847
      894,332
      148,387
      TOTAL  
      2,815,529
      3,013,408
      2,869,086

  • Country by NAICS

    • All NAICS data is grouped by countries. This option is best when you want to see which products were traded by specific countries.

      SAMPLE of a Country by NAICS report with YEAR across
      Country NAICS
      2003
      2004
      2005
       
      Imports Total Trade
      Imports Total Trade
      Imports Total Trade
      Canada 111
      698,339
      541,248
      879,214
      112
      145,783
      514,367
      846,552
      France 111
      987,148
      742,314
      147,477
      Mexico 111
      841,412
      321,147
      847,456
      112
      142,847
      894,332
      148,387
      TOTAL  
      2,815,529
      3,013,408
      2,869,086

  • NAICS

    • Only list the NAICS code totals.

      SAMPLE of a NAICS report with YEAR across
      NAICS
      2003
      2004
      2005
       
      Imports Total Trade
      Imports Total Trade
      Imports Total Trade
      111
      2,526,899
      1,604,709
      1,874,147
      112
      288,630
      1,408,699
      994,939
      TOTAL
      2,815,529
      3,013,408
      2,869,086

  • COUNTRY

    • Only list the COUNTRY totals.

      SAMPLE of a NAICS report with YEAR across
      Country
      2003
      2004
      2005
       
      Imports Total Trade
      Imports Total Trade
      Imports Total Trade
      Canada

      844,122

      1,055,615
      1,725,766
      France
      987,148
      742,314
      147,477
      Mexico
      984,259
      1,215,479
      995,843
      TOTAL
      2,815,529
      3,013,408
      2,869,086

Each of these options has two variations:

  • YEAR Across:

    Display annual data in columns going across the report.

    SAMPLE of a Country by NAICS report with YEAR across
    Country NAICS 2003 2004 2005
     
    Imports Total Trade
    Imports Total Trade
    Imports Total Trade
    Canada 111
    698,339
    541,248
    879,214
    112
    145,783
    514,367
    846,552
    TOTAL COUNTRY
    844,122
    1,055,615
    1,725,766

  • YEAR Down:

    Display annual data in rows going down the report.

    SAMPLE of a Country by NAICS report with YEAR down
    Country NAICS Year Imports Total Trade
    Canada 111 2003
    698,339
    2004
    541,248
    2005
    879,214
    TOTAL NAICS
    2,118,801
    112 2003
    145,783
    2004
    514,367
    2005
    846,552
    TOTAL NAICS
    1,506,702
    TOTAL COUNTRY
    3,625,503

How would you like to format your data?

  • Descriptions

    • You can turn the descriptions ON and OFF. Instead of seeing "11 Agricultural and Livestock Products", you can see "11" which is the 2-digit NAICS code for "Agricultural and Livestock Products".

  • Variables
    • DOLLAR
      • Display all numbers with "$" in front of them.
    • COMMA
      • Display all numbers with commas in the appropriate places. Example: "2,875,345" instead of "2875345".
    • NO COMMA
      • Display all numbers with no formatting.

  • Totals
    • You can turn the TOTALS which appear at the bottom of the columns on and off.

      SAMPLE of data with TOTALS turned ON
      Country NAICS Year Imports Total Trade
      Canada 111 2003
      698,339
      2004
      541,248
      2005
      879,214
      TOTAL COUNTRY 2,118,801


      SAMPLE of data with TOTALS turned OFF
      Country NAICS Year Imports Total Trade
      Canada 111 2003
      698,339
      2004
      541,248
      2005
      879,214


How would you like to view your data?

  • HTML
    • A table (or series of tables) displayed inside your web browser.

  • CSV
    • A comma delimited file. Best suited for spreadsheets and databases.
      • Each row of data is on one line.
      • Each column is separated by a comma.

    • The column names in the CSV file are as follows:

      Variable names in CSV files
      Variable Name in the CSV file... ... represents this category.
      NAICS The seelcted NAICS codes.
      YEAR The selected years.
      IMP_TOT Imports Total Trade
      IMP_REL Imports Related Trade
      IMP_NON Imports Nonrelated Trade
      IMP_NOT Imports Nonreported Trade
      EXP_TOT Domestic Exports Total Trade
      EXP_REL Domestic Exports Related Trade
      EXP_NON Domestic Exports Nonrelated Trade
      EXP_NOT Domestic Exports Nonreported Trade

    • If YEARS are displayed across, they will be appended to the end of their respective variables.

      • Example:

        Pull data for "Imports Total Trade" and "Domestic Exports Total Trade" for 2010, 2011, and 2012. When YEARS are displayed DOWN, there will be a column for YEAR, IMP_TOT, and EXP_TOT. When YEARS are displayed across, there will be no column for YEAR, but the other variables will be listed as IMP_TOT2010, IMP_TOT2011, IMP_TOT2012, EXP_TOT2010, EXP_TOT2011, and EXP_TOT2012.

  • PDF
    • Adobe Acrobat file. You need the Adobe Acrobat Reader (free from Adobe) to read it.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Source: FTDWebMaster, Foreign Trade Division, U.S. Census Bureau, Washington, D.C. 20233
Location: MAIN: STATISTICS:HISTORICAL SERIES
Created: 09 May 2007
Last modified: 17 August 2017 at 02:21:47 PM


[an error occurred while processing this directive]