Distribution Of Population Over 18 Years By Most Frequent Activity Status, Age Group And Sex

Eurostat code: ilc_lvhl02 · (2003 - 2024)

@eurostat.ilc_lvhl02

Table List

2 tables(492.7 KB)

Distribution Of Population Over 18 Years By Most Frequent Activity Status, Age Group And Sex - Raw

Distribution Of Population Over 18 Years By Most Frequent Activity Status, Age Group And Sex - Unpivoted

Distribution Of Population Over 18 Years By Most Frequent Activity Status, Age Group And Sex - Unpivoted

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

196.85 KB
158598 rows
9 columns

freq Freq	incgrp Incgrp	wstatus Wstatus	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Females	Percentage	Austria	2003	62.2
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Females	Percentage	Belgium	2003	58.2
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Females	Percentage	Denmark	2003	73.1
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Females	Percentage	Greece	2003	50.7
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Females	Percentage	Ireland	2003	62.1
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Females	Percentage	Luxembourg	2003	56.2
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Females	Percentage	Norway	2003	72.8
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Males	Percentage	Austria	2003	81.2
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Males	Percentage	Belgium	2003	73.7
Annual	Above 60% of median equivalised income	Employed persons	From 18 to 64 years	Males	Percentage	Denmark	2003	82.4


CREATE TABLE tidy (
  "freq" VARCHAR,
  "incgrp" VARCHAR,
  "wstatus" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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