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

@eurostat.crim_crt_per.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.

17.82 KB
1892 rows
6 columns

freq Freq	leg_stat Leg Stat	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Acquitted	Number	Bosnia and Herzegovina	2008	800
Annual	Acquitted	Number	Bulgaria	2008	1094
Annual	Acquitted	Number	Cyprus	2008	1129
Annual	Acquitted	Number	Germany	2008	31874
Annual	Acquitted	Number	Denmark	2008	13995
Annual	Acquitted	Number	Spain	2008	41267
Annual	Acquitted	Number	Finland	2008	3404
Annual	Acquitted	Number	France	2008	26735
Annual	Acquitted	Number	Croatia	2008	8779
Annual	Acquitted	Number	Hungary	2008	7942


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.