Baselight
Sign In

Euro/ECU Exchange Rates - Quarterly Data

Eurostat code: ert_bil_eur_q ยท (1971-Q1 - 2025-Q1)

@eurostat.ert_bil_eur_q

Euro/ECU Exchange Rates - Quarterly Data - Unpivoted
@eurostat.ert_bil_eur_q.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

  • 85.95 KB
  • 10489 rows
  • 6 columns
freq

Freq

statinfo

Statinfo

unit

Unit

currency

Currency

time_period

Time Period

value

Value

QuarterlyAverageNational currencyDanish krone1971-Q17.6946
QuarterlyAverageNational currencyPound sterling1971-Q10.42601
QuarterlyAverageNational currencyUS dollar1971-Q11.0284
QuarterlyAverageNational currencyDanish krone1971-Q27.7434
QuarterlyAverageNational currencyPound sterling1971-Q20.42733
QuarterlyAverageNational currencyUS dollar1971-Q21.0336
QuarterlyAverageNational currencyDanish krone1971-Q37.7888
QuarterlyAverageNational currencyPound sterling1971-Q30.43038
QuarterlyAverageNational currencyUS dollar1971-Q31.0508
QuarterlyAverageNational currencyDanish krone1971-Q47.7838

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

Share link

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