U.S. flag

An official website of the United States government

end of header

U.S. Exports 5 Year 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.

X
  Is this page helpful?
Thumbs Up Image Yes    Thumbs Down Image No
X
No, thanks
255 characters remaining
X
Thank you for your feedback.
Comments or suggestions?