origins_variables

Data license: CC-BY

8 rows where variableId = 953900

✎ View and edit SQL

This data as json, CSV (advanced)

Link originId variableId displayOrder
70,953900 Population 70 Source 953900 1
71,953900 Systema Globalis 71 Source 953900 7
339,953900 History Database of the Global Environment 339 Source 953900 0
1037,953900 World Population Prospects 1037 Source 953900 2
1038,953900 World Population Prospects 1038 Source 953900 3
1039,953900 World Population Prospects 1039 Source 953900 4
1040,953900 World Population Prospects 1040 Source 953900 5
1041,953900 World Population Prospects 1041 Source 953900 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
);