## WHD REO (October 2019) — Dataset Overview

## Source details

**Canonical URL:** [WHD REO (October 2019) — Dataset Overview](https://www.imf.org/-/media/files/publications/reo/whd/2019/october/english/data.xlsx)

## Other formats

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

---

### Dataset summary
- File type: dataset (XLSX)
- Worksheets included (sampled in metadata): 26 distinct worksheet names (examples shown): "WHD REO (October 2019)", "Table of Contents", "Figure 1", "Figure 2", "Figure 3", "Figure 4", "Figure 5", "Figure 6", "Figure 7", "Figure 8", "Figure 9", "Figure 10", "Figure 11", "Figure 12", "Figure 13", "Figure 14", "Box Figure 1.1", "Annex Figure 1.1", "Annex Figure 1.2", "Annex Figure 1.3".
- Presented metadata fields (per worksheet): name, rowCount, columnCount, sampleRows.
- Time stamps and date fields appear in ISO 8601 format (examples): "2019-10-28T00:00:00.000Z", "2017-01-31T00:00:00.000Z", "2014-01-01T00:00:00.000Z", "2018-01-03T00:00:00.000Z", "2014-01-31T00:00:00.000Z", "2017-01-31T00:00:00.000Z", "2018:Q1", "2007:Q1", "2011", "2015", "2002", "2018", "2019", "2020", "2011 = 100", "August 2019".

### Structure and coverage (by worksheet metadata)
- "WHD REO (October 2019)": rowCount 32, columnCount 12.
- "Table of Contents": rowCount 36, columnCount 10.
- "Figure 1": rowCount 46, columnCount 18.
- "Figure 2": rowCount 24, columnCount 28.
- "Figure 3": rowCount 1509, columnCount 45.
- "Figure 4": rowCount 16, columnCount 33.
- "Figure 5": rowCount 43, columnCount 29.
- "Figure 6": rowCount 43, columnCount 29.
- "Figure 7": rowCount 78, columnCount 25.
- "Figure 8": rowCount 78, columnCount 27.
- "Figure 9": rowCount 78, columnCount 39.
- "Figure 10": rowCount 78, columnCount 27.
- "Figure 11": rowCount 78, columnCount 29.
- "Figure 12": rowCount 78, columnCount 26.
- "Figure 13": rowCount 151, columnCount 29.
- "Figure 14": rowCount 151, columnCount 23.
- "Box Figure 1.1": rowCount 78, columnCount 23.
- "Annex Figure 1.1": rowCount 13, columnCount 26.
- "Annex Figure 1.2": rowCount 40, columnCount 28.
- "Annex Figure 1.3": rowCount 102, columnCount 29.

### Key figures, series, and explicit numeric values (preserved verbatim from sample rows)
- Figure 1 (LAC: Exports Growth): date 2017-01-31T00:00:00.000Z; series values: 11.908229346930765 (World), 2.2224132247290855 (LAC), 2.03092773805516 (CHN), 0.2693953970066402 (JPN-KOR), 4.672892755839176 (USA-CAN), 0.9699354732964395 (EU), 1.7426647580042742 (Other).
- Figure 2 (Trading Partners Growth and Outlook for Commodity Prices): LAC trading-partners weight 3.850772633662825 (2011); commodity indices (Index: 2011 = 100): Oil 100, Copper 100, Iron ore 100, Soybeans 100 (2011 baseline).
- Figure 3 (Financial Conditions and Capital Flows): US 10YBY value 3.035 (2014-01-01T00:00:00.000Z); sovereign spreads snapshot date 2014-01-31T00:00:00.000Z with values 189.195652173913 (Max), 255.04347826087 (Min), 154.695652173913, 314.036739130435; VIX example date 2014-01-01T00:00:00.000Z with value 13.72; EPFR flows example year 2018 and date 2018-01-03T00:00:00.000Z with values 89.1268, ARG 305.86929999999995, BRA 71.56, CHL 97.8626, COL 194.4562, MEX 59.1771, PER 13.601099999999999, URY 9.716, VEN 841.3691 (Total).
- Figure 4 (Economic Growth): 2018 aggregate contributions: Real GDP growth 1.605157040996618, Private consumption 1.37195839113257, Public consumption 0.1004007272709855, Investment 0.3866807631361761, Inventories 0.028351463533175882, Exports 0.8582714158219674, Imports -1.1405057198982562. LA5 2018:Q1 Real GDP growth 2.0521302028322537, Private consumption 2.090458025883737, Public consumption 0.25864291771757736, Investment 0.5174337969490531, Inventories -0.007768260388063378, Exports 0.8380070469353114, Imports -1.6446433242653635.
- Figure 5 (Confidence Indices): Business Confidence 2017-01-31T00:00:00.000Z examples: ARG 1.13401187695703, BRA -0.5039539045781234, CHL -1.1754029928045016, COL 0.2105754411221014, MEX -0.957231875028227. Consumer Confidence same date: ARG -0.6013305382106542, BRA -1.2126709359865813, CHL -0.9538598334677285, COL -1.7366776559600947, MEX -1.5284584638017238.
- Figure 6 (Confidence and the Growth Outlook): Brazil scenario values — Pessimistic 1, WEO 2.039205003964947, Optimistic 4; Consumer-confidence scenarios for Brazil — Pessimistic 0.3, WEO 2.039205003964947, Optimistic 2.6.
- Figure 7 (Labor Markets): Brazil formal employment 2014-01-31T00:00:00.000Z value 2.7970487831736612; LA4 country examples 2014-01-31T00:00:00.000Z Chile null, Colombia 9.35724650389449, Mexico 2.7452987810291596.
- Figure 8 (Financial Conditions and Corporate Leverage): FCI 2007:Q1 -1.702037935352543; Real credit growth 22.061783067152717; Corporate leverage median/mean for 2014:Q1 23.63032, 25.28193.
- Figure 9 (Internal and External Balances): URY inflation/indices 2018 7.960199004975118, 2019 7.499999999999998, 2020 6.999999999999992; output gap bounds "Lower" 3, "Upper" 7 (context columns preserved); example Current account balance 2002 value -1.2855637150354822; External financing requirements example country ARG 35.302823459608405 and Reserves 14.464254935600419.
- Figure 10 (Spillovers from China and the United States): USA response to China growth shock -0.03680251 and to increase in sovereign spreads -0.0357437; USA response to US growth shock on potential GDP -0.9961247 and to increase in sovereign spreads -0.04573439999999995.
- Figure 11 (Public Debt): General government gross debt example 2002 for Latin America and the Caribbean 58.13489850102032 and for Emerging market and developing economies 51.79121882216714; country example BRB domestic currency 86.72251959513288, foreign currency 28.688086520231952, EMDE 53.33643873682777.
- Figure 12 (Fiscal Impulse, Real Policy Rate, and Real Neutral Rate): ARG fiscal impulse 2018 -3.025205931595431, 2019 -2.4055530665388876, 2020 -1.937749415217222; MEX latest real policy rate 4.20199493568416, Neutral rate (Min) 2, Neutral rate (Max) 2.5.
- Figure 13 (Structural Indicators): WDI/PISA/Ease of Doing Business percentile examples include 56.9636688232422, Latin America 43.31490349769592, Advanced economies 72.32889783704603, Corruption perception distribution example Latin America and the Caribbean 70, Advanced economies 88, Emerging market and developing economies 70.
- Figure 14 (CAPDR: Inflation): August 2019 example NIC 6.299249312258115.
- Box Figure 1.1 (Impact of Venezuela's Migration Crisis): Government expenditure impact example CAN 0.0010703762612006816; PRY 0.0013005691269337863 (Percent of GDP; 2023).
- Annex Figure 1.1 (Capital Flows and Sudden Stops): LA7 portfolio flows sensitivity -0.08 (2000–18) and -0.17 (2012–18); Policy responses: Fiscal 58.06451612903226 (percent of cases), Other countries 38.23529411764706; Floating regime example 8.3 and 5.2.
- Annex Figure 1.2 (Effects of Consolidation Announcements on EMBIG Spreads): Period 1 unrestricted sample effect -2.703400135040283; Dummy1 -0.5010147476196289; Dummy2 -4.4047707748413085; conditional fiscal stress case includes -7.946188926696777; IMF support case includes -4.087580680847168.
- Annex Figure 1.3 (Informality): Okun's coefficient (No lags) series examples AE -0.2528273, EM -0.1301467, LAC -0.1778989, SA -0.2055698, CA -0.11567331666666668, MEX -0.1837077; USA ISO code informal employment 18.3, Okun's coefficient -0.3144452; LAC no-lags value -0.2664931647058823 and one-lag -0.32723228823529416.

### Notes on semantics and labels (as they appear in the dataset)
- Units and labels preserved from the dataset include: "(Percent)", "(Year-over-year percent change; weighted by exports)", "(Index: 2011 = 100)", "(Billions of US dollars)", "(Year-over-year percent change; excludes Venezuela)", "(Year-over-year percent change; seasonally adjusted)", "(Normalized; three-month moving average)", "(VIX)", "(Basis points)", "(Percent of potential GDP; excludes Venezuela)", "(Percent of GDP; excludes Venezuela)", "(Percent of GDP)", "(Percent; one-year impact)", "(Percent of fiscal year GDP)", "(Percentage points of GDP; +/– = loosening/tightening)", "(Percentile ranks, unless otherwise indicated)", "(12-month percentage change)", "(Percent of GDP; 2023)", "(Percent; average 2017–30)", "(Okun's coefficient; average)".
- Region and country labels used in sample rows: World, LAC, CHN, JPN-KOR, USA-CAN, EU, Other, ARG, BRA, CHL, COL, MEX, PER, URY, VEN, BRB, NIC, CAN, PRY, USA, LA7, EMDE, Advanced economies, Emerging market and developing economies.

*Source: https://www.imf.org/-/media/files/publications/reo/whd/2019/october/english/data.xlsx*

---


_Source: https://www.imf.org/-/media/files/publications/reo/whd/2019/october/english/data.xlsx_