Single Permits Issued By Type Of Decision, Length Of Validity

Eurostat code: migr_ressing · (2013 - 2023)

@eurostat.migr_ressing

Table List

2 tables(147.09 KB)

Single Permits Issued By Type Of Decision, Length Of Validity - Raw

Single Permits Issued By Type Of Decision, Length Of Validity - Unpivoted

Single Permits Issued By Type Of Decision, Length Of Validity - Unpivoted

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

65.6 KB
19036 rows
8 columns

freq Freq	reason Reason	unit Unit	decision Decision	duration Duration	geo Geo	time_period Time Period	value Value
Annual	Education reasons	Person	Decision to change	From 3 to 5 months	Bulgaria	2013
Annual	Education reasons	Person	Decision to change	From 3 to 5 months	France	2013
Annual	Education reasons	Person	Decision to change	From 3 to 5 months	Poland	2013
Annual	Education reasons	Person	Decision to change	From 3 to 5 months	Portugal	2013
Annual	Education reasons	Person	Decision to change	From 3 to 5 months	Romania	2013
Annual	Education reasons	Person	Decision to change	From 3 to 5 months	Sweden	2013	5
Annual	Education reasons	Person	Decision to change	From 6 to 11 months	Bulgaria	2013
Annual	Education reasons	Person	Decision to change	From 6 to 11 months	France	2013
Annual	Education reasons	Person	Decision to change	From 6 to 11 months	Poland	2013
Annual	Education reasons	Person	Decision to change	From 6 to 11 months	Portugal	2013


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

Share link

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