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 = 3006 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
610 Lindert_Historical (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": "Lindert, Peter H. The Rise of Social Spending, 1880-1930. Explorations in Economic History, 1994"
}
 2017-05-17 23:40:03 2017-11-02 13:04:39 Social Expenditure %GDP - Lindert_Historical (2004) (split) 3006 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");