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 = 2965 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
15683 Prevalence of undernourishment since 2000 (FAOstats, 2018) 
{
    "link": "http://www.fao.org/faostat/en/#data/FS",
    "retrievedDate": "20th September 2018",
    "additionalInfo": "Estimated prevalence and total number of undernourished individuals as reported by the UN Food and Agriculture Organization (FAO).\n\nData is based on its latest statistics on FAOstats (http://www.fao.org/faostat/en/#data/FS). This data extends from the year 2000 through to 2016 at national levels, and 2017 estimates by region and at the global level.\n\nFigures at the national level are reported as 3-year averages; here we have allocated these figures to the mid-year. For example, the UN FAO reports national data for \"2014-2016\" which we allocate to the year 2015.\n\nSome data, particularly for high-income countries, is not reported by the UN FAO. This is often the case for countries where the prevalence of undernourishment is less than 2.5% of the total population.\n\nThe categories of Extreme Fragility and Fragile have been added as a variable based on the country groupings defined in the OECD's States of Fragility (2018) Report.",
    "dataPublishedBy": "Food and Agriculture Organization (FAO) of the United Nations",
    "dataPublisherSource": null
}
 2018-09-20 13:09:36 2018-09-20 13:09:36 Prevalence of undernourishment since 2000 (FAOstats, 2018) 2965 Estimated prevalence and total number of undernourished individuals as reported by the UN Food and Agriculture Organization (FAO). Data is based on its latest statistics on FAOstats (http://www.fao.org/faostat/en/#data/FS). This data extends from the year 2000 through to 2016 at national levels, and 2017 estimates by region and at the global level. Figures at the national level are reported as 3-year averages; here we have allocated these figures to the mid-year. For example, the UN FAO reports national data for "2014-2016" which we allocate to the year 2015. Some data, particularly for high-income countries, is not reported by the UN FAO. This is often the case for countries where the prevalence of undernourishment is less than 2.5% of the total population. The categories of Extreme Fragility and Fragile have been added as a variable based on the country groupings defined in the OECD's States of Fragility (2018) Report. http://www.fao.org/faostat/en/#data/FS Food and Agriculture Organization (FAO) of the United Nations

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