U.S. Exports Merchandise Trade 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: 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.