## ESR Chapter 1 2024 — dataset overview

## Source details

**Canonical URL:** [ESR Chapter 1 2024 — dataset overview](https://www.imf.org/-/media/files/publications/esr/2024/data/ch1data.xlsx)

## Other formats

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

---

### Dataset summary
- Publication type: dataset (XLSX or CSV)
- Source filename: ch1data
- Canonical source URL: https://www.imf.org/-/media/files/publications/esr/2024/data/ch1data.xlsx
- High-level content: worksheet-level time series and panel data underlying Chapter 1 figures of the 2024 EXTERNAL SECTOR REPORT.

### Worksheets and dimensions (selected)
- "ESR Chapter 1 2024": rowCount 32, columnCount 10
- "Table of Contents": rowCount 43, columnCount 14
- "Figure 1.1": rowCount 388, columnCount 31
- "Figure 1.2": rowCount 339, columnCount 33
- "Figure 1.3": rowCount 33, columnCount 25
- "Figure 1.4": rowCount 48, columnCount 17
- "Figure 1.5": rowCount 41, columnCount 23
- "Figure 1.6": rowCount 45, columnCount 27
- "Figure 1.7": rowCount 101, columnCount 25
- "Figure 1.8": rowCount 177, columnCount 25
- "Figure 1.9": rowCount 37, columnCount 26
- "Figure 1.10": rowCount 40, columnCount 40
- "Figure 1.11": rowCount 333, columnCount 18
- "Figure 1.12": rowCount 211, columnCount 45
- "Figure 1.13": rowCount 6852, columnCount 25
- "Figure 1.14": rowCount 42, columnCount 17
- "Figure 1.15": rowCount 40, columnCount 20
- "Figure 1.16": rowCount 18, columnCount 15
- "Figure 1.17": rowCount 47, columnCount 20
- "Figure 1.18": rowCount 68, columnCount 17
- "Figure 1.19": rowCount 67, columnCount 21
- "Figure 1.20": rowCount 34, columnCount 33
- "Figure 1.21": rowCount 46, columnCount 23
- "Figure 1.22": rowCount 34, columnCount 19
- "Figure 1.23": rowCount 205, columnCount 25
- "Figure 1.1.1": rowCount 40, columnCount 22
- "Figure 1.1.2": rowCount 66, columnCount 22
- "Figure 1.2.1": rowCount 54, columnCount 25
- "Figure 1.2.2": rowCount 54, columnCount 25
- "Figure 1.2.3": rowCount 54, columnCount 0
- "Figure 1.2.4": rowCount 40, columnCount 20
- "Figure 1.3.1": rowCount 155, columnCount 17
- "Figure 1.3.2": rowCount 49, columnCount 22
- "Figure 1.3.3": rowCount 49, columnCount 21

### Major data themes and series (extracted from sample rows)
- Global shipping and supply indicators (Figure 1.1, Panel 1):
  - "Harper Petersen Charter Rate Index" sample values: 98.99794006, 99.8365097, 100.3027267, 100.8628159, 101.3290329, 101.7952576, 103.3816528, 107.4868774
  - "Baltic Dry Index" sample values: 105.108696, 99.3478241, 101.4130402, 94.13043213, 85.32608795, 77.39130402, 76.30434418, 88.47826385
  - "Global Supply Chain Pressure Index (std. dev. pts., right scale)" sample value: 0.19, 0.19, 0.19, 0.19, 0.18, 0.18, 0.18, 0.18
- Global current account composition (Figure 1.2):
  - Columns include "United States", "China", "Global current account balance", "Oil exporters", "Others"
  - Sample row (2000): United States 1.180135587, China 0.059992676, Global current account balance 3.411, Oil exporters 0.526487649, Others 1.644160785
  - Sample row (2005): United States 1.567099144, China 0.276883828, Global current account balance 4.874, Oil exporters 0.913440464, Others 2.116398674
- Changes in global balance relative to 2019 (Figure 1.3):
  - "Change in global balance, relative to 2019" sample values by year: 2019 = 0, 2020 = 0.23, 2021 = 0.69, 2022 = 0.75, 2023 = 0.24
  - Category sample contributions: "Travel" 2021 = 0.09, 2022 = 0.18, 2023 = 0.11; "Household" 2021 = 0.14, 2022 = 0.21
- Cyclically adjusted fiscal balances (Figure 1.4 sample):
  - "Cyclically adjusted fiscal balance" for sample groups: CA deficit economies (excl. the United States) -0.44847, CA surplus economies -0.143857, United States -3.84289
- Country-level accounting (Figure 1.5 sample rows for USA and CHN, 2019–2023):
  - USA 2019: Current account 0.0051, Investment -0.1686, Private Saving 0.3035, Public Saving -0.13
  - USA 2023: Current account 0.1896, Investment 0.0274, Private Saving 0.9211, Public Saving -0.76
  - CHN 2019: Current account 0.09, Investment 0, Private Saving 0.3579, Public Saving -0.26
  - CHN 2023: Current account -0.15, Investment 0.56, Private Saving -0.7816, Public Saving 0.07
- Exchange market pressure and reserves (Figure 1.7 sample):
  - EMDE sample entries: "RUS" Nominal exchange rate 25.522, Interest rate 3.01, Adjusted change in FX reserves 3.042, Total Exchange Market Pressure 2023 31.574, Total Exchange Market Pressure 2022 5.0637208
  - "CHN" sample: Nominal exchange rate 2.46, Interest rate -0.086, Adjusted change in FX reserves -0.496, Total Exchange Market Pressure 2023 1.878, Total Exchange Market Pressure 2022 7.7111624
- Capital flows and net inflows (Figures 1.8–1.10, 1.23 samples):
  - Figure 1.8 sample (2014): EM (excl China) 0.7468, China -0.65998, Total net inflows (including reserves) 0.086861
  - Figure 1.9 sample (2014, EM excl China): FDI 1.05929, Portfolio 0.69606, Other -0.55884, Reserves 0.0707, Total 1.26721; China 2014: FDI 1.37746, Portfolio 0.78323, Other -2.64872, Reserves -1.11916, Total -1.60719
  - Figure 1.10 sample (2014, EM excl China Gross Inflows): FDI 2.321311, Portfolio 1.351911, Other 1.006048, Total 4.67927; Gross Outflows 2014: FDI 1.26202, Portfolio 0.65585, Other 1.56489, Reserves -0.0707, Total 3.41206
  - Figure 1.23 sample (Baseline 2023-09-01T00:00:00.000Z; 2024-05-01T00:00:00.000Z): at -10 baseline 0.00000611, 2023-09-01 0.00000498, 2024-05-01 0.0000068; at -9.9 baseline 0.00000675, 2023-09-01 0.0000056, 2024-05-01 0.0000076
- International investment position and valuation changes (Figure 1.14 sample):
  - Sample country entries (ISO and values in sample rows): "ARG" NIIP 16.96404, Valuation Change 1.039842, GDP 155253; "AUS" NIIP -32.8616, Valuation Change 2.647313, GDP 433592; "BEL" NIIP 66.57312, Valuation Change 13.6743, GDP 159124; "BRA" NIIP -44.4768, Valuation Change -5.17264, GDP 565042; "CHN" NIIP 16.32971, Valuation Change 1.277588, GDP 4414030
- Global reserves and safety nets (Figure 1.15 sample and Figure 1.16):
  - Figure 1.15 sample (Year 1995): Gross international reserves 1652.278, IMF quota resources 105.2677, IMF borrowed resources 27.49997, RFAs 7.4025
  - Figure 1.16 sample (2009–2016): Number of countries with active BSL agreements 2009 = 6, Sum of active BSL amounts 2009 = 650; 2016 = 35, Sum = 3343

### Cross-sectional and panel breakdowns (selected)
- Figure 1.12 provides liabilities and assets by "Financial center" and regions with annual entries from 2000 through 2007 sample rows (e.g., 2000 liabilities for USA -19.6698; assets for USA 22.44912).
- Figure 1.13 provides long panel by region (column headers include USA, CHN, DEU, IND, JPN, Rest of Europe, GBR, AE commodity exporters, EMDE debtor, Financial center, Oil exporters, ROW debtor, ROW creditor, Discrepancy) with annual sample rows (e.g., 2000 row: USA -4.71605, CHN 0.131304, Total 88.04 appears in other figures).
- Figure 1.17 sample shows EBA norm decomposition by country with exact contributions (example CHE: EBA norm1 6.405762017, Net foreign assets 3.73509936, Demographics 1.232643903, Oil -0.090800662, Other fundamentals2 2.066086663, Desirable policies3 -0.537267247).

### Representative country and group-level numeric excerpts (exact)
- USA 2019 current account: 0.0051
- CHN 2019 current account: 0.09
- Global Supply Chain Pressure Index sample value: 0.19
- RUS Total Exchange Market Pressure 2023: 31.574
- China NIIP (Figure 1.14 sample): 16.32971
- Gross international reserves 1995: 1652.278
- Number of active BSL agreements 2016: 35; Sum of active BSL amounts 2016: 3343

### Notes on structure for users
- Worksheets map directly to figures in Chapter 1; many worksheets contain time series and multi-panel columns suitable for plotting and replication of charts.
- Numeric precision is preserved in the dataset (examples above show multiple decimal places and exact timestamps such as "2017-01-06T00:00:00.000Z" and "2023: Q1\nMar.").
- Large panel: "Figure 1.13" with rowCount 6852 is the most extensive worksheet in the file and contains annual region/country rows (sample years shown: 2000–2007).

*Source: ch1data — https://www.imf.org/-/media/files/publications/esr/2024/data/ch1data.xlsx*

---


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