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 = 4167 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
16995 Public Opinion on Terrorism - World Values Survey (2019) 
{
    "link": "http://www.worldvaluessurvey.org/WVSOnline.jsp",
    "retrievedDate": "16/07/19",
    "additionalInfo": "Respondents were asked, \"to what degree are you worried about the following situations? A terrorist attack\".\n\nThey could answer, \"Very much\", \"A great deal\", \"Not much\", \"Not at all\", \"No answer\". This dataset gives the share of respondents that gave each of the first four answers. \"Worried\" is the sum of \"Very much\", and \"A great deal\". \"Not worried\" is the sum of \"Not much\", and \"Not at all\".\n\nData for 2014 was sampled between 2010 and 2014.",
    "dataPublishedBy": "World Values Survey",
    "dataPublisherSource": "Surveys"
}
 2019-07-16 13:25:06 2019-07-16 13:25:06 Worries about Terrorism - World Values Survey (2019) 4167 Respondents were asked, "to what degree are you worried about the following situations? A terrorist attack". They could answer, "Very much", "A great deal", "Not much", "Not at all", "No answer". This dataset gives the share of respondents that gave each of the first four answers. "Worried" is the sum of "Very much", and "A great deal". "Not worried" is the sum of "Not much", and "Not at all". Data for 2014 was sampled between 2010 and 2014. http://www.worldvaluessurvey.org/WVSOnline.jsp World Values Survey

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