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 - Raw

@eurostat.crim_hom_ocit.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

17.78 KB
72 rows
19 columns

freq Freq	unit Unit	cities Cities	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Number	Tirana	22	21	25	26	25	31	23	12	18	10	10	12	9	10	8	9
Annual	Number	Wien (greater city)	17	20	18	25	25	24	11	9	17	14	34	24	11	14	18	20
Annual	Number	Sarajevo	10		6	9	13	8	8	12		8	5	11
Annual	Number	Bruxelles/Brussel (greater city)	44	33	31	27	35	35	37	11	11	10	14	10	13	6	20
Annual	Number	Sofia	27	26	20	20	24	18	25	16	11	12	11	10	10	14	10	16
Annual	Number	Bern (greater city)														3	4	4
Annual	Number	Zurich (greater city)		4	10	1	2		2	2	4	2	2	8	1
Annual	Number	Lefkosia (greater city)	3	3	4	2	5	4	2	4	2	4	4	14
Annual	Number	Praha	18	23	16	13	16	12	10	10	10	12	11	14	10	7	16	8
Annual	Number	Berlin	42	67	41	43	50	53	47	22	39	34	36	44	49	48	46	45


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "cities" VARCHAR,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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