posts_gdocs_variables_faqs

Data license: CC-BY

2 rows where variableId = 577009

✎ View and edit SQL

This data as json, CSV (advanced)

Link gdocId variableId fragmentId displayOrder
1gGburArxglFdHXeTLotFW4TOOLoeRq5XW6UfAdKtaAw,life-satisfaction-measurement,577009 Data Pages FAQs 1gGburArxglFdHXeTLotFW4TOOLoeRq5XW6UfAdKtaAw Cantril ladder score 577009 life-satisfaction-measurement 0
1gGburArxglFdHXeTLotFW4TOOLoeRq5XW6UfAdKtaAw,life-satisfaction-vs-happiness,577009 Data Pages FAQs 1gGburArxglFdHXeTLotFW4TOOLoeRq5XW6UfAdKtaAw Cantril ladder score 577009 life-satisfaction-vs-happiness 1

Advanced export

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

CSV options: 

CREATE TABLE "posts_gdocs_variables_faqs" (
	"gdocId" VARCHAR(255) NOT NULL  ,
	"variableId" INTEGER NOT NULL  ,
	"fragmentId" VARCHAR(255) NOT NULL  ,
	"displayOrder" SMALLINT NOT NULL DEFAULT '0' ,
	PRIMARY KEY ("gdocId", "fragmentId", "variableId"),
	FOREIGN KEY("gdocId") REFERENCES "posts_gdocs" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION,
	FOREIGN KEY("variableId") REFERENCES "variables" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION
);