Questions and Answers

All Questions

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
  1. State and national IO tables are different from ABS National States Account and National IO table

Report abuse

0 Responses

No other responses made.

Answer this question

Debug Console

Close16 MBRequestSessionTimelineDatabase36Events23
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41... Array(
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B 1 0 152 45D51 0 25651 457525E5A 7 E D 4 85453 6 0 C5D C5A 651 C1B 3165952 2164044 C 016 A17 25056 31A5E 8545350555157 C B 5 05F F5E5C 051 D56 A535450 4 95C D 15258 D44 B4358 6 A16164A515412 24A 256515C1A C A5354 6515456 D5051 95E5056 9 1 5 5565D5D 9 4 0 1 1 D 755 7 D16 94A,
81f30cf708470b974874c8a96a6bcdb2 => 88d1bee25350f6f9c75b8d140885b6a5
)
$_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 => ZkcgugtxRlBdFAmQaV@pVwAAAAc,
REDIRECT_SCRIPT_URL => /answers/question/2,
REDIRECT_SCRIPT_URI => https://www.ielab.info/answers/question/2,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
UNIQUE_ID => ZkcgugtxRlBdFAmQaV@pVwAAAAc,
SCRIPT_URL => /answers/question/2,
SCRIPT_URI => https://www.ielab.info/answers/question/2,
HTTPS => on,
HTTP_X_FORWARDED_FOR => 3.143.1.57,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_PORT => 443,
HTTP_HOST => www.ielab.info,
HTTP_X_AMZN_TRACE_ID => Root=1-664720ba-61e1287306910fe74213c3bc,
HTTP_ACCEPT => */*,
HTTP_USER_AGENT => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com),
HTTP_REFERER => http://www.ielab.info/answers/question/2,
HTTP_ACCEPT_ENCODING => gzip, br, zstd, deflate,
HTTP_COOKIE => d482552ea4a74f85af0bb3d73890dabc=+5+E+45E43105E+E+2444543+7406F5D+11B+37E+B4A+3+05F41134B514059+4+951135F765817+3+B5C1243+B5612+F16+3+B+2+A1B+1+0+152+45D51+0+25651+457525E5A+7+E+D+4+85453+6+0+C5D+C5A+651+C1B+3165952+2164044+C+016+A17+25056+31A5E+8545350555157+C+B+5+05F+F5E5C+051+D56+A535450+4+95C+D+15258+D44+B4358+6+A16164A515412+24A+256515C1A+C+A5354+6515456+D5051+95E5056+9+1+5+5565D5D+9+4+0+1+1+D+755+7+D16+94A; 81f30cf708470b974874c8a96a6bcdb2=88d1bee25350f6f9c75b8d140885b6a5,
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 => www.ielab.info,
SERVER_ADDR => 10.84.154.253,
SERVER_PORT => 443,
REMOTE_ADDR => 10.84.154.105,
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 => 10954,
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 => 1715937466.1241,
REQUEST_TIME => 1715937466
)
session.client.forwarded ⇒ 3.143.1.57
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 88d1bee25350f6f9c75b8d140885b6a5
tracker.ssid ⇒ 88d1bee25350f6f9c75b8d140885b6a5
tracker.rsid ⇒ 88d1bee25350f6f9c75b8d140885b6a5
  • site 0.034 seconds (+0.034); 9.00 MB (+9.000) - afterInitialise
  • site 0.054 seconds (+0.020); 10.50 MB (+1.500) - afterRoute
  • site 0.121 seconds (+0.067); 14.50 MB (+4.000) - afterDispatch
  • site 0.135 seconds (+0.013); 14.75 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.136 seconds (+0.002); 14.75 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.140 seconds (+0.004); 15.00 MB (+0.250) - beforeRenderModule mod_collect (Collect)
  • site 0.142 seconds (+0.001); 15.25 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.142 seconds (+0.000); 15.25 MB (0.000) - beforeRenderModule mod_menu (Community)
  • site 0.144 seconds (+0.002); 15.25 MB (0.000) - afterRenderModule mod_menu (Community)
  • site 0.144 seconds (+0.000); 15.25 MB (0.000) - beforeRenderModule mod_menu (Support)
  • site 0.145 seconds (+0.002); 15.25 MB (0.000) - afterRenderModule mod_menu (Support)
  • site 0.145 seconds (+0.000); 15.25 MB (0.000) - beforeRenderModule mod_menu (Analyse)
  • site 0.146 seconds (+0.001); 15.25 MB (0.000) - afterRenderModule mod_menu (Analyse)
  • site 0.146 seconds (+0.000); 15.25 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.153 seconds (+0.007); 15.50 MB (+0.250) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.154 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.220 seconds (+0.067); 15.75 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.221 seconds (+0.000); 15.75 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.224 seconds (+0.003); 16.00 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.224 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.231 seconds (+0.007); 16.00 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.244 seconds (+0.013); 16.00 MB (0.000) - onAfterRender
  • site 0.251 seconds (+0.007); 16.00 MB (0.000) - sessionStore
16 MB

36 Queries Logged: 0.058634042739868 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '88d1bee25350f6f9c75b8d140885b6a5'
  2. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  3. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  4. 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'
  5. SELECT *
      FROM `jos_viewlevels`
  6. 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
  7. 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
  8. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  9. 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
  10. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  11. SELECT *
      FROM `jos_answers_questions`
      WHERE `jos_answers_questions`.`id` = '2'
  12. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1277'
  13. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1277';
  14. 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
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  16. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  17. 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
  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` = '1'
      GROUP BY jos_tags_object.label,jos_tags.id
  19. SELECT *
      FROM `jos_answers_responses`
      WHERE `jos_answers_responses`.`question_id` = '2'
      AND `jos_answers_responses`.`state` = '1'
  20. SELECT *
      FROM `jos_answers_responses`
      WHERE `jos_answers_responses`.`question_id` = '2'
      AND `jos_answers_responses`.`state` IN ('0','3')
  21. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  23. 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-17 09:17:46' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-05-17 09:17:46' )
      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
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  25. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  29. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  31. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  32. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  33. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  35. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  36. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1715937464;s:18:\"session.timer.last\";i:1715937464;s:17:\"session.timer.now\";i:1715937466;s:24:\"session.client.forwarded\";s:10:\"3.143.1.57\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}}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:\"88d1bee25350f6f9c75b8d140885b6a5\";s:12:\"tracker.ssid\";s:32:\"88d1bee25350f6f9c75b8d140885b6a5\";s:12:\"tracker.rsid\";s:32:\"88d1bee25350f6f9c75b8d140885b6a5\";}',`time` = '1715937466',`ip` = '10.84.154.105'
      WHERE `session_id` = '88d1bee25350f6f9c75b8d140885b6a5'
  • 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