sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 3078 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
16213 Human Capital Index (World Bank, 2018) 
{
    "link": "http://www.worldbank.org/en/publication/human-capital",
    "retrievedDate": "12th October 2018",
    "additionalInfo": "The Human Capital Index (HCI) combines indicators of health and education into a measure of the human capital that a child born today can expect to obtain by her 18th birthday, given the risks of poor education and health that prevail in the country where she lives. The HCI is measured in units of productivity relative to a benchmark of complete education and full health, and ranges from 0 to 1. A value of x on the HCI indicates that a child born today can expect to be only x x100 percent as productive as a future worker as she would be if she enjoyed complete education and full health. \n\nRanging between 0 and 1, the index takes the value 1 only if a child born today can expect to achieve full\nhealth (defined as no stunting and survival up to at least age 60) and complete her education potential\n(defined as 14 years of high-quality school by age 18). \n\nHCI is calculated based on the metrics of probability of survival to age 5, expected years of school, harmonized test scores, learning-adjusted years of schooling, stunting and adult survival rates.",
    "dataPublishedBy": "The World Bank"
}
 2018-10-12 14:27:39 2018-10-12 14:27:39 Human Capital Index (World Bank, 2018) 3078 The Human Capital Index (HCI) combines indicators of health and education into a measure of the human capital that a child born today can expect to obtain by her 18th birthday, given the risks of poor education and health that prevail in the country where she lives. The HCI is measured in units of productivity relative to a benchmark of complete education and full health, and ranges from 0 to 1. A value of x on the HCI indicates that a child born today can expect to be only x x100 percent as productive as a future worker as she would be if she enjoyed complete education and full health. Ranging between 0 and 1, the index takes the value 1 only if a child born today can expect to achieve full health (defined as no stunting and survival up to at least age 60) and complete her education potential (defined as 14 years of high-quality school by age 18). HCI is calculated based on the metrics of probability of survival to age 5, expected years of school, harmonized test scores, learning-adjusted years of schooling, stunting and adult survival rates. http://www.worldbank.org/en/publication/human-capital The World Bank

Advanced export

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

CSV options: 

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