Crimes Recorded By The Police By Other Typologies

Eurostat code: urt_crim_gen · (2008 - 2022)

@eurostat.urt_crim_gen

Table List

2 tables(229.15 KB)

Crimes Recorded By The Police By Other Typologies - Raw

Crimes Recorded By The Police By Other Typologies - Unpivoted

Crimes Recorded By The Police By Other Typologies - Raw

@eurostat.urt_crim_gen.raw

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

124.54 KB
2417 rows
20 columns

freq Freq	unit Unit	terrtypo Terrtypo	iccs Iccs	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
Annual	Number	Border regions	Intentional homicide	Albania	46	30	59	50	59	40	45	22	34	28	27	31	24	34	20
Annual	Number	Border regions	Intentional homicide	Austria	21	22	31	35	42	25	15	19	16	29	26	35	26	28	29
Annual	Number	Border regions	Intentional homicide	Belgium	124	130	116	158	130	131	138	149	108	119	121	93	93	100	118
Annual	Number	Border regions	Intentional homicide	Bulgaria	77	69	63	60	74	56	49	65	39	47	49	36	29	41	34
Annual	Number	Border regions	Intentional homicide	Switzerland		43	43	29	38	37	30	50	37	35	36	41	33	36	34
Annual	Number	Border regions	Intentional homicide	Cyprus
Annual	Number	Border regions	Intentional homicide	Czechia											79	53	38	35	52
Annual	Number	Border regions	Intentional homicide	Germany					107	110	104	99	105	96	81	81
Annual	Number	Border regions	Intentional homicide	Denmark	22	23	15	25	22	13	21	16	22	30	17	22	16	15	23
Annual	Number	Border regions	Intentional homicide	Estonia											16	10	18	8	8


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "terrtypo" VARCHAR,
  "iccs" 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
);

Share link

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