sources
Data license: CC-BY
1 row where datasetId = 139 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 |
---|---|---|---|---|---|---|---|---|
72 | United Nations Population Division and Human Mortality Database (2015) | { "link": "http://esa.un.org/unpd/wpp/DVD/, http://www.mortality.org/cgi-bin/hmd/hmd_download.php", "retrievedDate": "01/09/2015", "additionalInfo": "The data file used is called \u201cLife Expectancy at exact age x (ex) - Both Sexes\u201d on the website given under \u201cMortality indicators\u201d. This original data file has life expectancy at multiple ages for every country and different regions. We use only the countries and \u201cWorld\u201d data for age 10.\r\nEach country has a life table from which we extracted the life expectancy at age 10 (column ex, row where Age is 10 for each country.)\r\nWe combined the information from the UN Population Division (UNPD) and the Human Mortality Database (HMD) using an R script. In the final data set, UNPD values are used for 1950-2100, and HMD values are used pre-1950, where available. The data set uses the first year of the period to graph the data, i.e. the e10 value for 1950-1954 is graphed at 1950.\r\n\r\nWe omitted data from the first period for which data is available for each country, because often this first period was not a full 5 years long. For instance, the life table for Australia begins with the 4-year period 1921-1924, and every subsequent period is a full 5 years long. With data manipulation or extrapolation, this first data point can be included in the future.", "dataPublishedBy": "UN Population Division & Human Mortality Database", "dataPublisherSource": "United Nations & Human Mortality Database" } |
2015-10-26 01:32:31 | 2017-11-20 11:22:11 | Life expectancy at age 10, 1750-2100 - United Nations Population Division and Human Mortality Database (2015) 139 | The data file used is called “Life Expectancy at exact age x (ex) - Both Sexes” on the website given under “Mortality indicators”. This original data file has life expectancy at multiple ages for every country and different regions. We use only the countries and “World” data for age 10. Each country has a life table from which we extracted the life expectancy at age 10 (column ex, row where Age is 10 for each country.) We combined the information from the UN Population Division (UNPD) and the Human Mortality Database (HMD) using an R script. In the final data set, UNPD values are used for 1950-2100, and HMD values are used pre-1950, where available. The data set uses the first year of the period to graph the data, i.e. the e10 value for 1950-1954 is graphed at 1950. We omitted data from the first period for which data is available for each country, because often this first period was not a full 5 years long. For instance, the life table for Australia begins with the 4-year period 1921-1924, and every subsequent period is a full 5 years long. With data manipulation or extrapolation, this first data point can be included in the future. | http://esa.un.org/unpd/wpp/DVD/, http://www.mortality.org/cgi-bin/hmd/hmd_download.php | UN Population Division & Human Mortality Database |
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");