Suspects And Offenders By Citizenship

Eurostat code: crim_just_ctz · (2008 - 2023)

@eurostat.crim_just_ctz

Table List

2 tables(120.08 KB)

Suspects And Offenders By Citizenship - Raw

Suspects And Offenders By Citizenship - Unpivoted

Suspects And Offenders By Citizenship - Unpivoted

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

56.91 KB
7327 rows
7 columns

freq Freq	leg_stat Leg Stat	citizen Citizen	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Convicted person	Foreign country	Number	Austria	2008	10991
Annual	Convicted person	Foreign country	Number	Bulgaria	2008	903
Annual	Convicted person	Foreign country	Number	Switzerland	2008	48519
Annual	Convicted person	Foreign country	Number	Czechia	2008	5498
Annual	Convicted person	Foreign country	Number	Germany	2008	173642
Annual	Convicted person	Foreign country	Number	Finland	2008	19536
Annual	Convicted person	Foreign country	Number	France	2008	80518
Annual	Convicted person	Foreign country	Number	Hungary	2008	2936
Annual	Convicted person	Foreign country	Number	Italy	2008	86067
Annual	Convicted person	Foreign country	Number	Latvia	2008	108


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

Share link

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