Intentional Homicide Victims By Victim-offender Relationship And Sex

Eurostat code: crim_hom_vrel · (2008 - 2023)

@eurostat.crim_hom_vrel

Table List

2 tables(42.94 KB)

Intentional Homicide Victims By Victim-offender Relationship And Sex - Raw

Intentional Homicide Victims By Victim-offender Relationship And Sex - Unpivoted

Intentional Homicide Victims By Victim-offender Relationship And Sex - Unpivoted

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

14.71 KB
4891 rows
7 columns

freq Freq	pers_cat Pers Cat	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Family member	Females	Number	Czechia	2008	11
Annual	Family member	Females	Number	Finland	2008	3
Annual	Family member	Females	Number	Italy	2008	51
Annual	Family member	Females	Number	Lithuania	2008	9
Annual	Family member	Females	Number	Netherlands	2008	12
Annual	Family member	Females	Number	Slovenia	2008	1
Annual	Family member	Females	Number	England and Wales	2008	31
Annual	Family member	Females	Number	Scotland (NUTS 2021)	2008	3
Annual	Family member	Females	Number	Northern Ireland (UK) (NUTS 2021)	2008
Annual	Family member	Females	Per hundred thousand inhabitants	Czechia	2008	0.21


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