Baselight
Sign In

Suspects Of Migrant Smuggling By Citizenship

Eurostat code: crim_smu_sctz ยท (2016 - 2023)

@eurostat.crim_smu_sctz

Suspects Of Migrant Smuggling By Citizenship - Unpivoted
@eurostat.crim_smu_sctz.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.

  • 8.75 KB
  • 966 rows
  • 6 columns
freq

Freq

citizen

Citizen

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryNumberAustria2016
AnnualEU27 countries (from 2020) except reporting countryNumberBosnia and Herzegovina20161
AnnualEU27 countries (from 2020) except reporting countryNumberCyprus20165
AnnualEU27 countries (from 2020) except reporting countryNumberCzechia20165
AnnualEU27 countries (from 2020) except reporting countryNumberGreece201696
AnnualEU27 countries (from 2020) except reporting countryNumberSpain201622
AnnualEU27 countries (from 2020) except reporting countryNumberFinland2016110
AnnualEU27 countries (from 2020) except reporting countryNumberCroatia201627
AnnualEU27 countries (from 2020) except reporting countryNumberHungary2016119
AnnualEU27 countries (from 2020) except reporting countryNumberItaly2016118

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

Share link

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