Conversion Factors For Euro Fixed Series Into Euro/ECU - Monthly Data
Eurostat code: ert_bil_conv_m · (1971-01 - 2025-10)
@eurostat.ert_bil_conv_m
Eurostat code: ert_bil_conv_m · (1971-01 - 2025-10)
@eurostat.ert_bil_conv_m
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.
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-11-03T11:00:00+0100
CREATE TABLE raw (
"freq" VARCHAR,
"statinfo" VARCHAR,
"geo" VARCHAR,
"n_1971_01" DOUBLE -- 1971-01,
"n_1971_02" DOUBLE -- 1971-02,
"n_1971_03" DOUBLE -- 1971-03,
"n_1971_04" DOUBLE -- 1971-04,
"n_1971_05" DOUBLE -- 1971-05,
"n_1971_06" DOUBLE -- 1971-06,
"n_1971_07" DOUBLE -- 1971-07,
"n_1971_08" DOUBLE -- 1971-08,
"n_1971_09" DOUBLE -- 1971-09,
"n_1971_10" DOUBLE -- 1971-10,
"n_1971_11" DOUBLE -- 1971-11,
"n_1971_12" DOUBLE -- 1971-12,
"n_1972_01" DOUBLE -- 1972-01,
"n_1972_02" DOUBLE -- 1972-02,
"n_1972_03" DOUBLE -- 1972-03,
"n_1972_04" DOUBLE -- 1972-04,
"n_1972_05" DOUBLE -- 1972-05,
"n_1972_06" DOUBLE -- 1972-06,
"n_1972_07" DOUBLE -- 1972-07,
"n_1972_08" DOUBLE -- 1972-08,
"n_1972_09" DOUBLE -- 1972-09,
"n_1972_10" DOUBLE -- 1972-10,
"n_1972_11" DOUBLE -- 1972-11,
"n_1972_12" DOUBLE -- 1972-12,
"n_1973_01" DOUBLE -- 1973-01,
"n_1973_02" DOUBLE -- 1973-02,
"n_1973_03" DOUBLE -- 1973-03,
"n_1973_04" DOUBLE -- 1973-04,
"n_1973_05" DOUBLE -- 1973-05,
"n_1973_06" DOUBLE -- 1973-06,
"n_1973_07" DOUBLE -- 1973-07,
"n_1973_08" DOUBLE -- 1973-08,
"n_1973_09" DOUBLE -- 1973-09,
"n_1973_10" DOUBLE -- 1973-10,
"n_1973_11" DOUBLE -- 1973-11,
"n_1973_12" DOUBLE -- 1973-12,
"n_1974_01" DOUBLE -- 1974-01,
"n_1974_02" DOUBLE -- 1974-02,
"n_1974_03" DOUBLE -- 1974-03,
"n_1974_04" DOUBLE -- 1974-04,
"n_1974_05" DOUBLE -- 1974-05,
"n_1974_06" DOUBLE -- 1974-06,
"n_1974_07" DOUBLE -- 1974-07,
"n_1974_08" DOUBLE -- 1974-08,
"n_1974_09" DOUBLE -- 1974-09,
"n_1974_10" DOUBLE -- 1974-10,
"n_1974_11" DOUBLE -- 1974-11,
"n_1974_12" DOUBLE -- 1974-12,
"n_1975_01" DOUBLE -- 1975-01,
"n_1975_02" DOUBLE -- 1975-02,
"n_1975_03" DOUBLE -- 1975-03,
"n_1975_04" DOUBLE -- 1975-04,
"n_1975_05" DOUBLE -- 1975-05,
"n_1975_06" DOUBLE -- 1975-06,
"n_1975_07" DOUBLE -- 1975-07,
"n_1975_08" DOUBLE -- 1975-08,
"n_1975_09" DOUBLE -- 1975-09,
"n_1975_10" DOUBLE -- 1975-10,
"n_1975_11" DOUBLE -- 1975-11,
"n_1975_12" DOUBLE -- 1975-12,
"n_1976_01" DOUBLE -- 1976-01,
"n_1976_02" DOUBLE -- 1976-02,
"n_1976_03" DOUBLE -- 1976-03,
"n_1976_04" DOUBLE -- 1976-04,
"n_1976_05" DOUBLE -- 1976-05,
"n_1976_06" DOUBLE -- 1976-06,
"n_1976_07" DOUBLE -- 1976-07,
"n_1976_08" DOUBLE -- 1976-08,
"n_1976_09" DOUBLE -- 1976-09,
"n_1976_10" DOUBLE -- 1976-10,
"n_1976_11" DOUBLE -- 1976-11,
"n_1976_12" DOUBLE -- 1976-12,
"n_1977_01" DOUBLE -- 1977-01,
"n_1977_02" DOUBLE -- 1977-02,
"n_1977_03" DOUBLE -- 1977-03,
"n_1977_04" DOUBLE -- 1977-04,
"n_1977_05" DOUBLE -- 1977-05,
"n_1977_06" DOUBLE -- 1977-06,
"n_1977_07" DOUBLE -- 1977-07,
"n_1977_08" DOUBLE -- 1977-08,
"n_1977_09" DOUBLE -- 1977-09,
"n_1977_10" DOUBLE -- 1977-10,
"n_1977_11" DOUBLE -- 1977-11,
"n_1977_12" DOUBLE -- 1977-12,
"n_1978_01" DOUBLE -- 1978-01,
"n_1978_02" DOUBLE -- 1978-02,
"n_1978_03" DOUBLE -- 1978-03,
"n_1978_04" DOUBLE -- 1978-04,
"n_1978_05" DOUBLE -- 1978-05,
"n_1978_06" DOUBLE -- 1978-06,
"n_1978_07" DOUBLE -- 1978-07,
"n_1978_08" DOUBLE -- 1978-08,
"n_1978_09" DOUBLE -- 1978-09,
"n_1978_10" DOUBLE -- 1978-10,
"n_1978_11" DOUBLE -- 1978-11,
"n_1978_12" DOUBLE -- 1978-12,
"n_1979_01" DOUBLE -- 1979-01
);CREATE TABLE tidy (
"freq" VARCHAR,
"statinfo" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);Anyone who has the link will be able to view this.