variables
Data license: CC-BY
4 rows where sourceId = 15520 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, createdAt (date), updatedAt (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97480 | Share of non-essential products in total household (World Bank Global Consumption Database) | % | Total household expenditure on alcohol (including beer, wine, and spirits), games of chance, and tobacco as a share of total household consumption. Share of non-essential product consumption = ((Household expenditure on alcohol + games of chance + tobacco) / (total household consumption expenditures)) * 100 The surveys used in the database were conducted between 2000 and 2010. | 2018-05-05 11:17:49 | 2023-06-15 05:05:42 | Consumption shares in selected non-essential products - World Bank Global Consumption Database 2783 | World Bank Global Consumption Database 15520 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97479 | Share of tobacco in total household consumption (World Bank Global Consumption Database) | % | Total household expenditure on tobacco (in $PPP) as a share of total household consumption. Share of tobacco consumption = ((Household expenditure on tobacco)/(total household consumption expenditures)) * 100 Tobacco is defined according to the UN’s ‘Classification of Individual Consumption according to Purpose (COICOP)) as: “This group covers all purchases of tobacco by households, including purchases of tobacco in restaurants, cafés, bars, service stations, etc. It includes cigarettes; cigarette tobacco and cigarette papers; cigars, pipe tobacco, chewing tobacco or snuff. Excludes: other smokers' articles” The surveys used in the database were conducted between 2000 and 2010. | 2018-05-04 16:24:10 | 2023-06-15 05:05:42 | Consumption shares in selected non-essential products - World Bank Global Consumption Database 2783 | World Bank Global Consumption Database 15520 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97478 | Share of games of chance in total household consumption (World Bank Global Consumption Database) | % | Total household expenditure on games of chance (in $PPP) as a share of total household consumption. Share of games of chance consumption = ((Household expenditure on games of chance)/(total household consumption expenditures)) * 100 Games of chance are defined according to the UN’s ‘Classification of Individual Consumption according to Purpose (COICOP)) as: “Service charges for lotteries, bookmakers, totalizators, casinos and other gambling establishments, gaming machines, bingo halls, scratch cards, sweepstakes, etc. (Service charge is defined as the difference between the amounts paid for lottery tickets or placed in bets and the amounts paid out to winners.)” The surveys used in the database were conducted between 2000 and 2010. | 2018-05-04 16:24:10 | 2023-06-15 05:05:42 | Consumption shares in selected non-essential products - World Bank Global Consumption Database 2783 | World Bank Global Consumption Database 15520 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97477 | Share of alcohol in total household consumption (World Bank Global Consumption Database) | % | Total household expenditure spent on beer, wine, and spirits (in $PPP) as a share of total household consumption. Share of alcohol consumption = ((Household expenditure on beer+wine+spirits)/(total household consumption expenditures)) * 100 Alcohol is defined according to the UN’s ‘Classification of Individual Consumption according to Purpose (COICOP)) as: “[...] Alcoholic beverages [...] are those purchased for consumption at home. The group excludes alcoholic beverages sold for immediate consumption away from the home by hotels, restaurants, cafés, bars, kiosks, street vendors, automatic vending machines, etc. (11.1.1). The beverages classified here include low or non-alcoholic beverages which are generally alcoholic such as non-alcoholic beer.” The surveys used in the database were conducted between 2000 and 2010. | 2018-05-04 16:24:09 | 2023-06-15 05:05:42 | Consumption shares in selected non-essential products - World Bank Global Consumption Database 2783 | World Bank Global Consumption Database 15520 | {} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");