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 = 4868 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
17599 Suicides from pesticides (Mew et al., 2017) 
{
    "link": "https://www.sciencedirect.com/science/article/pii/S016503271730280X",
    "retrievedDate": "18th November 2019",
    "additionalInfo": "Mew et al. (2017) estimated the share and number of suicide deaths globally and regionally which resulted from pesticide poisoning.\n\nThe authors did so using:\n\"WHO method-specific suicide data were supplemented by a systematic review of the literature between 2006 and 2015, including searches of thirteen electronic databases and Google, citation searching and a review of reference lists and personal collections. Our primary outcome was the proportion of total suicides due to pesticide poisoning. Weighted estimates were calculated for seven WHO regional and income strata.\"",
    "dataPublishedBy": "Mew, E. J., Padmanathan, P., Konradsen, F., Eddleston, M., Chang, S. S., Phillips, M. R., & Gunnell, D. (2017). The global burden of fatal self-poisoning with pesticides 2006-15: systematic review. Journal of affective disorders, 219, 93-104."
}
 2019-11-18 12:41:09 2019-11-18 12:41:09 Suicides from pesticides (Mew et al., 2017) 4868 Mew et al. (2017) estimated the share and number of suicide deaths globally and regionally which resulted from pesticide poisoning. The authors did so using: "WHO method-specific suicide data were supplemented by a systematic review of the literature between 2006 and 2015, including searches of thirteen electronic databases and Google, citation searching and a review of reference lists and personal collections. Our primary outcome was the proportion of total suicides due to pesticide poisoning. Weighted estimates were calculated for seven WHO regional and income strata." https://www.sciencedirect.com/science/article/pii/S016503271730280X Mew, E. J., Padmanathan, P., Konradsen, F., Eddleston, M., Chang, S. S., Phillips, M. R., & Gunnell, D. (2017). The global burden of fatal self-poisoning with pesticides 2006-15: systematic review. Journal of affective disorders, 219, 93-104.

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