## Figure 1.19 (dataset overview)

## Source details

**Canonical URL:** [Figure 1.19 (dataset overview)](https://www.imf.org/-/media/files/publications/gfsr/2019/april/english/ch1data/ch1csv/figure1-19.csv)

## Other formats

- [Markdown version](/-/media/files/publications/gfsr/2019/april/english/ch1data/ch1csv/figure1-19.csv.md)
- [Structured JSON version](/-/media/files/publications/gfsr/2019/april/english/ch1data/ch1csv/figure1-19.csv.json)

---

### Dataset description
- Title text present in the worksheet: "Figure 1.18. Selected Euro Area Countries: Insurers� Exposures to Sovereign, Bank, and Corporate Bonds".
- Worksheet name: "csv".
- Worksheet dimensions: rowCount = 283, columnCount = 32.
- The worksheet contains multi-panel content headings for multiple figures/panels including:
  - "1. Banking Sector Interest Rates on New Loans and Funding"
  - "2. Central Bank Liquidity Support to Banking Systems"
  - "3. Estimated Impact of Provisioning to Fully Cover New Nonperforming"
  - "4. Estimated Losses from Reducing Gross Nonperforming Loan Ratios"

### Key columns and variable labels (as they appear)
- "Lending rate"
- "Deposit rate"
- "Estimated bank bond yield"
- "German government bond yield"
- Country codes/header entries appearing in the sheet: "ITA", "ESP", "PRT", "GRC", "SVN", "AUT", "BEL", "FRA", "NLD", "DEU"

### Sample dated observations (exact entries preserved)
- Row with date "1/31/2009":
  - Lending rate: "4.54"
  - Deposit rate: "2.91"
  - Estimated bank bond yield: "3.77"
  - German government bond yield: "1.12"
  - Country exposures (sample): "0" for ITA, "0" for ESP
- Row with date "2/28/2009":
  - Lending rate: "4.35"
  - Deposit rate: "2.46"
  - Estimated bank bond yield: "3.85"
  - German government bond yield: "0.79"
  - An integer entry: "1"
  - ESP exposure: "6.606090832"
- Row with date "3/31/2009":
  - Lending rate: "4.05"
  - Deposit rate: "2.23"
  - Estimated bank bond yield: "3.84"
  - German government bond yield: "0.50"
  - An integer entry: "1"
  - ESP exposure: "6.606090832"
  - Textual entries in later columns (preserved exactly):
    - "2017"
    - "The same as for the last five years"
    - "The same as during the euro area crisis"
    - (repeated) "2017"
    - "The same as for the last five years"
    - "The same as during the euro area crisis"

### Structure and content notes
- The worksheet mixes numeric time series (dates and interest rates) with panel titles, country exposure columns, integer flags, and textual annotations.
- Numeric precision is variable (e.g., "6.606090832" appears with high precision; interest rates shown as e.g. "4.54", "2.91", "3.77", "1.12").
- Several cells and columns are empty strings ("") in the sample rows; the sheet appears to contain layout rows and header rows interspersed with data rows.
- The file contains content spanning multiple conceptual panels (banking-sector rates, central-bank liquidity, provisioning impacts, NPL loss estimates) within the same worksheet.

*Source: figure1-19.csv (worksheet "csv")*

---


_Source: https://www.imf.org/-/media/files/publications/gfsr/2019/april/english/ch1data/ch1csv/figure1-19.csv_