## ESR 2021 — Chapter 2 dataset overview ## Source details **Canonical URL:** [ESR 2021 — Chapter 2 dataset overview](https://www.imf.org/-/media/files/publications/esr/2021/english/data/esr2021-ch02.xlsx) ## Other formats - [Markdown version](/-/media/files/publications/esr/2021/english/data/esr2021-ch02.xlsx.md) - [Structured JSON version](/-/media/files/publications/esr/2021/english/data/esr2021-ch02.xlsx.json) --- ### Worksheets (structure and purpose) - "ESR Chapter 2": 32 rows, 10 columns. Header rows contain repeated text "International Monetary Fund" and "2021 EXTERNAL SECTOR REPORT". - "Table of Contents": 26 rows, 14 columns. Contains references via formulas to "'ESR Chapter 2'!B6:J6" and "'ESR Chapter 2'!B23:J23" that produce "2021 EXTERNAL SECTOR REPORT" and "CHAPTER 2.". - Multiple "Figure ..." worksheets provide panelled time series and scenario outputs used in Chapter 2 figures (examples shown below). Each figure worksheet includes a year/time column and one or more series columns with numeric values. ### Figure 2.1 (sample rows and fields) - Columns (from sample row): year, Number of cases, Budgetary impact, ifs_code - Sample rows: - year: 1978; Number of cases: 1; ifs_code: 186 - year: 1978; ifs_code: 922 - year: 1978; ifs_code: 536 - year: 1978; ifs_code: 518 - year: 1978; ifs_code: 754 - year: 1978; ifs_code: 643 - year: 1978; ifs_code: 634 - year: 1978; ifs_code: 146 - year: 1978; ifs_code: 313 ### Figure 2.2 (Panel 1: Current Account) - Column names (sample): year, i, ihi, ilo - Sample rows: - year: -1; i: 0; ihi: 0; ilo: 0 - year: 0; i: 0.5156898; ihi: 0.705482; ilo: 0.3258977 - year: 1; i: 0.6722615; ihi: 0.8750992; ilo: 0.4694238 - year: 2; i: 0.6267831; ihi: 0.8244667; ilo: 0.4290996 - year: 3; i: 0.6042337; ihi: 0.8081761; ilo: 0.4002913 ### Figure 2.3 (multiple panels: Current Account, REER, Export volume, Import volume, REAL GDP, REAL Investment) - Column headers indicate panel layout and subgroup labels (e.g., "Post-GFC", "Pre-GFC") and series names like i, ihi, ilo, i1. - Sample rows for year 0 and 1 (Panel 1 Current Account and other panels): - year: 0; Current Account i: 0.7341207; ihi: 0.9820583; ilo: 0.486183 - year: 0; REER (Pre/Post-GFC) sample value: -1.697775 - year: 1; Current Account i: 0.8225002; ihi: 1.064662; ilo: 0.5803385 - year: 1; REER (Post-GFC) sample value: -1.88633 ### Figure 2.4 (Domestic Consolidation) - Column names: year, Capital income taxes, Labor Taxes, Consumption Taxes, General transfers, Targeted transfers, Government consumption, Government investment - Sample rows: - year: -1; Capital income taxes: 0; Labor Taxes: 0; Consumption Taxes: 0; General transfers: 0; Targeted transfers: 0; Government consumption: 0; Government investment: 0 - year: 0; Capital income taxes: 0.54309911; Labor Taxes: 0.27451858; Consumption Taxes: 0.29052672; General transfers: 0.320248; Targeted transfers: 0.369157; Government consumption: 0.30434698; Government investment: 0.492231 - year: 1; Capital income taxes: 0.76996583; Labor Taxes: 0.29892999; Consumption Taxes: 0.3188422; General transfers: 0.344577; Targeted transfers: 0.347985; Government consumption: 0.28542519; Government investment: 0.513893 - year: 2; Capital income taxes: 0.98727947; Labor Taxes: 0.3652865; Consumption Taxes: 0.39293498; General transfers: 0.424283; Targeted transfers: 0.405449; Government consumption: 0.36441618; Government investment: 0.613666 ### Figure 2.5 (scenario comparisons: openness, share, flexibility) - Column names: year, High openness, Low openness, High share, Low share, Higher flexilbility, Lower flexilbility - Sample rows: - year: -1; all series: 0 - year: 0; High openness: 0.618115; Low openness: 0.325583; High share: 0.831543; Low share: 0.450518; Higher flexilbility: 0.476024; Lower flexilbility: 0.73779 - year: 1; High openness: 0.637109; Low openness: 0.369301; High share: 0.791234; Low share: 0.431863; Higher flexilbility: 0.489943; Lower flexilbility: 0.854355 - year: 2; High openness: 0.688249; Low openness: 0.419495; High share: 0.807146; Low share: 0.506477; Higher flexilbility: 0.580381; Lower flexilbility: 0.875576 ### Figure 2.6 (Current account deficit vs surplus economies) - Columns: year, Current account deficit economies, Current account surplus economies - Sample rows: - year: 2019; Current account deficit economies: 0; Current account surplus economies: 0 - year: 20; Current account deficit economies: -4.650252; Current account surplus economies: -4.474223 - year: 21; Current account deficit economies: -4.729645; Current account surplus economies: -3.492589 - year: 22; Current account deficit economies: -2.392366; Current account surplus economies: -1.623431 - year: 23; Current account deficit economies: -0.9946752; Current account surplus economies: -1.061417 - year: 24; Current account deficit economies: -0.4396868; Current account surplus economies: -0.756887 - year: 25; Current account deficit economies: -0.2051888; Current account surplus economies: -0.4200046 - year: 26; Current account deficit economies: 0.0178399; Current account surplus economies: -0.1798904 ### Figure 2.7 and Figure 2.8 (country-level fiscal balance and current account impacts) - Figure 2.7 sample columns and values (Panel 1 and Panel 2 layout): - Average 2020-2021 entries include country abbreviations and numeric values: - "JPN": -7.332154; "Change in Fiscal Balance": -2.545; "Current Account Impact": 0 - "CHN": 1.258859; "Change in Fiscal Balance": 0.63; "Current Account Impact": 0 - "ZAF": -1.788993; "Change in Fiscal Balance": -0.785; "Current Account Impact": 0 - "Rest of world": -0.5562615; "Change in Fiscal Balance": -0.41; "Current Account Impact": 0 - "ITA": -5.8137755; "Change in Fiscal Balance": -2.29; "Current Account Impact": 0 - "ARG": 0.1156757; "Change in Fiscal Balance": -0.51; "Current Account Impact": 0 - "MEX": -0.7523031; "Change in Fiscal Balance": -0.42; "Current Account Impact": 0 - "AUS": -4.5999455; "Change in Fiscal Balance": -1.23; "Current Account Impact": 0 - Figure 2.8 sample rows map Average 2020-2021 to 2026 projections for selected countries: - "JPN": -7.332154; "Change in Fiscal Balance" (2020): -1.44; "Current Account Impact": 0; "CHN": 1.258859; "Change in Fiscal Balance" (2026): 0.77; "Current Account Impact": 0 - "ZAF": -1.788993; "Change in Fiscal Balance": -0.135; "Current Account Impact": 0 - "ITA": -5.8137755; "Change in Fiscal Balance": -0.995; "Current Account Impact": 0 - "ARG": 0.1156757; "Change in Fiscal Balance": 0.585; "Current Account Impact": 0 ### Figures 2.9–2.12 and Figures 2.1.1–2.1.2 (baseline and scenario time series) - Figure 2.9 (WEO baseline vs netting out fiscal impact) sample: - 2019: WEO baseline: 2.546966; Netting out fiscal impact: 2.546966 - 20: WEO baseline: 2.911894; Netting out fiscal impact: 3.035803 - 21: WEO baseline: 3.083853; Netting out fiscal impact: 2.698542 - Figure 2.10 (WEO baseline and alternate consolidation scenarios) sample: - 2019: 2.546966 - 2020: 2.911894 - 2021: 3.083853; CA surplus/deficit alternate values: 3.083853, 3.083853 - 2022: WEO baseline: 2.962272; "CA surplus economies consolidate more": 3.403825; "CA deficit economies consolidate more": 2.681786 - 2023: WEO baseline: 2.75546; alternates: 3.45667, 2.345932 - Figure 2.11 (WEO baseline and expansion scenarios) sample: - 2019: 2.546966 - 2020: 2.911894 - 2021: 3.083853; alternates equal 3.083853 - 2022: WEO baseline: 2.962272; "CA deficit economies expand more": 3.250474; "CA surplus economies expand more": 2.525362 - 2025: WEO baseline: 2.423489; alternates: 2.958208, 1.776446 - Figure 2.12 (Synchronized public investment push) sample: - 2019: 2.546966 - 2020: 2.911894 - 2021: 3.083853; alternate: 3.083853 - 2022: WEO baseline: 2.962272; alternate: 2.954866 - 2023: WEO baseline: 2.75546; alternate: 2.770556 - 2024: WEO baseline: 2.574397; alternate: 2.628669 - Figure 2.1.1 (time responses) sample: - time: 0; Current account: 0.085472; Export volume: 0.946801; Import volume: 0.150878; Real exchange rate: 0.130982; Real GDP: 0.000764; Real investment: 0.017058 - time: 1; Current account: 0.202244; Export volume: 0.89021; Import volume: 0.012014; Real exchange rate: 0.048676; Real GDP: 0.000342; Real investment: 0.000123 - time: 5; Current account: 0.001653; Export volume: 0.289071; Import volume: 0.31437; Real exchange rate: 0.467835; Real GDP: 0.001567; Real investment: 0.090828 - Figure 2.1.2 (Panel 1: Individual fiscal consolidation vs Global fiscal consolidation) - Sample rows show pairs of values: - 0, 0 - -1.9, 1.1 - -1.8, 1 - -1.5, 0.9 - -1.2, 0.8 - -1, 0.7 - -0.8, 0.6 ### Key dataset characteristics (usage notes) - Many worksheets encode panelled figure data with time indices (year or time) and multiple scenario or subgroup series (labels include i, ihi, ilo, i1, Post-GFC, Pre-GFC, country codes). - Numeric precision is preserved in the sheets (values include many decimal places, e.g., 0.54309911, -7.332154, 2.546966). - Country-level and scenario comparisons are provided for Average 2020-2021 and projections to 2026 in relevant figures. *Dataset: esr2021-ch02 (Chapter 2 figures and tables as extracted from the provided Excel sample).* --- _Source: https://www.imf.org/-/media/files/publications/esr/2021/english/data/esr2021-ch02.xlsx_