Police-recorded Offences By Offence Category

Eurostat code: crim_off_cat · (2008 - 2023)

@eurostat.crim_off_cat

Table List

2 tables(215.4 KB)

Police-recorded Offences By Offence Category - Raw

Police-recorded Offences By Offence Category - Unpivoted

Police-recorded Offences By Offence Category - Raw

@eurostat.crim_off_cat.raw

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

120.14 KB
1564 rows
20 columns

freq Freq	iccs Iccs	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	Number	Albania	88	82	118	124	125	107	98	54	71	52	51	58	52	61	42	34
Annual	Intentional homicide	Number	Austria	58	51	61	80	88	63	43	42	49	61	73	74	54	59	65	75
Annual	Intentional homicide	Number	Bosnia and Herzegovina	66	67	54	49	60	46	49	56	42	34	36	37	42	31	34	35
Annual	Intentional homicide	Number	Belgium	204	189	189	214	206	204	210	231	175	198	192	147	149	157	185	162
Annual	Intentional homicide	Number	Bulgaria	172	150	148	128	141	109	112	126	79	95	92	81	67	89	76	74
Annual	Intentional homicide	Number	Switzerland	54	51	53	46	45	57	41	57	45	45	50	46	47	42	42	53
Annual	Intentional homicide	Number	Cyprus	9	19	7	8	19	11	10	12	11	7	14	13	15	14	7	10
Annual	Intentional homicide	Number	Czechia	113	105	105	83	95	90	81	88	65	40	55	81	57	46	79	68
Annual	Intentional homicide	Number	Germany	656	721	699	689	619	623	645	655	747	738	632	586	719	631	614	661
Annual	Intentional homicide	Number	Denmark	53	56	49	49	43	41	62	52	53	61	54	54	51	42	59	53


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