Prisoners By Citizenship

Eurostat code: crim_pris_ctz · (2008 - 2023)

@eurostat.crim_pris_ctz

Table List

2 tables(62.13 KB)

Prisoners By Citizenship - Raw

Prisoners By Citizenship - Unpivoted

Prisoners By Citizenship - Raw

@eurostat.crim_pris_ctz.raw

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

35.87 KB
242 rows
20 columns

freq Freq	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	Foreign country	Number	Albania	36	38	54	69	68	84	99	89	89	101	90	113	109	114	123	125
Annual	Foreign country	Number	Austria	3349	3974	3904	4055	4180	4373	4449	4702	4686	4831	5029	4794	4298	4156	4644	4800
Annual	Foreign country	Number	Bosnia and Herzegovina			24	67		54	46	57	49	32	51	78	174	100	120	55
Annual	Foreign country	Number	Belgium	4124	4276	4430	4854	4902	5271		4812		4627	4555	4771	4593	4706	4730	5219
Annual	Foreign country	Number	Bulgaria	187	165	146	175	180	253	232	242	215	186	161	137	154	159	134	163
Annual	Foreign country	Number	Switzerland	3581	3831	4030	3911	4390	4857	4673	4514	4599	4615	4679	4478	4340	4230	4396	4734
Annual	Foreign country	Number	Cyprus	377	321	374	356	404	306	239	214	237	151	276	372	260	417	531	544
Annual	Foreign country	Number	Czechia	1449	579	1600	1730	1715	1523	1549	1670	1807	1814	1768	1794	1534	1396	1459	1651
Annual	Foreign country	Number	Denmark	792	811	853	838	979	1098	1002	865	954	968	1039	1137	1171	1074	1145	1107
Annual	Foreign country	Number	Estonia	165	1399	1349	1302	1248	1192	1226	1096	1060	996	916	837	799	725	686	623


CREATE TABLE raw (
  "freq" 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.