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 = 4247 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
17075 Wealth as percent national income by wealth type – Piketty (2014) 
{
    "link": "http://piketty.pse.ens.fr/files/capital21c/en/",
    "retrievedDate": "06/11/19",
    "additionalInfo": "National wealth held in different forms, expressed as a percentage of national income at the time.\n\nTaken from Thomas Piketty's book, 'Capital in the 21st Century'. All the data used in the book is made available by Piketty on his website here: http://piketty.pse.ens.fr/files/capital21c/en/",
    "dataPublishedBy": "Piketty, T., & Goldhammer, A. (2014). Capital in the twenty-first century. Cambridge Massachusetts: The Belknap Press of Harvard University Press."
}
 2019-11-06 12:52:47 2019-11-06 12:52:47 Wealth as percent national income by wealth type – Piketty (2014) 4247 National wealth held in different forms, expressed as a percentage of national income at the time. Taken from Thomas Piketty's book, 'Capital in the 21st Century'. All the data used in the book is made available by Piketty on his website here: http://piketty.pse.ens.fr/files/capital21c/en/ http://piketty.pse.ens.fr/files/capital21c/en/ Piketty, T., & Goldhammer, A. (2014). Capital in the twenty-first century. Cambridge Massachusetts: The Belknap Press of Harvard University Press.

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