owid: sources: 1 row where datasetId = 2627 sorted by id descending

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 = 2627 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
14848	OECD - Education and Training - Educational expenditure by source and destination	{ "link": "https://stats.oecd.org/Index.aspx?DataSetCode=EDU_FIN_SOURCE", "retrievedDate": "16-March-18", "additionalInfo": "Abstract\nAll entities that provide funds for education, either initially or as final payers, are classified as either governmental (public) sources or non-governmental (private) sources, the sole exception being \"international agencies and other foreign sources\", which are treated as a separate category.\u00a0 There are three types of financial transactions: Direct expenditure on educational institutions; Transfers to students or households and to other private entities; and Households' expenditure on education outside educational institutions.\nData source(s) used\nEducation at a Glance 2017\nEducation_at_a_Glance\nhttp://www.oecd.org/edu/eag.htm\nPeriodicity\nYearly\nDate last updated\n12-09-2017\nContact person\nManon COSTINOT ([email protected]).Giovanni SEMERARO ([email protected])\nOther data characteristics\nSchool academic year\nOther coverage\nGovernment expenditure refers to spending of public authorities at all levels and include three subcategories: central (national) government, regional government (province, state, Land, etc.) and local government (municipality, district, commune,etc.). Expenditure that is not directly related to education (e.g. culture, sports, youth activities, etc.) is not included unless provided as ancillary services. Private expenditure include two subcategories: households (that is to say students and their families) and private entities other than household. In this last category can be isolated expenditure of firms for specified educational activities. Funds from international agencies and other foreign sources include funds funds from international sources paid to governments or paid directly to educational institutions.\nClassification(s) used\nIndicators are computed on various levels of education. These levels refer to the International standard Classification of Educaiton (ISCED) 2011.\nQuality comments\nYou will find more information on the OECD Education GPS.\nGPS_EDUCATION\nhttp://gpseducation.oecd.org/IndicatorExplorer?query=14&indicators=A072A247B033A012C005A013A014A003A004A005A071A073A080A081A082A112A151A110A111A076A079A224A230A141A147C020C006C007A244C002D011D012A030A210A213A216A219A221A222A223C015A235C003A248A249B002B003B004B005B027B028B029B057B058B030B046D019D018D014D015D013D021D022D020D024D025D026D031D032*D033\nOther comments\nWant to know how your country compares with others in education opportunities and outcomes?Search our country profiles and customise your comparisons with the countries of your choice.\nCountry_profile\nhttp://gpseducation.oecd.org/CountryProfile\n", "dataPublishedBy": "OECD.Stat", "dataPublisherSource": null }	2018-03-16 17:18:34	2018-03-16 17:18:34	Education and Training - Educational expenditure by source and destination 2627	Abstract All entities that provide funds for education, either initially or as final payers, are classified as either governmental (public) sources or non-governmental (private) sources, the sole exception being "international agencies and other foreign sources", which are treated as a separate category. There are three types of financial transactions: Direct expenditure on educational institutions; Transfers to students or households and to other private entities; and Households' expenditure on education outside educational institutions. Data source(s) used Education at a Glance 2017 Education_at_a_Glance http://www.oecd.org/edu/eag.htm Periodicity Yearly Date last updated 12-09-2017 Contact person Manon COSTINOT ([email protected]).Giovanni SEMERARO ([email protected]) Other data characteristics School academic year Other coverage Government expenditure refers to spending of public authorities at all levels and include three subcategories: central (national) government, regional government (province, state, Land, etc.) and local government (municipality, district, commune,etc.). Expenditure that is not directly related to education (e.g. culture, sports, youth activities, etc.) is not included unless provided as ancillary services. Private expenditure include two subcategories: households (that is to say students and their families) and private entities other than household. In this last category can be isolated expenditure of firms for specified educational activities. Funds from international agencies and other foreign sources include funds funds from international sources paid to governments or paid directly to educational institutions. Classification(s) used Indicators are computed on various levels of education. These levels refer to the International standard Classification of Educaiton (ISCED) 2011. Quality comments You will find more information on the OECD Education GPS. GPS_EDUCATION http://gpseducation.oecd.org/IndicatorExplorer?query=14&indicators=A072A247B033A012C005A013A…	https://stats.oecd.org/Index.aspx?DataSetCode=EDU_FIN_SOURCE	OECD.Stat

id ▲

name

description

createdAt

updatedAt

datasetId

additionalInfo

link

dataPublishedBy

14848

