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 Intergenerational Income Mobility around the World(Washington, DC: World Bank, 2025-07-09)This paper introduces a new global database with estimates of intergenerational income mobility for 87 countries, covering 84 percent of the world’s population. This marks a notable expansion of the cross-country evidence base on income mobility, particularly among low- and middle-income countries. The estimates indicate that the negative association between income mobility and inequality (known as the Great Gatsby Curve) continues to hold across this wider range of countries. The database also reveals a positive association between income mobility and national income per capita, suggesting that countries achieve higher levels of intergenerational mobility as they grow richer.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 Engineering Ukraine’s Wirtschaftswunder(Washington, DC: World Bank, 2025-07-29)As Ukraine emerges from the devastation of war, it faces a historic opportunity to engineer its own Wirtschaftswunder—a productivity-driven economic transformation akin to post-war West Germany. While investment-led growth may offer quick wins, it is efficiency, innovation, and institutional reform that will determine Ukraine’s long-term economic trajectory. Drawing on rich micro-level firm data spanning 25 years, this paper uncovers deep structural distortions that have suppressed creative destruction and productivity in Ukraine. It finds that business dynamism is on the decline, alongside rising market concentration among incumbent businesses, including low productivity state owned enterprises. To inform priorities for reviving business dynamism, this study develops a model of creative destruction drawing on Acemoglu et al. (2018) and Akcigit et al. (2021). The quantitative assessment highlights that policies that discipline entrenched incumbents are the bedrock for reviving business dynamism and engineer Ukraine’s Wirtschaftswunder. Policies targeting specific types of firms have limited efficacy when incumbents run wild.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 Disentangling the Key Economic Channels through Which Infrastructure Affects Jobs(Washington, DC: World Bank, 2025-04-03)This paper takes stock of the literature on infrastructure and jobs published since the early 2000s, using a conceptual framework to identify the key channels through which different types of infrastructure impact jobs. Where relevant, it highlights the different approaches and findings in the cases of energy, digital, and transport infrastructure. Overall, the literature review provides strong evidence of infrastructure’s positive impact on employment, particularly for women. In the case of electricity, this impact arises from freeing time that would otherwise be spent on household tasks. Similarly, digital infrastructure, particularly mobile phone coverage, has demonstrated positive labor market effects, often driven by private sector investments rather than large public expenditures, which are typically required for other large-scale infrastructure projects. The evidence on structural transformation is also positive, with some notable exceptions, such as studies that find no significant impact on structural transformation in rural India in the cases of electricity and roads. Even with better market connections, remote areas may continue to lack economic opportunities, due to the absence of agglomeration economies and complementary inputs such as human capital. Accordingly, reducing transport costs alone may not be sufficient to drive economic transformation in rural areas. The spatial dimension of transformation is particularly relevant for transport, both internationally—by enhancing trade integration—and within countries, where economic development tends to drive firms and jobs toward urban centers, benefitting from economies scale and network effects. Turning to organizational transformation, evidence on skill bias in developing countries is more mixed than in developed countries and may vary considerably by context. Further research, especially on the possible reasons explaining the differences between developed and developing economies, is needed.
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 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 Business Ready 2024(Washington, DC: World Bank, 2024-10-03)Business Ready (B-READY) is a new World Bank Group corporate flagship report that evaluates the business and investment climate worldwide. It replaces and improves upon the Doing Business project. B-READY provides a comprehensive data set and description of the factors that strengthen the private sector, not only by advancing the interests of individual firms but also by elevating the interests of workers, consumers, potential new enterprises, and the natural environment. This 2024 report introduces a new analytical framework that benchmarks economies based on three pillars: Regulatory Framework, Public Services, and Operational Efficiency. The analysis centers on 10 topics essential for private sector development that correspond to various stages of the life cycle of a firm. The report also offers insights into three cross-cutting themes that are relevant for modern economies: digital adoption, environmental sustainability, and gender. B-READY draws on a robust data collection process that includes specially tailored expert questionnaires and firm-level surveys. The 2024 report, which covers 50 economies, serves as the first in a series that will expand in geographical coverage and refine its methodology over time, supporting reform advocacy, policy guidance, and further analysis and research.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 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.