Police-recorded Offences By Offence Category

Eurostat code: crim_off_cat$dv_1401

@eurostat.crim_off_cat_dv_1401

Table List

2 tables(18.95 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_1401.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.

7.53 KB
408 rows
6 columns

freq Freq	iccs Iccs	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Acts against computer systems	Number	Albania	2016	84
Annual	Acts against computer systems	Number	Austria	2016	13103
Annual	Acts against computer systems	Number	Belgium	2016	3660
Annual	Acts against computer systems	Number	Bulgaria	2016	58
Annual	Acts against computer systems	Number	Cyprus	2016	40
Annual	Acts against computer systems	Number	Germany	2016	15060
Annual	Acts against computer systems	Number	Estonia	2016	130
Annual	Acts against computer systems	Number	Greece	2016	142
Annual	Acts against computer systems	Number	Finland	2016	1008
Annual	Acts against computer systems	Number	France	2016	10549


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.