Prisoners By Citizenship

Eurostat code: crim_pris_ctz · (2008 - 2023)

@eurostat.crim_pris_ctz

Table List

2 tables(62.13 KB)

Prisoners By Citizenship - Unpivoted

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

26.26 KB
3470 rows
6 columns

freq Freq	citizen Citizen	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Foreign country	Number	Albania	2008	36
Annual	Foreign country	Number	Austria	2008	3349
Annual	Foreign country	Number	Belgium	2008	4124
Annual	Foreign country	Number	Bulgaria	2008	187
Annual	Foreign country	Number	Switzerland	2008	3581
Annual	Foreign country	Number	Cyprus	2008	377
Annual	Foreign country	Number	Czechia	2008	1449
Annual	Foreign country	Number	Denmark	2008	792
Annual	Foreign country	Number	Estonia	2008	165
Annual	Foreign country	Number	Greece	2008	6176


CREATE TABLE tidy (
  "freq" 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.