Employment By Professional Status

Eurostat code: enps_lfsa_egaps · (2005 - 2022)

@eurostat.enps_lfsa_egaps

Table List

2 tables(21.54 KB)

Employment By Professional Status - Unpivoted

Employment By Professional Status - Unpivoted

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

5.75 KB
192 rows
6 columns

freq Freq	unit Unit	wstatus Wstatus	geo Geo	time_period Time Period	value Value
Annual	Percentage	Contributing family workers	Algeria	2005	7.2
Annual	Percentage	Contributing family workers	Palestine*	2005	10.2
Annual	Percentage	Employees	Algeria	2005	65.3
Annual	Percentage	Employees	Palestine*	2005	58.9
Annual	Percentage	Self-employed persons	Algeria	2005	27.4
Annual	Percentage	Contributing family workers	Algeria	2006	7.8
Annual	Percentage	Contributing family workers	Palestine*	2006	11.4
Annual	Percentage	Employees	Algeria	2006	59.7
Annual	Percentage	Employees	Palestine*	2006	58.5
Annual	Percentage	Self-employed persons	Algeria	2006	32.5


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

Share link

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