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 = 702 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
2862 UN, World Population Prospects (various years) 
{
    "link": null,
    "retrievedDate": null,
    "additionalInfo": "Global population projections are based on historical World Population Prospects Editions published by the United Nations (UN) across a number of periodic publications.\n\nThe following UN Population Prospects have been included:\n\nUnited Nations (1973). World Population Prospects as Assessed in 1968. United Nations, New York.\n\nUnited Nations. World Population Prospects as Assessed in 1973. United Nations, New York.\n\nUnited Nations. World Population Prospects as Assessed in 1980. United Nations, New York.\n\nUnited Nations (1985). World Population Prospects: estimates and projections as assessed in 1982. United Nations, New York.\n\nUnited Nations (1986). World Population Prospects: estimates and projections as assessed in 1984. United Nations, New York.\n\nUnited Nations (1991). World Population Prospects 1990. United Nations, New York.\n\nUnited Nations (1998). World Population Prospects: the 1998 Revision. Volume I: Comprehensive Tables. United Nations, New York.\n\nUnited Nations, Department of Economic and Social Affairs, Population Division (2017). World Population Prospects: The 2017 Revision.\n\nUnited Nations, Department of Economic and Social Affairs, Population Division (2019). World Population Prospects 2019.\n\nUnited Nations, Department of Economic and Social Affairs, Population Division (2022). World Population Prospects 2022.",
    "dataPublishedBy": "UN, World Population Prospects (various years)",
    "dataPublisherSource": "Historical world population projections, census data"
}
 2017-08-26 16:48:38 2023-04-14 14:09:56 Historical World Population Prospects (UN, various years) 702 Global population projections are based on historical World Population Prospects Editions published by the United Nations (UN) across a number of periodic publications. The following UN Population Prospects have been included: United Nations (1973). World Population Prospects as Assessed in 1968. United Nations, New York. United Nations. World Population Prospects as Assessed in 1973. United Nations, New York. United Nations. World Population Prospects as Assessed in 1980. United Nations, New York. United Nations (1985). World Population Prospects: estimates and projections as assessed in 1982. United Nations, New York. United Nations (1986). World Population Prospects: estimates and projections as assessed in 1984. United Nations, New York. United Nations (1991). World Population Prospects 1990. United Nations, New York. United Nations (1998). World Population Prospects: the 1998 Revision. Volume I: Comprehensive Tables. United Nations, New York. United Nations, Department of Economic and Social Affairs, Population Division (2017). World Population Prospects: The 2017 Revision. United Nations, Department of Economic and Social Affairs, Population Division (2019). World Population Prospects 2019. United Nations, Department of Economic and Social Affairs, Population Division (2022). World Population Prospects 2022.   UN, World Population Prospects (various years)

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