Exchange Rates

Eurostat code: med_ec9 · (2005 - 2019)

@eurostat.med_ec9

Table List

2 tables(17.89 KB)

Exchange Rates - Raw

Exchange Rates - Unpivoted

Exchange Rates - Raw

@eurostat.med_ec9.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

12.88 KB
8 rows
18 columns

freq Freq	currency Currency	geo Geo	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019
Annual	Euro	Algeria	91.163	91.215	94.965	94.988	101.329	98.613	101.53	99.618	105.409	107.049	111.717	121.143	125.366	136.86
Annual	Euro	Egypt	7.189	7.199	7.723	7.99	7.734	7.453	8.258	7.781	9.124	9.403	8.533	11.097	20.089	20.983
Annual	Euro	Israel	5.583	5.592	5.627	5.267	5.469	4.95	4.977	4.953	4.797	4.747	4.312	4.25	4.062	4.244	4.034
Annual	Euro	Jordan	0.882	0.89	0.972	1.044	0.99	0.941	0.988	0.912	0.943	0.943	0.788	0.786	0.802	0.839
Annual	Euro	Lebanon	1875.481	1892.817	2066.029	2217.231	2102.661	1998.67	2099.34	1937.32	2001.8	2002.74	1673.44	1668.5	1702.79	1780.64
Annual	Euro	Libya	1.628	1.649	1.73	1.8	1.748	1.679	1.704	1.621	1.689	1.69	1.532	1.539	1.575	1.612
Annual	Euro	Morocco	11.021	11.042	11.219	11.348	11.249	11.153	11.249	11.091	11.156	11.156	10.83	10.849	10.961	11.086
Annual	Euro	Tunisia	1.614	1.671	1.756	1.812	1.883	1.898	1.96	2.007	2.158	2.255	2.176	2.378	2.733	3.126


CREATE TABLE raw (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE
);

Share link

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