variables
Data license: CC-BY
19 rows where datasetId = 2985 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, timespan, display, createdAt (date), updatedAt (date)
id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104360 | Traditional leaders | Percentage of respondents who answered that either “Most” or “All” traditional leaders are corrupt. | 2019-05-09 13:58:21 | 2023-06-15 05:05:42 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||||
104359 | Tax officials | Percentage of respondents who answered that either “Most” or “All” tax officials are corrupt. | 2019-05-09 13:58:21 | 2023-06-15 05:05:42 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||||
104358 | Prime Minister / President | Percentage of respondents who answered that either “Most” or “All” Prime Ministers / Presidents are corrupt. | 2019-05-09 13:58:21 | 2023-06-15 05:05:42 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||||
104357 | Local government councillors | Percentage of respondents who answered that either “Most” or “All” local government councillors are corrupt. | 2019-05-09 13:58:21 | 2023-06-15 05:05:42 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||||
1423 | null | % | How do u delete this | 2016-10-13 18:26:06 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | % | {} |
0 | 1 | ||||||||||||||||||||||||
1420 | Bribery Rate (%) | % | Share of people who have bribed. | 2016-10-11 22:24:16 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | % | { "name": "Bribery Rate (%)" } |
0 | 1 | ||||||||||||||||||||||||
1418 | Government officials | % | Percentage of respondents who answered that either “Most” or “All” government officials are corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1417 | Police | % | Percentage of respondents who answered that either “Most” or “All” of the police are corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1416 | Medical and health | % | Share of respondents in a particular country who felt that medical and health services were corrupt/extremely corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1415 | Judges and magistrates | % | Percentage of respondents who answered that either “Most” or “All” judges and magistrates are corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1414 | Education system | % | Share of respondents in a particular country who felt that the education system is corrupt/extremely corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1413 | Business executives | % | Percentage of respondents who answered that either “Most” or “All” of the business executives are corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1412 | Religious leaders | % | Percentage of respondents who answered that either “Most” or “All” religious leaders are corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1411 | Media | % | Percentage of respondents who answered that either “Most” or “All” of the media are corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1410 | NGOs | % | Percentage of respondents who answered that either “Most” or “All” of NGOs are corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1409 | Military | % | Percentage of respondents who answered that either “Most” or “All” of the military is corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1408 | Legislature | % | Percentage of respondents who answered that either “Most” or “All” of the elected representatives / legislatures are corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1407 | Political Parties | % | Percentage of respondents who answered that either “Most” or “All” political parties are corrupt. | 2016-10-11 20:30:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 | |||||||||||||||||||||||||
1406 | Corruption Perception Rating | Average of all individuals' perception ratings on a scale from 1 (corruption is not a problem) to 5 (corruption is a very serious problem). | 2016-10-11 18:59:15 | 2023-06-15 05:05:42 | 2013 | Global Corruption Barometer - Transparancy International (2017) 2985 | Transparency International - GCB (2017) 409 | {} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(750) NULL , "unit" VARCHAR(255) NOT NULL , "description" TEXT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "code" VARCHAR(255) NULL , "coverage" VARCHAR(255) NOT NULL , "timespan" VARCHAR(255) NOT NULL , "datasetId" INTEGER NOT NULL , "sourceId" INTEGER NULL , "shortUnit" VARCHAR(255) NULL , "display" TEXT NOT NULL , "columnOrder" INTEGER NOT NULL DEFAULT '0' , "originalMetadata" TEXT NULL , "grapherConfigAdmin" TEXT NULL , "shortName" VARCHAR(255) NULL , "catalogPath" VARCHAR(767) NULL , "dimensions" TEXT NULL , "schemaVersion" INTEGER NOT NULL DEFAULT '1' , "processingLevel" VARCHAR(30) NULL , "processingLog" TEXT NULL , "titlePublic" VARCHAR(512) NULL , "titleVariant" VARCHAR(255) NULL , "attributionShort" VARCHAR(512) NULL , "attribution" TEXT NULL , "descriptionShort" TEXT NULL , "descriptionFromProducer" TEXT NULL , "descriptionKey" TEXT NULL , "descriptionProcessing" TEXT NULL , "licenses" TEXT NULL , "license" TEXT NULL , "grapherConfigETL" TEXT NULL , "type" TEXT NULL , "sort" TEXT NULL , "dataChecksum" VARCHAR(64) NULL , "metadataChecksum" VARCHAR(64) NULL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT, FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath"); CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId"); CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId"); CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId"); CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId"); CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");