Police-recorded Offences By Offence Category

Eurostat code: crim_off_cat$dv_348

@eurostat.crim_off_cat_dv_348

Table List

2 tables(47.05 KB)

Police-recorded Offences By Offence Category - Raw

Police-recorded Offences By Offence Category - Unpivoted

Police-recorded Offences By Offence Category - Unpivoted

@eurostat.crim_off_cat_dv_348.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.

17.62 KB
2468 rows
6 columns

freq Freq	iccs Iccs	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Intentional homicide	Number	Albania	2008	88
Annual	Intentional homicide	Number	Austria	2008	58
Annual	Intentional homicide	Number	Bosnia and Herzegovina	2008	66
Annual	Intentional homicide	Number	Belgium	2008	204
Annual	Intentional homicide	Number	Bulgaria	2008	172
Annual	Intentional homicide	Number	Switzerland	2008	54
Annual	Intentional homicide	Number	Cyprus	2008	9
Annual	Intentional homicide	Number	Czechia	2008	113
Annual	Intentional homicide	Number	Germany	2008	656
Annual	Intentional homicide	Number	Denmark	2008	53


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

Share link

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