Persons Participating In Formal/informal Voluntary Activities Or Active Citizenship By Income Quintile, Household Composition And Degree Of Urbanisation

Eurostat code: ilc_scp20 · (2015 - 2022)

@eurostat.ilc_scp20

Table List

2 tables(131.39 KB)

Persons Participating In Formal/informal Voluntary Activities Or Active Citizenship By Income Quintile, Household Composition And Degree Of Urbanisation - Raw

Persons Participating In Formal/informal Voluntary Activities Or Active Citizenship By Income Quintile, Household Composition And Degree Of Urbanisation - Unpivoted

Persons Participating In Formal/informal Voluntary Activities Or Active Citizenship By Income Quintile, Household Composition And Degree Of Urbanisation - Unpivoted

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

63.39 KB
37969 rows
9 columns

freq Freq	acl00 Acl00	quant_inc Quant Inc	deg_urb Deg Urb	hhcomp Hhcomp	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Austria	2015	19.4
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Belgium	2015	11.9
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Bulgaria	2015	3.7
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Switzerland	2015	23.6
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Cyprus	2015	5.4
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Czechia	2015	6.3
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Germany	2015	20.6
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Denmark	2015	39.1
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Estonia	2015	16.6
Annual	Formal voluntary activities	First quintile	Cities	One adult	Percentage	Greece	2015	8.6


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

Share link

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