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 = 5571 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
21962 Our World In Data based on Lindert (1994), OECD (1993), OECD Stat 
{
    "link": "https://nextjournal.com/fiona-spooner/government-health-expenditure",
    "retrievedDate": "2022-04-01",
    "additionalInfo": "The data processing is fully described in the notebook available here: https://nextjournal.com/fiona-spooner/government-health-expenditure",
    "dataPublishedBy": "Our World In Data",
    "dataPublisherSource": "Data after 1970 correspond corresponds to estimates based on the figures from the \u2018Health expenditure and financing series\u2019 published by OECD Stat. Data from1960 to 1969 corresponds to estimates based on the figures from OECD (1993), OECD Health Systems: facts and trends 1960-1991, Health Policy Studies n\u00b03. Data from 1880 to1930 corresponds to estimates based on the figures from Lindert (1994), The Rise of Social Spending, 1880-1930, in Explorations in Economic History, 31, 1-37."
}
 2022-04-01 09:11:46 2022-04-01 09:11:46 OMM - Public expenditure on health (%GDP) 5571 The data processing is fully described in the notebook available here: https://nextjournal.com/fiona-spooner/government-health-expenditure https://nextjournal.com/fiona-spooner/government-health-expenditure Our World In Data

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