Skip to Search Skip to Left Navigation U.S. Department of Transportation (US DOT) Research and Innovative Technology Administration (RITA) Bureau of Transportation Statistics (BTS)Bureau of Transportation Statistics (BTS) - Research and Innovative Technology Administration (RITA) - United States Department of Transportation (USDOT, US DOT or DOT)
  ABOUT RITA | CONTACT US | PRESS ROOM | CAREERS | SITE MAP
Bureau of Transportation Statistics
Data and Statistics
Bookstore
Programs
TransBorder Freight Data
Query Detailed Statistics
Get Fast Facts
Download Raw Data
Releases and Reports
Major Changes
FAQ
Data Fields
Codes
About BTS
Upcoming Press Releases
External Links
Intelligent Transportation Systems
National Transportation Library
Research, Development and Technology
Transportation Safety Institute
University Transportation Centers
Volpe Center
Printable Version

Table 2: U.S. Trade with Canada and Mexico with State and Commodity Detail

Excel | CSV

Field Name Data Element Description Type Width
CANPROV Canadian Province of Origin or Destination Standard Canadian province postal abbreviation Character 2
CHARGES Aggregate Charges Aggregate shipping charges on imports, in U.S. $ Numeric 11
COMMODITY Schedule B or HTSUSA code Two-digit commodity code, indicated by Schedule B for U.S. export shipments and Harmonized Tariff Schedule of the United States for U.S. import shipments Character 2
CONTCODE Container Code Distinguishes whether the merchandise is containerized "1" = containerized shipment Character 1
COUNTRY Country of Origin or Destination "2010" to denote Mexico or "1220" to denote Canada Character 4
DF Domestic/Foreign Code Distinguishes whether the Code merchandise was produced in the U.S.; "1" = domestically produced merchandise, "2" = foreign produced merchandise Character 1
DISAGMOT Disaggregated MOT Method of transportation by which the commodities are exported; "1" = air, "3" = vessel, "4" = mail, "5" = truck, "6" = rail, "7" = pipeline, "8" = other (including unknown), "9" = imports into Foreign Trade Zones Character 1
FREIGHT Freight Costs Cost of moving export goods from U.S. state to the consignee in Canada or Mexico, in U.S. $ Numeric 11
MEXSTATE Mexican State of Destination Standard Mexican state postal abbreviation Character 2
SHIPWT Shipping Weight Commodity weight in kilograms Numeric 11
STATMO Statistical Month Expressed as two digits, such as MM. Example Month 05= May Character 2
STATYR Statistical Year Expressed as four digits, such as YYYY. Example Year 2005= 2005 Character 4
TRDTYPE Direction of Trade, Export or Import Trade direction; "1" = export, "2" = import Character 1
USASTATE U.S. State of Origin or Destination U.S. state standard postal abbreviation Character 2
VALUE Value of Shipments Commodity value in U.S. $ Numeric 11