Final Consumption Expenditure Of Households And NPISH, Current Prices

Eurostat code: teina020 · (2022-Q1 - 2024-Q4)

@eurostat.teina020

Table List

2 tables(24.6 KB)

Final Consumption Expenditure Of Households And NPISH, Current Prices - Raw

Final Consumption Expenditure Of Households And NPISH, Current Prices - Unpivoted

Final Consumption Expenditure Of Households And NPISH, Current Prices - Unpivoted

@eurostat.teina020.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.

9 KB
432 rows
7 columns

freq Freq	na_item Na Item	s_adj S Adj	unit Unit	geo Geo	time_period Time Period	value Value
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Austria	2022-Q1	54679.5
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Belgium	2022-Q1	68831.7
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Bulgaria	2022-Q1	11386.6
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Switzerland	2022-Q1	93555.2
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Cyprus	2022-Q1	4040.7
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Czechia	2022-Q1	33634
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Germany	2022-Q1	501428
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Denmark	2022-Q1	40729.7
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2022-Q1	1726659.4
Quarterly	Household and NPISH final consumption expenditure	Seasonally and calendar adjusted data	Million euro (SCA)	Euro area – 20 countries (from 2023)	2022-Q1	1735909.9


CREATE TABLE tidy (
  "freq" VARCHAR,
  "na_item" VARCHAR,
  "s_adj" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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