Population By Group Of Country Of Birth, Educational Attainment Level And NUTS 2 Region

Eurostat code: cens_11cobe_r2 · (2011 - 2011)

@eurostat.cens_11cobe_r2

Table List

2 tables(3.02 MB)

Population By Group Of Country Of Birth, Educational Attainment Level And NUTS 2 Region - Raw

Population By Group Of Country Of Birth, Educational Attainment Level And NUTS 2 Region - Unpivoted

Population By Group Of Country Of Birth, Educational Attainment Level And NUTS 2 Region - Unpivoted

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

1.5 MB
703304 rows
9 columns

freq Freq	age Age	sex Sex	c_birth C Birth	isced97 Isced97	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Austria	2011	22055
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Ostösterreich	2011	8378
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Burgenland	2011	895
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Niederösterreich	2011	2871
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Wien	2011	4612
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Südösterreich	2011	3989
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Kärnten	2011	1312
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Steiermark	2011	2677
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Westösterreich	2011	9688
Annual	Total	Females	Other EU countries	Primary education or first stage of basic education (level 1)	Number	Oberösterreich	2011	3942


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

Share link

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