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.) |
