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 = 5008 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
17739 Agri-Environmental Indicators: Livestock Manure 
{
    "link": "http://www.fao.org/faostat/en/?#data/",
    "retrievedDate": "13-Feb-2020",
    "additionalInfo": "Physical Supply and Use accounts for fertilizers, including livestock manure are in the scope of the System of Environmental-Economic Accounting Central Framework (SEEA CF) and were developed in the FAO System of Environmental-Economic Accounting for Agriculture Forestry and Fisheries (SEEA AFF). Fertilizers statistics, including natural fertilizers such as manure or compost, are listed among the relevant agri-environmental statistics in the Framework for the Development of Environmental Statistics 2013 (FDES, 2017).  EUROSTAT disseminates information on trends in storage of manure, application techniques and animal housing as part of its Agri-environmental indicators.",
    "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)",
    "dataPublisherSource": "FAOSTAT Livestock manure estimates are computed based on Activity Data from official statistics in other FAOSTAT domains (Production \\ Live animals \\ asses, buffaloes, camelids (other), camels, cattle, chickens, goats, horses, mules, pigs, sheep, turkeys) as well as Production \\ Livestock Primary \\ Eggs, hen in shell, milk, whole fresh cow) and applying relevant coefficients from the IPCC 2006 guidelines (http://www.ipcc-nggip.iges.or.jp/public/2006gl/vol4.html)."
}
 2020-02-14 01:37:34 2020-02-14 01:37:34 Agri-Environmental Indicators: Livestock Manure 5008 Physical Supply and Use accounts for fertilizers, including livestock manure are in the scope of the System of Environmental-Economic Accounting Central Framework (SEEA CF) and were developed in the FAO System of Environmental-Economic Accounting for Agriculture Forestry and Fisheries (SEEA AFF). Fertilizers statistics, including natural fertilizers such as manure or compost, are listed among the relevant agri-environmental statistics in the Framework for the Development of Environmental Statistics 2013 (FDES, 2017). EUROSTAT disseminates information on trends in storage of manure, application techniques and animal housing as part of its Agri-environmental indicators. 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");