IELab USA

US IE Lab (USLab) provides a Multi-Regional Input-Output (MRIO) database that can be used to study economic impacts of changes intended across the US economic system. The USLab follows the same architecture as other IE labs and contains a time series of sub-national MRIO tables. The input data to the lab consists of national level IO tables as the starting point along with data for constraints on state level GDP and labor data. These national IO tables are then disaggregated to create the sub-regional MRIO tables based on non-survey approaches and constraints added to balance the sectoral and regional outputs.

The USLab can generate MRIO tables at several levels of regional and sectoral aggregation. Region options include 52, 9, and 5 regions corresponding to the 50 states plus Washington, DC and Puerto Rico, and two US Census Region levels, respectively. Users can tailor the MRIO sector aggregation to 21, 100, 312, 708, and 1,058 sectors, corresponding to NAICS codes, based on the disaggregation level required for their own analysis.The USLab is hosted on a server at University of Sydney and is accessed remotely to run analysis. The data required to build the USLab comes from the US Bureau of Economic Analysis (US BEA), that provides the national IO accounts and state GDP data, which are used as some of the constraints for disaggregation. Other optional constraining data include commodity flow survey, exports/imports, and consumer spending data. Using a time series or forecast of GDP, the USLab also provides a capability to generate a time series of US MRIO tables. Currently, data for years 2012-2017 has been included. To be able to use USLab, users should be familiar with Matlab and ALANG files that form the foundation of the IELab structure and the supply and use framework for constructing IO tables. This is the first MRIO Lab platform available for US that can use different non-survey methods to study the structural variations in MRIO tables.The lab has been used to study the economic impact of desired economic changes (such as renewable energy transition, low carbon economy etc.) in the US economy across all states along with satellite energy impacts. A satellite account of employment data from the Bureau of Labor Statistics’ QCEW is also available. Currently, the capabilities are being expanded to perform GHG analysis by developing a satellite account that contains data on associated emissions for each sector.

Debug Console

Close16 MBRequestSessionTimelineDatabase35Events25
$_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 => ZidpPcyVfFjgAL106wuazgAAABo,
REDIRECT_SCRIPT_URL => /analyse/ielab-usa,
REDIRECT_SCRIPT_URI => https://ielab.info/analyse/ielab-usa,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
UNIQUE_ID => ZidpPcyVfFjgAL106wuazgAAABo,
SCRIPT_URL => /analyse/ielab-usa,
SCRIPT_URI => https://ielab.info/analyse/ielab-usa,
HTTPS => on,
HTTP_X_FORWARDED_FOR => 3.238.235.248,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_PORT => 443,
HTTP_HOST => ielab.info,
HTTP_X_AMZN_TRACE_ID => Root=1-6627693d-39d7e9c1243217710d749ed2,
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 => Sat, 30 Sep 2023 22:52:05 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.251,
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 => 11950,
REDIRECT_URL => /analyse/ielab-usa,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /analyse/ielab-usa,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1713858877.7138,
REQUEST_TIME => 1713858877
)
session.client.forwarded 3.238.235.248
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 1adcd7f729670790566ff2134f785f94
tracker.ssid 1adcd7f729670790566ff2134f785f94
tracker.rsid 1adcd7f729670790566ff2134f785f94
  • site 0.040 seconds (+0.040); 9.50 MB (+9.500) - afterInitialise
  • site 0.059 seconds (+0.019); 11.25 MB (+1.750) - afterRoute
  • site 0.091 seconds (+0.032); 14.50 MB (+3.250) - afterDispatch
  • site 0.101 seconds (+0.010); 14.75 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.103 seconds (+0.001); 14.75 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.103 seconds (+0.000); 15.00 MB (+0.250) - beforeRenderModule mod_collect (Collect)
  • site 0.104 seconds (+0.001); 15.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.104 seconds (+0.000); 15.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.106 seconds (+0.002); 15.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.106 seconds (+0.000); 15.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.129 seconds (+0.023); 15.50 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.129 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.131 seconds (+0.001); 15.50 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.131 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.133 seconds (+0.003); 15.50 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.135 seconds (+0.002); 15.50 MB (0.000) - onAfterRender
  • site 0.137 seconds (+0.001); 15.50 MB (0.000) - sessionStore
16 MB

35 Queries Logged: 0.013723373413086 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'ee3786f6b7ebc769a3a2df92e2bb9f28'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = 'ee3786f6b7ebc769a3a2df92e2bb9f28'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '1adcd7f729670790566ff2134f785f94'
  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` = '1adcd7f729670790566ff2134f785f94'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('1adcd7f729670790566ff2134f785f94','0','1713858877','10.84.154.251')
  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 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
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  15. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  16. 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_content'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  17. SELECT a.*,a.id,a.asset_id,a.title,a.alias,a.title_alias,a.introtext,a.fulltext,
      CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END AS state,a.mask,a.catid,a.created,a.created_by,a.created_by_alias,
      CASE WHEN a.modified IS NULL THEN a.created ELSE a.modified END AS modified,a.modified_by,a.checked_out,a.checked_out_time,a.publish_up,a.publish_down,a.images,a.urls,a.attribs,a.version,a.parentid,a.ordering,a.metakey,a.metadesc,a.access,a.hits,a.metadata,a.featured,a.language,a.xreference,c.title AS category_title,c.alias AS category_alias,c.access AS category_access,u.name AS author,parent.title AS parent_title,parent.id AS parent_id,parent.path AS parent_route,parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating,v.rating_count AS rating_count
      FROM `jos_content` AS `a`
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE `a`.`id` = '39'
      AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= '2024-04-23 07:54:37' )
      AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= '2024-04-23 07:54:37' )
      AND `a`.`state` IN ('1','2')
  18. SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jos_categories` AS `c`
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (`c`.`extension` = 'com_content' OR `c`.`extension` = 'system' )
      AND `c`.`access` IN ('1','1','4')
      AND `c`.`published` = '1'
      AND `s`.`id` = '28'
      AND badcats.id is null
      GROUP BY c.id,c.asset_id,c.access,c.alias,c.checked_out,c.checked_out_time,c.created_time,c.created_user_id,c.description,c.extension,c.hits,c.language,c.level,c.lft,c.metadata,c.metadesc,c.metakey,c.modified_time,c.note,c.params,c.parent_id,c.path,c.published,c.rgt,c.title,c.modified_user_id
      ORDER BY `c`.`lft` ASC
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  20. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  21. 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-04-23 07:54:37' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-04-23 07:54:37' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '161' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  23. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  25. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  29. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  31. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  32. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  33. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  35. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713858877;s:18:\"session.timer.last\";i:1713858877;s:17:\"session.timer.now\";i:1713858877;s:24:\"session.client.forwarded\";s:13:\"3.238.235.248\";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:\"1adcd7f729670790566ff2134f785f94\";s:12:\"tracker.ssid\";s:32:\"1adcd7f729670790566ff2134f785f94\";s:12:\"tracker.rsid\";s:32:\"1adcd7f729670790566ff2134f785f94\";}',`time` = '1713858877',`ip` = '10.84.154.251'
      WHERE `session_id` = '1adcd7f729670790566ff2134f785f94'
  • 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
  • onContentBeforeDisplay Method plgContentPagenavigation::onContentBeforeDisplay /core/plugins/content/pagenavigation/pagenavigation.php:25
  • onContentBeforeDisplay Method plgContentVote::onContentBeforeDisplay /core/plugins/content/vote/vote.php:32
  • 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