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

Eurostat code: crim_hom_soff$dv_1941

@eurostat.crim_hom_soff_dv_1941

Table List

2 tables(64.43 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_dv_1941.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.

26.5 KB
5586 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	Victim	Females	Number	Albania	2014	13
Annual	Intentional homicide	Victim	Females	Number	Austria	2014	23
Annual	Intentional homicide	Victim	Females	Number	Bosnia and Herzegovina	2014	11
Annual	Intentional homicide	Victim	Females	Number	Bulgaria	2014	26
Annual	Intentional homicide	Victim	Females	Number	Switzerland	2014	24
Annual	Intentional homicide	Victim	Females	Number	Cyprus	2014	5
Annual	Intentional homicide	Victim	Females	Number	Czechia	2014	45
Annual	Intentional homicide	Victim	Females	Number	Germany	2014	339
Annual	Intentional homicide	Victim	Females	Number	Denmark	2014	31
Annual	Intentional homicide	Victim	Females	Number	Estonia	2014	9


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.