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

Eurostat code: crim_hom_soff · (2008 - 2023)

@eurostat.crim_hom_soff

Table List

2 tables(234.82 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 - Raw

@eurostat.crim_hom_soff.raw

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

138.51 KB
2687 rows
22 columns

freq Freq	iccs Iccs	leg_stat Leg Stat	sex Sex	unit Unit	geo Geo	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	Intentional homicide	Convicted person	Females	Number	Albania						4	3	5	3	2	1		2		3	1
Annual	Intentional homicide	Convicted person	Females	Number	Austria	6	3	3	3	4	5	4	4	4	2	2	2	4	6	1	2
Annual	Intentional homicide	Convicted person	Females	Number	Bosnia and Herzegovina				6	6	24	14	11	8	14	5	2	7	4	7	8
Annual	Intentional homicide	Convicted person	Females	Number	Belgium			24	33	21	22	20	12	11	14	8	13	7
Annual	Intentional homicide	Convicted person	Females	Number	Bulgaria	9	9	13	7	10	11	8	5	5	2	10	2	2	6	3	2
Annual	Intentional homicide	Convicted person	Females	Number	Switzerland	5	7	7	7	5	4	1	5	5	4	5	3	1	4	4	1
Annual	Intentional homicide	Convicted person	Females	Number	Cyprus	1		2		1					3			1	1
Annual	Intentional homicide	Convicted person	Females	Number	Czechia	15	11	19	23	13	18	21	14	17	13	16	12	20	17	11	22
Annual	Intentional homicide	Convicted person	Females	Number	Germany		48	38	39	29	29	33	36	31	40	35	29	34	28	40	38
Annual	Intentional homicide	Convicted person	Females	Number	Denmark	1	1	6	2	3	4	6	3	4	3	4	1	3	3	4	5


CREATE TABLE raw (
  "freq" VARCHAR,
  "iccs" VARCHAR,
  "leg_stat" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" 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.