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 = 5246 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
17975 Top marginal income tax rate - World Inequality Report (2018) 
{
    "link": "https://wir2018.wid.world/methodology.html",
    "retrievedDate": "27/01/2021",
    "additionalInfo": "The World Inequality Report 2018 provides a long-term series of the top marginal income tax rates in rich countries including the US, UK, France, Germany, and Japan from 1900 to 2017.\n\nThe top marginal income tax rates reported include general income tax supplements (such as surtaxes applying to all incomes above a certain level) but excludes all other taxes and social contributions. \n\nFor more detailed information on the construction of the top marginal income tax rate country-by-country, see page 161 of the World Inequality Report 2018 <a href=\"http://wid.world/static/technical-notes-for-figures-and-tables.pdf\">Technical Notes for Figures and Tables</a>.",
    "dataPublishedBy": "Alvaredo, F., Chancel, L., Piketty, T., Saez, E., & Zucman, G. (Eds.). (2018). World Inequality Report 2018. Belknap Press.",
    "dataPublisherSource": "Statistical agencies"
}
 2021-01-27 21:11:41 2021-01-27 21:11:41 Top marginal income tax rate - World Inequality Report (2018) 5246 The World Inequality Report 2018 provides a long-term series of the top marginal income tax rates in rich countries including the US, UK, France, Germany, and Japan from 1900 to 2017. The top marginal income tax rates reported include general income tax supplements (such as surtaxes applying to all incomes above a certain level) but excludes all other taxes and social contributions. For more detailed information on the construction of the top marginal income tax rate country-by-country, see page 161 of the World Inequality Report 2018 <a href="http://wid.world/static/technical-notes-for-figures-and-tables.pdf">Technical Notes for Figures and Tables</a>. https://wir2018.wid.world/methodology.html Alvaredo, F., Chancel, L., Piketty, T., Saez, E., & Zucman, G. (Eds.). (2018). World Inequality Report 2018. Belknap 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");