owid: sources: 1 row where datasetId = 2614 sorted by id descending

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 = 2614 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
14835	OECD - Prices and Purchasing Power Parities - Purchasing Power Parities for GDP and related indicators	{ "link": "https://stats.oecd.org/Index.aspx?DataSetCode=PPPGDP", "retrievedDate": "16-March-18", "additionalInfo": "Contact person/organisation\[email protected]\nSource metadata\nThis dataset contains Purchasing Power Parities (PPPs) for all OECD countries. PPPs are the rates of currency conversion that eliminate the differences in price levels between countries. Per capita volume indices based on PPP converted data reflect only differences in the volume of goods and services produced. Comparative price levels are defined as the ratios of PPPs to exchange rates. They provide measures of the differences in price levels between countries. The PPPs are given in national currency units per US dollar. The price levels and volume indices derived using these PPPs have been rebased on the OECD average.\nPeriodicity\nAnnual\nDate last updated\nFebruary 6, 2018\nLink to Release calendar\nUpdated data are available at the beginning of each month.\nClick here for release dates\nhttp://www.oecd.org/std/prices-ppp/oecdcomparativepricelevelsandthegdppppsandderivedindices-timetable.htm\nOther coverage\nFor more information, please refer to Frequently Asked Questions on PPPs:\nFAQs\nhttp://www.oecd.org/std/prices-ppp/purchasingpowerparities-frequentlyaskedquestionsfaqs.htm\nRecommended uses and limitations\nPer capita volume indices should not be used to rank countries as PPPs are statistical constructs rather than precise measures. Minor differences between countries should be interpreted with caution.\n", "dataPublishedBy": "OECD.Stat", "dataPublisherSource": null }	2018-03-16 17:17:36	2018-03-16 17:17:36	Prices and Purchasing Power Parities - Purchasing Power Parities for GDP and related indicators 2614	Contact person/organisation [email protected] Source metadata This dataset contains Purchasing Power Parities (PPPs) for all OECD countries. PPPs are the rates of currency conversion that eliminate the differences in price levels between countries. Per capita volume indices based on PPP converted data reflect only differences in the volume of goods and services produced. Comparative price levels are defined as the ratios of PPPs to exchange rates. They provide measures of the differences in price levels between countries. The PPPs are given in national currency units per US dollar. The price levels and volume indices derived using these PPPs have been rebased on the OECD average. Periodicity Annual Date last updated February 6, 2018 Link to Release calendar Updated data are available at the beginning of each month. Click here for release dates http://www.oecd.org/std/prices-ppp/oecdcomparativepricelevelsandthegdppppsandderivedindices-timetable.htm Other coverage For more information, please refer to Frequently Asked Questions on PPPs: FAQs http://www.oecd.org/std/prices-ppp/purchasingpowerparities-frequentlyaskedquestionsfaqs.htm Recommended uses and limitations Per capita volume indices should not be used to rank countries as PPPs are statistical constructs rather than precise measures. Minor differences between countries should be interpreted with caution.	https://stats.oecd.org/Index.aspx?DataSetCode=PPPGDP	OECD.Stat

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