Export To Import Ratio

Eurostat code: egi_tr1 · (2007 - 2023)

@eurostat.egi_tr1

Table List

2 tables(22.81 KB)

Export To Import Ratio - Raw

Export To Import Ratio - Unpivoted

Export To Import Ratio - Raw

@eurostat.egi_tr1.raw

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

17.02 KB
39 rows
20 columns

freq Freq	indic_et Indic Et	geo Geo	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	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Export/import ratio	Albania	0.51	0.49	0.51	0.58	0.56	0.61	0.61	0.6	0.61	0.63	0.68	0.7	0.81	0.61		0.78
Annual	Export/import ratio	Austria	1.09	1.09	1.08	1.07	1.05	1.05	1.06	1.07	1.08	1.07	1.06	1.07	1.06	1.07	1.02	1.02	1.05
Annual	Export/import ratio	Bosnia and Herzegovina	0.48	0.45	0.51	0.58	0.57	0.58	0.62	0.6	0.65	0.68	0.74	0.73	1.09	0.7		0.76
Annual	Export/import ratio	Belgium	1.05	1.01	1.03	1.02	1.01	1.01	1.01	1.01	1.02	1.02	1.01	1.01	1.01	1.01	1.02	0.98	0.99
Annual	Export/import ratio	Bulgaria	0.74	0.73	0.84	0.95	1.01	0.95	0.99	0.98	1	1.07	1.06	1.01	1.05	1.03	1.02	1.01	1.05
Annual	Export/import ratio	Switzerland	1.23	1.2	1.15	1.2	1.15	1.18	1.2	1.22	1.23	1.21	1.2	1.23	1.05	1.16	1.27	1.2	1.2
Annual	Export/import ratio	Cyprus	0.92	0.8	0.9	0.87	0.95	0.98	1.02	1.03	1	0.99	0.95	0.97	0.99	0.92	1.01	1	0.98
Annual	Export/import ratio	Czechia	1.04	1.03	1.07	1.05	1.06	1.07	1.08	1.08	1.08	1.11	1.1	1.09	1.09	1.11	1.04	1	1.08
Annual	Export/import ratio	Germany	1.18	1.16	1.15	1.14	1.12	1.15	1.15	1.18	1.21	1.2	1.19	1.17	1.14	1.15	1.13	1.04	1.1
Annual	Export/import ratio	Denmark	1.06	1.07	1.11	1.16	1.14	1.12	1.14	1.14	1.14	1.14	1.15	1.11	1.14	1.13	1.13	1.18	1.16


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_et" VARCHAR,
  "geo" VARCHAR,
  "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,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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