Persons Getting Together With Family And Relatives Or Friends By Income Quintile, Household Composition, Degree Of Urbanisation And Frequency

Eurostat code: ilc_scp10 · (2015 - 2022)

@eurostat.ilc_scp10

Table List

2 tables(433.61 KB)

Persons Getting Together With Family And Relatives Or Friends By Income Quintile, Household Composition, Degree Of Urbanisation And Frequency - Raw

Persons Getting Together With Family And Relatives Or Friends By Income Quintile, Household Composition, Degree Of Urbanisation And Frequency - Unpivoted

Persons Getting Together With Family And Relatives Or Friends By Income Quintile, Household Composition, Degree Of Urbanisation And Frequency - Unpivoted

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

214.25 KB
148668 rows
10 columns

freq Freq	frequenc Frequenc	pers_cat Pers Cat	deg_urb Deg Urb	hhcomp Hhcomp	quant_inc Quant Inc	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Austria	2015	19.8
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Belgium	2015	5.8
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Bulgaria	2015	26.2
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Switzerland	2015	12.6
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Cyprus	2015	2.2
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Czechia	2015	16.9
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Germany	2015	15.3
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Denmark	2015	18.4
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Estonia	2015	16.6
Annual	Once a month	Family and relatives	Cities	One adult	First quintile	Percentage	Greece	2015	12.8


CREATE TABLE tidy (
  "freq" VARCHAR,
  "frequenc" VARCHAR,
  "pers_cat" VARCHAR,
  "deg_urb" VARCHAR,
  "hhcomp" VARCHAR,
  "quant_inc" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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