ceumicrodata / respect-trade-similarity

Trade Similarity Index for RESPECT project
MIT License
2 stars 2 forks source link

Explore bulk COMEXT data #1

Closed korenmiklos closed 5 years ago

korenmiklos commented 5 years ago

https://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?sort=1&dir=%2Fcomext

We need 2000-2014, all reporting and partner countries. External trade only, both exports and imports. Most detailed product descriptions, Combine Nomenclature. Annual is enough, monthly not needed.

korenmiklos commented 5 years ago

Look for files of the format nc2015_SK

~/Downloads ❯ 7z x nc2015_SK.7z 

7-Zip [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21
p7zip Version 16.02 (locale=utf8,Utf16=on,HugeFiles=on,64 bits,4 CPUs x64)

Scanning the drive for archives:
1 file, 8351873 bytes (8157 KiB)

Extracting archive: nc2015_SK.7z
--
Path = nc2015_SK.7z
Type = 7z
Physical Size = 8351873
Headers Size = 126
Method = LZMA:26
Solid = -
Blocks = 1

Everything is Ok   

Size:       53409088
Compressed: 8351873
~/Downloads ❯ head 2015_063.txt 
DECLARANT,PARTNER,PRODUCT,FLOW,STAT_REGIME,PERIOD,VALUE_1000EURO,QUANTITY_TON,SUP_QUANTITY
063,0001,01,1,4,201501,60.89,0.8,
063,0001,01,2,4,201501,2.37,0.0,
063,0001,01051111,1,4,201501,60.89,0.8,20387
063,0001,01061900,2,4,201501,2.37,0.0,
063,0001,02,1,4,201501,556.34,418.0,
063,0001,02031190,1,4,201501,20.40,22.2,
063,0001,02031219,1,4,201501,205.83,177.2,
063,0001,02031915,1,4,201501,330.11,218.6,
063,0001,03,1,4,201501,1.64,0.1,