Pending 'Dublin' Incoming Requests By Submitting Country (PARTNER), Type Of Request, Sex And Type Of Applicant

Eurostat code: migr_dubrpeni · (2008 - 2024)

@eurostat.migr_dubrpeni

Table List

2 tables(206.35 KB)

Pending 'Dublin' Incoming Requests By Submitting Country (PARTNER), Type Of Request, Sex And Type Of Applicant - Raw

Pending 'Dublin' Incoming Requests By Submitting Country (PARTNER), Type Of Request, Sex And Type Of Applicant - Unpivoted

Pending 'Dublin' Incoming Requests By Submitting Country (PARTNER), Type Of Request, Sex And Type Of Applicant - Unpivoted

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

82.24 KB
247763 rows
9 columns

freq Freq	unit Unit	request Request	partner Partner	applicant Applicant	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Requests	Austria	Total	Total	Austria	2008
Annual	Number	Requests	Austria	Total	Total	Belgium	2008	14
Annual	Number	Requests	Austria	Total	Total	Bulgaria	2008	2
Annual	Number	Requests	Austria	Total	Total	Switzerland	2008
Annual	Number	Requests	Austria	Total	Total	Cyprus	2008	2
Annual	Number	Requests	Austria	Total	Total	Czechia	2008	3
Annual	Number	Requests	Austria	Total	Total	Germany	2008	4
Annual	Number	Requests	Austria	Total	Total	Denmark	2008	6
Annual	Number	Requests	Austria	Total	Total	Estonia	2008
Annual	Number	Requests	Austria	Total	Total	Spain	2008	1


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "request" 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.