Baselight
Sign In

Persons Not Participating In Active Citizenship By Income Quintile, Household Composition, Degree Of Urbanization And Reasons

Eurostat code: ilc_scp26 · (2022 - 2022)

@eurostat.ilc_scp26

Persons Not Participating In Active Citizenship By Income Quintile, Household Composition, Degree Of Urbanization And Reasons - Unpivoted
@eurostat.ilc_scp26.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.

  • 37.6 KB
  • 19386 rows
  • 9 columns
freq

Freq

reason

Reason

quant_inc

Quant Inc

deg_urb

Deg Urb

hhcomp

Hhcomp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNo interestFirst quintileCitiesOne adultPercentageAustria2022
AnnualNo interestFirst quintileCitiesOne adultPercentageBelgium202266.4
AnnualNo interestFirst quintileCitiesOne adultPercentageBulgaria202214.4
AnnualNo interestFirst quintileCitiesOne adultPercentageSwitzerland202252.5
AnnualNo interestFirst quintileCitiesOne adultPercentageCyprus202265.6
AnnualNo interestFirst quintileCitiesOne adultPercentageCzechia202274.2
AnnualNo interestFirst quintileCitiesOne adultPercentageDenmark202249.5
AnnualNo interestFirst quintileCitiesOne adultPercentageEuro area – 20 countries (from 2023)202251.7
AnnualNo interestFirst quintileCitiesOne adultPercentageEstonia202247.3
AnnualNo interestFirst quintileCitiesOne adultPercentageGreece202279.7

CREATE TABLE tidy (
  "freq" VARCHAR,
  "reason" 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.