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 = 2885 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
15613 Number of countries with minimum urban population threshold (UN;2018) 
{
    "link": "https://esa.un.org/unpd/wup/",
    "retrievedDate": "21st August 2018",
    "additionalInfo": "Data was assessed by Our World in Data based on UN documentation of its Urbanization Prospects (2018). The Urbanization Prospects presents data on the number and share of the population residing in urban areas for each country from 1950 with projections to 2050.\n\nThere is no consistent definition of what constitutes an 'urban area'. This is highly variable across countries. This data presents the number of countries with a given minimum threshold of inhabitants needed for it to be defined an 'urban area'. For many countries, there is no defined threshold based on inhabitants; other metrics such as population density, infrastructure, or even pre-defined cities may be used.\n\nNote that some countries with minimum inhabitant thresholds noted here also include additional qualities (such as population density) to be met.",
    "dataPublishedBy": "United Nations, Department of Economic and Social Affairs, Population Division (2018). World Urbanization Prospects: The 2018 Revision, Online Edition.",
    "dataPublisherSource": "Censuses and national statistics"
}
 2018-08-21 14:04:13 2018-08-21 14:04:13 Number of countries with minimum urban population threshold (UN;2018) 2885 Data was assessed by Our World in Data based on UN documentation of its Urbanization Prospects (2018). The Urbanization Prospects presents data on the number and share of the population residing in urban areas for each country from 1950 with projections to 2050. There is no consistent definition of what constitutes an 'urban area'. This is highly variable across countries. This data presents the number of countries with a given minimum threshold of inhabitants needed for it to be defined an 'urban area'. For many countries, there is no defined threshold based on inhabitants; other metrics such as population density, infrastructure, or even pre-defined cities may be used. Note that some countries with minimum inhabitant thresholds noted here also include additional qualities (such as population density) to be met. https://esa.un.org/unpd/wup/ United Nations, Department of Economic and Social Affairs, Population Division (2018). World Urbanization Prospects: The 2018 Revision, Online Edition.

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