Aggregate Replacement Ratio

Eurostat code: tespm100 · (2013 - 2024)

@eurostat.tespm100

Table List

2 tables(18.89 KB)

Aggregate Replacement Ratio - Raw

Aggregate Replacement Ratio - Unpivoted

Aggregate Replacement Ratio - Raw

@eurostat.tespm100.raw

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

13.18 KB
38 rows
16 columns

freq Freq	sex Sex	unit Unit	geo Geo	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	n_2024 2024
Annual	Total	Percentage	Albania					0.44	0.42	0.43	0.39	0.37
Annual	Total	Percentage	Austria	0.58	0.61	0.61	0.59	0.61	0.59	0.6	0.6	0.61	0.57	0.56
Annual	Total	Percentage	Belgium	0.47	0.48	0.49	0.48	0.5	0.5	0.47	0.47	0.49	0.47	0.48	0.48
Annual	Total	Percentage	Bulgaria	0.43	0.48	0.42	0.47	0.38	0.41	0.37	0.35	0.37	0.38	0.46	0.44
Annual	Total	Percentage	Switzerland	0.42	0.44	0.45	0.48	0.5	0.51	0.52	0.52	0.49	0.47	0.48
Annual	Total	Percentage	Cyprus	0.45	0.42	0.44	0.45	0.42	0.43	0.42	0.41	0.45	0.44	0.42	0.41
Annual	Total	Percentage	Czechia	0.57	0.55	0.52	0.51	0.51	0.5	0.5	0.49	0.51	0.49	0.52	0.56
Annual	Total	Percentage	Germany	0.51	0.49	0.5	0.5	0.5	0.48	0.47	0.46	0.48	0.48	0.49	0.49
Annual	Total	Percentage	Denmark	0.46	0.47	0.47	0.47	0.49	0.5	0.5	0.47	0.44	0.47	0.47	0.47
Annual	Total	Percentage	Euro area – 20 countries (from 2023)	0.58	0.58	0.59	0.59	0.6	0.6	0.59	0.58	0.6	0.59	0.6


CREATE TABLE raw (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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,
  "n_2024" DOUBLE
);

Share link

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