Prisoners By Age And Sex

Eurostat code: crim_pris_age · (2008 - 2023)

@eurostat.crim_pris_age

Table List

2 tables(127.16 KB)

Prisoners By Age And Sex - Unpivoted

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

55.56 KB
10530 rows
7 columns

freq Freq	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Adult	Females	Number	Albania	2008	101
Annual	Adult	Females	Number	Austria	2008	396
Annual	Adult	Females	Number	Belgium	2008	441
Annual	Adult	Females	Number	Bulgaria	2008	290
Annual	Adult	Females	Number	Switzerland	2008	298
Annual	Adult	Females	Number	Cyprus	2008	42
Annual	Adult	Females	Number	Czechia	2008	1079
Annual	Adult	Females	Number	Germany	2008	3930
Annual	Adult	Females	Number	Denmark	2008	155
Annual	Adult	Females	Number	Estonia	2008	190


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

Share link

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