U.S. Census Bureau
FOREIGN TRADE STATISTICS: Your Key to Trade [Skip all navigation and go directly to page content]
[Go to the FTD MAIN page.]
[FTD Main Navigation] MAIN: About Foreign Trade | Data | A.E.S. | Regulations | Reference | Definitions | Schedule B | FAQs | Feedback | Search
[FTD Subject Navigation] REFERENCE: Announcements and Information Papers | Codes | FAQs | Forms | Guides
[ADVERT: USATrade Online - Trade data online]

U.S. Exports Merchandise Trade Files - Layouts



FILENAME: CONCORD.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 235

POSITION FIELD NAME DESCRIPTION
1-10 commodity 10-Digit Schedule B Commodity Code
11-160 descriptn 150-Digit Schedule B Commodity Code Description
161-210 abbreviatn 50-Digit Schedule B Commodity Code Description
211-213 unit_qy1 3-digit Unit of Quanitity 1
214-216 unit_qy2 3-digit Unit of Quanitity 2
217-221 sitc 5-Digit SITC Code
222-226 end_use 5-Digit ENDUSE Code
227-232 naics 6-Digit NAICS Code
233-233 usda 1-Digit USDA Code
234-235 hitech 2-Digit HITECH Code

 

FILENAME: COUNTRY.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 61

POSITION FIELD NAME DESCRIPTION
1-4 cty_code 4-Digit Country Code
5-11 cty_desc 7-Digit Country Description
12-61 cty_name 50-Digit Country Name

 

FILENAME: DISTRICT.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 59

POSITION FIELD NAME DESCRIPTION
1-2 dist_code 2-Digit Distrcit Code
3-9 dist_desc 7-Digit District Description
10-59 dist_name 50-Digit District Name

 

FILENAME: ENDUSE.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 105

POSITION FIELD NAME DESCRIPTION
1-5 enduse 5-Digit ENDUSE Code*
6-105 eudesc 100-Digit ENDUSE Description

* Includes 1-, 2-, 3-, and 5-digit end-use codes.

 

FILENAME: EXP_COMM.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 373

POSITION FIELD NAME DESCRIPTION
1-1 df 1-digit Domestic or Foreign Code
2-11 commodity 10-digit Schedule B Commodity Code
12-61 comm_desc 50-digit Schedule B Commodity Code Description
62-64 unit_qy1 3-digit Unit of Quantity 1
65-67 unit_qy2 3-digit Unit of Quantity 2
68-71 year 4-digit Statistical Year
72-73 month 2-digit Statistical Month
74-88 cards_mo 15-digit Card Count
89-103 qty_1_mo 15-digit Quantity 1
104-118 qty_2_mo 15-digit Quantity 2
119-133 all_val_mo 15-digit Total Value
134-148 air_val_mo 15-digit Air Value
149-163 air_wgt_mo 15-digit Air Shipping Weight
164-178 ves_val_mo 15-digit Vessel Value
179-193 ves_wgt_mo 15-digit Vessel Shipping Weight
194-208 cnt_val_mo 15-digit Containerized Vessel Value
209-223 cnt_wgt_mo 15-digit Containerized Vessel Shipping Weight
224-238 cards_yr 15-digit Year-to-Date Card Count
239-253 qty_1_yr
15-digit Year-to-Date Quantity 1
254-268 qty_2_yr 15-digit Year-to-Date Quantity 2
269-283 all_val_yr 15-digit Year-to-Date Total Value
284-298 air_val_yr 15-digit Year-to-Date Air Value
299-313 air_wgt_yr 15-digit Year-to-Date Air Shipping Weight
314-328 ves_val_yr 15-digit Year-to-Date Vessel Value
329-343 ves_wgt_yr 15-digit Year-to-Date Vessel Shipping Weight
344-358 cnt_val_yr 15-digit Year-to-Date Containerized Vessel Value
359-373 cnt_wgt_yr 15-digit Year-to-Date Containerized Vessel Shipping Weight

 

FILENAME: EXP_CTY.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 280

