Baselight
Sign In

Incoming 'Dublin' Requests Based On EURODAC By Submitting Country (PARTNER), Type Of Request, Legal Provision, Sex And Type Of Applicant

Eurostat code: migr_dubredaci ยท (2008 - 2024)

@eurostat.migr_dubredaci

Incoming 'Dublin' Requests Based On EURODAC By Submitting Country (PARTNER), Type Of Request, Legal Provision, Sex And Type Of Applicant - Unpivoted
@eurostat.migr_dubredaci.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.

  • 367.44 KB
  • 783186 rows
  • 10 columns
freq

Freq

unit

Unit

request

Request

leg_prov

Leg Prov

partner

Partner

applicant

Applicant

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalAustria2008
AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalBelgium200828
AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalBulgaria20081
AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalSwitzerland2008
AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalCyprus2008
AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalCzechia200835
AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalGermany200891
AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalDenmark2008
AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalEstonia2008
AnnualNumberRequestsRequests based on EURODAC (European Dactyloscopy)AustriaTotalTotalSpain200811

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