sources

Data license: CC-BY

1 row where datasetId = 5399 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "additionalInfo": "This dataset is collated by Our World in Data based on several data sources, including:\n\nPowering Past Coal Alliance (PPCA): https://www.poweringpastcoal.org/\nBeyond Coal EU: https://beyond-coal.eu/coal-exit-tracker/\nBloomberg Global Coal Countdown: https://bloombergcoalcountdown.com/\nEMBER Climate: https://ember-climate.org/\nNational announcements during the COP26 Climate Summit: https://ukcop26.org/global-coal-to-clean-power-transition-statement/\n\nWhere a concrete phase out date is not defined, we have allocated the final year of the target decade. For example, \"Phase out in the 2040s\" is given a target date of 2049. ",
    "dataPublishedBy": "Powering Past Coal Alliance; Ember Climate; Beyond Coal EU; Bloomberg Coal Countdown and other sources"
}

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