Publication: icio: Economic Analysis with Inter-Country Input-Output Tables in Stata
Loading...
Date
2020-02
ISSN
Published
2020-02
Editor(s)
Abstract
Several new statistical tools and analytical frameworks have been developed recently to measure countries' and sectors' involvement in global value chains. Such wealth of methodologies reflects that different empirical questions call for distinct accounting methods, along with different levels of aggregation of trade flows. This paper is a companion to the conceptual framework presented in Borin and Mancini (2019). The paper describes a new Stata module, icio, that allows the user to construct the most appropriate measure for given empirical questions on trade in value-added and participation in global value chains of countries and sectors. By exploiting inter-country input-output tables, icio provides decompositions of aggregate, bilateral, and sectoral exports and imports according to the source and destination of their value-added content. As different measures are suited to address distinct economic questions, icio is designed to be flexible also in this respect.
Link to Data Set
Citation
“Belotti, Federico; Borin, Alessandro; Mancini, Michele. 2020. icio: Economic Analysis with Inter-Country Input-Output Tables in Stata. Policy Research Working Paper;No. 9156. © World Bank. http://hdl.handle.net/10986/33361 License: CC BY 3.0 IGO.”
Associated URLs
Associated content
Other publications in this report series
Publication The Future of Poverty(Washington, DC: World Bank, 2025-07-15)Climate change is increasingly acknowledged as a critical issue with far-reaching socioeconomic implications that extend well beyond environmental concerns. Among the most pressing challenges is its impact on global poverty. This paper projects the potential impacts of unmitigated climate change on global poverty rates between 2023 and 2050. Building on a study that provided a detailed analysis of how temperature changes affect economic productivity, this paper integrates those findings with binned data from 217 countries, sourced from the World Bank’s Poverty and Inequality Platform. By simulating poverty rates and the number of poor under two climate change scenarios, the paper uncovers some alarming trends. One of the primary findings is that the number of people living in extreme poverty worldwide could be nearly doubled due to climate change. In all scenarios, Sub-Saharan Africa is projected to bear the brunt, contributing the largest number of poor people, with estimates ranging between 40.5 million and 73.5 million by 2050. Another significant finding is the disproportionate impact of inequality on poverty. Even small increases in inequality can lead to substantial rises in poverty levels. For instance, if every country’s Gini coefficient increases by just 1 percent between 2022 and 2050, an additional 8.8 million people could be pushed below the international poverty line by 2050. In a more extreme scenario, where every country’s Gini coefficient increases by 10 percent between 2022 and 2050, the number of people falling into poverty could rise by an additional 148.8 million relative to the baseline scenario. These findings underscore the urgent need for comprehensive climate policies that not only mitigate environmental impacts but also address socioeconomic vulnerabilities.Publication Exports, Labor Markets, and the Environment(Washington, DC: World Bank, 2025-07-14)What is the environmental impact of exports? Focusing on 2000–20, this paper combines customs, administrative, and census microdata to estimate employment elasticities with respect to exports. The findings show that municipalities that faced increased exports experienced faster growth in formal employment. The elasticities were 0.25 on impact, peaked at 0.4, and remained positive and significant even 10 years after the shock, pointing to a long and protracted labor market adjustment. In the long run, informal employment responds negatively to export shocks. Using a granular taxonomy for economic activities based on their environmental impact, the paper documents that environmentally risky activities have a larger share of employment than environmentally sustainable ones, and that the relationship between these activities and exports is nuanced. Over the short run, environmentally risky employment responds more strongly to exports relative to environmentally sustainable employment. However, over the long run, this pattern reverses, as the impact of exports on environmentally sustainable employment is more persistent.Publication The Macroeconomic Implications of Climate Change Impacts and Adaptation Options(Washington, DC: World Bank, 2025-05-29)Estimating the macroeconomic implications of climate change impacts and adaptation options is a topic of intense research. This paper presents a framework in the World Bank's macrostructural model to assess climate-related damages. This approach has been used in many Country Climate and Development Reports, a World Bank diagnostic that identifies priorities to ensure continued development in spite of climate change and climate policy objectives. The methodology captures a set of impact channels through which climate change affects the economy by (1) connecting a set of biophysical models to the macroeconomic model and (2) exploring a set of development and climate scenarios. The paper summarizes the results for five countries, highlighting the sources and magnitudes of their vulnerability --- with estimated gross domestic product losses in 2050 exceeding 10 percent of gross domestic product in some countries and scenarios, although only a small set of impact channels is included. The paper also presents estimates of the macroeconomic gains from sector-level adaptation interventions, considering their upfront costs and avoided climate impacts and finding significant net gross domestic product gains from adaptation opportunities identified in the Country Climate and Development Reports. Finally, the paper discusses the limits of current modeling approaches, and their complementarity with empirical approaches based on historical data series. The integrated modeling approach proposed in this paper can inform policymakers as they make proactive decisions on climate change adaptation and resilience.Publication The Asymmetric Bank Distress Amplifier of Recessions(Washington, DC: World Bank, 2025-07-11)One defining feature of financial crises, evident in U.S. and international data, is asymmetric bank distress—concentrated losses on a subset of banks. This paper proposes a model in which shocks to borrowers’ productivity dispersion lead to asymmetric bank losses. The framework exhibits a “bank distress amplifier,” exacerbating economic downturns by causing costly bank failures and raising uncertainty about the solvency of banks, thereby pushing banks to deleverage. Quantitative analysis shows that the bank distress amplifier doubles investment decline and increases the spread by 2.5 times during the Great Recession compared to a standard financial accelerator model. The mechanism helps explain how a seemingly small shock can sometimes trigger a large crisis.Publication Impact of Heat Waves on Learning Outcomes and the Role of Conditional Cash Transfers(Washington, DC: World Bank, 2025-07-14)This paper evaluates the impact of higher temperatures on learning outcomes in Peru. The results suggest that 1 degree above 20°C is equivalent to 7 and 6 percent of a standard deviation of what a student learns in a year for math and reading tests, respectively. These results hold true when the main specification is changed, splitting the sample, collapsing the data at school level, and using other climate specifications. The paper aims to improve understanding of how to deal with the impacts of climate change on learning outcomes in developing countries. The evidence suggests that conditional cash transfer programs can mitigate the negative effects of higher temperatures on students’ learning outcomes in math and reading.
Journal
Journal Volume
Journal Issue
Related items
Showing items related by metadata.
Publication Economic Consequences of Trade and Global Value Chain Integration(World Bank, Washington, DC, 2025-04-04)This paper introduces a new approach to measuring Global Value Chains (GVC), crucial for informed policy-making. It features a tripartite classification (backward, forward, and two-sided) covering trade and production data. The findings indicate that traditional trade-based GVC metrics significantly underestimate global GVC activity, especially in sectors like services and upstream manufacturing, and overstate risks in early trade liberalization stages. Additionally, conventional backward-forward classifications over-estimate backward linkages. The paper further applies these measures empirically to assess how GVC participation mediates the impact of demand shocks on domestic output, highlighting both the exposure and stabilizing potential of GVC integration. These new measures are comprehensively available on the World Bank’s WITS Platform, providing a key resource for GVC analysis.Publication Measuring What Matters in Global Value Chains and Value-Added Trade(World Bank, Washington, DC, 2019-04)The spread of global value chains (GVCs) has given rise to new statistical tools, the Inter-Country Input-Output tables and new analytical frameworks aimed at properly identifying production linkages between and within economies. However, several important questions remain unaddressed. This paper proposes a new toolkit for value-added accounting of trade flows at the aggregate, bilateral, and sectoral levels that can be used to investigate a broad set of empirical questions -- including an assessment of the share of trade related to GVCs. The paper shows how different empirical issues require distinct accounting perspectives, and maps these methodologies onto the economic questions they are best suited to address. In this way, in addition to providing novel tools, the paper brings a large part of the related literature under one comprehensive framework.Publication Trade and Production, 1976-99(World Bank, Washington, DC, 2001-11)The authors have prepared this paper as a companion to the Trade and Production database, which contains trade, production, and tariff data for 67 industrial and developing countries at the industry level for 1976-99. The sector disaggregation in the database follows the International Standard Industrial Classification (ISIC), with data provided at the three-digit level (28 industries) for all 67 countries and at the four-digit level (81 industries) for 24 of these countries. The production data are from the United Nations Industrial Development Organization's Industrial Statistics Database at the three- and four-digit level of ISIC. They include value added, total output, average wages, capital formation, number of employees, number of female employees, and number of firms. The trade data are from the United Nations Statistics Division's Commodity Trade (Comtrade) database (through the World Bank's World Integrated Trade Solution, or WITS, software) and include imports and exports. Data on mirror exports (reported by trading partners) were obtained using WITS. The trade data are aggregated by region and income group, as defined by the World Bank. A separate data set provides bilateral trade flows (by partner) at the industry level. The data on average tariffs (most favored nation) are from the Trains database maintained by the United Nations Conference on Trade and Development and from the World Trade Organization's Trade Policy Reviews and Integrated Database. The database also provides an input-output table for each country using data from version 4 of the Global Trade Analysis Project (GTAP) database. The database is available on request on CD-ROM in a series of ASCII files and Microsoft Excel worksheets. It is also available on the Web at http://www.worldbank.org./research/trade.Publication Regional, Multilateral, and Unilateral Trade Policies on MERCOSUR for Growth and Poverty Reduction in Brazil(World Bank, Washington, DC, 2003-05)The authors estimate that the Free Trade Agreement of the Americas (FTAA), the EU-MERCOSUR agreement, and multilateral trade policy changes will all be beneficial for Brazil. The Brazilian government strategy of simultaneously negotiating the FTAA and the EU-MERCOSUR agreement, while supporting multilateral liberalization through the Doha Agenda, will increase the benefits of each of these policies. The authors estimate that the poorest households typically gain roughly three to four times the average for Brazil from any of the policies considerethe United States protects its most highly protected markets. Both the FTAA and the EU-MERCOSUR agreements are net trade-creating for the countries involved, but excluded countries almost always lose from the agreements. The authors estimate that multilateral trade liberalization of 50 percent in tariffs and export subsidies results in gains to the world more than four times greater than either the FTAA or the EU-MERCOSUR agreement. This shows the continued importance to the world trading community of the multilateral negotiations.Publication The Role of Imported Intermediate Inputs in the Indonesian Economy(World Bank, Jakarta, 2015-04)The recent emergence of a persistent deficit in Indonesia s trade balance has triggered concerns over reliance on imports. Notably, imports of intermediate inputs and capital goods have been on the rise over the last decade. Apart from firms partaking in the emergence of global production networks, firms imported intermediates for various reasons, including value, variety, and quality. Concerns may arise about the impact that an increase in reliance on imported inputs may have on domestic jobs, and value added. A careful examination of sector and firm level data from the Indonesian manufacturing sector reveals that: (1) the growth of intermediates imports roughly matches the growth of Indonesian GDP, implying a relatively stable reliance on imported inputs. (2) Users of imported inputs in Indonesia are exceptional performers: they grow faster in terms of output, value added and employment, they are more productive, and they pay higher wages. (3) The increased availability of imported inputs has contributed to improved product quality in Indonesian manufacturing. Larger shares of imported inputs in total inputs, as well as lower tariffs on inputs, are associated with a higher probability of producing high quality goods. (4) Firms product diversification processes have been boosted by lower tariffs on inputs, and by increased usage of imported versions. In light of these results, this note argues that facilitating the import of intermediate products can help the Indonesian economy to diversify, avoid being stuck in low-skilled processing or around natural resource based manufacturing, and to climb up the value chain. Such an approach, however, is not sufficient in isolation and active policies are needed to increase firms absorptive capacities and workers skills.
Users also downloaded
Showing related downloaded files
Publication Digital Progress and Trends Report 2023(Washington, DC: World Bank, 2024-03-05)Digitalization is the transformational opportunity of our time. The digital sector has become a powerhouse of innovation, economic growth, and job creation. Value added in the IT services sector grew at 8 percent annually during 2000–22, nearly twice as fast as the global economy. Employment growth in IT services reached 7 percent annually, six times higher than total employment growth. The diffusion and adoption of digital technologies are just as critical as their invention. Digital uptake has accelerated since the COVID-19 pandemic, with 1.5 billion new internet users added from 2018 to 2022. The share of firms investing in digital solutions around the world has more than doubled from 2020 to 2022. Low-income countries, vulnerable populations, and small firms, however, have been falling behind, while transformative digital innovations such as artificial intelligence (AI) have been accelerating in higher-income countries. Although more than 90 percent of the population in high-income countries was online in 2022, only one in four people in low-income countries used the internet, and the speed of their connection was typically only a small fraction of that in wealthier countries. As businesses in technologically advanced countries integrate generative AI into their products and services, less than half of the businesses in many low- and middle-income countries have an internet connection. The growing digital divide is exacerbating the poverty and productivity gaps between richer and poorer economies. The Digital Progress and Trends Report series will track global digitalization progress and highlight policy trends, debates, and implications for low- and middle-income countries. The series adds to the global efforts to study the progress and trends of digitalization in two main ways: · By compiling, curating, and analyzing data from diverse sources to present a comprehensive picture of digitalization in low- and middle-income countries, including in-depth analyses on understudied topics. · By developing insights on policy opportunities, challenges, and debates and reflecting the perspectives of various stakeholders and the World Bank’s operational experiences. This report, the first in the series, aims to inform evidence-based policy making and motivate action among internal and external audiences and stakeholders. The report will bring global attention to high-performing countries that have valuable experience to share as well as to areas where efforts will need to be redoubled.Publication Global Economic Prospects, January 2024(Washington, DC: World Bank, 2024-01-09)Note: Chart 1.2.B has been updated on January 18, 2024. Chart 2.2.3 B has been updated on January 14, 2024. Global growth is expected to slow further this year, reflecting the lagged and ongoing effects of tight monetary policy to rein in inflation, restrictive credit conditions, and anemic global trade and investment. Downside risks include an escalation of the recent conflict in the Middle East, financial stress, persistent inflation, weaker-than-expected activity in China, trade fragmentation, and climate-related disasters. Against this backdrop, policy makers face enormous challenges. In emerging market and developing economies (EMDEs), commodity exporters face the enduring challenges posed by fiscal policy procyclicality and volatility, which highlight the need for robust fiscal frameworks. Across EMDEs, previous episodes of investment growth acceleration underscore the critical importance of macroeconomic and structural policies and an enabling institutional environment in bolstering investment and long-term growth. At the global level, cooperation needs to be strengthened to provide debt relief, facilitate trade integration, tackle climate change, and alleviate food insecurity.Publication Global Economic Prospects, June 2025(Washington, DC: World Bank, 2025-06-10)The global economy is facing another substantial headwind, emanating largely from an increase in trade tensions and heightened global policy uncertainty. For emerging market and developing economies (EMDEs), the ability to boost job creation and reduce extreme poverty has declined. Key downside risks include a further escalation of trade barriers and continued policy uncertainty. These challenges are exacerbated by subdued foreign direct investment into EMDEs. Global cooperation is needed to restore a more stable international trade environment and scale up support for vulnerable countries grappling with conflict, debt burdens, and climate change. Domestic policy action is also critical to contain inflation risks and strengthen fiscal resilience. To accelerate job creation and long-term growth, structural reforms must focus on raising institutional quality, attracting private investment, and strengthening human capital and labor markets. Countries in fragile and conflict situations face daunting development challenges that will require tailored domestic policy reforms and well-coordinated multilateral support.Publication Global Economic Prospects, January 2025(Washington, DC: World Bank, 2025-01-16)Global growth is expected to hold steady at 2.7 percent in 2025-26. However, the global economy appears to be settling at a low growth rate that will be insufficient to foster sustained economic development—with the possibility of further headwinds from heightened policy uncertainty and adverse trade policy shifts, geopolitical tensions, persistent inflation, and climate-related natural disasters. Against this backdrop, emerging market and developing economies are set to enter the second quarter of the twenty-first century with per capita incomes on a trajectory that implies substantially slower catch-up toward advanced-economy living standards than they previously experienced. Without course corrections, most low-income countries are unlikely to graduate to middle-income status by the middle of the century. Policy action at both global and national levels is needed to foster a more favorable external environment, enhance macroeconomic stability, reduce structural constraints, address the effects of climate change, and thus accelerate long-term growth and development.Publication The Container Port Performance Index 2023(Washington, DC: World Bank, 2024-07-18)The Container Port Performance Index (CPPI) measures the time container ships spend in port, making it an important point of reference for stakeholders in the global economy. These stakeholders include port authorities and operators, national governments, supranational organizations, development agencies, and other public and private players in trade and logistics. The index highlights where vessel time in container ports could be improved. Streamlining these processes would benefit all parties involved, including shipping lines, national governments, and consumers. This fourth edition of the CPPI relies on data from 405 container ports with at least 24 container ship port calls in the calendar year 2023. As in earlier editions of the CPPI, the ranking employs two different methodological approaches: an administrative (technical) approach and a statistical approach (using matrix factorization). Combining these two approaches ensures that the overall ranking of container ports reflects actual port performance as closely as possible while also being statistically robust. The CPPI methodology assesses the sequential steps of a container ship port call. ‘Total port hours’ refers to the total time elapsed from the moment a ship arrives at the port until the vessel leaves the berth after completing its cargo operations. The CPPI uses time as an indicator because time is very important to shipping lines, ports, and the entire logistics chain. However, time, as captured by the CPPI, is not the only way to measure port efficiency, so it does not tell the entire story of a port’s performance. Factors that can influence the time vessels spend in ports can be location-specific and under the port’s control (endogenous) or external and beyond the control of the port (exogenous). The CPPI measures time spent in container ports, strictly based on quantitative data only, which do not reveal the underlying factors or root causes of extended port times. A detailed port-specific diagnostic would be required to assess the contribution of underlying factors to the time a vessel spends in port. A very low ranking or a significant change in ranking may warrant special attention, for which the World Bank generally recommends a detailed diagnostic.