origins_variables

Data license: CC-BY

9 rows where variableId = 953906

✎ View and edit SQL

This data as json, CSV (advanced)

Link originId variableId displayOrder
70,953906 Population 70 Population density 953906 1
71,953906 Systema Globalis 71 Population density 953906 7
339,953906 History Database of the Global Environment 339 Population density 953906 0
526,953906 Land, Inputs and Sustainability: Land Use 526 Population density 953906 8
1037,953906 World Population Prospects 1037 Population density 953906 2
1038,953906 World Population Prospects 1038 Population density 953906 3
1039,953906 World Population Prospects 1039 Population density 953906 4
1040,953906 World Population Prospects 1040 Population density 953906 5
1041,953906 World Population Prospects 1041 Population density 953906 6

Advanced export

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

CSV options: 

CREATE TABLE "origins_variables" (
	"originId" INTEGER NOT NULL  ,
	"variableId" INTEGER NOT NULL  ,
	"displayOrder" SMALLINT NOT NULL DEFAULT '0' ,
	PRIMARY KEY ("originId", "variableId"),
	FOREIGN KEY("originId") REFERENCES "origins" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION,
	FOREIGN KEY("variableId") REFERENCES "variables" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION
);