Suspects And Offenders By Citizenship

Eurostat code: crim_just_ctz · (2008 - 2023)

@eurostat.crim_just_ctz

Table List

2 tables(120.08 KB)

Suspects And Offenders By Citizenship - Raw

Suspects And Offenders By Citizenship - Unpivoted

Suspects And Offenders By Citizenship - Raw

@eurostat.crim_just_ctz.raw

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

63.17 KB
578 rows
21 columns

freq Freq	leg_stat Leg Stat	citizen Citizen	unit Unit	geo Geo	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	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	Convicted person	Foreign country	Number	Austria	10991	11309	12062	11625	11795	12107	12210	12857	12520	13001	12033	11665	9665	9795	10414	11279
Annual	Convicted person	Foreign country	Number	Bosnia and Herzegovina				39	43	41
Annual	Convicted person	Foreign country	Number	Belgium			21553	23541	28623	28530	24628	28355		53018	51534	45414	35396
Annual	Convicted person	Foreign country	Number	Bulgaria	903	1024	2286	1579	1931	3464	4851	3271	2281	1465	1211	1177	1011	1866	2515	2306
Annual	Convicted person	Foreign country	Number	Switzerland	48519	50817	53598	53143	58875	60829	61374	61178	61496	59938	60499	53502	53502	54590	58135	61297
Annual	Convicted person	Foreign country	Number	Czechia	5498	5328	4853	4853	4913	4920	4777	4877	5168	5128	5312	5843	4721	5001	5488	6396
Annual	Convicted person	Foreign country	Number	Germany	173642	169315	169667	177575	176942	185042	194673	209603	231562	233065	242311	255885	247657	238665	238653	255669
Annual	Convicted person	Foreign country	Number	Denmark							36347	29598	30119	29661	33005	11500	11104	10838	11527	12958
Annual	Convicted person	Foreign country	Number	Greece														2179	1644	1393
Annual	Convicted person	Foreign country	Number	Spain							55356	54897	65550	67424	70444	74506	57836	72755	81231	80426


CREATE TABLE raw (
  "freq" VARCHAR,
  "leg_stat" VARCHAR,
  "citizen" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "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.