## Dataset: boxfigure-221

## Source details

**Canonical URL:** [Dataset: boxfigure-221](https://www.imf.org/-/media/files/publications/gfsr/2019/april/english/ch2data/csv/boxfigure-221.csv)

## Other formats

- [Markdown version](/-/media/files/publications/gfsr/2019/april/english/ch2data/csv/boxfigure-221.csv.md)
- [Structured JSON version](/-/media/files/publications/gfsr/2019/april/english/ch2data/csv/boxfigure-221.csv.json)

---

### Dataset scope and structure
- Worksheet name: "csv"
- Row count: 149
- Column count: 32
- Top-level figure headings present in columns:
  - "1. Downside Risks to House Prices across US Cities"
  - "2. Downside Risks to House Prices across Canadian Cities"
  - "3. House Prices at Risk (HaR) and Valuations across US Cities"
  - "4. House Prices at Risk (HaR) and Valuations across Canadian Cities"
  - "5. Capital Flows as Drivers of HaR in United States"
  - "6. Capital Flows as Drivers of HaR in Canada"
- Subtitles and notes appearing in the sheet:
  - "(Five percent HaR, four quarters ahead)"
  - "(Selected American cities; coefficients: 10th percentile; GaR four"
  - "(Selected American cities; coefficients: 10th percentile; GaR four quarters ahead)"
  - Column categories observed: "10th percentile", "Median", "90th percentile"
  - Variables for valuation/HaR panels: "City", "House price to income ratio", "One-year ahead HaR"

### Variables and formats observed
- Time-period index entries in quarterly format (example values): "1982Q2", "1982Q3", "1982Q4", "1983Q1", "1983Q2", "1983Q3", "1983Q4"
- Numerical series given with full precision (negative and positive decimals). Example series under percentile columns:
  - 1982Q2: "-26.37258158", "-15.06543099", "-5.865455703"
  - 1982Q3: "-24.11879779", "-14.33966673", "-4.409081175"
  - 1982Q4: "-22.01153391", "-12.16060817", "-2.538213555"
  - 1983Q1: "-20.04912239", "-10.23175738", "-2.113515088"
  - 1983Q2: "-16.33977829", "-8.347344227", "-1.055524746"
  - 1983Q3: "-15.52286125", "-5.270882629", "-0.198849606"
- Valuation and HaR sample rows (panel 3 and 4):
  - Year "2008", City index "1", "House price to income ratio" "1.319435", "One-year ahead HaR" "-18.571933"
  - Year "2008", City index "1", "House price to income ratio" "1.215302", "One-year ahead HaR" "-10.925551"
  - City index "2", "House price to income ratio" "1.498821", "One-year ahead HaR" "-8.735095"
  - City index "2", "House price to income ratio" "1.284001", "One-year ahead HaR" "-18.585155"
  - City index "3", "House price to income ratio" "1.722304", "One-year ahead HaR" "-16.040644"
  - City index "3", "House price to income ratio" "0.9464027", "One-year ahead HaR" "-1.5852513"
  - City index "4", "House price to income ratio" "1.24949", "One-year ahead HaR" "-8.758248"
  - City index "4", "House price to income ratio" "1.016805", "One-year ahead HaR" "-0.30413486"
  - City index "5", "House price to income ratio" "1.420235", "One-year ahead HaR" "-20.721772"
  - City index "5", "House price to income ratio" "1.013563", "One-year ahead HaR" "0.57899397"
  - City index "6", "House price to income ratio" "1.071024", "One-year ahead HaR" "-19.184891"
  - City index "6", "House price to income ratio" "1.018624", "One-year ahead HaR" "3.5386122"

### Capital flows and coefficients (selected entries)
- Column labels observed for capital flows regression panels: "Foreign direct investments", "Other capital flows"
- Sample city-level coefficients and capital-flow values:
  - New York: "-0.85946", "0.09291"
  - Boston: "0.21074", "0.08461"
  - Phoenix: "-1.14151", "-0.02587"
  - Philadelphia: "-0.71968", "-0.12028"
  - Quebec City: "0.6281589", "0.5199257"
  - St. Catharines: "0.1465946", "0.4040017"
  - Canada (aggregate): "-1.440322", "0.1659449"
  - Victoria: "-0.2997707", "0.1039687"

### Notable dataset features for analysis
- Multiple panels in a single worksheet comparing:
  - Downside risks to house prices across US and Canadian cities at percentile bands (10th percentile, Median, 90th percentile)
  - House Prices at Risk (HaR) and valuations across US and Canadian cities with "House price to income ratio" and "One-year ahead HaR"
  - Role of capital flows ("Foreign direct investments", "Other capital flows") as drivers of HaR for United States and Canada
- Precision is maintained throughout: quarterly time stamps, integer year labels, and decimal coefficients with up to 11 significant digits in some cells (for example "-26.37258158")

*Source: boxfigure-221 (csv worksheet)*

---


_Source: https://www.imf.org/-/media/files/publications/gfsr/2019/april/english/ch2data/csv/boxfigure-221.csv_