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 = 963 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
6822 Hanushek and Woessmann (2012) 
{
    "link": null,
    "retrievedDate": "2017, October 10",
    "additionalInfo": "Hanushek, E. A. and Woessmann, L. (2012) \u2013 Do better school lead to more growth? Cognitive skills, economic outcomes, and causation. In Journal of Economic Growth, 17, 267\u2013321. The paper is available on Eric Hanushek's website and at the journal's site. \r\n\r\nThe authors standardized the scores to the PISA test scale but divided the score then by 100. The PISA test scale has a mean of 500 and a standard deviation of 100. \r\n\r\nThe test scores are not given for a particular year, but instead are the average of all standardized math and science test scores of the international student achievement tests in which that country participated. The first of which is from 1964 and the last is from 2003 \u2013 but in general most results come from the later period.",
    "dataPublishedBy": "Hanushek and Woessmann (2012) \u2013 see below for the reference",
    "dataPublisherSource": "The data was constructed by the authors based on several student assessments. See the paper for details."
}
 2017-10-10 21:48:51 2017-12-08 09:13:31 Educational Outcomes – Hanushek and Woessmann (2012) 963 Hanushek, E. A. and Woessmann, L. (2012) – Do better school lead to more growth? Cognitive skills, economic outcomes, and causation. In Journal of Economic Growth, 17, 267–321. The paper is available on Eric Hanushek's website and at the journal's site. The authors standardized the scores to the PISA test scale but divided the score then by 100. The PISA test scale has a mean of 500 and a standard deviation of 100. The test scores are not given for a particular year, but instead are the average of all standardized math and science test scores of the international student achievement tests in which that country participated. The first of which is from 1964 and the last is from 2003 – but in general most results come from the later period.   Hanushek and Woessmann (2012) – see below for the reference

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