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 = 2871 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
15599 Education at a Glance 2017: OECD Indicators (2017) 
{
    "link": "https://www.oecd-ilibrary.org/education/education-at-a-glance-2017_eag-2017-en",
    "retrievedDate": "07/08/2018",
    "additionalInfo": "The year of reference is 2016 for all countries except for: Argentina (2014), Russia (2015), Brazil (2015), Chile (2015), Ireland (2015), Indonesia (2015), South Africa (2015), and Saudi Arabia (2014). \n\nData on Argentina should be used with caution. Data below 30 persons in the denominator are generally considered unreliable. Data below 5 persons in the numerator have been omitted due to confidentiality reasons. For further details on national data sources and reliability thresholds, see Table 3 in <a href=\"http://www.oecd.org/education/skills-beyond-school/EAG2017-Annex-3.pdf\" rel=\"noopener\" target=\"_blank\">Annex 3: Sources, methods and technical notes</a>\n\nNote: for the United Kingdom the OECD specifies \"Data for upper secondary attainment include completion of a sufficient volume and standard of programmes that would be classified individually as completion of intermediate upper secondary programmes (16% of the adults aged 25-64 are in this group).\"",
    "dataPublishedBy": "OECD",
    "dataPublisherSource": "National data sources"
}
 2018-08-07 16:46:31 2018-08-07 16:46:31 Employment rate, ages 25-34, by education - Education at a Glance: OECD Indicators (2017) 2871 The year of reference is 2016 for all countries except for: Argentina (2014), Russia (2015), Brazil (2015), Chile (2015), Ireland (2015), Indonesia (2015), South Africa (2015), and Saudi Arabia (2014). Data on Argentina should be used with caution. Data below 30 persons in the denominator are generally considered unreliable. Data below 5 persons in the numerator have been omitted due to confidentiality reasons. For further details on national data sources and reliability thresholds, see Table 3 in <a href="http://www.oecd.org/education/skills-beyond-school/EAG2017-Annex-3.pdf" rel="noopener" target="_blank">Annex 3: Sources, methods and technical notes</a> Note: for the United Kingdom the OECD specifies "Data for upper secondary attainment include completion of a sufficient volume and standard of programmes that would be classified individually as completion of intermediate upper secondary programmes (16% of the adults aged 25-64 are in this group)." https://www.oecd-ilibrary.org/education/education-at-a-glance-2017_eag-2017-en OECD

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