Household Final Consumption Expenditure By Purpose (COICOP 1999)

Eurostat code: nama_10_co3_p3$dv_1002

@eurostat.nama_10_co3_p3_dv_1002

Table List

2 tables(95.45 KB)

Household Final Consumption Expenditure By Purpose (COICOP 1999) - Raw

Household Final Consumption Expenditure By Purpose (COICOP 1999) - Unpivoted

Household Final Consumption Expenditure By Purpose (COICOP 1999) - Raw

@eurostat.nama_10_co3_p3_dv_1002.raw

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

52.1 KB
1076 rows
14 columns

freq Freq	unit Unit	coicop Coicop	geo Geo	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	Chain linked volumes, index 2015=100	Recreation and culture	Albania	100	105.93	108.377	112.568	124.752	66.353	123.421	166.157	205.15
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Austria	100	101.052	102.633	105.02	104.807	85.419	87.161	107.013
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Bosnia and Herzegovina	100	103.745	105.982	106.529	109.524	91.651	106.587	116.526	122.1
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Belgium	100	99.88	101.933	104.77	105.132	85.43	93.747	103.415
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Bulgaria	100	105.571	107.553	110.71	124.131	109.759	132.802	128.42
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Switzerland	100	96.072	95.652	91.987	91.022	79.569	79.406	88.682
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Cyprus	100	102.611	101.798	107.014	114.602	99.083	109.604	122.062
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Czechia	100	107.296	114.068	118.42	130.329	109.797	119.768	138.185
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Germany	100	103.44	106.83	107.82	110.13	93.12	93.26	103.27
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Denmark	100	105.884	111.24	115.327	117.579	106.344	113.622	125.769


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "coicop" VARCHAR,
  "geo" VARCHAR,
  "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.