Follow the link to the origin of the table

click : here to select part of table


Post this (httpRequest) to include table in your program:

Url:
http://bank.stat.gl/api/v1/en/Greenland/EN/EN20/ENX2IEB.px
Query:


Example in R, copy/paste code and edit pxpath :

library(httpRequest)
library(rjstat)
library(pxR)
host <- "bank.stat.gl"
path <- "http:/api/v1/en/Greenland/EN/EN20/ENX2IEB.px"
data <- '

'
d1 <- simplePostToHost(host, path, data, contenttype="text/px")
k1 <- sub("[^§]*§", "", sub("\r\n\r\n", "§", d1))
sink('c:/pxpath/file.px')
cat(k1)
sink()
my.px.object <- read.px("c:/pxpath/file.px")
helloWorld <- as.data.frame( my.px.object )

Chart Comming soon?

MaybeBaby
en-GL
http://bank.stat.gl/api/v1/en/Greenland/EN/EN20/ENX2IEB.px
Energy Imports, Exports and Bunkers by product, activity and time

unit 2
product 7
activity 3
time 19 True

{"dataset":{"status":{"19":"...","20":"...","21":"...","22":"...","23":"...","24":"...","25":"...","26":"...","27":"...","28":"...","29":"...","30":"...","31":"...","32":"...","33":"...","34":"...","35":"...","36":"...","37":"...","76":"...","77":"...","78":"...","79":"...","80":"...","81":"...","82":"...","83":"...","84":"...","85":"...","86":"...","87":"...","88":"...","89":"...","90":"...","91":"...","92":"...","93":"...","94":"...","133":"...","134":"...","135":"...","136":"...","137":"...","138":"...","139":"...","140":"...","141":"...","142":"...","143":"...","144":"...","145":"...","146":"...","147":"...","148":"...","149":"...","150":"...","151":"...","190":"...","191":"...","192":"...","193":"...","194":"...","195":"...","196":"...","197":"...","198":"...","199":"...","200":"...","201":"...","202":"...","203":"...","204":"...","205":"...","206":"...","207":"...","208":"...","247":"...","248":"...","249":"...","250":"...","251":"...","252":"...","253":"...","254":"...","255":"...","256":"...","257":"...","258":"...","259":"...","260":"...","261":"...","262":"...","263":"...","264":"...","265":"...","304":"...","305":"...","306":"...","307":"...","308":"...","309":"...","310":"...","311":"...","312":"...","313":"...","314":"...","315":"...","316":"...","317":"...","318":"...","319":"...","320":"...","321":"...","322":"...","361":"...","362":"...","363":"...","364":"...","365":"...","366":"...","367":"...","368":"...","369":"...","370":"...","371":"...","372":"...","373":"...","374":"...","375":"...","376":"...","377":"...","378":"...","379":"...","418":"...","419":"...","420":"...","421":"...","422":"...","423":"...","424":"...","425":"...","426":"...","427":"...","428":"...","429":"...","430":"...","431":"...","432":"...","433":"...","434":"...","435":"...","436":"...","475":"...","476":"...","477":"...","478":"...","479":"...","480":"...","481":"...","482":"...","483":"...","484":"...","485":"...","486":"...","487":"...","488":"...","489":"...","490":"...","491":"...","492":"...","493":"...","532":"...","533":"...","534":"...","535":"...","536":"...","537":"...","538":"...","539":"...","540":"...","541":"...","542":"...","543":"...","544":"...","545":"...","546":"...","547":"...","548":"...","549":"...","550":"...","570":"...","571":"...","572":"...","573":"...","574":"...","575":"...","589":"...","590":"...","591":"...","592":"...","593":"...","594":"...","595":"...","596":"...","597":"...","598":"...","599":"...","600":"...","601":"...","602":"...","603":"...","604":"...","605":"...","606":"...","607":"...","608":"...","609":"...","610":"...","611":"...","612":"...","613":"...","646":"...","647":"...","648":"...","649":"...","650":"...","651":"...","652":"...","653":"...","654":"...","655":"...","656":"...","657":"...","658":"...","659":"...","660":"...","661":"...","662":"...","663":"...","664":"...","703":"...","704":"...","705":"...","706":"...","707":"...","708":"...","709":"...","710":"...","711":"...","712":"...","713":"...","714":"...","715":"...","716":"...","717":"...","718":"...","719":"...","720":"...","721":"...","760":"...","761":"...","762":"...","763":"...","764":"...","765":"...","766":"...","767":"...","768":"...","769":"...","770":"...","771":"...","772":"...","773":"...","774":"...","775":"...","776":"...","777":"...","778":"..."},"dimension":{"unit":{"label":"unit","category":{"index":{"0":0,"1":1},"label":{"0":"Giga Joule","1":"m3"}},"extension":{"show":"value"}},"product":{"label":"product","category":{"index":{"0":0,"1":1,"2":2,"3":3,"4":4,"5":5,"6":6},"label":{"0":"Gasoline","1":"Diesel Fuel Arctic","2":"Aviation Gasoline","3":"Fueloil","4":"Gas oil","5":"Jet Fuel/Kerosene","6":"LPG"}},"extension":{"show":"value"}},"activity":{"label":"activity","category":{"index":{"0":0,"1":1,"2":2},"label":{"0":"Imports","1":"Exports","2":"Bunkers"}},"extension":{"show":"value"}},"time":{"label":"time","category":{"index":{"0":0,"1":1,"2":2,"3":3,"4":4,"5":5,"6":6,"7":7,"8":8,"9":9,"10":10,"11":11,"12":12,"13":13,"14":14,"15":15,"16":16,"17":17,"18":18},"label":{"0":"2004","1":"2005","2":"2006","3":"2007","4":"2008","5":"2009","6":"2010","7":"2011","8":"2012","9":"2013","10":"2014","11":"2015","12":"2016","13":"2017","14":"2018","15":"2019","16":"2020","17":"2021","18":"2022"}},"extension":{"show":"value"}},"id":["unit","product","activity","time"],"size":[2,7,3,19],"role":{"time":["time"]}},"label":"Energy Imports, Exports and Bunkers by unit, product, activity and time","source":null,"updated":"2023-12-18T13:00:00Z","value":[448761,453472,474762,613315,509612,540850,608145,656375,524759,592567,567644,555104,661415,668943,690923,694218,827082,911840,814888,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,2,3,0,0,0,0,0,104,648,0,0,1196,1230,194429,166536,228356,215507,210484,227765,210474,173207,161484,193013,183158,188600,188230,189586,189005,169915,170103,169770,161741,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,348,4105,3949,6064,5262,2693,3670,1437,6164,5094,2301,1462,809,902,684,1306,0,0,2575,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,25,0,0,0,0,0,0,125345,378014,437757,550901,559368,512397,474294,563611,447075,778681,0,683,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,40717,297654,343152,460516,44926,42047,40544,63794,67141,89445,19168,0,0,6823731,8382057,7300443,7990019,7318345,7292183,9966941,8952372,6906146,6456441,5454881,6142193,5823353,5795831,5889171,6250888,6779230,6648372,6642581,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,570030,476843,287596,440260,616707,486091,1661611,1698441,591090,195325,671642,256776,687310,758982,844458,766772,843961,529776,941282,582044,885402,952060,943937,948050,843078,757612,923257,728734,700991,729987,665659,764592,1228760,842984,824272,264378,520142,890467,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6705,5775,5533,5133,5088,4277,4220,3969,3841,3438,3183,3343,3395,3174,3141,2751,2721,3174,3185,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,13846,13991,14648,18922,15723,16687,18763,20251,16190,18282,17513,17127,20406,20639,21317,21419,25518,28133,25142,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,3,20,0,0,37,38,5527,4677,6413,6126,5983,6475,5983,4864,4590,5487,5404,5495,5485,5524,5507,5014,5019,5009,4772,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11,132,127,195,169,87,118,46,198,164,74,47,26,29,22,42,0,0,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,null,null,null,null,null,null,3186,9687,10989,13689,14186,12862,11906,14294,11223,19954,0,18,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1035,7627,8614,11443,1139,1055,1018,1618,1685,2292,491,0,0,189359,232602,205028,224395,205531,204796,279915,251422,193955,181325,155065,172500,163545,162772,165394,175552,192712,186715,188828,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15818,13232,8077,12364,17320,13652,46665,47700,16600,5486,19093,7211,19303,21316,23716,21534,23991,14878,26758,16519,25443,27358,27125,27243,24226,21770,26866,20941,20143,21242,19370,21971,35309,24530,23986,7597,15136,25912,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,270,233,223,207,205,172,170,160,155,138,128,135,137,128,126,111,110,128,128,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]}}