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 = 4185 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
17013 Structure of general government expenditures by function - OECD (2017) 
{
    "link": "https://www.oecd-ilibrary.org/governance/government-at-a-glance-2017_gov_glance-2017-en",
    "retrievedDate": "14/10/19",
    "additionalInfo": "This dataset outlines government spending on key areas such as education, health, defence, social protection, or public order and safety. The different functions aggregate expenditures according to pre-defined categories to enable sensible comparisons of national priorities across governments. \n\nData for Iceland are not included in the OECD average due to missing time-series.\nData are not available for Canada, Chile, Mexico, New Zealand and Turkey.\n\nFor more details on methodology and definitions, see the Government at a Glance (2017) report available <a href=\"https://www.oecd-ilibrary.org/docserver/gov_glance-2017-en.pdf?expires=1565822131&id=id&accname=guest&checksum=8D7F6956D86BAF746E61A3468330841F\">here</a>.\n\nFor a comprehensive breakdown of what spending items are included in each function of government see Annex C of the Government at a Glance (2017) report.  ",
    "dataPublishedBy": "OECD, Government at a Glance (2017)",
    "dataPublisherSource": "OECD, Government at a Glance (2017)"
}
 2019-08-14 22:26:09 2019-08-14 22:26:09 Structure of general government expenditures by function - OECD (2017) 4185 This dataset outlines government spending on key areas such as education, health, defence, social protection, or public order and safety. The different functions aggregate expenditures according to pre-defined categories to enable sensible comparisons of national priorities across governments. Data for Iceland are not included in the OECD average due to missing time-series. Data are not available for Canada, Chile, Mexico, New Zealand and Turkey. For more details on methodology and definitions, see the Government at a Glance (2017) report available <a href="https://www.oecd-ilibrary.org/docserver/gov_glance-2017-en.pdf?expires=1565822131&id=id&accname=guest&checksum=8D7F6956D86BAF746E61A3468330841F">here</a>. For a comprehensive breakdown of what spending items are included in each function of government see Annex C of the Government at a Glance (2017) report. https://www.oecd-ilibrary.org/governance/government-at-a-glance-2017_gov_glance-2017-en OECD, Government at a Glance (2017)

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