Table 3: U.S. Trade with Canada and Mexico with Port and Commodity Detail

Excel | CSV

Field Name Data Element Description Type Width
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
DEPE District and Port of Entry Four-digit classification of U.S. Customs districts and ports of entry. 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
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
VALUE Value of Shipments Commodity value in U.S. $ Numeric 11