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 = 4164 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
16992 Wang and Caminada (2017) 
{
    "link": "https://www.universiteitleiden.nl/en/law/institute-for-tax-law-and-economics/economics/data-sets/leiden-lis-budget-incidence-fiscal-redistribution-dataset-on-income-inequality-for-47-lis-countries---1967-2014",
    "additionalInfo": "Gini data available at roughly five year intervals. Gini averaged for each country over the time period available. Time periods are: 1981-2010 for Australia, 1987-2013 for Austria, 1985-2000 for Belgium, 1971 - 2010 for Canada, 1987 - 2013 for Denmark, 1987 - 2013 for Finland, 1978 - 2010 for France, 1973 - 2013 for Germany, 1986 - 2014 for Italy, 1985 - 2013 for Luxembourg, 1983 - 2013 for Netherlands, 1979 - 2013 for Norway, 1967 - 2005 for Sweden, 1982 - 2013 for Switzerland, 1969 - 2013 for the United Kingdom and 1974 - 2013 for the United States. \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t",
    "dataPublishedBy": "Koen Caminada, Jinxian Wang, Kees Goudswaard & Chen Wang (2017), Income inequality and fiscal redistribution in 47 LIS-countries (1967-2014), LIS Working Paper Series No. 724."
}
 2019-07-10 19:58:45 2019-07-10 19:58:45 TE-19.30a_1 4164 Gini data available at roughly five year intervals. Gini averaged for each country over the time period available. Time periods are: 1981-2010 for Australia, 1987-2013 for Austria, 1985-2000 for Belgium, 1971 - 2010 for Canada, 1987 - 2013 for Denmark, 1987 - 2013 for Finland, 1978 - 2010 for France, 1973 - 2013 for Germany, 1986 - 2014 for Italy, 1985 - 2013 for Luxembourg, 1983 - 2013 for Netherlands, 1979 - 2013 for Norway, 1967 - 2005 for Sweden, 1982 - 2013 for Switzerland, 1969 - 2013 for the United Kingdom and 1974 - 2013 for the United States. https://www.universiteitleiden.nl/en/law/institute-for-tax-law-and-economics/economics/data-sets/leiden-lis-budget-incidence-fiscal-redistribution-dataset-on-income-inequality-for-47-lis-countries---1967-2014 Koen Caminada, Jinxian Wang, Kees Goudswaard & Chen Wang (2017), Income inequality and fiscal redistribution in 47 LIS-countries (1967-2014), LIS Working Paper Series No. 724.

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