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 = 1018 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
6878 World Development Report, Shortfalls in Learning (2018) 
{
    "link": "http://www.worldbank.org/en/publication/wdr2018/brief/world-development-report-2018-data",
    "retrievedDate": "6 November 2017",
    "additionalInfo": "The World Development Report (2018) includes the following information regarding sources: \"WDR 2018 team, using reading and mathematics data for Kenya and Uganda from Uwezo, Annual Assessment Reports, 2015 (www.uwezo.net/); reading and mathematics data for rural India from ASER Centre (2017); reading data for all other countries from U.S. Agency for International Development (USAID), Early Grade Reading Barometer, 2017, accessed May 30, 2017 (www.earlygradereadingbarometer.org/); and mathematics data for all other countries from USAID/RTI Early Grade Mathematics Assessment intervention reports, 2012\u00e2\u20ac\u201c15 (shared.rti.org/sub-topic/early-grade-math-assessment-egma).\"\n\nThe original source notes: \"These data typically pertain to selected regions in the countries and are not necessarily nationally representative. Data for India pertain to rural areas.\"",
    "dataPublishedBy": "World Development Report (2018)",
    "dataPublisherSource": "Early Grade Reading Barometer and other country-specific surveys"
}
 2017-11-06 19:44:00 2017-11-07 15:45:52 Basic reading and maths skills - World Development Report (2018) 1018 The World Development Report (2018) includes the following information regarding sources: "WDR 2018 team, using reading and mathematics data for Kenya and Uganda from Uwezo, Annual Assessment Reports, 2015 (www.uwezo.net/); reading and mathematics data for rural India from ASER Centre (2017); reading data for all other countries from U.S. Agency for International Development (USAID), Early Grade Reading Barometer, 2017, accessed May 30, 2017 (www.earlygradereadingbarometer.org/); and mathematics data for all other countries from USAID/RTI Early Grade Mathematics Assessment intervention reports, 2012–15 (shared.rti.org/sub-topic/early-grade-math-assessment-egma)." The original source notes: "These data typically pertain to selected regions in the countries and are not necessarily nationally representative. Data for India pertain to rural areas." http://www.worldbank.org/en/publication/wdr2018/brief/world-development-report-2018-data World Development Report (2018)

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