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 = 944 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
6803 World Bank's, World Bank Analytical Classifications (2017) 
{
    "link": "https://datahelpdesk.worldbank.org/knowledgebase/articles/906519-world-bank-country-and-lending-groups",
    "retrievedDate": "07/09/2017",
    "additionalInfo": "\u2013The Atlas methodology is used to reduce the impact of exchange rate fluctuations in the cross-country comparison of national incomes. The Atlas conversion factor for any year is the average of a country's exchange rate for that year and its exchange rates for the two preceding years, adjusted for the differences between the rate of inflation in the country and that in Japan, the United Kingdom, the United States, and the Euro area. A country's inflation rate is measured by the change in its GDP deflator. The inflation rate for the above countries, representing international inflation, is measured by the changes in the SDR deflator. (Special drawing rights, or SDRs, are the IMF's unit of account.)\n\u2013 Data on Serbia & Montenegro, prior to 2006 have been allocated to the sovereign states of Serbia, and Montenegro, respectively. Similarly, the 15 post-Soviet States have been allocated the USSR's classification for 1990. This includes Moldova, Estonia, Latvia, Lithuania, Kazakhstan, Kyrgyzstan, Tajikistan, Turkmenistan, Uzbekistan, Russia, Armenia, Azerbaijan, Georgia, Ukraine, and Belarus.",
    "dataPublishedBy": "World Bank WDI",
    "dataPublisherSource": "The main source is gross national income (GNI) estimates obtained from economists in World Bank country units; and the size of the population is estimated by World Bank demographers from a variety of sources, including the UN's biennial 'World Population Prospects'."
}
 2017-09-30 10:46:40 2023-04-21 11:01:29 Income Classification - World Bank (2017) 944 –The Atlas methodology is used to reduce the impact of exchange rate fluctuations in the cross-country comparison of national incomes. The Atlas conversion factor for any year is the average of a country's exchange rate for that year and its exchange rates for the two preceding years, adjusted for the differences between the rate of inflation in the country and that in Japan, the United Kingdom, the United States, and the Euro area. A country's inflation rate is measured by the change in its GDP deflator. The inflation rate for the above countries, representing international inflation, is measured by the changes in the SDR deflator. (Special drawing rights, or SDRs, are the IMF's unit of account.) – Data on Serbia & Montenegro, prior to 2006 have been allocated to the sovereign states of Serbia, and Montenegro, respectively. Similarly, the 15 post-Soviet States have been allocated the USSR's classification for 1990. This includes Moldova, Estonia, Latvia, Lithuania, Kazakhstan, Kyrgyzstan, Tajikistan, Turkmenistan, Uzbekistan, Russia, Armenia, Azerbaijan, Georgia, Ukraine, and Belarus. https://datahelpdesk.worldbank.org/knowledgebase/articles/906519-world-bank-country-and-lending-groups World Bank WDI

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");