Decisions On Outgoing 'Dublin' Requests Based On EURODAC By Receiving Country (PARTNER), Type Of Request, Sex And Type Of Applicant

Eurostat code: migr_dubdedaco · (2008 - 2024)

@eurostat.migr_dubdedaco

Table List

2 tables(2.18 MB)

Decisions On Outgoing 'Dublin' Requests Based On EURODAC By Receiving Country (PARTNER), Type Of Request, Sex And Type Of Applicant - Raw

Decisions On Outgoing 'Dublin' Requests Based On EURODAC By Receiving Country (PARTNER), Type Of Request, Sex And Type Of Applicant - Unpivoted

Decisions On Outgoing 'Dublin' Requests Based On EURODAC By Receiving Country (PARTNER), Type Of Request, Sex And Type Of Applicant - Unpivoted

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

1.01 MB
2371068 rows
11 columns

freq Freq	unit Unit	leg_prov Leg Prov	request Request	decision Decision	partner Partner	applicant Applicant	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Austria	2008
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Belgium	2008	19
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Bulgaria	2008	1
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Switzerland	2008
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Cyprus	2008	1
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Czechia	2008	1
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Germany	2008	146
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Denmark	2008
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Estonia	2008
Annual	Number	Requests based on EURODAC (European Dactyloscopy)	Requests	Negative decision	Austria	Total	Total	Greece	2008


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