sources

Data license: CC-BY

1 row where datasetId = 39 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

{
    "link": "http://www.oeaw.ac.at/vid/dataexplorer/",
    "retrievedDate": "08/10/2015",
    "additionalInfo": "The data on past and projected rates of educational attainment comes from the International Institute for Applied Systems Analysis (IIASA) and can be found here. These projections are constructed using current Global Economic Trends (GET). There are other scenarios available, including a best and worst case.",
    "dataPublishedBy": " IIASA (2015)",
    "dataPublisherSource": "Lutz, Wolfgang, William P. Butz, and Samir (2014) World population and human capital in the twenty-first century. Oxford: Oxford University Press."
}

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");