U.S. flag

An official website of the United States government

census.gov Notification
Due to the lapse of federal funding, portions of this website are not being updated. Any inquiries submitted via www.census.gov will not be answered until appropriations are enacted.

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?