Baselight
Sign In

Long-term Residence Permits Issued During The Year

Eurostat code: migr_resltr ยท (2016 - 2023)

@eurostat.migr_resltr

Long-term Residence Permits Issued During The Year - Unpivoted
@eurostat.migr_resltr.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.

  • 130.41 KB
  • 112402 rows
  • 7 columns
freq

Freq

leg_fram

Leg Fram

unit

Unit

citizen

Citizen

geo

Geo

time_period

Time Period

value

Value

AnnualEU frameworkPersonAndorraAustria2016
AnnualEU frameworkPersonAndorraBelgium2016
AnnualEU frameworkPersonAndorraBulgaria2016
AnnualEU frameworkPersonAndorraCyprus2016
AnnualEU frameworkPersonAndorraEstonia2016
AnnualEU frameworkPersonAndorraSpain20161
AnnualEU frameworkPersonAndorraFinland2016
AnnualEU frameworkPersonAndorraFrance2016
AnnualEU frameworkPersonAndorraCroatia2016
AnnualEU frameworkPersonAndorraHungary2016

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

Share link

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