Baselight

Day-to-day Rates For Euro Area Countries - Monthly Data

Eurostat code: irt_h_ddmr_m ยท (1970-01 - 2014-12)

@eurostat.irt_h_ddmr_m

Day-to-day Rates For Euro Area Countries - Monthly Data - Unpivoted
@eurostat.irt_h_ddmr_m.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.

  • 20.76 KB
  • 3995 rows
  • 5 columns
freq

Freq

int_rt

Int Rt

geo

Geo

time_period

Time Period

value

Value

MonthlyDay-to-day rateBelgium1970-015.75
MonthlyDay-to-day rateLuxembourg1970-015.75
MonthlyDay-to-day rateBelgium1970-026.44
MonthlyDay-to-day rateLuxembourg1970-026.44
MonthlyDay-to-day rateBelgium1970-036.65
MonthlyDay-to-day rateLuxembourg1970-036.65
MonthlyDay-to-day rateBelgium1970-046.47
MonthlyDay-to-day rateLuxembourg1970-046.47
MonthlyDay-to-day rateBelgium1970-056.74
MonthlyDay-to-day rateLuxembourg1970-056.74

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

Share link

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