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 Exports NAICS4 Database Record Layout

FIX FORMATTED ASCII FILE RECORD LENGTH: 226

EXPORTS - NAICS 4-Digit by Country by State

FILENAME: STNAICS<YY><MM>.TXT

POSITION FIELD NAME DESCRIPTION
1-4 NAICS 4-digit NAICS Code
5-8 cty_code 4-digit Country Code
9-10 state 2-digit State of Origin, using US Postal Service State Abbreviations. "XX" = Unidentified
11-14 year 4-digit Statistical Year
15-16 month 2-digit Statistical Month
17-31 value_mo 15-digit Total Value
32-46 air_val_mo 15-digit Air Value
47-61 air_swt_mo 15-digit Air Shipping Weight
62-76 ves_val_mo 15-digit Vessel Value
77-91 ves_swt_mo 15-digit Vessel Shipping Weight
92-106 cnt_val_mo 15-digit Containerized Vessel Value
107-121 cnt_swt_mo 15-digit Containerized Vessel Shipping Weight
122-136 value_yr 15-digit Year-to-Date Total Value
137-151 air_val_yr 15-digit Year-to-Date Air Value
152-166 air_swt_yr 15-digit Year-to-Date Air Shipping Weight
167-181 ves_val_yr 15-digit Year-to-Date Vessel Value
182-196 ves_swt_yr 15-digit Year-to-Date Vessel Shipping Weight
197-211 cnt_val_yr 15-digit Year-to-Date Containerized Vessel Value
212-226 cnt_swt_yr 15-digit Year-to-Date Containerized Vessel Shipping Weight

August 2014
Trade Numbers

Deficit: $40.1 Billion
Exports: $198.5 Billion
Imports: $238.6 Billion

Next release: November 4, 2014
Complete Release Schedule

Export Training Videos


Collection of videos to enhance export training.

Upcoming Training

AES Compliance Seminars

Oct 22-23, 2014
New Orleans, LA

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