## 2021 EXTERNAL SECTOR REPORT — Chapter 1 (dataset overview)

## Source details

**Canonical URL:** [2021 EXTERNAL SECTOR REPORT — Chapter 1 (dataset overview)](https://www.imf.org/-/media/files/publications/esr/2021/english/data/esr2021-ch01.xlsx)

## Other formats

- [Markdown version](/-/media/files/publications/esr/2021/english/data/esr2021-ch01.xlsx.md)
- [Structured JSON version](/-/media/files/publications/esr/2021/english/data/esr2021-ch01.xlsx.json)

---

### Dataset scope and structure
- Workbook contains multiple worksheets corresponding to figures and tables from CHAPTER 1 of the 2021 EXTERNAL SECTOR REPORT.
- Sample worksheet names include: "ESR Chapter 1 2021", "Table of Contents", "Figure 1.1" through "Figure 1.5.1", and numerous numbered sub-figures (e.g., "Figure 1.1.1", "Figure 1.2.1", "Figure 1.3.1", etc.).
- Worksheets include time series, country-level indicators, panel breakdowns, and per-panel numeric values (quarters, months, indices, percentages, levels).

### Headline time-series and indices (selected values preserved exactly)
- Figure 1.1 (indices; 2017 Q1=100 / 2019 average =100 / 2017 Jan=100):
  - Goods index: 2017q1 = 100; 2017q2 = 101.1357; 2017q3 = 102.189; 2017q4 = 104.087.
  - Services index: 2017q1 = 100; 2017q2 = 103.3489; 2017q3 = 102.3106; 2017q4 = 103.8224.
  - All commodities price index (2019m1 = 99.5778; 2019m2 = 101.2221; 2019m3 = 101.9863; 2019m4 = 104.9688).
  - Oil demand (2019m1 = 100.56592696816055; 2019m2 = 100.05870687491449).
  - Tourism arrivals (2019m1 = 85.59004225582098; 2019m2 = 86.33467349985516; 2019m3 = 96.29875917828247).
  - COVID-19 Cases examples: 2020m1 = 0.6945; 2020m2 = 2.601965; 2020m3 = 22.80174; 2020m4 = 77.1021; 2020m5 = 91.4892; 2020m6 = 141.3409; 2020m7 = 224.3908.

### Country equity, REER, and GDP snapshots (selected country values)
- Figure 1.3 (panels with FXI/GDP, neer change, GDP USD):
  - SWE: FXI/GDP = 0.479911501; neer change = 8.5; GDP USD = 625.9.
  - CHE: FXI/GDP = 20.04196677; neer change = -2.2; GDP USD = 824.7.
  - SGP: FXI/GDP = 30.89638024; neer change = 0.9; GDP USD = 374.4.
  - TUR (Panel 2 example): FXI/GDP = -7.5; neer change = -26.9; GDP USD = 795.

### Portfolio flows and volatility indicators (selected values)
- Figure 1.4:
  - Jan. 2018: VIX (left scale) = 11.06; Emerging market portfolio flows (billions of US dollars, right scale) = 77.34485.
  - Feb. 18: VIX = 22.46; portfolio flows = 24.42626.
  - 2018:Q1 net flows (by region): Emerging Europe excluding Russia = 0.07; Russia = 0.09; China = 0.16; India = 0.04; Emerging Asia excluding China and India = -0.04; Latin America = -0.1; Total = 0.12.

### Tourism, travel balances and COVID impact (selected country values)
- Figure 1.1.1 (tourism share and travel balances):
  - GRD (tourism share example): Tourism share = 48.8; Travel balance = -23.4 (Panel entries show 40.9 and -23.4 in subpanels).
  - MDV: Tourism share = 51.9; Travel balance = 3.9.
  - AIA: Tourism share = 38.9; Current Account Balance = -20.8.

### Country-specific event-period FX and equity moves (selected changes)
- Figure 1.2 (period returns across crisis windows):
  - ARG: Feb. 19 to Mar. 16, 2020 = 2.771001682; Mar. 16 to Dec. 31 = -27.9668554; Jan. 1, 2021 to Jun. 25, 2021 = -12.3667366; Since start of COVID-19 crisis = -35.04812937.
  - TUR: Feb. 19 to Mar. 16, 2020 = -5.319868638; Mar. 16 to Dec. 31 = -19.10684394; Jan. 1, 2021 to Jun. 25, 2021 = -14.22466251; Since start of COVID-19 crisis = -34.6025443.
  - RUS: Feb. 19 to Mar. 16, 2020 = -14.40582179; Mar. 16 to Dec. 31 = -5.769749719; Jan. 1, 2021 to Jun. 25, 2021 = 4.311235526; Since start of COVID-19 crisis = -15.27158897.

### Current account, public/private lending panels (selected country-level entries)
- Figure 1.8 (per-country Current Account, Public Net Lending, Private Net Lending with Log PPP GDP per capita and NGDPD):
  - USA: Current Account = -0.5965268; Log PPP GDP per capita = 11.08603; NGDPD = 20932.75.
  - USA (Public Net Lending) = -10.38691; (Private Net Lending) = 9.052217.
  - GBR: Current Account = 0.5314673; Log PPP GDP per capita = 10.79144; NGDPD = 2710.9704.
  - AUT: Current Account = 0.4782599; Public Net Lending = -9.780752; Private Net Lending = 8.919137.

### Reserves and short-term external financing (selected country values)
- Figure 1.18 (Panel 1 reserves and ST debt + CA deficit as percentage of GDP; Panel 2 changes):
  - ARG: Reserves (Percentage of GDP) = 10.3; ST debt+CA deficit (Percentage of GDP) = 24.2; US dollar GDP = 382.5; Change in Reserves = 0.2; Change in ST debt+CA deficit = 3.7.
  - BRA: Reserves = 24.8; ST debt+CA deficit = 12.5; US dollar GDP = 1434.1; Change in Reserves = 5.8; Change in ST debt+CA deficit = -0.5.
  - CHL: Reserves = 15.5; ST debt+CA deficit = 13.4; US dollar GDP = 252.8; Change in Reserves = 0.9; Change in ST debt+CA deficit = -10.

### Trade policy and tariff series (selected values)
- Figure 1.20 (tariff series):
  - Jan. 2018: "China's tariffs on US exports" = 8; "US tariffs on Chinese exports" = 3.1; "China's tariffs on ROW exports" = 8; "US tariffs on ROW exports" = 2.2.
  - Mar. 18: China's tariffs on US exports = 8; US tariffs on Chinese exports = 3.8; China's tariffs on ROW exports = 8; US tariffs on ROW exports = 2.5.
  - Jul. 18: China's tariffs on US exports = 10.1; US tariffs on Chinese exports = 6.7; China's tariffs on ROW exports = 6.9; US tariffs on ROW exports = 2.9.
  - Aug. 18: China's tariffs on US exports = 14.4; US tariffs on Chinese exports = 8.2; China's tariffs on ROW exports = 6.9; US tariffs on ROW exports = 2.9.

### Household saving, consumption, and government support (selected time-series)
- Figure 1.2.1 (United States household accounts, quarters; values expressed in percentages or index points as provided):
  - 2019:Q1 baseline entries = 0, 0, 0, 0 (Consumption (–), Other gross disposable income, Government support (transfers, taxes), Household saving).
  - 19:Q2 = Consumption (–) = -0.53; Other gross disposable income = -0.22; Government support = -0.09; Household saving = -0.84.
  - 20:Q1 = Consumption (–) = -0.03; Other gross disposable income = 0.83; Government support = 0.2; Household saving = 1.01.

### Crisis episodes and balance adjustments (selected panel medians and ranges)
- Figure 1.5 (changes in Current Account):
  - Panel with "Changes CA in 2017 and 2021" — distribution values: Min = -2.120431; Q1 = -0.7798813; Med = 0.0464294; Q3 = 0.5617272; Max = 2.477909 (labelled "2017–19").
  - Figure 1.11 (Sum of absolute current account balances, Panel 1): 2015 = 3.5676; 2016 = 3.2429; 2017 = 3.0154; 2018 = 3.022.

### Cross-sectional policy and normative components (selected desired-policy decompositions)
- Figure 1.13 (EBA norm and other desired policies, selected country rows):
  - CHE: EBA norm = 5.599105834; Other desired policies1 = 1.555305834; NFA = -0.05745; Demographics = 0.79154.
  - JPN: EBA norm = 3.593803534; Other desired policies1 = -0.220006466; NFA = -0.05745; Demographics = 1.38511.
  - RUS: EBA norm = 3.200056534; Other desired policies1 = -0.188703466; Oil = 1.05981; Reserve currency = 0.

*Dataset: esr2021-ch01 (worksheets and sample numeric values extracted from the workbook for CHAPTER 1 of the 2021 EXTERNAL SECTOR REPORT).*

---


_Source: https://www.imf.org/-/media/files/publications/esr/2021/english/data/esr2021-ch01.xlsx_