POSITION FIELD NAME DESCRIPTION
1-4 cty_code 4-digit Country Code
5-34 cty_name 30-digit Country Name
35-38 year 4-digit Statistical Year
39-40 month 2-digit Statistical Month
41-55 cards_mo 15-digit Card Count
56-70 all_val_mo 15-digit Total Value
71-85 air_val_mo 15-digit Air Value
86-100 air_wgt_mo 15-digit Air Shipping Weight
101-115 ves_val_mo 15-digit Vessel Value
116-130 ves_wgt_mo 15-digit Vessel Shipping Weight
131-145 cnt_val_mo 15-digit Containerized Vessel Value
146-160 cnt_wgt_mo 15-digit Containerized Vessel Shipping Weight
161-175 cards_yr 15-digit Year-to-Date Card Count
176-190 all_val_yr 15-digit Year-to-Date Total Value
191-205 air_val_yr 15-digit Year-to-Date Air Value
206-220 air_wgt_yr 15-digit Year-to-Date Air Shipping Weight
221-235 ves_val_yr 15-digit Year-to-Date Vessel Value
236-250 ves_wgt_yr 15-digit Year-to-Date Vessel Shipping Weight
251-265 cnt_val_yr 15-digit Year-to-Date Containerized Vessel Value
266-280 cnt_wgt_yr 15-digit Year-to-Date Containerized Vessel Shipping Weight

 

FILENAME: EXP_DETL.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 323

POSITION FIELD NAME DESCRIPTION
1-1 df 1-digit Domestic or Foreign Code
2-11 commodity 10-digit Harmonized Tariff Schedule (HTS) Code
12-15 cty_code 4-digit Country Code
16-17 district 2-digit District Code
18-21 year 4-digit Statistical Year
22-23 month 2-digit Statistical Month
24-38 cards_mo 15-digit Card Count
39-53 qty_1_mo
15-digit Quantity 1
54-68 qty_2_mo 15-digit Quantity 2
69-83 all_val_mo 15-digit Total Value
84-98 air_val_mo 15-digit Air Value
99-113 air_wgt_mo 15-digit Air Shipping Weight
114-128 ves_val_mo 15-digit Vessel Value
129-143 ves_wgt_mo 15-digit Vessel Shipping Weight
144-158 cnt_val_mo 15-digit Containerized Vessel Value
159-173 cnt_wgt_mo 15-digit Containerized Vessel Shipping Weight
174-188 cards_yr 15-digit Year-to-Date Card Count
189-203 qty_1_yr 15-digit Year-to-Date Quantity 1
204-218 qty_2_yr 15-digit Year-to-Date Quantity 2
219-233 all_val_yr 15-digit Year-to-Date Total Value
234-248 air_val_yr 15-digit Year-to-Date Air Value
249-263 air_wgt_yr 15-digit Year-to-Date Air Shipping Weight
264-278 ves_val_yr 15-digit Year-to-Date Vessel Value
279-293 ves_wgt_yr 15-digit Year-to-Date Vessel Shipping Weight
294-308 cnt_val_yr 15-digit Year-to-Date Containerized Vessel Value
309-323 cnt_wgt_yr 15-digit Year-to-Date Containerized Vessel Shipping Weight

 

FILENAME: EXP_DIST.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 278

POSITION FIELD NAME DESCRIPTION
1-2 district 2-digit District Code
3-32 dist_name 30-digit District Name
33-36 year 4-digit Statistical Year
37-38 month 2-digit Statistical Month
39-53 cards_mo 15-digit Card Count
54-68 all_val_mo 15-digit Total Value
69-83 air_val_mo 15-digit Air Value
84-98 air_wgt_mo 15-digit Air Shipping Weight
99-113 ves_val_mo 15-digit Vessel Value
114-128 ves_wgt_mo 15-digit Vessel Shipping Weight
129-143 cnt_val_mo 15-digit Containerized Vessel Value
144-158 cnt_wgt_mo 15-digit Containerized Vessel Shipping Weight
159-173 cards_yr 15-digit Year-to-Date Card Count
174-188 all_val_yr 15-digit Year-to-Date Total Value
189-203 air_val_yr 15-digit Year-to-Date Air Value
204-218 air_wgt_yr 15-digit Year-to-Date Air Shipping Weight
219-233 ves_val_yr 15-digit Year-to-Date Vessel Value
234-248 ves_wgt_yr 15-digit Year-to-Date Vessel Shipping Weight
249-263 cnt_val_yr 15-digit Year-to-Date Containerized Vessel Value
264-278 cnt_wgt_yr 15-digit Year-to-Date Containerized Vessel Shipping Weight

 

