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 = 2669 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
14893 Gallup (2017) 
{
    "link": "http://news.gallup.com/file/poll/222428/171116MaleFemaleBoss.pdf?g_source=link_newsv9&g_campaign=item_222425&g_medium=copy",
    "retrievedDate": "21/03/2018",
    "additionalInfo": "Question posed to respondents: If you were taking a new job and had your choice of a boss would you prefer to work for a man or a woman?\n\nPossible answers included: prefer man boss, prefer woman boss, no difference, and no opinion. \nWe report the first two responses to this question.\n\nFor more information on the Gallup Poll see the link above. ",
    "dataPublishedBy": "Gallup",
    "dataPublisherSource": "Results are based on telephone interviews conducted November 2-8, 2017 with a random sample of \u20131,028\u2014 adults, ages 18+, living in all 50 U.S. states and the District of Columbia."
}
 2018-03-21 11:09:18 2018-03-21 11:09:18 Gender preference for boss - Gallup (2017) 2669 Question posed to respondents: If you were taking a new job and had your choice of a boss would you prefer to work for a man or a woman? Possible answers included: prefer man boss, prefer woman boss, no difference, and no opinion. We report the first two responses to this question. For more information on the Gallup Poll see the link above. http://news.gallup.com/file/poll/222428/171116MaleFemaleBoss.pdf?g_source=link_newsv9&g_campaign=item_222425&g_medium=copy Gallup

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