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 History Files - Layouts



FILENAME: CONCORD.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 245

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
236-245 years_ap 10-Digit All 2-Digit Years Schedule B Code has Data During 5 Year History

 

FILENAME: COUNTRY.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 51

POSITION FIELD NAME DESCRIPTION
1-4 cty_code 4-Digit Country Code
5-11 cty_desc 7-Digit Country Description
12-41 cty_name 30-Digit Country Name
42-51 years_ap 10-Digit All 2-Digit Years Country Code Was Valid During 5 Year History

 

FILENAME: DISTRICT.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 49

POSITION FIELD NAME DESCRIPTION
1-2 dist_code 2-Digit Distrcit Code
3-9 dist_desc 7-Digit District Description
10-39 dist_name 30-Digit District Name
40-49 years_ap 10-Digit All 2-Digit Years District Code Was Valid During 5 Year History

 

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: 224

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-74 years_ap 10-Digit All 2-Digit Years HS Code has Data During 5 Year History
75-89 qty_1_[Y1] 15-Digit Quantity 1, First Year in Series, where [Y1] is the 2-digit year
90-104 all_val_[Y1] 15-Digit Total Value, First Year in Series, where [Y1] is the 2-digit year
105-119 qty_1_[Y2] 15-Digit Quantity 1, Second Year in Series, where [Y1] is the 2-digit year
120-134 all_val_[Y2] 15-Digit Total Value, Second Year in Series, where [Y1] is the 2-digit year
135-149 qty_1_[Y3] 15-Digit Quantity 1, Third Year in Series, where [Y1] is the 2-digit year
150-164 all_val_[Y3] 15-Digit Total Value, Third Year in Series, where [Y1] is the 2-digit year
165-179 qty_1_[Y4] 15-Digit Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year
180-194 all_val_[Y4] 15-Digit Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
195-209 qty_1_[Y5] 15-Digit Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year
210-224 all_val_[Y5] 15-Digit Total Value, Fifth Year in Series, where [Y1] is the 2-digit year

 

FILENAME: EXP_CTY.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 119

POSITION FIELD NAME DESCRIPTION
1-4 cty_code 4-Digit Country Code
5-34 cty_name 30-Digit Country Name
35-44 years_ap 10-Digit All 2-Digit Years HS Code has Data During 5 Year History
45-59 all_val_[Y1] 15-Digit Total Value, First Year in Series, where [Y1] is the 2-digit year
60-74 all_val_[Y2] 15-Digit Total Value, Second Year in Series, where [Y1] is the 2-digit year
75-89 all_val_[Y3] 15-Digit Total Value, Third Year in Series, where [Y1] is the 2-digit year
90-104 air_val_[Y4] 15-Digit Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
105-119 all_val_[Y5] 15-Digit Total Value, Fifth Year in Series, where [Y1] is the 2-digit year

 

FILENAME: EXP_DETL.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 290

POSITION FIELD NAME DESCRIPTION
1-1 df 1-Digit Domestic or Foreign Code (domestic = 1; foreign = 2)
2-11 commodity 10-Digit Schedule B Commodity Code
12-61 comm_desc 50-Digit Schedule B Description
62-64 unit_qy1 3-Digit Unit of Quantity
65-68 cty_code 4-Digit Country Code
69-98 cty_name 30-Digit Country Name
99-100 district 2-Digit District Code
101-130 dist_desc 30-Digit District Description
131-140 years_ap 10-Digit All 2-Digit Years HS Codes has data during 5 year history
141-155 qty_1_[Y1] 15-Digit Quantity 1, First Year in Series, where [Y1] is the 2-digit year
156-170 all_val_[Y1] 15-Digit Total Value, First Year in Series, where [Y1] is the 2-digit year
171-185 qty_1_[Y2] 15-Digit Quantity 1, Second Year in Series, where [Y2] is the 2-digit year
186-200 all_val_[Y2] 15-Digit Total Value, Second Year in Series, where [Y2] is the 2-digit year
201-215 qty_1_[Y3] 15-Digit Quantity 1, Third Year in Series, where [Y3] is the 2-digit year
216-230 all_val_[Y3] 15-Digit Total Value, Third Year in Series, where [Y3] is the 2-digit year
231-245 qty_1_[Y4] 15-Digit Quantity 1, Fourth Year in Series, where [Y4] is the 2-digit year
246-260 all_val_[Y4] 15-Digit Total Value, Fourth Year in Series, where [Y4] is the 2-digit year
261-275 qty_1_[Y5] 15-Digit Quantity 1, Fifth Year in Series, where [Y5] is the 2-digit year
276-290 all_val_[Y5] 15-Digit Total Value, Fifth Year in Series, where [Y5] is the 2-digit year

 

FILENAME: EXP_DIST.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 117

POSITION FIELD NAME DESCRIPTION
1-2 district 2-Digit District Code
3-32 dist_name 30-Digit District Name
33-42 year 10-Digit All 2-Digit Years HS Code has data During 5 Year History
43-57 all_val_[Y1] 15-Digit Total Value, First Year in Series, where [Y1] is the 2-digit year
58-72 all_val_[Y2] 15-Digit Total Value, Second Year in Series, where [Y1] is the 2-digit year
73-87 all_val_[Y3] 15-Digit Total Value, Third Year in Series, where [Y1] is the 2-digit year
88-102 air_val_[Y4] 15-Digit Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
103-117 all_val_[Y5] 15-Digit Total Value, Fifth Year in Series, where [Y1] is the 2-digit year

 

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.

 


October 2014
Trade Numbers

Deficit: $43.4 Billion
Exports: $197.5 Billion
Imports: $241.0 Billion

Next release: January 7, 2015
Complete Release Schedule

Export Training Videos


Collection of videos to enhance export training.

Upcoming Training

AES Compliance Seminars

Dec 10-11, 2014
Newark, NJ

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