Foreign Trade
You are here: Census.gov › Business & Industry ›Foreign 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 |
July 2012
Trade Numbers
Deficit: $42.0 Billion
Exports: $183.3 Billion
Imports: $225.3 Billion
Next release: October 11, 2012
Complete Release Schedule
Export Training Videos
A collection of videos to enhance export trainingUpcoming Seminars and Workshops
October 3, 2012
The Fundamentals of Exporting Webinar Series
The Fundamentals of Exporting Webinar Series
October 16, 2012
Go Global
Chicago, IL
Go Global
Chicago, IL
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 
denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Reader® 
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 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 available for free from Microsoft®.
This symbol 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.
denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Reader® 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 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 available for free from Microsoft®.
This symbol 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.
Facebook
Twitter
Flickr
YouTube