sources

Data license: CC-BY

1 row where datasetId = 2968 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

{
    "link": "http://mpra.ub.uni-muenchen.de/32861/  https://fsolt.org/swiid/  www.lisdatacenter.org",
    "retrievedDate": null,
    "additionalInfo": "The dataset contains middle- and high-income countries from the LIS database according to Wang and Caminada (2011) plus a selection of middle income countries from Solt (2006).\n\nCalculations were conducted by Stefan Thewissen (University of Oxford) in April 2015 using LIS micro data (www.lisdatacenter.org).",
    "dataPublishedBy": "Wang and Caminada (2011), Disentangling Income Inequality and the Redistributive Effect of Social Transfers and Taxes in 36 LIS Countries, LIS Working Paper Series No. 567; Solt, Frederick. 2016. \u201cThe Standardized World Income Inequality Database.\u201d Social Science Quarterly 97. SWIID; LIS micro data",
    "dataPublisherSource": null
}

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