## esr2020-ch01 (dataset overview)

## Source details

**Canonical URL:** [esr2020-ch01 (dataset overview)](https://www.imf.org/-/media/files/publications/esr/2020/english/data/esr2020-ch01.xlsx)

## Other formats

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

---

### Scope and structure
- Workbook contains multiple worksheets representing data and figure tables used in "2020 EXTERNAL SECTOR REPORT" (ESR Chapter 1).
- Sample worksheet names (as provided): "ESR Chapter 1 2020", "Table of Contents", "Figure 1.1" through "Figure 1.17", and multiple sub-figure worksheets including "Figure 1.2.1", "Figure 1.2.2", "Figure 1.2.3", "Figure 1.3.1", "Figure 1.4.1", "Figure 1.4.2", "Figure 1.5.1", "Figure 1.5.2", "Figure 1.6.1".
- Row and column counts (examples):
  - "ESR Chapter 1 2020": rowCount 32, columnCount 10.
  - "Table of Contents": rowCount 38, columnCount 14.
  - "Figure 1.2.1": rowCount 1113, columnCount 14.
  - "Figure 1.2.3": rowCount 731, columnCount 14.

### Key figures, panels, and variables included
- Figure 1.1 (sample columns / panel labels): includes "Panel 1" and country/group columns such as "CHN", "DEU/NLD", "JPN", "Surplus AEs", "Other surplus", "Oil exporters", "USA", "GBR", "Deficit EMs", "AE commodity exporters", "Other deficit", "EA (other)", "Discrepancy", "Overall balances (right scale)".
  - Sample data row for year label "1990": 0, 0.25, 0.19, 0.08, 0.16, 0.12, -0.34, -0.16, -0.13, -0.16, -0.26, -0.24, -0.486, 2.062
  - Sample row with year cell "91": 0, -0.08, 0.28, 0.08, 0.21, -0.22, 0.01, -0.07, -0.11, -0.14, -0.34, -0.25, -0.631, 1.791
- Figure 1.2 (sample columns / panel labels): includes "USA", "CHN", "DEU/NLD", "JPN", "EA (other)", "GBR", "Creditor AEs", "Oil exporters", "AE commodity exporters", "Debtor EMs", "Other debtors", "Other creditors", "Discrepancy".
  - Sample data row for "1990" (with additional year field 1990): -1.07, 0.02, 1.63, 1.39, -1.71, -0.15, 1.72, 1.46, -1.8, -1.74, -3.13, 0.99, -2.392
  - Sample row for "1997" (with year 1997): -2.72, -0.15, 0.34, 3.01, -0.31, -0.31, 1.86, 1.32, -1.4, -2.27, -4.31, 1.82, -3.105
- Figure 1.3 (panels for CA gaps and REER gaps):
  - Example entries: "BEL" EBA CA gap 2019 = -3.5; "SAU" EBA REER gap 2019 = 10; "USA" EBA REER gap 2019 = 10.1; other sample values include -2.5, -2, -1.8, -2.4, -4.2, -0.9.
- Figure 1.4 (scatter X/Y sample points):
  - "ARG": X = -2, Y = -1.5
  - "AUS": X = 0.8, Y = -4
  - "CHN": X = 1, Y = -2
  - "EA": X = 1.2, Y = -2.8
- Figure 1.5 (country panels with GDP and other measures):
  - "CHN": y = 0.2, x = 0.8, GDP value 14587.18, additional columns -1.5, -0.5
  - "USA": y = 0.1, x = -1.4, GDP value 21427.68, additional columns 9, 2
  - "ARG": y = 1, x = -3, GDP value 448.6669, additional columns -12.5, 11
- Figure 1.6 (panels comparing GFC and COVID-19 indices and forecasts):
  - Panel sample: "GFC: value (Jul 2008 = 100)" and "COVID-19: value (Dec 2019 = 100)".
  - Example data row index 0: Panel values 100, 100, 100, 100; year field 2017; global breakdowns 52.559, 54.1029, 50.5466, 50.9629; Panel 2 forecast "Data and forecast for 2020" shows -7.1, -8.9, -7.5, 5 (and year 1980, -0.05, 0 in other columns).
- Figure 1.7 (financial market panel with date ranges):
  - Country sample "MEX": February 19 to March 16 = -18.5501, Since March 16 = 5.742244, Since February 19 = -13.873
  - "RUS": February 19 to March 16 = -14.4058, Since March 16 = 7.910563, Since February 19 = -7.63484
- Figure 1.8 (multiple panels for EMDE commodity exporters, NEER_change, NGDPD):
  - Example country rows:
    - "Turkey": ifs_code 186, iso2code "TR", BROAD_B_RES = -32, NEER_change = -9, NGDPD = 787.8
    - "South Africa": ifs_code 199, iso2code "ZA", BROAD_B_RES = -4, NEER_change = -16, NGDPD = 354.4
    - "Argentina": ifs_code 213, iso2code "AR", BROAD_B_RES = -5, NEER_change = 8, NGDPD = 530.3
- Figure 1.9 (commodity price indices, panels for Jan. 2008 and Jan. 2019):
  - Jan. 2008 panel values: Food 87.46677, Raw materials 91.61968, Metals 97.98208, Energy 68.72987
  - Jan. 2019 panel values: Food 95.35418, Raw materials 101.3181, Metals 87.46651, Energy 104.621
- Figure 1.10 (tourism/travel indices and export/import/current account impacts):
  - Jan. 2019: Hotel reservations 100, International travel 100, International tourism arrivals 100; ISO "THA": Impact on exports -7.97, Impact on imports 1.87, Impact on current account -6.09
  - Mar. 19: Hotel reservations 116, International travel 110, International tourism arrivals 111; ISO "PRT": Impact on exports -6.24, Impact on imports 1.8, Impact on current account -4.45
- Figure 1.11 (remittances and net current account impacts; panel 1 series):
  - Panel 1 includes seasonally adjusted total (example 2006 value 4.593).
  - Sample country impacts: "GTM" impact on remittance inflows -2.67, outflows 0, net -2.67; "PAK" -1.79, 0.01, -1.78; "EGY" -1.74, 0.04, -1.7
- Figure 1.12 (panel time series with monthly timestamps and country group contributions):
  - Sample timestamp "2003-01-15T00:00:00.000Z" with series values: USA -1.54, GBR -0.22, Deficit EMs 0.09, AE commodity exporters 0.05, Other deficit -0.08, EA (other) -0.08, CHN -0.02, DEU/NLD 0.43, JPN 0.19, Surplus AEs 0.13, Other surplus 0.1, Oil exporters 0.65
- Figure 1.13 (change in overall balance and panels CA and nid):
  - Panel 1 (CA) 2009 row: 2009, -0.26, 0, 0.02, 0.1, 0.13, -0.74, 0.45, 0.05, 0.09, -0.06, 0.1, 0.23, -1.61
  - Panel 1 (CA) 2020 row: 2020, 0.08, -0.09, -0.02, -0.08, -0.13, -0.38, 0.08, 0.01, 0.08, -0.02, 0.03, 0.05, -0.33
  - Panel 2 (nid) 2009 row: 2009, 0.78, -0.25, -0.09, -0.16, -0.13, -0.31, -0.61, -0.22, -0.09, -0.12, -0.23, -0.6, -2.03
  - Panel 2 (nid) 2020 row: 2020, 0.72, -0.04, 0.04, -0.03, -0.02, -0.14, 0.016, -0.16, -0.21, -0.09, -0.01, -0.41, -0.32
- Figure 1.14 (reserves, short-term debt + current account deficit, GDP in USD):
  - "ARG": Reserves (percent of GDP) 10, short-term debt + current account deficit (percent of GDP) 25.4, GDP in USD 448.7
  - "IND": Reserves 15.7, short-term debt + current account deficit 10.4, GDP in USD 3035.3
- Figure 1.15 (trade percent of GDP and GVC participation):
  - 1980 row: Trade, percent of GDP 38.1, Overall GVC participation, percent of global trade 41.4
  - Additional sample values: 37.5, 35.9, 34.1, 34.8, 33.6, 31.8, 32.9, 33.3, 33.3 with overall GVC around 40.87–41.32 range in examples
- Figure 1.16 (net flows by goods/services/investment):
  - Panel 1 sample 2009: Net total 0, Goods 0, Services 0, Investment 0
  - Other sample rows include numeric panels like 10 → 96, 97, -1, 0 and 2011 → 82, 78, 2, 2
- Figure 1.17 (change in monetary base, COVID-19 crisis panel):
  - "MYS" Malaysia: -1.68
  - "CHN" China: -1.01
  - "BRA" Brazil: -0.76
  - "MEX" Mexico: 0.3
  - "GTM" Guatemala: 0.41

### Notable time series, indices and date formats
- Time stamps use ISO 8601 format in many panels, e.g., "2017-01-15T00:00:00.000Z", "2003-01-15T00:00:00.000Z", "2020-01-15T00:00:00.000Z", "2020-02-26T00:00:00.000Z".
- Several panels use index baselines such as "Jul 2008 = 100" or "Dec 2019 = 100".
- Panel and sub-figure numbering includes multi-level figures (e.g., Figure 1.2 with sub-figures 1.2.1, 1.2.2, 1.2.3).

### Data types and recurring variables (observed in samples)
- Country and group identifiers (e.g., CHN, USA, GBR, DEU/NLD, EA (other)).
- Macroeconomic series: current account components, NEER_change, NGDPD, GDP in USD, reserves (percent of GDP), short-term debt + current account deficit (percent of GDP).
- Price and commodity indices: Food, Raw materials, Metals, Energy, Oil price.
- Financial market indicators: Mutual fund flows, VIX, stock price exposure measures, median and 95th percentile VIX.
- Tourism/travel indices and associated impacts on exports/imports/current account.
- Remittances: impact on remittance inflows/outflows and net current account impact.
- Event-dated announcement or policy variables (e.g., "US announcements", "China announcements", "Impact of trade policy news", "Actual change in RMB-USD exchange rate").

### Usage notes (based on worksheet samples)
- Larger time-series panels (e.g., "Figure 1.2.1" with rowCount 1113) indicate high-frequency/date-indexed data suitable for time-series analysis and event studies.
- Country-level panels provide cross-sectional snapshots with numeric indicators suitable for comparative analysis (examples include GDP in USD, BROAD_B_RES, NEER_change).
- Index baselines and consistent date formatting support merging with other time-series datasets that use ISO 8601 timestamps.

*Source: https://www.imf.org/-/media/files/publications/esr/2020/english/data/esr2020-ch01.xlsx*

---


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