sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 2986 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
410 Transparency International – BPI 
{
    "link": "http://www.transparency.org/research/bpi/overview",
    "retrievedDate": "11/10/2016",
    "additionalInfo": "Data for the Bribe Payers Index is drawn from the Bribe Payers Survey. The survey asked business executives: \"In your principal lines of business in this country, do you have business relationships (for example as a supplier, client, partner or competitor) with companies whose headquarters are located in any of the following countries?\".\n\n \n\nRespondents were presented a list of 28 countries. For each instance where the respondent answered that they do have business relationships with companies headquartered in a country, the respondents were then asked: \"How often do firms headquartered in (country name) engage in bribery in this country?\"\n\n \n\nAnswers were given on a 5-point scale where 1 corresponded to \u2018never\u2019 and 5 to \u2018always\u2019. This was then converted into a 10-point scale system, where 10 corresponds to \u2018never\u2019 and 0 to \u2018always\u2019. Since the index reflects views on foreign bribery, assessments of companies from the respondents\u2019 own countries were excluded.",
    "dataPublishedBy": "Transparency International \u2013 Bribe Payers Index \u00a0",
    "dataPublisherSource": "Surveys among business executives"
}
 2016-10-11 22:57:58 2017-11-02 13:04:39 Bribe payers index (Transparency International - GCB (2013)) (split) 2986 Data for the Bribe Payers Index is drawn from the Bribe Payers Survey. The survey asked business executives: "In your principal lines of business in this country, do you have business relationships (for example as a supplier, client, partner or competitor) with companies whose headquarters are located in any of the following countries?". Respondents were presented a list of 28 countries. For each instance where the respondent answered that they do have business relationships with companies headquartered in a country, the respondents were then asked: "How often do firms headquartered in (country name) engage in bribery in this country?" Answers were given on a 5-point scale where 1 corresponded to ‘never’ and 5 to ‘always’. This was then converted into a 10-point scale system, where 10 corresponds to ‘never’ and 0 to ‘always’. Since the index reflects views on foreign bribery, assessments of companies from the respondents’ own countries were excluded. http://www.transparency.org/research/bpi/overview Transparency International – Bribe Payers Index  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");