Intra-corporate Notifications Received By Economic Sector And Citizenship

Eurostat code: migr_resict2_2 · (2017 - 2023)

@eurostat.migr_resict2_2

Table List

2 tables(328.53 KB)

Intra-corporate Notifications Received By Economic Sector And Citizenship - Raw

Intra-corporate Notifications Received By Economic Sector And Citizenship - Unpivoted

Intra-corporate Notifications Received By Economic Sector And Citizenship - Unpivoted

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

69.69 KB
628663 rows
8 columns

freq Freq	decision Decision	citizen Citizen	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	Cyprus	2017
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	Germany	2017
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	France	2017
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	Italy	2017
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	Malta	2017
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	Netherlands	2017
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	Romania	2017
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	Sweden	2017
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	Slovenia	2017
Annual	Notification objected	Andorra	Agriculture, forestry and fishing	Number	Slovakia	2017


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

Share link

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