sources
Data license: CC-BY
2 rows where datasetId = 6409 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
30265 | United Nations, Department of Economic and Social Affairs, Population Division (2022) | { "link": "https://population.un.org/wpp/Download/", "retrievedDate": "2022-09-09", "additionalInfo": "\nWorld Population Prospects 2022 is the 27th edition of the official estimates and projections of the global population that have been published by the United Nations since 1951. The estimates are based on all available sources of data on population size and levels of fertility, mortality and international migration for 237 countries or areas. More details at https://population.un.org/wpp/Publications/.", "dataPublishedBy": "United Nations, Department of Economic and Social Affairs, Population Division (2022)" } |
2024-03-15 18:54:39 | 2024-07-08 17:40:35 | World Population Prospects 6409 | World Population Prospects 2022 is the 27th edition of the official estimates and projections of the global population that have been published by the United Nations since 1951. The estimates are based on all available sources of data on population size and levels of fertility, mortality and international migration for 237 countries or areas. More details at https://population.un.org/wpp/Publications/. | https://population.un.org/wpp/Download/ | United Nations, Department of Economic and Social Affairs, Population Division (2022) |
30264 | United Nations, Department of Economic and Social Affairs, Population Division (2022) | { "link": "https://population.un.org/wpp/Download/", "retrievedDate": "2022-09-09", "additionalInfo": "World Population Prospects 2022 is the 27th edition of the official estimates and projections of the global population that have been published by the United Nations since 1951. The estimates are based on all available sources of data on population size and levels of fertility, mortality and international migration for 237 countries or areas. More details at https://population.un.org/wpp/Publications/.", "dataPublishedBy": "United Nations, Department of Economic and Social Affairs, Population Division (2022)" } |
2024-03-15 18:54:39 | 2024-07-08 17:40:35 | World Population Prospects 6409 | World Population Prospects 2022 is the 27th edition of the official estimates and projections of the global population that have been published by the United Nations since 1951. The estimates are based on all available sources of data on population size and levels of fertility, mortality and international migration for 237 countries or areas. More details at https://population.un.org/wpp/Publications/. | https://population.un.org/wpp/Download/ | United Nations, Department of Economic and Social Affairs, Population Division (2022) |
Advanced export
JSON shape: default, array, newline-delimited, object
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");