Baselight

Final Consumption Expenditure Of Households And Non-profit Institutions Serving Households - Annual Data

Eurostat code: tipsna51 ยท (1995 - 2024)

@eurostat.tipsna51

Final Consumption Expenditure Of Households And Non-profit Institutions Serving Households - Annual Data - Unpivoted
@eurostat.tipsna51.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.

  • 19.29 KB
  • 2425 rows
  • 6 columns
freq

Freq

unit

Unit

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureAustria199595656
AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureBelgium1995111685.7
AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureBulgaria1995733.6
AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureCyprus19954749.7
AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureCzechia1995786023
AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureGermany19951055011
AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureDenmark1995523668.7
AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureEstonia19951600
AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureGreece199562954.9
AnnualCurrent prices, million units of national currencyHousehold and NPISH final consumption expenditureSpain1995280777

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

Share link

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