sources

Data license: CC-BY

1 row where datasetId = 460 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": null,
    "retrievedDate": null,
    "additionalInfo": "Data is based on the hypothetical scenario where the total global population had the same carbon dioxide production footprint as the average citizen of a given country.\r\n\r\nFigures were derived by multiplying the average per capita CO2 footprint (sourced from CDIAC, referenced below) in 2014, by the UN estimated global population in 2014 of 7,265,786,000.\r\n\r\nReferences:\r\n\r\nCarbon Dioxide Information Analysis Center (CDIAC). Available at: http://cdiac.ornl.gov/CO2_Emission/ (accessed 2017-05-06)\r\n\r\nWorld Population Prospects, the 2015 Revision. United Nations Population Division. Available at: https://esa.un.org/unpd/wpp/ (accessed 2017-05-06)",
    "dataPublishedBy": "Hypothetical global emissions - CDIAC (2014)",
    "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");