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 = 4915 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
17646 Number of people without access to safe water and sanitation (WHO Wash, 2019) 
{
    "link": "https://washdata.org/data",
    "retrievedDate": "7th February 2020",
    "additionalInfo": "Absolute numbers of people without access to safely managed drinking water and sanitation was calculated by Our World in Data based on original data sourced from the WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (JMP) and World Bank's World Development Indicators.\n\nOur World in Data calculated absolute numbers based on original data on the number with access to safely managed drinking water and sanitation, and the total population numbers.\n\n\u2013 Number of people without access to safely managed drinking water = [population \u2013 number of people with access to safe drinking water]\n\u2013 Number of people without access to sanitation = [population \u2013 number of people with access to sanitation]\n\nSafely managed drinking water: \u201cSafely managed drinking water\u201d is defined as an \u201cImproved source located on premises, available when needed, and free from microbiological and priority chemical contamination.\u201d\n\nSafely managed sanitation facilities: \u201cSafely managed sanitation\u201d is defined as the use of an improved sanitation facility which is not shared with other households and where:\n\u2022 excreta is safely disposed in situ or\n\u2022 excreta is transported and treated off-site.",
    "dataPublishedBy": "WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (JMP)"
}
 2020-02-09 16:21:56 2020-02-09 16:21:56 Number of people without access to safe water and sanitation (WHO Wash, 2019) 4915 Absolute numbers of people without access to safely managed drinking water and sanitation was calculated by Our World in Data based on original data sourced from the WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (JMP) and World Bank's World Development Indicators. Our World in Data calculated absolute numbers based on original data on the number with access to safely managed drinking water and sanitation, and the total population numbers. – Number of people without access to safely managed drinking water = [population – number of people with access to safe drinking water] – Number of people without access to sanitation = [population – number of people with access to sanitation] Safely managed drinking water: “Safely managed drinking water” is defined as an “Improved source located on premises, available when needed, and free from microbiological and priority chemical contamination.” Safely managed sanitation facilities: “Safely managed sanitation” is defined as the use of an improved sanitation facility which is not shared with other households and where: • excreta is safely disposed in situ or • excreta is transported and treated off-site. https://washdata.org/data WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (JMP)

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