## Dataset overview

## Source details

**Canonical URL:** [Dataset overview](https://www.imf.org/-/media/files/publications/gfsr/2017/october/chapter-3/csv-data/data-appendix.xlsx)

## Other formats

- [Markdown version](/-/media/files/publications/gfsr/2017/october/chapter-3/csv-data/data-appendix.xlsx.md)
- [Structured JSON version](/-/media/files/publications/gfsr/2017/october/chapter-3/csv-data/data-appendix.xlsx.json)

---

### Dataset scope and structure
- Type: dataset (XLSX or CSV) — data-appendix
- Worksheets: 3 (names and respective sizes)
  - "Read_me": rowCount 16415, columnCount 10
  - "Countries included in fig_3.2": rowCount 178, columnCount 40
  - "Rest of the countries": rowCount 178, columnCount 103

### Variables and measures included
- Repeated column headers (per country block):
  - "5th percentile (percent)"
  - "Median (percent)"
  - "95th percentile (percent)"
  - "FCI (standard deviations)"
- Time identifiers observed in sample rows:
  - Quarterly format examples: "1991:Q1", "91:Q2", "73:Q2", "1973:Q1", "1981:Q1"
  - Alternative quarter format examples: "1981Q1", "1991Q1", "1973Q1", "1992Q1"

### Countries / country blocks (as presented in worksheets)
- Countries listed explicitly in the "Countries included in fig_3.2" worksheet (sample ordering shows):
  - 1. Brazil
  - 2. Australia
  - 3. South Africa
  - 4. Sweden
  - 5. Turkey
  - 6. United States
- "Rest of the countries" worksheet includes blocks for:
  - Canada, Chile, China, France, Germany, India, Indonesia, Italy, Japan, Korea, Mexico, Russia, Spain, Switzerland, United Kingdom
  - Each block repeats the same four core measures per quarter as listed above

### Sample data points (exact values from sample rows)
- From "Countries included in fig_3.2" (Brazil block, first sample row):
  - Date: "1991:Q1"
  - 5th percentile (percent): -13.5573477
  - Median (percent): -2.976610184
  - 95th percentile (percent): -2.619803035
  - FCI (standard deviations): 0.033523706
- From "Countries included in fig_3.2" (United States block, first sample row):
  - Date: "1973:Q1"
  - 5th percentile (percent): -0.05459215
  - Median (percent): 2.396822814
  - 95th percentile (percent): 5.852929541
  - FCI (standard deviations): 6.084518621
- From "Rest of the countries" (Canada block, first sample row):
  - Date: "1981Q1"
  - 5th percentile (percent): -0.8984531239102578
  - Median (percent): 2.6587204220502434
  - 95th percentile (percent): 5.505953668376983
  - FCI (standard deviations): -0.9250224031418388

### Data layout notes relevant for use
- Country data are presented in repeated column blocks: each country block contains the four measures ("5th percentile (percent)", "Median (percent)", "95th percentile (percent)", "FCI (standard deviations)") aligned under the country header.
- Time identifiers in the sample rows appear in multiple quarterly formats (e.g., "1991:Q1" and "1991Q1"); users should account for both formats when parsing.
- Many cells in the sample rows are null where column spacing or block alignment exists; the worksheet columnCount values (40 and 103) reflect repeated blocks rather than unique variable names.

_This dataset overview is derived from the worksheet metadata and sample rows contained in the supplied data-appendix.xlsx content unit._

---


_Source: https://www.imf.org/-/media/files/publications/gfsr/2017/october/chapter-3/csv-data/data-appendix.xlsx_