sources
Data license: CC-BY
1 row where datasetId = 5057 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 |
---|---|---|---|---|---|---|---|---|
17788 | Trade: Trade Indices | { "link": "http://www.fao.org/faostat/en/?#data/", "retrievedDate": "13-Feb-2020", "additionalInfo": "Unit value of agricultural imports/exports: Unit value of the imported/exported commodity is the amount actually paid for one unit (by quantity unit) of the given commodity when sold for importation/exportation from/to the compiling country; the unit value is calculated by dividing the trade value by the trade quantity. In the FAOSTAT database, the unit value is expressed in US dollars per tonne, US dollars per live animal, or US dollars per 1000 heads in the case of poultry, rabbits, pigeons and other birds.Agricultural import/export quantity/value index: Quantity/value indices represent the changes in the price-weighted sum of quantities of food and agriculture products traded between countries. The weights are the unit value averages of 2004-2006. These indices are calculated using a Laspeyres-type formula. Indices for food products include commodities that are considered edible and contain nutrients, excluding animal feed products and alcoholic beverages. Coffee and tea are also excluded because, although edible, they have practically no nutritional value.Agricultural import/export unit value index: Unit value indices represent the changes in the quantity-weighted unit values of products traded between countries. The weights are the quantity averages of 2004-2006. These indices are calculated using a Laspeyres-type formula.Import/Export Value Base Period Quantity and Import/Export Value Base Period Price are derived from the variables above.The variables listed above are measured for the following two aggregates: Total Agriculture Products and Food excluding Fish.", "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)", "dataPublisherSource": "Data are primarily sourced from official country statistics compiled by UNSD and Eurostat. Other sources include:1. INTERFAIS WFP food aid data base: This data source is used to capture the food aid data, which is sometimes excluded from commercial trade records and is thus not always included in UNSD data.2. National web databases, national and international publications to update the trade data for the non-reporting countries which are missing from COMTRADE." } |
2020-02-14 03:24:19 | 2020-02-14 03:24:19 | Trade: Trade Indices 5057 | Unit value of agricultural imports/exports: Unit value of the imported/exported commodity is the amount actually paid for one unit (by quantity unit) of the given commodity when sold for importation/exportation from/to the compiling country; the unit value is calculated by dividing the trade value by the trade quantity. In the FAOSTAT database, the unit value is expressed in US dollars per tonne, US dollars per live animal, or US dollars per 1000 heads in the case of poultry, rabbits, pigeons and other birds.Agricultural import/export quantity/value index: Quantity/value indices represent the changes in the price-weighted sum of quantities of food and agriculture products traded between countries. The weights are the unit value averages of 2004-2006. These indices are calculated using a Laspeyres-type formula. Indices for food products include commodities that are considered edible and contain nutrients, excluding animal feed products and alcoholic beverages. Coffee and tea are also excluded because, although edible, they have practically no nutritional value.Agricultural import/export unit value index: Unit value indices represent the changes in the quantity-weighted unit values of products traded between countries. The weights are the quantity averages of 2004-2006. These indices are calculated using a Laspeyres-type formula.Import/Export Value Base Period Quantity and Import/Export Value Base Period Price are derived from the variables above.The variables listed above are measured for the following two aggregates: Total Agriculture Products and Food excluding Fish. | 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
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");