CATALOGS FTD - Reference - Codes
Skip Main Navigation Skip To Navigation Content

Foreign Trade

Skip top of page navigation
You are here: Census.govBusiness & IndustryForeign Trade › U.S. International Trade Data

U.S. Imports 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.

 


October 2014
Trade Numbers

Deficit: $43.4 Billion
Exports: $197.5 Billion
Imports: $241.0 Billion

Next release: January 7, 2015
Complete Release Schedule

Export Training Videos


Collection of videos to enhance export training.

Upcoming Training

AES Compliance Seminars

Dec 10-11, 2014
Newark, NJ

Contact Us

Contact the Foreign Trade Data Dissemination staff: Email us! or use our feedback form!

Call us: (301)763-2311 or 1-800-549-0595 option 4

[PDF] or PDF denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Reader® Off Site available free from Adobe. [Excel] or the letters [xls] indicate a document is in the Microsoft® Excel® Spreadsheet Format (XLS). To view the file, you will need the Microsoft® Excel® Viewer Off Site available for free from Microsoft®. [MSWord] or the letters [doc] indicate a document is in the Microsoft® Word Format (DOC). To view the file, you will need the Microsoft® Word Viewer Off Site available for free from Microsoft®. This symbol Off Site indicates a link to a non-government web site. Our linking to these sites does not constitute an endorsement of any products, services or the information found on them. Once you link to another site you are subject to the policies of the new site.
Source: U.S. Census Bureau | Foreign Trade | ftdwebmaster@census.gov |  Last Revised: October 31, 2011