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 = 2863 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
15597 Human Mortality Database (2018) and others 
{
    "link": "Human Mortality Database (2018): https://www.mortality.org/ Hacker (2010): https://www.tandfonline.com/doi/pdf/10.1080/01615441003720449?needAccess=true and the US Social Security Administration: https://www.ssa.gov/oact/HistEst/PerLifeTables/2017/PerLifeTables2017.html",
    "retrievedDate": "27/08/2018",
    "additionalInfo": "US estimates are based on Hacker (2010) for the period 1780 to 1890. The year 1790 refers to the period 1790-99; see Table 8: New Life Tables for the White Population of the United States, 1780-1900 for the original data consulted for this period. The US Social Security Administration data is used from 1900 to today.\n\nFor other countries,  estimates are based on the Human Mortality Database period tables. Following <a href=\"http://www.nber.org/papers/w24716\" rel=\"noopener\" target=\"_blank\">Goldin and Lleras-Muney (2018)</a>, our data covers only years in which a census was undertaken. Goldin and Lleras-Muney (2018) explain: \"census data are available every ten years starting in 1841 for England, and every ten years starting in 1860 for Sweden. For France they occurred every 5 years between 1836 and 1936 (except for 1871 which was held in 1872, and for 1916 which was cancelled) and then for 1946, 1962, 1968, 1975, 1982, 1990 and 1999.\"\n\nNote: the United Kingdom refers to the total population of England and Wales.",
    "dataPublishedBy": "Human Mortality Database, Hacker (2010), and the US Social Security Administration (2017)",
    "dataPublisherSource": "Scholarly sources and historical data"
}
 2018-08-03 09:32:29 2018-08-03 09:32:29 Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 US estimates are based on Hacker (2010) for the period 1780 to 1890. The year 1790 refers to the period 1790-99; see Table 8: New Life Tables for the White Population of the United States, 1780-1900 for the original data consulted for this period. The US Social Security Administration data is used from 1900 to today. For other countries, estimates are based on the Human Mortality Database period tables. Following <a href="http://www.nber.org/papers/w24716" rel="noopener" target="_blank">Goldin and Lleras-Muney (2018)</a>, our data covers only years in which a census was undertaken. Goldin and Lleras-Muney (2018) explain: "census data are available every ten years starting in 1841 for England, and every ten years starting in 1860 for Sweden. For France they occurred every 5 years between 1836 and 1936 (except for 1871 which was held in 1872, and for 1916 which was cancelled) and then for 1946, 1962, 1968, 1975, 1982, 1990 and 1999." Note: the United Kingdom refers to the total population of England and Wales. Human Mortality Database (2018): https://www.mortality.org/ Hacker (2010): https://www.tandfonline.com/doi/pdf/10.1080/01615441003720449?needAccess=true and the US Social Security Administration: https://www.ssa.gov/oact/HistEst/PerLifeTables/2017/PerLifeTables2017.html Human Mortality Database, Hacker (2010), and the US Social Security Administration (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");