Foreign Trade - Raw Data

Well this is it. Pretty impressive numbers and letters.

YEAR	MO	E	TSUSA	COUN	DI	KILOS	DOLLARS	R
-------	-----	-	-------	--------	----	------	------------	-
1996	01	E	0305632000	4759	10	3500	17750	0
1996	01	E	0305634000	5490	10	6041	31027	0
1996	01	E	0305634000	5800	10	1700	9873	0
1996	01	E	0305636000	3570	27	30823	66605	0
1996	01	E	0305636000	3570	10	16267	26027	0
1996	01	E	1604161000	4759	10	500	3350	0
1996	01	E	1604161000	5650	10	1867	2400	0
1996	01	E	1604161000	5800	53	1086	1856	0

The following data is the same, as above, but output as a comma delimited file.

        1996,01,E,"0305632000",4759,"10",3500,17750,0
        1996,01,E,"0305634000",5490,"10",6041,31027,0
        1996,01,E,"0305634000",5800,"10",1700,9873,0
        1996,01,E,"0305636000",3570,"27",30823,66605,0
        1996,01,E,"0305636000",3570,"10",16267,26027,0
        1996,01,E,"1604161000",4759,"10",500,3350,0
        1996,01,E,"1604161000",5650,"10",1867,2400,0
        1996,01,E,"1604161000",5800,"53",1086,1856,0

Next question, what does it all mean?

Field	Definition
YEAR	Four character year
MO	Two character month
E	Indicates if the product is (E)dible or (N)on-edible
TSUSA	Ten character commodity code
COUN	Four character country code
DI	Two character U.S. Customs district code
KILOS	Thats right kilos, we don't do pounds.
DOLLARS	See the note below
R	Indicates the type of trade:0 = imports, 1 = exports, 2 = re-exports

Exactly what are the dollars?

For exports and re-exports it is the f.a.s. (free alongside ship) value defined as the value at the port of export, based on the transaction price including inland freight, insurance and other charges incurred in placing the merchandise alongside the carrier. It excludes the cost of loading the merchandise, freight, insurance, and other charges or transportation costs beyond the port of exportation.

For Imports it is the Customs value. This is generally defined as the price actually paid or payable for merchandise when sold for exportation to the United States, excluding U.S. import duties, freight, insurance and other charges incurred in bringing the merchandise to the United States. (This value approximates f.a.s. value.)