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 = 5115 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
17845 Arjun and Bowles (2005) 
{
    "link": "https://www.sciencedirect.com/science/article/abs/pii/S0304387806000125",
    "additionalInfo": "Based on research by Bowles and Jayadev reported in the New York Times on Feb 15, 2014. For their methods and sources see Jayadev Arjun and Samuel Bowles. 2005. \"Guard Labor.\" Journal of Development Economics, 79, pp. 328-48.",
    "dataPublishedBy": "Arjun Jayadev and Samuel Bowles. 2006. \u2018Guard Labor\u2019. Journal of Development Economics 79 (2): pp.  328\u201348."
}
 2020-07-17 10:17:31 2020-07-17 10:17:31 Figure_19.30c 5115 Based on research by Bowles and Jayadev reported in the New York Times on Feb 15, 2014. For their methods and sources see Jayadev Arjun and Samuel Bowles. 2005. "Guard Labor." Journal of Development Economics, 79, pp. 328-48. https://www.sciencedirect.com/science/article/abs/pii/S0304387806000125 Arjun Jayadev and Samuel Bowles. 2006. ‘Guard Labor’. Journal of Development Economics 79 (2): pp. 328–48.

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