Skip Main Navigation Skip To Navigation Content

Foreign Trade

Skip top of page navigation
You are here: Census.govBusiness & IndustryForeign Trade › U.S. International Trade Data

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 (domestic = 1; foreign = 2)
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.

 


June 2014
Trade Numbers

Deficit: $41.5 Billion
Exports: $195.9 Billion
Imports: $237.4 Billion

Next release: September 4, 2014
Complete Release Schedule

Export Training Videos


Collection of videos to enhance export training.

Upcoming Training

AES Compliance Seminars

Aug 20-21, 2014
Buffalo, NY

Contact Us

Contact the Foreign Trade Data Dissemination staff: Email us! or use our feedback form!

Call us: (301)763-2311 or 1-800-549-0595 option 4

[PDF] or PDF denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Reader® Off Site available free from Adobe. [Excel] or the letters [xls] indicate a document is in the Microsoft® Excel® Spreadsheet Format (XLS). To view the file, you will need the Microsoft® Excel® Viewer Off Site available for free from Microsoft®. [MSWord] or the letters [doc] indicate a document is in the Microsoft® Word Format (DOC). To view the file, you will need the Microsoft® Word Viewer Off Site available for free from Microsoft®. This symbol Off Site indicates a link to a non-government web site. Our linking to these sites does not constitute an endorsement of any products, services or the information found on them. Once you link to another site you are subject to the policies of the new site.
Source: U.S. Census Bureau | Foreign Trade | ftdwebmaster@census.gov |  Last Revised: December 13, 2011