Intra-corporate Notifications Received By Length Of Validity And Citizenship

Eurostat code: migr_resict2_1 · (2017 - 2023)

@eurostat.migr_resict2_1

Table List

2 tables(76.78 KB)

Intra-corporate Notifications Received By Length Of Validity And Citizenship - Raw

Intra-corporate Notifications Received By Length Of Validity And Citizenship - Unpivoted

Intra-corporate Notifications Received By Length Of Validity And Citizenship - Unpivoted

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

20.09 KB
103761 rows
8 columns

freq Freq	citizen Citizen	decision Decision	unit Unit	duration Duration	geo Geo	time_period Time Period
Annual	Andorra	Notification objected	Number	From 12 to 36 months	Cyprus	2017
Annual	Andorra	Notification objected	Number	From 12 to 36 months	Germany	2017
Annual	Andorra	Notification objected	Number	From 12 to 36 months	France	2017
Annual	Andorra	Notification objected	Number	From 12 to 36 months	Malta	2017
Annual	Andorra	Notification objected	Number	From 12 to 36 months	Netherlands	2017
Annual	Andorra	Notification objected	Number	From 12 to 36 months	Romania	2017
Annual	Andorra	Notification objected	Number	From 12 to 36 months	Slovenia	2017
Annual	Andorra	Notification objected	Number	From 12 to 36 months	Slovakia	2017
Annual	Andorra	Notification objected	Number	From 3 to 5 months	Cyprus	2017
Annual	Andorra	Notification objected	Number	From 3 to 5 months	Germany	2017


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

Share link

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