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 = 229 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
195 Incomes across the Distribution Database (Nolan, Thewissen, Roser) in levels (2016) 
{
    "link": "The entire database was published by Brian Nolan, Stefan Thewissen here\u00a0https://ourworldindata.org/incomes-across-the-distribution/",
    "retrievedDate": "26/05/2016",
    "additionalInfo": "The decile cut-offs \u00a0are calculated on the basis of disposable household income. The measure of disposable household income employed in the Luxembourg Income Study is paid employment and self-employment income, capital income, transfer income, which includes social security transfers (work-related insurance transfers, universal benefits, and assistance benefits) and private transfers, minus income taxes and social security contributions. This follows the definitions of the Canberra Group.",
    "dataPublishedBy": "Incomes across the Distribution Database",
    "dataPublisherSource": "Based on microdata from the Luxembourg Income Study Database"
}
 2016-05-26 12:30:30 2017-11-13 17:21:38 Incomes across the Distribution Database (Nolan, Thewissen, Roser) in levels (2016) 229 The decile cut-offs  are calculated on the basis of disposable household income. The measure of disposable household income employed in the Luxembourg Income Study is paid employment and self-employment income, capital income, transfer income, which includes social security transfers (work-related insurance transfers, universal benefits, and assistance benefits) and private transfers, minus income taxes and social security contributions. This follows the definitions of the Canberra Group. The entire database was published by Brian Nolan, Stefan Thewissen here https://ourworldindata.org/incomes-across-the-distribution/ Incomes across the Distribution Database

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