## ch2data — dataset overview

## Source details

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

## Other formats

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

---

### Dataset summary
- Publication type: dataset (XLSX or CSV).
- Origin: 2024 EXTERNAL SECTOR REPORT — chapter-level data (worksheet "ESR Chapter 2") and multiple figure worksheets (Figure 2.1 through Figure 2.4.2 and subfigures).
- File referenced: ch2data (canonical source URL provided).

### Worksheets and structure
- Total worksheets listed in metadata: 30+ (examples provided include "Table of Contents", "ESR Chapter 2", "Figure 2.1", "Figure 2.2", "Figure 2.3", "Figure 2.4", "Figure 2.5", "Figure 2.6", "Figure 2.7", "Figure 2.8", "Figure 2.1.1", "Figure 2.1.2", "Figure 2.2.1", "Figure 2.2.2", "Figure 2.3.1", "Figure 2.3.2", "Figure 2.3.3", "Figure 2.4.1", "Figure 2.4.2").
- Worksheets vary in size: examples of rowCount include 28, 32, 655, 768, 56, 70, 295, 813, 651, etc.
- Column counts vary broadly (examples: 10, 14, 15, 17, 20, 21, 23, 24, 33, 50).

### Key variables, panels, and labels (as present in sample rows)
- Common panel headings and labels include:
  - "Panel 1", "Panel 2", "Panel 3", "Panel 4".
  - Time identifiers: "Year", "Date", "month", "Quarter", "Panel 1 Data".
  - Commodity and sector labels: "All commodities", "Energy", "Oil", "Crude oil", "Natural gas", "Coal", "Gold", "Aluminum", "Copper", "Metals", "Food", "Agricultural", "Mineral products", "Basic metals".
  - Financial/price indices and spreads: "Nominal broad U.S. dollar index, (right scale)", "Real energy price (Index, 2016=100)", "BAA spread", "Real oil price".
  - Macroeconomic indicators in panels: "Global activity shock", "Oil supply shock (right scale)", "Exporters", "Importers", "Oil exporter".
  - US-specific series: "US oil trade balance", "Correlation between US dollar and oil price", "US oil trade balance (percent of GDP)".

### Selected numeric highlights preserved exactly from sample rows
- Figure 2.1 samples:
  - Crude oil: 2.420151
  - Natural gas: 0.362594
  - Coal: 0.148602
  - Oil (1970, month 1): 40.8
  - Nominal broad U.S. dollar index example: 70.91926
  - Real energy price example: 94.89971376
- Figure 2.2 samples:
  - Real oil price (1960): 32.32897; subsequent month values include 33.17105, 33.15173, 33.03197, 32.99791, 32.98303
- Figure 2.3 samples (Panel coefficients and intervals):
  - Quarter 0 coefficient: 10 (both Global activity shock and Oil supply shock examples show 10)
  - Quarter 1 Global activity shock coefficient: 21.6877; Lower 68: 15.4456; Lower 90: 11.4194; Upper 68: 27.9298; Upper 90: 31.9559
  - Quarter 3 Global activity shock coefficient: 34.5064
- Figure 2.4 sample (Exporters vs Importers coefficients):
  - Quarter 0 Exporters coefficient: 0.3; Importers coefficient: 0.229
  - Quarter 1 Exporters coefficient: 0.8; Importers coefficient: -0.186
  - Quarter 4 Exporters coefficient: 0.8; Importers coefficient: -0.67
- Figure 2.5 sample (Panel 1 Exporters):
  - Quarter 0 coefficient: 0.503; Lower 68: 0.322; Upper 90: 0.802
  - Quarter 1 coefficient: 1.11; Lower 68: 0.86; Upper 90: 1.523
- Figure 2.6 sample (multiple panels, coefficients and confidence bounds):
  - Panel 1, Quarter 0 Coefficient: -0.012; Lower 68: -0.145; Upper 90: 0.206
  - Panel 3, Quarter 0 Coefficient: 1.338; Lower 68: 0.755; Upper 90: 2.296
  - Panel 1, Quarter 1 Coefficient: -0.545; Panel 1, Quarter 2 Coefficient: -0.875
- Figure 2.7 sample (projections by year and shock/type):
  - Panel 1 Oil supply shock: 10 (base) and 1.588758 (2025), 1.192858 (2026), 0.90908 (2027), 0.672246 (2028), 0.490001 (2029)
  - Panel 1 Global demand shock: 10 (base) and 4.362691 (2025), 1.906597 (2026), 0.759765 (2027), 0.825401 (2028), 0.76033 (2029)
  - Panel 2 Oil supply shock (percent): -0.19 (2025), -0.0539 (2026), 0.01 (2027)
  - Panel 3 Oil exporter (2024–2029): 0.64 (2024), 0.28 (2025), 0.09 (2026), 0 (2027), 0 (2028), -0.02 (2029)
  - Panel 4 Oil exporter (2024–2029): 1.2 (2024), 0.8 (2025), 0.57 (2026), 0.43 (2027), 0.35 (2028), 0.32 (2029)
- Figure 2.8 sample (monthly US oil trade balance and correlation examples):
  - Date "2000:M1": US oil trade balance -0.8665; Correlation between US dollar and oil price -0.5323
  - Date "2000m2": US oil trade balance -0.9724; Correlation -0.5635
  - Date "2000m3": US oil trade balance -1.0076; Correlation -0.5605
  - Date "2000m4": US oil trade balance -1.0135; Correlation -0.5791
  - Date "2000m5": US oil trade balance -1.0336; Correlation -0.6638