FILENAME: HITECH.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 32

POSITION FIELD NAME DESCRIPTION
1-2 hitech 2-Digit HITECH Code
3-32 hidesc 30-Digit HITECH Description

 

FILENAME: HSDESC.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 206

POSITION FIELD NAME DESCRIPTION
1-6 commodity 6-Digit Harmonized Code
7-156 descriptn 150-Digit Commodity Description
157-206 abbreviatn 50-Digit Commodity Description

* Includes 2-, 4-, and 6-digit HS codes.

 

FILENAME: NAICS.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 56

POSITION FIELD NAME DESCRIPTION
1-6 naics 6-Digit NAICS Code
7-56 naicdesc 50-Digit NAICS Description

* Includes 2-, 3-, 4-, 5-, and 6-digit NAICS codes.

 

FILENAME: SITC.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 205

POSITION FIELD NAME DESCRIPTION
1-5 sitc 5-Digit SITC Code
6-155 sitcdesc 150-Digit SITC Description
156-205 sitcabrev 50-Digit SITC Description

* Includes 1-, 2-, 3-, 4-, and 5-digit SITC codes.

 

FTD Web News

What is required for me to ship charity goods to Haiti?
From GLOBAL REACH: "In order to facilitate the movements of these goods, we offer the following guidance that applies to any goods not requiring a license, such as food, clothing, and medicines." (January 22, 2010)

Foreign Trade has GLOBAL REACH
Foreign Trade has just created and published its official blog, "Global Reach." Visit it to discuss the Foreign Trade Regulations, Export Filing (AES), Trade Data, and other trade related topics. Posts are current and relevant to you as the filer, exporter, data user, or curious blog reader. (January 5, 2010)

FTZ: Guidelines for Submtting Statistical Data (PDF) (1.8 MB)
Guidelines and best practices for fulfilling FTZ's statistical reporting requirements are now available.

NEW EXPORT TRAINING VIDEOS!!!
- Training videos on topics such as the Foreign Trade Regulations, AESDirect, NAFTA, Taxes/Tariffs, Commodities, etc. now available!

2009 Constant Dollar Data
- The Census Bureau identified a processing error that caused incorrect deflators to be applied to the revised data for 2009. The data have been corrected.

2009 DATA PRODUCT CHANGES
- U.S. Census Bureau will modify the structure of several data products to accommodate changing technology and user demand.

EXPORT COMPLIANCE SEMINARS AND WORKSHOPS
- The export environment has dramatically changed. Come and understand what it takes to remain compliant, aware and out of trouble.

2003 AES Option 4 Moratorium
Option 4 Filing Review Process Suspended

AES Compliance Best Practices:
Best Practices for maintaining AES Compliance are now available.

Related Party Database Application:
Time series RELATED PARTY data for specific commodities and countries.

ORDER AND DOWNLOAD FOREIGN TRADE DATA PRODUCTS:
- Online Order Form
- FTD DropBox
- Merchandise Trade Downloads

NEW Schedule B Search Engine:
It's new. It's flexible. It has more options.

NEWEST TRADE DATA!
- Get the basics!
- Learn more!

Source: FTDWebMaster, Foreign Trade Division, U.S. Census Bureau, Washington, D.C. 20233
Location: MAIN: REFERENCE: CATALOGS
Created: 1 September 2008
Last modified: 13 November 2008 at 09:28:02 AM