Classroom Teachers And Academic Staff By Education Level, Programme Orientation, Sex, Type Of Institution And Employment Status

Eurostat code: educ_uoe_perp02 · (2013 - 2023)

@eurostat.educ_uoe_perp02

Table List

2 tables(1.34 MB)

Classroom Teachers And Academic Staff By Education Level, Programme Orientation, Sex, Type Of Institution And Employment Status - Raw

Classroom Teachers And Academic Staff By Education Level, Programme Orientation, Sex, Type Of Institution And Employment Status - Unpivoted

Classroom Teachers And Academic Staff By Education Level, Programme Orientation, Sex, Type Of Institution And Employment Status - Unpivoted

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

645.65 KB
191298 rows
9 columns

freq Freq	unit Unit	worktime Worktime	isced11 Isced11	sector Sector	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Full-time	Early childhood education	Private institutions	Females	Austria	2013	5429
Annual	Number	Full-time	Early childhood education	Private institutions	Females	Bulgaria	2013	330
Annual	Number	Full-time	Early childhood education	Private institutions	Females	Switzerland	2013	415
Annual	Number	Full-time	Early childhood education	Private institutions	Females	Cyprus	2013	683
Annual	Number	Full-time	Early childhood education	Private institutions	Females	Germany	2013	109234
Annual	Number	Full-time	Early childhood education	Private institutions	Females	Estonia	2013	246
Annual	Number	Full-time	Early childhood education	Private institutions	Females	Spain	2013	41773
Annual	Number	Full-time	Early childhood education	Private institutions	Females	France	2013	9773
Annual	Number	Full-time	Early childhood education	Private institutions	Females	Croatia	2013	1635
Annual	Number	Full-time	Early childhood education	Private institutions	Females	Iceland	2013	426


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

Share link

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