Suspects Of Migrant Smuggling By Citizenship

Eurostat code: crim_smu_sctz · (2016 - 2023)

@eurostat.crim_smu_sctz

Table List

2 tables(22.7 KB)

Suspects Of Migrant Smuggling By Citizenship - Raw

Suspects Of Migrant Smuggling By Citizenship - Unpivoted

Suspects Of Migrant Smuggling By Citizenship - Raw

@eurostat.crim_smu_sctz.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

13.94 KB
159 rows
12 columns

freq Freq	citizen Citizen	unit Unit	geo Geo	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	EU27 countries (from 2020) except reporting country	Number	Austria		5	3	1	13	3	207	294
Annual	EU27 countries (from 2020) except reporting country	Number	Bosnia and Herzegovina	1			14	2	1	4	19
Annual	EU27 countries (from 2020) except reporting country	Number	Belgium			11		16		27	35
Annual	EU27 countries (from 2020) except reporting country	Number	Bulgaria
Annual	EU27 countries (from 2020) except reporting country	Number	Cyprus	5		3	3	4	8	14	8
Annual	EU27 countries (from 2020) except reporting country	Number	Czechia	5	2	9	4	7	13	56	66
Annual	EU27 countries (from 2020) except reporting country	Number	Germany			480	388	460	545	488	641
Annual	EU27 countries (from 2020) except reporting country	Number	Denmark			2			1
Annual	EU27 countries (from 2020) except reporting country	Number	Greece	96	158	186	178	90	88	120	125
Annual	EU27 countries (from 2020) except reporting country	Number	Spain	22	47	50	24	26	31	16	17


CREATE TABLE raw (
  "freq" VARCHAR,
  "citizen" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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