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

@eurostat.crim_hom_soff_dv_1941.raw

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

37.94 KB
658 rows
16 columns

freq Freq	iccs Iccs	leg_stat Leg Stat	sex Sex	unit Unit	geo Geo	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	Victim	Females	Number	Albania	13	16	17	12	15	13	9	12	8	12
Annual	Intentional homicide	Victim	Females	Number	Austria	23	17	31	37	44	40	37	40	41	45
Annual	Intentional homicide	Victim	Females	Number	Bosnia and Herzegovina	11	18	15	10	8	10	5	7	12	13
Annual	Intentional homicide	Victim	Females	Number	Bulgaria	26	29	22	35	38	23	26	28	29	31
Annual	Intentional homicide	Victim	Females	Number	Switzerland	24	30	25	20	28	26	27	25	20	28
Annual	Intentional homicide	Victim	Females	Number	Cyprus	5	2	5		6	10	10	7	4	1
Annual	Intentional homicide	Victim	Females	Number	Czechia	45	49	36	30		39	39	27	39	45
Annual	Intentional homicide	Victim	Females	Number	Germany	339	327	469	380	367	276	357	337	349	374
Annual	Intentional homicide	Victim	Females	Number	Denmark	31	24	23	20	20	24	15	14	23	17
Annual	Intentional homicide	Victim	Females	Number	Estonia	9	10	9	8	5	6	10	4	4	6


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