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 = 529 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
669 Number of people with and without access to improved water sources - World Bank and UN 
{
    "link": null,
    "retrievedDate": null,
    "additionalInfo": "Dataset derived through the combination of percentage electricity access statistics and UN population figures.\r\n\r\nThe absolute number of people with and without access to improved water sources was derived by multiplying the percentage of the global population with access to improved water sources (from World Bank, World Development Indicators) by United Nations figures on global population in any given year.\r\n\r\nAs defined by the World Bank: \"improved drinking water source includes piped water on premises (piped household water connection located inside the user\u2019s dwelling, plot or yard), and other improved drinking water sources (public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, and rainwater collection).\"\r\n\r\nAccess to improved water sources (%) data was derived from World Bank World Development Indicators (WDI). Available at: http://data.worldbank.org/ [accessed 2017-06-12].\r\n\r\nGlobal population figures were sourced from the United Nations Population Prospects Division. Available at: https://esa.un.org/unpd/wpp/Download/Standard/Population/ [accessed 2017-06-12]",
    "dataPublishedBy": "Number of people with and without access to improved water sources - World Bank and UN",
    "dataPublisherSource": null
}
 2017-06-12 13:25:11 2017-11-20 14:49:13 Number of people with and without access to improved water sources - World Bank and UN 529 Dataset derived through the combination of percentage electricity access statistics and UN population figures. The absolute number of people with and without access to improved water sources was derived by multiplying the percentage of the global population with access to improved water sources (from World Bank, World Development Indicators) by United Nations figures on global population in any given year. As defined by the World Bank: "improved drinking water source includes piped water on premises (piped household water connection located inside the user’s dwelling, plot or yard), and other improved drinking water sources (public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, and rainwater collection)." Access to improved water sources (%) data was derived from World Bank World Development Indicators (WDI). Available at: http://data.worldbank.org/ [accessed 2017-06-12]. Global population figures were sourced from the United Nations Population Prospects Division. Available at: https://esa.un.org/unpd/wpp/Download/Standard/Population/ [accessed 2017-06-12]   Number of people with and without access to improved water sources - World Bank and UN

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