## Dataset overview: ch1data (2025 EXTERNAL SECTOR REPORT — Chapter 1)

## Source details

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

## Other formats

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

---

### Summary
- Excel dataset with multiple worksheets supporting "2025 EXTERNAL SECTOR REPORT" Chapter 1.
- Contains time series, panel data, country-level indicators, and decompositions used for figures in Chapter 1.
- Provided canonical filename: ch1data and canonical source URL: https://www.imf.org/-/media/files/publications/esr/2025/data/ch1data.xlsx

### Worksheets and structure
- Worksheet names (sample): "ESR Chapter 1 2025", "Table of Contents", "Figure 1.1", "Figure 1.2", ..., up to "Figure 1.4.2".
- Row and column counts vary by sheet; examples:
  - "ESR Chapter 1 2025": rowCount 32, columnCount 10.
  - "Table of Contents": rowCount 45, columnCount 14.
  - "Figure 1.1": rowCount 388, columnCount 43.
  - "Figure 1.13": rowCount 6852, columnCount 25.
- Many figure sheets include labeled panels (e.g., "Panel 1", "Panel 2") and country ISO codes or regional labels (e.g., CHN, JPN, GBR, USA, EA).

### Key numeric samples and series (preserve values exactly)
- Figure 1.1 (Panel 1) — country-level values for 2023 and 2024–2023 change:
  - 2023 overall balance sample: 263.38235336819 (CHN), 158.50453630423598 (JPN), -118.275761810533 (GBR), -905.376 (USA), 263.09012878385596 (EA).
  - "2024–2023" differences sample: 160.53686134810994 (CHN), 34.46386278279101 (JPN), -4.405297457344005 (GBR), -228.24500000000012 (USA), 197.78937735667205 (EA).
- Figure 1.2 (Panel 1) — headline/adjusted series:
  - 2005: 4.9 (Headline)
  - "06": 5.5 (Adjusted)
  - "07": 5.4; "08": 5.2; "09": 3.5
- Figure 1.3 — decomposition (sample values):
  - United States: Current account -0.17477912037723753; Investment -0.1298996018397336; Private saving 0.04793091386880277; Public saving -0.09281043240630671
  - China: Current account 0.13599976990901394; Investment 0.20559873424329211; Private saving -0.01981140748253643; Public saving -0.04978755685174174
  - EA: Current account 0.1362090512202776; Investment 0.1165041587991702; Private saving -0.05946132802633948; Public saving 0.07916622044744688
- Figure 1.4 (Panel 1) — year-level sample:
  - 2000: EUR 3.655266; JPN 0.5444167; GBR 3.659082; USA 3.379167; World 3.1169828516691074
  - 2005: EUR 1.548889; JPN -0.07525; GBR 2.569447; USA 1.855638; World 1.5381927996048714
- Figure 1.5 — current-account components (sample):
  - United States: Current account -0.17477912037723753; Trade balance in goods except for oil -0.10946316262337374; Trade balance in oil 0.011259138438943134; Trade balance in services 0.0054140776671149915; Primary income balance -0.0710200694092013; Secondary income balance -0.010968234874670413
  - China: Current account 0.13599976990901394; Trade balance in goods except for oil 0.11856249183757717; Trade balance in oil 0.0179850992853694; Trade balance in services -0.011295758972432512; Primary income balance 0.007990940706213631; Secondary income balance 0.002756997052286353
- Figure 1.8 (Panel 1) — US REER monthly samples:
  - "2022M1": 107.17078246524339 ("Shaded Area" = "Yes")
  - "2022M6": 112.57700632350169 ("Yes")
  - "2022M9": 116.78754595390168 ("Yes")
- Figure 1.13 — monthly series (Panel 1 - China, EM (excl. China), Total):
  - "2024-01-01T00:00:00.000Z": China 20.82764374202529; EM (excl. China) 14.295747590365869; Total 35.12339133239116
  - "2024-06-01T00:00:00.000Z": China 11.641047748192863; EM (excl. China) -6.04236572014923; Total 5.598682028043633
- Figure 1.16 — NIIP and valuation (sample):
  - ARG: NIIP 16.7166; Valuation -6.390700000000001; GDP 648116
  - AUS: NIIP -32.14494; Valuation 5.68671; GDP 1741966
  - BEL: NIIP 52.66526; Valuation 8.6721; GDP 644896
- Figure 1.24 — scenario contributions to "Total" (sample years):
  - 2025: Total 0.02464366; USA fiscal expansion 0.0091743469; EA lower productivity -0.0031046867; CHN weaker domestic demand 0.018499374
  - 2029: Total 0.10611129; USA fiscal expansion 0.054021597; EA lower productivity -0.0035784245; CHN weaker domestic demand 0.05575633
- Figure 1.27 — US Effective Tariff Rates on All Imports (sample years):
  - 1990: 3.3; 1991: 3.4; 1992: 3.3; 1993: 3.2; 1994: 3; 1995: 2.5; 1996: 2.3; 1997: 2.1; 1998: 2
- Selected model / shock magnitudes and indices (exact values preserved):
  - Figure 1.4.1 shock samples: CHN 34.0263670257119; EA 56.288079339211; ROW 86.84708203986; USA 192.770398750488
  - Figure 1.3.2 investment impacts (High Tariffs), year 2025: CHN -0.5414954386651516; EA -0.03250204026699066; RoW -0.0873863697052002; USA -0.43280250392854214

### Notable panels, decompositions, and coverage
- Country and regional coverage includes CHN, JPN, GBR, USA, EA, DEU/NLD, CHN, EA (other), Commodity exporters, Oil exporters, Deficit EMDEs, etc.
- Decompositions include current account components (trade in goods excluding oil, oil, services, primary income, secondary income), saving/investment decompositions, capital flows (Inflows, FDI, Portfolio, Other), and valuation effects.
- Time frequency ranges from yearly panels (e.g., 2000–2030), quarterly series (e.g., "2024:Q1"), to monthly series (e.g., "2024-01-01T00:00:00.000Z", "2022M1").

### Usage notes for analysts (based only on supplied content)
- Large sheet "Figure 1.13" contains dense monthly time series (rowCount 6852) useful for high-frequency flow analysis.
- Multiple sheets present both headline and adjusted series; verify column headers like "Headline", "Adjusted", "Total", "FDI", "Portfolio", "Other", "Reserves".
- Several sheets include explicit panel labels (e.g., "Panel 1", "Panel 2") to map table columns to figure panels.
- Numeric precision is high and must be preserved when ingesting (examples show many values with many decimal places).

*Source: ch1data Excel dataset supporting "2025 EXTERNAL SECTOR REPORT" Chapter 1 — https://www.imf.org/-/media/files/publications/esr/2025/data/ch1data.xlsx*

---


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