sources
Data license: CC-BY
1 row where datasetId = 581 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
2220 | Our World in Data based on UN FAO & historical sources | { "link": null, "retrievedDate": null, "additionalInfo": "This dataset has been constructed by Our World in Data from multiple sources.\n\nAll data from 1961 onwards is sourced from the Food and Agriculture Organization of the United Nations. Available at: https://www.fao.org/faostat/en/#data/FBS\n\nPre-1961 data is available for some countries, based on a range of historical reconstructions.\n\nWe provide further details of all of these sources, and how this dataset is constructed here: https://ourworldindata.org/calorie-supply-sources", "dataPublishedBy": " Our World in Data based on UN FAO & historical sources", "dataPublisherSource": null } |
2017-07-18 17:40:47 | 2017-11-02 13:04:39 | Daily supply of calories per person (OWID based on UN FAO & historical sources) 581 | This dataset has been constructed by Our World in Data from multiple sources. All data from 1961 onwards is sourced from the Food and Agriculture Organization of the United Nations. Available at: https://www.fao.org/faostat/en/#data/FBS Pre-1961 data is available for some countries, based on a range of historical reconstructions. We provide further details of all of these sources, and how this dataset is constructed here: https://ourworldindata.org/calorie-supply-sources | Our World in Data based on UN FAO & historical sources |
Advanced export
JSON shape: default, array, newline-delimited, object
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");