sources

Data license: CC-BY

1 row where datasetId = 2781 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "https://espacioinvestiga.org/home-hihd/?lang=en",
    "retrievedDate": "2nd May 2018",
    "additionalInfo": "The Historical Index of Human Development (HIHD) is a composite statistic (index) that measures key dimensions of human development:\n- life expectancy\n- literacy\n- educational enrolment\n\u2013 and per capita gross domestic product (GDP)\n\nThis particular metric presents the assessed HDI normalised without the variable of per capita gross domestic product (GDP), so includes life expectancy, literacy and schooling rates only.\n\nSources on the following dimensions can be found at: https://espacioinvestiga.org/home-hihd/about-indices-hihd/hihd-sources-and-procedures/?lang=en",
    "dataPublishedBy": "Leandro Prados de la Escosura (HIHD)",
    "dataPublisherSource": null
}

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");