Goal
Argentinian export customs declarations downloaded from Sicex 2.5 and COMTRADE data for years 2013 - 2017 have shown considerable differences and no clear pattern, and so did not pass preprocessing QA.
As a first step, the CD data has been redownloaded from Sicex 2.5 in October 2018. The COMTRADE data download has been automated and is obtained in real time using the comtradr R package. Both datasets did not change, and comparisons with both COMTRADE and COMEX were far off.
Below we are testing a number of hypotheses to understand the issue(s) in the Argentinian customs declarations, and help us decide how to move forward.
COMTRADE
COMTRADE Argentina Exports 2013 - 2017 (tonnes)
| beef |
269895 |
274397 |
263075 |
277750 |
348810 |
| chicken |
367782 |
312989 |
215743 |
185904 |
206835 |
| corn |
20200820 |
16028558 |
17543941 |
24632459 |
23811510 |
| cocoa |
663 |
490 |
435 |
400 |
333 |
| coffee |
267 |
241 |
250 |
333 |
332 |
| cotton |
83896 |
142620 |
161099 |
150979 |
65706 |
| pork |
3497 |
4425 |
4050 |
5189 |
7729 |
| leather |
112433 |
108293 |
95053 |
94739 |
113793 |
| timber |
55 |
0 |
4 |
0 |
0 |
| palmoil |
1 |
0 |
0 |
0 |
0 |
| palmkernel |
0 |
0 |
0 |
0 |
0 |
| cpo |
1 |
0 |
0 |
0 |
0 |
| woodpulp |
196532 |
184877 |
167811 |
174796 |
214312 |
| shrimps |
91289 |
107480 |
120790 |
159889 |
183280 |
| soy |
34121374 |
36205610 |
43911140 |
43796286 |
40636046 |
| sugarcane |
281996 |
95664 |
202988 |
585052 |
306173 |
COMEX
COMEX Argentina Exports 2013 - 2017 (tonnes)
| beef |
269895 |
274397 |
263068 |
277922 |
350051 |
| chicken |
367782 |
312964 |
215770 |
186079 |
207354 |
| corn |
20200820 |
16027986 |
17544170 |
24636052 |
23820875 |
| cocoa |
663 |
471 |
435 |
400 |
333 |
| coffee |
267 |
241 |
250 |
333 |
332 |
| cotton |
83896 |
142620 |
161100 |
150412 |
67241 |
| pork |
3497 |
4425 |
4050 |
5189 |
7745 |
| leather |
112433 |
108293 |
95118 |
94762 |
113891 |
| timber |
55 |
0 |
4 |
0 |
0 |
| palmoil |
0 |
0 |
0 |
0 |
0 |
| palmkernel |
0 |
0 |
0 |
0 |
0 |
| cpo |
0 |
0 |
0 |
0 |
0 |
| woodpulp |
196532 |
184877 |
167811 |
174796 |
215316 |
| shrimps |
91289 |
107480 |
120906 |
159877 |
183231 |
| soy |
34121374 |
36205690 |
43910540 |
43801639 |
40636965 |
| sugarcane |
281996 |
95664 |
203162 |
585737 |
307222 |
SICEX 2.5
Cantidad.Estadistica
Sicex 2.5 Argentina Exports 2013 - 2017: Cantidad.Estadistica (tonnes)
| beef |
0 |
0 |
0 |
0 |
0 |
| chicken |
0 |
0 |
0 |
0 |
0 |
| corn |
22341901 |
17767047 |
19053434 |
28885547 |
21408765 |
| cocoa |
0 |
0 |
0 |
0 |
0 |
| coffee |
0 |
0 |
0 |
0 |
0 |
| cotton |
93659 |
161223 |
190306 |
205352 |
69637 |
| pork |
0 |
0 |
0 |
0 |
0 |
| leather |
0 |
0 |
0 |
0 |
0 |
| timber |
0 |
0 |
0 |
0 |
0 |
| palmoil |
0 |
0 |
0 |
0 |
0 |
| palmkernel |
0 |
0 |
0 |
0 |
0 |
| cpo |
0 |
0 |
0 |
0 |
0 |
| woodpulp |
179420 |
174030 |
170455 |
193808 |
199103 |
| shrimps |
94279 |
99375 |
129955 |
332846 |
191922 |
| soy |
37561780 |
40952213 |
48827541 |
49044646 |
37266372 |
| sugarcane |
0 |
0 |
0 |
0 |
0 |
Sicex 2.5 Argentina Exports 2013 - 2017: Cantidad.Estadistica / COMEX Argentina Exports 2013 - 2017
| beef |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| chicken |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| corn |
1.106 |
1.109 |
1.086 |
1.172 |
0.899 |
| cocoa |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| coffee |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| cotton |
1.116 |
1.130 |
1.181 |
1.365 |
1.036 |
| pork |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| leather |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| timber |
0.000 |
NaN |
0.000 |
NaN |
NaN |
| palmoil |
0.000 |
NaN |
NaN |
NaN |
NaN |
| palmkernel |
NaN |
NaN |
NaN |
NaN |
0.000 |
| cpo |
0.000 |
NaN |
NaN |
NaN |
NaN |
| woodpulp |
0.913 |
0.941 |
1.016 |
1.109 |
0.925 |
| shrimps |
1.033 |
0.925 |
1.075 |
2.082 |
1.047 |
| soy |
1.101 |
1.131 |
1.112 |
1.120 |
0.917 |
| sugarcane |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
Total.Quantity.1
Sicex 2.5 Argentina Exports 2013 - 2017: TOTAL.Quantity.1 (tonnes)
| beef |
0 |
0 |
0 |
0 |
0 |
| chicken |
0 |
0 |
0 |
0 |
0 |
| corn |
90496 |
48232 |
28536 |
38125 |
29311 |
| cocoa |
0 |
0 |
0 |
0 |
0 |
| coffee |
0 |
0 |
0 |
0 |
0 |
| cotton |
3963 |
2221 |
3031 |
2224 |
1044 |
| pork |
0 |
0 |
0 |
0 |
0 |
| leather |
0 |
0 |
0 |
0 |
0 |
| timber |
0 |
0 |
0 |
0 |
0 |
| palmoil |
0 |
0 |
0 |
0 |
0 |
| palmkernel |
0 |
0 |
0 |
0 |
0 |
| cpo |
0 |
0 |
0 |
0 |
0 |
| woodpulp |
0 |
0 |
1 |
0 |
0 |
| shrimps |
49772 |
48973 |
75087 |
174434 |
60963 |
| soy |
15991 |
19979 |
20289 |
22431 |
10610 |
| sugarcane |
0 |
0 |
0 |
0 |
0 |
Sicex 2.5 Argentina Exports 2013 - 2017: TOTAL.Quantity.1 / COMEX Argentina Exports 2013 - 2017
| beef |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| chicken |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| corn |
0.004 |
0.003 |
0.002 |
0.002 |
0.001 |
| cocoa |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| coffee |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| cotton |
0.047 |
0.016 |
0.019 |
0.015 |
0.016 |
| pork |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| leather |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| timber |
0.000 |
NaN |
0.000 |
NaN |
NaN |
| palmoil |
0.000 |
NaN |
NaN |
NaN |
NaN |
| palmkernel |
NaN |
NaN |
NaN |
NaN |
0.000 |
| cpo |
0.000 |
NaN |
NaN |
NaN |
NaN |
| woodpulp |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| shrimps |
0.545 |
0.456 |
0.621 |
1.091 |
0.333 |
| soy |
0.000 |
0.001 |
0.000 |
0.001 |
0.000 |
| sugarcane |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
Tests for various hypotheses
We notice that sometimes, where we see several records with the same shipment ID (‘Import.Declaration.Number’), the value in ‘Cantidad.Estadistica’ is the same for each record with the specific ID. We also notice that the value in ‘Cantidad.Estadistica’ seems to be the sum of all values in ‘Total.Quantity.1’, for the records with the same shipment ID. We define a test that will be used below:
For a given shipment ID, do the values in ‘Total.Quantity.1’ sum to the value in ‘Cantidad.Estadistica’? If yes, we can use the sum of all values in ‘Total.Quantity.1’ for these shipment IDs, or the sum of ‘Cantidad.Estadistica’, for one record per shipment ID for which the test holds.
Number of IDs for which CE = sum(TQ1) DOES NOT hold, vs. number of IDs in files Sicex 2.5 Argentina Exports 2013 - 2017
| beef |
NA |
NA |
NA |
NA |
NA |
| chicken |
NA |
NA |
NA |
NA |
NA |
| corn |
7225 / 8441 |
5832 / 6682 |
7503 / 8141 |
7379 / 7934 |
5043 / 5573 |
| cocoa |
NA |
NA |
NA |
NA |
NA |
| coffee |
NA |
NA |
NA |
NA |
NA |
| cotton |
573 / 737 |
1384 / 1480 |
1008 / 1112 |
1232 / 1318 |
476 / 522 |
| pork |
NA |
NA |
NA |
NA |
NA |
| leather |
NA |
NA |
NA |
NA |
NA |
| timber |
NA |
NA |
NA |
NA |
NA |
| palmoil |
NA |
NA |
NA |
NA |
NA |
| palmkernel |
NA |
NA |
NA |
NA |
NA |
| cpo |
NA |
NA |
NA |
NA |
NA |
| woodpulp |
1683 / 1683 |
2257 / 2257 |
2067 / 2067 |
1942 / 1942 |
1566 / 1566 |
| shrimps |
1617 / 2540 |
1689 / 2600 |
2082 / 3418 |
2839 / 5185 |
3809 / 5097 |
| soy |
6514 / 6794 |
7053 / 7283 |
8270 / 8534 |
8493 / 8761 |
5865 / 6062 |
| sugarcane |
NA |
NA |
NA |
NA |
NA |
Hypothesis 1: Duplicate lines
Hypothesis 2: Incorrect units (FOB/kg)
First, let’s look at the weights of records with a unique import declaration number.
Sicex 2.5 Argentina Exports 2013 - 2017: Cantidad.Estadistica (tonnes) for unique shipment IDs
| beef |
0 |
0 |
0 |
0 |
0 |
| chicken |
0 |
0 |
0 |
0 |
0 |
| corn |
12408267 |
10617450 |
13388642 |
18805853 |
17259800 |
| cocoa |
0 |
0 |
0 |
0 |
0 |
| coffee |
0 |
0 |
0 |
0 |
0 |
| cotton |
56212 |
109210 |
135423 |
123193 |
52545 |
| pork |
0 |
0 |
0 |
0 |
0 |
| leather |
0 |
0 |
0 |
0 |
0 |
| timber |
0 |
0 |
0 |
0 |
0 |
| palmoil |
0 |
0 |
0 |
0 |
0 |
| palmkernel |
0 |
0 |
0 |
0 |
0 |
| cpo |
0 |
0 |
0 |
0 |
0 |
| woodpulp |
179312 |
173232 |
168870 |
191259 |
198668 |
| shrimps |
58567 |
59596 |
87545 |
148606 |
136848 |
| soy |
24284837 |
28234303 |
37677021 |
38091148 |
32954267 |
| sugarcane |
0 |
0 |
0 |
0 |
0 |
Sicex 2.5 Argentina Exports 2013 - 2017: Cantidad.Estadistica for unique shipment IDs / COMEX Argentina Exports 2013 - 2017
| beef |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| chicken |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| corn |
0.614 |
0.662 |
0.763 |
0.763 |
0.725 |
| cocoa |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| coffee |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| cotton |
0.670 |
0.766 |
0.841 |
0.819 |
0.781 |
| pork |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| leather |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| timber |
0.000 |
NaN |
0.000 |
NaN |
NaN |
| palmoil |
0.000 |
NaN |
NaN |
NaN |
NaN |
| palmkernel |
NaN |
NaN |
NaN |
NaN |
0.000 |
| cpo |
0.000 |
NaN |
NaN |
NaN |
NaN |
| woodpulp |
0.912 |
0.937 |
1.006 |
1.094 |
0.923 |
| shrimps |
0.642 |
0.554 |
0.724 |
0.930 |
0.747 |
| soy |
0.712 |
0.780 |
0.858 |
0.870 |
0.811 |
| sugarcane |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
Let’s add records for shipment IDs which pass the Cantidad.Estadistica = sum(TOTAL.Quantity.1) test.
Sicex 2.5 Argentina Exports 2013 - 2017: Cantidad.Estadistica (tonnes) for unique shipment IDs and IDs with CE = sum(TQ1)
| beef |
0 |
0 |
0 |
0 |
0 |
| chicken |
0 |
0 |
0 |
0 |
0 |
| corn |
9891497 |
7139801 |
5659514 |
10064024 |
4142315 |
| cocoa |
0 |
0 |
0 |
0 |
0 |
| coffee |
0 |
0 |
0 |
0 |
0 |
| cotton |
36370 |
51400 |
54101 |
81108 |
16536 |
| pork |
0 |
0 |
0 |
0 |
0 |
| leather |
0 |
0 |
0 |
0 |
0 |
| timber |
0 |
0 |
0 |
0 |
0 |
| palmoil |
0 |
0 |
0 |
0 |
0 |
| palmkernel |
0 |
0 |
0 |
0 |
0 |
| cpo |
0 |
0 |
0 |
0 |
0 |
| woodpulp |
108 |
798 |
1585 |
2549 |
435 |
| shrimps |
30608 |
34881 |
37846 |
170858 |
49809 |
| soy |
13276160 |
12716093 |
11150344 |
10952415 |
4310800 |
| sugarcane |
0 |
0 |
0 |
0 |
0 |
Sicex 2.5 Argentina Exports 2013 - 2017: Cantidad.Estadistica for unique shipment IDs and IDs with CE = sum(TQ1) / COMEX Argentina Exports 2013 - 2017
| beef |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| chicken |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| corn |
0.490 |
0.445 |
0.323 |
0.409 |
0.174 |
| cocoa |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| coffee |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| cotton |
0.434 |
0.360 |
0.336 |
0.539 |
0.246 |
| pork |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| leather |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| timber |
0.000 |
NaN |
0.000 |
NaN |
NaN |
| palmoil |
0.000 |
NaN |
NaN |
NaN |
NaN |
| palmkernel |
NaN |
NaN |
NaN |
NaN |
0.000 |
| cpo |
0.000 |
NaN |
NaN |
NaN |
NaN |
| woodpulp |
0.001 |
0.004 |
0.009 |
0.015 |
0.002 |
| shrimps |
0.335 |
0.325 |
0.313 |
1.069 |
0.272 |
| soy |
0.389 |
0.351 |
0.254 |
0.250 |
0.106 |
| sugarcane |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
Take a look at records for which CE != sum(TQ1), and which don’t have a unique shipment ID. Check records for duplicates, and unusual FOB/kg ratios.
Sicex 2.5 Argentina Exports 2013: CE != sum(TQ1) and shipment ID not unique, with FOB/kg
| 1 |
08019EC01001016F |
30613 |
SHRIMP AND SHRIMP OTHER PRAWNS. FROZEN. |
L1= 10/19 PZA/KG 6 CAJAS X 2 KGN |
107688.00 |
KILOGRAMOS |
1152.00 |
KILOGRAMOS |
16323.84 |
0.1516 |
| 2 |
08019EC01001016F |
30613 |
SHRIMP AND SHRIMP OTHER PRAWNS. FROZEN. |
L2= 20/29 PZA/KG 6 CAJAS X 2 KGN |
107688.00 |
KILOGRAMOS |
28080.00 |
KILOGRAMOS |
338083.19 |
3.1395 |
| 3 |
08019EC01001016F |
30613 |
SHRIMP AND SHRIMP OTHER PRAWNS. FROZEN. |
L3= 30/39 PZA/KG 6 CAJAS X 2 KGN |
107688.00 |
KILOGRAMOS |
35376.00 |
KILOGRAMOS |
378523.19 |
3.5150 |
| 4 |
08019EC01001016F |
30613 |
SHRIMP AND SHRIMP OTHER PRAWNS. FROZEN. |
L4= 40/59 PZA/KG 6 CAJAS X 2 KGN |
107688.00 |
KILOGRAMOS |
38796.00 |
KILOGRAMOS |
335973.38 |
3.1199 |
| 5 |
08019EC01001016F |
30613 |
SHRIMP AND SHRIMP OTHER PRAWNS. FROZEN. |
L5= 60/70 GR/PZA 6 CAJAS X 2 KGN |
107688.00 |
KILOGRAMOS |
4284.00 |
KILOGRAMOS |
33715.08 |
0.3131 |
| 6 |
10008EC01006069J |
120100 |
BEANS (BEANS BEANS BEANS) SOY (SOY) OR NOT BROKEN. |
NA |
263050.00 |
KILOGRAMOS |
0.00 |
TONELADA |
94961.05 |
0.3610 |
| 7 |
12001EC01097344K |
470321 |
WOOD PULP QCA SEMI-BLEACHED OR BLEACHED D D CONIFERS. THE SODA (SODA) OR SULPHATE. EXCEPT DISSOLVING GRADES |
NA |
242305.00 |
KILOGRAMOS |
0.00 |
TONELADA |
153802.17 |
0.6347 |
| 8 |
12001EC01097984U |
470321 |
WOOD PULP QCA SEMI-BLEACHED OR BLEACHED D D CONIFERS. THE SODA (SODA) OR SULPHATE. EXCEPT DISSOLVING GRADES |
NA |
234745.00 |
KILOGRAMOS |
0.00 |
TONELADA |
150286.02 |
0.6402 |
| 11 |
12001EC01118240W |
470321 |
WOOD PULP QCA SEMI-BLEACHED OR BLEACHED D D CONIFERS. THE SODA (SODA) OR SULPHATE. EXCEPT DISSOLVING GRADES |
NA |
234690.00 |
KILOGRAMOS |
0.00 |
TONELADA |
158682.16 |
0.6761 |
| 12 |
12001EC01118343D |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
49700.00 |
KILOGRAMOS |
0.00 |
TONELADA |
66290.04 |
1.3338 |
| 15 |
12001EC01121974H |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
21940.00 |
KILOGRAMOS |
0.00 |
TONELADA |
29384.02 |
1.3393 |
| 16 |
12001EC01122195D |
100590 |
THE CORN OTHER |
NA |
52000.00 |
KILOGRAMOS |
0.00 |
TONELADA |
45080.36 |
0.8669 |
| 19 |
12001EC01122438D |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
174100.00 |
KILOGRAMOS |
0.00 |
TONELADA |
199586.50 |
1.1464 |
| 22 |
12001EC01122567G |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
89040.00 |
KILOGRAMOS |
0.00 |
TONELADA |
127593.43 |
1.4330 |
| 23 |
12001EC01122724B |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
94030.00 |
KILOGRAMOS |
0.00 |
TONELADA |
127488.69 |
1.3558 |
| 24 |
12001EC01122730V |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
140340.00 |
KILOGRAMOS |
0.00 |
TONELADA |
190277.19 |
1.3558 |
| 25 |
12001EC01123121Z |
100510 |
MAIZE SEED. |
000098 000080 |
19768.95 |
KILOGRAMOS |
985.00 |
UNIDADES |
45241.05 |
2.2885 |
| 28 |
12001EC01123294E |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
73120.00 |
KILOGRAMOS |
0.00 |
TONELADA |
92277.44 |
1.2620 |
| 31 |
12001EC01123690E |
520299 |
THE COTTON WASTE OTHER |
NA |
46380.00 |
KILOGRAMOS |
46.38 |
TONELADA |
39877.25 |
0.8598 |
| 32 |
12001EC01123887M |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
50.45 |
KILOGRAMOS |
0.00 |
TONELADA |
75632.17 |
1499.1510 |
| 33 |
12001EC01123891H |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
100.01 |
KILOGRAMOS |
0.00 |
TONELADA |
142213.12 |
1421.9890 |
| 34 |
12001EC01123916F |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
24120.00 |
KILOGRAMOS |
0.00 |
TONELADA |
30841.52 |
1.2787 |
| 35 |
12001EC01123917G |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
67820.00 |
KILOGRAMOS |
0.00 |
TONELADA |
75483.66 |
1.1130 |
| 36 |
12001EC01123949L |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
46040.00 |
KILOGRAMOS |
0.00 |
TONELADA |
62422.42 |
1.3558 |
| 37 |
12001EC01124067D |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
65590.00 |
KILOGRAMOS |
0.00 |
TONELADA |
65069.88 |
0.9921 |
Sicex 2.5 Argentina Exports 2014: CE != sum(TQ1) and shipment ID not unique, with FOB/kg
| 5 |
14001EC01012288G |
110812 |
CORNSTARCH. |
NA |
17500.0 |
KILOGRAMOS |
17.50 |
TONELADA |
7490.00 |
0.4280 |
| 6 |
14001EC01012292B |
110812 |
CORNSTARCH. |
NA |
17500.0 |
KILOGRAMOS |
17.50 |
TONELADA |
7490.00 |
0.4280 |
| 7 |
14001EC01012310P |
110812 |
CORNSTARCH. |
NA |
52500.0 |
KILOGRAMOS |
52.50 |
TONELADA |
22470.00 |
0.4280 |
| 8 |
14001EC01012313S |
110812 |
CORNSTARCH. |
NA |
140000.0 |
KILOGRAMOS |
5600.00 |
UNIDADES |
55300.00 |
0.3950 |
| 9 |
14001EC01012757H |
520299 |
THE COTTON WASTE OTHER |
NA |
20850.0 |
KILOGRAMOS |
20.85 |
TONELADA |
16992.75 |
0.8150 |
| 10 |
14001EC01012801U |
150790 |
THE SOYBEAN OIL OTHER AND ITS FRACTIONS. WHETHER OR NOT REFINED BUT NOT CHEMICALLY MODIFIED. |
CAJA 12 X 1 LT. 001000 |
52992.0 |
KILOGRAMOS |
4800.00 |
UNIDADES |
45462.72 |
0.8579 |
| 11 |
14001EC01013001N |
520299 |
THE COTTON WASTE OTHER |
NA |
22670.0 |
KILOGRAMOS |
22.67 |
TONELADA |
18476.05 |
0.8150 |
| 12 |
14001EC01013180V |
150710 |
SOYBEAN OIL CRUDE. WHETHER OR NOT DEGUMMED. |
ACEITE DE SOJA FLEXITANK |
206.7 |
KILOGRAMOS |
206.70 |
TONELADA |
165426.14 |
800.3200 |
| 13 |
14001EC01013310Z |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
25110.0 |
KILOGRAMOS |
0.00 |
TONELADA |
39857.40 |
1.5873 |
| 14 |
14001EC01013447E |
100590 |
THE CORN OTHER |
NA |
50000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
37500.00 |
0.7500 |
| 15 |
14001EC01013451W |
110313 |
CORN GROATS AND MEAL. |
NA |
75000.0 |
KILOGRAMOS |
75.00 |
TONELADA |
37080.00 |
0.4944 |
| 17 |
14001EC01013649X |
100510 |
MAIZE SEED. |
000098 000095 |
44000.0 |
KILOGRAMOS |
44000.00 |
KILOGRAMOS |
224128.00 |
5.0938 |
| 20 |
14001EC01013662D |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
23870.0 |
KILOGRAMOS |
0.00 |
TONELADA |
28943.09 |
1.2125 |
| 21 |
14001EC01013667X |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
203940.0 |
KILOGRAMOS |
0.00 |
TONELADA |
301235.69 |
1.4771 |
| 22 |
14001EC01013781F |
110812 |
CORNSTARCH. |
NA |
52500.0 |
KILOGRAMOS |
2100.00 |
UNIDADES |
21000.00 |
0.4000 |
| 23 |
14001EC01013873H |
100590 |
THE CORN OTHER |
NA |
78000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
54419.82 |
0.6977 |
| 24 |
14001EC01013952F |
100510 |
MAIZE SEED. |
000098 000095 |
308000.0 |
KILOGRAMOS |
308000.00 |
KILOGRAMOS |
1568280.00 |
5.0918 |
| 29 |
14001EC01014285F |
100590 |
THE CORN OTHER |
NA |
25000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
14700.00 |
0.5880 |
| 30 |
14001EC01014416B |
100510 |
MAIZE SEED. |
000098 000095 |
175370.0 |
KILOGRAMOS |
175370.00 |
KILOGRAMOS |
893035.19 |
5.0923 |
| 31 |
14001EC01014485H |
100590 |
THE CORN OTHER |
NA |
52000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
35880.00 |
0.6900 |
| 33 |
14001EC01014511U |
100590 |
THE CORN OTHER |
NA |
26000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
18533.06 |
0.7128 |
| 51 |
14001EC01014739J |
100590 |
THE CORN OTHER |
NA |
130000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
87300.20 |
0.6715 |
| 52 |
14001EC01014749K |
100590 |
THE CORN OTHER |
NA |
104000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
69840.16 |
0.6715 |
| 53 |
14001EC01014805D |
100510 |
MAIZE SEED. |
000098 000095 |
36425.0 |
KILOGRAMOS |
36425.00 |
KILOGRAMOS |
186468.00 |
5.1192 |
| 55 |
14001EC01014834F |
110220 |
CORN MEAL. |
NA |
2250.0 |
KILOGRAMOS |
3750.00 |
UNIDADES |
3225.00 |
1.4333 |
Sicex 2.5 Argentina Exports 2015: CE != sum(TQ1) and shipment ID not unique, with FOB/kg
| 12029EC01007577T |
470321 |
WOOD PULP QCA SEMI-BLEACHED OR BLEACHED D D CONIFERS. THE SODA (SODA) OR SULPHATE. EXCEPT DISSOLVING GRADES |
NA |
111418.0 |
KILOGRAMOS |
0.0 |
TONELADA |
73823.30 |
0.6626 |
| 13029EC01006638R |
470321 |
WOOD PULP QCA SEMI-BLEACHED OR BLEACHED D D CONIFERS. THE SODA (SODA) OR SULPHATE. EXCEPT DISSOLVING GRADES |
NA |
52767.0 |
KILOGRAMOS |
0.0 |
TONELADA |
36829.22 |
0.6980 |
| 14001EC01090761X |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
25610.0 |
KILOGRAMOS |
0.0 |
TONELADA |
23151.44 |
0.9040 |
| 14001EC01092881N |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
123640.0 |
KILOGRAMOS |
0.0 |
TONELADA |
117208.00 |
0.9480 |
| 14001EC01096354M |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
450.0 |
KILOGRAMOS |
0.0 |
TONELADA |
570.44 |
1.2676 |
| 14001EC01096368R |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
50040.0 |
KILOGRAMOS |
0.0 |
TONELADA |
39714.75 |
0.7937 |
| 14001EC01096730K |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
25710.0 |
KILOGRAMOS |
0.0 |
TONELADA |
20404.74 |
0.7936 |
| 14001EC01096764R |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
25470.0 |
KILOGRAMOS |
0.0 |
TONELADA |
20214.27 |
0.7937 |
| 14001EC01096776U |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
125610.0 |
KILOGRAMOS |
0.0 |
TONELADA |
99690.38 |
0.7937 |
| 14001EC01098254N |
520299 |
THE COTTON WASTE OTHER |
NA |
33449.9 |
KILOGRAMOS |
33449.9 |
KILOGRAMOS |
33449.90 |
1.0000 |
| 14001EC01098599C |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
24960.0 |
KILOGRAMOS |
0.0 |
TONELADA |
19809.75 |
0.7937 |
| 14001EC01099167R |
100590 |
THE CORN OTHER |
NA |
25000.0 |
KILOGRAMOS |
0.0 |
TONELADA |
13300.00 |
0.5320 |
| 14001EC01099412K |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
197250.0 |
KILOGRAMOS |
0.0 |
TONELADA |
156547.45 |
0.7936 |
| 14001EC01099435P |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
44260.0 |
KILOGRAMOS |
0.0 |
TONELADA |
35126.95 |
0.7937 |
| 14001EC01099717S |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
46690.0 |
KILOGRAMOS |
0.0 |
TONELADA |
37055.52 |
0.7937 |
| 14001EC01099821Y |
100590 |
THE CORN OTHER |
NA |
49930.0 |
KILOGRAMOS |
0.0 |
TONELADA |
22967.80 |
0.4600 |
| 14001EC01100001K |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
126500.0 |
KILOGRAMOS |
0.0 |
TONELADA |
100397.99 |
0.7937 |
| 14001EC01100006P |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
68030.0 |
KILOGRAMOS |
0.0 |
TONELADA |
53992.69 |
0.7937 |
| 14001EC01100123P |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
169080.0 |
KILOGRAMOS |
0.0 |
TONELADA |
137918.89 |
0.8157 |
| 14001EC01100151Z |
100590 |
THE CORN OTHER |
NA |
125000.0 |
KILOGRAMOS |
0.0 |
TONELADA |
55125.00 |
0.4410 |
| 14001EC01100549E |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
128130.0 |
KILOGRAMOS |
0.0 |
TONELADA |
101691.66 |
0.7937 |
| 14001EC01100643W |
100590 |
THE CORN OTHER |
NA |
390000.0 |
KILOGRAMOS |
0.0 |
TONELADA |
193050.00 |
0.4950 |
| 14001EC01100665D |
100590 |
THE CORN OTHER |
NA |
49720.0 |
KILOGRAMOS |
0.0 |
TONELADA |
24362.80 |
0.4900 |
| 14001EC01101038V |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
99830.0 |
KILOGRAMOS |
0.0 |
TONELADA |
79231.08 |
0.7937 |
| 14001EC01101108T |
100590 |
THE CORN OTHER |
NA |
57000.0 |
KILOGRAMOS |
0.0 |
TONELADA |
43320.00 |
0.7600 |
Sicex 2.5 Argentina Exports 2016: CE != sum(TQ1) and shipment ID not unique, with FOB/kg
| 3 |
15003EC01004581G |
230400 |
OTHER CAKE AND SOLID WASTE REMOVAL OF SOYBEAN OIL EVEN GROUND OR IN PELLETS |
NA |
1000000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
321590.00 |
0.3216 |
| 4 |
15003EC01004705E |
230400 |
OTHER CAKE AND SOLID WASTE REMOVAL OF SOYBEAN OIL EVEN GROUND OR IN PELLETS |
NA |
15520000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
4975557.00 |
0.3206 |
| 5 |
15008EC01010255G |
110812 |
CORNSTARCH. |
NA |
437325.0 |
KILOGRAMOS |
17493.00 |
UNIDADES |
146503.88 |
0.3350 |
| 6 |
15008EC01010821F |
110812 |
CORNSTARCH. |
NA |
175000.0 |
KILOGRAMOS |
7000.00 |
UNIDADES |
59500.00 |
0.3400 |
| 7 |
15008EC01011047G |
110812 |
CORNSTARCH. |
NA |
349975.0 |
KILOGRAMOS |
13999.00 |
UNIDADES |
117241.63 |
0.3350 |
| 8 |
15008EC01011205C |
100590 |
THE CORN OTHER |
NA |
127500.0 |
KILOGRAMOS |
0.00 |
TONELADA |
45362.50 |
0.3558 |
| 11 |
15008EC01011371G |
110812 |
CORNSTARCH. |
NA |
35000.0 |
KILOGRAMOS |
1400.00 |
UNIDADES |
12950.00 |
0.3700 |
| 12 |
15008EC01011420B |
100590 |
THE CORN OTHER |
NA |
130400.0 |
KILOGRAMOS |
0.00 |
TONELADA |
46355.90 |
0.3555 |
| 13 |
15008EC01011421C |
100590 |
THE CORN OTHER |
NA |
26000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
10400.00 |
0.4000 |
| 16 |
15008EC01011442F |
100590 |
THE CORN OTHER |
NA |
52160.0 |
KILOGRAMOS |
0.00 |
TONELADA |
20107.21 |
0.3855 |
| 17 |
15008EC01011443G |
100590 |
THE CORN OTHER |
NA |
26080.0 |
KILOGRAMOS |
0.00 |
TONELADA |
9090.78 |
0.3486 |
| 18 |
15008EC01011460F |
100590 |
THE CORN OTHER |
NA |
51600.0 |
KILOGRAMOS |
0.00 |
TONELADA |
17697.77 |
0.3430 |
| 19 |
15008EC01011464J |
100590 |
THE CORN OTHER |
NA |
39000.0 |
KILOGRAMOS |
0.00 |
TONELADA |
23400.00 |
0.6000 |
| 20 |
15008EC01011465K |
100590 |
THE CORN OTHER |
NA |
26080.0 |
KILOGRAMOS |
0.00 |
TONELADA |
10264.38 |
0.3936 |
| 23 |
15008EC01011475L |
110812 |
CORNSTARCH. |
NA |
385000.0 |
KILOGRAMOS |
15400.00 |
UNIDADES |
132825.00 |
0.3450 |
| 24 |
15008EC01011480H |
120190 |
OTHER BEANS (BEANS-BEAN-BEANS) SOY (SOY) - EVEN BROKEN |
NA |
329670.0 |
KILOGRAMOS |
0.00 |
TONELADA |
263736.00 |
0.8000 |
| 25 |
15008EC01011492K |
100590 |
THE CORN OTHER |
NA |
25800.0 |
KILOGRAMOS |
0.00 |
TONELADA |
8848.88 |
0.3430 |
| 26 |
15008EC01011513E |
100590 |
THE CORN OTHER |
NA |
50960.0 |
KILOGRAMOS |
0.00 |
TONELADA |
18243.68 |
0.3580 |
| 27 |
15008EC01011533G |
151529 |
OTHER THE CORN OIL AND ITS FRACTIONS. |
GRANEL |
27730.0 |
KILOGRAMOS |
27.73 |
TONELADA |
31057.60 |
1.1200 |
| 28 |
15008EC01011541F |
120810 |
MEAL OF BEANS (POROTOS.FRIJOLES.FREJOLES) SOY (SOY). |
NA |
273940.0 |
KILOGRAMOS |
0.00 |
TONELADA |
279418.81 |
1.0200 |
| 29 |
15008EC01011549N |
110812 |
CORNSTARCH. |
NA |
161950.0 |
KILOGRAMOS |
6478.00 |
UNIDADES |
53929.35 |
0.3330 |
| 30 |
15008EC01011550F |
110812 |
CORNSTARCH. |
NA |
48000.0 |
KILOGRAMOS |
1920.00 |
UNIDADES |
16800.00 |
0.3500 |
| 31 |
15018EC01000093G |
110423 |
THE GRAIN OF CORN OTHER WORKED (EJM, HULLED SLICED OR BROKEN PEARL). |
NA |
279200.0 |
KILOGRAMOS |
279200.00 |
KILOGRAMOS |
64495.20 |
0.2310 |
| 32 |
15018EC01000098L |
110423 |
THE GRAIN OF CORN OTHER WORKED (EJM, HULLED SLICED OR BROKEN PEARL). |
NA |
278440.0 |
KILOGRAMOS |
278440.00 |
KILOGRAMOS |
64319.64 |
0.2310 |
| 33 |
15019EC01000748Y |
30614 |
CRABS (EXCEPT MACRUROS) FROZEN. |
1 X 13.61 KG CAJA |
57978.6 |
KILOGRAMOS |
20836.91 |
KILOGRAMOS |
166695.28 |
2.8751 |
Sicex 2.5 Argentina Exports 2017: CE != sum(TQ1) and shipment ID not unique, with FOB/kg
| 16001EC01057550J |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
99750.00 |
KILOGRAMOS |
0.0 |
TONELADA |
119850.62 |
1.2015 |
| 16001EC01057716N |
150790 |
THE SOYBEAN OIL OTHER AND ITS FRACTIONS. WHETHER OR NOT REFINED BUT NOT CHEMICALLY MODIFIED. |
CAJAS 6 X 3 LT 003000 |
24970.68 |
KILOGRAMOS |
1512.0 |
UNIDADES |
28903.09 |
1.1575 |
| 16001EC01058187Z |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
42290.00 |
KILOGRAMOS |
0.0 |
TONELADA |
60601.15 |
1.4330 |
| 16001EC01058528P |
100590 |
THE CORN OTHER |
NA |
25000.00 |
KILOGRAMOS |
0.0 |
TONELADA |
15050.00 |
0.6020 |
| 16001EC01058566R |
150790 |
THE SOYBEAN OIL OTHER AND ITS FRACTIONS. WHETHER OR NOT REFINED BUT NOT CHEMICALLY MODIFIED. |
CAJAS 6 X 3 LT 003000 |
24970.68 |
KILOGRAMOS |
1512.0 |
UNIDADES |
28032.18 |
1.1226 |
| 16001EC01058573P |
150790 |
THE SOYBEAN OIL OTHER AND ITS FRACTIONS. WHETHER OR NOT REFINED BUT NOT CHEMICALLY MODIFIED. |
CAJAS 6 X 3 LT 003000 |
24970.68 |
KILOGRAMOS |
1512.0 |
UNIDADES |
29329.47 |
1.1746 |
| 16001EC01058577T |
150790 |
THE SOYBEAN OIL OTHER AND ITS FRACTIONS. WHETHER OR NOT REFINED BUT NOT CHEMICALLY MODIFIED. |
CAJAS 4 X 5 LT 005000 |
25102.80 |
KILOGRAMOS |
1368.0 |
UNIDADES |
28153.99 |
1.1215 |
| 16001EC01058585S |
150790 |
THE SOYBEAN OIL OTHER AND ITS FRACTIONS. WHETHER OR NOT REFINED BUT NOT CHEMICALLY MODIFIED. |
CAJAS 6 X 3 LT 003000 |
24970.68 |
KILOGRAMOS |
1512.0 |
UNIDADES |
28340.93 |
1.1350 |
| 16001EC01058951P |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
72950.00 |
KILOGRAMOS |
0.0 |
TONELADA |
87650.15 |
1.2015 |
| 16001EC01059212G |
150790 |
THE SOYBEAN OIL OTHER AND ITS FRACTIONS. WHETHER OR NOT REFINED BUT NOT CHEMICALLY MODIFIED. |
CAJA 6 X 2 LTS. 002000 |
25270.56 |
KILOGRAMOS |
2289.0 |
UNIDADES |
21201.86 |
0.8390 |
| 16001EC01059233J |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
102320.00 |
KILOGRAMOS |
0.0 |
TONELADA |
154697.61 |
1.5119 |
| 16001EC01059238Y |
150790 |
THE SOYBEAN OIL OTHER AND ITS FRACTIONS. WHETHER OR NOT REFINED BUT NOT CHEMICALLY MODIFIED. |
NA |
24067.20 |
KILOGRAMOS |
0.0 |
UNIDADES |
20278.84 |
0.8426 |
| 16001EC01059367R |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
248113.50 |
KILOGRAMOS |
0.0 |
KILOGRAMOS |
246145.95 |
0.9921 |
| 16001EC01059410G |
470321 |
WOOD PULP QCA SEMI-BLEACHED OR BLEACHED D D CONIFERS. THE SODA (SODA) OR SULPHATE. EXCEPT DISSOLVING GRADES |
NA |
256016.00 |
KILOGRAMOS |
0.0 |
TONELADA |
129048.64 |
0.5041 |
| 16001EC01059563P |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
25580.00 |
KILOGRAMOS |
0.0 |
TONELADA |
36091.85 |
1.4109 |
| 16001EC01059603K |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
48730.00 |
KILOGRAMOS |
0.0 |
TONELADA |
58549.58 |
1.2015 |
| 16001EC01059689B |
520299 |
THE COTTON WASTE OTHER |
NA |
16415.40 |
KILOGRAMOS |
16415.4 |
KILOGRAMOS |
14445.55 |
0.8800 |
| 16001EC01059771Z |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
72420.00 |
KILOGRAMOS |
0.0 |
TONELADA |
102978.86 |
1.4220 |
| 16001EC01059796A |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
14560.00 |
KILOGRAMOS |
0.0 |
TONELADA |
17012.49 |
1.1684 |
| 16001EC01059799D |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
96820.00 |
KILOGRAMOS |
0.0 |
TONELADA |
138742.09 |
1.4330 |
| 16001EC01059810K |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
51970.00 |
KILOGRAMOS |
0.0 |
TONELADA |
60723.83 |
1.1684 |
| 16001EC01059860P |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
24890.00 |
KILOGRAMOS |
0.0 |
TONELADA |
32923.50 |
1.3228 |
| 16001EC01060035B |
100590 |
THE CORN OTHER |
NA |
78000.00 |
KILOGRAMOS |
0.0 |
TONELADA |
43170.03 |
0.5535 |
| 16001EC01060042W |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
51500.00 |
KILOGRAMOS |
0.0 |
TONELADA |
78522.05 |
1.5247 |
| 16001EC01060105W |
520100 |
COTTON, NOT CARDED OR COMBED. |
NA |
23320.00 |
KILOGRAMOS |
0.0 |
TONELADA |
30846.77 |
1.3228 |