Prisoners By Offence Category And Sex

Eurostat code: crim_pris_off · (2008 - 2023)

@eurostat.crim_pris_off

Table List

2 tables(82.07 KB)

Prisoners By Offence Category And Sex - Raw

Prisoners By Offence Category And Sex - Unpivoted

Prisoners By Offence Category And Sex - Raw

@eurostat.crim_pris_off.raw

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

50.39 KB
681 rows
21 columns

freq Freq	iccs Iccs	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	Females	Number	Albania	51	9	27	32	28	22	16	4	4	3	3	2	1	1	1
Annual	Intentional homicide	Females	Number	Austria	36	36	37	31	32	37	37	37	6	39	30	31	33	37	38	42
Annual	Intentional homicide	Females	Number	Bosnia and Herzegovina						20	21	20	10		10	25	24	22	22
Annual	Intentional homicide	Females	Number	Belgium	51	40	45	49	63
Annual	Intentional homicide	Females	Number	Bulgaria	52	53	54	43	37	34	36	37	37	34	39	36	33	32	28	59
Annual	Intentional homicide	Females	Number	Switzerland	21	29	32	31	34	33	41	43	46	49	53	60	62	60	54
Annual	Intentional homicide	Females	Number	Cyprus			1	1	1	2									2
Annual	Intentional homicide	Females	Number	Czechia				96	89	96	107	108	119	114	119	109	115	109	119	110
Annual	Intentional homicide	Females	Number	Germany						249	229	229	211	204	212	215	222	213	215	221
Annual	Intentional homicide	Females	Number	Denmark	14	14	15	18	16	14	13	9	9	12	9	12	11	8	14	11


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