National Civil Servants In Central Public Administration

Eurostat code: prc_rem_nr · (2004-S2 - 2024-S2)

@eurostat.prc_rem_nr

Table List

2 tables(32.78 KB)

National Civil Servants In Central Public Administration - Raw

National Civil Servants In Central Public Administration - Unpivoted

National Civil Servants In Central Public Administration - Unpivoted

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

10.13 KB
1113 rows
6 columns

freq Freq	statinfo Statinfo	unit Unit	geo Geo	time_period Time Period	value Value
Half-yearly, semesterly	Sample	Number	Austria	2004-S2	38543
Half-yearly, semesterly	Sample	Number	Belgium	2004-S2	62195
Half-yearly, semesterly	Sample	Number	Cyprus	2004-S2	10589
Half-yearly, semesterly	Sample	Number	Czechia	2004-S2	18308
Half-yearly, semesterly	Sample	Number	Germany	2004-S2	13047
Half-yearly, semesterly	Sample	Number	Denmark	2004-S2	8137
Half-yearly, semesterly	Sample	Number	Greece	2004-S2	78184
Half-yearly, semesterly	Sample	Number	Spain	2004-S2	78006
Half-yearly, semesterly	Sample	Number	Finland	2004-S2	2833
Half-yearly, semesterly	Sample	Number	France	2004-S2	22822


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

Share link

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