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 = 5038 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
17769 Prices: Exchange rates - Annual 
{
    "link": "http://www.fao.org/faostat/en/?#data/",
    "retrievedDate": "13-Feb-2020",
    "additionalInfo": "Exchange rates are defined as the price of one country\u2019s currency in relation to another, and can be: i) a market rate in which the rate floats and is determined largely by market forces; ii) an official rate, as determined or announced by national authorities (typically the central bank); and iii) the principal, secondary, or tertiary rate, for countries maintaining multiple exchange arrangements. In this domain, exchange rates are provided in terms of Standard Local Currency (SLC) per US dollar, where SLC refers to the currency used in the most recent reference year of the statistical reference period covered. For example, the \"euro\u201d is the SLC for Italy from 1970 to 2016, as it was the currency used by Italy in the 2016 reference year, though the Lire was the actual currency used, or local currency unit (LCU), for 1970 to 1998, while the euro was the LCU for Italy from 1999 to the present.",
    "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)",
    "dataPublisherSource": "The main data sources are UNSD National Accounts Estimates of Analytical Main Aggregates (AMA) for data from 1970 to all but the most recent year (2018). IMF Macroeconomic  Financial Data are predominantly used for year 2018 and for countries for which IMF does not have data or IMF data are not matching UNSD data, UN Operational Rates of Exchange are used instead. The link to the sources are: http://unstats.un.org/unsd/snaama/dnlList.asp, http://data.imf.org/?sk=af1819f1-9b6c-43ec-bee4-b1b55fa54cf7sId=1390030341854, https://treasury.un.org/operationalrates/OperationalRates.php"
}
 2020-02-14 02:54:06 2020-02-14 02:54:06 Prices: Exchange rates - Annual 5038 Exchange rates are defined as the price of one country’s currency in relation to another, and can be: i) a market rate in which the rate floats and is determined largely by market forces; ii) an official rate, as determined or announced by national authorities (typically the central bank); and iii) the principal, secondary, or tertiary rate, for countries maintaining multiple exchange arrangements. In this domain, exchange rates are provided in terms of Standard Local Currency (SLC) per US dollar, where SLC refers to the currency used in the most recent reference year of the statistical reference period covered. For example, the "euro” is the SLC for Italy from 1970 to 2016, as it was the currency used by Italy in the 2016 reference year, though the Lire was the actual currency used, or local currency unit (LCU), for 1970 to 1998, while the euro was the LCU for Italy from 1999 to the present. 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");