General Government Employment

Eurostat code: gov_10a_emp · (1995 - 2023)

@eurostat.gov_10a_emp

Table List

2 tables(34.9 KB)

General Government Employment - Unpivoted

General Government Employment - Unpivoted

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

8.79 KB
604 rows
7 columns

freq Freq	unit Unit	sector Sector	na_item Na Item	geo Geo	time_period Time Period	value Value
Annual	Thousand persons	Central government	Total employment domestic concept	Italy	1995	1969.9
Annual	Thousand persons	Central government	Total employment domestic concept	Malta	1995	31.9
Annual	Thousand persons	Central government	Total employment domestic concept	Netherlands	1995	293
Annual	Thousand persons	Central government	Total employment domestic concept	Sweden	1995	262.5
Annual	Thousand persons	Local government	Total employment domestic concept	Italy	1995	1529.9
Annual	Thousand persons	Local government	Total employment domestic concept	Malta	1995	0.1
Annual	Thousand persons	Local government	Total employment domestic concept	Netherlands	1995	692
Annual	Thousand persons	Local government	Total employment domestic concept	Sweden	1995	1107.5
Annual	Thousand persons	Social security funds	Total employment domestic concept	Italy	1995	57
Annual	Thousand persons	Social security funds	Total employment domestic concept	Netherlands	1995	31


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

Share link

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