Prisoners By Legal Status Of The Trial Process

Eurostat code: crim_pris_tri · (2008 - 2023)

@eurostat.crim_pris_tri

Table List

2 tables(53.41 KB)

Prisoners By Legal Status Of The Trial Process - Raw

Prisoners By Legal Status Of The Trial Process - Unpivoted

Prisoners By Legal Status Of The Trial Process - Raw

@eurostat.crim_pris_tri.raw

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

31.81 KB
192 rows
20 columns

freq Freq	leg_stat Leg Stat	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	Pre-trial	Number	Albania	1947	1628	1885	1850	1756	1975	2924	2945	2980	2374	2220	2264	2325	2793	2858	2822
Annual	Pre-trial	Number	Austria	1883	1994	1895	1816	1791	1809	1834	1721	1766	1938	1874	1813	1571	1614	1864	1868
Annual	Pre-trial	Number	Bosnia and Herzegovina			491	402		338	343	411	435	435	1229	1426	1172	1124	1247	1173
Annual	Pre-trial	Number	Belgium	3527	3561	3709	3890	3535	3746		3019				3013	2970	2923	2935	3069
Annual	Pre-trial	Number	Bulgaria	794	890	1059	1099	927	774	669	689	587	639	609	623	677	545	476	461
Annual	Pre-trial	Number	Switzerland	2350	2521	2566	2406	2753	2915	2770	2756	2770	2756	2969	2908	2884	2843	3043	3260
Annual	Pre-trial	Number	Cyprus	118	105	139	135	156	117	101	110	135	151	188	242	169	214	300	296
Annual	Pre-trial	Number	Czechia	2402	2415	2443	2613	2183	2308	2185	1960	1907	1809	1816	1798	1570	1392	1438	1566
Annual	Pre-trial	Number	Germany	13713	13601	12911	12899	12903	12943	12981	13713	14671	15786	15709	14576	13796	12993	13826	15588
Annual	Pre-trial	Number	Denmark	1183	1426	1409	1381	1092	1226	1066	930	923	1275	1236	1351	1554	1242	1281	1213


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