Loading...
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/OF/OF30/OFXREAU.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/OF/OF30/OFXREAU.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/OF/OF30/OFXREAU.px
Expenditure of general government sector by type of transaction by sector, transaction and time
{"dataset":{"status":{"75":"-","76":"-","77":"-","78":"-","79":"-","80":"-","81":"-","82":"-","83":"-","84":"-","85":"-","86":"-","87":"-","88":"-","89":"-","90":"-","91":"-","92":"-","93":"-","94":"-","95":"-","96":"-","97":"-","98":"-","99":"-","125":"-","126":"-","127":"-","128":"-","129":"-","130":"-","131":"-","132":"-","133":"-","134":"-","135":"-","136":"-","137":"-","138":"-","139":"-","140":"-","141":"-","142":"-","143":"-","144":"-","145":"-","146":"-","147":"-","148":"-","149":"-","275":"-","276":"-","277":"-","278":"-","279":"-","280":"-","281":"-","282":"-","283":"-","284":"-","285":"-","286":"-","287":"-","288":"-","289":"-","290":"-","291":"-","292":"-","293":"-","294":"-","295":"-","296":"-","297":"-","298":"-","299":"-","300":"-","301":"-","302":"-","303":"-","304":"-","305":"-","306":"-","307":"-","308":"-","309":"-","310":"-","311":"-","312":"-","313":"-","314":"-","315":"-","316":"-","317":"-","318":"-","319":"-","320":"-","321":"-","322":"-","323":"-","324":"-","325":"-","326":"-","327":"-","328":"-","329":"-","330":"-","331":"-","332":"-","333":"-","334":"-","335":"-","336":"-","337":"-","338":"-","339":"-","340":"-","341":"-","342":"-","343":"-","344":"-","345":"-","346":"-","347":"-","348":"-","349":"-","350":"-","351":"-","352":"-","353":"-","354":"-","355":"-","356":"-","357":"-","358":"-","359":"-","360":"-","361":"-","362":"-","363":"-","364":"-","365":"-","366":"-","367":"-","368":"-","369":"-","370":"-","371":"-","372":"-","373":"-","374":"-","375":"-","376":"-","377":"-","378":"-","379":"-","380":"-","381":"-","382":"-","383":"-","384":"-","385":"-","386":"-","387":"-","388":"-","389":"-","390":"-","391":"-","392":"-","393":"-","394":"-","395":"-","396":"-","397":"-","398":"-","399":"-","450":"-","451":"-","452":"-","453":"-","454":"-","455":"-","456":"-","457":"-","458":"-","459":"-","460":"-","461":"-","462":"-","463":"-","464":"-","465":"-","466":"-","467":"-","468":"-","469":"-","470":"-","471":"-","472":"-","473":"-","474":"-","475":"-","476":"-","477":"-","478":"-","479":"-","480":"-","481":"-","482":"-","483":"-","484":"-","485":"-","486":"-","487":"-","488":"-","489":"-","490":"-","491":"-","492":"-","493":"-","494":"-","495":"-","496":"-","497":"-","498":"-","499":"-","500":"-","501":"-","502":"-","503":"-","504":"-","505":"-","506":"-","507":"-","508":"-","509":"-","510":"-","511":"-","512":"-","513":"-","514":"-","515":"-","516":"-","517":"-","518":"-","519":"-","520":"-","521":"-","522":"-","523":"-","524":"-","525":"-","526":"-","527":"-","528":"-","529":"-","530":"-","531":"-","532":"-","533":"-","534":"-","535":"-","536":"-","537":"-","538":"-","539":"-","540":"-","541":"-","542":"-","543":"-","544":"-","545":"-","546":"-","547":"-","548":"-","549":"-","645":"-","650":"-","651":"-","652":"-","653":"-","654":"-","655":"-","656":"-","657":"-","658":"-","659":"-","660":"-","661":"-","662":"-","663":"-","664":"-","665":"-","666":"-","667":"-","668":"-","669":"-","670":"-","671":"-","672":"-","673":"-","674":"-","675":"-","676":"-","677":"-","678":"-","679":"-","680":"-","681":"-","682":"-","683":"-","684":"-","685":"-","687":"-","688":"-","689":"-","690":"-","691":"-","692":"-","693":"-","694":"-","695":"-","696":"-","697":"-","698":"-","770":"-","773":"-","774":"-","788":"-","790":"-","792":"-","800":"-","801":"-","802":"-","803":"-","804":"-","805":"-","806":"-","807":"-","808":"-","809":"-","810":"-","811":"-","812":"-","813":"-","814":"-","815":"-","816":"-","817":"-","818":"-","819":"-","820":"-","821":"-","822":"-","823":"-","824":"-","825":"-","826":"-","827":"-","828":"-","829":"-","830":"-","831":"-","832":"-","833":"-","834":"-","835":"-","836":"-","837":"-","838":"-","839":"-","840":"-","841":"-","842":"-","843":"-","844":"-","845":"-","846":"-","847":"-","848":"-","849":"-","850":"-","851":"-","852":"-","853":"-","854":"-","855":"-","856":"-","857":"-","858":"-","859":"-","860":"-","861":"-","862":"-","863":"-","864":"-","865":"-","866":"-","867":"-","868":"-","869":"-","870":"-","871":"-","872":"-","873":"-","874":"-","875":"-","876":"-","877":"-","878":"-","879":"-","880":"-","881":"-","882":"-","883":"-","884":"-","885":"-","886":"-","887":"-","888":"-","889":"-","890":"-","891":"-","892":"-","893":"-","894":"-","895":"-","896":"-","897":"-","898":"-","899":"-","900":"-","901":"-","902":"-","903":"-","904":"-","905":"-","906":"-","907":"-","908":"-","909":"-","910":"-","911":"-","912":"-","913":"-","914":"-","915":"-","916":"-","917":"-","918":"-","919":"-","920":"-","921":"-","922":"-","923":"-","924":"-","974":"-","975":"-","976":"-","977":"-","978":"-","979":"-","980":"-","981":"-","982":"-","983":"-","984":"-","985":"-","986":"-","987":"-","988":"-","989":"-","990":"-","991":"-","992":"-","993":"-","994":"-","995":"-","996":"-","997":"-","998":"-","999":"-","1000":"-","1001":"-","1002":"-","1003":"-","1004":"-","1005":"-","1006":"-","1007":"-","1008":"-","1009":"-","1010":"-","1011":"-","1012":"-","1013":"-","1014":"-","1015":"-","1016":"-","1017":"-","1018":"-","1019":"-","1020":"-","1021":"-","1022":"-","1023":"-","1024":"-","1025":"-","1026":"-","1027":"-","1028":"-","1029":"-","1030":"-","1031":"-","1032":"-","1033":"-","1034":"-","1035":"-","1036":"-","1037":"-","1038":"-","1039":"-","1040":"-","1041":"-","1042":"-","1043":"-","1044":"-","1045":"-","1046":"-","1047":"-","1048":"-","1049":"-"},"dimension":{"transaction":{"label":"transaction","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,"19":19,"20":20,"21":21,"22":22,"23":23,"24":24,"25":25,"26":26,"27":27,"28":28,"29":29,"30":30,"31":31,"32":32,"33":33,"34":34,"35":35,"36":36,"37":37,"38":38,"39":39,"40":40,"41":41,"42":42,"43":43,"44":44},"label":{"0":"1 Compensation of employees","1":"2 Consumption of fixed capital","2":"3 Intermediate consumption","3":"4 Social transfers in kind","4":"5 Sales of goods and services","5":"6 Final consumption expenditure, total (1+2+3+4+5)","6":"7 Interest","7":"8 Subsidies","8":"8.1 Interest","9":"8.2 Subsidies to other enterprises","10":"9 Income transfers","11":"9.1 Income transfers to other levels of government","12":"9.1.1 Central government in Greenland","13":"9.1.2 Social security funds","14":"9.1.3 Selfgovernment","15":"9.1.4 Municipalities","16":"9.2 Households","17":"9.3 Income transfers to private non-profit institutions","18":"9.4 Income transfers to the rest of the world","19":"9.4.1 The Danish State","20":"9.4.2 To Denmark","21":"9.4.3 To the rest of the world","22":"10 Income transfers, total (7+8+9)","23":"11 Current outlays, total (6+10)","24":"12 Acquisition of new fixed assets","25":"13 Acquisition of existing buildings, net","26":"14 Changes in inventories","27":"15 Acquisition of land and intangible assets, net","28":"16 Non-financial captial accumulation, total (12+13+14+15)","29":"17 Investment grants and capitaltransfers","30":"17.1 To quasi-corporations","31":"17.2 To other enterprises","32":"17.3 To other levels of government","33":"17.3.1 Central government in Greenland","34":"17.3.2 Social security funds","35":"17.3.3 Selfgovernment","36":"17.3.4 Municipalities","37":"17.4 To households","38":"17.5 Toprivate non-profit institutions","39":"17.6 To the rest of the world","40":"17.6.1 To Denmark","41":"17.6.2 To others","42":"18 Capital transfers, total (17)","43":"19 Capital outlays, total (16+18)","44":"20 TOTAL OUTLAYS (11+19)"}}},"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,"19":19,"20":20,"21":21,"22":22,"23":23,"24":24},"label":{"0":"1994","1":"1995","2":"1996","3":"1997","4":"1998","5":"1999","6":"2000","7":"2001","8":"2002","9":"2003","10":"2004","11":"2005","12":"2006","13":"2007","14":"2008","15":"2009","16":"2010","17":"2011","18":"2012","19":"2013","20":"2014","21":"2015","22":"2016","23":"2017","24":"2018"}}},"id":["transaction","time"],"size":[45,25],"role":{"time":["time"]}},"label":"Expenditure of general government sector by type of transaction by transaction and time","source":"Statistics Greenland","updated":"2009-12-18T20:40:00Z","value":[2010861.0899,2066985.3243,2128662.6666,2207917.141,2357768.5293,2397211.748,2489765.3374,2681168.0196,2768648.1396,2882807.0001,3020188.4618,3047110.2065,3195169.4323,3398318.9662,3518281.5481,3773664.6448,3902673.8987,3947443.6395,4024565.9164,4105456.563,4100772.9444,4180719.265,4300554.3107,4490812.0685,4649919.6624,314702.881,320630.3908,326124.3252,328692.5394,333204.5068,337797.2765,345096.5661,364308.6297,383352.0254,399592.3267,408488.4181,414586.3233,428095.6938,445047.3386,480756.6699,498910.2014,516819.8416,534256.8525,559536.8822,570062.6475,581390.7776,591620.0537,598405.4812,614151.4417,621292.2891,1535154.2549,1542716.6201,1636031.6538,1721548.8787,1791491.3243,1887789.5997,1985636.304,2081315.2529,2159558.4341,2243110.982,2170591.1577,2283427.5121,2556638.7416,2678213.5227,3005005.932,3210792.2388,3112434.2272,3298796.3346,3430328.5371,3480480.14,3673982.5735,3669589.4635,3973783.0154,4145453.4792,4268640.2313,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,-388004.6609,-323768.3898,-427321.8017,-404029.7069,-444510.6894,-447845.6846,-436157.0533,-419484.2947,-437938.3166,-456809.3315,-444874.7947,-513411.252,-532996.6145,-589232.3279,-622698.8638,-634247.1051,-740158.2675,-728932.8414,-702855.394,-733927.2738,-850368.276,-973169.6565,-920390.5709,-1014956.0129,-979977.5651,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,107874.5479,142510.6824,81865.6584,64046.5676,88029.7515,21421.4834,15466.0365,20051.3566,20039.6647,19245.1537,15802.3471,27097.5424,31398.8696,44725.2127,24720.6338,18056.6452,16926.4933,22163.0586,19547.7157,25515.0773,20494.205,23353.1904,21428.1473,18131.1039,24864.2845,595923.3901,576719.2387,590190.718,598654.4548,648132.5872,688698.1432,631569.2017,657729.8319,670140.3799,610224.0325,595466.6032,650287.8402,568108.398,565103.8923,517203.5745,506727.641,532524.2899,514021.3775,513393.8377,484508.5,468572.3085,474358.2908,453912.5906,456007.3279,535191.3874,160976.6344,155047.289,153535.7518,142480.3961,133866.3031,138993.9699,147911.5461,114935.4213,107625.0249,96305.2153,101096.8722,182565.455,148345.8631,154753.3149,127907.5888,137854.3465,156012.8262,138376.4573,122742.584,105164.7052,92896.8694,96903.6931,86719.8164,82665.5102,158290.6552,434946.7557,421671.9497,436654.9663,456174.0588,514266.284,549704.1733,483657.6556,542794.4106,562515.355,513918.8172,494369.731,467722.3852,419762.535,410350.5774,389295.9858,368873.2946,376511.4637,375644.9202,390651.2537,379343.7948,375675.4391,377454.5977,367192.7743,373341.8177,376900.7322,921487.0068,905563.4293,946816.1188,1008902.1679,1066589.3431,1104935.8581,1038670.978,1080425.3826,1071081.4207,1069622.0468,1100983.888,1133734.2788,1180941.1479,1263696.9266,1353580.1593,1416637.7627,1422437.5152,1435106.996,1499898.9887,1510956.0318,1526476.4536,1536068.8717,1537041.4601,1476491.3935,1437754.107,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,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,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,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,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,854716.2293,843471.8723,882083.0218,931981.9998,978149.2278,1008140.9449,933936.1065,972236.008,948162.5916,957805.7228,983637.3546,1008985.9203,1048178.2438,1117439.4329,1187028.8777,1274803.8,1268004.2372,1274782.8898,1324621.7252,1320841.9289,1326818.0985,1340985.013,1326458.9562,1260116.7183,1253549.8089,66770.7775,62091.5571,64733.0969,76920.1681,88440.1153,96794.9132,104734.8715,108189.3746,122918.8291,111816.324,117346.5334,124748.3586,132762.9041,146257.4936,166551.2816,141833.9627,154433.278,160324.1061,175277.2635,190114.1029,199658.3551,195083.8587,210582.5038,216374.6752,184204.2981,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,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,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,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,1625284.9448,1624793.3504,1618872.4952,1671603.1903,1802751.6817,1815055.4846,1685706.2162,1758206.5711,1761261.4654,1699091.2331,1712252.8383,1811119.6614,1780448.4156,1873526.0316,1895504.3676,1941422.0489,1971888.2984,1971291.4321,2032840.5421,2020979.6091,2015542.9671,2033780.353,2012382.1979,1950629.8252,1997809.7789,5097998.5098,5231357.2958,5282369.3391,5525732.0424,5840705.3526,5990008.4242,6070047.3704,6465514.1785,6634881.7479,6767792.2102,6866646.0812,7042832.4513,7427355.6687,7805873.5311,8276849.6538,8790542.0288,8763657.9983,9022855.4174,9344416.4837,9443051.6857,9521320.9866,9502539.4787,9964734.4344,10186090.8018,10557684.3967,336699.4435,329845.7362,346631.3248,331425.2939,361051.6612,356813.8324,352836.4317,538309.0793,580074.4615,584889.6035,397865.1767,400383.6491,466494.3654,551160.9859,586569.1683,742426.22,713538.098,599439.2734,698505.643,667129.7324,658413.7531,638823.9708,609600.7019,865157.8229,774012.6212,-4011.1385,1291.6435,31566.8782,6699.704,1815.9344,11695.2061,907.4528,3232.0367,-13468.1091,196.282,18059.7371,5563.5668,32573.1216,104.0093,-1403.8685,5.2005,-800,-308.85,1773.732,17,null,6032.2125,37894.313,2544.2995,10248.6061,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,null,null,null,null,null,null,null,null,null,null,null,-1840,null,null,null,null,null,null,null,null,null,null,null,null,-8023.1026,332688.305,331137.3797,378198.203,338124.9979,362867.5956,368509.0385,353743.8844,541541.116,566606.3524,585085.8854,415924.9138,404107.2159,499067.487,551264.9952,585165.2998,742431.4205,712738.098,599130.4234,700279.375,667146.7324,658413.7531,644856.1833,647495.0149,867702.1224,776238.1247,244223.4018,195637.1005,161244.4061,98741.2385,114082.4994,115575.0614,94262.6163,134908.5393,264787.8914,135029.2463,224140.8953,146085.3159,242234.1755,161320.142,182251.7749,115443.6339,179167.3867,49519.2393,62094.6885,65207.5786,60180.983,78958.8184,36176.6507,95177.8912,207974.2895,8008.2899,5936.667,5964.8465,3544.771,6080.5714,7268.5985,4949.846,5589.316,27978.364,4965.5951,21045.5813,35956.7891,46265.9225,37576.6125,44479.2761,36526.4124,33844.3596,15344.9113,6642.9359,6132.3394,null,1082.7801,13.775,null,null,153307.5897,100952.384,64549.6641,34925.8911,62232.3022,15223.2852,7842.8325,1144.4737,40769.9223,10437.1662,28437.0033,8684.8769,10508.8013,null,1827.3427,null,9963.4093,null,7715.7953,0.898,1520.8019,816.2536,803.807,745.0793,97258.1373,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,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,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,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,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,37015.8303,45252.8303,63256.0969,53317.3619,39392.5099,61837.9222,38682.4892,62120.9864,155361.0967,84475.278,116000.3503,56679.1398,126013.0669,67210.7881,72473.1439,77657.9662,134679.4191,34172.1848,47157.2073,60104.6962,58475.167,76508.9147,25394.8854,90617.7482,110716.1523,45891.6919,43495.2192,27473.7986,6953.2145,6377.1159,31245.2555,42787.4486,66053.7631,40678.5084,35151.207,58657.9604,44764.5101,59446.3847,56532.7414,63472.0123,1259.2553,680.1987,2.1433,578.75,-1030.355,185.0141,550.87,9964.1834,3815.0637,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,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,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,null,244223.4018,195637.1005,161244.4061,98741.2385,114082.4994,115575.0614,94262.6163,134908.5393,264787.8914,135029.2463,224140.8953,146085.3159,242234.1755,161320.142,182251.7749,115443.6339,179167.3867,49519.2393,62094.6885,65207.5786,60180.983,78958.8184,36176.6507,95177.8912,207974.2895,576911.7067,526774.4802,539442.6091,436866.2363,476950.095,484084.0999,448006.5008,676449.6553,831394.2438,720115.1317,640065.8092,550192.5318,741301.6625,712585.1372,767417.0747,857875.0544,891905.4847,648649.6627,762374.0634,732354.311,718594.7361,723815.0017,683671.6656,962880.0136,984212.4142,5674910.2165,5758131.7761,5821811.9482,5962598.2787,6317655.4476,6474092.5241,6518053.8712,7141963.8338,7466275.9917,7487907.3419,7506711.8904,7593024.9832,8168657.3311,8518458.6683,9044266.7286,9648417.0832,9655563.483,9671505.0801,10106790.5472,10175405.9967,10239915.7226,10226354.4804,10648406.1,11148970.8154,11541896.811]}}

Data Preview

http://bank.stat.gl/api/v1/en/Greenland/OF/OF30/OFXREAU.px