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 = 5815 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
27101 Basic education by region - Zanden et al. (2014) 
{
    "link": "https://www.oecd-ilibrary.org/economics/how-was-life_9789264214262-en",
    "additionalInfo": "How was life in 1820, and how has it improved since then? What are the long-term trends in global well-being? Views on social progress since the Industrial Revolution are largely based on historical national accounting in the tradition of Kuznets and Maddison. But trends in real GDP per capita may not fully re\u00adflect changes in other dimensions of well-being such as life expectancy, education, personal security or gender inequality. Looking at these indicators usually reveals a more equal world than the picture given by incomes alone, but has this always been the case? The new report How Was Life? aims to fill this gap. It presents the first systematic evidence on long-term trends in global well-being since 1820 for 25 major countries and 8 regions in the world covering more than 80% of the world\u2019s population. It not only shows the data but also discusses the underlying sources and their limitations, pays attention to country averages and inequality, and pinpoints avenues for further research.\n\nThe How Was Life? report is the product of collaboration between the OECD, the OECD Development Centre and the CLIO-INFRA project. It represents the culmination of work by a group of economic historians to systematically chart long-term changes in the dimensions of global well-being and inequality, using the most recent research carried out within the discipline. The historical evidence reviewed in the report is organised around ten dimensions of well-being that mirror those used by the OECD in its well-being report How\u2019s Life? and draw on the best sources and expertise currently available for historical perspectives in this field. These dimensions are per capita GDP, real wages, educational attainment, life expectancy, height, personal security, political institutions, environmental quality, income inequality and gender inequality.",
    "dataPublishedBy": "clio-infra.eu via Zanden et al. (2014)"
}
 2022-10-24 15:29:49 2022-10-24 15:29:49 Basic education by region - Zanden et al. (2014) 5815 How was life in 1820, and how has it improved since then? What are the long-term trends in global well-being? Views on social progress since the Industrial Revolution are largely based on historical national accounting in the tradition of Kuznets and Maddison. But trends in real GDP per capita may not fully re­flect changes in other dimensions of well-being such as life expectancy, education, personal security or gender inequality. Looking at these indicators usually reveals a more equal world than the picture given by incomes alone, but has this always been the case? The new report How Was Life? aims to fill this gap. It presents the first systematic evidence on long-term trends in global well-being since 1820 for 25 major countries and 8 regions in the world covering more than 80% of the world’s population. It not only shows the data but also discusses the underlying sources and their limitations, pays attention to country averages and inequality, and pinpoints avenues for further research. The How Was Life? report is the product of collaboration between the OECD, the OECD Development Centre and the CLIO-INFRA project. It represents the culmination of work by a group of economic historians to systematically chart long-term changes in the dimensions of global well-being and inequality, using the most recent research carried out within the discipline. The historical evidence reviewed in the report is organised around ten dimensions of well-being that mirror those used by the OECD in its well-being report How’s Life? and draw on the best sources and expertise currently available for historical perspectives in this field. These dimensions are per capita GDP, real wages, educational attainment, life expectancy, height, personal security, political institutions, environmental quality, income inequality and gender inequality. https://www.oecd-ilibrary.org/economics/how-was-life_9789264214262-en clio-infra.eu via Zanden et al. (2014)

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