Baselight
Sign In

First Permits Issued For Other Reasons By Reason, Length Of Validity And Citizenship

Eurostat code: migr_resoth ยท (2008 - 2023)

@eurostat.migr_resoth

First Permits Issued For Other Reasons By Reason, Length Of Validity And Citizenship - Unpivoted
@eurostat.migr_resoth.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.

  • 1.26 MB
  • 2290677 rows
  • 8 columns
freq

Freq

reason

Reason

citizen

Citizen

unit

Unit

duration

Duration

geo

Geo

time_period

Time Period

value

Value

AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsAustria2008
AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsBelgium2008
AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsBulgaria2008
AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsCyprus2008
AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsCzechia2008
AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsGermany2008
AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsDenmark2008
AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsEstonia2008
AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsGreece2008
AnnualNot specifiedAndorraPersonFrom 3 to 5 monthsSpain2008

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

Share link

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