sources
Data license: CC-BY
1 row where datasetId = 2515 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 |
---|---|---|---|---|---|---|---|---|
14733 | Global meat projections to 2050 - FAO | { "link": null, "retrievedDate": null, "additionalInfo": "Data extending from 1961-2013 is based on the UN Food and Agriculture (FAO) Statistics database: http://www.fao.org/faostat/en/\n\nProjections to 2050 are based on UN FAO projections under business-as-usual population, and forecasted economic growth models. This data is sourced from:\nAlexandratos, N., & Bruinsma, J. (2012). World agriculture towards 2030/2050: the 2012 revision (Vol. 12, No. 3). FAO, Rome: ESA Working paper. Available at: http://www.fao.org/docrep/016/ap106e/ap106e.pdf", "dataPublishedBy": "UN Food and Agriculture Organization (FAO)", "dataPublisherSource": null } |
2018-03-14 10:38:38 | 2018-03-14 14:12:40 | Global meat projections to 2050 - FAO 2515 | Data extending from 1961-2013 is based on the UN Food and Agriculture (FAO) Statistics database: http://www.fao.org/faostat/en/ Projections to 2050 are based on UN FAO projections under business-as-usual population, and forecasted economic growth models. This data is sourced from: Alexandratos, N., & Bruinsma, J. (2012). World agriculture towards 2030/2050: the 2012 revision (Vol. 12, No. 3). FAO, Rome: ESA Working paper. Available at: http://www.fao.org/docrep/016/ap106e/ap106e.pdf | UN Food and Agriculture Organization (FAO) |
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");