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 = 5037 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
17768 Prices: Deflators 
{
    "link": "http://www.fao.org/faostat/en/?#data/",
    "retrievedDate": "13-Feb-2020",
    "additionalInfo": "A deflator allows data to be measured over time, in terms of a base period, in order to distinguish between a change in the monetary value due to change in prices, and change in physical output. It is the measure of the price level for some quantity.  Implicit deflators are calculated by dividing an aggregate measured in current prices by the same aggregate measured in constant prices. Implicit deflators are named after the aggregate used. Deflator of gross domestic product, of gross fixed capital formation, of agriculture value-added, and of manufacturing value-addedmeasure price changes in their respective domain. They are used to eliminate inflationary effects from aggregate series.",
    "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)",
    "dataPublisherSource": "The basic source for the dataset is UNSD which receives national accounts data from countries and partner international organizations (OECD, Eurostat and UNECE)."
}
 2020-02-14 02:53:54 2020-02-14 02:53:54 Prices: Deflators 5037 A deflator allows data to be measured over time, in terms of a base period, in order to distinguish between a change in the monetary value due to change in prices, and change in physical output. It is the measure of the price level for some quantity. Implicit deflators are calculated by dividing an aggregate measured in current prices by the same aggregate measured in constant prices. Implicit deflators are named after the aggregate used. Deflator of gross domestic product, of gross fixed capital formation, of agriculture value-added, and of manufacturing value-addedmeasure price changes in their respective domain. They are used to eliminate inflationary effects from aggregate series. 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");