sources

Data license: CC-BY

1 row where datasetId = 3269 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": "10th April 2019",
    "additionalInfo": "Sex ratio is here defined as the number of males per 100 females. Data is given at different life stages: one-year olds, 5-year olds, 10-year olds, 15-year olds, 20-year olds and each decade thereafter (to 100 year olds).\n\nThis was calculated by Our World in Data based on male and female population estimates published in the United Nations World Population Prospects (2017 Revision).",
    "dataPublishedBy": "Calculated by Our World in Data based on United Nations, Department of Economic and Social Affairs, Population Division (2017). World Population Prospects: The 2017 Revision, DVD Edition."
}

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