sources
Data license: CC-BY
1 row where datasetId = 2752 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 |
---|---|---|---|---|---|---|---|---|
15485 | Hypothetical meat consumption - OWID based on FAO & UN | { "link": null, "retrievedDate": null, "additionalInfo": "This is a hypothetical variable derived by Our World in Data which asks the question: \"what would global meat production have to be if everyone in the world was to consume the average per capita amount of a given country?\" e.g. \"how much meat would we need if everyone in the world consumed the same amount of meat as the average UK citizen?\".\n\nThis was derived by multiplying global population figures from the UN Population Division (2017 Revision) by per capita meat supply of a given, as published by the UN FAO. \n\nSources: \nUN FAO: http://www.fao.org/faostat/en/\n\nUN Population Division (2017 Revision): United Nations, Department of Economic and Social Affairs, Population Division (2017). World Population Prospects: The 2017 Revision, DVD Edition. Available at: https://esa.un.org/unpd/wpp/Download/Standard/Population/", "dataPublishedBy": "Hypothetical meat consumption - OWID based on FAO & UN", "dataPublisherSource": null } |
2018-04-10 20:40:53 | 2018-04-10 20:40:53 | Hypothetical meat consumption - OWID based on FAO & UN 2752 | This is a hypothetical variable derived by Our World in Data which asks the question: "what would global meat production have to be if everyone in the world was to consume the average per capita amount of a given country?" e.g. "how much meat would we need if everyone in the world consumed the same amount of meat as the average UK citizen?". This was derived by multiplying global population figures from the UN Population Division (2017 Revision) by per capita meat supply of a given, as published by the UN FAO. Sources: UN FAO: http://www.fao.org/faostat/en/ UN Population Division (2017 Revision): United Nations, Department of Economic and Social Affairs, Population Division (2017). World Population Prospects: The 2017 Revision, DVD Edition. Available at: https://esa.un.org/unpd/wpp/Download/Standard/Population/ | Hypothetical meat consumption - OWID based on FAO & UN |
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");