U.S. flag

An official website of the United States government


end of header

U.S. Imports 5 Year History Files - Layouts

FILENAME: CONCORD.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 235

POSITION FIELD NAME DESCRIPTION
1-10 commodity 10-Digit Harmonized Tariff Schedule (HTS) Code
11-160 descriptn 150-Digit HTS Description
161-210 abbreviatn 50-Digit HTS 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 HS 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: 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: IMP_COMM.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 373

POSITION FIELD NAME DESCRIPTION
1-10 commodity 10-Digit Harmonized Tariff Schedule (HTS) Code
11-60 comm_desc 50-Digit HTS Description
61-63 unit_qy1 3-Digit Unit of Quantity 1
64-73 years_ap 10-Digit All 2-Digit Years HS Code Has Data During 5 Year History
74-88 con_qy1_[Y1] 15-Digit Imports for Consumption, Quantity 1, First Year in Series, where [Y1] is the 2-digit year
89-103 con_val_[Y1] 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year
104-118 gen_qy1_[Y1] 15-Digit General Imports, Quantity 1, First Year in Series, where [Y1] is the 2-digit year
119-133 gen_val_[Y1] 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year
134-148 con_qy1_[Y2] 15-Digit Imports for Consumption, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year
149-163 con_val_[Y2] 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year
164-178 gen_qy1_[Y2] 15-Digit General Imports, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year
179-193 gen_val_[Y2] 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year
194-208 con_qy1_[Y3] 15-Digit Imports for Consumption, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year
209-223 con_val_[Y3] 15-Digit Imports for Consumption, Total Value, Third Year in Series, where [Y1] is the 2-digit year
224-238 gen_qy1_[Y3] 15-Digit General Imports, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year
239-253 gen_val_[Y3] 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year
254-268 con_qy1_[Y4] 15-Digit Imports for Consumption, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year
269-283 con_val_[Y4] 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
284-298 gen_qy1_[Y4] 15-Digit General Imports, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year
299-313 gen_val_[Y4] 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
314-328 con_qy1_[05] 15-Digit Imports for Consumption, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year
329-343 con_val_[05] 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year
344-358 gen_qy1_[05] 15-Digit General Imports, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year
359-373 gen_val_[05] 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year

FILENAME: IMP_CTY.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 194

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 con_val_[Y1] 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year
60-74 gen_val_[Y1] 15-Digit General Imports, Total Value, First Year in Series, where [Y1] is the 2-digit year
75-89 con_val_[Y2] 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year
90-104 gen_val_[Y2] 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year
105-119 con_val_[Y3] 15-Digit Imports for Consumption, Total Value, ThirdYear in Series, where [Y1] is the 2-digit year
120-134 gen_val_[Y3] 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year
135-149 con_val_[Y4] 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
150-164 gen_val_[Y4] 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
165-179 con_val_[Y5] 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year
180-194 gen_val_[Y5] 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year

FILENAMES: IMP_DE.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 192

POSITION FIELD NAME DESCRIPTION
1-2 cty_code 4-Digit Country Code
3-32 cty_name 30-Digit Country Name
33-42 years_ap 10-Digit All 2-Digit Years HS Code has Data During 5 Year History
43-57 con_val_[Y1] 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year
58-72 gen_val_[Y1] 15-Digit General Imports, Total Value, First Year in Series, where [Y1] is the 2-digit year
73-87 con_val_[Y2] 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year
88-102 gen_val_[Y2] 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year
103-117 con_val_[Y3] 15-Digit Imports for Consumption, Total Value, ThirdYear in Series, where [Y1] is the 2-digit year
118-132 gen_val_[Y3] 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year
133-147 con_val_[Y4] 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
148-162 gen_val_[Y4] 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
163-177 con_val_[Y5] 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year
178-192 gen_val_[Y5] 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year

FILENAME: IMP_DETL.TXT

FIX FORMATTED ASCII FILE RECORD LENGTH: 441

POSITION FIELD NAME DESCRIPTION
1-10 commodity 10-Digit Harmonized Tariff Schedule (HTS) Code
11-60 abbreviatn 50-Digit HTS Description
61-63 unit_qy1 3-Digit Unit of Quantity 1
64-67 cty_code 4-Digit Country Code
68-97 cty_name 30-Digit Country Name
98-99

cty_subco

2-Digit Country Subcode
100-101 dist_entry 2-Digit District of Entry Code
102-131 dist_name 30-Digit District Name
132-141 years_ap 10-Digit All 2-Digit Years HS Code Has Data During 5 Year History
142-156 con_qy1_[Y1] 15-Digit Imports for Consumption, Quantity 1, First Year in Series, where [Y1] is the 2-digit year
157-171 con_val_[Y1] 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year
172-186 gen_qy1_[Y1] 15-Digit General Imports, Quantity 1, First Year in Series, where [Y1] is the 2-digit year
187-201 gen_val_[Y1] 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year
202-216 con_qy1_[Y2] 15-Digit Imports for Consumption, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year
217-231 con_val_[Y2] 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year
232-246 gen_qy1_[Y2] 15-Digit General Imports, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year
247-261 gen_val_[Y2] 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year
262-276 con_qy1_[Y3] 15-Digit Imports for Consumption, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year
277-291 con_val_[Y3] 15-Digit Imports for Consumption, Total Value, Third Year in Series, where [Y1] is the 2-digit year
292-306 gen_qy1_[Y3] 15-Digit General Imports, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year
307-321 gen_val_[Y3] 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year
322-336 con_qy1_[Y4] 15-Digit Imports for Consumption, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year
337-351 con_val_[Y4] 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
352-366 gen_qy1_[Y4] 15-Digit General Imports, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year
367-381 gen_val_[Y4] 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year
382-396 con_qy1_[Y5] 15-Digit Imports for Consumption, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year
397-411 con_val_[Y5] 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year
412-426 gen_qy1_[Y5] 15-Digit General Imports, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year
427-441 gen_val_[Y5] 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year

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?