## 2019esr-ch2 (dataset overview)

## Source details

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

## Other formats

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

---

### Dataset structure and worksheets
- Worksheets included (names and basic dimensions):
  - "ESR Chapter 2 2019" — rowCount: 32; columnCount: 10.
  - "Table of Contents" — rowCount: 22; columnCount: 12.
  - "Figure 2.1" — rowCount: 46; columnCount: 22.
  - "Figure 2.2" — rowCount: 18; columnCount: 26.
  - "Figure 2.3" — rowCount: 19; columnCount: 26.
  - "Figure 2.4" — rowCount: 49; columnCount: 22.
  - "Figure 2.5" — rowCount: 16; columnCount: 19.
  - "Figure 2.6" — rowCount: 12; columnCount: 18.
  - "Figure 2.7" — rowCount: 531; columnCount: 20.
  - "Figure 2.8" — rowCount: 59; columnCount: 23.
  - "Figure 2.1.1" — rowCount: 59; columnCount: 23.
  - "Figure  2.4.1" — rowCount: 59; columnCount: 23.

### High-level content themes (as labeled in the workbook)
- Core report title repeated in sheet content: "2019 EXTERNAL SECTOR REPORT".
- Chapter heading present: "CHAPTER 2. EXCHANGE RATES AND EXTERNAL ADJUSTMENT".
- Figures focus on exchange rates, US dollar invoicing, pass-through, trade volume elasticities, global value chain (GVC) integration, trade openness, and trade-balance responses.

### Key figures and labeled findings extracted from sample rows
- Figure 2.1. Trade with United States and US Dollar Invoicing:
  - Subpanels: "1. Exports to US and Exports Invoiced in US Dollars", "2. Imports from US and Imports Invoiced in US Dollars".
  - Country-level sample entries (Share of exports / Share of imports and US$ invoicing):
    - TUR: 0.0771007 (Share exported to US (2001-15 average)), 0.4613397 (Share invoiced in US$).
    - BRA: 0.2481017 (Share exported to US (2001-15 average)), 0.8436 (Share invoiced in US$).
    - MEX: 0.8205495 (Share exported to US (2001-15 average)).
    - CHN: 0.1491689 (Share imported from US (2001-15 average)), 0.9276355 (Share invoiced in US$).
- Figure 2.2. Exchange-rate Pass-through from Bilateral and US Dollar Exchange Rates (Weighted regressions):
  - Panel "1. Average Effects":
    - "Export prices" / "Short term" / "Bilateral": 0.303392 (upper), 0.10660799999999998 (lower), 0.205 (point).
  - Panel "2. Effects for Countries with Low/High US Dollar Invoicing":
    - "Export prices" / "Short term" / "Bilateral": 0.316 (average), -0.2202 (Additional effect from high USD invoicing), 0.0958 (Overall effect with high US$ invoicing).
- Figure 2.3. Estimated Trade Volume Elasticities to Bilateral and US Dollar Exchange Rates:
  - Labeled as "(Weighted regressions)" with panels mirroring Figure 2.2 (specific numeric sample rows not shown in the sample beyond headings).
- Figure 2.4. Integration into Global Value Chains, 2001-14:
  - Labeled "(Manufacturing, trade weighted average across trading partners)".
  - Panels: "1. Backward Integration" (Share of exports) and "2. Forward Integration" (Share of imports).
  - Column headings include year markers: 2001 and 2014 and "GDP".
- Figure 2.5. Trade Flow Responses and GVC Integration (Response to a 10 percent depreciation vis-à-vis all currencies, weighted regression):
  - Quantiles reported for "25th", "Median GVC integration", "75th".
  - Volumes / Exports (Short term): 0.674 (25th), 0.14 (Median), -0.20199999999999999 (75th).
  - Exports (Medium term): 4.32 (25th), 3.4499999999999997 (Median), 2.9 (75th).
  - Imports (Short term): -2.5300000000000002 (25th), -1.7199999999999998 (Median), -0.822 (75th).
- Figure 2.6. Impact of GVC and Trade Openness on Trade Balance Response to Exchange Rate (Response to a 10 percent depreciation vis-à-vis all currencies):
  - For "Varying GVC integration¹":
    - "Short term": 0.513 (25th), 0.371 (median), 0.184 (75th).
    - "Medium term": 1.456 (25th), 1.169 (median), 0.852 (75th).
  - For "Varying openness²":
    - "Short term": 0.176 (25th), 0.371 (median), 0.538 (75th).
- Figure 2.7. Partial Correlation Between Trade Openness and Backward/Forward GVC Integration:
  - Panels "1. Backward" and "2. Forward" with sample partial correlation entries:
    - -0.12110618759491881, -0.15334024406259272 (row sample for first pair).
    - -0.10659944674081906, -0.13680775994457806 (row sample for next pair).
    - 0.13193211517133652, -0.1447278537932647 (sample pair in panel 2).
    - -0.04524658955715699, -0.14318519983218747 (another sample pair).
- Figure 2.8. Trade Balance Response: Distribution and Variation over Time, 2000-14 (Response to a 10 percent depreciation vis-à-vis all currencies, in percent of GDP):
  - Panel "1. Distribution, 2001 and 2014" and "2. Time Variation for Average Economy".
  - Sample TB elasticity and density values:
    - TB elasticity: -0.322370196619117; density, 2001: 0.05013179076194836.
    - TB elasticity: -0.23766440182941345; density, 2014: 0.10031089552116569.
  - Time variation entries for "constant GVCs":
    - 2000: 0.9421869840902403; "2001-04": 0.967148530664699; "2005-09": 1.0476478803850156; "2010-14": 1.0497607960763542.
  - Time variation entries for "constant openness":
    - 2000: 0.9421869840902403; "2001-04": 0.9188539077321978; "2005-09": 0.8929610653457344; "2010-14": 0.8477840141576403.
- Figure 2.1.1. Trade Volume Responses to a 10 Percent Appreciation of the US Dollar (Weighted regression):
  - "Rest of the world" Short term: -1.3026 (upper), -3.4194000000000004 (lower), -2.361 (point).
  - "Medium term": 1.9896 (upper), -2.3616 (lower), -0.186 (point).
- Figure 2.4.1. Foreign to Domestic Value Added (World, five-year averages, percent):
  - FVA/DVA:
    - "1995-99": 21.067888727766736.
    - "2000-04": 26.542664593629144.

### Observations on numeric content and use
- The workbook provides many precise point estimates, quantiles, regression coefficient aggregates, partial correlations, and time-series aggregates relevant to:
  - Exchange-rate pass-through to export prices.
  - Trade volume elasticities to bilateral and US dollar exchange rates.
  - Trade flow responses to currency depreciation across GVC integration quantiles.
  - Trade-balance responses in percent of GDP under varying GVC integration and openness scenarios.
  - Partial correlations between trade openness and backward/forward GVC integration.
  - World-level foreign to domestic value added (FVA/DVA) five-year averages.
- Numeric precision is preserved in the source (including many multi-decimal entries and negative values), suitable for reproducible quantitative analysis.

*Dataset: 2019esr-ch2 (excerpted worksheet samples and numeric entries).*

---


_Source: https://www.imf.org/-/media/files/publications/esr/2019/english/data/2019esr-ch2.xlsx_