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

@eurostat.urt_crim_gen.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

104.61 KB
21408 rows
7 columns

freq Freq	unit Unit	terrtypo Terrtypo	iccs Iccs	geo Geo	time_period Time Period	value Value
Annual	Number	Border regions	Intentional homicide	Albania	2008	46
Annual	Number	Border regions	Intentional homicide	Austria	2008	21
Annual	Number	Border regions	Intentional homicide	Belgium	2008	124
Annual	Number	Border regions	Intentional homicide	Bulgaria	2008	77
Annual	Number	Border regions	Intentional homicide	Denmark	2008	22
Annual	Number	Border regions	Intentional homicide	Greece	2008	7
Annual	Number	Border regions	Intentional homicide	Spain	2008	57
Annual	Number	Border regions	Intentional homicide	Italy	2008	38
Annual	Number	Border regions	Intentional homicide	Liechtenstein	2008	1
Annual	Number	Border regions	Intentional homicide	Luxembourg	2008	7


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "terrtypo" VARCHAR,
  "iccs" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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