Related Party Trade Database Application: Help

Table of contents:

• Description
• "Please select data you would like in your request"
  • NAICS Codes
  • Years
  • Countries
  • Variables
• How would you like to layout your report?
  • NAICS by Country
  • Country by NAICS
  • NAICS
  • COUNTRY
  • Year Down/Across
• How would you like to format your data?
  • Descriptions
  • Variables
  • Totals
• How would you like to view your data?
  • HTML
  • CSV
  • PDF
    

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.

"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.

---

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.
  • Non-Related Trade: Trade between parties, whether importers or exporters that have no affiliation with each other or who do not meet the relevant equity requirements.
  • Not Reported Trade: Trade that has not been explicitly identified either related or non-related trade.
    
    
• Exports
  • Total Trade: Total value of all domestic exports
  • Related Trade: Trade with an entity located outside the United States in which the exporter holds at least a 10% equity interest.
  • Non-Related Trade: Trade between parties, whether importers or exporters that have no affiliation with each other or who do not meet the relevant equity requirements.
  • Not Reported 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.
• PDF
  • Adobe Acrobat file. You need the Adobe Acrobat Reader (free from Adobe) to read it.