Baselight

Conversion Factors For Euro Fixed Series Into Euro/ECU - Monthly Data

Eurostat code: ert_bil_conv_m ยท (1971-01 - 2025-05)

@eurostat.ert_bil_conv_m

Loading...
Loading...

About this Dataset

Conversion Factors For Euro Fixed Series Into Euro/ECU - Monthly Data

This Eurostat dataset contains data on conversion factors for euro fixed series into euro/ecu - monthly 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: 2025-06-02T11:00:00+0200

Tables

Conversion Factors For Euro Fixed Series Into Euro/ECU - Monthly Data - Raw

@eurostat.ert_bil_conv_m.raw
  • 516.34 KB
  • 40 rows
  • 656 columns
Loading...

CREATE TABLE raw (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "geo" VARCHAR,
  "n_1971_01" DOUBLE,
  "n_1971_02" DOUBLE,
  "n_1971_03" DOUBLE,
  "n_1971_04" DOUBLE,
  "n_1971_05" DOUBLE,
  "n_1971_06" DOUBLE,
  "n_1971_07" DOUBLE,
  "n_1971_08" DOUBLE,
  "n_1971_09" DOUBLE,
  "n_1971_10" DOUBLE,
  "n_1971_11" DOUBLE,
  "n_1971_12" DOUBLE,
  "n_1972_01" DOUBLE,
  "n_1972_02" DOUBLE,
  "n_1972_03" DOUBLE,
  "n_1972_04" DOUBLE,
  "n_1972_05" DOUBLE,
  "n_1972_06" DOUBLE,
  "n_1972_07" DOUBLE,
  "n_1972_08" DOUBLE,
  "n_1972_09" DOUBLE,
  "n_1972_10" DOUBLE,
  "n_1972_11" DOUBLE,
  "n_1972_12" DOUBLE,
  "n_1973_01" DOUBLE,
  "n_1973_02" DOUBLE,
  "n_1973_03" DOUBLE,
  "n_1973_04" DOUBLE,
  "n_1973_05" DOUBLE,
  "n_1973_06" DOUBLE,
  "n_1973_07" DOUBLE,
  "n_1973_08" DOUBLE,
  "n_1973_09" DOUBLE,
  "n_1973_10" DOUBLE,
  "n_1973_11" DOUBLE,
  "n_1973_12" DOUBLE,
  "n_1974_01" DOUBLE,
  "n_1974_02" DOUBLE,
  "n_1974_03" DOUBLE,
  "n_1974_04" DOUBLE,
  "n_1974_05" DOUBLE,
  "n_1974_06" DOUBLE,
  "n_1974_07" DOUBLE,
  "n_1974_08" DOUBLE,
  "n_1974_09" DOUBLE,
  "n_1974_10" DOUBLE,
  "n_1974_11" DOUBLE,
  "n_1974_12" DOUBLE,
  "n_1975_01" DOUBLE,
  "n_1975_02" DOUBLE,
  "n_1975_03" DOUBLE,
  "n_1975_04" DOUBLE,
  "n_1975_05" DOUBLE,
  "n_1975_06" DOUBLE,
  "n_1975_07" DOUBLE,
  "n_1975_08" DOUBLE,
  "n_1975_09" DOUBLE,
  "n_1975_10" DOUBLE,
  "n_1975_11" DOUBLE,
  "n_1975_12" DOUBLE,
  "n_1976_01" DOUBLE,
  "n_1976_02" DOUBLE,
  "n_1976_03" DOUBLE,
  "n_1976_04" DOUBLE,
  "n_1976_05" DOUBLE,
  "n_1976_06" DOUBLE,
  "n_1976_07" DOUBLE,
  "n_1976_08" DOUBLE,
  "n_1976_09" DOUBLE,
  "n_1976_10" DOUBLE,
  "n_1976_11" DOUBLE,
  "n_1976_12" DOUBLE,
  "n_1977_01" DOUBLE,
  "n_1977_02" DOUBLE,
  "n_1977_03" DOUBLE,
  "n_1977_04" DOUBLE,
  "n_1977_05" DOUBLE,
  "n_1977_06" DOUBLE,
  "n_1977_07" DOUBLE,
  "n_1977_08" DOUBLE,
  "n_1977_09" DOUBLE,
  "n_1977_10" DOUBLE,
  "n_1977_11" DOUBLE,
  "n_1977_12" DOUBLE,
  "n_1978_01" DOUBLE,
  "n_1978_02" DOUBLE,
  "n_1978_03" DOUBLE,
  "n_1978_04" DOUBLE,
  "n_1978_05" DOUBLE,
  "n_1978_06" DOUBLE,
  "n_1978_07" DOUBLE,
  "n_1978_08" DOUBLE,
  "n_1978_09" DOUBLE,
  "n_1978_10" DOUBLE,
  "n_1978_11" DOUBLE,
  "n_1978_12" DOUBLE,
  "n_1979_01" DOUBLE
);

Conversion Factors For Euro Fixed Series Into Euro/ECU - Monthly Data - Unpivoted

@eurostat.ert_bil_conv_m.tidy
  • 107.2 KB
  • 21679 rows
  • 5 columns
Loading...

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

Share link

Anyone who has the link will be able to view this.