Intentional Homicide Offences In Largest Cities

Eurostat code: crim_hom_ocit · (2008 - 2023)

@eurostat.crim_hom_ocit

Table List

2 tables(25.05 KB)

Intentional Homicide Offences In Largest Cities - Raw

Intentional Homicide Offences In Largest Cities - Unpivoted

Intentional Homicide Offences In Largest Cities - Unpivoted

@eurostat.crim_hom_ocit.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.27 KB
881 rows
5 columns

freq Freq	unit Unit	cities Cities	time_period Time Period	value Value
Annual	Number	Tirana	2008	22
Annual	Number	Wien (greater city)	2008	17
Annual	Number	Sarajevo	2008	10
Annual	Number	Bruxelles/Brussel (greater city)	2008	44
Annual	Number	Sofia	2008	27
Annual	Number	Lefkosia (greater city)	2008	3
Annual	Number	Praha	2008	18
Annual	Number	Berlin	2008	42
Annual	Number	Athina (greater city)	2008	69
Annual	Number	Madrid (greater city)	2008	39


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

Share link

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