variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

8 rows where datasetId = 6555 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, updatedAt, timespan, shortUnit, display, createdAt (date), updatedAt (date), descriptionKey (array)

id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata grapherConfigAdmin shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license grapherConfigETL type sort dataChecksum metadataChecksum
931761 Sales of all tobacco products per adult per day grams per adult per day   2024-06-11 18:05:09 2024-07-25 23:11:33     1862-2015 International Smoking Statistics 6555   g 
{
    "unit": "grams per adult per day",
    "shortUnit": "g",
    "numDecimalPlaces": 1
}
 0     all_tobacco_products_grams_per_adult_per_day grapher/smoking/2024-05-30/cigarette_sales/cigarette_sales#all_tobacco_products_grams_per_adult_per_day   2 major   Sales of all tobacco products per adult per day       Daily sales of all tobacco products to people aged 15 and over.   
[
    "Data includes cigarettes, cigars and smokeless tobacco, such as chewing tobacco or snuff, which is held in the mouth without chewing.",
    "The time series for Germany includes a population weighted average for West and East Germany cigarette sales for the 1948-1989 period."
]
         float 
[]
 e4a2766d62d81557c24cead284882a20 e9213c03ecf860b0aaad85b4e66bc3b7
931760 Sales of all tobacco products tons   2024-06-11 18:05:09 2024-07-25 23:11:33     1862-2015 International Smoking Statistics 6555   t 
{
    "unit": "tons",
    "shortUnit": "t",
    "numDecimalPlaces": 1
}
 0     all_tobacco_products_tonnes grapher/smoking/2024-05-30/cigarette_sales/cigarette_sales#all_tobacco_products_tonnes   2 major   Sales of all tobacco products           
[
    "Data includes cigarettes, cigars and smokeless tobacco, such as chewing tobacco or snuff, which is held in the mouth without chewing.",
    "The time series for Germany includes the sum of West and East Germany cigarette sales for the 1948-1989 period."
]
         float 
[]
 fe5407adbbde22e2d515eaaf8209bd72 52e08de5412acb1d6ac8552d14e64046
931759 Total cigarettes sold per adult per day cigarettes per adult per day   2024-06-11 18:05:09 2024-07-25 23:11:33     1907-2015 International Smoking Statistics 6555   cigarettes 
{
    "unit": "cigarettes per adult per day",
    "shortUnit": "cigarettes",
    "numDecimalPlaces": 1
}
 0     total_cigarettes_per_adult_per_day grapher/smoking/2024-05-30/cigarette_sales/cigarette_sales#total_cigarettes_per_adult_per_day   2 major   Total cigarette sales per adult per day       Daily sales of manufactured and hand-rolled cigarettes to people aged 15 and over.   
[
    "Total cigarette sales are the sum of manufactured and hand-rolled cigarette sales. Where one or the other is missing, total cigarette sales data is also not available.",
    "The time series for Germany includes a population weighted average for West and East Germany cigarette sales for the 1948-1989 period."
]
         float 
[]
 cb3bc2a5d6f1744079e67dadef9e01f7 b3fb26bdb7dedeeefcbf21aa1a41ff5b
931758 Total annual sales of cigarettes cigarettes   2024-06-11 18:05:09 2024-07-25 23:11:32     1907-2015 International Smoking Statistics 6555   cigarettes 
{
    "unit": "cigarettes",
    "shortUnit": "cigarettes",
    "numDecimalPlaces": 0
}
 0     total_cigarettes grapher/smoking/2024-05-30/cigarette_sales/cigarette_sales#total_cigarettes   2 major   Total cigarette sales           
[
    "Total cigarette sales are the sum of manufactured and hand-rolled cigarette sales. Where one or the other is missing, total cigarette sales data is also not available.",
    "The time series for Germany includes the sum of West and East Germany cigarette sales for the 1948-1989 period."
]
         float 
[]
 b14310c62b0dc0e8172bde41dad0917e 2ae7fa5ebfe054a8d4c214f8592d1ee6
931757 Hand-rolled cigarettes sold per adult per day cigarettes per adult per day   2024-06-11 18:05:09 2024-07-25 23:11:32     1907-2015 International Smoking Statistics 6555   cigarettes 
{
    "unit": "cigarettes per adult per day",
    "shortUnit": "cigarettes",
    "numDecimalPlaces": 1
}
 0     handrolled_cigarettes_per_adult_per_day grapher/smoking/2024-05-30/cigarette_sales/cigarette_sales#handrolled_cigarettes_per_adult_per_day   2 major   Hand-rolled cigarette sales per adult per day       Daily sales of hand-rolled cigarettes to people aged 15 and over.   
