Persons Brought Before Criminal Courts By Legal Status Of The Court Process

Eurostat code: crim_crt_per · (2008 - 2023)

@eurostat.crim_crt_per

Table List

2 tables(44.55 KB)

Persons Brought Before Criminal Courts By Legal Status Of The Court Process - Raw

Persons Brought Before Criminal Courts By Legal Status Of The Court Process - Unpivoted

Persons Brought Before Criminal Courts By Legal Status Of The Court Process - Raw

@eurostat.crim_crt_per.raw

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

26.73 KB
140 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	Acquitted	Number	Albania		431	400	474	370	397	375	525	1090	528	404	372	331	420	392	309
Annual	Acquitted	Number	Austria		11209	10875	10797		10727	10727	10677					7967	8901	8556	9077
Annual	Acquitted	Number	Bosnia and Herzegovina	800	770	775	722	1010	1057	1278	1103	1110	1144	1189	1172	861	851	1044	990
Annual	Acquitted	Number	Bulgaria	1094	1097	1606	1282	1463	1128	965	820	767	740	718	585	650	616	553	573
Annual	Acquitted	Number	Cyprus	1129	1007	1252	1303	1490	1233	875	1959	2236	1552	1595
Annual	Acquitted	Number	Czechia		5144	5623	5631	5601	4812	4677	4312	3594	3256	3044	2739	2299	2058	1818	1679
Annual	Acquitted	Number	Germany	31874	32738	32048	30798	29440	29209	28652	26950	24871	24273	23741	24875	22268	21562	20439	20834
Annual	Acquitted	Number	Denmark	13995	14798	16570	16717	16481	15563	15224	14734	14380	15457	15310	17920	19549	19682	19275	19856
Annual	Acquitted	Number	Estonia		193				161	87	81	88	31	39	64	97	112	86	73
Annual	Acquitted	Number	Greece															78	70


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.