- Figure 2.1.1 sample (energy subcomponents, Jan.2021 entry):
  - Jan.2021: Natural gas 132.0202; Electricity 125.4585; Coal 147.3936; Oil 98.84177
  - Later monthly values include 158.5414, 181.1089, 214.2641, 249.8733, 351.1717, 462.5771, 420.1982 for Natural gas (as shown).
- Figure 2.1.2 sample (country energy price/tax, year 2000 and 2010 entries):
  - 2000, France Energy (price): 0.052207; Energy (tax): 0.002251
  - 2000, Germany Energy (price): 0.034065; Energy (tax): 0.00169
  - 2000, Japan Energy (price): 0.154177; Energy (tax): 0.005373
  - 2000, United Kingdom Energy (price): 0.057692; Energy (tax): 0.000464
  - 2000, United States Energy (price): 0.067616; Energy (tax): 0
  - 2000, United States Commodity "Mineral products" Energy (price): 0.249698; Energy (tax): 0.024112
  - 2010, France Basic metals Energy (price): 0.565427; Energy (tax): 0.052693
- Figure 2.2.1 sample (explained variance by number of components, 1980–2023):
  - Number of Components 1: 39.75 (1980–2023); 48.16 (1980s); 38.44 (1990s); 52.36 (2000s); 49.59 (2010s)
  - Number of Components 9: 86.71 (1980–2023); 92.31 (1980s); 90.15 (1990s); 92.4 (2000s); 91.27 (2010s)
- Figure 2.2.2 sample (commodity correlations):
  - "All commodities" Total Correlation: 0.9345
  - "Coal" Energy Correlation: 0.8857
  - "Crude oil" Energy Correlation: 0.8655
  - "Natural gas" Energy Correlation: 0.6155
  - "Tin" Metals Correlation: 0.9503
  - "Copper" Metals Correlation: 0.9267
  - "Gold" Metals Correlation: 0.9156
  - "Iron ore" Metals Correlation: 0.8926
- Figure 2.3.1 sample (US oil trade balance percent of GDP starting 1970:M1):
  - 1970:M1 through 1970m9 entries show US oil trade balance (percent of GDP) consistently: -0.2292 (repeated for months shown)
- Figure 2.3.2 sample (post–2020 vs 2000–19 sample period coefficients by quarter):
  - Post–2020 Quarter 0 coefficient: 0
  - 2000–19 Quarter 0 coefficient: -0.5252; Lower 68: -0.8073; Lower 90: -0.9892; Upper 68: -0.2431; Upper 90: -0.0612
  - Post–2020 Quarter 1 coefficient: -0.0842; Lower 68: -0.1694; Upper 90: 0.0559
  - Post–2020 Quarter 6 coefficient: 0.3202; Lower 68: -0.1427; Upper 90: 1.0815
- Figure 2.3.3 sample (net purchases and asset class shares across decades):
  - 1980s Net purchases (scientific notation): -7.43e-19; other asset entries include -1.65e-18, 1e-18
  - 1990s Net purchases example: 4.66e-18
  - 2020s Net purchases example: 2.36e-16
  - Quantity-style entries by decade: 1980s 0.000664; 1990s 0.010344; 2020s 0.590432 (and related subcomponents)
- Figure 2.4.1 sample (impulse-response months for panels):
  - Panel 1 Real GDP Month t: -0.59; t+1: -1.37; t+2: -2.27; up to t+7: -4.61
  - Panel 2 Investment Month t: -12.5; t+1: -20.9; t+2: -24.53; up to t+7: -15.53
  - Panel 3 REER Month t: -12.15; t+1: -11.15; t+2: -9.22; up to t+7: -1.39
  - Panel 4 CA / GDP Month t: 0.32; t+1: 1.48; up to t+7: 0.87
- Figure 2.4.2 sample (alternative group impulse-response months for panels):
  - Panel 1 Real GDP Month t: 0.31; t+1: 0.94; up to t+7: 2.56
  - Panel 2 Investment Month t: 9.42; t+1: 14.35; t+2: 15.74; up to t+7: 6.69
  - Panel 3 REER Month t: 4.19; t+1: 3.54; up to t+7: -3.37
  - Panel 4 CA / GDP Month t: -0.89; t+1: -1.47; up to t+7: -0.97

### Data formats and conventions observed
- Dates are presented in mixed formats: "1970", "1970m2", "2000:M1", "Jan.2021", "Friday, January 1, 1960", monthly abbreviations like "2000m3".
- Numeric formats include:
  - Standard decimals (e.g., 0.362594, 70.91926).
  - Scientific notation in small magnitude values (e.g., -7.43e-19, 4.66e-18).
  - Percent-of-GDP style entries without explicit percent symbol in samples (e.g., US oil trade balance (percent of GDP) shown as -0.2292).
- Panels include point estimates and interval bounds labeled "Lower 68", "Lower 90", "Upper 68", "Upper 90".

### Usage notes for analysts
- The dataset contains extensive panel-level impulse responses, commodity price series, country-level energy price and tax splits, correlation series, and decade/comparative statistics — all presented with high numeric precision.
- When extracting time series, preserve the original date string formats as found in worksheets (e.g., "1970:M1", "2000m2", "Jan.2021", "Friday, January 1, 1960").
- Confidence bounds are provided alongside coefficients in many figures; retain "Lower 68", "Lower 90", "Upper 68", and "Upper 90" labels and values exactly.
- Watch for mixed numeric representations (scientific notation and decimals) and preserve them exactly when reusing or publishing these values.

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

---


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