Third Country Nationals Ordered To Leave - Annual Data (rounded)

Eurostat code: migr_eiord$dv_1261

@eurostat.migr_eiord_dv_1261

Table List

2 tables(14.99 KB)

Third Country Nationals Ordered To Leave - Annual Data (rounded) - Raw

Third Country Nationals Ordered To Leave - Annual Data (rounded) - Unpivoted

Third Country Nationals Ordered To Leave - Annual Data (rounded) - Unpivoted

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

6.54 KB
134 rows
8 columns

freq Freq	citizen Citizen	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Less than 18 years	Total	Person	Austria	2018	1580
Annual	Total	Less than 18 years	Total	Person	Switzerland	2018	110
Annual	Total	Less than 18 years	Total	Person	Denmark	2018	715
Annual	Total	Less than 18 years	Total	Person	Finland	2018	620
Annual	Total	Less than 18 years	Total	Person	France	2018	9755
Annual	Total	Less than 18 years	Total	Person	Croatia	2018	335
Annual	Total	Less than 18 years	Total	Person	Hungary	2018	40
Annual	Total	Less than 18 years	Total	Person	Ireland	2018	115
Annual	Total	Less than 18 years	Total	Person	Italy	2018	50
Annual	Total	Less than 18 years	Total	Person	Liechtenstein	2018


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

Share link

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