Permits Valid At The End Of The Year For Family Reunification With A Beneficiary Of Protection Status

Eurostat code: migr_resfrps2 · (2016 - 2023)

@eurostat.migr_resfrps2

Table List

2 tables(369.25 KB)

Permits Valid At The End Of The Year For Family Reunification With A Beneficiary Of Protection Status - Raw

Permits Valid At The End Of The Year For Family Reunification With A Beneficiary Of Protection Status - Unpivoted

Permits Valid At The End Of The Year For Family Reunification With A Beneficiary Of Protection Status - Unpivoted

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

150.8 KB
491139 rows
8 columns

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


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

Share link

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