Bribery By Legal Status And Sex Of The Person Involved

Eurostat code: crim_just_bri · (2016 - 2023)

@eurostat.crim_just_bri

Table List

2 tables(34.3 KB)

Bribery By Legal Status And Sex Of The Person Involved - Raw

Bribery By Legal Status And Sex Of The Person Involved - Unpivoted

Bribery By Legal Status And Sex Of The Person Involved - Unpivoted

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

13.41 KB
2696 rows
7 columns

freq Freq	leg_stat Leg Stat	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Convicted person	Females	Number	Albania	2016	20
Annual	Convicted person	Females	Number	Austria	2016
Annual	Convicted person	Females	Number	Bosnia and Herzegovina	2016	8
Annual	Convicted person	Females	Number	Belgium	2016	1
Annual	Convicted person	Females	Number	Bulgaria	2016	9
Annual	Convicted person	Females	Number	Switzerland	2016	6
Annual	Convicted person	Females	Number	Czechia	2016	11
Annual	Convicted person	Females	Number	Denmark	2016
Annual	Convicted person	Females	Number	Estonia	2016	3
Annual	Convicted person	Females	Number	Spain	2016	22


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

Share link

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