alexandersimoes / oec

The website powering the Observatory of Economic Complexity
atlas.media.mit.edu
157 stars 52 forks source link

Bhutan electricity export do not show up #252

Open gagarine opened 5 years ago

gagarine commented 5 years ago

Bhutan has hydroelectric plants and export electricity (mainly to India).

Src: https://www.mof.gov.bt/wp-content/uploads/2017/03/BTS2016.pdf

Yet electricity do not show up at all on https://oec.world/en/visualize/tree_map/hs92/export/btn/all/show/2017/ Screenshot 2019-09-25 at 19 05 05

gagarine commented 5 years ago

So I clearly have another kind of result from http://atlas.cid.harvard.edu/explore?country=35&product=undefined&year=2017&productClass=HS&target=Product&partner=undefined&startYear=undefined

Screenshot 2019-09-25 at 19 02 49

alexandersimoes commented 5 years ago

I'm not sure the source of their data but we are using trade data from the BACI database of CEPII. I just redownloaded the latest files from their source and here is what they claim the top 20 exports for Bhutan were in 2017:

hs6 t i j v q hs6_name
720221 32272 1024 8080 118322.101764943 105491.02800000002 Ferro-silicon, >55% silicon
284910 2017 64 699 12424.453981999999 19113.44 Calcium carbide
284920 2017 64 699 10314.950679000001 18341.0 Silicon carbide
251810 2017 64 699 9535.284371200001 1770656.0 Dolomite not calcined
252010 2017 64 524 5110.6950495 110961.0 Gypsum, anhydride
720719 2017 64 699 3540.7354232000002 9782.62 Semi-finished product, iron or non-alloy steel <0.25%C, nes
090830 2017 64 699 3444.92 496.543 Cardamoms
220210 2017 64 699 2948.9111183 9463.493 Beverage waters, sweetened or flavoured
270119 2017 64 524 2154.5037829999997 19467.3 Coal except anthracite or bituminous, not agglomerate
392010 2017 64 699 2037.0770000000002 960.6669999999999 Sheet/film not cellular/reinf polymers of ethylene
251830 2017 64 699 1879.9816782999999 392106.0 Agglomerated dolomite (including tarred dolomite)
392099 2017 64 699 1784.386 758.319 Sheet/film not cellular/reinf plastics nes
200980 2017 64 699 1571.3189824 1923.865 Single fruit, veg juice nes, not fermented or spirite
441010 2017 64 699 1338.5211053 1162.9189999999999 Particle board of wood
720229 12102 384 2570 1252.0823022119998 2664.79 Ferro-silicon, <55% silicon
391810 2017 64 251 1157.4562353000001 5.185 Floor, wall, ceiling cover, roll, tile, vinyl chlorid
740819 2017 64 699 1152.138 183.94799999999998 Wire of refined copper < 6mm wide
720299 6051 192 2134 968.750078586 713.87 Ferro-alloys, nes
680221 2017 64 699 931.52084021 1485.0870000000002 Cut or sawn slabs of marble, travertine or alabaster
220720 2017 64 699 908.13660274 1400.0 Ethyl alcohol and other spirits, denatured

Here is a link to find out more about their cleaning methodology: http://www.cepii.fr/CEPII/en/bdd_modele/presentation.asp?id=1.

gagarine commented 5 years ago

Thanks for this data export. I contacted cepil by email but they didn't give me access to those data. So it was a bit hard for me to know where was the problem.

I believe the data in COMTRADE are correct but the one in CEPIL seem wrong. Why? Because tools that use COMTRADE data directly seem to report electricity export correctly.

I understand CEPIL they compare export/import from different country to try to catch error in reporting. Yet India and Bhutan report both import and export respectively of electricity from each other. I aks them to look into the problem, not sure they will do it.

gagarine commented 5 years ago

Or perhaps CEPIL is only about physical product exchange?

gagarine commented 5 years ago

253 is related.

My conclusion is that CEPIL only account for physical good. In my opinion, this is very misleading about the reality of the economy of a country.