Intentional Homicide Victims In Largest Cities By Sex

Eurostat code: crim_hom_vcit · (2008 - 2023)

@eurostat.crim_hom_vcit

Table List

2 tables(24.44 KB)

Intentional Homicide Victims In Largest Cities By Sex - Raw

Intentional Homicide Victims In Largest Cities By Sex - Unpivoted

Intentional Homicide Victims In Largest Cities By Sex - Unpivoted

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

7.26 KB
670 rows
6 columns

freq Freq	sex Sex	unit Unit	cities Cities	time_period Time Period	value Value
Annual	Total	Number	Tirana	2008	18
Annual	Total	Number	Wien (greater city)	2008	48
Annual	Total	Number	Sofia	2008	27
Annual	Total	Number	Praha	2008	19
Annual	Total	Number	Helsinki/Helsingfors	2008	16
Annual	Total	Number	Budapest (greater city)	2008	33
Annual	Total	Number	Roma	2008	28
Annual	Total	Number	Luxembourg (greater city)	2008	3
Annual	Total	Number	Skopje	2008	13
Annual	Total	Number	Amsterdam (greater city)	2008	11


CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "cities" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.