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

SPI DATA BANK RECORD LAYOUT

FIX FORMATTED ASCII FILE

RECORD LENGTH:   178

POSITION FIELD NAME DESCRIPTION
1-10 HS 10-digit harmonized commodity classification code (HTSUSA number).
11-14 COUNTRY 4-digit country of origin code (Schedule C).
15-16 COUNTRY SUBCODE 2-digit country subcode.
- '00' = Country of origin
- '01' = Country of shipment, country of origin unknown
- 'A ' = All Developing Beneficiary Countries; Eligible for All Articles (GSP)
- 'A*' = Certain Develping Beneficiary
Countries; Not Eligible for Specific Articles (GSP)
- 'A+' = All Least Develped Beneficiary
Countries; Eligible for All Articles (GSP)
- 'B ' = Automotive Products Trade Act (APTA)
- 'C ' = Agreement on Trade in Civil Aircraft
- 'CA' = NAFTA goods marked as Canada
- 'CL' = Products of Chile under designated
provision of the HTSUSA (New 01/2004)
- 'D ' = African Growth and Opportunity Act (New 01/2001)
- 'E ' = All articles elibible under designated provision of the HTSUSA (CBI)
- 'E*' = Articles or specific countries not eligible under the designated provision of the
HTSUSA (CBERA)
- 'IL' = Israel Free Trade Area Implementation Act
- 'J ' = Articles eligible from beneficiary countries under provision of the HTUSA (ATPA)
- 'J*' = Articles eligible from beneficiary countries under provision of the HTUSA with
execptions(ATPA)
- 'J+' = Articles elsibible from beneficiary countries under provision of the HTSUSA (ATPA)
- 'JO' = Jordon free Trade Act of 2002
- 'K ' = Agreement on Trade in Pharmaceutical Products
- 'L ' = Concessions on Intermediate Chemicals for Dyes
- 'MX' = NAFTA goods marked as Mexico
- 'N ' = Duty-free code for West Bank and Gaza Strip
- 'R ' = Caribbean Basin Trade Partnership Act (New 01/2001)
- 'SG' = Products of Singapore under designated provision of the HTSUSA (New 01/2004)
- 'W ' = Puerto Rican product under
Customs and Trade Act of 1990
- 'Z ' = Marshall Islands and the Federated States of Micronesia Compact of Free Association Act
17 PROGRAM INDICATOR 1-digit secondary special program indicator.
- 'F' = Certified hand-loomed or folklore product
- 'G' = Made to measure Hong Kong suits
- 'H' = Special regime commodity
- 'M' = Fashion Samples and Chinese Floor Coverings
- 'S' = Outward Processing Program for textiles and apparel. (eff 1/2000)
- 'V' = Set components
- 'X' = ***Discontinued 07/93
18-19 US_GOODS 2-digit Census special program indicator.
- '01' = HTSUSA 9802.00.5010 articles repaired or assembled abroad.
- '02' = HTSUSA 9802.00.8040 articles repaired or assembled abroad.
- '03' = HTSUSA 9802.00.6000 articles of metal manufactured in the .which were exported for
further processing abroad and returned to the U.S. for more processing
- '04' = HTSUSA 9802.00.8015 textile articles assembled abroad and entered under a special access program. (9802.00.8010 before January 1, 1994)
- '05' = HTSUSA 9802.00.8016 textile articles assembled abroad and entered under a special access program. (Effective January 1, 2000)
- '06' = HTUSA 9802.00.8042 Apparel articles
- '07' = HTUSA 9802.00.8044 Apparel articles
- '08' = HTUSA 9802.00.8046(CBTPA)
- '09' = HTUSA 9802.00.8048(ATPDEA)
- '10' = HTSUSA 9802.00.8055 textile or apparel goods assembled in Mexico.
- '11' = HTSUSA 9802.00.8068 articles
assembled abroad and enteredunder a Special Access Program. (9802.00.8066 before November 2002 and 9802.00.8065 before January 2002
- '12' = HTSUSA 9802.00.9000 textile and apparel goods assembled in Mexico from U.S. formed and cut fabric.
20-21 DISTRICT ENTRY 2-digit Customs district of entry.
22-23 DISTRICT UNLADING 2-digit Customs district of unlading code (Schedule D).
24-25 RATE PROVISION 2-digit rate provision code.
- '00' = Item entered into warehouse or foreign trade zone, duty not applicable
- '10','11','13','14','16','17','18' or '19' = Free Rate Provisions
- '61' = "General" rates apply
- '62' = "Column 2" rates apply
- '64' = "Special" NAFTA, Israel or ATPA trade agreement rates
- '69' = Chapter 99 rates apply - duty reported
- '70' = Various or special rates prescribed in rates of duty columns of HTSUSA chapters 01-97
- '79' = Chapter 99 rates apply - no duty reported
26-27 STAT_MO 2-digit statistical month.
28 FILLER 3-digit filler
29-40 CONSUMPTION QTY1 12-digit numeric consumption primary quantity.
41-52 CONSUMPTION QTY2 12-digit numeric consumption secondary quantity.
53-64 CONSUMPTION VALUE 12-digit numeric consumption Customs value (in dollars).
65-76 CONSUMPTION US VALUE 12-digit numeric consumption value of the merchandise portion originating in the U.S. (in dollars).
77-88 CONSUMPTION CHARGES 12-digit numeric consumption aggregate charges (in dollars).
89-100 CONSUMPTION CIF 12-digit numeric consumption cost, insurance and freight.
101-112 GENERAL QTY1 12-digit numeric general primary quantity.
113-124 GENERAL QTY2 12-digit numeric general secondary quantity.
125-136 GENERAL VALUE 12-digit numeric general Customs value (in dollars).
137-148 GENERAL US VALUE 12-digit numeric general value of the merchandise portion originating in the U.S. (in dollars).
149-160 GENERAL CHARGES 12-digit numeric general aggregate charges (in dollars).
161-172 GENERAL CIF 12-digit numeric general cost, insurance and freight.
173-176 STAT_YEAR 4-digit statistical year.

September 2014
Trade Numbers

Deficit: $43.0 Billion
Exports: $195.6 Billion
Imports: $238.6 Billion

Next release: December 5, 2014
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: January 15, 2013