tags_variables_topic_tags
Data license: CC-BY
8 rows where tagId = 16
This data as json, CSV (advanced)
Link | tagId | variableId | displayOrder |
---|---|---|---|
16,931754 | Smoking 16 | Annual sales of manufactured cigarettes 931754 | 0 |
16,931755 | Smoking 16 | Annual sales of hand-rolled cigarettes 931755 | 0 |
16,931756 | Smoking 16 | Manufactured cigarettes sold per adult per day 931756 | 0 |
16,931757 | Smoking 16 | Hand-rolled cigarettes sold per adult per day 931757 | 0 |
16,931758 | Smoking 16 | Total annual sales of cigarettes 931758 | 0 |
16,931759 | Smoking 16 | Total cigarettes sold per adult per day 931759 | 0 |
16,931760 | Smoking 16 | Sales of all tobacco products 931760 | 0 |
16,931761 | Smoking 16 | Sales of all tobacco products per adult per day 931761 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "tags_variables_topic_tags" ( "tagId" INTEGER NOT NULL , "variableId" INTEGER NOT NULL , "displayOrder" SMALLINT NOT NULL DEFAULT '0' , PRIMARY KEY ("tagId", "variableId"), FOREIGN KEY("tagId") REFERENCES "tags" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("variableId") REFERENCES "variables" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION );