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 = 3224 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
16728 Government expenditure and learning outcomes (2005-2015) 
{
    "link": "https://datacatalog.worldbank.org/dataset/education-statistics; https://openknowledge.worldbank.org/handle/10986/31280",
    "retrievedDate": "26 February 2019",
    "additionalInfo": "This dataset was compiled to compare the government expenditure per primary student ($PPP) with learning outcomes. Because of the patchy nature of the government expenditure data as obtained from the World Bank EdStats Dataset, the most recent available expenditure data were used while 2006 was used as a cut-off point. \n\nThe measure of learning outcome used is the share of students either achieving or not achieving a minimum proficiency benchmark. Achievement outcomes come from standardized, psychometrically-robust international and regional tests. In order to maximize coverage by country, tests have been harmonized and pooled across subjects (math, reading, science) and levels (primary and secondary education). Higher proficiency benchmarks that represent the missing share of 100% are students that reached intermediate or advanced proficiency levels. See source for details on proficiency benchmarks. ",
    "dataPublishedBy": "OWID (Sophie)",
    "dataPublisherSource": "World Bank Education Statistics; Angrist et al. 2019"
}
 2019-02-26 10:13:22 2019-02-26 10:13:22 Government expenditure and learning outcomes 3224 This dataset was compiled to compare the government expenditure per primary student ($PPP) with learning outcomes. Because of the patchy nature of the government expenditure data as obtained from the World Bank EdStats Dataset, the most recent available expenditure data were used while 2006 was used as a cut-off point. The measure of learning outcome used is the share of students either achieving or not achieving a minimum proficiency benchmark. Achievement outcomes come from standardized, psychometrically-robust international and regional tests. In order to maximize coverage by country, tests have been harmonized and pooled across subjects (math, reading, science) and levels (primary and secondary education). Higher proficiency benchmarks that represent the missing share of 100% are students that reached intermediate or advanced proficiency levels. See source for details on proficiency benchmarks. https://datacatalog.worldbank.org/dataset/education-statistics; https://openknowledge.worldbank.org/handle/10986/31280 OWID (Sophie)

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