## Dataset overview

## Source details

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

## Other formats

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

---

### Dataset description
- Publication type: dataset (XLSX or CSV)
- Canonical source URL: https://www.imf.org/-/media/files/publications/reo/whd/2021/english/data.xlsx
- Worksheets: 45 (listed in the provided metadata)
- Dataset covers figures, boxes, and annex figures associated with the Regional Economic Outlook (Western Hemisphere Department), as reflected in worksheet names such as "Figure 1" through "Figure 18", "Table 1", "Box Figure 1.1", and multiple "Annex Figure" sheets.

### Worksheets inventory (name and dimensions)
- "WHD REO (October 2021)" — rowCount: 32; columnCount: 12
- "Table of Contents" — rowCount: 51; columnCount: 10
- "Figure 1" — rowCount: 594; columnCount: 66
- "Figure 2" — rowCount: 40; columnCount: 75
- "Figure 3" — rowCount: 1509; columnCount: 54
- "Figure 4" — rowCount: 1770; columnCount: 42
- "Figure 5" — rowCount: 994; columnCount: 44
- "Figure 6" — rowCount: 49; columnCount: 49
- "Figure 7" — rowCount: 78; columnCount: 47
- "Figure 8" — rowCount: 466; columnCount: 66
- "Figure 9" — rowCount: 78; columnCount: 38
- "Figure 10" — rowCount: 78; columnCount: 53
- "Figure 11" — rowCount: 78; columnCount: 38
- "Figure 12" — rowCount: 75; columnCount: 36
- "Figure 13" — rowCount: 151; columnCount: 30
- "Figure 14" — rowCount: 151; columnCount: 38
- "Figure 15" — rowCount: 43; columnCount: 27
- "Figure 16" — rowCount: 227; columnCount: 33
- "Figure 17" — rowCount: 15; columnCount: 29
- "Figure 18" — rowCount: 34; columnCount: 28
- "Table 1" — rowCount: 1; columnCount: 1
- "Box Figure 1.1" — rowCount: 425; columnCount: 27
- "Box Figure 1.2" — rowCount: 25; columnCount: 17
- "Box Figure 2.1" — rowCount: 26; columnCount: 39
- "Box Figure 2.2" — rowCount: 21; columnCount: 38
- "Annex Figure 2.1" — rowCount: 40; columnCount: 33
- "Annex Figure 2.2" — rowCount: 38; columnCount: 39
- "Annex Figure 3.1" — rowCount: 102; columnCount: 30
- "Annex Figure 3.2" — rowCount: 20; columnCount: 18
- "Annex Figure 4.1" — rowCount: 792; columnCount: 37
- "Annex Figure 5.1" — rowCount: 44; columnCount: 23
- "Annex Figure 5.2" — rowCount: 30; columnCount: 17

### Representative content and exact numeric values from sample rows
- Timestamps and dates appearing in samples:
  - "2021-10-21T00:00:00.000Z"
  - "2019-01-31T00:00:00.000Z"
  - "2020-01-01T00:00:00.000Z"
  - "2020Q1"
  - "2021-10-01T00:00:00.000Z"
  - "Jan-2019"
  - "Jan-2019" (inflation index context)
  - Multiple monthly dates: "2020-01-31T00:00:00.000Z", "2020-02-29T00:00:00.000Z", "2020-03-31T00:00:00.000Z", "2020-04-30T00:00:00.000Z", "2020-05-31T00:00:00.000Z", "2020-06-30T00:00:00.000Z", "2020-07-31T00:00:00.000Z", "2020-08-31T00:00:00.000Z", "2020-09-30T00:00:00.000Z", "2020-10-31T00:00:00.000Z", "2020-11-30T00:00:00.000Z", "2020-12-31T00:00:00.000Z", "2021-01-31T00:00:00.000Z", "2021-02-28T00:00:00.000Z", "2021-03-31T00:00:00.000Z", "2021-04-30T00:00:00.000Z", "2021-05-31T00:00:00.000Z", "2021-06-30T00:00:00.000Z"
