Intentional Homicide Victims By Victim-offender Relationship And Sex

Eurostat code: crim_hom_vrel$dv_1645

@eurostat.crim_hom_vrel_dv_1645

Table List

2 tables(20.23 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_dv_1645.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.

9 KB
1553 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	Austria	2018	31
Annual	Family member	Females	Number	Switzerland	2018	8
Annual	Family member	Females	Number	Germany	2018	77
Annual	Family member	Females	Number	Spain	2018	26
Annual	Family member	Females	Number	Finland	2018	3
Annual	Family member	Females	Number	France	2018	40
Annual	Family member	Females	Number	Croatia	2018	1
Annual	Family member	Females	Number	Hungary	2018	2
Annual	Family member	Females	Number	Iceland	2018
Annual	Family member	Females	Number	Italy	2018	36


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.