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/Port Database - Record Layout

FIX FORMATTED ASCII FILE RECORD LENGTH: 99

Filename: STPORT[MM]Q[Q].TXT


POSITION FIELD NAME DESCRIPTION
1-2 state 2-digit State of Origin
3 filler 1-digit filler
4-5 district 2-digit Customs District of Exportation (Schedule D):
6-7 port 2-digit Customs Port of Exportation (Schedule D).
8-11 country 4-digit Country of Destination code (Schedule C).
12 time_period 1-digit time period
- '1' = January, February or March
- '2' = April, May or June
- '3' = July, August or September
- '4' = October, November or December.
13-23 value 12-digit Total Value
24-35 air_val 12-digit Air Value.
36-47 air_swt 12-digit Air Shipping Weight
48-59 ves_val 12-digit Vessel Value
60-71 cnt_val 12-digit Containerized Vessel Value
72-83 ves_swt 12-digit Vessel Shippiing Weight
84-95 cnt_swt 12-digit Containerized Vessel Shipping Weight
96-99 stat_year 4-digit Statistical Year

July 2014
Trade Numbers

Deficit: $40.5 Billion
Exports: $198.0 Billion
Imports: $238.6 Billion

Next release: October 3, 2014
Complete Release Schedule

Export Training Videos


Collection of videos to enhance export training.

Upcoming Training

AES Compliance Seminars

Oct 1-2, 2014
Cleveland, OH

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