sources

Data license: CC-BY

1 row where datasetId = 5521 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

{
    "additionalInfo": "Stunting measures the number of children under age 5 whose height for age is more than two standard deviations below the median for the international reference population.\n\nThis was calculated by Our World in Data based on the prevalence of stunting and estimates of the total population under five years of age.\n\n\u2013 Source for stunting prevalence: UNICEF/WHO via the World Bank (https://databank.worldbank.org/source/world-development-indicators)\n\n\u2013 Source for under-five population: UN World Population Prospects (https://population.un.org/wpp/)\n\nInput data and script for this dataset can be found on GitHub here: https://github.com/owid/notebooks/tree/main/HannahRitchie/number-stunted",
    "dataPublishedBy": "Calculated by Our World in Data based on UNICEF and WHO; and UN World Population Prospects"
}

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