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 = 3267 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
16771 Causes of infant death in boys and girls (IHME, 2018) 
{
    "link": "http://ghdx.healthdata.org/gbd-results-tool",
    "retrievedDate": "5th April 2019",
    "additionalInfo": "Rates of infant mortality by sex for selected causes of death. This is based on death rates per 100,000 for infants less than one year old. This is given for a range of leading causes of death for comparison between infant mortality rates in males and females.\n\nFor conciseness and clarity, we have shortened a few of the original IHME causes of death:\nCongenital birth defects = Birth defects\nCongenital heart anomalies = Heart anomalies\nDigestive congenital anomalies = Digestive anomalies\nNeonatal encephalopathy due to birth asphyxia and trauma = Encephalopathy from asphyxia and trauma\nNeonatal preterm birth = Preterm birth\n",
    "dataPublishedBy": "Global Burden of Disease Collaborative Network. Global Burden of Disease Study 2017 (GBD 2017) Results. Seattle, United States: Institute for Health Metrics and Evaluation (IHME), 2018."
}
 2019-04-05 12:25:32 2019-04-05 12:25:32 Causes of infant death in boys and girls (IHME, 2018) 3267 Rates of infant mortality by sex for selected causes of death. This is based on death rates per 100,000 for infants less than one year old. This is given for a range of leading causes of death for comparison between infant mortality rates in males and females. For conciseness and clarity, we have shortened a few of the original IHME causes of death: Congenital birth defects = Birth defects Congenital heart anomalies = Heart anomalies Digestive congenital anomalies = Digestive anomalies Neonatal encephalopathy due to birth asphyxia and trauma = Encephalopathy from asphyxia and trauma Neonatal preterm birth = Preterm birth http://ghdx.healthdata.org/gbd-results-tool Global Burden of Disease Collaborative Network. Global Burden of Disease Study 2017 (GBD 2017) Results. Seattle, United States: Institute for Health Metrics and Evaluation (IHME), 2018.

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