Name: Corruption Indicator Data Of 180 Governments
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Corruption Indicator Data Of 180 Governments

Disclaimer

This dataset is NOT a reflection of my personal views.

Background Context

The Corruption Perceptions Index (CPI) is the most widely used global corruption ranking in the world. It measures how corrupt each country’s public sector is perceived to be, according to experts and businesspeople (source).

Each country’s score is a combination of at least 3 data sources drawn from 13 different corruption surveys and assessments. These data sources are collected by a variety of reputable institutions, including the World Bank and the World Economic Forum (source).

About this Dataset

This dataset contains evaluation of corruption from two major agencies, Transparency International and Worldwide Governance Indicators (WGI), a World Bank project. The data from Transparency International is split into two files because they don't have exactly the same columns, although most columns are the same. It makes more sense to have them seperately, and you can merge them if you would like to.

transparency_active.csv contains Transparency International data from 2012-2021
transparency_legacy.csv contains Transparency International data from 1995-2011
wgidataset.csv contains WGI data from 1996-2021
wgidataset_readme.pdf is a documentation that explains what the indicators mean in wgidataset.csv

Tables

Transparency Active

@kaggle.cvengr_government_corruption_data_of_180_countries.transparency_active

28.87 KB
1820 rows
9 columns


CREATE TABLE transparency_active (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "iso3" VARCHAR,
  "region" VARCHAR,
  "year" BIGINT,
  "score" DOUBLE,
  "rank" DOUBLE,
  "sources" DOUBLE,
  "standarderror" DOUBLE
);

Transparency Legacy

@kaggle.cvengr_government_corruption_data_of_180_countries.transparency_legacy

40.73 KB
2116 rows
10 columns


CREATE TABLE transparency_legacy (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "iso" VARCHAR,
  "region" VARCHAR,
  "score" DOUBLE,
  "rank" BIGINT,
  "change" BIGINT,
  "year" BIGINT,
  "standard_deviation" VARCHAR,
  "range" VARCHAR
);

Wgidataset

@kaggle.cvengr_government_corruption_data_of_180_countries.wgidataset

731.37 KB
4922 rows
40 columns


CREATE TABLE wgidataset (
  "unnamed_0" BIGINT,
  "code" VARCHAR,
  "countryname" VARCHAR,
  "year" BIGINT,
  "vae" DOUBLE,
  "vas" DOUBLE,
  "van" DOUBLE,
  "var" DOUBLE,
  "val" DOUBLE,
  "vau" DOUBLE,
  "pve" DOUBLE,
  "pvs" DOUBLE,
  "pvn" DOUBLE,
  "pvr" DOUBLE,
  "pvl" DOUBLE,
  "pvu" DOUBLE,
  "gee" DOUBLE,
  "ges" DOUBLE,
  "gen" DOUBLE,
  "ger" DOUBLE,
  "gel" DOUBLE,
  "geu" DOUBLE,
  "rqe" DOUBLE,
  "rqs" DOUBLE,
  "rqn" DOUBLE,
  "rqr" DOUBLE,
  "rql" DOUBLE,
  "rqu" DOUBLE,
  "rle" DOUBLE,
  "rls" DOUBLE,
  "rln" DOUBLE,
  "rlr" DOUBLE,
  "rll" DOUBLE,
  "rlu" DOUBLE,
  "cce" DOUBLE,
  "ccs" DOUBLE,
  "ccn" DOUBLE,
  "ccr" DOUBLE,
  "ccl" DOUBLE,
  "ccu" DOUBLE
);