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 = 5814 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
27100 Inequality Among World Citizens - Bourguignon and Morrisson (2002) 
{
    "link": "http://dx.doi.org/10.1257/00028280260344443",
    "additionalInfo": "This paper investigates the distribution of well-being among world citizens during the last two centuries. The estimates show that inequality in the world distribution of income worsened from the beginning of the 19th century to World War II. After that, it seems to have stabilized or grown more slowly. In the early 19th century, most inequalities were due to differences within countries; later, it was due to differences between countries. Inequality in longevity also increased during the 19th century. Still, it then was reversed in the second half of the 20th century, perhaps mitigating the failure of income inequality to improve in the last decades. (JEL D31, F0, N0, O0)",
    "dataPublishedBy": "Bourguignon and Morrisson (2002)"
}
 2022-10-24 15:00:33 2022-10-24 15:00:33 Inequality Among World Citizens - Bourguignon and Morrisson (2002) 5814 This paper investigates the distribution of well-being among world citizens during the last two centuries. The estimates show that inequality in the world distribution of income worsened from the beginning of the 19th century to World War II. After that, it seems to have stabilized or grown more slowly. In the early 19th century, most inequalities were due to differences within countries; later, it was due to differences between countries. Inequality in longevity also increased during the 19th century. Still, it then was reversed in the second half of the 20th century, perhaps mitigating the failure of income inequality to improve in the last decades. (JEL D31, F0, N0, O0) http://dx.doi.org/10.1257/00028280260344443 Bourguignon and Morrisson (2002)

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