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: A.E.S. | Reference | Regulations | Statistics | 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

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.
- See Seminar and Workshop Schedule

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