owid: sources: 1 row where datasetId = 2465 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 = 2465 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
14668	International Smoking Statistics (2017)	{ "link": "http://www.pnlee.co.uk/ISS.htm", "retrievedDate": "20/02/2018", "additionalInfo": "Total cigarettes include both manufactured and hand-rolled cigarettes. For Latvia, total cigarettes comprise of manufactured cigarettes and Papyrosi cigarettes. \n\nIn some countries the original data reports 0 for a specific year, with otherwise large reported values for the years before and after. In these cases we treat 0 as a mistake and report missing data for that year.\n\nThe 'number of cigarettes smoked per person per day' for both males and females has been averaged across all years in which multiple estimates were provided in the ISS dataset for the United States, to arrive at one estimate for each year.\n\nThe time series for Germany includes West Germany cigarette sales for the 1948-1989 period .", "dataPublishedBy": "Authors Barbara Forey, Jan Hamling, John Hamling, Alison Thornton, Peter Lee", "dataPublisherSource": "National statistics" }	2018-02-21 18:32:39	2018-03-13 15:17:53	Smoking cigarette sales (International Smoking Statistics (2017)) 2465	Total cigarettes include both manufactured and hand-rolled cigarettes. For Latvia, total cigarettes comprise of manufactured cigarettes and Papyrosi cigarettes. In some countries the original data reports 0 for a specific year, with otherwise large reported values for the years before and after. In these cases we treat 0 as a mistake and report missing data for that year. The 'number of cigarettes smoked per person per day' for both males and females has been averaged across all years in which multiple estimates were provided in the ISS dataset for the United States, to arrive at one estimate for each year. The time series for Germany includes West Germany cigarette sales for the 1948-1989 period .	http://www.pnlee.co.uk/ISS.htm	Authors Barbara Forey, Jan Hamling, John Hamling, Alison Thornton, Peter Lee

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