Baselight
Sign In

Decisions On Asylum Applications By Citizenship (until 2007) - Annual Data

Eurostat code: migr_asydctzy ยท (1999 - 2007)

@eurostat.migr_asydctzy

Decisions On Asylum Applications By Citizenship (until 2007) - Annual Data - Unpivoted
@eurostat.migr_asydctzy.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.

  • 134.32 KB
  • 235589 rows
  • 7 columns
freq

Freq

unit

Unit

decision

Decision

citizen

Citizen

geo

Geo

time_period

Time Period

value

Value

AnnualPersonApplications pending at the end of the periodAndorraAustria1999
AnnualPersonApplications pending at the end of the periodAndorraDenmark1999
AnnualPersonApplications pending at the end of the periodAndorraIreland1999
AnnualPersonApplications pending at the end of the periodAndorraSweden1999
AnnualPersonApplications pending at the end of the periodUnited Arab EmiratesAustria1999
AnnualPersonApplications pending at the end of the periodUnited Arab EmiratesDenmark1999
AnnualPersonApplications pending at the end of the periodUnited Arab EmiratesIreland1999
AnnualPersonApplications pending at the end of the periodUnited Arab EmiratesSweden1999
AnnualPersonApplications pending at the end of the periodAfghanistanAustria1999
AnnualPersonApplications pending at the end of the periodAfghanistanDenmark1999235

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

Share link

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