OECD - Education and Training - Educational expenditure by source and destination

{
    "link": "https://stats.oecd.org/Index.aspx?DataSetCode=EDU_FIN_SOURCE",
    "retrievedDate": "16-March-18",
    "additionalInfo": "Abstract\nAll entities that provide funds for education, either initially or as final payers, are classified as either governmental (public) sources or non-governmental (private) sources, the sole exception being \"international agencies and other foreign sources\", which are treated as a separate category.\u00a0 There are three types of financial transactions: Direct expenditure on educational institutions; Transfers to students or households and to other private entities; and Households' expenditure on education outside educational institutions.\nData source(s) used\nEducation at a Glance 2017\nEducation_at_a_Glance\nhttp://www.oecd.org/edu/eag.htm\nPeriodicity\nYearly\nDate last updated\n12-09-2017\nContact person\nManon COSTINOT ([email protected]).Giovanni SEMERARO ([email protected])\nOther data characteristics\nSchool academic year\nOther coverage\nGovernment expenditure refers to spending of public authorities at all levels and include three subcategories: central (national) government, regional government (province, state, Land, etc.) and local government (municipality, district, commune,etc.). Expenditure that is not directly related to education (e.g. culture, sports, youth activities, etc.) is not included unless provided as ancillary services. Private expenditure include two subcategories: households (that is to say students and their families) and private entities other than household. In this last category can be isolated expenditure of firms for specified educational activities. Funds from international agencies and other foreign sources include funds funds from international sources paid to governments or paid directly to educational institutions.\nClassification(s) used\nIndicators are computed on various levels of education. These levels refer to the International standard Classification of Educaiton (ISCED) 2011.\nQuality comments\nYou will find more information on the OECD Education GPS.\nGPS_EDUCATION\nhttp://gpseducation.oecd.org/IndicatorExplorer?query=14&indicators=A072*A247*B033*A012*C005*A013*A014*A003*A004*A005*A071*A073*A080*A081*A082*A112*A151*A110*A111*A076*A079*A224*A230*A141*A147*C020*C006*C007*A244*C002*D011*D012*A030*A210*A213*A216*A219*A221*A222*A223*C015*A235*C003*A248*A249*B002*B003*B004*B005*B027*B028*B029*B057*B058*B030*B046*D019*D018*D014*D015*D013*D021*D022*D020*D024*D025*D026*D031*D032*D033\nOther comments\nWant to know how your country compares with others in education opportunities and outcomes?Search our country profiles and customise your comparisons with the countries of your choice.\nCountry_profile\nhttp://gpseducation.oecd.org/CountryProfile\n",
    "dataPublishedBy": "OECD.Stat",
    "dataPublisherSource": null
}

2018-03-16 17:18:34

Education and Training - Educational expenditure by source and destination 2627

Abstract All entities that provide funds for education, either initially or as final payers, are classified as either governmental (public) sources or non-governmental (private) sources, the sole exception being "international agencies and other foreign sources", which are treated as a separate category. There are three types of financial transactions: Direct expenditure on educational institutions; Transfers to students or households and to other private entities; and Households' expenditure on education outside educational institutions. Data source(s) used Education at a Glance 2017 Education_at_a_Glance http://www.oecd.org/edu/eag.htm Periodicity Yearly Date last updated 12-09-2017 Contact person Manon COSTINOT ([email protected]).Giovanni SEMERARO ([email protected]) Other data characteristics School academic year Other coverage Government expenditure refers to spending of public authorities at all levels and include three subcategories: central (national) government, regional government (province, state, Land, etc.) and local government (municipality, district, commune,etc.). Expenditure that is not directly related to education (e.g. culture, sports, youth activities, etc.) is not included unless provided as ancillary services. Private expenditure include two subcategories: households (that is to say students and their families) and private entities other than household. In this last category can be isolated expenditure of firms for specified educational activities. Funds from international agencies and other foreign sources include funds funds from international sources paid to governments or paid directly to educational institutions. Classification(s) used Indicators are computed on various levels of education. These levels refer to the International standard Classification of Educaiton (ISCED) 2011. Quality comments You will find more information on the OECD Education GPS. GPS_EDUCATION http://gpseducation.oecd.org/IndicatorExplorer?query=14&indicators=A072*A247*B033*A012*C005*A013*A…

https://stats.oecd.org/Index.aspx?DataSetCode=EDU_FIN_SOURCE

OECD.Stat

Advanced export

JSON shape: default, array, newline-delimited, object

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