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 - Unpivoted

@eurostat.crim_pris_tri.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

21.6 KB
2843 rows
6 columns

freq Freq	leg_stat Leg Stat	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Pre-trial	Number	Albania	2008	1947
Annual	Pre-trial	Number	Austria	2008	1883
Annual	Pre-trial	Number	Belgium	2008	3527
Annual	Pre-trial	Number	Bulgaria	2008	794
Annual	Pre-trial	Number	Switzerland	2008	2350
Annual	Pre-trial	Number	Cyprus	2008	118
Annual	Pre-trial	Number	Czechia	2008	2402
Annual	Pre-trial	Number	Germany	2008	13713
Annual	Pre-trial	Number	Denmark	2008	1183
Annual	Pre-trial	Number	Estonia	2008	990


CREATE TABLE tidy (
  "freq" VARCHAR,
  "leg_stat" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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