## Dataset overview

## Source details

**Canonical URL:** [Dataset overview](https://www.imf.org/-/media/files/publications/reo/whd/2020/oct/english/data.xlsx)

## Other formats

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

---

### Dataset identity and scope
- Filename: data (canonical URL provided separately).
- Publication type: dataset (XLSX or CSV).
- Workbook contains multiple worksheets focused on the Western Hemisphere Department Regional Economic Outlook (October 2020) and accompanying figures, annexes, and boxes.
- Two explicit timestamp entries in sample rows: "2020-09-28T00:00:00.000Z" and "2020-09-28T00:00:00.000Z".

### Worksheet inventory (selected by name and row/column counts)
- "WHD REO (October 2020)": rowCount 32, columnCount 12.
- "Table of Contents": rowCount 48, columnCount 10.
- Figures:
  - "Figure 1": rowCount 253, columnCount 39.
  - "Figure 2": rowCount 43, columnCount 25.
  - "Figure 3": rowCount 1509, columnCount 59.
  - "Figure 4": rowCount 1770, columnCount 41.
  - "Figure 5": rowCount 43, columnCount 25.
  - "Figure 6": rowCount 43, columnCount 53.
  - "Figure 7": rowCount 78, columnCount 48.
  - "Figure 8": rowCount 467, columnCount 66.
  - "Figure 9": rowCount 78, columnCount 38.
  - "Figure 10": rowCount 78, columnCount 27.
  - "Figure 11": rowCount 78, columnCount 27.
  - "Figure 12": rowCount 78, columnCount 23.
  - "Figure 13": rowCount 151, columnCount 31.
  - "Figure 14": rowCount 151, columnCount 38.
  - "Figure 15": rowCount 43, columnCount 29.
  - "Figure 16": rowCount 228, columnCount 28.
  - "Figure 17": rowCount 15, columnCount 34.
- Box and Annex content:
  - "Box Figure 1.1": rowCount 201, columnCount 27.
  - Multiple Annex Figures (e.g., "Annex Figure 1.1": rowCount 42, columnCount 29; "Annex Figure 2.1": rowCount 40, columnCount 39; "Annex Figure 3.1": rowCount 102, columnCount 30; "Annex Figure 4.1": rowCount 102, columnCount 31).
- Numerous Tables and Box Tables with minimal sample rows (e.g., "Table 1", "Table 2", "Table 3", "Box Table 1.1", "Annex Table 1.1") appear as placeholders (rowCount 1).

### Thematic coverage (from worksheet titles and headers)
- COVID-19 pandemic developments and indicators (Figure 1: "Recent Developments in the COVID-19 Pandemic"; subpanels include "COVID-19 Confirmed Cases and Deaths", "COVID-19 Deaths and Containment Stringency Index", "Containment Stringency", "Hospital Beds and Tests").
- Contact intensity and remote work (Figure 2: "Contact Intensity and Remote WorkSources"; panels include "Share of Employment in Contact-Intensive Sectors", "Exposure to Contact-Intensive Sectors", "Share of Teleworkable Jobs").
- Global economic conditions, trade, tourism, remittances, commodity prices, and export values (Figure 3).
- Financial conditions and capital flows, including sovereign and corporate spreads, EPFR flows, and exchange rates (Figure 4).
- Changes in holders of public debt denominated in local currency (Figure 5).
- Recession characteristics, activity indices, and sectoral demand impacts (Figure 6).
- Recovery dynamics: retail sales, PMI, business confidence, employment indices (Figure 7).
- Fiscal and monetary developments: discretionary fiscal measures, fiscal balances, policy rates, credit growth (Figure 8).
- Growth projections, contributions to GDP growth, and drivers of growth (Figures 9 and 10).
- External sector developments, trading partners’ growth, commodity prices, current account balances (Figure 11).
- Long-run real GDP per capita series (Figure 12).
- Inflation forecasts and output gaps (Figure 13).
- Scarring: forecast revisions, cumulative investment losses, tenure premium, productivity impacts (Figure 14).
- Debt outlook: drivers of change in public debt and public debt service (Figure 15).
- Financial and corporate developments: CEMBI spreads and MSCI indices (Figure 16).
- Social safety net program coverage and adequacy (Figure 17).
- Debt restructuring pre/post dynamics and bond prices (Box Figure 1.1).
- Determinants of containment effectiveness, employment changes by worker characteristics, effects of COVID-19 measures, corporate and financial vulnerabilities (Annex Figures).

### Sample numeric values and exact figures (preserved verbatim)
- Timestamps:
  - "2020-09-28T00:00:00.000Z"
- Contact intensity / telework metrics (Figure 2 sample):
  - LIC: 27.29667
  - LIC: 13.28495
- Changes in holders of local-currency public debt (Figure 5 sample; percent change; March to August 2020):
  - Brazil: Foreign investors -0.025957818544864748, Institutional investors 2.414077124672412, Commercial banks 1.9643079995008115, Other residents -0.16747784849619488, Total 4.184699862723074
  - Colombia: Foreign investors 0.8582846222413075, Institutional investors 2.722311239837826, Commercial banks -1.3214066643742752, Central bank 0.2086169822219893, Other residents 1.2596120591979276, Total 3.727418239124769
  - Mexico: Foreign investors -5.76534849092704, Institutional investors 0.9363560231748738, Commercial banks 6.359795495053752, Other residents -1.4410321650022766, Repos 0.7032351444970953, Total 0.7930060067963929
  - Peru: Foreign investors 2.9321930360415425, Institutional investors -6.294260051132379, Commercial banks 4.186369224039759, Central bank 0, Other residents -1.3914341953437956, Total -0.5671319863948754
- Figure 6: Real GDP growth panels reference "LA5" and country labels Brazil, Chile, Colombia, Mexico, Peru.
- Figure 8: Fiscal measures described in "(Percent of GDP)" and panels labeled "Above the line", "Below the line", "Contingent liabilities and others"; country labels include BRA, CHL, COL, CRI, MEX, PRY, PER, USA.
- Figure 12: Time series sample rows:
  - 1965, 7.41774433309424
  - 1966, 7.536556826227591
  - 1967, 7.641389924285011
  - 1968, 8.006657048321435
  - 1969, 8.254530586125462
  - 1970, 8.355431634630866
- Figure 13: End-of-period inflation panels and target ranges; years listed: 2019, 2020, 2021.
- Figure 14: Brazil sample coefficient: 1.16 (Tenure Premium panel).
- Annex Figure 2.1 sample employment changes for Brazil:
  - Male: -7.5577112135176705
  - Female: -12.350107526881715
  - Age groups: "<24" to ">60" include values such as -18.596918085969182, -10.81191469498497, -6.261694557912767, -6.530239833159546
  - Education changes: -21.634185277088502, -4.795341397849462, 3.281433691756286
  - Informality: -12.339535745480534, -5.937410278495547
- Figure 17: Social safety net coverage and adequacy (Percent) for Q1 (Poorest):
  - Coverage Q1 (Poorest): BRA 64.1510009765625, CHL 90.45658874511719, COL 83.32312774658203, MEX 61.2167854309082, PER 88.02033233642578, EMDE 71.70366668701172, LAC 76.8524284362793
  - Adequacy Q1 (Poorest): BRA 33.9965705871582, CHL 15.489591598510742, COL 13.195830345153809, MEX 29.7194881439209, PER 12.255077362060547, EMDE 23.27478790283203, LAC 23.97808837890625

### File structure and data usage notes (from sample rows)
- Many figure worksheets include multiple numbered panels (e.g., "1. ...", "2. ...", etc.) and units explicitly stated in headers, such as:
  - "(Per million people)", "(Stringency index: 14-day lagged, dashed line; new deaths per million: 14-day moving average, solid line, right scale)", "(Index: December 2019 = 100)", "(Percent of GDP)", "(Percent, year-over-year)", "(Billions of US dollars; Pre: solid line;Post: dashed line)".
- Country and region labels frequently used: World, LAC, CHN, JPN-KOR, USA-CAN, EU, Other, LA5, LA7, BRA, CHL, COL, MEX, PER, BOL, DOM, SLV, GTM, HND, PRY, CRI, USA, EMDE, EME, CEEMEA.
- Multiple worksheets contain empty or placeholder rows indicating structure for charts and table headers rather than raw tabular time series in the sample rows.

### Intended analytical themes (inferred from worksheet headings and panels)
- Pandemic epidemiology and policy stringency metrics tied to economic outcomes.
- Labor market impacts across gender, age, education, and informality.
- Sectoral exposure to contact intensity and teleworkability.
- Short-term projections and scenario comparisons for GDP, inflation, fiscal balances, and debt dynamics.
- Financial market stress indicators and corporate vulnerabilities.
- Social safety net coverage and adequacy metrics for the poorest quintile.

_This overlay is generated from the supplied dataset workbook sample rows and worksheet metadata._

---


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