## Dataset: ch1data (2022 EXTERNAL SECTOR REPORT — Chapter 1 dataset)

## Source details

**Canonical URL:** [Dataset: ch1data (2022 EXTERNAL SECTOR REPORT — Chapter 1 dataset)](https://www.imf.org/-/media/files/publications/esr/2022/data/ch1data.xlsx)

## Other formats

- [Markdown version](/-/media/files/publications/esr/2022/data/ch1data.xlsx.md)
- [Structured JSON version](/-/media/files/publications/esr/2022/data/ch1data.xlsx.json)

---

### Dataset overview
- Type: dataset (XLSX)
- Primary worksheet names (as present in the file): "ESR Chapter 1 2022", "Table of Contents", and multiple figure worksheets (e.g., "Figure 1.1", "Figure 1.2", ..., "Figure 1.4.2").
- Row and column counts for sampled worksheets:
  - "ESR Chapter 1 2022": rowCount 32, columnCount 10
  - "Table of Contents": rowCount 51, columnCount 14
  - "Figure 1.1": rowCount 283, columnCount 34
  - "Figure 1.2": rowCount 118, columnCount 26
  - "Figure 1.3": rowCount 33, columnCount 26
  - "Figure 1.4": rowCount 48, columnCount 20
  - (Additional figure worksheets with varying rowCount and columnCount as listed in the file)

### Contents and structure (major themes and panels)
- The workbook is organized around Chapter 1 figures and subfigures (Panels), with many worksheets encoding panel labels and time-series data.
- Typical panels and themes include:
  - Commodity price indices and subcomponents (Panel labels such as "Wheat", "Rice", "Corn", "Sorghum", "Oil price", "Oil demand", "All commodities price index", "Energy prices", "Industrial production").
  - Oil trade balances and current account aggregates for importers and exporters.
  - Country-level current account, investment, and savings entries (country codes shown, e.g., "TUR", "POL", "KOR", "ITA", "NLD", "IND", "CHE", "ESP", "DEU").
  - Sectoral decomposition of demand (Services, Durable Goods, Nondurables) split by AEs and EMDE.
  - Comparisons of WEO (World Economic Outlook) vintages (Jun. 2020 WEO, Jan. 2020 WEO, Jan. 2022 WEO, Apr. 2022 WEO).
  - Household saving and investment medians by quarter.
  - Regional/current-account group decompositions (USA, CHN, DEU/NLD, JPN, EA (other), GBR, Surplus AEs, Oil exporters, AE commodity exporters, Deficit EMs, Other deficit, Other surplus).
  - Financial flows: "Net Portfolio Flows", "FDI Flows", VIX and emerging market portfolio flows by region.
  - Reserve adequacy and external balance assessment components (EBA norm, Net foreign assets, Demographics, Oil, Other fundamentals, Desirable policies).
  - EBA CA gap, IMF staff–assessed CA gap ranges (Floor and Top).
  - Panels on valuation, net lending, change in net financial wealth (quarterly panels: "2020: Q1", "2020: Q2", "2020: Q3", "2020: Q4", "2021: Q1", "2021: Q2", "2021: Q3").
  - Distributional and wealth-change tables (Top 1, Next 9, Next 40, Bottom 50).
  - Country-level reserve, short-term debt, CA deficit, portfolio and other investment liabilities, and 2022 changes for multiple countries (examples include ARG, BRA, CHL, COL, CRI, EGY, HUN).
  - Panels labeled "Panel 1", "Panel 2", etc., repeated across many figure worksheets.

### Key numeric samples (preserved exactly as in the dataset samples)
- Figure 1.1 (selected index base and values)
  - "Jan. 2020" — Wheat: 100; Rice: 100; Sorghum: 100
  - "Jan. 2019" — Oil price: 90.10914; Oil demand: 108.07
  - Sample index values: 96.6278; 100.4033; 98.21346; 98.77802; 96.47571; 98.74; 100.9376; 101.2664; 104.3113
  - July. 20 — Wheat: 95.69817; Rice: 108.3908; Corn: 88.8097; Sorghum: 105.2056
- Figure 1.2 (oil and current-account series, 2011–2021)
  - "Oil trade balance of importers" (2011–2021 samples): -3.35469; -3.75174; -3.4556; -3.25019; -2.10505; -1.64206; -2.01335; -2.49614; -2.25811; -1.48827; -2.23075
  - "Oil trade balance of exporters" (2011–2021 samples): 13.01829; 12.69601; 11.99767; 11.02675; 7.845863; 6.708076; 7.722682; 9.230734; 8.006604; 5.751865; 7.862992
  - "Current account of importers" (2011–2021 samples): -0.63096; -0.68196; -0.09619; 0.169549; 0.752102; 0.772546; 0.643205; 0.117988; 0.466006; 1.366509; 1.110943
  - "Current account of exporters" (2011–2021 samples): 6.134951; 4.747758; 3.391262; 2.296051; -0.79495; -0.54892; 0.68233; 2.390259; 0.703895; -0.34529; 3.423309
- Figure 1.3 (country-level current account and savings/investment samples)
  - TUR: Current account commodity importers: -5.4939; Investment: -2.2182; Savings: -3.29584
  - POL: -2.3988; Investment: -0.53874; Savings: -1.86006
  - KOR: -2.26574; Investment: -1.46341; Savings: -0.80233
  - ITA: -1.49594; Investment: -1.66343; Savings: 0.23796
  - NLD: -1.39822; Investment: 0.7424; Savings: -2.14062
  - IND: -1.38055; Investment: -1.5402; Savings: 0.15966
  - CHE: -1.10707; Investment: -0.68358; Savings: -0.42348
  - ESP: -1.03125; Investment: -0.04107; Savings: -0.99017
  - DEU: -0.88046; Investment: -0.55962; Savings: -0.32084
- Figure 1.4 (trade composition samples)
  - Panel labels show AEs and EMDE split for Services, Durable Goods, Nondurables with sample "2019:Q1" baseline set to 0 and "2019q2" entries such as -0.1481819; -0.0854263; 0.1243839; -0.1125031; 0.023798; 0.1979294
- Figure 1.5 (WEO vintage index samples)
  - 2019 baseline: 100
  - 2020: Jun. 2020 WEO 89.34566; Jan. 2020 WEO 103.2043; Jan. 2022 WEO 94.99944; Apr. 2022 WEO 95.00079
  - 2021: Jun. 2020 WEO 96.21059; Jan. 2020 WEO 107.275; Jan. 2022 WEO 105.6154; Apr. 2022 WEO 106.3182
  - 2022: Jun. 2020 WEO 101.2268; Jan. 2020 WEO 111.5897; Jan. 2022 WEO 111.0569; Apr. 2022 WEO 112.4388
  - 2023: Jun. 2020 WEO 105.5125; Jan. 2020 WEO 116.1083; Jan. 2022 WEO 115.9385; Apr. 2022 WEO 116.9531
- Figure 1.6 (household saving and investment medians by quarter)
  - 2019:Q1: Savings: 0; Investment: 0
  - 2020:Q1 — Saving: 2.14; median: 1.46; Investment: 2.35; other entries include Q2 Saving: 6.35; 4.88; Investment: 9.4
  - Q3 Saving: 3.13; 1.92; Investment: 4.24
  - Q4 Saving: 4.41; 2.94; Investment: 5.6
- Figure 1.7 (regional contribution samples, 2018–2019)
  - 2018 sample row: USA -1.14; CHN 0.77; DEU/NLD 0.48; JPN 0.05; EA (other) -0.02; GBR -0.31; Surplus AEs 0.14; Oil exporters 0.78; AE commodity exporters 0; Deficit EMs -0.29; Other deficit -0.18; Other surplus 0.06
  - 2019 sample row: USA -1.17; CHN 0.77; DEU/NLD 0.44; JPN -0.08; EA (other) -0.01; GBR -0.25; Surplus AEs 0.21; Oil exporters 0.68; AE commodity exporters -0.01; Deficit EMs -0.27; Other deficit -0.19; Other surplus 0
- Figure 1.8 (sample headline CA and staff gaps)
  - "Jul. 2022" row: 3.55; 3.23; 3.01; 3.06; 2.81; 3.04; 3.45; 3.79; 3.3; 2.95; 2.7
  - "Netting out impact of COVID-19 factors" row: 3.55; 3.23; 3.01; 3.06; 2.81; 2.62; 2.87
  - "COVID-19 factors" row: 0.42; 0.58
- Figure 1.10 (country-specific changes by periods)
  - RUS: Jan. 1, 2021 – Dec. 31, 2021 = 3.9; Jan. 3, 2022 – Feb. 23, 2022 = -8.5; Feb. 24, 2022 – June 27, 2022 = 63.7; Jan. 1, 2021 – June 27, 2022 = 54
  - SAU: 4.4; 0; 5.2; 10.6 (same columns)
  - BRA: -1.9; 13.4; 2.4; 10.4
  - CHN: 7.9; 0.5; -1; 8.5
  - USA: 3.3; -0.5; 4.3; 8.4
- Figure 1.11 (FX intervention/GDP and NEER change samples)
  - TUR: FXI/GDP -0.2; neer change -25.9
  - ZAF: FXI/GDP 1; neer change -3.5
  - ARG: FXI/GDP -0.2; neer change -8.9
  - BRA: FXI/GDP 0.1; neer change 3.1
  - MEX: FXI/GDP 0.2; neer change 0
  - IND: FXI/GDP 0.3; neer change -1.6
  - IDN: FXI/GDP 0.6; neer change 3
  - MYS: FXI/GDP 2.5; neer change -0.8
  - THA: FXI/GDP 0.1; neer change -6.7
- Figure 1.12 (portfolio flows and FDI panel samples)
  - VIX Jan. 2018: 11.06; Emerging market portfolio flows Jan. 2018: 77.34485
  - "Jan. 2018" FDI panel entry: "2018:Q1" 0.1; 0.1; 0.2; 0; 0; -0.1; -0.1; 0.1
  - "Feb. 18" VIX: 22.46; emerging portfolio flows: 24.42626; "18:Q2" FDI sample row: -0.1; -0.1; 0.9; -0.1; 0.1; -0.2; 0.1; 0.5
- Figure 1.13 (long-run current account panel samples, 1990–1996)
  - 1990 row: USA -1.06; CHN 0.02; DEU/NLD 1.62; JPN 1.38; EA (other) -1.71; GBR -0.15; Surplus AEs 1.71; Oil exporters 1.45; AE commodity exporters -1.79; Deficit EMDEs -1.68; Other deficit -3.14; Other surplus 1; Discrepancy -2.357
  - 1991 row: USA -1.37; CHN 0.07; ... Discrepancy -3.222
  - 1992 row: ... Discrepancy -3.717
  - 1993 row: ... Discrepancy -3.251
  - 1994 row: ... Discrepancy -2.863
  - 1995 row: ... Discrepancy -3.094
  - 1996 row: ... Discrepancy -3.104
- Figure 1.14 (reserve and financing components samples)
  - 1995: Gross international reserves (eop, RHS) 5.3; IMF quota resources5 0.3; IMF borrowed resources4 0.1; RFAs3 0
  - 96 row: 5.7; 0.3; 0.1; 0
  - 97 row: 5.8; 0.3; 0.1; 0
  - 98 row: 6; 0.3; 0.2; 0
  - 99 row: 6.2; 0.5; 0.1; 0
  - 2000 row: 6.5; 0.5; 0.1; 0; 0; 0
- Figure 1.15 (sample country numeric values)
  - Euro Area: 491.32945682307945
  - Denmark: 27.292010458235858
  - Sweden: 16.168782158260875
  - Poland: 0
  - United States: 521.5530975226106
  - United Kingdom: 147.875
  - Japan: 304.8438046567042
  - Switzerland: 63.263263157894734
  - Canada: 86.4086586676619
  - China: 526.7091456086554
- Figure 1.16 (EBA norm decomposition sample rows)
  - CHE: EBA norm 6.791; Net foreign assets 3.671; Demographics 1.165; Oil -0.092; Other fundamentals 2.229; Desirable policies -0.181
  - NLD: 5.134; 3.334; 0.892; -0.092; 1.569; -0.568
  - KOR: 5.024; 1.024; 3.07; -0.092; 0.471; 0.551
  - RUS: 4.419; 0.934; -0.713; 1.271; 1.04; 1.886
  - JPN: 3.85; 2.278; 1.808; -0.092; 1.233; -1.377
  - ITA: 3.391; -0.045; 2.27; -0.092; 1.015; 0.243
  - DEU: 3.3; 2.14; 0.438; -0.092; 1.468; -0.654
  - BEL: 3.117; 1.438; 0.345; -0.092; 1.54; -0.114
  - CAN: 2.631; 1.387; 0.199; 0.149; 0.846; 0.05
- Figure 1.18 (EBA CA gap and IMF staff ranges)
  - BEL (Belgium): EBA CA gap -3.11395; IMF staff–assessed CA gap range Floor -3.01149; Top -0.6
  - ZAF (South Africa): EBA CA gap -1.25285; Floor -1.00621; Top -1.4
  - CAN (Canada): EBA CA gap -3.0331; Floor -1.06065; Top -0.8
  - USA (United States): EBA CA gap -1.89658; Floor -0.47468; Top -1.2
  - SAU (Saudi Arabia): EBA CA gap "."; Floor -2.8; Top 0.8
  - CHE (Switzerland): EBA CA gap 3.064963; Floor -0.09135; Top -1.6
  - ITA (Italy): EBA CA gap -1.21144; Floor -0.16898; Top -1.4
- Figure 1.19 (headline CA and staff gaps cross samples)
  - 2015 sample: 3.55; 1.55 (headline CA and staff gaps)
  - CHN: change in staff gaps -0.99; 2020 staff gaps 0.71
  - EA: change in staff gaps 0.55; 2020 staff gaps 0.64
  - JPN: -0.46; -0.09
- Figure 1.20 (panels with CA and public saving by country group and year codes)
  - Year 21: CHN CA 0.04; Surplus AEs 0.04; Deficit AEs 0.15; Surplus EMDEs -0.07; Deficit EMDEs -0.17; Oil exporters 0.45; USA -0.13; World 0.4
  - Panel 2 Year 21: Public Saving CHN 0.69; Surplus AEs 0.51; Deficit AEs 0.34; Surplus EMDEs 0.05; Deficit EMDEs 0.31; Oil exporters 0.27; USA 0.92; World 3.1
  - Subsequent years (22–27) include values for CA and Public Saving (see worksheet for full series).
- Figure 1.21 (net flows panel, 2009–2017 sample rows)
  - 2009 baseline: Total net 0; Net (goods) 0; Net (services) 0; Net (investment) 0
  - 2010 sample: Total net 10; Net (goods) 6; Net (services) 6; Net (investment) 0
  - 2011 sample: Total net 6; Net (goods) 6; Net (services) 0; Net (investment) 0
  - 2012 sample: Total net 12; Net (goods) -1; Net (services) -1; Net (investment) 0
  - 2013 sample: Total net 13; Net (goods) 6; Net (services) 6; Net (investment) 0
  - 2014 sample: Total net 14; Net (goods) 5; Net (services) 5; Net (investment) 0
  - 2015 sample: Total net 15; Net (goods) 4; Net (services) 4; Net (investment) 0
  - 2016 sample: Total net 16; Net (goods) -6; Net (services) -6; Net (investment) 0
  - 2017 sample: Total net 17; Net (goods) 7; Net (services) 7; Net (investment) 0
- Figure 1.22 (selected percentage series)
  - Korea (2017–2021): 10.45; 10.22; 8.95; 8.97; 8.469999999999999
  - Japan (2017–2021): 9.76; 9.08; 8.85; 9.11; 8.18
- Figure 1.23 (reserve and short-term debt, country samples)
  - ARG: Reserve 8.1; ST debt+CA deficit 14.4; GDP 491; Change in reserve -2; Change in ST debt+CA deficit -8.6; 2022 GDP 596.49
  - BRA: Reserve 22.5; ST debt+CA deficit 10.8; GDP 1608.1; Change in reserve -2; Change in ST debt+CA deficit -1.5; 2022 GDP 2015.96
  - CHL: Reserve 16.2; ST debt+CA deficit 29.1; GDP 316.8; Change in reserve 0.7; Change in ST debt+CA deficit 9; 2022 GDP 323.08
  - COL: Reserve 19; ST debt+CA deficit 17; GDP 314.4; Change in reserve -2.9; Change in ST debt+CA deficit -0.2; 2022 GDP 352.23
  - CRI: Reserve 10.7; ST debt+CA deficit 12.7; GDP 64.4; Change in reserve -0.9; Change in ST debt+CA deficit 3.1; 2022 GDP 65
  - EGY: Reserve 9.8; ST debt+CA deficit 9.3; GDP 402.8; Change in reserve -0.4; Change in ST debt+CA deficit 2.4; 2022 GDP 439.57
  - HUN: Reserve 24.8; ST debt+CA deficit 13.3; GDP 184.6; Change in reserve -1.5; Change in ST debt+CA deficit -5.5; 2022 GDP 197.81
- Figure 1.1.3 (valuation and net financial wealth quarterly samples)
  - 2020: Q2 — Valuation 28.456796; Net lending 5.363794; Change in net financial wealth 33.82059
  - 2020: Q3 — Valuation 41.243907; Net lending 8.237753; Change in net financial wealth 49.48166
  - 2020: Q4 — Valuation 70.71907; Net lending 10.48592; Change in net financial wealth 81.20499
  - 2021: Q1 — Valuation 84.35691; Net lending 14.84042; Change in net financial wealth 99.19733
  - 2021: Q2 — Valuation 102.11503; Net lending 16.66457; Change in net financial wealth 118.7796
  - 2021: Q3 — Valuation 103.41338; Net lending 18.26662; Change in net financial wealth 121.68
- Figure 1.1.4 (net wealth composition samples)
  - "Normal" Net wealth 11.8; Real estate 0; Corporate equities and shares 1; Other assets 1; Liabilities (-) -0.2; Valuation and other volume changes 10; Of which: savings 1.8
  - "COVID-19" Net wealth 33.5; Real estate -0.5; Corporate equities and shares 2.8; Other assets 4; Liabilities (-) 0; Valuation and other volume changes 27.1; Of which: savings 6.4
  - Additional "Normal" and "COVID-19" rows with different sample values (15.2; 29.9; 9.7; 21.3, etc.)
- Figure 1.1.5 (income groups 2019–2020 sample)
  - Top 1: 2019 = 5.26; 2020 = 5.66
  - Next 9: 2019 = 7; 2020 = 7.24
  - Next 40: 2019 = 6.38; 2020 = 8.82
  - Bottom 50: 2019 = -7.16; 2020 = -3.93
- Figure 1.2.1 (residuals and gaps)
  - Residuals (when < 0): 2.2
  - Residuals (when > 0): 4.5
  - 2012–19: 4.7
  - All countries: 3.9
  - FX Reserve gaps: 0.7
  - Health gaps: 10.7
  - Credit gaps, contrib. < 0: 4.9
  - Credit gaps, contrib. > 0: 9
- Figure 1.3.1 (disaster coefficients and intervals)
  - disaster_coef for level 0: -1.09015; disaster_u 0.160223; disaster_l -2.34052
  - disaster_coef for level 1: -1.98738; disaster_u -0.58148; disaster_l -3.39328
  - disaster_coef for level 2: -2.0729; disaster_u -0.43673; disaster_l -3.70907
  - disaster_coef for level 3: -2.01594; disaster_u -0.29778; disaster_l -3.73409
  - disaster_coef for level 4: -0.89036; disaster_u 0.764454; disaster_l -2.54517
  - disaster_coef for level 5: 0.008048; disaster_u 1.562222; disaster_l -1.54612
  - disaster_coef for level 6: -0.43827; disaster_u 1.022609; disaster_l -1.89914
- Figure 1.3.2 (adaptation scenarios sample)
  - No adaptation or contingency fund series includes values: -6; -5; -4; -3; -2; -1; 0; 1
  - "Adaptation only" and "Adaptation + contingency fund" sample offsets: 0; -0.6; -0.4; -2.1; -1.1; -1.5
- Figure 1.4.1 (historical counts by group)
  - Year 1949: AE 15; EMDE 14; LIDCs 14
  - Subsequent entries include repeated counts of 15/14/14 and later 14/14/14, 14/13/14, etc.
- Figure 1.4.2 (trade and GDP impacts samples)
  - Exports: -1.8; -3
  - Imports: -3.2; -4
  - Trade Balance (percent of GDP) sample: 0.1; 0.3
  - Current account balance (percent of GDP) sample: -0.1; 0.2
  - GDP sample: -1; -1.7
  - Investment sample: -2.2; -3
  - Productivity sample: -0.8; -1.4

### Notes on usage
- The workbook encodes many panel labels and repeated numeric series across figures; use the specific worksheet to extract full series where only sample rows are listed here.
- All numeric values above are preserved exactly as they appear in the sampled rows of the dataset.

*Dataset: ch1data — worksheet and sample-row excerpts from the 2022 EXTERNAL SECTOR REPORT Chapter 1 dataset (XLSX).*

---


_Source: https://www.imf.org/-/media/files/publications/esr/2022/data/ch1data.xlsx_