Corruption Perceptions Index

Eurostat code: sdg_16_50 · (2012 - 2024)

@eurostat.sdg_16_50

Table List

2 tables(18.71 KB)

Corruption Perceptions Index - Unpivoted

Corruption Perceptions Index - Unpivoted

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

5.25 KB
572 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	Albania	2012	33
Annual	Number	Austria	2012	69
Annual	Number	Bosnia and Herzegovina	2012	42
Annual	Number	Belgium	2012	75
Annual	Number	Bulgaria	2012	41
Annual	Number	Switzerland	2012	86
Annual	Number	Cyprus	2012	66
Annual	Number	Czechia	2012	49
Annual	Number	Germany	2012	79
Annual	Number	Denmark	2012	90


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

Share link

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