Name: Euro Yields - Coefficients - Daily Data
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Euro Yields - Coefficients - Daily Data

This Eurostat dataset contains data on euro yields - coefficients - daily data, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2009-03-27T11:00:00+0100

Tables

Euro Yields - Coefficients - Daily Data - Raw

@eurostat.irt_h_eurcoe_d.raw

1.42 MB
18 rows
1,663 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "yld_curv" VARCHAR,
  "coef" VARCHAR,
  "geo" VARCHAR,
  "n_1999_01_04" DOUBLE  -- 1999-01-04,
  "n_1999_01_05" DOUBLE  -- 1999-01-05,
  "n_1999_01_06" DOUBLE  -- 1999-01-06,
  "n_1999_01_07" DOUBLE  -- 1999-01-07,
  "n_1999_01_08" DOUBLE  -- 1999-01-08,
  "n_1999_01_11" DOUBLE  -- 1999-01-11,
  "n_1999_01_12" DOUBLE  -- 1999-01-12,
  "n_1999_01_13" DOUBLE  -- 1999-01-13,
  "n_1999_01_14" DOUBLE  -- 1999-01-14,
  "n_1999_01_15" DOUBLE  -- 1999-01-15,
  "n_1999_01_18" DOUBLE  -- 1999-01-18,
  "n_1999_01_19" DOUBLE  -- 1999-01-19,
  "n_1999_01_20" DOUBLE  -- 1999-01-20,
  "n_1999_01_21" DOUBLE  -- 1999-01-21,
  "n_1999_01_22" DOUBLE  -- 1999-01-22,
  "n_1999_01_25" DOUBLE  -- 1999-01-25,
  "n_1999_01_26" DOUBLE  -- 1999-01-26,
  "n_1999_01_27" DOUBLE  -- 1999-01-27,
  "n_1999_01_28" DOUBLE  -- 1999-01-28,
  "n_1999_01_29" DOUBLE  -- 1999-01-29,
  "n_1999_02_01" DOUBLE  -- 1999-02-01,
  "n_1999_02_02" DOUBLE  -- 1999-02-02,
  "n_1999_02_03" DOUBLE  -- 1999-02-03,
  "n_1999_02_04" DOUBLE  -- 1999-02-04,
  "n_1999_02_05" DOUBLE  -- 1999-02-05,
  "n_1999_02_08" DOUBLE  -- 1999-02-08,
  "n_1999_02_09" DOUBLE  -- 1999-02-09,
  "n_1999_02_10" DOUBLE  -- 1999-02-10,
  "n_1999_02_11" DOUBLE  -- 1999-02-11,
  "n_1999_02_12" DOUBLE  -- 1999-02-12,
  "n_1999_02_15" DOUBLE  -- 1999-02-15,
  "n_1999_02_16" DOUBLE  -- 1999-02-16,
  "n_1999_02_17" DOUBLE  -- 1999-02-17,
  "n_1999_02_18" DOUBLE  -- 1999-02-18,
  "n_1999_02_19" DOUBLE  -- 1999-02-19,
  "n_1999_02_22" DOUBLE  -- 1999-02-22,
  "n_1999_02_23" DOUBLE  -- 1999-02-23,
  "n_1999_02_24" DOUBLE  -- 1999-02-24,
  "n_1999_02_25" DOUBLE  -- 1999-02-25,
  "n_1999_02_26" DOUBLE  -- 1999-02-26,
  "n_1999_03_01" DOUBLE  -- 1999-03-01,
  "n_1999_03_02" DOUBLE  -- 1999-03-02,
  "n_1999_03_03" DOUBLE  -- 1999-03-03,
  "n_1999_03_04" DOUBLE  -- 1999-03-04,
  "n_1999_03_05" DOUBLE  -- 1999-03-05,
  "n_1999_03_08" DOUBLE  -- 1999-03-08,
  "n_1999_03_09" DOUBLE  -- 1999-03-09,
  "n_1999_03_10" DOUBLE  -- 1999-03-10,
  "n_1999_03_11" DOUBLE  -- 1999-03-11,
  "n_1999_03_12" DOUBLE  -- 1999-03-12,
  "n_1999_03_15" DOUBLE  -- 1999-03-15,
  "n_1999_03_16" DOUBLE  -- 1999-03-16,
  "n_1999_03_17" DOUBLE  -- 1999-03-17,
  "n_1999_03_18" DOUBLE  -- 1999-03-18,
  "n_1999_03_19" DOUBLE  -- 1999-03-19,
  "n_1999_03_22" DOUBLE  -- 1999-03-22,
  "n_1999_03_23" DOUBLE  -- 1999-03-23,
  "n_1999_03_24" DOUBLE  -- 1999-03-24,
  "n_1999_03_25" DOUBLE  -- 1999-03-25,
  "n_1999_03_26" DOUBLE  -- 1999-03-26,
  "n_1999_03_29" DOUBLE  -- 1999-03-29,
  "n_1999_03_30" DOUBLE  -- 1999-03-30,
  "n_1999_03_31" DOUBLE  -- 1999-03-31,
  "n_1999_04_01" DOUBLE  -- 1999-04-01,
  "n_1999_04_06" DOUBLE  -- 1999-04-06,
  "n_1999_04_07" DOUBLE  -- 1999-04-07,
  "n_1999_04_08" DOUBLE  -- 1999-04-08,
  "n_1999_04_09" DOUBLE  -- 1999-04-09,
  "n_1999_04_12" DOUBLE  -- 1999-04-12,
  "n_1999_04_13" DOUBLE  -- 1999-04-13,
  "n_1999_04_14" DOUBLE  -- 1999-04-14,
  "n_1999_04_15" DOUBLE  -- 1999-04-15,
  "n_1999_04_16" DOUBLE  -- 1999-04-16,
  "n_1999_04_19" DOUBLE  -- 1999-04-19,
  "n_1999_04_20" DOUBLE  -- 1999-04-20,
  "n_1999_04_21" DOUBLE  -- 1999-04-21,
  "n_1999_04_22" DOUBLE  -- 1999-04-22,
  "n_1999_04_23" DOUBLE  -- 1999-04-23,
  "n_1999_04_26" DOUBLE  -- 1999-04-26,
  "n_1999_04_27" DOUBLE  -- 1999-04-27,
  "n_1999_04_28" DOUBLE  -- 1999-04-28,
  "n_1999_04_29" DOUBLE  -- 1999-04-29,
  "n_1999_04_30" DOUBLE  -- 1999-04-30,
  "n_1999_05_04" DOUBLE  -- 1999-05-04,
  "n_1999_05_05" DOUBLE  -- 1999-05-05,
  "n_1999_05_06" DOUBLE  -- 1999-05-06,
  "n_1999_05_07" DOUBLE  -- 1999-05-07,
  "n_1999_05_10" DOUBLE  -- 1999-05-10,
  "n_1999_05_11" DOUBLE  -- 1999-05-11,
  "n_1999_05_12" DOUBLE  -- 1999-05-12,
  "n_1999_05_13" DOUBLE  -- 1999-05-13,
  "n_1999_05_14" DOUBLE  -- 1999-05-14,
  "n_1999_05_17" DOUBLE  -- 1999-05-17,
  "n_1999_05_18" DOUBLE  -- 1999-05-18,
  "n_1999_05_19" DOUBLE  -- 1999-05-19,
  "n_1999_05_20" DOUBLE  -- 1999-05-20
);

Euro Yields - Coefficients - Daily Data - Unpivoted

@eurostat.irt_h_eurcoe_d.tidy

297.55 kB
29,862 rows
6 columns

CREATE TABLE tidy (
  "freq" VARCHAR,
  "yld_curv" VARCHAR,
  "coef" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);