Baselight
Sign In

Valid Permits By Reasons - % Of Total Valid Permits

Eurostat code: migr_resspc ยท (2008 - 2023)

@eurostat.migr_resspc

Valid Permits By Reasons - % Of Total Valid Permits - Unpivoted
@eurostat.migr_resspc.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.

  • 17.17 KB
  • 2525 rows
  • 6 columns
freq

Freq

reason

Reason

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEducation reasonsPercentageBulgaria200831.08
AnnualEducation reasonsPercentageCyprus200812.47
AnnualEducation reasonsPercentageCzechia20082.28
AnnualEducation reasonsPercentageGermany20083.22
AnnualEducation reasonsPercentageEstonia20080.2
AnnualEducation reasonsPercentageGreece20081.17
AnnualEducation reasonsPercentageSpain20081.45
AnnualEducation reasonsPercentageFinland20085.74
AnnualEducation reasonsPercentageFrance20085.67
AnnualEducation reasonsPercentageHungary20088.62

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.