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 = 5004 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
17735 Agri-Environmental Indicators: Emissions intensities 
{
    "link": "http://www.fao.org/faostat/en/?#data/",
    "retrievedDate": "13-Feb-2020",
    "additionalInfo": "The Emissions intensities domain under the FAOSTAT section of Agri-Environmental Indicators contains analytical data on the intensity of greenhouse gas (GHG) emissions by commodity. This indicator is defined as greenhouse gas emissions per unit of product. Data are available for a set of agricultural commodities (e.g. rice and other cereals, meat, milk, eggs), by country, with global coverage and relative to the period 1961\u20132017.   Data in the domain Emissions intensities are computed from FAO statistics, disseminated in the Emissions and Production sections of FAOSTAT. The following data categories for each agricultural commodity are available for download: production quantities (in tonnes); emissions (in gigagrams of CO2eq); and emissions intensity (in kg of CO2eq per kg of product.   Data are updated yearly and are available for all individual countries and territories, for standard FAOSTAT regional aggregations, as well as for UNFCCC Annex I and non-Annex I groups.   FAOSTAT agri-environmental indicators aim at facilitating national and regional agri-environmental trend analysis and to support member countries with country-level reference information.  The GHG emissions used in the computation of the FAOSTAT Emissions Intensities indicator are limited to emissions generated within the farm gate. Additional emissions from upstream and downstream production and consumption processes and trade are excluded. Emissions intensities are disseminated for the following items: \"Rice\"; for the aggregate \"Cereals excluding rice\"; \"Meat, cattle\"; \"Meat, goat\"; \"Meat, buffalo\"; \"Meat, sheep\"; \"Meat, pig\"; \"Meat, chicken\"; \"Milk, whole fresh cow\"; \"Milk, whole fresh goat\"; \"Milk, whole fresh sheep\"; \"Meat, whole fresh camel\"; and \"Eggs, hen, in shell\".",
    "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)",
    "dataPublisherSource": "Emission Intensities are estimated at country level and for each year from data in the FAOSTAT domains \"Emissions-Agriculture\"; \u201cProduction/Crops\u201d; \u201cProduction/Livestock primary\u201d; and \"Production/Live animals\u201d. The analysis also applies external parameters, namely the N fertilizers use by crop (FAO, 2002)."
}
 2020-02-14 01:33:18 2020-02-14 01:33:18 Agri-Environmental Indicators: Emissions intensities 5004 The Emissions intensities domain under the FAOSTAT section of Agri-Environmental Indicators contains analytical data on the intensity of greenhouse gas (GHG) emissions by commodity. This indicator is defined as greenhouse gas emissions per unit of product. Data are available for a set of agricultural commodities (e.g. rice and other cereals, meat, milk, eggs), by country, with global coverage and relative to the period 1961–2017. Data in the domain Emissions intensities are computed from FAO statistics, disseminated in the Emissions and Production sections of FAOSTAT. The following data categories for each agricultural commodity are available for download: production quantities (in tonnes); emissions (in gigagrams of CO2eq); and emissions intensity (in kg of CO2eq per kg of product. Data are updated yearly and are available for all individual countries and territories, for standard FAOSTAT regional aggregations, as well as for UNFCCC Annex I and non-Annex I groups. FAOSTAT agri-environmental indicators aim at facilitating national and regional agri-environmental trend analysis and to support member countries with country-level reference information. The GHG emissions used in the computation of the FAOSTAT Emissions Intensities indicator are limited to emissions generated within the farm gate. Additional emissions from upstream and downstream production and consumption processes and trade are excluded. Emissions intensities are disseminated for the following items: "Rice"; for the aggregate "Cereals excluding rice"; "Meat, cattle"; "Meat, goat"; "Meat, buffalo"; "Meat, sheep"; "Meat, pig"; "Meat, chicken"; "Milk, whole fresh cow"; "Milk, whole fresh goat"; "Milk, whole fresh sheep"; "Meat, whole fresh camel"; and "Eggs, hen, in shell". http://www.fao.org/faostat/en/?#data/ Food and Agriculture Organization of the United Nations (FAO) (2020)

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