First Permits Issued For Family Reunification With A Beneficiary Of Protection Status

Eurostat code: migr_resfrps1 · (2016 - 2023)

@eurostat.migr_resfrps1

Table List

2 tables(343.02 KB)

First Permits Issued For Family Reunification With A Beneficiary Of Protection Status - Raw

First Permits Issued For Family Reunification With A Beneficiary Of Protection Status - Unpivoted

First Permits Issued For Family Reunification With A Beneficiary Of Protection Status - Unpivoted

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

135.84 KB
601459 rows
8 columns

freq Freq	leg_fram Leg Fram	reason Reason	citizen Citizen	unit Unit	geo Geo	time_period Time Period
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	Belgium	2016
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	Bulgaria	2016
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	Cyprus	2016
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	Denmark	2016
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	Estonia	2016
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	France	2016
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	Croatia	2016
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	Italy	2016
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	Luxembourg	2016
Annual	Directive 2003/86/EC on the right to family reunification	Sponsor with humanitarian status (national law)	Andorra	Person	Latvia	2016


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

Share link

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