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 = 4122 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
16951 Rotavirus deaths and cases in under-5s (IHME, 2018) 
{
    "link": "https://jamanetwork.com/journals/jamapediatrics/fullarticle/2696431",
    "retrievedDate": "19th May 2019",
    "additionalInfo": "Data is the summary of research published by Troeger et al. (2018) based on statistics from the IHME, Global Burden of Disease study.\n\nData presents the estimated number of child (under five years old) deaths; child mortality rate; and number of cases from rotavirus. Also given is the estimated number of deaths averted from the rotavirus vaccine, and potential avertable deaths if full rotavirus vaccine coverage was achieved.\n\nRotavirus is a diarrheal disease responsible for an estimated 29% of diarrheal disease deaths in children under five years old.\n\nEstimates of potentially avertable deaths from the rotavirus vaccine take into consideration its efficacy in different regions: whilst efficacy in children in high-income countries is typically greater than 90%, in lower-income countries, particularly in Sub-Saharan Africa, this efficacy rate is closer to 50%.",
    "dataPublishedBy": "Troeger, C., Khalil, I. A., Rao, P. C., Cao, S., Blacker, B. F., Ahmed, T., ... & Kang, G. (2018). Rotavirus vaccination and the global burden of rotavirus diarrhea among children younger than 5 years. JAMA Pediatrics, 172(10), 958-965.",
    "dataPublisherSource": "Institute of Health Metrics and Evaluation (IHME), Global Burden of Disease"
}
 2019-05-19 19:55:23 2019-05-19 19:55:23 Rotavirus deaths and cases in under-5s (IHME, 2018) 4122 Data is the summary of research published by Troeger et al. (2018) based on statistics from the IHME, Global Burden of Disease study. Data presents the estimated number of child (under five years old) deaths; child mortality rate; and number of cases from rotavirus. Also given is the estimated number of deaths averted from the rotavirus vaccine, and potential avertable deaths if full rotavirus vaccine coverage was achieved. Rotavirus is a diarrheal disease responsible for an estimated 29% of diarrheal disease deaths in children under five years old. Estimates of potentially avertable deaths from the rotavirus vaccine take into consideration its efficacy in different regions: whilst efficacy in children in high-income countries is typically greater than 90%, in lower-income countries, particularly in Sub-Saharan Africa, this efficacy rate is closer to 50%. https://jamanetwork.com/journals/jamapediatrics/fullarticle/2696431 Troeger, C., Khalil, I. A., Rao, P. C., Cao, S., Blacker, B. F., Ahmed, T., ... & Kang, G. (2018). Rotavirus vaccination and the global burden of rotavirus diarrhea among children younger than 5 years. JAMA Pediatrics, 172(10), 958-965.

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