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" = vessel, "3" = air, "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