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 = 4130 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
16959 ICTD/UNU-WIDER Government Revenue Dataset, September 2019 
{
    "link": "https://www.wider.unu.edu/project/government-revenue-dataset",
    "retrievedDate": "04/09/2019",
    "additionalInfo": "This data comes from the 'merged' dataset provided by ICTD, after excluding observations flagged as unreliable. Specifically, we excluded the observations where the ICTD indicated concerns about their quality, accuracy or comparability. Details regarding these flags, as well as the dataset more generally, are available Prichard, W. (2016). Reassessing Tax and Development Research: A New Dataset, New Findings, and Lessons for Research. World Development, 80, 48-60.\n\nThe September 2019 release differs from the previous release with the inclusion of new data for 2017. For more details on the Government Revenue Dataset see its <a href=\"https://www.wider.unu.edu/about-grd\">update history</a>. ",
    "dataPublishedBy": "International Centre for Tax and Development / UNU-WIDER",
    "dataPublisherSource": "OECD Revenue Statistics; OECD Latin American Tax Statistics; IMF Government Finance Statistics (GFS); IMF Article IV Staff Reports; CEPALSTAT Revenue Statistics in Latin America."
}
 2019-05-24 20:31:09 2019-05-24 20:31:09 Corporate tax revenue - ICTD UNU-WIDER GRD (2019) 4130 This data comes from the 'merged' dataset provided by ICTD, after excluding observations flagged as unreliable. Specifically, we excluded the observations where the ICTD indicated concerns about their quality, accuracy or comparability. Details regarding these flags, as well as the dataset more generally, are available Prichard, W. (2016). Reassessing Tax and Development Research: A New Dataset, New Findings, and Lessons for Research. World Development, 80, 48-60. The September 2019 release differs from the previous release with the inclusion of new data for 2017. For more details on the Government Revenue Dataset see its <a href="https://www.wider.unu.edu/about-grd">update history</a>. https://www.wider.unu.edu/project/government-revenue-dataset International Centre for Tax and Development / UNU-WIDER

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