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 = 5049 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
17780 Inputs: Fertilizers by Product 
{
    "link": "http://www.fao.org/faostat/en/?#data/",
    "retrievedDate": "13-Feb-2020",
    "additionalInfo": "The FAOSTAT Fertilizers by Product domain is compliant with the System of Environmental-Economic Accounting for Agriculture Forestry and Fisheries (SEEA AFF) in terms of:  i)\tDefinitions: fertilizers definitions in the SEEA AFF are based on FAO; ii)\tClassifications: it follows the Central Product Classification (CPC); and iii)\tApplicability: data can be used to compile the SEEA AFF Table 4.6, \u201cPhysical flow account for fertilizers\u201d. The domain also aligns with the Framework for the Development of Environmental Statistics (FDES 2013) as natural and chemical fertilizers are included in FDES Component 1, Environmental Conditions and Quality; Component 2, Environmental Resources and their use; and Component 3, Residuals. Amount of fertilizers used for crops is a FDES Core Core set/ Tier 1 statistics. (FDES, Table 4.2, \u201cThe Core Set of Environmental Statistics\u201d).",
    "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)",
    "dataPublisherSource": "Primary data source: FAO Questionnaire on Fertilizers and UN COMTRADE for trade data. These official statistics may be complemented with government data sources such as yearbooks and ministerial data portals. Data gaps may be filled with secondary sources such as country studies from other International organizations. Data are flagged according to the type of data and the source"
}
 2020-02-14 03:20:11 2020-02-14 03:20:11 Inputs: Fertilizers by Product 5049 The FAOSTAT Fertilizers by Product domain is compliant with the System of Environmental-Economic Accounting for Agriculture Forestry and Fisheries (SEEA AFF) in terms of: i) Definitions: fertilizers definitions in the SEEA AFF are based on FAO; ii) Classifications: it follows the Central Product Classification (CPC); and iii) Applicability: data can be used to compile the SEEA AFF Table 4.6, “Physical flow account for fertilizers”. The domain also aligns with the Framework for the Development of Environmental Statistics (FDES 2013) as natural and chemical fertilizers are included in FDES Component 1, Environmental Conditions and Quality; Component 2, Environmental Resources and their use; and Component 3, Residuals. Amount of fertilizers used for crops is a FDES Core Core set/ Tier 1 statistics. (FDES, Table 4.2, “The Core Set of Environmental Statistics”). 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");