Name: Persons Brought Before Criminal Courts By Legal Status Of The Court Process
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

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

This Eurostat dataset contains data on persons brought before criminal courts by legal status of the court process, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-04-23T11:00:00+0200

Tables

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

@eurostat.crim_crt_per.raw

27.37 kB
140 rows
20 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "leg_stat" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE  -- 2008,
  "n_2009" DOUBLE  -- 2009,
  "n_2010" DOUBLE  -- 2010,
  "n_2011" DOUBLE  -- 2011,
  "n_2012" DOUBLE  -- 2012,
  "n_2013" DOUBLE  -- 2013,
  "n_2014" DOUBLE  -- 2014,
  "n_2015" DOUBLE  -- 2015,
  "n_2016" DOUBLE  -- 2016,
  "n_2017" DOUBLE  -- 2017,
  "n_2018" DOUBLE  -- 2018,
  "n_2019" DOUBLE  -- 2019,
  "n_2020" DOUBLE  -- 2020,
  "n_2021" DOUBLE  -- 2021,
  "n_2022" DOUBLE  -- 2022,
  "n_2023" DOUBLE  -- 2023
);

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

@eurostat.crim_crt_per.tidy

18.25 kB
1,892 rows
6 columns

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