sources

Data license: CC-BY

1 row where datasetId = 2861 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "https://esa.un.org/unpd/wpp/Download/Standard/Population/",
    "retrievedDate": null,
    "additionalInfo": "Population data is based on the Medium UN projection (2017 Edition) from 2015-2100. \n\nOur World in Data have derived the change in the projected under-5 population between the year 2015 to 2050 (here, denoted as '2050') and the change between 2050 to 2100 (here, denoted as '2100'). This was calculated simply through the subtraction of 2015 under-5 numbers from projected 2050 figures; and 2050 figures subtracted from 2100 projections.",
    "dataPublishedBy": "OWID based on data from United Nations, Department of Economic and Social Affairs, Population Division (2017). World Population Prospects: The 2017 Revision, DVD Edition.",
    "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");