Pending Outgoing 'Dublin' Transfers By Receiving Country (PARTNER), Sex And Type Of Applicant

Eurostat code: migr_dubtpeno · (2014 - 2024)

@eurostat.migr_dubtpeno

Table List

2 tables(135.96 KB)

Pending Outgoing 'Dublin' Transfers By Receiving Country (PARTNER), Sex And Type Of Applicant - Raw

Pending Outgoing 'Dublin' Transfers By Receiving Country (PARTNER), Sex And Type Of Applicant - Unpivoted

Pending Outgoing 'Dublin' Transfers By Receiving Country (PARTNER), Sex And Type Of Applicant - Unpivoted

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

55.92 KB
87536 rows
8 columns

freq Freq	unit Unit	partner Partner	applicant Applicant	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Austria	Total	Total	Austria	2014
Annual	Number	Austria	Total	Total	Denmark	2014	3
Annual	Number	Austria	Total	Total	Estonia	2014
Annual	Number	Austria	Total	Total	Greece	2014	16
Annual	Number	Austria	Total	Total	Croatia	2014
Annual	Number	Austria	Total	Total	Ireland	2014
Annual	Number	Austria	Total	Total	Iceland	2014
Annual	Number	Austria	Total	Total	Italy	2014
Annual	Number	Austria	Total	Total	Liechtenstein	2014
Annual	Number	Austria	Total	Total	Luxembourg	2014	7


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

Share link

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