Questions and Answers

0 Like 0 Dislike

Jiao Wang

IO table checking against ABS publications
Dear All, I downloaded both states/territories and national IO table from IElab in time series. Then, I compared with national IO table and national states account (from the perspective of GSP). 1. The numbers compiled through IElab seem to be quite low. 2. Also there are large amount of negative values (small) in the USE matrix. Many values = 0.000000000099 by default zero but should be different levels of small not “zero” 3. At the state level, there are zero rows for Residential Buildings Construction and Non-Residential Buildings Construction. 4. Use WA's IO table as a showcase, the totals and overall outputs look small approx. $165.7bn (smaller than reference years in ABS State Accounts) compared to $249.5bn Really keen to understand the IO table structure from IElab. I feel I might look into the wrong part of IO table. Please help me through. Thanks heaps. My email is jwang@synergygroup.net.au

Report abuse

0 Responses

No other responses made.

Debug Console

Close16 MBRequestSessionTimelineDatabase40Events23
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( USER => apache, HOME => /usr/share/httpd, FCGI_ROLE => RESPONDER, REDIRECT_HTTP_AU... Array(
USER => apache,
HOME => /usr/share/httpd,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_UNIQUE_ID => ZlQr0cQnUx4-iN2QpFAOYQAAAAA,
REDIRECT_SCRIPT_URL => /answers/question/2,
REDIRECT_SCRIPT_URI => https://ielab.info/answers/question/2,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
UNIQUE_ID => ZlQr0cQnUx4-iN2QpFAOYQAAAAA,
SCRIPT_URL => /answers/question/2,
SCRIPT_URI => https://ielab.info/answers/question/2,
HTTPS => on,
HTTP_X_FORWARDED_FOR => 44.223.39.67,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_PORT => 443,
HTTP_HOST => ielab.info,
HTTP_X_AMZN_TRACE_ID => Root=1-66542bd1-4ebdaee44dc8e286387de022,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_IF_MODIFIED_SINCE => Fri, 09 Jun 2023 01:28:03 GMT,
HTTP_ACCEPT_ENCODING => br,gzip,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_python/3.5.0- Python/2.7.5,
SERVER_NAME => ielab.info,
SERVER_ADDR => 10.84.154.253,
SERVER_PORT => 443,
REMOTE_ADDR => 10.84.154.176,
DOCUMENT_ROOT => /var/www/ielab,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/ielab,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/ielab/index.php,
REMOTE_PORT => 24400,
REDIRECT_URL => /answers/question/2,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /answers/question/2,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1716792273.0624,
REQUEST_TIME => 1716792273
)
session.client.forwarded 44.223.39.67
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 55a77409f0d9dd61e94f4717ad7b6205
tracker.ssid 55a77409f0d9dd61e94f4717ad7b6205
tracker.rsid 55a77409f0d9dd61e94f4717ad7b6205
  • site 0.040 seconds (+0.040); 9.50 MB (+9.500) - afterInitialise
  • site 0.059 seconds (+0.020); 11.25 MB (+1.750) - afterRoute
  • site 0.097 seconds (+0.038); 15.25 MB (+4.000) - afterDispatch
  • site 0.105 seconds (+0.007); 15.50 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.106 seconds (+0.001); 15.50 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.106 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.107 seconds (+0.001); 15.75 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.107 seconds (+0.000); 15.75 MB (0.000) - beforeRenderModule mod_menu (Community)
  • site 0.109 seconds (+0.001); 15.75 MB (0.000) - afterRenderModule mod_menu (Community)
  • site 0.109 seconds (+0.000); 15.75 MB (0.000) - beforeRenderModule mod_menu (Support)
  • site 0.109 seconds (+0.000); 15.75 MB (0.000) - afterRenderModule mod_menu (Support)
  • site 0.109 seconds (+0.000); 15.75 MB (0.000) - beforeRenderModule mod_menu (Analyse)
  • site 0.110 seconds (+0.000); 15.75 MB (0.000) - afterRenderModule mod_menu (Analyse)
  • site 0.110 seconds (+0.000); 15.75 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.114 seconds (+0.004); 16.00 MB (+0.250) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.115 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.134 seconds (+0.020); 16.25 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.134 seconds (+0.000); 16.25 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.135 seconds (+0.001); 16.50 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.136 seconds (+0.000); 16.50 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.138 seconds (+0.002); 16.50 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.140 seconds (+0.002); 16.50 MB (0.000) - onAfterRender
  • site 0.141 seconds (+0.001); 16.50 MB (0.000) - sessionStore
16 MB

40 Queries Logged: 0.013867378234863 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'dc0917405b0081c79f558b526050c1d5'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = 'dc0917405b0081c79f558b526050c1d5'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '55a77409f0d9dd61e94f4717ad7b6205'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '55a77409f0d9dd61e94f4717ad7b6205'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('55a77409f0d9dd61e94f4717ad7b6205','0','1716792273','10.84.154.176')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  13. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  15. SELECT *
      FROM `jos_answers_questions`
      WHERE `jos_answers_questions`.`id` = '2'
  16. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1277'
  17. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1277';
  18. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'answers'
      AND `jos_tags_object`.`objectid` = '2'
      AND `jos_tags`.`admin` NOT IN ('1')
      GROUP BY jos_tags_object.label,jos_tags.id
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  20. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  21. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_answers'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  22. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'answers'
      AND `jos_tags_object`.`objectid` = '2'
      AND `jos_tags`.`admin` = '1'
      GROUP BY jos_tags_object.label,jos_tags.id
  23. SELECT *
      FROM `jos_answers_responses`
      WHERE `jos_answers_responses`.`question_id` = '2'
      AND `jos_answers_responses`.`state` = '1'
  24. SELECT *
      FROM `jos_answers_responses`
      WHERE `jos_answers_responses`.`question_id` = '2'
      AND `jos_answers_responses`.`state` IN ('0','3')
  25. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  27. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2024-05-27 06:44:33' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-05-27 06:44:33' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '77' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  29. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  31. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  32. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  33. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  35. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  36. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  37. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  38. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  39. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  40. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1716792273;s:18:\"session.timer.last\";i:1716792273;s:17:\"session.timer.now\";i:1716792273;s:24:\"session.client.forwarded\";s:12:\"44.223.39.67\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"55a77409f0d9dd61e94f4717ad7b6205\";s:12:\"tracker.ssid\";s:32:\"55a77409f0d9dd61e94f4717ad7b6205\";s:12:\"tracker.rsid\";s:32:\"55a77409f0d9dd61e94f4717ad7b6205\";}',`time` = '1716792273',`ip` = '10.84.154.176'
      WHERE `session_id` = '55a77409f0d9dd61e94f4717ad7b6205'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:20
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:21
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare Method plgContentFormatwiki::onContentPrepare /core/plugins/content/formatwiki/formatwiki.php:63
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:22
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:60
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:25
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:21