Prisoners By Offence Category And Sex

Eurostat code: crim_pris_off · (2008 - 2023)

@eurostat.crim_pris_off

Table List

2 tables(82.07 KB)

Prisoners By Offence Category And Sex - Raw

Prisoners By Offence Category And Sex - Unpivoted

Prisoners By Offence Category And Sex - Unpivoted

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

31.67 KB
7673 rows
7 columns

freq Freq	iccs Iccs	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Intentional homicide	Females	Number	Albania	2008	51
Annual	Intentional homicide	Females	Number	Austria	2008	36
Annual	Intentional homicide	Females	Number	Belgium	2008	51
Annual	Intentional homicide	Females	Number	Bulgaria	2008	52
Annual	Intentional homicide	Females	Number	Switzerland	2008	21
Annual	Intentional homicide	Females	Number	Denmark	2008	14
Annual	Intentional homicide	Females	Number	Greece	2008	44
Annual	Intentional homicide	Females	Number	Spain	2008	150
Annual	Intentional homicide	Females	Number	Finland	2008	54
Annual	Intentional homicide	Females	Number	France	2008	245


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