Intentional Homicide And Sexual Offences By Legal Status And Sex Of The Person Involved

Eurostat code: crim_hom_soff · (2008 - 2023)

@eurostat.crim_hom_soff

Table List

2 tables(234.82 KB)

Intentional Homicide And Sexual Offences By Legal Status And Sex Of The Person Involved - Raw

Intentional Homicide And Sexual Offences By Legal Status And Sex Of The Person Involved - Unpivoted

Intentional Homicide And Sexual Offences By Legal Status And Sex Of The Person Involved - Unpivoted

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

96.31 KB
33596 rows
8 columns

freq Freq	iccs Iccs	leg_stat Leg Stat	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Intentional homicide	Convicted person	Females	Number	Austria	2008	6
Annual	Intentional homicide	Convicted person	Females	Number	Bulgaria	2008	9
Annual	Intentional homicide	Convicted person	Females	Number	Switzerland	2008	5
Annual	Intentional homicide	Convicted person	Females	Number	Cyprus	2008	1
Annual	Intentional homicide	Convicted person	Females	Number	Czechia	2008	15
Annual	Intentional homicide	Convicted person	Females	Number	Denmark	2008	1
Annual	Intentional homicide	Convicted person	Females	Number	Finland	2008	7
Annual	Intentional homicide	Convicted person	Females	Number	France	2008	80
Annual	Intentional homicide	Convicted person	Females	Number	Croatia	2008	1
Annual	Intentional homicide	Convicted person	Females	Number	Hungary	2008	27


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