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 = 4153 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
16981 Attitudes to Vaccines - Wellcome Trust (2019) 
{
    "link": "https://wellcome.ac.uk/reports/wellcome-global-monitor/2018",
    "retrievedDate": "23/06/19",
    "additionalInfo": "The Wellcome Global Monitor is the world\u2019s largest study into how people around the world think and feel about science and major health challenges. It surveys over 140,000 people from more than 140 countries. \n\nSurvey respondents were asked:\n(1) Do you strongly or somewhat agree, strongly or somewhat disagree or neither agree nor disagree with the following statements? 'Vaccines are important for children to have'.\n\n(2) Do you strongly or somewhat agree, strongly or somewhat disagree or neither agree nor disagree with the following statement? 'Vaccines are safe.'\n\n(3) Do you strongly or somewhat agree, strongly or somewhat disagree or neither agree nor disagree with the following statement? 'Vaccines are effective'.\n\nFor each question we have calculated the \"share of people who agree\" to be the sum of those who \"strongly agree\" and \"somewhat agree\"; and the \"share of people who disagree\" to be the sum of those who \"strongly disagree\" and \"somewhat disagree\".",
    "dataPublishedBy": "Wellcome Trust (2019)"
}
 2019-06-24 11:19:55 2019-06-24 11:19:55 Attitudes to Vaccines - Wellcome Trust (2019) 4153 The Wellcome Global Monitor is the world’s largest study into how people around the world think and feel about science and major health challenges. It surveys over 140,000 people from more than 140 countries. Survey respondents were asked: (1) Do you strongly or somewhat agree, strongly or somewhat disagree or neither agree nor disagree with the following statements? 'Vaccines are important for children to have'. (2) Do you strongly or somewhat agree, strongly or somewhat disagree or neither agree nor disagree with the following statement? 'Vaccines are safe.' (3) Do you strongly or somewhat agree, strongly or somewhat disagree or neither agree nor disagree with the following statement? 'Vaccines are effective'. For each question we have calculated the "share of people who agree" to be the sum of those who "strongly agree" and "somewhat agree"; and the "share of people who disagree" to be the sum of those who "strongly disagree" and "somewhat disagree". https://wellcome.ac.uk/reports/wellcome-global-monitor/2018 Wellcome Trust (2019)

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