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 = 3008 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
612 Lindert_OECD_New (2004) 
{
    "link": "http://www.worldcat.org/title/growing-public-social-spending-and-economic-growth-since-the-eighteenth-century/oclc/799512151&referer=brief_results",
    "retrievedDate": "01/04/2017",
    "additionalInfo": "Lindert (2004) makes a distinction between social transfers and total social expenditure. He defines total social expenditure as social transfers plus public expenditure on education. However, the OECD Social Expenditure Database (SOCX) does not include expenditure on education.\n\nAccording to Lindert (2004), total social transfers correspond to basic assistance to poor families [alias \u201cpoor relief\u201d (before 1930), \u201cfamily assistance,\u201d \u201cwelfare\u201d (in America), or \u201csupplemental income\u201d], unemployment compensation, (alias \u201cthe dole\u201d), public non-contributory pensions (in which the funds come from persons other than the recipient and his or her employer), public health expenditures, and housing subsidies.",
    "dataPublishedBy": "Lindert, Peter H., Growing Public: Social Spending and Economic Growth since the Eighteenth Century. Vol. 1 \u2013 The Story, Cambridge University Press, 2004.",
    "dataPublisherSource": "OECD (1999), \"Social Expenditure Database 1980-1996\", Paris: OECD."
}
 2017-05-17 23:48:14 2017-11-02 13:04:39 Social Expenditure %GDP - Lindert_OECD_New (2004) (split) 3008 Lindert (2004) makes a distinction between social transfers and total social expenditure. He defines total social expenditure as social transfers plus public expenditure on education. However, the OECD Social Expenditure Database (SOCX) does not include expenditure on education. According to Lindert (2004), total social transfers correspond to basic assistance to poor families [alias “poor relief” (before 1930), “family assistance,” “welfare” (in America), or “supplemental income”], unemployment compensation, (alias “the dole”), public non-contributory pensions (in which the funds come from persons other than the recipient and his or her employer), public health expenditures, and housing subsidies. http://www.worldcat.org/title/growing-public-social-spending-and-economic-growth-since-the-eighteenth-century/oclc/799512151&referer=brief_results Lindert, Peter H., Growing Public: Social Spending and Economic Growth since the Eighteenth Century. Vol. 1 – The Story, Cambridge University Press, 2004.

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