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

State HS6 Database - Exports Record Layout

FIX FORMATTED ASCII FILE RECORD LENGTH: 228

EXPORTS HS 6-Digit by Country by State

FILENAME: STHS6<YY><MM>.TXT

POSITION FIELD NAME DESCRIPTION
1-6 commodity 6-digit Harmonized Schedule (HS) Code
7-10 cty_code 4-digit Country Code
11-12 state 2-digit State of Origin, using US Postal Service State Abbreviations. "XX" = Unidentified
13-16 year 4-digit Statistical Year
17-18 month 2-digit Statistical Month
19-33 value_mo 15-digit Total Value
34-48 air_val_mo 15-digit Air Value
49-63 air_swt_mo 15-digit Air Shipping Weight
64-78 ves_val_mo 15-digit Vessel Value
79-93 ves_swt_mo 15-digit Vessel Shipping Weight
94-108 cnt_val_mo 15-digit Containerized Vessel Value
109-123 cnt_swt_mo 15-digit Containerized Vessel Shipping Weight
124-138 value_yr 15-digit Year to Date Total Value
139-153 air_val_yr 15-digit Year to Date Air Value
154-168 air_swt_yr 15-digit Year to Date Air Shipping Weight
169-183 ves_val_yr 15-digit Year to Date Vessel Value
184-198 ves_swt_yr 15-digit Year to Date Vessel Shipping Weight
199-213 cnt_val_yr 15-digit Year to Date Containerized Vessel Value
214-228 cnt_swt_yr 15-digit Year to Date Containerized Vessel Shipping Weight

June 2014
Trade Numbers

Deficit: $41.5 Billion
Exports: $195.9 Billion
Imports: $237.4 Billion

Next release: September 4, 2014
Complete Release Schedule

Export Training Videos


Collection of videos to enhance export training.

Upcoming Training

AES Compliance Seminars

Sep 9-10, 2014
Dallas, TX

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: July 12, 2011