sources
Data license: CC-BY
1 row where datasetId = 1892 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
| id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
|---|---|---|---|---|---|---|---|---|
| 13901 | Riley (2005), Clio Infra (2015), UN Population Division (2019) | {
"link": "https://datasets.socialhistory.org/dataset.xhtml?persistentId=hdl:10622/LKYT53, http://onlinelibrary.wiley.com/doi/10.1111/j.1728-4457.2005.00083.x/epdf, https://population.un.org/wpp/Download/Standard/Population/",
"retrievedDate": "14/09/2019",
"additionalInfo": "Data was compiled by Our World in Data based on estimates by James C. Riley, Clio Infra, and the United Nations Population Division.\n\nFor regional- and global-level data pre-1950, we use data from a study by Riley, which draws from over 700 sources to estimate life expectancy at birth from 1800 to 2001.\n\nRiley estimated life expectancy before 1800, which he calls \"the pre-health transition period\". \"Health transitions began in different countries in different periods, as early as the 1770s in Denmark and as late as the 1970s in some countries of sub-Saharan Africa\". As such, for the sake of consistency, we have assigned the period before the health transition to the year 1770. \"The life expectancy values employed are averages of estimates for the period before the beginning of the transitions for countries within that region. ... This period has presumably the weakest basis, the largest margin of error, and the simplest method of deriving an estimate.\"\n\nFor country-level data pre-1950, we use Clio Infra's dataset, compiled by Zijdeman and Ribeira da Silva (2015).\n\nFor country-, regional- and global-level data post-1950, we use data published by the United Nations Population Division, since they are updated every year. This is possible because Riley writes that \"for 1950-2001, I have drawn life expectancy estimates chiefly from various sources provided by the United Nations, the World Bank\u2019s World Development Indicators, and the Human Mortality Database\". \n\nFor the Americas from 1950-2015, we took the population-weighted average of Northern America and Latin America and the Caribbean, using UN Population Division estimates of population size.",
"dataPublishedBy": "James C. Riley (2005) \u2013 Estimates of Regional and Global Life Expectancy, 1800\u20132001. Issue Population and Development Review. Population and Development Review. Volume 31, Issue 3, pages 537\u2013543, September 2005., Zijdeman, Richard; Ribeira da Silva, Filipa, 2015, \"Life Expectancy at Birth (Total)\", http://hdl.handle.net/10622/LKYT53, IISH Dataverse, V1, and UN Population Division (2019)",
"dataPublisherSource": "https://www.lifetable.de/RileyBib.pdf"
} |
2018-01-04 15:25:44 | 2018-01-04 15:25:44 | Life expectancy - Riley (2005), Clio Infra (2015), and UN (2019) 1892 | Data was compiled by Our World in Data based on estimates by James C. Riley, Clio Infra, and the United Nations Population Division. For regional- and global-level data pre-1950, we use data from a study by Riley, which draws from over 700 sources to estimate life expectancy at birth from 1800 to 2001. Riley estimated life expectancy before 1800, which he calls "the pre-health transition period". "Health transitions began in different countries in different periods, as early as the 1770s in Denmark and as late as the 1970s in some countries of sub-Saharan Africa". As such, for the sake of consistency, we have assigned the period before the health transition to the year 1770. "The life expectancy values employed are averages of estimates for the period before the beginning of the transitions for countries within that region. ... This period has presumably the weakest basis, the largest margin of error, and the simplest method of deriving an estimate." For country-level data pre-1950, we use Clio Infra's dataset, compiled by Zijdeman and Ribeira da Silva (2015). For country-, regional- and global-level data post-1950, we use data published by the United Nations Population Division, since they are updated every year. This is possible because Riley writes that "for 1950-2001, I have drawn life expectancy estimates chiefly from various sources provided by the United Nations, the World Bank’s World Development Indicators, and the Human Mortality Database". For the Americas from 1950-2015, we took the population-weighted average of Northern America and Latin America and the Caribbean, using UN Population Division estimates of population size. | https://datasets.socialhistory.org/dataset.xhtml?persistentId=hdl:10622/LKYT53, http://onlinelibrary.wiley.com/doi/10.1111/j.1728-4457.2005.00083.x/epdf, https://population.un.org/wpp/Download/Standard/Population/ | James C. Riley (2005) – Estimates of Regional and Global Life Expectancy, 1800–2001. Issue Population and Development Review. Population and Development Review. Volume 31, Issue 3, pages 537–543, September 2005., Zijdeman, Richard; Ribeira da Silva, Filipa, 2015, "Life Expectancy at Birth (Total)", http://hdl.handle.net/10622/LKYT53, IISH Dataverse, V1, and UN Population Division (2019) |
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");