origins_variables
Data license: CC-BY
8 rows where variableId = 953899
This data as json, CSV (advanced)
Link | originId | variableId | displayOrder |
---|---|---|---|
70,953899 | Population 70 | Population 953899 | 1 |
71,953899 | Systema Globalis 71 | Population 953899 | 7 |
339,953899 | History Database of the Global Environment 339 | Population 953899 | 0 |
1037,953899 | World Population Prospects 1037 | Population 953899 | 2 |
1038,953899 | World Population Prospects 1038 | Population 953899 | 3 |
1039,953899 | World Population Prospects 1039 | Population 953899 | 4 |
1040,953899 | World Population Prospects 1040 | Population 953899 | 5 |
1041,953899 | World Population Prospects 1041 | Population 953899 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );