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 = 323 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
431 Global child mortality (since 1800) based on Gapminder and World Bank 
{
    "link": "http://www.gapminder.org/data/documentation/gd005/  and http://data.worldbank.org/indicator/SH.DYN.MORT",
    "retrievedDate": "30th January 2019",
    "additionalInfo": "More about the Gapminder estimates can be found here:\u00a0http://www.gapminder.org/data/documentation/gd005/.\n\nDue to data inconsistencies between previous (2016) World Bank child mortality series (which extended from 1960 to 2015) to most recent World Bank series (2019) extending only from 1990 to 2017, data for the year 1989 has been excluded as an observation.",
    "dataPublishedBy": "The World series for 1800 to 1960 was calculated by Max Roser on the basis of the Gapminder estimates of child mortality and the Gapminder series on population by country. For each estimate in that period a population weighted global average was calculated. The recent annual observations of the World series (1960 to 1988) was taken from the 2016 version of World Bank estimates (http://data.worldbank.org/indicator/SH.DYN.MORT). Latest data from 1990 to 2017 is taken from the 2019 update of World Bank data.",
    "dataPublisherSource": null
}
 2016-12-14 00:55:05 2017-11-16 14:29:13 Global child mortality (since 1800) - based on Gapminder and World Bank (2019) 323 More about the Gapminder estimates can be found here: http://www.gapminder.org/data/documentation/gd005/. Due to data inconsistencies between previous (2016) World Bank child mortality series (which extended from 1960 to 2015) to most recent World Bank series (2019) extending only from 1990 to 2017, data for the year 1989 has been excluded as an observation. http://www.gapminder.org/data/documentation/gd005/ and http://data.worldbank.org/indicator/SH.DYN.MORT The World series for 1800 to 1960 was calculated by Max Roser on the basis of the Gapminder estimates of child mortality and the Gapminder series on population by country. For each estimate in that period a population weighted global average was calculated. The recent annual observations of the World series (1960 to 1988) was taken from the 2016 version of World Bank estimates (http://data.worldbank.org/indicator/SH.DYN.MORT). Latest data from 1990 to 2017 is taken from the 2019 update of World Bank data.

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