U.S. Exports History Files - Layouts

• concord.txt
• country.txt
• district.txt
• enduse.txt
• exp_comm.txt
• exp_cty.txt
• exp_detl.txt
• exp_dist.txt
• hitech.txt
• hsdesc.txt
• naics.txt
• sitc.txt

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.