sources
Data license: CC-BY
1 row where datasetId = 267 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 |
|---|---|---|---|---|---|---|---|---|
| 270 | Life expectancy – James Riley for data 1990 and earlier; WHO and World Bank for later data (by Max Roser) | {
"link": null,
"retrievedDate": "13/07/2016",
"additionalInfo": "Changes to Riley's data by Max Roser:\n\nI have assigned the 'Life expectancy before health transition' from Riley's data to the year 1770 for all world regions. The reason for doing this is that 1770 is the earliest available data from his paper and I chose that as the start year for the chart.\n\nThen I took Riley's estimate for 'Period when earliest health transition in region began' and assigned the 'Life expectancy before health transition' to the mid-point of that period.\n\nFrom then on I show Riley's data until 1990 where his dataset ends.\n\n\n\nFor 2000 and later estimates:\n\nAfrica: WHO for world region 'Africa'\n\nAmericas: WHO for world region 'Americas'\n\nAsia: World Bank population weighted average of all countries in Riley's definition of Asia http://www.lifetable.de/cgi-bin/countryR.plx?c=Asia\n\nFormer Soviet Union countries: World Bank population weighted average of former Soviet countries ( Russian Federation, Ukraine, Republic of Belarus, Republic of Uzbekistan, Republic of Kazakhstan, Georgia, Republic of Azerbaijan, Republic of Lithuania, Republic of Moldova, Republic of Latvia, Kyrgyz Republic, Republic of Tajikistan, Republic of Armenia, Turkmenistan, and Republic of Estonia.)\n\nEurope: Riley's definition of Europe is this: http://www.lifetable.de/cgi-bin/countryR.plx?c=Europe The data here is from the World Bank \n\nWorld Bank: Population weighted average of all countries in Riley's definition of Oceania http://www.lifetable.de/RileyBib.htm)",
"dataPublishedBy": "Data until 1990 are from: 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. http://onlinelibrary.wiley.com/doi/10.1111/j.1728-4457.2005.00083.x/epdf. Data 2000 and later are from the WHO and World Bank \u2013 assembled by Max Roser",
"dataPublisherSource": "Riley\u00a0drew data\u00a0from some 700 sources. The estimates along with the sources are presented online at lifetable.de."
} |
2016-07-13 16:30:35 | 2017-11-02 13:04:39 | Life expectancy – James Riley for data 1990 and earlier; WHO and World Bank for later data (by Max Roser) 267 | Changes to Riley's data by Max Roser: I have assigned the 'Life expectancy before health transition' from Riley's data to the year 1770 for all world regions. The reason for doing this is that 1770 is the earliest available data from his paper and I chose that as the start year for the chart. Then I took Riley's estimate for 'Period when earliest health transition in region began' and assigned the 'Life expectancy before health transition' to the mid-point of that period. From then on I show Riley's data until 1990 where his dataset ends. For 2000 and later estimates: Africa: WHO for world region 'Africa' Americas: WHO for world region 'Americas' Asia: World Bank population weighted average of all countries in Riley's definition of Asia http://www.lifetable.de/cgi-bin/countryR.plx?c=Asia Former Soviet Union countries: World Bank population weighted average of former Soviet countries ( Russian Federation, Ukraine, Republic of Belarus, Republic of Uzbekistan, Republic of Kazakhstan, Georgia, Republic of Azerbaijan, Republic of Lithuania, Republic of Moldova, Republic of Latvia, Kyrgyz Republic, Republic of Tajikistan, Republic of Armenia, Turkmenistan, and Republic of Estonia.) Europe: Riley's definition of Europe is this: http://www.lifetable.de/cgi-bin/countryR.plx?c=Europe The data here is from the World Bank World Bank: Population weighted average of all countries in Riley's definition of Oceania http://www.lifetable.de/RileyBib.htm) | Data until 1990 are from: 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. http://onlinelibrary.wiley.com/doi/10.1111/j.1728-4457.2005.00083.x/epdf. Data 2000 and later are from the WHO and World Bank – assembled by Max Roser |
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");