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.35 MB
18 rows
1663 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "yld_curv" VARCHAR,
  "coef" VARCHAR,
  "geo" VARCHAR,
  "n_1999_01_04" DOUBLE,
  "n_1999_01_05" DOUBLE,
  "n_1999_01_06" DOUBLE,
  "n_1999_01_07" DOUBLE,
  "n_1999_01_08" DOUBLE,
  "n_1999_01_11" DOUBLE,
  "n_1999_01_12" DOUBLE,
  "n_1999_01_13" DOUBLE,
  "n_1999_01_14" DOUBLE,
  "n_1999_01_15" DOUBLE,
  "n_1999_01_18" DOUBLE,
  "n_1999_01_19" DOUBLE,
  "n_1999_01_20" DOUBLE,
  "n_1999_01_21" DOUBLE,
  "n_1999_01_22" DOUBLE,
  "n_1999_01_25" DOUBLE,
  "n_1999_01_26" DOUBLE,
  "n_1999_01_27" DOUBLE,
  "n_1999_01_28" DOUBLE,
  "n_1999_01_29" DOUBLE,
  "n_1999_02_01" DOUBLE,
  "n_1999_02_02" DOUBLE,
  "n_1999_02_03" DOUBLE,
  "n_1999_02_04" DOUBLE,
  "n_1999_02_05" DOUBLE,
  "n_1999_02_08" DOUBLE,
  "n_1999_02_09" DOUBLE,
  "n_1999_02_10" DOUBLE,
  "n_1999_02_11" DOUBLE,
  "n_1999_02_12" DOUBLE,
  "n_1999_02_15" DOUBLE,
  "n_1999_02_16" DOUBLE,
  "n_1999_02_17" DOUBLE,
  "n_1999_02_18" DOUBLE,
  "n_1999_02_19" DOUBLE,
  "n_1999_02_22" DOUBLE,
  "n_1999_02_23" DOUBLE,
  "n_1999_02_24" DOUBLE,
  "n_1999_02_25" DOUBLE,
  "n_1999_02_26" DOUBLE,
  "n_1999_03_01" DOUBLE,
  "n_1999_03_02" DOUBLE,
  "n_1999_03_03" DOUBLE,
  "n_1999_03_04" DOUBLE,
  "n_1999_03_05" DOUBLE,
  "n_1999_03_08" DOUBLE,
  "n_1999_03_09" DOUBLE,
  "n_1999_03_10" DOUBLE,
  "n_1999_03_11" DOUBLE,
  "n_1999_03_12" DOUBLE,
  "n_1999_03_15" DOUBLE,
  "n_1999_03_16" DOUBLE,
  "n_1999_03_17" DOUBLE,
  "n_1999_03_18" DOUBLE,
  "n_1999_03_19" DOUBLE,
  "n_1999_03_22" DOUBLE,
  "n_1999_03_23" DOUBLE,
  "n_1999_03_24" DOUBLE,
  "n_1999_03_25" DOUBLE,
  "n_1999_03_26" DOUBLE,
  "n_1999_03_29" DOUBLE,
  "n_1999_03_30" DOUBLE,
  "n_1999_03_31" DOUBLE,
  "n_1999_04_01" DOUBLE,
  "n_1999_04_06" DOUBLE,
  "n_1999_04_07" DOUBLE,
  "n_1999_04_08" DOUBLE,
  "n_1999_04_09" DOUBLE,
  "n_1999_04_12" DOUBLE,
  "n_1999_04_13" DOUBLE,
  "n_1999_04_14" DOUBLE,
  "n_1999_04_15" DOUBLE,
  "n_1999_04_16" DOUBLE,
  "n_1999_04_19" DOUBLE,
  "n_1999_04_20" DOUBLE,
  "n_1999_04_21" DOUBLE,
  "n_1999_04_22" DOUBLE,
  "n_1999_04_23" DOUBLE,
  "n_1999_04_26" DOUBLE,
  "n_1999_04_27" DOUBLE,
  "n_1999_04_28" DOUBLE,
  "n_1999_04_29" DOUBLE,
  "n_1999_04_30" DOUBLE,
  "n_1999_05_04" DOUBLE,
  "n_1999_05_05" DOUBLE,
  "n_1999_05_06" DOUBLE,
  "n_1999_05_07" DOUBLE,
  "n_1999_05_10" DOUBLE,
  "n_1999_05_11" DOUBLE,
  "n_1999_05_12" DOUBLE,
  "n_1999_05_13" DOUBLE,
  "n_1999_05_14" DOUBLE,
  "n_1999_05_17" DOUBLE,
  "n_1999_05_18" DOUBLE,
  "n_1999_05_19" DOUBLE,
  "n_1999_05_20" DOUBLE
);

Euro Yields - Coefficients - Daily Data - Unpivoted

@eurostat.irt_h_eurcoe_d.tidy

290.57 KB
29862 rows
6 columns


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