tags_variables_topic_tags
Data license: CC-BY
3 rows where tagId = 159
This data as json, CSV (advanced)
Link | tagId | variableId | displayOrder |
---|---|---|---|
159,577009 | Happiness & Life Satisfaction 159 | Cantril ladder score 577009 | 0 |
159,935656 | Happiness & Life Satisfaction 159 | Population 935656 | 0 |
159,935657 | Happiness & Life Satisfaction 159 | Cantril ladder score 935657 | 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 );