sources

Data license: CC-BY

1 row where datasetId = 2987 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "http://www.enterprisesurveys.org/data/exploretopics/corruption#--1",
    "retrievedDate": "11/10/2016",
    "additionalInfo": "The source notes: \"most surveys were administered using the Enterprise Surveys Global Methodology as outlined in the Methodology page, while some others did not strictly adhere to the Enterprise Surveys Global Methodology. For example, for surveys which do not follow the Global Methodology, the Universe under consideration may have consisted of only manufacturing firms or the questionnaire used may have been different from the standard global questionnaire.\"",
    "dataPublishedBy": "World Bank \u2013 Enterprise Survey",
    "dataPublisherSource": "Firm-level surveys of a representative sample of an economy's private sector"
}

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");