sources
Data license: CC-BY
1 row where datasetId = 5695 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 |
---|---|---|---|---|---|---|---|---|
26718 | Food and Agriculture Organization of the United Nations | { "link": "http://www.fao.org/faostat/en/#data", "retrievedDate": "2022-05-17", "additionalInfo": "The food and agricultural trade dataset is collected, processed and disseminated by FAO according to the standard International Merchandise Trade Statistics (IMTS) Methodology. The data is mainly provided by UNSD, Eurostat, and other national authorities as needed. This source data is checked for outliers, trade partner data is used for non-reporting countries or missing cells, and data on food aid is added to take into account total cross-border trade flows. The trade database includes the following variables: export quantity, export value, import quantity, and import value. The trade database includes all food and agricultural products imported/exported annually by all the countries in the world.", "dataPublishedBy": "Food and Agriculture Organization of the United Nations", "dataPublisherSource": null } |
2022-08-23 17:41:54 | 2022-08-24 13:57:41 | Trade: Crops and livestock products (FAO, 2022-05-17) 5695 | The food and agricultural trade dataset is collected, processed and disseminated by FAO according to the standard International Merchandise Trade Statistics (IMTS) Methodology. The data is mainly provided by UNSD, Eurostat, and other national authorities as needed. This source data is checked for outliers, trade partner data is used for non-reporting countries or missing cells, and data on food aid is added to take into account total cross-border trade flows. The trade database includes the following variables: export quantity, export value, import quantity, and import value. The trade database includes all food and agricultural products imported/exported annually by all the countries in the world. | http://www.fao.org/faostat/en/#data | Food and Agriculture Organization of the United Nations |
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");