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 = 37 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
13 OECD Programme for International Student Assessment (PISA) (2015) 
{
    "link": "http://www.oecd.org/pisa/home/",
    "retrievedDate": "08/06/2015",
    "additionalInfo": "PISA education test scores (reading, mathematics, and science)\nOECD PISA average variable is the mean average taken over the mathematics, reading and sciences scores to create an overall ranking. Note also that a problem solving test was included in 2003 and also used to calculate the average. Data is missing for US Reading in 2006 as it was disqualified. Method of averaging over different tests is not endorsed by OECD",
    "dataPublishedBy": "OECD (2015)",
    "dataPublisherSource": "OECD, census data"
}
 2015-07-09 18:18:15 2017-11-02 13:04:39 OECD Education: PISA Test Scores - PISA (2015) 37 PISA education test scores (reading, mathematics, and science) OECD PISA average variable is the mean average taken over the mathematics, reading and sciences scores to create an overall ranking. Note also that a problem solving test was included in 2003 and also used to calculate the average. Data is missing for US Reading in 2006 as it was disqualified. Method of averaging over different tests is not endorsed by OECD http://www.oecd.org/pisa/home/ OECD (2015)

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