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 = 3176 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
16680 Bowles (2012) 
{
    "additionalInfo": "Bars represent ordinary least squares coefficients (value of the estimated coefficient is in parentheses) predicting support for redistribution. The dependent variable is standardised. Independent variables are the respondent's belief in the importance of the factor shown to getting ahead in life. The coefficients are the estimated effects of a one-point increase in the response scale for a given belief on the standard deviations of the support for redistribution.\t\t\t\t\t\t\t\t\t",
    "dataPublishedBy": "Figure 5.3 in Samuel Bowles. 2012. The New Economics of Inequality and Redistribution. Cambridge: Cambridge University Press; Christina Fong, Samuel Bowles, and Herbert Gintis. 2005. \u2018Strong Reciprocity and the Welfare State\u2019. In Handbook of Giving, Reciprocity and Altruism. Edited by Serge-Christophe Kolm and Jean Mercier Ythier. Amsterdam: Elsevier."
}
 2019-01-08 11:17:21 2019-01-08 11:17:21 Figure_19.14 3176 Bars represent ordinary least squares coefficients (value of the estimated coefficient is in parentheses) predicting support for redistribution. The dependent variable is standardised. Independent variables are the respondent's belief in the importance of the factor shown to getting ahead in life. The coefficients are the estimated effects of a one-point increase in the response scale for a given belief on the standard deviations of the support for redistribution.   Figure 5.3 in Samuel Bowles. 2012. The New Economics of Inequality and Redistribution. Cambridge: Cambridge University Press; Christina Fong, Samuel Bowles, and Herbert Gintis. 2005. ‘Strong Reciprocity and the Welfare State’. In Handbook of Giving, Reciprocity and Altruism. Edited by Serge-Christophe Kolm and Jean Mercier Ythier. Amsterdam: Elsevier.

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