- Selected numeric sample values preserved exactly:
  - Figure 1 sample row: "Unexposed sectors", 54.89133, 160.481, 97.59988
  - Figure 3 sample row: 264.651, 154.5, 107, 292
  - Figure 3 sample row: Jan-2020, 10.888097497258197, 24.47161047351579, 28.65, 50.21
  - Figure 3 sample row: 2020-01-01T00:00:00.000Z, 0, 0
  - Figure 4 sample row: 2018, 19.75498, 21.262099999999997
  - Figure 4 sample row: 2019-12-31T00:00:00.000Z, 16.292115064569753, 2.815576939322888, 132.95202945141654
  - Figure 5 sample row: BRA, 7.209474394945345, -6.708778603748863, -0.8154833907424051
  - Figure 5 sample row: BRA, 87.6578395633004, 98.94335608474437, 90.18670574421233
  - Figure 5 sample row (policy rates): 2019-01-01T00:00:00.000Z, 6.5, 2.75, 4.25, 5.25, 8.25, 5.25, 2.75, 2.375
  - Figure 5 sample row (credit growth): Jan-2019, 4.104525614011319, 7.093162068850802, 6.386013239708956, 5.625537049852005
  - Figure 6 sample row (inflation indices): Jan-2019, 100, 99.99999999999999, 100, 99.99999999999999
  - Figure 6 sample row (trendlines): 100.04748083537413, 100.10471466882143
  - Figure 11 sample row: "2021-10-01T00:00:00.000Z", "Pre-pandemic"
  - Figure 13 sample row: "Real GDP", -4.741642431436996
  - Figure 14 sample rows (Brazil, Percent of GDP):
    - 2019, 8.08664965668391, 5.881325800714543
    - 2020, 10.7788037849272, 13.36829664042964
    - 2021, 15.8205918191814, 6.158982867590447
  - Figure 15 sample row (poverty/gini): 2011, 26.562453243669992; 2000, 52.737500000000004
  - Figure 16 sample row (Annex/monetary): 2022, 2.1350709912397052, 0.270800881716724, 0.1969213705728965, 0.2793428958051791
  - Figure 17 sample row (school closures): "All Economies ", 32.25238095238095
  - Box Figure 2.2 sample row (Tourism-dependent Real GDP, October 2021): 100, 90.51678317436436, 92.62796188250718, 96.45476735620264, 99.3103682658594, 101.56488020884926, 103.37183698096972, 105.04912377097122
  - Annex Figure 4.1 sample header: "Total Tax Revenue Collection, 2019", "(Percent of GDP)", "INCOME / GDP PER CAPITA", "Statutory", "Effective", "Revenue change relative to baseline", "Average effective PIT rate", "Gini change relative to baseline"
  - Annex Figure 5.1 sample header: "(Percent of 2030 BAU)", "$25 carbon tax", "$50 carbon tax", "$75 carbon tax", "NDC"

### Structure and terminology preserved
- Sheet titles preserve exact IMF nomenclature: "Figure", "Box Figure", "Annex Figure", "Table of Contents", and "WHD REO (October 2021)".
- Numeric precision and formatting are preserved exactly as in the sample rows (including negative values, decimal precision, and date-time ISO strings).
- Labels and index conventions preserved exactly where provided: e.g., "(7-day moving average; as of September 29, 2021)", "(Index: February 2020 = 100; median)", "(Year-over-year percent change)", "(Percent of GDP)", "(Number of weeks)", "(Fourteen-day moving average)".

### Usage notes (data extraction guidance)
- Many worksheets contain mixed headers and multi-row labels (for example, descriptive titles in top rows and axis/legend labels next). Expect to parse out header rows before numeric series.
- Time series appear with multiple date formats: ISO timestamps such as "2020-01-01T00:00:00.000Z", quarter codes like "2020Q1", and month labels like "Jan-2019".
- Several worksheets include rich-text elements (superscripts and bold within labels); extract text content while preserving numeric values exactly.

*Source: data.xlsx (WHD REO October 2021 dataset metadata and sample rows).*

---


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