COMEXT - ASCII version
======================
Format of the trade statistics on the monthly CD-ROMs:
In the directory DATA, all the data of the monthly CD-ROM are
available. The files (*,dat and *,hs2) are compressed with ZIP
The format is the following:
FLOW,PRODUCT CODE,PARTNER COUNTRY,STATISTICAL PROCEDURE,REPORTING
COUNTRY,VALUE IN 1000ECU,VALUE IN TONS,VALUE IN SUPPLEMENTARY UNIT
One file corresponds with one period. E.g. n9601.dat --> January
1996
n9601.hs2 --> January 1996
FLOW : =1 for import =2 for export
PRODUCT CODE : CN8 (8 digits) for the file *.dat
: HS2 (2 digits) for the file *.hs2
(code TT is the TOTAL TRADE)
PARTNER COUNTRY : 4 digits code
STATISTICAL PROCEDURE : 1 digit code (see the file methodo.txt)
For the statistical procedure 1 you have to calculate it yourself
from the other procedure, like this
RS1 = RS4-RS3-RS5-RS6-RS7
REPORTING COUNTRY : 3 digits (000 is the Europe)
example of a file *.dat :
1,00900000,0001,4,003,4277,1602,0
1,00900000,0001,4,004,6499,3497,0
1,00900000,0001,4,006,35807,8109,0
1,00900000,0001,4,019,46583,13208,0
1,00900000,0002,4,003,6130,6711,0
1,00900000,0002,4,004,23937,48844,0
1,00900000,0002,4,006,9652,9055,0
1,00900000,0002,4,019,39718,64610,0
1,09YYY123,0003,4,004,410455,2451584,0
1,09SSS123,0003,4,006,15458,9894,0
example of a file *.hs2 :
1,TT,0001,4,002,1645518,2473278,0
1,TT,0001,4,003,604235,610602,0
1,TT,0001,4,004,3217318,2337476,0
1,TT,0001,4,005,2162954,2078616,0
1,TT,0001,4,006,1794549,953244,0
1,TT,0001,4,007,85682,68176,0
1,01,0001,4,008,166575,63810,0
1,01,0001,4,009,129421,240452,0
1,01,0001,4,010,270386,202874,0
1,01,0001,4,011,1470561,1086700,0
To obtain a CN4 code (4 digits) or CN6 code (6 digits), you have
to add the corresponding 8 digits code.
For example the code 1234 is the sum of the 8 digits code which
begin by 1234 (1234 = sum (1234????))
5/15/01
(c) Eurostat