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