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 = 5047 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
17778 Production: Value of Agricultural Production 
{
    "link": "http://www.fao.org/faostat/en/?#data/",
    "retrievedDate": "13-Feb-2020",
    "additionalInfo": "Statistical concepts and definitions Value of gross production has been compiled by multiplying gross production in physical terms by output prices at farm gate. Thus, value of production measures production in monetary terms at the farm gate level. Since intermediate uses within the agricultural sector (seed and feed) have not been subtracted from production data, this value of production aggregate refers to the notion of \"gross production\". Value of gross production is provided in both current and constant terms and is expressed in US dollars and Standard Local Currency (SLC). The current value of production measures value in the prices relating to the period being measured. Thus, it represents the market value of food and agricultural products at the time they were produced. Knowing this figure is helpful in understanding exactly what was happening within a given economy at that point in time. Often, this information can help explain economic trends that emerged in later periods and why they took place. Value of production in constant terms is derived using the average prices of a selected year or years, known as the base period. Constant price series can be used to show how the quantity or volume of products has changed, and are often referred to as volume measures. The ratio of the current and constant price series gives a measure of price movements. US dollar figures for value of gross production are converted from local currencies using official exchange rates as prevailing in the respective years. The SLC of a country is the local currency prevailing in the latest year. Expressing data series in one uniform currency is useful because it avoids the influence of revaluation in local currency, if any, on value of production. Please note that livestock value of production is measured in terms of indigenous meat.",
    "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)",
    "dataPublisherSource": "Value of Agricultural Production is calculated on the basis of the production and price data provided by FAO member countries or estimated/imputed by FAO."
}
 2020-02-14 03:07:08 2020-02-14 03:07:08 Production: Value of Agricultural Production 5047 Statistical concepts and definitions Value of gross production has been compiled by multiplying gross production in physical terms by output prices at farm gate. Thus, value of production measures production in monetary terms at the farm gate level. Since intermediate uses within the agricultural sector (seed and feed) have not been subtracted from production data, this value of production aggregate refers to the notion of "gross production". Value of gross production is provided in both current and constant terms and is expressed in US dollars and Standard Local Currency (SLC). The current value of production measures value in the prices relating to the period being measured. Thus, it represents the market value of food and agricultural products at the time they were produced. Knowing this figure is helpful in understanding exactly what was happening within a given economy at that point in time. Often, this information can help explain economic trends that emerged in later periods and why they took place. Value of production in constant terms is derived using the average prices of a selected year or years, known as the base period. Constant price series can be used to show how the quantity or volume of products has changed, and are often referred to as volume measures. The ratio of the current and constant price series gives a measure of price movements. US dollar figures for value of gross production are converted from local currencies using official exchange rates as prevailing in the respective years. The SLC of a country is the local currency prevailing in the latest year. Expressing data series in one uniform currency is useful because it avoids the influence of revaluation in local currency, if any, on value of production. Please note that livestock value of production is measured in terms of indigenous meat. 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");