Baselight
Sign In

First Residence Permits By Reasons - % Of Total First Residence Permits

Eurostat code: migr_resfpc ยท (2008 - 2023)

@eurostat.migr_resfpc

First Residence Permits By Reasons - % Of Total First Residence Permits - Unpivoted
@eurostat.migr_resfpc.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.

  • 15.46 KB
  • 1964 rows
  • 6 columns
freq

Freq

reason

Reason

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEducation reasonsPercentageAustria200813.1
AnnualEducation reasonsPercentageBelgium200814.59
AnnualEducation reasonsPercentageBulgaria200829.7
AnnualEducation reasonsPercentageCyprus200815.99
AnnualEducation reasonsPercentageCzechia20086.88
AnnualEducation reasonsPercentageGermany200826.24
AnnualEducation reasonsPercentageDenmark200860.9
AnnualEducation reasonsPercentageEstonia20088.73
AnnualEducation reasonsPercentageGreece20083.59
AnnualEducation reasonsPercentageSpain20085.42

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

Share link

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