sources

Data license: CC-BY

1 row where datasetId = 438 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "http://www.worldvaluessurvey.org/",
    "retrievedDate": "27/07/2016",
    "additionalInfo": "The data in the World Value Survey comes from surveys conducted in waves. The years in the dataset correspond to the end year in the corresponding wave. For example, observations from surveys in the wave 1981-1984 are dated 1984.\n\nThe dataset includes observations for Egypt. However, we have excluded these observations from our analysis. This is because the survey for Egypt in the wave labeled 2014 is from 2012, which was a year characterized by extreme political instability.",
    "dataPublishedBy": "World Value Survey (Longitudinal Multiple-Wave file, version 2015)",
    "dataPublisherSource": "Household surveys (representative at the national level)"
}

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