[
    "Estimates of hand-rolled cigarette consumption are based on the sales of loose tobacco.",
    "For Latvia, Papyrosi cigarettes are counted instead of loose tobacco/ hand-rolled cigarettes.",
    "The time series for Germany includes a population weighted average for West and East Germany cigarette sales for the 1948-1989 period."
]
         float 
[]
 65c12058f575d9467f12cc2e9749f348 7d7e1ba4d1067250b70dc591574ca81d
931756 Manufactured cigarettes sold per adult per day cigarettes per adult per day   2024-06-11 18:05:09 2024-07-25 23:11:32     1865-2015 International Smoking Statistics 6555   cigarettes 
{
    "unit": "cigarettes per adult per day",
    "shortUnit": "cigarettes",
    "numDecimalPlaces": 1
}
 0     manufactured_cigarettes_per_adult_per_day grapher/smoking/2024-05-30/cigarette_sales/cigarette_sales#manufactured_cigarettes_per_adult_per_day   2 major   Manufactured cigarette sales per adult per day       Daily sales of manufactured cigarettes to people aged 15 and over.   
[
    "The time series for Germany includes a population weighted average for West and East Germany cigarette sales for the 1948-1989 period."
]
         float 
[]
 5100eb7c9f2298f54041291590d8ad26 5198d5b2a88c4876c397e9ff53ab8b40
931755 Annual sales of hand-rolled cigarettes cigarettes   2024-06-11 18:05:09 2024-07-25 23:11:32     1907-2015 International Smoking Statistics 6555   cigarettes 
{
    "unit": "cigarettes",
    "shortUnit": "cigarettes",
    "numDecimalPlaces": 0
}
 0     handrolled_cigarettes grapher/smoking/2024-05-30/cigarette_sales/cigarette_sales#handrolled_cigarettes   2 major   Hand-rolled cigarette sales           
[
    "Estimates of hand-rolled cigarette consumption are based on the sales of loose tobacco.",
    "For Latvia, Papyrosi cigarettes are counted instead of loose tobacco/ hand-rolled cigarettes.",
    "The time series for Germany includes the sum of West and East Germany cigarette sales for the 1948-1989 period."
]
         float 
[]
 3f4e044412dae6b096b9905a2546bc61 32ed07726c0ae5c323934bf57383b0c9
931754 Annual sales of manufactured cigarettes cigarettes   2024-06-11 18:05:09 2024-07-25 23:11:32     1865-2015 International Smoking Statistics 6555   cigarettes 
{
    "unit": "cigarettes",
    "shortUnit": "cigarettes",
    "numDecimalPlaces": 0
}
 0     manufactured_cigarettes grapher/smoking/2024-05-30/cigarette_sales/cigarette_sales#manufactured_cigarettes   2 major   Manufactured cigarette sales           
[
    "The time series for Germany includes the sum of West and East Germany cigarette sales for the 1948-1989 period."
]
         float 
[]
 faf0afb9b8b520204e81efcfd75afc11 1b99dd55d0ab26eb2801ba1d5f7c283c

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "variables" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(750) NULL  ,
	"unit" VARCHAR(255) NOT NULL  ,
	"description" TEXT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"code" VARCHAR(255) NULL  ,
	"coverage" VARCHAR(255) NOT NULL  ,
	"timespan" VARCHAR(255) NOT NULL  ,
	"datasetId" INTEGER NOT NULL  ,
	"sourceId" INTEGER NULL  ,
	"shortUnit" VARCHAR(255) NULL  ,
	"display" TEXT NOT NULL  ,
	"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
	"originalMetadata" TEXT NULL  ,
	"grapherConfigAdmin" TEXT NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"catalogPath" VARCHAR(767) NULL  ,
	"dimensions" TEXT NULL  ,
	"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
	"processingLevel" VARCHAR(30) NULL  ,
	"processingLog" TEXT NULL  ,
	"titlePublic" VARCHAR(512) NULL  ,
	"titleVariant" VARCHAR(255) NULL  ,
	"attributionShort" VARCHAR(512) NULL  ,
	"attribution" TEXT NULL  ,
	"descriptionShort" TEXT NULL  ,
	"descriptionFromProducer" TEXT NULL  ,
	"descriptionKey" TEXT NULL  ,
	"descriptionProcessing" TEXT NULL  ,
	"licenses" TEXT NULL  ,
	"license" TEXT NULL  ,
	"grapherConfigETL" TEXT NULL  ,
	"type" TEXT NULL  ,
	"sort" TEXT NULL  ,
	"dataChecksum" VARCHAR(64) NULL  ,
	"metadataChecksum" VARCHAR(64) NULL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");